We provide IT Staff Augmentation Services!

Delivery Manager Resume

SUMMARY

  • Developed and implemented an agile program to transform the analytics maturity with a hybrid data engineering stack with on - premise data-warehouse appliance and cloud based data pipeline while expanding data coverage exponentially.
  • Introduced business capabilities such as consumer and account segmentation leveraging machine learning. The program created industry first ML algorithms for product recommendation and opportunities identification leveraged by sales and distributors. The capability has delivered net incremental GP of $12M since inception
  • Led the architecture design for migration of all Analytics and Reporting Solution to MicroStrategy from Cognos, Spotfire and Excel.
  • Architected the end to end solution of the commercial Apps including identification of the source data, aggregation need of the data in AWS Pipeline, the Caching layer, the APIs and the frontend (UI/UX).
  • Deployed the Analytics solutions to 1400 global users with 900 active users every day
  • Rearchitect the EDW Data model to sunset the business division specific datamart and implementation of Logical Data Model (LDM) for Analytics.
  • Design the ETL architecture for data feed to the centralized Enterprise Data Warehouse (EDW) from existing legacy systems, ERP (JDE and SAP ECC) and other 3rd party data providers.
  • Involved in design of the Data model for the Data ware house and Application.
  • Develop ETL flows and framework to support ETL development.
  • Design the Development of the ODI staging database, triggers and procedure for data validation.
  • Installation, upgrade and Administration of ODI Environment.
  • Setup ODI coding standards and guidelines, design and development of reusable ODI objects and framework.
  • Design of ETL process using ODI.
  • Design and develop the Error Handler for all the ODI packages.
  • Design, Development and Unit Testing of ODI Projects, Interfaces, Procedures and Packages for data loading into the Ware house from different data sources.
  • Code review of ETL interfaces to ensure the standards are followed as per guidelines.
  • Set up job flows and ODI scheduler for nightly cycle.
  • Optimize data warehouse to support business users and Business Intelligence (BI) applications such as Cognos and other analytics tools
  • Setting up different ODI user IDs for different roles. (i.e. developer, testers, reviewers, etc)
  • Migration of ODI code from one environment to other environment.
  • Develop shell script to invoke the ODI scenarios.
  • Develop test script for the ETL process for Integration and User Acceptance Testing

TECHNICAL SKILLS

  • Data Engineering
  • Cloud Engineering
  • Analytics
  • Agile / SCRUM
  • Design Thinking
  • Lean Startup
  • BI Tools
  • EDW/Data Lake
  • ODI/Attunity
  • DevOps
  • CI/CD
  • Project Management
  • Solution Architecture
  • CMMI
  • SDLC
  • ITIL
  • Financial Management
  • Coaching
  • Servant Leadership

PROFESSIONAL EXPERIENCE

Delivery Manager

Confidential

Responsibilities:

  • Led the platform selection of the Data Warehouse. Performed POC on 3 Appliances (Teradata, Exadata and Netezza) and selected EXADATA.
  • Architecture and set up of Exadata environment for Dev, Test and Prod.
  • Set up ODI Agent on Exadata server.
  • Involved in design of the Data model for the Data ware house and Application.
  • Develop ETL flows and framework to support ETL development.
  • Design the Development of the ODI staging database, triggers and procedure for data validation.
  • Develop source to target maps and identify transformation rules.
  • Setup ODI coding standards and guidelines.
  • Design of ETL process using ODI.
  • Design and develop the Error Handler for all the ODI packages.
  • Design, Development and Unit Testing of ODI Projects, Interfaces, Procedures and Packages for data loading into the Ware house from different data sources.
  • Code review of ETL interfaces to ensure the standards are followed as per guidelines.
  • Set up nightly ODI job flows using Enterprise scheduler (TIDAL).
  • Optimize data warehouse to support business users and Business Intelligence (BI) applications such as Cognos and other analytics tools
  • Create customized ODI roles and setting up different ODI user IDs for different roles. (i.e. developer, testers, reviewers, etc)
  • Migration of ODI code from one environment to other environment.
  • Develop shell script to invoke the ODI scenarios.
  • Develop test script for the ETL process for Integration and User Acceptance Testing.

Architect, Enterprise Data Warehouse and MDM

Confidential

Responsibilities:

  • Design the ETL architecture for all the inbound and outbound data feeds between different systems.
  • Architect the Master data Management solution (PDH and CDH) including process flow.
  • Architect the Technical environments for Dev, TEST and Prod environment including sizing estimates and servers and network needs
  • Work with the Implementation partner to define all the project deliverables and the Delivery process and approach.
  • Design ETL flow framework, reusable objects to support ETL development.
  • Architect the Integration between JDE, JDA and EDW system
  • Guide the Data Modelers and DBA team to design the efficient ODS and EDW data model.
  • Setup design and coding standards and guidelines based in industry best practices.
  • Oversee the overall design of the program and coordinated different work stream’s tasks to deliver MVP in time.
  • Worked with the PMO and PMs to develop and baseline the overall schedule for the program.
  • Selection of the technology platform for tools applying Enterprise Architecture principle.
  • Performance Tuning and optimization.
  • Set up ODI CDC to pull data from ERP system into EDW.
  • Customize the ODI Knowledge modules to meet business requirements.
  • Design Reusable Error Handler, File import export process etc.

Lead ETL Developer

Confidential, New York, NY

Responsibilities:

  • Design the Application and Data Warehouse Data Model (both Logical and physical).
  • Design the ETL architecture for data feed to the Data Warehouse and Data Mart from outside sources and the CBIDAS application and vice versa.
  • Manage all the ETL and Database work with 4 team members.
  • Lead the Design and Development of KPI and reports using OBIEE.
  • Lead the development of the database and ETL objects, triggers and procedure for data validation.
  • Involved in developing predictive analytics on possibility of fire exposures and notifying fire inspectors.
  • Define the Test strategy, Test Plan and Implementation plan.
  • Lead the Design, Development and Unit Testing of ODI Projects, Interfaces, Procedures and Packages for data loading into the Ware house and Application database from different data sources.
  • Set up job flows and ODI scheduler for nightly cycle.
  • Performance tuning of ODI projects.
  • Automation of ODI code migration from one environment to other environment.
  • Develop stored procedure using PL/SQL for checking data integrity.
  • Develop test script for the ETL process for Integration and User Acceptance Testing.
  • Lead application support transition to FDNY system team.

Lead Developer, Enterprise Interface Hub

Confidential

Responsibilities:

  • Study the existing system of the Agencies and come up with the data need of individual agencies.
  • Design and develop Enterprise Interface Hub Architecture and ETL Processes for data synchronization between CityTime and City’s Payroll Management System.
  • Define and design the standard XML messages.
  • Data mapping between Source DB2 table and Target Oracle tables.
  • Extract data from DB2 database and load the data using ODI in ORACLE database.
  • Set up CDC process in ODI to capture change data.
  • Installation and administration of ODI tool.
  • Use MQ to decouple the Interface ETL process from the Application.
  • Created Logical and Physical data model of the Interface database and reporting Data Mart.
  • Develop shell script to invoke the ODI scenarios.
  • Test automation of the ODI Scenario.
  • Installation and Administration including code migration of ODI into Development, Test and PROD Environments.

Hire Now