John Wireko

Phone: 410-***-****

ac2eab@r.postjobfree.com

Experience

8+ years; seeking a Tableau/ SSRS/ SSIS/SSAS or BI Technology Architecture role in IT. Manage SQL Server databases and administer Servers for ongoing operations. Daily task and assignments include but not limited to: Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.

COMPUTER SKILLS

Environment: MySQL, Php, HTML, wordpress, App Inventor, JustInmind, Oracle 11g, MS Office, Data

Language/ Domain knowledge SQL, TSQL, PL/SQL, UNIX Shell, Php, Java, JavaScript, Html, XML, CSS, Ajax

Data modelling/ Data warehouse concept/Microsoft Strategy/Sql, Meta data WMS.

SOFTWARE

BI Tools: SSIS, SSAS, SSRS, TABLEAU

PLATFORMS: UNIX, Microsoft windows XP, Windows 10

DATABASE: MS SQL server, Oracle, DB2, MySQL, MS SQL SERVER 2014 /2008 / 2005 / 2000, MS Access 97/2000/2003.

DB Tools: SQL Server Management Studio, SQL Enterprise Manager, Query Analyzer and SQL Profiler.

Operation Systems UNIX/Windows XP&NT/Windows 10/ Windows 8/ Windows 7/2000/2003.

Programming Languages: SQL/MySQL

Web Technologies: HTML, XML, Wordpress, Inkscape

Productivity Applications: MS Word, MS Excel, MS Access, MS FrontPage, MS Project, MS Publisher.

Reporting Tools: MS Access, MS SQL Reporting services (SSRS) and Microsoft Excel, Tableau

RITE AID CORPORATION, PERRYMAN, MD

SQL/TABLEAU DEVELOPER/DATA ANALYST

February,2013 To Date

Developed reports using Warehouse Management system (WMS), Application manager, Cubiscan report and Host report to march projected sales compared with customer purchases to project targeted inventory. Daily tasks and assignments includes but not limited to:

Responsibilities:

•Install upgrade Tableau server and server performance tuning for optimization (from v9 to v10)

•Create highly visual analytical dashboard using Tableau 9.3 and 10.0 and SSIS

•Help develop and capture KPI’ by exploring data

•Data modelling

•Oversight of the data associated with data assets that information can be integrated, accessed, shared, linked, analyzed and maintained to best effect across an organization using Meta data.

•Configure Tableau to Dashboard from various data sources and SSIS, SSAS

•Design and develop Tableau visualization solutions using v9 and v10

•Work on generating various dashboards in Tableau server using various data sources

•Prepare Dashboards using calculations, parameters in Tableau

•Proof-read all documents and maintain accuracy of information and preparing SOP

•Developing Dashboard and preparing ad-Hoc reports and SSIS

•Define best practices for Tableau Development

INFOVIEW DATA SOLUTIONS, MD

SQL/TABLEAU DEVELOPER

04/2010 - 01/2013

•Install, implement SQL Database

•Create Pro Database and tables, triggers and views

•Developed Data entry, query and reports request screens and tuned the SQL queries.

•Perform testing in Tableau with “TabJolt” to push a heavy workload and test how the server bends or breaks under load.

•Perform data blending to bring data from multiple data sources to one Tableau view

•Used joins, indexes effectively in where clauses for Query optimization using Tableau and SSIS

•Assisted and supported issues related to the queries and database systems.

•Contribute to the compilation, organization, and production of protocols, reports, regulatory submissions, or other controlled documentation.

Configured, installed and administered oracle database systems and roles

Conferred with end users to define and implement members’ system requirements such as data release format, delivery schedules, and testing protocols

Design and validate databases including designing or testing logic checks

Generate data queries based on validation checks or errors and omissions identified

Set triggers, create Views as part of security checks

Create store procedures using MySQL

NORTH AMERICA BAPTIST ASSOCIATION, BRONX, NY

ORACLE/ETL DATA ANALYST

03/2008 - 04/2010

•Conduct risk assessment of assigned department or functional area using SSIS and SQL

•Establish risk-based audit programs. Review the suitability of internal control design.

•Conduct audit testing of specified area and identify reportable issues and dimension of risk.

•Determine compliance with policies and procedures.

• Extract and analyze the NABA data from the database using to find out if there are violation of laws such as SBC Convention, regulations and management policies, etc.

•Inspect the reports of association members to analyze the transactions and efficiency of the report procedures using Tableau and SSRS

•Report to the NABA Head office, information regarding the audit results and suggest changes in trend in financial activities and operations of NABA.

•Discuss with Association members regarding transactions in the statements.

•Identify risks or problems using data analysis and make recommendations to the individual NABA members for improvement.

EDUCATION

UNIVERSITY OF MARYLAND BALTIMORE COUNTY (UMBC)

MS INFORMATION SYSTEM

2016

UNIVERSITY OF SCIENCE & TECHNOLOGY KUMASI GHANA

BA SOCIAL SCIENCE (ECONOMICS/LAW)

09/1996 – 05/1999

Contact this candidate