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 AP, AR, GL, PO, INV, BOM, HR, SSHR, Payroll, PMS modules.
• 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 reports.
• Worked on developing Technical Design for custom reports, interfaces and conversion
• Developed code for importing OTL data from Timeclock System to Oracle Time and Labor
• 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 on developing critical reports like Payroll Reconciliation Report
• 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 GL, AR, AP, INV, PO,BOM, SSHR, PMSDatabases: Oracle 11i, MySQL

Reporting Tools: Oracle Reports 6i, 10g, XMLP 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.
• Worked on upgrade and support of Oracle GL, AR, AP, PO, INV, BOM modules.
• Developed Interfaces, Conversions, Reports using SQL, PL/SQL Packages, Procedures, Functions, SQL*LOADER.
• Extensively developed the RICE components in the major financial modules like GL, AP, AR.
• Worked on Oracle AR create receipts interface.
• Worked on AR invoice customizations, AR invoice print, statement print processes.
• Developed AR Invoice import program for importing invoices into base tables.
• Created and customized reports using XML Publisher in AR, AP,INV, BOM and PO.
• Developed Payable open interface to import flat file data into base tables.
• Developed Oracle Finance Interface for Creating Invoices from third party system into Oracle Receivables.
• Modified OA Framework Pages to display Total Score to Managers.
• Worked on OA Framework personalization to hide Rating levels from Employees.
• Worked on CO Extension for restriction of adding Objectives in Employee Self Service Performance Management.
• Created New Objectives Template to hide inactive Objectives for Employees; New Competencies template to restrict selective competencies
• Worked on outbound interfaces to First Advantage and XEROX Vendors
• Coordinated with vendors like First Advantage and Fidelity.
• Designed solution for new customizations
• Worked closely with DBA’s to address performance issues.
• Worked closely with the DBA’s for code migration

Confidential, MA

Techno-Functional Consultant

Environment: Oracle Apps R12 Upgrade & Support.

Responsibilities:

• Worked on upgrade and support of Oracle AR, AP, GL, PO,INV, BOM modules.
• Used SQL*Loader and UTL FILE packages for data conversion and interfaces.
• Developed customized reports using XML Publisher & Discoverer Reports.
• Set up and customized Performance Management Templates for Appraisals
• Worked on different phases like UAT, deployment on production etc .
• Supported all go-live activities and post-production troubleshooting.
• Designed and developed an Interface program to load open invoices from legacy system into Payables.
• Developed an Interface program to load receivables data from legacy system into Receivables.
• Worked with Auto Invoice interface to upload the invoices into the AR tables.
• Worked on creating custom programs to import Journals from a legacy system into General Ledger.
• Designed and Developed AR Auto-invoice interface from different front-end systems.
• Creation of value sets in various modules of the application.
• Worked on Costing and Transfer to GL Processes.
• Prepared the code packs to migrate deliverables from one instance to another instance.
• 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.
• Worked on AIM Documentation like MD50,MD70, MD120.
• Worked on HRMS Reports and Customizations.

Confidential, Atlanta

Technical Consultant

Environment: Oracle Apps R12.

Responsibilities:

• Worked on Enhancement and Support forAP, ARandGLmodules.
• Customized the reports for Financial Module (GL, AP, and AR) using Report Builder
• Customized StandardARReceipt RegisterReportusingReports6i/10g.
• Used SQL*Loader and UTL FILE packages for data conversion and interfaces..
• Developed conversion to load AR Invoices from MAB to oracle.
• Developed customized reports using XML Publisher & Discoverer Reports.
• Developed several Outbound interfaces from Oracle EBS to Third party vendors
• Developed several SQL*loader scripts to upload the data in to database.
• Created different transaction types and sources for Receivables
• Created distribution sets, receipt sources, receipt classes & payment terms
• Defined application rule sets, and auto cash rule sets
• Set up the auto accounting and accounting rules
• Created different bank accounts for Payables and Receivables
• Creation of Values Sets as per the requirement in the Application.
• Worked on Inbound Interfaces from vendors to Oracle HR
• 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
• 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.
• 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
• 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
• 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.