Perumalla Uday Kumar
Assistant Consultant at TCS!!
- Role
- Assistant Consultant at Tata Consultancy Services
- Location
- Bengaluru, KA, IN
- LinkedIn followers
- 500 followers
About Perumalla Uday Kumar
Experience : Having a total experience around 9 years in Data Analytics IT industry in all phases of life cycle.Skills: Experienced in Snowflake Cloud, SQL, AWS, Python, Tableau, SAS, Cognos BI, ML Techniques. Career Highlights: DATA ENGINEER - SNOWFLAKE CLOUD:a. Automate the data loading process from AWS S3 to Snowflake Cloud using AWS Bucket, Policy, Role,External Stages, Integration Storage objects, Pipe.b. Designed data pipelines for SCD Type 2 & Type 3 data loading using Merge statements, Streams, Tasks, Views, Tables etc.c. Worked on Data Full & Incremental load from Kafka/AWS to SF, created Jobs, Process to load data into Stage, Intermediate, Core, Top of Stack, Control tables, Semantic & Snap views.d. Successful Implementation of Data movement from On-Premise to Snowflake Cloud.DATA ENGINEERING - PYTHON : Created following utilities for different projects.a. Get the Object mapping from stage to intermediate to core to semantic views at each column-table level.b. Compared columns, datatypes of an object from Snowflake DB with Git Repository & compared columns from one layer to other layer table wise.c. Get the stats like batch, etl_date wise, counts for each table to know data discrepancy.d. Migration from one system to other, provided insights of new objects for column manipulations which has text case issues at source.e. Created Different Flags for each object to ensure all the mandatory columns/ recently added cols are present.f. Generated DML scripts with table, type of operation & figure out missing jobs if any.g. Created backup tables with CR/date & Cleaned the backup/ test tables in single go.h. Created Data Pipelines to load data from one layer to other layer using python.BI REPORTS & VISUALIZATION:a. Worked on designing Data Models in report layer as per business use cases using sql in optimized approach.b. Worked on desgining complex dashboards,data blending using Parameters, Filters, LODs, Time functions,Calculated Fields, Actions based on business use cases.c. Ability to Migrate Cognos BI reports to Tableau, repointing of reports from one DB to other DB & performed SIT, UT, Functional, Regression testing & verified business functionality is present.d. Worked on enhancement project on the existing code Tableau & Worked on issues in upgradation of servers in Tableau.PROJECT MANAGEMENT:a. Worked on Effort Estimates, Resource allocation, Sprint planning, Identify Risk & Challenges in advance & provide Mitigation plans.b. Mentoring the team members & providing the necessary support in the project.
Experience
Assistant Consultant
Jun 2022 — Present · Bengaluru, IN
Education
Jawaharlal Nehru Technological University, Kakinada
Master of Technology
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.