Data Analyst Tableau

SHIKHAR TANWAR

+1-469-***-**** ***********@*****.***

Business/ Data Analyst with 5+ years of experience in interpreting and analyzing data for driving business solutions. Proficient knowledge in statistics, analytics and related tools. Experienced in business operations, reporting & managing complex data analysis BUSINESS EXPERIENCE

Sprint, Reston, VA Dec 2018 – Present

Business Data Analyst, AEM

Worked with the Sprint Support page, Payment Center, Universal Components, updated homepage and the Sprint App

Responsible for interacting with users to map out high level requirements and scope of the project

Partnered with Sales, Business Intelligence, UI/UX and Product teams to analyze and optimize the content management system

Delivered simple to complex solutions involving design, development, building proof of concepts, developing and executing test cases in preparation development testing

Integrated and migrate the content repository from legacy CMS systems to the current systems and workflows in AEM

Develop and implement databases (DAM’s), data collection systems, data analytics and other strategies that optimize efficiency and quality

Produce automated dashboards, reports, and other assets to monitor applications against targets and KPIs using AEM suite of tools like adobe analytics and adobe target

Flexon Technologies, Pleasanton, CA Jan 2018 – Oct 2018 IT Business Analyst

Increased digital sales by 5% by analyzing web and transactional data and recommending changes to business processes

Integrated Tableau with the different data sources for intuitive visualizations explaining the performance to business owners

Designed KPI dashboards, Parameterized reports using SSRS and Tableau which were used by various stake holders in taking data driven decisions

Identified segments and effectively used it for direct marketing campaigns Qubit Solutions Inc., Dallas, TX Aug 2017 – Feb 2018 Data Analyst

Explored Retail IRI data ranging from POS data, scanner data, customer demographics data to generate insights on brand switching, promotions and market level analysis

Generated insights utilizing data analysis techniques like RFM analysis, panel regression and time series analysis on SAS

Designed ad-hoc reports and dashboards in Tableau for presenting results to the business users

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau Fidelity Investments, Dallas, TX Jan 2017 – August 2017 Data Analytics Capstone Intern (UTD)

Partnered with Business Intelligence and product team to analyze and optimize exception manager system (EMS)

Optimized the performance of EMS processes with the goal of reducing wait time by nearly 50%

Designed dashboards in tableau and predicted the KPI’s for user experience thus providing feasible solutions to the client to improve user experience

Presented & reported the full analysis to the higher management and gave suggestions about server utilization, reducing no. of processes in one submission and implementing an active dashboard

Reviewed and optimized SQL queries to achieve maximum efficiency and scalability Qubit Solutions, Dallas, TX June 2016 – December 2016 Business Analyst Intern

Interacted with users to gather business requirements and analyzed, designed and developed the Data feed and Reporting systems

Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format)

Generated insights on brand switching, promotions & discount effectiveness of different brands of different products

Designed and published dashboards explaining effects of price sensitivity & cross price elasticity on market share of top selling brands

Tazasabzi.com (Now Cibovegg.com), Jaipur, India July 2013 – August 2015 Business Analyst

Performed market research on the customers, labor requirements and demand supply gap to formulate company goals

Examined cost data across various segments using SQL queries & regression analysis resulting in cost optimization by 10%

Modeled an Information System using UML, designed workflow for an e-commerce platform and did requirement analysis

Followed Agile methodology for the project to reduce the chances of failing and to keep doors open for any upcoming big change in the requirements

Analyzed the order trends and implemented a new time slot based delivery of orders using clustering and segmentation for better customer service. This led to reduction of the delivery cost by 30% and better use of manpower

Managed and trained 8 employees on basic MS Excel, customer service policies, handling business operations, quality checks EDUCATION

M.S. - Business Analytics (Dean’s Excellence Scholarship) August 2015 - May 2017 The University of Texas at Dallas GPA: 3.5/4

Coursework: Business Data Warehousing, Business Intelligence, Data Visualization, Prescriptive & Predictive Analytics, Econometrics and Time Series, Spreadsheet Modelling, Marketing Research, System Analysis and Project Management, Business Statistics B.Tech - Electronics and Telecommunication Engineering August 2009 - June 2013 Jaypee University of Information Technology, India GPA: 3.7/4 ACADEMIC PROJECTS

ZIPCAR - System Analysis and Project Management (SDLC) January 2017 - May 2017

Reviewed, researched and analyzed the existing system and identified the causes of information related problem, and designed a new system to mitigate these problems

Performed system analysis and system design for the current and to be (proposed) system

Modeled an information system using Unified Modeling Language (UML) diagrams using Agile methodology KAGGLE - Data Visualization using R/Tableau May 2016 - July 2016

Assembled and merged data files from different sources into a single informative dataset within MS Excel using SQL

Suggested Insights for future player selection through stories, dashboards, visualizations using Tableau motion and R

Manipulated and cleaned data in R and created specific visualizations using “dplyr”, “RSQLite”, “DescTools” TECHNICAL SKILLS

Tools : Python, R, SAS (base & E-miner), SQL (SSIS, SSRS, SSAS), MS Excel, Tableau, Google Analytics Stats Modelling : Logistic & Multiple Regression, ANOVA, Factor & Cluster analysis, Hypothesis Testing CERTIFICATIONS

Python for Data Science: Fundamentals course from Dataquest

SAS-UTD Data mining and Business Intelligence

R Programming (Johns Hopkins University from Coursera) VOLUNTEER EXPERIENCE

Toastmasters International, Sergeant-At-Arms

Rotary International, Secretary

American Red Cross Society, Volunteer

Contact this candidate