Binay Prasad
Unit ****, Littleton, CO 80124, USA
Email: acxkqr@r.postjobfree.com
Cell / Mobile: +1-860-***-****
Visa Status: Green Card
Experience Summary
Seasoned professional with excellent knowledge in Oracle Application Modules
Trained and Certified Oracle Cloud professional on General Ledger
Excellent knowledge on OM, PO, INV, AP, AR, GL, PA, CM, Iproc, iExp, Install base and Service Contracts
Excellent knowledge on P2P cycle and O2C cycle
Has around 13 Years of experience in IT industry working as a Techno-Functional extensively in Oracle Apps implementation, Upgrade and Production Support projects.
He has done implementation of EBS using middleware BPEL/SOA. He has around 2+ years’ experience in Middleware Technology (BPEL/SOA) Integration with Oracle apps. He has also worked in R12 Financial accounting Hub in configuration and Technical development. He is conversant with oracle best practices and quality while executing his projects
He has extensively worked in Oracle Applications R12.2, R-12.1.3 and 11i
Strong knowledge on SQL/PLSQL, API's, AME, Workflow
Very strong communication skills and requirement gathering and execution on oracle projects
Awards:
Certificate of excellence from, Conway logistics, Portland, USA
Been a STAR performer for continuous 4 years in Satyam Computer Services LTD.
Live Wire Certificate award from HCL Technology for excellent performance/delivery for Quarter
Award and Certificate from VMware Client for excellent performance for Term license project.
Appreciation from Huntington Sr. Vice President for 1099 process and corporate credit card process for solution design and development.
Appreciation from CIGNA SR DIRECTOR during CRP1 implementation.
PROFESSIONAL EXPERIENCE:
ORGANIZATION
POSITION
PERIOD
CH2MHILL
Sr. Oracle Apps developer
Apr 2016 Till date
Arrow Electronics
Applications Engineer
May 2015 till Apr 2016
TCS
Asst. Consultant
March 2011 to May 2015
HCL
Lead Consultant
May2010 to Feb 2011
Satyam Computers Ltd
System Analyst/Team Lead
Jan2004 to May2010
Technology
Operating system
Linux 7.0,Windows NT, Windows 9x/ME, Windows2000, WinXP
Languages
C,C++, SQL./PLSQL
GUI
Forms 6i, Reports 6i. Fusion Middle ware BPEL/SOA, OAF personalization's, BI reports., WEB ADI, XML Publisher, AME, Workflow customization
Tools and Packages
Kintana, TOAD, PVCS, JDEV, SQL Developer, STAT Migration Tool
ERP
Oracle Applications (FAH, AP, AR, GL, FA, PA, PO, OM, INV, iProc, iExp, Install Base and Service Contracts)
Training on oracle cloud and Fusion application
Qualifications
Degree
Institute
Specialization
B.E, 2003
Sir M. Visvesvaraya Institute of Technology, VTU, Bangalore
Electrical and Electronics
Assignments
Project Title
CH2MHILL, R12.1.3, Production Support and Enhancement
Client
CH2MHILL
Position
Techno- Functional Consultant
Period
April 2016 - till Date
Responsibilities
Involved in the day to day production support activities.
Worked on WEBADI, 1099 reports, forms development and OAF personalization's
Worked on resolving issues related to the patches for the invoices
Day to day ongoing issues for data fixes and oracle SR's.
Workflow customizations on AP approval workflow and credit card
Worked on customizing account analysis report and building new reports from scratch.
Worked on various API's and Interfaces (AP/AR/GL/Iexpense)
Worked on New Project initiatives within CH2M HILL
Worked on co-coordinating Hyperion project (ODI)
Working on the SQL loader and util's file API's/Gather stats, AME etc.
Training on Oracle cloud and Fusion applications
iExpense related web page issue.
Permanent solution and business process for ongoing data fixes.
Project Title
Arrow Electronics, 11i Production Support and Enhancement
Client
Arrow Electronics
Position
Techno- Functional Consultant
Period
May 2015 and Apr 2016
Responsibilities
Involved in the day to day production support activities.
Involved in Building a new custom functionality for Rebate to Seller and Vendor
Meetings with Business and Functional Analyst for doing various solution designs.
Working on tool called My work space quoting tool
Worked on rdf Report and exiting Forms customizations.
Building new XML reports and customizations.
Metalized views design and queries for mywork space tools.
Performance tune some of the concurrent program which were taking more than 24hrs to 4 hours.
Writing PLSQL programs and interfaces (like WEB ADI for customer receipts)
Project Title
R12.1.3 Upgrade project
Client
Western Union, Denver, USA
Position
Techno- Functional Consultant
Period
Dec 2014 – May 2015
Responsibilities
Requirement gathering and development for the Oracle Apps upgrade project which involves co-coordinating, planning, defect resolution and executing the project. Making sure all the functionality was intact and integration was functioning successfully in modules AP, AR, GL, FA, PO, iPROC
Single Point of Contact for development and testing
Understanding the Business Requirements(MD50,MD70)
Working on all the customizations objects relegated to the upgrade
Testing and developing all the interfaces and file transfers process
Building API's, Interfaces, forms, XML reports, AME
Resolving the punch out issue and setup
The Project
Western Union connects people and businesses around the globe by providing fast, reliable and convenient ways to move money. WU 160-year history and more than 500,000 Western Union Agent locations in more than 200 countries and territories strengthen their commitment to offering services in every corner of the globe.
Western Union R12 upgrade project was to upgrade from R12.0.6 to R12.1.3. It involved more than 300+ custom components and enhancement to be retrofitted.
Project Title
Cigna, Building Financial Foundation Project
Client
Cigna, Bloomfield, USA
Position
Techno- Functional Developer
Period
Apr 2013 – Dec 2014
Responsibilities
Lead and actually involved in development for Production support after GO LIVE
Doing the Oracle Apps Upgrade Project followed by Production Support and Enhancement for BFF project which involves Development, coordinating, planning, defect resolution and executing the project.
Single Handily working with development team for CRP1 with respect to delivery, design and Testing the RICEW components
Financial Accounting Hub configurations and development
Worked on AP,AR,GL defects on BFF projects
Understanding the Business Requirements(MD50,MD70)
Designed and developed functional specifications as per the business requirements
Stream lining the Business process and solution design
End to End knowledge on STAT tool
The Project
Cigna headquartered in Bloomfield, Connecticut, US, is a global health services organization. Its insurance subsidiaries are major providers of medical, dental, disability, life and accident insurance and related products and services, the majority of which are offered through employers and other groups (e.g. governmental and non-governmental organizations, unions and associations).
The BFF Program Roadmap has a clear vision and future state for Finance, including organizational structure, processes, and systems. Accounting information systems and processes are in scope for this initiative. Opportunities to consolidate applications, process transaction in a more efficient manner, and increase automation will also be addressed as part of the BFF Program Roadmap.
Project Title
Huntington bank, Oracle Apps R12 implementation Support
Client
Huntington Bank, Columbus, OHIO, USA
Position
Techno- Functional Consultant
Period
July 2012 – Apr 2013
Responsibilities
Development of AP, AR, GL, PO components. Forms, XML reports, Workflow, Interfaces, Unit testing and Reviewing results
Resolving all the defects with respect Prod support defects
Daily status calls with customer and Status Reporting
Designed and developed functional specifications as per the business requirements
Analyse the system for R12 Oracle apps enhancements
Impact Analysis for the Business Requirements & Coding according to the technical specifications.
Corporate Credit card Project end to end solutions
Worked on some parts of AME for iProcurement.
The Project
The Huntington National Bank is headquartered in Columbus, Ohio and provides personal banking for individuals and families, small business banking, banking for middle market businesses and non-profit organizations, and specialty financial services across six states: Ohio, Michigan, Indiana, Pennsylvania, West Virginia, and Kentucky.
Huntington bank Entire Financial system is driven by Oracle Apps ERP. This project was more towards the support and Enhancement
Project Title
Oracle Apps R12 Upgrade and 11i Support and Maintenance
Client
Humana Inc, USA
Position
Techno- Functional Consultant
Period
Mar 2011 – June 2012
Responsibilities
Requirement gathering and upgrading to Oracle R12
Developed APIs scripts for R12 functionality for Interfaces.
Complete Technical code changes for all the 1500+ components as per R12 functionality.
WED ADI components development.
Development of AP, AR, GL and PO interface components.
SR follow-up and resolutions and Support for 11i system
The Project
Humana is a Fortune 100 company that markets and administers health insurance with a customer base of over 11.5 million in the United States. Humana markets its health insurance services in all 50 U.S. states, D.C., and Puerto Rico, and has international business interests in Western Europe.
Humana Oracle Apps R12 upgrade project was to migrate from 11i to R12.1.3. It was more of technical upgrade to migrate 1500+ customized components.
Project Title
Term Licensing, Oracle application, VMware
Client
Vmware, CA, USA
Position
Oracle Apps Techno Functional, Hyderabad
Period
May2010 – Feb 2011
Responsibilities
Involved as a Sr Developer to understand the scope of project and develop the component.
Involved in integration, enhancement and development of the order management, install base, contract module components.
BPEL/SOA integration solution for the components.
The Project
VMware the global leader in cloud infrastructure delivers customer-proven virtualization solutions that significantly reduce IT complexity. VMware accelerates an organization’s transition to cloud computing. Organizations rely on VMware, its partners and its industry-leading virtual infrastructure platform, VMware has more than 170,000 customers and 25,000 partners worldwide.
Project Title
Cisco Quote to Cash, Oracle application/ Cisco ICC 1.5 Credit Check for SOWB
Client
Cisco Systems, CA, USA
Position
Oracle Apps Techno Functional
Period
SEP2009 – May 2010
Responsibilities
Involved as a SDF team (solution definition team). Where supposed to write FSD (functional specific design) getting the business requirement.
Involved in integration, enhancement and development of the order management components.
And after the development need to support the order SOWB modules. Which involves the resolving the error and bug in the system.
Post production support to resolve the entire problem till the system becomes stable
Modifying the SOWB form to do the custom credit check for the Cisco Economic customer.
Reviewing the test case and helping QA to test the functionality.
Supporting the Test cycles.
Requirement gathering and development for the order management components.
The Project
Cisco system is the largest networking company.
This project involves the Enhancement, development and customization of existing Order management SOWB work bench form. Cisco systems wanted to add new features of Cisco Custom functionality. We have to do the impact analysis and designing and development of the modules. The order Management module has to be analysed and then implement the changes. We implemented the Credit check before the order was booked.
Project Title
QUEST Financial-R12.0.6 Implementation / QUEST Financial-R12.0.6 Production Support
Client
Schneider Natinal, Greenbay, WI, USA
Position
Onsite Team Member, Green Bay /SME
Period
FEB 2008 – SEP 2009
Responsibilities
SME for all the interfaces design.
Requirement gathering of various interfaces of (AP, AR, PO and GL) modules(R-12.0.4).
Interface development (inbound and outbound) between EBS and other systems (OTM, Siebel, EDMS, TMW, M5, Source) using BPEL/SOA as middle layer.
Worked as a lead in designing all the interfaces and help other to develop the interfaces.
Have been in Production support and trained resources to give production support.
Build Real time customer Interface between Siebel and EBS(R-12) using BPEL/SOA as middle layer.
Build Real time AR and AP invoice Interface between OTM and EBS(R-12).
Build Auto Lock box interface.
Building of interface of AR invoice report that is sent to EDMS system for printing using BPEL/SOA.
Building of Interface between EDMS and BI Publisher system to send Email and Fax using BPEL/SOA.
Also contributed in PO order and receipts in AP.
Development of DVMs, X-ref in SOA layer.
Development of EBO/EBM for BPEL service.
Building the MD70’s and development.
Using BPEL/SOA suite to integrate the different system using AIA architecture.
Building of RICE objects. Building the T-20’s
Worked as a lead in designing all the interfaces and help other to develop the interfaces.
The Project
Schneider national is a logistics company. Schneider National Inc. is not only North America's largest truckload carrier but also a leading global logistics services provider.
The scope of this project is Implementation of Oracle apps financial module R-12 using BPEL/SOA suite to integrate different system (SIEBEL, Oracle Transport management (OTM), Oracle HRMS, TMW, SOURCE, Lawson and Imaging system). We have successfully completed development for four releases of this project and have gone live for 3 phases. Schneider National is one of the first companies to implement R12 Oracle application using fusion technology to integrate with other application using BPEL/SOA.
Title
Winning at CONWAY, USA (Portland)
Client
Con-way, Portland, Oregon, USA
Position
Onsite Team Member (USA Portland)
Period
NOV 2007 – FEB 2008
Responsibilities
Standardize & globalize system usage
Creation of new work product for the migration
Add new applications
Consolidate database
Reduce customization
Testing the above developments
Support after migration
The Project
CONWAY is a logistics company. Conway Company is for freight transportation for commercial, industrial, retail, wholesale and manufacturing companies throughout North America.Con-way Freight is fastest, reliable carrier in North America, having centralized control on operations; reducing inventory cost and time-in-transit, with peace of mind from shipping.
The scope of the project Winning@Con-way covers merging operations from three regions Southern, Western & Central to one centralized system. This merging is having impact on financial system too. The main data migrations to be carried out are:
Customer Consolidation Data volume : 1.7 billion
751 Roll-up Data Volume : 90 billion
Besides possible logic for above roll-up, main emphasis is on bulk update, multithreading, parallel query & processing for completing the task in scheduled & allocate time-frame.
Title
FULLETRON FINANCIAL HOLDINGS, DUBAI
Client
ASIA FINANCIAL HOLDINGS, DUBAI
Position
Onsite Technical Team Lead, DUBAI
Period
April 2007 – OCT2007
Responsibilities
Analysis and Enhancements of the Business Requirements
On demand Feasibility check for the Technical Requirements
Designing the layout and structure of CRM/financials and other related integrations to CRM
Designing the Integration approaches for the whole system
Designing the Integration Documents
Meeting Deadlines of the deliverables
Developing APIs for the complex data and process integrations
Development of complex forms
Custom PLL
Forms personalization and customization
Confirming the adherence to best practices
Reviewing and testing the components after unit testing
Planning of SIT and assuring phase wise deliveries
User Training and maintaining UAT environment
Analysing the CRs and incorporating them with the developed components
As an offshore team lead was involved in developing forms, reports, interfaces of financial and CRM modules where the data flow was through BPEL which was a middle ware to transfer the data from oracle to other system and visa-a-versa.
Also was responsible for reviewing the offshore deliverables and guiding the offshore team.
The Project
Fullerton Financial Holdings: Fullerton financials is a brand of Temasek, a US$80 billion firm, which deals with providing financial solutions. There are many products involved to make the final system. The challenge was to integrate all these different systems which were done my means of BPEL (Business Process Execution Language).
Title
DU OFI Data Migration
Client
DU Telecom, Dubai
Position
Onsite Team member, Dubai
Period
March2007 – April 2007
Responsibilities
Involved in requirement gathering, development of oracle open interface and reports of oracle apps modules (GL and AR).
Also was responsible for data migration in AR modules.
The Project
DU was a new telecom company in the Middle East. It has its head office in DUBAI (UAE).
This project involved in development of Oracle Apps open interfaces. The various modules were GL and AR
Title
ERP Implementation in Axiom Telecom
Client
Axiom Telecom
Position
Onsite Team Member, Dubai
Period
DEC 2006
Responsibilities
As a team member I was involved in development of oracle open interface and reports of oracle apps modules (PO, AP, GL and INV).
The Project
Axiom telecom is the largest distributor in Middle East for all the electronics items sold in UAE, It has many retail and whole sale outlets in entire UAE.
This project involved in ERP implementation of INV, PO, OM, AP, GL and AR modules.
Title
Dubai Holding, DUBAI
Client
Dubai Holding, DUBAI
Position
Onsite Team member, Dubai
Period
October 2006 to NOV 2006
Responsibilities
As a team member I was involved in the development of reports and interfaces across all modules.
Requirement gathering and development.
The Project
This project involved development and enhancement of Oracle apps reports. The modules involved were (INV, PO, GL, AP and AR).
Title
Oracle Applications integration with Oracle Retail Warehouse Management System (OA – ORWMS)(RETEK)
Client
DUBAI DUTY FREE
Position
Onsite Team Lead, DUBAI
Period
June 2006 – September2006
Responsibilities
On-site lead Development member and leading a team of 7 members
Involved in requirement gathering and development.
Development of FORMS, REPORTS and INTERAFACES across oracle Apps modules PO, AP, GL and INV modules.
Testing and migrating the developed components.
The Project
The Dubai duty free project involved development of Interfaces, forms and reports in oracle apps 11.5.10.2. The oracle modules which were involved were (PO, AP, GL and INV). The functional and technical design aspects of each component that comprise the building an Interface between Oracle Applications (E-Business Suite) and Oracle Retail Warehouse Management System (ORWMS).
Title
11i QTC (Quote to Cash) Everest Release project
Client
Cisco Systems Inc
Position
Team Member
Period
Jan2004 -June-2006
Responsibilities
Oracle Distribution Module OM, Workflow and AOL Setups
Development of Forms, Reports, Alerts, Concurrent programs, interfaces
Involved in bug fixing and analysis of SOWB (sales order work bench) form, The SOWB form is for Creating Standard Orders/ lines and Order Ship sets into new or existing orders that are in entered status, in the Order Management (OM) Sales Order Workbench. 11i allows creating of orders manually from within the Sale Order form or from the Order Organizer.
EBF for SOM (Supply order Manager) during post go live support.
Part of the CCI (Kintana migration) team.
The Project
Cisco Systems, Inc. is the worldwide Leader in Networking for the Internet.
The project was a migration project from Oracle Applications 10.7 to Oracle Applications 11.5.9. The elementary requirements were to Upgrade 10.7 systems to 11i, add new applications, Consolidate databases, Reduce customization, Standardize and globalize system usage
Visa Status: Green Card (USA)