SUMMARY:

Confidential is a Specialist in Data Modeling Architecture (Transaction processing, and Analytical processing), Data Warehousing/Reporting Solutions, Data - Integration (using Informatica, SSIS, Ab-Initio, and Amazon tools), Data Governance tools (in DQ, DM-A, MDM), Cloud (AWS, GCP), Big Data (Hadoop, Hive, EMR, Splice-Machine), and Program/Project Management with over 12 years of IT experience in delivering enterprise scale projects. He has successfully implemented projects end-to-end for various Big 4 Technology, Fortune 50, State clients, Health Care, Banking, and Life Sciences clients. He is highly adaptable, and a hands-on leader with a passion in Data-Engineering, Data Governance, and Cloud platforms.

TECHNICAL SKILLS:

Software / Products: Amazon Web Services (AWS - EMR, Hive, S3, EDX, Redshift), Hadoop, HDFS, Hive, HBase, Snowflake Cloud DWH, Splice Machine, Informatica PowerCenter, SSIS, SSRS, OBIEE, SQL Deverloper, SQL Workbench, Oracle BI Cloud Services, Workday

Development Tools / Languages: VB.Net, Unix Shell Scripting, C, Prolog, Lisp

Hardware / Operating Systems: Windows, Unix, Linux

Middleware / Databases: Mulesoft, Oracle, SQL Server, Redshift, Teradata, Mulesoft, Workday/Workday Studio

General Tools: MS Excel, PowerPoint, Project, JIRA, ALM

Software / Products: Amazon Web Services (AWS - EMR, Hive, S3, EDX, Redshift), GCP Data Engineering (BigQuery, BigTable) Hadoop, Informatica PowerCenter, SSIS, SSRS, OBIEE, SQL Developer, SQL Workbench, Oracle BI Cloud Services, Workday

EXPERIENCE:

Confidential

Delivery/Technical Program Manager

Responsibilities:

• Delivery Manager for 8 deliverables including ETL/BI/Data Operations modernizations, and Short/Long term Database strategies including Database Decommissioning, Move-to-Cloud, and Future-state Data Architecture
• Program Manager for 6 ETL/BI/Data-Integration/Strategy tracks delivering 8 deliverables within budget, cost, and timelines.
• Successful handling of Client (leadership, management, development teams), Deloitte Leadership, and successful management of 10 Onsite-Offshore Deloitte resources.

Confidential

Lead Data/Systems Architect

Responsibilities:

• Lead Data/Systems Architect to perform an end-to-end analysis of Data Capture, Maintenance, and Consumption of CUSTOMER module for myriad of Source and Target systems.
• Current state assessment of Salesforce, SUS, and multiple downstream and third-party systems at Conceptual and Logical level.
• Current state capabilities, and maturity assessment of CUSTOMER module.
• Future state recommendations to design a scalable SOA/Middleware based architecture to on-board multiple systems seamlessly and eliminate point-to-point integrations.
• MDM strategy recommendation to address CUSTOMER challenges, and uniquely identify a golden record, and recommendations on Data-Quality tools and processes to improve CUSTOMER DQ.

Confidential

Lead Data/Systems Architect

Responsibilities:

• Lead Data/Systems Architect for assessing the impact of “Innovative Study Design” for “Oncology Clinical Trial Acceleration” changes for 6 Key Systems in the IS ecosystem.
• Responsible for the design of mock-up datasets for the possible STUDY/BRANCH/COHORT/SUBJECT/SITE/MILESTONE level data with the anticipated changes.
• Provided the current state and proposed future state Conceptual state for the BRANCH level design along with the “IS Systems Architecture”.
• Provided Consultation on Data-Architecture activities to the Client Enterprise Architect, and provided the Implementation Plan for short-term Business Continuity, and long-term implementation for 6 systems: CMZ DataMart, DevODS, eTMF, SAP, eClinical, and CTA.

Confidential

Lead Big Data Engineer

Responsibilities:

• Worked on 2 PoC’s, and provided an assessment of Hive vs. Splice Machine for migrating Confidential .
• Provided stats, assessment of Splice Machine/HBase vs. existing Hive w.r.t load-times, query executions on small/large datasets, Explain Plans, and other SQL parameters.
• Analyzed various options (External Tools, In-House, Scala Code) to parse EDI file formats for Healthcare (834, 837I), and provided recommendations to the Client.
• Demo to the Client on Splice Machine query engine, EDI file parsing, and Splice Machine
• Provided an estimation of migration efforts including Resource, Cost, and Time estimation.

Technical Environment: Hive, HBase, Hadoop, HDFS, Splice Machine, Scala

Confidential

Data Integration Architect

Responsibilities:

• Data Integration Architect in the design and architecture of various Finance/Workforce/MDM Conceptual and Logical Data-Models.
• Gathered requirements from Finance, Workforce, and MDM Business Stakeholders.
• On-boarded various upstream systems: HR, Workforce (Oracle HCM, Taleo), Salesforce, Netsuite, and MDM (Dell Boomi) into the Snowflake DWH.
• Designed the data-models for Workforce, and Financial Planning for downstream Oracle Hyperion Cloud.
• Data-Integration of various source systems (Finance, HCM, MDM) into elastic Snowflake Cloud Data-Warehouse.
• Data-Profiling on existing data (in SQL Server, MySQL, and Oracle HCM) to understand current source systems (for the design of future state in Snowflake).
• Presented Conceptual, Logical Data-Models, and Overall Solution Architecture to the Client

Technical Environment: Oracle HCM, Dell Boomi, Oracle Hyperion, Snowflake Cloud DWH, SQL Server, MySQL

Confidential

Sr. AWS Data Engineer

Responsibilities:

• Build an Enterprise Data Lake ( Confidential ) using AWS technologies, and migrate the 2200 tables eCommerce DataWareHouse to the Data Lake, and support three platforms: Confidential, Oracle, and Redshift. Migrate all the DWH tables using the DCS (Data Collection Service) to EDX (Elastic Data Exchange).
• Provided a secure way of storing bulk datasets across Amazon in a highly secure Amazon S3-backed storage system called EDX (Elastic Data Exchange) that provides fast and easy management of data-storage, access, and movement.
• Gathered requirements, designed the DCS and EDX Test Profiles, performed Data-Quality (DQ) between DCS and EDX, and migrated from the DCS-to-EDX (Elastic Data Exchange) after successful Data Quality validations.

Technical Environment: Amazon Web Services (EMR, Hive, S3, EDX), Redshift, Oracle, Dynamo DB, DATANET (ETL)

Confidential

Technical Program Manager/Sr. Oracle Cloud Consultant

Responsibilities:

• Modernization of BI Reporting experience in Oracle BI Cloud Services (BICS) environment.
• Laid the roadmap along with timelines for the migration of ~90 reports from Discoverer to Oracle Cloud 12c.
• Interacted with various Business Stakeholders to understand the requirements for 4 important modules - HR, Sales, Finance, and Payroll to prepare the Business Requirements Documentation (BRD’s).
• Translated the BRD’s into Technical Specifications for the design and development of OBIEE Repositories, and Reports in the BI Cloud environment.
• SIT and UAT testing and Signoff’s on ~50 reports from the Business Stakeholders.
• Executed the MtP (Move-to-Production) activities for the HR, and Finance repositories, and reports.

Technical Environment: Oracle BICS 12c, SQL Developer, OBIEE

Confidential

Technical Program Manager/Sr. Data Architect

Responsibilities:

• Implementation of 3-layered architecture to load data into Internal IT systems from a major SaaS Cloud Vendor.
• Migration of all HR and Payroll data from Peoplesoft to Workday SaaS vendor.
• Design of various transaction and analytical processing data-models for database modernization and datawarehouse implementation.
• Technical Architect/Lead in the rollout of Workday Reporting and Integration workstream.
• Implementation of various successful migrations to Workday - Benefits, Compensation, Workday Recruiting, eAwards, One-Time Payments.
• Successfully led and managed global ETL/BI/Data Engineering teams for various Internal implementations.
• Set up the Data Governance teams at HR and Payroll IT for MDM, DQ, DM&A projects.

Technical Environment: Workday, Oracle, Erwin, Informatica, OBIEE, MS Project, JIRA, ALM

Technical Project Manager/Sr. Data Engineer

Confidential

Responsibilities:

• Migration of data from legacy systems, and implementation of databases, and
• Datawarehouse for BI Reporting.
• Design and architecture of transaction processing and analytical processing data- Models using Erwin for the revamped legacy systems.
• Data-migration and BI Lead for the migration of data from legacy systems into the Data-marts, and Datawarehouse.
• Managed and planned project budgets and schedules by laying out On-site/Off-shore Resource models.
• Successfully planned, managed, and delivered various project deliverables to meet and release significant pay-points from the client.
• Successfully managed external resourcing (in US) and global Solution Services IT teams.
• Design of various Budgeting tables, General Ledger, Accounts Payable/Receivable tables.

Technical Environment: MS Project, Erwin, Informatica, OBIEE, Business Objects, Oracle