Default profile banner
PK

Praveen Kumar

@praveenkumar2197

Data Engineer

Lucknow

https://www.linkedin.com/in/praveen-kumar-4679781a1/

Tranzita SystemsBuddha Institute of Technology

Highly skilled Data Engineer with a results-driven mindset and 2.5 years of experience. Proficient in utilizing a wide range of analytical tools to extract valuable insights from raw data. Demonstrated success in designing and implementing robust data pipelines, warehouses, and reporting solutions. Expertise includes leveraging cloud computing platforms like Azure for efficient data storage, processing, and deployment. Committed to optimizing ETL processes, ensuring data quality, and fostering data-driven decision-making through effective collaboration with stakeholders.

Experience

DATA ENGINEER (Proctor & Gamble Projects)

Tranzita Systems

•Feb 2021 - Present•Lucknow

Managed On-Shelf Availability (OSA) using Azure Data Factory, SQL, KNIME, Python, Azure Functions, and Power BI. Cultivated a strong partnership with P&G to track sales and P&L, implementing predictive analysis with 95% accuracy. Led the development of an ETL pipeline using Azure Data Factory into SQL, achieving 100% efficiency. Implemented advanced SQL stored procedures and visualized data in Power BI. Developed data retrieval processes using Python/KNIME from SharePoint/OneDrive/HTML, and designed robust ETL pipelines for dashboards using Azure Data Factory and Power BI.

Education

Buddha Institute of Technology

B.Tech

Electronic & Communication Engineering

Jan 2016 - Jan 2020

Licenses & Certifications

Python certificate

LTBP

• No expiration

Skills

SQL
Azure Functions
Power BI
Python
Azure Data Factory
Logic Apps
Advance Excel
KNIME
SharePoint
OneDrive
ETL
Panda library