We provide IT Staff Augmentation Services!

Database And Bi Expert Resume

PROFILE:

  • Sr. IT Consultant with 25+ years of experience using SQL server and 16 years using business intelligence tools (SSRS, SSIS, ETL, SSAS). Performed complex work using: SSRS, ETL (SSIS), SQL server, OLAP cube (SSAS).
  • Expertise includes: Data Modeling, Data Performance, Database/architect, database design and implementation, collecting information directly from the end user, leading the team, planning the project, planning the work, creating reports with SSRS. Fluent in English and French.
  • Designed, tested, implemented, maintained and control centralized databases for leadership.
  • Worked closely with technical management and leadership to design and implement databases and database support tools in support of complex business application development requirements and processes
  • Maintained customer - focused approach with users to provide different solutions.
  • Supported designed and managed upgrades to software that interacts with these databases.
  • ETL maintenance and job monitoring.
  • Integrity and security of data in Data Warehouses and Data Marts.

RELEVANT SKILLS:

Database programming (TSQL, Procedures, Tables, indexes, views, triggers.) + modeling& Analyst & Administration: SQL 25 years

Data warehouse architect using Kimball methodology

Banking and finance: 8 years

Benchmarking and threshold testing of databases

Data modeling and prototyping

Data Lineage Analysis and Data Quality Analysis

Team leader: 7 years

IT Manager: 5 years

Crystal Reports 8 years.

Data structures, Data cleaning and transformation: 18 years

BI tools (SSIS, SSRS, SSAS, SQL DQS, and OLAP): 17 years

Database Architect: 8 years

ASP.net, C#, VB, VB.net, HTML, JavaScript, VBScript, Visual SourceSafe, SharePoint: 10 years

International experiences: 3 years in USA, 1 year in France and 17 years in Canada.

DAX, MDX

Structured Query Language TSQL

Tabular BISM

Complex Data structure

Power BI (Power query, Power View, Power Pivot, Gateway, Hybrid, on - premises and on-cloud configuration )

PROFESSIONAL EXPERIENCE:

Confidential

Database and BI expert

Responsibilities:

  • Creating New data store with tables, views and procedures
  • Data analysis
  • Loading the data with SSIS
  • Creating reports with Power Bi desktop and SSRS

Confidential

Database, Data architect and BI developer/Analyst

Responsibilities:

  • Created a full cycle data warehouse
  • Data modeling
  • Data integration (SSIS)
  • Created Cubes, Reports SSRS and Power BI reports
  • Documentation

Confidential, Boston, MA

Database, Data architect and BI developer, Analyst

Responsibilities:

  • Created new data warehouse by modeling the current database.
  • Created SSIS packages
  • Created SSRS Reports
  • Created Reports with Power BI Desktop
  • Added calculation with DAX/MDX

Technological Environment: SQL 2014, SQL 2008, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, DAX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, Power-Pivot, Pivot table, Microsoft SharePoint, Power BI, Gateway connection, DAX, Tabular BISM, Power Bi Desktop

Confidential, Augusta, Maine

Database, Data architect and BI developer, Analyst

Responsibilities:

  • Created new data warehouse by modeling the current database.
  • Fixed and create SSIS reports
  • Created SSIS packages.
  • Updated and modified the current SSAS cube
  • Added calculation with DAX/MDX
  • Created Power BI dashboard (using power BI desktop)
  • Optimized the database

Technological Environment: SQL 2014, SQL 2012, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, DAX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, Power-Pivot, Pivot table, Microsoft SharePoint, Power BI, DAX, Tabular BISM, Power Bi Desktop

Confidential, St. Louis, IL

Database and BI developer

Responsibilities:

  • Created more than 245 SSIS reports
  • Created more than 55 SSIS packages
  • Created DataMart and cube
  • Added calculation with DAX/MDX
  • Created Power BI dashboard reports

Confidential, NY

Database & BI Developer, Analyst, architect (SSIS, SSRS, SSAS)

Responsibilities:

  • Participated to help balance the data. Helped users finding the problem with non-balance accounts.
  • Monitoring the database to improve the performance
  • Created new cubes for the company Portfolio with SSAS
  • Updated the current cube with new measurements and dimension
  • Added new DAX/MDX calculation to the cube
  • Created SSIS packages to import data from live databases and other sources like flat files, excel to the data mart.
  • Used the incremental load, to load the new and the updated rows.
  • Configuration of the packages to use external parameters like the server name the data base name the folder name
  • Added logging to the packages to log the errors, so it will be easier to fix the problem when it happens.
  • The final step, I have scheduled the packages on daily basis.
  • Trial Balance report
  • Port report
  • Collateral transaction
  • Transaction amendment
  • Transaction Report
  • Treasury transaction
  • Accounting impact on position
  • Accounting impact on transaction
  • Physical and reconciliation to Economic

Technological Environment: SQL 2012 enterprise, SQL 2008 Enterprise, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, DAX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, Power-Pivot, Pivot table, Microsoft SharePoint, Power BIDAX, Tabular BISM, Power Bi Desktop

Confidential

Database & BI Developer and architect (SSIS, SSRS, SSAS)

Responsibilities:

  • Created more than 10 packages with SSIS to load the data from different sources to the SQL server. Sources like: Flat files CSV, Text, XML, or from different servers like: SQL server.
  • Created reports with SSRS using data sources: SQL server and cubes.
  • Improved the database performance using different mereologies.
  • Designed new DataMart
  • Created new cube and added calculation with DAX/MDX

Technological Environment: SQL 2012 enterprise edition, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, DAX, Tabular BISM, Microsoft SharePoint, Power BI.

Confidential

Database & BI Developer and architect (SSIS, SSRS, SSAS)

Responsibilities:

  • create packages with SSIS fix the performance problems update the current cube with new request
  • Advised on the best strategy to create cubes;
  • Advised and helped on monitoring and fixing the data performance;
  • Helped finding solution for some complex problems.
  • Added new functions to the cube with MDX
  • Added new dimension (Linked, Role playing, Junk, Conformed, SCD) and facts tables
  • Added new measurement (Full additive, semi additive)
  • Created new packages to feed the DataMart.

Technological Environment: SQL 2012 Enterprise edition, SSIS, SSRS, SSAS, OLAP, ROLAP, Power BI, MOLAP, Transact/SQL, MDX, TSF, Kimball methodology, Microsoft Access, Microsoft SharePoint.

Confidential

Database & BI Developer and architect (SSIS, SSRS, SSAS)

Responsibilities:

  • Create list of reports required by the users
  • Create new packages to load the data into the datamart
  • Update the current cube with new requests.
  • Created a list of reports with SSRS, about 150 reports
  • Created 15 packages to load the new data from sources like XML, CSV and Excel to the data art
  • Updated the currents cubes with new requests
  • Created new cube for the portfolio of the company

Technological Environment: SQL 2012 Enterprise, SQL 2008 enterprise, SQL 2005, SQL 2000, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, Erwin, Cube OLAP SQL, MDX, XSLT, Team Foundation Server (TSF), Microsoft Access, DAX, Tabular BISM, Microsoft SharePoint

Confidential

Team lead, Database & BI Developer and architect (SSIS, SSRS, SSAS)

Responsibilities:

  • Created 55 SSIS Packages;
  • Created 50 Reports with SSRS;
  • Cubes 2 cubes with SSAS;
  • Created 2 Data mart

Technological Environment: SQL 2008 Enterprise edition, SQL 2005, SQL 2000, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, Erwin, Cube OLAP SQL, MDX, XSLT, Microsoft SharePoint, Microsoft Access, Microsoft SharePoint

Confidential

Database & BI Developer and architect (SSIS, SSRS, SSAS)

Responsibilities:

  • Created 22 SSIS Packages;
  • Created 44 Reports with SSRS;
  • Created 2 Cubes with SSAS;

Technological Environment: SQL 2008 Enterprise, SQL 2005, SQL 2000, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, Erwin, Cube OLAP SQL, MDX, XSLT, Team Foundation Server, Microsoft Access, Microsoft SharePoint

Confidential

Database & BI Developer and architect (SQL 2005 & 2008) Team Lead

Responsibilities:

  • Created 145 packages using SSIS
  • Created 4 data Mart in SQL server
  • Created 85 reports using SSRS

Technological Environment: SQL server 2005/2008/2000 Enterprise, Analysis services (SSAS), Cube, MDX, Reporting services (SSRS), Pivot table, Integration services (SSIS), Microsoft SharePoint

Confidential

Database & BI Developer and architect (SQL 2005 & 2008)

Responsibilities:

  • Fixing the performance problem of the database server;
  • Architect and development of more than 105 SSIS packages; designing and development of 75 reports with reporting services; designing and development of 5 Cubes with services;
  • Database design, Creation of tables, triggers, function, views, stored procedures;
  • Data analyst & Data models;
  • Designing and developing data conversion processes and scripts;
  • Designing and developing data warehouse specific data conversion processes and scripts;
  • Experience extracting, transforming and loading data with MS SQL Server 2005, 2008, 2008A, SQL Server Integration Services (SSIS);
  • Scheduling stored procedures and packages;

Technological Environment: SQL server 2008/2005/2000 Enterprise, Analysis services (SSAS), Cube, MDX, Reporting services (SSRS), Pivot table, Integration services (SSIS), TSQL, Microsoft SharePoint

Hire Now