Sign in

Data Analyst Sql Server

Austin, Texas, United States
October 15, 2016

Contact this candidate


Wembo Mulumba

Systems Analyst

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

Austin, TX 78754

Cell +1-812-***-****





As a Systems Analyst and IT Professional for 12 years, Wembo would like to join a team of like-minded people with a lot of experience of creating logical and innovative solutions to complex problems for IT and other businesses. Wembo is diligent, fast learner, team player and have a keen interest in finance, entertainment, engineering, technology and software.


Software Engineer and Front End Developer for the web portal WEBGESTUS.COM and others sites using HTML 5, CSS3, AngularJS, JavaScript, WordPress, and PHP.

Excellent with UML, VB.Net, C#, Java, SQL Server Admin, Technical Writing and OOP.

Bilingual Fluency in Both English and French.

Time Management and Project Management.

Wembo Can manage multiple tasks in a fast-paced, deadline-driven environment Education: Bachelor of Science in Computer Science & Math Dec 2013

Binary University: KL, Malaysia, 4 years with 3.0 GPA (Graduated)

Important Subjects: Business Modeling, Java, C++, Database and OOP

Indiana State University: Indiana. Master classes: Computer Network, System Program, and Web Development II. Graduated with a BS & Master Credits(9) May 2016 Certifications:

Interlink Language Center Certifications in English 2014-2015 ISP Certificate in Network & Telecommunications Industry 2013 Work Experience:

Data Analyst & Representative Sept 15 - Current

Apple Inc. Austin, Texas

Recruiting as by Apex Systems as Apple Data Analyst for Maps Team. My Roles & Responsibilities:

Interpret data from primary and secondary sources using statistical techniques and provide ongoing reports.

Performed daily data SQL queries and prepared reports on regular basis.

Used advanced Excel functions to generate spreadsheets and pivot tables.

Developed Data Migration strategy for the customer to transfer enterprise legacy data to the newly developed ERP application and other software that I can’t talk about. Reverse engineered various application to develop data mapping between the two applications and implemented PL/SQL migration scripts to load data across multiple table by maintaining data integrity.

Compile and validate data; reinforce and maintain compliance with corporate standards.

Develop and initiate more efficient data collection procedures.

Working with managing leadership to prioritize business and information requirements. Computer Technician & Web Developer June 3- Current Cell Surgeons LLC. Austin, Texas

Troubleshooting a variety of computer issues.

Installing Hardware and Software for the company.

Configuring computer networks and Providing customer support

Fixing and Repairing PC, Tablets and Phones.

Daily use of Excel, Word and QuickBooks for Sales Report.

Use of WordPress, PHP/MYSQL, Photoshop, Fireworks, for: and also provided the SEO for better online presence. Development Mode :

Full Stack Developer Sept 2014 – April 2016

Business AB Travel & Fret SPRL Lubumbashi (DRCONGO)

Responsible of installing software on physical desktops.

Developing websites for the company: PHP 5.4, MySQL, HTML 5, and CSS & JQuery. Such as

Responsible for technical support Server Administration and Maintenance of the website using WordPress.

Provided Content and SEO solutions for the business and websites. IT Manager and Senior Data Analyst April 2013 – Dec 2014 Camel Oil Petroleum SPRL Lubumbashi (DRCONGO)

Worked as IT manager, and Data Analyst:

Performed daily data queries and prepared reports on daily, weekly, monthly basis. Used advanced Excel functions to generate spreadsheets and pivot tables.

Worked with SDLC methodologies to develop solutions for our new Businesses and Products. Was responsible of Documents, Reporting Sales using Excel, Word.

Outlook and Scheduling Technical Operations for the Building of Gas Stations and Providing Training for Our Accountants and Operations Managers.

Delivered support to existing business users and investigating and resolving and application errors, data discrepancies and queries. Software Developer & SQL Server Developer 2010 - 2013 Binary University College Kuala Lumpur, Malaysia

My responsibilities and Duties was to:

Develop and maintain software systems and web apps using Java/.NET.

Analyze technical specifications, product requirements, design features, implement and test software components.

Proficient in extracting, transforming and loading of data using SQL Server DTS and SSIS.

Experience writing complex SQL Queries and Procedures.

Day to Day included manipulation of XML, CSV and XSL files.

Extended knowledge of using and VBScript for data manipulation. Development/Tools:

Operating Systems: Mac OS, Linux/UNIX and Windows. Tools: Eclipse IDE, NetBeans, Visual Studio, GitHub MS Office, Putty, TeamViewer, QuickBooks

Programming Languages: C++/C, Java, C#, SQL, VB.NET, JS, HTML, and PHP. Database Systems Oracle, MongoDB, MSSQL, ACCESS.

Servers: Apache Tomcat 6.0, IIS, WebLogic, PWS.


Web Development Frontend & Backend

Designed the Interface of the websites,

Using HTML 5, PHP, MySQL and Angular JS, Designed the Interface of the website and the Backend System. Most of codes can be found on my GitHub Account:

Programmed the website functionalities using PHP and Web Services, Implemented SEO Concepts to increase visibility.

C# Hotel Reservation System 2015

Designed the Database Using Microsoft SQL Server and Performed the DBA functions using Command Line and SQL Management Studio. The Functionality of the system was coded in C# and Windows forms.

Made use of Metro Framework and Crystal Reports. Code will be illustrated upon request.

ANDROID Mobile Banking App (JAVA) 2013

Mobile Banking System and Thesis in Binary University College (Malaysia)

Created the Database to store information about the Mobile application Using MySQL, SQLite and XML.

The Android app Demonstrate the functions Internet banking system using Android app. Used of Eclipse IDE, Android SDK.

Database Management Jan 2011


Wrote Procedure to support GUI interface using ODBC.

Installed the software in all administrative Computer in the University.

The software was capable to generate reports and invoices each semester for every students. The Team Used C# and MSSQL.

References available upon request.

Contact this candidate