Rohit Tikle

Data Analyst

Adidas•  January 2019 - June 2019

Discovered the business trends & insights by developing quantifiable metrics on complex datasets with 20M+ rows § Created datasets for the sales & products by extracting data from Salesforce, MicroStrategy & SQL, ORACLE databases § Built & maintained SQL scripts, indexes and complex queries for data analysis leveraging Amazon Redshift and Athena § Developed & tested ETL workflows to integrate new data sources in high data volume data warehouse environments § Achieved 95% customer satisfaction rating by forecasting reports to show KPI’s & identified areas of improvement § Translated data from multiple sources into useful information and created visually impactful dashboards using PowerBI § Reinforced reporting solutions by executing automations of weekly sales reports using pivot, linking and VLOOKUPS § Enhanced the productivity by 42% & saved 400 manual monthly hours by developing web automation model using python

Data Analyst

IBM•  January 2015 - December 2017

Led a 5-member cross functional team to manage BI projects, adhoc reporting & improved process efficiency to 92% § Interviewed business clients to analyze their business needs & translated into technical requirements & solution designs § Performed customer profiling, segmentation, predictive modelling & data mining using R, Python & SAS statistical packages § Developed advanced SQL table joins, group functions, T-SQL stored procedures, set operations & UDF’s for data analysis § Planned & Executed A/B, Multivariate experiments and analyzed reports for product enhancements based on findings § Designed data warehouse to store consumer and products data, created ETL’s to extract data from flat files and excel files § Loaded 10M+ rows of data from flat data files into Microsoft SQL server database tables using bulk copy program utility § Tuned BI & DB queries, created ETL solutions, jobs & processed data in AWS S3, Redshift to calculate business metrics § Own the reporting, design & development, analysis, maintenance of running metrics to drive key business decisions § Implemented OLAP cubes across multiple data marts using OLAP methods in business objects for reporting & automation § Worked independently and Monitored key data issues, ensured data quality & accuracy also optimize data pipelines § Performed customer profiling, segmentation, predictive modelling & data mining using R, Python & SPSS statistical packages § Developed Tableau dashboards by blending & joining complex data sources and presented key insights to live customers § Acted as liaison between clients & organization to ensure the fulfillment of client’s needs and deliverables within deadlines