Power Bi Business Intelligence

Name- Pavan Kumar Reddy Mudiyala

Contact- 405-***-****

Email- ***************@*****.***

BI Developer

SUMMARY

* ***** ** ********** ** the IT Industry. Expertise in the field of Business Intelligence (BI) Analytics, Reporting & Dashboard development using Power BIand Tableauin developing various reports and Data Visualization.

Experience in gathering Business requirements, Analysis, Design, Implementation, and documentation of various functionalities of Data marts and Business Intelligence.

Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and Processing, writing data extract scripts/programming of data conversion, and researching complex data problems.

Import data from multiple sources like SQL Server, Excel, Oracleinto Power BI.

Experience in creating dashboards, reports, and Ad-Hoc reports through Power BI.

Experience in Developing, Designing and Support interactive POWER BI dashboards.

Hands on Experience in using performance analyzer to evaluate the detailed performance of every visualization component, Measures &DAX expressions to optimize the overall performance of the dashboard in Power BI.

Hands-on experience in writing SQL using RDBMS like Oracle, SQL Server etc.; also good in SQL tuning and Query Performance technique.

Working on MSBI Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App).

Hands on experience in following the SDLC methodologies like Waterfall model and Agile model.

Experience in writing complex SQL Queries involving various tables using SQL joins and writing Sub Queries. Experience in writing complex-SQL Stored Procedures and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity.

Expertise in writing SQL Queries, Dynamic-queries, sub-queries, and complex joins for generating.

Establish Best Practices for Enterprise Tableau Environment and application intake and Development processes.

Extensive understanding of ETL processes for various scenarios.

Tweaking SQL Queries for best performance

Expertise knowledge in Statistics and Analytic data.

Experience in working in an agile environment using JIRA, Rally etc.

Excellence in analytical communication and interpersonal skills and proficient in technical writing and presentation and a good team player.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.

Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.

Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and csv and XML.

SKILLS:

RDBMS/DBMS:

MS SQL Server 2019/2017/2016/2014/2012/2008R2/2008, MySQL, Oracle 13c/12c/11g/10g/9i/8i & MS Access

Database Technologies/Tools:

SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools:

Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop, SQL Server Analysis Services (SSAS), SQL Server Reporting Service (SSRS), SQL Server Reporting Services, Crystal Reports, Tableau, Excel, Pandas, ThoughtSpot BI, ThoughtSpot.

Operating Systems:

Linux, Mac OS X, Microsoft Windows/Advanced Server, MS-DOS

Programming Languages:

T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++, Java, Java script, CSS, Windows Scripts

Design Tools:

Erwin, MS Visio, Rational Rose

Data Warehouse / Business Intelligence Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Snowflake, DBT, Visual Studio 2015/2013/2010/2008, SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012/ Visual Studio Shell.

Cloud Technologies

Microsoft Azure, Amazon Web Services (AWS) & Snowflake

EXPERIENCE:

Client: State Of NY, Albany, NY Dec 2022 - Present

Role: Senior Power BI Developer

Responsibilities:

My responsibilities involved in designing and developing comprehensive Power Bi reports and dashboards that provide valuable insights with a specific focus on debit and credit card transactions.

Conducted performance tuning and optimization of BigQuery queries to enhance report.

Applied Data Exploration techniques across multiple visualizations using Power BI, contributing to a more comprehensive understanding of complex datasets.

Extensively used DAX functions and M Language within the query editor.

Analyzed data using SQL, R, Python, Apache Spark and presented analytical reports to management and technical teams.

Expertise in working with ETL Tools like Informatica, and Alteryx.

Utilized AzureDatabricks for advanced data analytics and integration, enhancing data processing capabilities.

Designed and implemented Alteryx workflows to automate data preparation tasks, improving efficiency and accuracy.

Have a great deal of expertise in creating the best user experience possible by utilizing Bookmarks, Sync Slicers, and Buttons.

Integrated OLAP technology seamlessly into Power BI dashboards for interactive data exploration.

Additionally, my experience includes creating advanced queries in SQL datasets for Power BI and generating Ad-Hoc reports, showcasing my proficiency in managing and transforming data at the SQL level.

This integration results in 20% Reduction in report latency for card transaction data, enhancing the overall user experience.

Extensively used custom R-Visuals, Clustered Bar Charts, Clustered Column charts, Donut Charts,Hierarchy slicers, Waterfall charts, Scatter charts, Area charts, KPIs in power BI reports.

Designed and implemented complex Dimensional Models to support data warehousing solutions, enabling efficient analysis and reporting for business users.

Created interactive dashboards at IDMC to track key performance indicators (KPIs) and trends.

Integrated Power BI with various data sources including SQL Server, Excel, and SharePoint to create comprehensive reporting solutions, replacing OBIEE data connections.

Utilized Dimensional modeling principles (star schema, snowflake schema) to design scalable and robust data marts tailored to business analytics requirements.

Connected Power BI to Azure SQL to create several operation reports that require live updates.

Proficient in adhering to the Software Development Lifecycle (SDLC) process.

Utilized Python for data preprocessing and transformation, enhancing data quality and consistency for Power BI reports.

Designed and optimized data ingestion processes from various sources into Azure Data Lake, ensuring data quality and integrity for Power BI reporting and analysis.

Integrated Snowflake with Power BI, enabling seamless data visualization and real-time analytics.

Utilized Snowflake to design and implement data warehousing solutions, supporting robust data analytics and reporting in Power BI

Strong in Design and develop ETL and Data Quality Mappings to load and transform data from source to DWH (backend connections).

Strong Skills in Data Modelling/Relationships and loading data from multiple data sources.

Publishing Power BI Desktop reports created in Report view to the Power BI service/ Power BI report Server.

Involved in Requirement gathering & designing Power BI applications by using Agile Methodology.

This data workflow contributed to a 15% Reduction in data processing time for card transactions.

Ensured data governance and security by implementing role-based access control in Qlik Sense.

Designed ThoughtSpot Liveboards for financial analytics and transaction reporting, providing real-time insights into debit and credit card transactions.

Integrated ThoughtSpot with Snowflake and Azure SQL to enable fast, scalable, and secure data access for financial data analysis.

Developed AI-driven search experiences, allowing business users to perform ad-hoc analysis without writing SQL queries.

Created custom formulas and SpotIQ insights to detect anomalies, fraud patterns, and spending trends in financial datasets.

Configured row-level security (RLS) and user-based access control to ensure compliance with data governance policies.

Implemented data modeling best practices to optimize performance for large datasets queried through ThoughtSpot.

Assisted business stakeholders in migrating traditional BI reports to ThoughtSpot, reducing manual reporting efforts by 30%.

Provided user training and enablement to enhance adoption of self-service analytics within financial teams.

Environment: Qlik Sense 3.2, Power BI, Tableau, SQL Server, Oracle 11g, MongoDB, Windows 2012 Server, Qlik

Management Console, Qlik Web Connectors, Red Shift.

Client: USAA, Plano, TX May2020–Nov 2022

Role: Power BI Developer

Responsibilities:

Worked on designing and developing insightful Power BI reports and dashboards that provide valuable insights in clinical analysis and operational efficiency.

Performed Storytelling in Power BI after pre-processing Covid-19 datasets to aid the web design team.

Involved in creating My Epic/Radar dashboards. Built reports around Patients, Encounters, Admissions, Discharges, Registration, Verification, Visits, Orders, Diseases.

Demonstrated expertise in Data Modeling, including working with various Epic Clinical and Rev cycle Data Models, ensuring accurate representation of healthcare data for analysis.

Extracted and integrated data from IQVIA sources into Power BI for comprehensive healthcare analytics.

Collaborated with data engineers and analysts to streamline data workflows between Databricks and Power BI, enhancing collaboration and productivity.

Developed custom Python scripts to automate data extraction, cleaning, and loading processes, streamlining ETL workflows.

Collaborated with business stakeholders to translate analytical requirements into efficient Dimensional Models, enhancing data accessibility for data science projects.

Streamlined ETL (Extract, Transform, Load) processes by integrating Alteryx workflows directly into Power BI pipelines.

Developed sales and healthcare analytics dashboards using ThoughtSpot Liveboards and Pinboards, delivering actionable insights into quota attainment, patient admissions, and revenue performance.

Connected ThoughtSpot to Salesforce, Epic Clinical Data, and Azure Data Lake, enabling real-time reporting across multiple data sources.

Designed custom SpotIQ insights to identify sales performance trends, patient care patterns, and operational inefficiencies.

Utilized ThoughtSpot’s natural language search capabilities, empowering non-technical users to generate reports dynamically.

Created ranked and comparative analyses using ThoughtSpot’s advanced search capabilities, helping leadership track top-performing sales reps and distributors.

Optimized query performance and data indexing strategies, reducing dashboard load times by 40%.

Integrated machine learning-driven insights from ThoughtSpot into Power BI reports, improving the depth of data-driven decision-making.

Led ThoughtSpot adoption workshops for executives and analysts, enabling a shift toward a self-service BI culture.

Demonstrated ability to streamline project management processes using Jira and Confluence, enhancing team collaboration and productivity.

Managed and maintained Snowflake schemas, tables, and views to organize and streamline data for Power BI consumption.

Built complex SQL Joins across multiple fact and dimension tables, enabling accurate segmentation and cohort analysis for customer insights.

Developed complex SQL queries for data extraction and transformation, leveraging Dimensional Modeling to provide business insights and streamline analysis processes.

Extensive experience integrating Azure Data Lake with Power BI for scalable data storage and processing, enabling advanced analytics, and reporting capabilities for large datasets.

Collaborated with cross-functional teams to align Snowflake data models with business requirements, driving accurate and actionable insights in Power BI.

Optimized Power BI reports for performance and scalability when connected to No SQL datasets.

Data cleaning, Data wrangling, Manipulation and Visualization. Extract data from relational databases and perform complex data manipulations. Also conducted extensive data checks to ensure data quality.

Utilized Azure SQL Server as a high-performance data source for Power BI, optimizing data retrieval and processing speed while ensuring data security and reliability in the cloud environment.

Built and maintained Dimensional Models in a cloud environment, integrating data from multiple sources for comprehensive analytics using SQL.

Demonstrated ability to adapt to varying SDLC requirements and methodologies.

Designed and optimized Power BI data models to efficiently handle Veeva data, creating relationships, calculated columns, and measures using DAX for enhanced analytical capabilities.

Collaborated with cross-functional teams to identify OLAP requirements and deliver tailored solutions in Power BI.

Transformed raw data into meaningful visualizations to facilitate decision-making processes, transitioning from OBIEE to Power BI.

Integrated Komodo Health data seamlessly with other relevant data sources within Power BI, creating a unified and comprehensive view for decision-makers.

Implemented real-time reporting solutions in Power BI to reflect changes and updates in Komodo Health data, ensuring stakeholders have access to the latest healthcare-related information.

Connected Tableau to EPIC and created Patient data related dashboards for clinical analysis.

Worked in EDI and HIPAA Testing Privacy with multiple transactions exposure such as Inbound 834MembershipEnrolment,837Institutional,837Professional,837Dental,835Claim Payment/Remittance Advise, 270/271 Eligibility Benefit Inquiry/Response, 276/277 Claim Status.

This methodology improved overall data security and reduced potential privacy-related risks by 15%.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Power BI.

Working with team of developers designed, developed, and implemented a BI solution for Sales, Product and Customer KPIs.

I utilized Power BI's native ETL Functionality, automating Data Mapping and Integration. This strategic approach led to a 25% Reduction in migration-related challenges and ensured a smooth transition.

Responsible for creating SQL datasets for Power BI and Ad-Hoc reports.

Involved in creating Parameters, Actions, Local Filter, Global Filter, and calculated sets for preparing dashboards and worksheets using QlikView and Business Objects.

Used Power BI to provide a native ETL functionality so when migrating from QlikView to Power BI, the data is automatically mapped in Power BI.

Environment: Power BI, Qlik Sense, Tableau, SQL Server, Teradata, MongoDB, Windows 2008 Server, Windows 2012 Serve

Client: Charter Communications, St. Louis, MO Jul 2018–Apr 2020

Role: MSBI/Power BI Developer

Responsibilities:

Implementing KPIs in the Main dashboard page for High-Level Business Analysis.

Developing User Interactive reports using various visualization Objects.

Optimized data models and visualizations maximizing Power BI’s Speed of response.

Expertise and proven experience in development of reports, dashboards, aggregating data from multiple sources.

Creating data modeling in Power BI desktop.

Perform Data transformation Using Power Query editor.

Publishing and sharing the reports by creating a content pack in Power BI Service, designing, and developing the application as per the user's requirements.

Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, Databricks, SQL Database and SQL Datawarehouse environment.

Worked on troubleshooting of the entire banking claim, financial processing issues with all the providers.

Worked in Technical Specification and creating and modifying the SSIS packages according to the Business requirements and developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using SQL Server SSIS 2000/2005/2008/12

Developed and maintained SSIS packages to integrate with different types of sources such as SQL Servers, Oracle, flat files, and non-SQL sources.

Worked in creating Stored Procedures, Views, Functions and Triggers in T-SQL for designing and Developing SSIS packages.

Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.

Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012/2008.

Design and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad-Hoc and Sub-reports using Report Designer and Report Builder based on the requirements.

Worked in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements using SSRS.

Creating test data using existing Enrollment and Financial Claims applications (P&C).

Elicited, documented, modelled, validated, and prioritized functional and non-functional requirements using interviews & data analysis for financial, insurance policy lifecycle i.e. right from policy creation to policy renewal.

Developed automated data pipelines from various external data sources (web pages, API etc.) to internal data warehouse (SQL server, AWS), then export to reporting tools by Python.

Environment: QlikView 11.2, Power BI, Tableau, SQL Server, Oracle 11g, Teradata, Red Shift, Operating Systems, Windows 2008 Server, Windows 2012 Serve, QlikView, Publisher, Qlik Management Console, Qlik SAP Connector.

Client: AmerisourceBergen, Chesterbrook, PA Jan 2017–Jun 2018

Role: Power BI Developer

Responsibilities:

Works with planning team to ensure availability of parts to financial customers.

Implemented data partitioning and indexing strategies within Azure Data Lake to optimize query performance and enhance the responsiveness of Power BI reports and visualizations.

Work on any fulfilling other data related needs around other projects in operations projects, Pipeline Reports

Worked in developing, publishing, and scheduling Power BI reports as per the business requirements.

Developing visual reports, dashboards and KPI scorecards using Power BI desktop.

Perform Data transformation Using Power Query editor.

Connecting to heterogenous data sources, importing data, transforming, and integrating data for Power BI.

Gather user requirements and create user stories.

Developed Calculated Columns and Measures using DAX in Power BI to satisfy the business requirements.

Implement row level security on data and understand application security layer models in Power BI.

Producing Ad hoc reports using SQL, JDA, Excel (Pivotal Tables) and MS Access

User Acceptance Tests (UATs) for completed parts of project.

Worked to integrate Power BI reports into other applications using embedded analytics like Power BI service by API automation.

Writing complex SQL queries for checking the counts and for validating the data at field level (Oracle, DB2, Teradata).

Implemented data pipeline using ETL tools and SQL.

Involved in ETL applications, data feeding, cleansing, archiving, and re-modeling.

Environment: Operating Systems: Windows 2008 Server, Data modeling, Microsoft SQL Server, MongoDB, Qlik SAP Connector.

Client: Accenture, India Mar 2015–Dec 2016

Role: SQL BI Developer

Responsibilities:

Performed current state analysis to assist in the definition of new concepts.

Consult with key stakeholders, business data owners, and data stewards to establish data management capabilities, implement and enforce enterprise data standards, and establish effective practices and capabilities for critical data controls in alignment to the EDM policy.

Assist in establishing accountability, data owners and stewards, policies, and standards.

Technical proficiency with MS Office, including Access and Visio

Responded to client inquiries and problems in addition to being able to effectively prioritize issues, tasks and follow-up items while remaining focused.

Generated internal sales leads after inquiring and analyzing clients’ overall portfolios.

Surpassed both Sales and Call Center Key Performance Indicators (KPI) which helped me maintain the President’s Club enrollment for multiple quarters.

Delivered presentations on assisting clients and internal lead generation to various teams.

Trained various teams on using Salesforce CRM.

Worked as Business System Analyst/ Salesforce Admin for all needed Salesforce Configurations

Maintain the cash flow model on a daily and prepared quarterly cash flow forecast and conduct variance analysis.

Produced, analyzed and maintained service and sales Apple reports in excel for a team of 12-15 associates.

Reduced Bank fees by 18% by switching some vendor payments from check to ACH and removing unnecessary bank services.

Managed security portfolio of $2.8 billion which consisted of statutory deposits with several different states. Created and sent monthly reporting on the security portfolio to various departments.

Environment: Power BI, Tableau, Data visualization, ETL, Data Analysis skills, Microsoft Office, PL/SQL.

EDUCATION :

Jawaharlal Nehru Technological University, Hyderabad June 2011 – July 2015

(Bachelors in Information Technology)

Contact this candidate