PROFESSIONAL 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:

DataStage (10+ years)

Mainframe (18+ years)

Client Focused

Data & System Analysis

Data Warehousing

Legacy System Modernization

Mentor and Trainer

Project Leadership

Solution Oriented

Technical Documentation

DataStage v8.5/11.3

Unix Shell Scripting

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

Domain Expertise

Accounting Custom Reporting Insurance

Banking Estate Settlement Payroll

Billing & Invoices Finance Tax Reporting

WORK EXPERIENCE:

Confidential, Chicago, IL

Application Consultant - ETL DataStage & Mainframe

Responsibilities:

• 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.

Senior Systems Analyst

Confidential

Responsibilities:

• Gathered business requirements from internal partners and clients, performed system analysis, provided cost estimates, created detailed technical design and managed the onsite and offshore development team.
• 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.

Systems Analyst

Confidential

Responsibilities:

• Transformed business requirements to detailed technical design, performed system analysis, provided cost estimates, and worked closely with developers to ensure program was coded to standard, on time and within budget.
• 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.

Programmer Analyst

Confidential

Responsibilities:

• Debugged problems, proposed solutions, developed and implemented changes, performed database maintenance and updated system support documents for future reference.
• 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.

Programmer

Confidential

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.

Senior Portfolio Accounting Analyst

Confidential

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.