Summary of Profile:-

• Currently I am working as Oracle Developer / ERP Consultant R12. I have 9 years of experience in Business Analysis/design, developing, managing and Implementing banking applications & Database(MCB Bank-Pak, National Bank Pak & Bank AlBilad)
• Successfully managed a team of 6 developers and business Analyst at MCB Bank Limited in developing/customization of new Modules for existing applications
• Extensive experience in all phases of business analysis and project management from concept through implementation/Setup and support

Professional Certification/Training/Workshops:

• Master in Computer Sciences
• R12 Financials Certified Expert Consultant
• R12 Financials Certified Expert Consultant
• Oracle 9i DBA Certified Professional(OCP)
• Training-Forms Developer 9i & PLSQL
• Completed Online Functional Setup Coaching R12 PO, FA, CM, OM
• Core Banking Globus Training:- Introduction Customer, Accounts, Loans and Deposits, Fund Transfer & Limits ()

Expertise:

• Expertise in functional setup R12 GL, AP, PO, AR, OM, FM, CM and Work flow and Alerts
• Experience in designing, developing/customization, testing and supporting RDBMS based applications, which involves programming with Oracle tools Reports Builder, Forms builder 6i, 10g, and PL/SQL(stored procedures/Functions/triggers/Packages)
• Experience with physical and logical database design, Database Tuning and Backup Recovery (9i,10g)

Professional Experience:

• Confidential,Oracle Developer / ERP Consultant
• Confidential,Oracle Application Team Leader MCB Bank (Dec-05 to May-08)
• System Coordinator / Analyst Programmer MCB Bank Ltd, Pak (Mar-05 to Nov-05)
• Ora- Tech Pak: Senior Software Engineer (May-03 to Apr-04)

Banking Experience: 8+Years:-

• Banking Domain – Finance & Retail Banking
• Banking Systems:

Oracle EBS R12- GL, AP, AR, PO, FA,CM, OM HRMS, Work flow and Alerts
Temenos - T24/Globus, Insight Financial, Insight Risk, CRM-Siebel

Oracle Developer / ERP Consultant
Key responsibilities:

• Responsible for full lifecycle development of Oracle applications including conception, design, development, testing, deployment, and maintenance
• Develop functional design documentation for use in development of business process changes and report creations.
• Participated as key stakeholder in Oracle E-Business Suite R12 implementation
• Responsible for hands-on configuration and Setup of Oracle Financial
• Manage the development and maintenance of Business Process Documents such as BR100 data configuration and setup, functional requirements, Gap Analysis
• Create Users, Responsibilities, Menus, Concurrent programs, Define Value sets, Descriptive flex fields and other system administration jobs
• Coordinate with Oracle support, DBA, Technical consultant and other Functional consultants for implementing bug fixes
• Supervise, support and direct less senior team members during the project
• Monitoring and following up on user training requirements, including providing ERP training on new functionalities

Projects

• Implementation of GL & Payable, Fixed Asset, PO and Cash Management(2009)
• Implementation of FAH(2010)
• Insight Risk Implementation & Integration with GL (2011)
• Insight Financial Implementation & Integration with GL (2012)

• System Coordinator / Analyst Programmer (Mar-05 to Nov-05)
• Oracle Application Team Leader (Dec-05 to May-08)

Key responsibilities:

• Managing the Team of Business Analyst/Developers as a Team Lead
• Responsible for full lifecycle development of Oracle applications including conception, design, development, testing, deployment, and maintenance
• Design, architecting, development and maintenance of Oracle based applications and application database schemas
• Develop/maintain applications and write complex PL/SQL queries, Triggers, Procedures, Functions and Packages
• Create new production environments and conduct user acceptance testing
• Provide instruction and training to users as well as prepare on-line and hard copy documentation of systems and user applications
• Preparing RFP(Request For Proposal) for new System

Projects Successfully Completed at MCB Bank using Oracle Forms 6i/9i/10g:-
Developed end to end Integration module for :-

• General Ledger with Consumer Asset Management system
• ATS (Application Tracking System) & Collateral Management System
• Insurance Financing & Tracker Financing Module
• Integrate Auto Debit of Installments with Core Banking MIBS & SYMBOL
• Loan Enhancement Module & Loan Maturity & Recovery Module

Key responsibilities: (Clients MCB Bank, National Bank, Fatima Group)

• Support/Development for the Consumer Asset Management System(Personal Loan, Auto Financing/Leasing, Mortgage) for MCB Bank & National Bank
• by Creating, Designing Oracle Forms & Developing Reports
• Analyzing needs and customer requirements and create a functional design documents
• Participates in implementation, installation, and testing of Oracle Applications software and Database management in term of Performance and availability
• Develop/maintain applications and write complex PL/SQL queries, Performing Database Tuning, Backup and Recoveries
• Installing Application Server, Report Server and Database Server
• Elicit requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, scenarios, business analysis

Projects Successfully Completed for Ora-Tech:-

• Successful migration of Consumer Assets Management system from Application Server 9i to 10g

Programming / DBMS / Development Tools / Skills:

PL/SQL, SQL PLUS, Java, C++, VC++, VB, ASP, HTML, Java, Java Scripting, Data Structure

RDBMS/DBMS:

Oracle 9i and 10g, SQL Server

Oracle Tools/Utilities:

Sql*Loader, Oracle RMAN, Developer and Toad

Development Tool & Application Server:

Developer 6i, 9i, 10g, Oracle Application Server 9i, 10g

Skills:

MS Project 2003, MS Visio, Rational Rose, Team Explorer, Clear Quest, Software Engineering I&II