EXPERIENCE SUMMARY:

• Total 11+ years of analysis and development experience in Oracle HCM applications using various methodologies
• Experience in Implementation, upgrades, Production support, Acquisition and De - commission projects.
• Played the role of developer, tester, systems analyst and techno-functional consultant.
• Experience with R12 features and functionalities.
• Complete knowledge of the oracle tables and database objects
• Excellent knowledge in generic tools, Oracle Metalink and Service Request Process
• Excellent work allocation and team management skills
• Oracle Certified 11i HRMS Americas - Oracle Implementation Champion.
• Oracle Certified 11i Compensation and Benefits Americas - Oracle Implementation Champion
• Worked in functional area configuring HR/Payroll setups. Worked on many sites for post production issues.
• Analyzed detailed business requirements and mapped future business processes to the Oracle 11i HRMS Suite solution including its integration with the non-Oracle enterprise systems.
• Review and analysis of existing configurations with any potential functionality in the new release/family packs.
• Provided technical support to configure, implement and test the Oracle 11i/Rel12 HRMS Suite of Applications for implementation.
• Strong problem solving skills with attention to detail, reliability, accuracy, and maintainability
• Developing inbound & outbound interfaces. Data Conversion process (Using Oracle APIs)
• Hands on experience using WebAdis.
• Excellent hands on experience in Oracle SQL*Plus, Oracle SQL*Loader, data loader, UTL FILE utilities, Oracle SQL, PL/SQL, Oracle Workflow, Oracle Reports and Forms, Quest TOAD, PLSQL developer and FTP tools
• Excellent working knowledge in HP Quality Center, HP Portfolio management tools. Clearcase, VSS, Kintana, MS Word, MS Excel, Forms 6i

SKILLS SYNOPSIS:

Applications: Oracle HRMS Modules (Core HR, Payroll, SSHR). Oracle Financials (AP,AR,GL,iExpenses) functionality and integration knowledge, Experienced with R12 features and functionalities.

RDBMS: Oracle 8.x,Oracle 9i and 10g.

Languages: SQL, PL/SQL,C

Technical Expertise: Excellent hands on experience with oracle API, Fast Formulas, reports and alerts, Develop Stored Procedures, Packages, and Triggers.

Operating System: UNIX, Sun Solaris, Windows, Sun Enterprise Server, IBM, HP.

PROFESSIONAL EXPERIENCE:

Confidential

Senior IT Support Analyst

Responsibilities:

• Define business requirements and manage them through a standard Software Development Lifecycle.
• Manage the resolution of level 2 problem tickets and change requests.
• Analyze system problems and recommend solutions.
• Lead efforts in the areas of systems integration, implementation, software updates, bug fixes, change requests and application support activities for assigned systems.
• Ensure that system documentation is complete and in accordance with IT and Corporate policy and guidelines.
• Perform & document unit testing of all code, managed in a source code controlled environment.
• Act as an IT Lead mentoring more junior employees and as well as a project team member on strategic company projects.
• Document the functional design leading to the production of exceptionally high quality deliverables, ready for functional testing by Software Quality Assurance, and later Process Validation by representatives of the business.
• Setting up new users, responsibilities, conducting end user trainings, creating Oracle SRs.

Confidential

HCM Consultant

Responsibilities:

• Lead the team, Involve in client discussions in various project initiatives, provide expertise in subject matters.
• Production support of Core HR.
• Configuration and setup of Oracle HCM and other HR system to support business requirements

Confidential

HRIS Techno functional Analyst

Responsibilities:

• Production support of Core HR, self service applications.
• Configuration and setup of Oracle HCM and other HR system to support business requirements
• Standard configuration like setting up elements, defining new payrolls, creating new jobs, new organizations globally
• Develop and implement custom and standard reports to support HR management and staff
• Investigate, propose, and implement process enhancements to improve the collection, retrieval, accessibility, and usage of workforce information
• Develop in depth understanding of portfolio of technologies, tools, and applications that support the HR organization
• Align with HR functional teams to gather and analyze business requirement and propose technology recommendations and solutions. Partner with IT on development, deployment and implementation of solutions
• Provide day to day operational assistance as required to support the HR Operations and HRIS teams
• Participate as needed in various projects and initiatives by providing expertise and assistance
• Conversions, data migrations or data loads using Web ADIs.

Confidential

System Analyst and Development Team lead

Responsibilities:

• Standard payroll configuration like setting up elements, element links.
• Defining new payrolls, creating elements sets, assignment sets, running payrolls, quick pays, balance adjustments.
• Modifying Fast formulas, defining absences elements, absence types, Accruals (PTO and Custom PTO Solutions).
• Running other post payroll process, analyzing the payroll issues and post payroll process issues.
• Design Ongoing IT Support Strategy for production support after go live.
• Majorly working on bug fixes and enhancements. Responsible for development and deployment of the code in oracle application environment.
• Identifying ongoing issues in deployed components, identifying operational issues that may require enhancements or fixes, Performing root cause analysis.
• Acts as the liaison between the Business Team, QA and the Core Configuration groups.
• Performing impact analysis, Proposing resolution and designing the solutions.
• Technical design and documentation of the Interfaces, alerts and reports development and deploy.
• Configuring the data setups required for testing the interfaces that have been developed.
• Testing and reviewing of the Interfaces and reports developed. Defect opening and uploading test cases using QC tool.
• Working with QA teams, resolving issues and performing defect triages.
• Coordinating and guiding offshore team members.

Confidential

Oracle - HR and Payroll Production support

Responsibilities:

• Lead and manage the development team of five people, responsible for their training on core HR and Payroll functional modules.
• Responsible for conducting training in interfaces, reports development and other technical trainings.
• Understanding business requirements and map them to the Oracle Application functionality.
• Referring and reviewing the RD50 business requirement docs, MD.070 technical design documents and preparing TE40 testing documents.
• Define testing scenarios and reviewing test case documents.
• Identify business requirements and map them to the Oracle Application functionality.
• Handling the customer Requirements, Development, Enhancement and Maintenance of the existing applications.
• Planning, preparation and execution of Unit, System and Integration Testing of Performance Management Systems and Talent Planning Systems.
• Basic Salary Elements Configuration, Links, Batch Element Entry (BEE), Grade Rate & Pay Scales, Salary Management.
• Developing and designing Payroll interfaces, calculating PTD, YTD balance values and FTP them into client requested directory.
• Creating out bound interfaces with organization, job and other employee demographic and payroll data.
• Creating technical specifications for the employee data and payroll data.

Confidential

Systems Analyst and Programmer Analyst

Responsibilities:

• Implementation of Oracle core HR and Payroll, integrating with 3rd party applications and Internal application enhancements.
• Defining Business Group and Key Flex field definition, Job Design and Benchmarking, EEO Reporting, Positions, Grades, Grade Steps, People Group, Costing, Assignment setup, Salary Management, Elements, Element links, Fast Formula, Special Information types (SITs), Extra Information types (EITs), Attachments, Absences and Accruals, Fast Formulas, Salary Basis and Payroll, Organization Design, Position Hierarchy, Custom Reports, Dashboard and Repository.
• Configure flex fields, elements, balances, modifying Fast formulas, Data Conversion, etc. during initial implementation process.

Confidential

Systems Analyst and Programmer Analyst

Responsibilities:

• Implementation of core HR/Payroll.
• Implementation included configuring the various earnings, deduction, workers compensation elements required.
• Involved in the implementation of work structures and various flexfields (key and descriptive) set up
• Defined flexfields, Payrolls, Pay basis, Assignment sets
• Running quick pays and balance adjustments.
• Develop scripts using Oracle SQL*Loader and UTL FILE utilities. Database Objects and Alerts, Database development with SQL, PLSQL.
• Develop Stored Procedures, Packages and Triggers. Developing inbound & outbound interfaces.
• Convert client data into current existing system through Data Conversion process (Using Oracle APIs).