Vamsi Krishna Praturi
Hyderabad
Summary
Dynamic data engineer with proven skills in SQL scripting, ETL processes, and data visualization. Developed efficient data pipelines and enhanced business intelligence initiatives, contributing to measurable improvements in reporting and analysis.
Overview
10
10
years of professional experience
Work History
Associate Manager(Data Engineer/Data Analyst)
Pepsico Global Services India Pvt
Hyderabad
03.2021 - Current
- Designed and developed data pipelines for efficient integration of large datasets.
- Collaborated with cross-functional teams to define data requirements and solutions.
- Analyzed data patterns to enhance business intelligence initiatives.
- Created Python scripts for data extraction from web services APIs into databases.
- Maintained and optimized Power BI reports to improve user accessibility.
- Participated in project meetings to ensure alignment of reporting solutions with business goals.
- Programmed applications using object-oriented languages to achieve code stability and reuse.
- Resolved customer issues by establishing workarounds and debugging defects.
- Collaborated with stakeholders to gather requirements and define project scope.
- Trained team members on best practices for data visualization techniques.
- Transformed raw data into meaningful reports using Power BI tools.
- Conducted data analysis to identify trends and support decision-making.
- Managed team schedules and coordinated daily operations to ensure efficiency.
- Analyzed workflow processes to identify areas for improvement in service delivery.
- Collaborated with cross-functional teams to execute strategic initiatives effectively.
- Implemented quality control measures to enhance product and service standards.
Lead Data Analyst
Keylent/Bright Visionz
Hyderabad
01.2020 - 03.2021
- Work with business partners to understand business objectives, develop value-added reporting, and provide data extracts and analysis.
- Wrote logical T-SQL scripts for Excel formulas for created stored procedures for smooth automation.
- Designing SSIS packages and deploying them to SQL to schedule the packages.
- Created Adobe Analytics templates and connected them with Power BI to create dashboards and customize visuals.
- Loading Adobe Analytics Templates data to SQL Server through SSIS using Azure connectivity.
- Fully automated Google Analytics templates data to load into SQL tables and use Power BI to transform data with some customized visuals.
- Continuously improve campaign design and delivery by leveraging all analytical tools/techniques.
BI Developer
Vengai Software Solutions Pvt
Hyderabad
08.2018 - 01.2020
- Created relationships at the database level and tabular model for custom dimensions.
- Created the reports using charts such as pie, bar, line, KPIs, custom visuals, etc.
- Charts are used to make reports more user-friendly for analysis purposes.
- Expertise in writing complex DAX functions in Power BI.
- Published reports to the Power BI publisher, and scheduled the data sets.
Software Developer
MD India Health Insurance TPA
Hyderabad
12.2015 - 08.2018
- Expertise in extracting, transforming, and loading (ETL) data from Excel, flat files, to MS SQL Server by using DTS and SSIS services.
- Experience in developing custom reports and different types of tabular reports, matrix reports, and drill-down reports in multiple formats using SQL Server Reporting Services (SSRS).
- Expertise in extracting, transforming, and loading (ETL) data from Excel, flat files, to MS SQL Server by using DTS and SSIS services.
- Developed and used C# code to auto run the SSIS packages and SSRS reports.
Education
B-Tech - Electrical, Electronics And Communications Engineering
JNTUH
Hyderabad07-2015
Skills
- SQL scripting
- Data visualization
- ETL processes
- Business intelligence
- Data analysis
- Teradata
- Tableau
- Power BI
- Python
- Visier
- DBeaver
Languages
English
First Language
Hindi
Intermediate (B1)
B1
Telugu
Upper Intermediate (B2)
B2
Marathi
Beginner
A1
Timeline
Associate Manager(Data Engineer/Data Analyst)
Pepsico Global Services India Pvt
03.2021 - Current
Lead Data Analyst
Keylent/Bright Visionz
01.2020 - 03.2021
BI Developer
Vengai Software Solutions Pvt
08.2018 - 01.2020
Software Developer
MD India Health Insurance TPA
12.2015 - 08.2018
B-Tech - Electrical, Electronics And Communications Engineering
JNTUH
Similar Profiles
Yuvadeep Nihaar AnugulaYuvadeep Nihaar Anugula
Associate Manager - HR at Pepsico Global Services India Pvt LtdAssociate Manager - HR at Pepsico Global Services India Pvt Ltd
Rakshith BhatRakshith Bhat
Manager - HR Transformation Projects at PepsiCo Global Business Services India LLPManager - HR Transformation Projects at PepsiCo Global Business Services India LLP
Soumya BastiaSoumya Bastia
Manager-Talent Acquisition (India and AMESA Business) at PepsiCo Global Business Services India LLPManager-Talent Acquisition (India and AMESA Business) at PepsiCo Global Business Services India LLP
Rahul SinghRahul Singh
Manager-HR & L&D at KhetyiManager-HR & L&D at Khetyi
RABAB FATIMARABAB FATIMA
Agency Success Lead – DV360 at CognizantAgency Success Lead – DV360 at Cognizant