SUMMARY:

• Senior architecture and development positions in projects requiring wide and diverse set of skills and experience in Data Architecture and Modeling, Data Governance, Master Data Management, Data Modeler/Data Warehouse, Data Integration (ETL) and Business Intelligence (BI) Architecture and Development, Big Data tools, techniques and frameworks:
• 16 years in Data Architecture and Modeling, Data Modeler, Data Transformation, Master Data Management and Data Governance.
• 16 years in and Data Integration/ETL Design and Development, Data Warehouse Architecture and Implementation,
• 16 years in Business Intelligence Architecture and Report Development, Retrospective/Predictive Analytics.
• 16 years in Relational Database Administration and Programming, Business and Systems Analysis and Architecture.
• 5 years in Big Data tools, techniques, frameworks and NoSQL databases: Hadoop, HDFS, HIVE, HBASE, MonetDB, MongoDB.

TECHNICAL SKILLS:

Databases: Oracle, MS SQL Server, IBM Informix, IBM DB2/UDB, IBM Netezza, Oracle Exadata, Cloudera Hadoop, HDFS, HIVE, HBASE, MonetDB, MongoDB, Postgres/PostgreSQL.

Modeling Tools: Sybase PowerDesigner, Oracle Designer, CA Erwin Data Modeler, Microsoft Visio.

Data Integration: Informatica Platform, Informatica Big Data Edition, Informatica PowerExchange for Lotus Notes/PeopleSoft/SAP/Netezza, Streamsets, Microsoft SQL*Server Integration Services (SSIS), Oracle PL/SQL packages.

Business Intelligence: Cognos BI Suite, MS Power BI, Oracle OBI, MS SQL*Server Analysis (SSAS) and Reporting Services (SSRS), SAP BusinessObjects XI, Oracle Reports.

Programming Environments: HIVE QL, HBASE Shell, Altova XMLSpy, Altova MapForce, Oracle PL/SQL Packages, SOA and Microservices Design Patterns, Python, Java, Scala, JDBC, XML, HTML, Web Services, PL/SQL, SQL, Unix/Linux Shell Scripting.

Operating Systems: Oracle Enterprise Linux, RedHat Linux, Sun Solaris, IBM AIX, HP - UX, Private/Public/Hybrid Clouds.

Methodologies: Ralph Kimball and Bill Inmon DW/BI methodologies, Agile Software Development, SCRUM.

Web and Application Servers: IBM Web Sphere Application Server, Oracle Application Server, Oracle BEA WebLogic, Microsoft IIS, JBoss Application Server, Apache Tomcat Servlet Container.

Application Software: Oracle Siebel CRM, IBM Lotus Notes, PeopleSoft HRMS, Lawson Financial Applications, XRT-CERG Cash and Treasury Management, Syscon OTIS, Niche Police RMS, Versaterm VDX RMS.

Version Control: Apache Git and Bitbucket, Atlasian JIRA,IBM Rational ClearCase, Microsoft Visual SourceSafe.

Publications: Author of University books Advanced Programming in C/C++ Language

PROFESSIONAL EXPERIENCE:

Data and Database Architect

Confidential

Responsibilities:

• Assisted in Cerebri AI Pipeline architecture based on Streamsets Data Collector and Spark Data Processing and Streaming.
• Designed and deployed standardized data models for Cerebri AI applications, API and UI.
• Designed and deployed Cerebri AI Pipeline metadata repositories with data catalogue, processing rules, data and processing versioning, mappings, application and pipeline logging, tracing and tracking.
• Designed and deployed data models for Data Ingestion and Landing Zones, Dimensional Store, Feature and Label Bank, Model Bank, Model, Cerebri Projections (API-read Optimized Tables) and Data Cubes for BI interface.

Technology Stack: CA ERwin Data Modeler, Postgres/PostgreSQL, MonetDB, Apache Git and Bitbucket, Atlasian JIRA, Microsoft Azure, Streamsets Data Collector, Airflow, Elasticsearch with Kibana, Microservices Design Patterns, Microsoft Teams, Agile Software Development (SCRUM).

Solution Designer and Data Architect

Confidential

Responsibilities:

• Provided overall technical solutions, data architecture, data integration design and business intelligence architecture.
• Identified and evaluated source data elements, identified their mutual relationships and application data entry dependencies, and developed and articulated rules to extract, transform and load them to REDI Data Warehouse based on Big Data technology stack.
• Designed logical and physical relational and multi-dimensional data models and physicalized them in most optimal way.
• Designed, developed and deployed ETL/Data Integration processes with robust workflows, e-mail notifications and error-message handlers, and designed and helped develop ETL for data migration to Big Data Platform and Cloud.
• Designed, developed and published cubes, reports, scorecards, key performance indicators (KPI), retrospective and predictive analytics.
• Prepared technical documentation Deployment and Operation’s Guides and System Design Document for the solutions.

Technology Stack: SAP PowerDesigner, CA ERwin Data Modeler, Cloudera Hadoop, HDFS, HIVE, HIVE QL, HBASE, HBASE Shell, MongoDB, Informatica Platform for Big Data, IBM Cognos BI Suite, Oracle Siebel CRM, IBM Lotus Notes, Web Services, Oracle, OPS Private Cloud, Microsoft Azure, Agile Software Development (SCRUM).

Solution and Data Architect

Confidential

Responsibilities:

• Delivered High Level and Detailed Solution Architecture for uploading flat files (files intake) from primary insurance agencies in non-standardized format into Munich Re Proprietary International System for Commercial Lines (ISyCL).
• Lead development of files intake uploading into Munich Re ISyCL Application, and managed and instructed the offshore development.
• Delivered High Level and Detailed Design Document for Munich Re Data Warehouse based on Hadoop and Big Data technology stack.
• Designed logical and physical relational and multi-dimensional data models and physicalized them in most optimal way.
• Designed ETL between Munich Re application databases and Munich Re Data Warehouse, managed and instructed the off-shoring development team, and designed and helped develop ETL for data migration to Big Data Platform and Cloud.
• Conducted rationalization of the current Business Intelligence reports, discovered the duplicated and overlapped reports and suggested their merging and optimization using the newly built MROC Data Warehouse.
• Defined corporate-level Data Governance and Master Data Management Frameworks including business procedures and processes.
• Served as a liaison between MROC technical and business staff and on-board and off-shoring development teams.

Technology Stack: SAP PowerDesigner, CA ERwin Data Modeler, Cloudera Hadoop, HDFS, HIVE, HIVE QL, HBASE, HBASE Shell, MongoDB, Microsoft SQL*Server Integration and Reporting Services (SSIS, SSAS, SSRS), Oracle, MS Sql*Server, MS Visual Studio, Microsoft Power BI, Microsoft Azure, Munich Re Private Cloud, Altova XMLSpy, Altova MapForce, Microservices Design Patterns, Agile Software Development (SCRUM).

Solution Designer and Data Architect

Confidential

Responsibilities:

• Helped determine the project work plans, project timelines and milestones, implementation and deployment approach and evaluation methods throughout the project management lifecycle (PMLC).
• Provided overall technical solutions, data architecture, data integration design and business intelligence architecture.
• Identified source data elements, identified their mutual relationships and application data entry dependencies, and developed and articulated rules to extract, transform and load them to REDI Data Warehouse.
• Designed logical and physical relational and multi-dimensional data models and physicalized them in most optimal way.
• Designed, developed and deployed ETL/Data Integration processes with robust workflows, e-mail notifications, error-message handlers, tuned performance execution, and designed and helped develop ETL for data migration to Big Data Platform and Cloud.
• Designed and facilitated development and publishing cubes, reports, mobile reports, key performance indicators (KPI) and dashboards.
• Defined and implemented Ministry-level Data Governance and Master Data Management Strategies and Frameworks.
• Prepared technical documentation Deployment and Operation’s Guides and System Design Document for the solutions.

Technology Stack: SAP PowerDesigner, CA ERwin Data Modeler, Informatica Platform for Big Data, Cloudera Hadoop, HIVE, HIVE QL, Mongo DB, IBM Cognos BI Suite, Oracle Siebel CRM, IBM Lotus Notes, Oracle, MS SQL*Server, IBM DB2/UDB, OPS Private Cloud, Microsoft Azure, Altova XMLSpy, Altova MapForce, Web Services, Agile Software Development (SCRUM).

Confidential

Data Warehouse Architect / Data Architect

Responsibilities:

• Analyzed current CIBC Risk Data Warehouses (retail, wholesale, market, trading and operational) define common risk data elements for data integration and presented results to RDA teams.
• Helped design, implement and load Enterprise Data Hub with Cloudera Hadoop and Informatica for Big Data.
• Participated in discussion about candidate and final enterprise architecture for risk data aggregation, and in mapping exercises with OFSAA and IBM BDW atomic and dimensional data models as candidates for integrated risk data models.
• Participated in definition and implementation of Data Governance and Master Data Management strategy, policies and rules.
• Prepared solution and defined sources for gathering metadata about information assets like risk databases, logical and physical data models, Informatica and SAS repositories, and others.
• Designed logical and physical relational and multi-dimensional data models and physicalized them in most optimal way.
• Handled data migration and conversion from IBM Netezza and Oracle Exadata to Cloudera Hadoop Platform.
• Defined data lineage for OSFI Reports with compliance with Basel III/BCBS 239 principles.
• Technology Stack: CA ERwin Data Modeler, IBM Netezza, Oracle Exadata, Cisco Information Server, Informatica Platform for Big Data, Cloudera Hadoop, HIVE, HIVE QL, Altova XMLSpy, Altova MapForce, Agile Software Development (SCRUM).

Solution Designer and Data Architect

Confidential

Responsibilities:

• Provided technical leadership for the project and directed the development teams in all phases of the project.
• Identified and evaluated data sources and elements for completeness and suitability, identified their mutual relationships and application data entry dependencies, and developed and articulated rules to extract, transform and integrate source data into MPI search engine.
• Developed data models for MPI search engine, multi-dimensional data models for MPI statistical analysis and reporting and implemented them into MPI database in most optimal way.
• Designed, developed and deployed and ETL/Data Integration processes with robust workflows, e-mail notifications, error-message handlers and tuned the overall system.

Technology Stack: SAP PowerDesigner, CA ERwin Data Modeler, Cloudera Hadoop, HDFS, HBASE, HBASE Shell, Informatica Platform for Big Data, Oracle Siebel CRM, IBM Lotus Notes, Oracle, MS SQL*Server, Informatica PowerExchange for Lotus Notes, Agile Software Development (SCRUM).

Senior Information Architect and Team Lead

Confidential

Responsibilities:

• Designed and established robust TPS Data Warehouse for Business Intelligence reporting capable to support TPS BI requirements and worked with SMEs to define reporting and analytical requirements and organized ETL and Business Intelligence development.
• Identified and evaluated source data elements, identified their mutual relationships and dependencies, and developed and articulated rules to extract, transform and integrate source data into multi-dimensional data models.
• Designed logical and physical relational and multi-dimensional data models and physicalized them in most optimal way.
• Designed, developed and deployed ETL/Data Integration processes with robust workflows, e-mail notifications, error-message handlers with optimal performance of the overall solution.
• Designed, developed and published cubes, reports, active reports, mobile reports, scorecards, key performance indicators (KPI), retrospective and predictive analytics (crime index trends), dashboards and KPIs.
• Analyzed security and privacy requirements, defined Data Governance business and Master Data Management procedures and processes and configured TPS BI environment accordingly.

Technology Stack: IBM Informix, Versaterm VDX RMS (RMS, Court, Property), CA ERWin Data Modeler, Altova XMLSpy, Altova MapForce, Microsoft SQL*Server Integration and Reporting Services (SSIS, SSAS, SSRS), IBM Cognos BI Suite, Oracle, IBM DB2/UDB, MS SQL*Server, PeopleSoft HRMS, SAP Financials, Agile Software Development.

Senior Data Architect

Confidential

Responsibilities:

• Participated in sessions with subject matter experts to clarify mathematical models for scorecards and decision trees and techniques planned to use for clients’ credit risk assessment.
• Designed conceptual, logical and physical relational de-normalized and multi-dimensional data models, deployed and maintained them and made specifications for cubes.
• Developed and articulated rules to extract, transform and integrate source data elements into a consistent and interrelated normalized relational and multi-dimensional data models, and provided source-to-target mappings.
• Helped design, develop, test, publish and maintain cubes, reports, mobile and active reports, dashboards, to visualize quantitative credit risk estimations and their mutual comparison.
• Designed and Implemented Data Governance business and Master Data Management Frameworks.
• Provided technical leadership for the project and directed the ETL and BI development teams in all phases of the project.

Environment: CA ERWin Data Modeler, Oracle, IBM DB2, IBM Cognos BI Suite, IBM SPSS Statistics, IBM SPSS Modeler, Informatica Platform, Teradata FS-LDM, IBM Netezza, Microsoft Windows, Agile Software Development.

Senior Data Integration Architect

Confidential

Responsibilities:

• Identified MDM processes for data source identification, data collection, data transformation, normalization, business rule administration, error detection and correction, data reconciliation and consolidation, data storage capacity, and data distribution across security applications.
• Designed, configured, developed, tested and deployed MDM processes for source data identification, data collection, data transformation, normalization, business rule administration, error detection and correction, master data cleansing, matching and consolidation, and master data publishing and distribution across target security applications.
• Identified Data Governance processes and methods with focus on data quality, privacy, regulatory compliance, security and data integration, and determined decision rights and accountabilities for data stewards and data custodians how to handle data.
• Designed logical and physical relational and multi-dimensional data models and physicalized them in most optimal way.
• Organized sessions to demonstrate Data Governance and Master Data Management benefits.

Technology Stack: Sybase PowerDesigner, CA ERwin Data Modeler, Informatica, Oracle, Microsoft SQL*Server Integration and Reporting Services (SSIS, SSAS, SSRS).

Solution Designer and Data Architect

Confidential

Responsibilities:

• Defined project goals and objectives, project work plans, project timelines and milestones, identified potential project risks, reviewed project activities, defined implementation and deployment strategies and evaluation methods.
• Defined rules for data source identification, data collection, data transformation, normalization, business rule administration, error detection and correction, data reconciliation and consolidation and data distribution across source application databases.
• Provided source data validation, analyzed source data quality, lead source data quality resolution, and provided complete set of mappings between source data elements and WIRE reporting data elements and defined data transformation rules.
• Designed conceptual, logical and physical normalized relational and multi-dimensional data models, deployed and maintained them in source application databases and WIRE Data Warehouse.
• Designed, developed and deployed data integration code, processes and workflows, e-mail notifications, error-message handlers, and performance tuning of the overall solution in a fully integrated Business Intelligence environment.
• Identified Data Governance and Master Data Management processes and methods with focus on regulatory compliance, security and data integration, and determined decision rights and accountabilities for data stewards and data custodians.
• Designed, developed and delivered reports, dashboards, scorecards, and modeled key performance indicators (KPIs).

Technology Stack: Oracle RAC, MS SQL*Server, CA ERwin Data Modeler, IBM Cognos BI, Informatica Platform (DI, DQ, MDM), Sybase PowerDesigner, Oracle Siebel CRM, Oracle OBI, Microsoft SharePoint, Agile Software Development.