Manager Project

[pic]

Mayuresh Kanade

Contact: 503-***-**** Email:

*****.******@*****.***

SUMMARY:

. Oracle Applications HRMS Functional Consultant/Business Analyst with 6

years of experience in both 11i and R12 versions.

. Experience in analysis, design and implementation of Oracle

Application.

. Experience in working with users for gathering requirements, MAP/GAP

analysis and creating MD050s.

. Good understanding of Oracle Advanced Benefits with benefit programs,

plans, plan types, options, enrollments, enrollment rates etc.

. Specialization in implementing and working in Production support for

Oracle HRMS Applications: Oracle Payroll, Core HR,

iRecruitment/Benefits with a very good exposure to SCM, iExpense.

. Good experience in AME, Oracle Fast formulas, Oracle PL/SQL.

. Import HR and Payroll data from flat files to Oracle HRMS.

. Worked on 401k interface for benefit providers, Annual Basic Life

Insurance interface for Third Party Vendors, ADP, SuccessFactors.

. Experience in defining System Administration activities like

responsibilities, value sets, flexfields, forms, reports, managing

concurrent programs and providing support to APPS end users.

. Well versed with the knowledge of key flexfields, descriptive

flexfields and protected flexfields.

. Very effiecient in building documents. Translate functional

specifications to technical design specifications for development of

Oracle applications 11i extensions, modifications and integrations

including system interfaces, reports, data conversions and custom

extension.

. Sound knowledge of RDBMS which represents Oracle Developer Certified

Associate credential.

. Sound working knowledge on different operating systems like Windows 9x-

XP and UNIX.

. Excellent verbal and written communication skills with leadership

qualities.

. Excellent team player with very good organization skills and result-

oriented.

EDUCATION AND CERTIFICATIONS

. Bachelor's in Electrical Engineering - Mumbai University 1999-2003

. Master of Science in Electrical Engineering- Texas A&M 2005-2006

. OCP (Oracle Certified Professional) - Dallas, TX (May 2006)

TECHNICAL SKILLS

Oracle Applications: Oracle HR, Oracle Payroll, OTL, SSHR, iRecruitment,

OLM, iExpense, Advanced Benefits, AME, Oracle Fast Formula.

Oracle Technologies: Oracle Reports 6i, Oracle Discoverer 9i/4i.

Operating Systems: Microsoft Windows 9x-XP, MS-DOS, UNIX.

Programming Languages: C, C++, SQL, and PL/SQL.

Databases: Oracle 10g/9i, MS Access, SQL Server 2000.

Tools/Packages: SQL* Plus, Toad, FTP, SQL Developer, SQL*Loader, Harvest,

Clarity

RELATED PROJECTS

Project#1

Client: SunPower, San Jose CA Jan 2011

till date

Position: Oracle HR Lead Functional Consultant

Project: Oracle HR, Interfaces-ADP, Successfactors, Smith Barney

Environment: Oracle Applications 12.0.6

Project Description: SunPower is the number one provider of turnkey solar

energy solutions for businesses and government agencies in North America.

SunPower is planning the data center move to a different location so the

whole system needs testing to ensure all the end to end processes work fine

after the move.

Currently, I am working as Oracle HR SME to test SunPower's vanilla

applications including all custom objects such as reports and interfaces

with third party vendors.

As an HR Functional lead for testing:

. Verify all standard HR business processes are running smoothly with

various business scenarios.

. Test HR to ADP Interface

. Test HR to Successfactors Interface

. Test HR to Smith Barney Interface

. Lead the offshore team on a daily basis to create test cases and

execute the test plan.

Project#2

Client: Demand Media, Santa Monica CA

Jun 2010 till Oct 2010

Position: Oracle HR Lead Functional Consultant

Project: Oracle HRMS (HR, SSHR)

Environment: Oracle Applications 12.1.2, PL/SQL.

Project Description: Demand Media (DM) is a privately held online media

company that operates online brands such as eHow, livestrong.com and

Cracked, The company provides social media platforms to existing large

company websites and distributes content bundled with social media tools to

outlets around the web. The company also owns eNom, the world's second-

largest domain registrar.

Worked at DM to implement Manager Self Service module and help the

technical team with HR to ADP web services integration. The project was

mainly around designing custom AME rules for various Manager Actions under

Manager Self Service.

As an HR Functional lead at DM:

. Prepare Test Scripts, train users, update BR100, create MD050s and get

business approval/sign offs for requirements and processes.

. Weekly status meeting with the project team to track issues and

provide solutions to fix them as per priority.

. Set up all the profiles for HR and SSHR such as Security Profile to

restrict employee information by supervisor and also give only HR

access to all employees for Absence Management and Termination.

. Set up DFFs, KFFs, Look ups for salary reasons, leaving reasons etc.

. Setup AME for all the approval processes in SSHR for managers:

- Set up Approver Groups (Based on requirements with custom queries)

- Set up Attributes.

- Create Custom AME Rules for Manager Self Service.

- Create User IDs, Custom Responsibilities and Menus.

- Self Service (SSHR) setup.

- Personalization of OAF Pages for Self-Service.

- Configured and customized SSHR Personalization for Manager Self

Service.

Apart from their headquarters in Santa Monica, DM has different

locations in TX, WA, NY etc. so conducted all the sessions through

WebEx with HR reps and director.

. During all CRP and UAT WebEx sessions with DM HR team,

- Conduct training sessions.

- Prepare test scenarios/scripts and perform them during CRP sessions.

- Conduct regression or shake-out testing.

- Get the sign-off from business for all approval routing processes and

personalizations.

. Bi-directional Interface using Web Services with ADP Payroll:

- DM is implementing Bi-directional Interface from Core Oracle HR

with ADP. This will be a live connection between Oracle and ADP

which will call different ADP Web Services to update information in

both systems.

Managers will perform only assignment and salary actions on their

employees under Manager Self Service, information gets updates in

Core HR upon final approval and then it flows to ADP to keep both

the systems in sync.

- Prepare Business requirements, Map/Gap analysis being the primary

point of contact between DM and ADP.

- Prepare MD050 and work with the developer to help them map the

fields.

- Conduct a weekly conference call with ADP and DM technical for

status update and mapping questions.

- Set up Workers Comp codes in the system for ADP field mapping.

- Set up Assignment Categories in the system for ADP field mapping.

Project#3

Client: ArcSight, Cupertino CA

Aug 2009 till May 2010

Position: Oracle HR Lead Functional Consultant

Project: Oracle HRMS (HR, SSHR, iRecruitment)

Environment: Oracle Applications R12.0.6, PL/SQL.

Project Description: ArcSight (NASDAQ: ARST) is a leading global provider

of security and compliance management solutions that intelligently identify

and mitigate cyber threat and risk for businesses and government agencies.

ArcSight has implemented Oracle R12 On Demand as their ERP application for

their business.

It is a vanilla implementation of Oracle HR and SSHR with a couple of

outbound interfaces to the third party vendors viz. Success Factors and

ADP.

As an HR Functional lead at ArcSight:

. Work with the teams from almost all business areas on different issues

HR being the main integration point. Co-ordinate between HR and

Purchasing/Projects/OTL/iRecruitment/iExpense/OM/Service

Contracts/DBA/Developers.

. Prepare Test Scripts, train users, update BR100, create MD050s and get

business approval/sign offs for requirements and prcoesses.

. Daily tag up with the project team to track issues from the CRP issue

log and provide solutions to fix them as per priority.

. Perform unit testing and log SRs with Oracle On Demand. Weekly call

with Oracle to discuss open SRs.

. Set up all the profiles for HR and SSHR.

. Setup AME for all the approval processes in SSHR and also direct them

to the required supervisors as email notifications.

. Set up salary grade ranges for salaried, hourly employees, assignment

categories, and job titles.

. Manual HR Conversion using HR Web ADI tool.

. Set up OLM with Enrolling employees as students through components

such as Enroll by Department Demands, Enroll Individually, Enroll by

Group, Enroll in Course and Quick enrollment and finally defining

course, course sessions and course cost details.

. During all CRP sessions with ArcSight HR team,

- Conduct training sessions.

- Prepare test scenarios/scripts and perform them during CRP sessions.

- Conduct regression or shake-out testing.

- Get the sign-off from business for all HR functionalities.

. During HR/SSHR implementation in phase 1 as a Business Analyst:

- Manual HR Employee/Ex-Employee Conversion using HR Web ADI. MAP/GAP

Analysis, build CV040 and get the sign off from HR.

- Create User IDs, custom responsibilities, work with recruitment

team for requirement gathering, Map/Gap analysis.

- Self Service (SSHR) setup.

- Personalization of OAF Pages for Self-Service.

- Configured SSHR Personalizations in OAF, customized Self Service

Personal Details screen & different SIT's.

- Gather requirements for iRecruitment implementation and GAP

analysis.

. Set up the whole Multi-Organization structure in HR from accounting

point of view with 4 Operating Units based on Chart of Accounts.

During the Org Structure setup:

- Gather the Org structure mapping from finance; discuss/analyze with

users/SMEs/Finance Manager/HR Manager/GL and Projects Functional Lead.

- Implement the entire Org set-ups with their cost centers.

- Map all the employees to the Orgs and upload all records accordingly.

. Outbound Interface with ADP Payroll Vendor:

- ArcSight has an Inbound Interface with the third party Payroll

vendor ADP for maintaining employees' payroll and benefits

information. This interface is on a semi-monthly basis which

contains demographic and salary information for all the active

employees. Prepare Business requirements, Map/Gap analysis being

the primary point of contact between ArcSight and ADP.

- Prepare MD050 and work with the developer on MD070s, coding.

- Conduct a weekly conference call with ADP and ArcSight Payroll

Admin for status update and action items.

- Set up SUI codes in the system for the file transfer to ADP.

. Outbound Interface with Success Factors (SF):

- At ArcSight, there exists today an online process of maintaining

employees demographic and assignment information.

- The outbound file is sent to SF via FTP. The file is be processed

and is a semi-monthly process.

- Prepare Business requirements, Gap Analysis, MD050.

- As per the gap, created DFFs to hold the required information.

Project#4

Client: NJVC LLC, Vienna VA

Jul 2008 till Jul 2009

Position: Oracle HRMS Lead Functional/Business Analyst

Project: Oracle HRMS (HR, Payroll, SSHR, OTL, Benefits, iRecruitment,

iExpense)

Environment: Oracle Applications 11i, PL/SQL.

Project Description: NJVC, LLC is one of the largest information technology

solutions providers supporting the United States Department of Defense

(DoD). NJVC has implemented Oracle 11i as their ERP application.

After a successful Oracle vanilla implementation in phase 1 for HRMS,

Projects, Payroll and SSHR, Finance, iRecruitment, iExpense and Inventory

were implemented; a key milestone during phase 2.

Responsibilities:

Initially involved in HR/PAYROLL Implementation and go-live cut-over

activities.

- Work with Payroll/OTL team to adjust balances and element entries to

validate the conversion data in Oracle during go-live.

- HR set-ups, gather and freeze the final requirements, fix the

outstanding issues.

But mainly as an HR Functional lead during one year production support:

. Fix various HR issues like incorrect hire/term dates, person types,

assignment records, incorrect reverse terminations, incorrect rehires.

. Work with the teams from almost all business areas on different issues

HR being the main integration point. Co-ordinate between HR and

Subks/Purchasing/Projects/Payroll/OTL/iRecruitment/iExpense/DBAs/Develo

pers.

. Work closely with Subcontractors to fix the bugs in the system and

maintain Subk information such as suppliers, supervisors/TCAs.

. Prepare Test Scripts, train users, update BR100, create MD050s and get

business approval/sign offs.

. Work very closely with the Payroll/OTL functional/technical team, SMEs

and the users to fix various issues regarding balances, accruals, HR

and payroll elements and set ups.

. Daily tag up with the business team and HR/Payroll SMEs to track

issues from the run book and provide solutions to fix them as per

priority.

. During the database upgrade from 9i to 10g,

- Conduct training sessions.

- Conduct UATs, prepare test scenarios/scripts.

- Conduct regression or shake-out testing.

- Get the sign-off from business for all HR functionalities.

. NJVC changed the whole Organization structure to reduce the no. of

cost centers from accounting point of view. During the Org Structure:

- Gather the Org structure mapping from business; discuss/analyze with

users/SMEs/Business Services Director/Finance deputy/HR Sr.

Manager/GL/SCM Functional Lead.

- Implement the entire Org set-ups with their cost centers.

- Map all the employees to the Orgs and work with developer to update

all records programmatically.

- Work with Projects team/SME to set up the correct project and task

owning orgs and fix the issues in Projects transactions for direct and

indirect projects.

. Inbound Interface with Benelogic:

- NJVC has an Inbound Interface with the third party Benefits vendor

Benelogic for maintaining employees' benefits. This interface is on

a bi-weekly basis which contains demographic and Benefits

information for all the active employees. Prepare Business

requirements, Map/Gap analysis being the primary point of contact

between NJVC and Benelogic.

- Prepare MD050 and work with the developer on MD070s, coding.

- Conduct a weekly conference call with Benelogic and NJVC HR for

status update and action items.

. Outbound Interface with Benelogic:

- At NJVC, there exists today an online process of Benefits Selection

for employee data exchange which typically begins with employee's

demographic data to Benelogic (NJVC's benefits management vendor).

This Benelogic outbound census interface was developed in order to

maintain current employee demographic and benefits deduction

information for maintaining employees' information.

- The outbound payroll file is sent by Benelogic via FTP. The file is

be processed by Benelogic. Once the file and data has been

validated, the Benefits Administrator loads the file on Benelogic

database. This is a bi-weekly process.

- Prepare Business requirements, Gap Analysis, MD050.

- As per the gap, created a DFF to hold Benefit class information.

. New Hire State Report:

- Virginia State requires all employers to report newly hired and re-

hired employees to a state directory within 20 days of their hire

date with a specific position based format.

- Gather requirements from HR, prepare Gap analysis and MD050.

- Work with the technical team to develop this custom report as per

the state government requirement and FTP the file to their server

successfully.

. Gather requirements for all HR/Payroll/Subk reports, prepare MD050s

and work with technical team to build the custom reports such as

Complete Employee run, Benefits report, Merit Report, Accrued Leave

Report, OTL Status report, Subk Rate report, New Salary increase

report.

. Fix issues/bugs in the system, day-to-day HRMS data maintenance,

customizations. Fix issues/provide solutions for PO related issues

such as positions, position hierarchy, approval flows, AME/Workflow

errors.

. Set up salary grade ranges for salaried, hourly employees and interns,

assignment categories, job titles.

. During iExpense implementation in phase 2:

- Create a custom Audit hierarchy for paperless audit trail.

- Set up a custom security profile for auditing and run the Security

List Maintenance concurrent program to enable the audit feature on

iExpense Audit Manager Responsibilities.

- Get HR sign off and perform thorough testing.

. During iRecruitment/SSHR implementation in phase 2:

- Create User IDs, custom responsibilities, work with recruitment

team for requirement gathering, Map/Gap analysis.

- HR Set ups for competencies, salary surveys.

- Self Service (SSHR) setup.

- Personalization of OAF Pages for Self-Service

- Fix the issues with self-service pages like issues with creating

appraisals, final process date not available after termination.

- Configured SSHR Personalizations in OAF, customized Self Service

Personal Details screen & different SIT's.

- Creating recruiting site information

- Setting up base URL profile options

- Setting up offers and assesments

- Configure approvals, create and manage vacancies

. Under OTL module:

- Basic set up of Holiday Calendar, Shift, Work Plan, Rotation Plan,

and Earning Groups.

- MD050s, updated BR100. Set up various profile options.

- Discuss and design time entry rules with the payroll team.

- Set up of Self Service based Timecard using OTL module which

included creation of Recurring Time Periods, Approval Periods,

Element Time Information, Time Categories, Time Entry Rules,

Approval Style, Retrieval Rules, Element Set, Preferences

- Daily tag up meetings with the Business to discuss and analyze

different business scenarios.

Project#5

Client: Persistent, Sunnyvale CA

Jan 2008 till Jun 2008

Position: HRMS Lead Functional

Project: HRMS (HR, Payroll, Self Service, Irecruitment)

Environment: Oracle Applications 11i, PL/SQL, UNIX, Reports 6i

Responsibilities:

The role involved implementation of Oracle HR. The functionality involved:

. Creating key flexfields, Business Groups, locations, Organizations,

Organization Hierarchies.

. Defining jobs, grades and positions.

. Setting up of financial and government reporting structures (GREs).

. Managing currencies and exchange rates.

. Worked on Hiring Applicants and Terminating employees and maintaining

Salaries

. Defined person types, assignment statutes, created contracts and

defined collective agreement for People Management in HRMS.

. Worked closely with the development team on an inbound interface to

fetch employee service credit hours, which effects seniority, benefits

and disbursement and store the information in Service Credit SIT using

KFF, APIs, USER HOOKS, PL/SQL and Concurrent Manager.

. Performed data conversion from legacy system in into Oracle Apps

including Employee, Assignment, Address, Contacts data from legacy

system into Oracle HRMS with the technical team.

. Created an inbound interface to create employee records in Oracle HRMS

from V3 system, which handles new employee hiring from county with the

technical team.

. Used Validation Sets, Request Sets and Lookup Types in Oracle HRMS

extensions.

. Developed employee service information reports for external employers

with the help of the technical team.

Project#6

Client: MARTA, Atlanta GA

Jan 2007 to Dec 2007

Position: Oracle HRMS Lead Functional Consultant

Project: Oracle HRMS (HR, Payroll/OTL, SSHR, Benefits, iRecruitment)

Environment: Oracle Applications R12, PL/SQL.

Responsibilities:

I was involved in HR/PAYROLL Implementation project by IBM in MARTA for

401K pension interfaces where I was a part of the functional team. The

functionality involved:

. Worked on 401K pension related Interfaces. Gathered Business

Requirements. Prepared BR, Map/Gap, MD050 and Unit Test Plan documents

to accomplish the implementation. All the interfaces that I worked on

were outbound and FTPd to the third party vendors.

. Configured SSHR Personalizations in OAF, customized Self Service

Personal Details screen & different SIT's.

. Customized the core Self Service HR workflow to implement various

different business requirements.

. Worked with the development team on Procedures, Functions, Key FFs,

DFFs PL/SQL stored packages, Value sets, Concurrent programs.

. Worked on outbound interface for third party vendor, Lynchval for all

the non-representative employees. One of the interface files (Employee

file) is used to send Employee data information to Lynchval which

needs to identify changes in employee information and manage the

employee benefit pension plan appropriately. The other file (Wage

file) is used to send information like the Employee Wages YTD/PTD,

Employer's Contribution YTD/PTD, Sick hours available and pay period

start date/end date to Lynchval to manage the pension plan

appropriately.

. Worked on outbound interface for National Bond and Trust for Savings

Bond. Prepared MD050, MD070 and unit test plan. This interface file is

run to send the person information and deduction amounts of all the

employees enrolled in Savings Bond plan.

. Worked on Outbound Interface for ASI bi-weekly pension union

interface. It generates a Represented pension information data file

which is used by ASI to manage employee benefits plan. Most of the

extract involved HR and Benefits information of an employee. Prepared

Business requirements, Map/Gap, MD050 and MD070.

. Worked constantly with the IBM functional team, testing team and the

users and fixed various issues regarding balances, HR and payroll

elements and set ups.

. Prepare MD050s, business requirement gathering documents, test

scripts:

- Conduct/Co-ordinate training sessions.

- Active participation in UATs, prepare test scenarios.

- Conduct regression or shake-out testing.

- Get the sign-off from business for all HR functionalities.

. Under OTL module:

- Defined Holiday Calendars, Earning Groups, Earning Policy,

Assignment Time information, Configured Time Entry Messages for

OTL.

- Provided support for customizations and conversions to technical

developers.

Project#7

Client: ICICI Mumbai, India

Sep 2003 to May 2005

Position: HRMS Functional Consultant

Project: HRMS

Environment: Oracle Applications 11i, UNIX, Reports 6i

Responsibilities:

. The project involved the implementation of Oracle Applications 11i

that includes implementing HR, Payroll and Time & Labor modules,

creating interface documents according to user and business

requirements and developing several reports using oracle reports 6i

according to the functional specifications provided.

. Worked in the support system, performed the responsibility of system

administration which involved creating users, setting up the user

profile, registering and managing the concurrent programs.

. Configured the application to demonstrate the highly dynamic,

flexible, and extensible functionality offered by Oracle HRMS.

. Analyzed, designed, and configured fully automated processes in Oracle

Human Resources. In addition created and developed the configuration

documentation for the client to leverage in their training. Worked in

creating menus, functions, sub functions, defining responsibilities

and Segregation of Duties.

. Managed the User Acceptance Testing (UAT).

. Worked on Error Handling System in storing all the errors that occur

during interfacing and loading. Also played a main part during the

production support.

. Held regular meetings with implementation team members, client staff

and client technology providers to monitor tasks, update plan

activities and expedite issues until the client's "Go Live" date.

References are available on request

If you like my resume and find it to be a good match for your requirement,

Please do get in touch with me or my Relationship Manager whose details are

given below.

Harish Xenosoft Technologies Inc.,

Email: ******@********.*** Phone: 972-***-**** Fax: 972-***-****

www.xtglobal.com

Contact this candidate