Power Bi Data Analyst

Pranay Lingapuram

Ó +1-630-***-**** R ****************@*****.*** linkedin.com/in/pranay-lingapuram EXPERIENCE

Data Engineer 05/2022 - present

Cygnus Insight Inc

• Skills: Power BI, DOMO, Azure, ETL Development, SQL, Python, Data Governance, Linux VM Automation

• Designed and maintained 20+ ETL pipelines using Azure Data Factory for data integration across ERP and CRM.

• Developed 15+ Power BI dashboards and DOMO reports, with business intelligence and 40% faster reporting time.

• Optimized SQL queries and indexing strategies, improving database performance by 30% for large-scale reporting.

• Implemented data governance policies, ensuring data consistency, security, and compliance.

• Automated BI dashboards with LLM-powered insights, enabling real-time trend analysis and anomaly detection.

• Configured Linux VM automation for scheduled jobs, ensuring system stability and workflow efficiency.

• Managed automation jobs on Linux VMs, ensuring uptime and streamlining ETL workflows. Data Analyst II 08/2020 - 08/2021

Spreader IT Solutions

• Skills: Python, Power BI, ETL Pipelines, Azure, AWS, Data Validation, Query Optimization

• Developed and maintained ETL workflows for ERP and CRM, ensuring seamless integration across multiple platforms.

• Created interactive Power BI dashboards and implemented DOMO analytics, enabling data-driven decision-making.

• Conducted 100+ data validation checks, improving data quality and reducing inconsistencies by 45%

• Integrated customer churn prediction models into BI reports, enhancing customer retention strategies.

• Designed SQL-based data extraction and transformation processes, optimizing query execution time.

• Modeled database schemas for BI systems, ensuring data reliability and enhancing reporting efficiency.

• Trained colleagues in Power BI basics, empowering team members to independently generate insights. Data Analyst I 05/2019 - 08/2020

Spreader IT Solutions

• Skills: Python, Power BI, MySQL, Spark, Data Automation, Linux Scripting

• Built Power BI dashboards and automated DOMO reports, reducing manual reporting efforts.

• Designed ETL data pipelines and automated data refresh schedules, ensuring real-time reporting.

• Developed Python-based data transformation scripts, reducing data preprocessing time by 80%.

• Automated data normalization and extraction using Spark, reduced data pre-processing time by 80%.

• Implemented Linux/UNIX shell scripts for data movement and automation, reducing manual tasks by 25%.

• Developed and scheduled batch processes using Python, ensuring timely data availability for analytics teams.

• Utilized Python scripts for automation of data processes, decreasing manual work by 20%. EDUCATION

Lewis University [GPA: 3.5/4.0] Chicago, IL

Master of Science, Computer Science Dec 2022

CERTIFICATIONS

Microsoft Certified: Azure Data Engineer Associate W Microsoft Certified: Power BI Data Analyst Associate W PROJECTS

Customer Churn Prediction Integration for BI Reporting 03/2021

• Integrated churn prediction models into Power BI reports, enabling proactive customer retention strategies. Enhanced BI dashboards with predictive insights to aid decision-making for sales and support teams. Conducted data validation and preprocessing on AWS to ensure accurate inputs for machine learning models, increasing data quality by 45%. Real-Time Weather Dashboard with Streamlit and OpenWeather API 08/2023

• Created an interactive weather dashboard using Streamlit, integrating data from the OpenWeather API for real-time updates. Provided forecasts and weather pattern insights, with the option to view detailed maps for multiple cities. Custom LLM Chatbot with LangChain and OCI 04/2024

• Built a GenAI chatbot using LangChain and OCI. Extracted embeddings from PDFs, indexed in Chroma vector database, and applied RAG for information retrieval. Fine-tuned Cohere LLM model on SQuAD, on OCI GPU cluster.

Contact this candidate