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