Post Job Free
Sign in

Business Intelligence Power Bi

Location:
Newark, NJ
Posted:
September 24, 2024

Contact this candidate

Resume:

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),

732-***-****



Contact this candidate