PowerBi Data Analyst

Sathish Kumar ● adxix2@r.postjobfree.com

+1-469-***-****

Charlotte, NC

SUMMARY

Senior Business Intelligence Analyst with 11 years of IT industry experience in Business Intelligence & Analytics, Data Warehousing. Successful at responding to shifting business needs and priorities in systematic and effective way. Proficient in requirement gathering, Data Analysis, testing, client interaction, peer coordination and meeting aggressive timelines by innovation.

• Experienced in Data Analysis, Report Generation, Maintenance of Business Report Processes and Data Verifications and Validations.

• Microsoft certified PowerBi Data Analyst.

• Certified on “Business Analytics with Excel”.

• Delivered successful projects on Data Visualization tools like PowerBi, Tableau.

• BI Analyst with experience in data gathering and analyzing the business requirements as well as in database management, data analysis, and designing data marts.

• Professional in managing reports and dashboards using Microsoft Power BI Reporting Tool.

• Experienced in creating Interactive dash boards with the drill-down functionality.

• Experienced with designing and developing row-level security (RLS) for power bi reports.

• Worked on the end-to end project in Azure Environment by pulling the source data from SQL server and storing the data in Azure SQL server Blob storage and creating reports using Power BI Desktop.

• Expert in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, splitting columns, Date & Time Column, etc.

• Experienced in all facets of the Software Development Life Cycle (Analysis, Design, Development, Testing, and maintenance) using Waterfall and Agile methodologies.

• Experienced in data visualizations and report development with Power BI multi-language support (DAX, Power Query, SQL and Python.)

• Understanding of Python script, CSS, SQL and other Python script libraries.

• Experienced with different Relational databases like Oracle and SQL Server.

• Strong Experience in working on MS Access, MS Excel and MS Power Point.

• Basic Knowledge in DB (SQL/Mongo), API (REST/SOAP). Experience with running Complex SQL Queries.

• Worked with SCRUM team in preparation of burndown reports & developing dashboards while working within SharePoint, TFS and RALLY, JIRA control environment.

• Extensive SQL experience in querying, data extraction and data transformations.

• Excellent Business writing skills in developing Business Requirements Document (BRD), Use Case Specifications, Systems Requirements Specification (SRS), Workflows, Project Plan and User stories.

• Worked on development of web and mobile application for processing claims.

• Lead meetings with business and IT users to gather functional and non-functional requirements and map the process flows in Visio, suggesting ways to optimize processes as needed.

• Strong experience in SDLC and STLC processes.

• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, and Agile/Scrum.

• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.

• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.

• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Pro-model, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.

SKILLS

Reporting Tools : Power BI Desktop, Power BI service, Axiom Software Databases : MS SQL Server 2017/ 2016/2014/2012 /2008 R2, Oracle 13c/12c/11g/10g/9i/8i, TOAD 7.5, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio

(BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database. BI Skills : Microsoft Power BI Desktop, Data visualization and modeling, Data warehousing and analytics.

Development Tools : Visual Studio 2017/2015/2013, SSIS, SSAS, SSRS. Programming Languages : Python, R, SQL, Linux, UNIX shell scripting, Java, JSP, HTML, JavaScript, JIRA, T-SQL, PL/SQL, C/C++, XML, HTML, CSS, VisualBasic6, VBScript, Java script, C#, PHP, .NET, VB.NET, ASP.NET.

Cloud Services : Microsoft Azure, Confidential Web Services (AWS) and Oracle Enterprise Manager Cloud.

Business Analyst skills : Business Requirement Document, Documentation, Impact Analysis, Process Flow, Diagrams, Planning Processes, Use Cases, User Stories, Requirements Elicitation, As Is & To Be process documentation. Tools : Visual Studio 2012, TFS, Git, Lucid Chart. Database developer tools : BIDS, SQL server profiler, FTP, Workbench, TOAD. Operating Systems : Windows, MacOS, Unix, Linux (Ubuntu, Red Hat) Methodologies : Agile, Waterfall.

Other Software Tools : MS Office, Visio, Adobe Photoshop, HPALM, JIRA Project Management Tools : JIRA, Asana, Trello, RALLY PROFESSIONAL EXPERIENCE

THRYVE DIGITAL HEALTH LLP

Project: Highmark Health. [Sep 2021 – March 2023]

Role: Data Analyst

(40% Data analysis and Data Modeling, 50% Visualization/reporting, 10% Documentation) Roles and Responsibilities:

• Imported Daily & Historical data related files using SQL based application.

• Expert in configuring, designing, development, implementation and using Axiom software (Financial data) and ETL mappings according to business requirements.

• Examined cash flow and financial statements, generate summary reports, monitor rate changes, develop financial models, and complete forecasting reports.

• Created Power BI visualization of dashboards and scoreboards (KPI) for Finance department.

• Analyzed business requirements, created business/process flow charts, database flowcharts.

• Design and create innovative and valuable visualizations to identify patterns, trends and expectations which enable the business executives and senior leaders to make data driven decisions.

• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision-makers for strategic planning.

• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

• Implemented Role-Based Security as part of security in Power BI.

• Created notifications and alerts, subscriptions to reports in the Power BI service.

• Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards collaborate using workspaces, apps, and get quick insights into datasets.

• Participating in Daily stand-up Agile/Scrum meetings to discuss the enhancements to be made for the existing requirements.

Environment: Axiom Software, SQL, MS Smart sheet, Azure Boards, Azure Cloud, EXCEL, Microsoft Power BI Desktop, Power BI Service, DAX.

Project: Highmark Health - BCBS [Jan 2021 – Aug 2021] Role: Data Analyst

Roles and Responsibilities:

• Analyzed functional requirements gathering from business users and IT teams to understand and express business process and business logic

• Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc.

• Extracted data from data warehouse server by developing complex SQL statements using stored- procedures and common table expressions (CTEs) to support report building

• Interacted with the Stakeholders, Business Users, System Architects, Developers to understand data models and structural data hierarchy.

• Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.

• Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.

• Assisted in creating SQL database maintenance logs and presenting any issues to the database architects.

• Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc.

• Made Power BI reports more interact and activate by using storytelling features such as bookmarks, selection panes, drill through filters, etc.Manage customer relationships and expectations by developing communication process to keep others up-to date on project results.

• Adopt in analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post Production support.

Tools and Technologies used: Microsoft SQL Server 2012/2014, visual studio, SSRS, SAP -Hybris, MuleSoft.

.Net, GIT, Jira and Power Bi.

Unify Technologies Pvt Ltd

Project: FWAE_003 R1 RCD [Feb 2020- Jan 2021]

Client: Optum Global Solutions (UHG)

Role: Data Analyst

Develop the documents using Customer Communication Management tool, where age, category filters and apply Display rules for individual paragraphs.

• Designed and developed SSIS Packages to import and export data from MS Excel, and Flat files to SQL Server.

• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.

• Proficient in performing data analysis, querying data bases, and utilizing SQL query tools.

• Created stored procedures, functions, indexes, views based on data processing and data cleansing.

• Involved in creating DAX and tabular models using SQL Analysis Services (SSAS). Used different types of visualizations (Stacked bar chart, Clustered bar chart, Scattered chart, Pie chart, Donut chart, Line & Clustered column chart, Decomposition tree, Card, Map, Slicer etc.) in Power BI according to the requirements.

• Used Power BI to collaborate with different users and stakeholders to work on live data sources.

• Understand, own and support operational dashboards, business performance dashboards, interpret the results and summarize opportunities for improvement and make recommendations.

• Create reports in Power BI desktop and publish reports to respective workspaces, apps and automated the process to show the latest data.

• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

• Conduct training sessions with business users on Power BI reports and Dashboards.

• Performed user acceptance testing to ensure system integrity before release to production Tools and Technologies used: SQL Server 2012, Visual Studio, SSIS, MS Office 365, Power BI Desktop, DAX, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum). Project: HEDIS RateMax 430- Clinical Claim Process [Aug 2019- Sep 2020] Client: Optum Global Solutions (UHG)

Role: Data Analyst

RateMax 430 Processing Team processes claims basis the determination made by the clinical investigation department after reviewing medical records and also determine whether to reconsider or disapprove the payment of claims. The goal is to communicate the results of the Fraud, Waste, Abuse, and Error audit to the providers.

• Worked with different team's client, analytics, data sources, QA and visualization.

• Worked in agile process having expertise in life cycle of a project from start to end.

• Created data warehouse and data marts from scratch based on data structures and reporting needs.

• Worked on writing ad hoc SQL scripts which are required for reporting purposes. Worked on creating basic dashboards in tableau connected to Azure SQL database for client reporting.

• Worked on user management for power bi. Sharing the dashboard access for power bi online.

• Worked on Power BI dash boards and ad hoc DAX queries for power bi.

• Extensive back end support for many various reports on Tableau and Power BI.

• Created store procedures, functions, triggers, indexes, views based on data processing and data cleansing.

• Created various SSIS packages for data movements and transformations. Worked on Python code to load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query.

• Worked on creating POC for data movement in NiFi (Hortonworks), C# programming used in script task for SSIS and in Azure functions to create retrievers for data pull from API.

• Hands on experience in working with Applications Migration and App Development in AZURE.

• Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.

• Worked on Web Applications in Azure and Azure functions to pull data from API to blob Storage and SQL.

• Worked on deploying web sites in Azure and used MVC framework on backend. Experienced in Developing PL/SQL - Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.

• Extensive knowledge in developing PL/SQL codes using Oracle 11g.

• Create and review SSAS tabular cubes for consuming as a data source for reports, Dashboards, Pivot table.

• Worked on creating multiple databases from scratch.

• Worked on Azure SQL data warehouse and database development. Experienced user of PL/SQL for development of server-end program units as well as reusable codes using Procedures, functions and worked on ad hoc change tickets.

Tools and Technologies used: Microsoft Visual Studio2016, SQL Server, Azure, Power BI, Power Pivot, SAS EG, Teradata SQL assistant, Java, Postman, SQL, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum).

Project: EMR Audit Unify technologies, [Jun 2019- Aug 2019] Client: Optum Global Solutions (UHG)

Role: Data Analyst

EMR Audit is the project to Audit the Medical Records attended by the Associates. It includes validating the fields (Parameters) addressed by the associates and consolidating the user wise day to day reports. Includes refreshing the data, formatting report, printing to pdf, save the file to the desired location, and email to particular DL list. Code and provide an implementation for new enhancements

• Created various SSIS packages for data movements and transformations. Worked on Python code to load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query.

• Worked on creating POC for data movement in NiFi (Hortonworks), C# programming used in script task for SSIS and in Azure functions to create retrievers for data pull from API.

• Hands on experience in working with Applications Migration and App Development in AZURE.

• Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.

• Worked on Web Applications in Azure and Azure functions to pull data from API to blob Storage and SQL.

• Worked on deploying web sites in Azure and used MVC framework on backend. Experienced in Developing PL/SQL - Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.

• Extracted data from data warehouse server by developing complex SQL statements using stored- procedures and common table expressions (CTEs) to support report building

• Interacted with the Stakeholders, Business Users, System Architects, Developers to understand data models and structural data hierarchy.

• Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects. Tools and Technologies used: Windows XP, AWS, Mainframe, Java, SQL, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum), Kanban.Net, UiPath, UiPath Studio, Orchestrator. RAPRA software technologies

Project: Patient Access Management Tool. RAPRA Software technologies, [Mar 2016- Jun 2019]

Role: Business Analyst

The tool is developed and incorporated the new features where the associate will have access to patient’s previous visit details. Analyst will be provided with the Insurance information, to which the patient is subscribed to and looking at the bill details for the treatment, the analyst will be able to give basic payment information to the patient.

1. Requirements gathering, Analysis, design, coding, and unit testing, UAT. 2. Developed C# code for validating the data before giving input to BOT. 3. Interacting with clients to understand the business on a daily basis. 4. Preparing feasible study documents based on the requirement. 5. visualization and Responsible for conducting scrum events 6. Used MS Office suite (Word, Excel, Access, Power Point) for project tracking, documentation, presentation and managing the document in developing a variety of possible test scenarios and cases to ensure that the system being built is resilient.

7. Created BRD, FRS documents describing the end to end requirements for the project. 8. Involved in the design and development of HTML presentation using CSS & XSLT. 9. Create UML diagrams and maintain meeting notes and prototypes. 10. Develop wireframes using tools and creating application mock-up designs 11. Formulated Use Cases for each business requirement and normalized the use cases to suit the requirements.

Tools and Technologies used: Windows XP, AWS, Mainframe, Java, Postman, SQL, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum), Kanban.Net, JavaScript, SQL Server 2012, Visual Studio 2012, Angular JS, HTML 5.

Project: RevAudit RAPRA Software technologies Pvt. Ltd, [May 2014 - Dec 2016]

Role: Business Analyst

RevAudit is an Audit application which runs as an extension to the Medical coding application. RevAudit takes the input from RevCode by applying rules to the input data that is provided to application. It is a Process/ Client independent platform acting as a centralized dashboard and reporting tool. RevAudit was designed as a one-stop-shop for all the Business operations.

1. Requirements gathering, Analysis, design, coding, and unit testing, UAT. 2. Create and maintain project artifacts related to business requirements. 3. Interacting with clients to understand the business on a daily basis. 4. Preparing feasible study documents based on the requirement. 5. visualization and Responsible for conducting scrum events 6. Used MS Office suite (Word, Excel, Access, Power Point) for project tracking, documentation, presentation and managing the document in developing a variety of possible test scenarios and cases to ensure that the system being built is resilient.

7. Created BRD, FRS documents describing the end to end requirements for the project. 8. Involved in the design and development of HTML presentation using CSS & XSLT. 9. Create UML diagrams and maintain meeting notes and prototypes. 10. Develop wireframes using tools and creating application mock-up designs 11. Formulated Use Cases for each business requirement and normalized the use cases to suit the requirements.

Tools and Technologies used: Windows XP, AWS, Mainframe, Java, Postman, SQL, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum), Kanban.Net, JavaScript, SQL Server 2012, Visual Studio 2012, Angular JS, HTML 5, J Query.

Project: RevCode RAPRA Software technologies Pvt. Ltd, [May 2012 - Dec 2014] Role: Business Analyst

RevCode is a medical coding application developed to capture the CPT and ICD codes. It is a Process/ Client independent platform acting as a centralized dashboard and reporting tool. RevCode was designed as a one- stop-shop for all the Business operations. Associates right from the leadership team to entry-level associates to track and conduct their work in compliance with regulations and strategic goals. 1. Involved in the design and development of Mockup screen presentation. 2. Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs. 3. Supported multiple projects including migration project, Vendor product project and legacy product Project

4. Successfully resolved ad-hoc assignments on statement imbalances and adjustments quickly and accurately.

5. Involved in the Workshops with the clients and participated in the discussion for new requirements to be added to the current deliverable product to get the strategic solution and implement it. 6. Worked with the IT risk and regulatory teams to understand the enterprise-wide risk and regulatory reports by working closely with data providers, report preparers and report owners. 7. Used Agile SCRUM methodology for tracking defects and managing the project. 8. Defined and created Jira project, product backlog, iterations and scrum boards and provide artifact visualization and Responsible for conducting scrum events 9. Used MS Office suite (Word, Excel, Access, Power Point) for project tracking, documentation, presentation and managing the document in developing a variety of possible test scenarios and cases to ensure that the system being built is resilient. 10. Created BRD, FRS documents describing the end-to-end requirements for the project. 11. Involved in the design and development of HTML presentation using CSS & XSLT. 12. Create UML diagrams and maintain meeting notes and prototypes. 13. Develop wireframes using tools and creating application mock-up designs 14. Formulated Use Cases for each business requirement and normalized the use cases to suit the requirements.

Tools and Technologies used: Windows XP, AWS, Mainframe, Java, Postman, SQL, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum), Kanban.Net, JavaScript, SQL Server 2012, Visual Studio 2012

ACADEMICS

Bachelor of Technology (Computer Science Engineering), St.Martins Engineering College - JNTUH

60 %

[Oct 2008 - June 2012]

Contact this candidate