SUMMARY:

Solid background in all areas of software design and development, with an emphasis back - end data applications (i.e., Data Warehousing/Data Marts, Business Intelligence (BI), Master Data Management (MDM), Data Architecture/Modeling, ETL). Experience gained in project management, data analysis, pre-sales, and working with users for requirements analysis. Due to a lifestyle change, after 2004 changed from the long-term employee model to a self-employed consultant. Open to both consulting and long-term full-time employment as well as presales positions.

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Data Migration Consultant

Responsibilities:

• Used MSSQL and SSIS to move data from a legacy P&C Insurance accounting system to Version 2.0.
• Created test scripts for validating SSIS data flows.
• Created ETL scripts for migrating Version 2.0 data back into legacy format for validation purposes.
• Optimized queries and scripts for runtime performance improvement.

Confidential, Hackensack, NJ

BI Architect

Responsibilities:

• Created a batch processing functionality for the startup.
• Used MSSQL and SSIS to create various ETL processes for loading external data into the main databases.
• Create analysis datasets for use in assessing success and/or failures of actual treatment regimens in the field .

Confidential, Rahway, NJ

Information Systems Architect

Responsibilities:

• Re-architect the Signaling data mart used to detect Serious Adverse Clinical Events.
• Re-architect the Spotfire business intelligence clinical safety data mart.
• Used big data analysis techniques to analyze performance logs in order to pinpoint performance issue sources.
• Performed data quality analysis and platform proposals.
• Create a road map for Confidential to implement proposals.

Confidential, Lyndhurst, NJ

Sr. Advisory Consultant

Responsibilities:

• Create a vision and develop a high level architecture for an Informatica MDM (Siperian) implementation.
• Create an extraction strategy for the Facility, Client and Lab Test domains from multiple legacy mainframe systems.

Confidential, Wilmington, DE

Architect

Responsibilities:

• Analyze and review the new Customer Master Data Management process using Oracle, Informatica ETL 9.1 and Informatica MDM (Siperian) 9.5.
• Analyze and review vendor TOGAF architecture artifacts.
• Set Informatica ETL and PL/SQL development standards.
• Developed an alternative approach to the SIF/Middleware paradigm in Informatica MDM.
• Review and create project artifacts and documentation.
• Guide the use of Trillium and the name and address data cleaning and matching process.
• Oversee the creation of a new health care organization (HCO) customer data model that manages the relationships between health care organizations, their departments, medical plans and the health care professionals that are associated with them.
• Profiled the various sources of HCO data (i.e., IMS, CMS, MedPro, etc.) for data quality, data completeness and trust issues.
• Designed a HCO data scrub process for sending in house customer data to a data vendor, and processing the returned scrubbed data into the new customer data management hub.
• Designed and developed a test script and publish query repository.
• Designed and developed an ETL generation tool that is fed from the repository for publishing customer data to target channels.

Confidential, Roseland, NJ

Architect

Responsibilities:

• Re-engineered a failing Enterprise Data Warehouse (EDW) to use leading edge techniques and methodologies to deliver accurate data to Cognos.
• Modified existing and created new Informatica mappings and workflows.
• Created a new Operational Data Store (ODS)
• Negotiated with European business users on how to source data from Salesforce.Com.
• Designed an automated sales data delivery process that reduced administrative requirements to zero.
• Designed and developed data quality reports and functionality.
• Designed and developed Business Intelligence (BI) Data Marts.

Confidential, New York, NY

Consultant

Responsibilities:

• Designed and developed a Financial Product Master Data Bulk Edit process using Oracle, Informatica ETL and Informatica MDM (Siperian).
• Created and populated a pre-staging data architecture for Informatica MDM.
• Created a Data Governance process for the financial product master data.
• Performed some Informatica MDM administration and configuration.
• Used Oracle to directly create SOAP XML to invoke a web service.
• Used Informatica to extract data from a Sybase financial instrument master data repository.
• Data architected, designed and developed an MDM bulk extract process that enabled end users to view the master data repository in a single report.
• Used ER/Studio to model the data architecture.
• Coordinated and project managed the release to production.
• Used Informatica to invoke a web service.

Confidential, Teaneck, NJ

Enterprise Architect

Responsibilities:

• Designed and developed a full tick data equity trading research test bed for back testing trading strategies using Oracle, both NYSE and NASDAP, both during trading hours and after hours.
• Designed and developed ETL processes for updating the tick database.
• Designed and developed strategy tests for the traders.

Confidential, New York, NY

Business Intelligence Architect

Responsibilities:

• Designed and developed a custom prototype Customer Master Data Hub using Oracle.
• Developed scripts and processes to create customer objects from subscription data.
• Developed a real-time custom customer matching algorithm.
• Designed and developed batch loading processes to integrate Siebel data into the Customer Hub.
• Designed and developed batch loading processes to initially load the Customer Hub from the Data Warehouse.
• Designed and developed a UDB/DB2 data cleansing application to enable a customer marketing promotion.
• Designed and developed initial load scripts for a Siperian customer list database application.
• Designed and developed a batch process for loading changed data into the Siperian customer list database application.
• Developed a test bed for the Siperian customer list database application.
• Used Informatica to create an incremental (change data capture) load workflow to update the Siperian customer list database.

Confidential, Cranford, NJ

Lead Software Architect

Responsibilities:

• Used Oracle and MSSQL and other relational database tools to extract legacy data from several failed banks and convert the data into well-formed XML.
• Used SSIS as the ETL tool for migrating non-mainframe data.
• Loaded the XML into an XML data warehouse hosted on Xdb, a new enterprise level XML database.
• Created a standard metadata model to facilitate and standardize the harvesting of structured data.
• Designed and managed the creation and implementation of a report dataset generation tool for Xdb that converted XQuery output into CSV format.
• Designed an FDIC approved RUP validation process for transferring legacy data from failed banks into the acquiring bank’s IT infrastructure.
• Designed and implemented a formal process and software framework for implementing and managing the structured data harvesting process.
• Used ER/Studio and Erwin to create data models of the financial data.
• Led a series of meetings with the acquiring banks’ C level management on the process, getting their buy-in, answering their objections and incorporating their suggestions.
• Created a presentation for the presales team to use to sell the process to the C level management.
• Created various metadata artifacts as per said validation process.
• Created a metadata repository to enable easy analyst access to the legacy data.
• Managed technical resources to meet an extremely ambitious timeline.
• Created XQuery applications for proof of concept applications.
• Tuned and administered the new Xdb database.

Confidential, New York, NY

Data Mart Architect

Responsibilities:

• Used Teradata, DB2, Informatica and Business Objects to create a report data mart for producing and distributing an Indication of Interest report, sourced from the Teradata data warehouse.
• Conducted joint application development meetings (JAD Sessions) with end users to extract business requirements.
• Used the Agile software development process to guide the creation of the various deliverables.
• Translated business requirements into the standard documentation formats.
• Performed extensive source system analysis and created a metadata repository.
• Used ERWin to create a logical and physical data model of the DB2 source data entities.
• Created a project plan to implement the data mart in production.

Confidential, Hopewell, NJ

Project Manager/Test Environment Architect/Data Mart Architect

Responsibilities:

• Specified, designed and built a testing data warehouse data mart using Oracle 10g, PL/SQL and DataStage on AIX to create a report data mart for understanding the reasons for correlation failures between the “house holding” and account management master data systems implemented in Siperian.
• Used Oracle functionality (Explain Plan, optimizers) to tune several Siperian queries behind the scenes in order to improve performance.
• Used ERWin to create a physical data model of the entities involved in the correlation data mart.
• Used the Rational Unified Process (RUP) to guide the creation of the various deliverables.
• Led and managed the multi-department business and technical team in the effort to understand what the failures were, and the reasons why they occurred and how to correct them.
• Led and managed the multi-department business and technical team in creating, running and tracking the Batch Delta Testing effort in a DBA role.
• Created supporting documentation for the project management efforts and used it to brief management on project status.
• Architected and developed the ETL environment for an online master data management system.
• Specified, designed and built a Product Master logical and physical data model using ERWin.
• Specified, designed and built a thin-client Equipment master logical and physical data model using ERWin as well as an application for managing the outsourced receiver manufacturing.
• Specified, designed and built a thin-client Satellite Radio Channel Master logical and physical data model using ERWin and a master data management application to maintain it.
• Interfaced with Teradata sales team for infrastructure upgrades.
• Specified, designed and built a thin-client Data Warehousing Metadata Repository to track source to target mappings as well as program to program linkages in an SOA paradigm.
• Developed a data warehouse data mart using MSSQL, Oracle, SSIS and Teradata to create a prototype snowflake schema web log data mart to calculate song royalty payments, advertisement listening, and general overall marketing research.
• Used Erwin to create a dimensional data model of the snowflake schema.
• Used the Agile software development process to guide the creation of the various deliverables.
• Created a full-fledged business process involving developers, business analysts, managers and end users to migrate reports from the current ad hoc MSSQL databases to the Teradata Enterprise Data Warehouse.

Confidential, Hackensack, NJ

Implementation Architect

Responsibilities:

• Used the proprietary Confidential ® J2EE platform to specify, design and build a thin client clinical trial management system that included clinical trial design functionality on an Oracle 10g platform.
• Used the proprietary Confidential ® platform to specify, design and build a thin client privacy incident tracking system on an Oracle 10g platform.
• Specified, designed and built a thin-client application supporting the BBC’s Standard Media Exchange Framework (SMEF) data architecture on an Oracle 10g platform.
• Used the proprietary Confidential MDR® product to maintain an ISO 11179 compliant metadata repository.
• Gained expertise in developing thin-client Master Data and Reference Data management applications and portals.
• Used the proprietary Confidential ® platform to create a Service Oriented Architecture (SOA) registry repository.
• Worked on a dynamic ETL tool to map clinical trials to the CDISC SDTM standard formats.
• Served in a pre-sales support role when necessary.

Confidential, New York, NY

Data Warehouse Architect

Responsibilities:

• Specified, designed and architected a hardware and operating system independent data warehouse using Kimball approaches for an insurance company.
• Specified, designed and built a metadata repository for AGC’s transactional source systems to store AGC’s data model. The source systems were municipal bond and property and casualty insurance systems.
• Used the Agile software development process to guide the creation of the various deliverables.
• Used Oracle Replication to manage the Extraction/Translation/Loading (ETL) processes on an Oracle 10g platform.
• Created Oracle databases on an AIX platform in a DBA role.
• Specified, designed and built OLAP cubes and other aggregations for the Business Intelligence (BI) reporting requirements using Cognos and Business Objects.
• Extracted business rules and other analysis to create facts and dimensions for the data warehouse.
• Specified, designed and built a light weight and fast change data capture (CDC) system to move transactional data to the data warehouse.
• Specified, designed and built logical and conceptual dimensional models using Visio and Erwin.

Confidential, Princeton, NJ

Solution Architect

Responsibilities:

• Specified, designed and architected an ASP .NET based software product that enables Pharmaceutical companies to easily comply with the FDA's new Structured Product Label (SPL) XML requirement for prescription package inserts.
• Served as technical lead for pre-sales efforts.
• Served as Product Manager for Submit SPL®, Confidential ’ SPL product.
• Specified, designed and created an XML Schema for transferring clinical trial data.
• Architected a ASP .NET based product to efficiently enable Clinical Data Warehousing and automate clinical reporting, including a dynamic ETL tool.
• Designed a Universal Development Data Model (UDDM) to store clinical trial data in consistent, trial-independent structures.
• Designed a generic Business Intelligence (BI) reporting framework for monitoring and analyzing clinical trial subject enrollment issues.

Confidential, E. Hanover, NJ

Senior Clinical Software Architect

Responsibilities:

• Specified, designed and architected a Clinical Development Enterprise Data Warehouse (DEDW) that incorporated two separate clinical trial administration systems, a Serious Adverse Event Reporting System and clinical data from over 250 trials. This was the first clinical trial data warehouse created, to be used for enterprise resource planning (ERP). The original intention was to use the clinical data to improve the trial enrollment and tracking processes, as well as reconcile adverse events recorded in two separate systems.
• Used Kimball approaches towards architecting the trial administration and serious adverse event sections of the data warehouse.
• Created and performed DBA activities on Oracle databases on both Windows NT and AIX platforms.
• Created new data warehousing methodologies for the clinical trial data sections because the Kimball approaches weren’t suitable.
• Using the DEDW, specified, designed and architected an Investigation New Drug Annual Report Assistant (IND Assistant) datamart that automated and standardized a chaotic, non-validated reporting system.
• Using the DEDW, specified, designed and architected an Adverse Event/Serious Adverse Event Reconciliation datamart that brought together Safety and Clinical data together from heterogeneous databases.
• Using the DEDW, specified, designed and architected a PK/PD datamart for data mining purposes across clinical trials.
• Using the DEDW, specified, designed and architected a BI reporting framework to enable clinical trial management to analyze and compare subject enrollment metrics between various clinical trial investigation sites using Cognos.
• Did the business analysis with the clinicians to design the IND Assistant functionality.
• Created new business processes to implement the IND Assistant.
• Created and delivered presentations at the vice president level for making the case for data warehousing.
• Used the Agile software development process to guide the creation of the various deliverables for non-DEDW activities.
• Used the Rational Unified Process (RUP) software development process to guide the creation of the various deliverables for DEDW activities.
• Specified, designed and built a dynamic ETL tool that reads from a clinical metadata master data repository to programmatically generate ETL programs using PL/SQL.
• Specified, designed and built Informatica mappings that moved data from the source systems to the staging area of the data warehouse.
• Specified, designed and built Informatica mappings that moved data from the operation data store (ODS) to the data marts fed from the data warehouse.
• Specified, designed and built a validated tool that automatically uploaded externally data managed clinical data using SAS and Unix shell scripts.
• Specified, designed and built processes and server-side software to dynamically upload clinical trial datasets stored as SAS datasets into Oracle tables while resolving metadata issues between Oracle and SAS.
• Used SAS and LaTeX to create an NDA Dataset Report generation tool that creates a completely annotated, hyperlinked Section 11 Case Report Tabulation, reducing the time to create the report from two person weeks to 10 minutes. The tool saves the company approximately $150,000 per year in addition to the days shaved off time to submission.
• Gave a presentation at the 2001 DIA conference in Denver on the NDA Dataset Report tool.
• Used PL/SQL and Oracle replication functionality to specify, design and build an FDA compliant multi-instance extension to ClinTrial 4.1 and 4.2 that duplicated the current functionality of Oracle RAC.
• Specified, designed, developed, and implemented a Medical Coding Data Warehouse.
• Used PL/SQL, SAS and ClinTrial 4.1 to specify, design, develop, and implement a Medical Coding Data reporting system.
• Specified, designed, developed, and implemented a Clinical Data Discrepancy Data Warehouse.
• Created BI Dashboard reports from the Clinical Data Discrepancy Data Warehouse to enable the clinical trial management to analyze and compare the performance of various investigators vis-à-vis the quality of their data.
• Used SAS and ClinTrial 4.1 to specify, design, develop, and implement a Clinical Data Discrepancy reporting system.
• Specified, modeled, designed, developed, and implemented an interface between ClinTrial 4.1 and IMPACT, a clinical site management tool.

Confidential, Warren, NJ

ETL Architect

Responsibilities:

• Used Oracle, Unix Shell Script, PL/SQL, and SQL - Loader to specify, design, develop, and implement an interface between an SAP payroll system and remaining legacy mainframe programs.
• Used MS-Access to create a set of monitoring reports for the above system.
• Used Oracle and PL/SQL to create an SAP debugging tool.

Confidential

Transactional System/Data Migration Architect

Responsibilities:

• Worked with clients to perform requirements analysis and develop new business rules for managing the physical and logical creation and tracking of serum samples.
• Specified, designed, developed, and implemented strictly object-oriented Clinical Sample Tracking and Vial Label Generation systems for a database based on 450,000 vial records using Smalltalk, MS-Access and Oracle on a Windows NT client platform.
• Used rigorous rules to logically design the database tables and relationships for the above subsystems, which formed the middle layer in a hierarchical serology management system.
• Specified, designed, developed, and implemented server side batch stored procedures using Oracle PL-SQL on a Unix server platform.
• Performed the object-relational mapping from SmallTalk to Oracle..
• Performed database tuning in a DBA role using Oracle Object Manager and PL-SQL.
• Worked with clients in a DBA role to resolve database integrity issues with a legacy database.
• Migrated that legacy database into the new production database using SQL and PL-SQL.
• Created over 1000 pages of FDA compliant unit test documentation for the Clinical Sample Tracking, Vial Label Generation and other modules.
• Created Software Maintenance Manuals for the above modules.