Mike Pirzadeh (PMP, ITIL)

** *** ***** ***, *********, ON

Tel: 647-***-**** Email: adelf3@r.postjobfree.com

BUSINESS PROFILE

A self-managed and result-oriented leader with more than 25 years of experience in Designing, Delivering, and Project Management of cutting edge Business Intelligence, Analytic, and Big Data technology and working in financial, Insurance, and telecommunication industries. Experienced in managing large scale and highly complex projects while initiate targeted strategies, delivered cost-effective solutions.

Strategic leader/SME with strong interpersonal, communication, problem solving and decision making skills. Ability to establish and maintain strong alliances, lead and motivate teams, drive projects to successful completion, convey complex technical requirements/data, exceed client expectations and achieve fiscal bottom-line results.

TECHNICAL SKILLS

Project Management/Scrum Master (PMP) / ITIL

AWS and Private Cloud (S3, Redshift, EC2, EMR, Glue, Kinese Services, Lambda, Athena )

Big Data/ Hadoop Platform (Cloudera)

Machine Learning / Artificial Intelligence (Python and R)

Business Intelligence Analytical Reporting Tools (Cognos, OBIEE, Business Objects, QLIK)

Data Discovery Tools (Spotfire, Tableau)

Messaging/Stream Processing (Kafka, Flume, Storm)

Data Modeling for Big Data application (Hierarchy and Graph modeling) and traditional Dimensional/Star schema modeling

Relational Database Management System (Oracle, IBM DB2, PostgreSQL, Microsoft SQL Server, Sybase, HP Non-Stop)

Appliance (Oracle Exadata, IBM Neteeza, Teradata)

ETL Tools (Informatica, SAS)

Data Replication using Oracle Golden Gate and (Active) Data Guard

Using SQL for ad-hoc reporting

Agile Development

Cloudera databases (HIVE, Impala, HBase, Impala and start working with Kodo)

PROFESSIONAL EXPERIENCE

AVIVA Canada (Insurance) AVP BigData (Analytics/Data Engineering) September 2017 – March 2020

SELECTED ACCOMPLISHMENTS

Projects/DevOps

Leading the Design/Implementation of the foundation of Enterprise Data Hub using BigData(Hive, Impala, Spark), PostgreSQL, and Informatica BDM to collect data from 35 different lines of business like Policy Center, Claims Center, Billing Center, Underwriters, Finance, 3rd party data, rates, and so on in excess of $7MM with the scope of building 60 new servers for all different regions includes tens of thousands of Informatica workflows, Cloudera Spark, HiveQL, and tables/views

Defined and implemented different zones in Enterprise Data Hub to cover the data acquisition, data quality/standardization/profiling, data integration/reconciliation, data aggregation, and data presentation in conjunction with traditional data marts.

Established a new data scientists platform (dataiku) to calculate the risk rates and other analytical models for underwrites as Tier 1 (Business Critical).

Developed Machine Learning Regression Model for underwriters to score a rate for each new policy in real time using dataiku applied the model against training and test data set and deployed that into production

Developed and tuned up hundreds of reports (statics and dynamics) in Business Objects (SAP) and Qlick Sense and published the inventories

Designed and implemented two data marts (Billing and Pricing) with scope of 100+ tables/views, KPIs, and thousands workflows and scheduled scripts with proper documentations

Created a zone for the data scientists with sanitized data in Enterprise DataHub.

Organized and facilitated agile and scrum meetings which included sprint planning, daily scrum and operated in 3 weeks sprints with flexibility on length for the above projects.

Updated stakeholders(Product owners) and senior leadership with the progress of the projects (budget, timing and scope) on regular basis while providing risks and mitigation.

Established the guidelines and best practices, also new technologies for data engineers/admin teams for all disciplines (data engineer, data modeler, report-developer, DBAs)

Operations

Managing Tier 1 applications databases (Guidewire – Policy and Claim Center) using 3 Oracle rack nodes with DR using data guards.

Managing 35 data streams encompass data acquisition, data quality/standardization/profiling, data integration/reconciliation, data aggregation, and data presentation in conjunction with traditional data mart.

Created multiple dashboards with approved KPIs/Scorecard to show/monitor all of the data streams load completion (meeting their SLA) encompass data quality, data profiling, reconciliation process including business system monitoring like the number of loaded Policies, Claims, call center interactions, and so on which were the benchmark of the operations.

Moving some streams from Batch to Near Real Time data processing to improve the data availability and minimize the server load.

Optimized hundreds of existing dynamic Business Objects and Qlik Sense reports.

Monitoring and handling all the backlogs and tickets queue and updates clients.

Created an effective process of handing over the projects to operations which was incremental transfer of knowledge during the design, coding, and testing with standard documentations(review sessions).

Participating in the intake process and change management to review any new changes while providing estimates

Working with Infosec and auditors(Internal and external) to cover the SOC2 items like the availability, integrity, confidentiality, and privacy of loaded data.

Monitoring and managing assigned IT risk queue and address them based on agreed plan.

Administrating of hundreds of Oracle, Hive, Impala, DB2, SQL Server, PostgreSQL, and MongoDB databases across hundreds of database servers.

Addressing the currency with all their dependencies and vulnerabilities in an on-going basis.

Maintaining the capacity planning for all the environments.

Cloud (AWS)

Identified candidate infrastructures/applications to move into Cloud (AMS-AWS Managed Services and Private) like Informatica MDM, Qlik Sense, and dataiku (Data Science Platform) adopting as IaaS, SaaS.

Exploring the opportunity of building the new stack of data analytic in cloud to processing batch using S3, EMR, Glue, and near real time stream using Kinesis services (firehose, analytic), Storing in data warehouse (redshift) and reporting using Athena and Amazon quicksight.

Financial

Oversee CapEx and OpEx in excess of $10MM+, ensuring cost are accurately captured, updates are provided in a timely manner. Monitoring for the licenses renewal for Oracle, DB2, PostgreSQL, Informatica (MDM, BDM, Power Exchange, PowerCenter, CDC ), Business Object, QLIk, dataiku, Cloudera, people, professional services, SOWs for maintenance and application support, and so on

Management

Leading a team of 20 Data Engineers including Scrum Master, Business Solution Designers, System Analysts, ETL Developers, DBAs, Data Modelers and application support [On-shore and off-shore]) while monitoring their performance and provided feedback, coaching, and mentoring as needed.

Exceptional Oral, written and interpersonal communication skills with ability to simplify complex technical concepts into business and value-focused language.

Visionary, highly organized, detailed oriented, problem solver, lead and balance multiple parallel initiatives/projects, and analytical thinker.

Collaborating with product manager and stakeholders to ensure the projects/changes outcomes are aligned with business goals and strategic objectives while satisfies key financial and operational performance indicators.

Prepared performance reports, executive presentation material and ad-hoc reports; Craft analysis, and conclusions, and facilitate associated actions.

Improved team efficiency by 40% with the definition of a business & data analysis best practices including data acquisition automation, standardize processes, reusable templates, and cross training.

Vendor Management (Informatica, IBM, HP, ORACLE, TCS, ACCENTURE, PWC, TATA, and so on) including RFP and SOW and monitoring their performance and deliverable.

PROFESSIONAL EXPERIENCE

ABTron Inc. Project Manager/Solution Designer/Delivery July 2016 – August 2017

SELECTED ACCOMPLISHMENTS

Leading a team of Business Analysis, ETL/DBA Developers (Oracle PL/SQL), and Data Modelers

Automate sales and all processes around that

Created a data dictionary for all data elements in the organization

Established data warehouse for all domains (clients, sales, products, vendors, and so on).

Created detailed programs/projects road maps, plans, dependencies, critical path, conflict management, prioritization, internal and external stakeholder status meeting, Monitoring project risks and scope creep to identify potential problems and proactively

Communicated effectively and clearly the project deliverable, mile stones, budget, and solutions on a regular basis to the organization

PROFESSIONAL EXPERIENCE

CIBC, Director of Data/BI/Enterprise Data Hub BigData March 2007-Feb 2016

SELECTED ACCOMPLISHMENTS

Leading a team of 50 (Matrix and Direct reports) PMs, Business Solution Designers, System Analysts, ETL Developers (Informatica, SAS), Db As, and Data Modelers (off-shore and on-site)

Managed multimillion-dollar projects aligning business goals with technology solutions to drive process improvements, competitive advantage and bottom-line gains.

Designed/Implemented the foundation of Enterprise Data Domain/Hub (EDH-BigData) / Data Lake for CIBC to collect all the master data from authoritative data sources across Retail, Wholesale, and World Market (structured and unstructured data) in excess of $50MM project using Big Data/Hadoop technology.

Collaborate with all different lines of businesses and technologies in establishing the business case for Enterprise Data Hub / Data Lake in the CIBC organization.

Participated in defining the blue print of rationalizing all the data warehouses / data marts in CIBC and migrating them to the Enterprise Data Hub and Enterprise Data Warehouse combination which could save more than $100MM in annual cost.

Defined and implemented different zones in Enterprise Data Hub/Data Lake to cover the data acquisition, data quality/standardization/profiling, data integration/reconciliation, data aggregation, and data presentation in conjunction with traditional data warehouse / data mart.

Designed and implemented data consumption layer in Enterprise Data Hub / Data Lake for further analytic and reporting for different lines of businesses / data scientists.

Participated in defining and implementing all the required processes with Chief Data Office (CDO) around data governance for new data life cycle management in Enterprise Data Hub / Data Lake.

Participated in defining the operational processes of maintaining the Enterprise Data Hub/Data Lake (i.e. on boarding, change management, cost model, and so on).

Participated in creating the new data model for Enterprise Data Hub / Data Lake to accommodate the hierarchical and graph data pattern in addition to traditional relational data model using Financial IBM Enterprise Model.

Participated in identifying the CIBC critical data elements as starting point for Data Governance Council

Defined the Enterprise Meta Data Management including business rules, data verification, and data lineage.

Defined processes and tools best suited to each project while moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, dependencies, critical path, conflict management, prioritization, internal and external stakeholder status meeting, schedules, work breakdown structures, budget with time tracking in project plan, risk/issue management, and operational readiness.

Monitoring project risks and scope creep to identify potential problems and proactively identifying solutions to address them in advance.

Improved team efficiency by 40% with the definition of a business & data analysis practice including data acquisition automation, standardize processes, reusable templates, and cross training.

Vendor Management (IBM, HP, ORACLE, Deloitte, TCS, ACCENTURE, PWC, TATA, and so on)

Participated in delivering hundreds of successful complex projects with different nature (Marketing Campaign, Loyalty, Finance, AML, Insurance, Mortgage, Regulatory, Optimization, and so on) on time and on budget with the budget of +$100MM

Designed and implemented the first cluster of Oracle Exadata appliance in CIBC and second in Canada with the budget of $10MM.

Communicated complex technical concepts to non-technical audiences

Perform/guide Data Discovery activities to help different line of businesses understand the quality, completeness and analysis potential of their data sets

Outstanding analytical and diagnostic skills when dealing with complex issues and uncertainty, and the ability to make sound decisions quickly while carefully evaluating risks and alternatives before taking action. Possesses strong negotiation and collaboration skills, and effectively consults and communicates with key stakeholders regarding critical decisions.

Support daily operational needs across all delivery areas, establish service level management to set and meeting business expectations for performance, availability, data quality and relevance

Created short and long term BI Strategy/roadmapsand architecture for all supported line of business

Created a solid foundation for the Mortgage performance analytical and dash board (Using TIBCO Spotfire in CIBC for all regions in Canada

Developed and implemented a business case for using BI reporting tool(OBIEE) replacing all manual workload (using SAS) for the whole report-development activity for customer marketing department with hundreds of analytics, dashboard, and report

Designed and implemented integration between HP Non-Stop and Oracle Exadata using Oracle Golden Gate

Designed the traditional data model for ODS (Operational Data Model) and Data Warehouse/Data Mart using Dimensional and Star Schema Modelling

PROFESSIONAL EXPERIENCE

CIBC, Global Database Engineering 2004 – 2007

Sr. Manager of Global Database Engineering

SELECTED ACCOMPLISHMENTS

Built a team of 25+ Db As from the ground up to support many Lines of businesses.

Designed and Implemented an Oracle farm hosting 500 Oracle databases for all different environments (DIT, SIT, UAT, PTE, and PROD)

Participating in BASEL I and BASEL II Projects

Developed all required processes around a database farm regarding managing all the change management and operations (capacity planning, monitoring, and so on).

PROFESSIONAL EXPERIENCE

CIBC, Mortgages 1999 – 2004

Sr. Database Developer / Administrator

SELECTED ACCOMPLISHMENTS

Completed all related Y2K projects on schedule and 20% under budget

Developed and maintained all the mortgages databases in all environments and platforms (Oracle, UDB2, SYBASE, and Microsoft SQL Server).

Built a team of 3 Db As from the ground up to support different departments in Mortgage.

PROFESSIONAL EXPERIENCE

Bell Mobility Sr. Program Analyst 1997 – 1999

Developed and maintained Java code to extract, transform, and load all the required data into a Sybase database for future reporting and data mining

Acted as 2nd and 3rd level of support for all the ETL jobs

Built a team of 3 Db As from the ground up and split the workload and acting as team leader

Developed an UI and back end Sybase for collecting all the Clients information

Supporting and developing all the required reports and analytics

Using VB and crystal report for generating and number of reports

PROFESSIONAL EXPERIENCE

Parsian- Director of IT department 1990 – 1997

Built a team of 20 IT staff in different categories (Database, development, networking, analyst)

Prepared the budget for all on-going projects and operations

Designed and implemented all required applications (Payroll, Inventory, Accounting, and so on)

Automated all the design/drawing for all power stations and High Voltage power lines using LISP for AutoCAD

Designed and developed a central data warehouse and many datamarts for different LOBs(Marketing, Engineering, Sales, HR, and so on)

Established a LAN to address all the requirement of the 350 users with required software and clients installed

created all the required design documents for each stage of developments and review by the team members.

Managing the currency and apply patches on a regular basis to all HW and SW

Present the progress of all active IT projects to the management on a weekly basis

Have a regular one to one meeting with all team members and review the performance and provide constructive feedback in a two way communication

Created an automated UI script generator template based on generic UI to improve the cycle of developments

EDUCATION

Isfahan University – Software Engineering (Artificial Intelligence and Expert Systems) 1986-1990

REFERENCES ARE AVAILABLE UPON REQUEST

Contact this candidate