MBA, PMP, CPA, CMC, in addition to ** years of Technology Arctitect experience in the big 5 consulting firm

PROFILE: Sr. Data Program Manager

Summary

I am a Senior Program Manager, a Pragmatic Sales and PMP certified Leader with 10 years of sales, delivery and marketing experience, accelerates growth for IBM Professional service providers, MSP’s and technology vendors with a bespoke range of consultancy offerings, project manger, and Queen’s University graduate groomed in big five multinational consulting firms (Arthur Andersen, Deloitte and Touche, Ernst & Young, KPMG and PricewaterhouseCoopers). Currently responsible for overall IBMs Finnacial Clients Data Analysis and Business Integliance systems implementation, upgrade, and optimization with heavy specialization in the Data Warehouse, Data Marts, and Reporting. Strong interpersonal, technical and leadership skills have resulted from multiple leadership roles in small and large size organizations. Significant operational experiences gained in Retail Banking, financial, health, and banking industry. High standards of professionalism, ethics, people management skills and technical fluency. Demonstrated ability to lead in a highly dynamic environment and perceived as a member of the business leadership team first – Program Executive professional second.

End-to-end expertise installing, configuring, implementing, and maintaining Enterprise BI, Data Integration, and Visual Analytics reporting solutions as well as the industry-specific Retail Banking Combined expertise in the development of effective data infrastructure, ETL processing, data warehouse, data modeling, and business intelligence reporting and dashboards. Combined experiences both on the technical side and business side of information technology and software design

Gained broad experience across diverse range of technologies and business architectures. Expertise in understanding and assessing current reporting capabilities against business goals and critical needs, and formulating cost effective solutions and tactical plans. Specialising in working with and managing large and complex changes in environments involving high risk, uncertainty and diverse or competing stakeholder interests. Key skills areas include:

I developed Strategic Business Plan that secured $160 million venture capital start-up investment. Created and implemented initial marketing programs which produced $10 million annual sales.

Created "virtual" marketing department of 9 agencies to build, brand and execute national launch of the service in 6 mo. Managed $100M annual budget and staff of 35. Drove CPGA from $500 to $50 leveraging integrated, interactive marketing, Pop-Up bundling with big data mining sets to break-in to a closed retail environment

Diligently provide technical pre-sales support in sales analysis, presentations, demonstrations, and proposals.

Lead the full sales and delivery life cycle while always maintaining customer satisfaction: marketing, prospecting, qualifying, requirements gathering, solution development, proposal writing, onboarding, project management, delivery, and final acceptance.

Track record of using a collaborative style to successfully redefine and implement new operating models and strategic change programs, deliver best in class sales processes and control environments, improve operating performance through automation and innovation, and by building, mentoring and inspiring high performing teams.

Partner with enterprise sales executives by driving the sales process in support of selling Smartsheet’s SaaS platform to large enterprises

14 years of experience in BI and expert in designing and developing solutions for Enterprise data warehouse (EDW), Master Data Management (MDM), Data Quality,Big Data and Data Migration.

Data Architect in the Big Data space by creating opportunities for technologists to evolve their analytical skills into the area of unstructured managed data with tools such as Hadoop.

Specialties: Big Data, Outsourcing, Off-shoring, Business Intelligence, Managing Companies, PMO, Project Management, Mentor, Management Strategy, International Trade, Software Methodologies, CMMi.

Delivered Volcker Inventory Turnover & Customer Facing Trade Ratio metrics using Big-Data (Hadoop, Map Reduce, Hive, PIG) technology.

Technologies: Web Services (RESTful/Flume, Java), Hadoop, HDFS, Map Reduce using Java/Pig/Hive/Pentaho DI/Talend, JSON, NoSQL (Hbase, Mongo DB, Accumulo), Phoenix, Oozie, Agile, R, Tableau, Eclipse, Java, Flume, SQOOP, CDH4 distribution on Linux, AWS EC2, S3, EBS, Lucene/Elastic Search, ZooKeeper, SSRS, Cloudera, IBM BigInsights, AWS EC2, AWS S3, Data Encryption and Access controls on Big Data Eco System.

14 years of experience in BI and expert in designing and developing solutions for Enterprise data warehouse (EDW), Master Data Management (MDM), Data Quality,Big Data and Data Migration.

Build a cross-asset Risk Publication Warehouse for risk and analytics on Cloudera hadoop platform

Leadership and management in the requirements, business and solution architecture and integration phase of a large and complex project or program of change.

Functional expertise in the delivery of software solutions, covering financial crime detection, to major blue chip clients.

Knowledge management and re-use of techniques, methods, and frameworks

11 years experience in BIconsulting across the full systems development life cycle, including 4 years at project executive level in IBM

Extensive experience in systems with strong knowledge of various languages, software and multi-platform environments, and latest technologies.

Specialization in HR, Audit / Accounting Systems, Financial Control, Treasury Systems.

Strong contemporary business sense and business analysis.

Many years experience in project management and consulting in wide range of industries.

Team leader, work well under pressure.

Build Functional Specifications and Design for personalization and customizations if the Cognos package out-of-box could not support the business process.

Reporting, Data Modeling, Cubes and universes components design.

Account management skills within large commercial corporate customer environments. delivered product based solutions to the Industrial Sector

Program/Project Manage client engagements with responsibility for project scoping, planning, resourcing, communications, budget management and project quality assurance. Ensure that projects are delivered on time, to specification and within budget.

April 2000 to Present IBM Global Services

Senior Data Program Manager

Lead national teams responsible for sales and marketing of IBM's global services offering. Responsible for promoting and selling IBM software, developing business and executing sales projects to achve growth, maintaining and developing new business partnerships, and developing and maintaining customer relationships.

Drive Sales and customers aquisations and project delivery within IBM’s professional services, Leveraged by IBM's as a subject matter professionals and credentials to provide exceptional service quality & business transformation to IBM’s clients. Called the “Architects of Growth”, armed with insights, networking, and ability to present o executives and shorten sales cycles; Led Sales Bids for large scale projects, Received consecutive IBM Excellence Awards 2009-2012 and 2014-2016

Solution Architect/ Manager/ Scrum Master with experience in Design, Development, Maintenance and Testing of Databases /Data warehousing, ETL, Business Intelligence and Reporting Projects. IBM began as a platform for a start-up data mining for marketing training and certification business which evolved into a series of special projects and consulting assignments including:

•Lead the Strategy & Implementation team for the Marketing & Sales Digital Shared Services pillar. Report to the Director of Marketing & Sales Transformation.

•Responsible for the Marketing & Sales technology strategy & roadmap, as well as the implementation of new or enhanced marketing professional Services at IBM Global Services.

•Lead the Platforms Knowledge Sharing & Collaboration team and report to the Director of Marketing & Sales Transformation.

•Accelerate revenue growth from cloud, managed and telecom services by providing a range of consultancy services to Cloud Providers, MSP's and Technology vendors.

•Advising C-Level Suite Executives on industry best practice, and how different technology drivers help accelerate the growth of a company

•Created intellectual capital including but not limited to Sales and Distribution Intercompany White Paper, Order Management White Paper, and Sales Presentation for Big Data Analytics

•Accelerated market penetration and expansion through high-level market research and implementing effective sales channel strategies.

•Developed strategies for pipeline management, program and project management, operational and P&L management, and competitive pricing to outperform the competition.

•Sealed key partner relationships with Fortune 500 companies and established strategic relationships through B2B and B2C affinity partnerships.

•Generated $100M+ in annual sales by formulating strategies to profile, price, identify, and penetrate new markets.

•Created national service launch plan, regional sales management organization (B2B and B2C) and customer support organization and performance metrics.

•Undertook a strategic consulting assignment to revitalize sales of a $260M global connector manufacturer. Wrote 5-year strategic plan, evaluated strategic acquisitions, formalized competitive intelligence program, restructured global sales force and incentive plans, imposed formal product management discipline and altered sales approach to value based selling. Developed branded line of media cables for retail and packaged proprietary training program into a revenue generating asset with user driven social media feedback loop.

•I developed Strategic Business Plan that secured $160 million venture capital start-up investment. Created and implemented initial marketing programs which produced $10 million annual sales.

•Led the creation and implementation of Marketing Plan for product/service bundle launch that includes Market Research, Segmentation and Targeting, Positioning, Service Characteristics, Branding, Pricing, Marketing Distribution, Strategy, Implementation Management, Incremental Revenue and Budget, and Success Metrics Establishment for launch. In addition to, “Youthify” clients’ branded and Wireless Wave.

GiantBear - Led marketing and product development for Application Service Provider – managed client partnerships, service delivery / satisfaction, built Ad Sales team generating $4M on new platform, built & managed customizable, co-branded, multi-lingual e-commerce portal, built/managed portfolio of 26 applications.

MCSQD -Contributed to the concept, build and sale of innovative, interactive advertising application for MSO’s . Helped to define the i-board, a proprietary ‘closed’ social media, UGC community platform (www.iboard.com)

USA Digital Direct - Business development / marketing lead for proprietary e-commerce technology - built business model, led business development for an interactive, hybrid CD-ROM / internet shopping application

SmartServ – planned market introduction for banking application

Led the creation and implementation of Marketing Plan for product/service bundle launch that includes Market Research, Segmentation and Targeting, Positioning, Service Characteristics, Branding, Pricing, Marketing Distribution, Strategy, Implementation Management, Incremental Revenue and Budget, and Success Metrics Establishment for launch.

Managed the transition from distributed data model to a consolidated data warehouse solution. Defined the data ETL requirements and the master data model. Worked with DBA and infrastructure teams to federate and manage data from SQL and Oracle data warehouses, Hadoop and other data sources and provide consistent and high quality data for open use globally.

Expert in Hadoop Operations and cluster deployments at large scale

Built and deployed larges Hadoop infrastructure platforms including all operational aspects for a major eCommerce / retail company and Healthcare provider

Scaled Hadoop/Big Data Cluster infrastructure from 120 servers to 700+ servers storing more than 20+ PB of data to achieve unprecedented view into customer behavior, preferences, and product perception to deliver targeted advertising solution

Data Governance Tools: Collibra DGC, IBM InfoSphere Governance Catalog (Business Glossary, Metadata Workbench)

Relational Database: Microsoft SQL Server, MySQL, Oracle, Hive

Graph Database: Neo4j

Data Modeling: ER Studio, Activiti BPMN

Data Profiling: Powercenter Express, Informatica Developer, Waterline Data Inventory

Metadata Management: DAG Metacenter, ASG Rochade, Oracle Enterprise Metadata Management, Informatica Metadata Manager, Cloudera Navigator, Teradata Loom

Data Quality: Informatica Data Quality, Trillium Data Quality, Oracle Enterprise Data Quality, SAS Data Loader for Hadoop

ETL: IBM DataStage Designer, Informatica Powercenter Designer, Powercenter Express

Data Analysis: Tableau, Alteryx, Datameer

Information Security and Privacy: Dataguise, Informatica Dynamic Data Masking, IBM InfoSphere Guardium

Reporting Tools: SQL Server Reporting Services, Tableau, IBM Cognos Business Intelligence 10.2

Stream Computing: DataSift

Big Data

oHadoop Distributions: Cloudera Enterprise, Cloudera VM, Hortonworks, MapR

oHadoop Ecosystem: Hive, Sqoop, HBase, Flume, Pig, Metastore, HDFS, Flume, MapRFS

VMware: VMware Workstation, VMware Player

Responsible for providing architecture design for global Data Warehousing, Business Intelligence, Enterprise Infrastructure, Web Application Development and Integration projects.

Solution Architect: End to End solution Architecture for database, data warehouse/ data marts and Business Intelligence/ analytics projects

Project Management, Tracking and execution of Database/ Data Warehouse, ETL, BI/Reporting Projects including Functional Analysis, Specifications, Scoping, Estimation, Costing, Resource Allocation, Scheduling, Risk Management, Planning and Execution Control.

Scrum Master: Scrum Master, Agile Software Development, Creating Product Backlogs/ Project Plans, Sprint Management, Retrospective etc.

Database Modeling/ Database development: Database Design/ Modeling, table creation for OLTP, DWH/Data Marts/ OLAP applications. Creating tables, SQL queries, Triggers, Views and Stored Procedure

Experience in Actimize AIS,Modeler,Designer and RCM (Risk Case Manager) environments.

Performance tuning: Database, tables, SQL queries, Stored Procedures

BI/ Reporting: Business Objects, Cognos, PowerBuilder/ Infomaker, SSRS, Microstrategy

ETL: SSIS, Teradata, Informatica (understanding of shell scripts)

Databases/ Data warehousing: Sybase ASE, MS SQL Server, Oracle, TeraData

Database Migration (schema, Stored Procedures, Data etc.). Had been involved in Sybase to Oracle, Sybase 12.5 to Sybase 15 and Sybase ASE 15 to SQL Server 2008 migration

An experienced SYSTEMS PROFESSIONAL/DATAWAREHOUSE SPECIALIST with years of database development, database design and management experience. Strong technical background in Data Warehouse, Business Intelligence BI, multi-language, multi-platform programming, re-engineering, Application Integration and Data modeling (Third normal form - 3NF/Star/Snowflake) with expertise in project coordination, determination of scope and priority, project implementation, and training/development of IT staff. Proficient project and time management skills, able to implement projects on schedule and within budget.

August 1994 to April 2000 Deloitte and Touch Consulting

BI Solution Testing, Architect, ETL mapping, Architecture design, Implementations, Integration and testing specialist

Specialties:

Delivery/ Project Manager/ Scrum Master: - Database, Datawarehouse, ETL, BI & Reporting

Data Warehousing, Business Intelligence, Database Modeling, Database Migration, Sybase, Oracle, SQL Server

ETL,Dimensional modeling,Informatica Power Center,MDM,Informatica Data Quality(IDQ),Informatica B2B,Informatica Data Analyzer,Business Objects Data integrator(BODI),Hadoop,SSIS,SSAS,SSRS,SAP R/3(MM,SD and FICO),SAP B/W,Cognos,Business Objects(BO's),ERwin,Oracle,Teradata,DB2,SQL Server,UNIX,Windows,etc,

Accomplishments:

Agile Scrum management - Scrum Master for multiple over-sized development teams (onshore and offshore; 54 developers and testers) engaged in building, maintaining, and enhancing a commercial asset quality forecasting Big Data application migrated from Oracle to Hadoop for Dodd-Frank Act supervisory stress test modeling of commercial real estate loan portfolio, in a regulatory-driven, high-energy development culture. Tools include VersionOne, JIRA.

Led definition and adoption big data and hadoop solutions. Define use case, big data solution architecture, assess current data landscape, identify strengths and weaknesses to develop a forward-looking strategy that also takes into account broader industry trends.

Designed complex analytical applications leveraging diverse & massive, structured and unstructured datasets. Defined data injection strategies into Hadoop. Deployed applications on distributed architecture. Participated in cluster configuration & architecture setup. Leverage market intelligence to identify innovative analytical tools & architectural solutions.

Responsible for Analysis,Design,Coding of Data warehousing Applications,MDM using Informatica Power Center,Informatica Data Quality and SQL Server,etc.

Responsible for ETL Design,coding and testing of data warehousing applications.Involved in all phases of the project SDLC including Analysis,Design,Coding and testing BI Applications.

Analyzed the competitive market for Sales portfolio to improve the positioning of the account strategy.

Identified the impact of competitive offers on the professional service market in order to determine the impact to D&T value added solution propositions.

Diligently provided technical pre-sales support in sales analysis, presentations, demonstrations, quotations, and proposals.

Coordinated the cration, planning, and execution of business development activities for obtaining consulting contracts.

Led branding and marketing efforts via direct mail, email, telemarketing, cold-calling, and high impact presentations.

Managed and supported all business development activities.

Served as a liaison between the sales and marketing teams to identify new markets and formulate strategies to penetrate them.

Tracked progress of sales leads, sales, and accounts receivable; implemented corrective measures when issues were identified.

Field Force Effectiveness (Sales):

Exceed sales objectives 321% annual growth and 28% quarterly growth during 2-year tenure.

Examine territory performance metrics and activity reports to assess impact and alignment with sales direction. Increase sales force effectiveness through strategic leadership and coaching.

Primary liaison between corporate and field personnel on all sales and marketing initiatives

Experience in all implementation phases and their stages and Milestones: Selection Phase (Orientation, Solution and Resolution stage), Implementation Phase and the SIMS ( Mapping, Piloting and Migration stage) and Optimization Phase (Operations, Control and Strategy stage).

Experience in Gap analysis, and Business Modeling.

Setting up clients’, treasury, administration and finance systems and creating cost and general ledger chart of accounts. Mapped out computerized processes for reporting system. Solving problems. (e.g. currency exchange differences and rates, reconciliation between the system reports itself in one hand and between the system reports and a third party document in another hand, month and year end closures and changing the chart of accounts between two accounting period).

Active role in liaison & communications between the banking professionals and the computer programmers professionals

Year-end and interim Audit and Risk Management, IT Risk assessment for the client’s accounts

Customize IBM clients Reporting packages to ensure the proper reporting in accuracy and variety.

Business process process analyst work as a Logistics and Finance Functional Consultant. Providing subject matter expert consulting in banking systems environment focusing on logistics and finance functional areas on implementation projects. Including solution design, configuration, and design validation. Experience leading selling and managing SAP consulting services initiative for the Banking vertical functional area

Depth of knowledge and experience with core banking systems, including integration with the Financial areas, Knowledge and experience with standard systems lifecycle development methodologies; specifically test scenarios, and management of expected vs. actual results. Implementation and upgrade methodology.

Served as Principal Architect, and Project manager for the development for “Sportsmaker,” a web based entertainment gambling/gaming system for a major Las Vegas Hotel that enabled 3000 home users and 2000 kiosk customers to bet on video sports events from home. An extranet system consisting of 500 servers and kiosks & laptops that used Smart Cards with heavy security technologies

Designed and launched the Smart Card architecture and development delivery system for card issuance and personalization that supported multiple applications on a single card.

This system required that all data within the 6 internal divisions and 12 external sources flow through the SOA/ESB data integration hub and then be processed by the Master Dealer MDM repository and then by the CRM on demand application and infrastructure cloud system that replaced Sales Force.com (Sales Management & Marketing campaigns/Promotions & Leads Generation) functional processing.

The data management endeavor consisted of Vendor, Product and Customer Hierarchy Definition; Mapping of Item, Vendor, and Product Masters; Data Governance, Data Quality and Master Data Strategy activities

This endeavor required massive account data clean-up and the match/merge de-duping of duplicate accounts on 74 files and 12 data bases. Informatica ‘s ETL tools were used to create the DW data bases from source interface applications systems.BI retrievals were done from the aggregated cube data.as well.

Implemented Data Integration projects for large BI applications for retail, financial services, telecommunications, and pharma clients as a consultant performing requirements, analysis, design, implementation roles using Oracle databases and AbInitio, DataStage, and Informatica ETL tools.

Designed and developed a large CRM Business Intelligence application for a pharmaceutical company. The application was developed using the Informatica ETL tool and supported with Oracle database procedures and Unix scripts. Accomplishments included leadership of the development team the production of design documents, data model, and database administration, and oversight of the development team, both onshore and offshore, for the Integration Layer involving 60+ interfaces and the Operational Data Store.

March 1984 to July 1994 Wells Fargo: Wealth Management, The Private Bank

Business Analyst, and Systems Architect

Project Management, Business Analysis, Data Architecture, Architecture, Technical Skills

Project Lifecycle: PMBOK Business Analysis Lifecycle: BABOK

Enterprise Architecture Framework: TOGAF SDLC: Agile, Unified Process, Scrum, Waterfall, CMMI

Provided business analysis, project management, interface design, and technical documentation for a program-level organizational merger. Designed and managed SharePoint program site and project sub-sites. Developed front-end design and business requirements, and then managed the development of same as a CMS platform for multiple departments within The Private Bank. Provided process engineering, business requirements creation, Service Level Agreements, SIT and UAT test writing for multiple projects, and system training to full-time employees. Program resource for SharePoint issues and project plan assistance.

Languages: SQL, SAS, UML, XML Hardware: Windows, Linux, AIX, Solaris, And Mainframes

Software: HP Project & Portfolio Management, Microsoft Project, Microsoft Office, Visio, Business Objects Enterprise, Spotfire, Xcelsius 2008 Crystal Reports 2008, DashBoard Builder, Voyager, Informatica Power Center 9x, Informatica Data Quality Suite 9.x, Informatica Metadata Manager 9x, ProClarity, Microsoft Analysis Services, Microsoft SSIS, Mircosoft Reporting Services, Unica, Enterprise Architect, Casewise, Cognos, DQXI, Data Integrator, SAP Data Federator, DataStage, Tibco Rendezvous, Trillium, Oracle Financials, SAS EBI, SAS Enterprise Guide, SAS Campaign Studio, SAS EMiner, SAS Data Integrator, SAS InfoMaps. SAS Web Reports, Studio, Websphere, Weblogic, Salesforce.com, MetaCenter, Enterprise Architect, Oracle/Raza MDM, GoldenSource MDM, Microsoft Master Data Services 2012, WebTrends, Essbase, Oracle, Oracle Discover, SQLServer 2008, Sybase, DB2, DB2 EII, Q-Replication, Infobright Columnar Database, CICS, Toad, Toad Modeler, Toad Modeler, Erwin, HP Performance Center, SiteScope, XmlSpy, Securent, SharePoint, Citrix

Responsibilities:

Direct report to the Chief Business Information Officer and mandate to lead the initiative to manage, architect, develop and deploy the firms' new data warehouse, reporting and business intelligence competency center to facilitate the business decision making process for aggressive expansion of business operations globally.

Created the project plan, staff planning, vision, architecture blueprints and execution strategy to create a reporting and data delivery architecture strategic roadmap for client's historical business intelligence requirements for integration of 80 MGAs and TPAs claims and premium monthly data feeds.

Realigned the data warehouse architecture strategy with business goals by advocating the benefits of Informatica' Power Center, Data Quality, Metadata tools which resulted in a $400K savings in vendor license fees. Equally important, championed the benefits of a Microsoft Master Data Services which resulted in a $350K savings in license fees and mitigate of poor quality reference data managed in Excel.

Responsible for leveraging the Group developed logical data model and implementing the physical design in Erwin and generating the DDL for database creation.

Facilitated and documented client requirements for reporting, business measures, data mappings, star-schema bus architecture, reverse and forward engineering of database to create ERD and DDL code.

ETL Developer - coding transformation logic between source systems and target databases, implementing householding rules on customer related data, and coding business rule transformations. ETL tools used include DataStage, Informatica, Ab Initio. Database involved in sources/targets of ETL include Oracle, DB2, Teradata, Netezza.

Led and managed ETL development of a Sales Reporting Data Warehouse and Marts using Informatica ETL tool with DB2 source and Netezza target databases; coordinated the activities of the 8 person off-shore team; coordinated and executed System, Integration, and Performance Tests; supported Production Conversion Runs; produced project documentation; conducted Knowledge Transfer of SRW system components with the Marriott Support team

Senior technical Outlooksoft developer. Implemented Microsoft analysis services cubes by extracting data via DTS (data transformation services) from Oracle data marts (data marts were build using Informatica) into 2 cubes. Budgeting/Planning cube and currency exchange cube. The project also required building several budget templates in Everest WebExcel. The implementation also required to deploy the excel templates over the web, by using Outlooksoft web components. The goal of this project was to deploy the budget process over the web so field managers can enter budget data from their laptop offices.

The system data match/merge process involved using multiple composite matching keys, business survivor rules and business processing conditions, decisions and actions.

EDUCATION...

MBA Queen’s School of Business, Queen’s University

B.Com University of Toronto, St. George Campus

PMP Project Manager Processional

CPA… Certified Public Accountant

CFA Certified Financial Analyst

CMA, Certified Management Accountant

CMC Certified Management Consultant

CISA… Certified Information Systems Auditor (CISA)

CGEIT… Certified in Governance of Enterprise IT (CGEIT)

CRISC… Certified in Certified in Risk and Information Systems Control (CRISC)

BS, Computer Systems Analysis, École Polytechnique

Microsoft Office Word/Excel/PowerPoint/Access dB and MS Project

SQL (structured Query Language)

CorelDraw / ABC Flowcharter / Lotus Notes.

Successfully passed Architecture design certificates courses: (Basic Overview, Foundation Logistics, Enterprise Logistics, Enterprise Finance, Enterprise Tools, Enterprise Modeler and most elective courses.

MANAGEMENT SEMINARS & WORKSHOPS

Matrix Management Training Course Thunder Bird University, Portland, US.

Various management, administration, finance, reporting and computer skill seminars.

References available upon request.

Wasim Jalal, MBA, CPA, PMP, CMC

34 Eglinton Avenue West

Toronto, ON, M4R-2H6

Telephone: 416-***-****

Cell: 416-***-****

e-Mail: addunz@r.postjobfree.com

Contact this candidate