Ahmad Jaloul

****-** ****** ****** ******* 647-***-**** ac7qfq@r.postjobfree.com

Sr. PL/SQL Developer ~ System Analyst

A results-driven and quality-focused Oracle PL/SQL developer/ System Analyst with over 26 years experience in system analysis, design, development, implementation and support of software solutions.

Technical Skills

Languages: PL/SQL, SQL, SQL*Loader, UNIX Shell Scripts, Python

Databases: Oracle 9i/10g/11g

Oracle: Oracle Developer

Design: Data Modeling & Relational Database Design

Industries: Financial and Investment

Areas of Expertise

PL/SQL development, including Cursors, Procedures, Functions, Table function, Packages, Collections, Triggers, Table Indexing, function-Based indexing, SQL Loader

Performance tuning and optimization

Unix shell scripting

Software engineering, system analysis, design and application development

ORACLE database for major ORACLE versions

Physical and logical database design

Data migration, ETL operations, data cleansing, data extraction and data loading in a high-volume environment.

Requirements analysis and solution designs to meet customer expectation, system architecture, functional and non-functional requirements

Promotes best practices and strategies for Oracle application development.

Employment Background

Senior Software Developer/Designer (June 2017 – Present)

AppsMosic, Toronto, Ontario

Provide PL/SQL and Python development in a high-volume data environment.

Performed functional analysis, gathered system requirements and developed functional documentation.

Prepared work estimates, planned and organized development tasks

Mackenzie Investments, Toronto (Feb 1999 – May 2017)

Team Leader/ System Analyst / Sr. PL/SQL Developer 2011 - 2017

Collaborated with the project leadership teams on application architecture, project planning, scoping, resourcing and overall system analysis, design, development and implementation.

Estimated work effort and provided regular status reports on progress

Planned and organized development tasks and monitored performance.

Provided data and process modeling, system and data flow.

Performed and documented requirements analysis and produced Solution Designs to meet customer expectation, system architecture, functional and non-functional requirements

Provided SQL, PL/SQL development for Oracle based application systems

Implemented and supported ETL operations between Oracle applications and Mainframe applications.

Build and supported the Data access and extraction layer, using table functions and cursors, to provide accurate and consistent result set to the presentation layer.

Provided assistance to review QA test cases and scenarios, and provided technical support to Development and QA teams during the build and test cycles.

Trained, guided and directed senior and junior Oracle Developers; reviewed program code written by other team members to ensure conformity with standards and best practices.

Key projects:

Rate of Return for Mackenzie Investments by account/household, fund and fund series levels.

Mutual fund fees/rebate restructuring based on client grouping by agreement, Households and High-Water-Mark assets.

Trailing commission (service fee) to dealers and sales representatives.

FundServ XML reporting – all file types and frequencies.

Oracle database and application servers’ migration - from HP UNIX servers to IBM AIX servers.

Oracle database version migration from Oracle v10 to Oracle v11.

Environment: Oracle 11/10, SQL*Loader, PL/SQL, SQL, UNIX, shell, Mainframe, ESP, PVCS Version Manager, Microsoft Visio.

System Architect 2008 - 2010

Shared in the success of providing system architecture, disaster recovery architecture and disaster recovery plans for Mackenzie group of companies.

Provided technical architectural designs solutions and built interfaces for several business initiatives and upgrade projects.

Worked with business and technology stakeholders to refine high-level designs into detailed design deliverables

Sr. Programmer/System Analyst 1999 - 2008

Built a customized mainframe to Oracle 10g/11g database cloning system.

Provided SQL, PLSQL and UNIX shell development for Oracle based application systems

Performed functional analysis, gathered system requirements and developed functional documentation.

Built data extracts as required by business users and produced custom reports.

Performed SQL performance tuning and optimization.

Analyzed and tuned complex database triggers and stored procedures.

Scripted and managed database change requests to production systems.

Provided Data and process modeling, system and data flow diagrams.

Wrote custom ETL scripts to inspect clean and transform data feeds into needed formats.

AGF MANAGEMENT LTD., Toronto (1990 – Feb 1999)

Sr. Programmer/ System Analyst

Key player in the successful implementation of a project to migrate a Mutual fund computer system from an IBM Mainframe to an Oracle RDBMS on a UNIX Platform.

Integral part of a team to develop and maintain the core Process Model that defined the process and business rules for the Mutual Fund Processing system.

Developed and maintained the core financial system using SQL, PL/SQL, UNIX shell and “Power Builder”.

Worked with the business community to analyze and document business processes and define how several software tools could be leveraged to optimize processes.

Performed data mapping/cleansing design and development.

Provided Data and process modeling, system and data flow diagrams.

Environment: Oracle 7/8/9i, SQL*Loader, PL/SQL, SQL, UNIX, shell, Mainframe, PowerBuilder, System Architect (CASE), PB Win, ER Win.

Prior to 1990 held progressive professional accounting positions in Lebanon

Education

B.Sc. in Business Computer. Lebanese American University, Lebanon, 1986

Contact this candidate