Ayush Pathak

Experience

• 

  Tata Consultancy Services

  Jun 2019 - Jan 2022

  Data Cleaning & Data Preparation – Missing value imputation, outlier treatment, Exploratory Data Analysis (EDA) over continuous & categorical variables.Python,SQL Queries, Quality Testing of the Dashboards & reports across,SQL,Excel & Power-BI. Created a machine learning model as a proof-of-concept (classification & regression).Compile timely, comprehensive and accurate documentation and or reports as requested. And, working in an Agile Environment. Built modern applications/pages with C#, ASP.NET, Angular, SQL Server & Toad for Oracle.Revised, modularized and updated old code bases to modern development standards, reducing operating costs and improving functionality.

  • System Engineer

    Apr 2021 - Jan 2022

  • Assistant System Engineer

    Jun 2020 - Mar 2021

  • Assistant System Engineer Trainee

    Jun 2019 - May 2020
• 

  Flip Robo Technologies

  Apr 2021 - Oct 2021

  Data Science Intern

  -->Roles and Responsibilities-1) Analyzing client demand, conducting exploratory data analysis to extract insights and uncover import groups,trends and relationship in data and also performing Data Visualization , Data Cleaning and Building Machine learning models. 2) Web Scraping – Scraped data from various websites and read the required data into Python using Beautiful Soup & Selenium(handling exceptions)

• 

  KPMG

  Jun 2021 - Jun 2021

  Data Analyst

  1. It is an internship organized by the KPMG Group.2. It entails tackling real-world data difficulties that enterprises all across the world encounter.3. As a Data Analyst, I'm expected to report my findings from the data and provide recommendations about what variables might be causing a drop in clients on a certain platform.4. For evaluation, the final recommendations are compared to insights provided by the Senior KPMG Data Analyst.-->Task-1In order to prepare for analysis, data quality and accuracy are analyzed.Identifying data quality issues and developing ways to address them.-->Task-2Customer demographics and attributes are used to target high-value consumers.Prepare a clear plan for completing the study, including tasks such as data distribution analysis, feature engineering, data transformations, modelling, findings interpretation, and reporting.-->Task-3Visualizations are used to show information.Create a dashboard that we may show the client on our next meeting. In a dashboard, showcase your data summary and analysis results.I now feel more confident in my ability to review difficult contracts, communicate with clients, provide the suitable advice requested of me and more. Virtual internships are a terrific opportunity to spend your time at home doing something practical while also demonstrating your dedication to the law. Show less

• 

  Deloitte

  Jan 2022 - Feb 2024

  Analyzed client requirements with business and functional users.Lead a technical team of 3-4 members to identify and develop solutions within a project using spark scala and python for automation of multiple audit processes such as Journal Entry Testing, Capture Trade Payable Analysis etc.Provided full support and coverage for numerous legacy scripts in production built on Spark, Python, SQL etc to address ETL failures or addditonal capabilities.Provided regular assistance to team leadership in hiring and mentorship for new hires and interns within the Analytics team. Show less Responsible for developing several big data analytics pipeline and conducting EDA over continuous and categorical datasets, including recomputation, exception finding, random sampling, summary analysis and revenue re-performance.These pipelines are now widely used to produce insights from clients data and suggest suitable actions, all with the objective of improving the efficiency of Audit and Assurance services across Deloitte offices in India.Developed spark sql scripts for reperformance of Expected Credit Loss (ECL) calculation for one of India's largest NBFCs. These scripts are also used to generate design workflows and supporting documents for final ECL reports for audit purposes.In addition, served client in a wide range of industries, such as Banking & Finance, Manufacturing, Technology, Retail, Ed-Tech and Telecom. Show less

  • Assistant Manager Analytics

    Jun 2023 - Feb 2024

  • Senior Executive Analytics

    Jan 2022 - May 2023
• 

  Maruti Suzuki India Limited

  Feb 2024 - now

  Deputy Manager Data Scientist

  Driving the forefront of enterprise generative AI product development through collaborative efforts with partner teams, committed to identifying and implementing cutting-edge capabilities and enhancements to elevate business profitability and strategic initiatives.