Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Manoj Arora

San Francisco,CA

Summary

  • 18 Years of Engineering experience in Architecture, Solution and Supporting of Data Warehouse, Business Intelligence, Telemetry System, Big-data, Near Real-time, Legacy, Cloud based and Analytics applications.
  • Responsible for defining the information architecture and technology infrastructure along with the design of data models for Enterprise Data Service team using Waterfall and Agile methodology.
  • Designed and developed Data Engineering Frameworks like Auto ETL, Data Quality, Security Predicate, Auditing and few others.
  • Responsible for managing the data analysis, data warehouse, data mapping along with defining the Metadata repository for Data Applications.
  • Highly motivated, energetic individual and a very good team player willing to work smart to meet intensive schedules and having excellent communication, presentation and interpersonal skills.
  • Strong knowledge of concepts in Data Quality, Master Data Management, Data Governance and Data Stewardship.
  • Excited to solution Machine Learning and Data Science problems.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Lead Data Engineer

Salesforce.com
06.2014 - Current
  • Designed and developed various BI solutions for giving insights to business leaders on all the aspects of the CRM stages.
  • Auto ETL Framework: Designed and developed Python framework to replace ETL tool with Auto ETL till ODS layer using API, Big Data Golden gate, AWS and Snowflake.
  • Tableau Telemetry System: Designed tableau Telemetery system to collect Petabyte scale of daya on Snowflake and Big Data Platform.
  • Enterprise Data Hub: Design and developed EDH for Salesforce to load/retrieval of real time data by Integration/Analytics applications.
  • Audit Framework: Designed and developed Audit Framework to be used across Data Engineering team.
  • Data Quality Framework: Designed and developed Data Quality framework which outlines and Data Issue in Proactive way.
  • Data Sharing Framework: As part of Self Service Enablement project, designed SSE framework to On-board business teams and share data securely with each other.
  • Data Security Framework: Designed and developed Data Security Framework for BI tools.
  • Designed and developed solutions for Near Real Time data loading using Big
    Data Golden Gate, AWS, Snowflake and Tableau.
  • Finance - Designed BI solutions to create Complex metrics like ACV, AOV, Attrition, Open Pipe, Plan-Outlook, System Usage etc. These are very complex and highly Critical Metrics which are used by many business teams/Data Scientists across Salesforce.

Senior Data Engineer

Cognizant Technologies
12.2013 - 06.2014
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Designed and implemented effective database solutions and models to store and retrieve data.
  • Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
  • Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.

Senior Data Engineer

Headstrong Corporation
06.2010 - 12.2013
  • Responsible to design, develop many EDW and BI applications for Morgan Stanley Bank.
  • Most of the applications were used to report Financial data to FED.
  • Designed HELOC system for BI to report suspicious mis-use.
  • Designed BI application for BASEL II. Basel II is an international business
    standard that requires financial institutions to maintain enough cash reserves
    to cover risks incurred by operations.
  • Designed Treasury Reporting system. It was heavily used by business to report
    data for FED.

Data Engineer

HCL Technologies
02.2005 - 06.2010
  • Architect and Deployed analytical capabilities for Fortune 500 Organizations.
  • Created Oracle Procedures/Functions for Performance faster performance.
  • Implemented all types of Slowly Changing Dimensions.

Education

B. Tech - Information Technology

Institute of Engineering And Technology
Lucknow, India
07.2004

Skills

  • Snowflake
  • Big Data Technology: EMR Spark, Hive
  • Airflow, Tidal
  • Advanced Python Scripting
  • ETL Tools : Auto ETL (Self Designed) Informatica, Jitterbit
  • Agile Scrum Master
  • Docker Kubernetes
  • Business Intelligence: Tableau, Einstein Analytics
  • Oracle Exadata, Teradata
  • AWS BI EcoSystem
  • Cloud and On-prem Data Warehouse and BI Applications

Certification

Snowflake Training
Advanced Python Programming Kafka for Data Engineers
AWS Eco System
Tableau Desktop

Timeline

Lead Data Engineer

Salesforce.com
06.2014 - Current

Senior Data Engineer

Cognizant Technologies
12.2013 - 06.2014

Senior Data Engineer

Headstrong Corporation
06.2010 - 12.2013

Data Engineer

HCL Technologies
02.2005 - 06.2010

B. Tech - Information Technology

Institute of Engineering And Technology
Manoj Arora