PROFESSIONAL SYNOPSIS:

• Achieved 8yrs of rich experience in Oracle E-Business suite. My Prime expertise is as Oracle Technical consultant spreading to modules AR, OM and HRMS Package, also has very strong knowledge in BI/XML Publisher and ETL process and Business Intelligence.
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e. Stored Procedures, Packages, Views, Synonyms, Sequences, Functions & Triggers using PL/SQL Developer as development tools and Robust Technical skills in Front-end Development of Forms and Reports
• Worked extensively on technical Reporting components of Accounts receivables and Order management, having sufficient understanding of end to end process of Order to Cash modules, Customized complex reports like balance forward billing report, billing history reports.
• Have good knowledge on Payroll modules in terms of both technical and functional expertise like Elements, Element links, Entries, BEE(Batch Element Entry), Assignment sets, Element Sets, Continous-Caluclation, Retro Pay, Advance Pay, Fast formulas, Salary Basis ,Taxation, Balances etc
• Worked On Core HR modules like People (Enter and Maintain), Assignment, Work Structures, Mass Updates, and Budgets and besides has a extensive knowledge in Flex-fields, System Administrator and AOL. Hands-on experience also in personalization, People Management templates, Task flows and also on oracle application Diagnostics.
• Also have experience working on System Administration activities like user setup, defining responsibilities, value-sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs and Internal Audit
• Expertise with Unix Shell Scripting, Skill in Performance tuning of the database, Expert in utilities like Explain plans, SQL*Loader, Export, Import, UTL File.
• Strong experience with conversion using oracle API\'s, Web ADI, Data Loader and PL/SQL Programs. Developed several FAST FORMULAS for Payroll and Benefits elements. Extracted data from oracle into various flat files using utl_file functionality.
• Good Knowledge of Implementation Methodologies like AIM (MD200/MD60/70/BR100/CF250)
• Having strong Conceptual, Business and Analytical and problem solving skills .Excellent oral and written communication skills.

PROFESSIONAL EXPERIENCE:

Confidential,Houston, TX Oct-2010 to Feb-2012

Oracle E-Business Suite Technical Consultant- Distributed Order Orchestration

My role is to involve in Client discussions, analyze their legacy systems and work on solution architecture for high volume variable data processing for health care customers using Oracle BI Publisher. Worked with Java and Dot net developers in developing portals and UI for new BIP Integrated systems and use advance BIP features to develop various complex Reports which met both the Health care company requirements and CGX Printers limitations. CGX has also chosen to implement Oracle Financials- AR and GL module to maintain invoices for their direct client – Apple Inc and Blurb.
Responsibilities:

• My role was to develop new reports on XML Publisher so that Client can view them in Excel format.
• Had high level understanding on order to cash flow process focusing on OM and AR.
• Customized many reports like Generate Forward Balance report, Billing History Report to suit client requirements and developed them on XML Publisher and used Busting concepts.
• Worked on onsite-offshore model.
• Used AIM Implementation methodology for Requirement and Technical Design like MD50/70/BR100.
• Worked on Inbound/outbound interfaces and Conversions on modules related to AR.
• Only resource responsible for Health spring, BCBS, Care-First and Molina healthcare application’s integration with BIPublisher.
• Developed Proxy web-methods and web-services that can consume BIP web-services using Jdeveloper 10g.

Env: Oracle R12 E-Business Suite, PL/SQL, SQL, Toad, Sqlplus, Metalink, XML/BI Publisher

Confidential,Houston, TX Mar-10/Oct-10

Apps Consultant
GE Aero is US based company having manufacturing and facility centers across the globe, Aero manufactures various parts required for aircraft engines and also has servicing centers to handle warranties and repairing.

Responsibilities:

• Responsible to recommend and sanity test Oracle HRMS mandatory patches.
• Responsible to log HRMS TARS for Oracle support and resolve issues.
• Oracle HRMS Q2 -2010 SQWL patches coordinator

Env: Oracle 11i E business suite, PL/SQL, SQL, Toad, Sqlplus, Metalink

Confidential,Colorado Springs, CO Jun-06 / Feb-10

Application Engineer

The Oracle E-Business Suite Human Resources Management System family of applications automates the entire recruit-to-retire process, so you can align your workforce with strategic objectives. As a Developer need complete understanding of application and all code flows and play key role in fixing the bugs raised by customer, QA and working on ER’s (Enhancement requests).

Responsibilities:

• Maintenance of 11i and R12 versions of Core HR, IRec & US Payroll module.
• Well versed with ARCS – Version controlling system and hands-on experience on all deployment and migration stuff such as creating new file versions, branch versions, recording changes, maintaining several code lines (11i, R12 Main line, R12.1 Main line, their corresponding branch lines etc), checking compatibilities of various versions, suggesting customers on their patch download versions, building patch readme’s, part of several Oracle family pack and new version releases etc.
• Good Understanding on various Oracle file types such as ldts, lcts, hdts, hcts, odfs etc
• Great grip on ARU – an Oracle Patch building system.
• Building new enhancements.
• Fixing bugs in 11i and R12.
• Provide data fix for the customers when there is a data corruption.
• Looking into various modules like People (Enter and Maintain), Flex-fields, Assignment, Work Structures, Mass Updates, Budgets, Personalization, People Management Templates, Salary Basis, Absences, PTO (Paid Time Off), Elements, Balance adjustments, retro pay, pre and post payment processes and Fast Formulas etc.
• Interacting with support and customers to resolve the issues.
• Preparing internal documents.
• Database development included writing PL/SQL stored procedures, triggers, and functions.
• Preparing new diagnostics scripts for customers.
• Registration of Forms, Reports, Concurrent Programs and Menus. Created new Concurrent Programs to archive data from live tables and generating report from archived data using XML Publisher.
• Defining Values Sets, registration of reports and concurrent programs in applications.
• Specialized in various US Payroll modules like USHR, Taxation, Garnishments, SQWL, Quarterly JIT patches and Annual Geo-code patches.
• Handled year end and year begin releases for US payroll

Below are few Major Enhancements to mention –

Documents of Records:
The ‘Documents of record’ functionality will consolidate the maintenance of various personal and legislative documents in Oracle HRMS at one place. Initially it will provide an effective replacement to existing EIT based solutions provided for the purpose. In later phases it is under consideration to integrate with other modules in HRMS product family and consolidate other person documents, like resumes, contract notes, in this single repository.

Person Name Formats:
This enhancement is to provide flexible name formats throughout the eBusiness Suite. The chosen design allows Oracle Applications and customer code to display names in a consistent format by implementation of certain formatting rules. The rules themselves will be stored in one new table. Oracle will create and deliver the rules for a certain subset of name formats, as determined principally by the UI team.

VETS 100A Reports (For USHR Customers):
The VETS-100A Report is to be completed by each federal contractor or subcontractor with a contract or subcontract entered into or modified on or after December 1, 2003, in the amount of $100,000 or more with any department or agency of the United States for the procurement of personal property and non-personal services (including construction).

As part of this Enhancement, developed VETS 100A Suite of Reports which comprised the below list of reports.
VETS-100A Consolidated Veterans Employment Report
VETS-100A Employment Listing
VETS-100A Veterans Employment Report (SIGNLE)
VETS-100A Veterans Employment Report – all establishments
Electronic VETS 100A Report

Env: Ebiz suite 11i / R12 PAY, HR, USPAY, IREC, SSHR, XML Publisher, Oracle reports 9i, Oracle Forms 9i

Confidential,Hyderabad, India Mar-04 / May-06

Associate Apps Technical Consultant

My responsibility includes overall maintenance of the application.

Responsibilities:

• Maintaining the Payroll runs (Weekly and Monthly runs), In case of any issues we need to resolve quickly
• Need to find out the root cause of the problem.
• Gathering the complete requirements for all kinds of enhancements and code fixes and help the testing team in preparing the case before fixing the main issue.
• Regular continuous support to resolve day to day issues which will come through Service Center incidents.
• Fine tuning the sqls which takes more time to complete in Production.
• Using HRMS APIs for bulk loads and data migration.
• Train the new comers on basic fundamentals of HRMS, data dictionary, elements, and fast formulas, Accruals, Interfaces, Alerts, APIs, Hooks, Concurrent Manager and Payroll Cycle.
• Preparing and Reviewing Documents.
• Wrote various Form Level trigger at the backend to implement specific business rules and policies
• Developed scripts using FNDLOAD to migrate concurrent programs, value sets, and concurrent managers and profile options.
• Developed Web ADI Scripts for validating and loading data into Oracle base tables.
• Developed custom conversion code to import data into tables using standard API’s for HR and payroll
• Assisted functional team in meetings with end-user to finalize the technical requirements for the features that we implemented in Payroll and OAB like PTO, Retro, FLSA, Costing, Employee, Payroll and Balance Conversion, Benefit Program, Plan Types, Plans and Options
• Designed and defined Benefits which included creating Pre-tax deductions, voluntary deductions, and custom taxability rules.
• Designed and provided several solutions to client with form personalization and customizations for requirements specific to HFL.
• Setup and configured Oracle Enhanced Retro Pay functionality

Product /Env: 11i E-Business Suite (Payroll and HR), Oracle 9i