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 wif 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 wif Oracle Financials, Oracle manufacturing, Oracle Apex, 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 TEMPeffectively 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, Oracle Apex

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 wif Oracle Federal Financials 11i (version 11.5.9) E-Business Suite which include teh 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 teh 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 teh CUSTOM.pll file.
• Developed Interfaces for Oracle Financial Modules-AR.AP,GL,PO and FV
• Converting Discover reports to Oracle Business Intelligence reports.
• Worked wif transformations using Dimensional & Fact tables for mappings.
• Mappings were created using ODI Navigator for migrating teh 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 Oracle APEX (version 5)
• Designing Debugging, Coding in Oracle APEX(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 Autantication of Schemas in Oracle Apex.
• Created documentation for design and testing and implementation.

Confidential

Oracle EBS Developer

Responsibilities:

• Worked wif 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 teh 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 TEMPhas 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 teh invoice number is not in teh order of Release when Approved. dis 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 wif users, database administrators and database/application designers to develop a system that meets teh 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. Teh PL/Sal packages were tuned to run faster and improve performance in loading teh staging tables as well as teh base tables.
• Materialized views were created also and were refreshed.
• Lead as well as create Oracle Financial reports using Oracle 6i Developer. Teh flex fields in Oracle Financials for Dept of Energy were setup to use a lot of teh 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 teh data.
• Lead in supporting Oracle Discoverer.
• Performance for these reports is optimized.
• Working on development of teh Oracle Financial Datawarehousing database which houses all teh datawarehouse tables. My role is to create and populate teh Datawarehouse tables and create a streamline process for users to extract data from these tables. Currently, all teh data in teh datawarehouse is fed from teh headquarters to a star schema. Our feed extracts teh Oracle Financial data from teh staging tables in star schema and populates teh local tables. Data extracted is from Oracle General Ledger, Oracle Purchasing, Oracle Accounts Payable and Account Receivables.
• Populating teh ODS Schema wif data from STAR Schema. dis is done very similar to populating teh Datawarehouse tables.
• Teh ODS environment consists of Tables as well as Materialized Views consisting of summarized data. dis will be used for financial reporting purposes.
• Working wif users to gather information and translating them into design documents for coding purposes. These documents are tan submitted for approvals.
• Have a good understanding of Oracle Financials setups as well as teh 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 teh correct access to different reports. Also, customize discoverer reports (workbooks) based on user requirements.

Oracle EBS Developer

Confidential, WV

Responsibilities:

• Involved wif Oracle Financials. Modules involved are Oracle Purchasing, Oracle Payables, Oracle General Ledger & Oracle Project Costing and Budget. dis role needed both functional as well as technical noledge in communicating wif teh users. Also, a good understanding of financial setups in teh 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 teh concurrent manager. Purchase Order was one of teh 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 teh 10g reports to Oracle single sign-on Portal.
• Customized teh Purchase Order to suit their business and as well as customize many complexes delivered Oracle Report.