Vishal Patel

IT Services Consultant (Functional/Technical) (10+ Yrs. Exp)

Phone: 281-***-****

Email: ad013n@r.postjobfree.com

PROFESSIONAL SUMMARY

Proficient Senior consultant and developer with 10+ years of experience working with object-based programming languages, SQL, and project management services. Analytical, motivated, organized, and eager to learn new skills and employ existing skills. Seeking to further my depth of knowledge and experience in software development in a professional environment. As a consultant I have experience in both the functional and technical aspects, specifically within the energy industry with an emphasis in business analysis, and support. Through various clients and projects I gained experience with Polymers, Crude, Midstream/NGL and Refined Product commodities within the ETRM industry. My previous projects required work in multiple systems and areas, which has instilled a strong work ethic and helped adapt to changing environments and technologies. As a result, I have working knowledge with RightAngle S10, S11, S14, S15, Endur V9.1, SAP, Power BI, ZaiNet, and Veson IMOS v6.

SKILL SUMMARY

LANGUAGES/Runtime ENV’s, Tools

Industries (Energy & Financial)

APPLICATIONS/DEVELOPMENT TOOLS (ETRM/Other)

Java, C#, C++

Python

SQL, PostgreSQL, Oracle PSQL

JavaScript

REST, SOAP

JSON, XML, XSL, XPATH, XSLT

CAD

Polymers

Crude

NGL (Commercial & Refining)

Refined Products

Marine

Commodities Trading

NYMEX

OpenLink RightAngle

OpenLink Endur

SAP

Power BI

Vesson IMOS

COIN

Zainet

OpenLink Race Tool

MS Visual Studio

MS Office Suite

Oracle SQL Developer

AutoCAD

Business Consulting

PROJECT MANAGEMENT TOOLS

Management Utilities

Business Process Redesign

System Configuration

Training Development

Requirement Gathering

Testing

Project Reporting

System Design

CLARITY PPM 14.X,15.X

Clarity Studio

Power BI

AD Hoc, Jasper Studio

XOG, NSQL, GEL, REST

Query, InvokeAction, Object API’s

Clarity Workbench

Jira, Rally

ServiceNow

MSSQL Mgmt. Studio

Oracle Enterprise Manager

Ubuntu, Red Hat, Centos

SVN, GitHub, Bitbucket

VirtualBox, Hyper-V, VMware

PROFESSIONAL EXPERIENCE

IT IGNITE

CA PPM CLARITY FUNCTIONAL/TECHNICAL/BUSINESS ANALYST

March 2023 – present

Triosoft Technologies Pvt LTD March 2023 – Present

Business Function: Primary Role on this project is being responsible for managing the Clarity PPM system, including configuration, customization, and administration. As the Clarity specialist I work closely with project managers and stakeholders to ensure that the system is meeting the needs of the organization.

Configured and customized Clarity PPM to meet the needs of the organization

Administered the Clarity PPM system, including user management, security, and system maintenance

Collaborated with project managers and stakeholders to gather requirements and ensure the system is meeting their needs

Developed and maintain reports and dashboards to provide visibility into project performance

Provided training and support to all Clarity PPM system users

Tested reports that were converted from Business Objects to JasperSoft

Created Ad-Hoc views

DISYS

POLYMERS DIGITIAL INSIGHT (PDI) BUSINESS ANALYST

April 2022 – February 2023

Shell Oil Company (Houston, Texas Woodcreek) April 2022 – February 2023

Business Function: As the primary BA, I primarily focused on business intelligence and reporting technologies/methodologies as well as performing data manipulation and cleansing to prepare datasets for visualization.

Assisted in the delivery of quality solutions using Microsoft Business Intelligence tools (Power BI) and related technologies.

Partnered with PDI customers and technical team members to assist with requirements definitions, solution designs, technical architecture, and delivery of PDI customer dashboards and reports

Implemented solutions using Microsoft Power BI tool suite and related technologies

Leveraged database systems including data warehouses, data marts, and models needed for business, financial, and operational analysis and/or reporting

Developed reports, dashboards & scorecards, data exploration, and visual analytics using existing and emerging technologies and tools

Developed high performing, reliable, and scalable solutions using and leveraging existing data and manual data sets

Clearly communicated technical details to business and management staff

Performed data analysis which supports and enhances Shell information management systems and services

Authored and oversaw design documents for approved projects

Provided meaningful feedback and coaching of other team members in the use of Microsoft Power BI and related technologies

Provide insight and recommendations on new and emerging technologies and concepts to PDI team members

Performed other duties, as needed

IT IGNITE

CA PPM CLARITY FUNCTIONAL/TECHNICAL/BUSINESS ANALYST

February 2019 – March 2022

National Cancer Institute (Washington, D.C.) Februrary 2019 – March 2022

Business Function: Primary Role for this project was to leverage my Technical CA PPM knowledge to translate business requests to Functional design. Demoed and implemented modules. Also, worked with the support team and assisted in troubleshooting issues that required complex troubleshooting.

Requirements mapping to CA PPM Clarity to fulfill business needs

Host design and implementation meetings

Implemented Cost Plans and Budget Plans

Demo / trained users on the use of Cost Plans

Restricted Charge Code on the Task Object so PMs couldn’t change it manually without an approval from Finance

Normalized all employee overtime in CA PPM so costs and Cost Plans could reflect accurately

Demoed the difference of doing normalization by using the Transaction Date vs Posted Date

Secure financial data that was exposing rates and other confidential information in JasperSoft

Created Test Scripts in HPQC (HPALM)

Managed Grooming sessions

Trained Support team on infrastructure and administration of CA PPM

Demo Portfolio Management module

Minimized the number of roles to less than 60 from over 250

Tested reports that were converted from Business Objects to JasperSoft

Created Ad-Hoc views

MRE CONSULTING

SENIOR CONSULTANT

July 2010 – November 2018

Phillips 66 (May 2012 – November 2018)

Business Function: Senior Consultant in the Commercial Business Services group at Phillips 66. This required work as part of a team that upgraded the RightAngle S14 environment to RightAngle S15 for the Crude business, and also migrated the Midstream/NGL business from RightAngle S10 to the same RightAngle S15 instance. Prior to that, I worked on projects to migrate the Crude business from an in-house application to RightAngle S11, and projects to streamline the Crude inventory reconciliation & reporting and tariff process. My responsibilities included:

Functional analysis and design documentation for custom reports/processes

Managed analyzing, cleaning and migrating various RightAngle data elements required for deal entry, which needed substantial redesign according to project designs and RightAngle system change

Conducted integration, CFT and UAT testing through various system upgrades and implementations

Delivered training to various users during system upgrades and implementations

Developing training materials and desk manuals for various maintenance modules and reports for RightAngle S11, S14 and S15

Guiding approximately 30+ users through the cutover processes and business validation for go-live

ConocoPhillips / Phillips 66 (Augusts 2011 – April 2012)

Business Function: Senior Business Analyst in the Commercial Integration group at ConocoPhillips and Phillips 66. This required work with ~40 resources across different groups to support daily & monthly production issues within various ETRM systems. My responsibilities included:

Production support for RightAngle, SAP, COIN, IMOS and ZaiNet

Supported the creation, modification and execution of various deal types (Blend, terminal, sales, etc.) in RightAngle

Support of Commercial Marine business in IMOS (Barge, Vessel, Boat and Contact creation and modification)

Worked in various areas of Commercial Integration before and after transition including M&MA and Data Center

Vendor/Customer setups in COIN and SAP

Trained various team members during transition in multiple systems

CFT and FIT testing in various trading systems during upgrades and transition

BG Group (July 2010 – July 2011)

Business Function: End of Day (EOD) Workflow Process Support

As a junior business analyst, I was responsible for executing the EOD process and providing support for Open Link Endur V9.1. This required working with a group of ten resources to ensure the daily EOD process successfully completed prior to the next day of business. My responsibilities included:

Executed the EOD process including running simulation, VaR, cube processing and RTPES

Supported the EOD process including troubleshoot errors and issues

Rolled Endur’s business, trading and process dates at EOD completion

Workflow load balancing across all appservers to improve EOD efficiency

Proactively monitored of script executing times for upward trending workflows

Proposed and documented process improvements for EOD protocol along with creating as-is EOD process documentation

Communicated changes and expectations across groups related to EOD process

Trained new EOD team members

PPM ESSENTIALS

CA CLARITY TECHNICAL CONSULTANT/DEVELOPER

February 2009 – July 2010

Business Function:

As a business analyst and junior consultant, I worked on projects to implement and support various CA Clarity Studio customizations. My clients included Wells Fargo, Turner Broadcasting System, and EPMA Group. My responsibilities included:

Worked as a developer for interface projects using JAVA special loads from DB2 databases

Created stored procedures and functions to support CA Clarity and provide simplified access to data via reports, portlets, and jobs

Worked with CA Clarity Studio to create objects, attributes, portlets, and portlet pages

Wrote technical design documentation for interfaces and CA Clarity Studio development

ACCENTURE

CA CLARITY TECHNICAL CONSULTANT/DEVELOPER AND INTERN

March 2005 – November 2008

Business Function:

I began as an intern with Accenture and transitioned to junior consultant. My clients included BBVA Compass, Comcast, and Toyota Financial Services. As a junior consultant I worked on projects to implement and support various CA Clarity Studio customizations. My responsibilities included:

Worked on custom portlet development using NSQL queries

Wrote stored procedures to support scheduled Clarity jobs

Used XOG to move data from development, pre-production and production to support development efforts

Worked with support tickets

Education and Certifications

Formal Education

Texas Southern University

BS in Computer Engineering Technology

Industry certifications

Certified Broadcom Clarity Administrator

Business Objects XI Certification

Currently training to obtain ServiceNow Administration Certification

Contact this candidate