Post Job Free

Resume

Sign in

Data Analyst Sales

Location:
Los Angeles, CA
Posted:
January 01, 2021

Contact this candidate

Resume:

Dhanesh Shirodkar +1-469-***-****; adi2xb@r.postjobfree.com

https://www.linkedin.com/in/dhaneshshirodkar

SUMMARY

Versatile and efficient Business Data Analyst with 5+ years of experience in business intelligence and data visualization

Adept at researching and developing strategies for a wide variety of products and clients and work flow analysis

Diversified skills include client relations, project management and inclination to learn different foreign languages

TECHNICAL SKILLS

Programming: MS SQL, R, Python, C++

Data Visualization Tools: PowerBI, Tableau, Microstrategy, Qlikview

ETL Tools: SSIS

BUSINESS EXPERIENCE

Brillio LLC., Los Angeles, US February 2020- Present

Senior Business Analyst, Sempra (SoCalGas Company)

Led Customer Analytics team to analyze gas consumption data across time to make data driven recommendations

Collaborated with SMEs to prepare technical documents such as Solution Architecture and Detailed Design Document

Closely assisted Customer Analytics team to gather requirements and build Tableau dashboard on gas bookings data

Performed data integrity and quality checks by running SQL queries in production and development environments

Senior Business Analyst, Hewlett-Packard (Aruba) March 2019- February 2020

Minimized operational reporting effort by 45% by consolidating reports from multiple sales teams into single dashboard

Delivered education sessions regarding Sales Pipeline dashboard to regional sales teams in NA, LATAM, APJ and EMEA

Built quarterly insights deck for Executive team highlighting product performance based on discounting and bookings data

Conceptualized PowerBI dashboard highlighting sales pipeline and KPIs at regional, product and market segment level

UnitedHealth Group, Austin, US

Business Analyst, Crimson Continuum of Care September 2018- March 2019

Led product life cycle and developed SDLC artifacts while redeploying clients in new standardized staging environment

Owned Technical Health Index functionality that identified data load issues and improved client satisfaction score by 30%

Interpreted data from multiple sources and partnered with product team to improve product value and optimize usage

Conducted interactive session emphasizing neglected mistakes and best practices of data visualization using Microstrategy

Mu Sigma, Inc., Bellevue, US

Business Data Analyst, Microsoft April 2018- June 2018

Worked closely with technical teams to leverage data from delivery systems so as to accelerate monetization on MSN.com

Designed dashboards using Power BI for different Microsoft publisher platforms highlighting trends in advertiser’s KPIs

Integrated and validated data from various sources to generate report on monthly payout given to MSN content partners

Business Data Analyst, T-Mobile June 2017 – March 2018

Analyzed customer journey model to improvise efficiency of digital environment for T-Mobile consumers by 21%

Sourced data from Redshift to build Tableau dashboard on T-Mobile’s performance during iPhone 8/X launch

Generated periodic executive reports to track quarterly goals and ensure compliance with digital market strategy

Drove delivery of time series forecasting model (ARIMA) using Python to forecast bookings based on historical data

VizSense, Inc., Plano, US

Business Intelligence Analyst Intern June 2016 – May 2017

Evaluated in-company data visualization tool and suggested improvisations thereby increasing operational efficacy

Executed text and sentiment analytics on available Twitter data to suggest strategic recommendations for client’s brand

Forecasted product performance using analytical tools and designed marketing tradecraft that met client’s expectations

Larsen & Toubro Infotech, Mumbai, India

Senior Business Analyst (Team Lead), Larsen & Toubro Corporate IT January 2011 – July 2015

Optimized critical application SQL database performance by 25%, automating fine tuning and indexing on fortnightly basis

Visualized business data using Tableau and MS Excel features to increase efficiency in testing the business logic

Performed impact analysis for new requirement and practiced change management achieving 20% growth in productivity

EDUCATION

The University of Texas at Dallas - M.S., Management Information Systems GPA 3.69 May 2017

University of Mumbai - B.E., Electronics & Telecommunications GPA 3.6 May 2010



Contact this candidate