SUMMARY:

• Over 10+ years of experience in IT industry.
• Extensively on Oracle HCM Cloud Integrations, Application Security, SSO, User Provisioning, HDL and BI Publisher Reports in implementing, upgrading and supporting.
• Functional knowledge on Core HR, Compensation, Payroll, Talent Management modules in Oracle HCM Cloud.
• Extensively on PeopleSoft HRMS Analysis and Development experience in customizing HRMS modules and supporting Core HRMS, North American Payroll, Base Benefits, Benefits Administration, Security, ESS and MSS systems by performing enhancements and modifications of the PeopleSoft HRMS online objects, SQR reports, SQR interfaces, App Engine programs and people code and is very proficient in application design, development, implementation and customizations.
• Strong experience in analyzing, developing and customizing of the complex PL/SQL programs and fine tuning them.
• Strong experience in applying Tax Updates for PeopleSoft Payroll for North America and PeopleSoft HRMS 9.1 upgrade.
• Good Communication skills.
• Very good analytical and problem solving skills.

TECHNICAL SKILLS:

Oracle HCM Cloud: R9, R10, R11, R12 & R13 - Core HR, Compensation, Payroll, Talent Management, ESS & MSS

Development Tools: Application Security, SSO, User Provisioning, HDL, BI Publisher, HDL and OTBI reports.

PeopleSoft: PeopleSoft 8.8/8.9/9.0/9.1 HRMS, Core HRMS, Base Benefits, Benefits Administration, North American Payroll, Tax Updates, People Tools 8.46/8.49/8.52 .

Development Tools: Application Designer, PeopleCode, Application Engine, Component Interface, Integration Broker, PS Query, Tree Manager, Component Registry.

Administration Tools: Security Administrator, Object Security.

Data Management: Data Mover and Process Scheduler.

Reporting Tools: SQR, XML Publisher, PS/Query, Crystal Reports.

Operating Systems: Windows NT/2k/XP/Vista/7.

Languages: C, C++, Java, PL/SQL.

Database Systems: Oracle 9i/10G, SQL Server 2000/2005, MS-Access.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. Programmer Analyst

Responsibilities:

• Analyzing and understanding business requirements.
• Meeting business users and customers to gather detail functional requirements.
• Preparing technical analysis (analysis details + solution options + estimations) documents for the business requirements.
• Preparing unit test cases and test plan for the requirements.
• Attending test plan meetings to discuss about the testing strategy.
• Implemented & supported Oracle HCM Cloud application security by building various custom roles, auto-provision rules and personalization etc. when migrating from PeopleSoft.
• Implemented automated new hire provisioning process for network & work email access and played very key lead role in designing the whole end-to-end process by working with various internal teams.
• Played key lead role in implementing SSO & password reset/setup functionality for all Oracle HCM Cloud users.
• Supporting major release upgrades & monthly updates for Oracle HCM Cloud.
• Supporting production issues and various requests from business groups.
• Supported data loads for HR Setups, Compensation setups & other data using HDL.
• Developed and supported BI Publisher and OTBI Reports.
• Supporting QA team and functional test team in testing the enhancements.
• Involved in post-production support of the modules by fixing the issues that come up in production.
• Planning and scheduling the work requests order based on priority and criticality of the enhancements requests created by the business users.

Environment: Oracle HCM Cloud (R9, R10, R11, R12, R13), PeopleSoft HRMS 9.0, PeopleTools 8.48, UNIX file server, Oracle 10g, Tools used: Toad, CuteFTP, Share Point, ALM, Ultra Edit and Beyond Compare.

Confidential, Columbus, OH

Programmer Analyst (PeopleSoft)

Responsibilities:

• Analyzing and understanding the high level business requirements.
• Meeting business users and customers to gather detail functional requirements.
• Preparing technical analysis (analysis details + solution options + estimations) documents for the business requirements.
• Getting approvals for the technical analysis and proposed solutions.
• Preparing developer test cases and test plan for the requirements.
• Attending test plan meetings to discuss about the testing strategy.
• Enhanced custom AE programs to accommodate the business requirements.
• Developed and customized several online run control pages for the SQRs.
• Involved in creation of inbound/outbound SQR interfaces.
• Extensively involved in writing peoplecode programs and testing them.
• Extensively executed SQL on Oracle tables to determine successful transaction of data from the application.
• Extensively unit testing the areas which get impacted by enhancements and new changes.
• Preparing technical specifications and test results documents.
• Supporting QA team and functional test team in testing the enhancements.
• Involved in post-production support of the modules by fixing the issues that come up in production.
• Planning and scheduling the work requests order based on priority and criticality of the enhancements requests created by the business users.

Environment: PeopleSoft HRMS 9.0, PeopleTools 8.48, UNIX file server, Oracle 10g, Tools used: Toad, CuteFTP, Share Point, ALM, Ultra Edit and Beyond Compare.

Confidential, Federal Way, WA

PeopleSoft Developer/PeopleSoft Upgrade Analyst

Responsibilities:

• Analyzing and understanding the high level business requirements.
• Meeting business users and customers to gather detail functional requirements.
• Preparing technical analysis (analysis details + solution options + estimations) documents for the business requirements.
• Getting approvals for the technical analysis and proposed solutions.
• Preparing developer test cases and test plan for the requirements.
• Attending test plan meetings to discuss about the testing strategy.
• Applying latest Tax Updates bundles, ADP updates and other patches whenever they are being released.
• Enhanced multiple complex custom SQR outbound interfaces to meet the current changes in Benefits Administration and Payroll business process.
• Enhanced custom AE programs to accommodate the business requirements.
• Developed and customized several online run control pages for the SQRs.
• Involved in creation of inbound/outbound SQR interfaces.
• Extensively involved in writing peoplecode programs and testing them.
• Extensively executed SQL on Oracle tables to determine successful transaction of data from the application.
• After the completion of development, need to work with code reviewers to get the new/modified code/objects reviewed as per the client standards.
• Extensively unit testing the areas which get impacted by enhancements and new changes.
• Preparing technical specifications and test results documents.
• Supporting QA team and functional test team in testing the enhancements.
• Involved in post-production support of the modules by fixing the issues that come up in production.
• Planning and scheduling the work requests order based on priority and criticality of the enhancements requests created by the business users.
• Working as HRMS On-Call support analyst for production environment.

Environment: Citrix secure gateway, UNIX file server, PeopleTools 8.46, Oracle 9i, Application Release HRMS 8.8SP1, Tools used: Reflection, Toad, OVSD/Service Manager - Issue assigning and tracking, VSS, WeyCC (Bolt-on application in PeopleSoft for Change Control and Time entry).

Confidential, Seattle, WA

PeopleSoft Analyst / Developer

Responsibilities:

• Analyzing and understanding the country specific business requirements.
• Developed new online pages like setup pages, ESS, MSS and administrator pages, components and registering them.
• Extensively involved in writing peoplecode programs and testing them.
• Developed new custom app engine process to calculate the time-off balances for all eligible employees.
• Involved in development of the PeopleSoft test cases and Test plans.
• Involved in unit testing and manual testing of Application.
• Involved in post-production support of the modules by fixing the issues that come up in production.
• Active participation in onsite - offshore conference calls.

Environment: VPN Connection, PeopleTools 8.49.27, Oracle 11g, Application Release HRMS 8.90

Confidential, Seattle, WA

PeopleSoft Analyst / Developer

Responsibilities:

• Analyzing and understanding the requirements/enhancements.
• Developed several new online pages, components and registering them.
• Extensively involved in writing peoplecode programs and testing them.
• Involved in development of the PeopleSoft test cases and Test plans.
• Involved in unit testing and manual testing of Application.
• Involved in post production support of the modules by fixing the issues that come up in production.
• Active participation in onsite - offshore conference calls.

Environment: Network Connection, Virtual Remote Desktop Connection, Citrix, PeopleTools 8.49, SQL Server 2008, Application Release HRMS 8.9

Confidential, Seattle, WA

PeopleSoft Analyst / Developer

Responsibilities:

• Analyzing and understanding the requirements/enhancements.
• Analyzing the tax update release notes.
• Developed several new online pages, components and registering them.
• Analyzing Confidential customizations/enhancements and preparing the documents regarding the findings from analysis.
• Understanding the release notes for Maintenance packs 6 and 7.
• Running compare reports in application designer and analyzing them.
• Reapplying the Confidential customizations.
• Comparing the production and maintenance packs versions of SQRs and reapplying the needed customizations after analysis.
• Involved in development of new SQRs and customization of several delivered SQRs.
• Involved in customizations of the PeopleSoft delivered peoplecode and testing them.
• Developed several PL/SQL Stored procedures and testing them.
• Analyzing the complex PL/SQL programs and customizing them.
• Involved in development of the PeopleSoft test cases and Test plans.
• Involved in unit testing and manual testing of affected areas in Application.
• Involved in post production support of the project by fixing the issues that come up in production.
• Involved in preparation of the technical specification documents.
• Involved in preparation of the objects list document to maintain the change history of newly created and affected objects.
• Involved in post-production support of the project by fixing the issues that come up in production.
• Active participation in onsite - offshore conference calls.

Environment: Citrix Connection, PeopleTools 8.49, SQL Server 2005, Application Release HRMS 9.0

Confidential, Federal Way, WA

PeopleSoft Analyst/Developer

Responsibilities:

• Attended several client meetings and status meetings.
• Involved in creation of outbound SQR interfaces.
• Developed several run control pages for the new SQRs developed.
• Registered the component using Component Registry.
• Responsible for the manual development of the PeopleSoft test cases and Test plans.
• Involved in unit testing and manual testing of Application.
• Involved in preparation of the technical specification documents.
• Active participation in onsite - offshore conference calls.

Environment: Citrix secure gateway, UNIX file server, PeopleTools 8.46, Oracle 9i, Application Release HRMS 8.8SP1, Tools used: Reflection, Toad, OVSD - Issue assigning and tracking, VSS, WeyCC (Bolt-on application in PeopleSoft for Change Control and Time entry).

Confidential, Seattle, WA

PeopleSoft Analyst / Developer

Responsibilities:

• Analyzing and understanding the requirements/enhancements.
• Developed several new online pages, components and registering them.
• Extensively involved in writing peoplecode programs and testing them.
• Involved in development of the PeopleSoft test cases and Test plans.
• Involved in unit testing and manual testing of Application.
• Active participation in onsite - offshore conference calls.

Environment: Network Connection, Virtual Remote Desktop Connection, Citrix, PeopleTools 8.49, SQL Server 2008, Application Release HRMS 8.9

Confidential, Federal Way, WA

PeopleSoft Developer

Responsibilities:

• Analyzing and understanding the requirements documents.
• Developed new pages and components.
• Involved in development of new SQRs and customization of several delivered SQRs.
• Developed and customized several online run control pages for the new SQRs developed.
• Involved in creation of inbound/outbound SQR interfaces.
• Extensively involved in writing peoplecode programs and testing them.
• Extensively executed SQL on Oracle tables to determine successful transaction of data from the application.
• Involved in unit testing and manual testing of Application.
• Involved in post production support of the modules by fixing the issues that come up in production.
• Active participation in onsite - offshore conference calls.

Environment: Citrix secure gateway, UNIX file server, PeopleTools 8.46, Oracle 9i, Application Release HRMS 8.8SP1, Tools used: Reflection, Toad, OVSD - Issue assigning and tracking, VSS, WeyCC (Bolt-on application in PeopleSoft for Change Control and Time entry).