Candidates About

 

Umair Tirmizi

ORACLE Business Analyst with an extensive and demonstrable track record within the IT field. Well-versed in mapping customer business process/requirement to Oracle Applications flow, analyzing gaps and designing gap fillers. Good understanding of accounting rules, functions and logic involved in any business and accordingly mapping them to Oracle Apps. Support and QA Analyst experience including troubleshooting and giving effective & efficient resolutions for issues. Strong analytical and problem-solving skills.

 

SUMMARY:

·         Over 6 years of experience as an Oracle Applications R12/11i (E Business Suite) Techno Functional Consultant and Business Analyst with expertise in Oracle Financials modules (GL, AP, AR, IExpense ,FA and CM), Manufacturing Modules(INV, OM and PO), Daily Base Intelligence Payables & Receivables and Approval Management Engine AME

·         Experience in Order to Cash (O2C), Procure to Pay (P2P) business flows

·         Created Test cases from scratch by using Business Functional Requirement Specs, and also responsible for developing, reviewing, coordinating and delivering the Test Strategy and System Test Plan documents and also responsible for creating the test specifications, including test plans and test cases

·         Involved in writing Test Scenarios using Business Requirements

·         Involved in writing Test Planning coverage, Test cases

·         Evaluated the progress and take initiatives to meet the QA testing targets

·         Good-working knowledge in designing documents using AIM Methodologies (MD50, BR.100,MD70, CV40 AND CV70)

·         Excellent knowledge of System Administration and Approval Management Engine Modules

·         Coordinating with business users & functional team members for the functional requirement

·         Experienced in interacting with users, gathering requirements, and drawing up Business Case Scenarios to enable the testing of system setups

·         Knowledge of design and development of conversion programs, interfaces and Trading Community Architecture (TCA) APIs to import data from legacy systems

·         Experienced in loading data through Application Desktop Integrator(ADI)

·         Knowledge in developing and customizing Reports and Forms in Oracle E-Business Suite R12/11i, Oracle 11g/10g/9i ,Oracle Reports/Forms 10g, XML Publisher 5.6.3/5.6.2

·         Involved in development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs

·         Extensively worked on changing reports according to client requirements and optimizing report performance

·         Solely managed activities such as design, development, testing and End-user training

·         Experience in using Oracle tools like SQL Navigator, SQL*Loader, Data Loader, FND LOAD, SQL developer and TOAD

Technical Skills

Application Tools:

UPK3.5, Reports 10g, XML/BI Publisher 5.6.3/5.6.2, Oracle Forms 10g, Workflow Builder, Oracle Enterprise Manager (2.1.0) and Data Loader

Databases & Tools:

Oracle 11g/10g, SQL*PLUS, SQL*Loader and SQL* Developer 

Operating Systems:

Windows 10/8/7/NT/XP/2000/98, UNIX, Linux, MS-DOS

Languages:

SQL, PL/SQL & XML

BI:

XML/BI Publisher

 

Academics

§  Bachelor of Business Administration - Honors Program in Supply Chain Management            

2010-2014

 

 

 

Professional Experience

 

SM Tech Industries

AUG 2015 – PRESENT

Jr. Oracle Functional Analyst

Responsibilities:

§  Processed invoices, purchase orders, sales tax, and credit memos through Oracle software

§  Acts as second line support to the customer

§  Conducts training to the end user on means of operating the implemented system

§  Uploading data sheets with Data loader and ADI

§  Responsible for the Vendor development and New Product Development

§  Involved in developing programs to load suppliers, customers and AP/AR invoices

§   Conducting end user training sessions for system users

§  Integrated various functions of Oracle apps into users system.

§  Ensured proper functioning of supply chain applications under Oracle management.

§  Collaborated with Oracle Support team and business associates to ascertain provision of best solutions.

§  Tested and drafted reports on business practice by instance configurations of Oracle SCM apps and fit-gap analysis.

§  Collected info and analyzed, designed and tested oracle-based systems.

§  Adhered to project standards while creating Oracle effecting strategies and troubleshooting specific issues.

§  Work in Oracle Payables, General Ledger, Receivables and Purchasing.

§  Carried out month-end close responsibilities

§  Presented variance analysis and explanations

§  Prepared balance sheet reconciliations

§  Assisted with special projects as assigned

§  Reconciled bank balances; recorded general ledger entries

§  Reconciled bank account for general expense checks

§  Established and maintained solid business relationships with all levels of management

 

PROJECTS:

                                                                                                       

Dubai Port-World                       

AUG 2014 – JUN 2015

Role: Oracle Techno-Functional Consultant

§  Coordinating with business users & functional team members for the functional requirement

§  Functional testing of all financial modules

§  Provide User Acceptance Trainings

§  Open DFFs in in various modules as per client requirement

§  Involved in developing a program to load Customers through APIs

§  Involved in developing a program to load Suppliers through APIs

§  Involved in developing customized supplier aging report

§  Actively involved in System Validation and Regression Testing on every Patch Release

§  Responsible for closing periods for AP, PO, Inventory, FA, AR & PA during system testing in quarterly releases

§  Involved in customization of several standard reports to serve important business processes very specific to the client. Reports included Purchase Order Detail Report in PO, Invoice on hold report, Vendor, Payments, and analysis reports in AP, and also Customer, receipts, invoice, and adjustment reports in AR using Reports 10g

§  Involved in developing new reports as per requirement

§  Personalized forms as per user requirements

 

Mackinnon Mackenzie & CO. (Dubai Port-World operated)                                                 

JAN 2014 – Mar 2014

ROLE: Implemented Oracle Accounts Payables

§  Involved in developing Analysis of documents (RD 20, RD50), solution design document (BR30) and closed the processes with Gap analysis (BR 10) then converted it to setup documents (BR.100)

§   BR.100 establishing the set-up of the Oracle General Ledger and Oracle Payable

§   (MD.050) for create financials applications functional design for customization

§  (MD.070) for create financials applications technical design for customization

§   Have conducted user trainings and prepared AP.140, AP.150, TA.060 with help of UPK3.5 

§   Contributed in development of reports and interface of Oracle with other applications

§  Involved in developing Customize reports

§  Involved in developing a program to load suppliers

§   Team up with functional team and customer's staff and produce desirable results

§  Building standard user guide for the training for modules
 

P&O Containers (Dubai Port-World operated)                                                                                                     

APR 2014 – JUL2014 

ROLE: Implemented Oracle Accounts Payables

Version: 12.1.3

§  Carried out the Requirement analysis of the client’s business for the implementation of Oracle Accounts Payables

§  Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40)

§  Documented Operation Analysis, Solution Design & User Manuals

§  Conducted gap analysis between delivered functionality and client requirements and recommended solutions

§  Successfully mapped business requirements for FA with minimal customization.

§  Implemented Oracle Accounts Payables before target time

§  Contributed in development of  SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger

§  Providing functional support to users

§  Conducted UAT of the Users

 

Sherazi Tradings

NOV 2013 – DEC 2013

Role: System Reviewer

§  Systems testing

§  Analyzed gaps and suggesting gap fillers

§  Documented projects

 

 

LOTTE CHEMICALS                                                                                                                             

may 2013 – jun 2013

Role: Functional testing and trainings in upgrade from 11i to r12

§  Ran pre & post reports

§  Compiled data

§  Functional Testing

§  Resolved key issues Of Payables and Purchasing Hierarchy

§  Created documents

§  Conducted trainings & UAT

 

 

Bank Al Habib

FEB 2013 – APR 2013

Role: Oracle EBS Support

§  Oracle Financials & SCM Support

§  Resolved issues of key users

§  Responsible for checking system integrity after patches application.  

§  Provided Support for General Ledger and Purchasing modules.

 

SAI (Shaheen Air International)                                                                         

SEP 2012 – JAN 2013

ROLE: End to End Implementation of Oracle Financials

§  Developed Future Process Model (To-be) for clients (BP.080)

§  Involved in developing Analysis of documents (RD 20, RD 50), Solution Design documents (BR 30) and closed processes with Gap analysis (BR 10) then converted it to setup documents (BR.100)

§  Setup FA fully, uploaded & purged the Assets data and prepared the reports.

§  Interacted with users to resolve any issues during the production, development and enhancement phases.

§  Utilized Application Desktop Integrator (ADI) and Data-Loader for FA data loading

§  Setup AR as per requirement of the client with Auto Invoice, Autocash and revenue recognition features

§  Worked in Oracle Cash Management modules to load, import and auto-reconcile bank statement transaction against payments in Accounts Payable (AP)/AR

§  Matched AP Invoices (2-way) & (3-way) to the purchase order in payable modules

§  Trained end-users with Oracle UPK for smooth business activities with Oracle financials in future

 

SEAMS(Shaheen Engineering Aircraft Maintenance Service)        

Oct 2011 – JUL 2012

ROLE: End to End Implementation of Oracle Financials

§  Responsible for end to end implementation of Oracle R12 EBS Financial Modules General Ledger, Accounts Payable, Account Receivables, Fixed Assets, Cash Management and Approval Management Engine.

§  Carried out functional requirements gathering, requirements analysis, gap analysis, functional setups and customizations and testing

§  Involved with study of existing system, preparing the BR100/ Functional (MD50), Technical (MD70) design document and Conversion Data Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables

§  Involved in designing, setup and configuration of Organization structure with chart of accounts, calendar and currency

§  Set up Suppliers, created Purchase requisitions, Purchase orders in Oracle Purchasing for Accounts Payable

§  Handled functional and technical related issues by investigating and applying solution for specific problems

§  Trained end-users with Oracle UPK for smooth business activities with Oracle financials in future

§  Data migration and Go live.

§   Go live and Project closure Sign Off. 

§   Post Implementation Support for Distribution module-one month-Onsite.

§   Post Implementation Support for Distribution module-three month-Offshore.

 

Alina Combine Pharmaceuticals

August 2010-Nov 2010

Implementation of Oracle GL and Oracle Inventory

 

• Project Management including preparation of the project plan; track the closure of each activity against the project plan, quality compliance and audits, steering committee meetings and other activities. 
• Business process study.
• Product Walk through Module wise.
• Documentation of the requirements study as per the AIM Methodology(RD-20 and RD 50) 
• Solution mapping, presentation, documentation of BR 30 and identify the Gap and Record the Gap in the BR-10 Document.
• Product configuration and setup including documentation of BR-100.
• Preparation of MD-50 for the interface and other custom built components
• Key user Training 
• Conducted User Acceptance testing.
• Data migration and Go live. 
• Go live and Project closure Sign Off. 
• Post Implementation Support for inventory and GL module-one month-Onsite.