SUMMARY

• Oracle Certified HCM Cloud Implementation Specialist with 10 plus years of experience in ERP Implementations covering Oracle HCM and Peoplesoft.
• Worked on Oracle HCM - Oracle HCM Global Human Resources - Workforce directory (Employee Self-service & Manager Self Service), Workforce Administration, Grades, Workflows, Workforce Life cycle & Profile Management.
• Oracle HCM Talent Management - Goal Management, Performance Management, Career Development, Talent Review & Succession Planning.
• Oracle HCM Benefits - Open Enrollment set ups & issues, worked on defining Rates, Creating Benefit groups and Processing Life events, addressing life events issues, creating fast formulas with person selection rule etc.
• Full Life Cycle implementations of Global HR and Talent Modules and support experience with Benefits and Payroll modules.
• Experience in system analysis, requirement study, and project plan definition, specification generation, test plan preparation, unit testing & system integration testing.
• Expertise in Gathering, analyzing business requirements and performing Fit-Gap analysis.
• Extensively used HCM Data Loader(HDL), File-based loader (FBL), Spreadsheet Loader and Payroll Batch Loader (PBL) for Migration/Data loading/Conversion of several business objects related to Core HR as well as Payroll modules.
• Data Loading/Conversions of business objects which includes the Workforce structure data, Worker data, Work relationships data etc.
• Strong experience on Test design, Test scenarios, building test scripts & executing them.
• Handled Fusion HCM Cloud Implementation, HCM Cloud Upgrade, Patch updates, Cloud Testing, Support & Maintenance.
• Good experience coordinating with Oracle team on SR’s and critical issues during the HCM Cloud implementation and ongoing Support for quick resolutions.
• Extensive experience in creating OTBI Reports, BI Publisher Reports and HCM Extracts and Personalization.
• Hands on Experience in Creating - Descriptive Flex fields (DFF) and EFF, developed Value sets and Lookups.
• Good experience with Oracle Fusion security roles, role mapping & security profiles.
• Has extensive experience with customizing and integrating FSCM/HCM application with third-party / legacy systems.
• Attended Oracle University Trainings on Oracle Cloud Benefits.
• Technical expertise in PeopleSoft - Application Designer, Application engine, Permission Lists & Roles, SQL, and People code, PS Query, SQR’s and Approval Workflows.
• Involved in PeopleSoft Production Support, Upgrades, Development, Unit Testing and System Integration testing.

TECHNICAL SKILLS

Oracle Fusion Technical: HCM Data Loaders, Spreadsheet Loader, PBL, OTBI, BIP & HCM Extracts

PeopleSoft Modules: HCM/HRMS (Core HR, Base Benefits, NA Payroll, Time & Labor, Profile Management, ESS, MSS) and FSCM (Accounts Payable, Accounts Receivable, Billing, Procurement and Travel & expenses)

PeopleSoft Technical: Application Designer, People Code, Application Engine, Process Scheduler, Component Interface, Integration broker, File Layout, ExceltoCI, Application Messaging, AWE, XML Publisher & Web services

Database: Oracle 12c/11g/10g/9i, SQL Server

Operating Systems: Windows 95/98/NT/2000/XP, Windows7

Languages: Unix, SQL, Peoplecode

Other ERPs: Oracle PeopleSoft

PROFESSIONAL EXPERIENCE

Confidential, OH

Oracle HCM Consultant

Environment: Oracle HCM Cloud Release R11, R12 (Current version)

Responsibilities:

• Gathering Requirements and mapping them to the cloud application functionality and provide solution to the functional gaps.
• Supporting Benefits Business team in Preparing the system for Open Enrollments.
• Knowledge transfer to Business team and documenting the best practices to follow for any Core HR and Benefits transactions, processes etc.
• Involved in end to end Regression testing of the application for Release upgrades as well as Post Patch bundle application.
• Working with business leaders, super users, and end-users (customers) to develop and redesign the business capabilities provided by Oracle Cloud/Fusion and other applications in the HRMS group portfolio, including data flow analysis, system configuration, data setup, including recommendations to implement new features or functions.
• Addressing day to day issues encountered by the users and provides suggestions and solutions on them.
• Fosters a strong relationship with business users in all HR functional areas.
• Created Payroll reports to pull employees MTD Payroll balances.
• Created Payroll report to pull employees arrears elements balances. These employees will be processed through PBL based on this report.
• OTBI and BI reporting contact for entire Total Rewards team. Writing queries or custom reports as needed to analyze data issues, provide ad-hoc reports, and solve system issues.
• Communicates and maintains relationship with Level 1 and Level 2 support organizations to understand quality and support issues for consideration in future HR software product releases.
• Assist with trouble-shooting and resolution of daily/weekly issues, error messages, etc.
• Leads conversations and facilitates discussion with technical resources to translate functional business requirements into technology solutions. Ensures successful delivery of requested work products.
• Addressing Benefits open enrollment issues on a daily basis.
• Overall project management. Tracking and monitoring issues.
• UAT testing, coordinate all patches and bundles (including interfaces) as well as open enrollment.
• Identification of ongoing improvement ideas; assist with documenting the request and working with IT resources to move the work forward.
• Defect identification, development, document, trouble shooting and problem solving, testing, coordinating with vendors.
• Participating in System upgrades.
• Worked on the issues related to global transfers and termination life events.
• Open Enrollment (Benefits) testing and validating the transactions.
• Validating the transactions in Core HR to make sure that they are in sync with Benefits transactions.
• Identifying the errors while validating and testing the data between Core HR & Benefits and then reporting the issues to Business team.
• Processing/Backing out the life events in Benefits Service Center to make sure that the employee don't see any issues during the open enrollment period.
• Resolving issues related to Benefits Life Events and processing them.
• Prepared several OTBI reports including customized reports for most HCM modules and Involved in raising SR with oracle & interacting with oracle team to solve SR related issues.
• Knowledge transfer to Business team and documenting the best practices to follow for Core HR, Benefits Transactions etc.
• Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports which needs to be delivered to Email (Business Users) and FTP sites.
• Developed Absence OTBI reports for Business users which are used to track accrual balance, adjustments, taken absences and carryover hours for different plans. This report will be sent to finance team.
• Developed BI report for Benefits Business team which is used track the enrollment changes occurred during Open Enrollment. This report will give us the employees previous year enrollments and current year enrollments with benefit amounts and coverage levels. Also developed BI report which is used to give us all the active benefits of employees till date.
• Developed Benefits OTBI reports for Business users which are used to track employee Payroll arrear balances for Medical, Dental and Vision plans and then processing employees benefits arrears through PBL as per the report output.
• Developed Compensation OTBI reports for Business users which are used to track the employee current salary and prior salary with the action reasons and increased percentage.
• Supporting Benefits Business team in preparing the system for Open Enrollments.
• Exclusively involved in Onsite and Offshore co-ordination for requirement transitions, meetings and for deliverables.
• Functionality testing of application for various scenarios and ensure that it meets functional specifications for transactions pertaining to Global HR and Benefits after the Patch/ Upgrades.
• Worked on Global Transfers issues related to Core HR and Benefits.

Confidential

Principal Consultant - Oracle HCM Cloud

Responsibilities:

• Conducted workshops to determine the business goals and drivers for the implementation of Oracle HCM Cloud Performance Management Suite which includes Talent Management base, Performance management and Goal Management.
• Prepared the document that details the findings from the Oracle HCM Cloud Performance Management workshops conducted and describes the business objectives, guiding principles, constraints, risks and challenges, assumptions, and other considerations for client’s implementation.
• Involved in Gathering, analyzing business requirements and performed Fit-Gap analysis.
• Gathering requirements and mapping them to the cloud application functionality and provides solutions to the functional gaps related to Goal and Performance Management.
• Created Business Requirement Documentation for Goal Management and Performance Management.
• Developed work plan, follow and deliver in line with Oracle HCM Cloud Implementation Roadmap and Methodology.

Confidential

Oracle HCM & PeopleSoft Specialist

Responsibilities:

• Created Business Requirement Documentation for Goal Management and Performance Management.
• Involved in End to End configuration of Performance management.
• Addressing ad hoc requests on Benefits module.
• Running processes to Create and evaluate life event.
• Created Fast formulas to create Person selection rules to identify population to process Open enrollment.
• Served as Fusion Applications Techno Functional consultant for Extending, Customizing Fusion Applications, and Custom UI implementations.
• Taking up the responsibilities which mostly involved in extending and customizing Fusion Applications functionality and new development.
• Involved in rising the SR’s with Oracle if any of the seeded functionality is not working as expected and participated in many OWC calls with Oracle.
• Worked on Global Transfers issues related to Performance & Goal Management.
• Developed complex BI Reports, one with Core HR data that includes key person and assignment information and the other one which will pull only international (non-US) employees for purpose of establishing a brokerage account.
• Involved in internal reviews like code walkthroughs and unit-review tests of converted programs related to offshore team.
• Involved in preparation of Test Cases, Test Scripts for the Core HR & Talent Management modules.
• Involved in User Interface functional testing & testing the end to end functionalities of Global HR, Goal and Performance Management.
• Functional Configuration and Data Migration in Core HR using HDL.
• Worked on OTBI, BIP Reports related to Core HR, Goal Management & Performance Management.
• Contributed to the repository of Fusion HCM Talent Management training documentation.
• Exclusively involved in Onsite and Offshore co-ordination for requirement transitions, meetings and for deliverables.
• Functionality testing of application for various scenarios and ensure that it meets functional specifications for transactions pertaining to Global HR and Talent Management after the Patch/ Upgrades.
• Involved in Development and testing the custom components in Fusion apps instance.

Confidential

Application Support Specialist

Responsibilities:

• Working with multiple clients concurrently in multiple versions of PeopleSoft and People tools.
• Involved in providing technical support for more than 35 PeopleSoft hosted and remote clients.
• Troubleshoot/debug, performance tuning and Production Support.
• Developed and tuned scripts for SQL/SQR, Application Engine and Data Mover.
• Involved in changing the Search records to establish row level security.
• Developed Pivot grids and pagelets as per the client requirement.
• Developed App Engine program to load the data in to the delivered Job component.
• Worked on Excel to CI, Data mover for loading bulk data into PeopleSoft system.
• Managed security by creating roles and permission lists.
• Customizing existing Interfaces and Queries to suit client requirements.
• Perform code reviews, specifications reviews, update related logs & send regular weekly updates to client as part of our own quality process.
• Involved in training the users and developed hand out documents that are used by the users for understanding the latest changes.
• Provide expert troubleshooting for isolating the technical problems.
• Troubleshooting People code, PS Queries and Application Engines in Production environments.
• Analyze PS Queries, Peoplecode, Application Engine, Application Messaging and Security Administration.
• Developed custom and ad-hoc queries as requested by client which are used to track the total time entered on a particular project on a bi weekly basis.
• Analyzing and troubleshooting the batch job failures.
• Addressing the critical PROD tickets within SLA.
• Created and ran scheduled queries for end users. This scheduled query runs twice in a month to track the time entered for a project.
• Performed project migrations & workbench migrations from TEST to PROD environments.
• Trained the new hires on PeopleSoft technical modules and assigned activities to the new hires to work on them.
• Handling the issues related to application server domains, Process Scheduler & web server domains.
• Strong experience working on PeopleSoft 9.0, 9.1 & 9.2 application versions while handling the tickets from multiple clients.
• Provide quality formal and documentation consistent with client standards.
• Working knowledge of the full application lifecycle.
• Produce business requirements and technical specification documentation for development requests that will be coordinated with team members.

Environment: PeopleSoft v9.1, v9.2, Tools v8.53, v8.55, Oracle Database 11g

Confidential

PeopleSoft Specialist

Responsibilities:

• Performed Fit-Gap analysis for Peoplecode, SQR, Component Interface, Workflow, PS Query and Application Engine.
• Reviewed the compare reports to determine the difference in object definitions.
• Retrofitted and reapplied the customizations using Application Designer and Peoplecode in the new environment.
• Extensively worked on SQR and Application Engine retrofits.
• Worked extensively on North American Payroll and wrote multiple interfaces to load data into Pay Sheet tables.
• Created SQR which extract’s Employee Enrollment information from the Database to the data file.
• Created new PeopleSoft objects like Fields, Records, Pages, Menus, Components, Application Packages, SQL Objects & Application Engines.
• Loaded job data changes from a spreadsheet via a custom page in PeopleSoft.
• Worked on retrofitting SQR objects from 9.0 to 9.2 along with the new enhancements to them.
• Upgraded and generated custom inbound and outbound SQR reports for HR and Benefits.
• Worked on Job, Personal data & Payroll data conversions to extract and load data from Legacy system into PeopleSoft 9.2.
• Unit tested the customizations to make sure that it is working fine in the new environment and created Unit Test Plan & Test Results to signoff.
• Converted multiple manual jobs into automated ones thereby decreasing manual effort and increasing overall system performance.
• Involved in developing test plans and test scenarios for various modules of HRMS Application to ensure proper business compliance.
• Involved in unit testing and peer testing and defect fixing.

Environment: PeopleSoft v8.8, v9.2, Tools v8.49, v8.54, Oracle Database 10g

Confidential, Oklahoma City, OK

PeopleSoft Specialist

Responsibilities:

• Involved in the PeopleSoft upgrade of Project for Core HR, Benefits and Profile Management modules.
• Involved in setup of Set ID table, Company Information, Establishments, Location, Department, Salary Plan, Job Code and Pay Group tables for HRMS System.
• Loaded data via ExceltoCI for Non-Person Profiles in Profile Management.
• Used Excel to CI to import data in higher volumes into the PeopleSoft system.
• Created new Peoplecode application class method to ensure that the correct profile identifier data is being inserted via a component interface.
• Created custom setup pages and developed asynchronous integration between setup pages in HCM and FSCM using Integration Broker.
• Worked closely with the business analyst to create technical design documents and PeopleSoft objects to the customer business needs.
• Created new PeopleSoft objects like Fields, Records, Pages, Menus, Components, Application Packages, SQL Objects, Application Engines, and Component Interfaces & IB Services.
• Retrofitting objects - Peoplecode, SQL, SQRs, UNIX Scripts and AEs based on the requirement and Build the objects.
• Customized and tested the SQRs and App Engine programs based on new requirement.
• Developed various PS Queries to help the client day to day activity.
• Developed bolt on pages required for interfaces & testing online applications.
• Involved in developing test plans and test scenarios for various modules of HRMS Application to ensure proper business compliance.
• Worked extensively on Application Designer, Application Engine, Peoplecode, Application Package, Integration Broker, Component Interface, PS Query, and XML/BI Publisher.
• Discussing and providing support during the system testing and UAT to solve any functional/technical issues that arise and finish them within SLA time lines.
• Involved in unit testing, peer testing and defect fixing.

Environment: PeopleSoft v9.0, v9.2, People Tools v8.49, v8.54, Oracle Database 10g

Confidential

PeopleSoft Specialist

Responsibilities:

• Analysis of the requirements to understand the complexity/effort and impact.
• Worked closely with the business analyst to create technical design documents and PeopleSoft objects to the customer business needs.
• Created new PeopleSoft objects (Panels, Panel Groups, Menus, People Code, Application Packages and Process Definition) based on the requirement.
• Developed Approval Workflow to trigger Emails to Users with Designated Entry Authority for expense and timesheets. Whenever a user submits the expense or time report on behalf of someone and if the expense/time report gets rejected by manager, Email will be triggered to the designated user and actual user.
• Developed Workflow to trigger an email to Billing Team for all the finalized Invoice Copies which will help billing team keep track of all invoices finalized.
• Customizing and testing the existing SQRs, PS Queries, and AEs based on new requirement.
• Developed bolt on pages required for interfaces & testing online applications.
• Prepared online reports using SQRs and Application Engines.
• Involved in developing test plans and test scenarios for various modules of HRMS Application to ensure proper business compliance.
• Worked on Application Messaging errors and restarted them accordingly.
• Coordinated with the users for any clarifications on the requirements.
• Involved in defect fixing and sent the daily status report on all the defects assigned.
• Maintaining track of the defects raised and status of them.

Environment: PeopleSoft 9.0, v9.2, People Tools v8.49, v8.54, Oracle Database 10g

Confidential, NY

Technical Analyst-ERP

Responsibilities:

• Created new and customized existing PeopleSoft objects (Panels, Panel Groups, Menus, People Code, and Process Definition) and SQRs as per the requirement.
• Troubleshooting People code, PS Queries and Application Engines in Production environments & troubleshooting the Process failures.
• Worked closely with the business analyst to create technical design documents and PeopleSoft objects to the customer business needs.
• Developed bolt on pages required for interfaces & testing online applications.
• Created various permissions, roles & user profiles to fit user’s requirement.
• Actively involved in discussion for various issues regarding different modules with the team.
• Involved in unit testing, peer testing and defect fixing.
• Giving demo to the client about the finished developments before user testing.

Environment: PeopleSoft v9.1, People Tools v8.52, Oracle Database 10g

Confidential, Minneapolis, MN

Technical Analyst & QA Analyst-ERP

Responsibilities:

• Reviewed Business requirements, IT Design documents and prepared Test Plans for all assigned project releases.
• Involved in testing entire referral module and Lead-Referral interface.
• Involved in testing Referral Management Module that includes Search Recipient, Offer/Product Recommendation, and Search Referral.
• Involved in testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Ensure that all the test cases are written and updated in the HP Quality Center.
• Involved in System Integration Testing.
• Involved in Backend Database testing using Oracle SQL Developer.
• Defects were tracked, reviewed, analyzed and compared using HP Quality Center.
• Reported defects in timely manner and logged the same into defect tracking tool.
• Verified the Fixed CRs and tracked the same to closure.

Environment: PeopleSoft v9.1 People Tools 8.51 Oracle Database 10g

Confidential, Boston, MA

Technical Analyst-ERP

Responsibilities:

• Actively involved in PeopleSoft Financials Upgrade from v8.8 to 9.1.
• Created new and customized existing PeopleSoft objects (Panels, Menus, Peoplecode, and Process Definition) and applied security.
• Identified, documented and resolved issues in Financials Upgrade (AP, AR and GL).
• Upgrading, Support and Troubleshooting Technical issues.
• Modified Application Engines and Modified custom PS objects.
• Involved in executing Test cases/scripts.
• Involved in Vanilla compare to find out the level of customization.
• Reviewed the Compare Reports to determine the differences in object definitions.
• Retrofitted and reapplied customizations using Application Designer & Peoplecode.
• Developed and modified Application Engine, PS Query and Crystal Reports as per Business Requirements.
• Worked on records, pages, SQR and Application Engine Programs.
• Involved in running Upgrade compare reports between Demo database and Copy of production before we do the upgrade copy.
• Modified customized SQR reports to make it version 9.1 compatible.
• Extensively used Process Scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of the Reports.
• Created Permission Lists, Roles and assigned Roles to users through Maintain Security.
• Retrofitted People Code programs.
• Retrofitted and tested Application Engine programs.
• Customized existing Interfaces and Queries to suit client requirements.
• Developed ad-hoc reports and ad-hoc queries and developed run control pages as per requirements and attached to menu to run SQRs.
• Extensively used Process Scheduler for setting up the reports to run at specific time.
• Involved in the daily status calls.
• Involved in developing test plans and test scenarios for various modules of FSCM application to ensure proper business compliance.
• Adjusting existing definitions on pages for accurate design purpose.
• Involved in Keep-Drop Analysis, Impact Analysis.
• Involved in Unit testing and prepared UTCs.

Environment: PeopleSoftv8.8, v9.1, People Tools v8.50, v8.52 Oracle Database 10g

Confidential, Westerville, OH

System Analyst

Responsibilities:

• Gathering requirements from the onsite coordinator and analyzing user requirements.
• Worked closely with the business analyst to create technical design documents.
• Involved in developing test plans and test scenarios for various modules of HRMS Application to ensure proper business compliance.
• Developed SQR Reports for Employee timesheets, Unapproved timesheets by employee, Timesheet status for Timesheet supervisor, Employee contract assignments, Employee bill rates, Employee pay rates and Employee Security.
• Created run control records, run control pages as per the requirements and attached to menu to run the SQR online through PeopleSoft by using Process Scheduler.
• Development and Enhancement of online objects.
• Developed several PS query reports in both 2-tier and N-tier.
• Worked extensively in debugging, tracing and compiling various Application Engine and SQR programs.
• Configured the application to add new business logic as per the user requirement.
• Developed reports using SQR, PS Query based on Technical Specifications.
• Adjusting existing definitions on pages for accurate design purpose.
• Modifying existing Peoplecode for Objects.
• Documented all the modifications and maintaining history for future reference.
• Customization of existing Interfaces and Reports to suit client requirements.
• Developed Run Control Pages as per requirements and attached to menu to run custom SQRs.
• Resolved Technical issues rose during the daily working of the university.
• Sending the daily project status report.

Environment: PeopleSoft v8.8, People Tools v8.51, Microsoft SQL Server 2005