Andrew Maciver

Andrew Maciver Email and Phone Number

Consultant @
Andrew Maciver's Location
Ottawa, Ontario, Canada, Canada
Andrew Maciver's Contact Details

Andrew Maciver personal email

About Andrew Maciver

Integration Management professional for cloud application, migration and data integration, and data warehousing with superior client management and project delivery skills (managing/leading projects, coordinating business requirements and design sessions). Multi-faceted communication and technical skills easily integrate business and technical communities. Functional roles performed:• Data engineer/integration lead (data analysis, testing, validation, normalization and reconciliation, data modeling, data warehousing, ETL, data conversion and data migration, data warehouse tester)• Application integration lead (technical and data requirements, security, cloud integration, cloud migration and development, data transformation, SAAS, sFTP file transfer, web services)• Data architect / DBA developing architecture frameworks, methodology, metadata registry / master data repositoriesTechnologies utilized:• Azure, Spark, DataBricks, Python Notebooks, AWS, AWS Glue,S3, Python, Parquet,Saas, Web services, Unix, SOAP/Rest/XMl, Cloud • SQL databases (Redshift, Oracle, SQL Server, MySQL, Sybase)• Business Intelligence tools PowerBI, Cognos (Frramework Manager, Metrics Studio/CMM, Analysis Studio), PowerPlay, Impromptu, ReportNet, Informatica PowerMart, SSAS)• ETL/Data warehousing (Databricks, SQL Server SSIS, Infosphere DataStage,. Data Manager, Informatica PowerMart, Data Junction, PL/SQL, Dell Boomi, Data Integrator, DbFit)• Metadata and Data modeling (Cognos Framework Manager, ErWin, Oracle Designer,SQL Developer Modeler, Visio), UML (Use Case, Sequence,Activity ), XML, XML Schema• Developer in Python, Java, .Net, Perl, Transact SQL, PL/SQL , Visual Basic, C++, ASP , DbFit/Fitnesse• Communications: Microsoft Teams, DevOps, Outlook.

Andrew Maciver's Current Company Details
Data Foresight

Data Foresight

Consultant
Andrew Maciver Work Experience Details
  • Data Foresight
    Consultant
    Data Foresight Jul 2019 - Present
  • Accenture
    Software Engineering Associate Manager
    Accenture Jan 2017 - Jan 2019
    Led the CMHC data warehouse project consisting of SQL Server, DB2, SSIS/SSAS/SSRS, Cognos Powerplay, Datastage. Managed integrations for Finance, Insurance, HR.
    View
  • Canada Mortgage And And Housing Corporation (Cmhc)
    Metadata Dictionary Specialist
    Canada Mortgage And And Housing Corporation (Cmhc) Jul 2015 - Jan 2017
    Metadata SpecialistStraddling the technical and business divide, led the technical design and implementation of CMHC’s pilot enterprise information governance program, managing a SAS technical team for implementation. Represented Information Technology on the Data Governance committee, contributing technical expertise and elucidating clarity of new process requirements, ensuring the smooth flow of information.Environment: SAS Data Integration Studio (DI Studio), Dataflux Data Quality Analysis, Business Development Network, SAS Data Governance, SAS Lineage, SAS EG, Windows Server 2012, SQL Server, DB2, ITIL Service Management
  • Mitel
    Application Integration Management
    Mitel Jul 2013 - Jul 2015
    With full ownership of the organization’s Cloud integration service (server hardware/software, security, applications, web services), managed, planned, and organized the consistent, stable and cost-effective operation of the IPAAS integration platform service. Led application integrations, renewal, data architecture and data migrations to ensure alignment with long term strategy. Developed communication channels with multiple business unit managers, raised awareness of integration capabilities, planned integration solutions to business needs while simultaneously rapidly establishing teams/infrastructure for the evaluation of new cloud applications (Enterprise Search, legal) for business/technology replacement .Managed offshore support and development teams in the integration domain. Environment: SAP and Salesforce, Java, JDBC, ETL, Windows Server 2008, Unix, SOAP/Rest web services, Pervasive/Actian, Boomi.
    View
  • Data Foresight Inc
    Senior Associate
    Data Foresight Inc Oct 2006 - Jul 2013
    Information and Data Management consulting.Lead Datastage Etl architect at Aboriginal Affairs and Northern Development.Data Foresight specializes in data management (data architecture frameworks, methodology, metadata and data analysis, data modeling, ETL/Datastage, data conversion and migration), requirements management, and business intelligence.
  • Cognos Inc
    Senior Software Architect
    Cognos Inc Feb 2005 - Sep 2006
    As an architect within Platform Architecture (ownership of Cognos 8 architecture), established business case and directed a task force across multiple teams for the business requirements for a metadata repository across business intelligence and performance management lines of business. Organized a full day team-building workshop for over 30 of Cognos’ senior software architects. Delivered the opening address, establishing objectives while easing the barriers to communication.Managed multi-team analysis project, facilitated several meetings between product management and development, validating then relating requirements to development capabilities, schedules and resourcing.
    View
  • Data Foresight Inc
    Senior Consultant
    Data Foresight Inc Jan 1996 - Jan 2005
    Project delivery, product planning, business and requirements analysis, application development.
  • Nutat Technologies
    Technology Architect
    Nutat Technologies Nov 1986 - Dec 1995

Andrew Maciver Skills

Data Warehousing Data Modeling Business Intelligence Microsoft Sql Server Business Analysis Etl Databases Sql Data Analysis Data Architecture Informatica Java Cognos Pl/sql Datastage Data Conversion Product Management Data Profiling Data Quality Ssis .net Cognos Reportnet C++ Erwin Uml Oracle T Sql Sql Server Integration Services Unified Modeling Language Data Reconciliation Cognos 8 Oracle Sql Information Governance Sas Data Integration Studio Itil Certified

Frequently Asked Questions about Andrew Maciver

What company does Andrew Maciver work for?

Andrew Maciver works for Data Foresight

What is Andrew Maciver's role at the current company?

Andrew Maciver's current role is Consultant.

What is Andrew Maciver's email address?

Andrew Maciver's email address is an****@****ail.com

What skills is Andrew Maciver known for?

Andrew Maciver has skills like Data Warehousing, Data Modeling, Business Intelligence, Microsoft Sql Server, Business Analysis, Etl, Databases, Sql, Data Analysis, Data Architecture, Informatica, Java.

Not the Andrew Maciver you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.