Data Engineer Power Bi

614-***-**** github.com/prashantbhatta

Prashant Bhatta

Reynoldsburg, OH 43068

******************@*****.*** linkedin.com/in/pbhatta Data Engineer with expertise in designing and optimizing high-performance ETL pipelines, reducing processing time by 30% using Python, SQL, and Snowflake. Adept at cloud-based architecture (Azure, GCP) and data warehousing, ensuring scalability and cost optimization. Skilled in business intelligence (Tableau, Looker, Power BI), enabling data-driven decision-making. Proven track record of reducing data latency, automating workflows, and mentoring teams to enhance efficiency. Skills

• Data Engineering Skills: ETL Development, Data Pipeline Optimization, Cloud Architecture (Azure, GCP), Data Warehousing

(Snowflake), Data Modelling, Backup and Recovery, Data Analysis, Data Migration

•Programming Skills: Python (Pandas, NumPy, Matplotlib), SQL, Bash Scripting, C, C++

•Tools & Frameworks: Apache Airflow, Azure Data Factory, Tableau, Looker, Power BI, Git, GitHub, JIRA, Slack

•Soft Skills: Communication, Analytical and Problem-Solving, Teamwork, Leadership, Drive and Initiative Experience

Lis Nepal Pvt Ltd Data Engineer Aug 2023 - Jul 2024

• Engineered scalable data pipelines integrating and transforming 10+ data sources (JSON, TAR, SFTP, API), ensuring seamless reporting and analytics.

• Optimized Apache Airflow pipelines, reducing data latency by 30%, improving system efficiency for 2M+ rows processed twice daily.

• Automated deployment workflows on Google Cloud Platform (GCP), reducing rollout time by 40% and enhancing system uptime.

• Enhanced QA processes, achieving a 25% reduction in post-deployment issues through robust testing and hypercare strategies.

• Documented workflows and conducted 5+ training sessions, resulting in a 20% decreased in post-handover support requests. Lis Nepal Pvt Ltd Associate Data Engineer Apr 2022 - Aug 2023

• Led the lifecycle of a retail inventory project across 5 geolocations (EU, US, UK, HK, CA), ensuring data accuracy and scalability.

• Designed and implemented ETL pipelines using Azure Data Factory, handling subject area dependencies and processing 10+ years of historical data.

• Built and optimized Snowflake data warehouses, reducing data processing time by 20% and supporting real-time analytics for inventory and sales metrics.

• Delivered 20+ actionable insights via Tableau and Looker, improving decision-making for inventory management by 30%.

• Mentored 5 interns and conducted 6 knowledge transfer sessions, enabling seamless project transitions. Lis Nepal Pvt Ltd Data Engineer Intern Jan 2022 - Apr 2022

• Evaluated and streamlined ETL workflows, reducing processing time by over 15 hours weekly.

• Authored and executed rigorous testing protocols for ETL processes, achieving a 98% validation success rate, which minimized data discrepancies and enhanced the overall reliability of data reporting for stakeholders. Projects

Cloud Migration Project

•Migrated 10+ TB of legacy on-premises data to Snowflake on Azure, achieving a 40% improvement in query performance. Retail Inventory Optimization

•Developed scalable ETL workflows to process global inventory data, providing insights that improved supply chain efficiency by 25%. Education

Wright State University Aug 2024 - Aug 2026

Master of Science, Computer Science (GPA: 3.5)

• Coursework: Big Data Analytics, Cloud Computing, Advanced Database Systems, Machine Learning for Engineers Kathmandu University Aug 2017 - Mar 2022

Bachelor of Engineering, Computer Engineering (GPA: 3.67)

• Achievements: Internships: Software Engineering Intern, focusing on data pipeline optimization and ETL processes.

Contact this candidate