Sql Server Power Bi

Jean Bosco Hagenimana

PROFESSIONAL SUMMARY:

Over 10 years of Information Technology experience in developing business intelligence artifacts over multiple database platforms (SQL server, Oracle, PostgreSQL, Greenplum, MySQL and DB2).

12 years of experience in programming with T-SQL, MDX and query language

Designing and Building OLTP and OLAP or multidimensional (cubes) schema

Designing and building Enterprise Data Warehouse System and corresponding marts based on star or snowflake models

5 years of experience in development, and maintenance of ETL processes using SSIS tool.

Building and deployment of OLAP Cubes with SSAS tool

Debugging and troubleshooting based on the root cause analysis of the problem

Database monitoring and performance tuning

Extensively knowledgeable and experienced in developing Data Visualization dashboards with Tableau and Power BI tools

Developing various types of complex reports using cascade parameters, drill down and drill through reports, matrix reports, sub reports, parameterized reports, ad hoc and charts using Power BI and Tableau tools.

Deployment and maintenance of SSRS reports to the report server or SharePoint.

Building analytical, CRM data driven solutions with Tableau

Developing with Windows command scripting and Unix Shell scripting

Building actuarial predictive models with statistical data analysis education and US Bureau of Census work experience

Business analysis skills to understand business needs and to design appropriate solutions.

Gathering requirements from business users and building business requirement documents (BRD) and technical data map- ping data documents.

A well-organized, goal-oriented, highly motivated team player with excellent analytical, troubleshooting skill.

Quicky learning of new IT technology such as Spark, data lake, NOSQL and Neo4J. TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SSIS, SSRS, SSAS, SQL Server, SQL profiler Databases: SQL Server 2008 R2, 2012, 2014 and 2016, PostgreSQL, Greenplum, Oracle, DB2, Neo4J Data Visualization: Tableau. Power BI

Statistical software tools: SPSS Statistics, SAS 9.1, R Studio Healthcare management system: Care2X software package Programming Languages: Python, Java, Java Script, HTML, DAX, T-SQL, MDX, C# and VB.Net Operating Systems: Windows, Unix, Linux

Microsoft Tools: MS Visio, SharePoint 2016, Microsoft Office 2016 Version control tool: TFS, Git

Process Workflow and ticketing management tools: Jira, Trello and ServiceNow. Job Scheduling tool: Cronjob, Crontab and CA scheduler Development tool: Visual Studio, SQL Developer

Data modeling tool: Erwin

PROFESSIONAL EXPERIENCE

AAFES (Army Air Force Exchange Services)

Dallas, TX May 2018 – Present

Business Intelligence Developer

I have worked on Human Capital Analytics, B2B eCommerce, CRM Customer Hub, and Marketing Automation projects. Human Capital Analytics (HCA) is a full-scale analytics solution built for HR Directorate and has three parts: dimensional schema data warehouse, a web dashboard, and analytics reports. Users can drill down from executive, exchange, facility, and associate level. B2B eCommerce consists in a web store, web API and SOA integration for handling orders, invoices, ship notices and returns, and Power BI report for tracing daily operations on orders fulfilment and invoices processing. CRM Customer Hub is a customer graphic database for analytics platform. Marketing Automation project is to identify targeted cus- tomers from their purchasing histories, patterns and intendency and to build marketing strategies and market segmentation. Responsibilities:

Developing and maintaining HCA reports and dashboards

Developing and supporting Power BI reports for B2B eCommerce

Migrated and upgraded CRM ETL packages from SSIS 2008 to 2016.

Developing SSIS for data feed from or to Acoustic, P&G pilot program, Google Merchant Center, and HAVAS partners

Monitoring and supporting CRM ETL process at daily basis.

Converting Oracle BI report into Power BI for Oracle advanced procurement system.

Updating the knowledge base documentation for CRM ETL SSIS packages in Confluence. All States Insurance February 2018-May 2018

Chicago, IL

Tableau Report Developer

Responsibilities:

Developed an analytical application (DRIVEWISE) for the Auto Insurance line

Pulled data from 2012 SQL server databases by using stored procedures.

Developed ad-hoc and permanent reports and dashboards with Tableau. AETNA November 2017-January 2018

Chicago, IL

Tableau Report Developer

Responsibilities:

Developed stored procedures with T-SQL.

Pulled data from SQL server databases by using stored procedures.

Developer ad-hoc and permanent reports and dashboards with Tableau 10.4 Wells Fargo Mortgage

Irving, TX February 2017- July 2017

Data Analyst/Report Developer

Responsibilities:

Analyzed SAS Macro scripts and SAS generated Excel Reports used by Litigation department and created technical documentation for an offshore Team of developers.

Created Business Requirements (BRD) for Operational and Executive summary reports created in SAS.

Created Mapping Documents and testing the SSRS reports created by the Offshore team of developers.

Created Ad Hoc and Parameterized reports using SSRS.

Created various ad-hoc SQL queries for customer reports and executive management reports based on PROC SQL extracted from SAS macros.

Created SSIS packages for populating the data mart for litigation and home equity reports. AAFES (Army Air Force Exchange Services)

Dallas, TX November 2015 – December 2016

SQL Developer

Human Capital Analytics (HCA) is a full-scale analytics solution built for HR Directorate and has three parts: dimensional schema data warehouse, a web dashboard, and analytics reports. Users can drill down from executive, exchange, facility, and associate level. Responsibilities:

Developed Complex, multi values, cascading, parametrized 25 reports for HCA Project using SSRS.

Created complex Queries using PL/PGSQL language to optimize reports and improve the performance.

Created a special program to allow displaying a report with sensitive, protected data, based on the SPOCODE and the user profile.

Designed, developed, and optimized the HR Metrics dashboard.

Elaborated technical documentation for each developed, in the Harvest source control environment. INNOVAR Solutions September 2015 - October 2015

McKinney, TX

SQL BI Developer

Responsibilities:

Developed Stored Procedures, CTES, Temporary tables Using T-SQL

Developed ETL solution using DEVART SSIS Data Flow Components to extract data from Mongo DB, two SQL databases (SQL server and Oracle), one Salesforce CRM to build a Data mart needed for the developed reports.

Created optimized Queries on Oracle database, using PL/SQL scripting language.

Developed the prototype of reports (RDL files) by using SSRS.

Proposed a solution to embed all reports into a web application by using ASP.NET integration capability. CROSSMARK June 2015 - August 2015

Frisco, Texas

SQL BI Developer

Responsibilities:

Gathered business requirements from the Client.

Created Functional requirement document for the reports.

Developed Stored Procedures, CTES, Temporary tables Using T-SQL

Tuned the Stored procedure to respond to the performance requirements for SQL Server parallel data warehouse, PDW platform environment as required by the client.

Used Nexus Chameleon Interface and Visual studio 2013.

Pulled data from a 15 terabytes Netezza database and Salesforce CRM and created a data mart.

Developed the requested reports with SSRS tool and deployed them to production.

Created a Power BI Dashboard and Reports for the Bike Factory client. Express Analytics Consulting, LLC

Dallas, Texas February 2015 – May 2015

Database Analyst/BI Developer

Responsibilities:

Designed database objects including tables, views, stored procedures for hospital database.

Developed Stored Procedures, tables, functions, and views in T-S.QL.

Used SSIS, T-SQL, SSAS to build data warehouses and multidimensional database (Cubes).

Created SSIS packages following ETL good practices to clean, transform, and load data from different sources including XML. Access, Excel, CSV, and flat files for a mortgage broker company.

Developed business reports with SSRS tool.

AutoNation SSC

Irving, Texas March 2012 – January 2015

Database Analyst/BI Developer

Responsibilities:

Developed Stored Procedures, tables, functions, and views using T-SQL.

Created SSIS packages following ETL good practices to clean, transform, and load data from different sources including Access, Excel, CSV, and text files.

Developed business reports using SQL Server Reporting Services (SSRS) and Tableau.

Implemented security to restrict the access to users and to allow them to view reports based on their profiles.

Monitored database performance, disk space usage, scheduled jobs, and log errors.

Provided 24/7 database support and participated in solving problems raised on different tickets.

Performed database optimization using indexes, query plans, and query hints.

Extensively worked on developing OLAP cubes using SSAS.

Created Ad Hoc reports using power BI and Tableau.

Created Report parameters included cascading parameters, single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).

Created various ad-hoc SQL queries for operational reports, executive management reports in different types such as matrix, drill-through, drill-down, crosstab, sub reports etc.

Created analytical reports and visualizations with Tableau for exploratory analysis as requested by the sales department manager.

NOVIDIA Analytics

Plano, Texas September 2009 – February 2012

Database Analyst/BI Developer

Responsibilities:

Documented and delivered functional specification document to the project team. Assisted the Project Manager/Data Architect to develop both high-level and detailed application architecture to meet user requests and business needs.

Worked extensively in developing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, and user- defined functions.

Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries.

Designed and implemented Stored Procedures for automating tasks.

Development and testing of the ETL processes to get data from various source systems feeds using SSIS.

Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.

Transferred data from various OLTP data sources from Excel files, Flat files, and CSV files into SQL Server 2008.

Scheduled the jobs to streamline and automate cumbersome repeated tasks using SSIS.

Used SSRS to create operational reports, customized Reports, on-demand reports, and ad-hoc reports.

configured selected reports to run and be delivered on schedule. Saint Joseph Medical Hospital

Mishawaka, Indiana

Data Programmer /Analyst May 2005 - July 2009

Responsibilities:

Transferred data from various OLTP data sources, such as MS Excel files, Flat files, and CSV files into SQL Server 2005.

Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML) and loaded the data into target SQL database.

Coordinating with the third-party service provider for timely repair of the system under the maintenance contract and repairing minor flaws in hardware if not covered by the contract. EDUCATION

COLABERRY School of Data Analytics – 2014

SQL Server 2012 – SSIS, SSAS, SSRS

Ball State University, Muncie, Indiana- 2009

Master of Arts in Actuarial Science

Bethel College, South Bend, Indiana – 2005

Bachelor of Science in Organization Management

INFORMATIX MULTIHEXA, Montreal, Canada, 1993

PC hardware Maintenance Training

US Bureau of Census (International Statistical Programming Center), Washington DC, USA – 1991

Census Data Processing training, ISPC-1991

Kigali Institute of Applied Statistics – 1989

Bachelor of Science in Applied Statistics

REFERENCES: Available upon request

Contact this candidate