JOSEPHINE EFFAH
*********@*****.*** 1-848-***-**** Tinton Falls, NJ 07712
Summary
I am a professional Business intelligence developer with 7 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; hoping to be a part of your Team soon.
Skills
TABLEAU DESKTOP
POWER BI DESKTOP
REPORT WRITING SKILLS
SQL
TABLEAU SERVER ADMIN
ALTERYX ETL
DATA ANALYTICS
AGILE/JIRA
MICRO STRATEGY
SNOW FLAKE
SALES FORCE
AWS
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 with stakeholders etc
Evaluate the needs and requirements of the users and provides technical, structural and organizational specifications
Determines appropriateness of Data and optimum storage, Data pipeline to streamline data sets accuracy
Schedule refreshes for workbooks to run efficiently without failing
Retrieves Data from multiple data sources, transform, structure it for specific tasks with help of SQL
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 Data source 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
KUMASI TECHNICAL UNIVERSITY KUMASI, GH
BACHELOR OF SCIENCE IN COMPUTER & STATISTICS
05/2017
Websites, Portfolios, Profiles
https://www.linkedin.com/in/jossy-effah
https://public.tableau.com/app/profile/josephine.effah/vizzes
References
RASHEED BATONG (PROJECT MANAGER), 615-***-****
MR. WILLIAMS OBENG (SUPERVISOR),