OBJECTIVE:

Detail-oriented, organized and efficient SQL Developer/Data Analyst seeking a position to utilize my knowledge and experience in SQL/SSIS/SSAS/SSRS/Tableau/Power BI/Python/and Microsoft applications in a position offering opportunities for personal contribution and professional growth.

PROFESSIONAL SUMMARY:

Over 10+ years of IT Professional experience in Software Development, Client Analysis, Data Analysis, Database Design, and Reporting using SQL Server 2012-2014/2008R2/2008/2005/2000, MS-Access, MS-Excel, VB/VBA and MS-Visio.

About 5 years of experience in Business Intelligence Development (SSIS/SSRS/SSAS), and less than 3 years for following data science applications: Tableau, Power BI, Python.

Hands on experience in all aspects of Software Development Life Cycle (SDLC), and Agile environment.

Experience in MS SQL Server 2015/2013/2010/2008 Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).

Extensive experience in the use of T-SQL for developing complex stored procedures, triggers, tables, user-defined functions, relational database models and data integrity, SQL joins and query writing.

Experience in managing alerts, operators and jobs through SQL Server Agent.

Experience in Normalization and De-normalization.

Experience in designing high level ETL architecture for overall data transfer from the OLTP-Online Transaction Processing to OLAP with the help of SSIS and SSAS.

Excellent experience in migration of data from Excel, Flat file, CSV, Text, Oracle, Access, XML, DB2, SQL to Microsoft SQL Server using SSIS.

Experience in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL server.

Experience in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Experienced in handling Slowly Changing Dimensions while loading data into data warehouse.

Experience in Building cubes using SSAS.

Experience in Performance Tuning SSIS packages by using Row Transformations, Block and Unblock Transformations.

Strong experience in designing and developing large number of reports using SSRS, Excel macros, and MS-Access.

Extensive experience in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS), and Tableau.

Extensive experience in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache.

Experience in handling Database Consistency Checks using DBCC Utilities, and in using Distributed Queries using Linked Servers.

Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, and Database Engine Tuning Advisor.

Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements.

Strong Object Oriented Analysis, design and programming technical skills, ability to learn new emerging technologies and adapt quickly.

Experience in software coding using VB, C#, VBA.

Proficient in Java, C++, HTM5, CSS3, ASP.NET, JQuery, Python, Oracle, Tableau, PowerBI, and A+.

Excellent interpersonal skills and communication skills.

Leadership and supervising experience.

Bilingual: English and French.

EDUCATION/ CERTIFICAT

In progress: Bachelor in Software Engineering: UTA, Arlington, Texas.

Associate of Arts: TCC, Hurst, Texas.

Associate of Applied Science in IT Application and Web development: TCC, Hurst, Texas.

Under-graduate in Information System Analyst: ETES, Kinshasa, Dem. Rep. of Congo.

Associate in Computer Programming: ACADEMIA, Kinshasa, Dem. Rep. Of Congo.

Microsoft® Certified Solution Associate in SQL Server® 2014/2012, USA.

BI/EDW certified developer: Colaberry School of Data Analytics Boot-camp, Irving, Texas.

SUMMARY OF TECHNICAL SKILLS

Databases

SQL Server 2012-2014/2008/2008R2, MySql, MS-Access, MS-Excel

Programming Languages

T-SQL, SQL, C#, C++, VB, PYTHON, XHTML, HTML5, CSS3, ASP.NET, PHP, Java Script, JQuery

Operating Systems

Windows 98/2000/2003/XP/NT/Vista, Windows 2000Advanced Server, Windows 2003 Enterprise Server, LINUX

BI Tools

SQL Server BI Development Studio (BIDS), Tableau, Power BI, SharePoint, MS Visual Studio 2013/2010/2008/2005

ETL Tools

SSIS, DTS

Data modeling Tools

MS Visio 2003/2007/2013

WORK EXPERIENCE

XPO Supply Chain, Fort Worth, TX October 2015 – September 2017

IT System/ Operations Supervisor/ Logistics Specialist

XPO Supply Chain, formerly MENLO, is an Amazon non-asset-based third-party logistics (3PL) provider. My essential duties and responsibilities were to:

-Participate in business analysis activities to gather reporting and dashboard requirements; Design, code, test, and maintain customized reports in Windows SharePoint using SSRS.

-Monitor and maintain the computer systems and networks of the site. Install and Configure computer systems; Diagnose hardware and software issues and solve technical and applications problems, either over the phone or in person.

-Advise and assist users for issues regarding the Warehouse Management System (WMS).

-Assist department manager by identifying work procedures in a priority manner and expedite workflow. Responsible for the day-to-day operations of the Inbound, Liquidation, and Vendor Return departments; Coordinate and lead activities of workers responsible for the receiving, counting, processing, inspecting, replenishing, and locating merchandise in the warehouse. Responsibilities include staffing, training, safety, scheduling, equipment maintenance and loss prevention.

GENCO (FedEx Company), Fort Worth, TX February 2003 – October 2015

Slotting Coordinator/ Reporting Specialist

FedEx Supply Chain, formerly GENCO, is a non-asset-based third-party logistics (3PL) provider. My essential duties and responsibilities were to:

-Integrate necessary data from WMS and other sources to a standalone database.

-Create and manage database to allow data analysis in order to sustain process improvement, and stock slotting policy.

-Lead Replenishment team which manages the put-away and down-stock processes, and support operational departments.

-Produce reports for internal and external requests.

-Participate in special management meeting related to slotting.

-Train and support users.

-Perform other duties as required.

ONATRA, Kinshasa, Dem. Rep. of Congo October 1987 – July 2002

IT Analyst-Programmer

The ‘Office National des Transports’ (ONATRA), presently SCTP, (National Transport Agency) is a publicly owned company, based in Kinshasa which operates railways, ports and river transport in the north and west of the Democratic Republic of Congo. ONATRA is a transportation company with 10,000+ employees. My essential duties and responsibilities were to:

-Work closely with the Project Manager in areas such as requirements definitions, functional specifications, documentation, and other necessary documents to ensure both customer and company expectations are met or exceeded, using a specific SDLC process called ‘MERISE’.

-Analyze user needs and software requirements to determine feasibility of systems or project implementation within time and cost constraints.

-Participate in project meetings as determined necessary by the Project Manager.

-Create and maintain database objects.

-Implement new systems or Modify existing ones as per the project requirements.

-Develop and maintain software using VB and other legacy languages such as Dbase, and Clipper.

-Create reports using Microsoft applications such as Access, Excel, and Word.

-Train and support users.

-Perform other duties as required.

Contact this candidate