KENNETH OPPONG

Email: add7ya@r.postjobfree.com 732-***-****

DESCRIPTION:

To obtain a challenging and fulfilling position in your organization that utilizes my strong computer skills, an opportunity to apply my learnings and gained experience in Information Technology to enhance my knowledge base.

PROFESSIONAL HIGHLIGHTS:

I have overall 6+ years of IT experience and 8 + years of experience Analysis, Design, Coding, Testing, Migration, Production support and Implementation of Software applications and on Tableau Business Intelligence/Business Analytics software.

Solid experience of technical support in major financial and Health institutions.

Expertise in Tableau, MySQL, FICS, SQL, MS. Access, MS SQL server

Experienced on Tableau Admin activities and writing SQL queries.

Database Administrator, Proficient in Document Management Software MS Office, MS

Visio and Excellent knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

SKILLS SUMMARY:

Programming languages/ BI Software: SQL, SSRS, SSIS, Tableau Desktop/Server, Alteryx.

Database/Cloud Storage: MS SQL Server, Oracle, MySQL, MS Access, AWS, Azure, Hadoop

Operating Systems: UNIX, Windows, Mac OS

Education

Coppin State University

BS. Nursing

WORK EXPERIENCE:

John Hopkins

Data Analyst/Tableau Developer September 2012- Current

Gather data from different data sources like MySQL, Oracle and SQL Server

Develop reports, dashboards using Tableau 9.3 for quick reviews to be presented to Business and IT users.

Developed POCs by building reports and dashboards using Tableau to perform

Statistical analysis of large data

Developed Ad-hoc reports using Tableau Desktop, Excel

Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.

Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.

Used SQL Server Reporting Services (SSRS) and SQL Server Management Studio 2008 -SSIS, SSAS, and SQL Profiler, including Crystal Reports to run scripts and maintain stored procedure and code functions across company's Databases

Performed schema changes in the database per request and met with clientele and with various subgroups for requirement gathering in order to allow self-extracted reports and created critical field reporting tools for Enterprise Data Management customer segments

TD BANK

SQL /Tableau Developer, February 2009- August-2012

Designed and developed custom revenue management models to predict and estimate flight

passenger capacity to maximize profits.

Validated data to correctly reflect reservations for passengers and carrying capacity of cargo.

Created SQL stored procedures using SQL Query Analyzer and Transact-SQL as data sources for

reports.

Trained, mentored, supervised, and advised over a dozen analysts in the development of programs.

Acted as a point of contact for answers to questions over two groups.

Trained analysts in development standards; according to corporate models and paradigms.

Developed databases to interface with SQL Server, Oracle,and MS Access databases.

Developed and supported applications for the Revenue Management and Revenue Management

Cargo groups.

Design, build, manage, and evolve a suite of Tableau Dashboards and other self-service tools for our key stakeholders.

Partner with the business teams to understand their analytics needs and look for opportunities to enhance our product offering.

Collaborate with other BI Analysts and Engineers to develop data/table structures in both on-prem and cloud-based data stores, optimizing for Tableau Dashboards and other self-service needs.

Offer strategic guidance to both analysts and business teams on how to best leverage tools.

Contact this candidate