Systems Analyst Field Service

Jomy George

650-***-**** – ********@*****.*** / US Citizen.

www.linkedin.com/in/jomygeorge1

ACCOMPLISHED IT BUSINESS LEADER / Functional Consultant

Deliver end-to-end product solutions for large, complex, multiple site projects.

Worldwide functional/technical experience in Oracle EBS R12/R11i projects implementation and customization; including gap analysis, requirements gathering, process analysis, solution design, integration, testing (UAT/, knowledge transfer, and documentation using CEMLI/AIM Methodologies. Successfully performed data migration from legacy systems to Oracle applications, designed and delivered custom concurrent programs and workflows and created user manuals for the end users. Excellent analytical and design skills with a thorough knowledge of Object-Oriented Programming and WEB based applications. Versatile team player with excellent communication and interpersonal skills who works well with remote users and is an effective mediator between DBAs, Development team, End users and Stakeholders. Inquisitive problem solver who enjoys challenges.

Areas of Oracle Application expertise:

19 years of experience in Oracle E-Business Suite as a Functional Consultant.

5 Years of experience in product development with in Oracle Corporation, Redwood Shores.

Strong Functional/Implementation/Testing/Support experience in Service/Project Contracts, Subscription Contracts, Install Base, Inventory, BoM, Quoting, Order Management, Advanced Pricing.

Through knowledge of C2C (Contracts to Receivables Flow), O2C (Order To Cash), P2P(Procure to Pay), Field service, Mobile Field Service, Teleservice, iSupport, and Depot Repair, Core Contracts, Service Contracts, Subscription Contracts, Contracts Renewal, Subscription Billing process, Back billing process, Contracts Credit and Rebill process.

Expert level knowledge in User Story, Use Case, UML, Business Process Modeling Notation (BPMN), and Data Flow Diagram (DFD). Facilitated JAD Sessions, Expert in Agile and Waterfall methods.

Elicited project relevant requirements and business rules using various techniques (interviews, workshops, brainstorming, questionnaires).

Organized and documented requirements in accordance with industry standards (Business Requirements Document, Context Diagram, ERD/Data Model, Business Rules, Decision Tables, and Process Maps, User stories, Use Cases, and Activity Diagrams, Screen and Interface designs).

Responsible for documentations, setups, bugs, enhancement requests, collecting debug/trace files working with Oracle support using TAR and escalation to Oracle duty manager.

Involved in Project Management Activities like meeting stakeholder requirements, Prioritizing system problems, enhancement requests, scope management and status reporting to management.

Experience in Production support and Business process improvements.

Conducted Fit/Gap Analysis. Delivered CV40s, BR100s, MD50s and MD70s.

Experience in design of custom interfaces between Oracle Applications and external systems.

Proficient in designing and collecting requirements for CEMLI (Configurations/Customization, Extension, Modification, Localization, and Integration.), Implementation, Conversion, Data Migration, AOL, Custom Batch processes and Custom Web Design.

Applications Version worked on 11.5.x, R12.2.8, Legacy to EBS Conversions.

Oracle Fusion O2C, P2P, SCM, Subscription Cloud, Field Service Cloud.

Technical knowledge in Oracle database architecture, SQL, PLSQL, OA framework, (SOA).

TECHNICAL SKILLS

Databases : Oracle 19C, IDMS and DB2.

Software’s/Tools : PL/SQL, SQL, Oracle Developer, Forms 6i, Reports 6i, TOAD, SQL Navigator, SQL Loader, Designer, Workflow, JAVA, XML, C, C++, JIRA, OA framework, FBDI, HDL ADFDI, Page composer.

Other Applications: MS Excel, Word, Visio, Project and PowerPoint, Discoverer 3.1, UNIX, LINUX.

EDUCATION AND PROFESSIONAL DEVELOPMENT

Bachelor of Computer Engineering – (4 Year Degree).

Certification in Planning Quality in Project, Identifying and Managing Project Risk.

PROFESSIONAL EXPERIENCE

Client: Entrust Jan.2023– Present.

Role: Senior Functional Consultant / Solution Architect / Project Management

Project Highlights: Salesforce, Configurator, BOM, Inventory, Advanced Pricing, O2C, Install Base, Service Contracts (Subscription, RMCS, Usage), AR, AP, GL, FA, Inventory. EBS To Fusion Migration. Fusion Subscriptions, PIM, DOO, Service Logistics Cloud.

•Managed Offshore team, Coordination of Technical, DBAs teams. Exceeded Stakeholder expectations.

•JIRA, Confluence, Rest APIs, Web services.

•CEMILE, Conversions, Support, Custom Solutions, User Training.

•Working with Oracle support, SR/ SR Escalations, End to End Testing, Support.

•Stakeholder support, Page personalization, Data conversion from 3rd Party systems to Oracle EBS. CRP/UAT, Cutover activities and hyper care support. Service Logistics Cloud.

•Designed and implemented custom solutions and coordinating between cross functional teams.

•Migration of EBS R12.2.8 To Fusion (SCM, OFSC, Subscription), FBDI, ADFDI.

Client: Scientific Games Alpharetta, GA July.2019– Dec.2022

Role: Oracle EBS Functional Consultant / Solution Architect / Project Management

Project Highlights: CARBS (Casino Revenue Billing System) Oracle EBS R12, PLM, PIM, Inventory, O2C, Service Contracts (Subscription, RMCS, Usage and Service), OFSC, Service Logistics Cloud, AR, AP, GL, FA, Advanced Pricing, Smartsheet, JIRA.

•Conducted Fit/Gap Analysis. Conducted requirement workshops, Prepared Process Flows.

•MD050/CV040/BR100, BR30, System Design, Configuration & Implementation. Offshore management.

•Designed and implemented custom solutions for Billing, Credit N Rebill, Upload Templates, Royalty Statement, WAP Jackpot, Game Upload, NGR and Deductions, Billing Pre-Validation, Invoice Print and Invoice backing sheets.

•Custom business solutions using APEX, designed and implemented SAP BO report.

•Data Analysis, Designed custom conversion process from legacy system to EBS (Items, IB, OKS).

•Conducted user Training and created user training documents.

•Mock Conversion, Created Test Scripts, Conducted UAT, CRP, SIT. Prepared Production Cutover Activities. Configuration, DFFs, Value Sets, Multi Org Setups and Custom Responsibilities. SQL, PLSQL.

Clients: TKE, Hyundai, Starbucks Headquarters, Seattle, WA. Sep.2017– June.2019

Role: Oracle EBS Senior Functional Consultant (through Infosys Ltd)

Project Highlights: Oracle EBS R12, OM, Service & Subscription, Inventory.

•Worked with stake holders to collect requirements. Implemented supported usage and Subscriptions functionality using EBSR12.

•JIRA, Confluence, Rest APIs, Web services, Smartsheet.

•Tools used: TOAD, SQL, PLSQL and Postman scripts, QA HP ALM, Test Script, Test Backlog.

Client: Toshiba Global Commerce Solutions, Raleigh, NC with Centroid Oct.2016– Sep.2017

Role: Functional Lead Consultant (through Centroid Systems)

Project Highlights: Oracle EBS Upgrade 12.1.3 To R12.2.6, Inventory, BOM, Service Contracts (Service & Subscription), OM, Install Base, O2C, C2C, P2P, Field Service, OFSC, Teleservice, Depot Repair, iSupport, CRM Foundation/CRM Admin.

•12.2.6 Upgrade from 12.1.3, Workshops with Business and collected Business Process changes / requirements.

•Analyzing RCDs and conducting workshops with business.

•Prepared Presentations, Process Flows and Workshop contents.

•Conducted Fit/Gap Analysis. Prepared Production Cutover Activities.

•Territory Configuration and SR Routing, IB Architecture change.

•Designed Custom solution for Oracle Service, Install Base, Depot Repair and Service Contracts.

•Created Test Cases for In-Track, Cross Track and End to End Testing.

•Conducted INT Testing, UAT Testing for In-Track, Cross-Track and E2E Test Cases.

•Testing of ECI Inbound and Outbound with legacy systems.

•Used Service Now for INT Testing, OATS (Oracle Testing Suite) for UAT Testing.

•Coordinated between DBAs, Development, Business and Managed Stake Holders and Offshore team.

•Worked with Oracle Support for Functional issues, Escalation with duty managers.

•Tools used: JIRA, Confluence, Rest APIs, Web services, Smartsheet, OATS, Service Now, ECM, TOAD, SQL, PLSQL and MS-Office.

Client: Cross Country Home Services, Ft. Lauderdale, FL. Nov.2014– Aug.2016

Role: Functional Lead Consultant

Project Highlights: Oracle EBS R12.2.5, Inventory, Quality, BOM, WIP, Service Contracts, OM, Install Base, C2C (Contract to Cash), O2C, OFSC(Field Services), Teleservice, Depot Repair, BoM, Purchasing, CRM Admin.

•Discussed with Business and Gathering requirements for (SNAD).

•Analyzed Process Decomposition. Developed Solution Design Documents.

•Conducted Fit/Gap Analysis. Delivered CV40s, BR100s, MD50s and MD70s. Business Review & Sign-off.

•Designed Custom solution for Oracle Service, Install Base, Depot Repair, Service Contracts & Subscription and Quality.

•Converted requirements to Oracle Configurations/Objects. End to end Testing of O2C, C2C and P2P.

•Migration of configuration from instance to instance using tools.

•Configuration for Service Contracts, Tele Service, Inventory, Oracle Marketing, Flex Fields and Custom Profiles.

•Researched, Analysis, design and setup for Custom UWQ.

•Coordinated between DBAs, Development, Business and Managed Stake Holders and Offshore team.

•Conducted UAT/CRPs, Designed and Tested RICE components.

•Tools used: JIRA, Confluence, Rest APIs, Web services, Smartsheet, SharePoint, TOAD, SQL, DATA LOADER, PLSQL, Config Snap Shot, and MS-Office.

Client: HID Global, Irvine, CA. Jan.2014– Oct.2014

Role: Functional Lead Consultant through (Jade Global)

Project Highlights: Oracle EBS R12.1.3 Service Contracts, Install Base, C2C (Contract to Cash), O2C (Order to Cash), Receivable, Inventory, Teleservice, PIM, OFSC (Field Service).

Integration of Legacy systems EasyLobby and ActivIdentity systems with Oracle EBS.

Analysis of existing legacy system for conversion. Conducted discussions with Business groups.

Conducted Fit/Gap Analysis. Delivered CV40s, BR100s, MD50s and MD70s.

Identified elements for Mapping to Oracle business processes.

Completed configurations required for Service Contract, Install Base, OM and AR from contracts perspective.

Performed Data manipulations, Data load to Staging Tables, Migrated to Oracle applications using custom interfaces.

Conducted Install Base, Service Contracts conversion both functional and technical for US, EMEA & APAC.

Conducted CRP/UAT and End User training.

Managed offshore development team and Remote user assistance.

Tools used: JIRA, Confluence, Rest APIs, Web services, Smartsheet. Service Now, Share point, TOAD, SQL, DATA LOADER, MS-Visio, MS-Office.

Client: Tyco Simplex Grinnell, West Minister, MA. Jul.2013– Dec.2013

Role: Business Solution Architect

Project Highlights: Oracle EBS R12.1.3 Service Contracts, Install Base, C2C (Contract to Cash), Order Management O2C, Receivable, (OFSC)Field Services, Teleservice, Advanced Pricing, Task, Debrief, Charges, Inventory and Depot Repair.

DeliveredCV40s, BR100s, MD50s, Test Plans and Training Manuals, CEMLI (Customization, Extension, Modification, Localization, and Integration) of above modules.

Conducted CRP/UAT and End User training. Remote Customer assistance.

RMA, Order Management to Service Contracts and Install Base. Billing to AR Flows. Field Service, Contact Center.

Custom Design for 'Credit & Re-bill for consolidated contracts'.

Integration of activities between Development, Business and DBA / Release teams.

Functional design created for Service Power integration for NICE technician, Assisted Scheduler.

Functional Design and configuration for Inspection Resource Planning Inspection SR.

Government GSA (Inspection SR and Break Fix) SR Debrief / Charges customization

Functional Design for SR Back feed from FireMaster to ACE.

Functional Design for SR feed for Local SR from EBS to FireMaster.

UI design for SR with PMA contract Cancellation process.

Functional design created for 'FCS Control for Invoiced for PMA contracts'.

Data Analysis, Multiple Data migration from legacy to Oracle Apps using interfaces, Functional design of interfaces for Service Contracts, OM, Receivable, Advanced Pricing, and Depot Repair modules.

Testing / Trouble shooting of Custom APIs, TOAD. Testing Discoverer 11i reports.

Setups for Descriptive Flex Fields, Custom Profiles, Custom Concurrent programs.

Tools used: JIRA, Confluence, Rest APIs, Web services, Smartsheet.

Client: Cannon America (Canon Business Solutions), Jamesburg, NJ. Oct.2012– May.2013

Role: Functional Lead Consultant.

Project Highlights: Enhancement, Support and Data conversion of Service Contracts, Advanced Pricing, Install Base, Order Management, BOM, Inventory, Accounts Receivable, Field Services, Teleservice and Depot Repair.

Business requirement analysis, Conducted Fit/Gap Analysis. Delivered CV40s, BR100s, MD50s.

Worked with business users for Custom Web Solutions (eManage), Order to cash custom web solution using Oracle standard APIS in Order Management O2C process.

Testing and configuring of Install Base, Service Contracts, and iStore.

Conducted CRP, System Testing, Functional Testing, and Test Plans.

Implemented, Setup and Testing for Meter Reads (SM Copies, BW, Color, BW Small, BW Large, Color Large, Color Small) using Install Base, Service contracts.

Supporting Service Contracts, Service Request, Depot Repair, Order Management, Inventory and iStore.

Designed and implemented custom web Application (using Oracle standard APIs) for ordering supply Items (O2C cycle) based on Manufacturer, Product Family, Product Series and Model.

Through knowledge of TOAD, HP Kintana, Debug/Trace, TKPROF. Performance tuning of custom process, Reports and Concurrent Program Trace and worked with Oracle support.

Setups for DFFs, Implemented Custom Workflow, Custom Form, Custom Concurrent programs and Concurrent Request Sets. Conducted performance tuning, worked with Oracle Support/Duty Managers using TAR to resolve/escalate customer issues.

Employer: EPICOR SOLUTIONS, Austin, TX. Oct.2007– Sep.2012

(formerly Activant Solutions)

Role: Functional Lead

Project Highlights: R12 upgraded from 11.5.10 Service Contracts, Advanced Pricing, Install Base, Order Management, BOM, Inventory, Accounts Receivable, Field Services, Teleservice and Depot Repair.

Automated Contracts Re-pricing system reducing 240 hours plus labor-intensive bi-monthly process to 8 hours across multiple business units.

Streamlined customer invoices by eliminating billing errors and delayed invoices.

Business requirement analysis, gap fitment, Conduct CRP, System integration Testing, Functional Testing, Conduct UAT, AIM Documentation BR100, MD50, MD70, Training Manuals.

Detail understanding of Service / Core / Subscription Contracts related setup, Contracts Renewal functionalities, Service / Warranty/Usage and Subscription Item Setup, Service and Subscription Billing process, BOM Setups for Warranty contracts, Sales Order to Contracts process and Subscription to Order process.

Data Analysis, Multiple Data migration from legacy to Oracle Apps using interfaces Development and debugging of PLSQL API/interfaces for OKS, AR, OM, IB modules.

Managed, Customized and trouble shot Contracts Renewal, Authoring/Billing Issues etc.

Setup Managed and trouble shot Install Base System, Instance, Mass Update, Instance Expiry, Custom Process for Item end of Life and Extended Attributes.

Reduced the turnaround time for credit hold reinstatement by automating credit approval.

Personalized service contracts form, Service Request form, Contact center form, and Agent Dashboard HTML page.

Setups for Flex Fields, Implemented Custom Workflow, Custom Form, Custom Concurrent programs and Concurrent Request Sets. Conducted performance tuning, worked with Oracle Support/Duty managers using TAR to resolve/escalate customer issues.

Routed Service Requests based on SR Type, Problem Code etc.

Set up Territory Management Administration for Routing.

Implemented Service module for HR Department to comply with HIPAA using SR security.

Client: Ricoh Americas Corporation, Pine Brook, NJ. Nov.2006 – Sep.2007

Role: Functional Consultant.

Project Highlights: Implemented 11.5.9 WIP, BOM, Inventory, OM, Service Contracts, Advanced Pricing, Install Base, Accounts Receivable, Field Services, Teleservice and Depot Repair.

Functional Design: Met with Ricoh users to understand business requirements.

Conducted Fit/Gap Analysis. Delivered MD70s.

Implemented custom service agreement termination process. Customized billing process and created Invoices.

Configured changes to existing Meter Read Upload process. Processed meter correction for termination. Allowed non-active statuses for contract termination.

Supported Authoring, QA Process, Termination, Billing Contracts, Service Request and Depot Repair.

Created Credit Memo for wrong orders and adjustments, apply/unapply payment, complete invoice, and fixed auto invoice interface exceptions.

Support/Troubleshooting: Supported the system for the monthly, quarterly and annual billing. Trouble shot and fixed processes from Order Management to IB to Contracts and to AR. Supported Service Request and Depot Repair issues, fixed Unbilled Contracts, Termination and Rebill issues. Trouble shot Contracts activation issues.

Worked with Oracle Support and managed escalations with Duty Manager.

Worked on Gap Analysis, Functional Design and Technical Design Documents (MD050, MD070) using AIM (Applications Implementation Methodology).

Oracle Application 11.5.9 (Service Contracts, IB, Order Management Inventory, AR,AP,GL, SQL, PL/SQL, Forms6i, Reports6i, TOAD, Harvest (version control),Clear Quest(Bug tracking), SQL Navigator, Putty, FTP.

Client: Thomas Publishing, NY, NY. Jan.2006 - Oct.2006

Role: Functional Consultant (through Thought Digital)

Project Highlights: Implementation of 11.5.10 Service Contracts, Inventory, Account Receivable, Account Payable and General Ledger and supporting existing 11.5.9 Service Contracts, AR, OM and Inventory.

Data migration from legacy to Oracle Apps, Development and debugging of interfaces.

Business Requirements Analysis, Gap Analysis, Process mapping and Oracle Applications functional setup.

Reimplementation: Gathered and documented client business and business process.

Analyzing and fixing Service Contracts billing process. Working with Oracle support and Oracle on demand through to solve issues.

Creating Credit Memo for wrong orders and re importing using auto invoice, Adjustments, apply/un apply payment, Complete Invoice, Fixing Auto invoice Interface exceptions.

Production Support: Supporting the system for the monthly, quarterly, and annual billing.

Testing: Involved in the full functional setups and testing for TPCO.

AIM (Applications Implementation Methodology)

Worked on Functional Design and Technical Design Documents (MD050, MD070).

Creation of Custom views and setting up daily refresh for the same.

Oracle EBS 11.5.9 and 11i.5.10 (Service Contracts, IB, Inventory, Account Receivable, Account Payable and General Ledger), SQL, PL/SQL, SQL Loader, Forms6i, Reports6i, TOAD, SQL Navigator, Putty, FTP.

Client: Wyndham Worldwide Corporation, Parsippany, NJ. Oct.2005 – Jan.2006

Role: Techno Functional Consultant (through Bearing Point)

Project Highlights: Conversion and Implementation of 11.5.10 Service Contracts, iSupport, Depot Repair, Field Services, Teleservice.

Collaborated with legacy team to identify key data elements and mapping with FIS NextGen.

Validated data cleansing of legacy data as a pre conversion effort.

Produced Configuration and Functional documents for the conversion.

Configured price modeling to support billing existing customers using 11.5.10 Service Contracts.

Setups & Unit testing: Involved in the full functional setups and testing for FIS NextGen.

Worked on Functional Design and Technical Design Documents (MD050, MD070) using AIM methodology.

Service Contracts, Field Service, Depot Repair, Tele Service, Installed Base, P2P, O2C, AR, AP, GL and Knowledge Base), TOAD, SQL Navigator.

Client: Kyocera Document Solutions America, Fairfield, NJ. Jan.2005– Sep.2005

Role: Techno Functional Consultant (through IBM)

Project Highlights: Implemented 11.5.9 Service contracts, Service Request, Field service, Installed Base, Depot Repair, Tele Service, Marketing, Contact Center.

GAP Analysis: Completed Process Mapping. Developed the client specific Process Analysis Questionnaires. Prepared the Process and GAP analysis documents.

Migrated data from AS-400 for Service Contracts, Service Requests, Installed Base modules.

Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from the legacy system.

Created a custom API that converted the data into a Contract (Header, Service and Usage Lines, Covered Lines, Revenue distribution). Designed Interface tables, loaded sample data for unit testing. Defined counters in Installed Base for usage billing in service and contracts.

Developed, tested and implemented custom interfaces/API for data upload to Oracle Service.

Setups & Testing: Involved in the full functional setups for Service Contracts, and selected setups for Application Foundation module. Prepared the Setup documents for Service Contracts.

Performed the functional Test Plans for various scenarios and execution of the same. Prepared Test Scripts for the said modules.

Integrated Order Management, Account Receivable and Inventory with CRM.

Reports: Prepared the functional specifications and developed new reports to suit the business needs based on user requirements using Oracle Reports 6i. Performed the testing for that report.

Customized Oracle Vanilla Report to suit customer need.

Created Oracle views for Installed Base, Service Contracts, and Service Requests.

Defined value sets, Flex field, concurrent programs, report sets, registered custom build forms, reports and PL/SQL Procedures, Triggers and Packages and created executables in the development environment.

Reduced the runtime and increased efficiency through performance tuning for PL/SQL programs.

Methodology: AIM (Applications Implementation Methodology).

Worked on Functional Design and Technical Design Documents (MD050, MD070).

Training: Prepared and executed a detailed training strategy for end-users.

Developed detailed End-user Manuals for Install Base, Service Contracts, Service Request, Counters, Contact Center and Debrief.

Support: Supported users in production and Test Instances.

Executed Forms Trace and TKPROF and worked with Oracle Support through TAR.

Trouble Shooting and fixed various user errors to close the books on time.

Oracle EBS 11i.5.9 (Service Contracts, Field Service, Depot Repair, Tele Service, OM, AR, Territory Management, Installed Base, Purchase Order, Account Receivable and Knowledge Base), SQL, PL/SQL, SQL Loader, Workflow, Discoverer, Forms6i, Reports6i, TOAD, SQL Navigator, Unix.

Employer: ORACLE Corporation, Redwood Shores, CA. Mar.2001 – Dec.2004

Role: Senior Application Engineer.

Worked at Oracle Headquarters in all phases of Product development and support of Oracle Applications 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10 (CRM Foundation, Service Contracts, Core Contracts, Contracts Intelligence, Subscription, Field service, Tele Service, AR, AP, GL, Territory Management, Quoting, OM.

Analyzed MRD and delivered HLDs, DLDs and Design documents for various Oracle Products.

Completed the feasibility study and effectively communicated with upper management for design approval.

Generated Design Specification as per Oracle Quality Standards to achieve business requirements for the product development in Oracle Service family of products.

Integration Contracts, IB and Oracle Service Modules in Internal Instances (Development, Acceptance, Quality and Certification Environments).

Documented issues, provided bug fixes and release patches via Metalink, and performed Root Cause Analysis.

Service Contract, Core Contract; Install Base, Oracle service Integration with Order Management, Account Receivable, and Purchase Order with other ERP Modules.

Supported various customer issues and conducted OWC and troubleshooting.

Supported Oracle World Wide Production (Oracle GSI) for various issues.

Worked closely with performance management team to resolve high volume transactions performance issues.

Communicating with customers through Bugs, Trouble Shooting and Conducting ODC (Oracle Direct Connect).

Oracle EBS 11.56, 11.5.7, 11.5.8, 11.5.9. Windows 2000/Linux/Sun Solaris with RDBMS Oracle9i, FORMS 6i, Reports 6i, Application Object Library, Java, OA Framework, ARU, SQL Navigator, Metal ink, Exceed, FTP, Excel.

REFERENCES

Available upon need

Contact this candidate