PROFESSIONAL SUMMARY:

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

• Discovery, UML Modeling (Present and Future State), Pain Point Analysis, Development of Recommendations, Presentation to stakeholders.
• Developed a System Interface Contact diagram to show the amount of systems with password change frequency that a Sales Rep encounters while carrying out Sales duties (Pinwheel diagram).
• Unique powerful graphic presentation that quickly conveyed the confusion that a Sales Rep faces when using all the software necessary to do the job.
• Developed requirements and diagrams for Data Integration and Reporting to standardize the process of integrating Third Party Data Vendor services into the Analytics Reporting System, with High Level Business Requirements detailing Vendor Data needs. From these, more detailed (Technical and Business-Specific) requirements can be developed. These are living expandable documents which started with two vendors, with a document format allowing for easy expansion to include more vendors. Included were diagrams for Conceptual Architecture, Data Governance and Data Stewardship.
• Created strong, flexible Business Requirements which can be used for any data sourcing and reporting needs, functioning as living documents. This is a template for future data and reporting requirements.
• Discovery and analysis to provide concise present and future state conditions showing KT and ownership change of the third party vendor team to a BMS team. Also created a graphic representation of reports and data sources for clarification.
• Discovery and Storyboard creation for current and future state customer interactions diagrams for Adverse Events, Product Quality Complaints, Medical Information, Clinical Trial Recruitment, After Hours Support, and Risk Management activities.
• Provided an extremely clear graphic presentation giving extremely clear functionality paths for the given interactions.
• Uncovered the extreme complexity of a process that had not been correctly documented.
• Presented present and future state conditions to improve functionality which was not visible before.
• Provided pain point analysis with customer present, and delivered extremely detailed sequence models showing current and suggested future states.
• Highlighted points where data could be used and entered once instead of multiple times.
• Presented extremely effective graphic presentation showing the need for streamlining of the HR process, and the need for managerial ownership to facilitate project execution.
• Propagated process to multiple markets.
• Presented complex models to multiple markets which highlighted the need for a more global approach with greater customer satisfaction.
• Provided extremely comprehensive discovery, pain point analysis with effective proposed solutions with benefit-effort review of complicated European alignment issues.
• Discovery and UML which documented the onboarding and offboarding of vendor staffing on BMS premises.
• Provided business with UML model which detailed the required roles and steps needed to carry out this process and ensure that new staff was adequately equipped to start work on arrival.

Confidential

Business Analyst

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.
• 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.
• Value Added - 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 Confidential entities and their instruments into a Finished Goods repository and reduced the number of siloed systems holding global Confidential 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.

Confidential, 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:

• Sales Tracking and Analysis
• 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 Confidential 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.

Confidential, Roseland, NJ

UNIX Systems Developer/Support

Responsibilities:

• Unix systems portion of rules-based general ledger accounting/data warehouse application -
• 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).
• Value Added - Close working relationship with ETL team to match and wrap their code with efficient, easy to support Unix code, extremely comprehensive support of application so that it never missed SLA for reasons other than late upstream data or system outages.