DAVID AGYEI BEMPAH Email: ad4nlt@r.postjobfree.com

Address: *** **** **, ******.

Massachusetts.

Objectives

Over 5 years of experience in analyzing, designing, developing, testing applications in OLTP, Clint/Server architecture and web-based applications. Proficient in providing client-focused, testing, and supporting the development and implementation of oracle data warehouse which supports several business requirements through numerous distributed database applications. Self-starter who thrives in fast paced agile environment, introducing, and learning new technologies and adapting to and changing direction quickly.

Skills

SQL Server Reporting Services (SSRS), SQL, C++, SQL Server Integration Services (SSIS), Core Java, C++, Shell programming, SQL, Visual Basic, Microsoft O365 Administration (MS word, MS Excel, MS Access, and MS PowerPoint), Photoshop, MySQL, Visio, Virtual Machine, Wireshark, Packet Tracer, Jira, SoapUI, Zendesk, Windows, Linux, Mac Os, JavaScript, React.JS, AWS, Power BI, MySQL, Informatica, Server, Tomcat.

Work Experience

SQL/ETL Developer

Judge Rotenberg Education Centre-July 2023 – Present

Designed ETL strategies using SSIS.

Resolving issues related to store procedures and enterprise data warehouse.

Exposed to software development life cycle involving database tuning, design, triggers, functionalities in production support.

Performed tuning SQL queries, store procedures to troubleshoot and resolve issues in OLTP environment.

Created indexes, analyzed the table partition and table statistics.

Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, stored procedure, Views, Trigger to implementing the business rules and transformations.

Performed tuning of query performance.

Develop Informatica data pipelines to support the company’s business requirements.

Developed function packages and store procedures for the company.

Developed and worked with different reports and forms for global tracking and auditing purposes.

Worked in data mapping, enabling the extract, transform and loading of the data into target table.

Server analysis Services Business intelligence (SSAS, SSRS).

Provide day-to-day support and monitoring SQL Server performance.

Managed integration services security and database security to various group users.

Responsible for database backup job monitoring and troubleshooting.

SQL Developer

Apptek Solutions Group- March 2021– May 2023

Developed database components, data storage, data schemata and data queries.

Combined data from different teams to the database and gave access authorized users to view the final data base on the business requirement.

Created stored reports with different types of graphs and charts to speak visually using SSRS.

Planned and designed SSIS packages based on the business requirement for loading and extracting data and forwarding the reports to other team members.

Worked with the DBA to deploy SSIS packages on the server both at package and project level.

Worked with a team to create deployment documentation, technical documentations, and test cases.

Participated in the full ETL development and analysis of software life cycle.

Experienced in working in agile environments and attended scrums daily meeting.

Improved the performance of a database by creating indexes to speed up searching and sorting, splitting queries and reducing the number of rows and columns when not needed by avoid inconsistency and duplication of data.

Automated payment transactions and analysis based on the requirements of the business.

Created stored procedures, views, and functions in MySQL to support SISS console applications, SSIS packages and SSRS reporting for data warehouse purposes.

Designed ER diagrams using Erwin 4.14.

On-demand learned PowerShell scripting to develop console applications using C++.

SQL Developer

Navy Federal Credit Union (Intern)- May 2019 – August 2019.

SSIS ETL/Analyst/Reported Nationwide Insurance is a full-range insurance company, it specializes in auto, life, health, term life, and home insurance services.

Improved the performance of existing views and reports using hints

Designed the logical and physical model architecture for database.

Interacted directly with the various SME for gathering the business requirements.

Involved in Design DW of Star Schema (Dimensional model and Fact tables) based on business.

Convert data from Legacy system to SQL Database.

Used ETL to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Education

MS in Information technology – January 2019 to December 2020 (Fairfax University of America, VA)

Cloud Technology: AWS Certified Cloud Practitioner.

AWS Certified Solutions Associate.

AWS Database Specialty.

CompTIA Cybersecurity Analyst.

Contact this candidate