Oracle HRMS Functionaltant, New York City

Sandeep Kumar Singh

IT Convergence

New York, NY

Email: **************@*****.***, **************@**********.***

Ph: 718-***-****

Experience Summary

I am an Business Analyst with IT Convergence for with total 4+ years of work experience. My main area of experience has been Implementation and Functional Support of project modules of various sizes in ERP, especially in Human Resources Management System, Payroll and Oracle Advanced Benefits areas. I have worked primarily in the domain of Oracle HRMS, specifically in OAB, Core HRMS, and Payroll. My technological forte is Oracle Apps. Mainly my experience is as a Functional Consultant in Oracle Apps HRMS.

Technology

Below is a list of important hardware, software products, tools and methods that I have worked with.

Hardware Software Products Tools Methods

Intel Series

• Oracle 9i

• Oracle Apps 11i - HRMS

• Unix, MS DOS-6.0

• MS-Access

• C

• C++

• HTML.

• PL/SQL

• Forms 6i

• Reports 6i • PL/SQL Developer

• MS- Visual Source Safe

• TOAD

• SQL Developer

• WS – FTP Tool

• D2K

• Oracle Reports Developer

Qualifications

Degree and Date Institute Major and Specialization

Bachelor of Engineering, (Sep - 2003) National Institute Of Science and Technology, Berhampur, Orissa Electronics and Instrumentation Engg.

Assignments

Project IT Convergence Support Services

Customer PFF Bank, Fitch Ratings, Otsuka Pharmaceuticals and GHX Healthcare

Period November, 2007 – Till Date

Description As a Business Analyst in IT Convergence Support Services, my role is to provide Functional Support in Oracle HRMS, Payroll, Benefits, OLM and OTL to the clients.

Role • Business Analyst for Functional Support

Solution Environment Oracle Apps 11i Windows NT

Tools Toad, Oracle EBS 11i

Highlights Customer Issue can be from any area in HRMS EBS and the turn around time is quite less. So I am always up on my toes.

Project Oracle HRMS Implementation at AXIS Bank

Customer AXIS BANK, India

Period August, 2007 – October , 2007

Description AXIS Bank, one of leading private sector bank in India, having 9000+ employee had requirement to implement Oracle HRMS in India localization to streamline its HR Business processes. The implementation covers over 570 branches of Axis Bank across India.

Role • Functional Consultant for Core HR and Benefits

• To Help in i-Recruitment and OLM set-up.

Solution Environment Oracle Apps 11i Windows NT

Tools PL/SQL Developer, Oracle EBS 11i

Highlights Data mapping is the greatest challenge in this project.

Project Hibernian-Ark Life Oracle Apps Integration

Customer Hibernian, Ireland

Period Mar, 2006 – Jul, 2007

Description • Hibernian, an Aviva Insurance group company made an acquisition over Ark Life. Hibernian’s HRMS system is in Oracle Apps. After the merger, there is a requirement to transfer Ark Life employees into Hibernian system.

Role • Functional Consultant for Payroll, Core HR and Benefits modules.

• Onsite co-ordinator

• Project Lead

Solution Environment Oracle Apps 11i Windows NT

Tools PL/SQL Developer, Oracle EBS 11i

Highlights

Project Proposal for Telenor Oracle HRMS Integration

Customer Telenor, Norway

Period Jan,2006 – Feb, 2006

Description • Telenor had a requirement for integrating their Global HRMS system with many Partner System such as SAP, Benerc, Hyperion etc. I am a part of the offshore team for evaluating various Integration option available, coming out with appropriate comparison and figuring ballpark estimates. My role is to co-ordinate with people from different functional area and finally come up with the deliverable.

Role Offshore Team Member

Solution Environment Oracle Fusion, Java/J2EE

Tools MS Word/Excel

Highlights Have done a lot of R&D on Oracle 10G Middleware Fusion and helped in figuring out ballpark estimates. Also maintained proper coordination amongst people to achieve the very purpose of the assignment.

Project USG Oracle Apps HRMS Implementation.

Customer USG, US

Period Dec, 2005 – Jan,2006

Description • USG has the requirement of Implementing Payroll, OAB, OTL, Core HRMS, iRecruitment of Oracle EBS 11i.

Role • Functional Lead for OAB Module Implementation.

Solution Environment Oracle Apps 11i

Tools PL/SQL Developer, Oracle EBS 11i

Highlights

Project OAB Module (HRMS) Enhancement for Pfizer Inc

Customer Fidelity Investments, US

Period Aug, 2005 – Nov, 2005

Description After OAB Implementation, Pfizer came up with certain amount of enhancements in terms new plans getting added, plan types getting dropped, rates and premium getting changed etc.

Role • Module lead for Rates and Life Events.

• Knowledge Management Prime

Solution Environment Oracle Apps 11i, Unix

Oracle 9I database

Tools Toad, WS FTP Tool, Oracle EBS 11i.

Highlights

Project Business Analysis for General Motors

Customer Fidelity Investments, US

Period Apr -2005 to Aug -2005

Description • Fidelity Investments had already got implemented the OAB module for General Motors. After the implementation, there were certain bottlenecks, which needed to be analyzed and corrected. This was undertaken by our team, 9 at offshore and 1 at onsite. My responsibility was to understand the bottlenecks lying in the implementation due to business complexity and come up with appropriate solution strategy for the same.

Role • Module Lead for Rates and Eligibility

• Knowledge Management Prime

Solution Environment Oracle Apps 11i Windows NT

Tools PL/SQL Developer, Oracle EBS 11i

Highlights

Project OAB Module (HRMS) Implementation for Pfizer Inc.

Customer Fidelity Investments, US

Period Jul-2004 to Apr-2005

Description • Fidelity Investments had the requirement of implementing OAB module for Pfizer, which was to be handled in a shorter time span. Infosys was the anchor of this implementation.

Role Module Lead/ Developer

Solution Environment Oracle Apps 11i Windows NT

Tools PL/SQL Developer, Oracle EBS 11i

Highlights Started this implementation as a Team player, but showed promising growth to be considered as Module Lead only after 3 Months the project had started.

Project Implementation of Oracle Manufacturing and distribution module

Customer Sony Seven and Vaio Enterprise Network, Japan

Period Mar, 2004 to Jul, 2004

Description • Sony Seven and Vaio Enterprise Network, Japan a well known Laptop manufacturing and distributing company had the requirement of migrating their manufacturing system from Legacy to Oracle Applications. Inventory stock setting is a module that has to extract inventory data from Legacy. After certain custom calculation these data have to be feed to Oracle to adjust on-hand inventory in EBS. The module was divided into two parts, one having the requirement of developing a custom form and registering in Apps, the other was a concurrent program which has to be run a scheduled basis.

• Sony had the requirement of transferring legacy system data for past transaction just before the go live phase of the project. Routing Data Conversion focused on transferring past Legacy routing data to Oracle.

Role Developer

Solution Environment Oracle Apps 11i Windows NT

Tools PL/SQL Developer, Oracle EBS 11i

Highlights Without any formal training, on work acquired knowledge for Forms 6i.

Key Competencies & Skills

My Competency Profile includes the following

Skill Proficiency (E0 to E4)

Oracle HRMS 11i E4

PL/SQL programming E3

SQL E3

Reports 6i E1

Oracle Discoverer E3

Career Profile

Dates Organization Employment Type Role

5-Nov-2007 to present IT Convergence, USA Fulltime-Permanent Business Analyst

23-Nov-2005 to 15-Oct-2007 TATA Consultancy Services, Mumbai Fulltime-Permanent Functional Consultant.

15-Dec-2003 to 11-Nov-2005 Infosys Technologies Ltd., Hyderabad. Fulltime-Permanent Module Lead.

Training / Continuing Education Summary

Program or Course Coverage Dates

E&R Generic Training Undergone one and half months of E&R training which comprised of Developing programming skills, Introducing database concepts and Code optimization steps at Infosys, Hyderabad. Dec, 2003 to Jan, 2004

ES University, Specific Training Two months of ES specific training under ES University, Infosys, Hyderabad that comprised of Introduction to Business process and usage of Oracle Applications for Business solutions. Jan 2004 to Mar 2004

Middle level J2EE course at Infosys, Hyderabad Introduction to Java and J2EE 5 Days

Undergone a professional training on Implementation of Peoplesoft EPM Introduction to Peoplesoft EPM. 7 Days

Visa details

H1B Visa valid up to 2010.

Contact this candidate