APPLICATION DEVELOPER / DATABASE ANALYST
An Information Systems Professional with expertise in healthcare, insurance,
billing, collections and financial systems. Over 10 years of combined IT
experience in business analysis, data modeling, process modeling, software
development, testing and implementation of software enhancements for small to
mid-size projects. Proven ability to translate business needs into software
solutions. Possess solid technical knowledge of relational database. Strong
skills in creating complex SQL Queries, Stored Procedures, Triggers, and Views.
Experience handling multiple projects and able to work in teams or independently.
TECHNICAL SKILL
Design Tools : Erwin, Visio, Structured Architect, SmartDraw
RDBMS : Informix, MS Access
Scripting/Coding Languages : SQL ,C, ESQL/C, PowerBuilder, PB Foundation Class
Library, SAS, Visual Basic ,Unix Shell Script, Cobol
Database Connections : ODBC
Presentation Tools : MS-Project, MS-Visio, MS-Power point, MS-Word, MS-Excel
Operating Environment : Windows 2000 Windows NT UNIX
PROFESSIONAL EXPERIENCE
USI AFFINITY, USI COLBURN INSURANCE, Philadelphia, PA 1997-Present
Programmer Analyst, Application Support & Development (2006-2009)
Responsible for Application Enhancements, Helpdesk Support, and Quality
Assurance. Provide solutions to day-to-day operational issues arising from the
in-house applications and website. Analyze current design to make additional
enhancements based on the needs of the departments. Troubleshoot unusual
processing errors, identify coding bugs and make appropriate changes to code;
whenever possible simplify the code base to reduce IT maintenance issues.
• Extended Carrier Reconciliation functionally which automates the
reconciliation of 25,000 line items for a $2 million remittance per month for
Independent Blue Cross (IBC). Improving efficiencies in the Accounting
department.
• Hands on experience with ACH/EFT Electronic Funds Transfer. Construct
electronic file comprised of customers balance and banking information for upload
into Webster, PNC, and Citizen Banks. EFT capabilities ensuring timely payments
for 1200 accounts, an automation for payments reconciliation for $90,000 per
month.
• Pro-actively leverage the client/server database by creating 130 stored
procedures to support a dynamic website for Open Enrollment. Significantly
reduce time, safeguard accuracies by applying business rules that cannot be
enforced with paper submissions.
• Experience with data migrations. Design database for standardized data
conversion project. Establish generic templates that will batch import
electronic policy data. By creating standards, subsequent conversions will be
imported quickly, accuracy, and with less IT effort. The first conversion
produced revenue of $300,000 annually.
• Foster positive carrier relationship with New York Life (NYL) by accommodating
all reporting expectations to ensure profit of $237,000 on 5100 transferred
polices. Coordinated NYL workflow processing. Extensive revision of the
Simplified Issue (Guarantee Offer) Option Bills, integrate new and renewal
commission requirements into the system for trouble-free reporting.
• Ensure quality assurance by documenting defects found with usability (UI),
data validation, test cases, code reviews and regression testing. As a result,
defects were identified before the release, reduce maintenance fixes by 95% and
building users confident in the software’s accuracy and capabilities.
• Provide a complete solution for billing invoice creation and group coverage
transfer utility which moved functionally out of Unix-based application and
delivering user-friendly Windows based interfaces with back-end transactional
integration to the legacy database. These improvements will assist the company
with moving to SQL server.
Programmer Analyst, Information Systems Support Team (2000-2006)
Provided technical support to all 8 sites. Assist users with gathering financial
and production information for the company’s top-executives. Supported in-house
Accounting, Billing and Collections applications, as well as, troubleshooting
problems due to workflow issues and programming errors. Responsible for fitting
new business rules into the current business framework, utilizing the full
project life cycle.
• Operations Award 2nd Quarter 2001
• Solely accountable for the development of all financial and production report
for the PPA Direct Application tracking the collection and calculation of
commissions on 2800+ accounts totaling $1.4 million.
Page 2 COURTNEY JEUNE
[Send email to request phone number] 80.6165
• In charge of creating a formal process encompassing the delinquent and nonpaid
tracking system. User friendly solution which automatically emails reports,
tracks delinquent accounts and batch load accounts for cancelation. Provide
flexible the Medical department needs to such as auto-batch or manual-edit
capabilities. Prior to implementation, this process was manually tracked in
excel, each account was verified on the system and took several days to gather.
• Facilitated with compliance standards by composed a module for Sarbanes –Oxley
reporting. Wrote diverse reports giving users various option such as emailing
(comma-delimited file) capabilities from Unix.
Programmer Analyst, Applications Support (1999-2000)
Responsible for applications support to all departments. Created SQL queries in
Informix-4GL to detect problematic records and data inconsistencies.
• Completed requests for financial and production reports by extracting data
from Informix using ESQL/C, SQL, Unix Shell and 4GL.
• Installed Y2K enhancements requiring changes to C code, UNIX shell scripts and
Informix stored procedures.
Programmer Analyst, Helpdesk Support (1997-1999)
Help Desk Duties include giving users rights to directories, adding users to
groups, modifying and resetting login passwords.. Responsible for third party
software, writing reports and minor software enhancements.
THE HAY GROUP, Philadelphia, PA 1997
Database Analyst, Information Compensation Center
Responsible for QA statistical data and documented changes pertaining to
contacts, compensation data, and reward practices. Modified SAS code and Access
tables, queries, reports, and import/export function. QA testing of web pages
for stress, performance and security issues on the Internet.
KEYSTONE MEDICAL SYSTEMS, Lemoyne, PA 1996
Software Engineer, Software Development (Intern)
Responsible for creating deployment diskettes, testing and writing technical
documentation. Created customized reports and forms based on users requirements.
Extracted data from the UNIFY relational database and migrated programs from the
SCO UNIX to AIX UNIX using C code.
EDUCATION
Bachelor of Science, Information Systems, Pennsylvania State University,
Middletown, PA
PROFESSIONAL DEVELOPMENT
Idea Integration, (2000-2002) - Fast Track to PowerBuilder 7.0 and Using Data
Window Objects
Learning Tree International, Philadelphia, PA (2006-2007)
C# Programming: Hands-On, ASP .NET Hands-On Introduction, Programming Windows &
Smart Clients Applications with .NET, NET Best Practices and Design Patterns; MS
Visual Studio, ADO. NET
AmerIT Learning, Philadelphia PA (2008) ITIL Awareness V3 Training
CERTIFICATIONS AND LICENSES
Professional Certificate, C# Application Development, Learning Tree
International, (2006-Present)
ASSOCIATIONS
Penn State Alumni Association
Black Data Processing Association – Philadelphia Chapter
|
