Data Analyst Power Bi

Sushma

Professional Summary:

Over *+ years of Experience worked across various data analysis roles in excel, SQL, and Business Intelligence with focus on Power BI

Experienced in Data wrangling, Data exploratory analysis, Data Profiling, Data governance, and Data validation techniques

Hands-on experience on Power BI Premium, and Power BI Pro covering retail, supply chain, hospitality, consumer services and financial services industries.

Excellent DAX skills with the ability to create and troubleshoot complex calculations and measures

Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices

Developed data visualization using Power BI and Tableau

Knowledge in various reporting objects like Measures, Dimensions, Hierarchies, filters, Calculated fields, Sets, Groups, Parameters etc., in Power BI and Tableau

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines and table calculations

Experienced in designing dashboards, reports development on various databases like Oracle, MS SQL Server, MS Access and Excel

Experienced in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables

data cleaning and analysis with pandas, advanced techniques for cleaning data in Python

Technical Skills:

Reporting Tools:

MS Power BI/Tableau Desktop/Server/Online/Public/10.4

Databases:

SQL Server, Oracle 11g/10g, MS Access

DB Analytical Tools

Toad, SQL Developer, Excel Functions, Pivot, conditional formatting Graphs

Operating Systems:

Windows 10, UNIX, Linux.

Methodologies/Tools:

Agile (Scrum), Waterfall, JIRA, HP QC

Project Experience:

Citi Group, NY Jan 2020- Mar 2023

Data Analyst

Environment: Power BI, SQL Server, Python, Oracle 11g

Description: As part of the overall Customer Complaints Reports Initiative (CRR) goal and its scope for reporting, a new reporting solution needs to be built to support customer complaints reporting needs, In-house ad-hoc reporting, Customized dashboards, and End User Reporting. In addition to this effort, a separate work stream to address root cause analysis and remediation of any issues that are identified on ongoing basis has been initiated.

Roles & Responsibilities:

Identify and document data warehouse objects and respective columns in scope as per requirement by analyzing from Fact tables, dimension tables, and association tables and updating the data fields in data mapping and reporting scope artefacts

Analyze the data through data profiling and sampling by referring and interpreting the attributes of the data using SQL queries and excel filters

Consistent interaction with the stakeholders and business users to understand report requirements based on existing reports/dashboards in source systems and other teams on dependencies, timelines and testing

Collect granular requirements and identify various visualizations using Bars, Lines and Pies, Maps, Scatter plots, waterfall charts, Bubbles, Histograms, Heat maps, Tree Maps and Highlight tables

Worked in various reporting objects like Facts, Attributes, Hierarchies, filters, Calculated fields, Sets, Groups, Parameters etc. using Power BI

Developed reports which show the comparisons of sales vs incentives percentage based on specified duration in the filter like MTD, QTD and YTD

Leading data exploration and analytic projects and providing on-going coaching of data topics (visualization, data mining, analytic techniques)

Developed dashboards and ad-hoc reports using Excel Pivot for senior management team for analysis

Used several functions for generating composite keys, like CONCAT, VLOOKUP, EXACT, Condition formatting, Custom Queries and filters

Utilized capabilities of Power BI such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations

Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections in Power BI

Worked as a liaison between client team, account team and BI development team

Created SQL scripts for testing and validating data on various reports and dashboards

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets

Created variety of interactive marketing visualizations & BI dashboards (statistical, predictive, forecasting, time series, trend analysis)

Ernst & Young, NJ Jun 2019- Oct 2019

DB & Reporting Tester

Environment: Power BI/Tableau Desktop/Server/Public/Online 7/8.x, Oracle 11g, SQL Server 2012

Description: EY/Delivers, internal audit teams reporting solution initiative is a robust, trust worthy reports to showcase various internal metrics, audit/compliance capabilities. Tableau reports are built and categorized into expense audit, compliance tagging of EY employees. This solution is being widely used across EY audit teams to find out employees who violates compliance and audit requirements and subsequently follow up with them for proper resolutions. All these reports provide single-view to EY's audit management on how the compliance/audit issues are being resolved over the period of time. New reporting capabilities helped in eliminating individual team’s maintenance of audit reports vs one view that can be used across the company.

Roles & Responsibilities:

Analyze the In scope area for verification from Data mapping, Archiving & Retention Documents

Analyze column lines, grid information, business rules, archiving validations to be tested

Modify, reuse and execute SQL queries to extract required data from various schema sources and export to excel for data comparison, profiling and validation

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, dimensions, Transformations, filters, prompts, Calculated fields, Sets, Groups, column gird Parameters etc. in Tableau/Power BI

Identify requirements for data visualizations using Tree Maps, Bubble Charts, Pie Charts & parameterized controls to highlight the value-added analytics in executive decision support control

Developed reports which show the comparisons of sales like MTD, QTD and YTD

Worked with developer to provide requirements for report schedules, data connections, projects, groups in Tableau server

Defined best practices for Power BI report development, hands-on development assisting users in creating and modifying worksheets and data visualization dashboards

Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Power BI and excel

PrimEra Medical Technologies January 2015- July 2018

MIS Analyst

Environment: Excel, Zoho Ticketing tool

Roles & Responsibilities:

Provide recommendation to update current MIS to improve reporting efficiency and consistency

Performing data analysis for generating reports.

Provide strong reporting and analytical information support to the management team

Generate both periodic and ad hoc reports as needed

Generate, maintain, consolidate and track ticket breakup records like TAT, Aging and Open Vs Resolved on regular basis

Generate and distribute management report in an accurate and timely manner on End user on Daily, Weekly & Monthly Basis.

Design and develop Summary reports and Dynamic dashboards to meet business requirements.

Experience on Monthly KPI reports which includes data extraction, interaction with process owners and coordination from all India Branches

Runs a list of aging charts (past 4 days of D/C that the coders are working on) to Pathology.

Proficient in multiple monitoring tools preferable manage engine, zoho ticketing tool etc.

Generate and distribute regular management reports in accurate and timely manner.

EDUCATIONAL QUALIFICATION:

Master of Business Administration in Finance, Marketing, HR from Nagarjuna University

Contact this candidate