Data Tableau

Bernard AMPAW

***** ***** ***** *** ********** MD 20871-4030 240-***-**** *********@*****.*** EDUCATION

University of Maryland College, Adelphi, MD Master of Science Data Analytics On going

University of Ghana, Accra, Ghana Master of Business Administration (MBA)

Finance

Central University College, Accra, Ghana BSc. Accounting

CERTIFICATIONS

MCP – Microsoft Certified Professional

CompTIA Security+ ce Certification

Databases:

SQL Server 2012/2014/2016, Relational and Multi-Dimensional databases. (RDMS),

Business Intelligence:

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, Teradata, Data Stage, Data Modeling, SAS, Tableau, informatica PowerCenter and Agile. and cloud computing.

Operating Systems:

Windows NT/XP/7/10, UNIX, and Windows

Software Applications:

MS Office, MS Project, Microsoft Visual Studio

2005/2010/2012.

Intermediate Microsoft Office: Word, Excel, Outlook, PowerPoint, and Access

Security Clearance Requirements: Public Trust

PROFESSIONAL EXPERIENCE

ASM Research - Fairfax, VA

Senior MS SQL Server DBA. (Nov,2019-Nov,2020)

•Designed, building, installing, configuring, and supporting Database servers.

•Applied the following concepts and features: Database Management, MS SQL Server 6.5 though SQL Server 2012, SQL Programming,

•Database Security, Requirements Analysis, Data Maintenance, Database Performance Tuning, Large Clustered System Implementation.

•Installed, maintained, and patched the MS-SQL software; created, moved,

•upgraded, and deleted databases; implemented backup and recovery processes.

•performed routine maintenance on databases; monitored and tuned databases using Performance Monitor,

•SQL Server Profiler and Dynamic Management Views; implemented and maintained security rules and security audits; maintained state of audit readiness; problem resolution.

•Deployed and maintained a SQL clustering environment.

•Monitored database system details within the database, including stored procedures and execution time.

•Monitored, optimize, and requested allocation physical data storage for database systems

•Planned and coordinate

INFOSYS LIMITED. – Charlotte, NC

TECHNOLOGY LEAD. (Sept 2018- Oct,2019)

Project: Customer Relationship Hub (CRH) – Sql, Tableau, Teradata, and Linux

•As a Technology Lead involved in all the phases of the project from scratch and performed different roles in the different phases of the project.

•Studying the Data flow of each customer VAP (Value Added Program) and checking for the Autosys job related.

•Gathered and Analyzed requirements, Design, functional & technical specification worked closely with the business users to understand business requirements and designed the process for the data extraction, business logic implementation and loading into target tables. Identified the dimensions, Fact tables and designed the data mart.

•Reconciling Data for PR (Preferred Reward) program from upstream to downstream if data are missing

•Any Nexus ticket raised by client assigned to me to address the issue.

•Created test data and unit testing cases to ensure successful data loading

•Experience in Linux shell scripting and job scheduling using Autosys

NTTDATA INC. – Charlotte, NC

APP. SOFTWARE DEV. PRIN. CNSLT. (Jan 2018 – Sept 2018)

•As a Developer involved in all the phases of the project from scratch and performed different roles in the different phases of the project.

•Gathered and Analyzed requirements, Design, functional & technical specification worked closely with the business users to understand business requirements and designed the process for the data extraction, business logic implementation and loading into target tables. Identified the dimensions, Fact tables and designed the data mart.

•Designed and developed the ETL solution using SSIS packages to implement slowly changing dimensions of Type 2 to populate current and historical data into Dimensions. ETL solution validated incoming data and sent notifications when jobs are done.

•Created Stored Procedures, User Defined Functions, Views. Created database triggers to check the referential integrity of the database.

•The Customer data thus loaded into data warehouse is utilized to generate reports using the SSRS reporting functionality.

•Developed monthly, weekly, and daily reports as per the requirement and user access with respect to security in Report Manager using SSRS.

•Created test data and unit testing cases to ensure successful data loading.

•Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks such as data loading, batch jobs.

•Worked on providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

•Taken backups base for to restoration process.

Akvarr Inc. – Gaithersburg, MD

Business Intelligence Developer (Dec 2015 – Nov 2017)

•Detail-oriented, organized, and competent 'SAS Programmer' with over + 3years of experience of working in any industry. Adept in operating SAS software, maintaining updated database, performing extraction of usable data from information as well as writing programming modules and possess excellent analytical as well as communication skills.

•Develop, Design and Support Interactive Tableau dashboards is preferred ·

•Experience with Business Intelligence data visualization tools, specifically Tableau.

•Work directly with operations to better understand their role and what types of data they have/use to work with Tableau.

•Tableau Server: Migrate all existing Tableau dashboards (currently packaged workbooks only viewable by customers with Reader) to Tableau Server; setting up security, user per missioning process/logic for Tableau Server

•Dashboards: Build new dashboards and adjust existing dashboards, based on requirements received.

•Intermediate Microsoft Office (Word, Excel, Outlook, PowerPoint, and Access) skills

Winners World Inc. – Washington DC.

ETL Developer (Dec 2013- Nov 2015)

•Worked on developing business intelligence solutions for the finance and accounting units.

•Developed SSIS packages and SSRS reports for various business processes such customer invoice and payment data.

•Designed ETL packages with different data sources and loaded the data into target data tables by performing different kinds of transformations using SSIS.

•Tuned and modified existing SSIS packages to improve their performance and speed.

•Performed source to target mapping.

•Created SSRS reports for financial statement metrics, audits metrics and month-end financial statement metrics, budget metrics.

•Responsible for database architecture, design and development.

•Set-up and managed Enterprise Resource Planning (ERP) system.

Contact this candidate