Situl Shah Email & Phone Number

Manage a team of internal BI developers and subcontractors that are added on an as-needed basis. Serve as the main point of contact for all data management tasks from data identification, extraction, modeling, warehousing to presentation.• Managed the entire development life-cycle for all data extraction, modeling, warehousing, and reporting projects.• Expanded the reporting portfolio from 3 informational Excel reports to about 170 actionable reports that are a combination of performance scorecards, KPI reports with drill-down and drill-through, a self-service reporting platform, executive-level dashboard reports, and a web-based employee reporting portal.• Developed and automated data and reporting processes for 3 new lines while the business while the business doubled within 4 years.• Designed an operational data warehouse and collaborated with the OBIEE team to develop a self-service BI platform to help analysts create their own reports and perform analysis. Their productivity has increased by completing analyses within hours from days. • Modeled a data warehousing solution to gain insight on technician’s driving patterns and vehicle assignments for 4000 vehicles in the fleet system using real-time GPS data. This initiative has improved technician’s safety scores by 30% and generated savings of about $20K per month for the Asset Management department.• Designed and automated predictive ordering and inventory audit reports for the Cellular and Security businesses. They have realized about $50K in savings from these actionable data. • Transformed the existing data and reporting hierarchy to a new standardized hierarchy that streamlined all reporting and software applications. This new hierarchy is the baseline for all transactional processing that happens within in-house software applications used by the company as well as for reporting and analysis. • Planned and managed the migration of the databases, ETL processes, and reporting services every 2 years.

Coppell, Tx

Member of the Business Intelligence and Analytics team for the Installment/Fulfillment line of business. The team provides operational support by managing all reporting, software application development, and business analytics functions.• Invented a major KPI report - The Financial Indicators Report. A very important tool used by all levels of management on a daily basis to manage operational and financial metrics. Used to capture $25M annual revenue from client• Developed and managed both a web and mobile version of the Technician Scorecard that impacts about 5000 employees. It is a key report used to measure employee performance across all operational metrics and their promotion/demotion eligibility• Designed and administered a subcontractor reporting portal that is used by about 100 contractor partners daily to access financial, operational, and inventory reporting. The portal has improved their operational performance by 40%• Eliminated operational inefficiencies of the resource management team by automating all their data access and reporting processes. The result was an Administration Audit report that helped the team to manage 5000 technicians’ schedules, training, and appointments routing.• Automated the Safety Flash reporting that immediately notifies management about any work-related accidents. Increased response time to accidents by 70% and helped save millions of dollars in lawsuits and insurance claims• Integrated all data and reporting processes during an acquisition. Built the entire set of reporting for the acquired business within a month. This was a crucial part of the acquisition’s success.

Lafayette, Louisiana Area

Graduate Research Assistant | University of Louisiana, Lafayette, LA Aug 06-Aug 08Member of the graduate research team for the Business Systems, Analysis, and Technology Department for the College of Business. The goal of the team was to assist faculty in their research projects that aimed to support local businesses• Conducted statistical data analysis and literature review for a faculty research project. The purpose of the study was to measure the comprehension of basic mathematical skills of students enrolled in statistics classes at a large regional university, and to determine if the scores earned on a basic math skills test are useful in forecasting student performance in these statistics classes, and to determine if students’ basic math skills have changed over time.• Developed a reporting platform for Laborde Diagnostics in MS Excel. The improved data visualization, analysis, and reporting solution had a positive financial impact on their business.

Master Of Business Administration (Mba), Management Of Information Systems (Mis)

Bachelor Of Science, Engineering