PROFESSIONAL SUMMARY:

• Over 10+ years of experience in Information Technology and worked as a very strong technical resource in all aspects of Software Applications Development Life Cycle and delivered business technology solutions and an experienced in Oracle Applications EBS and Oracle HCM Fusion Cloud Integrations.
• Very good technical and functional expertise in implementing Oracle Financial and Manufacturing Applications for various industries on various hardware and software platforms and worked on a number of projects for conversion of the company's legacy information to Oracle Financial, Manufacturing and CRM Applications.
• Involved in various projects requirement analysis, GAP analysis, design and define documents using AIM and CEMLI methodologies, also developed custom solutions as per the business needs.
• Extensive knowledge and good experience made me an excellent techno - functional resource for Financial, Manufacturing and Custom applications implementations and excellent working knowledge in Oracle SOA (service Oriented Architecture) and Oracle Application Framework (OAF), Integrated SOA Gateway and Oracle Fusion /Cloud HCM Applications R11, Cloud Integration Specialist technologies and Cloud Financial Applications R12.

PROFESSIONAL SKILLS:

Modules: Oracle EBS 11i/R12 Oracle General Ledger, Oracle Fixed Assets, Oracle Accounts Payable, Oracle Accounts Receivable, Oracle Order Management, Oracle e-Commerce Gateway. Oracle Inventory, Oracle Purchasing, Property Manager, Oracle Projects, Project accounting & Billings (PA), Discrete Mfg WIP, Oracle Property Manager, order to cash, procure to pay and Oracle Supply Chain SCM, HCM, Tax Manager, Product Data Hub and Master Data Management MDM, Depot Repair, install based, Cloud HCM, Financials Applications and Could Integration Technologies.

Technologies: Oracle database 9i/10g; Oracle Forms 4.5/6i, Oracle Reports 6i,10g, Oracle Form Personalization, java, C/C++, TOAD,SQL,PL/SQL stored procedures, packages, Workflow 2.6, Discoverer 4i/10g, OWB, XML Publisher, SQL* Loader, Mercury ITG, PVCS, AIM, Share point and Vertex, SOA, SOA Gateway, OAF,GRC and STAT(Migration Tool), Fusion Cloud R9.

Database: Oracle RDBMS v8i, 9i, 10g, 11g,, web logic server, apps server etc.

Environment: UNIX, MS Windows 2000, MS Windows NT v4.0, Sun Solaris, NT Server.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago - IL

Sr. EBS Resource Financial, HRMS Enhancements, Integration and Support

Responsibilities:

• Interacted with end users and functional architects for mapping the legacy data to the Oracle.
• Created MD050 (Functional design documents) specification for RICEW objects.
• Created MD070 (Technical design document) for all enhancement requirements.
• Prepared Test cases TE-020,030,040 for Financials modules (AP, AR, OM, and GL).
• Worked extensively with the Development and Business team to help upgrade 9i, 10g and R12 application P2P, O2C, HCM and SCM etc.
• Defined Profile Class, Dunning letters, Collectors, Customers, Auto Accounting, Transaction Types, Transaction Sources, Payment methods, Receipt classes, Receipt sources, Payment Terms, Receivable Activities in Receivables.
• Defined Payment Options, Payment terms, Distribution Set, Payment Format, Internal Banks, Recurring Invoices, Prepayments, Expense Report Templates, Interest on Invoice report, Matching options, Adjustment of Prepayments in Payables.
• Configured the setup for multi currency invoices and payments in Payables.
• Configured the setups for prepayments and adjustment to payment to suppliers
• Configured the setups for prepayment to employees and defined employee expense report.
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.
• Worked on Form Personalization to meet customer requirements in modules covering Payables.
• Involved in providing techno-functional Procure-to-Pay (P2P) life cycle support.
• Did the setup for Accrual options in Purchasing, and helped end-users to understand and run reports like Un-invoiced Receipt Report (URR), Accrual and Accrual ‘Rebuild’ Reconciliation Reports and use of write-off transactions option.
• Performed routine fixes for P2P issues in setup of users, responsibilities, suppliers, requisitioning, purchase orders, receiving, invoicing, payments etc.
• Primary resource in multi-org iExpense implementation which included setup of iExpense template, financial options, payables option, signing limits for employees, expense policies, profile options, excel template for each organization.
• Designed and developed AR invoices import process using Oracle standard APIs.
• Developed AP invoices import and export (Inbound and outbound) process for the third party system (Field glass).
• Project accounting inbound/outbound process is designed and developed using API. Imported Projects and Tasks in Oracle project accounting module.
• Designed and developed Project budget import process for the Oracle projects (PA).
• Customized Auto Accounting rules for project accounting (PA) transactions.
• Designed and developed AP, AP, GL, PA reports using spotfire reporting tool.
• Modified invoice approval workflow for approval limits.
• Added HTML based notifications to AP invoice approval workflow.
• Designed and developed custom reports in AR, Projects using XML Publisher.
• Developed several custom reports in AR, Projects and GL like the Manual Invoices report, Capital Expenditures report, GL Income Statement report, GL Balance report and GL Table Extracts report using XSLT-FO coding for complex grouping and sorting in XML Publisher RTF templates.
• Developed a complex report between RC (Cost Center) Hierarchy and Oracle Projects to report capital expenditure amounts to dynamically ‘roll up-drill down’ by complete RC Hierarchy using XML Publisher.
• Implemented page level calculations, page breaks, conditional formatting rules, running totals in BI Publisher reports utilizing RTF template features and BI Publisher data model.
• Developed new Print PO/Release Parameter form and attached the custom form to special tools menu in the Purchase Order (POXPOEPO) and Release (POXPOERL) forms using CUSTOM.pll.
• Integrated EBS HR, with Concur Cloud platform, oracle projects Accounting with Plan Plus (Time Entries) and TALEO (Recruitment)
• RICEW objects Develop using Oracle PL/SQL Packages, Reports, Interfaces, Extensions, APIs, and Workflows in Oracle EBusiness Suite, Spotfire tool for reporting BI Publisher etc for HRMS and Payroll Related reports.
• OAF page personalization on Oracle Core HR Configuration also designed and developed HR integration process with People Soft.
• Designed and developed several materialized views on HRMS base tables to feed data to applications outside of HR.
• Configure Project accounting and production support

Environment: 12.1.3, Oracle Forms 10g, Reports 10g, Oracle 10g, SQL*Loader, PL/SQL, UNIX, TOAD, Workflow, OAF.

Confidential

Cloud Consultant

Responsibilities:

• Worked on Inbound, outbound Integrations.
• HCM Data Loader
• HCM Spreadsheet Data Loader
• HCM Extracts and OTBI, Oracle Business Intelligence(Oracle BI Publisher)
• Set up Encryption for file transfer, encrypt and upload files, transfer files automatically from HCM extracts with PGP encryption.
• Worked on Payroll Batch Loader - Banks, Bank Branches, Elements Eligibilities
• Set up the integration between HCM and Oracle Taleo Recruiting Cloud Service facilitates seamless flow of the recruitment process from creating a job requisition to hiring a worker.
• Created HCM Data extracts, delivery options.
• Developed OTBI reports, subject areas, cross subject area.
• Worked on BI Reports - Data Model, RTF templates, wizard templates, bursting reports etc.
• Experience on Oracle Payroll, Compensation, Absence Fast Formulas.
• Defined the mapping between source data and Oracle Fusion HCM.
• Worked on the Data-File validator utility for data-formatting validations and Load HCM Data (LHD) for Coexistence Process.
• Worked on HCM File based Loader to load worker and Assignment Managers data in Oracle HCM Fusion data base using HDL/PBL.
• Created technical design based on functional design provided by functional team, develop/fix reports/interfaces, upload the data via HDL/PBL, Data Migration, perform unit testing and support other technical activities related to HCM Cloud.
• Worked on payroll batch loader (PBL) to load payroll objects into Cloud Oracle application.
• Exposure to functional areas like Core HR, Absence Mgmt and Benefits.
• Data Migration & Integration - HCM Extracts, HDL
• Excellent knowledge and experience in creating HCM Extracts and BI Publisher reports.
• Talent Management, Compensation and Benefits
• Good Experience with HCM Cloud fast formula and HCM extract, along with HDL files
• Ability to develop and maintain HCM Extract interfaces
• Experience in developing solutions for BI reports/interfaces
• Good Knowledge of HCM applications including Global Human Resources, Benefits
• Creating and Administering Analytics and Reports for HCM - Setup and Configuration, Set Currency Ps for Analytics, Configure Business Intelligence Publisher.
• Set Up the Delivery Channel and Enable Encryption

Environment: Cloud HCM Applications R11, HCM Integration Technologies, ADF Desk top Integration.

Confidential, Chicago. IL

Oracle EBS Consultant

Responsibilities:

• Worked on Custom programs for converting Legacy data into Oracle HR, Payroll and OAB for Employees, Assignments, Elements, Pay Methods, Salaries, Contacts, Addresses, Contact Addresses, Phones and Costing including history and involved in Benefits conversion.
• Responsible for running the Participation Process, Creating Life Events, Life event Summary Report, Enrollment Process in OAB (Oracle Advance Benefits).
• Extensively worked on Customization and setting up time and labor workflow such as OTL Workflow for Employees to meet the customer requirements.
• Designed MD70 documentation Benefits, payroll conversions and discoverer reports.
• Used SQL*Loader to import Benefits, fidelity and Payroll data from flat files to Oracle tables.
• Worked on the Data migration activities of Core HR/Payroll, OTL SSHR and OAB through conversion scripts(like personal, assignment, job, position, grade, qualifications, phones, SIT's, initial balance, bank details, element entry, pay proposals etc).
• Involved in Conversion of Benefit Enrollments from Third Party to Oracle for Open Enrollments and worked on retro pay process.
• Written some Fast Formulas for Rate Periodization Rule, Suspend Enrollment Rule, and Derived factor Age calculation Rule.
• Worked on custom forms, workflow customizations and Fast Formulas.
• Involved in Conversion and Open transactions Data activities.
• Preparation of the Technical documentation like. MD.70, MD.065 etc.
• Designed and developed the following Interfaces/ conversions exclusively.
• Employees rmation interface and TALEO.
• Employee’s assignments interface with TALEO.
• Worked on Payroll Positive Pay interface.
• Employee medical, dental and vision benefits outbound interfaces for service provider (GAUDIAN Dental also Caremark health and Eye Mad providers).
• Extremely worked on workforce’s time entry system integration with Oracle payroll integration.
• Minnesota Life Inbound Enrollment, Life Basic Eligibility Outbound, Life Payroll Deduction Outbound.
• Employees Pension Deduction.
• Designed and developed Employees and assignments conversion program.
• Designed and developed job, grades and job locations conversion programs.
• Configured Self Service HR Personalized Employee and Manager web pages, Setup additional flex fields to capture client specific information using self service web pages.
• Configured taxes (EB Tax) for financial modules in tax Manager.
• Developed Oracle Application Framework (OAF) page, Personalization, Extensions using AM, View Objects, Entity Objects, Controller, SPEL, Exception Handling with JDeveloper Tool.
• Worked on Custom programs for converting Legacy data into Oracle HRMS system for Employees, Assignments, Elements, Pay Methods, Salaries, Contacts, Addresses, Contact Addresses, Phones and Costing including history and involved in Benefits conversion.
• Responsible for running the Participation Process, Creating Life Events, Life event Summary Report, Enrolment Process in OAB (Oracle Advance Benefits)
• Customization of Self Service HR Personalized Employee and Manager web pages, Setup additional flex fields to capture client specific information using self-service web pages (Advanced Search page, contacts information page and rmation page).
• Developed and configured several Fast formulas in Oracle Payroll.
• Personalized views panel of search pages, table regions and search result views page using OAF personalization in SSHR module.
• Developed Complex programs to transfer timecard details from time and labor to Grants Accounting.
• Extensively worked on Customization and setting up time and labor workflow such as OTL Workflow for Employees to meet the customer requirements
• Extensively worked on extending OAframework page controller, view objects and application modules in time and labor module
• Developed program to update people group flex field program to make timecards editable
• Developed conversion program to convert data from OIT to OTL
• Developed Lot of customizations in timecard.ldt, review.ldt file and confirmation.ldt file which meet the customer requirements in oracle time and labor module.
• Personalized time entry page using self service personalization.
• Developed program to update accruals balance as per bi-weekly basis.
• Developed lot of reports to report data from oracle internet time to time and labor module.

Environment: 12.1.3, Oracle Forms 10g, Oracle 10g, BI Publisher, SQL*Loader, PL/SQL, UNIX, TOAD, Workflow, BI publisher, EBS HR, Payroll, OAB, TALEO.

Confidential, Matteson. IL

Oracle EBS Consultant

Responsibilities:

• Setting up open enrollment process for 19291 employees in 2012 year and involved in resolving many issues during this process.
• Conduct meetings & workshops to capture department mission & vision.
• Designed and built Compensation workbench plans such as Bonus processing plan and success objectives plan.
• Developed many Payroll and OAB Fast Formulas.
• Extensively worked on iRecruitment setup issues, open enrollment issues and CWB issues.
• Implementation of new weekly payroll and new benefits associated to specific payroll.
• Was involved in setting up new rates for long term disability.
• Configured HR and Payroll system as per business requirements.
• Configured new stores in Oracle like physical location, sub-inventories, stock locators, GL accounts, Taxes, banks and bank Accounts and receipts and receipts methods etc.
• Configured taxes (EB Tax) for AR and AP transactions in tax Manager.
• Defined payment methods for the payroll process. Configured element for payroll and wrote/updated fast formulas to calculate employee investment plan percentages amounts. Designed and developed investment plan inbound interface to update investment plan element entry using oracle seeded API.
• Designed and developed employee, assignment interface like create and update employee, addresses, assignment using HR API.
• Analyzed, designed and developed conversion programs for employee, investments and initial balances etc.
• Configured SIT, EIT for employees and assignments etc.
• Designed and developed interface of PO creation and update PO.
• Month end financial activities. Month end close, reconciliation process, closing and open accounting periods etc.
• Worked on Web ADI to generate JE template and Budget template.
• Involved in implementation of E-Business Suite Applications HRMS -HR, Payroll, CWB, SSHR, OAB and OTL.
• Worked on with Payroll processing steps and setups.
• Heavily worked on Customer, vendors and sites, employees, payroll history and AP and AR invoices conversion
• Was involved in setting up Paid Time off (PTO) Accruals in absence Management.
• Was involved in customization of Checks and Deposit Advices as per the business requirement.
• Was involved in setting up bonus Compensation Plan (CWB) by defining distribution budget, eligible salary and worksheet details.
• Implementation and setup of Open Enrollment in Oracle Advanced Benefits Module in R12 (R12.2.3).
• Extensively worked on developing fast formulas in OAB Module.
• Involved in resolving production issues during open enrollment in vision interface, COBRA interface and UHC interface.
• Extensively worked on Setting up plan enrollments, SIT upload and different setups in Compensation Work Bench.
• Extensively worked on Medical/vision/Dental Interfaces technical modifications.
• Developed an outbound Interface for Cobra file. Developed an outbound interface on Employee’s Vision Plan.
• Was involved in setting up OTLR by defining Holiday Calendar, Shifts, Work plans, Rotation plans, Element Time Information, Shift Differential Policy, Hours Deduction Policy, Premium Eligibility
• Policy, Earnings Policy, Assignment Time Information, Automatic Timecard Generation, Transfer to BEE.
• Was responsible in defining recurring periods, Alternate names, Flex field Mapping, element sets, Approval periods, Approval rules, Ps, Eligibility criteria, Timecard Layouts, Time Entry rules and transferring timecards from OTL self service to BEE.
• Daily production support issue and schedule weekly and monthly migrations.

Environment: 12.1.3, Oracle Forms 10g, Oracle 10g, BI Publisher, SQL*Loader, PL/SQL, UNIX, TOAD, Workflow, BI publisher, EBS HR, Payroll, OAB, TELEO,EBS, Financials, SOA, BEPL, KRONOS.

Confidential, Memphis - TN

Oracle EBS Consultant

Responsibilities:

• Extensively involved in Oracle Time and Labor module, Payroll for US Business Group and Benefits Module.
• Was involved in setting up OTL self service process by defining Approval rules, Hours types, Time entry rules, Approval styles and Setting up the Ps.
• Worked on approving and transferring timecards from OTL Self Service to BEE.
• Developing technical specification and performing actual conversions from legacy system to Oracle applications.
• Extensively worked on Fidelity Interface development, testing, and sending files to fidelity.
• Extensively worked on Benefits Inbound interface development, testing, users with SONIC integration with Confidential
• Extensively worked on Payroll interface of importing 800 sonic employees, payroll information from SONIC organization into Confidential
• Developed reports using discoverer report like US employee’s headcount report.
• Was involved in resolving Helpdesk tickets from different countries like United States, UK and Germany.
• Used Oracle Meta link for raising and tracking SR’s for oracle support, issues and patches.
• Used AIM Methodology for project related documentation.
• Customization of discoverer End User Layer involved creating customized folders, building robust business layers, customized joins and granting privileges.
• Creation of discoverer workbooks for iRecruitment implementation reports.
• Designed MD70 documentation Benefits, payroll conversions and discoverer reports.
• Used SQL*Loader to import Benefits, fidelity and Payroll data from flat files to Oracle tables.
• Worked on BEPL services and deployed in application server for SOA ISG integration.
• Integrated purchasing modules with source system using Integrated SOA gateway web services.
• Configured administration of SOA gateway and enabled EBS Business System Objects as web services for source system.
• Developed element entry audit report using BI publisher tool to generate different kinds of outputs and automatically email the report output to multiple people electronically.
• Extremely worked on Workflow and AME.
• Integrated TALEO system with Oracle HR system, worked on fast formulas for payroll, and balances configurations, wrote procedure balances adjustment.
• Provide support to production system and resolved issues quickly on priority bases.
• Designed and developed a BI report for the third party exchanges order, which means this report can generate third party order details and sends an email to customer and notify the items that are sent for replacement.
• BI publisher reports have been designed and developed as per the requirement reports for- Items Damage report; Item Not received report, Service request and Repair orders details report.
• Excellent client facing experience to gather requirements etc.

Environment: 12.1.3, Oracle Forms 10g, Oracle 10g, BI Publisher, SQL*Loader, PL/SQL, UNIX, TOAD, Workflow. SVN,OAF, Java, j Developer, XML publisher, EBS Financials, SOA, BEPL, business events, HR, PAYROLL, SSHR, OM, AR, AP,PO, Depot Repair, Install base etc.

Confidential, Chicago, IL

Oracle EBS

Responsibilities:

• Involved in the full life cycle implementation of i-Recruitment; Responsibilities included configuring the required profile options, setting up additional DFF’s, Lookups; Also was involved in setting up Qualification Types, Competencies, Compensation Plan, Security Setup and testing since the module to the company’s extranet. Worked closely with the Business to define the Approval Hierarchy for both Vacancy creation and Candidate Approvals. The Approval process was setup using Oracle Approvals Management Engine (AME).
• Was involved in setting up iRecruitment module - Recruiting Sites, Applicant Assignment Statuses, External Assignment Statuses, Creating Vacancies, Vacancy Approvals, Vacancy Security, Job Seekers, Site Visitors, Registered Users, Job Search, Job Baskets, Candidate Processing, offer and Hire.
• Developing technical specification and performing actual conversions from legacy system to iRecruitment applications.
• Designed and developed iRecruitment Conversions like “Vacancy Conversion, Applicant Conversion, Skill Conversion and Competence Type conversion” using PL/SQL programming.
• Was involved creation, update, deletion process, personalization and extension of web pages in OA Framework and ADF modules
• Created and maintained Daily Business Intelligence Discoverer Business areas.
• Customization of discoverer End User Layer involved creating customized folders, building robust business layers, customized joins and granting privileges.
• Creation of discoverer workbooks for iRecruitment implementation reports.
• Designed MD70 documentation iRecruitment conversions, forms, reports6i and discoverer reports.
• Worked on designing reports using reports 6i developer.
• Worked on designing form using forms6i developer.
• Was involved in designing and registering oracle iRecruitment reports using reports 6i.
• Used Shell - Scripting for FTP process to send the file to vendors.
• Worked on HR and Taleo integration and modified existing interfaces, balances.

Environment: 12.1.3, Oracle Forms 10g, Reports 10g, Oracle 10g, BI Publisher, SQL*Loader, PL/SQL, UNIX, TOAD, Workflow. SVN, XML, OAF, JAVA, J-Developer EBS Financials, integrated SOA Gateway, HRMS, Payroll.

Confidential, Nashville, TN

Oracle EBS Consultant

Responsibilities:

• Interacting directly with client for requirement gathering .
• Mapping the client requirement to system and preparing functional/technical specifications.
• User on the application functionality and new enhancements.
• Creation of project plan and designing migration strategy.
• Estimation of the effort required.
• Developed interface programs using WebADI for Employee, Job, EIT & SIT Creation.
• Fix bugs reported by HRMS issues (Production support) and enhancements.
• Worked on the dynamic solutions to resolve the DFF conflicts between different organizations
• Worked on post-production support to debug and resolve issues.
• Extensively used FNDLOAD utility to migrate concurrent programs, request sets, value sets, DFFs n KFFs etc.
• Worked on Forms and OAF (Oracle Applications Framework) Personalization’s.
• Created dynamic SQL queries using Execute Immediate statements.
• Extensively used SQL loader and import/export toolbar to load the data from excel files into oracle.
• Extensively worked on cursors, SQL joins (inner join, outer join, anti-join), views, packages, procedures, and functions.
• Worked with collections to reduce overhead involved with cursor looping. Bulk fetched the data from SQL engine into collection. Handled exceptions using SAVE EXCEPTIONS and %bulk exception.
• Extensively used materialized views, pragma autonomous transactions, object types, table functions, and pipelined functions to implement business logic effectively.
• Designed and developed BI Publisher Reports for Payroll and Core HR Modules.
• Writing the Technical Document and Installation guide.
• Involved in development of inbound, outbound interfaces and conversions.
• Registration of concurrent programs and creation of value sets.
• Involved in support activities.

Environment: Oracle E-Business Suite 12.1.3, PL /SQL, Workflows Discoverer Reports, Reports 6i, BI Publisher.

Confidential, IL

EBS Technical Resource

Responsibilities:

• Extremely handling on site and offshore technical teams in EBS production support and enhancements of existing EBS HRMS applications to meet the new business rules.
• Worked extensively on Oracle Payroll with specific focus on configuration.
• Worked closely with the functional lead to assist in the setup of Payroll Elements, Taxation rules, GREs and Tax Balances. Also worked on Paid Time Off (PTO) setup for Vacation, Sick and PTO plans.
• Create a Benefits Report using Reports 6i by aggregating data from various Oracle Advanced Benefits (OAB) Tables.
• Created an interface for hospital System call as STIX, where you pull all the current as well as Ex-employees information and put into a file which in turn is passed into the Hospital system called STIX.
• Create a View only Custom Form using Forms Configuration.
• Created SQL*Loader script to populate the staging tables from the feed data, created PL/SQL packages to validate the feed data against the primary tables.
• Prepared functional document to Create Assignment Set programmatically to include all the employees both existing, rehire as well as terminated employees eligible for special pay so that the payroll processes only employees with pay.
• Prepare specification to process the payment of long due special bonus to the eligible employees. Coordinate with the users, identify the employees based on the various criteria, and include programmatically the eligible employees into various Assignment sets, to be processed by various payrolls.

Environment: Oracle Applications R12.1, Oracle10g, HRMS, BI Publisher, Workflow 2.6, SQL, Toad, PL/SQL, SQL*Loader and UNIX.

Confidential, Chicago, IL

Oracle EBS Technical

Responsibilities:

• Communicated effectively with the clients to understand and get information regarding their Business practice. Involved in requirement gathering and analysis and design of the application.
• Create custom reports using XML publisher and RDF as requested by users.
• Involved in bug fixing and worked with the Oracle support teams and raised TARs to resolve issues.
• Extensively used FNDLOAD utility to migrate concurrent programs, request sets, value sets etc., from one instance to the other.
• Worked on different Payroll fast formulas API's related to Core HR and Payroll.
• Worked on the benefit extracts (for 3rd party vendors like Towers Watson, Sun life, etc.).
• Preparation of Design Level Documents, Installation Documents, Test Plans.
• Involved in Requirement Analysis and Estimations for development and support items.
• Maintain code in version control tools and Mode moving activates. Extensively worked on cursors, SQL joins (inner join, outer join, anti-join), views, packages, procedures, and functions.
• Worked with collections to reduce overhead involved with cursor looping. Bulk fetched the data from SQL engine into collection. Handled exceptions using SAVE EXCEPTIONS and %bulk exception.

Environment: Oracle E-Business Suite 11.5.10.2, PL /SQL, Alerts, Workflows Discoverer Reports, Reports 6i, XML Publisher, BI Publisher

Confidential, Ann Arbor, MI

HRMS Tech Lead Oracle EBS

Responsibilities:

• Confidential HRMS (EBS) Global Design & Implementation & production support team member.
• Extensively worked with business user to gather business requirements.
• Prepared MD. 050 and MD.070 Create Application extensions functional and Technical design documents.
• Worked on CV.010 defined data conversion requirements and strategy document.
• Extensively worked on custom schema creation and depth understanding on apps Schema and table entity-relationship.
• Worked on System Administrator and Application Developer modules configurations.
• Prepared CV.040 Perform data conversion mapping document and CV050 design data conversion programs.
• Was involved in setting up Paid Time off (PTO) Accruals in absence Management.
• Was involved in customization of Checks and Deposit Advices as per the business requirement.
• Worked on adding columns in Employee self Service Responsibility with support of Java Entity Object OAFramework Extensions Personalization.
• Involved in creation of template builder and registration of XML reports like Check Writer (XML) and Deposit Advice (XML).
• Customized effort report form of the Oracle Application as per the Client Requirement using Reports6i.
• Developed inbound interface For Mass Upload of Salaries from legacy system to OracleHRMSTables.
• Developed file for the Hospital. This process creates a file of all active hospital employees.
• Developed outbound interface to builds a file of employee data for Hospital Employee Health and developed the report for the same.

Environment: Applications R12.0, Oracle10g, BI Publisher, Discoverer, HRMs, Workflow 2.6, SQL, , OAF, Toad, PL/SQL, SQL*Loader and UNIX.