Project Service

MADHURI BATCHU

E-mail: ***********@*****.***

Mobile: 862-***-****

Summary

* 11 Years of professional experience as a HRIS and business/functional

lead in Oracle EBusiness Suite HRMS - EIS Reporting, Oracle Advanced

Benefits, Core HR, OTL, OLM, Payroll, Self Service HR (Self Service

Benefits), CWB, PTO, Performance Management - Success Factors, KBX

Reporting and Workflows.

* Experience in Project Management. Well versed in all stages of project

management and processes: initiation, control and closure.

* Experienced in resource allocation, project budgeting, cost benefit

analysis, risk management and vendor management.

* Experienced in Project Planning, CMMI5 Process Implementation,

Feasibility Study, writing Project Definition Document (PDD), Software

Requirement Specification (SRS) and Software Requirement Approach

(SRA)

* Well versed with all the stages of the Software Development Life

Cycle: Requirement analysis, Design, Development, Testing and

Deployment.

* Commendable experience in using Oracle APIs, fast formulas and PL/SQL.

* Strong functional experience in handling annual enrolments for

multiple clients, data conversion processes.

* Expertise in transposing the business requirements and user

expectations into detailed specifications employing use cases and

Unified Modelling Language (UML) diagrams using Visio and Rational

Rose.

* Proficient in Rational Unified Process (RUP), Object Oriented

Analysis, Rational Rose, Requisite Pro, Software Development Life

Cycle (SDLC) processes and Methodologies

* Expertise in using tools/ application servers like SQL Plus, SQL

Navigator, Toad and Lotus Notes, tools for version control and defect

tracking.

* Excellent experience in gathering business requirements, ensuring

complete issue resolution, ensuring that the system functionality is

at par with the requirement, writing PL/SQL queries, studying the

functionality of the code (viz. Procedures, Triggers, Cursors with

major Relational Databases MS SQL Server and Oracle).

* .Experience in assisting and testing in various phases like

Functionality Testing, Unit Testing, Integration Testing, System

Testing and User Acceptance Testing.

* Quick learner and a proactive individual with excellent communication,

strong analytical skills, keen problem solving skills and strategic

planning.

* Commendable experience in conducting/ leading business meetings with

respect to the requirements, status, issues and follow-ups

* Have been a part of Best Managed Project Team.

Technical Skill Set

Operating System : Windows NT/XP, Unix.

Languages : SQL, PL-SQL, C++,

Database : Oracle 11i (11.5.10),R12,

DB2, MS Access.

Database Query Tools : Toad, HOBS Query Tool, SQL

Navigator, SQL Plus

Test Management Tools : Test Director, Rational Requisite Pro

Bug Tracking Tools : Lotus Notes

Version Control Tools : MS Visual Source Safe, Lotus Notes, Clear

Case

Analysis Tools : Microsoft Office,

PowerPoint, Visio, MS Project

Education

Bachelors of Electrical and Electronics Engineering V.R.

Siddhartha Engineering College

1999-2003

Certifications

* Enterprise Functions Certification (Enterprise Domain) (Certification

issued by Infosys technologies Ltd for gaining overview knowledge on

Manufacturing, CRM, Financials and HR modules of Oracle Apps. Jan

2006).

* Package 100 (P100) (Certification issued by Infosys technologies Ltd

for gaining Generic overview, Architecture and Technology Overview,

cutting across various Practices and packages. July 2007).

Achievements

* Have achieved the ESTeem Award in recognition of exemplary achievement

and for outstanding contribution to Enterprise Solutions, as a team

member in the Best Managed Project - Sustenance (CSU Project Analysis

Project).

* Received appreciation from Client team for I.B.M Annual Enrollment

2008.

* Successfully handled Annual Open Enrollments for 3years (2006, 2007,

2008) for Fidelity clients viz. IBM, Toyota, Miller.

* Received client appreciation for the successful re-design of Health

Care Savings Account and Flexible Savings Account for the client I.B.M

for AE2007.

Project Experiences

Project: Monster Worldwide, Inc

Project Details

* Client - Monster Worldwide

* Industry - H&W Services

* Module - OAB, Core HR

* Role - Senior HRIS Business Lead

* Duration - July 2014 - Till Date

Project Overview and Scope:

Monster is the number one name in online recruitment. With

close to 6,000 employees in three dozen countries, industry-leading

products and services, a global brand and unparalleled international reach,

Monster is the preeminent destination for career and life management

Responsibility

* Lead the design, implementation and maintenance of internal/external

applications, interfaces, and Open Enrollment 2015.

* Created the Project plan and executed the same for the successful

completion of Open Enrollment.

* Analyzed the design at Monster, recommended solutions to improve the

business processes by using automation techniques.

* Lead cross functional project teams in the development and continuous

improvement of business process re-engineering through technology

and/or process improvements.

* Served as the subject matter expert for all applications used in Human

Resources, Oracle Security, researching and resolving HRIS issues

* Field day-to-day questions and interact with the HR community (HR, IS

and other Business Partners across Monster) in the support of the

Oracle HRMS system and data, as well as other HR applications and

Interfaces.

* Conduct detailed impact analysis on change requests and resolved the

issues with ADP Payroll Integrations and Taleo Integrations.

* Lead the development and maintenance of business analytics and

decision support solutions.

* Worked on the generation of HRIS reports using the KBX reporting tool

as per the management needs.

* Developed user procedures, guidelines and documentation and trained

internal customers on processes/functionality

* Partnered with HRIS team members in bringing the HR applications to

the next level and mentored more junior team members

* Developed and enhanced HR metrics, dashboards, and reports for

distribution to Executive Management

Software

* PL/SQL, Toad, Clear Quest, SharePoint, EIS Reporting Tool, SQL

Navigator, KBX Reporting Tool

Environment: R12.1.3

Project: TJX - HR Oracle

Production Support

Project Details

* Client -The TJX Companies Ltd

* Industry - H&W Services

* Module - EIS Reporting, OAB, Core HR, CWB

* Role - Business Support Lead Analyst

* Duration - Aug 2010 - June 2014

Project Overview and Scope:

The TJX Companies, Inc. is the leading off-price retailer of

apparel and home fashions in the United States. The target customer is

primarily focused on a middle- to upper-middle-income shopper who is

fashion and value conscious and fits the same profile as a department or

specialty store shopper.

The module deals with the configuration of the system for Oracle Advanced

Benefits and the creation of reports for different plans, eligibility,

enrollment requirements and Open enrollment reports.

Responsibility

* EIS Reports:

* Lead for the EIS Reporting module at TJX since August 2010.

* Designed the custom logic for EIS security cursor to restrict access

pertaining to responsibilities specific to different business groups.

* Created custom reports by building new views based on the requirements

and resolved issues/bugs by tweaking the existing views, so that they

meet the business needs.

* Designed 'As Of Date' views to have the output as of a current date

and 'Date Range' views to have the snapshot of the data between

certain time intervals.

* Managed security privileges for each subject area and dashboards

according to user requirements.

* Designed complex mega views integrating the data from Benefits and

Payroll. These views have supported as the base view for a large

number of custom reports.

* Designed reports for various plans like 'TJX 401K., Executive Savings

Plan and other enrollments. This information was essential for

reconciliation of dollars and to provide information to the vendors.

* Created HR, Benefits, Compensation and Payroll reports based on the

user requirements.

* Enhancements of various views to accommodate data in a lookup and

reference the same in the code. This avoids opening the view code for

minor changes.

* Designing of pre-report triggers before the view is referenced and

post-report triggers to clean the tables after the data is populated

on the report.

* Calculation columns based on the report layout helps in tailoring the

data as per the business needs with minimal changes to the code.

* Configuration of parameters on the report, creating conditions and

using mandatory parameters to ensure that performance issues are not

encountered.

* Performed Unit, Integration and Regression testing to validate report

and mapping functionality.

* Created user documentation and assisted the users with testing the

functionality.

* Benefits:

* Performed Requirements Analysis and design for the life-event 'Change

in Payroll' which is the link between the Benefits and Payroll module

(Sarbanes Oxley complaint).

* Designed the system for the Open Enrollment for the 'Program 2'

population of TJX.

* Designed the system for the functioning of Temporal events like 'Age

Changed' which are to be triggered by concurrent programs.

* Resolved the eligibility design issues for executives (management life

plan and imputed income) during the Open Enrollment 2012.

* Analyzed and provided solutions to the Benefits issues in Oracle with

dependent coverage dates for the Health care reform 2011.

* Resolved issues using the collapsing life-event logic when multiple

life-events are fired on the same day.

* Created the design of a quarterly process which updates the Person

extra information field on the number of hours that the associate

works in a week.

* Designed the SSDP/non-SSDP rates set-up for the Worcester associates.

* Tested and resolved the design issues which appear during the

installation ofRUP5 patches and upgrade.

* Designed custom fast formulas for eligibility, electability and rate

structures, person selection rules for union/ non-unions at Open

Enrollment.

* Compensation Workbench:

* Lead the Compensation Workbench meetings for completing and updating

the progress of the 2013 Bonus post mortem issues. Currently, we are

working on the 2014 post-mortem list.

* Assisted in the Performance Appraisals for Stores (Store Common

Review) and Bonuses for 2104. Torubleshooted queries for MIP, LRPIP,

Homegoods and Marmaxx Store Bonus.

* Resolved Self Service related issues which restricted the managers to

perform the appraisal and submit it into the system

* Did the setup for the Fiscal year cut-offs, Sales volume for Stores,

Job Level eligibility, OT hours calculation.

* Troubleshooted FF's for Bonus calculation, packages and functions

which evaluate eligibility and Bonus amounts.

* Core HR, Workflows:

* Lead the HRX business meetings and communicated the progress on the

work / outstanding issues to the business in a timely manner.

* Created AME Workflows for terminations, LOA (with different reasons)

approvals and FYI notifications to the business team.

* Worked on outbound feeds for the Learning Management Systems (LMS) for

Taleo.

* Worked on ESS ethnic origin patches which resolved the issues in the

Review page of MSS.

* Resolved the issues on Salary Page associated with the deployment of

incorrect attribute definition in MSS.

* Configured leave forms associated with LOA approvals in ESS.

* Personalized forms to hide/ make un-editable certain fields like SSN

of spouse (who is a former-associate).

* Personalized the organization email to remove update access in the

hire and rehire workflow globally (across all the BG's).

* Designed the logic for password resets (for sending

notifications/emails to users) in the Production instance.

* Assisted the Kronos team in the TJMaxx realignment of Stores to

Districts using the HR Change Reports.

* Implemented custom fixes to clear stuck workflows associated with the

expired roles.

* Working closely with users/developers and administrators to resolve

the production problems by reviewing design changes.

* Supported and analyzed the various AME issues at TJX.

Software

* PL/SQL, Toad, Lotus Notes, EIS Reporting Tool, SQL Navigator, Service

Center Tool

Environment : R12.1.3

Project: Implementation and Annual Enrollment

for IBM

Project Details

* Client - I.B.M

* Industry - H&W Services

* Module - EIS Reporting, Oracle Advanced Benefits

* Role - Functional Lead

* Duration - Oct 2008 - Apr 2009

Project Overview and Scope:

Fidelity Employer Services Company (FESCo) is a subsidiary of

Fidelity Investments, an international provider of financial services and

investment. Fidelity Employer Services Company (FESCo) has teamed up with

Infosys in order to provide the human resources and benefit services for

the client l.B.M for the retirement, pension, health and welfare, human

resources administration, and payroll programs. I.B.M being a large

organization, frequent acquisitions, and enhancements to various

Eligibility, Rate and Life event setups take place along with the ongoing

production issues. This project deals with OAB setup changes, functional

designs, unit testing for acquisitions/enhancements/production issues

before handling the designs to SQA for system testing.

Responsibility

* EIS Reporting:

* Defined the business requirements for the reports by conducting

meetings with the business team.

* Created the design documents for the reports, leveraged the existing

views so that minimal development effort is required.

* Designed mega views, ensured that conditions existed for performance

improvement, validated data for accuracy and consistency.

* Modified the report layout by addition/ removing of columns to tailor

the business needs.

* Designed various cursors for Job, Job number, Grade and salary to

incorporate the logic into the triggers.

* Assisted the business team with making minor changes to the report

layout and understanding the functionality.

* Created end-user documentation and providing training to the users.

* Benefits:

* Performed Requirements Analysis, Impact analysis and design for Annual

enrollment changes, bug fixes and enhancements.

* Benefits:

* Defined the scope for the implementation of the new Programs, Plans,

Plan Types, Options, Enrollments, Rates, Beneficiaries, and Life

Events in Advanced Benefits.

* Defined High level design documents which were used by developers to

do the programming.

* Configured elements for Medical, Dental, Supplemental Life,

Disability, COBRA plans etc and written formulas according to client

needs. Helped the client to implement new health care plans for the

year 2008. Worked with third party vendors to efficiently send the

extract files

* Performed the GAP analysis in order to bridge the As-Is and To-Be

landscapes at the client end.

* Developed the requirements document for the trigger rules to fire the

life-event associated with a participant of the relevant indicative

data and the evaluation rules for the potential life-event that needs

to be spawned from the associated trigger.

* Developed the specifications document for the changes in the benefit

structure rates by re-design of Rates, VAPROS and retropay.

* Documented the requirement for the Development & Testing of fast

formulas for derived factors - Age, Length Of service, Rate & Coverage

calculation, Evaluate Life Event, Enrollment opportunity, Default

Enrollment, Maximum period of enrollment, Post Election Edit, Partial

month Pro-ration Method, Person selection, communication usage etc.,

Software

* PL/SQL, Lotus Notes, CSW (used in running reports & interfaces),

Query Tool, SQL Navigator

Environment : R12.1.3

.

Project: Bank of America (Client Service Unit)

Project Details

* Client - Bank of America

* Industry - H&W Services

* Module -Oracle Advanced Benefits, OTL

* Role - Functional Lead

* Duration - April 2007 - Oct 2008

Project Overview and Scope:

Bank of America is one of the complex client implementations in

the client service unit. The complexity of the project increases as it

requires client specific knowledge. This project dealt majorly with the

design changes pertaining to the annual enrolment. It involved a lot of

changes in the eligibility, Rates, Carriers, Extract and Ongoing Event

changes for the populations in the Health and Other Benefits System (HOBS)

and adequate changes w.r.t the payroll configuration.

Responsibility

* Prepared Functional Design specification for Data conversion,

customization and various inbound and outbound interfaces.

* Created single client feed (SCF) for loading the data into the system

through the back-end.

* Conducted the Joint Application Requirements Definition (JAR/JAD)

sessions for articulating the issues w.r.t the requirement.

* Transposed the business requirements into functional specifications

supporting the project scope and vision and the project lifecycle best

practices. Additional expected deliverables include environment

requirements, process and workflows.

* Demonstrated the business flow of the design changes in the Conference

Room Pilot (CRP) presentation to the client team.

* Defined the user hook errors using the APIs (Application programming

interfaces).

* Defined the user specific application utilities look-up codes specific

to a requirement that can be called using the fast formulas.

* Prepared the functional specifications document for the complex Time

entry rules for OTL, including the solutions for controlling PTO

accrual maximum amounts during Time card entry.

* Designed the Accrual setup, Timecard setup including Exception layout

and Project and payroll layout, Time Entry Rule design, Time Entry

Preferences Design, Setup of OTL assignment and moving the time from

OTL to Element entries.

* Created Holiday calendar, work plans, rotation work plan, Earning

Group, Time management Policies (Shift Differential, Earning Policy

etc).

* Configured the Time Keeper entry window. Configured time entry

elements for regular hours, overtime, double time, absence, shift

Premium etc.

* Designed the set-up of Earning Policies, Earnings, Hour Deductions,

Shift Differentials.

* Designed the set up of Premium Eligibility, Premium Interactions, Time

Elements and Assignment Time Information.

* Designed the logic and configured the labor cost capture, accruals and

labor cost reporting.

* Configured the time entry rules and time entry validations through the

control of tour of duty functionality, time approvals and time-entry

based workflows.

* Created business flow diagrams using Visio.

* Developed Use Case diagrams, ER Diagrams, and Activity Diagrams.

* Processed Open Enrollment Event for the entire population and provided

production support

* Conducted walkthroughs for the functional specifications with the

business team. Resolving technical and design issues.

* Enhancements/customizations of OAB by re-design of Derived factors,

Rates, VAPROS, Eligibility, and Life Events & Communication Extracts.

* Conducted brain-storming sessions with the team to identify key

issues, using Fish-Bone diagram

* Defined functional test cases and performed user acceptance testing

(UAT)

* Defined the Setup of custom Responsibilities, Menus and functions for

Employee and Managers for Self Service HR, Set Employee Manager

Appraisals for Salaried, Hourly employees.

* Involved in the setup custom Responsibilities, Menus and functions for

Employees and Managers for Self Service HR

Software

* PL/SQL, Lotus Notes, CSW (used in running reports & interfaces), Query

Tool, SQL Navigator

Project: Toyota (H&W Implementation and Configuration)

Project Details

* Client - Toyota

* Industry - H&W Services

* Module -Oracle Advanced Benefits, Payroll

* Role - Functional Lead

* Duration - Nov 2006 - April 2007

Project Overview and Scope:

Implementation in the configuration front was provided for the

client Toyota. The design changes pertaining to the new enhancements and

the changes to the existing configuration were handled as a part of this

project. Bug fixing and the modifications to the code were done to ensure

that the program specifications were in-line with the functional

specifications. Business rules for the Oracle fast formulas were designed

for the Active, Cobra and Retiree program participants for Life Events,

Eligibility, Rates, and System Extracts (e.g.: Carrier Extracts, AP,

Payroll etc.).

Responsibility

* Translated the requirements to program specifications of moderate to

high complexity and designed the MD70 technical specifications.

* Designed various Annual Enrollment Enhancements/changes in OAB viz.

Plan/Option Additions/Drops, Eligibility updates, Rate changes,

Addition of New Life Events, New Enrollment opportunities, applying

defaults, communication generation and Carrier updates.

* Conducted code walkthroughs for resolving technical and design issues.

* Developed Rates and premium extracts out of HOBS.

* Designed the setup for the Life events, Derived Factors and

Eligibility Profiles.

* Responsible for enhancing the system to manipulate the eligible

and electable choices pertaining to a specific program.

* Designed the communication usages specific to a set of population

using the exclusive or logic.

* Designed the default enrollment rules for the target population and

specific rules providing the enrollment opportunity.

* Designed a new Monthly Value Premiums (MVP) process which updates the

premium records 10 times faster than the older version i.e. HOB

Recalculate Premiums.

* Designing the complex trigger rules for the dependents like spouse or

domestic partner/NQDP etc.

* Designed the set- up of Absences Types and PTO Accrual Plans.

* Designed the set-up of employer and employee tax information.

* Defined Payroll Information, Payment Methods and Consolidation

Set.

* Defined earnings and deductions types.

* Defined elements and links to make deductions from payroll and payroll

interfaces.

* Configured the descriptive flex fields for absence details in benefits

self service.

* Payroll, pre-payment, NACHA, deposit advice, check writer processes.

* Created new Fast formulas in Payroll to handle custom Pay basis and

payroll processing.

* Expertise in conversions and generating interfaces, oracle

applications framework as specified by the requirements.

* Worked on the reports, interfaces, conversions and extensions.

* Resolved functional and technical issues that came up in testing.

* Prepared unit test, system test plans and executed them to ensure that

the code developed is at par with the requirement.

* Expertise in debugging the programs using the methods of dry run and

inserting trace statements into the code.

* Mentored other team members with regards to software design, analysis

and development tips and techniques.

* Active participation with internal improvement team initiatives.

Software

* PL/SQL, Lotus Notes, CSW (used in running reports & interfaces), Query

Tool, SQL Navigator

Environment: Oracle Apps 11i

Project: H&W Multi Client Configuration

Project Details

* Client - Fidelity Employer Services Company

* Industry - HR Services

* Module -Oracle Advanced Benefits, OLM

* Role - Functional Consultant

* Duration - Mar 2005 - Nov 2006

Project Overview and Scope:

The project deals with providing the support for multiple

clients. It mainly involves the testing of the system that provides the

required Medical and Life Insurance benefits for the employees dealt across

multiple clients. The set-up of the extract files i.e. carrier, payroll

files etc with the appropriate layouts is validated and issues found

henceforth are raised as incidents. These incidents are raised against the

configuration team and the defects found in the system are fixed by them.

My team owns the responsibility of end to end maintenance of 1

module consisting of 5 different clients. Maintenance activity goes in the

form of a cycle of releases with each release for duration of 3 weeks.

First week goes in analyzing the issues reported by the client and

categorizing them into genuine bug fixes, data issues, enhancements etc. In

the second week we further analyze the issue and identify proper fix or

code change for the issue and then configuring the same in the Oracle Apps

11i system. System testing, UAT (user acceptance testing) and any re-

configuration if any are carried over in third week, and then the code goes

live.

Responsibility

* Designed In-bound Interfaces and Single Client feed files for loading

the data from legacy system

* Performed the testing of life events fired via the various concurrent

processes

* Responsible for providing the business with periodic AP and Payroll

information

* Responsible for testing the HIPAA (Health Insurance Portability and

Accountability Act) & communication extracts, out-bound interfaces

etc.

* Responsible for creating, analyzing, updating Rules (PL-SQL code &

procedures) and Fast Formula's.

* Involved in the set-up of organization security by creating FND_USER

for every employee using the OTA.

* Defined the set-up of the HR User Profile Options in OLM.

* Designed the set-up of user profiles to enable automatic wait listing

in OLM.

* Designed the set-up of price lists and pricing formulas in OLM.

* Designed the set-up of accounting flex-field value sets and segments

in OLM.

* Test execution of the same in order to track the changes implicated in

the configuration

* Designed and executed Unix scripts for the outbound files

* Performed data mining for getting the population/data for the analysis

and testing

* Facilitated knowledge share sessions about the OAB and healthcare

among the team members.

* Estimated the effort for a particular work request including test

planning and test case design in the test director format for the

issues mentioned.

* Performed defect prevention analysis, using Pareto Chart

* Updated client regarding the process by sending status reports and

through mails.

* Implemented all the processes to maintain the project at CMMI5 level

* Followed and implemented RUP methodology in the project

* Responsible for reviewing the work assigned to the team to ensure a

timely deliverable

* Designed project management, configuration management plans in

Microsoft Project

Software

* PL/SQL, Lotus Notes, CSW (used in running reports & interfaces), Query

Tool, SQL Navigator

Environment: Oracle Apps 11i

Project: Miller Implementation & Support

Team

Project Details

* Client -Miller

* Industry - HR Services

* Module -Oracle Advanced Benefits, Core HR

* Role - Functional Consultant

* Duration - Nov 2004 - Mar 2005

Project Overview and Scope:

Annual Enrollment is a fixed price enhancement project done for

each of the internal clients of FESCo on an annual basis. This is carried

out on 3 months period with 5 releases for each of the internal clients.

Annual enrollment is an opportunity given.

* for all the employees to change their health and other benefits

* for the insurance companies for adding/modifying/dropping their provided

benefits and

* For the clients to provide any changes in their HR structure and

reporting.

During this project, the already implemented HR system for the

client Miller is revisited for accommodating any new changes and

enhancements to be done as per the request by the client or insurance

companies

Responsibility

* Analyzed the existing HR structure in order to incorporate the new

enhancements as requested by the client.

* Designed and planned the inclusion of new organizations, locations,

plans, element entries etc.

* Trouble shooting of Fast formulas and Oracle Procedures in Live Events &

Extracts.

* Configuration of Benefits Structure, Eligibility, Rates & Life Events for

Annual Enrollments.

* Assisted in the migration of the changes to production and providing the

post-production support.

* Performed the root cause analysis on different issues pertaining to the

configuration design.

* Designed the program specifications for the conversion, production

support issues and the enhancement requests.

* Prepared the requirements document, Business System Analysis Requirements

(BSAR) document and Business System Design Requirements (BSDR) document.

* Performed cost benefit analysis

* Created, analyzed and upgraded the various interfaces which connect

existing HR system to different other legacy systems for the client like

AR systems, Payables systems etc.

* Maintained project plan, weekly project dash board and presented the same

to Business owners of the project.

* Forecasted and tracked risks, issues and project budget

Software

* PL/SQL, Lotus Notes, CSW (used in running reports & interfaces), Query

Tool, SQL Navigator

Project: Strategic Projects Interactive Implementation Team

Project Details

* Client - Interactive

* Industry - HR Services

* Module -Oracle Advanced Benefits, SSHR

* Role - Functional Consultant

* Duration - Dec 2003 - Nov 2004

Project Overview and Scope:

Strategic Projects Implementation team in involved in creating

strategic tools for enhancing efficiency, accuracy and reducing the costs

involved in the regular maintenance work for the Health and Welfare Benefit

administration for the 46 internal clients administered by our client FESCo

(Fidelity Employers Services Company, US).

The systems of these 46

Contact this candidate