Hasan Rizvi
adoz4e@r.postjobfree.com
Status: US Citizen
Clearance Level: Public Trust (C6)
Mr. Rizvi is a highly experienced in Oracle Financial Application, system Analyst, Oracle EBS Applications 10.7, 11i, and R12.2.10. Mr. Rizvi has extensive experience with General Ledger, Account Payable, Account Receivable, Purchase Order and Fixed assets modules, and reporting tools. Have implemented four(4) and upgraded five(5) Oracle EBS Application system have strong accounting knowledge and system integration. Supported EBS Tax, Taxware system with integration of EBS Payable modules and Receivable modules.
Qualifications Summary:
Experience in setup and testing skills of the Oracle Federal Financials modules GL, AP, PO, AR, FA, PA, and PA costing/ Billing.
Accounting education and strong accounting skills: Understand accounting jargon, requirements.
Extensive experience in Oracle Discoverer v3, v4i to 11g Plus Administration, Desktop & Viewer
Extensive experience in Federal Admin (FV) business process flow functionality
Extensive experience in Project Accounting Costing and Billing
Broad exposure to support Inter-Agency Agreement (IAA)
Extensive experience in helping the Budget Load and Budget Distribute
Extensive experience in Cash/Funds Management and Execution
Extensive experience in setting up Bank for suppliers and for reconciliation of monthly activities.
Familiar with structured design and coding in batch and real-time environments
Strong skills in upgrade and implementation of Oracle Application 10.7 to 11.5.10 (11i) and R12.2.10
Extensive experience in setup and configuration for new deployments of Oracle Financials
Extensive experience in gathering requirements and preparing Functional Specs documentation.
Extensive experience in creating Setup Documentation BR100 for GL, AP, AR, FA, PO and PA
Extensive experience in setting up Concurrent Program, Value Set, Form Personalization.
Extensive experience in integration of in Contract Life Cycle Management (CLM).
Extensive experience in GTAS processing and data validation / as per Treasury provided guide
Extensive experience in validating month-end closing (MEC) and year-end closing (YEC)
Extensive experience in supported O&M and implemented enhancements of Interagency Agreements
highly experienced in SQL, PL/SQL, and UNIX shell script Extensive experience with Oracle Financials Federal Projects
Extensive experience managing Change Management as per audit requirements
Extensive experience with FND Objects (AOL), Responsibilities, Menus, and Functions
Extensive experience in managing Sarbanes Oxley (SOX) and other compliance legislations for segregation of duties (SOD) and user responsibilities
EDUCATION
B.S. in Business Administration and Accounting 1988
CERTIFICATIONs AND TRAINING:
Oracle Certified Expert (OCE) Consultant: E-Business Suite R12 Financials, Payables
Extending Oracle Applications Using Oracle Forms and Reports
Developing Oracle Web Applications Using PL/SQL and HTML
Project Management Basics, Oracle Education
Oracle Lease Management, Oracle Education
Extending Oracle Applications using OA Framework
Oracle Release 11i Financial Applications
R12: Oracle Purchasing Functional Overview
R12: Oracle Purchasing Technical Overview
R12: Oracle Accounts Payables Fundamentals
R12 E-Business Essentials
BPEL and SOA, Oracle Education
R12 Oracle Order Management Fundamentals
R12 Oracle General Ledger Management Fundamentals
R12: Oracle Receivables Management Fundamentals
R12: Oracle Sub Ledger Accounting Fundamentals
Project Management Fundamental
Oracle Database, Oracle Developers and Visual Basic 5 from Neuware Technology
HP UX 10.20 System Administrator from Hewlett Packard Co.
Oracle PL/SQL, Forms 4.5, 6i and Reports 2.5, 6i from Oracle Education
Oracle Discoverer Administration 4i Plus Oracle Education
Functional Skills
Technical Skills
Business Analysis
Technical Analyst
Team Leadership
Team Leadership
Requirement and Gap Analysis
Customization, enhancement and O&M Support
Application module configuration
SQL, PL/SQL, UNIX, LINUX and shells Scripting
Production Support (O&M)
OBIEE, Toad, SQL Devl, Discoverer,
Function Specs (AIM) / BR100 (Configuration doc)
Technical Specs (AIM)
Configuration of CLM BR100
Customization of CLM IDV documents
Application Implementation / Upgrade
Package, Procedure, Trigger, APIs
EXPERIENCE HISTORY
Client: PBGC Feb 2021 to Present
Oracle Financials (EBS) System Analyst
Environment: Oracle 19C Financials Application (EBS) Upgrade R12.1.3 to R12.2.10
Providing O&M support for GL, AP, AR, PO, FV, and Budget.
Monitor User Created issue ticket through Service now and their priority, and worked on timely manner.
Develop functional documents for custom enhancement for AP and GL interfaces
Work with Team for full fill requirement of SCR and Tickets.
Validate Month End Closing activity and reconcile transactions.
Perform Year End activity and documented, reconcile commitment transaction and balance.
Interfaced budge, upload Budget, distribution budget (Allotment, Appropriation, Apportionment), Budget Approval, Accounting validation, reconciliation of Journals entries.
Resolved WEBADI issue on daily basis, reconcile Journal entries.
Developed G-Invoice Solution Overview.
Worked with Oracle Support created SRs
Developed AME setup document for Manual Journal Entry approval
Validated new Payment format (PAM) and tested Payment and Payment outbound Treasury files.
Providing support for upgrade from R12.1.3 to R12.2.10, Analyzing new feature and changed/absolute.
Modified budget interface document and setup new fund to complete user requirement.
Developed Budget execution enhance training material for User training.
Modified Subledger Accounting (SLA) setup to enhance Payable accounting for Treasury,
JLT, JLD, MS, ADR, AAD and assign to SLAM.
Monitor and reconciled inbound and out bound interfaces on daily basis.
Developed document and explained new feature of R12.2.10
Developed test plan as per client approved template.
Modified BR100 for SLA enhancement for Budget transaction for new fund.
Developed required document to present client.
Developed Test script, and perform testing for GL, AP, PO, Suppliers (TCA), and FV
Developed test script in Quality Center (HPQC) tool
Perform SIT test and compare data from existing R12.1.3 with R12.2.10
Provide support for UAT test, and training for new feature
Performed monthly release (SCR) SIT test and provide support for UAT test, prepared approval document and presented to client for approval
Client: Department of Labor July 2020 to Feb 2021
Oracle Financials System Analyst
Environment: Oracle 19C, Oracle Federal Financials Upgrade R12.1.3 to R12.2.9
Providing support for upgrade from R12.1.3 to R12.2.9, Analyzing new feature and changed/absolute objects in post upgrade R12.2.9
Developing document for AME Journal Approval functionality in R12.2.9
Developing document for Project accounting costing and billing new feature, new form introduce in R12.2.9 for sub-element for inventory cost calculation.
Developing document for new feature of Aset life Management (ALM) in R12.2.9
Developed document BR100 for Financial Accounting HUB (FAH)
Resolving GDF issue on AP Invoice Distribution form, After upgrade GDF is displaying
Resoving issue for Project Accounting Costing is sync with formula after upgrade R12.2.9
Client: National Institute of Health (NIH/NBS) March 2018 to Present
Oracle Financials System Analyst
Environment: Oracle 12g, Oracle Financials R12 programs
Provided Production support, analyzed current setups and interfaces for payable and General Ledger
Monitor user created ticket status, managing meeting and assigning work withing Functional team members. Close monitoring day by day production issue and on going projects to meet go live date.
Provided requirement analysis, processing review, configuration, development documentation, and implementing services and system enhancements within a shared service Oracle Financial R12 environment
Providing O&M support to NBS for Oracle Financials Application vs 12.2.3 for GL, AR, AP, PO, PA, FA.
Identifying and documenting requirements, working with users, and existing documentation
Reviewing existing business processes and Oracle configurations to determine the best approach for design and process improvements for GL, AP, AR and PA
Providing support for Project Accounting Costing and Billing, reconcile revenue recognition, and resolve any issue in cost, revenue, and billing.
Created a document and demonstrated functionality to users.
Setup EBS TAX for Payable suppliers.
Provide support for Project Accounting, Fund, Task and Treasury Schedule Number
Provide support for Project Accounting Costing, Billing, and revenue recognition.
Completed setup for project expenditure type and task
Recommend standard functionality to minimize extensions
I designed documentation for requirements, configuration, and testing for the custom interface.
Supporting Fund Management and Treasury related transactions and year-end activities
I supported the upload budget and distribution of budgets.
Designing documents, developing custom interface (CEMLI) for bulk project (PA) closing,
Supporting IAA, Integration and Year-End Closing for IAA
I supported year-end, for uploading funds and creating zero-dollar initialization for next BFY.
Extensive experience in validating month-end closing (MEC) and year-end closing (YEC) for GL, AR, GL, PO, PA and custom modules
Coordinating CRs and incident tickets among the team members.
Conducting daily standing, weekly meetings, agendas, and minutes.
Resolving inventory and account receivable issues (O2C)
i360 Technologies, Inc. June 2016 to March 2018
Client: Department of Interior (IBC Supporting DHS)
Environment: Oracle 11g, Oracle Financials R12,7 programs
I supported Oracle Financials by providing technical and functional Management expertise to clients.
I performed an analysis of existing financial and procurement data to determine readiness for conversion to Oracle.
Identified and documented requirements by facilitating work sessions with users
Identified and documented gaps within existing configurations as they relate to functional and technical requirements
Implemented and supported Oracle Federal Financials R12, with an emphasis on technical and functional analysis, solution development, implementation, and problem resolutions
Completed BR100 configuration documents for AR and AP
Completed technical development using Tool for Oracle Application Developers (TOAD), PL/SQL, SQL, Load scripts, and UNIX scripts.
I completed the implementation of Contract Life Cycle Management (CLM) configuration, customization, and production support.
I created several OBIA reports and supported existing report issues.
Client: Federal Aviation Administration (FAA) - Oklahoma, OK
Environment: Oracle Federal Financials R12 programs
Implemented the EDI Gateway and supported Oracle Federal Financials R12, with an emphasis on functional manager.
Provided requirement analysis, processed review and configuration and development documentations, and implemented services and system enhancements within a shared service Oracle Federal Financial R12 environment
Provided solution recommendations for development, implementation, and customization of invoice approval workflow process.
Supported multiple Agile scrum teams using SAFe methodologies
VIP Consulting Sept 2011 – May 2016
Client: Department of Education (DOE)
Oracle Financials System Analyst
Environment: Oracle 11g, Oracle Financials APPS 11.5.10.2 upgrade R12.2.4, PL/SQL, SQL*PLUS, Windows Vista, NT, UNIX AIX RS6000 (IBM), LINUX.
I provided O&M support for Federal Financial Application modules.
Provided support for Project Accounting, Fund, Task, and Treasury Schedule Number
Worked with technical and support teammates to ensure consistency and ease of maintenance
Resolved production day by day issues for GL, AP, PO, CM, IPROC AR
Completed and designed documents for custom interface and for Payable invoices
Resolved production issues for Cash Management, Encumbrance Accounting, and Advanced Collections
Configured payment process request (PPR) template, payment attributes, and processing
Resolved SLA issues to generate Payable trail balance report
Developed custom interface for Guarantor invoice payment portfolio by Treasury approval
Developed MD075 functional and technical designs using AIM and built the interface for payable inbound and outbound EDI interface
Designed and developed conversions specs and coded stored package for AR conversion
Gathered requirements and drafted design documents and developed custom codes for servicer interface.
Provided support for Project Accounting costing for time & labor reconcile revenue and billing
Extensive experience in GTAS processing and data validation/reporting
Extensive experience in validating month-end closing (MEC) and year-end closing (YEC)
Managed production release activities every month
Performed forms personalization for payable invoices
Developed the reconciliation process to reconcile overnight data with Legacy System
Designed and developed the interface for inventory and shipments
Designed and developed in transit inventory reconciliation processes
Developed upgrade strategy and gap analysis documents to upgrade from 11.5.10 to R12
Developed TCA and BANK documents to meet business processes
Reviewed custom and COTS programs for upgrade of R12
Modified custom interfaces to meet R12 requirements
Modified custom views to meet R12 requirements
Provided requirement analysis, processed review and configuration and development documentations, and implemented services and system enhancements within a shared service Oracle Federal Financial R12 environment
Comcast Cable April 2009 – Sept 2011
Oracle Financials System Analyst
Environment: Oracle 10g, Oracle Financials APPS 11.5.10.2, R12.1.3 PL/SQL, SQL*PLUS
Windows XP, NT, UNIX AIX RS6000 (IBM)
Provided production support, resolved day to day issues for AP, GL, CM, OM, PA Costing/Billing, and IPROC
Developed functional and technical designs using AIM and built the inbound and outbound EDI interfaces for payables
Reviewed existing business processes and Oracle configurations to determine best approach for design and process improvements
Created prototype and demonstrated functionality to users. Recommend standard functionality to minimize extensions
Prepared project documentation for requirements, design, configuration, and testing
Assisted in preparing work tasks and schedule
Setup PPR for accounts payable payment
Developed and designed the inbound payable invoice EDI interface from XIGN
Developed and designed reconciliation logic for inbound payables EDI invoices
Developed vendors and reconciliations
Developed custom report BI Publisher for AP, AR, INV and OM
Developed production handbook and training materials for Advance Collections
Developed outbound invoice status to XIGN portal
Developed BR010 Analyze Gaps from 11.5.10 to R12.1.3 for Custom codes
Prepared reconciliation process for XIGN portal suppliers with TCA
Created MD050 functional specs for outbound EDI interface for AP Invoices to XIGN portal
Resolved production issues after upgrade to R12
Oracle Corporation Oct 2007 – April 2009
Principal Consultant
Environment: Oracle 11g, Oracle Financials Supply Chain APPS R12.1.3 PL/SQL, SQL*PLUS
And UNIX
Client: US Marine Corps (USMC) Apr 2008 to Feb 2009
Oracle Manufacturing – Order Management, Shipping, and Inventory: Technical Manager for large implementation projects. Designed and developed interfaces to convert interface Legacy Systems data to Oracle Inventory and Order Management Applications. Designed and developed solutions to integrate Web Order Capture solutions to Oracle Order Management using Order Import API and Web Methods tools.
Provided requirement analysis, processed review and configuration and development documentation, and implemented services and system enhancements within a shared service Oracle Federal Financial R12 environment
Customized BOM interface to create a new instance for the master items
Custom Extensions: Extensions included a wide range of interfaces and EDI transactions between third party applications for inbound and outbound orders and shipment confirmations
Client: US Social Security Administration (SSA) Oct 2007 to Apr 2008
Oracle Federal Financial Application Functional Manager
Oracle General Ledger: Provided production support, gathered business requirements definition, developed key business flows, and completed map and gap analysis and implementation of multiple custom extensions. Designed, built and implemented multiple data-conversions and interfaces for Oracle General Ledger.
Oracle Accounts Payable: Provided production support, developed custom inbound and outbound EDI interfaces. I designed and built multiple extensions for Accounts Payable.
Developed IPAC process and design documents for Payments
Developed design documents for i-Procurement
Accounts Receivable: Provided production support, developed extensions and reports
Developed upgrade strategy and gap documents to upgrade from 11.5.10 to R12.1.3
Reviewed custom and COTS programs for the upgrade to R12
Kyocera Mitta America Inc. April 2004 – Sept 2007
Oracle Financials Functional SME
Environment: Oracle 9.0.2, Oracle Financials 11.5.9, PLSQL, SQL *PLUS,
Windows xx, UNIX AIX RS6000 (IBM)
Provided production support for day to day issues for GL, AR, AP, OM, INV, FA, PA, PO and HRM
Provided production support, resolved day to day issues for AP, GL, CM, OM, PA Costing/Billing, and IPROC
Developed functional and technical design using AIM, built the inbound and outbound EDI interfaces for payables
Reviewed existing business processes and Oracle configurations to determine best approach for
design and process improvements
Prototyped and demonstrated functionality to users. Recommend standard functionality to minimize extensions
Developed user training manuals, provided classroom and desk training
Developed user manual with screenshots for AP, AR, GL, CM, PO, OM, HRM, and INV
Independent Consultant -- ERP Consultant/ Lead March 2003 - April 2004
Client: US Department of Defense (DOD) through VTEC Systems
Developed strategy to upgrade Oracle Financials 11.5.4 to 11.5.9
Client: Premcor Refinery through MISI Company (8/03-3/04)
Upgraded Oracle Financials 11.5.4 to 11.5.9
Client: Cablevision through Solomon Page Group (7/03-8/03)
Client: US Department of Energy (DOE) through ISIS Technologies Inc. (3/03-6/03)
Wakefern Food Corporation Apr 2000 – March 2003
Systems Analyst
Environment: Oracle 8.1.7, Oracle Financials APPS 10.7NC, 11.5.7 (11i), PL/SQL, SQL*PLUS Windows xx, UNIX UX 9000(HP), UNIX AIX RS6000 (IBM)
Upgrade 11.5.7 to 11.5.9
FWA Corporations Morganville Feb 1997 to Apr 2000
Client: Screaming Media.com Inc.
Environment: Oracle 8.0.5, Oracle Financials Apps 11i, PL / SQL, SQL Plus
UNIX HP, Windows NT, Designer 2000
Implementation configuration
Client: AT&T Solutions
Environment: Oracle 7.3.4, 8.0.5 Oracle Financials Apps. 10.7 SC, Developer 2000, SQL,
PL/SQL, SQL*PLUS, UNIX HP UX & NCR.
Upgrade from 10.7 to 11.5.7
Bank Bumiputra July 1992 – Jan 1997
Application Developer
Environment: Oracle 7.1.6, Developer 2000, SQL, PL/SQL, SQL*PLUS, UNIX HP UX
Bank Saderat Sept 1988 – July 1992
IT Officer
Environment: IBM AS400, SWIFT, MCI Commdesk