Exploring new technology trends, Cooking and Long drive with family
NARESH SAHU
Associate Director
Pune
Summary
Highly organized and self-motivated professional with 13+ years of experience in project management, team development, analysis, design, development and deployment of Data Warehousing and Big Data Applications using AWS cloud data analytics applications, Cloudera(HDFS, HIVE, SCOOP), Informatica , MSBI (SSIS), Teradata, Oracle and Spark .
- Working as an Associate Director in Data Engineering.
- Having experience in Retail, Banking, FMCG, Insurance and Gambling domains.
- Strong working experience in ETL design and development.
- Having working knowledge in Azure Devops, Github, Gitlab, Gitbash, Confluence, JIRA.
- Leading a team of 20+ data engineers and testers distributed across different geographical regions from end to end development of data life cycle.
- Helped establishing best practice standards and guidelines.
- Providing technical leadership in areas of data engineering/techniques.
- Established partnership with different software vendors and IT partners in support of data warehousing initiatives.
- Responsible for overall project management and delivery, where taking take care of on time delivery.
- Passionate about driving business growth and creating positive work environment.
Overview
13
13
years of professional experience
1
1
Certification
3
3
Languages
Work History
Associate Director/Principal
Synechron
Pune
01.2023 - Current
- Working as an owner of a program where responsible for end to end development and deliveries.
- Designing new innovative systems with advanced technology utilizing internal resources and external software.
- As a future road-map redesigning the existing architecture to overcome the pain points. Taking initiative of multiple POCs.
- Determining all policies and procedures with oversight for Data Governance, Security and Cloud data controls.
- Collaborated with stakeholders to identify and analyze business requirements, resulting in an optimized technical solution.
- Leading a team of 21 resources.
- Working with project managers to develop and implement strategies for cost savings and resource optimization.
Technical Architect
HARMAN
Bangalore
10.2021 - 01.2023
- Worked as a Solution Architect/Technical Manager within the Digital transformation team.
- Designed the data pipeline from heterogeneous system to the data lake and data warehouse.
- Worked with senior architects to plan the migration of existing jobs developed in ETL tools to AWS.
- Used AWS data analytics tools to design and develop the data pipeline.
- Worked on enhancement tickets where analyzing the SQL queries and ETL Jobs and doing required changes.
- Managed a team of 14 resources and responsible for their overall growth in technical aspects.
- Responsible for project management and on time delivery.
- Worked in an agile environment.
- Participated on customer engagement activi
Senior Technical Lead
HCL Technologies
Hyderabad
01.2019 - 10.2021
- Worked as an ETL/Data Architect.
- Created models using data vault architecture.
- Closely worked with different stake holders to get the business requirements.
- Designed ETL framework with multiple cloud based technologies and ETL Tools.
- Worked with AWS cloud based ETL and analytics tools.
- Used MPP DB Teradata, AWS Redshift and used SQL Server, Oracle.
- Used AWS lambda with python for data ingestion to the data lake hosted in S3. Used SQS, SNS, Glue, Athena and Amazon EMR.
- Managed a team of 9 resources. Did the quarterly and year-end review of my reporters and responsible for approvals such as time-sheets, leaves and financia
Senior ETL Developer
NISUM Technologies
Hyderabad
07.2017 - 01.2019
- Gathered the requirements from customer.
- Created and modified existing data model.
- Created Mapping Sheet as per business requirement.
- Developing Teradata BTEQs to load data into tables.
- Developed Informatica PowerCenter jobs.
- Created SSIS packages based on existing Teradata BTEQs.
- Developed SSIS packages to load data into different layers like Stage, Work and Target.
- Implemented integration framework with SSIS using Audit and Control tables.
- Reviewed the ETL codes developed by the team.
- Participated in code migration from DEV to QA and PROD.
- Lead a team of 6 resources.
Senior Associate
Cognizant
Hyderabad
07.2016 - 06.2017
- Created Mapping Sheet as per PDM and business requirement.
- Created data model.
- Developed Teradata BTEQs to load data into tables.
- Developed views for Semantic layer to generate reports.
- Worked as a peer reviewer of ETL codes developed by the team.
- Lead a team of 6 resources.
Technology Lead
Infosys
Bhubaneswar
12.2015 - 06.2016
- Created ETL jobs to migrate the data from one environment to another environment.
- Reviewed the ETL codes developed by the team before code migration to upper environments.
- Used Informatica BDE tool for POC.
- Was part of Informatica COE team and providing ideas and feedback to different teams.
Senior Consultant
CapgeminiIndiaPvtLimited
Bengaluru
03.2011 - 11.2015
- Created ETL mapping specification docs based on the BIM alignment sheet.
- Created reusable components for Database (Stored Procedures) andETL (Mapping, Session, Worklet) loads.
- Extensibly worked on Informatica and TeradataSQL generators forSCD‑1 and SCD‑2.
- Involved inETL framework design.
- Developed Informatica PowerCenter Codes for data migration or to load into DWH tables.
- Worked at client location (Sweden).
- Was a member of Informatica trainers group where given training to junior/new team members.
Software Engineer
UST Global
Trivandrum
03.2010 - 03.2011
- Understanding the Business rules completely and implemented data transformation methodologies.
- Design the mapping to load the data into the target based on primary, foreign key relationship(constraint based load order) and used Target Load Plan.
- Involved in designing the E.T.L mapping document.
- Worked with various transformations like Aggregator, Sorter, Expression, Filter, Router and Update Strategy.
- Worked with different tasks like Session task, Command task and Email task. Involved in developing theUNIX shell scripts.
- Involved in Unit and Integration testing.
Education
Bachelor of Technology - Computer Science
National Institute Of Science And Technology
04.2001 -
Skills
SSISSQLServerOracleAWSRedshiftETLDesignHIVEScoopHBasePythonAthenaAWSGlueAWS S3SnowflakeAWS SNSData ArchitectProject ManagementAzure DevOpsAgile Data EngineAWS SQS
Apache Spark
Informatica
Team Management
Data Governance
Certification
AWS Solution Architect Associate
Interests
AWS Solution Architect Associate
I am a certified AWS Solution Architect.
Timeline
Associate Director/Principal
Synechron
01.2023 - Current
AWS Solution Architect Associate
01-2022
Technical Architect
HARMAN
10.2021 - 01.2023
Senior Technical Lead
HCL Technologies
01.2019 - 10.2021
Senior ETL Developer
NISUM Technologies
07.2017 - 01.2019
Senior Associate
Cognizant
07.2016 - 06.2017
Technology Lead
Infosys
12.2015 - 06.2016
Senior Consultant
CapgeminiIndiaPvtLimited
03.2011 - 11.2015
Software Engineer
UST Global
03.2010 - 03.2011
Bachelor of Technology - Computer Science
National Institute Of Science And Technology
04.2001 -