Data Analyst
Resume:
Kwesi Maison
Katy, Texas *****
***********@*****.***
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