PROFILE

An IT professional with * years’ experience

and a highly analytical, process-oriented

data analyst with in-depth knowledge of

database types; research methodologies; and

big data capture, curation, manipulation, and

visualization. Proficient knowledge in

Business Intelligence, Excel, relational

database administration, and analytics.

Excellent understanding of business

operations and analytics tools for effective

analysis of data. Seeking to utilize my skills,

abilities, teamwork, and excellent

organizational and problem-solving skills to

achieve the goal.

WORK EXPERIENCE

American Express National Bank April 2021 – Present New York, NY

Data Analyst/Tableau Developer

• Played key role in Migrating Customer data in structured, semi structured, and unstructured format into Snowflake environment.

• Created rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.

• Responsible for interaction with business stakeholders, gathering requirements, and managing the delivery.

• Investigated data discrepancies, resolved them, and articulated them to support the team's ability to do effective data analysis.

• Involved in analyzing the source data coming from different Data Sources.

• Analyzed the requirements to identify the necessary tables that need to be populated into the staging.

• Develop and maintain financial reports to clearly communicate actual results, forecasted performance, and variances to plan, forecast and budget.

• Develop dynamic reports, dashboards, and key performance indicators aligned with business strategies and initiative.

• Wrote complex SQL ad hoc queries with examined reports and presented findings in PowerPoint and Excel.

• Utilized techniques and business intelligence (Tableau) to create dashboards and ad hoc reports to address business problems and streamline processes.

• Created interactive filters, parameters, and calculations for dashboards and worksheets in Tableau Desktop and Tableau Online. SKILLS

• Data analysis and exploration.

• Statistical knowledge.

• Creating data visualizations.

• Creating dashboards and reports.

• Writing and communication.

• Domain knowledge.

• Problem solving.

• Data Collection

• Teamwork Skills

• Critical Thinking

• Presentation

• Data Mining

Roger Doku

Data Analyst / Tableau Developer

(571) 402- 5223 ~ adz7en@r.postjobfree.com ~ Address: Dumfries, VA Tableau Public: https://public.tableau.com/app/profile/roger.d TECHNICAL EXPERTISE

Business Intelligence Tools

Tableau, Power BI, Excel, and

PowerPivot, SSRS

Databases:

MS SQL SERVER, TERADATA

MySQL

Proficient in Microsoft Office

Excel, Access, Word, and PowerPoint

Operating Systems

Win XP, Vista, Windows Server

ETL / Other Tools

SSIS, Erwin Data Modeler, ER Assistant,

ALTERYX

Querying Tool

SQL Management Studio,

SQL Plus, SQL Developer,

Python, SAS

Cloud Migration Tools

Snowflake, Microsoft Azure,

AWS

WORK EXPERIENCE

J C Penney Company January 2017 – March 2021

Plano, TX

Data Analyst/Tableau Developer

• Used analytics tools such as Tableau to support the marketing and sales teams in finding leads.

• Used Tableau and SQL to redefine and track KPIs surrounding marketing initiatives and supplied recommendations to boost landing page conversion rate by 38%.

• Participated in early stage of data collection by analyzing both structured and semi-structured data in JSON formats to help define product priorities in SNOWFLAKE environment.

• Partnered with business and technology teams to build insightful analytical solutions.

• Harmonizing disparate data sources for use in the tableau by leveraging data blending.

• Built operational reporting in Tableau to find areas of improvement resulting in annual incremental revenue.

• Built out the data and reporting infrastructure from the ground up using Tableau and SQL to provide real-time insights into the product, marketing funnels, and business KPIs.

• Collaborated with data stewards to test, clean, and standardize data to meet business requirements.

• Built and published interactive dashboards on Tableau Server, resulting in increase in revenue.

• Developed ETL workflows with SSIS to pull data from different sources like Csv, Excel, Pdf, SQL to a centralized SQL Database. EDUCATION

Regional Maritime University

Ghana

Personal Safety and Social Responsibilities

Contact this candidate