Home

Rakesh - Power Bi developer

[email protected]

Location: Charlotte, North Carolina, USA

Relocation:

Visa: GC

Microsoft Power BI certified professional with 8+ years of IT industry experience in Business Intelligence & Analytics, Data Warehousing. Proficient in requirement gathering, Documentation, Data Analysis, testing, client interaction, peer coordination. Played roles of Technical Lead developer, Consultant / Senior Developer. Professional experience of 8+ years with collaborating with stakeholders to gather requirements, design data models which include Microsoft certified PowerBi Data Analyst with 7+ years of hands-on experience with development of Power BI solutions and certified on Business Analytics with Excel . Experienced with different Relational databases like Oracle and SQL Server. Experience in data gathering and analyzing requirements as well as in database management, data analysis, and designing data marts. Proficient in Databricks workspace setup, configuration, and management Exposed to Medicare and Medicaid domains of the healthcare systems and industry for Insurance, inpatient, Membership, Billing, Claims Payment Processing in relation to HIPAA, SOX, EDI. 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, managing relationships, creating different measures, remove rows, replace values, splitting columns, Date & Time Column, etc. Experienced in Healthcare data visualizations and report development with Power BI multi-language support (DAX, Power Query, Power Builder, SQL and Python.) Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets. Experience in complete MSBI Stack including data analysis, database design, data mapping and conversion and data load with SSIS, SSAS and SSRS. In-depth understanding of Databricks DBFS (Databricks File System) for data storage and management. Understanding of Python script, CSS, SQL and other Python script libraries. Basic Knowledge in API (REST/SOAP). Excellent Business writing skills in developing Business Requirements Document (BRD), Use Case Specifications, Systems Requirements Specification (SRS), Workflows, RACI Matrix, Risk Analysis and SDLC methodologies, Project Plan and User stories. 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 Category Tools and Technologies Programming Languages T-SQL, C/C++, SQL, Python, PL/SQL, JavaScript, Visual Basic 6, VBScript, Linux, XML, C#, HTML, .NET, PHP, UNIX shell scripting, CSS, Java, JSP, JIRA Development Tools Visual Studio (2017/2015/2013), SSIS, SSAS, SSRS Business Analyst Skills Process Flow, Use Cases, User Stories, As Is & To Be Process Documentation, Requirements Elicitation, Impact Analysis, Planning Processes, Business Requirement Document, Diagrams, Documentation Database Developer Tools FTP, TOAD, BIDS, SQL Server Profiler, Workbench Databases SQL Server Data Tools, SQL Server Management Studio, MS SQL Server (2017/2016/2014/2012/2008 R2), Oracle (13c/12c/11g/10g/9i/8i), DTS, Database, MS Access, BIDS, SQL Profiler, Performance Monitor Cloud Services Oracle Enterprise Manager Cloud, Microsoft Azure, Amazon Web Services (AWS) Tools Team Foundation Server (TFS), Lucid chart, Visual Studio 2012, Git Reporting Tools Data Analysis Expressions (DAX), Power BI Desktop, ALM, MS Power BI Service, Power Shell, Paginated Reports, Axiom Software, Power BI Service, SSRS, DAX Studio Ticketing Tool ServiceNow EDUCATION: BACHELOR OF TECHNOLOGY (COMPUTER SCIENCE ENGINEERING) - 2014. PROFESSIONAL EXPERIENCE Client: Quotient, Mountain View, CA [Sept 2022 Till Date ] Role: Power Bi Developer (40% Data analysis and Data Modeling, 50% Visualization/reporting, 10% Documentation) Roles and Responsibilities: Coordinated with Stakeholders, Business Analysts for defining the project scope and discuss the PowerBi Solutions. Gather and Imported Daily & Historical data related to Insurance payment files using SQL tool SSMS. Created paginated reports using report builder indicating the Loss Ratio, Policy Retention Rate, Policy Turnover Rate, CLV, CSAT parameters. Examined claim requests status 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 claim processing 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. 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. Designed, developed, and implemented end-to-end data processing pipelines using Databricks, leading to a 30% reduction in processing time and improved data accuracy. 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. Used Service Now ticketing tool for any procurements or any dependencies from the business end. Presented the tickets status along with project development status in Weekly status calls to the stakeholders and managers. Worked in CI/CD ways of working using tools like Azure DevOps. Tools and Technologies used: Microsoft Power BI Desktop, SQL, MS Smart sheet, Azure Boards, Azure Cloud, EXCEL, Power BI Service, Azure DevOps, DAX. Client: Blue Cross Blue Shield. [Nov 2020 Aug 2022] Role: Power Bi Developer. Roles and Responsibilities: The Scope of the project is developing Complex reports using Microsoft Power BI connecting with SAP HANA, Snowflake and creating Paginated reports with Teradata, oracle, MS-SQL as source. Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc. 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, published reports onto SharePoint, and deployed 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 processes to keep others up-to date on project results. Adapt in analyzing bugs, interacting with team members in fixing errors and UAT and assisted in Postproduction support. Managed the Requirements clarification or pending items from business end using the ticketing tool Service Now. Conducted RCA to the missed SLA tickets and present those to management for further communication to clear dependencies. Uses Azure DevOps / Team Foundation Server (TFS) to respond to organizational requests, document, and track progress, and maintain version control of reports and code. Tools and Technologies used: Microsoft SQL Server 2012/2014, visual studio, SSRS, SAP -Hybris, MuleSoft, .Net, GIT, Jira, and Power Bi. Client: Wells Fargo, Charlotte, NC [Sept 2018- Oct 2020] Role: Associate Power Bi Developer. Develop the Dashboards using the data from 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 environments such as star schema and snowflake schema. Proficient in performing data analysis, querying databases, 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 automate 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). Client: MK Technologies, India [Sept 2016- Feb 2018] Project: EMR Audit Role: Power Bi Developer 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, developing the Dashboards, 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: Microsoft Visual Studio 2016, 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), Windows XP, AWS, Mainframe, Kanban.Net, JavaScript, SQL Server 2012, Visual Studio 2012, Angular JS, and HTML 5. Client: Big Buzz Solutions, India [Jan 2016 - Aug 2016] Project: MedAudit Role: Business Analyst Requirements gathering, Analysis, design, coding, and unit testing, UAT. Create and maintain project artifacts related to business requirements. Interacting with clients to understand the business daily. Preparing feasible study documents based on the requirement. visualization and Responsible for conducting scrum events. 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. Created BRD, FRS documents describing the end-to-end requirements for the project. Involved in the design and development of HTML presentation using CSS & XSLT. Create UML diagrams and maintain meeting notes and prototypes. 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: MedCode [Dec 2014 - Dec 2015] Role: Business Analyst Involved in the design and development of Mockup screen presentation. Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs. Supported multiple projects including migration project, Vendor product project and legacy product Project. Successfully resolved ad-hoc assignments on statement imbalances and adjustments quickly and accurately. 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. Worked with the IT risk and regulatory teams to understand the enterprise-wide risk and regulatory reports by working closely with healthcare data providers, report preparers and report owners. Used Agile SCRUM methodology for tracking defects and managing the project. Defined and created Jira project, product backlog, iterations and scrum boards and provide artifact visualization and Responsible for conducting scrum events. 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. Created BRD, FRS documents describing the end-to-end requirements for the project. Involved in the design and development of HTML presentation using CSS & XSLT. Create UML diagrams and maintain meeting notes and prototypes. Develop wireframes using tools and creating application mock-up designs. 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. Keywords: cprogramm cplusplus csharp continuous integration continuous deployment javascript business intelligence active directory information technology microsoft procedural language California North Carolina