Cardinal Solutions was acquired by Insight in August of 2018 and merged with Blue Metal Architects to form Insight's Digital Innovation Group. A Team Lead for the Data & AI practice provides leadership and directionality to both the team and the company overall. The position provides a set of skills/responsibilities, which include:• Lead the Data and AI team for the Atlanta office, focusing on skill set development, professional development, and career path planning. • Represent the team to upper management, standing as an interviewing resource for hiring, and offering recommendations for staffing based on team skills and capabilities. • Function as the primary source for data project pre-sales and sales support for Atlanta sales channel, as needed.In addition to the role of Team Lead, continued to provide the full range of skills required for a Consultant in the Data and AI space, which include:• Act as a Subject Matter Expert, providing technical and business segment knowledge of Data and its specific potential application for the customer.• Work with customers during the initial phases of a project to define scope and identify the strategic and tactical issues to be addressed by the project.• Work with the business knowledge holders to define and design all of the technical and architectural components of the solution.• Build and deploy the project. This was done for projects including all of the technical arenas that Data covers • Document the entire solution, including instructions for execution and maintenance.• Train users and engineers in use and/or maintenance of an existing or newly built system.• Provide thought leadership through the development of design patterns and internal standards.

The Lead of the Data Solutions team provides leadership and directionality to both the team and the company overall. The position provides a set of skills/responsibilities, which include:• Led a team of five Data Solutions Consultants, focusing on skill set development, professional development, and career path planning. • Represented the either team to upper management, standing as the primary conduit of recommendations for staffing of projects. • Functioned as the primary source for project scoping and estimation for many Data Solutions projects.• Aiding in setting company goals for the use of new technologies related to the data space.In addition to the role of Lead, continued to provide the full range of skills required for a Consultant in Data Solutions, which include:• Act as a Subject Matter Expert, providing technical and business segment knowledge of Data and its specific potential application for the customer.• Work with customers during the initial phases of a project to define scope and identify the strategic and tactical issues to be addressed by the project.• Work with the business knowledge holders to define and design all of the technical and architectural components of the solution.• Build and deploy the project. This was done for projects including all of the technical arenas that Data covers • Document the entire solution, including instructions for execution and maintenance.• Train users and engineers in use and/or maintenance of an existing or newly built system.• Provide thought leadership through the development of design patterns and internal standards.

Provides the full range of skills required for a Consultant in Data and Business Intelligence, which include:• Act as a Subject Matter Expert, providing technical and business segment knowledge of BI and it specific potential application for the customer.• Work with customers during the initial phases of a project to define scope and identify the strategic and tactical issues to be addressed by the project.• Work with the business knowledge holders to define and design all of the technical and architectural components of the solution.• Build and deploy the project. This was done for projects including all of the technical arenas that Business Intelligence covers (Database design, Data Warehousing, ETL, Cubes, Reporting)• Document the entire solution, including instructions for execution and maintenance.• Provide both tactical and strategic level consulting for client's data landscape• Train users and engineers in use and/or maintenance of an existing or newly built system.• Provide thought leadership through the authoring of whitepapers and internal standards.All work was designed and delivered using the Microsoft BI stack (SQL Server, Power BI, SSIS, SSRS, SSAS, Sharepoint, PerformancePoint). Versions 2005, 2008, 2012 and 2016 of the Microsoft BI stack were used for various engagements.

The Practice Director provides leadership and directionality to both the team and the company overall. The position provides a set of skills/responsibilites, which include:• Led a team of twelve Data Services Consultants, focusing on skill set development, professional development, and career path planning. • Represented the either team to upper management, standing as the primary conduit of recommendations for staffing of projects. • Functioned as the primary source for project scoping and estimation for many Data Services projects.• Aiding in setting company goals for the use of new technologies related to the data space.In addition to the role of Practice Director, continued to provide the full range of skills required for a Consultant in Data and Business Intelligence, which include:• Act as a Subject Matter Expert, providing technical and business segment knowledge of BI and it specific potential application for the customer.• Work with customers during the initial phases of a project to define scope and identify the strategic and tactical issues to be addressed by the project.• Work with the business knowledge holders to define and design all of the technical and architectural components of the solution.• Build and deploy the project. This was done for projects including all of the technical arenas that Business Intelligence covers (Database design, Data Warehousing, ETL, Cubes, Reporting)• Document the entire solution, including instructions for execution and maintenance.• Train users and engineers in use and/or maintenance of an existing or newly built system.• Provide thought leadership through the authoring of whitepapers and internal standards.All work was designed and delivered using the Microsoft BI stack (SQL Server, SSIS, SSRS, SSAS, Sharepoint, PerformancePoint, PowerPivot). The 2005,2008, and 2012 versions of the Microsoft BI stack were used.

Provides the full range of skills required for a Consultant in Business Intelligence, which include:• Act as a Subject Matter Expert, providing technical and business segment knowledge of BI and it specific potential application for the customer.• Work with customers during the initial phases of a project to define scope and identify the strategic and tactical issues to be addressed by the project.• Work with the business knowledge holders to define and design all of the technical and architectural components of the solution.• Build and deploy the project. This was done for projects including all of the technical arenas that Business Intelligence covers (Database design, Data Warehousing, ETL, Cubes, Reporting)• Document the entire solution, including instructions for execution and maintenance.• Train users and engineers in use and/or maintenance of an existing or newly built system.• Provide thought leadership through the authoring of whitepapers and internal standards.All work was designed and delivered using the Microsoft BI stack (SQL Server, SSIS, SSRS, SSAS, Sharepoint, PerformancePoint). Both the 2005 and 2008 versions of the Microsoft BI stack were used

Inherited an existing Enterprise Data Warehouse (EDW) built using the Microsoft BI stack (SQL Server, SSIS, SSRS, SSAS). The EDW was suffering significant performance problems in the ETL and Reporting areas. Additionally, the EDW was prone to uptime and reliability issues. Adoption and usage were poor and user confidence was low.• Addressed several performance issues by making targeted schema changes in the database. ETL and Report performance were both significantly improved. • Redesigned the ETL solution in multiple phases, first re-factoring the base business logic code for performance and accuracy, and second, redesigning the package layouts and structure, improving maintainability and troubleshooting.• Created a ETL strategy and design template to govern all new ETL development, insuring consistent package naming, logging, error handling, etc..• Developed a style template and design template for all new reports. Retro-fitted most of the existing reports to this set of templates.• Upgraded the entire EDW environment to SQL Server 2008 from SQL Server 2005.• Designed and implemented a Report Model for the power users and business analysts.• Grew the EDW team from one to four persons, functioning as both technical architect and manager. • Rolled the EDW Reporting Portal out to a user base of over one hundred users, with daily usage averaging several report requests per day per user.• Moved the ETL nightly run to a eight-times-per-day process cycle, allowing for morning, mid-day, afternoon and early evening analysis of current day information.• Replaced SQL Server 2000 SQL Server 2005 Data Cubes with a single partitioned cube for use across the company.Overall gains in the EDW environment included a reduction of ETL run time from 6+ hours to approximately ten minutes per run. All user reports respond to user requests in under one minute. Usage was very solid, with a high level of user adoption and reliance on the EDW data.

Provided the full range of skills required for a Senior Consultant in Business Intelligence, which include:• Work with the Sales team in a Subject Matter Expert capacity, providing technical and business segment knowledge of BI and it specific potential application for the potential customer.• Lead and/or participate in the Explore phase of a customer project, working with the Business requestors and stakeholders in the customer’s company to define the scope and specific “pain points” that the project will address• Conduct a thorough Analyze and Define phase of the project, working with the business knowledge holders to define and design all of the technical and system architecture components of the solution, including hardware, software platform, application and all of the component pieces of the technical solution.• Lead and/or work in the Build and Deploy phase of the project to fully implement and deploy the designed solution. This includes all of the technical implementation (Data Warehouse, ETL, OLAP Cubes, Reporting, Dashboard and Scorecards, etc..) as well as support of User Acceptance Testing and collaboration with internal I.T. groups for the final deployment. Documentation of the entire solution, including instructions for execution and maintenance are provided, as is user training when required.• Consult with users with specific tactical needs involving existing BI systems.• Provide thought leadership through the authoring of whitepapers and internal standards.

Performed all of the standard job functions of a Database Architect as a normal part of the job:Work with business requestors to develop requirementsArchitect the databases:Evaluate requirements for their relevancy to (and impact on) the databases. Perform database capacity planning. Ensure that the system and software architectures properly integrate with the planned database structuring. Determine the appropriate database technology (e.g., relational, extended relational, or object database). Produce the Physical and Logical data models for the databases. Designed the physical structuring and indexing strategies for all objects, including multi-partitioned tables, clustered objects, and a variety of indexes of low and high cardinality.Collaborate with others to determine the impact of database changes on other systems. Specify user authorizations: Which users can access which databases. Which users can access which data in the databases. User access level for that data (e.g., insert, select, update, delete). Perform platform assessment regarding proper support for the selected databases. Design and provide the Data Access Layer: Accessing the databasesStored proceduresDesign and implement any and all backed ETL or data loads needed for the applicationDefine best practice conventions for Data and data related objectsPerformed Development Database Administrator functions as part of job. Security, backup and recovery, data migration, and tuning were included in the regular tasks.Designed and implemented a corporate scorecard reporting environment used by the top executives in the company. This included a new database, new ETL process, and a set of new reports. Used SQL Server 2005 for the DB, Sagent, SSIS and DTS for all ETL and Business Objects and SSRS for all reporting.Designed and implemented a number of other business critical BI projects. Was the sole Architect for new web portal for Customer Loan management.

Provide senior level analysis for overall system integration and functionality for a client base of over 300 companies. Each client has a custom solution of software and hardware, requiring a custom integration of all components. Functioned as a liaison point for the company's Client Support department to the rest of the development shop.Aided in determination of which core systems were in need of enhancement/repair.Provided overall management of the process of seeing that the resources needed were provided and utilized properlyPosition is very technical, despite the managerial framing. Required in-depth technical knowledge of all systems, including the Informix database, the C, VB, and .Net platforms and the OS, Linux.Designed, implemented and provide ongoing support for a suite of tools used for monitoring and repairing client site systems. Designed, implemented and provide ongoing support for a MySQL Database backend for ongoing reporting and monitoring of all client sites. Created a program suite that provides ongoing analysis and prioritized assignment of client site issues to available technicians. Designed, implemented and provide ongoing support for a Web interface for client site status reports and overall health indicators. Co-designed and implemented a trouble ticket system for the company's support department, including a full migration from a text-based client and Informix 2.0 DB to a web-client front end with a MySQL DB.Designed and implemented both logical and physical data models for new trouble ticket systemDesigned and implemented all ETL processes for data migration for the new database.

Responsible for design and support of several large, Oracle 8i, 9i and SQL Server OLTP systems.Oracle systems provided the backbone of the telephony services for the company and required query and index optimization for OLTP performance. Data structures handled all phone system functions for a customer base in excess of 2 million.Designed a new Commission payment system. A smaller relational database with approximately 50 tables. Performed full ETL design and implementation, physical and logical design.Provided development team with all query design and SQL optimization for use in code base. Expanded a Datamart into a full Data Warehouse. Designed the logical and physical data models.Designed physical structuring and indexing strategies for all objects, including multi-partitioned tables, clustered objects, and a variety of indexes of low and high cardinality. All work was based on analysis of available data to the Warehouse and the basic business needs of the different business units.Integrated data from both SQL Server and Oracle, with data from 4 distinct business groups (customer service, marketing, finance, and the OLTP systems)Designed and implemented the ETL strategy using PL/SQL, Oracle Stored Procedures, SQL Server Stored Procedures, DTS, Unix shell scripting and Perl.Design and implemented automation routines for all ETL processes, will full failover and rollback procedures.Systems handled of call detail data with associated aggregations and rollups based on time, business function, etc..Systems had, at times, in excess of 1 billion data rows in some data groups.Designed and implemented a number of OLAP cubes and other aggregations to service the needs of the different business entities.Optimized physical structures and indexes for OLAP use.

Helped design and implement several Decision Support Systems (DSS) and other Data Warehouses, including logical and physical models. Consultec provided Decision Support Systems for State governments to track Medicare and Medicade information.Data warehouses were all large, some holding as much as 600 million transactions with associated detail tables and aggregations.Designed and implemented applications using SQL, PL/SQL(Oracle), T-SQL(Sybase), and COBOL. Solely responsible for the design, management and implementation of a DataMart built off of an extremely large Data Warehouse. Data Warehouse was 5.5 years of transactional data, with approximately 200 tables.Datamart was built to contain large amounts of data being received from a statistical package used to analyze medical transaction patterns. Approximately 50 tables, most providing aggregations of the raw output of the statistical package.