SHESHADRI LOKAPUR
Mumbai
Summary
Results-driven Data Engineer with 3.3 years of expertise in Life Science & Healthcare (LSHC) and Technology, Media & Telecom(TMT) domains. Specializes in data modeling, warehousing, ETL processes, integration, and migration. Proficient in PySpark, Python, Databricks, SQL, AWS, Teradata, Greenplum, StreamSets and Kafka. Demonstrated success in delivering impactful projects and achieving measurable results.
Overview
3
3
years of professional experience
Work History
DC Analyst
Deloitte Consulting India Pvt Ltd
Mumbai
04.2021 - Current
- Designed and developed several data models and integrated data using reusable frameworks.
- Developed reusable near real-time, config-driven ETL frameworks using PySpark, Databricks and AWS, aimed at loading data end-to-end within a 15-minute SLA through Spark's Change Data Capture (CDC) feature.
- Created a config-driven batch processing ETL framework for efficient data ingestion.
- Strong understanding of SQL, including analytical functions and Slowly Changing Dimensions (SCD) types for effective data management and transformation.
- Proficient in understanding and integrating data from various source systems, including ERP (JDE & SAP), Manufacturing (Siemens MES & Werum) and Laboratory systems (LabWare LIMS & SQL LIMS).
- SME for Lot Track and Trace (LTT) systems, including designing and developing frameworks and data models for LTT use cases.
- Experienced with Databricks (Delta Lake, Cluster Types, Utility Catalog, Jobs, Notebooks) and AWS (IAM roles, S3, Lambda, Secret Manager, etc).
- Worked on data migration and integration from various sources into Teradata and Greenplum using Kafka for real-time data streaming.
- Responsible for development, System Integration Testing (SIT), deployment, and post-deployment support.
- Hands-on experience with CI/CD migration, JIRA, Tidal Scheduler, BMC Control-M Scheduler, ServiceNow.
- Created several automated scripts for unit testing to minimize defects in higher environments, enhancing overall quality and stability.
- Responsible for Development, SIT, Deployment & Post deployment Support.
Education
Bachelor of Engineering - Information Technology
University of Mumbai
Skills
- Expertise in designing dimensional data models using star schema and snowflake schema
- Proficient in analyzing business processes and requirements, and translating them into technical specifications
- Developed and optimized complex ETL data pipelines using Python, PySpark, and AWS within Databricks
- Solid understanding of database systems including Teradata, PostgreSQL, and SQL Server
- Experience in building Data Lakes with near real-time and batch configuration frameworks in Databricks
- Skilled in real-time data ingestion tools such as StreamSets and Kafka, including pub/sub models
System Experience / Development Tools
- Platform - Databricks, AWS, StreamSets, Tidal, BMC Control-M.
- CICD - GitHub, GitLab.
- Middleware / Databases: SQL, Teradata, Oracle, PostgreSQL.
- Languages: Python, SQL, Java, Unix.
- Big Data Technologies: Pysparks, Kafka.
Training
- AWS-Solution Architect Associate
- Introduction to modern application development by NPTEL.
Affiliations
- Certified AWS-Solution Architect Associate.
- Secured 3rd position in project competition held by Institution's Innovative Council 2.0(Ministry of HRD).
- Secured ELITE GOLD in Introduction to modern application development by NPTEL (IIT Madras).
Accomplishments
- Recognized with 3 Applause Awards by Deloitte for creating high-impact solutions and delivering exceptional quality work.
Soft Skills
- Quick Leaner
- Problem solving
- Good communication and presentation skills
Timeline
DC Analyst
Deloitte Consulting India Pvt Ltd
04.2021 - Current
Bachelor of Engineering - Information Technology
University of Mumbai
Similar Profiles
Surya Deepthi PemmarajuSurya Deepthi Pemmaraju
Sr.Analyst - Procurement at Deloitte Consulting India Pvt LtdDeloitte Support Services India Pvt LtdSr.Analyst - Procurement at Deloitte Consulting India Pvt LtdDeloitte Support Services India Pvt Ltd
Payal JoshiPayal Joshi
Senior Consultant at Deloitte Consulting India Pvt. Ltd.Senior Consultant at Deloitte Consulting India Pvt. Ltd.
SANTANU RANASANTANU RANA
Consultant at Deloitte Consulting India Pvt. Ltd. (Offices of the US)Consultant at Deloitte Consulting India Pvt. Ltd. (Offices of the US)
Ashwin VishnuAshwin Vishnu
Senior Consultant, Engagement Financial Advisor at Deloitte Consulting India Pvt LtdSenior Consultant, Engagement Financial Advisor at Deloitte Consulting India Pvt Ltd
Shikha NishadShikha Nishad
Director of Office Operations at Information Tech Consultants Ltd-Progriz COE Pvt LtdDirector of Office Operations at Information Tech Consultants Ltd-Progriz COE Pvt Ltd