Shahzad Siddiqui

Dallas, TX

Cell: 469-***-****

Email: ad39lu@r.postjobfree.com

Summary:

An experienced Senior Oracle PLSQL Developer / Database Architect with more than 19 years of experience in Analysis / Applications – Database 12c / 19c ExaData / Development Designing Modeling, ER - Dimensional Modelling / (SQL - PLSQL) database development / Performance and tuning of the code. Worked on EBS (HRMS / Financials) and SCM modules development and support.

Experience in Continuous Integration & Continuous Delivery (CI/CD) Pipelines using modern DevOps tools using GIT/BIT-Bucket / Jenkin – Jules in the data engineering space.

Business intelligence reports using BI Publisher and XML report publisher tool. ETL mapping / Informatica, Cloud (SAAS / PAAS), project development and implementation projects and in eliciting, documenting, refining and validating the requirement for a broad range of internal and external stakeholders. Have strong oral, written communication, analytical, facilitation and interpersonal skills and superior understanding of the IT development Lifecycle.

Technical Background:

Database: ORACLE 7.3/8.0/8i/9i application server/10g/11g/ Oracle 12c EXA Data12c,

Oracle19c.

Programming Language: SQL - PL/SQL Programming, C, Shell Scripting.

Client-server / web: Oracle EBS, Oracle Forms 6.0/6i/9i/10g,11g & Reports 6.0/6i/9i/10g,11g, Oracle WebLogic Fusion Middleware, Python, ODI (Oracle Data Integrator) Oracle Business Intelligence, XML Publisher Reporting, Oracle HCM Cloud – SAAS / PAAS.

Operating Systems: Windows, UNIX.

Tools / Development: Toad, PLSQL Developer, SQL Developer, Oracle Supply change management - SCM 10g, XML, HTML, CSS, IBM clear quest, Cherwell, SharePoint, Erwin, Ultra Edit, Dollar Universe (Uni Viewer Console), SVN, PVCS, ER-Studio, Mongo DB, JIRA, Confluence DevOps (GIT BIT-Bucket, Jenkins) tool.

Oracle Developer / DBA Certifications:

Achieved an OCP – Oracle Certified Professional in Developer Track (PLSQL Program Units, Forms1 / Forms2, Reports) and DBA Track.

Appreciation / Achievements:

Received a performance certificate in the first six months at Stantec Engineering and Management consulting Inc.

Achieving a team award of excellence with Alberta Justice and Solicitor General – Government of Alberta in recognition of the contribution to the correctional services renewal initiative (CSRI)

Synopsis of Work Experience:

Extensive experience in Oracle PLSQL (Database) / Architecture, Designing / Apps Development / Release Management, Performance and tuning of Oracle Databases, Technical Leads in Distributed / fast paced environments with SQL, PL/SQL, Oracle Fusion Forms11g / Reports11g Middle ware, EBS HRMS-Financials/ SCM (Order management / procurement), XML report publisher and BI Publisher reporting.

Experience with Continuous Integration & Continuous Delivery (CI/CD) Pipelines using DevOps tools using GIT/BIT-Bucket / Jenkin - Jules.

Proficiently working with PMOs to refine and develop user stories using SCRUM / Agile methodologies.

Experience of SDLC & RUP - Rational unified process (Inception, Elaboration, Construction and Transition) phases.

Experience conversion / migrating on-perm application to cloud.

Involved in the performance and tuning of complex SQL & PLSQL code using Partitioning, Indexing, (FOR ALL, BULK COLLECT), UDTs – User defined types, Explain plans, TK Proof, Query Optimizer hints.

Experience working on HCM (Human Capital Management) Cloud – SAAS & PAAS technologies / architecture.

Proficient in database conversions, application tuning, environment setups, security backup, restore procedures, HRMS data pump, API’s, SQL loader, External Tables.

Technical expertise and analytical skills in designing of ER modelling for OLTP and Dimensional modelling for OLAP.

Developed UML diagrams (e.g: Activity diagram, use cases, Sequential diagram, Class diagrams, Process flows etc.)

Involved in configuring & deploying XML report publisher (Oracle Financial 11.5.12) and BI Publisher 11g (reporting tool).

Used appropriate tools and methodologies to document and validate business requirements and functional specifications, such as use cases, user stories, UML, workflow analysis, data flow diagrams, entity relationship diagrams, flowcharts, and Agile methodologies.

PROFESSIONAL EXPERIENCE:

JP Morgan Chase Bank

Sr. Oracle Database Engineer / PLSQL Developer Feb-2022 – Present

Position Overview:

Working with the IDCERT- (Certifications and Entitlement Applications). Involved in the Analysis - Database Development / Performance & tuning / operational activities / testing of processes and release deployment / management. My responsibilities is to lead / development of a comprehensive end-to-end detailed solutions with overall accountability for the technical design / development (including documentation & communication) and is often focused on large scale, complex and enterprise projects.

Key Responsibilities:

Adopted Agile (Sprint) software design - development methodology / daily stand-up meetings.

Development of required processes using PL/SQL Packages (Procedures-Functions) Composite Data Types (PLSQL Collection / Records / Objects, Associative arrays and Nested tables, Explicit Cursors, Ref Cursors, UDTs – User defined types, Oracle Table / Pipeline function, Bulk Processing and Handling Exceptions, Log-file to track errors / Pragma – Autonomous Transactions.

Responsible Database objects creation / developing and testing of code (Unit - UAT testing)

Involved in performance & tuning of SQL and PL/SQL applications code (Partitioning, indexes, analysing explain plan, optimizer hints, (DBMS STATS) to collect statistics and improve performance.

Working on HCM cloud application, data mapping, API development on HRMS module and conversion project.

Working as a release manager to promote developed / modified (DB / Autosys - JIL / UI and Reports) code into UAT and PROD environment using GITHUB and Jules build - Pipelines.

Involved in Continuous Integration & Continuous Delivery (CI/CD): branching timelines, pull requests, issue triage, merge/conflict resolution, release notes.

Created deployment related Scripts, check into BIT Bucket using GIT prior releasing code into UAT and PROD. Also collecting and uploading Evidences in JET Console.

Extensively used Analytical functions in developing SQL queries and in PLSQL Code.

Attend daily Production Support calls to review backend Database / UI processes – Connector Jobs / Autosys Jobs (runs daily) and to resolve / troubleshoot issues.

Demonstrate ownership and good skills on problem management, problem solving and prevention of SLA breach under Incident / Problem Management processes.

Developed PLSQL programs to load data from OLTP (Transactional data) to OLAP (Fact / Dimension)

tables.

Involved in developing Materialized view / Incremental procedures to load data from source to target database objects.

Creating and managing UAT / PROD SNOW change requests / UAT Signoff as well as JET evidences upload / review and approval processes prior to PROD deployment.

Assisted in configuration, development and testing of Auto-Sys JIL and related scripts.

Effectively used Confluence to manage project documentations and BIT-Bucket to manage code version control.

Environment:

Oracle Database 12c-19c EXADATA, Toad, GITHUB, BIT-Bucket, Jenkins / Jules, JIRA, Confluence tools.

CITI Bank – Irving, TX

Sr. Oracle Database Engineer (PLSQL Development) Mar-2021 – Feb 2022

Position Overview:

Working on SFRM - Strategic Financial Resource Management project aims to build a financial forecasting ecosystem that addresses key operational plan pain points and enables strategic business driven decision making, as well as DataWare house project my responsibilties is to analysis, design,

development the creation of an end-to-end detailed designed solution with overall accountability for the technical design, data load from Source to Staging and Data ware house system.

Key Responsibilities:

Facilitate JAD sessions / presentation with business users in the analysis & requirement / gathering.

Designed data models (Fact / Dimension models (Metrics) using SQL Developer and Erwin tools.

Worked on complex PLSQL Packages(Stored Procedures / Functions, PLSQL Collections, REF Cursors, Bulk Collect features..

Involved in ETL creating and supporting Objects in Informatica, Data mapping, to load data from source database into target database using Oracle

Involved in the performance & tuning of SQL and PLSQL code using: Xplan plan, SQL Profiler, Indexes (B*tree – Bitmap), Table / Index Partitioning and Optimizer Hints.

Developed incremental procedures to load data from OLTP (Transactional data) to OLAP (Fact / Dimension) tables.

Developed templates and data field mapping documents to map EBS HRMS / Financials module fields with HCM Cloud prior loading into HCM cloud database.

Experience with DevOps automation, and Continuous Integration (CI) / Continuous Deployment (CD), Lean, and Agile Scrum/Kanban development techniques.

Worked on IBM - IFW Information Frame-Work - reporting tool using PLSQL and Java based Free Marker Code (Template Engine) to generate text output based on temlates.

Worked on Oracle packages (DBMS STATS) to collect statistics of many different kinds as an aid to improve the performance.

Involved in the RLM - Release Process Management / migration process using BIT-Bucket and Jenkin tools, change management from Dev to UAT and Production environment.

Supported EEMS - Enterprise Entitlement Management Systems, which facilates user provisioning and runtime authorization framework to enterprise applications and services.

Environment:

Oracle Database 12c, Toad, ERWIN, GIT, BIT-Bucket, Jenkins, JIRA tools.

Bank of America – Dallas, TX Senior Oracle PLSQL Developer / Database Architect Dec-2019 – Dec-2020

Key Responsibilities:

Extensively worked on SVN (Centralized version control) and DMA (Database Middleware Automation) tools to execute SQL & PLSQL related scripts into an Oracle Database.

Modifications and support of PLSQL programs to load data from OLTP (Transactional data) to OLAP (Fact / Dimension) tables.

Involved in the designing / modelling Database Architecture, performance and tuning of complex SQL & PLSQL code using Partitioning, Indexing, (FOR ALL, BULK COLLECT) Explain plans, TK Proof, Query Optimizer hints.

Used ETL Data Mapping / transformation and processes by using Informatica to load from Source to Staging tables.

Involved with team on BIG Data technologies / Project.

Design / developed BI reports / Dashboard using OBIEE.

Creations and maintenance of Auto-Sys jobs related to HRIS - ETL Framework Configuration entries.

Created partitioned on large tables using Range and Index Partitions.

Created Materialized views in order to facilitate Business Intelligence reporting.

Support UNIX shell scripting to scheduled Auto-Sys jobs and ETL framework configuration tables.

Performed UNIT / Integration and Smoke testing.

Involved in the monthly deployments / release with the DBA team.

Involved in coordinating onsite and offshore communications / daily stand-up meetings.

Environment:

Oracle Database 12c, Toad, SharePoint, SVN (Centralized version control), DMA (Database Middleware Automation), JIRA, Informatica – Power Builder, Unix.

CITI Bank – Irving, TX

Sr. Oracle PLSQL Developer / Tech Lead Nov-2018 – Dec-2019

Position Overview:

Worked on DataWare house project with the Citi bank at the Global Technology Operations. My role was to led / design / development the creation of an end-to-end detailed designed solution with overall accountability for the technical design / development, data load from Source to Staging and Data ware house system (including documentation & communication) and is often focused on large scale, complex and enterprise projects.

Key Responsibilities:

Requirements Gathering (JAD) sessions from the client for any new functionality to be added to the Project.

Development of functional / technical specification documentation.

Designed data models (Fact / Dimension models (Metrics) using SQL Developer and Erwin.

Developed complex database objects like PLSQL Packages (Stored Procedures, Functions, Ref Cursor, External Tables and Collections) using SQL and PL/SQL

Database performance & tuning, Table / Index Partitioning / optimizing in SQL queries & PLSQL Programs and extensively used XPLAN Plan.

Developed PLSQL programs to load data from OLTP (Transactional data) to OLAP (Fact / Dimension)

tables.

Worked on Oracle packages (DBMS STATS) to collect statistics of many different kinds as an aid to improve the performance and UTL FILE to read and write operating system text files.

Worked on ETL mapings, incremental procedures to load data from Source systems to Staging and Oracle 12c Data Warehouse.

Performed UNIT, integration and smoke testing of the application.

Involved in the RLM release management process / change management from Dev / UAT and Production environment.

Effectively used SharePoint and Cherwell to manage deliverables and status updates.

Environment:

Oracle Database 12c, SQL / PLSQL, SQL Server, Toad, SharePoint, ERWIN, SVN (Version Control), Oracle OEM, JIRA, Unix, Talend – ETL tool.

The Economical Mutual Insurance Group

Technical Lead Oracle Applications EBS / Cloud Aug 2016 –Nov-2018

Position Overview:

Worked on Oracle EBS HRMS 12.1.3 to Oracle HCM Human Capital Management Cloud - SAAS conversion / Integration Project. Involved with the business users to understand Projects Operational business activities and translate user’s business problems in analytical terms, participate in the design, functional / technical specification documentation / deliverables regarding implementation of Oracle HCM –Solutions.

Key Responsibilities:

Facilitate JAD sessions / presentation with business users in the requirement / gathering phase.

Followed Agile (Sprint) software design - development methodology.

Developed “System Architecture Diagrams” regarding current state and future state of EBS and HCM Cloud Application using Ms Visio.

Worked on Forms10 / Reports10. Designed, developed new Oracle Forms and Reports.

Created PL/SQL procedures - functions using Composite Data Types (PLSQL Collection / Records – Varrays, Associative arrays and Nested tables, Explicit Cursors, Ref Cursors, Bulk Processing and Handling Exceptions.

Involved in the customization on HRMS / Compensation / AP / AR / GL modules related forms & reports.

Experienced developing in Inbound/Outbound interfaces for third party Vendors e.g: OC Tanner, Ceridian, SEB Hewitt Benefits, Banks and for internal applications.

Developed AIM – (MD.070) Technical Specification documentation.

Experience developing RICE objects (interfaces, reports, data conversions and enhancements).

Worked in the Conversion / Integration project from Oracle EBS HRMS to Oracle HCM Cloud.

Worked on HCM (Human Capital Management) Cloud – SAAS technology / architecture.

Involved in the ETL processes to load EBS HR data into HCM cloud database tables.

Ability to integrate underlying database using database links and materialized views (including performance / tuning).

Worked closely with Solution Architect and developed Pre-spec docs / Business requirement documents. Process flow diagrams and Current state EBS HRMS and Financials modules by using MS, Visio.

Support the production support system issues and assign tickets to the developers based on severity levels.

Experience in consulting with business partners and project teams on all aspects of software development and integration ensuring solutions adhere to design principles and standards.

Environment: Oracle EBS 12.1.3 (HRMS / Financials), HCM Cloud13.1 (SAAS / PAAS), Toad, SharePoint,

ERWIN, PVCS (Version Control), Confluence, UNIX, JIRA.

Ford Motor Company – Detroit, Michigan

Specialty Development Senior (Oracle PLSQL Development_ Apr-2015 – Jun-2016

An ERP system developed to support the Prototype Globalization effort, to come up with common prototype processes across all Vehicle Centres - to reduce prototype costs.

The following are the main modules and include the following functions:

Modules:

Prototype Build and Scheduling.

Bill of Material.

Ordering.

Material Handling.

Functions:

Schedules and specifies prototype builds.

Generates the BOM - Bill of Material for vehicles and programs globally.

Handles all ordering and follow-up functions.

Provides warehousing activities, supports part picking, and shipping functions.

Controls builds and interfaces to accounting.

Key Responsibilities:

Facilitated and participated joint requirement sessions and conducted JAD sessions with SMEs to gather requirements.

Writing detailed Functional specifications and Technical Design documents to meet client’s requirements.

Involved in the data modelling & data base designing using Erwin / Toad (Oracle Database11g).

Extensively worked on SCM Modules: Order Management, Procurement and Supply Chain Planning,

Involved in the designing, development and support of Supply Change Management – SCM applications.

Developed APIs, SQL / PLSQL Packages (Procedures / Functions and Associative Arrays - Collections)

Involved in optimizing in SQL queries & PLSQL Programs and extensively used XPLAN Plan and Table and Index Petitioning.

Developed new Forms10g / Reports10g and made modifications on already developed Forms / Reports.

Developed and design complex data structures, ad hoc queries, reports and analytics.

Developed UML Diagrams, e.g. Process Diagrams, Sequence Diagram and Activity Diagrams by using MS – Visio.

Worked on Test Driven Development, write test cases / validated based on the project requirements.

Maintained / modified materialized views for data replication.

Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Extensive use of Unix Shell Scripts, Cron jobs and Autosys to automate process.

Installed / Configured Oracle WebLogic Server.

Troubleshoot, fixed, and implemented bug fixes and enhancements within tight deadlines.

Environment: Oracle Fusion Middleware Forms11g – Oracle WebLogic Server, Toad, utPLSQL automated testing tool, SharePoint, ERWIN, Putty, PVCS, Exceed – Open text tool, TDD test automation,

UNIX.

Justice and Solicitor General and Public Security - Government of Alberta

Sr. Oracle Developer / Lead Apr - 2011 – Mar - 2015

Position Overview:

Worked on Offender Management System project, and my role was to understand Projects Operational business activities and translate user’s business problems in analytical terms, participate in the design, functional / technical specification documents, as well as SQL / PLSQL coding, developed Forms10g / Reports10g, designed application framework and developed Oracle Forms based Application, testing and implementing and the production support of the “Offender Management System” project.

Key Responsibilities:

Refined and detailed functional requirements using use cases and non-functional requirements as supplementary specifications also have experienced documenting business rules and data models as per client needs.

Designed and Developed Offender Management System project based on Forms 10g / Reports 10g.

Created functional / technical specification documentation.

Worked on advanced features of PL/SQL Collections / Varrays Subtypes, PLSQL Records, PLSQL Tables, Object types and Dynamic SQL, global temporary tables, Inline views / correlated Sub queries.

Validated development efforts by creating test cases / test scripts using test types like Unit, System, Smoke, and Integration testing; executed test scripts for peer development efforts and performed peer code reviews.

Performed Unit testing on the developed PLSQL Packages (Procedures / Functions) and Offender Management System in development environment.

Used SharePoint and Cherwell to manage deliverables and status updates.

Configured / Installed OBIEE (Oracle Business Intelligence Enterprise Edition)

Designed developed BI Publisher reporting.

Writing unit test plans / scripts and conducting the testing to meet quality standards.

Experience in production support on Offender management systems project for end users across Alberta province.

Troubleshoot and resolved technical issues related to application and database level.

Environment: OracleForms10G, Reports 10G, SQL, PL/SQL, Oracle Database 11G, Oracle Discoverer10g, TOAD, VSS - Visual Source Safe, MS Visio, MS Project, SharePoint, ERWIN, Cherwell - IT service management software (Incident / ticket) tracking software, COT Application.

Stantec Consulting & Engineering Inc. Edmonton, Alberta

Oracle Apps Technical Consultant (Oracle Financial 11.5.12) May 2005 – Mar 2011

Position Overview:

Worked for this company since May-2005 as an Oracle Applications Technical Consultant, PLSQL, Oracle Forms / Reports and ADF for designing, developing and maintaining applications for the organization. I have successfully handled critical development and enhancement of SCM modules. As part of the new application development projects i have also done extensive research on the performance of PLSQL and Java.

Worked on Oracle E-Business Suite HRMS / Financials application.

Gathered business requirements through close interaction with all the stakeholders

Responsible for development / customization & client extension of oracle application modules including (Oracle Projects, Oracle Advanced Benefits (CA / US), Oracle HRMS, Accounts Payable, Oracle Time and Labour etc.

Developed / Modified PLSQL Packages (Stored Procedures, Functions) and database triggers using SQL and PL/SQL.

Expertise in Data Conversion and Interface development

Adept at designing and customizing the oracle application forms using TEMPLATE.fmb and CUSTOM.pll to create new functionality to the application.

Developed BI / statistical reports by using data warehousing environments.

Developed Web based user interfaces by using HTMLDB / SQL / PLSQL.

Conducted analysis & developed and delivered based on the analysis, user interface, data conversion scripts (e.g. API development) & client extensions.

Developed API to convert legacy data or mass update existing data.

Used data modelling tools to generate Logical and Physical data models.

Experience in maintaining and developing Fast formulas.

Extensively used SQL Loader to load external data into Oracle Application Tables.

Create table partitioning and index partitioning as per the requirements.

Experience in implementation / working on Oracle XML Publisher11.5.10 to convert Oracle reports into PDF, Ms Word, and Html Excels Format.

Developed different types of Customized Reports Drilldown, Aggregation to meet client requirements.

Customising existing applications and addressing issues raised by the end users, including bug fixes.

Environment: Oracle E-Business Suite application, Informatica, Oracle Database 10G, Oracle BI Discoverer, XML Report Publisher, Workflow, ODI (Oracle Data Integrator), PVCS (version control), MS Visio, SQL Loader, Quest Toad, UNIX.

Calyx Technologies (Software Solution Provider)

Oracle Developer / Designer Mar 2002 – Dec 2004

Designed and developed an Oracle ERP System and implemented on the client side. The banking & textiles ERP system comprises of multiple modules, it gives a complete business solution for textile & garment industry. Developed and support on GL / A/c Payable / A/c Receivable systems of Bolan and Citi bank.

The ERP system comprised on the following modules:

Marketing Management System (M.M.S)

Sampling Management System (S.M.S)

Order Management System (O.M.S)

Supply Chain Management (S.C.M )

Procurement Management System (P.M.S)

Inventory Control System (I.C.S)

General Ledger System (G.L.S)

Accounts Payable System. (A.P.S)

Accounts Receivable System (A.R.S)

Role: Software Design & Development:

Performed design & development for the Textiles ERP System. Conducted Joint Application Design JAD sessions with SMEs have in order to obtain requirements using water fall model approach / technique.

Designed and Developed Oracle Forms and Reports related to the ERP systems.

Worked extensively on PLSQL Packages (Procedures / Functions) Ref Cursor and PLSQL Tables.

Normalized Data Models for the application (Worked on ER-Studio tool to generated Conceptual and logical designs).

Wrote PLSQL packages / sub-programs on database and application level.

Involved in Functional and Regression testing on the developed ERP application modules.

Load data from legacy application to newly developed application by using Oracle Warehouse builder ETL tool.

Developed test scripts / tests cases & involved in the user acceptance testing – UAT with end users in order to test customized ERP system modules functionality.

Responsible in implementation of an ERP System on the client sites and conducted user training sessions.

Environment: Developer 2000 Forms6, Reports6, SQL, PL/SQL, Oracle Database8i, Oracle Enterprise Manager (OEM), Linux Management Server, MS Visio, Oracle Tuning Pack, SQL Developer, ER/ Studio 5.0.

Education:

1.M.sc (Computer Science) 2001 – 2003 (West Coast Institute of Management and Technology)

2.Bachelor of Commerce (B-COMM) 1996 – 1998

3.Oracle Certified Professional - OCP (Developer / DBA) - 1999 – Oracle Corporation

4.Two Years Advanced Diploma in Computer Sciences – 2000 - NCR Institute

5.Six Month Diploma in Oracle Developer & Database Administration – 1998

Trainings:

Attended web seminar (Online Training) on I/O in PLSQL – files screen outputs – UTL_File and UTL_MAILS by Steven Feuerstein web cast series sessions -1.

Completed course on PMP – Project Management Certification.

Best practices for writing SQL & PLSQL by Steven Feuerstein web cast series session – 2

Effective management of PLSQL applications by Steven Feuerstein web cast series session– 3.

Attended ITIL training course at NAIT institute – Edmonton – Canada.

Reference:

Will be furnished upon request.

Contact this candidate