SUMMARY:

• 18 + years of techno - functional experience in E-Business Suite/Oracle Fusion Cloud Applications Development, Customizations and Upgrades.
• Expert in Oracle Federal/commercial Financials and e-Business Suite Applications Development - Releases 10.7, 11.03,11i, R12. R13;
• SME in EBS Reports development and customization using various development tools (FSG, Reports 6i, BI (XML) Publisher, Discoverer 4i/10g; Oracle R13 Fusion/Cloud Financials Implementation, Data migration using FBDI Templates, Oracle Cloud OTBI Reports and Dashboards development.
• Forms development and customization using TEMPLATE.fmb, CUSTOM.pll; forms personalization.
• Functional knowledge and experience in GL, AR, AP, FA, PO,, iProcurement, OM, PA, INV, GRC/PCG.
• Expert in creating AIM documentation (BR100, CV060, MD050, MD070, MD120, TE040 etc).
• Unit, Integration and UAT testing of configuration and custom RICEW objects and processes.
• Expert in Oracle EBS e.g. as an Applications System Administrator:
• Created Concurrent Programs, Functions, Menus, Responsibilities, Users, Value Sets, Discoverer Publishing links.
• Served as a Solution Manager and Technical Lead for the EBS Reports Development team at several Oracle Implementation and upgrade projects.
• Provided in Discoverer, Oracle Reports and BI Publisher Tools to end users and peer developers.

TECHNICAL SKILLS:

Programming Languages proficiency: SQL, PL/SQL, HTML, XML

Operating Systems: UNIX, Linux, Windows (multiple Versions), Windows VM.

Oracle Financial and eBusiness Suite Applications: 10.7, 11i, R12, Oracle Financials Fusion Cloud, Oracle GRC.

Oracle Development Tools: Oracle Developer suite 2000, 6i, 9i,10g; Forms 3, 4.5, 5.0, 6i, 9i, Custom.pll.; Reports 1.0, 2.5, 5, 6i, 9i, 10g Discoverer 3.1, 4i, 10G, (Administration Edition, User Desktop Edition), Discoverer Plus and Viewer, BI (XML) Publisher; SQL*Plus, Oracle Enterprise Manager, TOAD, Designer 6i,Oracle Web ADI, Data Loader;

File Management and Version controls Systems: PVCS, Harvest, Versions, Asset Navigator 4, Tortoise, Stat 5.1.0, ITG (Kintana); Quality and status control tools Test Director 7.01, Mercury Quality Center, Battle Station, JIRA, Subversions.

WORK EXPERIENCE:

Confidential

Sr. GRC/PCG Techno-Functional Lead

Responsibilities:

• Performed pre - upgrade PCG Rules and code analysis, PCG Rules and Custom.pll modification and testing.
• Resolved various post upgrade issues, performed code reviews, wrote migration shell scripts and Documentation.
• Coordinated work between US and Confidential Off Shore Teams.
• Lead Reports Development for Talent and Compensation Module, including gap analysis, collecting and analyzing business requirements, writing functional and technical design documentation, creating OTBI (Oracle Transactional Business Intelligence) reports, analytics and dashboards, creating forms/pages customizations.

Solution Manager/Solution Architect

Confidential

Responsibilities:

• Successfully managed team of 4 developers, providing high level of expertise in all aspects of their work on a daily basis, e.g. explained technical and functional details of the assigned tasks; provided guidance with the steps to complete the assignments; investigated and resolved configuration, coding, functional and compilation issues; created SR with Oracle Supports and followed up till resolved; helped with coding and unit testing; performed code reviews; presented classed on Oracle EBS applications architecture, functionality, accounting principles and Oracle development tools.
• Completed most complex programming/development assignments for development and upgrade of SQL/PL/SQL, Extensions, forms, and reports.
• Oracle GRC/PCG Upgrade from 11i to R12. Performed pre - upgrade PCG Rules and code analysis, PCG Rules, forms Personalizations and Custom.pll modification and testing.
• Resolved various post upgrade issues, performed code reviews, wrote migration documentation.
• Coordinated work between US and Confidential Teams.
• Provided functional assistance with custom objects testing (Forms, Reports, Interfaces, and Extensions.
• Wrote techno-functional documents, testing scripts, and user guides.

Confidential

Sr. Oracle Techno-Functional Consultant

Responsibilities:

• Created Functional and Technical design documentation for Oracle EBS (UFMS) customizations:
• Oracle GRC module custom forms and process rules iProcurement and Purchasing custom reports Forms Personalization for GRC, AP, AR, PA and GL. CCR/SAM Process CAN Year End Process eTravel Interface
• Defined Forms Personalization for Invoice Bench, Payment Bench and PO Matching forms.

Confidential

Sr. Oracle Techno-Functional Consultant

Responsibilities:

• Provided user support during daily operations, developed ad - hoc queries and custom reports for AP, GL, AR using Oracle Report Builder tool, XML and BI Publisher.
• Tested custom forms and reports after migration to Linux, researched encountered errors and provided solutions.
• Provided daily production support for users. Other duties included: issue resolution, creating TARs (SRs) with Oracle Support and follow up; assistance with End Of Month closing and reconciliation for AP and AR;
• Wrote user s guides and AIM Documentation ( MD50, MD70, MD120, TE40), created FNDLOAD and Shell scripts for programs migration.
• Provided sessions on for AR User on Collection process, forms and reports use, and general Oracle EBS navigation.

Confidential, Iselin NJ

Sr. Techno-Functional Consultant

Responsibilities:

• Analyzed business requirements, wrote Functional and Technical Documentation (MD50, TE40, MD70, MD120, CV60). Defined custom responsibilities, menus, printers/styles, profiles.
• Updated BR100 for GL and PO Setups.
• Preformed custom code and documentation peer review and approval.
• Personalized AP Invoice Entry form.
• Created FSG reports.
• Developed Reports for the GL, PO, AP, OM and INV using Reports Builder 9i;
• Converted standard reports into BI/XML data templates (manual conversion).
• Created XML Data and rtf Templates for Excel/PDF outputs using BI (XML) Publisher tool.
• Performed unit testing, created installation scripts, custom value sets, registered concurrent programs and XML data and layout Templates.
• Assisted DBAs with custom code migration through instances, post migration testing and issues resolution.
• Served as coordinator between techno - functional team and business users.
• Provided technical and functional support during UAT testing and post-production.
• Created Technical Assistance Requests (TARs) online with Oracle Support (former Oracle Metalink).
• Wrote testing scripts and user guides and instructions for UAT. Tested custom workflow for the PO and Invoice approval processes, Customer and GL interfaces, custom reports, custom forms and personalization during UAT phase. Logged and monitored issues, tested and signed off bug fixes.
• Lead sessions for Discoverer Plus and Discoverer Viewer users.
• Trained fellow developers on Discoverer Administration and reports development.

Confidential, Washington, DC

Techno-Functional Sr. Staff Member

Responsibilities:

• Performed as a Techno-Functional Lead for FA module. Functional duties included gathering and analyzing Business requirements, writing AIM Documentation - BR100, CV060, MD50.
• Performed Data mapping from Legacy system (Momentum) to Oracle for AP and FA, performed setups for Fixed Assets module, loaded Assets data using Web ADI tool, wrote TE40 and configuration testing scripts.
• Performed unit and integration testing for the conversions and reports.
• Created PowerPoint slides and performed presentations for FA Module overview, and Asset additions and consolidation processes.
• Wrote user guides on Fixed Assets addition and maintenance.
• Analyzing functional requirements, writing Technical design and installation documentation (MD070, and MD120), creating queries and views for Discoverer 10g.

Confidential, Montgomery, AL

Techno-Functional consultant

Responsibilities:

• Testing iStore and iProcurement standard functionality, configuration setups, Requisition and Purchase Order Approval Work flows and various forms customizations/personalization and reports;
• Wrote AIM documentation (MD50, MD70, TE40, BR100, MD120 ) and testing scripts. Developed custom System Administration reports with Report Builder 10g and BI Publisher for DBAs.
• Developed Custom reports for AR, AP, FA, PO and GL modules using Oracle Reports builder 6i /BI Publisher, and Discoverer 10g.

Confidential

Sr. Oracle Technical Consultant

Responsibilities:

• Analyzed Business Requirements (MD50s), worked with users to assist with the functional design, developed and customized reports for upgrade from i and R12 (AR, MFG modules ONT, BOM. CST, INV modules) using Oracle Development Suite/Reports 6i. 9i and BI Publisher.
• Created custom values sets, menus, and responsibilities.
• Preformed unit and integration testing, issue resolution including login TARs with Oracle Support, testing and follow up.
• Created MD70 documents, shell and fnd load scripts.

Confidential, MD

Sr. Oracle Technical Consultant

Responsibilities:

• Developed R12 custom financial/EBS reports for (GL, FA, AR, AP, PO) with global localization, e.g. Japan, China, Europe), using Reports 6i tool.
• Created XML Templates for the reports in BI Publisher tool.
• Discoverer 10g administration and reports development - created business areas, custom views, item classes, Performed Export/Import Discoverer objects. Developed Discoverer workbooks.
• Wrote design, Installation and User guide documentation, fndload and installation shell scripts, Performed unit and integration testing. Provided post-production support and issue resolution.

Confidential

Sr. Oracle Technical Consultant

Responsibilities:

• Developed custom bi - lingual (English/ Russian/Czechoslovak) financial reports (GL, FA, AR, AP, and PO) for the Eastern Europe localization using Reports 6i tool. Created XML Templates for the reports in BI Publisher tool. Created views and workbooks in Discoverer 10g. Wrote installation shell scripts and AIM Documents, performed unit and integration testing.
• Provided bilingual (English/Russian) interpretations during daily communications/meetings for peer functional and technical consultants.
• Created bi-lingual (English/Russian/Czechoslovak) Technical Design, Installation and User guide documentation

Confidential, Boca Raton, FL

Sr. Oracle Technical Consultant/Technical Lead

Responsibilities:

• Performed as a Techno-Functional Lead and Sr. Developer/Discoverer Administrator for the EBS Oracle Reports Development team.
• Successfully managed, coordinated and supervised a team of 20 developers (7 onsite and 13 off shore).
• Coordinated work on gathering business requirements for EBS Reports; assisted with the technical questions and issues; advised on the best programming practices; performed reviews and approval of code and documentation created by team members.
• Coordinated meetings between users and developers at all the phases of implementation and customization to ensure prompt turn around response to any questions or issues.
• Created and lead Oracle Apps and Oracle Tools Presentations and CRP sessions.
• Personally conducted classed for the users groups; provided one - one-one and assistance or the upper level leadership officials.
• Wrote user manuals and materials on Discoverer Viewer and Plus; trained users and junior developers on various tools e.g. Forms, Reports, Discoverer, and XML Publisher.
• Created status reports for the management, coordinated and supervised meetings with the business module leads and users to discuss requirements; assisted Functional consultants and users with creating AIM documentation (BR30, BR100,MD50).
• Provided assistance to DBA team in resolving various post migration issues occurred for the Discoverer and EBS Reports, advised in various tool installation and configuration issue resolution.
• Created ITG (Kintana) Packages, preformed code approval and migrations to instances.