SUMMARY:

• 14 years of experience as an Oracle Applications Functional and Technical consultant (Release 11i and R12).
• Adept in understanding and compiling Business Requirements and architecting them into integrated Systems and Solutions with proven strong Interpersonal and Communication Skills.
• Skilled in Developing Test Cases for Unit and Functional testing. Worked in Multi - Org and Multi-Currency environments.
• Expertise in GAPS, managing all post implementation support activities including responding to end user questions and resolving production issues.
• Involved in Analysis, Design, Development and Implementation phases of complete Software Development Life Cycle.
• Well experienced in communicating with the End Users, Application Specialists, Network Consultants, Co-Functional Consultants, Design Architects, and Developers and with the superior management levels of hierarchy.
• Involved in the contribution of RFP response, highlighting best industry practices on Enterprise Risk Management, Knowledge transfer, Change Management, Org Chart preparation based on the SOW scope.

TECHNICAL SKILLS:

HUMAN RESOURCES: iCIMS, iRecruitment, Core, Self Service HR, Incentive Compensation, Compensation Workbench, Advance Benefits, Fast Formulas, Individual Compensation Distribution, ADP GOL, AME, Aurico

FINANCE: Accounts Receivable(AR), Accounts Payable(AP), Lease Management, Subledger Accounting

SUPPLY CHAIN MANAGEMENT: Purchasing, Customs, iSupplier, Sourcing

TOOLS: MS Excel, PowerPoint, Word, ServiceNow, Sailpoint,, HP Service Desk(HPSD), Mercury Quality Center(MQC), PVCS, Kintana, TOAD, Workflow Builder

LANGUAGES: SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Integration specialist involved in interface design and testing between Oracle and iCIMS using Web services REST API.
• Acted as a liaison between IT, Business, Project Management and Stake Holders.
• Shared services resource working on Oracle R12, iCIMS, Data warehouse and other 3rd party tools.
• Participated in the separation process of International Operations (Europe) from North America, by building a “virtual wall” in the system.
• Configured Compensation Workbench for International Operations.
• Involved in Open Enrollment for Benefits.
• Designed and configured Vision and Medical plans to be sent over to benefit providers.
• Experience supporting payroll interfaces with 3rd party vendors (ADP GOL) around the globe.
• Handle global deployment scenarios across North America and International, and ensure the deployments are reflected in iCIMS.
• Worked with Data warehousing team to map the required data fields from Oracle R12 to Oracle DW instances.
• Involved in testing the setup of GMF proxy server to re-route traffic between iCIMS and Oracle cloud services using TLS 1.2 encryption.
• Analyze the defects and develop process improvement techniques to achieve system stability.

Environment: Core/Self-Service HR, iCIMS, iRecruitment, Advance Benefits, Compensation Workbench, ADP GOL, RESTAPI Tool, Broadbean, Aurico, AME, Workflows, PL/SQL, Microsoft Word, Excel, Power Point, F5 Single Sign On (SSO).

Confidential

Responsibilities:

• Prepared conversion mapping documents based on transformation logic.
• Design test documents and data validation scripts.
• Involved client and third party vendors as part of SIT, UAT test cycles and bring resolution to defects

Environment: OFSAA, Microsoft Word, Power Point, Excel.

Confidential

Responsibilities:

• Include Narratives in RFP response to prospective clients on PwC processes related to Change Management, Risk Controls assessment, best practices, and Knowledge transfer
• Designed Organization Chart based on the proposed team structure
• Explain the challenges faced by the organization during earlier implementations and the remediation measures to overcome the challenges
• Categorize and maintain a list of Banking and Capital market accounts to track, market and prioritize the accounts for Sales team

Environment: Oracle Applications 11i, R12, Microsoft Word, Power Point, Excel.

Confidential

HRMS Functional Analyst

Responsibilities:

• Designed 11i to R12 conversion documents for North America.
• Implement Incentive Compensation in North America for Monthly, Quarterly and Annual plans for Sales and Credit.
• Designed Interface between Data-warehouse and OIC for collection transactions and resource quota load.
• Used custom matching attributes in Territory Manager to allocate sales credits in OIC.
• Configured AME rules in R12 for Self-Service HR modules.
• Configure work structures.
• Helped prepare documents in OIC.
• Involved in International Operations HRMS reporting track.
• Designed the functional spec for 24+ reports, tested and resolved issues raised in testing cycle/Production.
• Worked with business users in Europe to complete HR reports related to Headcount, Individual Comp Distribution elements, Salary ranges, anniversary, promotions, new hire and terminations, direct deposit of 2000+ employees and contingents.
• Drive the status calls with International users based in Europe.
• Reporting happened across 17 business groups or a single group based on the security settings.

Environment: Oracle Applications 11i, R12 - Core, Self Service HR, Incentive Compensation, CRM, Territory Manager, Individual Compensation Distribution, XML-Publisher, AME.

Confidential

Functional Analyst

Responsibilities:

• Involved in R12 upgrade
• Prioritized all I2C RICEW items after discussions with business to move them into appropriate test cycles
• Reviewed RICEW items to agree on retired and retrofit decisions with business
• Categorized RICEW list based on I2C sub-process and mapped it with the business requirements for Fit-Gap Analysis
• Designed the As-Is and To-Be process flows
• Used Revenue Accounting Management (RAM) wizard to provide a solution to amortize discounts over revenue recognition period
• Resolved Period Close and SLA reconciliation issues.
• Analyzed the feasibility to replace current 3rd party Payment system with iReceivables
• Involved in CRP testing and monitor SRs

Environment: Oracle Applications 11.5.10, R12 - Receivables, Subledger Accounting, iReceivables, Reports & Forms 10g.

Confidential

Supply Chain Functional Consultant

Responsibilities:

• Involved in R12 implementation
• Designed the functional spec, technical spec to create Move Orders based on data populated from Maximo in oracle reservations interface table
• Designed the functional spec, technical spec to approve Move Orders using AME
• Resolved critical and high severity defects in Sourcing, iSupplier, Purchasing, Payables, Cash Management, iExpenses, Contracts, Inventory
• Worked with Oracle support to fix defects related to SR

Environment: Oracle Applications R12 - Sourcing, iSupplier, Purchasing, Payables, Cash Management, iExpenses, Contracts, Inventory, Maximo, Reports & Forms 10g.

Confidential

Finance Functional Consultant

Responsibilities:

• Involved in R12 upgrade from 11. .1.3
• Retrofit and testing of components to function in R12 environment
• Involved in CRP testing and migration activities
• Designed and developed Bill Presentment Architecture (BPA) views to reuse the invoice templates across multiple operating units
• Performed Treasury Bank Account DFF conversion

Environment: Oracle Applications 11.5.10, R12 - AR, AP, Confidential Ledger, Purchasing, Reports & Forms 10g.

Confidential

HRMS Functional Support

Responsibilities:

• Worked on Severity 1, 2, 3 level tickets related to Advance Benefits, HRMS, OTL, and Payroll
• There were multiple business groups involved in both 11i and R12
• Troubleshoot production issues by replicating in Test instances and update the user and technical team on its root cause
• Interacted with Oracle Support team on patches and TAR required as part of resolving the tickets
• Involved in the configuration of new Business Groups based on BR100

Environment: Oracle Applications 11.5.10, R12 - Advance Benefits, Payroll, OTL, HRMS, SQL, Discoverer, Footprints Issue tracker.

Confidential

Finance Techno-functional Analyst

Responsibilities:

• Designed Late Asset return invoices program to calculate the late fee, for assets which were returned after the due date
• Involved in designing a solution to move the Payment Terms from Customer Bill-To Site to contract header for existing and new contracts
• Designed and developed Value Added Tax (VAT) engine for AR/AP which retrieves tax codes based on multiple levels of hierarchy like customer, payment level, item or default level

Environment: Oracle Applications 11.5.10 - AR, AP, Lease Management (OLM), PL/SQL, OA Framework, JDeveloper, Forms and Reports 6i, XML Publisher, PVCS, Kintana, Mercury Quality Center (MQC), AOL.

Confidential

Senior Software Engineer

Responsibilities:

• Developed Benefit proration fast formula (FF) to calculate the defined, communicated and annual amount based on plan coverage and life event for an employee.
• Involved in design, development and testin
• Developed Alerts using SMTP mail to send emails to HR users during reverse termination, change in employee assignment category, benefits group, government reporting entity
• Developed outbound interfaces using HIPAA standards and ftp the output file to various vendors
• Developed a data validation report to compare the earnings, deductions and taxes in payroll and archive records and display the difference
• Added summary columns by elements and location in Payroll Register report for earnings, deductions and taxes

Environment: Oracle Applications R12 - Payroll, Advance Benefits, HRMS, PL/SQL, Reports 6i, Fast Formulas.

Confidential

Senior Software Engineer

Responsibilities:

• Designer/Developer role involved in developing technical design documents (MD70, TE20)
• Conducted review meetings with onshore clients. Prepared Minutes of Meeting (MOM) and Implemented review comments raised during stage meetings, in MD70 and TE20
• Lead a team of 8 members to analyse and fix production change requests (CR's) raised by business users. Involved in daily status calls with functional team to update the status and get clarification on open questions in Finance CR's
• Developed technical design and test documents to include the option of converting fixed rate contracts to Floating rate contracts in Netherlands Operating Unit
• Billing request set programs were updated to compute variable rate interest based on the amortization schedules of contracts, taking into consideration the billing cycle, billing period for Advance and Arrears billed contracts
• Involved in Pre-Sales activities, worked closely with sales team to assist them with getting projects for the organization
• Conducted for new joiners, making them understand the business process and their relation to the underlying technical architecture
• Delivered GAPs within the delivery date, working with a team comprising of new joiners in the project

Environment: Oracle Applications 11.5.10 - AR, AP, Lease Management (OLM), PL/SQLOA Framework, JDeveloper, Forms and Reports 6i, XML Publisher, PVCS, Kintana, AOL, Mercury Quality Center (MQC).

Confidential

IT Analyst

Responsibilities:

• Involved in Joint Order ability project which integrates Oracle and SAP systems (implemented at a company acquired by Cisco)
• Products are booked and invoiced from Oracle. Shipping happens from SAP which in-turn triggers shipment in Oracle through an ASN signal
• Involved in the preparation of Functional Specification, Technical Specification, Unit test cases and regression testing
• Redesigned Cisco Customs Bolt-on tools to accommodate Non-Cisco items
• Designed API to populate and retrieve Harmonized Tariff schedule (HTS) and Country of origin (COO) for Non- Cisco items
• Involved in analyzing and fixing defects raised as part of Test cycles
• Documented test transition steps which is used during migration of objects in each test cycle
• Used PVCS software configuration management tool to maintain the code versions

Environment: Oracle Applications 12.0.4, 11.5.9 - Order Management, Shipping & Customs, Inventory, Purchasing, OA Framework, JDeveloper, Discoverer Reports 3i and 10g, Reports 6i and PL/SQL.

Confidential

Business Analyst

Responsibilities:

• Designed the Approved Supplier list for the Items which will default on PO’s. Updated the Cost Data report to retrieve the Vendor name for a Drop-Ship Item
• Designed Discoverer reports for Closed (Active), Booked (Not invoiced) customers, Customers without CMS or CMS expired and Renewal success rate% for Calix Management System (CMS)
• 12i - Involved in the upgrade of Oracle Discoverer version 3.1 to Oracle BIDiscoverer 10g (10.1.2)

Environment: Oracle Applications 12.0.4, Oracle Applications 11.5.9 - Advance Pricing, OM, SHP, INV, PO, Discoverer Reports 3i and 10g, Reports 6i, PL/SQL.

Confidential

Assistant Systems Engineer

Responsibilities:

• Analysis, Design and Development of MD70 technical documents based on the MD50, Functional documents and business requirements
• Supported for APPS 11i Implementation for functionality and technical bug fixings
• Involved in Oracle Discoverer installation and Configuration with Oracle Applications
• Involved in Oracle Discoverer Administration, Creating EUL schemas, Discoverer Classes and EUL user Administrations

ENVIRONMENT: Oracle Applications 11.5.10 OA Framework, Discoverer 4i, Reports 6i.

Confidential

Assistant Systems Engineer

Responsibilities:

• Developed programs using shipping API’s to update the freight costs and complete the ship-confirm process
• Developed and implemented SQL Loader programs for data loading
• Mapping of the organization structure of the client-business group, operating unit, legal entity, inventory organization and the set of books

ENVIRONMENT: HP-Unix-11.0, Oracle Applications 11.5.8, Oracle 8.1.7, Reports 6i.

Confidential

Programmer Analyst

Responsibilities:

• Analysis, Design and Development of MD70 technical documents based on the Functional documents and business requirements
• Review of change Requests, implementing the changes as per the customer requirements
• Interaction with onsite co-coordinators and implementing the changes as appropriate.
• Involved in Oracle Applications System Administration activities including Creating users, responsibilities, Concurrent Managers etc.
• Involved in Defining Data groups, Request groups, Registering new Reports, testing new forms and Reports from browsers etc.

ENVIRONMENT: Oracle 8.1.7 & 9.0.2, Oracle Applications 11.5.8 & 11.5.9 on HP-UX, Reports 6i.