Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Timeline
Generic

PRAMUKH MOLUGU

Downingtown

Summary

Results-driven Data Analyst | Business Intelligence Developer | SQL Developer with 8+ years of experience in data analytics, business intelligence, and enterprise reporting across healthcare, metal recycling, and insurance sectors. Proficient in designing and implementing ETL workflows, data pipelines, and reporting systems using SQL, SSIS, Power BI, and Tableau. Skilled in translating complex business requirements into actionable insights through advanced data modeling, visualization, and performance optimization. Adept at working with large datasets, optimizing queries, and improving data processing efficiency in cloud-based environments like Azure and Snowflake. A proactive problem solver with a "go-getter" attitude, excelling in stakeholder engagement, data governance, and process automation. Analytical and insightful Data Analyst known for productivity and efficiency in task completion. Specialize in data visualization, statistical analysis, and predictive modeling. Excel in problem-solving, critical thinking, and communication, ensuring successful project outcomes and team collaboration.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Data Analyst

Skygen USA
Menomonee Falls
01.2022 - Current
  • Developed, scheduled, and generated various reports, including List, Matrix, Drill-Down, Drill-Through, Chart, Cascaded, Multi-value, and Sub Reports, by leveraging SQL Server Reporting Services (SSRS)
  • Built and optimized complex T-SQL queries and stored procedures to integrate business rules into reporting systems using SSRS and Windward
  • Designed and modified SSIS packages using Control Flow Tasks to streamline ETL processes and enhance data integration
  • Resolved and documented reporting issues and modifications using Azure, ensuring compliance with business needs and maintaining detailed Service Desk records for tracking
  • Conducted performance tuning by analyzing Actual and Estimated Execution Plans in SSMS, optimizing queries using Clustered and Non-Clustered Indexes to improve efficiency
  • Created and maintained databases, tables, stored procedures, DDL/DML triggers, views, user-defined data types, and effective functions to support business operations
  • Analyzed internal and external client requests to determine project scope and requirements, ensuring timely and accurate data solutions
  • Ad Hoc Data Extraction & Reporting: Created and delivered ad hoc reports and data extracts using SQL, SSRS, and Power BI to address urgent business requests from stakeholders, ensuring timely insights for decision-making
  • Customized Analytics for Business Units: Conducted ad hoc data analysis on claims, provider performance, and cost containment using SQL and Python, identifying key trends and anomalies to improve operational efficiency
  • Rapid Response to Data Requests: Worked closely with business users and leadership teams to develop quick-turnaround reports for strategic planning, compliance audits, and performance reviews
  • Provided technical assistance and support for new and existing client implementations, troubleshooting data inconsistencies, and refining data validation processes
  • Evaluated and ensured the integrity and quality of incoming and outgoing data sets, maintaining data governance best practices
  • Claims Data Analytics & Fraud Detection: Implemented Python-based data models to analyze healthcare claims data, identifying patterns and anomalies to support fraud detection and provider network optimization
  • Process Automation & Report Generation: Created Python scripts to automate data validation, report generation, and API integrations, streamlining workflows in SSRS, Power BI, and SQL-based reporting systems
  • Conducted peer code reviews and quality assurance checks to validate business requirements, data accuracy, and technical implementations
  • Mentored and provided training to team members, offering guidance on SQL development, SSRS, and data quality management
  • Identified opportunities to leverage data for strategic business improvements, enhancing operational efficiency and performance reporting
  • Tools & Technologies: SQL Server, SSRS, SSIS, T-SQL, Azure, Windward, Service Desk, SSMS, Agile, SDLC, Performance Tuning, Data Governance, ETL, Python, Ad Hoc

Business Intelligence Developer

EMR Metal Recycling
Camden
07.2020 - 12.2021
  • Enterprise-Level Data Warehousing & Reporting: Developed and implemented enterprise-level data warehouse and reporting systems using Azure Cloud Reporting, T-SQL, SSRS, SSIS, Grafana, and Tableau to support proprietary global applications such as Trade II, Ferian, and My Auto Store
  • Designed and optimized ETL pipelines and data movement processes for efficient data integration
  • Mobile Reporting Application Development: Contributed to the development of Xamarin-based mobile reporting applications, ensuring responsive performance and scalability for remote data access across various business functions
  • Designed mobile reporting frameworks that aligned with operational and business requirements
  • Data Troubleshooting & Performance Optimization: Utilized advanced debugging techniques to resolve data inconsistencies, performance bottlenecks, and reporting issues
  • Monitored key performance metrics (DB Writes/Reads, DB Cache, Memory Structures) to assess database health, optimizing SQL and PL/SQL queries for improved efficiency
  • Technical Development Support: Provided ongoing support for existing reporting processes and architectures, ensuring scalability and alignment with business intelligence strategies
  • Utilized SQL replication, SSIS, and Azure Data Factory for streamlined data movement and reporting processes
  • Agile Methodology & DevOps Source Control: Collaborated within an Agile development team, adhering to DevOps-based source control methodologies
  • Recommended and implemented new reporting technologies and frameworks to enhance long-term business intelligence strategies
  • Tableau-Based Geospatial Reporting: Designed and developed interactive Tableau dashboards to visualize key business metrics, including operational performance, financial trends, and inventory tracking across multiple locations
  • Pinpointed key site locations, warehouses, and operational hubs using Tableau's geospatial mapping features
  • Enterprise-Level Data Visualization: Created dynamic Tableau reports integrating data from Azure, SQL Server, and NoSQL databases, transforming raw data into actionable insights for stakeholders
  • Developed custom dashboards with filters, drill-downs, and KPIs to improve decision-making
  • Cloud & NoSQL Data Integration: Integrated Microsoft Azure cloud solutions with unstructured data sources (NoSQL, JSON), ensuring seamless reporting and accessibility
  • Developed solutions for handling unstructured data, enhancing business-wide data analytics capabilities
  • Automated Data Processing & ETL Pipelines: Developed Python scripts to automate data extraction, transformation, and loading (ETL) processes, optimizing data movement between Azure Cloud, SQL Server, and NoSQL databases for improved reporting efficiency
  • Data Analysis & Performance Monitoring: Utilized Python and Pandas to analyze large datasets, detect anomalies, and generate insights for business intelligence dashboards in Tableau and Grafana, enhancing data-driven decision-making
  • Tools & Technologies: Azure Cloud, T-SQL, SSRS, SSIS, Grafana, Tableau, SQL Server, PL/SQL, ETL, Agile, DevOps, Data Factory, NoSQL (JSON), Xamarin, SQL Replication, Python

Data Analyst

Adaequare
02.2014 - 12.2018
  • Company Overview: India
  • Data Development & Integration: Designed, developed, and implemented data workflows using SSIS to automate ETL processes, ensuring efficient data extraction, transformation, and loading
  • Created interactive dashboards and reports in Tableau and Power BI, providing actionable insights for business stakeholders
  • Client & Business Interaction: Engaged with stakeholders to translate business requirements into technical solutions, collaborating across teams to define KPIs, reporting needs, and data governance standards
  • Independent Problem Solving & Execution: Acted as a 'go-getter', proactively identifying areas for data optimization and performance improvements, proposing innovative solutions, and successfully delivering high-impact analytics projects
  • Diagnosed and resolved technical issues to maintain high service levels and data accuracy
  • Continuous Improvement & Learning: Kept up to date with industry trends in data analytics, business intelligence, and cloud technologies, continuously enhancing data processing and reporting capabilities
  • Collaborated with cross-functional teams to optimize workflows, enhance reporting efficiency, and improve business intelligence processes
  • Data Analytics & Performance Optimization: Worked with large datasets, optimizing SQL queries, SSIS packages, and ETL pipelines to ensure scalability and efficiency
  • Developed data models and dashboards to support data-driven decision-making and regulatory compliance efforts
  • Regulatory Compliance & Data Governance: Ensured data governance compliance by validating and cleansing healthcare data, aligning with CMS and Medicaid regulations to support claims analytics, provider performance evaluation, and cost containment strategies
  • India
  • Tools & Technologies: SQL, SSIS, Power BI, Tableau, Python, PySpark, Snowflake, Azure Data Factory (ADF), Alteryx, Data Modeling, ETL, Data Governance, Business Intelligence

Education

Master's - Information System Technologies

Wilmington University
New Castle, DE
05.2020

Bachelor's - Computer Science

Jawaharlal Nehru Technological University
India
02.2014

Skills

  • Technical Tools: SQL, Python, Excel, Microsoft SQL Server Management Studio
  • ETL & BI Tools: SSIS, SSRS, Power BI, Tableau
  • Cloud Platforms: Azure, AWS
  • Business & Data Skills: Business Intelligence, Data Governance, Stakeholder Engagement
  • Core Strengths: Critical Thinking, Attention to Detail, Collaboration Skills

Certification

  • Academy Accreditation - Generative AI Fundamentals, Databricks, 02/25 - 02/27
  • Google Data Analytics Specialization, Google, 2024
  • Agile Foundations, Project Management Institute (PMI), 2024
  • Career Essentials in GitHub Professional Certificate, GitHub, 2024
  • Data Scientist Associate, DataCamp, Valid through 10/26

Projects

SQL Server Performance Optimization for Claims Processing, Developed and optimized T-SQL stored procedures, functions, and views to enhance claims data processing., Reduced query execution time by 40% using indexing strategies, execution plan analysis, and query refactoring., Implemented partitioning and caching techniques to improve database efficiency for high-volume transactions. ETL Pipeline Development for Healthcare Data Integration, Designed and developed SSIS-based ETL workflows to integrate claims, provider, and patient data into SQL Server., Automated data transformations and scheduled SQL Agent Jobs, improving ETL efficiency by 30%., Implemented error handling, logging, and data validation for seamless, high-accuracy processing.

Timeline

Data Analyst

Skygen USA
01.2022 - Current

Business Intelligence Developer

EMR Metal Recycling
07.2020 - 12.2021

Data Analyst

Adaequare
02.2014 - 12.2018

Master's - Information System Technologies

Wilmington University

Bachelor's - Computer Science

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
PRAMUKH MOLUGU