Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Mohanakrishna Potnuru

Mohanakrishna Potnuru

Hyderabad

Summary

Total 13+ years of experience in Data warehousing projects. Technical Team Lead & Architect – Snowflake, Teradata, and Tableau Part of EDW Projects for Clients Cisco, NHL, Apple, and Warner Bros Experience in understanding and implementing large scale data warehousing programs and E2E data integration. Leading Offshore Team of 5 Members during Cisco Supply Chain BI project in LTIM.

Overview

14
14
years of professional experience
2
2
Certification

Work History

Senior Specialist - Data Engineer ( Snowflake )

LTIMindtree
09.2022 - Current
  • Developing Logical and Physical Data models.
  • Responsible for design and build Data warehouse/Data Marts.
  • Doing analysis on requirements and source ELTP systems to identify dimensions and facts.
  • Working with admin team to setup environments.
  • Responsible for developing, testing, implementing and support/maintenance of ETL pipelines (from different source systems to Snowflake Data warehouse)
  • Preparing various documents like technical design, mapping, and test cases.
  • Developing Complex views, stored procedures, user defined functions and SQL scripts.
  • SQL Query tuning to improve performance
  • Support production environment and debug failures and issues raised by business.
  • Developing dashboard as per business requirement in Tableau.

Associate Consultant

TCS
01.2020 - 08.2022
  • Having experience in building Snow pipe to load data from heterogeneous sources to Snowflake through AWS S3 Stages.
  • Worked on Snowflake Stored Procedure using JavaScript Lang.
  • Converting Teradata Stored Procedure to Snowflake Stored Procedures.
  • Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
  • Worked on optimizing and tuning the Teradata views and SQLs to improve the performance of batch and response time of data for users.

Technical Lead Engineer

Wipro Technologies
08.2018 - 01.2020
  • Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
  • Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
  • Worked on optimizing and tuning the Teradata views and SQL's to improve the performance of batch and response time of data for users.
  • Worked closely with analysts to come up with detailed solution approach design documents.

Associate

Cognizant Technology Solutions, CTS
01.2015 - 08.2018
  • As an ETL Developer, involved in providing user support for executing various jobs and providing data to the reporting team
  • Involved in production implementation of new systems and Teradata system upgrades as part of maintenance. Performance tuning of Teradata queries as a part of ETL approach

Software Engineer

Tech Mahindra
11.2011 - 01.2015
  • To handle the tracks individually and responsible for any Physical data modeling with the help of LDM and release model to concern team and responsible to the packages gets deployed in Production.
  • To create scripts and packages and send the information to respective Dev and Stage teams.
  • To check whether the reference integrity and data types in code and make the code in stage is in sync with that of production.

Education

Bachelor Of Technology - Electrical & Electronics Engineering

JNTU
Kakinada, India
05-2011

Skills

  • Cloud & Data Platforms : Snowflake,Amazon S3
  • Programming & Scripting : Python, Shell Scripting, SQL, JavaScript (for Snowflake Procedures)
  • Data Engineering & Integration : ETL/ELT Design, Data Modelling, Data Pipelines, Informatica Power Center
  • Databases : Snowflake, Teradata, Oracle, SQL Server, PostgreSQL
  • BI & Reporting : Tableau Data Visualization, PowerBI (DAX, Power Query)

Certification

SnowPro Core Re-Certified

Power BI Data Analyst (PL-300) Certified

Timeline

Senior Specialist - Data Engineer ( Snowflake )

LTIMindtree
09.2022 - Current

Associate Consultant

TCS
01.2020 - 08.2022

Technical Lead Engineer

Wipro Technologies
08.2018 - 01.2020

Associate

Cognizant Technology Solutions, CTS
01.2015 - 08.2018

Software Engineer

Tech Mahindra
11.2011 - 01.2015

Bachelor Of Technology - Electrical & Electronics Engineering

JNTU

Similar Profiles

CREATE PROFILE
Mohanakrishna Potnuru