Power Bi Developer

Srinivasarao Panguluri Sr Power BI Developer

Mail: ***********@*****.*** Contact: +1-832-***-****

PROFESSIONAL SUMMARY

• Results-oriented Senior Power BI Developer with 7+ years of experience delivering enterprise BI solutions across financial services, healthcare, and logistics. Proven ability to transform complex multi-source data (SAP HANA, Salesforce, Snowflake, SQL Server, Azure Data Lake) into insightful dashboards, predictive models, and compliance-ready reports that drive executive decision-making.

• Expert in Power BI (DAX, Power Query, Service, Dataflows, Deployment Pipelines, Gateways, Premium capacity) with deep expertise in data modeling (star & snowflake schema), performance optimization, incremental refresh, hybrid tables, and Fabric OneLake integration. Skilled in requirement gathering, KPI definition, stakeholder workshops, and executive storytelling to enable self-service BI adoption across business units.

• Recognized for implementing end-to-end BI governance (Row-Level Security, Object-Level Security, audit trails, data lineage, metadata management, SOX/HIPAA/GDPR compliance) and CI/CD automation with Azure DevOps and Git. Strong background in Microsoft Azure, Microsoft Fabric, AWS Redshift, and Snowflake, with a track record of delivering audit-ready, scalable, and secure BI platforms that reduce reporting cycles and improve business outcomes. TECHNICAL SKILLS

• BI & Visualization: Power BI (Desktop, Service, Embedded, Dataflows, RLS, Deployment Pipelines, Gateways), Tableau, SSRS, QlikView

• Data Modeling: Star/Snowflake schema, Dimensional Modeling, SSAS, Aggregations, Performance Optimization

• ETL & Data Integration: Azure Data Factory (ADF), SSIS, Informatica, Talend, Alteryx, Databricks, Power Automate

• Cloud & Platforms: Microsoft Azure (Synapse, Analysis Services, Data Lake, Fabric Lakehouse), AWS (Redshift, S3, DynamoDB, QuickSight), Google BigQuery

• Programming & Analytics: DAX, M Query, SQL (T-SQL, PL/SQL), Python (Pandas, NumPy, Scikit-learn), Anomaly Detection, A/B Testing

• Governance & Security: Row-Level Security (RLS), Object-Level Security (OLS), Compliance (SOX, HIPAA, GDPR), Secure Data Access

• Collaboration & Tools: Azure DevOps, Git, JIRA, Agile (Scrum/Kanban), Power Apps, Report Scheduling PROFESSIONAL EXPERIENCE

Client: Fidelity Investments Power BI Developer Remote Feb 2024 to Present Responsibilities:

• Designed and delivered executive-level Power BI dashboards integrating SAP HANA, Salesforce, Snowflake, and Azure Data Lake, providing leadership with real-time insights into loan disbursement, repayment trends, and credit risk exposure.

• Streamlined ETL pipelines with Azure Data Factory and Databricks, reducing manual preparation by 70% and accelerating dashboard delivery by 30%.

• Applied Microsoft Fabric architecture and OneLake integration to unify data ingestion, reduce silos, and deliver trusted end- to-end financial reporting.

• Implemented Power BI Premium capacity management, workspaces, deployment pipelines, dataflows, and gateways for secure and scalable report distribution.

• Built optimized data models using star schema and snowflake methodology, with slowly changing dimensions improving query response times by 40%.

• Applied hybrid tables, incremental refresh, and aggregations, reducing report load times by 35% while enabling near real- time data accuracy for 50+ stakeholders.

• Authored advanced DAX measures including MTD, YTD, rolling averages, dynamic ranking, and what-if analysis to support KPI frameworks and executive decision-making.

• Conducted performance tuning across SQL queries, Power BI models, and DAX expressions, improving dashboard responsiveness and adoption.

• Established CI/CD pipelines using Azure DevOps and Git, enabling governed version-controlled releases across development, test, and production environments.

• Developed automated data validation scripts, DAX unit tests, and reconciliation checks, ensuring reporting accuracy and audit readiness.

• Partnered with cross-functional teams (Finance, Risk, Compliance) under Agile/Scrum methodology, ensuring timely delivery of business-critical analytics.

Client: Reinvestment Fund Org Power BI Developer Atlanta, GA Jan 2023 to Feb 2024 Responsibilities:

• Designed interactive dashboards and reports in Power BI and AWS QuickSight to track investments, loan portfolios, and community development programs.

• Built optimized data models using star and snowflake schema, indexing, and partitioning, reducing query time by 25% for complex financial and compliance reports.

• Integrated diverse data sources including Oracle, PostgreSQL, SQL Server, Redshift, APIs, and flat files to create unified and reliable reporting datasets.

• Developed Power BI dataflows and Power Query transformations to maintain data consistency and reusability across BI platforms.

• Authored advanced DAX measures for performance tracking, grant impact assessment, and compliance reporting aligned with business rules.

• Automated ETL data validation and quality checks, improving accuracy and stakeholder confidence in reporting outputs by 30%.

• Established governance policies including workspace management, role-based RLS, and access control to ensure secure distribution of reports.

• Leveraged AWS S3 and Redshift for scalable data storage and reporting, enabling near real-time reporting through optimized refresh strategies.

• Tuned SQL queries, stored procedures, and views to improve reporting efficiency and reduce manual preparation efforts.

• Collaborated with program managers, analysts, and compliance teams to gather requirements, ensuring dashboards aligned with reinvestment goals.

• Conducted user training sessions, documentation, and ongoing dashboard support, increasing self-service adoption and reducing IT dependency.

Client: UberEATS Data Analyst Hyderabad, India Dec 2020 to Aug 2022 Responsibilities:

• Automated ETL workflows for high-volume order, delivery, and customer data from SQL Server, Snowflake, Azure, and Excel using Python (Pandas, NumPy) and Power Query, boosting data refresh efficiency by 40% and enabling real-time self-service reporting.

• Designed advanced DAX-based KPIs (delivery times, cancellation rates, rider efficiency) in Power BI, driving a 15% improvement in on-time delivery performance across regional markets.

• Conducted A/B testing and predictive modeling on customer behavior (retention, order frequency, promotions), increasing repeat business by 12% and improving marketing ROI.

• Built interactive Power BI dashboards for 500+ restaurant partners, providing insights into order trends, customer satisfaction, and revenue growth, which led to a 20% increase in partner engagement.

• Engineered a predictive surge pricing solution by integrating order history, weather, and traffic data into Power BI, boosting profit margins by 8%.

• Implemented automated dashboard QA and reconciliation checks, reducing manual validation by 30% and ensuring executive reporting accuracy.

• Collaborated with Operations, Marketing, and Supply Chain teams, transforming analytics into actionable recommendations that improved logistics coordination and customer satisfaction. Client: UnitedHealth Group Data Analyst Hyderabad, India Sep 2018 to Dec 2020 Responsibilities:

• End-to-end ETL pipelines using SSIS and Azure Data Factory (ADF) handled over 5 million healthcare records monthly, standardizing data from SFTP, on-premises, and cloud sources into Azure SQL to support near real-time analytics.

• Data pipeline performance improved by 40% by resolving transformation bottlenecks, resulting in faster processing and optimized use of Azure resources.

• Designed HIPAA-compliant Power BI dashboards with advanced DAX, KPIs, and drill-through reports, improving decision- making efficiency by 30%.

• Complex data wrangling, outlier detection, and preprocessing of structured and semi-structured data with Power Query and Python (Pandas, NumPy, Matplotlib) reduced manual data-cleaning effort by 50%.

• Implemented Row-Level and Object-Level Security, data validation, and reconciliation scripts to ensure reporting accuracy and regulatory compliance.

• Collaboration with data engineering and business teams translated requirements into data-driven solutions, increasing reporting accuracy and usability by 25%.

CERTIFICATIONS

• AWS Certified Solutions Architect – Associate

• Microsoft Certified Azure Data Engineer Associate EDUCATION

• Master of Science (M.S.) – Engineering Data Science, University of Houston, Texas, USA.

• Bachelor of Technology (B.Tech.) – Electronics and Computer Engineering, KL University, AP.

Contact this candidate