Rathin Gupta Email & Phone Number

Calgary, Ab, Ca

Calgary, Alberta, Canada

Calgary, Alberta, Canada

Calgary, Alberta, Canada

- Led the execution of future state vision and solution for all Refined Products business operations, incorporating business requirements, target state business model governance, gap analysis and solution modeling. Managed the vendor teams and business SME’s through the execution and go-live.- Led the crude business scoping activities as part of the integration effort of the two legacy projects at Husky and Cenovus. Worked with the business stakeholders to finalize the crude implementation scope.- Domain expert in front and mid office risk strategy. Led the solution design for Crude, Refined products, NGL, Natural Gas and Grains businesses to ensure standardization of processes across all commodities.

Calgary, Canada Area

- Led a team of 5 consultants to aid a Canadian integrated oil and gas client design future state business processes and strategic roadmap for digital transformation of the downstream trading, supply and logistics business. Assets covered included: Pipelines, Terminals, Natural Gas Storage, Refineries and Natural Gas Processing Units.- Supported the Canadian Integrated Oil & Gas client through the technology platform selection process. Served as cross commodity subject matter expert during sessions to ensure alignment to future state vision.- Led a team of consultants to aid a Canadian Natural Gas and NGL producer and marketer identify future state business processes and requirements for their downstream CTRM business functions. Led the overall effort for CTRM system selection based on their future state business requirements.

Calgary, Canada Area

Project Delivery/Solution Design:- Delivery/Product Manager for a Fortune 100 Oil & Gas company to manage their pipeline assets management solution. This includes designing a product for their Order to Cash management and create a better user experience for the customers that move commodities through their assets.- Presenting member of RFP team that successfully developed and landed client proposal leading to Sapient being chosen as vendor for critical multi-year project.Energy Trading Risk Management (ETRM):- Led design and implementation for a fuel marketing & distribution client of their trading and risk management solution (Allegro).- Identified “Cost of Customer Relationship” costs by leading design of tableau dashboards on top of trading & supply data. Presented KPIs to President, CFO & VP-Business Development of a fuel marketing & distribution organization.- Led business design for a Natural Gas Trading organization to optimize utilization of new contracts with the pipeline counterparty. (Openlink Endur)- Led Business design for a power system operator to enable stronger digital interaction with the counterparties. Ran workshops with the counterparties to discuss ideas to increase user experience and journey through the process.Optimization/Analytics:- Model the complex Natural Gas Processing Business as a Linear Program Model using mathematical equations. Created a proof of concept optimization model for a midstream client- Solve the model using LP Solve and CBC.- Led a team of five consultants to model the liquid fuel marketing & distribution business into an optimization solution. Designed interactive dashboards around the optimization results. Results ranged from optimal supply opportunities, least cost routes and most profitable demand centers. - Lead presenting member of the RFP process for 3 major optimization projects.

Houston, Texas Area

Business Transformation/Business Process Re-Engineering:- Assisted a Fortune 100 midstream client to identify if all the crude, NGL and refined products midstream assets (includes pipelines, storage & terminals) can be combined into a single standard order to cash business process.- As part of the project, output was a roadmap of how the project will be executed and how the various assets can come on a single platform for order to cash.- Ran 100's of workshops/interviews with executives and facility operators across various client offices and functions to understand current world pain points.- Constructed business models to validate the future state process flows and finally presented to the client stakeholders.- Mentor a team of analysts by conducting training sessions, reviews and feedback sessions.- Involved in building the team for projects by conducting interviews.

Houston, Texas Area

Energy Trade Risk Management (ETRM):- Create a Natural Gas Profit and Loss Valuation Model for Historical Trades.- Create an optimization model for Natural Gas Storage Hedging Strategies. The model included Operational Constraints as well as pricing strategies to identify best withdrawal and injection schedules.- Create an excel model to analyze power cost components so that the client could identify opportunities to operate with NEISO and NYISO. The model also included forecasting the power cost components. - Business Process Optimization for Natural Gas Storage

Houston, Texas Area

Supply chain/Logistics for Oil Companies:- Analyzed the Terminal Forecasting spreadsheets for a refinery and provide solutions for better optimization of the terminal assets.- Analyzed the refinery terminal operations to see the impact on Financial control, Customer Allocation, and Marketing groups. Making recommendations for better business processes.- Analyzed the supply chain and logistic operations of a Canadian Oil and Gas pipeline firm.- Analyzing the complex business processes of the client and make certain recommendations to improve business goals.- Influence client teams with the planning and design of business processes and systems.- Generate recommendations and changes in order to improve and support business activities.- Articulate the business activities and present to a group from client management.

Houston, Texas Area

- Built a financial model using microsoft excel to analyze the financial worth of oil and gas company.- Built a financial model to help refinance a bond and structure it at a lower coupon rate.- Experience in conducting reserve and financial analysis to determine the credit worthiness of oil and gas firms. - Conducting in-depth analysis of the E&P sector for potential M&A targets. Make recommendations based on the reserach conducted. - Conducted in depth analysis of the mid stream sector and analyze the potential targets for acquisition. Recommended 10 companies for potential acquisitions of which 3 were pursued further.- Analysis of corporate financial transactions and credit exposure. Due diligence on the financial analysis process. - Developing income and cash flow projections, as well as risk adjusted profitability models for existing and prospective clients.- Interacting with senior management to help build and maintain relationships and information flow with the clients by preparing pitch books and other related documents.

Houston, Texas Area

- Analyzed the midstream sector to identify two to three suitable sub-sectors to help a portfolio company diversify it’s product offering.- Analyzed the competitive landscape of companies within these selected sub-sectors to identify three to ten potential acquisition candidates.- Conducted a thorough analysis of the candidates to ascertain any synergies and the best candidate to acquire.

Business Process Improvement for Bank of America (North American Operations)

Panipat, India

Analyzing Process Flows at the Panipat refinery

Master Of Business Administration (M.B.A.), Finance And Accounting

Activities and Societies: -Awarded a Jones student scholarship -Joint Director of Jones Student Association -Vice President of Asian.

B.E., Chemical Engineering

Activities and Societies: Student representative of the Placement Cell Coordinator for the department magazine "Tatva"Graduated with Honors