Data Analyst Sales

ROHIT TIKLE

Boston MA adcgn5@r.postjobfree.com 857-***-**** https://www.linkedin.com/in/rohit-tikle/ SUMMARY

Data enthusiast, passionate about measurements, testing & feature experimentation having 4 years of experience of applying technical & domain knowledge, helped in improving business strategies & in-house strength to get maximum value from data assets EDUCATION

Northeastern University, Boston, MS-Engineering Management Data Analytics (3.63/4.0) May 2020 SGGS college, India B-Tech Electronics & Telecommunications (3.3/4.0) June 2014 SKILLS

Programming: R (tidytext), Python (Numpy, Pandas, Selenium), streamlit ETL Tools: SSIS, SSAS, SSMS, Visual Studio Database Technologies: SQL server, ORACLE, SAP HANA, BR Tools BI Tools: Tableau, Kibana, SSRS, PowerBI ERP: SAP ECC, SAP NW 7.4, SAP S/4 HANA, SAP SD, CRM Atlassian Tools: Jira, Confluence Data Analysis Tools: Rstudio, MS Excel, VBA, ACI Analytics Other Tools: Salesforce DW, CyberSource, OmniHub PROFESSIONAL EXPERIENCE

Adidas AG- Reebok Int Ltd Product Data Analyst Intern Boston Jan 2019- Jun 2019

§ Enhanced the productivity by 42% & saved 400 manual monthly hours by developing web automation model using python

§ Discovered the business trends & insights by performing qualitative analysis on complex datasets with 20M+ rows

§ Optimized inventory, instrumentation and tracking by providing recommendations using in-depth data analysis

§ Created datasets for the sales & consumer products by extracting data from Salesforce, MicroStrategy & SQL databases

§ Collaborated with ETL developers to develop effective data models & also design analytical, attribute and calculated views

§ Achieved 95% customer satisfaction rating by forecasting weekly product KPI’s in PowerBI & sustained operation efficiency

§ Developed product roadmaps with product teams, collected data to measure testing and measurement product features

§ Reinforced reporting solutions by executing automations of weekly sales reports using pivot, linking and VLOOKUPS

§ Managed end-to-end process for updating and verifying orders data extracted from Salesforce Demandware application IBM Data Analyst India Jan 2015- Dec 2017

§ Led a 5-member cross functional team to manage special projects, adhoc reporting & improved process efficiency to 92%

§ Gathered and analyzed requirements by conducting a contextual inquiry with technical team using agile practices

§ Built & maintained SQL scripts, indexes and complex queries for data analysis, wrangling, data cleaning and extraction

§ Developed advanced SQL table joins, group functions, T-SQL stored procedures, set operations & UDF’s for data analysis

§ Designed data warehouse to store consumer and products data, created ETL’s to extract data from flat files and excel files.

§ Loaded 4M+ rows of data from flat data files into SQL server database tables using bulk copy program utility

§ Created stored procedures, ad-hoc reports & data input interfaces using SQL server 2016

§ Developed Tableau dashboards to support conclusions based on analytical evidences leveraging inferential statistics

§ Monitored & analyzed data reports, worked on RCA & troubleshooting issues that arise using prescriptive analytics

§ Worked independently with partners to identify problems, key data issues & developed solutions using testing methods, data mining, optimization, predictive modelling & machine learning as well as owned data quality

§ Acted as liaison between clients & organization to ensure the fulfillment of client’s needs and deliverables within deadlines PROJECTS

Attribution modelling for Bidding dataset- Criteo (streamlit, Snowflake) Jan 2020- April 2020

§ Wrangled the data in trifacta and pandas, analyzed their pricing, promotions and recommendations strategies

§ Built LTA & Logistic regression models and simulated ROI and provided recommendations to choose best model

§ Developed Einstein analytics dashboards to show effect of Adstock models on spending’s Data warehouse & BI design for Amazon products (SSIS, BW) Sep 2019- Dec 2019

§ Designed a multidimensional STAR SCHEMA data warehouse by integrating data from multiple sources using BCP & SSIS

§ Created ETL workflows & mappings in SSIS to load 6M+ rows of data from SQL staging to SQL server data warehouse

§ Presented reports using SSRS and Tableau to show consumer reviews, most selling products and goods Database design for Inventory management system (SQL, Oracle) Jan 2019 - Apr 2019

§ Created a Relational - Database to store inventory data & to track the inventory levels, orders, sales & deliveries

§ Implemented Joins, SQL queries, Stored Procedures, Triggers and optimized SQL query response time by 15% National MS Society Fundraising Activities (Numpy, SciPy, matplotlib) Sep 2018- Dec 2018

§ Measured the power of variables for fundraising by using the Naïve Bayes and clustering techniques in Python

§ Attenuated risk of overfitting by reducing degrees of freedom for dimension reduction using Principal Component Analysis Statistical Data Analysis of employee attrition (Tableau) Jan 2018 – Apr 2018

§ Designed visualizations through dynamic Tableau dashboards using level of detail calculations and filter

§ Identified the factors that lead to attrition, a comparison made between the employees who lost in attrition & employees who stay in the company and were evaluated on skills, hike in the salary, years of experience

Contact this candidate