Munir Muhammad

Cell: 302-***-****; Home: 302-***-****

Email: acwpzi@r.postjobfree.com

Career Objective

To obtain a contractual/full time position as an Oracle PL SQL / ETL / Database Developer where skills obtained from work and professional work can be utilized

Highlights

Overall 15+ Years of experience in Information Technology

Experienced Software developer in the design and development of high quality business applications using Oracle technologies

Eight years extensive experience in Oracle PL/SQL development (Packages, Stored Procedures, Functions and Triggers) in accordance with coding standards

Two Years’ experience in Database Administration with Oracle and SQL Server

One Year experience in Data Modeling and System Designing

Worked on projects involving System Studies, Analysis, Design, Coding, Debugging, Testing and Implementation of Business Application Software

Strong knowledge in the ETL (Extract, Transform and Load) of data into a data warehouse and OLTP/OLAP systems

Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing

Expertise in using Stored Procedures, Triggers, Constraints, Oracle Packages, Shell Scripting, MS Access, MS Office, MS Visio, VBScript and Crystal Reports

Proficient in Databases Conversions, Migration Application Tuning, Environment Setups, Security Backup, Restore, Indexes, ETL, Portal, Oracle Application Server 9iAS, Oracle HTML DB V1.6, UNIX, LINUX, SQL Loader, TOAD, FTP, Data warehouse and End-User support

Excellent experience in Tuning, Performance and Optimization of queries.

Extensive experience working on Waterfall and an Agile development environment.

Extensive experience in high volume of data processing and fast paced database environments

Worked in close cooperation with project managers and other team members

Installation, configuration and deployment experience of Oracle10g and 10g Application Server

Worked independently and part of a group, to deliver under pressure and tight schedules

Excellent Problem Solver, Committed to Work, Good Team Player and Target Oriented

Technical Skills

Databases: Oracle RDBMS 12c, 11g, 10g, 9i, 8i, 8x, 7x, 6x and SQL Server 6x, 7x, 2000

Designing Tools: Designer 2000, Erwin, ER Studio, Toad Data Analyst

Development Tools: Developer 11g, 6i, APEX, IDS 9i, Discoverer, Designer 2000, Visual Basic

Languages: COBOL, RPG, FoxPro, HTML, ASP, JAVA, SQL, PL/SQL

Operating Systems: HP UNIX, LINUX, AIX, SUN Solaris, Windows NT, Windows 2000

Hardware: IBM RISC System 6000, SUN Solaris, HP, Compaq

Character Tools: SQL PLUS, Server Manager, RMAN, SQL Loader, Export/Import, Partitioning

GUI Tools: Oracle Enterprise Manager, SQL Server Enterprise Manager, Data Stage, Crystal Report, Microsoft Project, Erwin, DB Artisan, Quest Software, Toad and Humming Bird, SDLC

Appreciation

Certificate of Merit - Over all first prize in Second Software Exhibition from PETROMAN

Appreciation Certificate from Computer Society for taking Participation in National Conference on Information Technology held on September 1997

Education

Master of Business Administration

Two Years Advanced Diploma in Computer Sciences

Diploma in Oracle 9i, SUN Solaris V9 and E-Commerce

Professional Experience

JP Morgan Chase, Wilmington Delaware, USA

Sr. Database Developer / PL SQL Developer August 2014- To-Date

JPMorgan Chase & Co. is an American multinational banking and financial services holding company. It is the largest bank in the United States, with total assets of US$2.515 trillion. It is a major provider of financial services and according to Forbes magazine is the world's third largest public company based on a composite ranking. The hedge fund unit of JPMorgan Chase is the second largest hedge fund in the United States.

I am working as a senior database developer to support ongoing projects in Card Services to support different lines of business including Oracle E-Business Suit.

Role:

Supporting lot of applications in the Card Services.

Involved in the tech refresh project for 5 applications by using Linux, Oracle, Control-M, batch servers and implemented successfully.

Working closely with business and different groups to resolve the issues.

Involved in database development by creating Oracle PL/SQL Packages, Stored Procedures, Functions and Database Triggers.

Rewrite lot of applications code to improve the performance of the query.

Involved to Monitor Control-M jobs & create Oracle Concurrent jobs and make schedule.

Involved to tune Discoverer Reports and Apex Application.

Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support.

Worked with the Solutions Architect to maintain technical documentation for DW design (Star Schema and Snowflake Schema, ETL, DW).

Involved in designing the logical and physical model of database objects.

Extensively used PL/SQL tables, analytical functions, cursors and exception handling.

Created high level detailed design documents. Involved in Gathered Requirements Technical Documentation, Unit testing and Integration Testing.

Involved in production support and On-call.

Worked closely with the team members, trained them to maintain development standards recommended by Oracle.

Provide technical / programming support in developing various business solutions.

Excellent working relationships with application teams and users in the design, development, tuning and problem resolution of database and applications.

Efficiently used Metalink in order to create service requests – SRs and bug fixes.

Experience in designing the data modelling and dimensional modelling.

Environment: Oracle EBS Rel. 12, Oracle Ver. 11g, UNIX Servers, Linux, Windows environment, PL/SQL, SQL Developer, Toad, Teradata, Discoverer Reports, Oracle Concurrent Manger, Eclipse, SVN, Control-M, Batch Servers etc.

Department of Correction, State of Delaware

Sr. Oracle Developer May 2014 – July 2014

CNT InfoTech provides services that include Application System Development, Client/Server Programming, Project Management Function, Data Warehousing, Network Design, Middleware Functionality, Package Selection, Training and Implementation Services, Outsourcing of Computer Related Functions and Maintenance Services. CNT Infotech is providing services for IT solution deliver to Department of Correction, State of Delaware. The State Department has different Software Application modules running on LINUX environment with Oracle 11g Database, 11g Application Server and Oracle 11g Developer Suit.

This was a short term project for 3 months with the client State of Delaware.

Role:

Involve to enhancement of the project for Offender management system application.

Involved in writing PL/SQL coding to generate notifications and case notes as part of the application development.

Involved in conversion of data from one platform to another platform.

Responsible for maintaining and implementing Development Standards.

Rewrite applications code to improve the performance of the queries.

Use TOAD for database design, changes, generate new queries, format and tune the SQL.

Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support.

Environment: Oracle 11g, Toad, Oracle Forms V5, Oracle Developer Suit 10g, 10g Application Server, SQL, PL/SQL, Oracle Database 10g, WebUtil, J2EE, Jar Files, Windows XP, LINUX

Barclays Bank, Wilmington Delaware, USA

Sr. Data Warehouse Developer / ETL Developer August 2012- April, 2014

Barclaycard US is a member of Barclay’s group of Barclays Capital, Barclays Wealth, Barclays Commercial, offering world-class solutions to various segment partners. Service partners include many clients like Bank of Hawaii, LL. Bean, B.J’s, Barnes and Nobles, Harvard Master card, Sears. The projects primarily involved the use of Barclay’s in-house customized Framework to migrate the data from DB to STG and further to different layers like SRC, ODS, ADS and DMA and finally to main legacy data warehouse to support different lines of business. System maintained accounts of all the customers and implemented a solution for providing standardized Accounting Reports and automates the process of providing the data to business without manual intervention.

Role:

Involved in load data from File to Stage and different layers like Source, ODS, ADS and DMA and finally to main legacy data warehouse to support different lines of business.

Involved in database development by creating Oracle PL/SQL Packages, Stored Procedures, Functions and Database Triggers.

For ETL worked on documenting Transformations and creating Mapping documents using OBIA Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

Rewrite lot of applications code to improve the performance of the query.

Extensive Knowledge and working of Bulk Collect for data retrieval and data loading.

Create and maintain Shell scripts to run Oracle Stored Procedures and Packages.

Use TOAD for database design, changes, generate new queries, format and tune the SQL.

Extensively used the advanced features of PL/SQL like Analytical functions, Performance hints, Subtypes, PLSQL Records, PLSQL Tables, Bulk Collect and Dynamic SQL.

Involved in Tuning, Performance, Optimization of queries and standardization of the code.

Involved in designing the logical and physical model of database objects using Toad.

Extensively used PL/SQL tables, cursors and exception handling.

Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support.

Involved in integrating data from disparate sources into a data warehouse using ETL and applied analytical/BI skills to develop existing business reports, thus reducing the time to generate these reports manually by doing complete automation.

Created database links to access data from remote databases.

Involved in conversion of data from one platform to another platform.

Created high level detailed design documents. Involved in Gathered Requirements Technical Documentation, Unit testing and Integration Testing.

Accomplishments:

Successfully Migrated 7 years of data for Barclay’s internal project, inserted around Eight hundred and eleven millions records successfully.

Successfully Migrated 5 years data to monthly snapshots from daily snapshots.

Tune the long running package to reduce time from 46 hours to 6 hours.

Successfully Migrated 10 years of data for another Barclay’s internal project, inserted around three hundred and sixty eight millions records successfully.

Drop database objects and its dependent objects to free up 1 TB space.

Dropped around 1800 views and synonyms which are invalid or greater than last 60 days and enhancement on the existing procedure and package to add drop view functionality in the main common package and free up 350 GB space.

Department of Correction, State of Delaware

Sr. PL/SQL Developer / Data Analyst Jul 2005 – August 2012

CNT InfoTech provides services that include Application System Development, Client/Server Programming, Project Management Function, Data Warehousing, Network Design, Middleware Functionality, Package Selection, Training and Implementation Services, Outsourcing of Computer Related Functions and Maintenance Services. CNT Infotech is providing services for IT solution deliver to Department of Correction, State of Delaware. The State Department has different Software Application modules running on LINUX environment with Oracle 11g Database, 11g Application Server and Oracle 11g Developer Suit.

I was working with the client State of Delaware during this period.

Role:

Develop and use server coded objects like stored Procedures, Functions, Packages and Database triggers.

Generate new queries, reports and regenerate the graphs.

Involved in designing the logical and physical model of database objects using Toad and Oracle Designer.

Normalization of the Data Models for the applications.

Rewrite lot of applications code to improve the performance of the query.

Use TOAD for database design, changes, generate new queries, format and tune the SQL

Involve Oracle web development tools, functional design, coding, testing and documentation.

Involved in the process of migration from Oracle Forms 5 and Reports to Oracle Developer Suit 10g being upgraded to be web deployed J2EE using Oracle 10gAS as part of the Oracle 10g Conversion project on the LINUX environment.

Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support.

Involved in conversion of data from one platform to another platform

Used Database trigger for making history of insertion, updating and all kind of Audit routines.

Responsible for maintaining and implementing Development Standards

Involved in the analysis, design, development, customization, testing and implementation of the system.

Environment: Oracle 10g, Toad, Oracle Forms V5, Oracle Developer Suit 10g, 10g Application Server, SQL, PL/SQL, Oracle Database 10g, WebUtil, J2EE, Jar Files, Windows XP, LINUX

City of Edmonton, Edmonton, AB, Canada

Oracle Developer Oct 2004 – Apr 2005

The City of Edmonton provides a variety of municipal programs and services. I was working with City of Edmonton at the Emergency Response Department (ERD) is reengineering the current documentation of patient care for the Emergency Medical Services (EMS). This package application, in conjunction with existing systems, will provide the key documentation and reporting functions. It will be actively used to support functions critical to the business mandate of documenting patient encounters. This application is used for various functions including maintaining information on events, personnel, scheduling and roster, fire investigations, patient care and more.

Role:

This application developed on Oracle 8i database with Developer 2000 Version 6i

My job responsibility was being upgraded to be web deployed J2EE using Oracle 10gAS as part of the Oracle 10g Conversion project

Designed and developed server coded objects like stored procedures, packages, triggers extensively using advanced features and thus incorporating the advanced functionality

Involved in the conversion of over 150 Reports and 45 Forms using Oracle Developer 2000

I had led the upgrade process of Oracle Forms and Reports Version 6i to 10g including the setup of the Oracle 10g Application Server and Oracle HTML DB V1.6 on Oracle Development Environment

Environment: Developer 2000 V6i, Oracle Developer Suit 10g, 10g Application server, SQL, PL/SQL, Oracle RDBMS V9i, Toad, OLE, WebUtil, J2EE, Jar Files, Windows 2000, Windows XP

Netcom, Toronto, ON, Canada

Oracle Database Developer Apr 2003 – Aug 2004

Netcom is a managed services provider that assembles, manages and continuously innovate customized solutions for the clients. I was working as an Oracle Consultant for different clients and responsible for the mission critical Oracle environments, development, deployment, databases, applications and enterprise infrastructure.

Role:

Responsible for understanding the customer requirement analysis, design, development and implementation of the system

Involved in designing the logical and physical model of database objects using ER-Win

Normalization of the Data Models for the applications

Involved in Migration of Databases from One version to another version

Worked with Oracle Enterprise Manager, Toad and DB Artisan

Designed and developed stored procedures/packages/triggers

Involved in performance fine-tuning of the queries/report using PL/SQL and SQL Plus

Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support

Worked with Parallel Extender for Parallel Processing to improve job performance while working with bulk data sources. Worked with most ofthe parallel stages applying different partitioning techniques.

Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL

Involved in the design and development of Forms and Reports using Developer2000

Created Form through Developer 2000 templates as for Form design using Visual attributes, Property Classes, Alters, Messages, Object groups and Tool bars

Environment: Developer 2000 V6i, Discoverer, SQL, PL/SQL, Oracle RDBMS V9i, Designer 2000, Oracle Enterprise Manager, Management Server, Oracle Tuning Pack, Toad, UNIX, Windows 2000

Koni Amri Tech Services Inc. Toronto, ON, Canada

Oracle Developer Jan 2003 – Mar 2003

KATSI Canada is in the business of software development and consulting services for many years and specialized in I.T consulting services. Working as a consultant to provide technical support and consulting services to the various assignments. I was playing a key role in the development and maintenance of application systems and databases of Department of Health and Social Services, Yukon Territorial Government.

Role:

Actively involve in Analysis and Design using Developer 2000 V6i, Oracle RDBMS 9i and Designer 2000

Involved in the normalization of the Data Models for the application

Designing and developing customized Oracle Forms and Oracle Reports for Client/Server environment

Creation of PL/SQL Functions, Cursors, Packages, Stored procedures. Database triggers

Involve in Tuning, Performance, Optimization of queries and standardization of the code

Responsible for providing connectivity using TCP/IP, SQL Net

Used PL/SQL table to avoid mutating problem in database trigger

Used Database trigger for making history of insertion, updating and all kind of Audit routines

Involved in performance fine-tuning of the queries/reports using PL/SQL and SQL Plus

Migrated data from Text file to ORACLE database

Created stored sub programs with Dynamic SQL at both Client and Server side

Environment: Developer 2000 V6i, Discoverer, SQL, PL/SQL, Oracle RDBMS V9i, Designer 2000, Oracle Enterprise Manager, Management Server, Oracle Tuning Pack, Toad, UNIX, Windows 2000

Region of Peel, Brampton, ON, Canada

Oracle DBA Sep 2002 – Dec 2002

The Region of Peel is Ontario's second largest municipality. The Region provides a variety of municipal programs and services. The Information Technology Services team is committed to providing high-class quality services to their clients. Region of Peel has 7 HP-UNIX Servers, 17 Windows NT Servers, around 3500 workstations all over the region connected with fiber optics and more than 70 Oracle Databases. GIS, PeopleSoft and other third party applications are running. The assignment involved migration, enhancements, maintenance and user support for applications databases.

Role:

Database migrated from Oracle7 to Oracle8i on HP/UNIX. The migration on HP/UNIX included Converting of word-size and testing 64-bit release and applied patch 8.1.7.5.0

Worked with Oracle Enterprise Manager, Oracle Management Server and NET 8 Admin

Optimized queries time with aggregated, partitioned and de-normalized to star and snowflake data-marts, materialized views and indexes.

Introduced Oracle partitioning option in the project, which brought about a dramatic performance boost

Streamlined Oracle RDBMS management using software that includes Enterprise Manager Console with Performance, Tuning, Quest Software, Toad, DB Artisan and Humming Bird

Upgraded Enterprise Manager to 2.2 with FAT and THIN client support using Apache Server

Trouble shooting / problem solving in Oracle Server or Client as needed

Created materialized views, Analyzed Query Plans, Partitioning and Indexing to increase the speed of queries.

Responsible for Data conversion using SQL*Loader

Used RMAN for Backup and Recovery

Installed and configured Omniback on HP-UX platform for Oracle database backup/restore

Worked on PeopleSoft and G.I.S. that involves Oracle databases with partition cartridge

Environment: Oracle V8i/V8/V7.3, HP-UX (V10.20 and V11.0), Windows NT, OmniBack, Exceed, PL/SQL, Windows 98, Oracle Enterprise Manager with Diagnostic and Tuning Pack, Oracle Management Server, Recovery Manager, Toad and DB Artisan

Kasadel, Toronto, ON, Canada / New York, USA

Oracle Database Developer Jan 2001 – Jul 2002

The Kasadel is one of the leading software-houses specializing in the development of customized Oracle based business applications. Involved in the capacity of an Application Database Administrator in the development, implementation and maintain databases for their clients.

Role:

Studied the business requirements and was involved in designing the conceptual Data Model, Entity – Relationship Data Model using Erwin

Designed the application model, created the Data Flow Diagrams and Module designs

Designed and developed server coded objects like stored procedures/packages/triggers extensively using advanced features and thus incorporating the advanced functionality

Involved in the design and development of Oracle Forms and Reports using Developer 2000

Created Forms with Developer 2000 templates as for Form design using Visual attributes, Property Classes, Alters, Messages, Object groups and Tool bars

Tuned frequently used SQL Statements and PL/SQL Blocks using Tuning Pack

Designed, wrote and supported 2 applications, a complete Membership management system (over 8,000 members) and a Conference registration tracking system in MS Access 2000. Includes reports which integrate with MS Word 2000 and using Contact data from MS Outlook 2000.

Involved in training customers on front-end application of the system.

Environment: Oracle Developer 6i/6x, Discoverer, VB, VBScript, MS Access, Oracle 8i/8x Databases, SQL Server, SQL, PL/SQL, JAVA, Toad, Windows NT, Windows 98

LTV CAPITAL MODARABA GROUP, Karachi

Oracle Developer / Junior DBA Aug 1996 – Dec 2000

This organization is one of the largest financial groups in Pakistan. During my service I actively participated in the user requirement, design and development of a suite of business applications. I also worked, as Oracle Data Base Administrator (DBA) designing, troubleshooting and tuning of databases, maintaining security and made sure that the databases were available to clients. Working experience with AIX operating system on IBM RISC System 6000 environment.

Role:

Involved in the analysis, design, development, customization, testing and implementation of the system

Developed Logical and Physical modeling of database objects using ER-Win

Responsible for coding for call routines for Reports as well as Forms using menu module of Developer 2000

Developed Database Packages for Complex monthly application processes

Involved in the generation of over 50 MIS reports using Reports 3.0/2.5

Developed an integrated interface to connect data submitted from the web into MS SQL Server 2000, using MS Access for administrative data entry, then export accounting-related data into Peachtree Accounting

Developed a Service Request, Payroll and Invoicing application using their wide-area network in MS Access and MS SQL Server 2000

Helped team members in writing efficient stored procedures/ packages/ triggers and gave solutions to their problems in software development activities

Environment: Developer 2000 V2, MS ACCESS, MS SQL Server, Forms 4.5/5.0, Report 3.0/2.5, PL/SQL, SQL*Loader, Oracle 8.0/7.3, Erwin, UNIX, Windows NT

Contact this candidate