SUMMARY

• 10+ years. of Oracle HRMS/HCM Techno Functonal experience.
• Functional experience includes: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.
• Technical Activities: interfacing with users, identifying functional and technical gaps, estimating work, experienced in writing PL/SQL queries to validate the data, and providing production support.
• Experience in implementation and customization of Oracle E - Business Suite R12/11i (HR, Payroll, OAB, SSHR, OLM, OTL) Modules
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications within HCM modules (Core-HR, Workforce Administration, Oracle Learning Management, Advanced Benefits, Absence Management, Payroll, Employee Self Service, Manager Self Service), Oracle Time and Labor (OTL)
• Provided solutions for customers to automate Human Resources Management processes.
• Experienced in complete payroll cycle with Pay Processing, Retro Pay, Costing and Transfer to GL
• As a business systems analyst created As-Is, To-Be, Mapping and Gaps Documents, Also creation Functional Specification for extensions like Reports, Forms and Interfaces
• Prepared UAT test cases to make sure that data elements captured as per the requirements
• Hands on experience in PL/SQL
• Have worked with top-notch companies in different businesses like Public Utility, Manufacturing, Education, Textile, Process, Service Providers, Government and Counties. Possess good communication skills, resulting in excellent rapport with employees, peers and executive management. Team player who is project and result oriented. Collaborate well with project management, business analysts, and department management teams.

TECHNICAL SKILLS

Database: Oracle 11g/10g/9i,MS Access

ERP Versions: Releases 11.5.8, 11.5.10 and R12.1.2, R12.1.3

ERP Modules: HRMS/Payroll and Time and Labor, Absence Management, SSHR, OAB and OLM

Job Experience: Adept at all stages SDLC and project lifecycle, from business requirements and technical definitions to development, testing, writing Functional and Technical Documentation (MD50-MD70), Training Documents, Test Plans including test case scenarios, unit test execution, user acceptance testing (UAT), production support, Interacting with End-User, Functional Analyst and DBA.

Tools: / Utilities: PL/SQL, Toad, Discoverer, XML, SQL*PLUS, PVCS Version Manager, HTML, Java Script, JSP, ASP, Oracle Portal, Microsoft Visual SourceSafe.

Other Tools: Ms-Access, MS-Office etc.

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Oracle Cloud Fusion HCM Techno Functional Analyst

Responsibilities:

• Defining earnings and deduction elements, Defining Element classification, defining links, salary basis elements, Setting up employer and employee tax information
• Creating Payment Methods and payrolls, Wage attachments, Payroll, pre-payment, NACHA, deposit advice, check writer processes, Costing process
• Worked on the Retry, rollback and reversal of payrolls.
• Setup Time Entry and Validation and approval in Workforce.
• Setup Time Entry rules using formulas and also with a set of fields in Workforce.
• Worked on lots of new plan setups, Designing and Developing special Fast Formula rules for Domestic partners/Common Law spouses - Certifications etc.
• Worked on custom Benefit Confirmations with Statement of Health attachments
• New Plan Setups, Rate Conversions, Plan Conversions and 401K Enrollments for the new Plan years.
• Setting up of Manager Self Service, Workflow Approval and AME Approval setups
• Custom ABBR Process to calculate and insert record in People SIT
• Worked on Salary updates using Salary API
• Mapped data between HR and ADP.
• Setup Business Group, Departments, Jobs and Grades.
• Setup complete organization hierarchies
• Setup securities for various responsibilities to provide data segregation
• And make excess to secure data
• Setup Benefits Program, Plan Types, and Plans including Medical,
• Dental, Vision, Flexible Spending, Group Term Life Insurance
• Setup Life events, Derived Factors and Eligibility Profiles
• Setup detailed Program and Plans Enrolment Requirements
• Setup Coverage calculations, Standard and Variable Rates, and Premium Calculation
• Setup detailed Program and Plans Enrolment Requirements
• Involved in training customers.
• Involved in debugging and testing of the product.
• Involved in the Process Setup by defining the Key Flex Fields and
• Descriptive Flex Fields for Jobs, Grade and people group as per the
• Worked on personalization SSHR screens
• Work on form personalization’s
• Setup HR related Descriptive Flex Fields, Key Flex Fields, Validation
• Sets, Special Information Types, Security Profile attachments, users, responsibilities, request sets and menus under the System Administrator responsibility
• Configured HRMS Organization Structure to create government
• Mandated Reports instead of client relying on custom reports and
• Third party sources for HR and Benefits
• Involved in creating the custom menus with different sets of core Oracle
• HR functionality based on the user groups.

Confidential, Arlington, VA

Oracle HCM Techno Functional Analyst

Responsibilities:

• Defined competence flex fields for adding competencies, descriptive flex fields for capturing the additional information of key responsibility areas (KRA) and special information types for capturing specific information
• Deployed AIM methodology for implementation, and continually created, updated, and maintained standardized documents and templates, throughout the life cycle of the project to help support project delivery and tasks within scope, on time and on budget.
• Setup the OTL Elements and element time information in OTL.
• Setup Time Management structures in OTL.
• Worked on the self-service time card configuration in OTL.
• Worked on the Time entry transfer process to Oracle projects using the transaction import from OTL process.
• Worked on setting up OTL for exporting and importing time templates for disconnected time entry.
• Used the Automatic Time card generation process to generate timecards in OTL.
• Transferred the self-service timecards to Oracle Projects using the PRC: Transaction Import Process.
• Worked on enabling OTL Timekeeper functionality.
• Supported the interface between Oracle Project Accounting and Oracle OTL.
• Worked on Oracle Absence Management module - defining general absence, absence structures, absence formulas and rates, absence time periods, defining eligibility, etc.
• Configured HR/Payroll. Set up Key and Descriptive flex fields, Organizations (Business Groups, GRE, HR etc.), Locations, Payment Methods, Consolidation Sets, Payrolls, Salary Basis, Elements, Element Links, Retro Pay, BEE, Absence Management and PTO Accrual Plans, Values sets, Employer and Employee Tax Rules, Assignment Sets, Fast formulas, Balances, Dimensions, User Functions, Global Values, Responsibilities, Request groups, Users etc.
• Worked on Advanced Benefits module - defining general benefits, defining benefits eligibility, defining life events, benefit rates and coverages, enrollment, enabling offerings, defining different plan types, creating eligibility profiles, defining benefit plans.
• Following are activities that I have assisted the client: Payroll Pre-processing, Payroll Processing, Pre-payments, Process Payroll Using subsets (Assignment set, Consolidation set, Element set), Payroll Post processing, Running Year End Process, Federal/State W2, NACHA, Deposit Advices, Direct Deposit etc., Adjust Balances, Processing Quick pay, Rollbacks, Retries, Reversals, Run various reports, Creation of elements, Retro pay Process, Setup 401(k) plans etc.
• Wrote fast formulas and functions for various Elements.
• Created and implemented various test plans. Conducted Functional, Technical and User Acceptance Testing. Assisted the Business Users to execute the Test cases and to verify the test results.
• Reviewed Technical and Migration documents for Conversions, Interfaces and Extensions.
• Assisted the Technical team for conversion of Employees, Address, Assignments, Element Entries, Taxes, SIT, EIT and Balances for US and Canada.
• Created the new XML report for Payslip.
• Defined Data definition, and Templates.
• Coordinated with DBAs to apply various Patches.
• Developed PL/SQL code to produce the output in the format of XML tags.
• Created template layouts in rtf format (Microsoft word) to generate the output in PDF, HTML and Excel and Word formats.
• Developed the Automated script to submit the Concurrent Programs.
• Developed Shell Script to transfer the generated pdf output to FTP folder.
• Migrated the Code using Harvest and Mercury IT Governance.
• Managed Oracle SRs.

Confidential, Lincolnshire, IL

Oracle HRMS/HCM Techno Functional Analyst

Responsibilities:

• Conducted few requirements gathering workshops with users, to write functional design documents / MD050s for some of CEMLI objects
• Updated BR 100 documents with all the configuration changes per design of these CEMLI objects.
• My CEMLI objects included interfaces, reports and fast formulae.
• Have used XML Publisher to develop reports including check writer program.
• Designed and developed data conversion documents, for offshore team to develop conversion programs.
• Worked on the Advanced Benefits modules.
• Granting required access to HCM secured business Objects (Unless you grant access to these objects, users cannot access them) through security profiles.
• Configured Workforce Life Cycle Management in Oracle Fusion.
• Worked on the setups of Core-HR, Workforce Administration, Oracle Learning Management, Payroll, Employee Self Service, Manager Self Service.
• Worked on the Oracle Time and Labor (OTL) module configurations.
• Worked closely with the Functional Team Lead to optimize business processes and dealt with innovatively by taking advantage of application functionality to improve the functions
• Have done code review of conversion, interface and reports code.
• Helped offshore team in writing some of the complex select statements used in conversion and interfaces.
• Written some of the complex payroll fast formulae that are needed for Union deductions.
• Assisted in configuring payroll setups per BR100s, used data loader for loading data including element input values, payroll balances and balance feeds.
• Responsible for complete detailed analysis on assigned deliverables and supported the deliverables throughout the project life cycle
• Used extensively HP Quality center, to log defects during testing phase of the project.
• Validating Data conversions from legacy system to Oracle.
• Share load of the peers as needed during parallel and product testing.
• Conducted Knowledge transfer sessions with client’s IT personnel.
• Coordinated with End Users, DBA Team, Functional Team, Operations and Infrastructure Teams as required on problem resolution and enhancements
• Assisted the team during the parallel testing and user acceptance testing
• Responsible for formal reviews of analysis deliverables, presented final solution to project team and all impacted areas to obtain sign off
• Interact actively with SEM / DATA teams during configuration and conversion phases of the project.

Confidential, Arlington, VA

Oracle HRMS/HCM Techno Functional Analyst

Responsibilities:

• Defined competence flex fields for adding competencies, descriptive flex fields for capturing the additional information of key responsibility areas (KRA) and special information types for capturing specific information
• Deployed AIM methodology for implementation, and continually created, updated, and maintained standardized documents and templates, throughout the life cycle of the project to help support project delivery and tasks within scope, on time and on budget.
• Defined value sets, added extra data to existing value sets which enables to capture the list of competencies with valid dates and rating scale
• Defines rating scales, tables, global values, lookups which are used in KRA setting and appraisal process
• Worked on the setups of Core-HR, Workforce Administration, Advance Benefits, Oracle Learning Management, Payroll, Incentive Compensation, Employee Self Service, Manager Self Service
• Supported in implementations of Oracle Advanced Benefits
• Created Benefit Structure such as Program, Plan Types, Plans and Options
• Life events, Eligibility, Electability and person types were analysed as per the requirement
• Rate, Premium, Coverage and data were set as per the business requirements
• System administrators functionality: creation of User/Responsibility set up of menus, functions and custom forms, setting up of profile options
• Involved in preparing setup documents, end user training materials, configuration set ups
• Post- Implementation support
• Designed and developed fast formulae for voluntary deductions, logic that has been detailed in MD050
• Designed and developed fast formulae for arrearage calculations, which is different from Oracle delivered functionality
• Designed and developed process of shift calculations that are very different compared to Oracle’s delivered functionality
• Written MD070 documents for all the development taken
• Developed Functional Requirements Solution Documents, Test Scripts and Setup Documents. This included analysis, design and documentation of the functionality, customized reports
• Amendment to the sign off document, taking the amendment and incorporating in and resign off the amended document
• Changed input values and formula results and conducted test run on elements to test the modified formulae and reported to the clients
• Basic PL/SQL functions were managed

Software/Tools: Oracle E-Business Suite Modules R 12.1.3 (Worked on the setups of Core-HR, Workforce Administration, Oracle Learning Management, Payroll, Incentive Compensation, Employee Self Service, Manager Self Service), TOAD

Environment: IBM AIX/ HP UNIX/ MS-Windows

Confidential

Techno Functional Consultant

Responsibilities:

• Involved in requirement gathering.
• Identified gaps and documented gap analysis
• Conducting CRPs with end users and finalizing the requirements.
• Analyzed created and maintained running BR100 documentation
• Liaison between users and technical folks.
• Created MD 50 functional design documents for the identified customization
• Designed and developed process of shift calculations that are very different compared to Oracle’s delivered functionality
• Involved and maintained RICE/CEMLI list of custom objects
• Configured payroll setups per BR 100
• Involved in preparing setup documents, end user training materials, configuration set ups
• Conducted weekly project meetings.
• Payroll implementations especially the ones in India is a big challenge given the complex tax laws and their interpretations which many times is different from the features available in Oracle India Legislation.
• Many HR and payroll Fast formulae were written to achieve the level of flexibility needed.
• Toyota Methodology for Project Management, Documentation and Process standards were followed
• Conducted UAT/Parallel/System integration testing
• Post production support as needed

Software Tools: Oracle ERP Modules R 12.1.3 (HRMS Payroll)