Data Analyst Ssis

Francis C Abuah

*** ********* *******,

Atlanta, GA 30339.

Tel: 321-***-****

Email: *************@*****.***

EDUCATION:

Florida Institute of Technology, Melbourne, Florida.

Master’s Degree in Computer Information System January 2015 - July 2017

Igbinedion University

Bachelor’s Degree in Computer Science, 2012

Technical Skills:

•SQL Server

•Databases: Microsoft SQL Server 2019/2016/2014/2008R2/2008/2005, Oracle 10g, MS Access.

•T-SQL

•Data Visualization Tool: Tableau

•ETL Tools: SSIS

•Object Oriented Programming (Java)

•Excel (Pivot Tables)

•MS Office: Microsoft-Word, Excel, Access, Project, Outlook, Power Point.

Professional Experience:

Capita (International business process outsourcing and Consulting company): AUG 2017 – Aug 2022

SQL Server Developer/Data Analyst

Responsibilities:

•Requirement gathering from your clients or stakeholders for the Design, development and maintenance of a Database or Table using SQL Server Management Studio (SSMS)

•Developing well detailed project process flow diagram.

•Developed Transact-SQL codes to create/update Tables, Stored Procedures, indexes, Views, Functions, CTE.

•Modifies Stored procedures and T-SQL Queries to improve Query execution Process.

•Wrote Complex T-SQL Queries or Scripts for Joining Multiple Tables.

•Assisted developers with code enhancements, tuning of queries and indexing the tables.

•Design creative and aesthetically sound visualization and literature to communicate analysis results, data characteristics, messages and themes, ideas, processes and methodologies in both textual and graphic mediums using Tableau Desktop.

•Developed Tableau Reports that provide clear visualizations of various industry specific KPIs.

•Developed Worksheets and created Dashboards using advanced Tableau features like Calculated Fields, Table Calculations, Parameters, Geographic Mappings, Joins, Data Blending, Dashboard Actions etc.

•Access and transform massive datasets in Tableau through Filtering, Grouping, Sets, Aggregation and Statistical Calculations to create Dashboards.

•Used Box Plots, Forecast, Trend Lines, Reference Lines and Drop Lines in Worksheets to deliver actionable insights and to enhance highly interactive Dashboards using Tableau Desktop.

•Involved in a massive project that used Tableau Level of Detail Calculation (LOD) to create a highly descriptive and Interactive Dashboard.

•Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (ORACLE), Excel Spreadsheets to SQL server.

•Developed SSIS packages to migrate data from Oracle, flat file, Excel MS Access and SQL Server.

•Exceptional Communication skills both in Writing and Speaking.

•Good Team Player and a great ability to lead and perform well under pressure situations.

Capita: Jan 2013 - Jan 2015

Jr SQL Server Developer/Data Analyst

Developed Transact-SQL codes to create/update Tables, Stored Procedures, indexes, Views and Triggers.

Collaborate with internal team members and client to manage and determine transformation of requirements and data extraction.

Read and write complex queries, ability to create database objects (tables, views, stored procedures, user-defined functions) and modify existing reporting content.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (ORACLE), Excel Spreadsheets to SQL server

Developed SSIS packages to migrate data from Oracle, flat file, Excel MS Access and SQL Server.

Design database schema based on data modeling of business requirements and entities.

Designed and implemented comprehensive Backup plan and disaster recovery strategies.

Designed, developed, tested and maintained Tableau functional reports based on user requirements.

Participate in analysis, design, and implementation of ETL (Extract Transform and Load) solutions around the EDW (Enterprise Data Warehouse).

2yrs employment Gap was for my MSc degree program at Florida tech.

Work Authorization: Green Card

Contact this candidate