SUMMARY:

• 8 years of experience in information technology in software design, development, testing, implementation, integration, documentation and user training of business applications.
• Strong Experience in front-end and back-end development using Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/9i, XML Publisher, Workflow Builder 2.6, SQL, PL/SQL, Oracle 11g/10g/9i/8i
• Strong experience with PL/SQL stored Procedures, Functions, Packages, Database Triggers and advanced PL/SQL objects types
• Strong experience with SQL with tables, indexes, views, sequences and Dynamic SQL
• Strong experience with SQL performance tuning with high volume of data
• Strong experience with data conversion from various sources
• Strong experience with Hyperion Interactive Reporting 11/9
• Strong experience with E-Business Applications Financials 11i General Ledger GL , Accounts Payable AP , Accounts Receivable AR , Fixed Assets FA , Purchasing PO , Order Management OM , HRMS, Oracle Utility Billing OUB
• Strong experience with Trading Community Architecture TCA / Customer Data Hub CDH
• Strong experience working with Data Warehouse and Star schema data model
• Strong experience with writing test plans
• Strong experience in producing high quality solutions on time during the project mile stones at every stage.
• Very good experience in Production Support on daily basis for issue resolutions
• Involved in implementation of Oracle Financial E-Business Applications in R12/11i/11.0.3 version
• Strong experience with Oracle Applications Object Library AOL
• Working experience with Perl 5.8
• Strong experience with Crystal Reports XI R2/2011

TECHNICAL SKILLS:

• Languages: SQL, PL/SQL, C, C , Perl
• Database: Oracle 11g/10g/9i/8i
• Front-end tools: Forms 10g/9i/6i, reports 10g/9i/6i, Discoverer 10g/9i, XML Publisher,
• Hyperion Interactive Reporting 11/9, Workflow Builder 2.6,
• Crystal Reports XI R2/ 2011, TOAD, PL/SQL Developer
• Oracle Applications
• ERP: Financials R12/11i/11.0.3: GL, AP, AR, FA, HRMS
• Purchasing PO , Order Management OM
• Application Object Library AOL .
• O/S: Unix, Linux, Solaris, Windows XP/7, MS-DOS

PROJECT EXPERIENCE:

Confidential

Role: Oracle Developer PLSQL, Crystal Reports

This Project is an enhancement of LASER applications for CONFIDENTIAL . LASER is a custom application to process various loan types. This includes various custom interfaces to process loans from 3rd party applications on daily basis. This includes Crystal reports upgrade.

Roles and Responsibilities:

• Created logical design document for various loan types.
• Designed the data mapping documents for interfaces from 3rd party applications to LASER.
• Modified the PLSQL packages for Master Serviced loans.
• Created control files using SQL Loader to load data into custom tables
• Developed PLSQL programs in Phoenix and Collateral applications.
• Modified Perl scripts to process data from different databases simultaneously.
• Modified SQL Server stored procedures to feed data into Crystal reports.
• Created Unix shell scripts to schedule jobs.
• Created database views for the new custom reports.
• Developed new reports using Crystal Reports 2011.
• Modified various tax reports, collateral balance detail report and remittance reports using Crystal reports designer as per business requirements.
• Developed new reports using Crystal designer which are based on query as well as stored procedure based.
• Involved in postproduction support
• Performed SQL tuning by using explain plan.
• Created indexes on loan processing tables to improve performance.
• Created test scripts on various components.
• Coordinated with business users during UAT testing.

Environment: Oracle, LASER, SQL, PL/SQL, PL/SQL Developer, SQL Server, Perl, Crystal Reports 2011, Unix, Windows 7.

CONFIDENTIAL

Role: Oracle Developer PLSQL

This project is to implement FACTS II system on Oracle platform. It includes conversion of data from Legacy FACTS I system into FACTS II system of various divisions data. SQL loader and Oracle import/export utilities were used for data migration.

Roles and Responsibilities:

• Interacted with Business Users, Process Owners, and Subject Matter Experts for business requirements gathering.
• Created design document for various components.
• Created conversion data mapping document.
• Involved in designing Logical Data Model.
• Created database tables, indexes and sequences.
• Prepared test cases for each conversion data set.
• Involved in doing performance tuning of PLSQL programs.
• Developed PL/SQL scripts and store procedures using mapping documents to transform and load data in Oracle database.
• Created lookup tables for various business validations and trnsaformations.
• Created XREF tables for transformations of high volume data using batch process.
• Created SQL loader control files to load flat files into Oracle tables.
• Involved in data conversion from Legacy system to Oracle database.

Environment: Oracle, SQL, PL/SQL, Toad, Unix, Windows XP.

CONFIDENTIAL

Role: Oracle Developer PLSQL, Crystal Reports

This Project is an enhancement of LASER applications for CONFIDENTIAL bank. LASER is a custom application to process various loan types. This includes various custom interfaces to process loans from 3rd party applications on daily basis.

Roles and Responsibilities:

• Developed the PLSQL packages to process loans.
• Created database triggers to keep track of changes to the loans for audit purpose.
• Modified various functions to improve performance.
• Created control files using SQL Loader to load data into custom tables
• Created Unix shell scripts to schedule jobs.
• Developed PLSQL programs for data conversion from various sources of data into Oracle database.
• Modified various crystal reports as per business requirements.
• Involved in setting up data in UAT to various users in offshore to test the modifications.
• Involved in testing the process flow of various loan types through LASER screens.

Environment: Oracle, LASER, SQL, PL/SQL, PL/SQL Developer, Crystal Reports 2011, Unix, Windows XP.

Oracle EBS R12 upgrade / Data Conversion

CONFIDENTIAL, Role: Oracle Applications PLSQL, Oracle Reports, Hyperion Reports / Developer

This Project is an Implementation of Oracle applications R12. The various modules involved in this Implementation are GL, AP, AR, FA. This Implementation included development of Data Conversions, Reports and extensions that meets various business requirements.

Roles and Responsibilities:

• Created technical design documents MD.070 for various enhancements to the financial modules.
• Designed the data mapping documents for Fixed Assets Data conversions in FA.
• Developed the PLSQL conversion programs for invoices and Fixed Assets.
• Created control files using SQL Loader to load legacy data into interim custom tables
• Created the datamarts for AR aging base, GL transactions, AR transaction Register, AP transactions and load the data on daily basis for the data warehouse.
• Converted the AR Aging report, Invoice print preview report using Hyperion interactive Reporting for the user to run for various operating units at a time.
• Customized the Oracle seeded workflow of AR Credit memo notification to change approval process
• Created function activity to call PLSQL function to set the workflow attributes of approvers.
• Redesigned the oracle alerts to improve the performance from hours to couple of minutes.
• Recreated PKSQL packages to split big queries into small queries and call them in a separate query.

Environment: Oracle Applications R12 12.1.3 , GL, AR, AP, FA, SQL, PL/SQL, PL/SQL Developer

Oracle 10g, Reports 10g, Hyperion Interactive Reporting 11,

Linux, Windows XP.

CONFIDENTIAL

Role: Oracle Applications PLSQL, Oracle Reports, Hyperion Reports / Developer

This Project is an implementation of Oracle applications 11i modules relating to financial sector to Lithonia Lighting. GL, AP, AR, PO and OM modules were implemented. The legacy business is operating on mainframe. The legacy system and the new system i.e., Oracle Applications are brought in to sync through the custom interfaces developed in PL/SQL. Oracle Reports builder, Discoverer, Hyperion Interactive Reporting and XML publisher tools were used to develop the business data analysis reports.

Roles and Responsibilities:

• Designed and developed the Conversion programs for customers and sales orders using PL/SQL packages.
• Created control files using SQL Loader to load the data into staging tables.
• Created the data mapping documents for Customer conversion.
• Developed a PL/SQL program to import sales orders from legacy system to Oracle.
• Customized the Ship Only Lines workflow in OM to add the new process for SHIPPING transaction type.
• Developed Inbound / outbound interfaces for data synchronization between Oracle EBS and third party applications like Propricer, Autotime etc.
• Designed and developed the Oracle reports in Discoverer, Hyperion, Reports builder and XML publisher for GL and AR.
• Developed the Interactive Reports in Hyperion Studio and import them to the web version and gave access to the user groups.
• Developed dash boards for Interactive Reports for the users to enter report parameters.
• Created Hyperion and Discoverer reports in Data warehouse.
• Created unix shell script for bank file transfer in AP.
• Created custom Form to enter the parameters for RFQ interface.
• Created custom PL/SQL procedures using Dynamic SQL to load RFQ and requisitions from legacy system to Oracle in PO.
• Created Data Loader files to load banks and branches, collectors, payment terms and customer credit limits in AP, AR
• Created the test plans after the development of data Conversions and interfaces for the users to test during user acceptance test.
• Production Support in GL, AR, AP and OM modules on day to day basis.
• Recreated SQL queries by changing the joins to improve performance

Environment: Oracle Applications 11i 11.5.10 , GL, AR, AP, PO, OM, TCA/CDH, SQL, PL/SQL, TOAD,

Workflow Builder, Oracle 10g, Reports 10g, Hyperion 11,

XML Publisher, Discoverer 9i, Linux, Windows XP.

CONFIDENTIAL

Role: Oracle Applications PLSQL, Forms, Reports Developer

This Project is an implementation of oracle financials modules in integration with Oracle Utility Billing OUB to the philadelphia water department. This project includes extension modules to the oracle applications standard modules. These extensions include Receivable adjustments, payment agreements, Shut-Off, Bill Printing and Bill Archiving etc. The city of Philadelphia decided to use the Oracle Utility Billing OUB for their billing system. All the extension modules are integrated with oracle AR and OUB modules.

Roles and Responsibilities:

• Designed the technical documentation MD.070 for the Shut-Off, Bill Printing and Bill Archive extensions.
• Designed and developed PL/SQL stored procedures and packages for conversion programs of Customers and invoices using PL/SQL package.
• Developed the Bill printing report using reports builder.
• Developed reports using Discoverer in AR and GL.
• Developed the custom forms to enter the customer payment agreements and receivable adjustments using forms developer.
• Developed the Unix shell script to move the output files from out directory to the network drive.
• Developed the invoice extract program from AR.
• Created Financial statement generator FSG reports in GL and open them in EXCEL format using XML publisher.
• Created many reports in GL and AR using XML publisher.
• Created test plans for conversions and extension modules
• Supported AR module on daily basis.

Environment: Oracle Applications 11i 11.5.9 , GL, AR, OUB, TCA, SQL, PL/SQL,TOAD, Oracle 9i, Forms 6i, Reports 6i, XML Publisher, Discoverer 9i, Unix, Windows XP.

CONFIDENTIAL

Role: Oracle Applications PLSQL, Reports Developer

This project is an implementation of Oracle modules GL, AP, AR, FA and HRMS to Glimcher Realty Trust. Participated in creating custom Pl/SQL packages to convert data from legacy system into Oracle. Development of these conversion programs are mainly for Oracle financial application modules like General Ledger GL , Fixed Assets FA , Account Payables AP , Account Receivables AR . SQL Loader oracle utilities are used for these conversions.

Role and Responsibilities:

• Created Interim database tables to store data from legacy systems for validations.
• Created database triggers and indexes based on business requirements
• Created control files to load data from legacy systems into Interim tables.
• Created Custom PL/SQL packages to convert Fixed Assets and Vendors from Legacy system to Oracle.
• Developed the package for Employee conversion.
• Involved in performance tuning of the SQL queries
• Developed the reports in AR and FA using discoverer.
• Created alerts upon GL consolidation, GL period close and journal reversal process.
• Supported GL, AP and AR module on daily basis.

Environment: Oracle Applications 11.0.3, GL, FA, AP, AR, HRMS, SQL, PL/SQL,TOAD, Oracle 9i, Forms 6i, Reports 6i, Discoverer 9i, Unix, Windows XP.