Data Analyst Business Intelligence

LINDA OSAFO

Severn, MD *****

240-***-**** - ad5x78@r.postjobfree.com

WEBSITES, PORTFOLIOS, PROFILES

https://linkedin.com/linda-o-mba-

https://public.tableau.com/app/profile/linda.osafo.agyei PROFESSIONAL SUMMARY

Data Analyst / Certified Tableau Desktop Specialist experienced in evaluating business needs to support key business goals. Five plus years of hands-on experience in Big Data Analytics, business intelligence, advanced analytics and data visualization. Proficient in qualitative and quantitative data analysis and performance analytics to enhance business results and decision-making.

SKILLS

Tableau Desktop Specialist /Tableau

Server Admin

MySQL

Data Quality Management

Hadoop (Hive, Impala)

PostgreSQL

Data Management(GDPR,CCPA)

MS Excel (Pivot Tables, VLOOKUP,)

Usability Testing (UAT)

Data Integration

Toad Data Point

Relational Databases

Power BI

Snowflake

Salesforce

SDLC

MySQL

Jira

Data Visualization and Presentations

Confluence

WORK HISTORY

01/2024 to 05/2024 Data Analyst

City National Bank -(Inspyr Solutions) – Remote

Developed tables and cleaned data using SQL for MRA reporting. Developed Tableau reports for Clients Onboarding, maintained and enhance dashboards and data in Snowflake.

Automated reports for efficiency and accuracy.

Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.

Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.

Enhanced business efficiency by identifying trends and patterns in complex datasets.

Created, maintained and updated Jira tickets on various tasks. Streamlined data processing for faster results by implementing advanced analytics tools.

Trained junior analysts on best practices, improving overall team performance and productivity.

Improved decision-making processes with accurate data analysis and visualization techniques.

Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.

07/2022 to 12/2023 Sr Data Analyst

PNC Bank – Severn, MD

Developed and maintained routine and ad-hoc dashboards using Tableau. Initiated and led project on server clean-up to enhance performance. Extracted large datasets from databases such as PostgreSQL, Oracle for other lines of business within the bank.

Integrated data from PostgreSQL tables and other sources into Hadoop tables for easy access and reporting for functional teams.

Provided analytics support for lines of business.

Tableau server administrator managing sites, projects, users, groups, roles and permissions.

Managed Tableau Server health for optimal performance. Subject Matter Expert for Tableau users providing user support in the bank. Extracted and interpreted data patterns to translate findings into actionable outcomes.

Identified, analyzed and interpreted trends or patterns in complex data sets. Created and automated data visualizations to present insights and tell compelling stories.

Coordinated weekly meetings for updates on various projects with other teams . Performed UI testing of various platforms after failover event. Extracted data from databases based on client request in line with GDPR and CCPA regulations.

Developed procedure for Tableau License give back to mop up unused and inactive licenses.

Interpreted data and translated ad hoc requirements and requests to deliver relevant and impactful results for other lines of business. Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

Participated in requirements meetings and data mapping sessions to understand business needs.

Analyzed and set up project for clean up of stale contents on servers. Produced monthly reports using advanced Excel spreadsheet functions. 05/2022 to 08/2022 Sr. Business Intelligence Analyst Marketpro Homebuyers – Rockville, MD

Developed intelligence-sharing dashboards, providing company-wide access to collected data.

Developed periodic reports from scratch connecting to multiple data sources and other prototype dashboards.

Maintained proficiency with latest database technologies especially in Tableau. Designed customized data collection models for specific visualization tasks and played key role development of Data Warehouse ( AWS Athena S3). Checked Tableau platform health and dashboard performance on server. Build various reports in Salesforce and visualized in Tableau. Integrated BI assets into customer relationship management tasks for Internal Sales Agents.

Provided analysis in areas such as KPI performance against goals, sales operations, forecast accuracy, segmentation, resource allocation and customer service. Partnered with Sales Field stakeholders to collect, document, and analyze business requirements and translating into tangible reporting and system deliverables with clearly defined acceptance criterion

Identified data sources that that will support reporting requirements and managing integration workflows to source, transform and load data into consumable datasets for reporting and analysis

Implement data quality processes to ensure integrity and accuracy of data sources and reports by leveraging automation and monitoring capabilities to proactively identify anomalies

Assisted members of analytics team and business stakeholders with ad-hoc and self-service reporting capabilities

Helped leadership identify business process efficiency/improvements Provided training and support to end users to facilitate change management efforts and to drive adoption of report and dashboard solutions through cross functional collaboration and coordination of activities.

Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes. Optimized system and platform performance capabilities in most efficient, practical way possible.

Created workflow diagrams to clearly demonstrate processes and timelines. Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.

Created data analysis tools to allow teams to query acquired information for unique details.

05/2019 to 03/2022 Tableau Developer

Bank Of America

Presented valuable insights generated from complex data set analysis through visualization techniques.

Involved in reviewing business requirements and analyzing data sources from Excel, SQL Server for design, development and analysis projects within Tableau. Designed and built data structures that allow trend tracking of data sources over time.

Developed Data flows that prepare data for use in reporting and visualization in Tableau.

Developed Data flows that prepare data for use in reporting and visualization in Tableau.

Prepared dashboards using calculated fields for different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau Desktop Published developed dashboards into Tableau Server and refreshed scheduled extract and tuned performance of dashboards.

Generate Key Performance Indicators (KPIs) for Market Leaders and departmental heads.

Utilized tableau to convert complex data into user-friendly visuals that are easy to understand for end users.

Translated business requirements into technical requirements. Analyzed business requirements and created functional requirements specifications to build and deploy solutions.

Interpreted data and translated ad hoc requirements and requests to deliver relevant and impactful results.

Developed and enhanced reports connecting to single or multiple data sources to improve performance.

EDUCATION

11/2013 MBA: Finance

University of Ghana - Legon, Accra

08/2009 Bachelor of Science: Banking & Finance

Central University College - Accra, Ghana

CERTIFICATIONS

Certified Tableau Desktop Specialist - No Expiration CompTIA Sec+ - Expiry 02/2025

Contact this candidate