Sql Developer Business Operations

Location:

Old Bridge, NJ

Posted:

January 21, 2024

Contact this candidate

Resume:

EMMANUEL K. DUAH

***********@*****.*** +1-848-***-**** Sayreville, NJ 08872

PROFESSIONAL SUMMARY:

A Database Developer professional with 15+ years of multi-disciplinary experience in diverse Database architecture design, implementation, Operation, Risk analysis, vulnerability management & compliance.

Experienced working in a consultative capacity to effect operational database design, development, and deployment.

Ability to improve business operations, reduce operational costs and increase business performance through proper deployment of technology.

Successfully built working relationships with external vendor in all corners of the globe.

Experienced developing high valued enterprise architecture database, plus database security ecosystems that bring people, processes, and technology together to create business values that adapt and evolve given the priorities set in the Enterprise Governance structure.

Engage in business strategy development to identify new business capability and technology-driven opportunities and ensure alignment and prioritization of IT strategy.

Develop, review, approve, and maintain enterprise database architecture designs, reference architectures, standards, solution blocks, solution patterns, and roadmaps.

Develop strategies to overcome architecture roadblocks and propose enterprise solutions that transcend business areas and functions.

Manage the definition of architecture patterns and reference models.

TECHNICAL SKILLS:

1.Databases (MSSQL, Oracle, Mongo DB, IBM DB2)

2.Data Warehousing

3.Data Migration – ETL, SSIS Packages

4.Power BI

5.Python

6.Cloud Operation (Azure)

7.T-SQL, PSQL, MySQL

8.Reporting (MSSRS, Crystal)

9.Frameworks - .NET

PROFESSIONAL EXPERIENCE

Cyber47 LLC / US July 2020 – Present

Database Developer / Engineer

Assessing the firm's existing databases and data structures

Preparing end-to-end models for evaluation and usage

Coding data structure and integrating current databases with newly developed ones

Refining and supervising databases

Keeping the database secure

Developing database protocols to guarantee the database's integrity

Meeting with senior management and investors to ascertain their requirements and objectives

Making sure data architecture conforms with all government and industry laws and guidelines

Monitoring the database and establishing feedback mechanisms that allow for improvement.

Creating and implementing database management processes

Studying new methods, applications, and solutions that may enhance the corporation data-related features

Cigna Group / USA December 2018 – May 2020

Data Analyst

Created workbooks by importing data, and defining relationships (Excel, Oracle, and MySQL).

Used Performance recording on Desktop and on Tableau Server and Tuned the Performance of Dashboards.

Performed data management projects and fulfilled ad-hoc requests according to user specifications by utilizing data management tools like Python, SQL, and Google Sheets.

Provided UAT assistance and post implementation production support.

Evaluated Provider level data to assess provider data quality, and built data quality reports using DQ analyzer, SQL server, MS Excel.

Responsibilities included extraction, cleansing, joining and analyzing data using SQL queries, Excel Marcos.

Worked closely with marketing and operations teams to build and analyze listener behavior reports.

Involved in all phases of data acquisition, data collection, data cleaning, model development, model validation, and visualization to deliver data science solutions.

Automated Quarterly reports and Budgets forecast model for People Operations using SQL and Tableau.

Quipu GmbH / Ghana March 2008 – May 2018

Head of Database Department

Developed various logic in the company’s core banking database.

Maintained High Level Availability, Integrity and Security of the core banking database.

I coordinate varieties of projects and other activities required by the banks we were supporting.

Ensure daily, weekly and monthly statistics regarding the support delivered to the ProCredit Banks across Africa.

Ensure Issues reported by the banks were resolved in-time using ticketing systems.

Supported banks information management system department in developing and generation of their monthly and yearly reports to the Central Bank.

Designed technical courses for personnel training purposes

Participates in meetings, workshops and seminars

Researches on new IT technologies needed for the development of new functionalities required by the Bank.

Travels to various destinations if the need arises to support and implement new features.

EDUCATION SUMMARY:

●2016 Simos Education – Macedonia (Certified Technology Specialist)

●2002 – 2005 A.B.M.A - UK, Associate Degree(Computer Engineering)

Projects Implemented Location

ProCredit Bank Germany

Upgraded Core Banking Database