Apoorv Srivastava Email & Phone Number

Hyderabad, In

Hyderabad, Telangana, India

Hyderabad, Telangana, India

>> Project: Data Management and BI & Reporting for Custome and Niche Product Manufacturing CompanyLed a team of 4 -1. Setting up and maintaining EDW and pipelines using Azure Synapse - ingesting data from 2 ERPs and Salesforce.2. Conceptualized and implemented 7 dashboards to provide the Finance team visibility into WCM (AR, AP, and Inventory) and Spends (Direct & Indirect - Department, Freight, Capex). Enhanced their analytical capabilities by reducing turnaround time on reporting and providing granularity of data that was hitherto inaccessible. 3. Designed and executed commercial reporting covering Revenue, Bookings, and Orders for sales and commercial teams. Developed demand forecasting tool to assimilate forecasts generated via ERPs and Salesforce. 4. Work to enhance their record to report process for various business processes and act as a trusted advisor on all things data management and BI & reporting.• Project: Tech Diagnostics for Veterinary Healthcare Aggregator1. Conducted a deep dive into the current state architecture of BI reporting and data storage, by conducting in-depth interviews of C & C-1 level executives. 2. Derived a set of recommendations for future state BI reporting and data warehousing architecture by performing technical assessments of 3 different tech stacks (Azure v/s Aws v/s Snowflake-dbt-fivetran) along with financial implications of each. Supplemented this with a data governance and EDW scale-up plan (500% growth in clinic count in 5 years). 3. Designed metrics matrix and conceptualized a set of 10 dashboards to drive data-driven decision-making. Covered the following areas - Financial (PnL, Working Capital Management reporting), Operations (Inventory, Clinic/Provider performance), M&A, HR (Headcount, Retention, and Development), and Talent Acquisition. 4. Developed a plan of implementation (timelines, costing and staffing, contingency planning) and RoI analysis of the promised future state.

Hyderabad, Telangana, India

>>Project: Credentialing Process Analytics for US-based Pediatric Healthcare AggregatorProvider credentialing (mandated by US Federal law) in healthcare is the process by which medical organizations and Insurance providers verify the credentials of healthcare providers to ensure they have the required licenses, certifications, and skills to treat and provide care to patients.1. Designed 20+ volume and velocity KPIs for effective and efficient monitoring credentialing process.2. Provided analytical support to identify process gaps in recording data and prioritize fixing of data quality issues. Along with that provided linkage to avoid any revenue loss due to errors in the credentialing process.3. Conceptualized and implemented a dynamic dashboard to track the KPIs designed. The dashboard is to be used by both executives and grassroots employees to monitor the progress and efficiencies of the process.4. Converted the project into a case study for internal consumption by the leadership team and to be used for business development purposes.>>Project: Operational AnalyticsExpanded responsibilities for new role: 1. Onboarding new team members and managing an intern. 2. Develop ideas for further expansion of the project and generate insights.3. Handling all tactical client communication.

Hyderabad, Telangana, India

>>Project: Operational Analytics for US-based Pediatric Healthcare Aggregator1. To provide visibility to the COO's office and regional heads into the day-to-day appointments funnel, portal usage, and provider/clinic efficiencies, conceptualized and developed a dynamic dashboard to track 40+ Operations KPIs across ~300 clinics with ~2M monthly patient demand. 2. Led analytics on appointment data to optimize for patient-physician contact time and drops across the appointments funnel (using metrics such as Fill Rate, Slot Utilization Rate, Cancellations, etc.) to decrease lost opportunity. 3. Enhanced the dashboard further by adding features to pull in patient level details for various metrics to be used by the call center for re-booking of canceled appointments and booking/rescheduling of empty slots.>>Project: Pricing Analytics for US-based Fitness Franchise Chain1. Developed models to recommend individual pricing opportunities for 250+ clubs across three different membership packages, potentially impacting $800M+ revenue. 2. The model was developed using sales and financial transactional datasets to analyze customer churn, retention analysis, and cohort LTR.3. Conceptualized and developed of suite of PowerBI dashboards to provide the CEO's office the ability to track revenue and membership trends (across temporal and spatial dimensions) on a real-time basis.

Bengaluru, Karnataka, India

• Designed and executed Demand Partner Profitability Framework for North American business, to optimize infrastructure costs. This helped to maintain the profitability margin above 15% for all accounts.• Conceptualized analytical framework for data projections to set annual targets and executed publisher floor pricing experiment.• Regular tasks involved KPI checks and optimizations, Supply Churn Analysis, Quarterly Business Reviews and preparing supply and demand landscape numbers.

Goa, India

• In Chemical Engineering Department for core course Kinetics and Reactor Design. • Designing and evaluating class assignment and quizzes. • Preparing teaching slides, demonstrations and exercises for tutorials. • Conducting exam prep and doubt clearing sessions.

Gurugram, Haryana, India

• Prepared Hydraulics reports for different projects.• Undertook general overview of Aromatics Technologies.• Review of simulations and project templates for different technologies

Bits Pilani, Goa Campus

● Led a 105-member team along with 5 other coordinators and achieved 60% member retention.● Primarily responsible for organizing the annual college Ball as a part of the cultural fest Waves. Fundamentally redesigned the concept of prom, integrating creative storytelling through visual decoration, interactive games, and live music. ● Work portfolio included conceptualizing the event, managing logistics, publicity, and coordination with relevant stakeholders.

Nagda, Madhya Pradesh, India

• Studied and corrected for the efficiency of Fluidized Bed Granulator, increasing the output by 4%. Conducted deep research to identify new and emerging technologies for the same.• Prepared model to stimulate production output of Granulators of different types under different configurations, working with Calcium Chloride slurry. • Prepared detailed report for Heat and Mass Balance for Calcium Chloride Plant.

Bachelor Of Engineering - Be, Chemical Engineering, 7.94

Aissce, 89.6%

Activities and Societies: Regional finalist for Jawaharlal Nehru National Science Exhibition, 2013. City level finalist of School Quiz.