SUMMARY

• Having 8+ years of IT experience in Implementation, Upgradation and Support of Oracle 11i/R12 EBS Applications and Oracle Fusion Middleware and Java/J2EE Environment
• Expert in Oracle Applications 11i Implementation and Support. Good exposure in R12 upgrades.
• Has Techno - Functional experience in Oracle Apps Core HR, SSHR, OAB, OTL, Payroll, PMS, AME modules.
• Expertise on HRMS API’s like Employee, Assignment, Address, EIT, Termination, Phone API’s
• Good work experience on OA Framework for customizing Self Service Pages
• Authored Functional Specification document (MD50), Technical Specification Document (MD70), Installation Document (MD120), Conversion Document (CV60) as per AIM guidelines.
• Extensive experience with Inbound and Outbound Interfaces on HRMS.
• Resolved several issues in a short time during CRP, UAT and Support period
• Worked closely with several vendors like ADP, First Advantage, Pro-Inbound etc
• Extensively worked on XMLP /BI Publisher reports and Forms personalization.
• Worked on developing Technical Design for custom reports, interfaces and conversion
• Experience in customizing and personalizing approvals using Oracle Approval Management (AME)
• Experience in web application development using different Frameworks like Spring MVC and Struts.
• Developed System Extracts to Export data from Oracle Advanced Benefits to Third party vendors
• Strong hands on experience on Oracle SQL, PLSQL, OAF and Java Programming
• Worked with Business users to understand the requirements and document the technical needs
• Good Hands on Experience in ADF Development (ADF BC,ADF Rich Faces, View Criteria’s, Task Flows, ADF
• Security and Deployment ) and Oracle JDeveloper.
• Experience in client side Technologies such as HTML, DHTML, CSS, JavaScript, and JQuery.
• Proficient in using RDBMS concepts with Oracle 9i/10g and MySQL Databases.
• Good experience with OUM Implementation methodology and documentation
• Worked with DBA’s for applying patches and code migrations.

TECHNICAL SKILLS

ERP Applications: Oracle applications 11i, R12 HR, Payroll, SSHR, OTL, OAB, PMS, GL, AR, AP, INV

Databases: Oracle 11i, MySQL

Reporting Tools: Oracle Reports 6i, 10g, XMLP /BI Reports and Discover Reports

Tools: SQL Loader, SQL Plus, Winscp, Toad and FTP

Programming Languages: JAVA/J2EE, SQL, PL/SQL, HTML and XML

Frameworks: Spring, Hibernate, Struts, ADF, OAF

IDE: Eclipse, JDeveloper

AIM Documentation: MD120, MD070 and MD050

Operating Systems: Windows 7/XP

Office Software: MS Word, MS Excel and MS PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Techno-Functional Consultant

Environment: Oracle Apps R12 Support

Responsibilities:

• Worked closely with business users to understand the requirements and document the requirements.
• Designed and developed several HRMS Interfaces.
• Worked on outbound interfaces to First Advantage and XEROX Vendors.
• Worked on the Data migration activities of Core HR/Payroll through conversion scripts(like personal, assignment, job, position, grade, qualifications, phones, SIT's, initial balance, bank details, element entry, pay proposals etc)
• Worked on XML / BI publisher reports like Overtime, Higher skills in HR/Payroll.
• Worked on timecard details report for Oracle Time and Labor.
• Worked on Workflow customizations for Self Service HR and PO Approvals.
• Worked on OAB API’s Like Process Life Events, Enrolment of Plans, and Processing of Enrolments.
• Fixed issues in existing interfaces from Oracle HR to Third Party Vendors
• Coordinated with vendors like First Advantage and Fidelity.
• Worked on migration of code, documents from instance to instance.
• Designed solution for new customizations.
• Worked closely with DBA’s to address performance issues.
• Worked on fixing the issues in existing reports.
• Coordinated with Oracle Support on various SRs.
• Worked on Leave Accrual Balances report with XML Publisher and Bursting features to Email Managers.
• Worked closely with the DBA’s for code migration.

Confidential, MA

Oracle Technical Consultant

Environment: Oracle Apps R12 Upgrade & Support & Production Support.

Responsibilities:

• Worked on upgrade and support of Oracle HRMS, SSHR, PMS modules.
• Configured HRMS, SSHR, Payroll, MSS, PMS Modules, SSHR and MSS Personalization.
• Developed New HR Reports as per the business requirement.
• Worked on the configuration of Several new elements, links and Balances.
• Set up and customized Performance Management Templates for Appraisals.
• Worked on different phases like UAT, deployment on production etc .
• Extensively worked on production Support level.
• Developed outbound interfaces to extract the data from base tables to Flat files.
• Creation of value sets in various modules of the application.
• Worked on Retro Pay, Payroll, Prepayments, Check Writer Processes.
• Worked on Forms Personalization.
• Worked on AME to set up AP invoices Approval Transactions.
• Created several new elements, fast formula and formula results for Payroll.
• Helped users resolve issues during New Hires and Assignment changes.
• Modified OA Framework(OAF) Pages to display Total Score to Managers.
• Worked on Employee, Address, Phone, Assignment data conversions using HRMS API’s.
• Worked on OA Framework (OAF) personalization to hide Rating levels from Employees.
• Worked on CO Extension (OAF)for restriction of adding Objectives in Employee Self Service Performance Management.
• Worked on OA Framework (OAF) CO Extension for showing Total Quantity of receipts or Amount in iprocurement.
• Worked on creating Descriptive Flex fields, EIT’s and Special Information Types.
• Prepared the code packs to migrate deliverables from one instance to another instance.
• Fixed the errors for multiple reports in several instances.
• Created New Objectives Template to hide inactive Objectives for Employees; New Competencies template to restrict selective competencies.
• Worked on AME (Approval Management Engine) to set up Approval for SSHR Transactions
• Fixed the errors for multiple reports in several instances.
• Developed an OTL report to identify missing time cards and approve them using a custom program.
• Set up New Elements, Element Links, Formula Results.
• Worked on AIM Documentation like MD50,MD70, MD120.
• Created several fast formulas for HRMS Modules.
• Worked on HRMS Reports and Customizations.

Confidential, Atlanta

Technical Consultant

Environment: Oracle Apps R12.

Responsibilities:

• Developed XMLP reports as per the business requirement .
• Developed several Outbound interfaces from Oracle EBS to Third party vendors.
• Mapping functional specifications to technical for customizing existing reports.
• Developed several SQL*loader scripts to upload the data in to database.
• Creation of Values Sets as per the requirement in the Application.
• Worked on Inbound Interfaces from vendors to Oracle HR.
• Development and customization of reports, interfaces and conversions.
• Worked on OTL Time Entry Rules and Payroll Fast Formulas.
• Worked on OTL Timecard Layout Customizations.
• Worked on OTL Inbound Interface.
• Created an Alert to notify the HR Department of the start date for an employee.
• Created New Elements, Fast Formula, Element Links, Formula Results.
• Developed pl/sql packages, procedures and triggers.
• Worked closely with the DBA team for code migrations.

Confidential

Technical Consultant

Environment: Oracle Apps R12

Responsibilities:

• Converting the client requirements into deliverables. Development and customization of reports.
• Developed Payable open interface to import flat file data into base tables.
• Worked on several Inbound and Outbound interfaces for Oracle HRMS modules.
• Developed Purchasing interface program.
• Created reports to identify the Employee Turnover during a period of time.
• Worked closely with the Business Users to understand the requirements.
• Involved in the development of SQL*loader scripts.
• Development and customization of reports, interfaces and conversions.
• Creation of Values Sets in the Application.
• Developed pl/sql packages, procedures and triggers.
• Developed various reports in HR, OM, PO modules.
• Good Exposure in Preparations of AIM and PMM documents like MD200’s.
• Creation of values sets in various modules of the application.
• Worked with DBA’s for code migrations and patches.

Confidential

Technical Consultant

Environment: Oracle Apps R12

Responsibilities:

• Converting the client requirements into deliverables. Development and customization of reports.
• Developed AR Invoice import program for importing invoices into base tables.
• Updated existing interface for New Hires to fix the issues.
• Created a new interface for importing Miscellaneous Reports.
• Worked with DBA’s for performance tuning.
• Fixed issues in Payroll Fast Formulas and OTL Fast Formulas.
• Developed Payable open interface to import flat file data into base tables.
• Developed Purchasing interface program.
• Created Multiple Alerts for New Hires, Birthday Reminders, PO Approval
• Created functions and procedures as per requirement.

Confidential

Software Engineer

Environment: JDK1.6, Spring MVC 3.0.3, spring security3.1.1, JQuery, Maven2, Jasper Reports, Hibernate3.3, Apache Tomcat 7.0, MySql5.5, Eclipse 4.2.

Responsibilities:

• Implemented MVC, DAO, J2EE design patterns as a part of application development.
• Developed various DAO classes for cataloging module.
• Implemented Business logic for Administration, Circulation Modules.
• Implemented Business logic and DAO classes for OPAC Module.
• Provided validations Using Validation framework.
• Wrote business logic with Java and JavaBean.
• Designed and developed user interfaces using JSP, HTML and CSS.
• Performed code review and unit tested the application.
• Responsible for writing complex SQL and HQL queries.