Nana Gyabeng Email: adh2u3@r.postjobfree.com

Cell: 864-***-****

Summary:

Performed complex SQL queries and built PL/SQL procedures for data migration

Designed reports, Graphs and deployed reports to Dashboards

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer

Strong Data Analysis skills using business intelligence, SQL and / or MS Office Tools.

Ability to provide solutions to complex Business Cases.

Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.

Extensive experience in creating data scope and requirements. Strong expertise in understanding various data sources.

Proficient in working with senior executives and multiple stakeholders to understand key data issues and identifying their resolution.

Technical Skills:

Databases: MS SQL Server 2019/2012/2008/2005/, oracle0.9, 11g, MS Access 2007,Teradata

Reporting: Crystal Reports, Power BI, SQL Server 2000/2005 reporting services.

ETL Tools: Data Stage, SSIS,,Tableau

Database Development: T-SQL and PL/SQL, Microsoft Hyper-V Server

Office Applications: MS Office (Word, Excel, Visio, PowerPoint, Project)

Operating Systems: Windows 7/Vista/2000/XP/2003, Unix 5.2/4.3

.

Professional Experience:

Sonnen Inc., Atlanta, GA,

Quality Data Analyst Engineer January 2019 to Present

Responsibilities:

Produces semiannual customer reports efficiently and accurately by auditing data and working with vendors to resolve inconsistency/suspicious activity

Develops complex SQL query extracting raw data into demanded data frame

Perform model validation to predict transaction volume/value trends for determining customer risk rating and identifying suspicious account activities

Visualize ad hoc complex data for reporting metrics using analysis tool such as Tableau and Power BI

Generates team workflows, cycle-end summary, issue-tracking log and document library for customer review process using VBA

Extensively involved in designing the SSRS reports and SSIS packages to export data of flat file source to SQL Server database

Involved in writing SQL joins, sub queries, Google Analytics tracing and performance tuning for better running of queries Develop and implement new databases for compliance purpose, data collection systems, data analytics and strategies optimize statistical efficiency/quality

Medtronic

Biomedical Data Analyst January 2018 to December 2018

Responsibilities:

Wrote code for database Access, Modifications, and Constructions including schemas, SSIS and stored procedures

Identified data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.

Gathered and analyzed requirements and Programs all or selected components of SQL applications.

Documented components and applications.

Researched, Evaluated and Recommends new tools and applications for use in assigned responsibilities

Resolved medium to high complexity application defects and solved a range of problems

Analyzed possible solutions using standard procedures

Received a moderate level of guidance and direction

Applied Security in Packages to safe guard sensitive data, and used log providers to log events.

Made the SSIS packages dynamic by passing the input from configuration files.

Involved in Performance tuning of ETL transformations, data validations and stored procedures

Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)

Wrote Stored Procedures / Transact-SQL scripts as per the business need.

Clemson University

Data Analyst Intern August 2017 to December 2017

Responsibilities:

Wrote SQL Stored Procedures and Views, and coordinate and perform in-depth testing of new and existing systems.

Created reports using MS Access and Excel. Applying filters to retrieve best results.

Created data Quality Scripts using SQL to validate successful data load and quality of the data. Created various types of data visualizations.

Education:

Master of Engineering, Biomedical Engineering, Clemson University, December 2017

Contact this candidate