Rishabh Jain Email & Phone Number

Chicago, Il, Us

Chicago, Illinois, Us

Chicago, Illinois, Us

Chicago, Illinois, Us

Half Moon Bay, California, Us

1. Developed tools, using Excel and in-house frameworks, to help reduce the QC process time by 25% for the business processing team.2. Worked with different teams to develop detailed Process and Data Flow Maps and made recommendations for improving the current process flow for the next fiscal year, 2022.3. Working with multiple teams within the organization to improve the turnaround time of projects for the next year based on the analysis and recommendations I provided.4. Working on improving a forecasting model’s accuracy, of a different business unit within the organization, using statistical techniques (regressions and descriptive statistics) and data visualization.

San Diego, California, Us

1. Worked with the teams within and outside the company to develop a dashboard that would give the senior managers visibility on all the POs that were active/canceled within six months.2. Worked with the sourcing team to develop a tool in Excel that would calculate ELC cost for 20,000+ items.3. Worked with the Vendor Management Team to determine the shipping lead time of both domestic and international vendors and developed strategies for reducing that time.4. Used Alteryx, Snowflake, and MicroStrategy to design new and automate existing KPI reports.

San Diego, California, Us

1. Collaborate with HRIS and Compensation teams in calculating the quarter and annual incentive payouts for 25000+ store and field employees.2. Track and report on different sales metrics to provide visibility to senior management, played a key role in improving the comp within last year.3. Created real-time Exception Report using Microstrategy and SQL Server that points out those stores which are missing their weekly targets by 5% or more across different areas.4. Design and maintain the timesheet report in Excel for the store operations department to help them track 150 store partners in 100+ stores across the country.5. Working on a dashboard in Microstrategy which would provide 25000+ employees real-time sales and other KPIs data on daily, weekly, quarterly and yearly level, provide business insights to drive up the sales.6. Simplified and automated reporting process in Microsoft Excel with the use of complex functions and macros, reduce the time to make a report by 20%.7. Work with HRIS in determining the staffing and volume of 1500+ stores.8. Formulated and applied mathematical modeling and other optimizing methods to develop and interpret information that assist management with decision making, policy formulation, or other managerial functions.9. Create and distribute weekly, biweekly, and monthly reports; continuously review ongoing reports for accuracy, to spot trends and identify areas for improvement in content and presentation.10. Train other Petco employees in the use of reporting and data mining software.

1. Managed the inventory of around 3000+ (active) items and ensured 10% variance between inventory and sales.2. Created weekly selling reports which played a key role in driving up the sales by 25 % and profitability by 8%.3. Worked closely with internal teams to strategically drive company-wide goals and improved operational sales process.4. Collaborated with the product development team to improve the item setup process.5. Communicated sales needs back to management and product team assisting in pricing analysis to ensure products relative to one another and in combination are priced correctly.6. Extracted data from OMS and SQL database to prepare excel reports and derive business insights from the collected data to drive up annual revenue.7. Developed and worked with the owners of the company in preparing budget and in forecasting inventory and sales.8. Created and managed new and existing crystal reports for streamlining inventory and sales. Used tables/views to help automate reporting.

Master Of Business Administration - Mba, Business Administration, Management And Operations

Master'S Degree, Engineering/Industrial Management

Bachelor'S Degree, Electrical And Electronics Engineering

Accounting, Finance And Marketing