Business Analyst Data

Aayushi Kachole

Contact:

+1-206-***-**** Seattle

Email:

****.*******@*****.***

Linkedin Profile

WORK EXPERIENCE

Business Analyst (March 2022– June 2023)

Amazon

1) Automation of XBR Reports -

- Collaborated WBR, MBR, QBR reports in a single dashboard to monitor and track key performance metrics for business with deep dive view and trending charts for better decision making and callouts.

- Optimized and created complex Sql Queries reducing run time and refresh time for dashboard and improving performance of analytics systems.

- Saved bandwidth of 2 employees in a team with cost reduction of $200k yearly.

- Designed and developed ETL data pipeline for large scale dataset. Developed De-norm table in highest granularity and appending matter to accumulate at-least 2 years data for YOY comparative view.

2) Stakeholder Project -

- Collaborated with stakeholders to define project objectives and identify business needs and data sources.

-Performed statistical gap analysis to identify areas of improvement in product. Analyzed key aspects of business to evaluate and forecast $$ saving, investments done to build product and summarized into presentations to verify with the finance team.

- Used A/B testing techniques to check significant trends and improvements with stations using product and not using product.

-Identified patterns and trends in large data sets and provided actionable insights to product team and tech-team.

- Created multiple datasets from different sources to combine all goal tracking metrics in the dashboard to track business performance. 3)Self Initiative -

-Analyzed data to identify root causes of problems for missort Packages/container was due to old labels getting scanned again resulting container delivered in wrong station

- Analysis recommended corrective actions to stakeholders and was taken as a potential project.

- Observed a drop of 10% concession cost in Missorted packages around ~$$2 million per month due to corrective actions recommended after the analysis. Database Analyst (July 2021– Feb 2022)

Cloud Mentor

-Learnt Litify (tool based on Salesforce platform)

-Understood client’s data architecture and built end-to-end data migration pipeline using complex SQL queries

-Performed data cleaning and formatting on legacy data Data Analyst (Feb 2020– June 2021)

Skill Santa

-Built an automated data pipeline using python script to ingest data from various sources

Goal

Reach the zenith of

professional excellence and

desire to learn new

concepts and technologies

and deliver all my skills

incurring technical expertise

in data analytics.

SKILLS

WORK

SQL

Tableau

Quick sight

AWS tools

Excel

SAP

Python

Agile

Jira

Scrum Master

PERSONAL

COMMUNICATION

ORGANIZATION

TEAM PLAYER

CREATIVITY

-Performed data massaging and created optimized data model for easy tabular load and extraction of data – created SQL scripts to perform the tasks

(Nov 2017 - Nov 2019)

SAP BI Consultant

Accenture

-Experience in complete project life cycle including documentation, analysis, development and testing. Always worked in close association with customers.

-Engaged senior stakeholders to design a BI / Performance Management framework for speed analysis.

-Worked on process chain monitoring, data load monitoring and query designer SOCIAL

EDUCATION

Smt. Kashibai Navale College of Engg, Pune

BE, Computer Science (2013 - 2017)

Distinction - 70%

Contact this candidate