Ajay Ambrose Rodriguez

Identifying Opportunities through Comprehensive Analyses and Research:

• Collaborating with leadership to conduct in-depth analyses of financial statements, pinpointing potential areas for growth and improvement.
• Utilizing internal teams to thoroughly research prospective client businesses, compiling a detailed fact-pack to inform strategic decisions.

Independent Diligence Phase:

• Defining the scope of opportunities within specific business units
• Key responsibilities include:
• Applying functional and industry expertise to steer effective problem-solving.
• Extracting valuable insights through meticulous analysis of client data.
• Developing exemplary initiatives based on early identified quick wins.
• Drawing insights from interviews with internal and external experts.
• Coordinating the IDP (Independent Diligence Phase) readout to ensure clear communication of findings.

Bottom-Up Planning Phase:

• Overseeing Transformation Office (Transformation office) Operations, including:
• Crafting a detailed bottom-up planning cadence.
• Establishing the Transformation office infrastructure, covering:
• Solutions: Ensuring the capability to execute through coordination, training, and Transformation office clinics.
• Cadence: Organizing Transformation office(TO) , Steering Committee, and other pivotal meetings.
• Managing Health Communication and TO Finance workstreams.
• Co-developing a comprehensive guide for initiative tracking.
• Facilitating ideation sessions with workstreams and delivering specialized 'L-gate' training sessions.
• Collaborating with workstreams and Initiative Owners (IOs) to construct robust business cases.
• Partnering with TO Finance to create transparent financial views of the transformation using Wave dashboards.
• Conducting sequencing sessions to ensure strategic alignment.
• Finalizing the Bankable Plan and coordinating the bottom-up plan readout.

Implementation/Execution Phase:

• Managing TO Operations, including:
• Designing an effective implementation cadence.
• Overseeing changes in Wave to streamline implementation.
• Providing advanced training on Wave tools.
• Adjusting meeting cadences as necessary to maintain momentum.
• Leading and supporting TO meetings to drive implementation and preparing for ExCo meetings.
• Assisting TO Finance in establishing and conducting Monthly Value Analysis (MVA) sessions.
• Helping workstreams refresh their initiative pipelines.
• Assisting IOs in tracking key performance indicators and initiative values. Introduced new technologies to streamline operations, resulting in increased efficiency and improved workflows across the organization.
• Resolved conflicts within teams effectively so as to maintain a harmonious work environment and achieve organizational goals.
• Established successful partnerships with external organizations to foster collaboration and drive mutually beneficial outcomes.
• Improved customer satisfaction rates by analyzing feedback data and implementing targeted initiatives aimed at addressing key areas of concern.

• Developed a standardized version of Excalibur Lite, a PMO tool which can be used as quick deployment of end-to-end solution for project management which has been deployed in 69 clients and earned 100k in the first 3 months of go live
• Helped the operations team of leading packaging manufacturer deliver a 350 Million in recurring savings by successfully revamping their financial and operations performance review process by developing a data visualization and data engineering capability at the client and enabled a mindset transformation regarding use of new tools and technology
• Built a complete financial dashboard to measure the performance of the transformation on tableau through various lenses and was able to create the first view of the actual performance of the workstreams on the program management tool
• Coached the client TO lead to restructure the agenda and the flow of the TO meetings to drive more accountability and solve problems with an action driven approach
• Helped relaunch the TO cadence to drive more workstream level performance discussions
• Collaborated with IT teams to develop custom solutions that addressed unique knowledge management challenges within the organization.
• Optimized team collaboration by developing appropriate policies, procedures, and guidelines for knowledge sharing.
• Supported enterprise-wide initiatives by providing timely access to relevant documents and resources through efficient search tools.

• Learned the overall transformation process recipe and combined it with the prior data analytics experience to standardize tools and processes and help in generating basic insights
• Managed multiple projects simultaneously, ensuring timely completion within scope and budget constraints.
• Supported business development, research and marketing as part of go-to-market analysis.
• Actively contributed to ongoing knowledge sharing initiatives by authoring articles for internal publication.

• Developed a tool (in MS Excel and SAS) for a major retail chain that automatically creates reports to study the performance of stores in terms of Finance, Store Safety and Internal team performance that in turn helped the clients in identifying potential problems and taking informed business decisions to counter them
• Worked on identifying and quantifying the impact of factors that affect the Supplier Order Plan Accuracy of one of Australia’s leading retailer

o Created a tool attributing the impact of factors for each item allowing the stakeholders to pin point areas of concern

o Linear regression was used for attribution model, Univariate and Bivariate analysis were performed in the course of the project to identify the right factors

• 
  
• Developed a tool which measures the effectiveness of the catalogue promotions to estimate the weekly performance of promotions. The tool helped in deciding the best performing products to be retained in the catalogue and the ones to be removed
• Created several reports to analyze the performance of different types of promotions for retail stores across the country
• Helped a large retailer to validate its supplier’s cost price increase requests. Validation was done by analyzing the percentage composition of each ingredient of the product and the price movements of the ingredients for the past 10 years. An excel tool was built to automate the entire price increase validation process
• Product assortment planning the goal of the project is to recommend the most suitable products to be ranged in the retail stores based on the performance of the products.

o The performance was measured by calculating a cumulative performance index (CPI) which was calculated using different metrics like sales, fifth margin etc which impacted the business most

o After proposing the range, capacity of products to be stored on the shelf in the store was calculated. Based on the capacity, the linear space required for each product was calculated