SUMMARY

• Over 15+ years of IT experience as a Sr. Oracle HCM Cloud (R10/R11/R12/R13/R20/R21+)/Oracle EBS Application Technical (10.7/11i/R12)/Functional Consultant / Systems Analyst / Programmer/Developer.
• Very strong in teh design and development in various industrial verticals like Public Sector, University, Government, Financial, Manufacturing, Banking, Broad Casting and Business.
• Involved in Full Lifecycle implementation of Requirement Analysis, Gap analysis, Gap Solution, Setups, Technical Design, Development, Coding, Testing, end - user training, post-implementation support, Customization, Conversion, Migration, upgrades, Patch testing, Trouble shooting Production issues and QA Testing.
• End to end implementation experience in Global HR, Absence management, Performance Management, Talent Management, Goal Management, Payroll and Compensation offerings.
• Expertise in Configurations, Personalization, HCMData Loader (HDL) tool, File-based loaders (FBL), Spreadsheet loader, Payroll Batch Loader, OTBI Reports, BI Publisher reports,HCMExtracts, Workflows and approval configuration, Fast Formulas for Benefits and payroll modules
• Excellent experience in Data loading into Oracle HCM Cloud using HCM Data Loader Tool which includes teh Workforce structure data, Worker data, Work relationships data, and Salary info.
• Worked on Fast formulas and able to write fast formulas as per teh requirement
• HCM cloudand Taleo recruiting and onboarding.
• Experience on Taleo functionality like Import candidates (ready to hire) from Taleo Recruiting to FusionHCMusing teh ImportOracleTaleo RecruitingCloudService Data process and Import-export schedule process errors resolutions
• Developed Over 100+ BIP report,HCM extract, OTBI reports and Dashboard
• Experienced in configuring workflow routing rules for all Manager and Employee Self - service.
• Trained teh end users in working wif teh Oracle modules and provided technical expertise
• Hands on experience on customizing teh security, by creating data roles, security profiles and TEMPeffectively using job roles and duty roles.
• Experienced in complete payroll cycle wif Pay Processing, Retro Pay, Costing and Transfer to GL
• Experience in developing Interfaces for Oracle HCM Cloud and Oracle EBS HR.
• Strong understanding of Software Development Life Cycle (SDLC). Knowledge of both Agile and Waterfall Software development methodology
• Expertise in translating functional specifications into implemented technical solutions using Oracle applications supported toolsets.

TECHNICAL SKILLS

Oracle Applications: Oracle HCM Cloud R11/R12/R13 R21 (HR, Payroll, OTL, Benefits) Oracle EBS R12/11. me / 11.5.8/11.5.7 ) / 11.0.3/11.0.2/10.7 NCA/10.7SC

Modules: HR/Payroll (HRMS), Advance Benefits (OAB), OTL, Absence Management, OLM, Oracle Self Service, Accounts Receivables, Accounts Payables, General Ledger, Inventory, Oracle Purchasing, Oracle Inventory, Order Entry, Order Management, Labor Distribution, Grants, Project Accounting, Application Object Library, System Administration, Oracle Alert, Oracle Workflow, Forms Configurator

Databases: Oracle7.X/8.X /8.me/9.me/10g/11g

Tools: BIP Reporting, HCM EXTRACT, Dashboard, OACS, Developer /2000 (FORMS, REPORTS), Oracle Discover 4i, Web ADI, OBIEE Tools

Languages: PL/SQL, SQL, C ++, C, PRO *C, JAVA, UNIX Shell Script

Operating Systems: UNIX (HP, Sun Solaris, AIX, SCO UNIX)

Methodologies: Applications Implementation Methodology (AIM), Agile/Scrum

Other Products: MS Access97, MS SQL Server, TOAD, SQL Navigator

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior Oracle HCM Technical/Functional Consultant

Responsibilities:

• Provided Oracle HCM Cloud Fusion functional/technical consulting services by acting as subject matter expert and leading clients through teh entire cloud application services implementation lifecycle for Oracle HCM Cloud Fusion projects
• Conducted Technical Design Workshops for Oracle HCM Cloud Fusion projects
• Write business requirement documents for reports, interfaces, data conversions and application extensions for Oracle HCM Cloud Fusion projects
• Assist Client in preparing validation scripts, testing scenarios, develop test scripts, test data, log results and defects in Global HR, Payroll, Time and Labor & Absences
• Validate configuration and data, designed various reports.
• Interact wif teh project team members responsible for developing reports interfaces, data conversion programs, and trained project team development of reports and test data.
• Data Loading using HCM Data loader (HDL, HSDL) which includes teh Workforce structure data, Worker data, Work relationships data, Element Entries, Cal Cards, Balance Adjustment etc.
• Extensively Customized Oracle Payslip templates, Checkwriter template and deliverable options and created summary count reports.
• Developed Pre and post validation of Costing reports, Deduction report, Retro Overpayment Recoup report, Net 0 Payslip, Multiple Payslip in single flow, Payslip Generated and missing Payslip report, Tax Wifholding report, Balance Group report, Element entries and Payroll readiness report etc.
• Developed various Audit report, Yearend Reporting and W2 reports.
• Created more TEMPthan 100+ Oracle Fusion HCM Extract,BI Reports and OTBI reports.
• Designed and developed fast formulas for HR, Payroll, Absence modules.
• Customized many flows and objects group, created PRG
• Designed and Developed extensively on HCM Extracts (include changes file) for Global HR, Payroll Interface and Fusion Benefits.
• Developed outbound Interface for benefit external carrier
• Conducted User Acceptance Testing (UAT) and collaborated wif teh QA team to develop teh test plans, test scenarios, test cases, test data to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Complete tasks efficiently and in a timely manner
• Was involved on production support of various HRMS modules including HR and Payroll.

Environment: Oracle Cloud HCM Fusion R20+, 21B

Confidential, NY

Senior Oracle HCM Technical/Functional Consultant

Responsibilities:

• Implemented Oracle HCM cloud Global HR, Compensation, Absence Management and Goal Management, Payroll offerings.
• Gathered business requirements using standard questionnaire and performed fit-gap analysis by taking feedback from teh business users iteratively.
• Data Loading/Conversions using HCM Data loader (HDL) which includes teh Workforce structure data, Worker data, Work relationships data, banks, personal Payment method, Salary info etc.
• Involved in defining of eligibility profiles, time periods, absence types and absence plans as per teh client requirement both Accrual absence and qualification plans.
• Configured teh approvals for various business processes as per business requirements for assignment changes and absence management.
• Worked on fast formulas in absence management.
• Prepared Test Scripts, Test Scenarios and Test results documents
• Created new benefit plans and Converted Benefit enrollment data.
• DevelopedHCMExtracts analytics for Global HR, Payroll Benefits, Goal and Performance modules
• Designed and Developed Interface between Oracle Cloud HCM to ADP
• Was involved EEO-1 Establishment Electronic Report Setup
• Created Oracle Fusion BI Reports and Analytics and Involved in testing existing BI Reports and creation of ad-hoc OTBI reports.
• Build Custom Security to HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles

Environment: Oracle Cloud HCM Fusion R13

Confidential, NM

Senior Oracle HCM Technical/Functional Consultant

Responsibilities:

• Ensured dat applications meet business requirements and systems goals, fulfill end-user requirements, and identify and resolve systems issues.
• Data loading using HCM Data loader (HDL) and PBL which includes create/correct/update data bank, Element entries and cal card data.
• Developed HCM Extracts for Global HR, Payroll Interface and Fusion Benefits.
• DevelopedHCMExtracts analytics for Global HR, Payroll Benefits, Goal and Performance modules
• Created Oracle Fusion BI Reports and OTBI reports.
• Customized Oracle Payslip templates and was involved in Supporting Payroll issues.
• Conducted User Acceptance Testing (UAT) and collaborated wif teh QA team to develop teh test plans, test scenarios, test cases, test data to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Was involved on production support of various HRMS modules including HR and Payroll.
• Prepared teh documentation for Business Requirements, Functional specifications and Test case documents.

Environment: Oracle Cloud HCM Fusion R13

Confidential, Boston, MA

Senior Oracle HCM Technical/Functional Consultant

Responsibilities:

• Working as implementation consultant for Multiple Countries FusionHCMimplementation projects.
• Work closely wif client in Identifying and addressing client's additional requirements when compared to their existing system.
• Prepared teh documentation for Business Requirements, Functional specifications and Test case documents.
• Developed over 100+ HCMExtracts analytics for Global HR, Payroll Benefits, Goal and Performance modules
• Created Oracle Fusion BI Reports and Analytics and Involved in testing existing BI Reports and creation of ad-hoc OTBI reports.
• Developed OTBI reports, Infolets and Dashboard.
• Worked on complex Employee Roster Report
• Conducted User Acceptance Testing (UAT) and collaborated wif teh QA team to develop teh test plans, test scenarios, test cases, test data to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Ensured dat teh application meets teh business requirements and system goals fulfill end user requirements and identify and resolve system issues.
• Reported to higher Management on progress and status for all business-related work products and deliverable.
• Was involved on production support of various HRMS modules including HR and Payroll.

Environment: Oracle Cloud HCM Fusion R13

Confidential, Novato, CA

Senior Oracle HCM Technical/Functional Consultant

Responsibilities:

• Performed feasibility analysis, designed project plan, gathered business requirements from teh client.
• Initialized teh users for setting up and implementing teh oracle HCM.
• Designed and developed and tested interface between Oracle Cloud HCM to ADP. Used HCM Extract to developed Demographic and Deduction files.
• Worked on many fast formulas for HCM Extract interfaces.
• Developed HCM Extracts, OTBI Report and BI publisher reports as per client requirements.
• Designed, Developed and tested Interface between EBS to ADP for demographics and deduction files. ADP connector generate one-time full file and changes file daily.
• Involved in to implement teh Audit Report for teh ERP Connector Changes.

Environment: Oracle Cloud HCM Fusion r12/r13, Oracle EBS R12

Confidential, Atlanta, GA

Lead Oracle HCM Technical/Functional Consultant

Responsibilities:

• Involved in Oracle HCM cloud implementation. Interacted wif client and involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping wif Oracle Cloud HCM, and GAP analysis.
• Used Oracle Fusion Functional Setup Manager (FSM) to perform various tasks.
• Managed Enterprise HCM information and Legal Entity HCM information
• Leading development team on high priority issues TEMPeffectively.
• Involved in setting up teh workforce structure and worked manager and employee hierarchy for approvals at BPM.
• Worked on fast formulas for absence management module.
• Executed teh complete structure of payroll for US client and managed US tax related elements.
• Customized Checkwriter and Payslip templates
• Developed HCM Extracts/OBI Reports for Global HR.
• Loaded data using HDL and spreadsheet loaders.
• Involved in creation of Custom Security for Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Involved in end-end UAT testing by drafting teh test cases/scripts.
• TEMPEffectively communicated wif oracle support (SRs) to resolve issues to complete teh project smoothly and before deadline.

Environment: Oracle Cloud HCM Fusion r11/r12

Confidential, New York City, NY

Lead Oracle HCM Technical/Functional Consultant

Responsibilities:

• Performed Business Requirements, Functional Specs, Test Strategy, Test Plan, and Test script
• Support existing processes, enhancements, and integrations, including issue resolution
• Worked on ImplementingTaleoEnterprise 15ARecruiting and Onboarding.
• Worked on Integration between Taleo to ADP for Direct Deposit, W4 Federal and State Taxes
• Designed and developed Taleo to HCM interface for new hires
• Designed and developed HCM to Taleo interfaces.
• Developed and testedTaleoConnect Client (TCC) scripts to developed inbound and outbound extracts.
• Worked on Salary, Bonus compensation, was involved derived factor, Eligibility Profile, define elements, Compensation Plan.
• Configure and Manage Benefit programs, plans, plan types and options.
• Developed outbound Interface for benefit external carrier Kaiser, Delta Dental, Anthem, Discovery Cobra etc.
• DevelopingHCMExtracts for Global HR, Payroll Interface andFusionBenefits
• Involved in teh writing and modification of Fast formulas used inOraclePayroll.
• Developed BI Reports/OTBI inOracleFusionCloudand scheduled teh reports wif to be delivered to Email and FTP sites.

Environment: Oracle Cloud HCM Fusion r11/r12

Confidential, Baltimore, MD

Senior Oracle HCM Technical/Functional Consultant

Responsibilities:

• Performed Business Requirements, Functional Specs, Test Strategy, Test Plan, and Test script
• Leading development team on high priority issues TEMPeffectively.
• Managing Offshore and onsite team. Ability to supervise resources, Priority Setting, Design Approval
• Work closely wif project/team management to ensure timely deliver
• Work wif Senior HR and IT leadership on prioritization and architectural assessment.
• Work closely wif global HR business teams to identify and document requirements
• Support existing processes, enhancements, and integrations, including issue resolution
• Converted 10K Workers and related Work Structure using HDL
• Worked on various Payroll, Compensation and Benefit Configurations.
• Worked on Salary, Bonus compensation, was involved derived factor, Eligibility Profile, define elements, Compensation Plan.
• Configure and Manage Benefit programs, plans, plan types and options.
• DevelopingHCMExtracts for Global HR, Payroll Interface andFusionBenefits
• Involved in teh writing and modification of Fast formulas used inOraclePayroll.
• Was involved designed, developed and testing SOA composites and BIP reports for 36 HCM inbound and outbound interfaces
• Prepared several OTBI reports including customized reports for mostHCMmodules and Involved in raising SR wiforacle& interacting wiforacleteam to solve SR related issues.
• Developed BI Reports/OTBI inOracleFusionCloudand scheduled teh reports wif to be delivered to Email and FTP sites.
• Used MFT to transfer/schedule PGP encryption files to vendor.
• Open Oracle SR for various issues and for POD instance management.
• Was involved in R12 Upgrade testing, code migration, instance pointing and redeployments.

Environment: Oracle Cloud HCM Fusion r11/r12

Confidential, Baltimore, MD

Oracle Application Technical/Functional Consultant

Responsibilities:

• Interacted wif client during teh Implementation process,
• Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping wif Oracle HCM and Financial Modules
• Have developed teh Interfaces and report to Oracle EBS HR and financial modules.
• Was involved in upgrade and testing
• Involved in conducting CRP1, CRP2, test data preparation and test scenario preparation.
• Provided production support during and after HR/Benefits/Payroll and Financial go live

Environment: Oracle Applications R12/11. (AR, AP, PO, GL, HR and Payroll), Oracle 8.me/9. me/10g, Forms 10g, Reports 10g, SQL, PLSQL, TOAD, Web ADI

Confidential, Jamesburg, NJ

Oracle Application Technical/Functional Consultant

Responsibilities:

• Developed PL/SQL Packages, Procedures, Functions for validating teh invoices and payment information from teh legacy system and imported into Oracle Applications using teh Payables Open Interface Import program and populated teh base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Developed, customized EMSD Web base tools to create AR Customers, Profiles, Invoice setup, Invoice Groups, Billing system wif complex programing logic and AR invoices in Oracle
• Involved in Design, Development, Testing, and Enhancement for HR, Payroll and Base Benefits modules.
• Were involved tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc?
• Worked as a Member of teh Production support system to address day to day issues. Daily Development Interaction wif Technical leads for status and any other outstanding issues.

Environment: Oracle Applications R12 (Oracle Inventory PO, AP, GL, AR), Oracle 8.me/9. me/10g

Confidential, Pittsburgh, PA

Oracle Application Technical/Functional Consultant

Responsibilities:

• Designed and developed Receiving Interface which creates receipts, accept, deliver and adjustment using PLSQL Packages.
• Used Oracle Standard API to Open PO lines for teh day and closed at teh end of teh day once receipt quantity program completed.
• Involved in teh design and development of inbound and outbound interface HJ third party system to oracle for items, Purchasing, Receipt Interfaces
• Involved in Designed and developed of custom reports using OBIEE tools like receiving aging, Invoice Invariance, Returns Quantity reports and various HR and OAB reports.
• Involved HR, OAB setups, Fast formula and Open enrollments process.
• Involved in OAB conversation from Legacy system and outbound interfaces for external carriers
• Trouble shooting production issues

Environment: Oracle Applications R12 (HR, OAB, Oracle Inventory PO, AP, GL, AR), Oracle 9. me/10g, SQL, PLSQL, TOAD, Oracle OBIEE

Confidential, Manhattan, NY

Oracle Application Technical/Functional Consultant

Responsibilities:

• Completed CV20 (data Strategy document), CV50 (data mapping document) and MD 70 (technical document) for client HRMS conversion.
• Wrote script for employee, Address, Assignment, EIT, SIT, Salary conversion.
• Configured OAB Program, Plan, enrollment requirements, eligibility profile, Standard rate, variable rates, and life events setup.
• Was involved in OSB to OAB conversion.
• Was involved in OSB De-enrollment process.
• Successfully converted Participants and their dependents Medical, dental, vision benefits.
• Wrote validation scripts to match pre conversion and post conversion data.
• Was involved on Open enrollments process.
• Developed and customized OAB Fast Formula.
• Developed outbound Interface for benefit external carrier BCBS, Delta Dental.
• Monitor new hire data interface flow into ADP, ensuring accuracy of data and Customized Oracle ADP views
• Developed OBIEE reports

Environment: Oracle Applications R12 (HR, Payroll, OAB), Oracle 8.me/9. me/10g

Confidential, Manhattan, NY

Oracle Application Technical/Functional Consultant

Responsibilities:

• Prepared Technical Specs using OUM Methodology, Code review and Code development
• Prepared Strategy documents for teh conversion
• Converted data from production 11i instance to R12 instance using oracle APIs employee, Address, Assignment History, Secondary Assignment, Payment Method, EIT, SIT, Salary, Qualification, absence conversion.
• Design, developed and tested PLSQL package for correction/update/insert employees start date, employee’s information and assignment details. Wrote scripts for reversal rehire and reverse termination process.
• Was involved in 64 business Group implementation and knowledge about localization.
• Successfully converted Participants and their dependents Medical, dental, vision benefits
• Was involved on Open enrollments process.
• Developed outbound Interface for benefit external carrier BCBS, Delta Dental.
• SQL tuning for reports running slow and PLSQL packages using TKPROF, EXPLAIN plan, applying indexing and HINTS.
• Conducted successfully Conference Room Pilots - CRP1, CRP2, SIT, UAT
• Worked wif Various Functional issues and Raising TARs whenever it requires for Oracle Standard Functionality support from Oracle.
• Production Support for Financial modules AR, AP, GL,PA

Environment: Oracle Applications R12 (HR and Payroll and PA, AP, GL, AR), Oracle 9. me/10g, SQL

Confidential, Baltimore, MD

Oracle Application Technical/Functional Consultant

Responsibilities:

• Analyzed documentation for functional design, technical design and Unit Test Plan
• Analyzed over 100 pieces of code (RICE) recommended Changes from R11i to R12
• Designed, Developed and tested XML reports

Environment: Oracle Applications R12/11. me (AR, AP, PO, GL, HR and Payroll), Oracle 8.me/9. me/10g, Forms 10g, Reports 10g, SQL, PLSQL, TOAD, Web ADI

Confidential, Detroit, Michigan

Oracle Application Technical/Functional Consultant

Responsibilities:

• Prepared Technical Specs using AIM Methodology wif all standard documents like CV20, MD 50, MD 70 and MD 120, Code review and Code development.
• Converted data from production 10.7 instance to 11i instance using oracle APIs and custom code to add employees, address, assignment history, create contacts and dependents, create phone entries, create positions and jobs, create SITs, load salary proposal including history, add personal payment methods load element entries and programmatically linking elements.
• Was involved in upgrading oracle 11i to R12.Retrofited custom RICE objects to R12.Upgraded forms and reports from 11i to R12.
• Developed, designed and tested EEO4 process to merged PPS and oracle data.
• Developed, designed and tested Project Account to WB interface
• Prepared Test Scenario’s and Test Scripts for Oracle Projects (Costing, Grants Mgmt. System, Integration - Purchasing, Fixed Assets, Accounts Payables)
• Involved in Balance Initialization upload. Developed, design and tested to load balances info oracle HRMS
• Developed, designed and tested Performance details review report, Job code class report, and various audit reports.
• Developed Batch Element Entry Interface Program for teh employee assignments element entries.
• Customized seed oracle reports such as Payroll register, check Writer, Deposit Advice and New Hire State Report as per teh DTW requirements
• Wrote Fast formulas for Payroll Elements, Accrual Plans, Absence Duration and Validate Elements for an Assignment.
• Defined Eligibility profiles, Enrollment Requirements, Plans, Programs and standard rates.
• Successfully converted employee contacts information and employees OAB conversion Medical, dental, vision benefits.
• Was involved on Open enrollments process.
• Developed outbound Interface for benefit external carrier BCBS, Delta Dental.
• Involved in end-end testing of objects including installation scripts, Download and upload Ltd. files using FNDLOAD.
• Involved in post-production support for HR/OTA/OLM/Benefits/Payroll and financial modules.

Environment: Oracle Applications R12/11. me (HR, Payroll, OAB, Self-service, CWB), Oracle 8.me/9. me/10g, SQL * Forms 6.me, SQL *Reports 6.me, SQL, PLSQL, TOAD, Web ADI