Badges
Certifications
Work Experience
Product and Business Operations Intern
Lenovo• June 2022 - April 2023
- Developed and automated real-time PowerBI dashboards to analyze market trends and track market share, reducing report generation time per product manager upto 4 hours - Modeled data into star schema by extracting, transforming and loading 7 million rows from data lake using optimized SQL queries - Analyzed competitive pricing by comparing KPI's and forecasted sales using Excel and Python leveraging data from International Data Corporation (IDC) to support senior executives in making strategic decisions - Implemented new KPI “Attached rates”, into PowerBI dashboards and track metrics leading to 12% YoY increase in sales for top products combinations - Automated manual report generation process by migrating data reports into PowerBI, resulting 8% reduction in workload - Composed and finalized technical specifications of 3 laptops (ThinkPad P16, P1) by incorporating feedback and collaborating with cross-functional teams, resulting in high-quality products
Business Analyst Intern
Orient Technologies Pvt. Ltd.• January 2021 - April 2021
- Automated tiered approval workflow process using Power Automate, improving efficiency by 25% - Executed Extract, Transform and Load (ETL) on existing database with 4 million records and exported data through SQL Server Integration Services (SSIS) package - Built decision-support data dashboard using Power BI for visualizing Fiscal sales to provide high-level business visibility - Led development of application using Power Apps that assisted in search for project specifics, saving 30 minutes of search time
Cloud Computing Engineer Intern
Orient Technologies Pvt. Ltd.• June 2018 - July 2018
- Coordinated with business teams to develop serverless website hosted on AWS service (Amazon S3) for language translation - Configured MySQL database using master-slave technique and replicated over 500 computers for backup and disaster management - Designed AWS system architectures based on customer requirements and prepared proposal presentations for stakeholders
Education
Syracuse University, Syracuse
Information Systems, MS• August 2021 - May 2023
Graduated with Certificate of Advanced Studies in Data Science
Thadomal Shahani Engineering College, Mumbai
Information Technology, BE• August 2016 - October 2020