Ntsiba Gassuet, Christian

Database Engineer

Phone:

207-***-****

Email:

acx7uh@r.postjobfree.com

LinkedIn:

linkedin.com/in/christianntsiba

Professional Experience

Skills

-C#, T-SQL, ASP.NET MVC

-Windows Server, SQL Server

-Visual Studio, SQL Server Management Studio

-ETL, SSIS, SSRS, SSAS, etc.

-HTML, PHP, JQuery

-Linux, MySQL, Amazon WEB Services EC2, RDS

-Windows, Word, Excel, Outlook

Languages spoken

-English

-French

Education

VTEC Training, Microsoft Partner. Portland, ME – 2017

-Business Intelligence (BI),

Microsoft Certified Solutions Expert (MCSE)

-SQL Server 2012/2014

Microsoft Certified Solutions Associate (MCSA)

Champlain College. Burlington, VT – 2014

-Network Security and Administration, Bachelors of Science

-Linux System Administration and Security, Certification

CIRAD. Montpellier, France – 2007

-Geometrics Information System and Database Management, Professional Certificate

Boston University (BU)

-Masters of Science – May 2018

Database Management and Business Intelligence

2015 -

cf. annex A

Programmer Analyst, ETL Developer and

SQL Server DBA, Community Health Options

Lewiston, ME

2013 - 2015

cf. annex B

Contract Application and ETL Developer, SQL Server and MySQL DBA, Caleidoscope Communications

Burlington, VT

2010 - 2013 cf. annex C

Advanced SQL Server/MySQL developer,

Emergent Media Center, Champlain College

Burlington, VT

2007 - 2010

Freelance Web and MySQL Database Developer,

Self-Employed

Developed web and database applications for clients

Burlington, VT

2003 - 2007

Geometrics Information System (GIS) technician and DBA, Forestry Economics Ministry.

In charge of geographical data acquisition, analysis and digitization of satellite images, and database administration at the Geomatics department.

Brazzaville, Rep. of Congo

ANNEX A

Programmer Analyst, ETL Developer and SQL Server DBA, Community Health Options

Data Warehouse

-Helped Design, develop and implement a data warehouse for Practioners and Health providers

-Created and deployed ETL solutions with SQL Server SSIS

-Debugged and troubleshot SSIS packages

-Implemented incremental ETL processes

-Deployed and configure SSIS packages

-Enforced data quality using Data Quality Services to find duplicate and cleanse the data

-Produced SRS reports

Qualified Health Plan (QHP)’s Provider Directory and Drug Formulary files

-Developed on an annual basis ASP .NET console applications for processing explanation of benefits (EOB) files transformation into Providers’ network and drug formulary JSON machine readable files according to the Centers for Medicare & Medicaid Service (CMS) of the United States Department of Health & Human Services’ specifications, and for submission to the CMS.

Members Enrollment Management Information System

-Implemented the design and developed the physical structure of the database with SQL Server on SQL Server Management Studio

-Designed and developed the front-end ASP.NET MVC web application with

-Administered the system’s database and its users

-Set up and configured the hosting the IIS 8 web server

Compliance and Regulations Affairs Department’s information management system for appeals, regulatory and non-regulatory complaints, and Privacy/Security incidents investigations

-Led the requirements gathering sessions with the members of the department

-Designed and developed the logical diagram and physical structure of the database with SQL Server on SQL Server Management Studio

-Designed and developed the front-end ASP.NET MVC application with Web APIs

-Set up and configured the hosting Windows server 2012 and the IIS 8 web server

-Administered the system’s database and its users

XML file transform

-Developed a console application that takes and translates XML files to populate related SQL tables

-Provided an executable file to be run with file path arguments, for authorized users

ANNEX B

Contract Application and ETL Developer, SQL Server and MySQL DBA, Caleidoscope Communications

Designed, developed, tested, secured, documented, deployed and administer on Amazon Web Services (AWS) EC2 and RDS infrastructure, an enterprise level CRM database and web application.

Installed, secured and administered the Linux server with MySQL and SQL Server with Windows Server.

Business System Analyst

-Conducted and facilitated requirements gathering session meetings to define detail business requirements as well as user requirements.

-Provided Functional Requirements Definition document for effective project management through requirements traceability to final product delivery.

Software Architect

-Provided a detailed Product Design specification document to guide the architectural definition and the development of the system.

Application Designer

-Provided a CRM System Modular Design: Administrative dashboard, product information management system, customer data management system, and order management system

-Designed Database ER model and diagram

-Planned and defined the system,

-Collected and analyzed requirements, provided an advanced entity relational diagram

-SQL coding implementation, application test prototyping, system recursive testing and operational maintenance.

Application Developer

-Provided an Implementation Plan for detailed listing of activities, costs, expected difficulties, and schedules required to achieve the objectives of the strategic plans.

-Provided unit test modules and delivered test reports and bug reporting sheets

Data Resource Administrator

Database migration: Implement and provide a Data Conversion Plan

System Administrator

-Software: Responsible of ensuring that the uptime, performance, resources, and security of the system to meet the needs of the users by providing technical support during and after the system development and deployment, including running the following test: Ad Hoc testing, performance testing, system testing

-Server: Configured, administered, and optimized the Amazon Web Services EC2 based company Linux and Windows servers, and related components to achieve high performance of the various business applications, and developed processes and procedures for ongoing management of the server environment.

Data Warehousing

-Designed and deployed SSIS ETL solutions

-Debugged and troubleshot SSIS packages

-Implemented incremental ETL processes

-Maintained and Updated SSIS packages

System users training

-Provided end-user training to the system’s users.

ANNEX C

Advanced SQL Server/MySQL developer, Emergent Media Center - Champlain College

Breakaway game analytics project

Designed and developed a query tool application for strategic data analytics for the “Breakaway” game’s database

Makers Lab

-Helped design and develop an application to help sell, register and manage memberships

-Designed and developed the admin CRUD dashboard

-Helped design and develop the underlining databases

Other

-Helped on diverse application/database development projects

Contact this candidate