RecruiterPK

Description

GHULAM MUSTAFA BUTT PMP®, OCP®

V – C – 5  / 22, Near MCB Papaosh Nagar Branch. Nazimabad, Karachi.

Cell: +92-309-123-0780

ghulam.butt@gmail.com

Objective:

Organized and results-driven project manager with over 20 years of experience leading cross-functional teams. Looking to offer my skills to a growing corporation with the opportunity to further my career.

Summary:

·        Over Twelve years of experience as Project Manager / Technical Lead.

·        Over Nineteen years of experience in Oracle 10g, 9i, 8x, 7x and 6 Databases, SQL *Plus,  PL/SQL, SQL,  Pro *C, Developer 2000 tools (Forms 9i IDS, 6i, 6, 5, 4.5 and Forms 3, Reports 9i, 6i, 6, 3 and 2.5 and Graphics 2.5) and Windows NT/2000/9x

·        Over Ten years of Experience with Oracle Applications 11i modules such as GL, AP, AR, Cash Management, Fixed Asset, iExpense, Supply Chain Management Modules such as Oracle Inventory, Oracle Order Management, Oracle Purchasing, BOM, Oracle Transportation Manger (OTM), Oracle Process Manufacturing OPM, Advance Pricing, XML/BI Publisher

·        Over one year of functional experience in Oracle Financials modules such as GL, AP, AR, CM, FA, PO, iExpense release 12

·        Over five years of experience with Oracle Business Intelligence Enterprise Edition 11g, 10g (OBIEE), Seible Analytics

·        Hands on experience with Oracle Business Intelligence Applications (OBIA) including HRMS Analytics, Financials Analytics and Supply Chain Analytics

·        Over five years of experience in Design, Development and implementation of reports, answers and dashboards, Warehouse dimentional and relational modeling

·        Hands-on experience with Oracle Application Development Frame Work (ADF) 11g, jDeveloper 11g, Oracle Application Frame work (OAF), Java, JSF, JSP, Weblogics, Webservices

·        Over nine years of Data migration experience between different platforms and databases

·        Eleven Years of Data modeling experience using CASE tools ERWin and Designer 2000

·        Eleven years of experience working with various Unix platforms

·        Two years of experience in Alpha/VMS and VAX/VMS

·        Excellent command of Web Development using Java, Java Script, HTML and Adobe Photo Shop

·        Excellent understanding about EBTax

·        Experience in working with Government projects such as Government of Yukon, Government of New FoundLand and Ministry of Children and Youth Services (MCYS)

·        Extensive experience in cross-platform computer networking

·        Strong international business experience and customer orientation

·        Oracle Certified Professional

Accomplishments

Integration Xperts, Karachi Pakistan                                                   Jan 2021 Todate

Project Manager

Client                                        Habib Bank Ltd. (HBL)

Project Overview:                    HCM Project E Business Suite / Cloud environment

·          Playing a role as Project Manager to support Oracle Applications to implement part of Oracle HRMS in a team of Functional and Technical Analysts

·          Defining requirements and work with relevant cross-functional teams to guarantee smooth, efficient implementation and delivery.

·          Supporting Oversee administrative needs of programs and projects.

Reviewing and analyzing customer service levels using standard reporting tools and highlight discrepancies and errors.

Client                                        Oracle Corporation / Habib Bank Ltd. (HBL)

·          Managing team as a project Manager to implement Enterprise Performance Management (EPM)

·          Successfully went live and implemented Accounts Reconciliation Cloud Service (ARCS)

·          Developed Custom Reports for EPM – ARCS.

Wipro Technologies Limited, Minnesota, USA                                Jan 2018 Aug 2018

Tech-Lead

Client                                        Best Buy, Richfield MN

Environment:                          Oracle E Business Suite release 12 (12.2.6), Oracle HRMS (Human Resources Management System, Oracle SQL Developer, PL/SQL, SQL

Project Overview:                    Best Buy wants to implement Market Hierarchy Project with an additional level in Organization Hierarchy

·        Played a lead role in a team of Techno-Functional Consultants to support Oracle Applications Release 12.2.6 to implement part of Oracle HRMS

·        Led a team of Six Developers and one functional analyst (Offshore)

·        Designed Functional Specifications

·        Designed and Developed EiS Reports integrated with Oracle HRMS R 12 (12.2.6)

Government of New FoundLand, Canada                                      Apr 2017 – Jul 2017

Senior Oracle Applications Architect

Environment:                          Oracle E Business Suite release 12 (12.1.3), Oracle Financial Modules such as Accounts Receivables, Accounts Payables, General Ledger, Oracle Fixed Assets, Cash Management, Oracle Purchasing, Oracle iExpense, PL/SQL, SQL

Project Overview:                    Government of New FounLand implemented Oracle Financials and Supply Chain in 2000 and there was legacy data which was migrated during the implementation and now they wanted to get rid of all the history data to save resources and to get better performance out of the system.

·        Involved in Analysis and Design for the Purge Financial Data from 1998 to 2010.
·        Designed and Developed Complex Custom Programs to provided the keys from E Business Suite to different External Systems

·        Desgined and Developed Custom Program for old data fixes.

Deloitte Consulting, British Columbia, Canada                            Mar 2017 – Apr 2017

Senior OBIEE / OBIA Techno-Functional Consultant

Client                                        Ministry of Finance, BC

Senior OBIA / Oracle Techno-Functional Consultant

Environment:                          Oracle E Business Suite release 12 (12.2.5), Oracle Financial Modules such as Accounts Receivables, Accounts Payables and General Ledger, Oracle Business Intelligence Enterprise Edition (OBIEE) 12c, OBIA 12c, Oracle Financial Analytics, Oracle HR Analytics, Oracle Supply Chain Analytics, PL/SQL, SQL

·        Played key role in a Team of OBIA Techno-functional Consultants.
·        Fixed OBIA security synchronized with eBusiness Suite.
·        Customized Dashboards and Analytics in Receivables Analytics
·        Fixed issues in Repository (rpd).
Air Liquide Quebec, Canada                                                          Oct 2016 – Mar 2017

Senior Oracle Techno-Functional Consultant

Environment:                          Oracle E Business Suite release 12 (12.2.5), Oracle Cloud, Oracle Supply Chain Modules such as Order Management, Inventory, Process Manufacturing, Purchasing, Oracle Financial Modules such as Accounts Receivables, Accounts Payables and General Ledger, Oracle Business Intelligence Enterprise Edition (OBIEE) 12c, Oracle Forms, Oracle Reports, Bi Publisher, PL/Sql and Sql
·        Played a key role in a team of Techno-Functional Consultants to support Oracle Applications Release 12.2.5

·        Sustained Post Go Live Project

·        Designed and Developed Interfaces using PL/SQL

·        Designed and Developed Reports

·        Designed and Developed Complex Forms

·        Designed and Developed Complex Reports using OBIEE

·        Designed and Developed Analytics to suite Business Requirements

·        Troubleshoot and fixed problems in the Repository (.rpd)

·        Migrated Large Data from Legacy System, SAP and People soft

Oracle Corporation, Ontario, Canada                                              May 2016 Sep 2016

Senior Oracle HCM Techno-Functional Consultant

Client                                        Canadian Nuclear Laboratories (CNL)

Environment:                          Oracle E Business Suite release 12 (12.2.4), Oracle Cloud, Oracle HCM Modules such as Oracle Human Resources (HR), Oracle Payroll, Oracle Self-Service Human Resources (SSHR), Oracle Time & Labor (OTL), Oracle Advanced Benefits (OAB)

·        Played a key role in a team of Techno-Functional Consultants for a project implementation of Oracle Applications Release 12.2.4

·        Designed and Developed Interfaces using PL/SQL

·        Migrated Data from People soft.

·        Designed and Developed Complex Report

·        Designed and Developed Organization / Department Hierarchy and populated into a Custom table for future use.

·        Designed and Developed Complex Reports using Bi-Publisher and Discoverer

State Street Corporation, Massachusetts, USA                             Oct 2015 – Feb 2016

Business / Data Analyst

Environment:                          Oracle E Business Suite release 12 (12.1.3), Oracle Financial Modules such as GL, AP, AR, Oracle Project Costing (OPC), Oracle Project Billing (OPB), Oracle Time and Labor (OTL), Oracle Human Resources Management System (OHRMS)

·        Played a key role in a team of Business Analysts for a project implementation of Oracle Applications Release 12

·        Configured Oracle Projects

·        Configured Auto Accounting

·        Created Design Documents such as BR100 and MD50 using AIMS methodologies

·        Interviewed Business Users to collect the Business Requirements

·        Responsible for End to End Business Processes for Expenditures, Allocations, Budgets and Forecasts

·        Worked with the Integration of Oracle Time and Labor (OTL) and Human Resources Management System (HRMS)

Capgemini, Ontario, Canada                                                          Jun 2015 – Sep 2015

Senior Oracle Financials Functional Consultant

Client:                                  Canada Bread, Wholesome Harvest USA / Canada and New York Bakery

Technical Environment:     Oracle E Business Suite release 12 (12.1.3), Oracle Cloud, Oracle Financial Modules such as GL, AP, AR, Oracle Purchasing, Oracle Transportation Management (OTM), Demantra, Oracle Supply Chain modules such as Oracle Inventory,  data bases such as Oracle 11g and 10g, Oracle Application Framework (OAF), Oracle Forms 10g, Oracle Reports 10g, XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Windows XP and HP Unix
·        Played a key role in a team of Functional Analysts for a project implementation of Oracle Applications Release 12

·        Configured Oracle Accounts Receivables

·        Configured Lockbox

·        Developed Design Documents such as BR100 and MD50 using AIMS methodologies

·        Responsible for End to End Receivable Processes such as Order to Cash

·        Responsible for Customer Master Import using Interface.

·        Migrated Data from SAP.

·        Responsible for Transactions Import from Legacy Systems using API and Ongoing Live Transactions using Auto Invoice Interface

Wipro Technologies, Alaska, USA                                                    Sep 2014 – Feb 2015

Senior Oracle Financials Techno-Functional Consultant

Client:                                  Alyeska Pipeline Service Company

Technical Environment:     Oracle E Business Suite release 12 (12.1.3), Oracle Financial Modules such as GL, AP, AR, HRMS, Oracle Projects, Project Billing, Project Accounting and Project costing, Oracle Purchasing, Oracle Supply Chain modules such as Oracle Inventory and Oracle Enterprises Asset Management (EAM),  data bases such as Oracle 11g and 10g, Oracle Application Framework (OAF), Oracle Forms 10g, Oracle Reports 10g, XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Windows XP and HP Unix
·        Played a key role in a senior techno-functional team for a project implementation and Post Go Live Support of Oracle Applications Release 12

·        Resolved issues which are assigned through the tickets.

·        Prepared Technical Documents using AIMS methodologies.

·        Personalized Forms in Oracle Application Framework (OAF)

·        Designed and Developed Reports using Oracle reports 11g and Bi Publisher.

·        Designed and Developed Packages, Procedures and functions using PL/SQL, SQL, Oracle SQL Developer.

·        Worked on detailed processes Procure to Pay (P2P)

·        Designed and Developed Complex Personalization for Oracle Purchase Requisition.

·        Customized and Update of Oracle Project table using API.

CGI Group, Quebec, Canada                                                          Feb 2014 – Jul 2014

Senior Oracle Financials Techno-Functional Consultant

Client:                                  CAE Inc.

Technical Environment:     Oracle Applications release 12 (12.1.3), Oracle Financial Modules such as GL, AP, AR, HRMS, Project Costing, Project Billing, Project Accounting, data bases such as Oracle 11g and 10g, Oracle Forms 10g, Oracle Reports 10g, XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Windows XP and HP Unix
·        Played a key role in a senior techno-functional team for a project implementation of Oracle Applications Release 12 upgrade from 11i

·        Prepared Technical Documents using AIMS and OUM methodologies.

·        Upgraded and Enhanced Check Printing.

·        Designed and Created Web ADI templates for Journals and AR Invoices

·        Designed and Developed Reports using Oracle reports 11g and Bi Publisher.

·        Designed and Developed Packages, Procedures and functions using PL/SQL, SQL, Oracle SQL Developer.

·        Designed and Developed Complex Personalization for AP Invoice.

·        Customized and Update of Oracle Project table using API.

·        Designed and Developed Complex POC Billing extension and Customized Billing Extension in Oracle Project Billing.

·        Performed code tuning and query optimization for the application using Application Tracing Tools.

Ministry of Children and Youth Services                                      Sep 2012 – Jan 2014

Senior Oracle Financials Techno-Functional Consultant

Technical Environment:     Oracle Applications release 12 (12.1.3), Oracle Financial Modules such as GL, AP, AR, Fixed Assets, iExpense, HRMS, data bases such as Oracle 11g and 10g, Oracle Forms 10g, Oracle Reports 10g, XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Windows XP and HP Unix
·        Played a key role in a functional team for a project implementation of Oracle Applications Release 12

·        Prepared BR100 documents for Oracle General Ledger, Oracle Accounts Receivables, Oracle Accounts Payables, Oracle Cash Management, Oracle Fixed Assets and Oracle Purchasing

·        Configured COA

·        Configured multiple Business Groups, Operating Units and Legal Entities in Oracle HRMS to segregate Employees for each Business Group.

·        Configured modules such as Oracle General Ledger, Oracle Account Receivables, Oracle Account Payables,  Oracle iExpense and Oracle Fixed Assets

·        Implemented Oracle Approval Management Engine (AME).

·        Configured Positions Hierarchy for the approval process in Purchasing.

·        Configured Workflow for Employee/Supervisor to approve the Journals and expense reports

·        Designed and Created Web ADI templates for Journals

·        Designed and Created Web ADI templates for AP invoices

·        Designed and Created Web ADI templates for AR Invoices

·        Demonstrated end to end processes such as Procure to Pay (P2P) to the Business Users.

·        Configured and Tested complete Bank Reconciliation

·        Worked with the team for Month-end process for AP and AR and then GL

·        Designed and Developed Reports using Oracle reports 11g and Bi Publisher.

·        Designed and Developed Packages, Procedures and functions using PL/SQL, SQL, Oracle SQL Developer.

·        Helped Senior Analyst to configure EBTax.

·        Performed Code Tuning and Query Optimization.

IBM  Canada                                                                                   Oct 2011 – Sep 2012

Senior Oracle Apps Technical Consultant

Technical Environment:     Oracle Applications release 11i (11.5.10.2), rel 12, Oracle Financial Modules such as GL, AP, AR, Project Accounting, Project Costing, data bases such as Oracle 11g and 10g, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle Business Intelligence Apps (OBIA), OBIA Modules such as Project Costing, Accounts Receivables, Accounts Payables, Human Resources, Oracle Forms 10g, 6i, Oracle Reports 10g, 6i, XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Windows XP and HP Unix
Clinent: Government of NewFoundland, St. John’s                                       Mar 2012 – Sep 2012

·        Played a key role in a development team for a project implementation of Oracle Applications Release 11i.

·        Designed and Developed Reports using Oracle reports 11g and Bi Publisher.

·        Configured Projects, Tasks and Budgets.

·        Designed and developed Reports for Oracle Project Accounting using Oracle Bi Publisher.

·        Designed and developed API`s to import Projects, Tasks and Budgets.

·        Performed code tuning and query optimizations for the application using Application Tracing Tools.

·        Created Unique, Non-unique and Function based Indexes where needed to Optimize the where clause.

·        Designed and Developed Packages, Procedures and functions using PL/SQL, SQL, Oracle SQL Developer.

·        Mentored intermediate developer.

Client: Nasittuq, Ottawa                                                                Oct 2011 – Jan 2012

·        Played a key role in a development team for a project implementation of Oracle Applications Release rel 12.

·        Designed and Developed Repository for OBIEE.

·        Modified/Sync, Added columns mapping with the database for OBIA.

·        Implemented Security (define application roles and assign them privileges) on Web logic Server Level.

·        Designed data and object security on repository level.

·        Enabled Single Sign On (SSO) between Oracle EBS r12 and OBIEE 11g.

·        Customized OBIA HRMS Analytics, Financials Analytics and Supply Chain Analytics.

·        Added columns in physical layer, Business Model and Presentation Layer.

·        Designed and Developed Reports using Oracle reports 11g and Bi Publisher.

·        Configured Projects, Tasks and Budgets.

·        Designed and developed Reports for Oracle Project Accounting using Oracle Bi Publisher.

·        Designed and developed API`s to import Projects, Tasks and Budgets.

·        Performed code tuning and query optimizations for the application using Application Tracing Tools.

·        Created Unique, Non-unique and Function based Indexes where needed to Optimize the where clause.

·        Designed and Developed Packages, Procedures and functions using PL/SQL, SQL, Oracle SQL Developer.

CAE Inc., Montreal, Quebec                                                         Nov 2010 – Sep 2011
Senior Oracle Apps Technical Consultant

Technical Environment:     Oracle Applications release 12, 11i (11.5.10.2), Oracle Financial Modules such as GL, AP, AR, Project Accounting, Project Costing, Supply Chain Management Modules such as Oracle Inventory, Oracle Order Management, Oracle Purchasing, BOM, Oracle Transportation Manger (OTM), Oracle Process Manufacturing OPM, Warehouse Management System (WMS), data bases such as Oracle 11g, 10g and 9i, Oracle Business Intelligence Enterprise Edition 10g (OBIEE), Oracle Discoverer 9.04, Oracle Forms 10g, 6i, Oracle Reports 10g, 6i, , XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Windows XP and HP Unix
·        Played a key role in a development team for a large project implementation of Oracle Applications Release 12.

·        Sustained Already Implemented project in Oracle application 11i.

·        Designed and developed Reports using XML / Bi Publisher.

·        Designed and developed Conversions and interfaces such as Item Cost, Kanban Replenishment, fnd_user and Stock Locators using PL/SQL, SQL and Oracle SQL Developer.

·        Configured Projects, Tasks and Budgets for Oracle Project Accounting.

·        Designed and developed API`s to import Projects, Tasks and Budgets for Oracle Project Accounting.

·        Designed and developed a custom form to print the Bar Code / Labels using Zebra Printers with WMS

·        Worked on the processes such as Procure to Pay (P2P)

·        Designed architecture, designed/developed extensions, interfaces, customizations (CEMLIs)

·        Performed code tuning and query optimizations for the application using Application Tracing Tools.

·        Created Unique, Non-unique and Function based Indexes where needed to Optimize the where clause.

·         Mobile personalisation

·        Customized wms pub API

Canadian Wheat Board, Winnipeg, Manitoba                                  Jul 2007 – Jul 2010
Senior Apps Technical Consultant

Technical Environment:   Oracle Applications 11i (11.5.10.2), Oracle Financial Modules such as GL, AP, AR, Supply Chain Management Modules such as Oracle Inventory, Oracle Order Management, Oracle Purchasing, BOM, Oracle Transportation Manger (OTM), Oracle Process Manufacturing OPM, Advance Pricing, data bases such as Oracle 10g and 9i, Oracle Business Intelligence Enterprise Edition 10g (OBIEE), Oracle Discoverer 9.04, Oracle Forms 6i, Oracle Reports 6i, , XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Quest Software Toad, Windows XP and HP Unix

Company Overview       The Canadian Wheat Board is the marketing agency for over 75,000 farmers who grow wheat, durum wheat and barley in Western Canada. Their role is to market these grains for the best possible price both within Canada and around the world.
Project Details                Supply Chain Transformation (SCT)

The project includes implementation and customization of different Oracle Apps. modules such as Oracle GL, Oracle AP, Oracle AR, Oracle Inventory, Oracle Order Management Oracle Purchasing, BOM, Oracle Transportation Manger (OTM), Oracle Process Manufacturing OPM, Advance Pricing

·        Coordinated/managed Off-shore team in India.

·        Sustained Post Go Live and resolved Issues which were assigned using the tickets

·        Designed and Coordinated with Functional Experts for Technical Overview Section in the Functional Specification Documents.

·        Worked with the functional experts to evaluate and identify functional gaps between the application and business requirements and identify potential solutions.

·        Reviewed Understanding Document prepared by off-shore team in India.

·        Reviewed Technical Designs prepared by off-shore team in India

·        Reviewed Codes written by off-shore team in India using Oracle Forms, Oracle Reports and PL/SQL.

·        Designed and developed Reports using XML / Bi Publisher.

·        Designed and Developed the PL/SQL Package for loading the data from OTM into AR interface tables and AP interface tables.

·        Designed technical solutions to meet business and user requirements.

·        Designed, developed and implemented business reports, Answers and dashboards using OBIEE 10g.

·        Designed data and object security on repository level for OBIEE 10g.

·        I was single point of contact for all the data warehouse issues.

·        Designed and developed Routines to migrate data from legacy system to oracle EBS 11i database.

·        Developed a separate Database with all RICE components which were developed by the offshore developers.

·        Designed Physical, Business Model and Mapping and Presentation.

·        Designed and developed a number of Reports for OTM, OPM and Planning using Discoverer 9.04 and more than 10 reports were complex and coded using SQL and PL/SQL.

·        Designed and developed PL/SQL packages, procedures and functions to code the complexity of reports built in Oracle Discoverer.

·        Troubleshoot and maintained existing base of applications in Production.

·        Converted functional specifications into Technical design specifications by performing necessary analysis and design.

·        Developed code and conducting unit testing of technical solutions.

Shaw Cable Systems Inc. Mississauga, Ontario                           Apr 2006 – Jun 2007

Senior Application Consultant

Technical Environment:   Oracle Applications 11i, 10.7, Oracle Financial Modules such as GL, AP,  AR, Supply Chain Modules such as Inventory, Services, Order Management, Purchasing, BOM, Oracle 9i and 8x, Oracle Forms 6i, 4.5, Oracle Reports 6i, 2.5, XML/BI Publisher, Seible Analytics, Oracle PL/SQL, SQL, SQL *Plus, ERWin, Windows NT, HP Unix, Quest Software Toad

Shaw Cable Systems Inc. is one of the largest Telecommunications Companies in Canada having different line of businesses such as Cable TV, Satellite, Cellular Phones, and Home Phones.

·          Played a key role in the development of a customized module such as Omni Vision. Omni vision is a customized application for tracking integrated with Oracle modules (such as GL, Service, Inventory, Order Entry and Bills of Material)
·          Interviewed client to gather specific functional requirements.
·          Prepared Design documents using Erwin.
·          Prepared Technical Document.
·          Customized codes in the oracle application modules such as Oracle Inventory, Bills of Material and Oracle Service.
·          Registered Customized Forms, Concurrent Programs such as PL/SQL Codes and Host script to Automate batch processes.
·          Designed and developed business reports using Seible Analytics

·          Designed Metadata including Physical Layer, Business Model and Mapping layer and Presentation Layer.

·          Created Reports using Dashboards, Answers and Oracle BI Publisher.

·          Created and modified Descriptive Flex Field to suite the functional requirements.
University Health Network, Toronto, Ontario                               Apr 2005 –  Feb 2006
Senior Analyst

Technical Environment:   Oracle 9x and 8x, Oracle Forms 9i, 6i, Oracle Reports 9i, 6i, C# .NET, Oracle PL/SQL, SQL, SQL *Plus, ERWin, Windows NT, Unix Solaris 10, HP Unix, IBM AIX, Oracle Enterprise Manager Console (OMS), SQL DBA Enterprise Manager, DB Artison, Quest Software Toad

University Health Network is a Union of Three large Hospitals such as Toronto General Hospital, Toronto West Hospital and Princess Margrate Hospital, and supported by Ministry of Health Ontario.

·        Played a key role as a team member development and support of a Number of Health care Applications databases as backend on Oracle, Sybase and Sql Server.

·        Developed database source such as Packages, stored procedures, functions and triggers using PL / SQL and Toad.

·        Performed code tuning and query optimizations for the application.

·        Performed on-call duties on rotation basis.

Munich Re-insurance Company of Canada, Toronto, Ontario     Sep 2003 – Mar 2005

Senior Consultant

Technical Environment:   Oracle 9i, 8i, Oracle Apps. 11i, Oracle GL, Oracle AP, Oracle Forms 6i, Oracle Reports 6i, Oracle PL/SQL, SQL, SQL *Plus 8, ERWin, UNIX Solaris, Windows NT, Quest Software Toad, SQL Programmer,  and TCP/IP

·        Played a key role in development and conversion of customized software COLIS (Commercial Lines Insurance System) and ISYCL (International System of Commercial Lines) and integrated with Oracle Apps 11i modules such as Oracle GL and Oracle AP.

·        Managed various day-to-day activities of insurance and reinsurance business. Working with Business Analysts and end-users to analyze reported problems Coordinated with .NET developers to streamline front-end and back-end integration

·        Performed code tuning and query optimizations for the application

·        Analyzed and Rectified problems reported from the production system

·        Migrated data from the Legacy system using Oracle utility SQL*Loader

·        Developed Unix shell scripts (using korn, bourne and shell)

·        Designed and Developed Input forms and output reports using Oracle Tools such as Forms 6i and Reports 6i

·        Developed database objects such as Packages, stored procedures, functions and triggers using PL / SQL, SQL Programmer and Toad.

·        Designed Physical and logical databases using ERWin. Designed Entity Relationship Diagrams, Physical and logical models and populated data dictionary

·        Prepared business and technical documentation.

Hudson’s Bay Company, Toronto, Ontario                                   Mar 2003 – Jun 2003

Application Consultant

Technical Environment:   Oracle 9i, Oracle Apps 11i (11.5.4), Oracle GL, AIX, Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer, PL/SQL, SQL, SQL *Plus 8, Windows NT, Quest Software Toad and TCP/IP

·        Played key role in the development of additional modules such as Store Financial Application (SFA), Financial Inventory System (FIS).

·        Integrated functions with Oracle application 11i modules such and Oracle GL.

·        Developed procedures, functions and triggers using PL / SQL, Procedure Builder and Toad.

·        Prepared technical documentation.

KATSI Canada Inc., Toronto, Ontario                                            Jan 2003 – Feb 2003

Senior Programmer / Analyst

Technical Environment:   Oracle 8.1.7, PL/SQL, SQL, SQL *Plus 8, Designer 6, Oracle Forms 6, Oracle Reports 6, Windows 2000/XP, TCP/IP

·        Played a key role in the development and maintenance of application systems and databases of Department of Health & Social Services, Yukon Territorial Government. Developed complex queries to meet client search criteria. Designed and developed stored procedures, functions and triggers.  Employed CASE tools such as Designer 2000 for data modeling.

·        As a team member designed and developed an application “Young Offenders Information System” for Government of Yukon.

·        Designed and developed customized forms 6 and reports 6 for client/server environment.

Formedic Communications Inc., Markham, Ontario                      Jul 2000 – Jun 2002

Programmer Analyst

Technical Environment:   Oracle 8.1.6 and 7.3, Oracle Application Server, Java, HTML, PL/SQL, Designer 6i, ERwin3.0, DBA Studio, Oracle Forms 6i, Oracle Reports 6i, SQL *Plus 8. SQL *Loader, VMS, Windows NT/2000, TCP/IP

·        Played a key role in the development and maintenance of application systems and databases of medical personnel and facilities. Developed complex queries to meet client search criteria. Designed and developed stored procedures and triggers.  Employed CASE tools such as Designer 2000 6i, ERWin for data modeling.

·        Converted from Oracle Forms 4.5 to Oracle Forms 6i

·        Designed, developed and implemented customized forms and reports for client/server environment satisfying user requirements. Designed and developed forms and Logical and Physical Data Models using ERWin. Designed reports for Intranet and Internet sites for publishing company policies and business procedures and rules using Oracle Forms 6I, Reports 6i JavaScript and HTML. Configured web server software and authorized web pages for publishing. Installed and Configured Oracle Form Server. Hands-on experience in three-tier systems architecture.

·        Performed product design, development, support and training. Prepared technical documentation.

·        Migrated data from ingres to oracle 8i.

·        Developed various scripts in UNIX/Windows NT for hot/cold backup.

PowerWare Inc.  Karachi, Pakistan                                                Jun 1999 – Jan 2000

Software Engineer/Team Leader

Technical Environment        Oracle 8x, Java, Java Script, HTML, PL/SQL, ERwin3.0, Oracle Forms 6.0, Oracle Reports 6.0, SQL *Plus 8

·        Interviewed clients for all the business requirements. Prepared Business Specification Document (BSD).

·        Designed logical and physical databases. Prepared Entity Relationship Diagrams (ERD), Logical and Physical Data Models using ERWin and Designer 2000.

·        Led a team of 5 Developers, 3 Junior Programmers and 2 Trainees. Analyzed, designed, developed and implemented, Billing Information System for leisure club with more than ten branches.

·        Migrated all the data from flat files to Oracle Tables using SQL *Loader.

·        Analyzed, designed, developed and implemented a Management Information System. The software was designed for a food services corporation. The applications included modules such as Inventory, Sales, Product Costing, Accounts Receivable, Accounts Payable and General Ledger.

Computer Research (Pvt) Ltd. Karachi, Pakistan                        Apr 1994 – May 1999

Sr. Programmer/Analyst

Platform:                      Client/Server, COMPAQ Proliant Server, COMPAQ Prosignia, IBM Server

Languages/Tools         Oracle 6, 7, 8.05, SQL *Plus 3.2, SQL DBA, PL/SQL, SQL *Plus, Erwin3.0, Developer2000 (Forms 4.5, 5, Reports 2.5, 3, Graphics 2.5), Oracle Discoverer, SQL *Forms 3.0, SQL *Report

·        Assessed clients for all the business requirements. Prepared Business Specification Document (BSD).

·        Designed logical and physical databases. Prepared Entity Relationship Diagrams (ERD), Logical and Physical Data Models using ERWin.

·        Led a team of 4 Developers. Analyzed, designed, developed and implemented customized software, Human Resources and Payroll System (HRPRS) for a large security replenishment company.  Developed input forms using Forms, Reports using Reports and Discoverer.

·        Led a team of 3 Developers. Analyzed, designed, developed and implemented an Inventory and Sales System (ISS) for a leading import and distribution company. The application was divided into modules (such as Imports, Sales, Inventory and Bank Reconciliation).

·        Led a team of 3 Developers Analyzed, designed, developed and implemented Sales and Bank System (SBS) for a printing corporation having more than ten different companies and also involving Digital Designing and Composing, Film Making, Plate Making, Production of Printing and Binding. This software was previously designed for Forms 3.0 and SQL *Reports with Oracle 6 as database. Converted the application from character based Forms and Reports to GUI Forms 4.5 and Reports 2.5 and migrated the database from Oracle 6 to Oracle 7.

Education
Degree/Diploma
University/College
Major
Year
Project Management Professional (PMP® )

2022
Oracle Middleware Application Development Framework Training (ADF)
Infusion Business Solutions
Application Development Framework Training (ADF)
2013
Bachelor of Arts degree in Computer Science (Equivalent)
Seattle Pacific University (U.S.A)

2000
UNIX Administration: A Hands-on Introduction
Learning Tree International
UNIX Solaris 10
2005
Oracle Certified Professional

1999
Diploma in Computer Science
Sindh Board of Technical Education
Oracle, Unix, C++, FoxPro, COBOL, BASIC
1994
Bachelor of Science
University of Karachi
Physics, Mathematics, Statistics
1987
References available upon request