Home

Ravi Varma - Power BI Developer

[email protected]

Location: Atlanta, Georgia, USA

Relocation: Yes

Visa: H-1B

Ravi kalidindi Email: [email protected] Phone : 636 312 8820 I am a Senior Software Analyst with 10+ years of experience overall with 9 years as Power BI Developer and 1 year as functional Test Engineer I am a certified PL-300 - Microsoft Power BI Data Analyst and Scrum master as well. Looking for an organization that encourages continuous learning and innovation where I can leverage my skills and knowledge. Expertise in designing, developing, and architecting Business Intelligence solutions across multiple domains, including financial services and e-commerce. Knowledge of ETL-Extraction, transformation loading, Operational Data Stores, Data Marts, and Data Warehouse concepts and methodologies, including star schemas, ETL processes, dimensional modeling, and reporting. Hands-on experience with different versions of SQL Server and Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services A solid understanding of software development life cycle (SDLC), Agile, Scrum, UML, Waterfall, and Project Management methodologies. Developing PBI dashboards for different portfolios, dashboards, and customer-level detailed reports for relational managers, directors, and vice presidents. Explored data in a variety of ways and across multiple visualizations using Power BI Desktop and Service. Experienced in creating multiple kinds of Reports in Power BI and presenting them using Story Points. Extract and analyze data using Power Query, PivotTables, MS Excel, and Power BI Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX) Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models. Well-versed in managing and administrating Power BI Service app workspaces, user roles, publishing apps, and setting data sources on enterprise gateways Experience in creating views, Constraints, Triggers, Joins, User defined functions, Stored Procedures at different stages of data migration/Cleaning process, reports, or Validations. Expert in writing T-SQL Commands (DDL, DML, DCL), User defined data types, and in writing Common Table Expressions. Expert knowledge of architecting and developing Power BI solutions by configuring the data security and assigning the licenses and sharing the reports and dashboards to the different user groups in the organization. Spearheaded the design and implementation of interactive Power BI dashboards tailored for Enterprise Asset Management. These dashboards provided real-time visibility into asset health, maintenance schedules, and performance metrics, resulting in a significant reduction in downtime and improved resource allocation. Developed MDX Scripts to create datasets to perform reporting and included interactive drill-down reports, report models, and dashboard reports. Expert in writing Parameterized Queries for generating Tabular reports, Sub reports using Global variables, Expressions, and Functions, Sorting the data, Dashboard, Scorecards, Drill - down and Drill-through reports, Defining Data sources and Subtotals for the reports using SSRS and integrating them with SharePoint server and native mode. Utilized Power BI's advanced analytical capabilities to create predictive maintenance models. By analyzing historical asset data and predicting potential failures, maintenance teams were empowered to proactively address issues, reducing unplanned downtime by 35%. Implemented key performance indicators (KPIs) and performance scorecards in Power BI to monitor asset performance and track critical metrics like Mean Time Between Failures (MTBF) and Overall Equipment Effectiveness (OEE). These insights facilitated data-driven decision-making for enhancing asset reliability and Professional Summary Professional Synopsis operational efficiency. Developed robust data integration solutions, consolidating data from various sources, such as IoT devices, CMMS systems, and ERP databases, into a unified data model within Power BI. Automation of data refresh and transformation processes streamlined data access and improved reporting efficiency. Scheduled reports for Daily, Weekly, and Monthly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting Services (SSRS) Experience in supporting web-based, mission-critical applications including Logical and Physical Database Design, Development, Performance Tuning, and Change Management Collaborated with cross-functional teams to identify reporting requirements and conducted user training sessions to ensure effective utilization of Power BI dashboards. As a result, stakeholders across the organization gained actionable insights, leading to more informed decision-making processes. Experience in embedding Power BI reports in internal portals and websites. Team builder with strong, analytical & interpersonal skills with good knowledge of Software Development Life Cycle (SDLC) and Proficient in technical writing. Extensive experience in building complex dashboards/reports in Power BI Extensive experience in Waterfall, Agile software development, and SCRUM methodology. Ability to work independently and as part of a team to accomplish critical business objectives as well as good decision-making skills under high-pressure complex scenarios Involved in importing the data from various source systems and creating the rich dashboards using Power BI Good knowledge on Data literacy , used perform different Data literacy activities. Operating Systems : Windows Server 2003,2008 and 2012. Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX Databases : (Oracle, SQL Server (SSIS, SSAS,SSRS), MySQL. Environments : Microsoft Power BI Desktop, Power BI Desktop RS, MS SQL Server 2016/2017/2018/ SQL Server Profiler, Web API, MS Excel, SharePoint, SSMS, On-Premises Data Gateways, Visual Studio. Defect Tracking Tool : ALM, Jira BI Reporting tools (Admin/Dev) : Power BI (Desktop, Service, DAX, Gateway, Reports, Datasets, Data Flows, Data Marts) Data Modeling : Star-Schema, Snow flake schema , Facts and Dimension tables Company: Wells Fargo April 2020-June 2023 Role: Senior Business Execution consultant (Power BI) Responsibilities Designed and develop business intelligence dashboards, analytical reports, and data visualizations using Power BI and providing access to different user groups like sales, operations, and finance team needs. Involved in writing complex DAX functions in Power BI and Power Pivot Involved in pulling data to Power BI from various sources such as SQL Server, Azure, Excel, Oracle, SharePoint, Web services Involved in Configuring and Upgrading the On-Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service. Design and develop Microsoft Power BI reports and Dashboards (Operational, Strategic & Analytical) including data set ingestion and transformation, Data Modelling, Azure data lake store, Azure Analysis service, Azure DW, Azure data factory, Data Analysis Expressions (DAX) using the appropriate report templates depicting the status of key performance indicators (KPIs) and other important business metrics for an organization to make data-driven decisions. Technical Skills Projects Worked Successfully collaborated with multidisciplinary teams to develop and implement interactive Power BI dashboards tailored specifically for Enterprise Asset Management, providing real-time insights into asset performance and maintenance schedules. Creating workspace and content packs for business users to view developed reports. Performed various complex calculations and created custom measures using Data Analysis expression (DAX). Involved in working with Power BI Report Server for Paginated Reports and Using Report Builder Tool. Created Stored procedures and SQL Queries to pull data into the Power pivot Model. Designing and maintaining a Database using Stored procedures, views, User defined functions Setting up Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway. Utilized advanced data integration techniques to consolidate diverse data sources, including IoT devices, CMMS systems, and ERP databases, into a unified data model for effective analysis and reporting within the realm of Enterprise Asset Management. Involved in the complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both environments (Development and Production). Creating Drill down reports, Drill through reports, parameterized report, linked report, and Sub-report for Weekly, Monthly, Quarterly, and yearly Involved in data literacy programme (Operational risks) including the development and monitoring of objectives, key results, and timelines for delivery. Develop library of online courses focused on improving data literacy and develop outreach strategies to ensure key audience are aware and able to access it. Develop materials to explain and promote the Centre s data literacy activities to key audiences. Creating KPI, KRI scorecards for different regions and distribute across the groups. Company: Wells Fargo March 2019- April 2020 Role: Business execution consultant (Power BI) Responsibilities Involved in design and development of multiple Power BI Dashboards and reports Implement row level security on data and application security layer models in Power BI. Set up and ran Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway. Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. Created Dax Queries to generate computed columns in Power BI. Created queries accurately to return the results of that aggregation to Power BI using Direct Query. Provided Data Cleansing for inventory coding, cleaning up databases for the client. Managing data privacy and security in Power BI Extensively involved in designing and developing the power BI Data model using multiple DAX expressions to build calculated columns and calculated measures. Scheduling Automatic refresh and scheduling refresh in power BI service. Worked on different types of transformations available to Power Query editor. Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging. Performed T-SQL tuning and optimizing queries for reports that take longer execution time. Created many calculated columns and measures using DAX in Power BI based on report requirements. Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Leveraged predictive analytics within Power BI to create maintenance optimization models, enabling proactive identification of potential asset failures and significantly reducing unplanned downtime for the organization. Worked on creating Dashboards in Power BI from a live SharePoint list and other data sources, resulted in analyzing, visualizing, reporting, and aggregating data from a dataset in Power BI. Created Calculated measures and calculated columns on power BI desktop for better dashboard creations. Developed tabular queries for efficient analysis of report using pivot/Un-pivot in T-SQL Company: Wells Fargo Jan 2018 Feb 2019 Role: Business execution consultant (Power BI) Responsibilities: Experience on publishing Power BI reports of dashboard in Power BI server and scheduling the dataset to refresh for upcoming data in Power BI server. Experience in Grouping, Creating Hierarchies for Power bi reports using Data Visualizations like bar charts, Line charts, pie charts, cluster columns chart etc. Utilized predictive analytics within Power BI to optimize maintenance strategies, enabling proactive identification of potential asset failures and minimizing unplanned downtime. Working with Power BI Report Server for Paginated Reports and Using Report Builder Tool. Creating Power BI Dashboards with Tiles and Pins from Reports, Insights and Workbooks. Working with Data Gateways for Automated and Manual Data Refresh from on-premise. Created data modelling which include import tables and giving relationship between tables. Expert in Power Query for Advanced Edits, Grouping and Hierarchies. Experience in creating calculated measures and columns with DAX in MS Power BI. Created custom visualizations in Power BI Desktop. Created Rich visualized Pie & Line Charts, Tree Map, Funnel, Scatter Bar Chart and Column Charts, Waterfall Tabular and Matrix Reports Using Power BI. Created filters and apply conditional formatting based on the user requirement. Created dashboards using Power BI which includes drillings, sorts etc. Implementation of Row Level Security By defining various Constraints for each defined role. Company: Wells Fargo Jan 2014 -Jan 2018 Role: Senior Business Administrator (Power BI) Responsibilities: Translate business requirements into specifications that will be used to implement the required. Reports and dashboards, created from potentially multiple data sources using Power BI. Proficiently developed and deployed interactive Power BI dashboards tailored to Enterprise Asset Management, providing real-time visibility into asset health, performance, and maintenance schedules. Designed power BI data visualization using cross tabs, maps, scatters plots, density charts. Adept in developing, publishing, and scheduling Power BI reports as per the business requirements. Worked with IT to test and incorporate new data sources as they become available. Ensured data accuracy by quality checking each analysis prior to publishing. Visualize complex data sets, draw conclusions and relationships, and develop actionable recommendations. Building, publishing customized interactive reports and dashboards, report scheduling using Power BI and Develop Unit testing of the modules. End to End implementation of Power BI Reports and Dashboards including Development, Testing, Deployment and Support Demonstrated expertise in integrating diverse EAM data sources, including IoT devices, CMMS systems, and ERP databases, to create a comprehensive data model for streamlined analysis and reporting. Review and resolve issues that arise in the current reporting, including and not limited to debugging and fixing current and new reports. Add clarity to business requirements, translate functional requirements into technical requirements, develop and test all the backend programs, Data Pipeline development. Meet with Product Owner, Scrum Master, and business users, gather business requirements and prepare documentation for analysis and Data Models. Work on all kind of reports such as Yearly, Quarterly, Monthly, and Daily. Developing visual reports, dashboards and KPI scorecards using Power BI desktop. Implement row level security on data and application security layer models in Power BI Presentation to the business users about the reports and their changes as required. Adept in developing, publishing, and scheduling Power BI reports as per the business requirements. Support ETL and Data Warehouse production, development & test environment. Recommend and develop optimal visualizations for insightful, actionable business use. Design dashboards based on visual analytics best practices and business requirements. Collaborate with business stakeholders to design and iterate insightful dashboards. Driven to provide simple yet optimized solutions to streamline operational reporting and supporting processes. Company: Kstrata IT Solutions Oct 2013 -Jan 2014 Project: E-commerce B2C Client : The Good Guys Domain: E-commerce Environment : Java Role : QA Analyst Tools : Functional , ETL Responsibilities Responsible for creating complete test cases, test plans, test data, and reportingstatus ensuring accurate coverage of requirements and business processes. Analyzing requirements and creating and executing test cases Involved in ETL process testing using Informatica ETL tool. Test Case Execution and Adhoc testing Performed Integration, End-to-End, system testing Involving in Functional Testing & Regression Testing Developing Automated Test Scripts to perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, RegressionTesting and Volume testing of the application using LoadRunner Involving in writing SQL queries and Database Checkpoints to verify data quality andcalculations, reviews Performed data validation testing writing SQL queries. Work on Quality Center for creating and documenting Test Plans and Test Cases and registeringthe expected results. responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes. Analyzing requirements and creating and executing test cases Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results. Working with the Development team for process improvement and release planning Analyzed application data using the SQL to identify the ETL processes. Modifying and creating SQL Queries and stored procedures for quality assurance and analysis. Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements. Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases. Wrote and modified SQL validation scripts and writing scripts in SQL to validate the outputs. Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period. Wrote complex queries to compare the counts and data from source to target. Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing. Performing database testing to verify backend database transactions. Coordinating user acceptance testing activities for business groups and IT. Involving in communication between UAT team members, business leaders, and IT. Participates in application release planning and status sessions. Used Agile testing methodology for achieving deadlines in UAT testing. Working on conversion of manual tests into automated test scripts Created, maintained, and updated regression suites upon receiving new build. Modifying and executing test scripts for web-based environment-using Quality Centre. Creating traceability relationship between requirements in the same module and between different modules. Extensively used Quality Center for documenting, organizing, and tracking requirements. Involving in formulating the test plan, procedures and Wrote test cases. 2011 - Bachelor of Engineering in Electronics and communication from DRK College of Engineeringand Technology I have undergone Core Java, selenium, .Net Training and UFT training at Wells Fargo. Along withtechnical aspects, I was also trained on soft skills One of the Star Performers in the Business Unit in Wells Fargo. I am extremely well recognized with good PI Scores in all the appraisal cycles Received multiple shared success and Excellence award I hereby declare that the above-mentioned information is true to the best of my knowledge. Place: Atlanta (RAVI VARMA KALIDINDI) Education Details Professional achievements and recognition Keywords: quality analyst access management business intelligence database information technology microsoft procedural language