Kapil Gupta

Sr. Business Consultant /Sr. Project Manager

Email : ac2z2s@r.postjobfree.com

Phone : +1-713-***-**** (M) / +1-281-***-**** (H)

LinkedIn : https://www.linkedin.com/in/kapsgupta/

Immigration Status : Permanent Resident/Green Card

PROFESSIONAL SUMMARY

16+ years of IT experience in Energy (Oil & Gas), Chemical, Utilities and Manufacturing Domain. Have extensive experience in Crude to Customer Value Chain Optimization, Refinery Scheduling, Planning, Vessel and Wharf Optimization as Business Consultant and Analyst. Have 7+ years of experience in leading large 50+ member team. Experience includes -

- Business Analysis and Consulting

- System Integration

- Migration and decommissioning

- Program and Project Management

- Onsite Offshore team management

- Solution Design

- Data Quality Management

- Master and Meta Data Management

- User Adoption Improvement

- User Experience Management

- 3D modeling

- Engineering Design

- Analytics and visualization

- Application Development

- Offshoring

- RPA (Robotic Process Automation)

SKILLS

Quick Learner with ability to grasp Business/Domain knowledge and newer technology

Ability to work independently and adapt to change in objectives, strategy, process, and schedule

Excellent relationship development and management skills, both internal and external to the organization

Strong Analytical ability with excellent communication, interpersonal and team skills

Team Management and leadership experience working with CXOs

Building stakeholder participation and ownership of the evolving business case

Knowledge of Software Development Life Cycle (SDLC) methodologies like Waterfall & Agile

Business process analysis and its integration with operational strategy development

Solution conceptualization to design, prototyping including UXM and visual modeling

Experience in preparing of documents such as Business Requirements, System Requirements, System Functionality

Compile and validate data; reinforce and maintain compliance with corporate standards

Skilled in creating UML Diagrams like Use Case diagrams, Activity Diagrams, Work Flow Diagrams

Expertise in writing and implementing Test scenarios, Test cases, System testing

Strong skills in Microsoft Technology including hands on development experience in Core ASP.Net, VB.Net, C#, Silverlight, Classic ASP, VB 6.0, HTML5, Excel VBA, Java Script, XML, SQL Server and OSISoft PI

Experience working with in Oracle, Teradata and SQL Server, can understand and write complex SQL queries

Good Experience in working and configuring AspenTech MBO (Multi Blend Optimizer), APS (AspenTech Petroleum Scheduler), M3 SIMTO. Understanding of Lab management system i.e. StarLIMS

Hands on experience in TIBCO Spotfire (including scripting), Microsoft Power BI (including DAX) and Crystal Reports

Knowledge and Experience working on RPA (Robotic Process Automation) tools, i.e. UIpath

Experience in IBM DataStage, WebMethods EDI Data Mapping, CA Siteminder, SAQQARA Catalog Management

Proficient with Windows, Mac OS, Microsoft Office Suite (Word, Excel, PowerPoint, Outlook), MS Project, Visio

Well versed with AutoCAD, 3DS Max, Adobe Creative Suite CS6-Photoshop and Macromedia Flash development

Understanding of SAS, Python and R Programming

PROJECTS DETAILS

Project:

Project Lynx - Supply Chain Visibility Project, and Chevron Pipeline Business Support System

Client:

Chevron Corporation, Houston TX

Duration:

Jul, 2007 – Till Date

Role:

Refinery Business Analyst / Sr. Project Manager

A Global Downstream initiative to implement targeted, optimized and sustainable improvements in the fuel supply chain processes, technology and organizational capabilities.

From technical perspective, project was to create a warehouse for the Chevron's downstream production data and to generate reports for business users to enable them to make quicker business decisions optimizing returns in terms of operational excellence and financial benefits.

Lynx was focused on providing the capabilities necessary to achieve supply chain optimization. These capabilities include supply chain information visibility; improved supply chain planning and scheduling solutions; and improved system-wide forecasting.

The Lynx Refinery Release (LRR), a core component of Project Lynx designed to standardize and improve the quality and capabilities of fuel blending and scheduling processes.

Performed dual roles, as Refinery Business Analyst and Sr. Project Manager for parent company –

Duties performed as in Refinery Business Analyst Role -

Find opportunities for IT simplification, integration, efficiency improvements and system/process automation

Developed Visualizations and Dashboards on Spotfire and Power BI, for users, global process advisors and for requirement analysis

Create and maintain material, tank, stream and property translation mappings between various refinery systems

Data Quality improvements via tool, process, rules, infrastructure and system enhancements

Business application support to core refinery users in the area of Fuel Blending, Refinery Scheduling and planning in multiple geographies – US (including Hawaii), Canada, South Africa and Asia

Designed integration jobs, user interface tools, application to support various business processes

Conceptualize and create prototype of various analytical reports to help business decisions

Plan and implement strategy for migrating business users from Old Tools to New System

Help in User Adoption and support of the new systems

Participated in architectural transformation projects, and platform migration

Product Lift report in Spotfire, potential savings of 9 MM /year

Data Mapping dashboard to compare mapping between various systems and remove errors

Blend Auto reconciliation, simplification and manual effort reduction

Conducted workshops and sessions for requirement gathering, brainstorming

Requirement gathering and solution design for multiple tools/applications i.e. Data Validation and mapping tools, Pre and Post Blend processing tools, Wharf Management etc.

Travelled to multiple refinery sites and build relationship with key and power users

Duties performed in Sr. Project Manager role –

Managed, Managed service engagement worth 6+ MM USD

Lead 50+ members team for 5+ years

Lead teams working on multiple development and support projects (Different subject areas – Sales & Operational Planning, Price Forecasting, Product scheduling, Refinery Blending, Refinery Scheduling)

Transitioned Development projects to run support

Setup offshore development team in Hyderabad India, and grew from 1 member to 11 members in 5 months

Managed project activities utilizing Chevron’s CPDEP process, work breakdown structure (WBS), critical path analysis, Risk/Mitigation Management

Prepared complete, accurate, and timely communications to all project stakeholders

Facilitated, coordinated, and managed meetings, briefings, written reports, and project milestones/deliverables for the highest levels of client management.

Project delivery /support metrics and presented to Governance council on quarterly

Participated with Sales and Presales team in responding to RFPs and RFIs, and in proposal defense

Reorganized and transformed client team/org structure to be more efficient, and to improve org capabilities

Worked with IT Managers and CIO on moving tradition support to Agile support model

Conducted workshops and meetings with client CXOs during India center visits

Project:

Work Order, Team and Financial Management Project

Client:

BP, Houston TX

Duration:

Jul, 2005 – Jul, 2007

Role:

Sr. Technical Consultant / Business Analyst

Scope for the first project was to rewrite old application written in Classic ASP to ASP.Net for Finance Control & Accounting Group. This application was to manage teams, work orders, time and cost. This application serves more than 800 users globally.

Also worked on various other projects on Management of Change and Asset Management

Involved in understanding the domain and supporting the system during system appreciation phase

Transition of the existing system from a different vendor

Requirement gathering, prototyping, estimation and Full Software Development Life cycle (SDLC) till Implementation and maintenance

Application run support, maintenance & enhancements and release management

Co-coordinating with business users and offshore team

Project:

Optimization Platform for Major Power Company in Houston, TX (USA)

Client:

Calpine Corporation, Houston TX

Duration:

May, 2005 – Jul, 2005

Role:

Sr. Technical Analyst

Optimization Platform is a very complex web services based system which used to get data from various sources and plants to suggest best performance parameters. It used BizTalk server query orchestrations to get data asynchronously from various data sources.

System appreciation and documentation

Worked with Infrastructure team to set up a new separate development environment

Bug fixing and enhancements at client site

Development of the System Test cases

Plan Strategy to publish the changes to Production

Performance analysis of the existing system and the framework

Architecture assessment of existing system and shared recommendations

Project:

User Registration & Intranet Applications Development and Support

Client:

Eastman Chemical Company, Kingsport TN

Client:

Sep, 2001 – May, 2005

Role:

Sr. Programmer Analyst

First project included development and maintenance of Complaint Handling System for company’s supply chain management system. This application manages a work flow to track customer complaints and track them until resolved.

Second project included development, testing and support of document mapping between iDocs and EDI (Electronic Data Interchange) using WebMethods. Purchase orders and receipts were sent and received through this.

Third project included enhancements and bug fixes for the company’s intranet and internet site registration. This also included Outlook integration and Role page maintenance.

A new site to upload and download files (similar to FTP) but with a better User Interface and integrated Reporting and time sheet was also developed as part of this big project.

Completed customization of Catalog Management tool and globalization for the chemical products.

Developed several mini sites to describe company’s polymer products and collect feedback from end customers.

Involved in full Software Development Life cycle (SDLC) from Analysis, prototype Design, Development till Implementation during application enhancement

Involved in bug fixing at client site and also some of the enhancements

Follow and coordinate with various team on upcoming releases

Create and implementing document mapping between iDocs and EDI

EDUCATIONAL BACKGROUND

B.E. (Arch) from Indian Institute of Technology (IIT), Roorkee, India (Year 2001)

- -

Contact this candidate