Ashish Rajamal Gujar

BSc Statistics

M-+91-905*******

Mail: ad385q@r.postjobfree.com

DOB: 2nd July 1992

Address:*** ****** *****, *******, ********, 390009.

Summary:

Data analyst with 5+ years of experience interpreting and analysing data in order of drive successful business solutions. Proficient knowledge in Statistics, Mathematics and Analytics. Excellent understanding of business operations and analytics tools for effective analysis of data.

Work experience:

Data Analyst in ONGC Petro Additions Ltd. (Pay Roll PSAS. Associate) (Join Feb 2019)

1)Data cleaning and mining using SQL and excel.

2)Update Retail database, items database, Supply chain database and transaction database using SQL queries.

3)Using automated tools to extract data from primary and secondary sources.

4)Using statistical tools to identify, analyse and interpret patterns and trend in complex data sets that could be helpful for the diagnosis and prediction.

5)Built out the data and reporting infrastructure from the ground up using SQL, EXCEL & POWER BI to provide real-time insights into the product.

6)Built a MULTIPLE REGRESSION model to help the production team decide which keyword to target, establishing effective insights on future trends and variables and managing and allocating an effective budget.

7)Using automated tools to extract data from primary and secondary sources.

8)Preparing final analysis reports for the management to understand the data analysis steps, enabling them to take important decisions based on various facts and trends.

Data management executive in M Power Micro Finance Pvt Ltd. (March 2018-Feb 2019)

1)Job profile included data management of loan customers.

2)Checking KYC before sending file for credit appraisal.

3)Submitting documents to system for authorisation and approval.

4)Sharing MIS to concern teams regarding pending issues and maintaining daily data.

Administration executive at Tech Care Solutions, Vadodara. (May 2017-March 2018)

1)Job included to work as administration executive.

2)Daily banking operations.

3)Meeting corporate client, receive payments and depositing in banks.

4)Managing data of customer leads from marketing team.

5)Reporting senior team with providing daily MIS.

Education:

1)B.Sc. (Statistics): KCES’S Mooljee Jaitha College, Jalgaon, North Maharashtra University (6.72/10), Passing year Apr-2014.

2)HSC: ASC College, Chopda Dist. Jalgaon. Nasik Board 50.33. Passing Year Feb-2010.

3)SSC: Z. T. Mahajan Madhyamik Vidyalaya Dhanora. Nasik Board 72.15% Passing Year Mar-2008.

Projects:

1)Transporters Performance Analysis and Freight Rate changes Analysis

Analyse transporters performance trends and identifying issues and opportunities for improvements and analyse Freight rate changes in the system etc using Excel, SAP, Statistical Methods.

2)Volume Forecasting

Develops a model in Excel using regression to estimating future industry and estimate the impact of various marketing tactics on sales in order to forecast and come up with a better marketing strategy to reach incremental lift.

3)Forecasting future trucks requirement.

Developed solution which automatically handling more than 1lac datasets at a time. Used various types of time series models like ARIMA, SARIMA, exponential smoothening with linear and exponential trend and holt’s winter model for forecasting future requirements of trucks volume.

Skills

●Analytical skill: Data Preprocessing, Statistical analysis, Data Mining, Data visualization, Regression analysis, Machine learning, Market mix modelling, Pivot tables, Complex excel formulas & advanced excel, Forecasting.

●Microsoft applications: MS Office (Excel, Word, Power point).

●Computer languages and software: SQL & SAP (TM, MM).

Strength

●Team handling.

● Excellent problem-solving skills.

●Solid numerical skills.

Personal details

●Name: Ashish Rajamal Gujar

● Date of Birth: 02/07/1992

●Hobbies: Playing Chess and Cricket

● Nationality: Indian.

●Marital status: Married

● Languages know: English, Hindi, Marathi and Gujarati (Read, Write, Speak)

Contact this candidate