Aayush Kapoor

1810/673 La Trobe Street · Docklands, Victoria · +61-448422091 · aayush.kapoor08@gmail.com

Customer-focused analyst and data engineer with strong business acumen and passion for data-driven decision making and designing cloud-based products. Expert in using the AWS platform to build and automate ETL pipelines, experienced in writing statistical reports, design, and build machine learning algorithms to solve business problems. Possess huge fluency in statistical programming using R, Python, SPSS, SQL, PySpark, MS Power BI. Ability to explain to owners and stakeholders the results, trends, and business outcome. Excellent team management skills with the ability to inspire and develop others.


Experience

Technical Architect

HCL Australia Services Pty Ltd

Melbourne, Victoria

I am currently working with our client ANZ bank on the data migration of their KYC platform Siebel to the new platform GoldTier, my roles and responsibilities are:

• Gathering business requirements from key stakeholders and converting into technical requirements.
• Designing and developing data models, integrated and operational data stores in client platforms using integration tools and providing advice and guidance for improving the efficiency of the system designed.
• Developing end-to-end data solutions for data ingestion, transformation and migration using Python, R, SQL.
• Analysing client platforms by profiling the data and using the insights to design client solutions in accordance to agreed requirements and quality accredited standards.
• Creating and maintaining technical programs, business process documents, standard operating procedures for the system designed.
• Developing and documenting proof of concept framework that includes technology solutions, limitations and recommendations on existing processes and systems.
• Diagnosing and testing the designed system for errors and faults as per testing standards, documenting the testing results by capturing all the test results, defects, issues and fixing the program code within established quality standards.
• Developed automated dashboards using MS SQL Server, data wrangling using M query and DAX (Data analysis expressions) functions on MS Power BI to measure and gauge the performance of the incident management system for the client.
February 2021

Data Analyst

Holmes Institute

Melbourne, Victoria

During my contract with Holmes, I worked on Student performance indicators under the TEQSA Risk Assessment framework, Student Engagement Surveys, Blackboard(learning management system), and forms digitalization.

• Transformed existing pipeline by removing manual steps and reduced the time taken by the process significantly by using AWS Glue making the process serverless and fully managed. Extensively used Python to transform raw text files into CSVs, XMLs as per requirement to load them in the database from file sharing services as part of the ETL pipeline.
• TEQSA Risk framework assures the quality of Australia’s higher education sector. Created python scripts that performed the calculations of different performance indicators like student attrition, progression rates, completion rates, grade distribution, and student satisfaction.
• Performed statistical analysis on SES(Student Engagement Survey) to compare and understand the longitudinal differences in student opinion of their experience during their study at Holmes. Created cross-tabulation, visualisations on Tableau and performed hypothesis testing.
• Build a machine learning classification model using NLP(natural language processing) on python to categorize different student requests/emails received on Blackboard(LMS) ticketing system, thus improving time to solve the issues efficiently by forwarding the requests/emails directly to the required department.
• Digitalized student inquiry, enrolment, and admission forms that were manually updated in excel. Created fillable pdf forms along with python script to capture information in the PDFs and convert it to excel. The new process saved un-counted man hours and improved the quality of data captured.
October 2019 - April 2020

Data Analyst

Australian Institute for Teaching and School Leadership

Melbourne, Victoria

Contracted by staffing agency Hudson to work on a one-month project as a Data analyst with AITSL and help in creating an annual engagement report. Performed diversified research techniques, but no limited to:

• Performing extensive data wrangling tasks on 2019 and 2016 stakeholder engagement survey using Python and SPSS scripts for merging the two-dataset (large dataset with 700 variables).
• Analysing and interpreting data, by performing non-parametric and parametric test like ANOVA and t-test to check for statistical difference among various categories of data.
• Creating visualizations to describe and present statistical findings using SPSS charts builder and MS Excel
• Implement driver analysis using the Shapley Value regression technique

June 2019 - July 2019

Data Science Intern

Impactful Ventures Pty. Ltd

Melbourne, Victoria

• Developed wireframes for the product and created a working prototype in 90 days
• Designed the data architecture for the product(job-portal) ensuring data governance policies adhere
• Extracted data using LinkedIn REST API thus helping in reducing the number of searches
• Created a personality assessment survey to understand traits that company feel is more aligned to role posted, and to further scope a deeper insight into how the candidate might fit into the company work culture

November 2018 - February 2019

IT Data Tools Operations Specialist

Gartner

Gurugram, India

• Analysing and interpreting data into charts, data visualization tools and CEB-quality graphics (QlikView) which helped clients to make a strategic business decision
• Building custom diagnostic surveys on EFM (VOVICI) that helped management in understanding key priority areas in their department/company
• Developing SPSS scripts to perform data wrangling and statistical analysis
• Generating reports presenting key research insights and data analysis results using QlikView Dashboard
• Coordinated with internal stakeholders on new product launches (worked on various diagnostics/tools development like Ignition Guides and Business Alignment Tool) using agile methodology and daily Scrum meetings, and JIRA to plan, track and update progress on user stories
• Lead the project of rebranding diagnostic surveys and report templates, successfully delivered the project four days in advance of stipulated time (Gartner acquiring CEB)

November 2014 - July 2017

Education

Monash University

Master of Data Science in Advanced Data Analytics
Coursework: Applied Data Analytics and Algorithms, Data Exploration and Visualisation, Data Processing for Big Data, Data Wrangling, Modelling for Data Analysis, Project Management, Business Forecasting(time-series using R), Professional Practice, Industry Experience, Database Management

July 2017 - October 2019

University of Delhi, Ramjas College

B.Sc(h) Statistics
Coursework: Multivariate Analysis and Non-Parametric Methods, Design of Experiments, Survey Sampling and Sampling Distribution, Statistical Inference, Statistical Quality Control, Stochastic Process and Linear Models

May 2009 - June 2012

Skills

Programming Languages & Tools

Technical Skills
Interpersonal Skills

Interests

Apart from being a data scientist, I am an aspiring chef. Living away from home I missed homecooked food so much that I initially started cooking once a week and based on public reviews I feel I have mastered the art of cooking Indian cuisines now.

I am an avid reader and love reading novels, currently reading Tuesdays with Morrie(as of 26 August 2021).

I also like to keep myself updated with movies and web-series on Netflix too (just in case!). Recently finished "Unorthodox".

Certifications