Ayush Sharma Email & Phone Number

Gurugram, Haryana, India

Currently working as Senior Analyst in FP&A where my current responsibilities includes :1. Developed a Metric to identify possible Clients Churns at an Overall Gartner level. This was an end to end product which started from collection of data to the final output view in Power BI.2. Working on Research engagement data and deriving patterns to identify the Churns and strategizing with the product and Sales teams to boost the engagements.3. Helped the team to automate the overall Gartner P&L's. This included working as a consultant for the Finance team and building an ETL process to migrate the data from Hyperion and EBS finance systems to SQL in encrypted format. Further leveraged the data to showcase the results in visualization tools. The process is automated and centralized and currently saves ~3 hr/finance associate.4. Worked on predicting the CV and transacted value using research metrics as a base and analyzing the levels of engagements at an associate level. This helps in identifying the risk products and helps define the strategy for increasing the ROI.5. Mentoring and coaching of teams on Analytical tools such as R, Python, SQL and Power BI.

Gurgaon, India

Worked as a Data Scientist –Analytics Consulting and Development at Fluor Corporation(EPC organization) o Have Experience in database designing and Database workflow documents.o Have worked upon MS VISIO in creating efficient and robust data flow allowing the intervention of multiple data sources.o Have knowledge about the Python Packages and building various Algorithms Related to Machine learning on Jupyter(Python) .o Knowledge about the Python Data Analysis.o Assisted in creating the database from scratch in SQL. The end to end process is automated and the automation part is being handled in Rstudio which works as an ETL Layer for the database and creates the Data Mart with the updated values.o Helped the team on setting up the complete ETL process and Schema structuring for the database. Followed a star Schema Approach in the same.o Helping team with the benchmarks using statistical approach to design the formula for each benchmark on a run time basis.o Created a regression model (KNN Included) to predict the Hours required for the execution of a particular project basis various factors. This project was taken up in Rstudio using SQL as a backend, the complete reporting part was presented in RshinyDasboard(R Studio package).o Worked upon Pricing And Quantity Analytics (Prediction of quantities and Prices using Predictive modelling)o Taking end to end ownership of implementing a ML model (Predictive, KNN).o Have worked upon multiple BI Platforms (Tableau, Spotfire, Alteryx , PowerBI)o Having knowledge about writing the advanced DAX Queries in PowerBI.o Providing lectures about various tools and Algorithms being used in the field of analytics to the teamso Working on PowerBI DAX queries and automation.

Gurgaon, India

• A little brief about the Organization:-o Easyrewardz is a Loyalty Payments Startup working on the loyalty payments and making shopping easier and interesting for the Indian brands and consumers. It particularly has 3 divisions –o LPAAS-loyalty payments as a service(POIINK App).o Customer analyticso Ecommerce sectionWhere I have been working in the Analytics and business intelligence section of the team.My areas of involvement includes:-o Working on multiple DB’s at a single time.o Working on the customer Analytics and making deep insights for the further growth of the Organisation and consumer business.o Taking leadership for the campaign response and campaign analytics involving use of languages such as R and MySQL.o Cleaning of huge data (Mostly Working on GB’s of data),Uploading the same on the DB.o Working on Queries and making better insights with data for meaningful approach.o Managing data on dashboards and keeping view of campaign analytics. Automating the entire campaign process.o Keeping track of the dashboards and the values adhering as per the database.o Making reports as per the requirements and presenting data in its best version available.(With the help of reporting tools such as PowerBi,Qlikview).o Involved in the time series forecasting and implementation of the same on various reporting dashboards and taking care of the prediction models in R.

Gurgaon, India

Worked as an Analyst

Bachelor In Technology, Electrical, Electronics And Communications Engineering

Education record