PROFESSIONAL SUMMARY:

• Over 15 years of Information Technology experience including Software Design, Development, Implementation And support involving large scale Oracle databases like CMS (Medicare and Medicaid).
• Excellent skills Data Modelling, Schema Design, Database Optimization, ER Diagrams, Flow Charts,
• Performance tuning, Systems Integration, Interfacing from and To Oracle ERP System.
• Over 12 years of Techno - Functional experience with Oracle E-Business Suite including 8 Years of experience in Oracle Federal Financials implementation and support.
• Experience with Shared System Service Provider Implementation (Centers for Medicare & Medicaid Services).
• Excellent with General Ledger, Payables, Receivable, Assets, Cash Management, Oracle CRM, Oracle CLMOrder Management, Purchasing, Inventory, Oracle Loans, Oracle Leasing, Shop Floor Management etc.
• Excellent with SQL, PL/SQL, Oracle Reports and Forms (6i-10G), BI/XML Publisher, OA Framework.
• Sound knowledge of AOL, Alerts, Workflow, AME, Sys-Admin, Shell scripting and Basic Networking.
• Lead role experience including Bearing Point, CGEY, Confidential, Confidential, Confidential and Oracle Consulting projects.
• Debugging, Patches Implementation and Production Support expertise.
• Knowledge of XML, XSLT, JAVA, BPEL, SOA and Web Service Technologies.
• Knowledge of PVCS, Kintana and Clear case/Clearquest Migration and version control tools. .
• DBA Skills, applying patches, troubleshooting, cloning etc. in R12 development environment.
• Good with MS Office, VISIO, TOAD, SQL Developer, JDeveloper, XML Marker and XML Spy.
• Good with Oracle Database VPD, Bulk Data Load, Materialized Views, Import and Export etc.
• Good with Oracle 10g and 11G and earlier versions and could work as DBA/Architect.
• Experience with OBIEE, Data Warehousing and Data Modeling.
• Trained in Cloud Financial modules, GL,AP,AR,CM and Assets, configuration and setups.
• Good with Templates to structure, format, and generate the data file according to the requirements of the target application objects.
• Capable of File-based load process to load the data file(s) into the respective product application interface tables.
• Knowledge of Application-specific data import processes to transfer data from product application interface tables to the relevant product application tables.
• Excellent with OTBI - Reports and BI Publisher Reports including bursting.
• Excellent with Cloud data export to 3rd party systems.
• Creation of business users and association of roles.
• Creation of custom roles, Customization of existing roles.

FUNCTIONAL SKILLS:

• Lead Experience in Implementation, Customization and Production Support projects.
• Able to work independently with end-users and within the IT team.
• Implementation support, Trouble shooting, User Interaction/Issues, Work-around and Problem-solving skills.
• Production Support experience in Financials, Inventory, Purchasing and CLM modules.
• Good knowledge of double entry accounting concepts and reconciliation.
• Good with Oracle EBS and third-party systems integration.
• Good with Configurations and setups and Functional design documents.
• Experience in Integration testing.
• Completed Oracle Cloud Financials, working on get more exposure to Could Financials.
• Good with GAP analysis and Business Process Re-engineering.

TECHNICAL SKILLS:

• Oracle Federal Financials, R12, SQL, PL/SQL, JDeveloper/OA Framework, BI/XML Publisher.
• Oracle Reports and Forms (6i-10G), WebLogic, BPEL/SOA, Webservices, SOAP UI, Java.
• OBIEE, Data Warehousing, SOA, BPEL, OBIEE, Web Service Technologies.
• MS Office, VISIO, TOAD, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Oracle EBS Rel- 12.1.3/12.2.6 Lead Techno-Functional Consultant

Responsibilities:

• Utilized (CLM, Financials, Order Management) 11i/R12 Oracle 10g/11G, Oracle Tools/PL SQL, OAF, Web Services, BI Publisher.
• Production support to Financials, CLM and Order Management.
• Resolved issues with Merge Documents Failure in CLM.
• Supported IPP interface and CITI bank invoice interface to CLM.
• Provided support to resolve Req/ mismatch issues like Inv Org/line type/amount-based vs quantity-based line issues, approval failures, /Source IDV issues, FPDS-NG reporting issues, PDF issues, SAM vendor Duns expiration issues, MOD change description issues.
• Developed reports for CLM s History, Inspection Due, working on P-CARD Integration.
• Provide technical support for Custom Developed Manufacturing extension to Oracle EBS.
• Retrofitted version 12.1.3 custom code to 12.2.6 version upgrade making database editioning compatible.
• Extensive Performance tuning of OAF VOs, Reports SQLs, PL/SQL concurrent programs.
• Analysis of existing design and provided better solution designs in Custom Manufacturing module MEC.
• Developed Move Order Return Functionality using OA Framework tool.
• Developed PL/SQL and SQL packages and customized BI/Publisher reports with bursting feature.
• Troubles shoot production support issues and resolve in timely manner.
• Support management with Technical inputs and time lines.
• Develop and design complex data structures, ad hoc queries, reports and analytics.
• Supported Web Services running between FLOWSYS and EBS system.
• Designed OBIEE Repositories for Note Reclamation process.
• Customized Pricing of Purchase Order Lines/CLM functionality.
• Modified PO CUSTOM SUBMISSION PKG for s validation.
• Customized and Implemented MAXIMO adapter for Integrating EBS system to MAXIMO Inventory System.
• Developed s Listings, Receipts Inspections Due report for CLM.

Confidential, Germantown, MD

Oracle Federal Financials (EBS) Rel-12.3 Sr. Techno-Functional Consultant

Responsibilities:

• Utilized (GL, AP,AR,PO) 11i/R12 Oracle 10g/11G, Oracle Tools/PL SQL, OBIEE, Oracle Reports, Forms.
• Provide expertise in all technical areas including design, development and implementation support.
• Converted Reports developed in Oracle EBS 11i to R12 environment.
• Unit Tested OBIEE Reports migrated from 10G environment and fixed bugs.

Confidential, Baltimore, MD

Oracle EBS Rel-12.1.3 Lead Techno-Functional Consultant

Responsibilities:

• Utilize R12 (iStore) in a Solaris, Oracle 10G, Oracle Tools/PL SQL, JDeveloper, WebLogic, VBScript, HTML, JSP,BPEL/SOA and OBIEE environment.
• Provide expertise in all technical areas including design, development and implementation support.
• Implementing Extensions and develop code extensions meet user requirements.
• Developed Check Scanner Interface using HTML/Script.
• SSA to Treasury Department OCTNET integration thru Webservice using JDeveloper, WebLogic, PL/SQL, Java.
• Developed web service using Jdeveloper, Weblogic and VB Script to make service from Scanner Interface to Oracle EBS.

Confidential, Parkersburg, WV

Oracle EBS Rel-12.1.x Sr. Technical Consultant

Responsibilities:

• Utilize R12 (Payable, Purchasing) in a Linux, Oracle 10G, Oracle Tools/PL SQL, BI/XML Publisher, Workflow Builder, FNDLOAD and Jdeveloper11g environment.
• Provide expertise in all technical areas including design, development and implementation support.
• Implementing Extensions and develop code extensions meet user requirements.
• Generated XML Output files using XSLT and XML transformation for PO Interface to IPP.
• Developed shell scripts for code migration.

Confidential, Washington, DC

Oracle EBS Rel-12.1.x Lead Techno-Functional Consultant

Responsibilities:

• Utilize R12 (GL, Payable, Receivable, Assets, Purchasing, iProcurement and Self Services) in a Linux, Oracle 10G, Oracle Tools/PL SQL, BI/XML Publisher, XML Spy, Workflow Builder and Jdeveloper11g environment.
• Provide expertise in all technical areas as the lead technical consultant to complete the Board upgrade to R12 from 11i version of EBS to Federal Client utilizing only 3 outside independent consultants.
• Mentor board developers, implement R12 standards, add extensions, and enhance interfaces and Workflows.
• Perform custom report development using BI/XML Publisher etc.
• Personalized iProcurement OAF screens.

Confidential, Dayton, OH

Oracle EBS Rel-12.1.x, Sr. Technical Consultant

Responsibilities:

• Utilized R12 (Inventory, Order Management, Warehouse Management) in a SUN OS 5.10, Oracle 10G, Oracle Tools/PL SQL, BI/XML Publisher, and XML Spy environment.
• Developed Interfaces and Reports for Inventory and Order Management Modules.
• Supported Integration testing in resolving technical issues with SQL and PL/SQL code.
• Modified XML Outbound Interface files using PL/SQL, BPEL (SOA).
• Developed Shipping Labels using ID Automation Barcodes.
• Supported team management and functional team on various Integration issues.
• Completed MD70 technical design for Interfaces.

Confidential, Washington, DC

Oracle EBS Rel-12.1.xSr. Technical Consultant

Responsibilities:

• Utilized R12 (Inventory, OM, PO, AP, Shop Floor Management) in a Linux, Oracle 10g, BI/XML Publisher, OBIEE and JDeveloper environment.
• Developed Lots Jobs Interface, Lot Move Jobs and Material Transactions Interfaces.
• Created technical design documentation MD-70 for Interfaces, Conversion, Extensions and Reports.
• Developed reports using XML Publisher.
• Designed MD-70 documentation for Inventory and Shop Floor Management nodules customizations and assisted functional consultants in MD-50 design and custom solutions with in Oracle EBS.
• Mentored team members on XML Data Template development and Report design using XML Publisher.
• Utilized RTF Templates and XSLT/XML scripts.
• Developed Migration scripts for custom objects using Unix Shell Scripts and SQL Plus Commands.

Confidential, Ashburn, VA

Oracle Apps Rel-12.1. lead Technical Consultant

Responsibilities:

• Completed R12 Upgrade from 11i (AP, PO, AR, PA, GL) in Confidential /AIX Oracle 10G, Oracle Tools/PL SQL, and BI/XML Publisher and OBIEE environment.
• Implemented Payables Open Interface in R12. Converted reports from R11i to R12 using XML publisher.
• Provided technical assistance to DBA team in migrating custom objects from R11i to R12 objects.
• Migrated a total of 15 XML reports from R11. Modified Shell scripts to run under R12 environment.
• Helped project management team in assessing the impact of custom 11i code and their impact on R12 architecture roll out schedule.

Confidential, Brainerd, MN

Oracle Apps Rel-12.1.x Lead Technical Consultant

Responsibilities:

• Utilized Accounts Payable, iExpense, General Ledger, Fixed Assets in an Confidential /AIX, Oracle 10G, Oracle Tools/PL SQL, and BI/XML Publisher and Confidential AS 400 environments.
• Lead Technical developer for the Confidential project which includes EBS and Oracle Retail.
• Designed (AIM Documents) and developed GL Open Balance conversions.
• Developed GL Interface and Payable Open balances from Confidential AS 400 Main Frame legacy systems.
• AP Supplier Conversions, AP Open Invoice Interface and AP History Invoices conversions and Assets Conversion interfaces, Credit Card Interface for iExpense.
• Modified Check processing program to pay by Supplier from the existing payment functionality by Supplier sites.
• Provided support for functional and testing teams.
• Worked with Oracle support team in fixing performance issues and bugs.
• Ensured GL and AP modules went live.
• Created UNIX shell scripts to migrate data files across secure server from and to Oracle server.
• Developed reports using Oracle Reports and XML Publisher.
• Performed forms personalization in AP.

Confidential, Melbourne, FL

Sr. Consultant, Oracle Portal

Responsibilities:

• Utilized BI Publisher, Oracle Portal, Oracle 10G, ClearQuest, ClearCase, TOAD, SQL, PL/SQL, and XML.
• Designed, developed, tested and supported FDCA Releases 3,5 and 6 using Oracle Tools and BI Publisher.
• Created reports mockups for Census verification for releases 3,5 and 6.
• Worked on reports with performance issues for a total of 30 BI Publisher reports and labels which were completed.
• Worked on reports with BARCODES.
• Coordinated with testing assembly test team for testing the reports and labels.
• Collaborated with Forms development team for fixing issues with data capturing.
• Completed a test project on converting Reports into Spanish with Accenture team based in MD.