SUMMARY:

• Over twenty years of experience in business applications analysis and development.
• Five years of experience as an IIS DataStage Administrator.
• Eight years of development experience using the ETL tool DataStage.
• Strong analytical and problem solving skills throughout full project life cycle development.
• Health care experience with both Confidential and Independence Blue Cross of PA.

TECHNICAL SKILLS:

• DataStage 7.5/8.1/8.5/9.1/11.3/11.5
• DB2
• Oracle
• PL/
• Toad
• Explain plan for query optimization
• AIX
• UNIX
• Linux
• Shell Scripts
• Orchadmin
• Istool
• Subversion
• Teradata
• MS SQL Server
• Reading XML Files
• COBOL
• CICS
• OS/JCL
• VSAM
• Micro Focus COBOL
• IBM Z/990
• OS/390
• MVS/XA
• TSO/ISPF
• RS/6000
• TELNET
• FTP
• SQLConnect:Direct
• XPEDITER
• Intertest
• File - AID.

PROFESSIONAL EXPERIENCE

Confidential

DataStage Developer

Responsibilities:

• Worked with a major health insurance company on the requirements for replacing their Pharmacy Benefit Manager (PBM) CVS Caremark with PBM OptumRx. Wrote the business requirements for the Sponsor Eligibility file that goes outbound to OptumRx.
• Was on a project with a major health insurance company using DataStage v11.5. This was the implementation of PBM OptumRx to replace PBM Express Scripts. Developed the group and member eligibility daily and weekly jobs for the Affordable Care Act (ACA) line of business (LOB). The jobs extract eligibility data from the Enterprise Data Warehouse (EDW) and send the extract files to OptumRx and Rx Savings Solutions. OptumRx relies on these feeds from the health insurance company so they can do their adjudication process.
• Developed DataStage v11.5 jobs to read the Compound Claims files received from OptumRx for the ACA and Medicare Advantage Part D (Med-D) LOB’s. The jobs load paid and reversed drug claims into the Integrated Data Source (IDS) and EDW databases. Rejected drug claims do not get loaded. When a prescription drug has more than one ingredient it can contain more than one compound that may or may not be covered by the health insurance company. The database tables store a breakdown of those ingredients and various costs among many other items.

Confidential

Risk & Governance Operations

Responsibilities:

• Tracked and monitored vulnerabilities identified by Global Information Security (GIS) on the 36 AIT’s or platforms using 1000+ servers under Data Science Integration Analytics Services (DSIAS). The number of attempts to break into the internet applications averages 39,200 times a day.
• Exported reports from the Continuous Monitoring tool and sent a weekly status to the AIT owners that had Priority 2 and Priority 3 vulnerabilities due for remediation. Prepared pdf slides highlighting on average 100+ past due vulnerability titles by AIT for the weekly deep dive Risk and Governance management team meeting.
• Experienced with the Enhanced Remediation Program (ERP) process. Vulnerabilities that cannot be remediated before the due date require an ERP to be filled out with a remediation timeline towards a new due date. ERP’s are presented each month by senior team leads for approval of the executive leader and GIS. Helped the AIT’s owners construct the ERP and answer the required series of questions in a way that would satisfy the executive leader and GIS for their approval.

Confidential

DataStage Administrator

Responsibilities:

• Team member with Data Platform Services (DPS) providing application and environment support on almost all the IBM InfoSphere Server (IIS) platforms Confidential the Bank.
• Primary Analyst on the Finance System of Record platform IIS v11.3. Responsible for onboarding new applications to the platform. Submitted the requests for creating the group id’s, service id’s, and powerbroker id’s. Created the directories, set access permissions, set user and group ownership, created configuration files, modified the dsenv file, migrated the DSParams files and ETL jobs. Secondary Analyst on the Enterprise Shared platform IIS v9.1 containing 25+ applications.
• Monitored the health of dozens of servers with Geneos Active Console and took action to resolve red status alerts.

Confidential

Datastage Administrator

Responsibilities:

• Team member with the ETL COE - Center of Excellence IBM IIS Application Support team. Supported 650 DataStage developers, 39 applications, 323,000 monthly jobs runs, Versions 9.1, 8.5, and 8.1, 6 AIX, 28 Linux production application servers.
• Responded to developer work requests. Requests include diagnosing DataStage job aborts, exporting and importing for migrations, granting access to the InfoSphere Information Server tools, opening service requests with IBM.
• In on-call rotation for off hour production work requests. Tasks included monitoring server health, contacting system administrators and database teams, communicating server status to the user community, recycling IIS, investigating slow jobs, checking file system space, killing jobs.

Confidential - Philadelphia, PA

DataStage Developer

Responsibilities:

• The GCM (Group Claims Management) Reporting Project’s main objective is to migrate data from different sources to a single data warehouse creating one centralized data repository for multiple reporting systems. Data from the Client, Policy, Consumer, and Claim business areas is loaded into 3 areas of the data warehouse called Staging, Subject, and End State.
• Developed DataStage jobs to pull data from Oracle and MS SQL Server databases and bulk load into Staging area DB2 tables.
• Developed DB2 stored procedures to pull from Staging area tables, load Subject area tables and then load the End State tables. The End State tables contain merged data from multiple subject areas and are de-normalized more for reporting. Subject and End State tables also contain full history.
• Developed master stored procedures for each business source to execute individual stored procedures in sequence. The stored procedures are coded to skip to a restart point after an execution error.
• Experience with explain plan and performance tuning of SQL cursors. Created indexes and restructured indexes to improve performance.
• Resolved DataStage and stored procedure tickets reported in HP Quality Center by the Quality Assurance team.
• Worked on both the mainframe and DataStage side of the SEEDS (Syndicate Enhanced Equity Distribution System) application. Changed how an index is calculated and used in ranking financial advisors. The purpose is to better align syndicate allocations with top advisors and improve the tracking of holding periods on allocations.
• Assigned to convert a COBOL ETL process to DataStage and populate a new database. This involved decomposing their current system called LADE (Life, Accident, Disability, Eligibility) on the mainframe and extracting the rules to be applied on the incoming employer feeds. Developed DataStage jobs to read and parse XML files created from the client feeds, include the edits, and load a new Consumer BoR (Book of Record).
• Supervised a co-worker in the portion of the project that replaces LADE. This effort was designed to feed into the old disability database. The DataStage jobs were a part of a successful prototype demonstrated to Confidential management.

Confidential

DataStage Developer

Responsibilities:

• Manual run of over a hundred DBOR (Database of Record) DataStage jobs against Oracle database to migrate select customer billing accounts. Thousands of billing accounts were migrated from the old ESB (Emerging Services Biller) database to the new UP (Universal Platform) database each month. System required a coordinated group effort to interface with a dozen other systems. Almost 70,000 accounts were migrated to complete the project.
• Completed ETL job change requests from tickets and enhancements from detail designs and sent out deployment plans.
• Lead role in system testing, IST testing and dry run to test accounts selected for monthly production run.
• Satisfied requests from account analysts for files of accounts that passed and failed in the different phases of the migration process.
• Billing Migration project exceeded $11M in cost, but has a huge benefit of yielding a $12M one time savings and $5M annually.

Confidential - Lawrenceville, NJ

Lead Analyst

Responsibilities:

• Actively involved in the data warehouse development of new applications and enhancement of existing applications using ETL tool DataStage.
• Created and scheduled jobs to migrate clienteling tables from marketing system on mainframe to Teradata data warehouse enabling management to roll out CRM (customer relationship management) strategies that allowed Saks Fifth Avenue to further differentiate them from the competition.
• Provided production support for the data warehouse, troubleshooting jobs that aborted, creating fix jobs when necessary and restarting jobs.
• Provided end-user support, including ad hoc requests and other support required.
• Manually executed jobs each morning that were not automated on the data warehouse. The merchandise locator job helped sales associate’s complete sales for items that were out of stock in their store.
• Held lead role in improving the Client Book system on the mainframe, an automated "customer book" used to assist sales associates in better serving customers in the Saks Fifth Avenue stores. Fulfilled all SDLC (system development life cycle) project methodologies for project scope/requirements, coding, test phases, user signoffs, and implementation.
• Major contributor for the “One Client” and “Look Up to Host” DB2 database projects which were major initiatives that enabled Saks Fifth Avenue to have one global client number for each client rather than a different client number in each store that the client shops in. This reduced client data redundancy by 8% in the database, saved CPU time and improved monthly reporting. It also enabled Sales Associates to review a client’s total purchase history to determine item preferences in order to facilitate personalized service for the client to increase sales.

Confidential, Edison, NJ

Senior Analyst

Responsibilities:

• Responsible for the research, design, and completion of a Centralized Fee Table system using COBOL, CICS, and Datacom for the Division of Motor Vehicles. It is an online data entry/inquiry system that a small team coded under my supervision to keep track of various fee amounts for permits, licenses, titles, registrations, and special plates. Amounts are entered when a change in legislation occurs that requires a new or modified fee. An audit trail of all changes will appear on audit inquiry screens, and fees that expire will appear on archive inquiry screens. Centralizing the fee tables allowed management to more efficiently monitor the fee schedule process saving the State time and labor resources.
• Supervised a team that coded COBOL batch programs to report on transactions and daily revenues from permits, licenses, titles, registrations, and special plates.
• Completed project on time, despite exceptionally tight year 2000 time constraints.

Confidential, Norristown, PA

Programmer/Analyst

Responsibilities:

• Wrote highly maintainable COBOL programs to company standards for a DB2 claim tracking system for Independence Blue Cross of PA. This system stores all information on claims. It follows the status of claims over a four day cycle from the time they are received to how they eventually end up paid, denied, or suspended.
• Coded a project for Keystone Health Plan Services involving a menu structured CICS VSAM claim information reporting system. Menu selections available would vary depending on the user's Id. Users can provide selection criteria for a report, submit a job and then view the report online.
• Worked in-house programming for a new CICS managed care system on a RS/6000 with a DB2 database designed to store a history of all health care data that has been captured. Some of this would include membership, encounters/referrals, claims, benefits, and providers. Responsible for resolving all bugs reported on by our clients. This would involve gathering information needed to duplicate the problem reported, preparing test scenarios, debugging, modifying code, testing, and then proving the programs work correctly prior to release.