IFFAT SHABBIR (PMP, MSc Computer Science)

Brampton ON, L7A 0M6 Tel: 647-***-**** Email: acgc33@r.postjobfree.com

TARGET: IT PROJECT MANAGER

IT Project Manager with 12+ years’ experience in end-to-end oversight of sophisticated IT projects supporting

business critical data, reporting, analytics, and operational support functions within complex, nationally-scaled

enterprise organizations within the media and communications industry. Offers strong knowledge of all phases of

SDLC (system development lifecycle) & PMLC (Project Management Lifecycle), combined with a proven talent for

bridging gaps between technical and business-side personnel. Brings a solid reputation as a collaborative team

player and leader along with exceptional skill in training, mentoring, and developing junior technical professionals.

Possesses a wide breadth of technical expertise in data warehousing, business intelligence, and finance systems

and technologies in addition to outstanding analytical and problem solving skills.

TECHNICAL PROFICIENCIES

Database/BI/ETL Tools: SQL Server, Visual Management Studio, T_SQL, DTS, SSIS, SSRS, Oracle, Oracle

Developer, PL/SQL, Queryman, Clear Access, MRE/Web Focus, FoxPro, MicroStrategy, Cognos, Teradata,

Informatica.

Applications: CRM, Campaign Management Software.

MS Office: Word, Excel, PowerPoint, Access, Outlook, Project, Visio, VBA Coding.

PROFESSIONAL EXPERIENCE

SENIOR PROJECT MANAGER – ENTERPRISE BUSINESS INTELLIGENCE 2013-Present

MANAGER – DATA DEVELOPMENT PROJECTS– CREDIT OPERATIONS 2011-2013

MANAGER – DATABASE & KNOWLEDGE MANAGEMENT PROJECTS– SALES OPERATIONS 2008-2011

Rogers Communications Canada, Brampton ON

Brought on board with this prominent Canadian communications and media company in a technical management

position in direct support of sales operations, before being entrusted with positions of progressive accountability

and authority, culminating in a senior project management position within the enterprise business intelligence

organization.

As SENIOR PROJECT MANAGER – ENTERPRISE BUSINESS INTELLIGENCE

Responsible for all aspects of project management, from initial assessment to the go-live stage at the head of

a diverse, multidisciplinary team comprising BAs, solutions architects, developers, DBAs, and technical leads.

Responsible to lead presentations to executive board from project concept to funding approvals.

Produced project artifacts and documentation including charters, integrated plans, resource plans,

contingency plans, financial plans and additional PM documents within pertinent enterprise risk, audit, and

compliance standards.

Managed multiple medium to large size projects including delivery of data marts enabling in-depth reporting

& analytics in response to business needs established by internal operations and client-facing customer care

teams, data migration from legacy server, Golden Gate replication, BCV/flashcopy projects etc.

Oversaw a team representing multiple internal IT groups and vendors in the production of an integrated data

repository sourcing data from various internal ITS applications.

Leveraged a strong technical background to provide coaching, guidance, and mentorship to junior team

members throughout the project development and execution cycle, effectively bridging the gap between IT

and business teams.

As MANAGER – DATA DEVELOPMENT PROJECTS – CREDIT OPERATIONS

Took the lead in data development reporting projects with the aim of providing self-serve reporting capacity to

business units within credit operations as well as in server capacity planning, backup, and recovery policies

and procedures.

Administered a team of senior-level ETL report developers and DBAs and coordinated efforts and deliverables

in order to meet project objectives, timelines, and scope parameters.

Offered comprehensive coaching and mentorship to new and incoming IT personnel to achieve the optimal

development of solutions designs into functional applications and systems.

Completed a data development project for the build out of an integrated data repository sourced from various

ITS systems and populated the dedicated credit operations server using SQL Server.

CONTINUED…

IFFAT SHABBIR

PAGE 2

PROFESSIONAL EXPERIENCE CONTINUED…

Rolled out 200+ reports to support operational reporting and strategic decision-making, incorporating more

than 60 tables within the server as technical lead for data, server, and reporting operations.

Produced a training plan for delivery to the reporting group in order to maintain a newly-established data

reporting environment, while assuming complete authority for the mitigation of server failures.

As MANAGER – DATABASE & KNOWLEDGE MANAGEMENT PROJECTS – SALES OPERATIONS

Delivered a sales data mart solution sourcing information from vendors and internal ITS systems, and

provided a stable reporting and data environment supporting end-to-end sales operations.

Steered the successful completion of a data development project for the automation of data needs for the

Microsoft CRM Dynamics used throughout the national enterprise by sales agents and managers.

Directed the automation of data feed into sales tools allowing national sales agents to conduct and record

sales, and enable executive management to pull reports in support of decision-making for strategic sales

operations.

Managed vendor relations surrounding a third-party-hosted web based account transition tool in order to

ensure delivery of raw data in compliance with business needs and requirements while correcting errors and

inconsistencies.

MANAGER, BUSINESS INTELLIGENCE 2007-2008

MANAGER, SMB PERFORMANCE MEASUREMENT /REPORTING 2004-2007

Bell Canada, Toronto ON

Handpicked to join the staff of this leading Canadian telecommunications firm in a management role in small

business performance measurement and reporting. Later joined the data analytics and business intelligence team

with a mandate in conducting intensive data analytics to increase the efficiency and effectiveness of marketing

campaigns while overseeing all aspects of business intelligence.

Played a key leadership role for business intelligence operations including the compilation, interpretation, and

value-added analysis of customer churn data to support retention campaigns managed by the marketing

department.

Coordinated the efforts of multiple reporting teams in compiling data into a KPI dashboard and processing

information from within the team for presentation to executive management personnel on a weekly basis.

Acted as key lead in business requirements document (BRD) development for new product bundles launched

to the market from a reporting perspective and translated requirements into efficient programming code.

Led the design and automation of multiple reporting dashboards including Campaign Tracking Dashboard and

Revenue Reporting, enabling data refreshing without manual intervention using Excel, PowerPoint, and Oracle

SQL server.

Oversaw VBA programming and SQL server management to ensure the automated refresh of reporting data in

order to accrue considerable savings with regard to both time and cost.

VARIOUS CONTRACT POSITIONS

2002-2004

Rogers Communications, Toronto ON

Recruited by Rogers in a series of consecutive contract positions including Reporting Analyst – Finance, Sales &

Marketing, Database Analyst – Marketing, Database Analyst and Programmer – Finance, and Reporting Analyst and

Programmer – Direct Sales Fulfillment Operations and earned the trust of management based on consistent,

outstanding performance.

As Reporting Analyst – Finance, Sales & Marketing: analyzed and translated user requirements into

technical specifications prior to coding programs in MRE/Web Focus, and led the automation of recurring

reports.

As Database Analyst – Marketing: prepared complex customer lists in support of marketing campaign

management and took the lead in identifying data needs and sources, ensuring data integrity, and authoring

related SQL queries.

As Database Analyst & Programmer – Finance : led analysis, development, and implementation of a

commission inquiry database using MS Access and Visual Basic code to provide for the unit’s complex

financial data needs.

As Reporting Analyst & Programmer – Direct Sales Fulfillment Operations : produced and rolled out

an extensive corporate profile database to assist sales and fulfillment teams at the national level.

Additional Experience includes Programmer Analyst (1998-2001) Ravi Autos; and Programmer (1996-1998)

Longman Mills.

EDUCATION & PROFESSIONAL DEVELOPMENT

PMP Certification (2014) PMI Leadership Express (2011) Rogers Canada Managing Matters (2009)

Rogers Canada

MSc. in Computer Science – Information System Analysis, Design & Development (1996) Quaid-i-Azam

University, Islamabad

BSc. in Mathematics (1993) Punjab University, Lahore

Contact this candidate