JOSEPHINE EFFAH

ad3ntj@r.postjobfree.com https://www.linkedin.com/in/jossy-effah

NJ

Summary

I am a professional Business intelligence developer with 6 years of experience using Microsoft SQL server, Tableau, Power BI & other related tools and technology to analyze and visualize large Data.

I currently work with MACY’S INC as a Lead developer, my role is to collaborate with clients and company officials to identify data analytic needs by gathering requirements, bringing Data to live through visualization to strategically enhance performance across all angles within the organization. I am driven to optimize Data through visual reports and tools by creating meaningful dashboards that meet expectations. With my experience in ETL I am able and makes sure to extract, cleanse and transform raw Data before loading it on Tableau to visualize it.

In the process of data integration I do all joins and unions when the need be. Validation & Data functionality is one of my key priority with the help of SQL as well as Google Big Query etc. I'm dedicated to improving business economy by revealing excellent KPI's, patterns, trends and forecasts. As an accomplished and motivated professional, I was compelled to contact you with my interest in the Tableau Developer opportunity with your company. I offer an extensive background of success in this field, along with the qualifications required for this role. I love my job as a Developer and I put in my very best.

Skills

TABLEAU DESKTOP

POWER BI DESKTOP

REPORT WRITING SKILLS

SQL

TABLEAU SERVER ADMIN

ALTERYX ETL

DATA ANALYTICS

AGILE/JIRA

SNOW FLAKE

SALES FORCE

GOOGLE BIG QUERY

Experience

MACY’S INC,

HERALD SQ, NEW YORK

LEAD TABLEAU DEVELOPER

03/2022 - Current

Effective requirements gathering process through evaluations, questioners, feasibility studies, customer reviews,research etc.

Evaluate the needs and requirements of the users and provides technical, structural and organizational specifications. Determines appropriateness of Data and optimum storage. Schedule refreshes for workbooks to run efficiently without failing.

Retrieves Data from multiple data sources, transform, structure it for specific tasks.

Builds interactive dashboard that answers Key Business Questions using Tableau desktop with functions like Action filter and parameters

Responsible for Tableau administration, including User provisioning, granting access to Users, workbooks, moving archived, decommissioned and deleting stale workbooks, add groups, revoke access etc. Server management, License administration and Version upgrades.

Ensures standards and best practices are established and met for consistent and accuracy of Tableau across the company.

Schedule Data Extracts on daily basis. Creates visual presentations of categories and relationships to Users, Marketers, etc using Tableau dashboards to highlight desired aspects of key financial and performance indicators.

Using Control M to run and manage applications at the deployment stage to prioritize Datasource refreshes to avoid delays in workbooks loadings.

Resolve end user reporting problems through collaboration and communicating with IT Engineers and Operation Analyst in QA environments for proper validation and functionality testing.

ENVIRONMENT: Windows XP,

Alteryx, Windows 7, Tableau, Tableau Server, SQL, MS-SQL 2008 R2, MS-Access. Mac OS, Excel etc

BRANDYWINE REHABILITATION

OCEAN TOWNSHIP,

DATA DEVELOPER

SPECIALIST

02/2020- 02/2022

Working with team of developers to design, develop and implement a Business Intelligence solution for Sales, Products, supplies and customer performance through KPI’s. And to ensure proper configuration management and change controls are implemented for BI Data Marts and Reports.

Creates Data models that ensure peak performance, integrate Business Intelligence tools with various technologies like Sql server, Hadoop etc.

Developed a 360-business dashboard with multiple panels and parameters that became a favorite sales tool for most of the sales and marketing force in the company.

Developed Tableau workbook to perform year over year, quarter to quarter, YTD, QTD, and MTD type of analysis for every fiscal year

Created and deployed dashboards to UAT/ QA for testing. Reshaping old dashboards and repointing data sources for workbook auditing transformations and house keeping.

Fine tuned SQL queries for maximum efficiency and performance.

Created Drill-down and Sub-Report and also monitored the performance of the Reports.

Generated Dashboards with filters, Parameters and sets to handle views more efficiently.

Managed large sets of Data corresponding to units; using SQL to reveal the schema and Data sets within the database Table name. Also validate for accuracy before sharing reports with Users and derive desired results for a particular visualization.

PNC BANK MATAWAN, NJ

BUSINESS INTELLIGENCE ANALYST/DEVELOPER

01/2018- 02/2020

Extract raw data, transform and load it. Models charts with Dax expressions.

Builds visualizations with meaningful dashboards based on business requirements with Power BI.

Performing remarkable joins and unions on Data sets. Schedules refresh in the service to optimize Data

Collaborated with team of designers in Agile environment for project evaluation.

Optimized data gathering processes, analysis procedures and visualization strategies.

Developed, tested and deployed standard reports and dashboards based on business requirements and document specifications.

Using AWS to run and manage applications. (s3) function for storage, upload and sharing of files plus using RDS to manage Database.

Education and Training

TABLEAU SPECIALIST CERTIFICATION

KUMASI TECHNICAL UNIVERSITY KUMASI, GH

BACHELOR OF SCIENCE IN COMPUTER& STATISTICS

Sep 2013 – May 2017

References

RASHEED BATONG (PROJECT MANAGER)

Tel ..615-***-****

MR. WILLIAMS OBENG (SUPERVISOR)

Tel..732-***-****

Contact this candidate