SUMMARY:

• Experienced in full software development life cycle such as requirements gathering, setups, development, testing, implementation and support of Oracle Application (Oracle HCM R12, Oracle HRMS 11i, Oracle Clinical, and PDS HRMS) and PeopleSoft for different Business Sectors. skills

TECHNICAL SKILLS:

ERP Applications: Oracle HCM R12, Oracle HRMS 11i, PeopleSoft 9.2,Oracle Clinical, PDS HRMS

Front End Tools: Oracle Developer 2000 (Oracle Reports 2.5/6.x), Discoverer (Oracle Browser 1.0, 4.0), Crystal Reports 6.5/8.x, Toad, SQL Navigator, HP Quality Center, KBX (Reporting tool)

Agile and Rational Tools (ReqPro, RQM, RTC)Databases: Oracle 8.x, Oracle 9i, 10G

Operating Systems: UNIX, Windows NT, Windows 9x, Windows 2000, Windows XP

Platforms: IBM RISC 6000 and IBM PCs

Languages: SQL*Plus, PL/SQL, SQL*Loader, HTML

PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft Financials Consultant

Environment: PeopleSoft Financials 9.2

Responsibilities:

• Responsible for providing support to technical professionals with PeopleSoft GL and participation in related system development projects of the most complex system. Uses appropriate project management techniques and methods to produce project deliverables
• Requirements documents, design documents, issues identification and management, identification of system defects, test plans.
• Gather Requirements, write Functional Design Documents, develop Use cases and Test scripts. Execute Unit and UAT test for interfaces.
• Use of metrics to measure project success, develops desktop procedures and
• Conducts and/or oversees pre - and post-implementation review and sign-off. Presents project deliverables to appropriate audiences, Coordinates release procedures and processes.
• Identifies and implements contingency plans and performs risk management assessments. Develop business solutions to satisfy project goals and objectives.

Confidential, Camp Hill, PA

Sr. HRIS Functional Lead

Environment: Oracle HCM - R12

Responsibilities:

• Responsible for ongoing application support, maintenance, and patches for Oracle Payroll, HR and OAB modules that support Shared Services Payroll for US/Canada.
• Liaison between Information Technology department and the Payroll and Human Resource business stakeholders and senior management to identify and address business needs, requirements and resolve complex system problems.
• Develop Functional Design documents including Requirement Documents and Functional Design Documents (RD and MD050), Test scenarios, Test scripts and provide direction to offshore development team.
• Lead Adhoc projects. Setup a project plan and supported yearend payroll process for US and Canada Business Groups.
• Supported Compensation and yearly merit process.
• Execute tests for developed objects using KBACE KBX Reports for data validation.
• Managed ATS (Applicant Tracking System) project for entire vendor selection process including the research, analysis, communications and collaboration with vendors and business stake holders for the product demonstrations and assist finalizing the vendor selection process.
• Supported functional aspect of interfaces by collaborating with vendors and business users.
• Provide functional setups, development, testing and support of application changes and enhancements. Actively participate in Payroll, HR and Benefits planning activities.
• Responsible for daily system support tasks to identify, provide expertise, track, and resolve system issues with internal users including HR, Payroll, Benefits and external vendors.
• Acts as functional expert for deployed Oracle modules. Assist users with application issues and needs as required. Identify and resolve errors or problems within existing processes and programs.
• Analyze business processes to identify and propose new business processes or program changes to address specific requirements and provide continuous improvement.
• Prepare Standard Operating Procedures and update necessary documentation and assist in developing and maintaining system documentation, using Oracle AIM methodology.
• Ensures all specifications and related activities comply with the global Harsco compliance standards and procedures.

Confidential, Pittsburgh, PA

Oracle HCM Consultant

Environment: Oracle HCM - R12 Implementation

Responsibilities:

• Gathered requirements and developed Functional Design Documents (MD50) for payroll, HR, OAB and CWB. Analyzed and designed new business processes and application configuration requirements. Conducted meetings with business owners to develop the Functional Design Documents.
• Completed setups and configurations to support the new functionality in the application. Documented setups in BR100
• Setup the data for testing in each module and conducted test in different cycles. Translated business requirements into test cases, Test Strategies, Scoping, Test Planning and estimations, tracking in HP Quality Center. Setup Test data and Test Environments readiness for testing.
• Coordinated with different teams for requirement gathering, testing and solutions for the problems raised during the testing. Served as liaison to business including super users and process area sponsors.
• Worked with RICE team and Developers to complete developing the interfaces, Reports and Extensions and ready for Testing. Opened defects in QC and worked with Developers and RICE team to fix the issues. Tracked and managed opened defects.
• Lead Oracle R12 HCM implementations testing aspect for a different HCM Modules including Core HR Compensation Work Bench.
• Translated business requirements into test cases, test scenarios, test scripts in HP Quality Center. Supported end users with Unit testing.
• Executed product and user acceptance tests according to detailed test plans, logged defects while testing in HP Quality Center 10.00.
• Recorded the scripts for performance test, provide test data and load historical data
• Performed end to end cycle on Compensation Workbench (CWB) implementation including configuration, setup plans, run participation process and post process.
• Tested compensation workbench (CWB) for validation, budget preparation, allocations, approvals and notifications. ed different merit plans to the eligible population for testing.
• Provided support to data team for data requirements and mapping rules
• Completed project deliverables and reviewed for quality and accuracy and compliance with established project standards.
• Documented the setups and configuration in the BR100.

Confidential, Parsippany, NJ

Oracle HCM Consultant

Environment: Oracle 11.5.10/R12- HRMS

Responsibilities:

• Conducted interviews to know the current process, and gathered requirements for future business process.
• Performed Fit and Gap analysis, and workaround provided for gaps and approved by the client.
• Assessment on HRMS R12 upgrade. Conducted questionnaire, gathered information for current environment.
• Captured Wyndham customization and process for HR, Compensation Workbench(CWB), Self Service(SSHR) and Oracle Learning management(OLM).
• Played back the information by creating flowcharts and provided R12 features.
• Recommended upgrades in different areas with R12 features.
• Performed the setups and configuration of the applications.
• Designed enrollment requirements for compensation workbench (CWB)
• Run participation process and post process and the close compensation enrollment processes for compensation workbench (CWB)
• Defined compensation workbench standard rate activity types like compensation workbench (CWB) worksheet amount and budget
• Used compensation workbench (CWB) for validation, budget preparation, allocations, approvals and notifications.
• Customized Projects & Payroll Timecard layout to include timecard layout, so that employees can charge time to projects, tasks and work orders.
• Conducted the Unit, Integration and User Acceptance Testing.
• Documented the setups and configuration in the BR100.
• Workaround and extensions to the application was documented in the MD50

Confidential, Cary, NC

Oracle HCM - Application Support/ Business Analyst

Environment: Oracle HRMS 11i(11.5.10) Implementation

Responsibilities:

• Performed configurations and new setups for HRMS 11i including the Flexfields and setup Lookup tables and Lookup codes. Setup new cost centers, jobs, grades and locations and maintained work structures, organizations, Employee and Manager Self service.
• Created custom responsibilities and enhanced oracle responsibilities. Created security hierarchy and attached to the custom responsibility. Defined user and system profiles. Registered programs in AOL. Maintained Security through periodic SOX audits for users and their responsibilities.
• Gathered business requirements, analyzed, and recommended for solutions and documented for the development.
• Participated in the development life cycle through the development of functionality and test scripts, reviews and execution of tests for within HRMS suite application. Setup new functionality OR upgrades and Deployed to the production.
• Prepared adequate technical documentation and ensured proper maintenance and security of the Applications.
• Served as systems administrator including registering the programs in concurrent manager, set up or change configuration, user and their responsibilities. Created user ids and passwords. Maintained and supported HR Alerts.
• Setup the plans and programs for Advance benefits. Assisted open enrollment for OAB and supported for OAB and payroll.
• Developed test cases and executed tests for OAB, Payroll, HR and Manager and Employee Self service(SSHR).
• Supported and maintained core HR, OAB, Payroll, OTL, CWB, Workflow included Manager, Employee Self Service and Notifications. Experienced with Workflow custom setups and configurations.
• Worked closely with managers and end users to deliver the products on time and prepare production support readiness through testing with functional owners and ultimately responsible for closing the tickets and moving to production.
• Worked closely with external vendor(s) and internal users in support of system applications. Supported and maintained systems and vendor interfaces.

Confidential, Raleigh, NC

ERP Programmer Analyst

Environment: Oracle HRMS 11i, Packages and Procedures, Oracle HR/Payroll Reports, Oracle Reports 6i, Pl/SQL

Responsibilities:

• Designed and developed PL/Sql procedures and packages for Oracle HRMS 11i.
• Developed and Customized Oracle HR/Payroll Reports for using Oracle Reports 6i.
• Developed and maintained adhoc reports.
• Coordinated payroll TARs with Metalink to resolve the issues.
• Involved in System Development Life Cycle such as Design, Development, Testing and Implementation.
• Supported Canadian HR and payroll.
• Registered custom interfaces and packages in AOL.

Confidential, Raleigh, NC

Consultant

Environment: UNIX, SQL Queries, Win runner, Load runner, QTP

Responsibilities:

• Involved in IVR System Migration Project to execute Installation Qualifications using UNIX
• Analyzed requirements, created test plans and test cases, assigned test sets, monitored execution and created reports.
• Developed test scripts for regression testing used SQL queries to perform data integrity testing. Developed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, User Interface, Performance, Usability and Security requirements
• Created and executed test cases for unit, functional, performance, User Acceptance Testing, Integration and Regression Testing.
• Involved in performance and stress testing of Web application using LoadRunner. Developed manual and automated test scripts in WinRunner for GUI testing. Used QTP for regression and functional testing for the automation

Confidential, Morrisville, NC

Systems Developer

Environment: Oracle 6i Reports, Oracle Clinicals, Tars (Metalink), iPatches, PL/SQL

Responsibilities:

• Designed and developed several custom Oracle Clinical Reports using Oracle 6i Reports. Developed and Modified PL/SQL packages and procedures. Created and modified SQL views. Analyzed information needs to extract pertinent relevant details and proposed options for resolution.
• Created and executed unit and system tests. Created and executed tests for verification of production release of new code. Assisted with design and maintenance of customized programs.
• Provided programming support for multiple projects such as creation and maintenance of programs used for data entry, data management, data validation. Created, executed and validated data to transfer data across data management systems.
• Researched issues and monitored for published bugs with Oracle resources such as Metalink and coordinated Oracle Clinical Tars with Oracle Tech Support. Worked with Oracle to resolution.
• Coordinated with data base administration over installation and testing of iPatches. Created and executed Operational Qualification and Change Control Checklist Process.
• Knowledgeable in System Development Life Cycle (SDLC) involved in Analysis, Design, Development, Testing and Implementation.
• Validated and maintained Oracle Clinical database. Assisted in designing CRF pages and data validation.
• Maintained and Supported Oracle 4.5 Oracle Clinical/TMS/RDC Applications including trouble shooting for various issues such as Application issues, Programming issues, account setups, password changes, hung sessions, batch validations using UNIX operating system.
• Provided for problem determination and resolution. Interfaced with user community group such as Data Management, Technical Operation and other user groups. Experience in using PDF with Oracle Clinical 4.5 and 4.0.3.
• Knowledgeable in PPD System Development and System validation SOPs and WPDs. Familiar with 21 CRF part 11 federal regulations

Confidential, Raleigh, NC

Oracle HCM Consultant

Environment: Oracle 11i HRMS, Payroll, TARS(Metalink)

Responsibilities:

• Supported Oracle 11i HRMS applications including creating elements, running inquiries and trouble shooting errors. Diagnosed problems and interfaced with MIS.
• Provided system problem resolution. Monitored issues related to software bugs and researched issues with Oracle resources as Metalink, and Oracle Application User Group. Coordinated payroll TARS with Oracle.
• Designed and maintained custom and ad hoc payroll reports using oracle 6i reports.
• Coordinated with database administrators over installation and testing of patches to Oracle software. Created and executed test plans for new code release.

Confidential, Raleigh, NC

Programmer

Environment: Oracle PDS HRMS, HRMS Oracle Reports

Responsibilities:

• Converted legacy data into PDS HRMS using oracle database. Used SQL*Loader to load legacy data to oracle tables. Converted Employees, Applicants, Addresses, Assignments, Salary, Taxes and Benefits to HRMS database.
• Developed HRMS Oracle Reports such as: Active Employees Enrolled in 401(K) Plan, Local, State and Federal Tax Report, Employee Address Mailing Report, Employee Payroll Deduction Report. Created several custom reports using Crystal Reports, Oracle Reports and Oracle Sql*Plus Reports.
• Maintained and supported HR/Payroll system. Created views, synonyms and indexes. Created and revoked grants and roles in Oracles Database for users. Migrated legacy payroll system to Oracle database in PDS HRMS application.

Confidential, Cary, NC

Accounts Payable

Environment: AS400, Accounts Payable

Responsibilities:

• Verified data for Accounts payable documents for accuracy.
• Scheduled and processed invoices for payments using AS/400 system. Worked as liaison between Vendors and Confidential different Department personnel.
• Prepared Monthly Bank reconciliation.
• Prepared Monthly sales tax reports. Prepared and filed quarterly road tax reports and gasoline tax reports using Excel spread sheets.
• Prepared and filed year-end tax reports for 1099 vendors.
• Rolled over and closed account balances at the year end using journal entries.
• Prepared several journal entries for account adjustments