Martin Innocent Mandengu

**** ******* ***** **

Bedford, TX 76021

972-***-****

ac6t0r@r.postjobfree.com

http://www.linkedin.com/pub/martin-mandengu/37/6b1/387 PROFESSIONAL SUMMARY

• Seasoned energetic Business Intelligence Developer/VB.Net Developer with over 7 years' experience of planning, designing, development, testing, implementation and support in the business intelligence environment

• Good knowledge of MS SSIS, SSRS, SSMS, SSAS, ASP.NET, WCF, T-SQL, SQL Server 2008, SQL Server 2012, MS Office (Excel, Word, PowerPoint, Access, Publisher), MySQL, JavaScript and Java

• Great communication skills obtained from positions that dealt directly with customers and other team members

• Professional, flexible, creative, self driven, analytical thinker with the ability to prepare ad hoc solutions using Business Intelligence tools.

• Experience in creating Indexes, Views, complex Triggers, effective Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.

• Good Experience creating SSIS packages to integrate data into different systems.

• Great Experience creating interactive reports using SSRS.

• Worked in both Agile and Waterfall methodology environments.

• Good experience writing complex SQL scripts in the SSMS environment.

• Worked with data extraction using SSIS and Data Warehouse staging, and loading.

• Proficient in using global variables, expressions, functions and sub reports in Reporting Services

(SSRS) 2008/2012/2014.

• Generate and compile simple ad hoc reports and data extraction including multiple tables and ODBC.

• Experienced in creating SQL Server Reports, handling sub-reports and writing queries to perform drill down, drill-through operations in SSRS 2008R2/2012. EDUCATION

MBA – Strategic Management (2019)

University of North Texas

Bachelor of Science

Business Computer Information Systems - 2011

University of North Texas

GPA – 3.54

TECHNICAL SKILLS

Languages T-SQL, VB Script, C#, Java, Bootstrap, HTML, MySQL, .Net Databases SQL 2005, 2008, 2012, 2016, MySQL, Oracle Analysis Tools SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS). ETL Tools SSIS, DTS

Data Modeling

Tools

Visio

EXPERIENCE

Baylor Scott and White

Business Intelligence Consultant (Contractor) 07/17 - Present

• Gather requirements from end users

• Prepare dashboards for physicians (SSRS)

• Tune report queries (SSMS)

• Investigate and look for new opportunities using analytic skills

• Document and report work to project managers

FirstCare Health Plans (Contractor)

Business Intelligence Consultant (Contractor) 10/16-07/17

• Created ad hoc reports (SSRS, SQL, BI Power, Excel)

• Requirement gathering from requestors to make sure that the reports created meet all the requirements

• Involved in quality assurance testing of the reports and troubleshooting issues that will be causing the report not to meet the requirements

• Documentation of the queries I write for future reference National Financial Partners - Austin, TX

Business Intelligence Consultant (Contractor) 11/15-10/16

• Create ad hoc reports (SSRS)

• Created integration solutions to consolidate data from different vendors for analytical purposes

(SSIS, SSRS, SSAS)

• Performance tuning of SSIS packages and reports

• Provide deep analysis of market trends by writing complex SQL scripts, Stored procedures, Functions in SSMS and presenting the data in reports

• Participated in requirement gathering and documentation of the teams project

• Was the scrum master in the projects I was a lead developer. (Agile)

• Designed ETL packages to be used for ad hoc reports

• Designed Stored Procedures, Function and cubes to pre-process large data sets with an aim to improve performance

• Troubleshoot incidents where packages would fail and provide documentation of what the issue was and the steps taken to solve the problem

• Prepared test cases for QA to use to test tasks completed Qv21 Technologies - Austin, TX (Contractor)

Business Intelligence Developer 05/14-11/15

• Gather report requirements, design, develop and maintain reports.

• Gather integration requirements, design, develop and maintain SSIS packages

• Designed and built the company's first Data Warehouse. (SSMS, SSAS, SSIS)

• Provided all phases of development of a Report Testing Project. Interfaced with internal groups to gather specifications and improve the reports efficiency and effectiveness for customers. Reports developed in SSRS.

• Scrum master to help spearhead projects going on.

• Developed the integration part of the reports into the software using ASP.NET, WCF, VB.NET

• Data modeling using SSMS and Visio

Hanger, Inc. - Austin, TX

Business Intelligence Developer 02/13-05/14

• Design and building ETL Packages for the new Data Warehouse (2014).

• Gather requirements and build pull statements for ETL packages using T-SQL

• Design Fact tables and Dimension tables to fit the repository needed for reporting.(SSIS, SSMS)

• Provided all phases of development of a Report Testing Project. Interfaced with internal groups to gather specifications and improve the reports efficiency and effectiveness for customers. Reports developed in SSRS.

• Developed the integration part of the reports into the software using ASP.NET, WCF, VB.NET

• Data modeling using SSMS and Visio

• Rotated being Scrum Master for the Business Intelligence team AutoStar Solutions - Fort Worth, TX

Bus. Intelligence Analyst 05/11 – 01/13

• Building and deploying reports with drill downs from different data sources using SSRS.

• Designing and creating stored procedures to help answer business questions.

• Manual check of Database backup to make sure that the scheduled runs ran properly.

• Conversion of the legacy code into SQL using SSMS.

• Provided all phases of development of a Report Testing Project. Interfaced with internal groups to gather specifications and improve the reports efficiency and effectiveness for customers. Reports developed in SSRS.

• Developed the integration part of the reports into the software using ASP.NET, WCF, VB.NET

• Assist with some ETL for SSIS packages.

• End user comprised of up to 175 car dealerships with an average of 5 users City of Corinth -Corinth, TX

Help Desk 03/11 - 05/11

• Provided internal IT support at the City Hall.

• Created and maintained web pages with real estate information for the City of Corinth.

• Worked on database backup (SQL oriented).

• Attended to calls relating to computer issues, phone systems, fax machines, computer network for the Corinth police department, computer imaging.

• Served up to almost 60 end users

Pack N Mail - Denton, TX

Customer Representative 11/09 – 12/10

• Attend to customer related issues face to face and over the phone.

• Ran the cash register and tallied up the money collected at the end of the day

• Served almost up to 50 customers on a daily basis

• Packed and shipped packages

InnoMand projects

Shipping.Network

• Gathered requirements for the web application

• Data modeling using SSMS

• Designed the Database for the company (SQL Server 2012)

• Designed and developed the web application (ASP.NET, C#, VB.NET, WCF)

• Geo-Location using Google maps

• Integrated Swipe checkout using web services

www.CartinCleaners.com

• Gathered requirements for the web application

• Data modeling using SSMS

• Designed the Database for the company (SQL Server 2012)

• Designed and developed the web application (ASP.NET, C#, VB.NET, WCF)

• Integrated Swipe checkout using web services

BuyerPricing.com

• Gathered requirements for the web application

• Data modeling using SSMS and Visio

• Designed the Database for the company (SQL Server 2008, 2012)

• Designed and developed the web application (ASP.NET, VB.NET, WCF) www.SpringBranchTennis.com

• Gathered requirements for the web application

• Designed and developed the web application (ASP.NET, C#, VB.NET, WCF)

Contact this candidate