Developer Oracle

Muhammad Nadeem Siddiqui

HIGHLIGHTS

Senior Oracle Developer with over 15 years of experience in designing, building, enhancing and supporting

custom RDBMS applications using Oracle databases and tools in Windows and Unix environments

Excellent SQL/PLSQL skills, ability to write efficient and complex queries against very large data sets

Wrote complex database procedures and packages, effectively made use of Table Function, Indexes, Table

Partitioning, Collections and Materialized views

Worked extensively on External tables, collection, UTL_FILE and Ref Cursors

Involved in Application Development, Query Optimization & Performance Tuning and implementation

experience in complete Systems Development Life Cycle (SDLC) as a Senior Solutions Developer at CTV Bell

Media

Developed and enhanced Oracle applications using Oracle Developer 11gR2 (Forms and Reports) and

WebLogic 11g application server

Developed reports using Oracle Discoverer 4 and maintained Discoverer repository (Desktop/Admin Edition)

Experienced in developing and supporting application using Visual Basic, C#, Microsoft Reporting Service and

TSQL

Worked on various projects with minimum supervision to develop and enhance custom application include

Revenue Reporting, Broadcast Operation Support System, Property Management, Financial (A/P, A/R,

and GL), Order Management, Property Tax Management, Time & Labour and Human Resource

Management

Hands-on experience with application performance tuning tasks such as analyzing execution plans,

analyzing AWR reports, optimizing inserts/updates/deletes, optimizing joins, indexing, creating views,

normalizing and de-normalizing

Possesses impressive analytical, problem solving, organizational and time management skills

SKILL SUMMARY

Software Last Used Experience

Oracle RDBMS: (Ver. 7.3 - 11gR2) Current 16 years

Oracle Development Tools:

Forms (Ver. 4.5 - 6i, 11gR2), Reports (Ver. 2.5- 6i, 11gR2), TOAD Current 13 years

Discoverer Ver. 4 Current 6 years

Application Server: Weblogic11g (10.3.6) Current 3 years

Microsoft Products:

C#, Visual Studio (2003), Reporting Service, Visual Source Safe. Aug 2008 3 years

Microsoft SQL Server Current 4 years

PeopleSoft (Ver. 7.5), SQR, Crystal Report 7, SQR Feb 2003 1 years

MicroStrategy Ver. 9.4.1 Current 6 month

Languages:

SQL, PL/SQL Current 16 years

VB Script, DTS Dec 2010 2 years

HTML, XML, TSQL Aug 2008 3 years

Standards & Methodologies:

SDLC: Requirement Analysis, Data Flow Diagram, ERD, Physical Current 6 years

Database Design, System Integration Test, Performance Optimization

and postproduction support

****************@*****.***

Muhammad N Siddiqui Page 1 of 4

PROFESSIONAL EXPERIENCE

CTV Inc. Bell Media [http://www.ctv.ca] Senior Programmer Analyst Aug 08 - Present

Environment: AIX UNIX 6, Oracle 11gR2, Oracle Developer 6i/11gR2 (11.1.2), Weblogic11g (10.3.6), Discoverer 4

(Desktop/Admin), MicroStrategy 9.4, VBScript, SQL Server 2003/2008

Broadcast Operation Support System (B.O.S.S)

Maintained and enhanced 3-tier application modules developed in Oracle Forms and Reports for CTV

program scheduling, asset and media rights management and reporting

Actively participated in design and development of back-end PL/SQL interface to integrate B.O.S.S scheduling

and asset management modules to Media Maestro (Media Rights Management System from Counter Point)

Lead conversion of B.O.S.S application from Oracle Developer 6i to Oracle Developer 11g about 100 forms

and equal number of reports were upgraded

Installed and configured WebLogic application server, web servers and Oracle Developer (Forms11g and

Reports 11g) on AIX UNIX

Managed application security and access to the database by granting appropriate privileges and roles to the user

Analyzed root causes of production issues and resolved tickets as support of production issues and document the

resolutions

Developed complex inventory reports using Oracle Discoverer and Oracle Table function.

Performed Discoverer EUL maintenance by updating relationship between folders, refreshing EUL after

changes to database tables, created business area, custom folder/folder, imported newly created database

function and user maintenance.

Developed, enhanced and debugged PL/SQL packages, procedures, triggers, functions to implement business

logic using TOAD on Oracle database 11g(11.2)

Sales and Revenue Reporting System

Worked as lead developer on centralized revenue reporting project for Wide Orbit. Wide Orbit Traffic System

house Radio Advertisement data for more than 100 stations across Canada.

During project performed following:

Designed and developed ETL process for Initial and Daily extract from remote database/system

Developed database by creating 100+ tables, external tables, views, procedure, functions, indexes and

partitioned tables

Developed packages for extracting data from remote system, merging and mappings extracted data of

customers, product, sale person and other related information

Processed data to generate revenue and pacing information and populate reporting tables in data mart

Fixed issues related to performance by reviewing execution plan, optimized SQL using hints

Co-ordinated with testing team and business users to investigate and fix bugs

Performed peer reviews of design and code and advised for necessary improvements

Documented the technical Specification SRS

QSP Inc. [http://www.qsp.ca/] Programmer Analyst Jul 03 - Aug 08

Environment: Sun Solaris 8, Oracle 9i, Developer 6i, C#, IIS, ASP, Visual Studio .Net (2003), Microsoft Reporting

Service, Exceed, SQL Server 2000.

Order Management (Browser based Application)

Performed troubleshooting and implemented bug fixes and enhancements within short deadlines

Developed and modified Oracle packages, stored procedure/functions to incorporate changes and enhancements

to various processes of application in Oracle and SQL Server 2000 environment

Developed and enhanced reports using Oracle Reports 6i and Microsoft Reporting Service

Customized and developed Oracle forms (6i) to provide day-to-day support to Oracle application

Actively participated in designing and development of new order management application using Microsoft Dot

****************@*****.***

Muhammad N Siddiqui Page 2 of 4

Net Framework and SQL Server 2000

Developed new C# classes and web pages using Visual Studio .Net and IIS

Liaised with project leader and coordinated with other team members to translate business rules from existing

Oracle application to new Dot Net application

Regional of DURHAM [www.region.durham.on.ca/] Programmer Analyst Sept 02 - Feb 03

Environment: UNIX, Oracle (8.1.x), PeopleSoft 7.5, SQR, SQL, PL/SQL, Crystal Reports 7

AR /Billing Implementation

Actively participated in the implementation of account receivable module.

Performed following during implementation:

Converted Customer, Invoice and related data from existing AccPac application

Developed SQR and PL/SQL script to extract transform and load data

Customized panels, PeopleCode and delivered SQR, SQC and Application Engine

Customized Crystal Reports

Used PeopleSoft tool Application Reviewer to debug PeopleCode

Set up overnight processes and jobs using Process Scheduler

Oct 00 – Nov 01

Workbrain Inc. [www.workbrain.com/] Application Developer

Environment: Oracle (8.1.x), Business Objects, HTML, XML, Visio, Visual Source Safe, Embarcadero’s Rapid SQL

Time & Attendance Application (Browser based Application)

Developed new ETL interface by developing Oracle package using UTL_FILE, DBMS_LOB etc.

Tuned PL/SQL procedures using SQL Trace, TKPROF and explain plan

Debugged stored procedures and functions using Embarcadero’s Rapid SQL

Maintained source code and objects in Microsoft Visual Source Safe version management system

Installed Oracle database and Oracle Application Server

Designed and developed Business Object using oracle packages

Designed forms and workflow using Java tool for developing business objects

Developed and maintained functional and technical specification and documentation

City Of Mississauga [www.city.mississauga.on.ca/] Application Developer Oct 98 - Oct 00

Environment: UNIX (HP), Oracle (7.3, 8), Developer 2000 tools (Form 4.5&5.0, 6 Report 2.5&3.0, 6 Graphics 2.5),

SQL*Loader, Crystal Report 6

Mississauga Express Approval (MAX) System

Approvals Xpress System tracks all aspects of the City of Mississauga's land development approvals process. From this

database, inventories of existing, under-construction, proposed and permitted buildings are derived to monitor

development and assist with growth forecasting.

Developed, modified and tested forms and reports as per specifications

Participated in conversion of existing system to 32 Bit application and created object libraries

Created and modified triggers, stored procedures, functions and libraries using PL/SQL

Developed scripts for loading property related data into the system using SQL*Loader

Used Crystal Report 6 to create ad-hoc less complex report as requested by user department

Mississauga Tax System

TAX system has been designed to process millions of dollars of taxes annually and handle customer inquiries. Actively

contributed to the development of phase two, which includes additional system functionality, and addressing the changes

to the Property tax legislation brought on by Bill 79.

Designed reports using Report 3.0

Modified and tested procedures and functions according to specifications using PL/SQL

****************@*****.***

Muhammad N Siddiqui Page 3 of 4

Karachi Metropolitan Corporation, Karachi Programmer Analyst Apr 94 - Mar 97

Environment: UNIX (SCO), Oracle (7.1), Form (3, 4.5), Report (1.2, 2.5), Windows 3.1, FoxPro (2.0), Paradox 3

WordPerfect (5.1) Lotus123 (4.0), Lotus Freelance.

Participated in development and testing of Complaint Implementation System, using oracle forms and report

Provided maintenance and support for payroll application developed in Oracle

Greater Karachi Water & Sanitation Project KW&SB (A World Bank Project) Nov 91 - Mar 94

Participated in development and implementation of project-monitoring database using Paradox

Selling Business Systems (SBS), Karachi Hardware Specialist Jan 90 -Nov 91

CERTIFICATIONS

Oracle Certified DBA (8i) on Sun Solaris 8 June 2002

Oracle Certified Application Developer (Release 1) July 1999

EDUCATION & TRAINING

MicroStrategy 9.4.1 Developer Reporting Essentials (MicroStrategy University) Feb 15

MicroStrategy 9.4.1 Architect Project Design Essentials (MicroStrategy University) Feb 15

MicroStrategy 9.4.1 Developer Advanced Reporting (MicroStrategy University) Feb 15

Oracle WebLogic (10.3.6) Administration (DesTech, Toronto) Dec 12

Oracle Database Administration (8i) Apr 02-Aug 02

19 weeks full time training in Oracle Database Administration at Indus Systems.

Oracle 8.0 RDBMS Professional Training Jul 98 -Nov 98

19 week full time training in Oracle 8 / Developer 2000 at Deeds project University of Toronto.

Diploma in Computer Science Jul 92 - Jun 93

Petroman Training Institute, Karachi, Pakistan.

M. Sc (Applied Physics) from University of Karachi, Pakistan. Aug 87 - Sep 89

****************@*****.***

Muhammad N Siddiqui Page 4 of 4

Contact this candidate