SUMMARY OF EXPERIENCE:

• Technology specialist with solid history of connecting needs of businesses with available technology.
• Works with audiences diverse in culture, technical abilities, and business acumen.
• Translates complex business requirements into technical requirements.
• Writes functional and technical specifications, status reports, test plans, and documentation conforming to customer’s methodologies and business practices.
• Produces SOX - compliant results, as an individual and team member.
• Implements Full Life Cycle solutions of regulated systems.
• Transfers knowledge to client’s representatives.
• Recent experience includes large scale pharmaceutical ETL work, large scale patient data analytics, modular library development, and report development.

Databases:  Oracle RDBMS, Microsoft SQL Server, Microsoft Access.

Tools:  Oracle SQL*Plus, Oracle PL/SQL, Oracle Enterprise Manager OEM, Toad, SQL Developer, Transact - SQL, T-SQL C, Oracle Pro*C, UNIX Shell Scripts, LINUX Shell Scripts, Gel Scripts, XOG, NSQL XML, HTML, JavaScript, XQuery, XSQL, Apache Ant, XSLT, XMLPad, oXygen VBA for Microsoft Excel, Microsoft Excel Macros, Microsoft Access Macros, and Microsoft Word Macros Microsoft Visual Studio .NET, Java, SAP ABAP, Crystal reports, VMware Tortoise SVN Subversion, Microsoft Visual Source Safe VSS, Mercurial TortoiseHg

Enterprise Applications: commercial off-the-shelf software - COTS SAP Finance (SAPFI), Oracle Financials, Khameleon Financial Accounting Siebel Call Center, Computer Associates (CA) Clarity, SunGard AvantGard GetPaid Vertex Sales and Use Tax, Quantum Utilities, Quantum Returns, Informatica MDM Thomson Reuters, Liquent, Parexel Insight Manager, Insight for Registrations PROFESSIONAL EXPERIENCE:

Horsham, PA,

ETL Data Migration Specialist

• Worked with pharmaceutical client to extract specific data from legacy Insight Manager since the company was splitting into two companies and each company would own the rights to certain products.
• Created and/or upgraded dozens of high profile reports for multiple pharmaceutical clients.
• Assisted pharmaceutical client with building a reporting data warehouse from multiple instances of Insight Manager through regular, recurring, support sessions.
• Worked with several pharmaceutical clients to migrate legacy pharmaceutical data into current release of Insight Manager.
• Worked with several pharmaceutical clients to upgrade their current Insight Manager software to the current major release, modifying interfaces to several upstream/downstream systems, including a reporting datamart. Assisted the client with many activities including audit requests, data investigations, performance issues, and enhancements.
• Worked with multiple pharmaceutical clients to facilitate data collection of IDMP data, automating where possible using technologies such as Excel VBA macros and Informatica MDM.

Horsham, PA

ETL Data Migration Specialist

• Worked with multiple pharmaceutical clients to migrate legacy pharmaceutical data into current release of Insight Manager.

Plymouth Meeting, PA

ETL/Data Warehouse Developer

• Created Client Deliverable studies involving historical and future Pharmaceutical Data, analyzed through Oracle PL/SQL, and delivered though Microsoft Excel/Access data and dynamic charts. Productionized the deliverables and transferred control to Production Department for ongoing delivery.
• Created Standard Library of Procedures and Functions with Invoker Rights to modularize custom development of Client Deliverables. Procedures implementing Business Logic.

Plymouth Meeting, PA

ETL/Data Warehouse Developer

• Streamlined Pharmaceutical Data Warehouse Analysis and Report Delivery by rewriting Oracle Stored Procedures, Microsoft SQL Server Stored Procedures, and Microsoft Excel Visual Basic Macros to achieve time savings in excess of 80%.
• Created several Client Deliverable studies involving historical and future Pharmaceutical Data, analyzed through Oracle PL/SQL, and delivered though Microsoft Excel/Access data and dynamic charts. Productionized the deliverables and transferred control to Production Department for ongoing delivery.
• Created parameter-driven Compliance and Persistency Study application for Pure Custom studies as well as Custom Microstrategy Data Mart studies. Parameter driven software allowed the user to create almost any CnP scenario, nearly removing the developer from the process. Logging, exception handling, and email functionality enabled the user to kick off a study and perform other tasks until receiving a success or failure email.
• Created Standard Library of Procedures and Functions with Invoker Rights to modularize custom development of Client Deliverables. Standard Library enabled faster turnaround times for Client Deliverables due to reduced development effort. Quality Control (QC) time was also reduced due to the decrease in pure custom code producing the Client Deliverable.
• Created parameter-driven Feasibility tool which allowed Business Analysts to answer Pharmaceutical Client feasibility questions without developer involvement. Using an Excel interface connected to an Oracle database, the user could define their RX/DX Market, modify several parameters, and simply press a button in order to determine whether enough sample data existed to develop a complete study. Previously, developers spent 1-3 days producing the feasibility result instead of their current workload.
• Created Dimension Maker which allowed developers to describe their reporting dimensions in an Excel spreadsheet and press a button to create standard sets of tables in their Oracle schema preloaded with data, saving much time.
• Created parameter-driven Cohort Builder tool which allowed developers to create a Custom Study Cohort simply by modifying several parameters and calling a Stored Procedure. A user, including a developer, would use the Feasibility tool to assess the Feasibility, and then use the Cohort Builder tool to build the Patient Sample. Cohort Builder would subject the initial Patient Sample to Standard Methodology practices, such as Patient Eligibility, Pharmacy Stability, and Provider Stability, which would virtually eliminate trend breaks due to data sources coming online or going offline.

Horsham, PA

ETL Data Migration Specialist

• Extracted legacy pharmaceutical data, transformed data according to business rules, and loaded data into Insight Manager for large pharmaceutical client using Oracle RDBMS, Apache Ant, XSQL, XSLT, XQuery, XPath, XMLPad, and oXygen.

Malvern, PA

Senior Programmer/Analyst, Systems Integrator

• Integrated Siebel Call Center Opportunities with Computer Associates (CA) Clarity Project Portfolio Management system using Oracle RDBMS, PL/SQL, XML, GEL Scripts, and XOG.
• Designed, created, and performed data extractions and transformations (ETL) from Khameleon Financial Accounting and Banner HR to SAP Finance (SAPFI) using Oracle RDBMS, PL/SQL, and Microsoft Excel Macros.
• Designed and developed Bank Upload File program for SAP Finance (SAPFI) using SAP ABAP.
• Designed and developed Positive Pay program for SAP Finance (SAPFI) using SAP ABAP.
• Designed and developed Hourly Employee Report for SAP Finance (SAPFI) using SAP ABAP.

Philadelphia, PA

Systems Integrator

Responsibilities:

• Migrated proprietary investment analysis server from UNIX to SUSE LINUX using UNIX System Administration, Linux System Administration, TAR, FTP, FORTRAN, C, Shell Scripts, Samba, and CLIQ.