SUMMARY

• Over 9 years of consulting experience on Oracle E - Business Suite and Oracle technologies.
• Strong experience in functional analysis, technical development, and implementation setups for Oracle EBS R12 and 11i modules: Order Management, Fixed Assets, General Ledger, Account Payables, Account Receivables, Oracle Purchasing, Order Management, Time and Labor, Labor Distribution, Human Resources, Payroll, Advanced Benefits, Performance Management & Learning Management.
• Gathered business requirements and GAP analysis. Configured Functional setups for Interfaces, Conversions in Financial Accounting Hub (FAH) and Accounts Payables modules and Supply chain Modules.
• High expertise in Oracle Financials: AR, AP, Financial Accounting Hub (FAH), GL | Oracle Supply Chain Management (SCM): Purchasing, Inventory, Order Management, Landed Cost Management | Oracle Process Manufacturing: Product Development, Process Execution, Quality Management, OPM Financials.
• Oracle Certified in R12 iProcurement.
• Involved in company setup (implementation) as a part of the Global ERP project.
• Submitted Proof of Concept of using Landed Cost Management (LCM) to skip Advanced Pricing.
• Developed Business Process, Business Requirements, MD 50/70, Configuration, Test Condition, Test Scripts documents and Functional testing across PT, SIT, UAT and Pre-Prod phases.
• Experience in Oracle interfacing to third party tools Inbound and outbound and Conversions, OAF Forms. Expert Skills in Report Development and customization, XML/BI Publisher report and Oracle forms development.
• Technical Expertise in application development using Oracle SOA Suite, JDeveloper, Application Development Framework (ADF), OA Framework, OBIEE, OBIA, BI Publisher, Discoverer, Oracle PL/SQL, Oracle Forms and Reports.
• Played roles as Techno Functional consultant, Technical lead / developer with activities: interacting with the business users, defining functional requirements, identifying functional and technical gaps, work estimation, architecting system interfaces, designing custom solutions, programming, leading development team, work scheduling, project documentation, and providing production support.
• Defined Month End/Year End Processes, OAF Screens, BI Publisher Reports, Concurrent Program, Concurrent Sets, Archiving processes and customizations in Forms & Reports.
• Thorough understanding of Oracle EBS Internal Architecture & Design.
• Active involvement in resolving pre and post-implementation problems.
• Thorough understanding of the high-level business process. Translation of business requirements into Functional and Technical design documents.
• Extensive experience in full System Development Life Cycle (SDLC) including analysis, specification, software and database design, development, maintenance, testing and production support.
• Excellent logical and analytical skills. Good communication and interpersonal skills.

TECHNICAL SKILLS

ERP: Oracle Apps R12 and 11i

Modules: Financials, Supply Chain Management and Manufacturing/ OM, OPM, GL, AP, AR, Financial Accounting Hub (FAH), Purchasing, Procurement, WIP, BOM, Time and Labor, Labor Distribution, Human Resources, Payroll, Advanced Benefits, Performance Management & Learning Management

Fusion Technologies: Oracle SOA Suite, BPEL, ADF, OA Framework

GUI Tools: Oracle Developer Suite (Forms 10g, 9i, 6i Reports 10g, 9i, 6i)

RDBMS: Oracle 11g, 10g, 9i, 8i, 8.0 & 7.x

Utilities: SQL Navigator, SQL Developer, TOAD, and Oracle Discoverer

Operation System: Linux, UNIX, Windows 7 - 98, Windows NT

Languages: C, C++, Java, C# and Oracle SQL, PL/SQL

Other Tools: Altova® XMLSPY, Visual Basic, Crystal Reports 7, 6

PROFESSIONAL EXPERIENCE

Confidential, PA

Oracle Apps R12 Order Management and Supply Chain

Responsibilities:

• Define functional requirements, created MD50 for LCB process in Order Management and Oracle Retail.
• Configured the Functional setups for Sales Order Conversion and OPM Operations Conversion.
• Build XSD and BPEL process flows for each extensions.
• Architect the BPEL event logging, error handling and recovery procedures.
• Designed workflow process, and defined the XML output to be consumed by the ESB process.
• Lead the onsite and offshore technical development team.
• Interaction and working closely with Oracle Point of Sale implementation team from Skillnet and LCB, to address any integration issues.
• Leveraged seeded Oracle Retail interface to Point of Sale and addressed version issues. Redesigned the extracts to provide on demand full extracts and daily incremental extracts.
• Designed the invoice report to be printed directly from Order submission using BI Publisher server, eliminating any physical file creation.
• Developed item pricing calculator in Oracle Retail - RPM.
• Built user guides and trained super users. Assisted users in testing the system.
• Resolved Functional and Technical gaps.
• Worked with Onshore and designed technical documents and developed Sales Order and OPM Operations Conversion
• Worked on OAF forms in OPM modules
• Developed various reports (RDF & XML (rtf and excel templates)) and Extensions.
• Submitted Proof of Concept of using Landed Cost Management (LCM) to skip Advanced Pricing.
• Worked on Auto invoice configurations in AR.

Environment: Oracle Apps R12 Order Management, Oracle Retail, SOA Suite - BPEL, Workflow, BI Publisher, Reports 10g, Oracle 10g on UNIX

Confidential

GL/AP Integration & Procurement

Responsibilities:

• Involved in documenting the business processes, requirements definition, and performed gap/fit analysis for General Ledger, Payables, and Purchasing modules. Documented as-is and to-be processes in RD.20 and RD.30 respectively and prepared/updated the BR.100s for GL, AP, and PO in line with the AIM methodology.
• Involved in the design of Supplier Master, configuring system options, distribution sets, bank setups, etc. in Payables.
• Gathered business requirements for the centralized payment process across multiple organizations and translated them to business processes to set up payment processing formats, payment process profiles, etc.
• Created custom templates with different selection criteria for weekly check runs of disbursements.
• Configured the Functional setups for JDEAP-FAH and JDEAR-FAH Inbound Interfaces.
• Developed complex Inbound Interfaces in Financial Accounting Hub (FAH) for JD Edwards’s legacy.
• Performed administrative tasks such as defining user security and applications responsibilities, creating custom menus, creating and managing report groups, report sets, and custom menus.
• Involved in the creation of roles and role hierarchies, managing user registrations and approvals, managing permission sets/grants through Oracle User Management/RBAC.
• Worked with HR to ensure email addresses are specified for each employee linked to a user and that appropriate hierarchies and approval limits were set up and did not violate control procedures.
• Worked on AP Outbound Payments interface using e-text format as per the client requirement
• Created UPK recordings in iProcurement, iSupplier, Purchasing, Sourcing and Contracts
• Worked with Onshore and developed technical designs for AP Payments Outbound Interface, UBC-FAH Inbound Interface, JDEAP-FAH Inbound Interface

Environment: Oracle Apps R12 Financials, Purchasing, Financial Accounting Hub, JD Edwards, BI Publisher, Reports 10g, Oracle 11g and UNIX.

Confidential

Responsibilities:

• Identified and mapped business requirements, translated into technical deliverables and executed in technical progress for RDF and XML(BI Publisher) reports, OAF Forms
• Prepared functional specification documents for customizations (mostly reports) involving GL, AP, AR, and PA modules.
• Customized Oracle’s seeded Payment format to generate Payables Checks for Suppliers and Subcontractors. Responsible for creating BI templates for both Supplier as well as Subcontractor checks.
• Customized Oracle’s seeded check styles for payroll checks, direct deposit checks, and Garnishments (third party checks). BI Publisher is used to create the templates for all the check types.
• Led the reporting phase of the project including overseeing the offshore team and the local team for successful implementation of the customizations.
• Worked on Oracle Application Framework (OAF) in Supply chain module.
• Worked on the development of xml reports especially in tuning SLA/XLA queries and conversion from discoverer to xml reports.

Environment: Oracle Apps R12 Financials, Project Accounting, OA Framework, Workflow, BI Publisher, Oracle 11g on UNIX

Confidential

Responsibilities:

• Responsible for gathering the requirements for RICE objects and designed the CV40s, MD50s, CV60s, and MD70s and helped the business to identify the right solution.
• Mapped the business requirements to Oracle Applications, Design solutions.
• Designed and Developed the Open Invoice Conversion from Legacy to Oracle eBS.
• Designed and developed the common error handling process across the OD team.
• Designed and Developed and modified the NACHA Payment Formats Report as per the Business and Bank Requirements.
• Designed and Developed Payment Batch Automation for Wachovia Bank and Confidential .
• Designed and Developed Auto-Confirm Payment Batch for the Payment Batches formatted for the CHECKS.
• Added the text to cash and other expenses page using OAF Personalization.
• Designed and Developed BPEL processes to copy the files from out directory to common outbound directory.
• Designed and Developed Custom Supplier Confirmed Receivable Process (Custom Tables, Forms, Reports, Payables Interface, XML Bursting Process).
• Developed the Electronic Billing and Consolidated Invoice Reports for AR.
• Formulated the test scripts and validate the deliverables.
• Wrote TE20s for UAT testing and assisted in Integration testing, tracked the issues and resolved the issues.
• Used Share Point for version control for code and JIRA for AIM Documents.
• Used Kintana for migrating code to all instances.
• Involved in Integration test and developed TE40s.
• Worked with Onshore and developed technical designs for GL COA Segment Value Sets Extract (Oracle GL to Concur) and AP Open Invoices Conversion.
• Designed Configured and Developed AP Invoices Conversion and got succeeded with 99.8% accuracy in Production.
• Worked on Complex Roll Forward Report which was a combination of 3 reports

Environment: Oracle Apps R12 CRM, Financials, Supply Chain, Order Management, Workflow, BI Publisher, Forms and Reports 10g, Oracle 10g, UNIX