SUMMARY:

• CEO, Director, Principal, and Senior Solution Architect for Consulting Services and Technology Companies
• Senior Data Architect for Pharmaceutical and Pharmaceutical Claims Companies
• Delivery Manager / Development Manager for Commercial Software Companies
• Data Scientist / Hadoop Development in Healthcare Industry
• Senior Data Analyst / MDM and Data Governance Implementations
• Business Intelligence and Data Warehouse - Cloud and On-Prem
• Data Governance / MDM / Data Quality Strategic Initiatives
• Financial and ERP Integration into a Data Warehouse
• Clinical Data Integration (Healthcare Provider)
• Pharmacy claims processing and adjudication
• Contracts and Rebates (Pharmaceutical)
• Mortgage Risk (Financial)
• Supply Chain Analytics
• Finance (Insurance, Mortgage, Credit Card)
• Pharmaceutical
• Crop Protection / Crop Science
• Healthcare Payer and Provider
• Consumer Goods Manufacturing
• Oil / Gas / Chemical / Utilities

TECHNICAL SKILLS:

RDBMS: Oracle, DB2, SQL Server, Teradata, SAP

Integration / Architecture: Erwin, Embarcadero ER/Studio, Informatica, SAP Business Objects, Cognos, SQL Server SSIS/SSRS/SSAS, Power BI, Oracle BI, Spotfire, Infosphere Data Stage / Data Architect / Fast Track

NoSQL: Hadoop, Python, Kafka, R, Pig, Ruby, Impala, Hive, Jenkins, Eclipse, Stash, MuleSoft, Salesforce Vlocity

PROFESSIONAL EXPERIENCE:

Confidential

Senior Solution Architect

Responsibilities:

• Primary point of contact for all database object design and development. Design and develop staging database and ODS for Digital Field Experience outage management, including outage audit messaging systems. Data is sourced in near real-time and performs incremental updates. Design and develop tables and complex stored procedures (Oracle / PL/SQL). Environment consists of approximately 20 stored procedures with nearly 10,000 lines of code and approximately 60 tables.
• Performance tune for optimal performance. Ensure trouble-free migrations of database objects across Development, Integration Test, UAT, and Production environments.
• Data is sourced from multiple outage management systems and custom developed MuleSoft applications providing data in tabular and JSON formats. Work with MuleSoft team to ensure smooth integration of the applications and the staging database.

Confidential

Senior Solution Architect

• Participate in a data assessment to determine a conversion and integration strategy for moving to a Salesforce Vlocity Provider CRM solution. Required the analysis of data flows between many different clinical and provider management systems as well as other custom developed solutions.
• Design and develop integrations (ETL) of RGA General Ledger and claims systems into the Financial Data Warehouse. Design and develop data models to support the new integrations.
• Design large scale integration solutions for Global Data Warehouse / BI, serving a worldwide user base. Solutions include Order Visibility (SAP Orders in Teradata), Logistics Metrics for Europe, Middle East and Asia (SAP, TMS, Teradata), Migration of custom applications (iBridge, others) to the Crop Data Warehouse.
• Guide development teams in designing the appropriate solutions for scalability, performance and maintainability and ensuring that enterprise standards are adhered to when appropriate.
• Develop Proof of Concept solutions for analytics to gauge performance and functionality.
• Perform data analysis and develop de-normalized views of SAP source data in Teradata DW, mapping required data to the correct sources in SAP.

Technologies / Applications / Data Sources: SFDC, SAP ECC,Teradata EDW in cloud, Teradata SQL Analyzer, SAP Power Designer, Oracle, Business Objects, Spotfire, Informatica, SQL Server, SSIS, Haystack.

Confidential

Solution Architect, ERP Systems Integration

Responsibilities:

• Design and develop integration strategies for ERPsystems into the Oracle Enterprise Data Warehouse.
• Manage ETL development teams (local and off-shore) to implement integrations. Conduct daily scrums.
• Design ETL processes for ERP systems into the financial data warehouse model and shared dimensions. This includes GL, Accounts Receivable and Accounts Payable.

Technologies: Microsoft Dynamics AX 2012, Extensive, complex SQL, Informatica, Data modeling

Confidential

Solution Architect

Responsibilities:

• Design and develop a source agnostic staging platform to accommodate SKU-level production, inventory, sales and demand forecast data from client ERP systems.
• Design and developed a 3NF operating model to accommodate the same data. Design and develop SSIS packages to load the data into this model.
• Design and develop a dimensional model to accommodate the application of the proprietary algorithms and deliver performant reporting of the output scenarios. Design and develop SSIS packages to apply the algorithms based on user input parameters and then transform and load the data to this model.
• Design and develop Power BI reports to present the output.

Confidential

Senior Consultant / Data Scientist

Responsibilities:

• Utilize the Explorys map reduce framework to load tables from many different RDBMS systems, as well as flat files into an HDFS Staging Grid. Wrote Pig scripts to join staged HDFS datasets to facilitate incremental loads. Wrote Ruby scripts to data from the joined data files. Performed bag exploration and lookups utilizing user-defined functions.
• Utilize advanced SQL skills to analyze and understand data flows in complex clinical and claims systems. Execute Impala and Hive queries to validate Pig and Ruby jobs.
• Manage code deployments in Eclipse SVN and GitHub. Configure, schedule and execute the loads with Jenkins. Publish the data out to HBase with map reduce.

Technologies utilized: Pig, Ruby, Eclipse, Unix, Jenkins Job Builder (configurations and scheduling), HDFS, Hadoop, Impala, Hive, SQL Developer, JIRA, NLP, Python

Confidential

Solution Architect

Responsibilities:

• Performed Information Management maturity assessment and recommended data governance initiative to coincide with a Value Based Care initiative
• Performed design of data governance framework and operational model.
• Determined data scope and plan for phased rollout, with focus on Quality Measures (QPP MACRA), Other Payer Cohort measures, Provider data, and Supplemental Lab Data.
• Worked with CIO, CMIO, and clinical program directors to ensure alignment of governance efforts with Epic instance consolidation, builds, and workflow standardization.
• Managed a small team of 4 analysts that were part of the initial data governance workgroup. Implemented a data governance findings review process and workflow for quality reporting and provider maintenance. Established initial Data Governance Committee and Executive Council.

Confidential

Senior Analyst, Data Quality

Responsibilities:

• Implemented a new data model for managing client profiles that originate from multiple sources in conjunction with new automated data quality processes, MDM rules (match, merge, standardization, survivorship and source prioritization at the attribute level), and data governance processes around key data elements.
• Serve as a business liaison to ensure a new client profile data model will conform to existing and future business use cases and to help identify and implement both IT and business-driven master data management rules that will, in turn, ensure improved data quality and better performance measures.
• Help formalize new governance processes and procedures to ensure future sustainability.
• Conduct business workgroup sessions to socialize the new model and gather critical business feedback required to formalize the MDM and Data Governance operating processes, framework and procedures moving forward.
• Managed two data quality analysts as part of this effort that were performing data profiling using Informatica Data Quality.
• Made architecture recommendations, as required.

Technologies utilized: SQL Server 2012, SSIS, SSRS, Python/SQLAlchemy, JSON feeds, MongoDB, Embarcadero ER Studio.

Confidential

Principal Consultant

Responsibilities:

• Use of Hadoop for persistent staging and archival of source files and SAS data sets and models.
• Broadening of virtualization across various platforms including Teradata, Hadoop, and Business Objects.
• Use of Impala for Hadoop analytics.
• Compliance requirements for BASEL II and their fit for the Hadoop Dynamic Data Exchange.
• Use of Rainstor for compression and archival of both Hadoop and Teradata data.
• Process change recommendations to get IT support more aligned with Data Analysts and departmental support groups.
• Opportunities to move aggregates up from Teradata to the Business Objects semantic layer to reduce user overhead on Teradata.
• Opportunities to migrate BASEL analysts, heavy users of the federated Teradata warehouse, to their own appliance along with use of Teradata’s Intelligent Memory for in-memory analytics and data lifecycle management.
• Perform Cerner and Soarian clinical data source system analysis to identify source tables in scope for integration, source table complexity, and transaction update processes. Initial analytics requirement is for a pneumonia study that involves encounter, order sets, clinical order, clinical findings, DRG’s, pharmacy order, and many other subject areas. Perform gap analysis between source systems and the IBM Healthcare Provider Data Model (HCPDM).
• Make modifications as necessary to the HCPDM data vault (atomic data warehouse) and the data marts (dimensional) using Infosphere Data Architect. Creat denormalized fact tables and views designed to optimize analytics capabilities and performance of Microstrategy BI. Maintain the business glossary and naming standards.
• Drafted the high level requirements and implementation roadmap for the integration effort.
• Managed a team of 2 data analysts responsible for mapping the clinical systems to the IBM Atomic and Dimensional Models.
• Helped implement Informatica. Responsible for ETL design. Profiled the sourcedata using Informatica. Managed a team of 3 Informatica ETL developers. Created unit test plans,performed peer reviews of their work, and helped resolve design/development issues(best practices to use in Informatica to ensure maintainability and high performance).
• Technologies employed include Netezza, DB2, Informatica Power Center and Data Profiler, Microstrategy, Infosphere Information Data Analyzer, and Business Glossary.
• Perform Cerner clinical data source system analysis to identify source tables in scope for integration, source table complexity, and transaction update processes. Source data included Clinical Orders and Findings, Diagnosis and Procedures, Patient Encounter and Tracking data, Pharmacy Order, and Allergy among others.
• Drafted the high level requirements and implementation roadmap for the integration effort.
• Helped craft the statement of work, provided resource estimates based on source data complexity and integration effort, and developed a project plan and timeline.
• Managed a team of 3 data analysts responsible for mapping the Cerner Clinical Data System to the IBM Atomic and Dimensional Models as well as reverse engineering existing reporting solutions and mapping attributes from Cerner that support Emergency Department Reporting into the IBM Dimensional Mart. Metrics applied include ED Operational, ED Quality, Lab and Radiology, and Diagnosis and Procedures.
• Managed a team of 5 ETL Developers responsible for integrating the Cerner data from source to staging and then to atomic data warehouse and dimensional mart.
• Technologies employed include Netezza, DB2, Data Stage, Fast Track, Business Objects, Information Data Analyzer, and Business Glossary.

Confidential

Responsibilities:

• Managed a team of 3 business and data analysts and data integrators.
• Analyzed all current Core HR data for possible conversion from ADP Enterprise to Workday.
• Developed a plan for conversion and cutover of Core HR data, benefits, compensation, recruiting, learning management, performance management, and payroll data. Plan was dependent on current business process cycles and dependencies.
• Developed a plan for sun-setting legacy systems.
• Drafted a Statement of Work, implementation roadmap, and resource estimates based on high level reporting requirements and source data complexity. Reports included Avoidable Care (Readmission, Ambulatory Care, ED Use, and Episode Treatment Groups). Source data included SAS extracts and other existing Data Warehouse source tables.

Confidential

Responsibilities:

• Developed a system development process that integrates with the company’s current development processes and leverages an offshore agile development model.
• Developed the management process to track daily progress, measure burn-down rate, velocity, and ensure timely delivery of incremental iterations of the ETL (Informatica) programs.
• Developed a functional test process that includes automated data profiling.
• Managed a Perficient team of one onshore tech lead and 4 offshore (China GDC, CMI Level 5) developers to deliver four integration systems (four separate enterprise applications integrated to a 3NF data warehouse) in a 5 month period.
• Provided governance of best practices and standards to ensure offshore development efforts conform to the corporate guidelines.

Confidential

Responsibilities:

• Work with business executives and other key stakeholders to formulate and map an information management strategy, help guide the project approach, drive out actionable and measurable requirements, and facilitate the ultimate design of the business intelligence architecture.
• Prepare agendas and conduct facilitated workshops and interviews to gather requirements. Structure the workshops to drive out comprehensive information usage patterns and prioritize functional and information requirements.
• Document business and technical requirements and proposed solution architecture. Guide the logical and physical architecture design.
• Assist with preparation of statements of work, project scoping and sizing, staffing and budgeting.
• Manage 4 Business Objects Data Integrator development resources to build ETL jobs to load the Staging tables and Data Warehouse.
• Manage 2 Tibco CIM development resources to build the master data management system.

Confidential

Data Architect

Responsibilities:

• Implemented Business Intelligence reporting and analytics via a SOA-based presentation framework. Drove integration efforts of various vendor-supplied data sources (including IMS NSP and First Data Bank), including the design for consolidation of these sources into a single repository for enterprise use.
• Responsible for concept to completion of a Data Mart fed by various operational systems including JD Edwards (iSeries DB2), SQL LIMS (Oracle Laboratory Information System), iMany CARS (Oracle Contracts and Rebates System), Trackwise (complaint system), SalesLogix and Siebel ePharma contact management (CRM) systems. Technologies used include Erwin for data modeling, Informatica and SSIS for ETL, WebFocus Crystal Enterprise, and Reporting and Analysis Services for Presentation and Analytics, Sharepoint for delivery, and Oracle 11g for the Enterprise Data Warehouse and the downstream Data Marts.
• Designed and developed a dimensional Data Mart for Manufacturing to provide near-real-time reporting capability for variances of shop floor data such as labor, raw material, and bulk and packaging yields. Utilized slowly changing dimensions and a single fact table for all shop floor data.
• Designed and developed a Data Mart to support a near-real time Executive Dashboard. The mart included reporting against key performance metrics for Inventory, Working Capital, and Sales Actuals against Budget and Forecast. Metrics included targets for Inventory (RAW, WIP and Finished Goods) including Inventory Turns, Accounts Payable and Receivable Aging, and weekly, monthly, and quarterly sales figures in dollars, units and doses against budgeted amounts.
• Designed and developed the data architecture (both Oracle and SQL Server) and data delivery for a drug pipeline forecasting application. Designed a centralized repository for IMS and First Data Bank national drug pricing and sales data that was provided via flat files supplied by the vendor. Data was bridged using NDC number, taking into account historical changes due to acquisitions and other factors and designed to handle monthly rolling history for 6 years.
• Designed a Sales, Rebate, and Chargeback analysis Data Mart downstream from the iMany CARS Contracts and Rebate System in Oracle, which also provided call tracking information from SalesLogix, a CRM application in SQL Server for the Inside Sales Department.
• Participated in vendor review and design strategy sessions to plan for future serialization of all packaged product to help meet federal and state requirements for ePedigree (government initiatives to prevent drug counterfeiting). Primary goal was to meet the stringent deadline imposed by the California Board of Pharmacy for all drug products sold in the state to have traceability at the unit level from the pharmacy all the way back to the manufacturer via the Pedigree. Investigated serialization, bar coding and RFID tagging options.
• Participated in numerous vendor reviews of Software-as-a-Service (SaaS) vendors that provide Predictive Sales Analytics capabilities by utilizing territory alignment data and call activity (Siebel) provided as data feeds, along with IMS Prescriber data loaded into a dimensional analytic model.

Confidential

Software Development Project Manager

Responsibilities:

• Responsible for multiple releases of a utility communication system, commercial software that communicated from master controllers to substations (utilities) and, ultimately, to meters and transponders via short hop RF two-way communication’
• Communicated project status and risk to executive management. Managed and mitigated risk to keep project on schedule and within budget.
• Employed MS Project, ClearQuest, ClearCase. Development in Weblogic, Oracle, C, Java, Python, XML, JUnit, and Jprobe. Agile & Waterfall methodologies. Conformed to ISO standards.

Confidential

Software Development Manager / Delivery Manager

Responsibilities:

• Development Manager for product that enables searching of chemical structures. Managed software release cycles on time and on budget. Requirements definition, design, development, testing and packaging of software. Managed a development team of 5 direct reports. Advanced use of Microsoft Project, Rational ClearCase and ClearQuest.
• Served as Engagement Manager for Tripos Professional Services. Responsible for managing the Discovery 360” project (Business Intelligence solution for Chemists, J2EE, Oracle, multi-tier, thin client, SOA architecture), a $5.5 Million project, from initial scoping and requirements definition through design, development, testing, and implementation of interim release cycles.
• Managed a project team of 20 developers, 5 QA analysts, and several business analysts. Managed and mitigated risk.

Confidential

President / Director of Professional Services

Responsibilities:

• Program Manager for Wellpoint: Managed a multi-terabyte healthcare-related Data Warehouse project from initial design to implementation. Served as Program Manager for a PMO office and supervised numerous project efforts for this approx. $30 million program including: Hardware procurement, data architecture, ETL design and development (including outsourced efforts) of both the Operational Data Store and the Data Warehouse. Led system analysis team of 5. Managed to a project plan with resource leveling. Development resources were distributed globally (India, Ireland, and several locations in the United States). Utilized risk management and mitigation. Met with C-level executives to present risk and issues plans.
• Project Manager for Wells Fargo: Data Warehouse and Operational Data Store design and development projects utilizing Wells Fargo’s modified Rational Unified Process. Developed a future-vision roadmap for Phase II of the Capital Markets Data Warehouse environment.
• Project Manager and Business Analyst for MasterCard: Analyzed data quality issues and tracking of customer data across a multi-terabyte Oracle Data Warehouse and multiple ERP and other enterprise applications utilizing Oracle RAC. Identified numerous breakdowns and inconsistencies in dataflow, and areas where customer data could be improved. Documented results and made suggestions for re-architecting the Data Warehouse. Analysis of complex database schemas & data mining.
• Decision Support Team Lead for Tyco: Managed a decision support development project utilizing Oracle and Business Objects to report sales and performance data as it relates to customer purchases on a large group purchasing (GPO) contract. Delivered the project on time and within budget. Developed programs for extraction, transformation and load (ETL) using Informatica.