Hi, I’m
Prateek Tyagi
Senior Business Analyst
Ghaziabad,UP
Summary
Experienced business analytics professional with a rich experience of 6 years across Product, Analytics, Data Science and Automation. Lead cross functional teams and managed clients across across India, US, EMEA in Ecommerce, Retail and Real Estate.
Overview
6
years of professional experience
8
years of post-secondary education
Work History
Saras AnalyticsHyderabad, Telangana
Senior Business Analyst
09.2020 - Current
Job overview
- Headed design and development of KPI dashboards to provide end to end reporting solutions to D2C aggregators, Agencies and DTC Brands giving full visibility into their marketing, sales, product, finance and supply chain functions. Lead of team of 5+ and engaged with 10+ clients with annual turnover of more than 1000 Cr
- Oversaw development of RPA solution to automate manual reporting tasks. Led to a FTE savings of $ .2 Mn across 10+ clients
- Designed data warehouse architecture and headed efforts to reduce warehouse operating cost through native cloud features. Estimated annual cost savings of around $ .1 Mn.
- Identified key drivers of subscriber churn by aggregating data from multiple sources both structured and unstructured. Coordinated with customer experience teams to improve 1 month retention rate by 5%
- Analysed customer reviews of a US D2C brand to identify topics/themes that affect customer experience . Helped improve CSAT score by 10%
- Developed dashboards to monitor outbound supply chain performance with KPIs like transit time, on time fulfillment, click to delivery. Boosted delivery SLA to 95% and reduced cost of delivery by 10%
- Hired, trained and mentored resources and set up KT processes for new joinees.
BuildSupplyGurgaon, Haryana
Business Analyst
04.2019 - 07.2020
Job overview
- Implemented and Managed the entire Analytics and reporting for the platform through Google Analytics and Firebase
- Used Content filtering and cosine similarity to develop Recommendation Engine for identifying Best Selling products for the Ecommerce platform
- Implemented event monitoring for commerce website to capture user behavior; led to an increase in quotations received worth 70L
- Consolidated data from disparate sources to create KPI Dashboards using Tableau
- Developed script to extract pricing information from unstructured data. Reduced time taken to completion from 2 days to 3 hrs
- Saved 20 man/hours by automating usage report of a SaaS product using Python
- Created an extensive catalog 30k of construction materials by managing a team of 3 interns
- Conceptualized a framework for SCM team to prioritize transactions to focus on the ones that provide more ROI
- Performed Credit Analysis of the companies in Real Estate and Construction Industry
- Performed Competitive Analysis and Feature benchmarking to arrive at Pricing Strategy
ICICI LombardMumbai, Maharashtra
Consultant
04.2018 - 06.2018
Job overview
- Used Advance Analytics techniques like Factor Analysis, Clustering and Linear Regression to identify new markets for selling health insurance.
- Used a mix of Internal and External Data
- Suggested Areas with expected Loss Ratio less than 50% and 14x growth potential
Infosys Ltd.Gurgaon, Haryana
Technical Analyst
05.2014 - 06.2017
Job overview
- Prepared Business Intelligence reports for Late Deduction filing, Tax Collection at District Level
- Prepared automation scripts to export, transfer, transform and import data across different environments
- Managed Backup, Security, and Controls of databases to prevent any hacking attempts
- Controlled and monitored user access to the database to prevent any unauthorized access in system
- Designed logical, physical structure of database and configured various performance parameters
- Monitored the effectiveness and efficiency of databases operation to speed up data processing
- Implemented and maintained all procedures for backup and recovery of database systems
- Capacity analysis and planning and created scripts for process automation of regular database tasks
Education
IIM NagpurNagpur
MBA from Mechanical
06.2017 - 03.2019
IIITDM JabalpurJabalpur
BTech from Mechanical Engineering
06.2010 - 06.2014
Ch. Chhabil Dass Public SchoolGhaziabad
Senior Secondary
05.2007 - 05.2009
Skills
SQL
Project Management
Power BI
Python
Product Management
Business Analytics
NLP
Accomplishments
- 1 among 2 rated Outstanding out of 30 for being a consistent performer in Infosys
- Estimated cost savings of Rs.10 lakhs to the project by compressing system logs of the transactions
- Awarded scholarship worth 5L for Analytics Course on exceptional performance in Entrance Test from Bridge School, Gurgaon
Timeline
Senior Business Analyst
Saras Analytics
09.2020 - Current
Business Analyst
BuildSupply
04.2019 - 07.2020
Consultant
ICICI Lombard
04.2018 - 06.2018
IIM Nagpur
MBA from Mechanical
06.2017 - 03.2019
Technical Analyst
Infosys Ltd.
05.2014 - 06.2017
IIITDM Jabalpur
BTech from Mechanical Engineering
06.2010 - 06.2014
Ch. Chhabil Dass Public School
Senior Secondary
05.2007 - 05.2009