Resume

Sign in

Data Analyst

Location:
Katy, TX
Posted:
October 26, 2019

Contact this candidate

Resume:

Kwesi Maison

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

Katy, Texas *****

832-***-****

adaoqa@r.postjobfree.com

PROFESSIONAL SUMMARY:

Advanced professional with over 10 years of combined experience in Relational Database Management Systems, reports creation, data analysis, data integration, ETL & data warehousing experience

Expert skills in SQL Server 2008, 2012, 2014, 2016, SSIS, SSRS and Tableau

Expert Skill in designing and creating the data warehouse and all related extraction, transformation and load of data functions

Expert skills in writing PL/SQL codes that can be used as shared libraries to enabling code integration and code reuse

Use SQL to code program blocks, triggers, stored procedures, functions loop statements and packages.

Proficient in MS Access, MS Excel utilizing macros, advanced functions, including pivot tables, V & H Look ups

Expert in Data extraction, cleansing, de-duplication, standardization, conversion, transformation loading, mining, archiving, type 60wpm, expert skills in MS PowerPoint and MS Word

Expert in writing functions in VBA (Visual Basic for Applications) to support reports production and automation

Use BCP, SQLCMD, and SQL Server Import/Export Wizard to import and export large volumes of data (ETL), run scripts and transactions, and shred XML in SQL Server.

Proficient in Transact-SQL, Stored Procedures, utilize Sequel Server Integration Services (SSIS) to upload data from various sources to staging tables and use the data for updating various tables. Perform data manipulation and extraction using Microsoft SQL Server Management Studio. Develop complex SQL queries against various data from both internal and external sources utilizing complex subqueries, correlated queries, and nested queries. Analyze and interpret data by producing clear and compelling reports for different audiences which include graphs and charts. Supports business area projects by applying general knowledge of the business area processes including best practices. Provides data and respond to request from external groups/agencies/vendors and exports data into Excel or CSV files and reviews them for quality and data integrity before sending them to internal or external clients.

Team player and an autonomous producer with a sense of timeliness, accuracy and the willingness to learn, strong verbal, written and interpersonal communication skills

EDUCATION:

University of Phoenix – BSc – Business Administration

Houston Community College – Database Administration

PITMAN CENTRAL COLLEGE – LONDON, UK

Certificate - office Automation

QUALIFICATIONS:

Advanced SQL Server 2008, 2012, 2014, 2016

SSIS, SSRS, Visual Studio and intermediate level Tableau

Intermediate level Oracle SQL & PL/SQL

RDBMS, Visual basic for applications (VBA)

Introduction to Level I C++ & Level I Visual basic

Certification Course in Office Technology

Advanced Excel & Advanced Microsoft Access

PROFESSIONAL EXPERIENCE:

Archer Systems - 04/2016 to 10/2018

Snr. Data Analyst

Responsible for designing and creating the data warehouse and all related extraction, transformation and load of data functions as well as testing and troubleshooting it before deployment

Responsible for deciding on full or incremental loading, creating an ETL scripts, control flows, data sources, data transformations, data destinations, resetting destination databases, data flow paths, fact and dimension tables, error output paths, configuring data sources and destinations, executing SSIS and deploying SSIS packages

Perform select, insert, update, delete, merge, commit and rollback transactions using TSQL Server

Use SQL to code program blocks, triggers, stored procedures, and functions

Design and deploy data table structures, reports, and queries in SQL Server.

Perform researches and make recommendations on ledger exports

Coordinate and work with other technical staff to develop relational databases and secondary

databases (i.e. Access).

Receive and Import data from various formats into SQL Server utilizing SSIS packages

Detect inaccuracies in existing and received tables and investigate, offer and apply solutions.

Identify and resolve database access and performance issues.

Develop, implement, and maintain change control and testing processes for modifications to

databases.

Use data profile to analyze the source data more effectively and understand the source data better to prevent data quality problems before they are introduced into the data warehouse.

Develop and maintain views, stored procedures and functions

Ensure all database systems meet business and performance requirements.

Produce ad-hoc queries in SQL Server and develop reports to support business needs.

Create and maintain technical documentation.

Implementation of data dashboards to display data in differing formats.

Maintain daily backups

Support analytics team with optimizing existing queries, views and stored procedures.

Perform analysis and provide user friendly reports, analysis, presentations, dashboards related to business information utilizing SSRS & tableau

Prepare / scrub data in MS Excel for import into sequel server database using both manual inserts and updating methods, utilizing SSIS packages. Run daily scripts and stored procedures to update the database and email team of any discrepancies or changes accordingly.

Maintain, Support and improve integration and reporting from Bankruptcy Salesforce system. Misc. database management tasks as requested by the team, including backups, restore, move database and sporadic data updates as requested by team and provide database support and troubleshooting of QSFDB system as needed and as backup for the team.

THE WILLIS GROUP / CONTRACT WITH SCI 02/2015 – 03/2016

HMIS Analyst

Complete projects that require cleansing, deduplication, data mining, analysis, and presentation

Present data in charts, graphs, and pivot tables

Move and connect data from various sources to include Excel, Access, and SQL Server

Design and develop relational databases for collecting data

Use Data Definition Language (DDL) and Data Manipulation Language (DML) SQL commands to update and manipulate data in SQL Server to update or improve existing data quality

Design and present conclusions gained from analyzing data

Create and manage CSV and XML imports and exports

Manage and grant security access to users, and resolve daily heat tickets to resolve user issues in HMIS

Automate processes wherever possible to enhance production

STEWART LENDER SERVICES 01/2012 – 07/2015

Systems Analyst

Prepare / scrub data in MS Excel for import into sequel server database, and generate pdf images for review

Data Extraction, cleansing, deduplication, Standardizing, conversion, transformation and loading, archiving and reporting

Use and maintain existing macros, and write new macros, Use /edit existing sequel scripts to manipulate data

Responsible for activities required to ensure optimum performance and data integrity in production environments, in line with the requirements.

Analyze information to determine, recommend and plan for future systems and system modifications.

Act to resolve problems in the using the fastest and most efficient method possible.

Provide important system points for training and development areas.

Train users on new and old system operations.

Ensure programming results are meeting the client’s requirements based on the client’s business needs.

Consults with developers and other technology staff to develop understanding of varied and complex business needs supported by the system.

Provide regular status reports to project management, updating tasks and time estimates, as necessary.

Deploy Document Templates prepared by the Program analysts.

Write queries in SQL to update the Pool Manager tracking system.

Responsible for creating, implementing and maintaining automated business processes

Use T-SQL/SQL scripting / other techniques to mine data and convert into custom formats

Execute SQL queries, managing and manipulating backend code to improve processing efficiencies

Post sample images and data files to client SharePoint, and Assist with User Acceptance Testing (UAT)

Use Business process modeling to visually represent workflows, to identify potential improvements by utilizing different methods, such as the flowchart, data-flow diagrams



Contact this candidate