Summary:-

More than 10 years of IT experience including Functional Consultant/Technical Consultant/Team lead/DC migration lead/Project lead experience in Financials/Supply Chain Management/Distribution domain.

Senior Techno-Functional Consultant having extensive experience in implementing Oracle Applications E-Business Suite solutions for large global enterprises like GE Commercial Finance, Electronic Arts, Cisco etc. I have worked on End to End Implementations, Upgrades, Roll outs and Post Implementation support, Stabilization as well.

• Extensively involved in Global Rollout of Oracle Financials Application for GE, Connecticut, USA.
• Extensively involved in Global Data migration, implementation, Conversion, Development, Upgrade, Enhancement and Support roles for General Electric Corporation.
• Extensively involved in Implementation, Development, and Upgrade for Electronic Arts, Redwood Shores USA.
• Experience in Interface Integration and Data migration Strategy.
• Strong co-ordination, communication and inter-personal skills
• Experienced in full life cycle / SDLC processes, implementation, development and post implementation support methodologies like AIM, Six Sigma
• Experience in various Techno-Functional Roles in Oracle Financials and Oracle Supply Chain 11i/R12.
• Worked extensively on Order to Cash O2C and Procure to Pay P2P Cycles.
• Completed three end-to-end Implementations of Oracle 11i, Oracle R12 in Multi-Org instances.
• Good knowledge of Financial Modules like Account Receivable AR , General Ledger GL , Account Payables AP , Cash Management CM , I-Expenses, I-Procurement, Project Accounting PA , Oracle Trade Management OTM and Oracle Lease Management OLFM modules.
• Expertise in Distribution Modules like Order Management, Purchasing, Advance pricing and Inventory.
• Thorough understanding of Application Object Library modules like System Administrator, Workflow Administration, Oracle Alerts.
• Basic proficiency in Fixed Asset, Contract Core, Sales Contract, Install base, product information management PIM , Advance supply chain planning, Oracle transport management OTM , Oracle Cost Management, i-Supplier, Application Desktop Integrator ADI , Oracle Payments.
• Extensively worked on Business Requirements Gathering, Solution design, Business Mapping, configuration, set-ups, Building RICE components Reports, Interface, Conversion, and Extensions , Discoverer Reports, and Workflows.
• Demonstrated ability to facilitate system review, data analysis, Conducting CRP, SIT UAT and situation assessment.
• Strong focus on implementing Quality Assurance Processes
• Certified Green Belt in Six Sigma

Professional Strengths:-

• Experience with the Software Development Life Cycle SDLC process - performing detailed analysis, collecting requirements, technical specifications, development and unit testing, integration and production installation and support.
• Proficiency in interacting with various stakeholders and collaborating with them for mission critical projects.
• Experience in Design, Development, Customization and Implementation of business applications using Oracle Applications, SQL, PL/SQL, Oracle 10g/9i/8i/7.x, forms6i, reports6i, Discoverer 4i/10g, Workflow 4.5.
• Strong conceptual knowledge on business processes in Inbound and Outbound Logistics.
• Experience in creating Procedures, APIs, Packages, Functions, Triggers views, collections nested tables and arrays , records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
• Strong analytical, diagnostic and problem solving abilities.
• Exposure to oracle AIM methodology.
• Experience in converting oracle reports into stylish PDF format using XML publisher.
• Familiarity in developing Project related design documents like MD70, MD50, MD120, and TE20.

Key Skills / Profile:-

• Experience of full-cycle Oracle implementations, Project transition, Support, Global roll-outs, version upgrade and offshore support projects.
• Solution Architect/Functional consultant for -Oracle 11i Production Support Project for Johnson Controls, Milwaukee, USA.
• Business system Analyst for Oracle R12 project for Motorola Mobility A Google Company ,Sunnyvale, California, USA
• Technical/Functional consultant for Oracle R12 upgrade project/Oracle 11i Support project for Cisco Systems Inc, San Jose, California, USA
• Technical/Functional consultant for Oracle R12 Implementation project for Electronic Arts, Redwood shores, California, USA
• DC Migration lead for Oracle 11i data center migration project for Carnival Cruises, Doral, Florida, USA
• Technical/Functional consultant for Oracle 11i Support project for Princess Cruises, Valencia, California, USA
• Technical/Functional consultant for Oracle 11i Support/Implementation/Upgrade/Enhancement project for General Electric, Connecticut, USA

Technical Skills:-

Oracle Apps:

• Financial Domain - Accounts Payable AP , General Ledger GL , Cash Management CM
• iExpense, Accounts Receivable AR , Oracle Lease Management OLFM , Oracle Trade management OTM , Fixed Asset FA , Contract Core, Sales Contract, I-Supplier, Oracle Payments and Project Accounting PA .
• Supply Chain Domain - Order Management OM , Inventory INV , Advance Pricing QP , Oracle Purchasing PO , Install base, product information management PIM , Advance supply chain planning ASCP , Oracle transport management OTM , Oracle Cost Management

Software:

Oracle E-Business Suite 11.5.10.2/12.1.3, Oracle Database 10g, PL/SQL, Reports 6i, XML

Publisher, Discoverer 4i/10g, Workflow.

Tools

:

TOAD, Data Loader, SQL Loader and Unix shell scripts.

PROFESSIONAL SUMMARY:-

Confidential

Oracle Apps Functional Consultant

The project involves in-house upgrade, customization and support of Oracle Financials particular to financial domain GL/AP/AR/PA/PO/OM/OLFM module which involve managing/maintaining data coming from upstream applications to oracle and further moving to downstream.

Responsibilities:

• Communicating with Business users for understanding of the requirements/issues.
• Analysis and issue resolution for Inventory/OM/PO/AP/PA/AR/OLFM functional/technical production issues involving Receiving, Shipping, Costing, Invoicing, Billing, Inventory, Interfaces and Integrations.
• Involved as a Functional Analyst in working with the issues raised during from contract creation to booking in Contract Booking system CBS . Contract creation happens at CBS and then flows to Oracle and also issues related to costing Project Cost .
• Involved in Contract Booking/Activation/Costing.
• Billing process to generate AR invoice and involved in project AP invoicing process.
• Debugging SQL queries and PL/SQL packages, procedures, triggers, and functions.
• Developing workarounds.
• Calls with the client and oracle regarding the data fixes and solutions.
• Acquiring and transferring knowledge of business processes to other members in the team.
• Participate in the meetings with the Client along with the Functional Trackers.
• Support several Interfaces between Oracle apps and other legacy systems.
• Worked on Support Tools like Remedy, Jira, SVN, and Hudson.
• Co-ordination with the team ensuring proper and timely interactions
• Oversee and perform designing coding and testing of program deliverables.
• Ensure on time delivery.
• Development, Code Reviews Testing of the project by reviewing code and maintain uniform Quality Standards along with the documentations.
• Interaction with offshore team for issue clarifications and other project related activities
• Analysis of the specification provided both front-end backend .
• Involved in the Production-Support and Enhancement as part of their ERP solution. The area of this project is building efficiency.
• Handled issues related to OM, PO, AP, AR, INV, GL/OLFM and PA modules including issues related to Interfaces.
• Coding in pl/sql, sql.
• Code / break fix after analyzing the issue with high-level functional point of view.
• Regular client interaction regarding the status of the project

Environment: Oracle database 10g, Oracle E-Business suite 11.5.10, Reports 6i, TOAD, SQL Loader, PL/SQL, Data Loader and Unix shell scripting.

Confidential

Oracle Apps Techno Functional Project Lead

Responsibilities:

• Involved in gathering Functional Requirements, Business Requirements and Design Documents.
• Involved as a Functional/Technical Analyst for check printing solution using bottom line technologies. Using Bottom line we format the file as per the client requirement and generates check print to check printer. Worked on pay base configuration and printer configuration in pay base for check print solution.
• Involved as a Technical Analyst with AP Interface issues and working on the development of outbound interfaces on GL/AP/AR. Worked on security profile setup to fix the issue with interfaces.
• Configured/Setup printers in network as well in oracle for check printing process.
• Attend Meetings and discussion with Client for improvements in project.
• Discussions with User to explain the various modules.

Environment: Oracle 9i database, Oracle E-Business suite 11.5.10 GL, AP, AR, CM , Reports 6i, UNIX, SQL Loader, PL/SQL, Work Flow Builder, Pay base Bottom Line technology .

Confidential

Oracle Apps Techno Functional Onsite OLFM Lead

Responsibilities:

• Involved in gathering Functional Requirements, Business Requirements and Design Documents.
• Involved as a Functional Analyst for establishing the Individual Benchmarks and Baselines for Oracle Applications R12 12.1.3 , Legacy, SFDC, Originations, ERP Modules GL, AP, SCM, AR, FA and OLFM Oracle lease management and Finance etc. From Quote creation in SFDC to deal Contract creation in OLFM.
• Involved in End to End Life cycles of lease like Application to Booking, Invoice to Receipt, Inquiry to resolution, Quote to termination, Asset return to disposal and period to close.
• Transaction Source Setup OKL Contracts .
• Performed end to end testing during SIT in areas of Terminations, Billing and Service.
• Created defects using HPQC and helped technical team in defect resolution testing and unit testing.
• Involved in below business processes as per business requirements and created business scenarios on below business processes.
• Create quotes for lease contracts
• Create credit lines and limits
• Author lease contracts
• Contract Booking/Activation in OLFM
• Request set to generate AR invoice
• Request set to generate AP invoice
• Lockbox process
• Direct debit process
• Create funding requests and generate invoices
• Generate billing, payments and disbursements
• Create Vendor Program Agreements
• Revise Contracts
• Provide Quotes and Terminate Contracts
• Process Asset returns
• Use Lease Accounting features of OLM
• Use Oracle Lease Center
• Involved in Asset-based finance process on below key business flows.
• Opportunity to Quote
• Credit to Booking
• Invoice to Receipt
• Quote to Termination
• Period Open to Period Close
• Inquiry to Resolution
• Involved in CRP and UAT testing's.
• Involved in monitoring the data flow from using SQL queries and stored procedures to extract the data from the database.
• Attend Meetings and discussion with Client for improvements in project
• Oversee 4 off-site analysts.
• Supervise development of SQL-queries/procedures for database and backend testing.
• Analyzed application, system, and security errors. Escalated issues to developers and verified fixes.
• Designed test plans and defined cases for functional, integration system, and user acceptance testing.
• Attended weekly defect report meetings and presented progress updates.
• Interacted with developers, system engineers, and testing teams to identify applications defects

Environment: Oracle 9i database, Oracle E-Business suite R12 12.1.3 OLFM, AP, AR, CM, OM , Reports 6i, UNIX, SQL Loader, PL/SQL, Work Flow Builder.

Confidential

Oracle Apps Technical Onsite Coordinator

Responsibilities:

• Requirement Gathering and Analysis
• Apply acquired knowledge of the system and come up with enhancement ideas
• Interacting with Business Users, analyzing change requests, impact analysis, and implementation of the same
• Attend Meetings and discussion with Client for improvements in project and future course of project
• Attend Meetings with Various Businesses leads whose Business is to be integrated with system.
• Discussions with User to explain the various modules like OM/Advance Pricing etc
• Ensuring the Application to be SOX compliant and necessary controls are in place for the same.
• Handling cases raised by end users on daily basis involving problems in the areas of accessing to the application, request for having a new or additional access, technical problems like mapping errors and performance issues, incorrect data in reports, delay in process etc.
• Providing consultation during acceptance testing and release of the product into the production environment
• Ensuring Walkthroughs Inspection are carried out as per standards
• Ensuring that the present project adheres to SEI CMM Level 5 standards
• Client status reporting
• Periodic status reporting to TCS management
• Adhering to TCS Internal Processes IPMS .
• Testing the developed codes
• Analyzing the interfaces and Extraction scripts for Oracle OM, Pricing.
• Performance tuning of the Inbound and Outbound SQL, PL/SQL scripts to suit user needs
• Carrying Month Close activities as defined by the Business Users

Environment: Oracle 9i database, Oracle E-Business suite 11.5.10 OM, Advance Pricing, Inv , Reports 6i, UNIX, SQL Loader, PL/SQL.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents.

Workflow Development: Worked extensively on development of Inventory account generator workflow.

Was involved in interaction with functional consultant and business users and customized standard workflow as per client requirement.

Interface/Reports Development:

• Developed Key master interface program to import keys from key master system to Oracle with required validations.
• Designed and developed reports using combination of Report 6i and XML publisher for modules like Order management, Inventory.
• Developed reports in Discoverer 10g and created various business areas, user views, custom folders and joins for reporting. Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Developed around 30 reports in Discoverer from scratch for Order Management, Account Receivable, Items, Inventory, trade management and collections.
• Created several Requests and Request Set to attach the PL/SQL procedures, SQL Loader routine and Reports with Application.
• Assisted in design of various conversions/customizations from legacy system to Oracle Accounts Payable and Oracle Purchasing and General Ledger.
• Imported data from legacy system to Oracle Payables tables using SQL Loader and validate them using PL/SQL procedures.
• Responsible to track the development of all the RICE components with the team on daily basis
• Requirement gathering from functional/client implementation team
• Interaction with users on specific BRs and CRs.
• Resolving of technical / functional issues at client place and communicating/coordinating on the issues with the offshore team.
• Technical analysis of existing business process flow based on the functional designs.
• Preparation of technical design document MD070, technical process/data flow chart.
• Rich experience in registration of Forms, Reports, and PLSQL programs.

Environment: Oracle 10g database, Oracle E-Business suite R12 12.1.3 OM, PO, CM, AR, GL, AP, INV, OTM , Reports 6i, PL/SQL, workflow Builder.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Main key responsibilities involved in taking knowledge transition from Carnival Application SME's about existing business processes and custom components.
• Conducted knowledge transition interviews, validate gap analysis, develop end-to-end business process flow diagrams using Visio .
• Prepared the knowledge transition documents and involved in Knowledge Acquisition KA playback presentation to relevant SME's. Responsible for taking signoff on the presentation from each Operating Company leads.
• Analyzed company policy, standards, and procedures, and drove policy changes with senior management.
• Transferred knowledge and system functional design to offshore technical team required for ADM support.
• Interacted with business users to perform change request analysis, define intended system behavior and document requirements to communicate change to management and technical team.
• Developed test scripts, communicated/guided business users/.stakeholders, test application and proactively resolve issues through effective cross-functional interactions.
• Customized CGFS HAL General Ledger by Account with Purchase Order as per user requirement.
• Customized the CGFS INV Approval Report as per business requirement.
• Worked and resolved the issue with check printing in Account payables as business was unable to print checks with proper style and signature was not appearing after once we migrated to Linux instance from IBM AIX instance. Worked with DBA team and did the necessary changes in printer driver arguments to resolve the issue.

MIGRATION:

DC migration application testing:

Review of test Strategy

• Capture the test results through validation by defined test users based on expected result and latency delay .
• Remediation of programs and scripts in eBS interfaces and at Operating System end
• Revalidate all components functionality at post remediation.
• Test Results for SMTP.
• FTP Service Test Cases
• Preparation of EBS Integration Test Cases
• Perform SMTP testing for concurrent and customized programs which are using email services in eBS application.
• Identify Make and Model of FAX/Print machines in various Op Co
• Communicate Carnival users and verify FAX send to Carnival SMEs
• Ensure availability of extract file in FTP server directory for Outbound program
• Gathering information of all external business partners e.g. Banks and their dependencies on all related FTP programs and other related functions.
• Capture the test results through validation by defined test users based on expected results and functionalities.
• Remediation of all FTP programs and other related scripts, directory structures, Users configurations
• Capture the test results through validation by defined test users based on expected output reports
• Test Results for Printing.
• Test FAX from the Right FAX server.
• Test the FAX from all the eBS processes.
• Test the Print from all the eBS processes.
• Printing Service Test Cases
• Submit few sample Standard Conc Programs report/Interface with valid parameters to verify readiness to test with Custom Program subsequently
• Fixing if any issue faced in step above with relevant team
• Identify all conc program custom report/interface to be tested - 2 reports 2 interfaces from each application module
• Communicate Carnival user, schedule test-printing activity, gather the physical print output
• Fire the print for the printable comp in LNX environment and from AIX to check result which should be same.
• Defect code, driver Fixation
• Migrate the code s in next higher instance
• Communicate Carnival user, schedule test-emailing activity, verify e-mails send to Carnival SMEs
• Communicate Carnival user, schedule test-FAX sending activity, verify FAX send to Carnival SMEs
• Code Migration from PAT to SIT instance

Environment: Oracle 9i database, Oracle E-Business suite 11.5.10 GL, AP, AR, PO, CM , Reports 6i, UNIX, Linux, SQL Loader, PL/SQL.

Confidential

Oracle Apps Technical Consultant Technical Lead

Responsibilities:

Interface Development:

Development of New Custom Program Mexican Tax Revaluation Program : The program that will be developed to automate the calculation and posting of Mexican Tax Revaluation adjustments. Created a high level design for Mexican Tax Revaluation Program and there were a number of steps that should be followed: Convert foreign currency balances to Peso by applying period MOR exchange rate for prior period and Convert foreign currency balances to Peso by applying period MOR exchange rate for current period and Compute the difference of the prior and current period MOR revaluation to create entry for each BLE and CENTER and Post journals.

GEAST Consistency Extract Program: GEAST Consistency Extract, for extracting PDP entries from the General Ledger from base tables to flat file using UTL FILE package. GEAST is required to provide PDP, Option and Capitalized Interest data from the GL to GE Corporate, as part of the Consistency project.

X-charge Change Request Cross Charge Change : The x-charge tool now tells me we have a payable balance on the 130 and a receivable balance on the 320 and function uplift perc added to get the uplift percentage values for corresponding cost center.

DFF Value Sets: Created DFF and Value sets for above program as per the requirement.

Mailer Program: Wrote GEAST Extract Mailer Program to identify business users that extract has been generated on server.

Process Improvement of in CXAO Interface GE Interface Engine : In GE Interface Engine There were no data coming for GL DATE on invoice header level and for invoice payments period name were coming wrong and for some invoices business want us to move the invoices to next period if period is closed. Business need to ask team to move the invoice to process into next period if accounting date for some invoices not in open period. It was a bug fix issue we have changed code as per the requirement now code is working fine.

Workflow: Worked on I-expenses module based on workflow and worked on the issues and enhancements which we received from the business. Worked on issues like Journal approver not found, Users from business was not running programs from proper responsibility the journal went into error. Worked on the issue in which there were no approval limits for particular user. In I expenses we worked on issues on which there were no managers for a employee, we need to setup manager for a employee.

Reports Development:

• Developed Purchase order and Account Payables Invoice Report to display the PO and corresponding Invoice details.
• Customized Trial Balance Detail report as GECFA Trial Balance Detail. GE Commercial Finance was needed correct CDR information and account in GECFA Trial Balance Detail report which shows incorrect CDR information and account. The accounts were truncated in Existing Reports. Developed a new program GECFA Trial Balance Detail for same.
• Aging Trial Balance Report:
• GE Commercial Finance is needed to get the ATB report for unpaid invoices for all the Europe countries and it will be By Stage, status and Collector. This report can be collected by two concurrent programs and the report will be in aging bucket format.
• Existing Reports were: GEFS EU ATB By Stage, status and Collector Excel format and GEFS EU ATB By Stage, status and Collector Period Adjusted
• The above two reports are for all the Europe countries which are in 7 Bucket format. Now Benelux is having new requirement to have 9 Bucket aging for above reports. So, need to develop the new program output with 9 aging columns. Create a Setup for Nine bucket aging report and modify the layout of report as per specification and created below reports: GEFS EU ATB By Stage, status and Collector Excel format -9 Bucket and GEFS EU ATB By Stage, status and Collector Period Adjusted 9 bucket.
• Customized Vat Tax Register report as per user requirement.
• Customized the GEFS EU Billing Receipt Report.
• Customized the GEFS IT Purchase Vat Register

Discoverer Reports: Developed Various Report of GL, AP and PO Module in discoverer.

FORMS:

• Customized GE Cost Centre Matrix Form and added two fields Initial IME and Target IME in form then migrated .fmx executable file to AU TOP on forms server of client and added above fields mapping table.
• Customized Sales Order Form.
• Created BSLA Security form GEASTDISCOSEC.fmb and register to Apps.
• Involved in the development of interfaces/ Conversions to import the data from legacy system into oracle application base tables.
• Worked on UTL PACKAGE and SQL LOADER for the interfaces and conversions.
• Interacting with Business Users, analyzing change requests, impact analysis, and implementation of the same
• Attend Meetings and discussion with Client for improvements in project and future course of project
• Attend Meetings with Various Businesses leads whose Business is to be integrated with Fleet, CFS and GECAS.
• Discussions with User to explain the various modules like GL/AP/CM/AR etc
• Handling cases raised by end users on daily basis involving problems in the areas of accessing to the application, request for having a new or additional access, technical problems like mapping errors and performance issues, incorrect data in reports, delay in process etc.
• Developed new Interfaces to enable the loading of data of new Businesses acquired by EEF or FLEET into GL or modifies the existing interface to accommodate the time-to-time changes in data format.
• Assisting business users in creating new reports and modifying existing reports in Discoverer.
• Preparation of setup documents for GL, AP, AR and CM Module.
• Providing consultation during acceptance testing and release of the product into the production environment
• Developed the Inbound interfaces and Extraction scripts for Oracle GL, AP and FA using PL/SQL and Unix Shell Scripting.
• System administrator Activities: - Create Concurrent Programs, Value sets, DFFs, Responsibilities, Menus, Reports, User Creations, registering forms etc. Month End and Year end Support.
• Development of database objects packages, procedures, triggers, views, etc. to provide custom functionality within the Oracle Applications.