Resume

Sign in

Data Analyst

Location:
Chandler, AZ
Salary:
110000
Posted:
March 29, 2021

Contact this candidate

Resume:

Tableau/Power BI Consultant

Experience Summary

Dedicated IT professional with 8+ years of experience in data analysis, business requirement analysis, quality assurance, design, development, and testing to further the success of various organizations business goals and objectives.

Proven track record to create insights by extracting, analyzing and visualizing data that identify opportunities, recommend changes and define success metrics for the business.

Have ability to understand how users react to changes, build and analyze experiments and help build out the optimal strategy for both short and long term.

Experience in Business Intelligence with strong emphasis in developing reporting solutions using Tableau and Power BI.

Good hands on experience working with ETL tools like Alteryx and SSIS.

Exposure to Incident tracking systems like Jira, Confluence and ALM.

Experience in working with a databases like Oracle, SQL Server, PostgresSQL, and MySQL.

Extensive experience working with End Users, Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.

Involved in the QA and UAT teams to validate the Reports for Data Accuracy.

Trained users in producing documents, running queries and generating reports.

Extensive experience in loading high volume data, worked extensively with data migration, data cleansing and ETL processes.

Involved in performance tuning of reports and resolving issues within database.

Trained Experience working in cross-functional teams.

Good communication skills with demonstrated proficiency in client interactions.

Flair to keep abreast the latest technology and industry moves.

Technical Skills

Reporting Tools

Tableau Desktop 2020/2019/2018,10.x/9.x/8.x, Power BI, SSRS

ETL Tools

Alteryx (certified), SSIS, Tableau Prep

DBMS

Oracle 12c/11g/10g, SQL Server 2008, SAP HANA, Access,

PostgresSQL, MySQL, Azure

Programming Language

Python (certified)

Other Tools

SAP ISU, CRM, BW

Certifications

Certified Alteryx Designer

Certified Associate Python Programming

Education

MBA, Osmania University, India

B.S. Computers, Osmania University, India

Detailed Professional Experience

DTE Energy, Detroit, Michigan

Data Conversion Analyst (Dec 2019 - Till Date)

Project2: Customer Service Performance Center

Environment: Power BI, Oracle 11g, Alteryx, SharePoint, SAP HANA, SAP ECC, Azure

Responsibilities:

Developed Interactive & Operational Power BI Dashboards for enterprise tracking of all the contacts to DTE starting from requesting to closing the loop with feedback/confirmation from the Customer.

Successfully able to initiate special project for low-income customer satisfaction with proof of concept.

Super headed a CRM enhancement project (Call Categorization) to scale down the average handling time (AHT) of the contact center by collaborating with IT Team and higher management.

Assessed the impact of call categorization process enhancement on end users, management and stakeholders, developed a set of metrics like Repeat calls, Same day resolution etc, derived from raw company data to track improvements with the new processes.

Developed complex workflows in alteryx designer to automate ad-hoc requests and data loads on daily basis using scheduler and provide scorecards to the board, directors after analyzing data.

Developed dashboards in Power BI to analyze the Call Volume, analyze the feedback from the customer surveys and trends of call pattern.

Prepared strategic trend reports to measure KPI, Increased leadership focus of the customer Service business Unit.

Performed statistical analysis using python programming.

Created multiple dashboards in Power Bi for the Leadership team to closely understand the changes that improved Contact Center post Go-Live.

Reconciled the data in SAP ECC, SAP CRM and Oracle to see if data is updated and correct.

Good Knowledge in writing complex DAX functions in Power BI and Power Pivot.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Created stored procedures, Views, Indexes, query performance tuning and ETL in troubleshooting issues with dashboard.

DTE Energy, Detroit, Michigan

Data Conversion Analyst (Dec 2018- Dec2019)

Project1: DTE Cares/ ECAC

Environment: Tableau Desktop 2018.1, Power BI, Alteryx, Oracle 11g, MS Access, SAP BW

Responsibilities:

Recreated the existing Tableau reports in Power BI.

Created Power BI Reports to get insights of Customers feedback and the calls that the customers had made to Michigan Public State commission against DTE.

Created +1’s and Defects dashboard for all the Departments to help them understand and work on the feedback that they are getting from the Customer.

Created MPSC Complaints and DTE calls vs. MPSC call YOY, MOM and WOW to understand the trend of Complaints.

Used different features in Power BI like Transpose, Split column by delimiter, Add column, Get Data, Report tab, Data Tab, Relationships.

Used Edit queries to manipulate the source data as per our business requirement by changing the type of Column, Split Column, Group by Column, Deriving month and year from Date columns.

Used the options like Fields, Format for each visualization to set the options of data analytics like Legend, Data colors, Detail labels, Background, Lock Aspect, Border, Title, General, Position, Font, Text size.

Worked on Manage Parameters which are used dynamically for calculation of few metrics.

In the Edit queries used the options Merge Queries, Append Queries, Combine files options.

Used different Visualizations like Donut Chart, Clustered Column Chart, Table (For detailed level data), Slicers, Text boxes, Pie Chart, Waterfall Chart, Filled map etc.

Used the options like Buttons to guide the data for end users like Left Arrow, Right Arrow, Reset etc.

Used the Visual level filters, Page level filters Report level filters

Used the option to drill through the data between the Pages with the filters

Used DAX function (Data Analytics Expressions) like Isblank, Iserror, IsLogical, Weekday, Weeknum etc to meet the business requirements.

Sorted the months based on number instead of default behavior by alphabets.

Worked on Microsoft Power Platform – MS PowerApps, Flow, and Power BI

Initially created the dashboards using desktop version and then published to the workspaces of different businesses in the app.powerbi.com and Microsoft TEAMS

Published the dashboards on the app.powerbi.com workspaces and scheduled the dashboards to refresh the data on a daily basis

Restoration Hardware Inc., Corte Madera, CA

Senior Data Analyst (Mar 2016 – Dec 2018)

Digital Acceleration

Environment: Tableau Desktop 10.4, Power BI, Amazon Redshift, Teradata, SQL Server 2016, Google Analytics, Alteryx, Jira

Responsibilities:

Designed and created data visualizations (reports and dashboards) as required to support user stories

Supported the Digital acceleration team with the understanding of business and data requirements and designed visualizations for initial concepts and prototypes that can be presented to customers for feedback

Partnered with the business to understand and map current and proposed business processes.

Identified and defined technology solutions that will support short and long-term business objectives and strategies.

Analyzed and prioritized business process changes and technical solution enhancements.

Interacted with business users for gathering requirements and look and feel of the applications to be developed.

Used Alteryx for blending data from different data sources.

Defined best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.

Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.

Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.

Supported project execution (ongoing requirements elaboration, design reviews, functional reviews and supporting the application development lifecycle).

Maintained detailed business process requirements and associated documentation. Developed other required documentation, such as process maps/models and meeting minutes.

Worked with the support team for three months according to the service level agreement and resolved the tickets before the deadline.

Performed detailed data analysis (i.e. determined the structure, content, and quality of the data through examination of source systems and data samples)

Defined, executed and interpreted complex/nested SQL queries

Created SQL Procedures, functions and performance tunings for databases efficiency. Also, troubleshooted and investigated data related issues and communicated analytical results through data visualization techniques.

Established standards and best practices for dashboards and related technologies for the project

Managed a repository of reusable data visualization templates and views

Works with Data Architects to understand and identify the source extracts

Ability to understand and interpret the requirements to accurately design the mapping data flow.

Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping &Mapplet Designer and Transformation Designer.

Collaborated with ETL developers, stakeholders and subject-matter experts to establish technical vision and analyzed trade-offs between usability and performance needs

Supported Activities to document, evolve and communicate artifacts developed using Tableau

Worked with Clients to maintain and implement a long term strategy for Tableau

Extensively used RedShift Database and Teradata

Wells Fargo., Hyderabad, India

Data Analyst (Jun 2012 – Jan 2016)

Asset Management

Environment: Tableau Desktop 9.2, SSIS, Teradata 15.1.1, Hadoop (Hive, Hue), SQL Server 2014, Jira 6.3.3, Confluence

Responsibilities:

Developed multiple dashboards, analytical reports, KPIs, and interactive reports based on business requirements using Power BI and Tableau.

Consulted with business partners on business needs, translated business needs into reporting requirements, and interfacing with partners and other teams and ensured successful delivery of client reporting.

Developed visualizations and provided business insights for Asset management team.

Developed reports, dashboards, and metadata layers sourced from information in Teradata, SQL Server, and Hadoop.

Translated requirements and wireframes into working prototypes and fully functional reporting products.

Developed various dashboards, used context filters, sets while dealing with huge volume of data.

Used excel sheet, flat files, CSV files to generate Tableau adhoc reports.

Designed dashboards for actionable, non-actionable complaints from Multidimensional database.

Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison.

Generated Dashboards by joining multiple complex tables.

Performed the Power BI report validation against the databases

Generated dashboard for Finance team, provided security by using user filters.

Created workspace and content packs for business users to view the reports.

Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.

Gathered data from different data sources like MySQL, Excel and Oracle.

Assisted in the development of baseline report & dashboard templates/themes.

Migrated existing legacy reports to newer applications with advanced functionality and validated data accuracy.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Experience in importing/exporting data between different sources like Oracle/Access/Excel etc

Ensured proper source control, documentation (Confluence), testing and quality assurance processes are established, implemented, and followed to maintain strong data integrity.

Supported peers and stakeholders as a Subject Matter Expert (SME) through troubleshooting, analysis of results, and identification of opportunities to solve business problems through BI.

Special Services

Environment: Tableau Desktop 9, Teradata, Oracle, Hadoop(Hive, Hue), SQL Server 2014, Jira, Confluence

Responsibilities:

Gathered Business requirements, translated them to work items and delivered on time, on budget - meeting Business expectations.

Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.

Data blending implemented on different databases and generated interactive dashboards.

Created adhoc reports to users in Tableau by connecting various data sources.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Published Workbooks by creating user filters so that only appropriate teams can view it.

Analyzed the source data and handled efficiently by modifying the data types.

Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

Re-created existing Cognos reports into Tableau Dashboard

Generated context filters and used performance actions while handling huge volume of data.

Generated tableau dashboards for sales with forecast and reference lines.

Generated tableau dashboards with combination charts for clear understanding.

Developed storyboards and dashboards using Tableau 9.

Analyzed backend data from SQL Server and Oracle create effective dashboards.

Created Tableau Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Created Workbooks and Projects, Database Views, Data Sources and Data Connections.

Designed dashboards servicing all business segments of the Special Services.

Applied communication, analytical and problem-solving skills to help maximize the benefit of Special Services system investments.

Prioritized customer issues properly and communicated updates as appropriate. Used good judgment to determine problems that needed escalation.

Worked across organizational boundaries, identified business information needs, and implemented applications that fulfilled them.

Managed multiple issues in a fast-paced environment.

Account Reconciliation:

Environment: Tableau Desktop 8.3, Oracle, Teradata, SQL Server 2012

Responsibilities:

Gathered Business requirements, translated them to work items and delivered on time, on budget - meeting Business expectations.

Designed reports and assisted in the design and implementation of a reporting infrastructure to support the business reporting needs, generated and compiled reports based on findings, completed with probable causes and possible solutions to systems issues.

Created dashboards using Tableau 8.3.

Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.

Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.

Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

Involved in creating and visualizing dashboards using Tableau Desktop.

Generated Tableau combination charts using Tableau visualization software.

Involved in discussing Requirement Clarifications with multiple technical and Business teams.

Created Technical Design Document from the functional specification documents.

Applied communication, analytical and problem-solving skills to help maximize the benefit of Account Reconciliation.

Prioritized customer issues properly and communicated updates as appropriate. Used good judgment to determine problems that needed escalation.

Worked across organizational boundaries and identified business information needs and implemented applications that fulfilled them.

Managed multiple issues in a fast-paced environment.



Contact this candidate