Louisa Adusah
Syracuse,NY
Summary
Driven by bottom line of any organization coupled with Core Technology skills to delivering exceptional services. Seeking a position as a Data Analyst/ Tableau Developer/Analyst; utilizing knowledge of relational database and Business Intelligence models to improve on efficiency and effectiveness of organization's IT functions towards achieving an ultimate goal. Skilled Tableau Developer with background in designing, developing and deploying interactive dashboards. Strong understanding of business requirements and translating them into effective visual reports. Strengths include excellent problem-solving abilities, strong knowledge of SQL, data modeling and ETL processes. In previous role, contributed to improved business decisions by providing insightful data visualization solutions.
Overview
5
5
years of professional experience
Work History
Tableau Developer
University of Rochester Medical Center
Rochester, NY
01.2024 - Current
- Migrated existing reports from other reporting tools into Tableau.
- Developed interactive drill down features across multiple levels of detail within dashboards.
- Researched new ways to visualize data in Tableau for enhanced presentation of results.
- Deployed Tableau Server security settings including authentication methods, permissions, row-level security settings.
- Analyzed complex datasets to identify trends and patterns.
- Implemented best practices for optimizing the performance of Tableau reports and dashboards.
- Created custom views, charts, graphs, filters, parameters, and data sources to meet specific user requirements.
- Provided technical support on existing dashboards and reports by troubleshooting issues related to data accuracy or report functionality.
- Analyzed large datasets to identify trends, patterns and correlations utilizing advanced analytics techniques in Tableau.
- Participated in design reviews to provide input on functional requirements, product designs, schedules, or potential problems.
- Managed the entire life cycle of projects from design and development through implementation and maintenance.
- Worked closely with BI teams to ensure that the right data is being extracted from source systems into the Data Warehouse layer for reporting purposes.
- Personally analyzed data sets collected over time to identify relevant patterns and trends, producing visual reports for presentation to appropriate personnel.
- Created visual representations of product categories and relationships, using Tableau dashboards to highlight desired aspects of key financial and performance indicators.
- Recommended improvements to facilitate team and project workflow.
- Assessed code during testing stage to determine potential glitches and bugs.
- Applied prescribed policies to programming syntax in compliance with internal language policies.
- Worked closely with systems analysts, engineers and programmers to understand limitations, develop capabilities and resolve software problems.
- Updated software upon release of vendor patches to mitigate vulnerabilities.
Data Analyst /Junior BI Developer
Amazon. (Swiftlearn IT Solutions)
Baltimore, MD
04.2021 - 12.2023
- Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.
- Leveraged multiple data sources like Oracle and MySQL during a project to construct dashboards using Tableau.
- Compiled extensive analytical data sets utilizing Excel.
- Performed SQL-based data extraction and adjustments aligned with business objectives.
- Leveraged Tableau Server for front-end BI tool and MS SQL Server 2012 as back-end database to design workbooks and dashboards.
- Administered user access controls on Tableau Server to ensure secure data handling.
- Facilitated portal integration by connecting the Tableau server.
- Designed and implemented database objects including tables, views, procedures, triggers, and functions using T-SQL.
- Formulated dashboards and worksheets using action filters, parameters and calculated sets in Tableau.
- Created Tableau workbooks by blending multiple data sources.
- Generate insightful Tableau dashboards for better decision-making.
Tableau Reports Developer Intern
Staples Inc. (Swiftlearn-IT-Solutions)
Framingham, MA
05.2020 - 04.2021
- Worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services.
- Prioritized and organized tasks to efficiently accomplish service goals.
- Maintained updated knowledge through continuing education and advanced training.
- Created and populated Customer data using advanced SQL and PL/SQL queries and scripts and also performed Teradata SQL performance tuning
- Performed drill down analysis reports using SQL Server Reporting Services
- Used Tableau server as a front-end BI tool and MS SQL Server 2012 as a back end database to design and develop workbooks, dashboards, global filter page, and complex parameters based calculations.
- Working with team of developers, designed, developed and implemented a BI solution for Sales, Product and Customer KPIs
- Create compelling dashboards using tableau dashboard and prepare user stories to deliver actionable insights
Tableau Reports Developer Intern
MC Auto parts Co. (Swiftlearn-IT-Solutions)
Baltimore, MD
12.2019 - 03.2020
- Working with team of developers, designed, developed and implemented a BI solution for Sales, Product and Customer KPIs.
- Created mappings using transformations like Source Qualifier, Aggregator, Filter, Update strategy, Joiner, Normalizer, Union, Store procedure and XML transformations
- Performed data migration between different environments and Third Party Databases
- Develop Tableau visualizations and dashboards using Tableau Desktop.
- Develop Tableau workbooks from numerous data sources using Data Blending.
- Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau.
Education
Bachelor of Information Technology -
University of Ghana
Legon GhanaSkills
- Data Analysis Proficiency
- Effective Conflict Resolution
- Cross-Cultural Understanding
- Skilled in Data Visualization Tools
- Data Quality Management
- Self-Motivated Professional
- Skilled in Cross-Level Collaboration
- Effective Time Management
TECHNICAL SKILLS
- Windows and Linux Expertise
- Database Management: MS SQL Server, Teradata, MySQL, Oracle
- Test Tools - HP Quick Test Professional 10/11, HP Quality Center 10
- Querying Tools - SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata PL/SQL
- Database Querying Proficiency
- Business Intelligence Tools Proficiency
- Mapping techniques
- Business intelligence
- Performance optimization
- Data storytelling
- Dashboard design
Languages
English
Professional
Languages
2
References
References available upon request.
Timeline
Tableau Developer
University of Rochester Medical Center
01.2024 - Current
Data Analyst /Junior BI Developer
Amazon. (Swiftlearn IT Solutions)
04.2021 - 12.2023
Tableau Reports Developer Intern
Staples Inc. (Swiftlearn-IT-Solutions)
05.2020 - 04.2021
Tableau Reports Developer Intern
MC Auto parts Co. (Swiftlearn-IT-Solutions)
12.2019 - 03.2020
Bachelor of Information Technology -
University of Ghana
Similar Profiles
Kaleb NegussieKaleb Negussie
Phlebotomist at University of Rochester Medical CenterPhlebotomist at University of Rochester Medical Center
Djai RazatDjai Razat
Financial Coordinator at University of Rochester Medical CenterFinancial Coordinator at University of Rochester Medical Center
HOLLY STINERHOLLY STINER
Supervisor, Academic Affairs at University of Rochester Medical CenterSupervisor, Academic Affairs at University of Rochester Medical Center
PRISCILLA R. REYNOLDSPRISCILLA R. REYNOLDS
Administrative Assistant (AA) at University of Rochester Medical CenterAdministrative Assistant (AA) at University of Rochester Medical Center
Michael BenzMichael Benz
Material Handler at Syracuse UniversityMaterial Handler at Syracuse University