Amrit Singh
Gurgaon
Summary
A dynamic and motivated data analyst with 4 years of experience, driven by unwavering determination and a passion for success. Proficient in translating stakeholders needs into effective project strategies, utilizing strong interpersonal skills for stakeholder engagement. Expertise in data analysis, fostering innovation, and driving business growth. Diligent, detail-oriented, and adept at leveraging analytical tools for impactful insights in dynamic team environments.
Overview
6
6
years of professional experience
Work History
Business Analyst
Vama
12.2023 - Current
- Conducted gap analyses to identify discrepancies between current and desired states, leading to actionable recommendations.
- Automated reports using SQL and Redash APIs, resulting in a weekly reduction of 10 hours in manual efforts.
- Managed stakeholder expectations through transparent communication and timely status updates, ensuring alignment between project deliverables and business objectives.
- Led the implementation of Redash from inception, streamlining data retrieval through SQL queries
- Mentored junior analysts on best practices for business analysis techniques, fostering professional growth within the team.
- Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies.
- Analyzed performance metrics to identify opportunities to increase sales.
- Communications to users was conducted subsequent to analyzing large datasets and interpreting findings.
- Implemented Segwise from scratch as an RCA tool.
Data Analyst
PhonePe
09.2022 - 12.2023
- Proficiently utilized SQL skills to generate targeted notifications (PNs) by formulating queries for the CRM team
- Generate data model insights, design right interventions & execute quantitative analysis that translates data into actionable insights
- Tasked with designing Qlik Sense dashboards, and optimizing resource utilization to ensure efficient performance and enhanced data visualization
- Optimized DAGs (Directed Acyclic Graphs) through the application of SQL skills, enhancing workflow efficiency and data processing
- Executed optimization and comprehensive data model revamp for over 5 dashboards, resulting in substantial resource savings of over 250 hours per month and achieving advanced data availability well ahead of schedule
- Implemented daily, weekly, and monthly automation to replace routine manual interventions, resulting in improved data accuracy, reduced error occurrences, and substantial monthly savings of over 150 hours in manual labor
- Utilized Airflow 2.0 to architect and deploy automated queries, significantly improving data analysis efficiency and fostering seamless collaboration among diverse stakeholders
- Led analysis and data model development for the entire Discover screens on Galaxy Store, showcasing strong autonomy and expertise in driving insights and enhancements
- Created data visualizations, and dashboards on Tableau to track key performance indicators and support business decision-making
- Gathered and presented historical performance data to clients, effectively demonstrating value and facilitating their engagement and onboarding.
Data Analyst
Indus OS
09.2020 - 09.2022
- Tracked expenses with MS Excel spreadsheets and reported on client budgets
- Acquired data from various data sources and maintained data sources
- Worked with management to prioritize business needs
- Identified and acquired large underlying data to meet objectives
- Worked on an ETL tool namely Arbutus Analyzer.
Data Analyst
SDR Tracks Pvt Ltd
07.2018 - 06.2019
- Interpreted and automated data analysis, leveraging Google Sheets/Excel, and generated continuous reports to present and communicate results
- Employed focused strategies to elevate Discover page installs through meticulous A/B testing and analysis, resulting in the seamless onboarding of more Samsung mobile devices.
Education
Senior Secondary School -
Delhi Public School
Gurugram, HRPost Graduation Program - Data Science and Engineering
Great Learning
Gurugram, HR01.2020
Bachelor of Computer Application -
K.R. Mangalam University
Gurugram, HR05.2015
Skills
- Airflow
- Jupyter Notebook
- Mixpanel
- MySQL Workbench
- DBeaver
- SQL
- Python
- Regression & Classification
- Exploratory Data Analysis
- Advanced Excel
- User Acceptance Testing
Timeline
Business Analyst
Vama
12.2023 - Current
Data Analyst
PhonePe
09.2022 - 12.2023
Data Analyst
Indus OS
09.2020 - 09.2022
Data Analyst
SDR Tracks Pvt Ltd
07.2018 - 06.2019
Senior Secondary School -
Delhi Public School
Post Graduation Program - Data Science and Engineering
Great Learning
Bachelor of Computer Application -
K.R. Mangalam University
Similar Profiles
Daniel CazacuDaniel Cazacu
Bartender at VAMA Night ClubBartender at VAMA Night Club
Akshat MishraAkshat Mishra
Java Software Developer (Client: American Express) at Infosys LimitedJava Software Developer (Client: American Express) at Infosys Limited
Tanisha TyagiTanisha Tyagi
Customer Success Manager at PeopleStrongCustomer Success Manager at PeopleStrong