Power Bi Human Resources

Hema Mushkam

E-Mail: *******.****@*****.*** Contact: +1-640-***-****

Professional Summary:

·Overall 10+ years of experience in IT Industry. I am an expert in setup, scale and stabilizing the Data Analytics and Business Intelligence teams according to requirement across Finance and Human Resources Domains

·Build visualization platforms and be able to generate quick decision-making insights

·Collaborated with Technical teams to build the design and architecture documents and artifacts

·Master's in applied statistics is required educational qualification for performing Analytics solution designing, Descriptive and Predictive analytical solutions.

·Hands on experience of using SAS, SPSS, and Tableau/Power BI, SQL for building analytical solutions to generate insights

·Experienced in working with database technologies like My SQL and PostgreSQL, Azure data factory (ADF), SSIS, SSRS.

·Hands on experience on Tableau versions like 8.3,9,10 and 2018, 2020.4.

·Extracting the data from different data sources with the help of cross database joins.

·Extensively used Calculations, LOD’s, Table Calculations, Date functions.

·Developed Tableau workbooks from multiple data sources using Data Blending.

·Generated Tableau Dashboards by using the Extract filters, Data sources filters, Context filters, Parameters and Calculated fields on Tableau reports.

·Strong problem solving and Analytical skills with high aptitude to adopt new tools and technologies with ease and seamlessly integrate skill set into the project implementation lifecycle

Technical Skills:

·Analytical Tools : BASE SAS, SPSS and Tableau, Power BI

·Office Suite : MS-Excel, Access, Power Point

·Database Tools : My SQL, PostgreSQL

·

Educational Qualifications:

· Master of science from Osmania University, specialized in Statistics

· Graduation in Statistics and Computer Science from Osmania University, Hyderabad

Professional Experience:

IL &FS Technologies company, Aug 2016 – Sep 2023

Lead Analyst

Snapshot:

·Understand the user requirements and convert them into technical specification documents.

·Extensively created dashboards using multiple data sources and data modes

·Developed various types of Tableau/Power BI reports using multiple Data sources and Visualizations.

·Share business insights regularly with the management for actionable insights.

·Developed different types of visualizations reports like bar charts, Trend lines,

·Used Different types of filters, Calculated Measures and columns on Power BI reports.

·Developed complex reports using data modelling concepts.

·Developed user Interactive dashboards with Desktop.

·Implemented Row Level Security (RLS) on user level access.

·Moving reports/Dashboards from Dev to Prod Env and Scheduling the dashboards using power BI Services.

·Worked on parameters with filters, calculated fields, actions, measure-swap, changing views and auto updates.

·Developed dashboards using different charts like Tree Maps, Pie Charts, Bar Graphs, Bubble Charts, Line Charts, Scatter Plots.

·Hands on experience in creating advanced charts like Waterfall chart, Pie chart, Bump chart.

·Published dashboards and reports into services and E mail subscriptions

·Published the Reports generated by the user in Info View for reusability by different users

·Scheduling the Reports in different formats on a Daily, Weekly and Monthly basis.

Delivery Insight Under ITS (power bi transformation):

Role: Application development Analyst Environment

Environment: Power BI, Power Bi Service, Dataflows, SQL, Power app, power automation

·I Evaluated & updated new requirements to existed power bi report and I Created the Dax measure and developed the dashboard.

·Based on the requirement. Cleaning data using power query (Editing data) with POWERBI desktop.

·Applied the buttons for navigating the detailed data and drillthrough, created calculated columns &

·developed model for connecting more table

·Created the Dataflows for schedule refresh for cubes.

·Using power automation to apply the automated refresh for dashboards and using of power apps created the buttons in dashboards for action based on requirement

·Publish the dashboards to UAT & Production services

Technology for operations (Encompass and power bi transformation):

Role: Application development Analyst Environment

Environment: Power BI, Power Bi Service, Encompass, SQL and Reporting Services

·I Evaluated & updated new requirements to existed power bi report and I Created the Dax measure and developed the dashboard.

·Developing, designing, and maintaining technologies that improve the way our clients and the world

·works

·Created multiple reports and dashboards using Power BI and scheduled them in Power

·BI Service

·Created multiple DAX measures and columns for current year vs previous year, Running total

·Implemented multiple shared datasets and reporting workspaces with different object level securities using workspace apps

·Created write back reports and custom landing pages

·Created different types of reports like Table, Matrix and various graphs

In Process Sales Analysis:

Role: BI Developer

Environment: Power BI, DAX, Snowflake

·Communicate with the client to understand the design necessity and limitations.

·Connecting the data from snowflake to Power bi

·The value and quantity Sales Analysis, Reduce the need for manual reporting

·Received – open orders not yet released for processing.

·Released – released to warehouse for processing

·Picked – picked orders, but not shipped

·Shipped – shipped orders, but not invoiced

·To improve the performance of the dashboard Information that took days or weeks to gather now takes

·minutes

The value and quantity Sales Analysis, Reduce the need for manual reporting

·Developing, designing and maintaining technologies that improve the way our clients and the world

The Hackett Group, June 2008 – Aug 2016

Senior Analyst

Snapshot:

·Facilitating the initial planning, and execution & delivery of process benchmarks in end-to-end processes of Sourcing and recruiting, Payroll and Administration, and Other Human resource Process

·Accountable for assisting and supporting senior research directors in setting research hypotheses, carrying out research process that includes analysis and report production, eventually leading to research based advisory services to select clientele

·Identifying opportunities for improving operational efficiencies and identifying the potential business opportunities with the clients through exceptional reporting

·Carrying out analysis for Hackett Group’s trademark book of numbers of research series as well as Hackett’s capability and research models

·Working closely with External and Internal clients to serve data inquiries, advisory inquiries, and benchmarking and research requests

WCAT (World Class Analysis Tool) Analysis:

·This tool is like the heart of company to generate business. This Excel file is fully automated, and macro enabled. We build this tool every year in the process of Annual Benchmark database analysis

·Identify the World Class and Non-World Class companies by calculating efficiency and effectiveness scores of each company participated in the analysis.

Identifying the Key Performance metrics:

·Identify the key performance metrics which contribute in terms of Efficiency and Effectiveness by using correlation technique.

Market Segmentation:

·Identify and cluster the basic characteristics, lifestyle, attitude, and mindsets of persons who are willing to take housing loans using segmentation and cluster analysis. In this project we have identified the clusters using with Hierarchical cluster and Non-Hierarchical cluster methods by grouping the observations.

oCustomer demographic and transactional data collection

oData Preparation/ Data cleansing along with Feature selection.

oHypothesis setup and Exploration of Data for insight generation.

oPreparing the presentation and documentation of the project report for actionable

Identify and Quantifies the Factors –Auto Insurance Industry (Auto insurance):

·This project mainly focuses on Identify and quantifies the factors responsible for losses in multivariate fashion for Auto insurance company. Database contains loss amount and policy related information. In this process we build Multiple Regression Model to identify and quantify the losses for Auto insurance company.

oData extraction from various sources

oPrepare the data (identify the missing values, imputing values like mean for interval variable, mode for categorical variable)

oApply the Data mining models like Multiple Regression and share the insights with stakeholders

Contact this candidate