David Mcintyre
- Lead ETL Designer/Developer
- Princeton, NJ
- Member Since Mar 16, 2023
Candidates About
David Mcintyre
Summary
● Business Intelligence Lead/Developer
● Cloud Engineer
● SQL Server and Oracle database design & implementation experience
● ETL process design and development experience
● Report design and development experience
● Insurance industry experience
● Financial services industry experience (Fixed Income, Equities, Repos, Securities Lending)
Technical Skills
|
|
|
|
Cloud |
Amazon Web Services (AWS), Amazon Relational Database Service (RDS), Amazon Elastic Compute Cloud (EC2), Amazon S3, Amazon Simple Workflow Service (SWS), Amazon DynamoDB, AWS Elastic Beanstalk, AWS CloudFormation, AWS Identity and Access Management (IAM), Amazon Virtual Private Cloud (VPC), Cloud Security |
|
Databases |
Microsoft SQL Server (2012, 2008/R2, 2005), Oracle |
|
Operating Systems
|
Windows, LINUX/UNIX |
|
Software/Tools/ Languages |
Microsoft (MS) SQL Server BI platform, SQL Server Integration Services/Analysis Services/Reporting Services (SSIS, SSAS, SSRS), .NET, Data Mining, SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), Business Intelligence Development Studio (BIDS), Visual Studio, Team Foundation Server (TFS), SharePoint, Power BI, PL/SQL Developer, Red Gate, SQL, C# |
|
Other |
Business intelligence and data warehouse (DW) solution design & implementation, Business Analysis, Relational and OLAP database design & implementation, Data Warehousing, Decision Support, ETL, Data architecture, Data Management, Business Process Management, Logical & physical data modeling, Dimensional modeling, Reporting & analytics, Data quality, Data cleansing, Reference / Master Data Management (MDM), Software engineering, Software Development Life Cycle (SDLC), Agile software development, Query optimization, Performance tuning, Disaster recovery (DR), Microsoft Certified Professional (MCP), Cloud certification, Workday |
Professional Experience
|
Axis Capital Business Intelligence Lead |
Mar 2015-Present |
Princeton, NJ |
BI lead responsible for delivery of specialty insurance company’s BI solutions for premium and claims applications incl. data warehousing and reporting applications. Processes leverage the entire SQL Server 2008 R2/2012 BI platform incl. database engine, SSIS, SSRS and SSAS/cube.
Responsibilities:
● Interfacing and collaborating with management, stakeholders and peers.
● Manage and lead projects incl. working w/ offshore teams.
● Requirements gathering, analysis and documentation.
● Solution design and implementation.
● Design and development of solutions incl. database objects (tables, views, stored procedures), reports using SSRS, ETL processes using SSIS incl. use of:
o Script tasks.
o Property expressions.
o Process auditing.
o Configurations.
|
AAA Lead ETL Designer/Developer |
Sep 2014-Jan 2015 |
Mount Laurel, NJ |
Lead ETL designer/developer for data validation and conversion/mapping process between company’s legacy financial management application and Workday Financials software-as-a-service (SaaS) financial management application. Processes leverage the SQL Server 2012 BI platform incl. database engine and SSIS.
Responsibilities:
● Requirements gathering, analysis and documentation.
● Interfacing and collaborating with management, stakeholders and peers.
● Solution design improvement.
● Performance tuning.
● Design and development of solution incl. database objects, ETL processes using SSIS incl. use of:
o XML files.
o Script tasks.
o Property expressions.
o Process auditing.
o Configurations.
|
Industrial and Commercial Bank of China Financial Services (ICBCFS) Business Intelligence Lead/Developer |
Jan 2011-Jul 2014 |
New York, NY |
BI lead/developer for several securities broker-dealer back office technology solutions leveraging the SQL Server 2008 & 2012 platforms and making use of all BI components, i.e. database engine, SSIS, SSRS, SSAS.
Responsibilities:
● Requirements gathering, analysis & design, development & implementation, support & documentation.
● Interfacing and collaborating with management, stakeholders and peers.
● Architecture, design and development in all areas of solutions incl. data warehouse, ETL processes, report production
● Disaster recovery (DR) implementation
● Design, development and implementation of the data warehouse incl.:
o Dimensional data model.
o ETL processes using SSIS incl. use of:
▪ Script tasks/components.
▪ Property expressions.
▪ SSIS configurations and logging.
▪ SCD (slowly-changing dimension).
● Design and development of reporting suites (using SSRS) leveraging the data warehouse and providing following functionality:
o Reporting and analysis of repo and securities lending data (incl. reconciliation against the general ledger).
o Risk Weighted Asset (RWA) Calculations.
o Management Reporting suite combining general ledger and timesheet data to provide additional perspectives and analysis vs. GAAP reporting, incl. reporting/analysis by business units and cost centers.
|
Brookfield Properties Business Intelligence Lead/Developer |
Mar 2010-Jan 2011 |
New York, NY |
BI lead/developer for Global Real Estate BI solution, an enterprise reporting platform providing collection and analysis of operational and financial metrics. App. features SharePoint and leverages the SQL Server 2008 BI platform and all BI components, i.e. database engine, SSIS, SSRS, SSAS.
Responsibilities:
● Requirements gathering, analysis and documentation.
● Architecture, design and development of BI solution incl. data warehouse, ETL processes, OLAP cube/UDM, report production.
● Design and development of dimensional model for data warehouse incl. definition of measures, dimensions, hierarchies, etc.
● Design and development of ETL processes using SSIS.
● Design and development of SSAS OLAP cube/UDM database including:
o Maintenance of dimensions (incl. attribute relationships and user-defined hierarchies).
o Maintenance of measures and measure groups.
|
Max Capital Group Business Intelligence Lead/Developer |
May 2009-Mar 2010 |
Florham Park, NJ |
Member of design & development team for (specialty insurance and reinsurance) Global Reporting Platform, a BI application featuring a global data warehouse and enterprise-wide reporting platform. Based on the MS SQL Server 2008 BI platform, the app. supports organization wide operational, analytical and compliance reporting in which access to insurance premium and claims data is vastly improved and simplified.
Responsibilities:
● Development and maintenance of data warehouse objects and ETL processes using SSIS, including:
o Dimensional modeling/data warehouse design.
o Multiple source data integration/Master data management (MDM).
● Development and maintenance of SSAS OLAP cube databases including:
o Maintenance of dimensions (incl. regular, reference and many-to-many dimension relationships, attribute relationships and hierarchies).
o Maintenance of measures and measure groups.
● Development and maintenance of production reports/dashboards for BI portal.
|
Symphic Technology Principal |
Aug 2006-May 2009 |
Edison, NJ |
Principal and principal trainer/consultant at this Microsoft partner and leading SQL Server BI training & consulting services provider.
Involved in all aspects of running company including scheduling and delivering classes.
Responsibilities:
● Developer and author of class content, class software and user manuals covering how to use all components of the Microsoft SQL Server BI platform, i.e.:
o Integration Services (SSIS).
o Analysis Services (SSAS - Multidimensional data).
o Reporting Services (SSRS).
o Data Mining.
● Author of:
o Class agenda documents.
o Student user guides.
o Student labs & lab instruction documents.
|
United Online Software Developer/Business Intelligence Architect |
Dec 1996-Aug 2006 |
New York, NY |
Software developer and BI architect providing hands-on technical expertise in software architecture, design and implementation.
Responsibilities:
● Work with Business and Technology groups to design solutions that meet their needs.
● Participate in all phases of SDLC incl. working with stakeholders and peers in identifying and defining requirements.
● Participate in vendor evaluations.
● Design and implementation of BI solutions using SQL Server platform for financial and CRM functional areas.
● Design & development of relational data warehouse & OLAP databases incl. dimensional data warehouse design.
● Design and implementation of reporting/analytics solutions
● Production support and application maintenance.
Education
|
Undergraduate |
BS in Business Administration in Computer Information Systems (Thomas Edison State College) |
|
Cloud |
Cloud Computing Certificate (Rackspace) AWS Certified Developer – Associate (Candidate)
|