Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Work Availability
Quote
Timeline
Hi, I’m

Serwah Tei

Data Analyst/Report Developer
Riverdale,US
Serwah Tei

Summary

Strategic and analytical professional with 5+ years of success in financial analysis and reporting. Talented in delivering advanced Excel and SQL reporting to plan, design, execute and evaluate report results. Highly adept in analyzing business needs using technical skills and BI tools to provide data and information analysis to achieve continuous improvement. Proficient in advanced R, Tableau, Power BI and ETL tools to produce data-driven reports. Expert in creating productive data visualizations and reports.

Overview

4
years of professional experience
1
Certification

Work History

AARP Foundation

Data Analyst'/Report Developer
04.2022 - 12.2022

Job overview

  • Developed Microsoft SQL Queries and procedures
  • Created SQL Queries with Microsoft SQL Server from scratch to build visualizations in Tableau
  • Wrote Queries for business intelligence reporting as needed
  • Created interactive, filters and interactive data visualizations with Tableau
  • Managed guidelines for calculations for metrics and analysis.
  • Designed and created tables in SQL, for analysis
  • Created Custom Reports and performed database maintenance tasks
  • Enhanced and improved existing workbooks in Tableau, created action filters and navigations for more interactive, insightful, and productive dashboards
  • Adjusted Queries in Microsoft SQL Server and PostgreSQL exported saved data outputs from Excel and PostgreSQL into Microsoft
  • SQL Server and Tableau as needed for analysis
  • Experience working with Salesforce, Springboard and Qualtrics, creating new Campaigns and locating Campaign IDS to transform raw excel data and normalize it for ETL database records
  • Transformed Dashboard documentation and information pages with Tableau Visualization software as needed
  • Made frequent suggestions to improve the information access and results of various workbooks
  • Key achievements include redesigning national and state workbooks, creating filters, calculated fields and other enhancements needed for more easy access of key information and metrics
  • Developed new methodologies for evaluating data and identifying trends in consumer behavior
  • Worked monthly on offline files in Excel for advocacy call to actions and various health concerns for the retired
  • Transformed and prepped raw Excel files data to get them in the right format for extract loading
  • Prepared and maintained documentation for critical reporting functions, processes and data sources
  • Reviewed data from internal or external sources to identify problems or opportunities for improvement
  • Checked source data to verify completeness and accuracy
  • Providing expertise in data storage structures, data mining and data cleansing as well as normalizing data
  • Translating numbers and metrics to enhance and inform strategic business decisions
  • Created graphical representations of data to support decision-making processes within the organization
  • Coming up with suggestions and solutions to costly business problems.
  • Enhanced data integrity by applying meticulous attention to detail when reviewing and analyzing data maintenance processes.

Blue Cross Blue Shield

Sr Data Analyst/BI Developer
11.2021 - 02.2022

Job overview

  • Created interactive dashboards as wells as visually appealing and informative dashboards with Power BI
  • Normalized and Cleaned Raw Data in Power Query before loading (ETL)
  • Built relationships and data models in the backend for adequate and best performance for visualizations in Power BI
  • Identified Key Performance Indicators (KPI's) with Power BI to help business achieve and fulfil their objectives
  • Reviewed Alteryx Workflows for enhancements
  • Worked on Gap Analysis and adjustments in Tableau
  • Worked with Teradata SQL, with exporting large existing queries into Tableau as needed
  • Performed and created DAX queries and basic measures using Power BI Tools
  • Documented specifications for business intelligence or information technology reports and dashboards
  • Designed and mapped data models to transform raw data into meaningful insights
  • Performed SQL Querying in Microsoft SQL Server for better results in visualizations
  • Sliced and diced data in Power BI, created filters and slicers as needed for best productive visualizations in Power BI.
  • Created and automated data visualizations to present insights and tell compelling stories.
  • Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.

Perkin Elmer

Associate Scientific Services Specialist
12.2019 - 09.2021

Job overview

  • Examined the company's training methods and made changes to address issues, improve efficiency, and achieve training objectives, resulting in [Good Inventory lab performances]
  • Properly allocated resources, budgets, inventories, training support, and team-building materials to increase overall productivity
  • Environmental feasibility study for manufacturing investment projects
  • Followed company guidelines and OSHA regulations on use of protective gear and safe operation of work equipment
  • Operated dishwashers, autoclaves, pH meters, scales and mixers
  • Sterilized equipment and supplies using germicides and autoclaves to protect patients and staff from infection
  • Maintained compliance with established company standards, safety procedures and regulatory requirements
  • Completed Autoclave ticket requests for various chemicals and broth media for scientists from six labs, as needed including downstream and upstream labs
  • Updated daily logs with accurate and timely Glassware metrics information
  • Assisted in chemical inventory 3 times a year, kept a record/excel spreadsheet of all chemical count in labs excluding expired chemicals
  • Worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services
  • Juggled multiple projects and tasks to ensure high quality and timely delivery
  • Provided excellent service and attention to customers when face-to-face or through phone conversations.

Glass, Thermofisher Scientific

wash/Autoclaving-lab assistant
07.2019 - 12.2019

Job overview

  • Oversaw the quality assurance program, which included on-site assessments, internal audits, and customer surveys
  • Had an excellent attendance record and was always on time for work
  • Kept an eye on the linen cart to make sure it was tidy and well-organized
  • Operated Glassware wash and Autoclave machines daily
  • Ran the whole lab daily, was in charge of glassware pick up for six labs including downstream and upstream labs
  • Assisted Scientists in autoclaving requests as needed
  • Kept track of all metrics for lab glassware activities in excel and created inventory reports quarterly with work partners.

National Academy of Sciences

Administration Coordinator
01.2019 - 12.2019

Job overview

  • Set up efficient workflow processes, tracked daily productivity, and made changes to improve the overall effectiveness of personnel and activities
  • Gathered and analyzed administrative cost data in order to prepare [Timeframe] budgets for corporate management
  • Was in charge of the supervisor's schedule and appointments, as well as streamlining the scheduling process
  • Provided expert clerical support by handling a wide range of routine and special requests efficiently
  • Created and updated work schedules to accommodate changing staffing levels and workload expectations
  • Organized physical files and digitized records so that authorized team members could update and retrieve them quickly
  • Increased customer satisfaction by using superior conflict resolution and problem-solving abilities
  • Assisted in creating badges for award members and greeting clients upon arrival
  • Was in charge of creating power point presentations for the membership program and USB copies
  • Certified Tableau Publisher- AARP
  • Honor Society Organization - Academic Excellence Achievement award
  • What is Data Science ?- IBM Coursera
  • Certificate of Completion - Aug 2022
  • Certificate of Completion - Tableau Desktop
  • Specialist Exam Prep 2022 - Achieved April 2022.
  • Assisted management with special projects to complete all tasks by deadlines.
  • Coordinated and scheduled meetings and appointments to keep organization running smoothly.
  • Created presentations and other materials to support organizational activities.

Education

New England College
Henniker, NH

Master of Science
2024

University Overview

GPA: 4.0

Temple University
Philadelphia, PA

Bachelor of Arts from Data Science
2012

University Overview

Skills

  • Data Visualization
  • Document Organization
  • Dashboard Creation
  • Excellent Communication
  • JIRA
  • SQL
  • Tableau
  • Alteryx Designer
  • Power BI
  • R Programming Language
  • Microsoft Excel
  • Data Analysis/Transformation
  • Data Mining

Accomplishments

Accomplishments
  • CERTIFICATIONS

Certification

  • Certificate of Completion - What is Data Science? - IBM(Coursera)
  • Certified Tableau Publisher - April 2022

Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins

Timeline

Data Analyst'/Report Developer
AARP Foundation
04.2022 - 12.2022
Sr Data Analyst/BI Developer
Blue Cross Blue Shield
11.2021 - 02.2022
Associate Scientific Services Specialist
Perkin Elmer
12.2019 - 09.2021
wash/Autoclaving-lab assistant
Glass, Thermofisher Scientific
07.2019 - 12.2019
Administration Coordinator
National Academy of Sciences
01.2019 - 12.2019
New England College
Master of Science
Temple University
Bachelor of Arts from Data Science

Similar Profiles

CREATE PROFILE
Serwah TeiData Analyst/Report Developer