SUMMARY:

• Around 15+ years of vigorous and energetic experience with a successful track record in all extensive HRMS ERP background from requirements gathering, investigation, analysis, estimation, design, configurations, management, development, testing, implementation, customization, upgrades to maintenance and support of business applications in most of the Oracle Fusion HCM Cloud, EBS releases, PeopleSoft, and large complex ERP systems application life cycles.
• Expert in giving introductory, familiarization, training, CRPs, workshops and design validation cycles to the high number of diversified business users.
• Good Expertise and implementation experience on Fusion HCM Offerings: Compensation Management, Workforce Deployment, Workforce Development (Goal Management, Performance Management, Talent Management, Review Management and Succession) Security, FBL, HCM Data Loader (HDL), and HCMExtracts.
• Good leadership and commination skills, on time deliveries, multi - tasking and assisting clients in the selection, implementation planning, fit/gap (As Is - To Be analysis) with alterative solutions for product limitations., Testing (test scripts, validations and POC's) post-implementation support in mass updates, data loading and design changes of Oracle Fusion HCM cloud/SaaS solutions at various customer sites.
• Expert in analysing future and current process modelling, Data Structures, Design Specifications, Application Mapping, Unit, Integration and system testing's.
• Expertise in all major Fusion HCM Offerings: Workforce Deployment (Global/Core HR, Profile, Securities, ESS/MSS, Absence, Payroll, Time and Labour (OTL) and Workforce Development (Talent Review, Performance, Goal and Succession Managements, Taleo, Compensation Management (Oracle Advance Benefits, Incentive, Individual and Mass Workforce Compensation.
• Designed Enterprise level solutions for both Global HR and Payroll along with Fusion HCM, Finance & Order Management architects in the initial designs and one time enterprise level setups including multiple legal entities, business units, reference data set assignments, common application configurations Positions and geography set ups.
• Experience in predefined and complex custom approval hierarchy flows, task configurations and BPM Management. ESS and MSS, Securities (Data, Job and Duty roles, aggregate privileges and permissions) and well versed in the configurations of OIM, OAM, APM and Security Console level setups.
• Excel in interacting with the project team members and responsible for coordination with team in developing reports, interfaces, data conversion programs requiring HRMS integration and conversion from legacy ERP to Fusion with various vendors.
• Worked on Enhancements, Service & Change Requests, Production Supports, Application Extensions and able to lead discussions during business requirement meetings and responsible for generating credible leads via customer presentations, assist in Pre-Sales efforts and project estimations.
• Experience in span business process like understanding and interpreting fast formulas, profile and workforce directory management, approvals and securities, SQL Loader, FBL and SSL, PBL, HCMData Loader (HDL) Full Mode, HCM Extracts, Data Modeling, OTBI, OBIEE/BIP custom and predefined Report and Subject Areas (added hands on experience in ETL Informatica mappings with DAC loads and ODI functionality).
• Technical skill sets including Programming Skills, Application Designer, PS Query, JCL, SQL PL/SQL and PL/SQL Stored Procedures, Functions, Packages, Triggers, FNDLOAD scripts and Expression Builder Functions/Operations.
• Followed Agile/Scrum, AIM and OUM Methodologies and coordinated with offshore and onsite teams for client specified requirements and assignments, involved in day to day requirement sessions with distinguish team leads, business system analysts and business users. Worked with Oracle implementation specialists and Satisfaction Managers on complex decision making scenarios.
• Worked on Eligibility Profiles, Eligibility Criteria, Utilised all six types of Derived Factors for HR, Compensation, Absence, Payroll, OTL, OAB and workforce development modules as per the client requirements.
• Prepared and Worked on Functional and Technical documentations, Business/Mapping rules documentations, SOW, BP 80, 60, 100, BR 100, MD 50, 70, TE 20, 30. RD 11, RD 30, DS 30, MC 030 Configuration Workbooks, Action Item log trackers and all other PPT's/Templates as per Oracle best approaches from inception to production.
• Strong understanding and expertise Oracle Applications Framework(OAF), Applications Development Framework (ADF), Application program interface (API) (Inbound and outbound using API'S and open interfaces for integrating other applications with Oracle Applications), Spreadsheet Data Loader(SDL), Service Oriented Architecture (SOA) and ETL/ELT.

PROFESSIONAL EXPERIENCE:

Sr. Oracle Cloud HCM Lead Consultant

Confidential,Milpitas, CA

• Oracle Fusion HCM Cloud responsible for Implementation Support / Configuration of Oracle Fusion HCM Global Payroll, Absence, Performance Management and Workforce Modeling modules.
• Worked with the business and users to understand the existing Talent management system and translates the requirements to be implemented to the Taleo system.
• Complete understanding of Oracle Apps Implementation in R12 and 11i and Upgrade Projects from 11i to R12. Performed several end-to-end implementations, upgrades as well as conducting conference room pilot (CRP), providing post production support, end user training and documentation.
• Conducted CRP1 sessions to demo the out of box functionality on Oracle EBS Core-HR, Payroll and Performance Management modules.
• Developed HCM Extracts/OBI Reports/OTBI Analytics for Global HR, PeopleSoft Payroll Interface and Fusion Benefits.
• Implemented Core HR-HCM, Performance, profile, Goal, Time and Labor & Benefits module and Taleo Recruit related all the transaction like Transfer, Termination, Promotion etc.
• Gather Core HR (Enterprise), Compensation, Absence business requirements (BRD) and map them to Oracle HCM Cloud functionality.
• Involved in the Integration & support to ADP applications used by client (e-TIME and Payforce) with Oracle (11i and R12).
• Application SME for R12 technical upgrade (from 11i to R12.2.3) and configurations related to Absence Management and Talent Management. Involved in estimating the SOW for Oracle implementations in pulling the history records as per the cut off dates from the legacy.
• Prepared and leaded familiarization sessions for HR and Comp for the large and diversified business users.
• Implementation consultant for Fusion HCM Cloud implementation project in SaaS environment.
• Opportunity to design Security tasks in the Release 12 and secured signoffs for custom roles and setups designs in the security console without APM and OIM interfaces.
• Involved in requirements gathering sessions, design review sessions and initial cycle validation sessions.
• Worked on Enterprise level designs and configurations. Mapped and solved the conversion issues related to the business units, salary basis and workforce structures.
• Implemented department and position structures and positions to GL cost allocation integrations and worked with Payroll leads in KFF's, Enterprise Setups and Positions Synchronizations.
• Involved in design sessions with Auditors, Hyperion budget distribution departments and Compensation Managers to provide alternative solutions to fill the gaps on product limitations.
• Worked on unique individual (Sign on bonus, bonus, shift, overtime off cycle promotions, charity contributions, performance appraisals and individual's ESOPs etc.).
• Implemented best Workforce Compensation foundation, Budgets, Worksheets designs, Model and Reports, Alerts setups. Validation, processing's and distinguish approval scenarios.
• Designed fast formulas to pull the flexfield information to the workforce compensation statements and worked on expression builder setups and dynamic populations and element mapping setups accordable with the requirements.
• Implemented meaningful total compensations statement, Budget - pools, approvals, distributions, publishing's and history tracking's
• Worked on Departments and Positions and Position Tree structures and implementations.
• Worked with Oracle customer satisfaction managers, implementation specialists and Oracle internal teams for complex design solutions.
• Optimized utilization of Oracle support, Enhancement and service request resolutions.
• Resolved convoluted tasks by providing less maintained setups in designing the custom reports by the data based on the EIT's, Profile card interpretations and provided the best alternatives for the product limitations.
• Worked on department wise custom security roles for Employee and Line Manger privileges.
• Involved and Coordinated in conversion issues with the offshore Oracle GSD technical teams in building complex Fast Formulas and data loading activities with SSI connect tool extractions for one time extractions.
• Worked on Taleo, Kronos, Labour Distribution, Risk Management, ADP and other third party integration and flexfield setups with Fusion HCM.

Oracle Fusion HCM Consultant

Confidential,Redwood City, CA

• Driving and documenting business requirements and procedures, obtain sign off to ensure Client alignment of proposed solution.
• Part of business process workshops/CRPs and requirements gathering sessions and support. clients in defining relevant processes. Provided business consulting support and facilitates discovery workshops.
• Coordinate with QA team and ensure the product is bug free and ensure all test cases and scenarios are covered.
• Perform Starter steps like Create Implementation Users; View all data roles, Load/Manage Geographies. Set up and Maintained Enterprise structure and Workforce structures.
• Experience in working both tier and three tier employment models with single and multiple assignments.
• Configured tree hierarchies for the reporting and security purpose and custom workflow routing rules for all Manager Self-services and Employee Self-services.
• Implemented Fusion shared modules Financials (GL/Primary ledger, AP and AR) for payroll configurations. Gaines added knowledge on Finance sales and order management functionality.
• Expert understanding and configuring legal entities, TRU, PSU, Legal employers LDG, Business unit set assignments, job configurations, employment models and distinguish tree setups.
• Worked on allocated checklists for the onboarding asset management and scheduled worker/managerial tasks. Interpreted areas of responsibility tasks in the Cloud HCM.
• Worked on Absence Integrations with Payroll, OTL and Workforce scheduling.
• Created various accrual and qualification absence plans and absence types where employees are restricted so that they can record absence only of a specific duration.
• Configured medical and personal leave categories and pulled the same to the HR and Payroll reporting purposes.
• Proficient in preparing E-Text template & RTF file formats for Absence, Core-HR & Talent management modules.
• Configuring the performance templets and making the changes in to the template in multiple languages.
• Implemented Performance module and integrated annual and quarterly templates for the compensation workbench.
• Worked on profile rating models, review periods, questions and questioner templates also implemented annual performance process flow.
• Got opportunity to work on profile content, Goals, Questionnaire, Overall Summary, Worker and Managerial Final Feedback.
• Implemented end to end performance and goal management and extensively worked on adding and editing the goals, setting the status of goals and deciding the accessibility of goals.
• Worked on Goal Types, review periods, multiple goal plans and plan sets and accurate target outcomes.
• Configured various levels of employee and manager portraits and dashboards. Specialised BI reports for talent management modules and helped in developing HCM Extracts for Global HR, Absence and Talent Management modules.
• Designed custom reporting and interfaces to meet client and audit requirements.
• Supported client in Oracle Cloud UI personalization's and customizations for end users and coordinating with Oracle for SRs, new product releases, upgrades/patches/fixes.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Import candidates (ready to hire) from Taleo Recruiting to Fusion HCM using the Import Oracle Taleo Recruiting Cloud Service Data process and Import export schedule process errors resolutions.
• Streamline Recruiting & On boarding processes with Core HR applications.
• Configure Requisition & Candidate files, Requisition approvals, Candidate Selection Workflows (CSW), Candidate Communication Agent (CCA), Configure Source Tracking, Evaluation Management, Recruiting Centre (welcome centre, Theme& Logo, Communications Channel in Taleo Recruiting.

Oracle HRMS/HCM Functional Consultant

Confidential,Milpitas, CA

• Implementation and support for Oracle core HRMS and SSHR modules and HR and Comp in Fusion.
• Worked on Enterprise Structure one time setups, Geography setups, and Workforce Structures, ESS/MSS, Security and approval tasks.
• Expert in how to use the fields in the Returned Rate Details, Override and Defaulting Rules, and Contributor Rules sections.
• Provided functional support for creating employees, defining salaries, terminate / retire employees, assign grade structure.
• HR related setups in Descriptive Flex Fields, Key Flex Fields, Validation Sets, Lookups and Specific Information Types, Security Profile attachments, users, responsibilities, request sets and menus under the System Administrator responsibility.
• Gather requirements for Oracle Advanced benefits implementation. Meet with users to gather requirements regarding various benefit plans including medical, dental, HAS and CORBA plans.
• Setup programs, plan types, plans for medical, supplemental and COBRA benefits.
• Setup eligibility profiles, enrolment requirements, life events, benefit groups at program, plan and option levels as required.
• Identify the data inconsistencies in Oracle HR including Date Tracking Issues, Payroll data issues, Benefit Life Event Issues and Conversion Issues.
• Involved in team discussion with customer and other functional and technical team members for analysing the impact on the inter module relationship.
• Worked on Eligibility Profiles, Eligibility Criteria, Utilised all six types of Derived Factors for HR, Absence, OAB and workforce development modules as per the client requirements.
• Support and maintain Human Resource Information Systems (HRIS) testing while maximizing the effectiveness of HR business operations. Identify and document test scenarios and build test cases.
• Setup self-service global contractor placement functionality with AME Approval Workflow customization for absence management and IRecruitment functions.
• Setup plan changes as ending the existing no offered plan and migrating the enrolled employees with dependents to newly offered plan and Set-up employee self-service to for updating employee personal data on-line.
• Worked on setting up of Work Structures - Location, Organization, Job, Grade in HR and discoverer reports for Comp and OAB.
• Setup all organizations, locations, elements, element links, costing, job titles, payrolls, bank details, cost centres, worker's compensation codes/rates, Global Values, Application Utility Lookups, Security Profiles and reports within the Oracle HRMS module for all applicable localizations.
• Provided a solution to allow users to enter cost allocation key flex fields thru self-service to synchronize with finance modules for general ledger.
• Configure profile Options, Goal Management Lookups, e-mail notifications and personnel goal plans settings in Oracle Fusion Goal Management.

Confidential

• Worked on employee information and various needs of Reporting. This Project was focused extensively on the customization of HRMS using People Tools and the Reporting Tools.
• Involved in Retrofitting, Modification and Unit Testing of PeopleSoft FSCM and modification and Retrofitting of SQR, Application engine programs.
• Develop and design the PeopleSoft Ver 8.12 Upgrade project map definition and creation and modification of objects according business rules.
• Design and develop the Upgrade templates for PeopleSoft HRMS, for use with the Upgrade Assistant for Confidential & Confidential Control project.
• Review training manuals and proof read the material before signing off the training material.
• Work with change management team and coordinate migration of changes from Development, test and prod environments.
• Involve in functional testing, prepare test scenarios, test cases and test data for regression and functional test cycles.
• Pair-program with developers to enhance current PL/SQL packages to fix production issues, build new functionality and improve processing time through code optimization.
• Customization and implementation of PeopleSoft applications and providing technical guidance to the team.
• Performing Internal Reviews to ensure quality.
• Communicate with clients about the post production support and issues.

Business Analyst / Requirement Analyst

Confidential,Philadelphia, PA

• Managed the administration of Oracle financial applications and related business software
• Lead and/or participated in system implementation, upgrade, and enhancement projects. Worked with end users and application developers to define requirements and deliverables, develop timelines, test results at each stage, train users, and roll out final versions.
• Performed system testing for software and hardware upgrades, database upgrades, etc. Writing test plans and scripts, coordinating testing effort, documenting results, identifying and implementing solutions for all testing issues.
• Oracle 11.0 and 11i System Administration. Security, Profile Options, Responsibility and User setup, Menus, application setups and options, Flexfields, Flexfield security.
• Provided consulting and user support for Oracle 11i applications, including Accounts Payable, General Ledger, Cash Management, Fixed Assets and Human Resources. Performing ad hoc database queries using Oracle Discoverer and SQL Plus.
• Partnered with Oracle Support and in-house Database Administrators to resolve technical issues (TARs), identify program fixes (patches), and implement and test solutions.
• Created routine and non-routine queries, ad-hoc reports, and spreadsheets supporting critical business needs.
• Documented procedures, processes and system features and enhancements.
• Created automated solutions to address business needs, including interfaces, uploads, downloads, FSG reporting, Discoverer reporting.
• Coded, tested, and implemented data interfaces using SQL Loader, SQLPlus and/or PL/SQL.
• Led and participated in numerous Oracle and other application system enhancement projects.
• Upgrade of Oracle applications from version 11.0.3 to version 11.5.8 - Identified all customizations, wrote all Financials test scripts, coordinated and conducted testing of standard and customized functionality, documented testing issues, identified necessary program fixes, re-tested after fixes were implemented.
• Trained end users in new/changed functionality for applications upgrade. Created training materials, coordinated and conducted training sessions for approximately forty users of AP, GL, FA and CE applications. Followed up with user departments to ensure their understanding of key functionality.
• Created a custom solution using SQLPlus and Oracle Discoverer to automate the reconciliation of a complex bank account, saving one week per month of manual reconciliation time.
• Redesigned interest checks using Optio Design Studio and Optio DCS, eliminating the need for pre-printed check stock. Created an interface of interest check detail to Oracle General Ledger, eliminating approximately 8 hours per month of manual entries
• Created several invoice interfaces to Oracle Accounts Payable, eliminating approximately two weeks per month of manual invoice entry.
• Created several bank statement interfaces to Oracle Cash Management, enabling automated bank reconciliation.
• Created several interfaces to General Ledger
• Upgraded Oracle Discoverer from version 3.1 to version 4.1.
• Created numerous Business Areas, custom folders, and queries in Oracle Discoverer Administration and Desktop Edition.
• Upgraded Applications Desktop Integrator (ADI) from version 4 to version 6, and version 6 to version 7.
• Coordinated and performed system testing for database and operating system upgrades; reported results and gave go-ahead when appropriate.
• Participated on HRMS implementation team.
• Managed the data conversion of CoreStates' General Ledger automated reconcilement detail items to First Union's automated reconcilement systems. Assisted in the development of conversion specifications, tested and debugged conversion files.
• Managed various projects involving the design, testing and implementation of system enhancements and interfaces. Managed several Financial/Business Analysts.
• Managed the following departments or functions: General Ledger, Accounts Payable, and Fixed Assets accounting.
• Designed branch general ledger MICR tickets. Delivered presentations to roll out the tickets to branch personnel.

Business Analyst

Confidential,Dallas, TX

• Prepared open & close end questionnaires and conducted interviews with the business end users & SME to gather the requirements; documented BRD.
• Worked with the clients and the technical team in communicating the requirements, designing of the system, and implementing the system by conducting several JAD sessions.
• Communicated effectively with technical team and acted as a liaison between the business unit & the technical team to remove the bottlenecks in the project to ensure accuracy.
• Followed Unified Modeling Language (UML) based approaches in creating Use-cases, class diagrams, object diagrams, activity diagrams, and state diagrams.
• Created data mapping document for extracting, transforming, and loading the data from source data feeds into the target database.
• Assisted data modeling team in creating ER diagrams and performed several SQL queries on the database.
• Reviewed technical specifications to develop test plan, test cases, test scripts and assisted the QA team in performing functional testing, integration testing, performance testing, smoke testing, and regression testing also, managed defect tracking life cycle.
• Created Requirements traceability Matrix (RTM) to follow & audit the requirements and their associations with test cases as well as other project deliverables.
• Supported the users in UAT (User Acceptance Testing) and worked in Production Support team to provide training & support to the end users of the application