Kamran Madni Cell: 647-***-**** Tel: 905-***-****

**** ****** ********, ***********, ******* L5W 1H1 ace2wr@r.postjobfree.com

OBJECTIVE: POSITION AS AN ETL DEVELOPER

CAREER SUMMARY

* ***** ** *** design/development using DataStage, latest IBM Infosphere DataStage v9.1.0.1

5 years of UNIX including 2+ years of shell scripting, 3+ years using DB2

1+ year NETEZZA, Mainframe ESP schedules, z/OS, TSO, JCL, Eclipse/ISPW, JIRA, AGILE DW

8 years as Oracle Application Developer using SQL, PL/SQL, Forms and Reports, Stored Procs

3 years as EAI developer using IBM Websphere DataStage TX 8.0 (formerly Mercator)

4 years of configuration management and source control using ISPW, HP Quality Center, PVCS

Requirement gathering investigation/analysis, problem solving, application design, development, unit testing, promotion to SIT/UAT, documentation, maintenance/support of various business applications

Data extraction, validation, profiling and data cleansing experience

Extensive experience in all phases of SDLC including AGILE project management methodology

Effective written and verbal communication, negotiation and interpersonal skills

Well organized, result oriented, creative, cooperative, trouble shooting and team work

Ability to perform in less or no supervision, effective time management to meet the deadlines without compromising on the quality of deliverables, flexible in regards to work schedules

Knowledge and experience using BI tools like Cognos and Business Objects

Knowledge of IBM InfoSphere QualityStage, MDM and Message Queue

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere DataStage 9.1, 8.7, 8.5, 7.5, SE 8.1, Informatica

EAI Tools: IBM WebSphere DataStage TX 7.5, 8.0

BI Tools: Working Knowledge of Cognos 8 and Imprompto and Business Objects

Databases: NETEZZA, DB2, CDC, Oracle 11g, MS SQL Server 2000, MS Access

Development Tools: Oracle Designer/2000, Developer suite 10g, 9i including:

Forms, Reports, Procedures, Functions, Packages,

Stored procedures, PL/SQL libraries and Object libraries

Operating Systems: AIX, Solaris, SCO-UNIX 3.2, Windows 8,7,XP, 2003, DOS

Languages: XML, SQL, PL/SQL, Oracle Analytic funcs, MF-COBOL3.2, VB Macros

Others: Eclipse/ISPW, Control-M 6.3, HP Quality Center(Mercury),TOAD, SQL Navigator, Xmlspy, WinSQL, PVCS, VSS, Team Foundation, MS Project, MS Office, Aqua Data Studio, ERWin, Visio, WinScp, Putty, JIRA

PROFESSIONAL EXPERIENCE

ETL/DataStage Consultant AEROPLAN (AIMIA), Montreal, Canada Oct 2013 – Mar 2014

Migrate ETL code from DataStage v7.5 to IIS 9.1 in a distributed environment

Modify DataStage jobs/sequencers and shell/SQL scripts, Unit test, INT, UAT on DB2 with Campaign Management software (UNICA) upgrade.

Conduct performance tests and optimize DataStage code and tune up SQL queries.

Investigate and resolve issues and ensure coding standards compliance.

Prepare Unit test cases, scripts and document test results to promote tested code.

Maintain versions of DS Objects (Export/Import) and other components like scripts.

Participate in team discussions to define strategies and resolve challenging issues

Prepare Deployment checklist and support during and after implementation.

Project: UNICA Upgrade (ETL Migration)

PROFESSIONAL EXPERIENCE continues…..

DataStage Developer CN Railway, Montreal, Canada July 2012 – Sept 2013

Design and develop DataStage jobs/sequences to extract data from various source systems, transform, validate, cleanse and aggregate data and load into target data marts.

Prepare and test ESP schedules on Mainframe to schedule and call DataStage Sequences.

Conduct peer reviews/code reviews for coding standards, performance and best practices.

Promote code and perform unit and Integration tests in DEV/UIT/UAT environments

Version control (check Out/In) using Eclipse/ISPW.

Prepare Promotion/Deployment docs, Process flows, job flows and technical documentation.

Interact with Project Architect, PM, data modeler, BA, DBA, BI and ETL developers.

Provide post implementation support.

Agile Project management, SPRINT planning, Retrospective and Daily Scum meetings.

Participate in designing and testing OLAP cube for IPM project.

Projects: Intermodal Performance Measures (DW/BI Dashboard), Fuel Inter-carrier Reconciliation

ETL Developer Yellow Pages Group, Toronto, Canada Oct 2010 – June 2012

Lead Developer role to design DataStage jobs, sequences, Control M schedules and UNIX shell scripts as per design specs and source to target mapping documents.

Extract data from various sources, transform and generate XML outputs for YP.CA website.

Unit test/Integration tests of the modules/cycles and review end results with the team members and end-users and other stakeholders.

Promote code into different test environments by taking exports and checking Out/In using MS Visual Studio Team Foundation.

Prepare deployment guides and trouble-shoot instructions for support team.

Pick, investigate and fix assigned defects from HP Quality Center, unit test/SIT, promote code fixes and update defect status in QC with details.

Projects: EApproval calling Web Services, CF2YPCA (daily website feed), Single Billing and Ad-hoc Data Fixes

DataStage Developer ExiomTech, Toronto, Canada May 2008 – Sept 2010

Design, develop and unit test ETL jobs, routines and Job sequences using DataStage to interface legacy systems with JDA Point of Sales systems for various clients like Office Depot and Kirkland.

Code SQL and PL/SQL stored procedures in Oracle as part of ETL.

Prepare functional and technical documentation with process modeling, Importing meta data, maintaining source code backups

Design and develop Work flows and mappings using Informatica PowerCenter for EDW project at Shoppers Drug Mart

DataStage TX Developer CAC- Ministry of Finance, Oshawa, Canada Dec 2008 - Mar 2009

Design and develop TX maps to enhance the existing system to process Federal Payments encrypted in EDI X12 formats for EDI FTP Project.

Unit test, Integration test and user approval

Participate in implementation and provide post production support

DataStage Developer Infomaxium, Toronto, Canada Oct 2007 – Dec 2007

Develop and integrate ETL jobs, Sequences and IBM DB2 SQL scripts for Gaming Data Repository for Ontario Lottery and Gaming Corp. (OLG) using DataStage SE 7.5.1 on AIX.

PROFESSIONAL EXPERIENCE continues…..

Integration Specialist KnowledgeNet, Riyadh, KSA July 2003 – June 2007

Develop ETL jobs and routines for Arab National Bank Enterprise Data Warehouse using DataStage EE 7.5.2 by extracting data from various ODS and core banking, that involved complex data transformation and populating EDW from staging area

Develop EAI layer using DataStage TX Maps, Type Trees and Integration Flow Diagrams to develop an Event-driven Application Integration Solution

Design, develop and implement E-Commerce solution SADADLink Integration Solution using DataStage TX 7.5, SQL and PL/SQL in Oracle 10g & Oracle 9i Database, Oracle Developer 10g & 9i (integrates the Billing companies with SADAD billing repository)

Prepare Process model diagrams for SadadLink using Visio.

Conceptualize, design, develop and implement Jussour (used as a gateway for the Message Routing Application to link up the Stock Brokerage Firms using FIX 4.2 protocol)

Develop Transaction Monitoring Application using Oracle 9i DB & development platform

Participate in Unit Tests, System Integration Tests and User Acceptance

Design ER Diagrams for the database model for Transaction monitoring system using ERWin

Study requirements, analyze business process, discuss with client business/technical teams

Provide Systems Support and maintenance to ensure smooth operation and transition

Participate in Unit test, integration test and deployment of the system after User Acceptance

Analyze requirement and develop ETL Proof of Concept on DataStage for a local Bank

Senior Oracle Developer Supreme Commission for Tourism- Riyadh, KSA 2003-2004

Develop, test and implement Document Tracking System using Oracle Database 9i, Developer 9i, Designer, SQL, PL/SQL, Sun Solaris, Windows2000

Develop System Administration screens to control application access and database security

Code enhancements, application security model, conduct Functional test and User approval

Team Lead/Senior Business Analyst ICSM Ltd. Riyadh, KSA 2002 – 2003

Gather business requirements from client discussion, analyze, and translate into technical specs

Prepare test plans and coordinate/communicate with different teams

Interact with the client regarding discussions on User comments and Functional Issues, responsible for closure of Task Order Requests, after resolution and completion

Participate in implementation of Application Enhancements to the Priority Development Systems for Royal Saudi Air Defense Forces

Coordinate with QA/CM, Development/Support and Documentation

Assign tasks and manage resources in the development team

Senior Developer ICSM Ltd. Riyadh, KSA 1999 – 2002

Design, develop and test Application Forms and Reports using Oracle DB, SQL, PL/SQL, Forms and Reports

Review Source Code to optimize and enhance the code performance and readability

Implement configuration change requests as a result of User Acceptance tests

Conducted Systems Integration Tests including setup, workflow, data sharing, data transmission and data integrity

Implemented Programming/GUI Standards document for System Conversion Plan

Assist Documentation team to update User and Systems manuals by providing necessary information about the Application modifications

Maintain proper documentation for every change to be approved and signed off by the client and the main contractor

PROFESSIONAL EXPERIENCE continues…..

Application Developer Merck Marker (Pvt.) Ltd. 1995 – 1999

Develop Sales Forecast System using Oracle Developer/2000, Oracle 8, Windows NT

Redesign and develop Stock & Sales Application for wholesale distribution in RDBMS

Achieve Y2K compliance, develop GUI application to benefit from the features of RDBMS

Perform testing and implement at whole sale distributors, provide end-user training

Gather requirements, design, develop and implement Student Information System to maintain complete status of faculties and students’ historical information using Developer/2000 (Forms and Reports) SQL & PL/SQL and Oracle database 7.3

Convert Stock & Sales System for Warehouses from COBOL to oracle 7.3 & Dev/2000

Design, develop, implement and End User training on Duplicate Billing System for a telecom using MF-COBOL 3.2, SCO-Unix

Develop MIS reports e.g. sales achievements against targets, stock status at each wholesale distributors for Merck’s field force using MF-COBOL, DOS 6.22

Senior Programmer KPMG Peat Marwick Ltd. (I.T. Consultants) 1992 – 1995

Develop General Ledger Accounting System using MF-COBOL 3.1 based on DOS and UNIX operating environments

Develop General Ledger Accounting and Payroll applications for NWFP Agricultural University using MF-COBOL 3.1, SCO UNIX 3.2

Develop Financial Accounting Systems for ATTOCK Oil Refinery including General Ledger, Inventory Control and Payroll modules on Oracle 6.0, SQLFORMS 3, ReportWriter, SCO UNIX

EDUCATION AND TECHNICAL TRAININGS

Bachelors of Commerce, University of Karachi

Diploma in Computer Science, Sind Board of Technical Education

DataStage Training, KnowledgeNet, Riyadh, KSA

DataStage TX Fundamental Training, KnowledgeNet, Riyadh, KSA

DataStage TX Advanced Training, KnowledgeNet, Riyadh, KSA

Oracle Developer/2000, Softvision, Karachi

Business Objects, KnowledgeNet, Riyadh, KSA

Cognos 8, KnowledgeNet, Riyadh, KSA

Project Management Professional Training (PMP), Riyadh, KSA

Contact this candidate