Power Bi Data Analyst

Power BI Developer/Data Analyst

Name: Jagadeesh Mopuru

Email: ******************@*****.***

Mobile: +1-502-***-****

PROFESSIONAL SUMMARY

Over 8+ years of experience in developing and optimizing SQL queries, oracle database Packages, stored procedures, functions, SSIS, SSRS and Power BI Developer with specialized expertise in executive scorecard development and Power Automate workflows.

Extensive experience in healthcare analytics and executive-level KPI dashboard development, with proven ability to transform complex Excel files into automated BI solutions.

Working in the Oracle EBS Applications R12, across the HRMS and Functional Modules such as P2P Cycle with strong focus on healthcare and government sector analytics.

Experience in Full Software Development Life Cycle implementations- requirements gathering, analysis, design, development, testing, and documentation with expertise in phased project approaches and roadmap development.

Expertise in designing and developing Power BI visualizations according to business requirement documents and plans for creating executive Dashboards and comprehensive KPI scorecards.

Strong knowledge on Power BI to import, load, transform and visualize the data from various sources such as SQL Server, Oracle, MS Excel, SQL Server Analysis Services (Tabular Model), and complex Excel workbooks with 15+ worksheets.

Advanced proficiency in Power Automate for workflow automation, Excel integration, and scheduled data refresh processes to achieve quick automation wins.

Hands-on with creating solution driven views and dashboards by developing different chart types with specific focus on executive-level reporting and C-suite analytics.

Built Interactive Power BI dashboards using multiple visuals, slicers, bookmarks, and Drill through functionalities for healthcare KPIs, financial metrics, and operational scorecards.

Skilled in creating measures, calculated columns and performing time series analysis using DAX in Power BI with expertise in healthcare analytics and executive KPI calculations.

Expert in semantic model development and centralized data architecture supporting enterprise-wide KPI reporting and executive scorecards.

Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models with advanced healthcare and financial analytics capabilities.

Responsible for creating Power BI reports and deploying Power BI services with experience in large Excel file transformation and automation.

Experience in 24/7 production and UAT support for monitoring the interfaces and resolving the issues as a priority with proven track record in healthcare environments.

Well Versed with business process flows in 'Procure to Pay' cycle and healthcare operational workflows.

Following agile methodology for the projects, setting up monthly sprints, and daily stand ups to identify roadblocks and measure the progress of the ongoing project with solutions-oriented mindset for complex BI implementations.

Proficient in database performance tuning, data modeling, and automation within the P2P workflow and healthcare data management systems.

Experience in forms customization and personalization using SQL and PL/SQL to enhance Oracle EBS R12 functionalities with healthcare compliance focus.

Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL with optimization for large healthcare datasets.

Skilled in handling large datasets, ensuring data integrity, and delivering scalable solutions with expertise in converting massive Excel files into automated BI systems.

Focused on enhancing business operations through process automation and optimization with proven ability to break down complex projects into actionable roadmaps.

Having good Communication skills, ability to interact with people at different levels and analyzing the situations and presenting the same in team meetings including executive-level presentations and C-suite reporting.

Familiarity with database management, software tools, documentation systems, and monitoring/version control tools with healthcare compliance experience.

Hand on experience with ServiceNow and JIRA for IT service management and Git for version control in healthcare and government environments.

Strong teamwork and multi-tasking skills with an ability to bring perfection in work while working against time constraints with proven success in phased project implementations.

Utilized version control systems such as GitLab, Bitbucket, GitHub, Mercurial and SVN for source code management and team collaboration in healthcare analytics projects.

Proven experience in building and managing reports, dashboards, and datasets using Power BI to support data-driven decision-making and improve business performance with specialized focus on executive scorecards and KPI consolidation.

Experience with various databases including On-premises, Azure Cosmos DB, MongoDB, PostgreSQL, MySQL, MSSQL, Amazon Aurora, Amazon RDS, and Amazon DynamoDB, Redshift supporting diverse application requirements in healthcare and financial sectors.

Knowledge of XML/BI Publisher for report generation and customization using SQL queries to fetch required data with healthcare regulatory compliance expertise.

Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills with experience in creating implementation roadmaps for complex BI projects.

SKILLS AND ABILITIES:

Programming Languages

Oracle SQL, MS SQL Server, T-SQL PL/SQL, C, Shell Scripting, Python, DAX, Power Query

Frameworks OS & Servers

Oracle Apps (Functional) R12, My SQL, I-Procurement, Windows XP/7, Ubuntu (Linux)

Cloud Platform

AWS, Azure, GCP, Oracle cloud

Reporting Tools

Power BI, Power Automate, Power Apps, SQL Server Reporting Services, Crystal Reports, Excel, Executive Scorecards, KPI Dashboards

Data Warehouse/Business

Intelligence Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Management Studio (SSMS), Semantic Model Development

Others

Putty, WINSCP, MobaXterm, ITSM, Service Central, Jira, Procurement forms, SVN, GITHUB, BITBUCKET, GIT, Jenkins, Docker, Spark, Healthcare Compliance Tools

PROFESSIONAL EXPERIENCE:

Client: Galen College of Nursing-Louisville, KY

Role: SQL/POWER BI DEVELOPER

Duration: April 2024 – Till date

Responsibilities:

Worked closely with various teams across the company to identify and solve business challenges with specific focus on executive scorecard development and KPI consolidation.

Led the design and implementation of comprehensive executive dashboard consolidating 50+ KPIs across student enrollment, retention, financial performance, and operational metrics for C-level stakeholders.

Successfully transformed a complex Excel workbook with 15+ worksheets into an automated Power BI solution, reducing manual processing time by 85% and serving as quick automation win.

Import Data from different data sources to create Power BI reports and Dashboards with expertise in handling massive Excel files and complex data structures.

Experience in developing Reports, Charts, Dashboards using Power BI Desktop and managed security based on requirements for executive-level consumption.

Implemented Power Automate workflows to extract data from multiple Excel files, validate data quality, and refresh executive dashboards on scheduled intervals.

Transform, define, navigate the data from data source and perform merge and append queries using Power Query with advanced Excel integration capabilities.

Performed transformations like Pivoting, Unpivoting and Splitting of Columns using Power Query for complex healthcare education metrics including NCLEX pass rates and clinical placement tracking.

Work with Power BI Report Server for paginated reports and using Report Builder Tool for regulatory compliance reporting.

Created measures, calculated columns in Power BI Desktop to show good data analysis techniques with specialized DAX measures for complex healthcare calculations.

Designed and implemented centralized semantic model supporting multiple departments with role-based security and optimized for executive consumption.

Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway for automated data refresh from Excel sources.

Used bookmarks feature which enables the ease to jump to respective report tabs with one click for executive navigation.

Imported custom themes and page backgrounds for rich visual effects tailored for C-suite presentations.

Performed end to end testing on the reports and packages developed to ensure data quality is met with focus on healthcare compliance standards.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources including complex Excel workbooks.

Explore data in a variety of ways and across multiple visualizations using Power BI for executive decision-making and KPI tracking.

Troubleshooting reports issues, ETL job failures, optimizing query performances with expertise in large Excel file processing.

Created many calculated columns and measures using DAX in Power BI based on report requirements for healthcare KPIs and executive scorecards.

Created phased project roadmap for executive scorecard implementation, breaking down complex requirements into manageable deliverables.

Designed and built-up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS with focus on healthcare data integration.

Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements for healthcare analytics.

Environment: MS SQL Server 2016/2014, MS SQL Server Integration Services (SSIS), Power BI Desktop, Power BI Service, Power BI Gateway, Power Automate, DAX, Power Query, Power Pivot, Power View,T SQL, SQL, MS Excel, Windows 8, GIT, Agile, Healthcare Analytics, Executive Scorecards.

Client: AgFirst - Columbia, SC

Role: SQL/PLSQL DEVELOPER

Duration: Aug2022 – April 2024

Responsibilities:

Participated in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation for executive scorecard projects.

Led migration of legacy Excel-based executive reporting to Power BI, creating unified scorecard for C-level executives with comprehensive KPI tracking.

Involved in analysis, design and development of large databases to solve complex business problems with focus on executive-level analytics and automated reporting.

Implemented Power Automate workflows reducing manual report generation from 40 hours/week to 2 hours/week, delivering immediate automation wins.

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs for executive consumption.

Created Queries for generating drill down reports in SSRS for financial performance dashboards tracking loan portfolios and risk metrics.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI with advanced financial analytics capabilities.

Created Power BI dashboard and generated reports using the SQL server tables as source with semantic model supporting 200+ business users across multiple departments.

Successfully integrated data from 8 different source systems into single semantic model supporting enterprise-wide analytics and executive reporting.

Led ETL processes and data migration efforts, utilizing SSIS to efficiently transform raw data into actionable insights for business intelligence reporting. Ensured data integrity and optimized performance during migration for executive dashboards.

Built automated alert system using Power Automate for critical KPI threshold breaches with mobile-optimized executive dashboards.

In-depth knowledge of cloud infrastructure, including Amazon EC2, Azure VMs, AWS RDS, Azure SQL, DynamoDB, MongoDB, security groups, and subnet management.

Optimized AWS services: scaled EC2 instances to handle peak loads, implemented S3 lifecycle policies to lower storage costs, and used RDS read replicas to enhance database performance, supporting increased user concurrency and handling higher peak hour traffic.

Expertise in automation, database CI/CD pipeline management, Devops Practice and cloud infrastructure.

Environment: Power BI, Power Automate, SQL Server, SSIS, SSRS, TSQL, MS PowerPoint, MS Project, Visual Studio, ETL, Excel and Windows, Jenkins, AWS,GITHUB, Executive Analytics, Financial Dashboards.

Company: State of California Sacramento, CA

Role: BI/PLSQL DEVELOPER

Duration: Jan 2019 – Aug 2022

Responsibilities:

Served as a techno-Functional expert on Oracle EBS Suite (P2P)module, developing interfaces and reports, and contributing to system functionality enhancements.

Led SQL and PL/SQL-based data management efforts, developing complex database structures (Procedures, Functions, Packages, Triggers) to optimize system performance and troubleshooting the bugs.

Engaged with cross-functional team and undertook proactive business requirements gathering large data sets.

Enhanced the execution speed and accuracy of intricate SQL queries and effectively managed migration scripts, optimizing data operations.

Familiarity with data pipelines, entity-relationship (ER) diagrams and other modeling/normalization techniques

Ability to identify the value and potential insights that can be derived from both structured and unstructured data sources.

Devised efficient SQL queries to fetch requested data promptly and accurately using SQL performance tuning, directly catering to business users’ data needs.

Extensive knowledge of Power BI and DAX expressions with experience in Jupyter Notebooks.

Developed and modified database schemas and code in alignment with project requirements, ensuring efficient data management and application performance.

Configured Database Scheduled Jobs to automate repetitive tasks and maintenance operations in a database, such as backups, data imports/exports, report generation and email notifications.

Provided 24/7 production and UAT support, monitoring the system for issues and resolving them promptly to minimize downtime.

Worked on REST API’s using PL/SQL.

Handled Oracle SR’s and resolving the issues with Patch application.

Collaborated with teams to optimize SQL scripts, reducing data retrieval times by 30% through indexing and query optimization.

prepared MD070 documents to manage change requests and ensure that customizations aligned with business needs.

Worked as SPOC for Finance Support and was involved in various Sprint Activities and Hypercare activities, ensuring smooth transition and support during deployment

Conducted sanity tests of new implementations or for any change releases; collaborated with cross-functional teams to address issues and optimize procurement processes.

Prepared the training manuals /SOP/ Unique Issue tracker for internal use with detailed explanations considering the business scenarios /Tickets as examples.

Provided critical support during P1 incidents, identifying the root cause and implemented preventive measures, demonstrating strong teamwork and multitasking skills under time constraints.

Acted as a point of contact for performance analysis, scalability issues, and service architecture/database administration.

Environment: Oracle My-SQL Server, Oracle E-business suite R12, SSIS, Power BI Desktop, Power BI Service, DAX, Power Query, SQL, MS Excel, Windows 8, GIT, SVN, Agile, Jenkins

Company: Ally Bank - Sandy, Utah

Role: SQL DEVELOPER

Duration: July 2018 – Jan 2019

Involved in the requirements gathering process and assisted business analysts in understanding the functional specifications and various scenarios of strategic planning and management of solutions delivery for Master Data Management and Customer Data Management, as well as helped manage the SE2 integration competency center.

• Worked with many complex SQL queries with joins, date functions, inline functions, and sub-queries to generate various reports.

• Extensively worked in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, and User-Defined Functions.

• Worked on using all kinds of Constraints, managing Indexes, Locks, troubleshooting deadlocks, and handling the Isolation Levels.

• Create Indexes for tables to have faster retrieval of data and increase optimization to queries.

• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).

• Developed SSIS packages using SSIS Data flow components like Derived Column, Data Conversion, Condition Split, Sort, SCD, Look Up, Merge, Merge Join, Pivot/Unpivot.

• Built SSIS Control Flow packages using Execute SQL Task & For Each Loop Container.

• I got a chance to work with the Finance team, creating files like the General Ledger and files for the soft team for Account Payables Checks and EFTs.

• Developed Tableau visualizations and parameterized reports supporting strategic decision-making across multiple departments

• Executed bi-weekly metrics reports and fulfilled ad hoc analytical requests from Finance and Academic Affairs teams

• Performed technical analysis on large datasets using T-SQL, Python pandas, and R statistical packages

• Built and optimized SSIS packages for ETL processes supporting analytical workflows

• Created drill-down and drill-through Tableau dashboards with advanced filtering and parameter controls and conducted data conversion and validation processes, ensuring data quality for analytical applications

Environment: SQL Server Integration Service (SSIS), SSDT. SQL Server Agent, SQL Server Reporting Service (SSRS), Tableau, Python, R, T-SQL, Windows Task Scheduler

Company: Arkray Healthcare Pvt. Ltd - India

Role: SQL Developer

Duration: May 2014 – June 2018

Responsibilities:

Involved in analysis, design and development of large databases to solve complex business problems in healthcare analytics and medical device reporting.

Developed reporting framework for medical device analytics and patient outcome tracking with focus on healthcare KPIs and operational dashboards.

Design of the Database and the Tables and built table relationships for healthcare data management and regulatory compliance.

Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables with focus on healthcare data integrity and patient information security.

Wrote complex SQL statements using joins, sub queries and correlated sub queries for healthcare analytics and clinical reporting.

Created complex Stored Procedures, Triggers, Functions, Indexes, and Tables, Views and other T- SQL code and SQL Joins for applications supporting healthcare operations.

Created operational dashboards for healthcare providers tracking device performance, patient metrics, and clinical outcomes.

Developed SQL procedures, functions, packages and triggers for building customized code as per the requirement for healthcare compliance and regulatory reporting.

Optimized query performance by creating indexes for large healthcare datasets and patient information systems.

Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files for healthcare regulatory submissions.

Worked with various SSIS packages which involve Transactions, restart ability and roll back techniques for healthcare data processing.

Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse for healthcare analytics.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables for healthcare data integration and patient tracking.

Created simple SQL query filters, prompted filters and complex filters to restrict data in reports for healthcare compliance and patient privacy.

Established data governance processes ensuring regulatory compliance for healthcare data reporting and patient information management.

Created report in SQL Server and deployed them on local host for remote access by healthcare providers and clinical staff.

Responsible for debug, performance checks and performed index tuning and query optimization for healthcare systems requiring 99.9% uptime.

Designed, developed, and deployed custom reports using SQL Server Reporting Services (SSRS), ensuring accurate data representation and user-friendly access to critical business insights for healthcare management.

Collaborated with teams to optimize SQL scripts, reducing data retrieval times by 30% through indexing and query optimization for healthcare applications.

Environment: MS SQL Server, SSRS, SSIS, SSAS, T- SQL, Stored Procedures and Windows, Healthcare Analytics, Medical Device Reporting.

Contact this candidate