Post Job Free

Resume

Sign in

Manager Data

Location:
Vaughan, ON, Canada
Posted:
October 20, 2016

Contact this candidate

Resume:

ABOL ASGHARI

** ***** *****

Richmond Hill, Ontario L4E 4T3

Phone: 647-***-****

E-mail: acw5sw@r.postjobfree.com

PROFILE

A result oriented and seasoned Business Intelligence and Data Warehouse professional with extensive experience in Data Modeling, Architect, Design, Development, Performance improvement, Support and Maintenance, Training, Leading Teams and Managing Projects. Customer oriented and friendly team player, who always exceeds organizational and client expectations and demonstrated strong planning, problem solving and interpersonal skills.

QUALIFICATION SUMMARY

Over 15 years of experience in BI, Data Warehousing, Data Modeling, Data Architect and ETL

Over 15 years of intensive experience in Database design and development

Hands on experience in QA and end-to-end data validation for ETL & BI systems

Extensive experience in Finance, Banking, Manufacturing and Public sectors

Web application development and design experience

Years of practical experience in managing projects, architecting, analysis, design, development, implementation, support and maintenance within different platforms

Demonstrated sound business judgment, decisiveness, and well-developed planning, analytical, and communication skills at a consistently high level of performance in a variety of progressively responsible and challenging assignments.

Achieved project and organizational goals by establishing excellent working relationship with co-workers and clients

Excellent communication skills with teamwork spirit

Enthusiastic quick learner of new technology and processes

Utilized the best industry standard and practices in full SDLC

SKILLS

OS : Windows, UNIX, Solaris, MVS

Databases : ORACLE, SQL Server, DB2, MS-Access

Languages : VB, VB.NET, ASP.NET, C#, C++, Java, T-SQL, PL/SQL, HTML, COBOL

Methodologies : SSADM, RAD, Waterfall, Incremental, Agile

Design/Modeling : MS-Visio, ERWIN

BI and Analytics : IBM COGNOS 10 BI Suite, MS Server BI Suite, Business Objects, Tableau, R

Data W/H : Dimensional and Relational modeling, Knowledge of Hadoop (HIVE, Map Reduce)

ETL : Informatica PowerCenter, MS SSIS, COGNOS Data Manager

PROFESSIONAL EXPERIENCE

Deutsche Bank Global Technology, June 2015 – July 2016

Assistant Vice President, COGNOS/ETL Architect

Managed requirement analysis, design and development of Regulatory related reporting applications

Utilized Global Change Management system to manage all projects deployments to production

Gathered and analyzed user requirements and provided Functional documentation

Designed BI reporting models by utilizing COGNOS Framework Manager (FM)

Created all mapping documents for Data, Process and Business layers of reporting models

Designed tables, views, functions and stored procedure to support reporting models

Architected complete Data Warehouse solution including Database and ETL process

Utilized Informatica PowerCenter to develop new requirements and maintain ETL application

Led the off-shore and onsite development team in metadata models and reports development

Designed full security levels in FM model to manage variety of security requirements

Defined system test strategy and plans, test data and test standards

Performed and led the end-to-end and cross-reference data validation plans

Led the test team and business users to perform Functional and Non-Functional testing

Led the support and maintenance team in stabilizing and implementing new BI solution

Platform: Unix, IBM COGNOS 10, Oracle, Informatica PowerCenter, TOAD, CONTROL-M, Service Now

VF Services, May 2013 – Dec 2014

Architect, Lead COGNOS Architect

Gathered, analyzed user requirements and provided Functional documentation

Designed Enterprise Data Warehouse to support management analysis and reporting needs

Designed BI reporting model by utilizing COGNOS Framework Manager (FM)

Created all mapping documents for Data, Process and Business layers of FM model

Designed tables, views, functions and stored procedure to support FM model

Participated in all aspects of EDW modeling with other team members and business users

Led the off-shore and onsite development team in developing FM model and BI reports

Designed row level and object level security in FM model to manage different security requirements

Defined system test strategy and plans, test data and test standards

Led the test team and business users to perform Functional and Non-Functional testing

Performed and led the end-to-end and cross-reference data validation plans

Managed and led the support and maintenance team in stabilizing and implementing new BI solution

Platform: Unix, COGNOS 10, IBM DB2, SAP and IBM Data Stage, TOAD, CONTROL-M, ALM

CCI, May 2012 – May 2013

Sr. Consultant, IBM COGNOS and ETL Lead

Design team member of METHODE Data Integration/Data warehouse project

Designed Data Warehouse to support management analysis and reporting needs

Created tables, views, functions and stored procedure and optimized them during development

Designed ETL process to integrate 20 Solarsoft ERP data sources including data cleansing, transformation, load and scheduling

Created all mapping documents for staging and DW environments

Led the ETL development team and contributed in developing SSIS packages

Designed all required supporting tables to manage the process and proper scheduling of the jobs

Contributed in designing of Data, Process and Business layers of Framework Manager model/package

Defined system test strategy and plans, test data and test standards

Led the test team and business users to perform Functional and Non-Functional testing

Performed and led the end-to-end and cross-reference data validation plans

Platform: COGNOS 10, SQL Server 2008, SSIS, DB2 and MS Visio 2010

CPAS, March 2012 – May 2012

Sr. Consultant, IBM COGNOS BI & Data Warehouse

Provided support and maintenance contract service for Pension Plan Administration application reporting (COGNOS reports)

Developed new COGNOS reports, database views and performed trouble shooting of existing reports

Supported and maintained application interface with COGNOS services

Assisted junior team members in their daily tasks and knowledge improvement

Platform: COGNOS 8.4 Report Studio, Framework Manager, Oracle PL/SQL

Accenture Canada, Nov 2010 – Dec 2011

Manager, IBM COGNOS BI & Data Warehouse Architect (Telecom Company)

Lead the design and development of Call Center Agents Performance and Monitoring system for one of the major telecom service providers in Canada. The major tasks for this project are:

Performed requirement analysis with stakeholders

Identified all input data sources, output tables and data integration processes

Designed Data Model including staging area and dimensional (Star schema) model tables

Created Entity Relational Diagram (ERD) and Process Flow Diagram (PFD)

Created Functional Design and Data Mapping documents, naming conventions, data quality and cleansing rules

Trained team members and transferred knowledge for development activities

Designed and developed interactive dashboards by utilizing Tableau visualization tool

Deeply involved in SSIS and SSRS development activities while leading the team

Supervised and coordinated all development activities to assure quality and compliance

Managed client change requests and applied modifications upon feedbacks

Defined system test strategy and plans, test data and test standards

Led the test team and business users to perform Functional and Non-Functional testing

Performed and led the end-to-end and cross-reference data validation plans

Platform: SQL Server 2008 SSIS, SSRS, SSAS, Informatica PowerCenter, COGNOS 8.4,Tableau and MS Visio 2010

Accenture, COGNOS BI SME (for Financial Institute client)

Member of an expert’s team conducted an assessment on Trading Risk Analysis system

Conducted workshops for data gathering, client inputs of Data Warehousing and Reporting component

Reviewed all documents and interviewed Data Architect, Project manager and Development lead

Evaluated project development life cycle for COGNOS Reporting project and provided final report including people, hardware, software, gaps, inconsistency and non-compliance cases

Platform: DB2, COGNOS BI 10

GlaxoSmithKline Inc. (GSK), May 2010 – August 2010

Sr. Consultant, COGNOS BI & Data Warehouse

Utilized POWEREPLAY Transformer in designing, enhancing and re-building the Activity Master MDC

Designed and developed Territory Time Management and Call Management reports from COGNOS POWERPLAY cube (Dimensional Reporting)

Utilized Framework Manager to design Dimensional and Relational model

Gathered client requirements, analyzed different solutions and implemented the best one

Consulted other members of project in their troubleshooting and supporting activities

Tested and successfully implemented project and trained users

Platform: COGNOS 8.4 Report Studio, Framework Manager, POWERPLAY Transformer, Oracle PL/SQL

CGI Inc., August 2007 – May 2010

Sr. Consultant (Banking & Investment), COGNOS BI & Data Warehouse

Utilizing Framework Manager to design new Relational COGNOS models

Providing maintenance and support service for over 15 major financial institutes and investment groups

Performing COGNOS administration activities, training clients, documentation and finalizing requirements

Mentoring and providing technical support for junior team members

Developing new stored procedures and views in order to provide solutions for clients requirements

Enhancing existing stored procedures, views and packages in order to improve performance

Planned and successfully performed migration of Royal Bank Investment Group (RBC Dexia) MView package from COGNOS C8 to 8.2 in order to increase the overall performance (+100%)

Designed and developed the Financial Statement Model-Package for RBC Dexia

Designed and developed the entire MFolio (Client Statement) Model-Package and report for Raymond James Investment (RJ)

Planned and successfully performed migration of TD SMA MFolio package from COGNOS C8 to 8.2 in order to increase the overall performance

Customized and Implemented the MView Model-Package and reports for RJ, FelCom and Investors Group (IG)

Supporting, maintaining and enhancing the MView Model-Package and reports for RBC Dexia, RJ, FelCom, TD SMA, National Bank of Canada and Investors Group

Supporting, maintaining and enhancing the MFolio Model-Package for Raymond James Investment, TD SMA and National Bank of Canada

Platform: COGNOS 8.x Report Studio, Framework Manager, UNIX, Windows, Oracle PL/SQL, Visio, VSS

Sierra Systems Group Inc., September 2004 – August 2007

Sr. Consultant, COGNOS BI & ETL

Designed and built data cubes, creating new reports and maintaining existing cubes and reports for Pilkington North America (PNA)

Supported large group of PNA users across North America using COGNOS tools such as

POWERPLAY Transformer, COGNOS Web Report, IMPROMPTU and UPFRONT

Responsibility of supporting and maintaining all the Data Warehouse objects and operations from manual ETL scripts to building cubes and solving users and clients problems

Improved ETL performance by optimizing stored procedures, views, indexes and scripts

Planned and developed all enhancements of ETL scripts to prevent the FTP job failures and as a result enhancing the production performance and increasing customer satisfaction.

Analyzed and Improved “YEAR END closing” procedures and scripts resulted in reducing processing time by 70%

Planed, managed and implemented the enhancement of eCard application suite of Toyota Canada Inc., enhancement and modernization project from a home grown to a fully supportable application with documentation.

Analyzed, planned, developed and successfully implemented other enhancement projects.

Platform: Windows, UNIX, COGNOS 7 (IMPROMPTU Web Report, POWERPLAY Transformer, Upfront)

Data Manager, Oracle PL/SQL, SQL Server 2000 (T-SQL, DTS), DB2, MVS, COBOL, Visio

Dyad Infosys Ltd., November 1998 – July 2004

Consultant, COGNOS BI & ETL

Performed requirement and Data Analysis, investigated on the existing Data Warehouse and Designed new data warehouse application. Developed and supported Data Warehousing Application for Foster Parents Plan. Using COGNOS IMPROMPTU, I designed and developed unique and easy maintainable catalog (Data Model) for entire organization. Also using COGNOS POWEPLAY transformer, I designed and created all required cubes (Multi Dimensional Cube) and major reports for departments. In the production environment I designed and developed all SQL stored procedures, COGNOS macros and VB programs to automate full process of ETL, building cubes, generating special reports and transferring from backroom to the front. I was able to increase the production performance more than %60.

Designed and developed new reports and data cubes for Ministry of Health (seven GTA Community Care Access Centers). Conducted data analysis, identified problems weaknesses of existing data warehouse application and prepared an automation plan. Developed all required scripts to automat full process of ETL, building cubes and transferring to the clients’ sites. Using VB, Windows and SQL Server Job Scheduler and other tools to automate complete process, decreased processing time from 48 hours per week to 18 hours.

Designed and developed Data Warehouse Application of Ministry of Health (COTA Service provider for MOH) including Catalog, IMR Reports and MDC, and automated full process from ETL to transferring results to the client’s sites.

Upgraded the NYGH’s MEDPHARM and COTA “Ordering system” to meet Y2K compliance

Upgraded the Claims and Payroll system of HSC and RMA to meet Y2K compliance

Designed, developed, maintained and supported the “SHIFT SCHEDULING Web application” for Toronto CCAC to facilitate scheduling and remotely signing up by employees.

Platform: Windows, UNIX, ASP.NET, VB.NET, C#, VB & Java Script, HTML, COGNOS Tools,

SQL Server 7.0 & 2000, DTS (SSIS old version), Oracle 8, COBOL, POWERHOUSE (4GL), Visio

EDUCATION

B.Sc. in Computer Applications and System Analysis

TRAININGS:

COGNOS 8 Data Manager (Decision Stream) Certification

COGNOS 8 Report Studio Certification

COGNOS 10 TM1

SAP BI (Business Intelligence)

ASM CERTIFIED PROFESSIONAL

CLIENT SERVER PROGRAMMING (VB, SQL Server, Oracle and C++, Java)

PROJECT CONTROL MANAGEMENT SYSTEM (PERT & CPM)

VALUE DRIVEN PROGRAM MANAGEMENT



Contact this candidate