Aayush Kumar Email & Phone Number

Navi Mumbai, Maharashtra, In

Paris, France, Fr

Clearwater, Florida, Us

• Developed a pipeline which will feed the data from HANA to Azure & further this data will be used for predictive modelling and building dashboards to show KPIs.• Used Spark SQL to fetch & transform data from multiple big files. Created a data pipeline to study the summary statistics by using Mapper & Reducer Programs on Databricks.• Extracted data from multiple sources to flat files and load the data to the target database.• Developed multiple databases on MS SQL Server from scratch and then pushed the same to Tableau to show pricing & workforce analytics.

Clearwater, Florida, Us

• Developed workflows for cleansing of datasets with 50 Million records using Alteryx.• Created action filters, parameters and calculated fields for preparing dashboards and worksheets in Tableau to show KPI and KRI.• Revamped/Enhanced existing Dashboards on Tableau to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. • Worked on creating a POC on predicting the churn rate for the resellers of Tech Data.

Tampa, Florida, Us

• Did Sentiment Analysis of Medical Drugs using the techniques of Text Mining.• Developed & Optimized a deep neural network for classifying various classes of animals using Keras.• Working on different ML Models like Regression, Nearest Neighbors, SVM, Neural Networks, Decision Trees.• Made a Timeseries Model to predict & analyze the stock prizes using ARIMA & ARMA.• Created a visual story articulating the crime that has happened in the US over a period of 20 years & did forecasting for the same.• Worked on making predictions using Azure ML Studio, SAS EM, Weka.• Implemented analytical simulations from Excel to R.

Bangalore, Karnataka, In

• Managed multiple components of a large project.• Lead the team in interface monitoring tasks & data collating, analysis, further discussed the ways of optimizing that, decreased the rate of monthly transaction errors in the system by 15%, saving $50,000 annually for the client.• Produced queries, and reports for analyzing, summarizing, and root causing board failure of data. Versed in finding patterns and trends in complex, multivariable data-sets.• Worked on SAP Process Integration/Orchestration(PI/PO) design objects to develop interfaces. • Banded together with Quality Assurance & User Acceptance Testing teams for successful project delivery.• Used Tableau and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests.• Communicated with the client to determine specific requirements and made FRD and BRD.

Bangalore, Karnataka, In

• Performed SQL queries to migrate the system data from ABAP to HANA & also debugged the same.• Designed invoices for a major German manufacturing company.• Following the project life cycle methodology like Agile & Waterfall; defined under the process framework.• Worked on SAP Scripts, Reports, ADLC, HANA Remediation.

Bangalore, Karnataka, In

• Worked on UI for an android application on Android Studio.• Created a Personal Chat Application on Python which offered users to chat with their contacts.• Made an e-Payment Portal Project which provides a facility for users to use e-wallets as a transaction medium using Java, Hibernate Framework, Oracle 10G.• Created Dashboards on Tableau for various business scenarios.

Master Of Science - Ms, Business Analytics & Information Systems

Bachelor Of Technology (Btech), Information Technology