Sql Server DBA, Database Engineer
Resume:
Ntsiba Gassuet, Christian
Database Engineer
Phone:
Email:
*********.******@*****.***
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