Summary:

• Over 6 years of development experience in planning, tracking, documenting the projects/programs related to Software Life Cycle on ERP.
• Expertise in Data Base Management System and Development of ERP Applications in HRMS (Oracle EBS 11i and R12).
• Good knowledge inOracle 10g PL/SQL, Oracle 10g Forms/Reports.
• Working knowledge in Dream Weaver 6.0, ERWIN Tool, Oracle Workflow Builder, Oracle Forms 10g, Oracle EBS SOA Suite etc.
• Functional Knowledge inOracle Payroll Module, Oracle Human Resource Management System (HRMS) Tax Computation and Payroll integration with Oracle Time and Labour Management, Oracle Self Service HR and Reimbursement modules.
• Oracle DBA track OCA certified Associate
• Excellent knowledge and experience in Designing/ Developing Data-Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports using Oracle Reports and Crystal Reports 11.x
• Specialization in Payroll Module, Tax Computation and Payroll integration with Leave Management, Time Management and Reimbursement modules.
• Excellent Communication skills with business clients, Development team members across various international locations.
• Involved in onsite-offshore Customer Support and project execution models with team members across various cross-functional teams
• Proficient in defining the requirements, prioritizing the work and making effective decisions.
• Proficient in Microsoft Word, Excel, Power Point, MS Access and MS Project.
• Quick Learner and excellent Team Player with good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.

Technical Skills:

• ERP - Oracle applications 11i, R12 & Active Marshal(Virtual Works)
• ORACLE 9i & 10g, MS-SQL Server 2000
• Oracle Reports, Crystal Report 9.x/11.x
• Oracle Business Intelligence (BI) Publisher and Forms
• SQL Navigator, PL/SQL Developer and Dream weaver.
• Entity Design, Erwin tools

Technical Certificates:

• 1Z0-031 Oracle 9i Database: Fundamentals I.
• Introduction to Oracle9i: SQL.

Training Undergone:

• Oracle 9i and Oracle 9iAS in Confidential, Chennai.

Educational Qualification:

• Bachelor of Engineering in Computer Science.

Project Experience:

Confidential, Lexington, MA Oct 2010 - Apr 2012
Oracle Application Technical Consultant
Environment: Oracle Applications 11.5.10, Oracle HRMS (HR, Payroll, Employee Self Service Manager Self Service) SQL, PL/SQL.

Confidential, is a biopharmaceutical company focused on the research, development, and commercialization of pharmaceutical products that address unmet medical needs in the acute care environment. They are using Oracle HR Application version 11.5.10.2 on 10g database.

Responsibilities:

• Main responsibilities included writing technical specifications, Installation Plans for interfaces and reports.
• Wrote customized fast formula for payroll deduction elements.
• Designed and developed an interface to send over employee demographic information from Oracle HR to 3rd party vendor (success factor) system to keep two systems in synch.
• Worked on interface to send over employee contact information from Oracle HR to Alert find system
• Worked on the modification of some existing interfaces to pull some extra information from Oracle HR Application.
• Made changes to Employee Self service responsibility menu and personalized the web pages of Employee self service responsibility as per business requirement.
• Oracle HR users will create tickets in our support queue as and when they encountered any issues. I worked on these daily tickets to resolve HR related issues.
• I was also responsible for resolving tickets related to oracle HR with the help of IT staff as and when they occur.
• Created and maintained Oracle documents for new and previously developed Reports as and when needed.

Confidential Management System family of applications automates the entire recruit-to-retire process, so you can align your workforce with strategic objectives. A single integrated data model provides an up-to-the-instant accurate view of human resources-related activities, including recruiting, performance management, learning, compensation, benefits, payroll, time management, and real time analytics. Oracle Human Resources Management System is part of the Oracle E-Business Suite, integrating with other E-Business Suite applications, including Financials and Projects.
Payroll localization for North America
Payroll localization team of the Human resources product is responsible for the development of custom payroll functionalities for specific countries according to their legislative rules. These functionalities change frequently as government changes this rules. All these functionalities demands substantial amount of PL/SQL coding and good knowledge in oracle reports and forms. North American localization includes US, Canada and Mexico localizations.

Technical Resolutions for customer issues

Platform : Linux/Unix
Technology : Oracle Applications
Database : Oracle 9i /10g
Report : Oracle Reports.
Team size : 14
Role : Developer

Responsibilities:

• Handled year-end releases for US payroll- Year End Project is released in three phases to customers before tax submissions every year, Responsible for resource and project planning , delivery of release packages on fixed target dates.
• Worked on service tickets raised by customers for various Enhancements / bug fixes involving fast formulas and payroll elements, forms, reports, flex fields, user tables.
• Involved in tracking legislative updates in government sites and incorporating them in the application.
• Setting up assignments, work structures, payroll and elements.
• Building forms and reports and troubleshooting errors in client's server.
• Modification of year-end archiving process and reports.
• Handled critical production bug fixes and legislative enhancements.
• Worked directly with customers on service requests to resolve critical production Issues.
• Payroll run, retro pay, balance adjustments, report generation, legislative enhancements.
• Have created concurrent programs to archive data from live tables and generating report from archived data using XML Publisher (Oracle BI Publisher). Have worked on many HRMS APIs, Interface tables.

Confidential, Chennai. India Nov 2005 - July 2007
Oracle Application Developer
Product
Ramco Human Resource Management System 4.0

Human Resources Management Solution offers comprehensive functionalities across the entire HRMS process spectrum. This product aligns itself to any organization's process through its configurable structure, flexible design and powerful tools.

I have been mainly working in HRMS Payroll module, handling payroll processing and constructing client specific and geography specific payroll rules, arrear processing .

Platform : Windows 2000 / IIS 6.0
Technology : Ramco Virtual Works
Tools : ASP, VB, JavaScript, HTML, Macromedia Dream Weaver, Erwin Tool
Database : Oracle 9i/SQL Server 2000
Report : Crystal Reports 9.0

Project Title/Client :
Implementation of Ramco HRMS/Confidential, Singapore Aug 2006 - July 2007

This implementation includes Ramco payroll, time management and reimbursement. An interface to be developed to interact with People soft employee information and leave management. Existing data to be migrated from Ramco HRMS 3.x to Ramco HRMS 4.x.

Platform : Windows 2003 / IIS 6.0
Technology : Ramco Virtual Works 143.12
Database : Oracle 10g
Report : Crystal Reports 9.0

Team size : 20
Role : Developer / CMI

Responsibilities:

• Payroll and arrear processing SP to be migrated from SQL 2005 to Oracle 10g. Developing client specific Payroll rules (Bonus Computations, statutory specific Computations, Payment of Reimbursement Claims and Tax Deductions etc).
• Performance Tuning of the Payroll Batch.
• Customizing base product and system development/maintenance of new screens in payroll module to achieve customer need.
• Environment set up and server maintenance. Release Management to site

Project Title/Client:
Implementation of Ramco HRMS /Confidential, New Zealand Nov 2005 -Aug 2006

This application is used to capture HR data of all the employees working in Confidential (New Zealand) to facilitate the HR activities with multilevel authorization wherever applicable and required across various components like employee induction, leave, time management and payroll with exit and arrear payroll.

Platform : Windows 2003 / IIS 6.0
Technology : Ramco Virtual Works 143.12
Database : SQL Server 2005
Report : Crystal Reports 11
Team size : 12
Role : Developer / CMI (Release Management)

Responsibilities:

• Gathering, analyzing and documenting Business Requirements, Developing System Requirements for ERP Reports and User Interface screen development.
• Coding payroll rules required for the client. (Statutory specific Computations, Payment of Reimbursement Claims and Tax Deductions etc).
• Performance Tuning of the Payroll Batch.
• Customizing base product and system development/maintenance of new screens in payroll module to achieve customer need.
• Server Set Up and Deployment Process.