SUMMARY

• Result - oriented IT Application Consultant with extensive experience in full software development life cycle with a strong emphasis on design, development and deployment of banking, financial and insurance products utilizing IBM InfoSphere DataStage and Mainframe technologies.
• Hands on experience leading all stages of system development efforts including requirements gathering, analysis, architecture, development, testing, implementation and support.
• Outstanding project lead with the ability to coordinate and direct all phases of project-based efforts while managing, motivating, training and guiding offshore and onsite development teams.

TECHNICAL SKILLS

• SQL
• Cobol
• Eagle88
• IMS DC/DB
• JCL
• PL1
• SyncSort
• Awk/Sed
• Oracle
• DB2
• SQL Server
• IMS
• VSAM
• Flat File
• XML File
• XLSX File
• CSV File
• Packed Data
• Linux
• Unix
• Mainframe
• Windows
• Mac OS X
• MS-DOS
• Oracle SQL Developer
• Rapid SQL
• File-Aid
• File Master Plus
• MS Suites
• Putty
• TSO/ISPF
• TFS
• Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Application Consultant - ETL DataStage & Mainframe

Responsibilities:

• Subject Matter Expert for the Retained Assets System (RAS), Fees External Manager Billing (FEX), Fees & Profitability (FEP), Fees Estate Settlement (FES) and Revport (FIO).
• Designed Data Mart and Data Warehouse to house data for business intelligence extraction and reporting.
• Automated FEP General Ledger Reconciliation Process to ensure all transactions were posted to PeopleSoft.
• Designed and developed:
• Process to detect and report accounts not in compliance with the USA Patriot Act.
• Escheatment process to identify and report dormant accounts as required by law.
• Complex Date Routines for DataStage that can be utilized by other application teams.
• Created conversion process to transfer 500,000+ accounts from other insurance and financial companies.
• Converted FEP, FEX, FES, and FIO systems from DataStage version 8.5 to the DataStage version 11.3.
• Installed, trained and mentored other colleagues on DataStage for rapid programming development.

Confidential

Senior Systems Analyst

Responsibilities:

• Attended weekly meetings with business partners and relationship managers to prioritize projects.
• Conducted JAD sessions with business partners to understand business requirements and expectations.
• Automated the IRS Tax Reporting System to reduce future development efforts and testing time.
• Designed and developed new DB2 and IMS Databases, Online IMS Screens and Custom Reports.
• Developed DB2 stored procedures to provide account’s demographic and financial info to GUI front-end.
• Maintained database data dictionary, system architecture diagram and external interface documents.

Confidential

Systems Analyst

Responsibilities:

• Prepared weekly status reports to inform managers of the development progress or any obstacles encountered.
• Created unit test documents containing data sources, test case procedures and expected results.
• Executed year-end tax process to generate 1099-INT, 1099-MSA and 5498-HSA forms for account holders.
• Automated batch testing process for new company setup by using predefined stored procedures.
• Interviewed potential candidates, trained and mentored new programmers to quickly integrate into the system.
• Developed over 100 custom reports in test and production environment.

Confidential

Programmer Analyst

Responsibilities:

• Developed and modified mainframe programs as per the detailed technical design.
• Performed regression testing, smoke testing, black/white box testing, negative testing, and system testing to ensure the business requirements were met, data was accurate and test result were captured.
• Conducted code review to ensure program was coded to standard and easy to support.
• Maintained disaster recovery document and participated in disaster recovery testing.
• Loaded test environment databases with production data using IBM Utilities and JCL.

Confidential

Programmer

Responsibilities:

• Modified existing mainframe programs as per the detailed technical design.
• Performed DB2 and IMS database maintenance, updates, and extraction using IBM Utilities.
• Produced and maintained supporting documentations for existing system and enhancements.
• Updated Computer Operations Documentation (COD) to instruct operator which step to restart aborted job.
• Scheduled jobs on Control-M Scheduling Software in the daily batch stream.
• Provided first level production support.

Confidential

Senior Portfolio Accounting Analyst

Responsibilities:

• Applied the Global Accounting Principle to analyze and detect errors within the client’s portfolios.
• Performed monthly reconciliation of the client’s portfolio to ensure the security prices, cash transactions and corporate actions are in balance and within tolerance.
• Worked closely with Relationship Managers, IMLG Team and London Team to resolve issues encountered.
• Utilized in-house CMR & NMR reports, Custom Templates, Fund Master and Bloomberg for reconciliation.
• Trained new analysts to quickly learn how to reconcile portfolios using various tools and reports.

Confidential, Chicago, IL

College Internship

Responsibilities:

• Distributed mutual fund reference materials to analyst for research and performance evaluation.
• Entered mutual fund ratings and historical data into Confidential ’s database for trend analysis and forecasting.
• Printed and distributed mutual fund performance evaluation to editors for proofreading and publication.