SUMMARY:

• Over 18 Years of Work experience in IT industry specifically working in Oracle Applications development. Ability to understand, document and resolve business problems quickly. Excellent programming skills with strong functional expertise and project management skills.
• Experience in all phases of Development life cycle involving analyzing, developing, designing, testing, maintaining software applications.
• Extensively worked with Oracle Financials, Oracle manufacturing, Confidential, OBIEE, Data warehousing, ETL using ODI
• Developed complex interfaces, packages, functions, procedures using SQL, PL/SQL, Oracle reports, Oracle Forms in Oracle Financials.
• Created mappings in ODI using different transformations.
• Experienced in supporting end - user reporting needs. Competent to manage and deliver results on multiple tasks by effectively managing time and priority constraints. Ability to address any on-going or changing business needs.

TECHNICAL SKILLS:

Operating System: Windows 2003/2008/XP/Vista/7/UNIX/

Database: Oracle 9i/10g/11g, SQL Server

ETL Tools: ODI

Programming Languages: SQL, PL/SQL, HTML, Javascript, UNIX Shell Script

Reporting Tools: Oracle Reports, BI Publisher

Applications: Oracle Financials Release 12, Oracle Manufacturing, Confidential

Other Tools: SQL*Plus, SQL Loader, MS Visio, MS Project, TOAD, SQL Navigator, Oracle Developer Oracle Developer Suite 10g, PVCS, ODI

PROFESSIONAL EXPERIENCE:

Confidential, VA

Oracle Systems Analyst/EBS Developer

Responsibilities:

• Worked on Oracle Application 11 upgrade to Release 12 for Oracle Financials.
• Involved in Converting, Modifying and customizing Reports, Interfaces, Conversions, and Enhancements to Release 12 (RICE)
• Worked with Oracle Federal Financials 11i (version 11.5.9) E-Business Suite which include the following modules GL (General Ledger), AP (Accounts Payable), PO (Purchasing), AR (Accounts Receivable), FA (Fixed Assets).
• Developed several OAF/ADF Forms Personalizations using JDeveloper 10g by extending VO (View Objects), AM (Application Modules), CO (Controller Objects) for AP, AR, and PO modules.
• Designed and developed custom OAF/ADF Web Forms using JDeveloper 10g.
• Worked on Oracle Financials upgrade project for Reports, Forms and interfaces.
• Converted custom.pll changes to Form Personalization for Oracle Financials for easier maintenance.
• Designed, developed and modified custom reports for the following modules: GL, Purchasing, Accounts Payable, Accounts Receivable, Fixed Assets, using Oracle Reports 6i.
• Developed custom Application Forms using Oracle Forms 6i
• Maintained and modified custom AP, AR, GL, and PO forms using Oracle Forms 6i.
• Customized forms functionality by modifying the CUSTOM.pll file.
• Developed Interfaces for Oracle Financial Modules-AR.AP,GL,PO and FV
• Converting Discover reports to Oracle Business Intelligence reports.
• Worked with transformations using Dimensional & Fact tables for mappings.
• Mappings were created using ODI Navigator for migrating the data from Oracle Financials tables to IDW using transformations and mappings.
• Debugging and validating data after mappings were completed.
• Customized seeded reports in BI Publisher.
• Created reports in OLTPI
• Designing Debugging, Coding in Confidential (Version 5)
• Worked on interactive APEX Reports/Forms- Tabular/ Master detail/Classic
• Worked on Application/Enhancements.
• User Interface, Rendering/Page Processing/Shared Components.
• Designing, debugging, coding and maintaining Cascading Style Sheets (CSS), HTML, JavaScript, JavaScript and XML (AJAX) code
• Created shared items in Shared Components as requirement needed.
• Created Dynamic Actions on Items.
• Added APEX Validation on items.
• Created edit links to Pages.
• Customizing look and feel of Pages.
• Used Oracle Calendar on Dashboards to enter schedules.
• Used Plugins where needed.
• Oracle SQL and PL/SQL Packages, Function coding.
• Worked on Authorization and Authentication of Schemas in Confidential .
• Created documentation for design and testing and implementation.

Confidential

Oracle EBS Developer

Responsibilities:

• Worked with Oracle Applications 11.5.10, Oracle Manufacturing, Oracle Project and Oracle Financials.
• Writing interfaces and extensions by calling API’s for Oracle Manufacturing.
• Gathering requirements from user and creating designs for robust process.
• Development and customizing Oracle forms.
• Creating Oracle PL/SQL procedures and packages.
• Tuning and improving sol performances.
• Customized Oracle Screens using CUSTOM.pll based on the requirements of users for Oracle Projects and WIP. Discrete jobs screen was customized thru custom.pll as well as personalization’s to restrict any changes after a job has been released. Customizations and personalizations were done to Department, Resource, Routings and Job screens.
• Extensions were done to Print-Release form for AR where an invoice can be released even if the invoice number is not in the order of Release when Approved. This was a complex change to integrate re-generation of invoice numbers as well as releasing them to AR.
• Customizing Oracle Reports for Bom/.
• Completed Technical AIM Documents - MD050, MD070. MD120 in order to keep documentation of process and design.
• Maintained code in Harvest.

Confidential, Arlington, VA

Responsibilities:

• Involved in Oracle HRMS/Payroll implementation and conversion.
• Develop custom Oracle Packages and formulas.
• Develop and customize Oracle Reports 6i.
• Work closely with users, database administrators and database/application designers to develop a system that meets the functional and technical requirements.

Confidential, Pittsburgh, PA

Oracle Developer

Responsibilities:

• Involved in Oracle Financials GL,AP,AR & PO.
• Tuning was done and Performance was improved for Data warehouse processes. The PL/Sal packages were tuned to run faster and improve performance in loading the staging tables as well as the base tables.
• Materialized views were created also and were refreshed.
• Lead as well as create Oracle Financial reports using Oracle 6i Developer. The flex fields in Oracle Financials for Dept of Energy were setup to use a lot of the formulas.
• Lead support for IDW database from Headquarters. Creating stored packages to load data in idw target database and as well as create a streamline load process for different processes.
• Lead in designing\developing\maintaining ODS database. Creating PL/SQL packages to load data as well as create a streamline process for different processes.
• Creating Oracle Forms and Reports.
• Analyze the data.
• Lead in supporting Oracle Discoverer.
• Performance for these reports is optimized.
• Working on development of the Oracle Financial Datawarehousing database which houses all the datawarehouse tables. My role is to create and populate the Datawarehouse tables and create a streamline process for users to extract data from these tables. Currently, all the data in the datawarehouse is fed from the headquarters to a star schema. Our feed extracts the Oracle Financial data from the staging tables in star schema and populates the local tables. Data extracted is from Oracle General Ledger, Oracle Purchasing, Oracle Accounts Payable and Account Receivables.
• Populating the ODS Schema with data from STAR Schema. This is done very similar to populating the Datawarehouse tables.
• The ODS environment consists of Tables as well as Materialized Views consisting of summarized data. This will be used for financial reporting purposes.
• Working with users to gather information and translating them into design documents for coding purposes. These documents are then submitted for approvals.
• Have a good understanding of Oracle Financials setups as well as the Financial functional aspect.
• Customized Oracle Forms to call Oracle Reports.
• Tools used are Oracle Reports, Discoverer.
• Lead support for Oracle Discoverer reports. Make sure that users have the correct access to different reports. Also, customize discoverer reports (workbooks) based on user requirements.

Oracle EBS Developer

Confidential, Wheeling, WV

Responsibilities:

• Involved with Oracle Financials. Modules involved are Oracle Purchasing, Oracle Payables, Oracle General Ledger & Oracle Project Costing and Budget. This role needed both functional as well as technical knowledge in communicating with the users. Also, a good understanding of financial setups in the company’s business.
• Customized as well as created several reports for Oracle Project Costing and Budget. These were very complex reports that had Oracle Projects as well as Assets and General Ledger information.
• Customized as well as created reports for Oracle Purchasing reports and setting them up in the concurrent manager. Purchase Order was one of the reports that needed several customizations.
• Modifying and writing Oracle PL/SQL packages and analyzing data.
• Converting legacy reports using Oracle Developer 10g suite to jsp formats.
• Adding the 10g reports to Oracle single sign-on Portal.
• Customized the Purchase Order to suit their business and as well as customize many complexes delivered Oracle Report.