Pavan Kalyan Sangepu
DATA ENGINEER
Euless,TX
Summary
Experienced BI Consultant, Data Engineer, and Azure Specialist with 5+ years in Business Intelligence, Data Engineering, and Cloud Solutions. Expertise in Power BI, Tableau, Azure Analysis Services, SQL Server, Data Factory, Synapse Analytics, and Databricks. Skilled in data integration, ETL processes, data modeling, performance tuning, and advanced analytics. Proficient in SQL, BigQuery, MySQL, and PostgreSQL, optimizing database performance and ensuring efficient data retrieval. Experienced in AWS services, including AWS Lambda, Amazon S3, and cloud-based data solutions. Applied business analysis, predictive analytics, and machine learning to drive data-driven decision-making. Managed security through Azure Active Directory and deployed reports on Azure and AWS platforms. Adept in CI/CD, Power Automate, and SharePoint for process automation and data governance. Strong analytical abilities, focused on data quality, visualization, and KPI-driven insights. Passionate about innovation, automation, and staying current with BI and cloud trends.
Overview
7
7
years of professional experience
3
3
Certifications
Work History
Power BI Developer
ConocoPhillips
05.2023 - Current
- Integrated Power BI with Azure SQL, Databricks, Snowflake, and BigQuery.
- Translated business requirements into KPI-driven analytics.
- Integrated Power BI with Azure SQL, Databricks, Snowflake, and BigQuery for real-time and batch reporting.
- Implemented RLS, performance tuning, and parameterized reports for optimized data retrieval.
- Led Power BI modernization, leveraging CI/CD pipelines, improving efficiency by 40%.
- Trained and mentored teams on Power BI, Tableau, data modeling, and automation with Power Automate and SharePoint.
- Ensured data integration and governance, utilizing CI/CD for reporting workflows.
- Worked with Medicaid data, ensuring compliance via SharePoint and Power Automate.
- Applied predictive analytics and machine learning to enhance forecasting and decision-making.
- Collaborated with stakeholders and IT teams to define and track KPIs effectively.
- Analyzed business needs and gathered requirements to develop KPI-driven solutions.
- Collaborated with stakeholders to align data analytics with business goals and strategy.
- Documented and communicated findings, offering actionable insights to improve business processes.
BI Developer
Rush Enterprise
01.2022 - 04.2023
- Worked extensively with Azure cloud services, including Data Lake, Azure SQL Database, and Snowflake.
- Created and optimized SQL queries to manage and retrieve data from relational databases, including Teradata.
- Collaborated with cross-functional teams to provide data-driven decision-making insights.
- Ensured data integrity and accuracy through validation techniques and best practices.
- Developed custom DAX measures and calculated columns to support complex analytical requirements.
- Automated data refresh processes to reduce manual reporting efforts and improve reporting efficiency.
- Assisted in Power BI governance, including workspace management, report lifecycle, and security implementation.
- Applied strong problem-solving and analytical thinking skills to troubleshoot complex data issues effectively.
- Medicaid data analyzed to generate insights for healthcare stakeholders and policymakers.
SQL Developer
AppSierra
01.2019 - 07.2021
- Assisted in building interactive dashboards and reports in Power BI, supporting business analytics.
- Developed SQL queries for data extraction, transformation, and reporting needs.
- Maintained and optimized Power BI datasets to ensure efficient performance.
- Participated in data modeling and warehousing initiatives to support reporting needs.
- Provided end-user training and documentation for Power BI solutions.
- Developed ad hoc reports and visualizations to support executive decision-making.
- Worked closely with stakeholders to refine reporting requirements and align solutions with business objectives.
- Conducted data quality audits and troubleshooting to resolve reporting inconsistencies.
- Effectively managed time and organizational abilities to handle multiple reporting tasks simultaneously.
- Leveraged Teradata and Snowflake for large-scale data processing and reporting.
Education
Master's - computer science
University of North Texas
Denton, United States12.2022
Bachelor's - Computer Science
GITAM University
Visakhapatnam, India05.2021
Skills
Data Skills: Data Analysis, Data Visualization, SQL, T-SQL, Python
Database Technologies: Azure SQL Database, Databricks, SQL Server, Snowflake, Oracle, Teradata
Version Control & DevOps: Git, CI/CD for data pipelines, infrastructure as code
Big Data & Processing Frameworks: Apache Spark, PySpark
ETL/ELT & Data Integration: ETL&ELT pipeline Design, CDC concepts, Data validation
Certification
Microsoft Certified Azure Data Engineer Associate
Timeline
Power BI Developer
ConocoPhillips
05.2023 - Current
BI Developer
Rush Enterprise
01.2022 - 04.2023
SQL Developer
AppSierra
01.2019 - 07.2021
Bachelor's - Computer Science
GITAM University
Master's - computer science
University of North Texas