We provide IT Staff Augmentation Services!

Business Intelligence Data Warehouse Resume

4.00 Rating

San Diego, CaliforniA

OBJECTIVE:

  • To secure a challenging position as a Data Warehouse Architect/Senior Business Intelligence Developer providing data analysis, OLAP data modeling, design, coding, testing, conversion, documentation, database development, and implementation of multidimensional databases (cube), ETL(extract, transform, load data) packages, enhancements and maintenance of legacy relational data warehouses, OLAP data warehouses, data marts, and application systems. I have over 18 years of Information Technology experience.

TECHNICAL SKILLS

  • SQL Server 2000/2005/2008 R2/2012/2014
  • SQL Server Integration Services (SSIS) ETL Packages)
  • Teradata
  • MongoDB
  • Informatica PowerCenter Designer
  • Toad Data Modeler
  • SQL Server Analysis Services (SSAS)
  • SQL Server Reporting Services (SSRS)
  • T - SQL
  • MDX Query Language
  • Oracle PL/SQL
  • Visual Basic 6
  • Active Server Pages
  • ASP
  • ADO
  • HTML
  • Dynamic HTML
  • XML
  • .NET Framework
  • Team Foundation Server (TFS)
  • SQL Server Data Tools for Visual Studio (SSDT)
  • MS SharePoint ServerVBScript
  • JavaScript
  • Cascading Style
  • ActiveX
  • ASP Components
  • COM/DCOM
  • MS Internet Explorer
  • Visual Interdev
  • FrontPage 2003
  • SQL Server Management Studio
  • Business Intelligence Development Studio
  • Reporting Services
  • MS Internet Information Server
  • MS Transaction Server
  • Windows 2012
  • Windows NT
  • MS VisioExcel 2013
  • Access 2013
  • Word 2013
  • Power Pivot
  • Tableau

PROFESSIONAL EXPERIENCE

Business Intelligence Data Warehouse

Confidential - San Diego, California

Responsibilities:

  • Gathered and analyzed the business requirements given by the City of Hope cancer research team in order to provide a secure and HIPAA compliant data solution for cancer research analytics.
  • Created the different types of data models required to implement into the data warehouse and data mart using Toad Data Modeler.
  • Developed, implemented, and maintained a data warehouse (relational form) for data processing/massaging of data into staging, and core tables using Informatica Power Center Designer (creating source, target, mappings, mapplets, and transformations).
  • Developed, implemented, and maintained a specific data mart (dimension and fact tables) based on data warehouse data, in order to provide analytics and visualization on cancer research.
  • Attended team meetings to discuss and write a user change requirements, and implemented changes into the data warehouse, data mart, and Tableau reports.
  • Data was composed of participants in the study, cancer registry data on participants, residence addresses, healthcare data from OSHPD, and questionnaire surveys gathered from participants.
  • Provided teaching support for front-end analysis tool (Tableau) for the cancer research team members explaining relationships, aggregations and calculation of data in order to produce the answers needed for decision-making.
  • Applied effective verbal and written communication skills with research scientists, managers, other BI developers, and data warehouse team to resolve data and programming issues. Completed all projects with accuracy and within time constraints.

Business Intelligence Consultant

Confidential

Responsibilities:

  • Analyzed existing database systems for complete understanding of business requirements to create sales metrics for the merchandising team.
  • Developed ETL packages using SQL Server Integration Services (SSIS) to extract, transform and load data from various database systems (Teradata, ParAccel, SQL Server) on a daily and weekly basis into development and production data warehouse (dimension and fact tables). Created bteq windows command scripts, bteq logs, ssis logs, package configuration files, event jobs to automate scheduling of SSIS packages using an ESP Scheduling Tool.
  • Provided support for various business cubes (merchandising sales) using SQL Server Analysis Services (SSAS). Created around 40 calculated measures for analysis of sales using (MDX) query language. Supported ETL packages for processing of cube by partitions based on measure groups, and set up the bteq scripts, bteq logs, ssis logs, configuration files, event jobs to automate scheduling of SSIS packages using an ESP Scheduling Tool.
  • Provided documentation on sale metrics describing the business logic, calculated measures, aggregations, and dimensions.

Confidential, Fort Lauderdale, Florida

Business Intelligence Consultant

Responsibilities:

  • Designed a logical data model and implemented the physical data model for an Operational Data Store (ODS) and build the various data marts composed of sales and marketing data.
  • Developed ETL packages, configuration files, and SSIS Jobs using SQL Server Integration Services (SSIS) for loading historical data on a daily basis into staging and data warehouse (ODS) databases from various data systems (MongoDB, SugarCRM MySQL, SQL Server) in development, quality control and production environments.
  • Developed stored procedures, views, and MySQL for massaging of data, aggregations, and calculations of data, creating measures for various business data marts.
  • Gathered business requirements from users to understand the data, build data models, and reporting needs.

Confidential, Boca Raton, Florida

Business Intelligence Consultant

Responsibilities:

  • Developed ETL packages using SQL Server Integration Services (SSIS) for loading data on a weekly basis into staging and OLAP relational data warehouse databases from various data systems (Teradata, DB2, retail and sales flat files). Data was comprised of customers (retail stores), products, store sales and locations, etc.
  • Developed stored procedures for massaging of data, aggregations, and calculations of data creating measures into percent, profits, ratings, goals, plans, sales dollars formats for displaying the facts on Cognos reports for management team.
  • Converted 2008 (SSIS) packages into 2014 (SSIS) packages using SQL Server Data Tools. Implemented several crucial steps for conversion: corrected errors when loading existing packages, changed any static variables, corrected outdated scripting task code, changed paths to use new paths for flat files and configuration files, run converted 2014 packages to ensure every task ran successfully.
  • Converted 2008 (SSAS) cubes into 2014 (SSAS) cubes using SQL Server Data Tools. Implemented several crucial steps for conversion: 1) Creation of cube - deployed existing cube on 2014 analysis server with process structure, run manual process for dimensions with data, process cube with data, corrected errors on processing cube. 2) SSIS packages for cube processing - corrected errors when loading existing packages, changed any static variables, corrected outdated scripting task code, changed paths to use new paths for configuration files, created new configuration files using current XML, run converted 2014 cube packages to ensure every task ran successfully and changes are correct for incremental and full processing of cube.
  • Tested in development and pushed to production using (ESP) Event scheduling tool to run events calling batch files to execute SSIS packages with specific configuration files.
  • Applied effective verbal and written communication skills with business users, managers, other BI developers, and data warehouse team to resolve data and programming issues. Completed all projects with accuracy and within time constraints.

Business Intelligence Consultant

Confidential - Miami, Florida

Responsibilities:

  • Gathered and analyzed the business requirements given by the commercial operation sales team and finance team in order to understand product data (medical devices) and sales (physicians and hospitals) used for business.
  • Provided production support and enhancements for staging and OLAP relational data warehouse databases using ETL packages using SQL Server Integration Services (SSIS) for data processing from various legacy systems (ERP Navision systems, flat files) into the data warehouse on a daily basis. Data was comprised of customers, products, product categories, territories, and sales people for analysis of actual and forecasted sales.
  • Developed, implemented, and maintained a multidimensional data model (fact and dimension tables) calling stored procedures for data processing/massaging of data into staging tables and data warehouse on a daily basis.
  • Developed, implemented, and maintained various business cubes (sales and finance) using SQL Server Analysis Services (SSAS) database. Created around 50 calculated measures for analysis of sales using (MDX) query language. Set up SQL Job for automation for processing of data into data warehouse and datamart and for processing of cubes on a daily basis. Provided support for front-end analysis tool (Tableau) used by sales and finance team members for creation of reports connecting to the cubes.
  • Assisted and provided technical knowledge to fellow BI team members to improve performance and implementation of data processes and cubes. Provided technical expertise for data modeling and creation of calculated measures for analysis.
  • Applied effective verbal and written communication skills with business users, managers, other BI developers, and data warehouse team to resolve data and programming issues. Completed all projects with accuracy and within time constraints.

Data Warehouse Architect

Confidential - Sunrise, Florida

Responsibilities:

  • Developing and implementing SSIS packages for importing Vendor data files (structured, semi-structured files (txt, xml, dat)) using MS SQL Server 2012/2014 into staging and production tables. SSIS packages include Event Error Handling and auditing of data, calling of incremental load process stored procedures, parsing of data files, and automation. Development of packages using SQL Server Data Tools for VS (SSDT).
  • Deployment of SSIS packages from Team Foundation Server into SSISDB environment.
  • Developing initial stage of OLAP data model for data warehouse (facts and dimensions tables) in SQL Server 2012 using vendor and transactional data from Oracle data warehouse.

Senior Business Intelligence Developer

Confidential - Ft. Lauderdale, Florida

Responsibilities:

  • Provided production support and enhancements for staging and OLAP relational data warehouse databases using ETL SSIS packages, amount of data receiving is in terabytes from outside data distribution collector. Data was comprised of retailers, distributors, products, brands, promos, and shipments for analysis of sales.
  • Developed and implemented multidimensional data model (fact and dimension tables) using SQL Server Integration Package (SSIS) for data processing from various legacy systems (Oracle Lawson and Payment database systems, flat files) into the data warehouse on a daily and bi weekly basis.
  • Provided production support and enhancements for various business cubes using SQL Server Analysis Services (SSAS) database using data from relational data warehouse for finance, business consumer intelligence, and premium group teams. Wrote a sql script to create a flattened balanced sales hierarchy and implement into volume cube.
  • Provided Ad hoc requests for data in different file formats from outside third party vendors, and provided on going analytic dashboard reports in Excel containing the raw detail data, pivot tables on data, charts, KPIs within internal business units. Developed and supported (SSRS) reports using data from data warehouse, passing parameters, calling sub reports, drill down/up, KPIs, and auto scheduling for various departments. Uploaded analytic SSRS reports to SharePoint site for users to analyze performance, and add value to organization.
  • Assisted and provided technical knowledge to fellow BI team members to improve performance of data processes and cubes, and implement automation. Demonstrated examples of how to provide excellent customer service relationships skills for improving our contacts with the business units.
  • Applied effective verbal and written communication skills with business users, managers, other BI developers, and data warehouse team to resolve data and programming issues, and implement changed business rules with various databases and reports in production environments. Completed all projects with accuracy and within time constraints.

We'd love your feedback!