PROFESSIONAL SUMMARY:

• Business Analyst/Process Modeler with 10 years experience in Pharmaceuticals (Business Process, Commercial, Managed Markets Contract + Government Pricing, CRM, CFR Part 11 Regulatory), Financials (General Ledger), Insurance (Disability Claims, Life) and Healthcare environments.
• 4.25 years experience in Process Analysis/Modeling in Commercial/Systems Analysis supporting Business Architecture/Systems solutions development efforts.
• 7 years experience as an ETL Data Warehouse Professional.
• Experienced in working with offshore teams.
• Team player with ability to work on several projects simultaneously.
• Excellent communication skills with ability to work in challenging situations.
• Proven ability to work in a competitive and fast - paced environment.
• Experienced in gathering and implementing business requirements on applications.
• Compliance-oriented (CMMI, SOX) to ensure security of application development.
• Lean SixSigma Methodologies.

TECHNICAL SUMMARY:

Business Environments: Pharmaceuticals ( Managed Market Rebates and Contract Pricing (Model N), CRM ), Investments, Insurance (Health, Disability, Life), Financials (General Ledger)

Communication/Presentation: MS Visio 2013 (VBA), MS PowerPoint 2013, MS Excel 2013 (VBA), MS Word, SharePoint, HP Quality Center

IT Systems: Unix Sun Solaris, Unix HP, Unix AIX, Red Hat Linux, Wintel

Databases: Oracle 11g, DB2/UDB v9.2

ETL Tools: Informatica PowerCenter, Ab Initio, SyncSort, Syperian (Informatica MDM)

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst / Process Modeler

Responsibilities:

• Upgrade of Managed Markets Warehouse Application which controls rebates, payments and chargebacks to contract holders by comparing purchase - based and utilization-based sales of products to contract specifications to verify payment activity and eligibility.
• The upgrade was to include and utilize the Model N Revenue Management Suite for sourcing and control of data.
• Wrote/Updated BRD and FRS documents for ETL interfaces between the Model N Revenue Management Suite to the in-house Managed Markets Warehouse, and then wrote/updated BRD and FRS documents for ETL interfaces between the in-house Managed Markets Warehouse to a Revitas CARS Claims Validation database for validation of Rebate and Chargeback claims.
• Worked with and assisted developers with creation/modification of Technical Design documents, including data flow/mapping from source to target database tables.
• Organized and facilitated walkthrough and review meetings with Offshore testing teams, stakeholders and compliance staff to ensure that testing with automated testing tool (HP Quality Center) was conducted correctly and in a timely fashion.
• Reviewed and approved Test Specifications and System Test Cases using automated testing tool (HP Quality Center).
• Worked on Requirements Traceability Matrix within automated testing tool (HP Quality Center) to ensure that requirements were matched to tests and results.
• Resolved data mapping issues by working with business stakeholders and development team.
• Worked with Data Architects to plan data source Views for ETL processing. Coordinated System Testing of ETL interfaces in large testing scenarios with multiple dependencies.
• Prepared End-to End Test Cases in automated testing tool (HP Quality Center) based on successful System Test efforts, verifying Data Flows sourced from Model N all the way to REVITAS CARS.
• Ensured that all changes to the Model N RMS were correctly accounted for in the BRD, FRS, and data mapping documents as Changes to Requirements.
• Ensured that the development team carried out changes to code as per the Changes to Requirements.
• Ensured that the development team carried out the correct processes for promotion of documentation and code to upper level environments.
• Maintained a strong relationship with Management to ensure timely and successful completion of tasks.
• Trained in Merck compliance methodologies.
• Came up to speed very quickly, performed tasks successfully in a tight time frame to match an aggressive schedule, and delivered results on time and correctly.

Confidential

Unix/Oracle/Informatica Developer

Responsibilities:

• Informatica/Oracle UNIX Server Consolidation - Server Consolidation for Informatica Customer Staging application.
• Developed cut-over plan and release checklists for consolidation of Informatica DEV and INT environments from separate Unix AIX servers to one server, and also for consolidation of PROD environment to a consolidated server.
• Value Added: Determined all Informatica, Oracle DB, and Unix KSH touch points for consolidation, and presented that in a cut-over release checklist so that all activities were identified with details.

Confidential

Unix/DB2 Developer

Responsibilities:

• Disability Claims Management application - Conversion of existing Group Insurance Disability Claims Management System application from SYBASE to DB2/UDB v9.2.
• Converting UNIX scripts, SYBASE embedded SQL and stored procedures to DB2/UDB to provide exactly the same functionality to end users.
• Wrote and rewrote several hundred UNIX shell scripts to function correctly in UDB as compared to SYBASE.
• Wrote and converted embedded SQL for UNIX scripts from SYBASE to DB2/UDB.
• Converted stored procedures from SYBASE to DB2/UDB.
• Performed Unit Tests of converted code, and ran converted batch cycles for UTP and QA.
• Reviewed and commented on other programmers UNIX and DB2/UDB code. Documentation of all efforts for compliance.

Confidential

ETL Developer

Responsibilities:

• Documented, developed, tested Informatica code.
• Developed Informatica mappings, mapplets, Unix Korn Shell scripts and complex DB2 Source Qualifiers to process and output data.
• Wrote Controls and Balances code to provide users with data showing performance of application.
• Participated in business analysis meetings, technical design, testing and promotion of code.
• Resolved many complex testing issues by being proactive with Business Analysts as well as with other staff to ensure that the most effective testing of data and data flow was accomplished.
• Approached job with the intent to provide the best resulting data as a result of using the best source of truthful data available.
• Focused not only on the correctness of the data, but also on the correctness of the overall process, with this outlook being of major consequence to effective testing of code. Collaborated with testing, business owners and management regarding processes and sources of data to ensure greatest correctness and most usefulness to end users.

Confidential, New York, NY

Database Developer/Analyst/Architect

Responsibilities:

• Created Oracle instances, schemas and objects for an application which consolidated and normalized global information about financial entities and their instruments into a Finished Goods repository and reduced the number of siloed systems holding global financial entity and instrument data which may at present be individually supported.
• Wrote Oracle scripts which created schemas, tables, indexes, sequence generators, triggers, constraints, links, comments, PL/SQL packages, procedures, functions, roles and views.
• Controlled promotion of code via CVS version control, release checklists and build scripts.
• Provided service to the team and to management in assisting in the creation of the Data Warehouse environment.

Confidential, Nutley, NJ

Systems Analyst/ETL Developer

Responsibilities:

• Investments application
• Documented, developed, modified and tested Informatica code.
• CRM application
• Documented, developed, modified and tested PL/SQL procedures, Informatica code and Siperian MDM Hub code.
• Estimated 2500+ man-hours for future work on applications in only 8 hours which was highly regarded by management.
• Provided data extracts to management on ad-hoc basis when required.
• Came up to speed very quickly on short-term assignment and was able to provide comprehensive service to senior management.

Confidential, Plainsboro, NJ

Systems Analyst/ETL Developer

Responsibilities:

• Upgraded existing application code to comply with FDA Title 21 CFR Part 11 Regulatory Compliance
• Streamlined code by replacing old, complex PL/SQL code with Informatica code.
• Wrote business requirements, technical design, test documents and performed data flow analysis to determine which sensitive data should be replaced with secure data.
• Created testing checklists and developed Test Analysis plans as well as Release Checklists.
• Knowledge transfer of Business Requirements, System Design and Code details to Staff.
• Was able to quickly conceptualize and package work effort efficiently to complete task in a timely fashion and deliver product back to management.

Citigroup, Warren, NJ

Senior ETL Developer

Responsibilities:

• Global Receivables Warehouse
• Documented, developed, modified and tested Ab Initio ETL graphs and sub-graphs, Korn Shell scripts, and Oracle SQL code for the loading of incoming transaction data to the Data Warehouse for corporate banking customer’s use.
• Replaced older Pro-C code with Ab Initio code and PL/SQL code.
• Assisted Data Modeler in the design and testing of new tables as required in the Global Warehouse and Marts.
• Expanded existing application code and replaced older code with newer more reliable code to keep within new corporate standards.

Confidential, Plainsboro, NJ

ETL Developer/Support

Responsibilities:

• Developed and supported Korn Shell scripts, Informatica mappings, Oracle PL/SQL, SyncSort transformation scripts for the processing of incoming sales data for both monthly and weekly data processing cycles
• Functioned as Code Promotion Gatekeeper for promotion of code from Development to Production.
• Value Added - Timely development of ETL enhancements as required. Also, timely delivery of data extracts to management on short notice for business planning. Timely and effective problem resolution of production issues to ensure satisfaction of SLA’s.

Confidential, Roseland, NJ

ETL Developer

Responsibilities:

• ETL portion of rules-based general ledger accounting/data warehouse application
• Developed Informatica and DB2 SQL code for loading of financial data to Data Warehouse and for extracts from Warehouse to end users.
• Created Informatica repositories for test environments.
• Assisted in moving application from CMMI Level 2 to Level 3.
• Reviewed and analyzed change proposals to application for impact of changes to application/environments to ensure feasibility and supportability.
• Wrote business requirements for offshore UNIX development staff.
• Wrote Release Checklists that detailed all steps needed to promote code from Development all the way up to Production.
• Took ownership of and full responsibility for a key ETL component of application.
• Brought full knowledge of application and development tools to bear to make sure that the application brought the greatest satisfaction to the business. Helped grow application from small 2-feed system to one with over 60 feeds.

Confidential, Roseland, NJ

UNIX Systems Developer/Support

Responsibilities:

• Developed Unix scripts (Korn Shell/PERL) for transfer programs to retrieve feeds from upstream Unix, NT and MVS systems and start Informatica workflows for ETL of data feeds for loading to warehouse, create reports and views for the user community and send extract feeds out to downstream systems.This includes all data integrity checks, data security on transfer, and Tivoli alerts to production problems encountered.
• Developed and supported UNIX code that changed application from single threaded (one Informatica repository) to multi-threaded (eleven Informatica repositories) so as to handle extreme volumes of data.
• Coordinated with ETL Development team to significantly expand application scope.
• Developed and modified Unix/DB2 portion of application which functioned as process control code with a “dashboard” for business users’ review of processing progress.
• Supported application as first point of contact to ensure completion of processing as per SLA’s.
• Wrote Release Checklists that detailed all steps needed to promote code from Development all the way up to Production.
• Took ownership of and full responsibility for UNIX coding and production support (first point of contact).