A highly motivated, success oriented IT professional with over Fifteen years of experience in designing, developing and implementing Oracle ERP Applications to support strategic business objectives. Primary field of expertise is in Oracle HCM/Payroll/Financials. Worked in Oracle Product development group as Sr. Applications developer to design and develop key functional features in Oracle HCM/Payroll. Areas of expertise encompass: requirements gathering, analysis, design, development, process improvement, documentation, customer support, testing, user training, troubleshooting and Project Management.

Confidential

Environment: Oracle 11g, SQL, PL/SQL, Oracle APEX, Oracle Managed Cloud System and Linux OS.

Job Title: Sr. Oracle Consultant

Responsibilities:

• Involved in New core interface solution NCIS design, development and documentation work. NCIS is used to interface HUDCAPS budget data to ARC Financials systems and ARC Travel GL transactions to HUDCAPS.
• Designed and developed Crosswalk Mapping and Data loader program to validate and load data into NCIS that maps ARC Financial system account segments to HUDCAPS account segments.
• Involved in development of NCIS Budget Interface and NCIS GL Interface programs.

Confidential

Environment: Oracle Applications Release 11.5.10.2, R12.1.3 Oracle Federal Financials, PRISM 6.5 Procurement

Job Title: Sr. Financial Application Specialist

Responsibilities:

• Impact Analysis and development of retrofit code for Oracle e-business suite upgrade from release 11i to 12.1.3 for PO, AP modules, custom RICE objects and Oracle Compusearch interface OCI components.
• Identification, analysis, validation and correction of data integrity errors as they relate to any of the following transaction flows: PRISM-to-PO, P2P, AR-to-GL, PO-to-GL and Intra-bureau/agency reconciliations/eliminations.
• Process improvement of OCI interface code to triage and resolve day to day production issues quickly.
• Designed and Developed Reports and processes to meet division data extraction needs and to automate and increase the efficiency and effectiveness of reconciliation, data validation and error detection efforts in Oracle EBS.
• Designed and developed OCI interface solution to avoid re-establishment of commitment issue when a PO line is de-obligated and sent from PRISM to Oracle PO that causes funds reserve failure in PRISM applications.
• Designed and developed 'PRISM Active Lines' functionality for OCI interface Award modifications sent from PRISM to Oracle financial systems to avoid day to day production issues that cause lot of delay when awards are stuck in PRISM.
• Designed and developed key reports in Oracle Projects reimbursable module 'Customer Statement of Account' and 'Invoice Bill for Collection' for ABU division and other adhoc reports for auditing purpose.

Confidential

Environment: Oracle Applications Release 11.5.10.2 Oracle HR/Payroll/Advanced Benefits modules , SSHR 5.7H, Jdeveloper 9i, Oracle 10g, SQL, PL/SQL, Developer 6i, HP-Unix OS.

Job Title: Sr. Oracle HRMS Consultant

Responsibilities:

• Modified Advanced Benefits Open enrollment interfaces BCBS, UMR, and Caremark to comply with vendor requirements for year 2009.
• Modified HRA Benefits process to comply with SAS retirement plans for years 2008 and 2009.
• Tuned 'HR/Payroll Detail Extract' process to achieve performance improvements from 9hrs to 15 minutes.
• Modified 'Payroll Gross/941' report to display Federal 941 Wages by State, Pre-tax deductions, Non-taxable benefit amounts for each Quarter separately in a given year, this is used by Finance department for reconciliation purposes.
• Designed and developed 'OASIS Payroll Elements by Cost Center/Account Report' that is used by Finance department for reconciliation purposes.
• Designed and developed 'New Hire EDI' interface for NC State to report new hires every month.
• Modified 'Salary Change' self service screen to incorporate custom pick list with OA extensions.
• Modified 'SAS US Workers Compensation' report to include Severance Pay information for each state and WC code.
• Worked on several small bug fixes for HR/Payroll and OAB modules.
• Oracle HRMS Q1-2009 SQWL patches coordinator.

Confidential

Environment: Oracle Applications Release 11.5.10.2, GL, AR, AP, PO, INV, OM, OP, WIP, BOM, WM modules, Oracle 9i, SQL, PL/SQL, Developer 6i, Linux OS, ADP Payroll.

Job Title: Sr. Oracle Applications Consultant

Responsibilities:

• Analyze, design and implement Purchasing Price Variance functionality to replace existing manual process. This includes design and development of custom forms to capture required data for each line item, analyzing existing manual calculations and developing PL/SQL package to perform the same.
• Designed, developed custom reports 'PO Acceptance Report' and 'Supplier Payment History report'.
• Lead the Oracle Applications Security project to comply with Sarbanes Oxley policies.
• Controlled Application data access with customized menus, responsibilities, report groups based on segregation of duties.
• Developed and implemented Logical Apps rules to restrict access.
• Created a project plan with detail tasks and time schedules to target the project.
• Created a full blown menu profiles worksheet for each module to gather requirements from each module lead.
• Created AIM BR110 Security Profiles documents for each module.

Confidential

Environment: Oracle Applications Release 11.0.3, 11.5.10.2 Oracle GL, AP, PO, AR, OM, INV, Budgeting and

Job Title: Sr. Oracle Applications Consultant

Responsibilities:

• Successfully upgraded Wake County's Oracle Applications from release 11.0.3 to 11.5.10.2
• Managed the Technical team of 5 members and completed various tasks well before the target time.
• Involved in the design phase of Purchase Order Report output format and fields with users for different types of purchase orders like Standard, Blanket, Contract, and Blanket Release.
• Involved in Trouble shooting Purchase order Encumbrance issue.
• Modified PO Approval work flow to change match option for certain order types.
• Developed customized periodic and event alerts for Oracle Purchasing module.
• Designed, Developed custom reports like 'Requisition Activity and Performance Report' and 'P Card transaction Report'.
• Performed yearly load of Textbooks items and P Card transactions.
• Supported yearly Accounts Payables 1099 forms printing.
• Customized Check Writer and Deposit Advice reports with Accruals information in Oracle Payroll.
• Tuned various reports to achieve performance improvements ranging from 4 hrs to 10 minutes
• Responsible to convert the employee numbers from SSN to sequence numbers to comply with privacy policies.
• Designed and developed custom State W4 screen using Oracle Applications Framework 5.10
• Responsible to recommend and sanity test business flows after applying Oracle E-business suite mandatory patches.
• Responsible to create new custom programs forms and reports as per user requirements.
• Responsible to log service requests with Oracle support and resolve issues.

Confidential

Environment: Oracle Applications Release 11.0.3, 11i Oracle HR/Payroll modules , Oracle 8i/9i, 10g, SQL, PL/SQL, Developer 6i, Developer 2000, Jdeveloper 9i, Oracle Applications Framework 5.10,

Job Title: Sr. Oracle Applications Engineer

Responsibilities:

• Developed product and technical design documents, working closely with product management, legislative analysts, Customers and support teams. Actively participated in the design decisions, with a strong focus on analytics and planning. Participated in the Quality Assurance validation process and help them with the creation of test scenarios. Reviewed product documentation and training class notes. Ensure timely, successful releases of the functionality to Quality Assurance, Support and Customers. Consistent commended on quality and timely completion of assignments. Mentored offshore team members to complete the tasks on time.
• Setup and System Configuration of Oracle HR/Payroll for US and Canada legislations. This includes Setup of Business Group, GRE, HR Organization, State Tax Rules, Federal Tax Rules, Federal Reporting entity, Provincial Reporting Entity, Key Flex fields, Descriptive Flex Fields, Payrolls, Payment Methods, Salary Basis, Earning elements, Deduction elements, User defined balances, Profile Options etc.
• Primary responsibility has been to design, develop, document, delivery and support of US HRMS, Canada HRMS product. Also involved to triage live customer issues using ODC.

Confidential

Environment: Oracle Applications 10.7 Oracle HR, Payroll, GL, PO, AP modules , Oracle 8.06/8i, SQL,

Job Title: Oracle Applications Consultant

Responsibilities:

• Developed PL/SQL package to convert open standard and blanket purchase orders.
• Developed PL/SQL package to convert Approved supplier list.
• Designed and developed Purchase Order carry over custom report.
• Imported Invoice Information from legacy system to Oracle Payables.
• Customized standard reports to meet the business requirement specifications.
• Designed, developed custom reports like Payroll Earnings and Benefits by Cost Center, Annual Deferred Compensation, Element Result listing, Employee Counts by Payroll section, Employee count by bargaining group, Insurance Deduction Changes reports.
• Designed and developed interface to load employee information from legacy system to Oracle HR.