Data Sql Server
Resume:
Zahid Mehmood Ph: 647-***-****
***-**** ************ ** 905-***-****
Mississauga, ON L4X 2T5 Email: *********@*****.***
------------------------------------------------------------------------------------------------------
Summary
• Over 6 years of experience in Data Warehousing on various Databases with a total IT experience of 9 years.
• Good Knowledge in BI tools Hyperion, Webfocus, BO and Cognos.
• Expert knowledge in Databases and tuning techniques (DB2, Oracle, SQL Server, etc)
• Experienced in data modeling and dimensional modeling concepts, data warehousing, data marts concepts.
• Extensive working experience on Unix and Windows platforms.
• Extensively involved in the development of DataStage ETL processes.
• Worked on DataStage 8.10/7.5.x/7.5.1 and Erwin 4.x.
• In depth experience in dealing with various Ascential DataStage stages (Pivot, Ftp, Merge, Sort, Agg, Lookup, Join, Funnel, Hash File etc).
• Involved with various parts of SDLC process starting from development through Production and then in production support.
• Developed DataStage jobs in Server and Parallel environment.
• Extensive use of Job parameters both customized and environment variables.
• Migrated DataStage Jobs from 7.5.x Version to Datastage Infoshpere 8.1 version.
• Used version control to move jobs from development environment to UAT (QA) and then to Production.
• Used DataStage Director to validate and run the dataStage jobs and usage of peek stage for debugging.
• Used built in routines and created user defined routines in DataStage.
• Scheduled Shell scripts through Automate, crontab, autosys to kick off the sequences and jobs.
• Experience in Hyperion 8.5, Webfocus 7, Business objects 6.x/5.x (Supervisor, Designer, Reporter).
• Excellent communication and interpersonal skills. Versatile team player with proven problem solving skills.
Technical Skills
Environment UNIX AIX 6.1/5.2/5.3, HP UNIX, Sco Unix, Linux 8.x/7.x, Windows 7/2003/XP/NT
ETL Tools Datastage 8.1/7.5.1/7.5/7.1/6.0 (Designer, Director, Manager, Administrator), SQL Server Integration Services 2005, ProfileStage
Reporting Tools Oracle Hyperion 8.5, Webfocus 4/7, Business Objects 6.5 (Supervisor, Designer, and Reporter), Cognos 7.0/6.6/5.0, Crystal Reports
RDBMS Oracle 8i/9i, SQL Server 6.5/7/2000/2005, MS Access, TeradataV2R5, DB2 UDB 9.5/9.0/8.x
Programming SQL, Dbvisualizer, PL/SQL, SQL Navigator5.0/4.0 SQL *LOADER, SQL*Plus, Unix Shell Scripting and TOAD, ASP, VB, VBScript, HTML
Communication Software Citrix, Check Point VPN 5.1, VMware, VNC, IIS, Wingate, PC Anywhere
Application Package CGI`s CORE Investment Applications (RSP, RIF, TFSA), MS Visual Studio, MS Office 2003, Visio Professional 2007, Erwin, HP Quality Center 9.2, Bugzilla
Education:
• M.Sc. Computer Science
Professional Experience:
Canadian Imperial Bank of Commerce (CIBC), Toronto, Ontario Mar-10~ Date
ETL Developer/Analyst
CIBC is one of Canada's leading financial services provider. Working in data warehouse for Retail Markets Technology (GDP-RMT) for GICs, Deposit Accounts, Global Payments and Wealth Management/Investment Products.
CIBC`s Wealth Management (RRSP, TFSA, RRIF) data warehouse is populated from a daily nightly batch process where data warehouse collects, organizes and stores data from CORE application in the form of xml and other operational systems to provide a single source of integrated and historical data. This Data Warehouse is used for reports and interface files generation to feed into other systems/applications.
Responsibilities
• Providing Production Support for daily and monthly production issues. Analysing and trouble shooting the problems in timely manner.
• Creating Operational Support and High Level Design documents for the processes.
• Project plan for any implementations following the Change Management procedures to create CM record, CAB and TAB approvals.
• Frequently used Hash files for lookups and as staging files to improve the performance in Server Jobs.
• Designing and Support for Hyperion Brio.
• Datastage Code Migration from datastage version 7.5 to datastage 8.1.
• Developed jobs for xml and complex files to load into data Warehouse.
• Designed Parallel jobs using Surrogate Key, Transformer, Row Generator, Column Generator, Compare, Modify, Lookup, Join, Funnel, Merge, Sort, Aggregator, DB2.
• Developed Batches and Sequence jobs in designer to run and control set of jobs.
• Developed Best Practices exercises and common routines.
• Involved in unit testing of Datastage jobs, integration testing of the Job sequencers with master sequencers and finally the UAT of whole Business Release.
• Write Unix Shell scripts to manipulate files, pre and post-processing of files.
• Involved in Performance Tuning of DataStage Jobs.
• Participating project walkthrough sessions before handing over to production support team.
• Running of test batches in UAT, PREPROD environments for any major implementations.
Environment
Datastage Infosphere 8.1, Db2 9.5, Autosys, MS Visio, Oracle Hyperion 8.5, AIX 6.1, HP Quality Center 9.2, HP Service Center, MS Project
Royal & SunAlliance Ins., Toronto, Ontario Apr-07~ Dec-09
ETL Developer
Royal & Sun Alliance (RSA) insurance company offers property and auto insurance in Canada. Involved in designing, development, implementation and support of RSA`s multi-terabyte data warehouse in multiple projects. In most of the projects involved in data migration from mainframe legacy systems to midrange data marts and then to data warehouse using datastage and SSIS.
Responsibilities
• Involved in designing the processes to extract data from mainframe, xml files, spread sheets and databases to load into data Warehouse and data marts.
• Used Enterprise and Server editions of DataStage to build jobs.
• Implementation of complex logic by using various DataStage stages (Modify, Lookup, Join, Funnel, Merge, Sort, Aggregator, DB2 etc) in PX.
• Designed Custom stages for complex mapping/functions using C++.
• Prepared & presented training sessions and presentations for datastage beginners.
• AutoMate scheduler scripts using dsjob to get the return code for error handling and notification purposes.
• Worked on Production Support issues during the monthly and daily production loads for more than 15 datastage applications.
• Migrated and tuned up datastage 7.5.2 version jobs for datastage 8.10 version.
• Used the ETL and SQL tuning techniques in most accurate way for increasing the speed of job execution
• Worked on Webfocus for reports generation.
Environment
Datastage Infosphere 8.1, Datastage 7.5.2/Parallel Extender, Db2 UDB/Z-OS 8.0/9.0, SQL Server 2005/SSIS, Crystal Reports, AutoMate 7.0/8.0, MS Visio, Erwin Data Modeler 4.1, Webfocus, ASP, JCL, Bugzilla
Regence Group, Salt Lake City, UT Mar-06~Feb-07
DataStage ETL Specialist
The Regence Group is a healthcare organization in US and is a close affiliation of Blue Cross/Blue Shield. The Regence Group’s REWARDS (Regence Warehouse, Reporting and Decision Support) project, based on DataStage , which is used to combine and enhance terabytes of operational data from its four affiliate companies into a single company-wide decision support platform.
Responsibilities
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
• Developed Parallel jobs for extracting, cleansing, transforming and loading data into Data Warehouse.
• Used Profile Stage to do the data analysis before the ETL by dataStage.
• Involved in implementing Slowly Changing Dimensions.
• Scheduled Sequence jobs using datastage Director.
• Created jobs to FTP source file from remote systems.
• Wrote PL/SQL scripts to validate the data after loading process.
• Used DataStage Manager to Export/Import jobs from environment to environment.
• Created User Acceptance Test and Integration Test plans in Test Director and validated the results.
• Production Support for various datastage applications.
• Wrote Shell Scripts to run DataStage Jobs, supplied parameters on fly to DS Jobs.
• Involved in report generation process using Business Objects (OLAP).
Environment
Data Stage 7.5.1/Parallel Extender, ProfileStage, Oracle 9i, PL/SQL, DB2 UDB 8.1, IBM-AIX 5.3, Erwin Data Modeler 4.1, PVCS, Test director 8.0, Business Objects 6.5
Fifth Third Bank, Cincinnati, OH Apr-05~Feb-06
Data Warehouse Developer
Fifth Third Bank provides banking, investment and electronic payment processing services to 5.7 million customers through 17 affiliates. The project involves extraction of data from the legacy system and creation of data marts and then integrating all the information into the data warehouse. Involved in running month end load and production and taking care of any lack of uniformity in data by making scrubbing Jobs for them.
Responsibilities
Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse. The data was standardized to store various Business Units in tables.
Analyzed Business Requirements, Analytics and strategies to improve the business.
Involved in designing server jobs mainly using hash files.
Extensively worked with DataStage and its components for Data cleansing and conversion and loaded data into target database.
Extensively involved in creating database procedures, functions and triggers.
Created DataStage jobs, batches, Job Sequences and tuned them for better performance.
Extensively used Hashed files to improve the performance of jobs
Used stages like Link Partitioner, Link Collector, Hash Files, Sequential File stage, ORAOCI, ODBC stages in jobs.
Involved in designing custom Routines and use of stage variables in certain jobs.
Creation of Shared containers so that it can be used by other modules of the plan.
Analyzed the performance bottle necks and fine tuned the jobs.
Wrote Unix Shell Scripts to automate the process
Environment
Ascential DataStage7.5, Erwin 4.0, Windows 2003, AIX 5.2/5.3 UNIX (Ksh), Oracle 8i, DB2 UDB 8.1, PL/SQL, Shell Scripts, SQL Navigator 4.0/5.0, PVCS, Cognos 6.6
Sears Roebuck & Co, Chicago, IL Jan-04~Mar-05
ETL Developer
This Business Data Mart is developed for Sears Apparel and Merchandising Division as a perfect and a managed tool that was piloted during the fall of 2004 aimed at producing circumstance-based management alerts highlighting at store level conditions of key item under-supply and over-supply. The Data mart created in this version was loaded at 2 a.m. on daily basis and reports from it were generated by early morning.
Responsibilities
• Used Ascential DataStage and migrated data from Oracle, SQL Server and other flat file data sources.
• Involved in the development of dimensional data models using Erwin as per the specified business requirements.
• Analyzing and defining Targets of the Data Mart.
• Studying the business requirement and developing functional and technical specifications accordingly.
• Analyzing business requirements of the Data Mart building.
• Importing data from their legacy databases to verify data discrepancies.
• Developing logical and physical models of the target database. Followed Star Schema in designing the target database tables.
• Creating some sequential files to have test data for loading into target.
• Involved in creating correct mappings and aggregating data to correct level.
• Created Server Edition jobs to do Inner Join and Left Outer Join using hash files.
• Used some aggregators and date transformations in designing the jobs.
• Use of Stage Variable was done to implement complex mappings and constraints to filter.
• Developed routines with case statements and used in built routines / transforms.
• Developing DataStage jobs for the required alerts and testing the designed jobs with varied data sizes for performance evaluation.
• Used local and shared containers.
• Scheduling the jobs with CronTab of Unix, Event Coordinator for batch transfers of data.
• Worked on migrating jobs from DataStage 7.1 to 7.5 version.
• Creating Business Objects Universes and loading the data into the Repository.
Environment
Unix (ksh), Windows NT workstation 4.0, Erwin 4.0, DataStage 7.5/7.1, Business Objects 6.1, Oracle 8.0, SQL Server 2000
Horizon Lines, Dallas, TX Feb-03~Dec-03
ETL Developer
Horizon Lines is a containerized solutions provider for shippers moving cargo between the continental United States, Hawaii, Guam, Alaska and Puerto Rico. The primary objective of the project is to develop Horizon lines system making extensive use of Data marts. The objective is to extract data stored in different databases and load into Teradata data warehouse.
Responsibilities
• Designed the mappings between sources (external files and databases) to operational staging targets.
• Studying the business requirement and developing functional and technical specifications accordingly.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database
• Used Parallel extender for splitting and organizing the data into subsets and to achieve better job performance.
• Performed Unit testing and Integration testing of the module.
• Used various Ascential Datastage stages Modify, Funnel, Lookup, Join, Copy, Sort, Column Gen. with PX Edition.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
• Used the DataStage Director and the runtime engine to schedule running the solution, testing and debugging its components and monitoring the resulting executable versions (on ad hoc or scheduled basis)
• Used Job Sequencer for integrating and running the jobs in sequence and shell script is developed to call the Job Sequencer
• Used Lookup transformations to manipulate the data
• Replaced the manual extraction with automatic process using DataStage tools.
• Developed Shell scripts to automate file manipulation and data loading procedures.
• Involved in the preparation of documentation for ETL using DataStage standards, procedures.
• Making in the user resources more flexible as per the business requirements by exporting Universe & BO reports
Environment
Ascential DataStage 6.0, Business Objects 5.0, Oracle 8i, Teradata V2R5, SQL, Shell Scripts, Windows NT 4.0., Unix SVR4 MP-RAS
Softech WorldWide LLC, Sterling, Virginia Feb-02~Jan-03
Developer
Responsibilities
This project included website administration module, Shopping Cart, Online Membership, Guest book Messages, News Section, Inventory Control, Online shopping, Online News.
• Developed a method that automates the headline news display for the users. The method also takes care of displaying the news according to its preference date and weight.
• Email News Subscription to send news as email to subscribers.
• Image/file uploading module for News and Product images.
• Online credit card transaction for a customer on secure site using VeriSign.
• Online membership and donations.
• Design, development and uploading of website.
• Design & development of database using MS SQL Server.
• Used Visual Source Safe for version control.
Environment
ASP, Java Script, VB Script, SQL Server 2000, Windows 2000 Server, Visual Source Safe
Interboro Medical Care & Diagnostic, New York, NY Aug-01~Jan-02
Developer
Based on different departments of the organization like Orthopedics, Chiropractic, Radiology and medicine, there was a requirement of user-friendly web interface for data entry. This was a project for patient data management. The goal was to make the patient data entry in to user-friendly computer based patient record system.
Responsibilities
• Wrote various procedures using PL/SQL and PRO*C
• Worked extensively with database procedures, functions, cursors, joins and triggers
• Developed screen to enter, update and delete records using developer 2000
• Generate weekly, monthly and yearly reports of the employees Involved in enhancement of reports
• Single handedly implemented complex business rules
Environment
Windows NT, UNIX, Oracle 7, MS-Access, Developer 2000 (Forms 5.0, Reports 3.0)
Contact this candidate