Candidates About
Kian Haghdad, Ph.D.
OBJECTIVE
Big Data Architect Consultant / BI Solutions Architect / Data Management Lead
QUALIFICATION HIGHLIGHTS
- 17 years of solid working experience in IT industry with a PhD from University of Waterloo.
- 12 years of experience as a hands-on Solutions Architect/ Team Lead/ Specialist/ Developer in Big Data, Business Intelligence (BI), Data Warehousing, and multi-tiered applications.
- Delivered projects for enterprises such as Canadian Tire, the Ministry of Education, the City of Toronto, Bank of Montreal, General Motors, as well as startups.
· Expert in Big Data: HDFS, Hive, Spark, Scala, Python, Hadoop, Sqoop, Map/Reduce, Hortonworks, Cloudera, MapR, HBase, Cassandra, Kafka, Storm, Spark Streaming, Zeppelin, Kibana, Spark MLib, Mahout, R, NiFi, Falcon, Oozie, Kylin, Atlas, Drill, Solr, ElasticSearch, Ambari,Ranger, Flume, Impala, Pig, HDInsight
· A full stack solutions architect at enterprise scale. Proficient in end-to-end design spectrum: developing business value justification and strategy, selecting and managing a technology vendor, designing a solution blueprint, envisioning the roadmap, team building, implementation, solution sustainment and DevOps
· Designed solutions utilizing advanced analytics, artificial intelligence and cognitive services. The solutions include prescriptive (recommendation) and predictive analytics, sentiment analysis, text analytics, vision/image processing, and speech recognition, classification, pattern recognition, and regression.
· Defined the data governance strategy, designed security patterns, implemented data standards and procedures across the enterprise; drafted business specific methodology to establish business stakeholder-driven data stewardship through MDM
· Led EDW projects on Massively Parallel Processing (MPP) Data Warehouse Appliances such as IBM Netezza, Teradata, APS (PDW), Oracle Exadata, Customer MDM, Product MDM, DQ Framework
· Expert in Enterprise Information Management (EIM) for retail operation. Designed various BI solutions including loyalty programs, card management, POS data management, customer behavioral analysis, store dashboards, finance, ecommerce, and cyber security analytics.
- Migrated 10s of applications and solutions to the Cloud.
- Extensively working on SQL Server 7 to 2016, Oracle, SQL, T-SQL, SSIS, SSRS, SSAS, OLTP, OLAP, Multidimensional Cube, MDX, PowerPivot, Tabular Model, SharePoint, PerformancePoint.
- Strong knowledge and proven results in Data Warehouse and Data Mart design including Dimensional Modeling (Star & Snowflake Schemas), ER Modeling, 3 Normal Forms, Normalization and Demoralization, Logical Model and Physical Model, Fact/Dimension/Hierarchy identifications.
- Demonstrated experience and understanding of the best practices in all aspects of data warehousing (Inmon/Kimball approach). Solid experience in Data Warehouse Development Lifecycle (SDLC) including system analysis, design, implementation, testing, deployment, and maintenance.
- From Business Case to Data Visualization, I have designed and developed solutions by combining Business Process with Information Technology.
- Years of design and hands on experience in application development using .NET and Service Oriented Architecture (SOA)
- Authored numerous best practices, technical reports, processes & workflows, and methodology documents to standardize implementation, support infrastructure and sustainment teams, and to promote knowledge sharing. Coached and trained development teams in utilizing the BI framework.
EXPERIENCE
Senior Big Data / BI Solutions Architect - Consultant 03/2016-Present
Hitachi Consulting, California
· Led a Big Data project on Teradata utilizing Spark, Scala, Cloudera, Hadoop, Hive, Impala, Flume, Sqoop, Map/Reduce, and Pig. The project collects information from cameras and sensors installed on the highways, performs advanced analytics to capture the information. Subsequently, the unstructured data is processed to feed the BI layer.
· Designed and led BI/DW projects for driver examination services. The solution consolidates the information from 55 Drive Test centers as well as 39 travel point locations. Designed the full stack BI solution including ETL, Staging, DW, Dashboard, and reporting layer.
· Designed and developed an advanced analytical solutions that utilizes Machine Learning and Deep Learning frameworks for driver examination services. The solutions utilize tools such as Machine Learning Studio, DLVM, R Server, Python, Jupyter notebooks, Azure SQL database and many other data science and ML tools.
- Designed and developed Artificial Intelligence (AI) applications with Natural Language Processing (NLP) - With Cognitive Services API's. The solution include text analytics, Vision, and Speech recognition. The project collects information from cameras and sensors installed on the highways, performs advanced analytics to capture the information. Subsequently, the unstructured data is processed to feed the BI layer.
· Designed and developed fast scalable search system using Azure Search (utilizing ElasticSearch) for incident and ticket management. The high speed search gets its data from a Machine Learning system with Key Phrase extraction capabilities. Subsequently, user can search and perform text mining through unstructured text in a large scale data source.
· Established a roadmap for migrating legacy information warehouse to a modern high performance data warehouse running on multiple DW appliances. Drafted a BI/DW prioritized implementation roadmap while taking input from organization, business, and IT strategy documentation
- Created high-level architecture, solution blueprints, technology infrastructure implementation plan, integration plan, and disaster recovery plan. Created architecture artifacts and provided subject matter expertise in support of a technology selection process.
Senior BI Lead/ Solution Architect Consultant 04/2015-03/2016
Canadian Tire, Toronto, Ontario
· Led a big data project on Teradata utilizing Spark, Hadoop, Hortonworks, Cloudera, Hive, Impala, Flume, Sqoop, Map/Reduce, Pig, HDInsight, HBase, oozie, and facilitating real-time data analysis by data scientist.
· Led EDW projects on Massively Parallel Processing (MPP) Data Warehouse Appliances such as IBM Netezza, Teradata, APS (PDW), Oracle Exadata
- Defined the data governance strategy, designed security patterns, implemented data standards and procedures across the enterprise; drafted business specific methodology to establish business stakeholder-driven data stewardship through MDM
· Designed Enterprise Information Management (EIM) solutions for retail operation. Led technical teams, provided estimation, planed resources, and designed various BI solutions including loyalty programs, card management, POS data management, customer behavioral analysis, store dashboards, finance, ecommerce, cyber security analytic.
· Drafted a BI/DW prioritized implementation roadmap while taking input from internal divisional service plans, business and IT strategy documentation, as well as corporate BI Strategy and the Financial Planning and Reporting System
- Created high-level architecture, solution blueprints, technology infrastructure implementation plan, integration plan, and disaster recovery plan. Created architecture artifacts and provided subject matter expertise in support of a technology selection process
· Designed a Scorecard and Strategy Management BI solution with capabilities aimed at communicating strategic goals across the organization and monitoring progress over time. Scorecard and Strategy Management provided capabilities to establish specific goals, defined how to measure success, and communicated information down the entire organization to increase organizational effectiveness and productivity through improved transparency, processes and technology
· Conducted and documented business stakeholder interviews and workshops
· Conducted BI maturity assessment of the organization. Architected DW&BI Program Structure, defined the role of DW&BI Program Steering Committee, it's mission, objectives, roles and responsibilities, monitored regular improvements to help manage risks, evaluate trends, and develop capacity and capability to achieve the Program mission
· Led a team of 16 individuals to plan, design, and migrate a portfolio of 6 projects to Azure Cloud. Was involved in the full cycle of vendor selection, evaluated RFP responses, requirement gathering, design, and development of this project. The migration included different aspects of the project from front, backend, and integration. According to the requirement, we selected Azure cloud for this project and utilized cutting edge utilities to perform the migration.
Senior BI Lead/ Solution Architect Consultant 01/2014-04/2015
Ministry of Education, Toronto, Ontario
- Led a big data project to be hosted on Azure cloud. Led the design and development of big data solution to conduct sentiment analysis for all schools across Ontario. The solution merges feeds from social media with school board structured data. The data then is analyzed by multiple dimensions including geographical, parent income, and crime rate. The analysis provides valuable insight and is used in planning, early detection of issues, and enhancing school performance. The tools utilized include Hadoop, HDInsight, PDW, Map/Reduce jobs, Hive, and Sqoop.
- Led the design and development of BI solution, ETL processes, and data mapping using SQL server, Master Data Services (MDS), Data Quality Services (DQS), SSIS to extract data from ITIL and Process Implementation tools such as Remedy and HP OVSD. The process loads the asset management information including server hardware, software, and application data and transform and load the data into data warehouse. Subsequently, designed and developed reports that are accessible through a SharePoint portal. Developed several BI components for implementation of new policies, process improvements and detailed work instructions that integrates application management processes with existing ITIL based processes such as incident management, change, knowledge, IT financial, and configuration management.
- Led the design and development of a SQL Server SSAS Analysis cube utilizing star schema with complex MDX calculated measures, named sets and KPIs, KPPIs to present an analytical view for the data and data quality with multiple dimensions.
- Led the design and development of data visualization using Microsoft Power View and Power Map to represent the server information across multiple data centers in Canada.
- Was involved in the full cycle of vendor selection, evaluated RFP responses, requirement gathering, design, and development of the projects.
Senior BI Solutions Architect/ Lead/ Senior BI Specialist 05/2012-01/2014
City of Toronto, Toronto, Ontario
- Led the design and development of 311 data warehouse and business intelligence solution that provide a consolidated view for the data for all services that the City provides to the citizens. The solution extracts data from Lagan ECM, different divisions including 311 Toronto, Toronto Water, Solid Waste Management, Municipal Licensing & Standards, Forestry & Recreation, Transportation Services and Parks. The extracted data, then, are corrected and cleansed according to business rules and presented as a single analytical view to the users such as Councillors, City senior management, and operational managers.
- Led the design and development of a big data solutions by utilizing Hadoop/HDInsight, PDW, Map/Reduce jobs, Hive, and Sqoop. The solutions measure the performance of 311 call centre by analyzing the data gathered from Cisco/IPCC telephone systems. Integrated with Cisco Verint for VOIP call recording, quality monitoring (QM), and speech analytics. The BI solution improves the communications between the City and the customers. The real-time data visualization shows a snapshot of the interactions between the CSRs and the customers at any given time.
- Led the design and development of the Workforce Management (WFM) data warehouse and BI solution to optimize adherence and attendance in the contact centre. The predictive analytic component accurately forecasts the number of CSRs needed in the call centre to fulfill the services.
- Led the design and development of an efficient BI auditing framework that collects the data from packages being executed and used in data flows, row counters, versioning, and error handling. The framework is crucial for monitoring, timing, troubleshooting, and auditing. Also, developed Stored Procedures, Views, and Functions for the framework to automate logging the information and error handling in the packages.
- Led the design and development of ETL processes and data mapping using SQL server, Master Data Services (MDS), SSIS to extract data from Lagan ECM and division data sources including SQL server and oracle databases, flat files, and excel sheets. The data, then, is transformed and loaded into a data warehouse for reporting.
- Led the design and development of data quality ETL packages to correct and cleanse the data and enhance the quality of consolidated data. Wrote hundreds lines of .NET C# code, embedded in the packages, to create a rules engine that loads business rules and apply them to the data efficiently. In addition, the data quality issues are mapped for reporting purposes.
- Led the design and development of a SQL Server SSAS Analysis cube utilizing star schema with complex MDX calculated measures, named sets and KPIs to present an analytical view for the data and data quality with multiple dimensions.
- Led the design and development of map application and report using ASP.NET/C# web application. The application loads the data from the data warehouse, combines it with geographical information, and displays the data on a map. The application communicates through restful mapping services and uses client side scripts (JavaScript and AJAX) to improve performance and user experience.
- Led the design and development of SharePoint web application, site collection, dashboard, and libraries. To present the analytical reports in a user-friendly and interactive way, SharePoint and dashboard designer 2010 are used to create a site that hosts PerformancePoint charts, filters, and integrated SSRS reports. The dashboard is connected to an SSAS cube and dynamically applies the filters to the data shown on the charts.
- Prepared system architecture documents and designed for high-availability clusters. Also, he configured multi-machine SharePoint farm through windows clusters to ensure reports and dashboards are always available in case of a failure. Also, configured distributed reporting services to be integrated with the farm.
- Led design of a Java application using Spring Framework to communicate, create and update the booking for the City facilities.
- Led the configuration of access levels for different groups and created security roles within SharePoint.
- Led the enhancement of the security of map application through SSL, security certificates, and windows authentication in IIS.
- Authored naming conventions, BI best practices, and development and deployment guidelines. The guidelines also provide steps for SharePoint installation, setup, backup, and recovering the system to help sustainment team promote the solutions to QA and production.
Senior BI Architect/ Sr. Business Intelligence Consultant 01/2012-05/2012
Bank of Montreal, Toronto, Ontario
- Led the design and development of a BI solution for a data quality management system (DQM) for a capital market Anti-Money Laundering (AML) solution using SQL server SSAS cubes and DB2 financial system. The solution measures the data quality according to a set of business rules and calculates KPIs with respect to the given thresholds. Created reports using SAS.
- Led the architected and development of a business intelligence solution for BMO Employee Giving Campaign. The solution extracts information regarding the donations of BMO employees to United Way from multiple sources including HR system and UW campaigns both in Canada and the US. Developed auditing framework, ETL packages, and a data warehouse with complex MDX calculated measures for the analytical reporting.
- Led the architected and development of a SharePoint dashboard using PerformancePoint 2010 that helps visualizing the quality of the data using charts, scorecards, reports, and indicators.
Sr. Business Intelligence Consultant 08/11-04/2012
First Canadian Title, Oakville, Ontario
- Led the architected and development of several projects for this leading insurance company. Also helped with the architecture. The projects facilitate the title insurance for commercial and residential transaction as well as refinancing mortgage programs for lenders such as TD, Bank of Nova Scotia, and RBC.
- Utilized service-oriented architecture (SOA) for integration and developed analytical reporting using SSIS, MS SQL Server 2008, SharePoint/PerformancePoint, SOA, .NET 4.0, ASP.NET, C#, WCF, MVC, LINQ, NetTire, SOAP UI.
BI Architect/ SSIS/SSAS Specialist/ Sr. Software Engineer 06/10-08/11
BBM Canada, Toronto, Ontario
· Led the architected and development of broadcast measurement and for analysis of consumer behavior. The solutions gather relevant information on audience behaviors after broadcasts, giving TV and Radio broadcasters and advertisers critical insights into the impacts of broadcast.
· Designed the template and built analytical reporting, business intelligence and data warehousing using SSIS, SSAS, SSRS, SQL server, and Oracle 10g, Oracle Mantas, and PL/SQL.
· Led the architected and development of a service oriented solution to retrieve the data from various data sources for data staging, parsing, and loading to a data warehouse using .NET 4.0, C#, WCF services, LINQ, WPF composite application block/Prism, Silverlight, MVC.
Lead/ SSIS/SSRS/SSAS Specialist/ Sr. Software Developer 08/09-06/10
General Motors/SCI, Markham, Ontario
· Led reporting analytic team to design and develop the data warehouse, ETL projects, and reporting solutions. The team includes 5 developers and a QA staff. Modeled the data according to the client requirements and business intelligence principles. Also worked on the architecture and created the prototypes for the related projects.
· Designed and developed solutions to help OEM's and dealers manage the end to end automotive sales process from campaign creation, to lead consolidation, delivery and management through sales, service and repurchase.
· Developed a Software-as-a-Service (SaaS) application that provides high performance services by using the state of the art technologies including ETL (SSIS), SSRS, SSAS (OLAP), .NET 3.5, C#, SQL server 2008, MVC, and Silverlight.
· Developed a report analytic project that generates reports for the campaigns as well as the lead fulfillment. The three tiered application consists of a report viewer, automates the data transfer, and manages the leads. A WCF service in C# handles the logic check and data access.
· Migrated Java application to C# .NET. The application automates and maintains the list of dealers across different states.
Technical Lead/ Sr. Software Engineer 08/08-08/09
Honda Canada Inc., Ontario
· Designed and developed a multi-tiered ASP.NET application for Honda.ca. The application intends to replace the paper brochure and help environment. Was also involved in the architecture and developing the innovative glossy online brochure using ASP.NET, C#, SQL server, data modeling, XML, service and object oriented page design, Java script, Ajax, and DHTML. The application also incorporates Google map and supports automatic IP to location detection mechanism.
Sr. Software Engineer 05/07-08/08
MDS Sciex, Concord, Ontario
- Worked on the architecture and development of a data acquisition application for high-performance bio-analytical measurement devices that accelerate and improve drug discovery and other life sciences research. The application is a multi-threaded multi-tiered application that acquires data in real time from multiple devices using C#, C, C++, XML, XAML, WCF, WPF, MySQL and a rich set of tools. The project includes a set of technology solutions for LC/MS (Liquid Chromatography/ Mass Spectrometry). The LC samples from an auto-sampler are injected into the mass spectrometer where it separates the ions of the given liquid in an electric field based on their charge and mass. The result of the mass spectrometry is stored, analyzed and compared against a given library to identify chemical characteristics of the candidate substances.
- Involved in the architecture, design, and development of this high-tech application using extreme programming approach (XP).
Sr. ETL/SSRS Developer/Sr. Software Engineer 01/06-05/07
Hexocom Ltd., Toronto, Ontario
- Involved in the architecture and development of an Enterprise Resource Planning (ERP) system for inventory management of companies such as Walmart, Costco, Blockbuster, Cadbury Adams.
- Developed several SSRS reports and automated the data transfer using ETL/SSIS. This distributed application, accessed from different cities, centralizes warehouse management and data entry. It’s an integrated system customized for logistic management with multiple functionalities that manages sales/purchase orders, warehouses, human resources, shipping, financing and scheduling.
- Developed an application using C# 2005, ASP.Net 2.0 and SQL server 2005 utilizing many tools including BizTalk, EDI, ETL, SQL Reporting Services, Web Services, XML, SSIS, Excel Automation, and InfoPath. This is to automate the data entry from various data and after applying rules using a rules engine the data is stored and processed in a Data Warehouse.
- Remodeled and integrated a financial application into the ERP system. The application includes account payable, account receivable, payroll, tax calculation for different warehouses in various provinces. Developed several Web Services for the application with the ability of caching to enhance performance. Designed and developed a graphical user interface (GUI) that changes dynamically based on the user interaction and selections.
- Developed a custom integration application to update the price for items through the API. The application also updates the barcodes, scans the products on conveyers using laser barcode scanners and retrieves the data back into the database. The application also analyzes the data and calculates an accurate KPI (Key Performance Indicator) for both human resources and the unit of operation itself.
Software Engineer 02/02-12/05
American SkySat Inc, California
· Led a team of 4 developers to develop an e-commerce application using Visual Studio .NET, ASP .NET, C# .NET, XML, CSS, XSL and SQL. The SQL database contains 45 tables and 50 stored procedures, etc. The application is a large ecommerce application with sophisticated Shopping Cart, Wish List, Product Catalog, Discounting, Coupons, Order Tracking, Fulfillment, Affiliates, Communities, etc. Has more than 50,000 lines of code in C# and ASP .NET that can be presented at the Interview (he does have the permission!):
· Migrated a banking application from classic ASP to ASP .NET. The application is a web-based asset management system that gives the user to customize portfolio, have watch list, and perform transactions. The application includes several Web Services and stock market objects, Capital Market, and provides secure access over TCP/IP.
· Was involved in developing an ERP system in visual C++ using advanced object oriented hierarchy and implemented the data warehouse. The application supports several modules in resource planning including sales, production, data exchange and inventory. Also was involved in designing the hierarchical structure for the object model and worked on the security issue.
· Developed an application in VB .NET and SQL server 2000 for windows, called ID maker. The application was designed to drive a digital camera, capture a picture and generate different ID cards (marketing for schools and clubs). The application also supports several customized filters. The Cannon digital camera is controlled via USB port.
· Was involved in the design flow of an ASIC. The IC is a video processing SOC. The project had several phases including simulation analysis, writing Perl and UNIX Shell scripts, Cadence ocean scripts to automate the testing; developing a simulator using C in UNIX environment, and using various tools for synthesis. Was also involved in the design verification and signal integrity analysis in the chip power distribution network (PDN) using PrimeTime SI.
· Identified areas of risk based on performance and reliability optimization for interconnects.
· Extracted the chip level thermal profile.
Software Engineer 5/01-01/02
Unisearch Associates, Concord, Ontario, Canada
Software Developer 10/00-5/01
01Communique, Mississauga, Ontario, Canada
Systems Analyst 3/98-9/00
Computek Inc., California
TECHNOLOGY
Data Warehouse, Data Mart, OLAP, OLTP Databases, Teradata, Netezza, Oracle, Parallel Data Warehouse (PDW), SQL Server, MDM, MDS, Data Quality (DQ), HDFS, Hive, Spark, Scala, Python, Hadoop, Sqoop, Map/Reduce, Hortonworks, Cloudera, MapR, HBase, Cassandra, Kafka, Storm, Spark Streaming, Zeppelin, Kibana, Spark MLib, Mahout, R, NiFi, Falcon, Oozie, Kylin, Atlas, Drill, Solr, ElasticSearch, Ambari,Ranger, Flume, Impala, Pig, HDInsight, StreamInsight, PolyBase, Microsoft SSIS, SSAS, SSRS, ETL, BI, MDX, PL/SQL, TSQL, ERwin, Enterprise Architecture (EA), SQL Servere 2000/2005/2008/2012/2014, Power Query, Power Map, PowerPivot, Power View, IBM Cognos, SPSS, InfoSphere DataStage, Informatica PowerCenter, SAP BusinessObjects (BO), SAP HANA, Crystal Reports, Hyperion, MicroStrategy, SharePoint 2007/2010/2013, Nintex, SharePoint Social, Collaboration, Record Management, Search, Web forms, InfoPath, Branding, CSOM, JSOM, PerformancePoint, Clustering, Failover, Web Analytics, Google Visualization, .NET 1.1 to 4.5, C#, WCF, Restful Services, WPF/Silverlight, WF, VB .NET, ASP .NET, ADO.NET, LINQ, MVC, MVVM, MVP, AJAX, Visual Studio, Dashboard Designer, SharePoint Designer, Visio, TFS, Cloud, Azure, PaaS, SaaS, IaaS, HTML 5.0, DHTML, XML, XSL, WSDL, XSD, JSON, COM, DCOM, MFC, C, Visual C++, Visual Basic, PowerShell scripts, and SDKs, DocXpress, BI Documentation, Nintex, SharePoint Social, Collaboration, Record Management, Search, Web forms, Branding.
ROLES
- Senior BI / DW Lead Consultant
- Senior Solution Architect Consultant
- Business intelligence technical lead
- Budgeting, Estimation, RFP, RFS
- BI / DW / Data Architect Consultant
- BI/SharePoint senior consultant
- Senior application developer
SOLUTIONS
- Business intelligence
- BI Frameworks
- Strategy and Implementation Plans
- Enterprise Metrics
- Integration Points
- Gap Analysis
- BI Portfolio
- Performance Management (PM)
- Solution and Integration
- BI life cycle
- Data quality and data cleansing
- Data mining and knowledge discovery
- Predictive analytics
- Real time BI
- Mobile BI
- Performance metrics and benchmarking
- Statistical inference
- Connect and integrate, monitor and govern, deploy and scale
- Data warehouse systems
- Data Warehouse MPP Appliances
- Inmon/ Kimball/ Imhoff models, data marts
- Real-time data integration and ETL
- Scalability and parallelism
- Revision and tuning
- Relational databases and Data Modeling
- RDBMS, Referential Integrity, ACID, Transactions, Locking, Indices, Partitioning
- Performance Tuning, Optimization
- HA, DR, Maintenance
- Big Data, PDW, NoSQL, Map/Reduce
- Hybrid
- Multi-Dimensional and Tabular databases
- OLAP cubes and Tabular modeling
- MDX
- Reporting
- Standard reports, ad-hoc analytical reports
- Map-based Reports
- Drill Down, Drill through, linked, and sub reports
- SharePoint Usage reports and web analytics
- SharePoint Integration
- Multi-machine SharePoint Farm Architecture
- Dashboard design, PerformancePoint, scorecards, KPIs, KPPIs, and reports
- Custom web parts, custom solutions
- Data visualization
- Power View, Power Map, PowerPivot, Excel, SSAS
- Google visualization
- Application Design and Development
- .NET Multi-threaded multi-tiered applications and web applications
- SharePoint web applications and custom solutions
- SaaS applications and service oriented architecture (SOA)
- Graphical user interfaces (GUI)
- Business Integration
- Integrating process and Information Modeling
- Asset management
- Information Technology Infrastructure Library (ITIL)
Service Asset and Configuration Management (SACM)
INDUSTRIES
- Government
- Municipalities
- Banking & financial
- Insurance