SUMMARY:

• Around 13+ years of experience as an Oracle HRMS Consultant, and Scrum Master Certified
• Have played roles of Functional Consultant, Technical Consultant, Business Analyst and Leading a Team in various projects
• Managed and successfully delivered projects on - time, on budget, complex, medium-sized projects as part of Enterprise Resource Planning (ERP), Implementation, Application Design, Development, Incident Management, Business Continuity Programs with onsite/offshore, time & material and fixed price model as Developer/Designer, Business/Technical Analyst and Project/Application Lead
• Worked extensively in 7+ full life cycle implementations and upgrades; right through Business Analysis, RICEW Components such as Reports, Interfaces, Customization, Enhancements, that includes Application Software Development, Mapping, Data Cleansing, Testing, Documentation, Production Deployment and Production Maintenance/Support
• Worked extensively in Oracle Applications releases R12, 11i; Provided high-level support, troubleshooting, fixing the issues, managed the issue logs, assigned the issues/cases to the project team from fixing the issues through to implementation into Production Environment, as per the agreed SLA and Change Control Management
• Played a significant role in upgradation of Oracle ERP Application from 11.5.2 to 11.5.10, R12.0.3 to R12.1.3 and R12.1.3 to R12.2.6
• Experienced in handling North America Year End and Benefit Open Enrolment
• Outstanding expertise in Application Configuration and Designing, Application Customization, Enhancements and Personalization, CRP, SIT, UAT, Regression Testing, PPR (Parallel Payroll Run)
• Proficient in interacting with End Users to understand the issues and enhancements needed (Gathering Requirements) in various projects. Developed business process models to identify current process and desired processes along with process improvements and costing. Developed User Manuals and Operation Guides where necessary.
• Proficient in managing the project team, liaising with end users, technical resources, functional resources and 3rd Party Suppliers in implementation and support projects. Has proven skills in preparing the Task Lists, Project Plans and Detailed Steps to track the progress of the project.
• Implemented projects by agile methodology
• Proficient in Solution Architecture, Design and development of systems in Oracle as well as integrating several functional systems and providing Post Implementation Support for different projects involving Bug Fixing, Performance Tuning, Enhancements, Code tuning, Version Control of Objects, Migrating/Transfer objects across instances etc.
• Proficient in in resolving Oracle E-business suite seeded bugs by creating Service Requests, follow up and effective analysis in providing an efficient resolution to the bugs
• Proficient in Reviewing Detail Design and Code Reviews, applying Change Control Management to tightly cover any changes in Production and UAT Environments. Change Control Documents prepared with Back-out plans and Risk Analysis.
• Proficient in using Oracle’s Application Implementation Methodology (AIM) to Produce MD050 Functional design, Develop MD070 Technical, Prepared BR100 Application Setup, Prepared TE010 for Testing Requirements/strategy, TE020 for Unit Test Script and TE120 for System Integration Testing documents.
• Strong expertise in Oracle SQL, PL/SQL, Fast formulas, APIs, Triggers, Procedures, Functions, Packages, Forms, Reports, XML Reports, Conversions, Interfaces, SQL*Loader, Data Loader, Unix Shell Scripting, WebADI, Form Personalization, Oracle Applications Framework (OAF), Alerts, AME, Security Profiles, EiS Reports
• Experience in Oracle HCM Fusion implementation

SKILLS:

• Oracle HRMS/HCM Modules - Core HR, Payroll, Compensation, Oracle Advanced Benefits (OAB), Oracle Paid Time Off (PTO), Oracle Time & Labor (OTL), Self Service HR (SSHR), Oracle Training & Administration (OTA), Performance Management System and knowledge in Oracle Financial Modules-Account Payable, Purchasing, Accounts Receivables and General Ledger
• Alerts, Data Migration, APIs, Security Extensions, User Hooks, Interfaces (Inbound & Outbound), Conversions, Form Personalization, Fast Formulas, Oracle Time Entry Rules
• Application Object Library (AOL), Defining custom application, defining messages, profiles, request sets, concurrent programs, value sets, implement/define DFFs, SITs, EITs and auditing
• Oracle Application System Administration skills (creating user responsibilities, managing request groups, menus, function security)
• Oracle WebADI, XML Reports, Oracle Applications Framework (OAF), Oracle Approval Management (AME), Personalization & Customization of SSHR
• XML Publisher defining templates and reports
• ORACLE FUSION HCM - Oracle Fusion HCM Core Implementation, Oracle Fusion Compensation Workbench, Oracle Fusion Payroll, Fast Formulas, Oracle Fusion HCM Data Loader
• Oracle Discoverer
• EiS Reports
• KBACE Reports

TECHNICAL SKILLS:

Database: Oracle 11g/10g/9i/8i/6i

Development Tools: SQL* Plus, PLSQL Developer, Forms, Reports, SQL*Loader, JDeveloper, Applications Utilities (Data pump, SQL loader, Export, Import, FNDLOAD)

Languages: SQL, PL/SQL, Unix, XML, JAVA

Third Party Tools: TOAD, SQL Navigator, SQL Developer, EiS Reports, Data Loader, KBACE Reports, PTC, SmartCVS, HPPPM, Putty, WinSCP

ERP & Web Application Servers: Oracle Apps R12/11i, Oracle 10g, Oracle Fusion

PROFESSIONAL EXPERIENCE:

Confidential, Dover, NJ

Oracle HRMS Analyst

Responsibilities:

• Responsible for design, implement, customize, validation and handling functional setups for HR and Benefit
• Working as a Solutions Architect to design to build Enterprise Application Integrations between cross functional applications and vendors like SAP Fieldglass, ADP, Kronos, etc.
• Architecture enhancements of Affordable Care Act Interfaces
• Designing, building, testing and deploying the technical components required for successful Oracle solutions, especially RICE (Reports, Interfaces, Conversions, and Extensions), Fast Formula, Oracle Applications Framework (OAF) and XML/BI Publisher
• Development, Customization and Enhancement of Inbound and Outbound Integrations (Full file, full with terms, full with changes, changes only)
• HR, Payroll & OAB - APIs and fast Formulas, COBRA enrolments, Child age out, Derived factors, Life events, life event triggers, eligibility profiles and ACA
• SQL, PL / SQL, Forms, Reports, Fast Formulas, triggers, APIs, XML Publisher, Workflow and AME
• Support Payroll processing, process Open Enrollment and perform Payroll and Benefits Year End activities
• Act as liaison between business users, IT, and system vendors to ensure required interfaces are maintained and new projects are implemented as required by the business
• Defines user security profiles and maintains them across all HR systems and ensures managers of users periodically review access and confirms valid user rights
• Develop and deliver requirements specifications, gap analysis, technical designs, and data mapping document and process flows as required
• Develop, document and support testing and implementation of solutions to prioritized issues or enhancements
• Recommend and implement best practice solutions and continuously improve HCM processes and procedures
• Provides support for HRMS including, but not limited to, researching and resolving HRMS problems, unexpected results or process flaws; perform scheduled activities; recommend solutions or alternate methods to meet requirements
• Development and customization of packages, procedures, functions, reports, WebADI and fast formulas as per the business requirements for Oracle HR, Payroll and OAB for US, Canada and Europe
• Participate in defining business, functional and technical requirements and support the business through this process by consulting with stakeholders through the process and using information provided to meet business needs
• Played a significant role in designing, requirements gathering, requirements & gap analysis, development, implementation, test plan preparation
• Identify requirements for business operations and configure system to meet those requirements
• Develop, test and maintain documentation of enhancements/modifications
• Liaison with IT to ensure escalated HRIS issues and concerns are addressed efficiently and all operational systems work properly
• Understand issues and drive root cause analysis and solutions
• Administers/manages technical systems per prescribed procedures
• Provides technical and functional supports regarding all HRIS related projects
• Consults with Business Process Owners, Subject Matter Experts, and Vendors to analyse data and recommend solutions to improve business processes
• Collaborates with HR Operations team and IT for HRMS updates, including analysis of new features, coordination of testing and implementation of update
• Partner with IT to assist in their support of integrations from HRMS to other systems
• Maximize efficiency and consistency by sharing existing reports and training users to modify and run reports as needed
• Demonstrates ability to question and investigate technical experts or vendors for potential solutions
• Good understanding and ability to work on PL/SQL Interfaces, XML Reports Conversions, PL/SQL Extensions, Workflow, Alerts, WEB ADI, Fast Formulas, triggers, APIs, Oracle Applications Framework (OAF) and Forms using Oracle Apps development technologies
• Ensure system/data integrity by performing proactive audits on a regular basis
• Development and Customization of Fast Formulas as per the business requirements
• Demonstration of good Customer focus and relationship management skills along with excellent written & verbal communication skills to work directly with customers in the business and other IT groups as well as offshore support team.
• Support Benefits Open Enrolment and perform Year End activities
• Participate in defining business, functional and technical requirements and support the business through this process by consulting with stakeholders through the process and using information provided to meet business needs
• Played a significant role in designing, requirements gathering, requirements & gap analysis, development, implementation, test plan preparation
• Identify requirements for business operations and configure system to meet those requirements
• Develop, test and maintain documentation of enhancements/modifications
• Understand issues and drive root cause analysis and solutions
• Administers/manages technical systems per prescribed procedures
• Consults with Business Process Owners, Subject Matter Experts, and Vendors to analyse data and recommend solutions to improve business processes
• Collaborates with HR Operations team and IT for HRMS updates, including analysis of new features, coordination of testing and implementation of update
• Demonstrates ability to question and investigate technical experts or vendors for potential solutions
• Demonstration of good Customer focus and relationship management skills along with excellent written & verbal communication skills to work directly with customers in the business and other IT groups as well as offshore support team.
• Enhancements/customizations of OAB by re-design of Derived factors, Rates, Variable Rate Profiles (VAPROS), Eligibility, and Life Events & Communication Extracts.
• Analyzed business requirements to identify business rules and converted them into functional/technical requirement specifications

Confidential, Camp Hill, PA

Sr Oracle HRMS Technical/Functional Analyst/System Analyst

Responsibilities:

• Implemented Oracle HR, Payroll, OAB and OTL for the US and Canada
• Involved in a Global rollout of Oracle HRMS for 32 countries
• Played a significant role in upgradation of R12.0.3 to R12.1.3
• Performing US Benefit Open Enrolment
• Handling US and Canada Payroll Year End Process
• Managing Oracle HRMS Patching activities and working experience with Oracle on SRs
• Development and Customization of Fast Formulas as per the business requirements
• Responsible for design, implement, customize and handling functional setups for HR, Payroll and Benefit
• Customized Oracle Standard forms by using Forms Personalization
• Set up security profiles so that different users have different responsibilities, menu structures and functions
• Implemented Affordable Care Act Interfaces
• Working with the team, DBAs and Oracle on the System Performance as necessary
• Working as a Solutions Architect to design to build Enterprise Application Integrations between cross functional applications and vendors like Kronos, ADP, Ceridian, KBACE, Wells Fargo, MetLife, Kronos, etc.
• Involved in designing, task assign to the team members and co-ordinate with the client for development and customization the RICE components
• Managing in Inbound and Outbound Interfaces & end to end Conversion process
• Development and customization of package, procedure, functions, reports, WebADI and fast formulas as per the business requirements
• Lead the development and implementation of project performance measures, indicators, benchmarks and guidelines to ensure project resources are used appropriately and the achievement of quality assurance standards
• Involved in System Upgrades (RUP8 and RUP9), Application & Process testing
• Discuss and Develop strategy for the Test and Production Environment
• Worked on design, setups and support of Annual Open Enrollments
• Enhancements/customizations of OAB by re-design of Derived factors, Rates, Variable Rate Profiles (VAPROS), Eligibility, and Life Events & Communication Extracts.
• Developed various Benefits fast formulas for default enrollments and electability as part of the Open Enrollment project.
• Handling and Migration of codes to Production throughout the instances
• Post go-live support
• Actively involved in requirements gathering with Key Business and Functional owners, downstream application teams and external service providers
• Analyzed business requirements to identify business rules and converted them into functional/technical requirement specifications
• Actively participated in project planning workshops with project managers, key business users and team members to analyze business requirements and outline the proposed solution
• Conducted Business analysis meetings to define Legacy process and Mapping rules to understand legacy process and define data conversion rules
• Prepared Technical specifications and Mapping documents based on Functional specifications, uploaded into SharePoint for document versioning
• Actively involved in planning and organizing data related activities, including legacy data identification, data mapping, data cleansing, Extract Transform Load processes, data validation, advising on data governance and maintenance processes
• Involved in workshops with functional users, to determine the flat file layouts, data types and naming conventions
• Playing key role in designing and implementing Data Quality, Conversion and Migration solutions
• Developed processes to meet the goal of 100% clean data in an environment of zero tolerance for duplicate records

Confidential

Sr Programmer/System Analyst

Responsibilities:

• Played a significant role in Implementation of Oracle HR, Payroll, OTL and Benefit for the US and Canada
• Worked in upgradation of R12.0.3 to R12.1.3
• Involved in US Benefit Open Enrolment
• Involved in US and Canada Payroll Year End Process
• Worked on HR, Payroll and Benefit Setup
• Handling the system performance tuning
• Worked on Inbound and Outbound Interfaces & end to end Conversion process
• Development and customization of package, procedure, functions, reports, WebADI and fast formulas as per the business requirements
• Customized Oracle Standard forms by using Forms Personalization
• Creating the Value Sets, Look Up Codes, UDT, Menus, Responsibilities & Customization of Fast Formulas, SIT and EIT
• Participated in defining functional and technical requirements and support the business
• Maintain and update functional and technical documentation for the implementation and integration of projects
• Played a significant role in designing, requirements gathering, requirements & gap analysis, development, implementation, test plan preparation, SIT, UAT, co-ordinate with the client
• Handling the development and implementation of project performance measures and the achievement of quality assurance standards
• Involved in System Upgrades (RUP5, RUP6 and Release 12), Application & Process testing
• Discuss and Develop strategy for the Test and Production Environment
• Worked on design, setups and support of Annual Open Enrollments
• Enhancements/customizations of OAB by re-design of Derived factors, Rates, Variable Rate Profiles (VAPROS), Eligibility, and Life Events & Communication Extracts.
• Developed various Benefits fast formulas for default enrollments and electability as part of the Open Enrollment project.

Confidential

Sr Oracle Developer/System Analyst

Responsibilities:

• Worked on Inbound and Outbound Interfaces
• Development and customization of procedure, functions, trigger, forms, reports & interfaces as per the business requirements
• Direct Interaction with client to gathering requirements
• Handling design, implement, customize functional setups for HR and Payroll
• Customized Oracle Standard forms by using Forms Personalization
• Involved in designing, gap analysis, development, implementation, test plan preparation, SIT, regression testing and task assign to team members
• Worked as a Solutions Architect to design and build Enterprise Application Integrations between cross functional applications
• Working with the SAP team on the rollout of the financial system
• Actively involved in requirements gathering with Key Business and Functional owners, downstream application teams and external service providers
• Analyzed business requirements to identify business rules and converted them into functional/technical requirement specifications
• Actively participated in project planning workshops with project managers, key business users and team members to analyze business requirements and outline the proposed solution
• Conducted Business analysis meetings to define Legacy process and Mapping rules to understand legacy process and define data conversion rules
• Prepared Technical specifications and Mapping documents based on Functional specifications, uploaded into SharePoint for document versioning
• Actively involved in planning and organizing data related activities, including legacy data identification, data mapping, data cleansing, Extract Transform Load processes, data validation, advising on data governance and maintenance processes
• Involved in workshops with functional users, to determine the flat file layouts, data types and naming conventions
• Playing key role in designing and implementing Data Quality, Conversion and Migration solutions
• Developed processes to meet the goal of 100% clean data in an environment of zero tolerance for duplicate records

Confidential

Sr System Analyst

Responsibilities:

• Gathering Detailed Requirements and documenting the same
• High Level design for Data Sources, Conversions and Mappings
• Prepares/develop MD070 Technical design based on provide High Level Design document (HLD).
• Prepared BR100 Application Setup, Prepared TE010 for Testing Requirements/strategy, and TE020 for Unit Test Script and TE120 for System Integration Testing documents.
• Prepares/develop MD070 Technical design based on provide High Level Design document (HLD).
• Prepared BR100 Application Setup, Prepared TE010 for Testing Requirements/strategy, and TE020 for Unit Test Script and TE120 for System Integration Testing documents.
• Involved in development and customization the RICE components
• Worked on Inbound and Outbound Interfaces
• Worked on end to end conversion process
• Development and customizations of forms
• Development and customization of package, procedure, functions and reports as per the business requirements
• Customized Oracle Standard forms by using Forms Personalization
• Registration of Concurrent Programs to the Request Groups
• Creating the Value Sets, Look Up Codes & Customization of Fast Formulas, SIT and EIT
• Participate in defining business and technical requirements and support the business through this process by consulting with stakeholders through the process and using information provided in order to meet business needs

Confidential

Responsibilities:

• Analysing of system and preparing technical documents and system requirements
• Direct Interaction with client to gathering requirements
• Development and customization of procedure, functions, trigger, forms and reports as per the business requirements
• Providing fixes to the issues identified in testing phase
• Setup security profiles
• Handling form customization
• Creating the Value Sets, Look Up Codes, UDT, Menus, Responsibilities & Customization of Flex Fields, SIT and EIT
• Provide production support for the deployed project till it is stabilized

Confidential

Oracle Core HR & Payroll Implementation

Responsibilities:

• Involved in development and customization of RICE components
• Worked on Inbound and Outbound Interfaces
• Worked on end to end conversion process
• Development and customizations of forms
• Development and customization of package, procedure, functions and reports as per the business requirements
• Customized Oracle Standard forms by using Forms Personalization
• Development and Customization Fast Formulas as per the business requirements
• Responsible for implement and customize Functional setups for HR and Payroll
• Registration of Concurrent Programs to the Request Groups
• Creating the Value Sets, Look Up Codes & Customization of FF, SIT and EIT
• Maintain and update functional, technical and project documentation as well as maintain a clear and concise documented process for the implementation and integration of projects.
• Direct Interaction with client to gathering requirements
• Participated in CRP, SIT & UAT
• Migration of codes throughout the instances
• Participated in defining business and technical requirements and support the business through this process by consulting with stakeholders through the process and using information provided in order to meet business needs
• Functional and Technical components requirement analysis
• Preparation of functional, technical, setup, SOP documents for custom components
• Provided training to Key and End users on custom components

Confidential

Oracle Apps Technical consultant

Responsibilities:

• Development and customization of package, procedure, functions and reports as per the business requirements
• Development of Conversions and Interfaces
• Registration of Concurrent Programs to the Request Groups
• Creating the Value Sets, Look Up Codes & Customization of Flex Fields
• Worked as a team member in the Implementation team
• Participated in upgradation of 11.5.2 to 11.5.10
• Part of Design engineers group as a subject matter expert on process engineering and change management
• Managed Yearends and Quarterly releases of Oracle HR and Payroll Patches