We provide IT Staff Augmentation Services!

Business Intelligence Manager Resume

Cambridge, MA

SUMMARY:

Over 25 years in IT, specializing in business intelligence, ETL, database and data warehousing modeling and design, reporting solutions and web applications. Skills include warehouse and database design, dimensional and OLTP modeling, data mapping, data feed design and implementation, warehouse processing, interfacing with reporting systems, and customer - facing communication. Database platforms include Microsoft SQL Server (> 15 years), Oracle (7 years), Informix and Microsoft Access. Dozens of successful projects involving soup-to-nuts system implementations.

TECHNICAL SKILLS:

  • MS-DOS and UNIX
  • Informix and SQLBase
  • C, Fortran and VB.NET

PROFESSIONAL EXPERIENCE:

Confidential, Cambridge, MA

Business Intelligence Manager

Responsibilities:

  • Chief architect and designer of business intelligence solution for Confidential . Design and development of new warehouse system to enhance reporting throughout a rapidly expanding global organization. Responsible for 3 direct reports in Africa and India, along with global communication with business stakeholders.
  • Strong 2012/2014 T-SQL design and development, warehouse architecture, SSIS, performance tuning.

Key technologies: SQL Server 2012/2014, T-SQL, ETL, SSRS

Confidential, Boston, MA

Senior Data Engineer

Responsibilities:

  • Design and development of warehouses, design of ETL processes and implementation of data feeds to build and populate analytical warehouses for mostly retail clients. Devised and tested enhancements to improve analytics and warehouse performance.
  • Strong 2008/2012 T-SQL design and development, SSIS, and performance tuning.

Key technologies: SQL Server 2008/2012, T-SQL, ETL.

Confidential, Boston, MA

Senior Data Architect

Responsibilities:

  • Design and modeling of warehouses, design of ETL processes and re-design of data feeds to improve data processing for medical billing and finance.operations. Devised and tested schema changes to improve analytics and warehouse performance.
  • Strong 2005/2008 T-SQL design and development, SSIS, Datastage and Cognos.

Key technologies: SQL Server 2005/2008, T-SQL, ETL.

Confidential

Application Architect, Sr. Principal Systems Engineer

Responsibilities:

  • Designed and modeled warehouses, modified ETL processes and re-designed data feeds to improve data quality and timeliness for effort supporting Confidential flight safety databases. Took novel approaches to speed up processing and loading. Devised and tested schema changes to improve analytics and warehouse performance.
  • Strong T-SQL 20design and development, along with SSIS and data modeling. Development, coding, and testing of complete solution.

Key technologies: SQL Server 2005/2008, T-SQL, ETL, SSRS

Confidential, Waltham, MA

Data Warehouse/ETL Engineer

Responsibilities:

  • Developed ETL solutions for generation of large analytical data warehouses supporting the pharmaceutical industry. Took customer requests through to complete implementation of features in very short time frames. Analyzed, coded, tested and validated fact tables for analytical end-users.
  • Strong T-SQL design and development, along with SSIS and data analysis. Development, coding, and testing, and tuning of complete solution.

Key technologies: SQL Server 2005, T-SQL, ETL.

Confidential, Newton, MA

Data Warehouse Architect//ETL Designer

Responsibilities:

  • Designed performance and reporting warehouse by modeling from scratch on SQL Server 2005 platform, including dimensional modeling, initial ETL for loads, proof-of-concept, and stored procedures for key reporting functions. Project includes performance tuning and optimization using SQL Server 2005 tools.
  • Strong T-SQL design and development, along with modeling, SSIS and Reporting Services. Design, development, coding, and testing of complete solution.

Key technologies: SQL Server 2005, T-SQL, ETL, Reporting Services.

Confidential, Cambridge, MA

Database Designer/Developer /ETL

Responsibilities:

  • Developed ETL system for Oracle/SQL server integration project to distribute identity management data to servers throughout the Confidential . Designed databases and devised novel methods to improve performance. Project involved use of Embarcadero DT Studio ETL tools.
  • Strong T-SQL design and development, along with PL/SQL. DT Studio to support fast-paced development environment. Designed, developed, coded, deployed, and tested complete solution on a soup-to-nuts basis.

Key technologies: SQL Server, Oracle 10g, T-SQL, ETL, DT Studio.

Confidential, Winchester, MA

Database Designer/Developer

Responsibilities:

  • Spearheaded schema design efforts and other design changes to improve performance of web-based, SQL Server HR system deployed for 500 client databases. Diagnosed key performance issues, proposed solutions, and implemented schema fixes to keep performance within SLA requirements. Carried out full analysis of database schema and proposed changes for upcoming releases to address both performance and functionality.
  • Strong T-SQL design and development, including DBA functions to support fast-paced development environment. Data conversion to support version and schema upgrades for production. Web development in ColdFusion.

Key technologies: SQL Server 2000/2005, T-SQL, ETL, ColdFusion

Confidential, Boston, MA

Database Developer/DBA

Responsibilities:

  • Development of new reporting warehouse on MS SQL Server 2000 platform. Integration of multiple data sources (including Oracle) using ETL. Full analysis and design of reporting, including MS Reporting Services.
  • Production support of 10GB SQL Server CRM application, including backup/restore, troubleshooting and security, along with application upgrades of database back end and Visual Basic front end.
  • Key technologies: SQL Server, Oracle, Visual Basic, ETL, MS Access.

Confidential, Waltham, MA

Datamart Developer/Health Claims/ETL

Responsibilities:

  • Developed datamart of medical claims data on SQL Server platform for analysis by health economists. Project included server selection, database modeling, design and implementation, data conversion, ETL, performance tuning, and integration with statistical package.
  • Saved client tens of thousands of dollars in reduced analysis time by re-engineering their data collection and analysis systems.

Key technologies: SQL Server, ETL, DTS, Visual Basic, MS Access, Data Junction, data conversion.

Confidential, Brighton, MA

Data Warehouse/ETL Developer

Responsibilities:

  • Developed novel routines to load and transform data derived from mainframe, midrange, and PC server sources to create data cubes for detailed analysis of clinical and financial performance by hospitals and health care providers.
  • Redesigned existing data loading and transformation processes for maximum automation and performance, taking hours off the existing process and providing smoother operation and maintainability.
  • Key technologies: SQL Server 2000, Visual Basic 6, DTS, Active X.

Confidential, Cambridge, MA

Database Developer/Pharma Labs

Responsibilities:

  • Developed multi-platform Reagent Management System to collect and analyze data on reagent use in biotech research laboratories using bar code technology. System runs on SQL Server back end, Access 2000 clients, and Windows CE data collection devices with seamless data synchronization between platforms.
  • Acted as project lead to specify and order hardware, set up development platforms, configure hardware, write, debug, and test code, and plan final deployment.

Key technologies: SQL Server 2000, Visual Basic 6, MS Access 2000, Windows CE, Embedded Visual Basic, bar code scanning.

Confidential, Andover, MA

Database Developer/DBA/ETL Specialist

Responsibilities:

  • Migrated infrastructure and databases from SQL 7.0 to SQL 2000 platform for global 7x24 mission-critical system.
  • Integrated external systems based on Informix and Oracle databases to SQL 2000 systems to provide a single seamless database system for both operations and billing.

Key technologies: SQL Server 2000, Visual Basic 6, MS Access 2000, Informix, Oracle 8.

Hire Now