SUMMARY:

• 8+ years of experience in Software Industry as Techno Functional Consultant, with proficiency in Oracle Applications SCM and Finance and HRMS modules (11i and R12)
• Solid of experience in software development and practices. I have been involved in analysis, design, coding and testing phases of different projects. I have extensive knowledge on usage of other technical tools and technologies like Putty, WINSCP.
• I have proficient inOracleReports, Forms, XML Publishers, Interface, Conversions, Web ADI, Alert, PL/SQL, SQL etc.
• Excellent at doing setups by defining and designing the Key Flex Fields and Descriptive Flex Fields based on the Context Sensitivity for the oracle HRMS Job, Position, Grade, Cost Allocation and Competency.
• Having good Experience on functional flow of Oracle Application Modules, which include Oracle HRMS, Oracle Payroll, Accounts Payable (AP), Purchasing (PO), General Ledger (GL), Inventory(INV), Order Management(OM), Trading Community Architecture (TCA), Receivables (AR), Service Requests, Self - Service, OAB.
• Worked towards leading and managing projects, worked with multiple stakeholders, communicated with them effectively, execution of Project according to Project Plan, Risk management, Requirement analysis, produced high quality deliverable within Project timeline and budgetary targets.
• Strong experience in Oracle Applications 11i, R12, R12.1(Core HRMS, Payroll, SSHR,OTL, Fast Formula) and order creation and the O2C and P2P process for SCM.
• Involved in performance tuning inOracleusing Explain plan and TK prof.
• I have worked in both 11i and R12. In R12 has exposure Sub Ledger Accounting, MOAC, E Business Tax modules.
• I have performed the following roles in this time. Expertise includes analysis, design, estimation, coding, testing, migrating and maintenance of application software with good working knowledge in various platforms i.e. Oracle 10g/9i/8.x/7.x, SQL*Plus, PL/SQL, Forms 9i/6i//4.5, Reports 6i/2.5, Discoverer 10g/4i and Unix Shell Scripts, XML Publisher Reports.
• Good knowledge of Code movement using FND LOAD for concurrent Programs, Request sets, AOL objects and BI Publisher templates etc.
• Having good knowledge of Using Oracle Seeded API’s on several modules and HCM fusion.
• Successfully accomplished numerous full cycle Oracle EBS implementations across multiple industries in Public/Private Sectors.
• Having good knowledge on SQL*Loader, Data Loader, OTBI (Oracle Transactional Business Intelligence), OAF, Discover Reports and developed user interface components using ADF Rich Faces and data controls.
• Managing and leading the technical team.Technical analysis and Due Diligence of a proposed project. Interacting with client and gathering requirements.Analysis of Functional Design documents.Development of Technical Design Specifications of Interfaces, Forms, Reports, Alert, Shell Scripts etc.

TECHNICAL SKILLS

ERP: Oracle Applications 11i Suite, Release 12

Databases: Oracle 8i, 9i, 10g

Oracle Applications: Oracle HRMS, Oracle Payroll, OAB, Oracle Financials/ Manufacturing 12/11i/ 11.0.2/10.7/10.7 sc/10.6,Order management, Inventory, PO, GL, AP, AR, Sys Admin & AOL)

Languages: SQL, PL/SQL, C, C++, JAVA

Reporting Tools: XML Publisher, BI Publisher, OTBI reports, Reports 6i, 10g

Other Tools: TOAD, Data Loader, SQL*Loader, Forms6i/10g, Reports 6i/10g, Bartender tool (Bar codes), WinSCP, Putty, OAF, Discover Reports, ADF

Integration Tools: Oracle SOA Suite 10.1.3, Oracle ESB (Database Adapter, File Adapter, AQ Adapter, Oracle Applications Adapter and JMS Adapter), OracleDeveloper

Operating Systems: UNIX, Windows NT/XP/98/2000

PROFESSIONAL EXPERIENCE:

Confidential

Techno-Functional Developer

Responsibilities:

• I have worked on the modules like Account Receivables, Lease Management and Supply Chain management. Current I have started worked with the Lease Management wherein I had an opportunity to develop the code for store master conversion and lease management conversion.
• Payroll-Setup for Child Support and alimony
• Payroll-Setup for Salary advance deduction
• Payroll-Setup for Employee Voluntary Contribution
• Payroll-Setup for Retro pay elements
• Onsite Coordinator for Data Conversion from Legacy to Oracle HRMS.
• Oracle HRMS Implementation using AIM Development methodologies, techniques, and standards
• Analyzing the legacy HR/Payroll system data and processes and co-relating with the process within the Oracle HR/Payroll.
• Extensively involved in impact analysis of adding Contingent workers in HR/Payroll.
• Involved in Oracle HRMS functionality such as Creating Security profile, Responsibility, registering concurrent programs, executables, form functions, defining users, administer responsibilities, adding custom reports/processes to request groups and several other related tasks. Configuring Jobs, KFF, DFF, Organization, Hierarchy, Grades, Locations, SIT, People Group, Absence, Appraisal, Fast Formulae, Web-ADI, OA-Framework, Form Personalization, and User hooks etc.
• Responsible for the HR, Payroll and SSHR end user issues resolution.

Environment: Oracle HRMS, Oracle payroll, Advanced PL/SQL, XML Publisher, SOA Integrated gateway WADL Service.

Confidential

Techno-Functional Developer

Responsibilities:

• Involved in writing fast formulas for tax calculation and PL/SQL Code for Direct Deposit.
• Provide technical and functional support to users and help them in understanding Oracle R12 application.
• Developed Custom Reports for Oracle HR and Payroll. Some of the reports are Over Time Report per Payroll, New Hire Report, Head Count Report, and Terminations Report.
• Defined Elements, Payment Methods, Payrolls, DFFs & KFFs, Organizations, Organization Hierarchies, Grades, Jobs, Positions, Special Information Types, Extra Information Types, pay slips, Statement of Earnings(SOE), Events, Event Groups, User Defined Tables(UDTs), Global Values, Lookups, Element Links, Absences, Costing.
• Invoice Integration for the third-party tools like ECOVA, TAX, TAX HQ, POS, Freight, Garnishment I have used the Gateway Integration tool with which it is integrated with Rest Service and import the data to oracle.
• Created a package which will be integrated with Rest Service and generate the XML at WebLogic and send in the data to oracle as part of XML and with Integration tool the data will be imported and migrated to oracle after business validation.
• AP Invoices Interface which I worked will be importing the third-party data to oracle in multiple formats using the web service as an interface.
• Created the logic for AP Standard Invoices to interface with REST SERVICE (middleware tool) in getting the inputs and creating the records in oracle without any issues and triggering the standard oracle import program for populating invoices to oracle.
• I have used the tax software 3rd party tool in extracting the inputs and integrating the records to REST SERIVCE for spawning the oracle package for validating the records and populating to oracle.
• Design and develop interfaces in Oracle EBS R12 for existing legacy systems data for the Oracle HRMS module.

Environment: SQL, PL/SQL, E-Text Templates, XML Publisher, RDF, Oracle Forms, SOA Integrated gateway WADL Service, UNIX Shell Scripting, SIT, EIT for Oracle HRMS, DFF and KFF for Jobs, Postions.

Confidential

Technical Developer

Responsibilities:

• Solely responsible for format payments module project related migrations.
• Involved in Functionally creation of payments and research on tables for populating.
• Worked on 15 complex format payments for upgrade and to find the replacement tables while creating payments.
• Retrofitted payment formats for Mexico, china and European countries for meeting their requirement for R12 upgrade.
• Worked with ONSITE team for getting inputs and generating the check printing for Confidential, Dollar and Peso report which are one of the complicated reports.
• Involved in the Process Setup by defining the Key Flex Fields and Descriptive Flex Fields for Jobs, Positions, and Grade as per the company’s existing system.

Environment: SQL, PL/SQL, E-Text Templates, XML Publisher, Oracle Report.

Confidential

Sr. Associate

Responsibilities:

• Mainly involved in the ONSITE and OFFSHORE Communications for Issues gathering for updating the changes to meet the R12 related changes.
• Mainly involved in Oracle SQL, PL/SQL design & development.
• Involved in code review and SQL tuning.
• Solely responsible for all project related migrations and deployments to QC and production environments.
• Involved in handled production problem tickets and issue resolution.
• Involved in post-production support.
• Mentored new team members.
• Involved majorly in the onsite support roles.

Environment: SQL, PL/SQL, Oracle Report.

Confidential, Milwaukee

Technical Associate

Responsibilities:

• Involved in Payroll Creation Setup and running various processes, such as Payroll Run, Prepayments, Cheque Writer, Costing, Cost Break Down Report and finally to Transfer the payroll data by running the Transfer to GL process.
• Mainly Involved in Design and Development planning.
• Requirement gathering and clarification of scope from Customer.
• Preparation of Impact Analysis for Efforts needed out of the scope.
• Solving the high-level issues from customers and Onsite counterparts.
• Involved in data migration of assignment information.

Environment: Oracle HRMS, Toad, Oracle Reports, Putty, SQL, PL/SQL

Confidential, Milwaukee

Sr Oracle Developer

Responsibilities:

• Played a very crucial role in gathering the requirement and flat files for mapping the fields involved more on client calls.
• Reviewing the new requests and change the existing mapping based on the new business requirements.
• Prepared the Documentation for the mappings according to the Design logic used in the mapping.
• Resolved if any issues in transformations and mappings with help of Technical specifications.

Environment: Toad, Oracle apps functional setups, SQL, PL/SQL

Confidential, Milwaukee

Technical Developer

Responsibilities:

• Reviewed the new requests and change the existing mapping based on the new business requirements.
• Prepared the Documentation for the changes according to the Design logic used in the mapping.
• Resolved if any issues in transformations and mappings with help of Technical specifications.

Environment: Oracle Report, RDF and XML Publisher reports.

Confidential

Technical Developer

Responsibilities:

• Developed control files for SQL* Loader and PL/SQL scripts for loading and validating data into interface tables from legacy system.
• Worked on Inbound Interface like requisition and Journals import.
• Worked on outbound interfaces like Purchase orders and journals using UTL FILE.
• Developed reports from modules like GL, AP and PO.
• Good working experience in System Administration like defining executables, concurrent programs, user set up, defining responsibilities, and adding menus, forms, reports.

Environment: Oracle Applications 11.5.9 (GL, AP, PO, Sys Admin), Oracle 9i, Reports 6i, Windows XP, UNIX, SQL*Loader, Discoverer 4i