Shruti Bhatnagar Email & Phone Number

Pennsylvania, United States

1. Mapping and consolidating 5+ Profit & Loss Reports on Tableau including Gross Receipts, Planned Cartons Per Hour (CPH), and Hour Plans, to enable 5 non-technical departments to filter dashboard results and leverage business intelligence, gaining more visibility transferring productive units while addressing volatile operations.2. Transformed disintegrated reporting across cross-functional departments, by analyzing 6 Retail Operation data sets and identifying data integrity issues… Show more 1. Mapping and consolidating 5+ Profit & Loss Reports on Tableau including Gross Receipts, Planned Cartons Per Hour (CPH), and Hour Plans, to enable 5 non-technical departments to filter dashboard results and leverage business intelligence, gaining more visibility transferring productive units while addressing volatile operations.2. Transformed disintegrated reporting across cross-functional departments, by analyzing 6 Retail Operation data sets and identifying data integrity issues, such as missing data and formatting errors, ensuring each business unit’s Cartons Per Hour (KPIs) are met.3. Automated scheduled aging invoice reports from Oracle Fusion to Excel reducing manual dependency leading to single source of truth for invoice payment leading to 40% reduced vendor follow ups.Developed SQL queries to calculate Units Per Hour metric for each warehouse associate performing VAS functions. 4. Presented day over day Gross Receipts trend to C-level management to indicate current operational efficiency and hourly worker needs for departments to hit planned CPH(cartons per hour) metric.5. Conducted What-if analysis in Excel for re-forecasting hour plan for 62 warehouse associates because of reduced gross receipts to ensure all departments hit their CPH goal.6. Developed Dashboards and data visualization for Financial Planning and Analytics team calculating day over day operational efficiency leading to 40% accuracy in gross receipts forecast prediction Show less

Delaware, United States

1. Lead the end-to-end reporting solutions within the Product Delivery team to leverage Aladdin, the internal utility grade supply chain database across all 4 regions (North America, Latin America, Asia Pacific, Europe / Middle East / Africa), to serve global clientele spanning 6+ financial products, enabling 300 month-end reports to be delivered per Service Level Agreement (SLA).2. Conducted root cause analysis using SQL queries by optimizing 50 month-end reports to remove legacy… Show more 1. Lead the end-to-end reporting solutions within the Product Delivery team to leverage Aladdin, the internal utility grade supply chain database across all 4 regions (North America, Latin America, Asia Pacific, Europe / Middle East / Africa), to serve global clientele spanning 6+ financial products, enabling 300 month-end reports to be delivered per Service Level Agreement (SLA).2. Conducted root cause analysis using SQL queries by optimizing 50 month-end reports to remove legacy processes and reconfigure reports using end-to-end automation on Aladdin, thus writing effective documentation to reduce production time by 30% and increase gross revenue.3. Built Tableau dashboards using data from the internal data repository to visualize Green Package Production KPI’s (GP timeliness, Wing to Wing Straight Through Process) leading to early identification of core issues by C-level management and developing strategic actionable steps, leading to 25% increase in operational efficiency.4. Supported the automation of report production and delivery process of a new Returns and Attribution task board for 300 deliverables, by reviewing upstream dependencies and documenting & removing production blockers via change management, to release reports with a 40% reduction in production time and increased client satisfaction.5. Coordinated with 50+ clients quarterly to identify reporting needs and challenges, to work with 4 cross-functional IT teams to tailor standard production processes, resulting in an increased client satisfaction. Show less

Maryland, United States

1. Provided Tier 1 and Tier 2 level support, maintenance, and triage for the internal Loan Operation System (LOS), by assisting internal business users with Software Application queries on Jira, resolving 1000+ queries monthly.2. Worked cross-functionally with 6 internal departments within the Loan application life cycle to gather, refine, and validate stakeholder requirements and develop user stories to resolve inter/cross departmental business needs. 3. Facilitated User Acceptance… Show more 1. Provided Tier 1 and Tier 2 level support, maintenance, and triage for the internal Loan Operation System (LOS), by assisting internal business users with Software Application queries on Jira, resolving 1000+ queries monthly.2. Worked cross-functionally with 6 internal departments within the Loan application life cycle to gather, refine, and validate stakeholder requirements and develop user stories to resolve inter/cross departmental business needs. 3. Facilitated User Acceptance Testing (UAT) with 6 internal business departments to execute different functions, in order to communicate feedback to the Offshore IT team, resulting in a streamlined loan application process.4. Participated in the Software Development Life Cycle (SDLC) process by resolving tickets, managing 10 IT team knowledge base articles, and becoming a Subject Matter Expert in application-related issues. Show less

Pennsylvania, United States

1. Documenting business processes within trade compliance that lead to requirements of integration with tools such as SAP ERP and Salesforce.2. Develop test scripts pertaining to Master Data and transactional Data linked to business requirements such as customer and vendor screening or shipment management with modules such as Watch list screening and export management.3. Investigate and resolve client issues such as inability to load data for screening on OCR trade compliance… Show more 1. Documenting business processes within trade compliance that lead to requirements of integration with tools such as SAP ERP and Salesforce.2. Develop test scripts pertaining to Master Data and transactional Data linked to business requirements such as customer and vendor screening or shipment management with modules such as Watch list screening and export management.3. Investigate and resolve client issues such as inability to load data for screening on OCR trade compliance tool, unsolicited hits when screening an entity against the configured Denied Party List etc. Show less

Uttar Pradesh, India

1. Created a skill management system using the Django framework in Python to manage and facilitate trainings of employees and consequently maintain employee skillsets in the system for users: human resources, managers, and employees.2. Developed the database schema for the system incorporating tables such as employees, departments, employee skill-mapping, skill training, training feedback and training effectiveness.3. Defined metrics such as skill sets for employees in various… Show more 1. Created a skill management system using the Django framework in Python to manage and facilitate trainings of employees and consequently maintain employee skillsets in the system for users: human resources, managers, and employees.2. Developed the database schema for the system incorporating tables such as employees, departments, employee skill-mapping, skill training, training feedback and training effectiveness.3. Defined metrics such as skill sets for employees in various departments constituting skills and levels of proficiency for various departments.4 Constructed a process flowchart involving essential components of the system such as gap analysis, training assignment, training designation and training feedback through the users: human resources, manager and employee.5. Developed functionality to interact with the system through front end and back end (Django-admin) for actors such as employees, managers and human resources.6. Tackled Django’s ORM (Object Relational Mapper) to facilitate table join. As for example, joined the tables: employees, departments and empskillmapping to show the current skills various employees have in various departments. Show less

Greater Noida

1. Supervised by Business Analysts responsible for monitoring a Mobile Vehicle Applicationthrough it’s testing phases.2. Tested Vehicles (Remotely and on Field) with Android and iOS versions of the Application.3. Logged and checked bugs, as well as updating on the Tulip Agile Project Management Software.4. Understood practical aspects of the Testing phase including User Acceptance Testing of theSoftware Development Life cycle as well as working with use cases.

Master Of Science - Ms, Management Information Systems, General

Coursework in First Semester Spreadsheet Programming for Business Technical Consulting for Social Impact Database Management Systems.

Bachelor Of Engineering - Be, Computer Science