Ravalika

Power BI Developer

ad4s0r@r.postjobfree.com

216-***-****

PROFESSIONAL SUMMARY

•Working as a Microsoft Power Platform Developer having around 9+ years of IT experience with multiple skill set and extensive working experience in data warehousing and Business Intelligence Technologies with expertise in Microsoft Power Platform (Power BI, Power Apps & Power Automate), Tableau, SAP BO for building, deploying and managing applications.

•Expertise in designing, creating, developing, and publishing various dashboards, and reports utilizing various Power BI Visualizations like Dual Axes, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Donut Charts and 100% Stacked-Bar Charts and Geographical Visualizations and more also making use of actions, local and global filters according to the Client requirement.

•Experience in creating Sets, Joins, Bins, Hierarchies, Sorting, Grouping, Legends, Table calculations, Functions, and Parameters.

•Expert in performing Power BI & Tableau data extracts, Data blending, Dashboard actions, and Row-level security.

•Mastered the ability to design and deploy Rich Graphic visualizations with the Drill Down Menu option and Parameterized using Tableau.

•Experience in working with ETL team on Data Migration using SQL, SQL Azure, Azure storage, Azure Data Factory, SSIS and PowerShell.

•in defining the transformation logic in the ELT (Azure Data factory), SSIS and Informatica.

•Hands-On experience in implementing Queries in SQL SERVER including User Defined Functions, Stored Procedures, Customized Aggregate Functions, View, CTE, Index, etc.

•Experienced in migration of data with SSIS (SQL Server Integration Service) as an ETL tool for Data Integration Services and Business Applications. Created several SSIS packages using various data transformations like Conditional Splitting, Derived Column, Fuzzy Lookup, Multi-Column, and Cast Conversion.

•Proficient in leveraging Snowflake and Azure data platforms to deliver actionable insights and drive business decision-making.

•Efficiently performed Data Conversion and Data Migration using SSIS and DTS (Data Transformation Services) across different data sources like SQL Servers, Flat Files, and MS Access.

•Worked extensively on configuring the Report Server, scheduling Report Manager, and giving permissions to different level users in SQL Server Reporting Server (SSRS).

•Strong knowledge in Troubleshooting, Performance tuning of reports, and resolving issues within Tableau.

•Experience with all phases and methodologies of the Software Development Life Cycle including Waterfall, Agile/Scrum, and RUP.

•Proficient in Maintaining, installing, configuring, and administering the Tableau Server in all environments and experience in creating Tableau Mobile dashboards.

•Experience in Tableau administration duties that comprised upgrading Tableau Servers, user & user group creation, managing licenses and data connections, setting up security features, scheduling tasks, and embedding views in Tableau Server

TECHNICAL SKILLS:

Languages

Python, SQL, R, #, T-SQL, XML, HTML, DHTML, C

Database/ Server

MySQL, Teradata, SnowFlake, Oracle, DB2, SQL Server,Azure Data, Oracle SQL, IBM Netezza, PL/SQL Azure SQL DB, Power Apps, Python

Data Warehousing

Warehouse Designer, Transformation Developer

BI Tools

Power BI Desktop, Power BI Services, Power BI On-Premises, Tableau Desktop, Power BI, Power Query Editor, JIRA, Rally, MS Office Suite, SharePoint

Scripting

Python

Analytics /Reporting

SSIS, SSAS, SSRS

OS

Windows, Linux/Unix

MS Technologies

MS Office (Word, Excel, PowerPoint), MS Access, MS Visio, MS SharePoint

Cloud

AWS, Azure

Methodology

Agile Methodologies, Waterfall

PROFESSIONAL EXPERIENCE

Transunion, Austin,TX Jan2022 - Present

Senior Power BI Developer

Responsibilities:

•Worked closely with Business Analysts to understand the requirements and suggested efficient Data visualization techniques.

• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to

visualize reports

•Wrote calculated columns, Measures queries in Power BI Desktop to show good data analysis. techniques.

•Hands on experience on both Load performance tuning and Report performance tuning.

•Conducted impactful client demonstrations, showcasing the capabilities of Power Apps, Power Automate, and Power BI to gather requirements and foster client engagement

•Programmed a utility in Python that used multiple packages (SciPy, NumPy, pandas).

•Expert knowledge of Data verse, SQL, Snowflake, and NoSQL solutions.

•Strong experience in the Power Platform ecosystem (Power BI, Model-Driven Power Apps, Power Automate.

•Build Pivot tables and lookups and do deeper analysis as per the requirement

•Built Dashboards using Power BI, and exported data to create Excel dashboards based on urgent requirements.

•Developed the python Scripts for Automate the Data Dumps

•Worked with the ESM team as Power BI Developer and built dashboards from scratch using existing SAS code and converted the SAS code into SQL queries.

•covid datasets, built visualizations and recommended insights for business using Python, SQL, and Power BI

•Implementing Azure Logic Apps, Azure Functions, Azure Storage, and Service Bus Queues for enterprise-level systems.

•Implemented Azure Storage - Storage accounts, blob storage, and Azure SQL Server

•Designed and built a comprehensive data model and data warehouse in Snowflake, enabling efficient data analysis and reporting.

•Involved in analyzing and reviewing data from various sources like Netezza, Excel, and CSV and performed joins and data blending techniques accordingly.

•Worked with the latest versions of Tableau Desktop and Servers.

•Hands-on experience working with Business Objects and converting existing business object reports into Tableau according to the requirements.

•Performed performance tuning on dashboards that are taking longer to load, used best techniques like going for extracts, tried to use less of quick filters, show fewer marks on the dashboards, and tuned them up.

•Integrated data from diverse sources, including Snowflake, Azure SQL Database, and Azure Data Lake Storage, using Power Query and Azure Data Factory.

Environment: Power BI Desktop, Power BI Services, PowerApps, Power BI On-Premises Gateway, Tableau Desktop, Microsoft Excel, CSV, PL/SQL, MS Office, Snowflake, Slack, JIRA, Power Apps, Azure, Rally, Python, IBM Netezza, Agility Workbench, Oracle SQL

Epicor, TX Oct 2019 – Dec 2021

Power Bi Developer

Responsibilities:

•Gathered and analyzed the business requirements and then translated them to technical specifications and designed documents for development.

•Actively participated in interaction with Users, Team leads, DBA, and Technical Managers to fully understand the requirements of the system.

•Worked extensively using EXCEL to validate the data and use them as the source data files.

•Analyzed the data using statistical features in Tableau to develop Trend Analysis.

•Provided mock-up visuals to speed up the requirement visualizations.

•Hands-on experience in creating and modifying worksheets and data visualization dashboards.

•Created LOD (Level of Detail) expressions data source columns that are computed for each row in the underlying data.

•Created Data Source Level Filter, Context Filter, and Cascading Filters to improve performance and user flexibility.

•Built multifunction readmission reports using python pandas and Django framework.

•Created Side by Sidebars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, and Symbol Maps according to deliverable specifications.

•Used Trend Lines, Log Axes, Groups, Hierarchies, and Sets to create a detail-level summary report and Dashboard using KPIs.

•Validated already developed python reports. Fixed the identified bugs and re-deployed the same.

•Developed and designed Power BI model to create reports and dashboards.

•Expertise in writing complex DAX functions in Power BI and Power Pivot.

•Worked on Power apps to create a new app that uses data from the Power BI.

•Installed and configured Enterprise gateway and Personal Gateway in Power BI Service.

•Created Power BI (Power Pivot/ View) to design multiple scorecards and dashboards to display information required by different departments and Upper-level management.

•Wrote calculated columns, Measures queries in Power BI Desktop to show good data analysis techniques.

•Explored data in a variety of ways and across multiple visualizations using Power BI. Strategic expertise in the design of experiments, data collection, analysis, and visualization.

•Created a summarized report for the team for Manager Level detailed view.

•Created Score Cards, Donut charts, Pie, Funnel, KPI dashboards to show detailed reports.

•Worked on all types of transformations that are available in the Power BI query editor.

•Used various Transformations in SSIS which include Merge files, Conditional Split, Aggregate, Union All, Derived column, Lookup, Fuzzy Lookup, Pivot, and Un-Pivot.

Environment: Power BI Desktop, Tableau Desktop10.0v, Power Apps, Python, MSSQL Server 2017, SQL BI Suite, SQL Server Integration Services (SSIS), Microsoft Excel, PL/SQL, MS Office, Visual Studio 2010

T-Mobile, Frisco, TX Aug 2016 – Sep 2019

Power Bi Developer/ Data Analyst

Responsibilities:

•Worked with Business users to gather requirement specifications for new dashboards.

•Communicating with the users about their requirements, converting the requirements into functional specifications and developing advanced visualizations.

•Worked on Data Cleansing using Power Query in Power BI Desktop Editor.

•Wrote DAX expressions to create new measures, calculations per business requirements.

•Effectively used data blending, filters, actions, and hierarchies feature in Power BI.

•Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.

•Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.

•Strong SQL skills with experience in Snowflake and Azure SQL Database

•Experience with Azure Data Factory, Azure Data Lake Storage, and Azure Synapse Analytics

•Responsible for gathering, analyzing, and documenting business requirements, functional requirements and data specifications to generate the Reports.

•Converted functional requirements into technical specifications and performed required data analysis, data mapping, functional testing, unit testing, and test case preparation using required tools based on project needs.

•Used Power BI to develop data analysis prototype and used Power View and Power Map to visualize reports.

•Expertise in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.

•Analyzed covid datasets, built visualizations and recommended insights for business using Python, SQL, and Power BI

•Used DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.

•Used Pandas, NumPy, seaborn, SciPy, Matplotlib, Scikit-learn, NLTK in Python for developing various machine learning algorithms and utilized machine learning algorithms such as linear regression, multivariate regression, naive Bayes, Random Forests, K-means, & KNN for data analysis.

Environment: Power BI Desktop, Python, Power BI Service, Power BI Data Gateway, DAX, T-SQL, SQL Profiler, MS Excel, MS SQL Server 2018, Snowflake, SSRS, SSIS, Azure, Windows.

CVS Health, CT June 2014 - July 2016

Tableau Developer

Responsibilities:

•Worked directly with Business lines in Customer care, Loans, Management Information Systems, and Card management to gather dashboard requirements for development.

•Extensive experience in reviewing those business requirements and analyzing data sources from Excel/Oracle SQL Server to Design, Develop, test reporting, and analyze projects within Tableau Desktop.

•Created views in Tableau Desktop that were published to the internal team for review and further data analysis and customization using Filters and Actions.

•Created Heat Maps showing current service subscribers by the color that was broken into regions allowing business Users to understand where we have the most users vs. least users.

•Projected and forecasted future growth by developing reports to show in detail.

•Converted charts into Crosstabs for further underlying data analysis in MS Excel.

•Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server, and MS Excel.

•Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

•Combined various workbooks into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

•Reviewed basic SQL Queries and edited inner, left, and right Joins in Tableau Desktop by connecting Live/Dynamic and Static datasets.

•Developed storytelling dashboards in Tableau Desktop and published them on Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on-demand needed information.

•Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

•Tested dashboards to ensure data was matching the business requirements and if there were any changes in underlying data.

•Collaborate with the development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores

•Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: MySQL, Oracle, Essbase, Teradata, SQL Server, Source System Applications and Data Visualization Tableau 8x Desktop and Server, MS Excel

Contact this candidate