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
Senior Talent Acquisition Partner/Sourcer at University of California – San FranciscoSenior Talent Acquisition Partner/Sourcer at University of California – San Francisco