Oracle PL/SQL Consultant

MOZHARUL HOQUE Tel : 905-***-**** (Res)

*** ********** ******, ****: 416-***-****

Woodbridge, Ontario L4H 2B8, Canada email: ******@*******.**

EDUCATION & PROFESSIONAL IT TRAINING

EDUCATION: B.Sc - Diploma in Computer Science (Dhaka University)

PROFESSIONAL IT TRAINING :

- ORACLE TECHNOLOGY with in-depth concepts of ORACLE Products.

Oracle Corporation Certification

ORACLE DATABASE / ORACLE MENU (SQL*MENU) / ORACLE FORMS ( SQL*

FORMS DESIGN ) ORACLE REPORT (SQL*REPORT WRITER) / PL/SQL / SQL *

PLUS / UNIX OS / SHELL SCRIPTING

- ORACLE DBA (Database Administration) QUADCOM , Canada

- CIS Banner Technical Architecture IT Training , Toronto Hydro

- CIS Banner Advanced Database

- Pro*C and Pro*Cobol programming

- Project Management : Skills for Success Learning Tree, Canada

- XML for B2B and Web Services Development Learning Tree, Canada

- ITIL V3 IT Service Management Essential B-Wyze Solutions, Canada

- Identifying & Confirming Users Requirement Learning Tree , Canada

- IT Professional / Consultant Training Toronto Hydro

- CC&B ( Oracle : Customer Care & Billing) Oracle ,Toronto Hydro

- ODS ( eMeter) Training Oracle ,Toronto Hydro

PROFESSIONAL HIGHLIGHTS

Diversified 15+ years experience in supporting/maintenance of large scale

business application system ( Utility Industry) using ORACLE MENU/FORMS/REPORTS / SQL / PL/SQL, Packages & Stored Procedures, Functions / Pro*C and Pro*Cobol / UNIX/ shell Scripting / Java / XML for B2B Electronic Business Transaction /Data Management / Project Management etc with the following responsibilities:

- Analyzing, designing, development ,testing and implementation of new

initiatives and enhancements to the business applications system.

- Manage the client's expectations so that the resultant system meets their budget

and time constraints without any business impact.

- Manage multiple projects and assignments, completion according to business

defined priorities and keeping them aligned with their timeline and drive to

successful completion.

- Manage QA test plan ,cases, executing unit, system and integration testing, and

document defects in collaboration with the project team.

- Maintain Software Development Life Cycle (SDLC) concepts and practices,

particularly as it relates to design, development, testing , promotion and

deployment of routine fixes and major releases into a production environment.

- Maintain IT Service Management (ITIL) and production support best

practices, particularly as they relate to incident, problem and change management

and remediation through root cause analysis and post incident review.

- Troubleshoot application problems when required. Providing technical assistance,

guidance and directions to various teams implicated throughout the system

development cycle.

- Working with various internal / external groups, including development, testing,

operations and service delivery to advocate production technology and process

standards and enforcement.

- Acting as a team lead and/or technical solution provider (subject matter expert)

for complex application problems.

WORK EXPERIENCE -1

[A] Toronto Hydro Electric System Ltd System Consultant Jan 2000-Oct 2011

(Local Distribution Company :Ontario’s Deregulated Electricity Marketplace)

System Support and Major Responsibilities :

1. CIS Banner application system (Customer Care & Billing ) :

Support CIS Banner incidents, change requests and problems in a timely manner to ensure implementation is without any serious business impacts and resolution within targeted timeframe using ORACLE MENU/FORMS/REPORTS / SQL / PL/SQL, Packages & Stored Procedures, Functions ,Pro*C and Pro*Cobol / Java / XML/ UNIX/ Shell scripting etc .

2. CIS Banner eBill Applications system ( eDirectory) :

Analyze, design,Test and implement the changes as and when required by business to meet business satisfaction on time in transmitting customer’s eBills using SQL / PL/SQL Packages & Stored Procedures, Functions / Java / XML.

3. EBT (Electronic Business Transaction) system:

Plan, implement OEB mandated energy retail market changes and manage end-to-end retail market testing. Monitor and support EBT-Banner Interfaces / Database and provide technical assistance to business unit to meet users satisfaction on time in error free transmission of energy market retailer’s data through EBT HUB using SQL / PL/SQL Packages & Stored Procedures, Functions / Java / XML.

4. MWM (Mobile Workforce Management) System:

Support MWM to CIS Banner / Banner to MWM interfaces, Handheld Upload

and Download Process metering data, investigation and fixing issues as and

when required on time, on scope and without any business impact using SQL / PL/SQL Packages & Stored Procedures, Functions / Java / XML.

PROJECT ACCOMPLISHMENTS:

1. Electricity Retail Market changes EBT V4.0 standards (as Project lead):

OEB mandated retail market changes EBT V4.0 standards analyzed ,designed, developed and implemented successfully and met target implementation timeframe

Prepared unit /QA/UAT test /Install plan and managed all resources, database / server backup for rollback procedure, post implementation verification. Accountable for overall successful project milestones on time and project closure without any major business impact in coordination with the Business and vendor The Spi Group Inc.

Technology used : ORACLE MENU /FORMS / REPORTS / SQL / PL/SQL, Packages & Stored Procedures, Functions ,Pro*C and Pro*Cobol / Java / XML.

2 Migration to EHC V4.0 in EBT system (as Project lead):

EBT EHC V4.0 migrated successfully without business impact and completed on time, scope and per approved schedule. Prepared unit Test/ QA test / Install plan and managed all resources, database / server backup for rollback procedure, post implementation verification and project closure successfully. Worked effectively and collaboratively with vendor The Spi Group Inc and infrastructure/DBA.

Technology used : Java / XML.

3. Smart Meter Bill Presentment:

Analyzed Smart Meter Bill presentment TOU (Time of Use) system design specification, programming, unit testing and delivered programs according to Smart Meter project plan within stipulated time frame

Technology used : ORACLE MENU /FORMS / REPORTS / SQL / PL/SQL, Packages & Stored Procedures, Functions ,Pro*C and Pro*Cobol / Java / XML.

4. MWM C&I (Commercial & Industrial Meter Changes) :

CIS Banner modifications to implement interface between Banner and SPL MWM for Commercial & Industrial Meter Changes .

Prepared Test cases / Install plan for resources, implementation, database / server backup, rollback procedure, post implementation verification. Implemented successfully and completed on time, scope and per approved schedule without any major business impact.

Technology used : ORACLE / SQL / PL/SQL, Packages & Stored Procedures, Functions ,Pro*C and Pro*Cobol / Java / XML.

5. CIS Banner HST compliance

Ontario government proposed HST legislation requirements compliance analyzed ,designed, developed and implemented successfully and met target implementation timeframe .

Prepared unit Test/ QA test / Install plan for resources, implementation, database / server backup, rollback procedure, post implementation verification. QA test and implemented successfully and completed on time, scope and per approved schedule in coordination with the Business and vendor ' The Spi Group Inc '.

Technology used : ORACLE / SQL / PL/SQL, Packages & Stored Procedures, Functions ,Pro*C and Pro*Cobol / Java / XML.

WORK EXPERIENCE -2

[B] Dubai Electricity & Water Authority System Analyst 1992-1999

Company Scope: Power Generation & Distribution / Govt. Utility Industry

Major Responsibilities / Functions:

- Analyzing, designing, development, implementation and supporting as per clients

Specification.

- Developing screen-based (Object Oriented) application using Oracle's SQL* Forms

Design, SQL / PL/SQL, Stored Procedures, Packages, Functions and Triggers.

- Maintenance and supporting existing applications as per client's requirements.

- Providing support to client by troubleshooting for programming malfunctions.

- Modification of technical documentation (User’s / Functional / Operational Manuals).

- Providing user’s training on newly installed application system.

PROJECT ACCOMPLISHMENTS:

Associated as a Team lead / System Analyst with the following in-house project:

Consumer Billing System : (Oct 1992 – July 1993)

Consumer Billing System for Dubai Electricity and Water Authority was developed for computerization of billing to consumer for the usage of Electricity & Water utility using ORACLE MENU/FORMS/REPORTS / SQL / PL/SQL, Packages & Stored Procedures, Functions .The system is fully menu based, user friendly and facilitates on-line help. System is equipped with built-in security features, which restricts unauthorized usage of IT resources.

Financial Accounting System : (Sept 1993 – May 1994)

Financial Accounting system was developed to computerize company’s Financial Accounting using ORACLE MENU/FORMS/REPORTS / SQL / PL/SQL, Packages & Stored Procedures, Functions. System is an easy-to-use menu-driven, user-friendly system. System has excellent security features, which restricts unauthorized usage of IT resources.

Payroll Accounting System : (Jun 1994 – Mar 1995)

The Payroll Accounting System was designed for computerization of the payroll accounting using ORACLE RDBMS MENU/FORMS/REPORTS / SQL / PL/SQL, Packages & Stored Procedures, Functions. The system is easy-to-use menu driven, user-friendly system. Payroll Accounting System has excellent security features and maintained through security module. It restricts unauthorized usage of IT resources.

Y2k Compliant System Analysis : (Aug 1997 - Oct 1998 ):

Y2k Impact Analysis, Program modification / Testing to make systems Y2k compliant

using Oracle MENU/FORMS/REPORTS/SQL/ PL/SQL, Stored Procedures , Triggers, Functions and Packages.

Contact this candidate