Data Analyst Power

Certified Tableau Professional/ Power BI Developer

Nik Tiyyagura

937-***-**** **************@*****.***

PROFESSIONAL SUMMARY

Dedicated and highly accomplished Business Intelligence professional with 3+ years of experience.

Excelled in critical and analytical skills, negotiating & completing projects accurately, on time & within budget.

Expertise in creating Dashboards, Scorecards, drill down reports, Standard reports, Views, Pivot tables, Charts for Data analysis using Power BI and Tableau.

Created Dashboards for monitoring, analysis, management and better understanding of the Key Performance Indicators (KPI’s).

Established reports and visualizations by connecting to various data sources (SAP HANA, MS SQL Server, MS Access, Share Point, Excel, CSV).

Insight statistical knowledge with p-value, A/B testing, UAT, hypothesis testing, linear regression and logistic regression.

Experience in extracting data from data sources and transforming it using SQL and R.

Good knowledge in creating SQL objects like tables, indexes, triggers, user defined data types and functions.

Strong knowledge in writing SQL queries, joins, and Nested queries.

Outstanding communication, presentation, problem-solving & relationship-management skills.

Team player with good logical reasoning ability, coordination and able to complete projects independently.

Prowess in generating actionable insights, comprehensive professional skills on solving complex challenges.

.

TECHNICAL EXPERTISE

Power BI, Tableau, Excel, SAP HANA, MS SQL Server, MS Access, SQL, DAX, RDBMS, OLAP, Regression Modeling, Linear Optimization, Python, R, JMP, Minitab, Forecasting, Design of Experiments, Microsoft Visio.

EDUCATION

Master’s degree in Industrial & Human Factors Engineering

Wright State University- Dayton

CERTIFICATION

Tableau Desktop Specialist (Candidate ID: 1011579)

WORK EXPERIENCE

Programmer Analyst/ IT Technical Lead Apr 2019 – Present

ABARTA Coca – Cola Beverages, Pittsburgh, PA

Designed and developed whole end to end reporting process based on CONA requirements.

Organized and led meetings with business stakeholders to clarify and document reporting requirements.

Created calculation views using HANA SQL and GUI from SAP tables and existing views as per reporting needs.

Used custom SQL to import the data into Power BI from SAP HANA views and live connection in Power BI.

Performed data transformation operations in the query editor for data cleansing and other transformations.

Developed reports using the data imported in the local Power BI environment for Finance, Sales, Warehouse, Supply chain, Delivery Execution, Production, and Fleet departments.

Published reports into Power BI premium on CONA tenant and made them available to local business users.

Created and maintained Azure active directory groups for the purpose of maintaining developed workspaces for each department users and admins.

Scheduled reports to refresh on daily, weekly and monthly basis to meet business requirements.

Involved and represented my company in weekly shared bottler BI production support, BI bottler and team meetings along with the other bottlers.

Created new Power BI reports based on existing Analysis for Office reports and performed Ad-HOC reporting on daily basis to meet the business user demands.

Participated in the COSMOS DB and Azure Data Warehouse Proof of Concept processes.

Completed several huge data extracts and performed ETL operations for an internal project.

Business Analyst/ Tableau Developer Jun 2018 – Mar 2019

MeritOne Inc, Detroit, MI

Acted as Single Point of contact for all reporting related requirements.

Excelled in developing data modeling and Business Intelligence reports in Tableau.

Involved in gathering requirements from the client and identify metrics using Excel, Tableau and questionnaires.

Created a single data source that stores information from different marketing channels and developed dashboards in Tableau to continuously monitor revenue streams.

Developed end to end reporting pipeline by establishing standard practices for clean and accurate data collection.

Ensured stable data flow from multiple marketing platforms, which led to easy monitoring of KPI’s.

Identified critical data collection points and made sure that the data is accurate and created SOP(Standard Operating Procedures for data collection).

Drive weekly Operations meeting and provide insights from analyzed data, to drive several KPI’s for business.

Reviewed trends in data sets, used SQL query operations to filter the data to understand the opportunities for clients.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Completed routine database backups to safeguard and secure data.

Data Analyst Jul 2017 – Apr 2018

Dayton- Phoenix Group, Dayton, OH

Provided in-depth analysis that involves compiling and analyzing large data sets using statistical methods and optimization modeling tools and presenting the results in a detailed format using Power BI, that drives management decision making.

Support the manufacturing leadership team in prioritizing & resolving current manufacturing issues.

Implemented advanced statistic methods such as analysis of variance (ANOVA), regression, linear models, variance concepts, and statistical process control (SPC) using JMP and Minitab.

Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions.

Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.

Created new forecasting model that consolidated different markets leading to quicker, more dynamic forecasts and greater efficiencies; Dealt with time series data (decomposition, forecasting).

From analyzing sales and inventory data, decreased warehouse costs by 35% by eliminating dead inventory.

Performed statistical analysis and hypothesis testing.

Created KPI by item to assist in reducing inventory and cutting warehouse costs.

Jr. Data Analyst Dec 2014 – Dec 2015

Sri Ram Techno Solutions, Hyderabad, India

Created/ Updated database objects like tables, views, stored procedures, functions and packages.

Tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update or delete.

Imported SQL server data from multiple data sources into PowerPivot for Excel.

Worked on creating complex dashboards using Tableau.

Implemented Drill through and hyperlinks in Tableau dashboards.

Created and presented impactful Tableau Dashboards and Excel visualizations to team members and clients to improve system efficiencies and reduce total expenses.

Participated in team projects and brainstorming sessions to assess various methodologies for study designs.

Communicated with technical and non-technical end users, providing clear explanation of procedures used and results obtained from data analysis tasks.

Contact this candidate