fbpx Prashant | DevReady

Let’s Get Started

Prashant
HirePrashant

Prashant

Fremont, California --:--:--

Prashant is a Talend Consultant with 20+ years of experience with Oracle EBS Application 12i/11i in various roles including success in the finance and supply chain management modules.  He is accomplished in handling large implementation projects and leading offshore teams.  Prashant has developed complex Talend services and integrated various disparate systems together, and modernizing systems.  He also has good experience developing SOAP/REST web services as well as skills in all stages of the project life cycle.

Hire Prashant
Skills
Years
1
2
3
4
5
6
7
8
9
10+
Oracle ERP
MFT
Talend
Git
Oracle SOA
SQL
SaaS
Workday
XQuery
BPEL
PL/SQL
ServiceNow
XPath
SVN
XML
Salesforce
M5
Toad
GetPaid
Shell Scripting
SQLPlus
SFTP Server
Reports 6i
Unix
Forms 6i
BI Publisher
Kintana
SOAP
Mercury
REST
Cisco
PVCS
SQL Loader
HTML
C
JSON
Developer Personality

Independent

Collaborative

Trailblazer

Conservative

Generalist

Specialist

Planner

Doer

Idealist

Pragmatist

Abstraction

Control

100
50
0
50
100
Feature Experience

Integration Services

Data Model Design

System Migration

SOA

MODERATE
EXTENSIVE
EXPERT
Cultural Experience

Social Networks

Financial

Supply Chain

MODERATE
EXTENSIVE
EXPERT
Portfolio

Aptude Inc

Sr Software Engineer

Categories

Work Experience : 2009 - present

• Involved in Requirement gathering and functional/technical design documentation.
• Developing various Integration Services in Talend
• Performing Unit Testing and support code migration activities until Production migration.

More

LinkedIn

Sr. SOA Consultant

Categories

Work Experience : 2015 - present

Project Name: ABACUS, MDM Merge, GWS, Parthenon, Atlas, Customer MDM

Project Description:

Involved into many projects which includes development of complex web Service in Talend, Oracle FMW,  development of complex wrapper API’s on MS SQL, Oracle PL/SQL.

  • Involved in Requirement gathering and functional/technical design documentation.
  • Developed various Integration Services in Talend to extract data from external system (Workday, Service Now, Jira) to Oracle Database. Experience in handling encrypted files provided by Vendors, to decrypt and load into Oracle.
  • Developed TSQL wrapper packages to transfer and hash PII Data between different databases in SQLSERVER for GWS Project.
  • Experience using tREST, tORacle, tExtractXML, tXMLMap, tSystem , tJava components.
  • Developed/Enhanced many web services(OSB/BPEL) in Oracle FMW for critical business processes like Credit Check, Service Contract Creation, Customer Creation, Receipt/Invoice Creation and  Global Workspace management. Used Business Service to connect to external systems, Salesforce, GetPaid, D365. Used XSLT, XQueries  designed complex XSD’s to support multiple level schema’s.
  • Experience with custom AQ, DB Adapters, WLS Security to enable Basic Authentication on Services.
  • Worked on many enhancements which involved PL/SQL packages, Reports, Oracle Forms.
  • Developed Workflow’s in MFT to transfer files from 3rd Party system(CDW, ZONES, ADP, Microsoft Cloud to internal Client Servers.
More

Cisco Systems

Team Lead: Q2CFY15 project

Categories

Work Experience : 2014-2015

Project Description:

This project involved the development of Web Services (to send notifications), Credit Card Integration with Cyber Source, and Invoice Creation and migration from 11i to R12.

  • Involved in Requirement gathering and functional design documentation.
  • Managed an onsite offshore team, daily status calls, and object deliverable tracking.
  • Developed metrics to test and monitor deliverables, ensuring they would meet deadlines.
  • Led team in the design of new interfaces, reports.
  • Configured Cyber Source in iPayments for making Credit Card Payments through Receivables.
  • Developed Web Service to call third-party web service to send notifications to the customer.
  • Developed Pl/SQL wrapper program to call Web Service from PL/SQL.
  • Developed PL/SQL wrapper program to create Credit Card and do the Credit Card Payments and Refunds automatically.
More

Equinix, Inc.

Team Lead: BI Report

Categories

Work Experience : 2014

Project Description:

This project involves the development of BI reports for AR/OM and GL modules

  • Involved in Requirement gathering and functional design documentation.
  • Managed an onsite-offshore team, daily status calls, and object deliverable tracking.
  • Develop metrics to test and monitor applications, ensuring consistent improvement.
  • Delivered project deliverables as per deadline.
  • Involved in performance tuning of various reports.
More

Symantec

Team Member: DA Vinci project

Categories

Work Experience : 2014

Project Description:

DA Vinci Project is an Oracle R12 EBS implementation project which involves Service Contract, Install Base, Order Management modules. The project involves Customer Facing Documentation such as Invoices, Sales Order printing, and various reports.

  • Involved in gathering requirements and feasibility study, process design, documenting using AIM methodology.
  • Working on Defects that occurred during the UAT phase.
  • Developed multi-organization Print Invoice templates specific to each country in BI Publisher.
  • Worked on BPA (Bill Presentment Architecture) to develop the custom template.
  • Support User testing.
  • Prepare test cases and update technical documentation.
More

Infoblox Inc.

Team Member: Customer Rebranding

Categories

Work Experience : 2013

Project Description:

The customer rebranding project involved a lot of Customer facing documentation redesign (AR Invoice/CM, AR Statement, Purchase Order, and Service Quote). It also involved customization in the Standard Purchase Requisition approval workflow.

  • Involved in gathering requirements and feasibility study, process design, documenting using AIM methodology.
  • Customized Oracle Standard Purchase Requisition workflow and notification. Added one more layer to the Standard approval hierarchy.
  • Customized Oracle Purchase Requisition workflow notification to show additional columns using OAF customization.
  • Involved in AR/GL Month-end close activities.
  • Involved in design and development of Oracle Customer, Service Contract, Item, Install Base integration to RightNow Product.
  • Redesigned AR Invoice/CM, AR Statement, Purchase Order RTF templates.
  • Worked on form personalization for Oracle Purchasing.

Skills

More

Responsys

Team Member: Oracle R12 Implementation

Categories

Work Experience : 2012-2013

Project Description:

The project involved Oracle EBS R12i implementation for Service Contracts/ AR, AP, and GL modules.

  • Involved in gathering client requirements and feasibility study, process design, documenting using AIM methodology.
  • Developed a new interface to interface source system Service Contracts data to Oracle EBS using Service Contracts Interface tables.
  • Customized Service Contracts Approval workflow using AME to accommodate custom approval hierarchy.
  • Worked on form personalization for Service Contracts forms.
More

Elance

Team Member: Project Phoenix

Categories

Work Experience : 2012

Project Description:

Elance is the most popular place to find, hire, manage and collaborate with online freelancers. The project involved the implementation of Oracle EBS R12i for AR/GL and AP modules.

  • Involved in gathering client requirements and feasibility study, process design, documenting using AIM methodology. Was involved in planning, identifying, and mitigating risks during the course of the project.
  • Developed a new interface to interface legacy GL transactions to Oracle EBS.
  • Developed complex BI Reports that combine data from Oracle EBS and Source System.
More

Infoblox

Team Member: POS Phase 2 project

Categories

Work Experience : 2012

Project Description:

POS Phase 2 project was for enhancement to the existing Custom functionality in OM/AR.

  • Worked on OM Custom Forms.
  • Developed wrapper programs to send Concurrent Program output as an attachment in email for the Service contracts program.
  • Worked on Service Contract form customization to initiate calls to Customers automatically from forms.
  • Worked on Install Base interface to update Item instances with the latest reseller information/installation detail and custom attributes using APIs.

Features

More

Equinix Inc.

Team Lead: ACaCM Implementation

Categories

Work Experience : 2011-2012

Project Description:

ACaCM project involved customization and development of new components for Oracle Advance Collection, Service Contract, and Credit Management modules.

  • Customized Oracle Advance Collections form to display additional data in the form of JTF Grid in custom tabs.
  • Managed the Onsite Offshore team and delivered objects on time.
  • Maintained Project/Deliverable progress status daily and make sure deadlines is not impacted.
  • Developed Custom Form to facilitate the creation of On Account Credit Memo. Developed AR Interface to create Account Credit Memos.
  • Developed new workflow using AME for custom Credit Memo Approval process. Designed custom approval hierarchy using AME.
  • Worked on custom Service Contracts Renewal program.
  • Customized OAF pages to add new attributes with LOV.
  • Customized existing logic of consolidated billing as per Business requirements.
  • Worked on performance issues for custom-designed OAF pages and reports.

Skills

More

Schneider National Inc.

Team Member: Quest project

Categories

Work Experience : 2008-2011

Project Description:

This project was the Implementation and rollout of Oracle Release 12(12.1) covering GL, AP, PO, AR, HRMS modules. Schneider is using SOA, BPEL, ODI, and Informatica for all the Integration between Siebel, OTM, EBS, Mainframe, and M5.SVN is used as a subversion tool.

  • Involved in gathering client requirements and feasibility study, process design, documenting using AIM methodology. Was involved in planning, identifying, and mitigating risks during the course of the project.
  • Designed complex web services using BPEL/SOA to interface EBS system with the Legacy system (Siebel/OTM, Imaging). Developed process in BPEL to send Email and Fax Invoices to Customers.
  • Worked on Driver PIP to interface Driver data from EBS to OTM.
  • Designed and Developed AR Interfaces to interface data from SIEBL/OTM to EBS using BPEL Processes.
  • Developed web services to interface data between different systems (M5/ OTM/ SIEBEL/ Imaging and Oracle EBS).
  • Developed interface to sync bank account details from HRMS to AP Supplier Site Bank details.
  • Designed Enterprise business service for interfacing Purchase Orders/Receipts data (M5, PowerPlus, and ComData) to EBS.
  • Developed inbound interface to import AP Invoices from OTM/SIEBEL/TMW system and feedback loop to update Invoice status back in EBS. Built custom rules for partial PO matching for Commdata Invoices.
  • Customized PO Approval workflow process to handle PO Communication through the custom approval process.
  • Worked on Customization of AR/AP Netting process for Contract Driver Payment Processing.
  • Developed outbound interface for HRMS.
  • Developed different Print Invoice Reports in Oracle Reports.
  • Developed PLSQL packages to send the Concurrent Program output as email/ or to send HTML/Plain email using workflow.
  • Developed shell script to transfer files from/to SFTP server.
  • Preparing Technical design documents, Unit Test Cases. Maintained high-quality standards in all documents.
  • Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on the integrated system environment
More

IBM India Ltd

Team Member: Project Polaris for BMC Software

Categories

Work Experience : 2007-2008

Project Description:

Project Polaris involved the implementation of Oracle Application 11.5.10 and implementing RICE components. Phase1 consisted of setting up a new chart of accounts, set of books, conversion, and interfaces of PA, AR Invoice, Customer, Supplier, and HRMS data to 11.5.10. Phase 2 consisted of Reports, extensions, and Customization of different modules of Oracle.

  • Involved in requirement gathering, feasibility study, process design, and documentation using AIM methodology,
  • Provided day-to-day functional support to end-users in PA, AR modules.
  • Was involved in planning, identifying, and mitigating risks during the course of the project.
  • Involved in setting up resources, resource lists, and budget entry methods.
  • Used Oracle APIs to create the budgets into Oracle base tables.
  • Involved in setting up Transaction source, transaction types, and Line Transaction flexfields in AR module.
  • Used Oracle Open interface and standard AutoInvoice Import program to create AR Invoice transactions.
  • Developed wrapper program for validation and derivation to load budget data from a source system into Oracle staging tables.
  • Worked on Project transaction control extension to incorporate the business requirement.
  • Defined Concurrent Programs, registered Custom Build PL/SQL Procedures and Packages, and created Executables using the Application Object Library (AOL) in the Development Environment.
More

OSI Consulting PVT LTD

Team Lead: Beckman Asia Rollout

Categories

Work Experience : 2007

This project is supported and enhanced for already implemented Oracle Applications. Beckman has oracle applications running in more than 7 countries and is about to implement in a few more countries like Japan, Korea. Work involved fixing the issues and enhancing the existing process by suggesting a better approach.

  • Worked with business analysts to translate business needs into functional and technical specifications, process flows.
  • Provided business support and module configuration to functional areas in INV, OM, and PO.
  • Defined document categories and assigned Sales Order and Requisition functions to those categories.
  • Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse impact on the integrated system environment.
  • Developed wrapper programs for Sales Order Interface and to transfer attachments from Internal Requisition to Internal Sales Order.
  • Created Periodic Alert to send notification for Invoice Number usage batch source wise.
  • Reviews application customization, extension, and modification designs to ensure accuracy and relevancy of functionality proposed and/or affected.
  • Collaborate with client to execute acceptance test to confirm Oracle functionality.
  • Providing technical support for application development, vendor interfaces.
More

OSI Consulting PVT LTD

Team Lead: Customer Conversion for Nordic Naturals, Inc.

Categories

Work Experience : 2007

Nordic naturals recently went live on Oracle Applications 11i. They are having their old legacy system and they have around 50000 customers, which have to migrate to 11i.

 

This project is to migrate 50000 customers, their addresses, address site use purpose, customer contact details (phone, email, mobile), and the relation between person and customer into Oracle Applications11i TCA architecture. Used TCA HZ APIs to create customers and its site/address/contact details.

  • Worked with business to analyze the business requirement and design the process to meet business requirements.
  • Provided business support and module configuration to the HZ Customer module.
  • Used HZ API’s to create Customers into Oracle Applications 11i TCA architecture.
  • Designed migration plan and prepared Technical design document and unit test cases.
  • Used SQL Loader to load data from flat file to staging table.
  • Written wrapper program to validate the imported data and to derive the certain columns required by HZ APIs.
  • Written PL/SQL program to create Customer/Person, their address, address site use, Contact Information, and Party relationships.
More

OSI Consulting PVT LTD

Team Lead: SHAW Communications, SHAW Implementation

Categories

Work Experience : 2006-2007

This Project was a fresh implementation of Oracle Applications 11i. The project consists of implementing P-2-P cycle for the existing business process Shaw. Also, work involves conversions like Item, Quantity On-Hand, Item Categories, SubInventory Transfer, and Approved Supplier List from legacy system to Oracle Applications 11.5.10 using Open interfaces. Customization of Standard Oracle functionality is required to map the business requirement in PO.

  • As a Team Lead was responsible for the delivery of each object, resource allocation, and maintaining high-quality standards.
  • Monitored and organized the work across the team to meet the deadline and customer satisfaction.
  • Reviews application customization, extension, and modification designs to ensure accuracy and relevancy of functionality proposed and/or affected.
  • Involved in defining the inventory organizations, Item Categories, Item Templates.
  • Participated in continuous improvement actions through data analysis and the creation of metrics.
  • Designed strategy for Conversions, Interfaces, and Extensions in PO, INV modules.
  • Designed process flow and development methodology for Item/Category/Quantity On-Hand and Approved Supplier List Conversions.
  • Customized PO form Item LOV to filter based on Approved Suppliers and Supplier Sites.
  • Used CUSTOM.pll to transfer DFF from Internal Requisition to PO, from PO to Receipt, and from Internal Requisition to Internal Sales Order. Also to validate Serial Numbers Length and prefix as defined in Item DFF.
More

Satyam Computer Services LTD

Team Member: QTC Everest Release for Cisco Systems Inc.

Categories

Work Experience : 2004-2006

QTC migration project was to migrate the Oracle Application 10.7 code to Oracle Applications 11.5.9 version. The work involved ASIS analysis and documentation of the current functionality and migrating those programs into Oracle applications release 11i by and changing the 10.7 obsolete table/column names to corresponding 11i table/column names. The project also involved changes to the existing functionality to enhance the processor to accommodate the new requirements.

  • Analyzed the existing programs and changed the 10.7 obsolete table/column names to corresponding 11i table/column names.
  • Prepared Technical Design documents, Unit Test Cases. Maintained high-quality standards in all documents.
  • Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse impact on the integrated system environment
  • Developed complex Print Invoice/Aging Bucket Reports.
  • Supported and fixes the issues in the Receipt/Lockbox business function.
  • Created and modified various summary/detail reports like customer detail/Summary report, Sales Order, Aging Bucket reports, Invoice/Receipt summary report, Receipt Register, etc in AR and OM modules.
  • Provided Implementation & Post Production Support to CISCO clients.
  • Developed Report Triggers, format triggers to display data depending on particular conditions.
  • Involved in customization of the Oracle Forms & Reports
More

Chenab Information Technologies PVT LTD

Project Lead: Aurobindo Pharma Oracle Application Implementation

Categories

Work Experience : 2002-2004

The company implemented Oracle Financials to create a secure financial management system that enables real-time visibility of critical business data and financial reports. Worked with business to set up and configure the modules in P2P, O-2-C cycle.

  • Worked with business analysts to translate business needs into functional and technical specifications, process flows.
  • Provided business support and module configuration in O-2-C cycle
  • Worked on extensive troubleshooting problems of diverse scope.
  • Defined training documentation and conducted end-user training
  • Defined setups in AP like supplier, buyer, payment terms, Banks and accounts, approval limit, approval assignment, distribution sets (Full and Skeleton), Payable and Financial options.
  • Worked on AR Invoice Interface, defined batch source, transaction type, auto accounting, grouping rule, line-ordering rule, line transaction flex fields for source.
  • Customized Oracle Applications Sales Order and packing list detail form to capture additional information required by EMS and to print the packing list respectively.
  • Defined Concurrent Programs like SQL, PL/SQL, Reports, and Forms, developed new reports, and customized existing reports as per requirements (formatting, addition/deletion of columns, formulas, etc) by creating/modifying the packages, procedures, and functions.
  • Created various reports using XML Publisher.
  • Created new Users, Responsibilities, Registration of new DFF, Profile Options, Form Registration, Reports Registrations, and Table Registrations.
More

Accomplishments Summary

Work Experience : 2015-2020
  • 20+ years of professional experience in Oracle EBS (E-Business Suite) Application 12i/11i in various roles with expertise in Financial and Supply chain management modules (AR, OM, INV, PO, AP, GL, HRMS, Service Contract, Install Base, Advance Collection and Credit Management).
  • 10+ Years of experience in developing web services using Oracle Fusion Middleware 10g/11g/12c, Talend ESB, MFT.
  • Handled large implementation projects and led the offshore team.
  • Worked extensively on RICE components across multiple modules using API/Open Interfaces.
  • Developed complex TALEND services for loading data from an external system to Oracle/SQL Server database.
  • Developed workflow’s in MFT for transferring files between two servers. Build workflow to invoke web services.
  • Integrated various disparate systems like Oracle EBS, Siebel, OTM, and other legacy systems using Oracle Fusion Middleware SOA11g/12c.
  • Strong experience developing Web Services and using XML, XSL, XSLT, XPath, XQuery, JSON, WSDL.
  • Very good knowledge of Oracle AIA foundation pack, Process Integration Packs (PIP).
  • Experience in developing SOAP/REST-based web Services.
  • Developed File-Based Data Integrations for Receivables, Payables Inbound Interfaces in OIC.
  • Expertise in order to cash (O2C) and procure-to-pay (P2P) business flows.
  • Expertise in tuning queries/reports for performance issues, testing business flow, and also working on Post-production support issues.
  • Developed a new workflow using AME for the Credit Memo Approval process.
  • Developed complex UNIX scripts to transfer files from SFTP server to EBS Servers.
  • Developed various interfaces using OSB in 12c with JSON support.
  • Adapt at all stages of the project lifecycle, from business requirements and design to development, testing, user acceptance testing (UAT), production support, and completion.
  • Good problem solving and troubleshooting skills, highly motivated, and ability to work as an individual or as a dynamic member of a team

ACADEMIC PROFILE: BE (Computer Science) from Walchand Institute of Technology, India June 2001.

CERTIFICATIONS: OCP 8i DBA

More

Hire Prashant