Srikanth Chanda Address: ** Carl Ghilani Circle, Ashland, MA 01721

Phone: 508-***-****, 203-***-****

Email: acd3el@r.postjobfree.com

Oracle HRMS/Payroll/OAB/Self- Service Techno Functional Lead Consultant

Profile: Sixteen years of progressive experience in Requirement Analysis,

Design, Development, Implementation, support, and project lead of

business applications using Developer 2000, Discoverer, Business

Objects, OBIEE, BI/XML Publisher, Oracle Forms and Reports, Oracle

workflow, AME, Oracle HRMS, Payroll, Advanced/Standard Benefits, Oracle

Time and Labor, and Self Service Applications. Competently juggle

multiple assignments while maintaining high emphasis on quality.

Strong Functional and Technical understanding of the Oracle HRMS Suite.

Employment History:

EMPLOYER

FROM

TO

Quest Syscon

Sep-1996

Jun-1998

WIPRO SYSTEMS

Jul-1998

Mar-2000

ORACLE CORPORATION

Apr-2000

Jun-2003

GANA TECHNOLOGIES

Jun-2003

Dec-2006

MAARG, INC

Jan-2007

Till Date

Experience: 2/13 - 04/14 Lozier Corporation Omaha,

NE

Oracle HR and OAB Techno Functional Lead

As an Oracle HR and OAB Techno Functional Lead, I'm responsible for

implementing the business requirements already documented by third

party vendor for Oracle Core HR, Employee/Manager Self Service, OAB,

and Self Service Enrollment for OAB.

Implemented Grade Ladders, a custom WEBADI to create a report of

current data and upon changes, upload Salary Changes along with

assignment DFF update, and Performance Reviews. A custom process to

submit the Grade Step Progression Process by employee as of their

promotion date. Within OAB, implemented Age Factors, Eligibility

Profiles, Variable Rates/Coverage, Fast Formulas for around 25 types of

different types including Extra Input, Default Enrollment, Post

Selection, Min/Max Coverage, Formulas for System Extract and others.

Life Events, Collapsing Rules, Enrollment Requirements, Designation

Requirements, Waiting Periods. Document and setup Open Enrollment

changes, Designed and developed processes to interface Oracle HRMS/OAB

with third party vendors using PL/SQL and System Extract. Gather

requirements for Self Service and assist with Security, Workflow

Process modifications, AME approvals and personalizations. Created SQLs

for views to be created as folder in Business Objects for HR reporting.

Customize ADP Views as per business requirements

This is a R12 Oracle HRMS, Emp & Mgr Self Service, Oracle Advanced

Benefits, Business Objects and ADP Connect implementation.

2/14 - 04/14 Extreme Networks Durham, NC

Oracle HR Techno Consultant

As a part-time Oracle HR Technical Consultant, I'm responsible for

re-writing the payroll interfaces (Employee Census and

Earning/Deductions); Third Party files for (ESPP, Commission Plan);

Concurrent Program Reports for users to run; Program to provision User

Accounts and Responsibilities based on Hire, Termination. Convert Job

and Salary History data into Oracle HRMS. Create programs to migrate

people to new Salary bases and update Default Expense account, update

Adjust Service Date, Create Check list events based on Hire and

Termination; Migrate Previous Employer, Education, Commission Plan,

and Stock Grant data into Previous Employer section and element entries

respectively. Create Summary Alert to send out email with list of

errors from User Provision process.

This is a R12 Oracle HRMS implementation.

9/12 - 2/13 Telephonics Farmingdale, NY

Open Enrollment and Year End Specialist

As an Oracle Advanced Benefits Open Enrollment Specialist, I'm

responsible for gathering changes for Open Enrollment, functional setup

changes in OAB, and Payroll; prepare BR.100 for Open Enrollment through

Self Service in R12 along with converting data to be used in OAB for

discounts on rates. In the process, I had to design and develop Fast

Formulas for Oracle Advanced Benefits for Participation and Rate

Eligibility, Post Selection to name a few. I have also developed PL/SQL

functions to be used in the Fast Formulas.

Changes for Open enrollment included tracking discount eligibility on a

Person EIT, New Plan Types, New Plans, rate changes, Inactivating

plans, life event setup, enrollment requirements setups, elections

conversion for few plans (being enrolled and maintained at 3rd party

vendor) and reports of coverage before and after open enrollments.

Create scripts to attach life events. This was used to attach Rate

Change life event to update rates.

As an Oracle Payroll Year End Specialist, I will be responsible for

verifying and adjusting the W2 balance feeds, create ad-hoc reports for

balance values, code to create balance adjustments, Script to retry all

the archive processes till the date of balance adjustments, year-end

balance adjustments in order to be able to print accurate W2 documents

and tax reporting.

Create a Termination Checklist with modifications to Workflow and Forms

Personalization.

This is a R12 Oracle HRMS, Employee Self Service, Payroll, Oracle

Advanced Benefits implementation.

9/11 - 9/12 City of Richmond Richmond, VA

Oracle HR, Payroll, and OAB Techno Functional Consultant

As an Oracle HRMS/Payroll/OAB/SS Techno Functional consultant, was

responsible for requirements gathering, functional setups and prepare

BR.100 for OAB, Payroll, and Self Service in R12 along with converting

the HRMS data, OAB enrollment data and design and develop Oracle

Payroll Balance Adjustments process to migrate the data from Legacy

Payroll system. Take initiative and resolve OTL, AME, Workflow, Self

Service issues; Also designed and developed the benefit interfaces to

and from Delta, Cigna, Virginia Retirement Systems, and AFLAC. Loaded

the balance initializations for payroll balances. Create fast formulas

for Payroll and OAB. Perform changes to Formula Results, Implement Self

Service Personalization, and AME Approvals. Provide production support

for HR Changes, Payroll runs and resolve issues, support OAB with Open

Enrollment with rate changes, plan changes, life event setup,

enrollment setups, and elections conversion for few plans and reporting

coverage before and after open enrollments. Create processes,

accordingly to business needs, to be run between the Time Transfer from

OTL and Processing Payroll within Oracle.

This is a R12 implementation of Oracle HRMS, Employee and Manager Self

Service, Payroll, Oracle Advanced Benefits, and Oracle Time and Labor

with multiple business groups.

3/11 - 8/11 Regeneron Pharmaceuticals Tarrytown, NY

Oracle OAB, OTL Business Analyst, Oracle Techno Functional Self Service

Consultant

Oracle OTL Techno Functional consultant contracted for implementing

Oracle Time and Labor with Paid Time Off in R12. Involved in production

setup; Created fast formulas for Time Entry Rules; Created PL/SQL

functions and wrote fast formulas for time entry rules; Created Alert

to email supervisor when employee exceeds negative 40 hours during

timesheet submission; Created alert to Supervisor to remind of pending

approval; Load PTO adjustments using WEBADI; Change CERIDIAN views to

consider the person type changes when calculating the record change

date; Resolved issues with time transferred from OTL not reflecting in

the accruals;

Gather Requirements for OAB and Self Service HRMS; prepare BR.100; and

setup CRP instance; Performed personalization, created user hooks for

validations; workflow changes and implemented AME Rules for approvals;

Created Test scripts, User Training Guide, and provide training;

Finished implementing Employee, Manager, and Generalist Self-Service HR

in R12.

10/10 - 03/11 Stream Global Wellesley, MA

Oracle HRMS Techno Functional Consultant

Oracle HRMS Techno Functional consultant contracted for implementing

benefit Life events in Oracle Basic Benefits on 11.5.10; Setup AME

Rules for Employee Self Service to define HR or Benefits Team as

approver depending on the Dependent Change Reason; Inbound interfaces

to Oracle from 3rd party Benefits Administrator(Mercer); ANSI-834

extract for Delta Dental. Outbound interfaces to 3rd party Benefits

Administrator and Benefit providers (United Healthcare, Hartford;

Provide production support for multiple legislations while interacting

with teams based in Philippines, and INDIA. Create Materialized views

to improve performance for BI Publisher reports; Resolve Workflow

issues in Employee and Manager Self Service transactions; Workflow

customizations to restrict usages of some of the list of values,

modifications to the workflow processes; Created User hook to perform

some validations on the Dependent screens in Self Service; Provided

production support for Employee and Manager Self-Service for multiple

countries.

02/10 - 07/10 ARIAD Pharmaceuticals, Inc Cambridge, MA

Oracle HRMS Techno Functional Consultant

Oracle HRMS Techno Functional consultant contracted for implementing

Oracle HR in release R12. Gather user requirements; Perform Gap

Analysis; Prepare BR.100 and setup HR with form personalization, custom

People Management Templates; Prepare Test Scripts; Convert HR Data;

Create Alerts; Resolve OTL Self Service personalization issues; Setup

OTL preferences, Projects and Payroll Layout along with Just Projects

layout, Time Entry Rules, Dynamic Approval Selection mechanism fast

formula; Convert Time History to OTL; Setup Absence Management Plans

and process for transferring balances from one plan to another;

Integrate Absences with HR; Setup Discoverer 10g for Oracle HRMS

Reporting; Gather reporting requirements; Develop Discoverer folders

and reports; Prepare User Guide and conduct training sessions; Resolve

issues with PO and Requisition Account Generator Workflow

customizations; Work with Oracle Support for Service Requests.

09/05 - 12/05, 03/06-08/09, 10/09 - 2/10 Mirant Corporation Atlanta,

GA

Oracle Payroll Techno-Functional Consultant

Oracle Payroll Consultant contracted for Payroll production support on

Oracle HR and Payroll release 11.5.10 for Jamaica, ASIA, and US.

Resolve issues in upgrading from 11.5.9 to 11.5.10; Review VERTEX

updates and get users approval to apply them; Modifications to inbound

and outbound interfaces as needed for payroll; Create complex

Discoverer and BI Publisher reports; Implement Custom Employee Paycheck

and Third Party check writer using BI Publisher; Create ad-hoc reports

for Payroll; Setup Deductions for ROTH 401K. Modify fast formulas to

integrate ROTH, 401K and After Tax 401K for limits and ER Match; Modify

fast formulas for United Way deductions; Setup Employer Liability for

NY Metropolitan Commuter Transportation Mobility Tax; Create and/or

modify Periodic and Even alerts; Work with Oracle Support for Service

Requests. Actively involved in gathering objects to be migrated and

assessment for R12 upgrade.

08/09 - 09/09 Regeneron Pharmaceuticals, Inc Tarrytown, NY

Oracle HRMS Techno Functional Lead Consultant

Oracle HRMS Techno Functional Lead consultant contracted for scoping,

and implementing Oracle HR in release R11.5.9. Prepare project plan and

bid for the project. Analyze user requirements; Prepare BR.100 and

setup HR with form personalization, Prepare Test Scripts; Lead the

functional consultants in implementing Core HR. Lead the technical

consultants in converting HR Data; write Fast formulas for compensation

workbench; Prepare User Guide and conduct training sessions; Work with

Oracle Support for Service Requests.

02/06 - 03/06 Merck-Serono Pharmaceuticals Rockland, MA

Oracle Financials Technical Consultant

Oracle Financial Technical consultant contracted for implementing an

interface of the credit card transactions from Gelco to Oracle General

Ledger release R11.5.9. Gather user requirements; Prepare Functional

and Technical Specifications document; Design and Develop interface to

load Summarized or Detail expenses from Gelco to Oracle General Ledger,

a custom form to correct the data errors as needed; Prepare

Implementation, User Guides; Prepare test scripts and conduct training

sessions; Work with Oracle Support for Service Requests.

05/04 - 09/05 Cubist Pharmaceuticals, Inc Lexington, MA

Oracle HRMS Techno Functional Consultant

Oracle HRMS Techno Functional consultant contracted for implementing

Oracle advanced benefits and Self Service enrollment in release

R11.5.9. Setup custom SITs and DFFs; Develop customizations using

Custom Library and User Hooks; Analyze user requirements; Prepare

BR.100 and setup Oracle Advanced Benefits with Standard and Variable

Rates, Coverage Factors, Derived Factors, life Events (Temporal and

Non-Temporal) Fast Formulas for eligibility, rate calculations, Post

Election Rules, open enrollment in Self Service; Develop Extracts for

Medical and Dental providers; Setup personalization and custom

Approvals for Self Service transactions; Prepare Test Scripts; Support

Open Enrollment in Self Service; Define System extracts for Benefits

Providers; Fast formula for compensation workbench; Prepare User Guide

and conduct training sessions; Work with Oracle Support for Service

Requests.

02/04 - 04/04 Steris Corporation Mentor, OH

Oracle HRMS Techno Functional Consultant

Oracle HRMS Techno Functional consultant contracted for implementing

Oracle Self Service in release 5.2; Provide screen shots of Self

Service transactions to gather user requirements; Analyze user

requirements; Prepare BR.100 and setup Employee and Manager Self

Service; Create custom Approvals process in Oracle Workflow Builder for

Employee/Manager Self Service transactions; Setup Personalization for

Self Service Screens; Prepare Test Scripts; Prepare User Guide and

conduct training sessions; Work with Oracle Support for Service

Requests. Resolve issues with Oracle Advanced Benefits in Extracts,

Develop a before and after Report for life events.

09/03 - 01/04 Burlington Coat Factory Burlington, NJ

Oracle HR Techno Functional Lead Consultant

Oracle HR Techno Functional lead consultant contracted for implementing

an interface from Oracle HR to third party Payroll system on Oracle HR

release 11.5.9; Document user requirements; Analyze user

requirements; Setup Oracle HR for gaps; Design Technical and Functional

Specification documents; Develop the interface using PL/SQL and shell

scripting; Prepare Test Scripts; Prepare User Guide and conduct

training sessions.

07/03 - 09/03 Shaw Group Baton Rouge, LA

Oracle Payroll Technical Lead Consultant

Oracle Payroll Technical consultant contracted for implementing a data

extract program from Oracle Payroll release 11.5.8 to J.D Edwards

Payroll; Depending on the requirements, identify the balances to be

extracted for Federal, State, SUI, and SDU Taxable Wages, Taxes

Withheld, Exempt Wages, and Imputed Income for employee; Developed and

interface to extract these balances;

09/02 - 07/03, on Need SWISS RE Armonk, NY

Oracle HRMS Techno Functional Consultant

Oracle HRMS Techno Functional consultant contracted for implementing

Self Service release 4.2 and Oracle Advanced Benefits in Oracle HRMS

release 11.5.8; Gather requirements for Advanced Benefits, and Self

Service; Analyze user requirements; Prepare BR.100 setup guide; Create

custom workflows for approvals and notifications; Setup Oracle Advanced

benefits; Setup Self Service with personalization along with Open

Enrollment; Provide production support for Oracle Self Service, Open

Enrollment and Oracle Advanced Benefits; Setups not limited to Life

Events (Temporal and Non-Temporal), Life Event Collapsing, Standard and

Variable Rates, eligibility factors, System Extracts, Reports with

before and after snapshot of the enrollment. Fast Formulas for

Eligibility, Rates, and election rules; Work with Oracle Support on

issues; Support Oracle HRMS for Latin America, US, Canada, and UK

legislations. Create ad-hoc reporting for Benefits and HR; After Client

started using the third party HR system 5 years after implementing OAB,

Created functional and technical specifications document for an

interface from third party HR system to Oracle HR; Designed and

Developed an interface from third party to Oracle HR; Created folders

in Business Objects with custom views for reporting. Create a custom

form to maintain translations;

06/02 - 09/02 ORACLE Consulting Stamford, CT

Oracle HR Technical Consultant

As an employee of Oracle Corporation, I was assigned to implement

Appraisals module for Oracle Consulting using Self Service release 3 in

Oracle HRMS release 11.5.x; Gather requirements for personalization in

Self Service, reporting, and interfaces; Prepare Br.100 setup guide for

the personalization; Create functional and technical specification

documents for reports and interfaces; Designed and developed numerous

reports and an interface to extract the competence ratings and upload

to Oracle HR as a performance rating;

04/02 - 05/02 Liberty Mutual Dover, NH

Oracle HRMS and Financial Consultant

Oracle HRMS Techno Functional Consultant contracted for implementing

extensions to existing Oracle HRMS and Financials modules; Solution to

load and maintain value sets programmatically; designed and developed

solution to update Employee's approval authority using Custom Library;

Create/Maintain User Accounts with Liberty Mutual's default

responsibilities; Configure Oracle Workflow Notification Mailer;

Establish links to intranet sites on Oracle Self Service pages; Create

an inbound interface to load the credit card membership details from

bank, and credit card transactions; Created Oracle Alerts as per

requirements; Designed and developed inbound interfaces to update

approval authority on the job definitions; Inbound interface to load

payments information from legacy system to Payables; Outbound interface

to extract the invoice info from payables to Legacy system; Interface

to load training information from the expense reports;

02/02 - 03/02 Master Protection (Simplex Grinnell)

Fort Myers, FL

Oracle Payroll Technical Consultant

Oracle Payroll technical consultant contracted to extract the payroll

data (Earnings, Deductions, Taxes, Liabilities) into flat files and

create custom reports (401K Non-discrimination, a report to show the

calculated ER match); Load tax balance adjustments to generate a

correct state quarterly wages report.

01/02 - 01/02 American Tower Corporation

Marlborough, MA

Oracle HRMS Technical Consultant

Oracle HRMS technical consultant contracted to extract the life

insurance data to show the total cost by insurance type, age group, and

roll the costs up to each division.

01/02 - 01/02 ABT Associates, Inc Cambridge, MA

Oracle HRMS Technical Consultant

Oracle HRMS technical consultant contracted to convert HR data in

release 11i and develop custom reports in Discoverer.

07/01 - 01/02 Sepracor, Inc Cambridge, MA

Oracle HRMS Technical Lead Consultant

Oracle HRMS technical lead consultant contracted to lead the team for

converting HR, and Oracle Advanced benefits data in release 11i,

perform extensions using custom library, and develop custom reports in

Discoverer. Analyze user requirements; Prepare technical specifications

document; Design, develop and Lead the technical consultants in

converting HR, and OAB Data; Create Fast formula for rate and coverage

calculations in benefits; Help functional team to resolve issues within

OAB setup; Work with Oracle Support for Service Requests

06/01 - 06/01 Select Appointments Reading, MA

Oracle Payroll Technical Consultant

Oracle Payroll technical consultant contracted to improve performance

on custom payroll reports and modify custom payroll reports in release

11.0.3

04/01 - 06/01 Mercury Computer Systems Chelmsford,

MA

Oracle HRMS Techno Functional Consultant

Oracle HRMS techno functional consultant contracted to implement

Appraisals, Employee and Manager Self Service in Oracle On Demand

environment with release 3.x; Gather user requirements; Prepare BR.100

document; setup Employee and Manager Self Service with custom Workflow

Approvals, Notifications; Loaded custom tips, and replaced oracle

images with custom ones; Work with Oracle Self Service Development team

in product enhancement for the appraisals module; Implemented custom

questionnaires using HTML and setup Appraisals module;

03/00 - 02/01 CMGI Andover, MA

Oracle HRMS Technical Consultant

Oracle HRMS technical consultant contracted to implement extensions in

Oracle HRMS, reporting using Discoverer, and setup Benefits Enrollment

in release 11.0.3. Created a custom tool using Mod PL/SQL for employees

to be able to enroll in benefits similar to what is now Oracle Advanced

Benefits. Integrated this module with Oracle Applications as part of

the Employee Self Service; Extend Dependents pages to facilitate some

custom fields from the person DFF. Created custom reports using

Discoverer; Designed and developed extensions using Custom Library and

User Hooks;

06/98 - 03/00 General Electric Fairfield, CT

Oracle HRMS Technical Lead Consultant

Oracle HRMS technical lead consultant contracted to manage

implementation of a custom Compensation planning module and integrate

with Oracle HRMS; Lead an off-shore team in developing the Compensation

Planning module; Designed and developed an outbound extract to

interface data from Oracle HR to the new compensation planning module;

Designed and developed an inbound interface to get the planned data

into Oracle HR; Develop new Alerts; Develop conversion scripts and

extensions with user hooks for Oracle supplied APIs, and CUSTOM

Library; Provide production support for multiple business groups in

multiple legislations across the world. Work with Oracle Support and

Development in resolving issues;

Education and Bachelor of Engineering from National Institute of Technology,

Training: WARANGAL, INDIA 1994

Continuing Professional Development:

11.0.3 Oracle HRMS Implement Oracle HR and Payroll (US), Oracle

Corporation

4.x Oracle Applications (OA) Framework Technology for Developers,

Oracle Corporation

JAVA Programming (JSP, Servlets, RMI, JDK 1.1, Java Server, and Apache

Server), Oracle Corporation

Oracle Advanced Benefits Technical Foundation and Conversion, Oracle

Corporation

Developing Web Based Applications Using PL/SQL Cartridge, Oracle

Corporation

Oracle Financial Applications 10.6 SC and 10.7, Wipro

Oracle 7.x database SQL, PL/SQL, Developer 2000

Technical: Applications: Oracle HRMS 10.6/10.7/11.0.3/11.5.3/11i/R12

Tools: Oracle Developer/2000 6i/11g, PL/SQL, SQL*Plus,

SQL*Developer, PVCS, HTML 4.0, Mod PL/SQL (PL/SQL

Cartridge), Discoverer 3.x/4.x/11g, MS Office, MS

PowerPoint, Workflow Builder

Operating UNIX, Windows 9x/NT/2000/XP/7

Systems:

Databases: Oracle 7.x, 8.x, 9i, 10g, 11g. MS Access

Contact this candidate