Human Resources System
Resume:
Esther Lin Ippolito Home
Email **********@*********.*** Cell
OBJECTIVE: Seeking a Senior Business Analyst or Software Engineer position.
I am a seasoned IT professional with a wide range of experience and
accomplishments in the Accounting, Health, Leasing, and Insurance industries.
QUALIFICATIONS:
• Strong analytical and process improvement skills.
• Detail oriented ability to multi-task.
• Maintains professional integrity and confidentiality.
• Excellent people skills, work independently and as a team player.
• Key experience in diverse areas, like Accounting, Inventory, Tax,
Payroll, and Human Resources.
SOFTWARE:
• Microsoft Visual Studio 2005/2008/10 with C#, ASP.Net 3.51
• Microsoft SQL Server 2008 R2, DB2, MySQL, Microsoft Access
• Microsoft SSIS, SSRS, T-SQL
• Informatica 9.1, UML
• C#, LINQ, Java, HTML, XML, DOS, Windows, UNIX, PHP
• COBOL, CICS, OS/JCL, AS/400
PROFESSIONAL EXPERIENCE:
Workers Compensation Insurance Ratings Bureau, San Francisco, California 2002 –
2012
The non-profit WCIRB provides Workers Compensation insurance rating services to insurers in the
state of California.
Senior Application Developer
Analyzed, designed, programmed and implemented Policy Examination and Ratings application
systems. Assisted legacy CICS team to port the system to .Net technology.
Primary analyst / developer responsible for creating year 2011 and 2012 Rating Procedure.
•
Worked with business users to get requirements to produce detailed specifications. System
took legacy data and used C# and LINQ to create XML files consumed by the WCIRB web
site.
User interface representative for both technical and business requirements for many projects.
•
Analyzed Carriers Insurance data requirements to produce carrier reports using Microsoft
•
Visual Studio’s SSRS report writer and SQL.
Used Microsoft Visual Studio’s SSIS to transfer VSAM files to CSV format that are loaded
•
into a SQL Server Database.
Implemented major enhancements to the C# based carrier Document Transfer System that
•
simplified usage saving staff manual effort.
Using Informatica, transformed VSAM Historical Rating Carrier data into an XML index
•
and corresponding text data file, consumed by the new system.
Used Informatica to restore critical Insurance system CSV file back to VSAM.
•
Page 1
Esther Lin Ippolito Home
Email **********@*********.*** Cell
Provided documentation and mentoring to colleagues, substantially reducing production
•
support calls and work effort.
McKesson Corporation, San Francisco, California 1993
- 2001
Senior Programmer Analyst
Analyzed, designed, programmed, implemented, and provided end-user support, for a variety of
application systems.
• Developed specifications for a web-based Order Entry system for large pharmaceutical chain
customers. This new system simplifies the reorder process, giving McKesson a strategic
advantage over its competitors.
• Designed and developed significant portions of the Speculative Deal and Procurement
System. Using a centralized DB2 database, the system allows pharmaceutical customers to
monitor their use of products,
and place replenishment and investment orders. Development utilized COBOL, CICS, and DB2 on
an OS/390 platform.
• Functional lead in the analysis, design, programming, and implementation, of a complex
nationwide Accounts Receivable System. This system more effectively manages the receipts
of pharmaceutical chain customers, and contributed to an increase in sales of $3-5 million
dollars per year. The system is written using the Millennium Accounts Receivable package,
CICS, COBOL, and VSAM.
• Assisted in development of an inventory tracking system for McKesson’s distribution
centers. Extensive programming performed using RPG/400.
• Supported the McKesson/FoxMeyer merger by modifying the Accounts Receivable system
to facilitate the consolidation and closing of distribution centers.
• Modified the Account Receivables System to support the addition of large customers with
their own individual contract payment terms. These changes allow the flexibility to tailor
contracts to customers, increasing revenue by over $3 million a month.
ITEL Rail Corporation, San Francisco, California 1990
- 1993
Senior Programmer Analyst / Team Leader
Team leader responsible for converting and porting the following systems within critical time
frames:
• Fixed Assets, Management Science America, Inc. (MSA), running on a leased IBM
mainframe to J.D.Edwards AS/400. This effort reduced MIS costs by over $400,000.
• Human Resources, Integral Systems Inc. (INTEGRALS), SYSTEM/38 to AS/400.
Page 2
Esther Lin Ippolito Home
Email **********@*********.*** Cell
General Accounting, J.D.Edwards SYSTEM/38 general ledger, accounts receivable and
•
accounts payable, to AS/400.
Implemented J.D.Edwards Corporate Tax System from a LOTUS spreadsheet.
•
Installed the MSA fixed asset system using CICS/VSAM from a LOTUS spreadsheet.
•
Participated in the conversion of the railcar mileage billing system from IDMS/CICS to
•
DB2/CICS.
Recipient of three annual performance awards.
•
EDUCATION: M. S., Mathematics, Illinois State University, Normal, IL
Java Programming Certification, University of California, Berkeley Extension
Working on Exam 70-461: Querying Microsoft SQL Server 2012 - toward
Certification
References provided upon request
Page 3
Contact this candidate