MERCY ELEH
Overview
9
9
years of professional experience
Work History
Sr Data Analyst / Tableau Developer
Fifth Third Bank
03.2023 - 01.2024
- Worked closely with senior managers, directors, business users and critical stakeholders to understand business directions, understand reporting needs, and produce effective, clean, well-turned, and actionable executive dashboards in Tableau and Power BI
- Analyzed requirements and data to determine suitability of data, discover patterns, and relevance of requirements in relationship to the overall business goals
- Created clean dashboards with good performance, strong security (using Row Level Security), and effective interactivity
- Expertly wrote SQL to reshape data, perform data discovery, data profiling, data validation, and to also create database objects such as stored procedures, functions, Views, Materialized Views, and Tables
- Enriched data by combining data from multiple sources by leveraging Joins, Relationships, Blending, and ETL Tools to create insightful dashboards
- Successfully increased the performance of Tableau and Power BI dashboards, Alteryx workflows, and SQL queries by leveraging best practices
- Created design documents, requirement documents, user manuals, and other project related documents.
Sr Data Analyst / Tableau Developer
Parkland Health
09.2021 - 01.2023
- Worked in an Agile, dynamic, and fast paced environment in collaboration with business users and other technical teams to create and maintain cutting-edge dashboards that provide technological solutions for business intelligence needs
- Developed clean and visually appealing data visualizations and dashboard for executive users for decision making
- Leveraged Tableau APIs (Python and JavaScript APIs) to automate and embed dashboards into other application systems to help provide an end-to-end solution for case management
- Utilized advanced SQL queries to perform analysis in Oracle and Hadoop for data validation, data profiling, data mining, creating Materialized Views, and Stored Procedures for reporting purposes
- Optimized and secured reports and queries using industry best practices and workaround
- Increased accuracy and reliability of reports, and saved 20 hours (weekly) by automating and migrating reports from Excel and PowerPoint into Tableau
- Enhanced high-performance by providing high-performance dashboards, with strong security by leveraging Tableau’s hybrid data security model, creating workarounds and customized charts
- Evaluated data models, designed data mapping, and performed data validations to ensure successful migration of data to cloud environments
- Participated in grooming stories, writing user stories, Scrum ceremonies, and the creation of documentation to ensure compliance with applicable rules and regulations.
Sr Data Analyst / Tableau Developer
Astoria Bank
10.2019 - 08.2021
- Proactively engaged business users to gather needed information, design reporting needs, and design technology solutions to promote decision-making based on facts
- Designed well-optimized data visualizations using Tableau and leveraged Pixel Perfect for to download data those visualization into PDF
- Successfully saved over 20 hours a week by migrating and automating static reports into Tableau by leveraging Tableau Python API and Tableau Server
- Capitalized on my entrepreneurial skills to build rapport with business users and work with other teams, enhancing our ability to collaborate and synergize
- Expertly met complex requirements by using advanced features in Tableau to design effective workarounds
- Successfully mined and analyzed data from different sources using complex joins, CTEs, Temp Tables, Dynamic SQL, UDFs, and Stored Procedures
- Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau
- Created user manuals, BRDs, FRDs, user stories, data flow diagrams, design documents, and data models using Word, Excel, ERWIN, PowerPoint, and Visio
Sr Data Analyst / Tableau Developer
SunTrust Bank
03.2018 - 10.2019
- Successfully worked with multiple sources, performed various LOD calculations, new dashboard development, troubleshooting the existing dashboards, and performance management
- Analyzed and assess requests to create a professional presentation, and quality deliverables in the form of dashboards & reports to provide additional insight into any critical indicators
- Trained end client users on Tableau by providing step-by-step guidance from basics to advanced functions in Tableau including working with calculations, parameters, and date functions
- Professionally established Tableau best practices in the creation and design of reports, developing SQL queries, and building advanced tableau dashboards
- Expertly resolved numerous performance challenges and implement best process distribution for 8+ projects, facilitating users in Tableau dashboard development
- Swiftly accomplished all tasks related to advance analysis actions, calculations (LODs), parameters, background images, maps, trend lines, and statistics
- Created groups, hierarchies, and data sets to develop summary levels and detailed reports
- Demonstrated experience and ability in working with business users to gather and document requirements and manage the scope
Sr Data Analyst / Tableau Developer
T-Mobile
07.2015 - 02.2018
- Delivered complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions
- Collaborated with various business stakeholders to understand their decision-making parameters, and analyze the available data to build Tableau dashboards
- Analyzed business requirements, performed data wrangling, data profiling, and Gap Analysis
- Interacted with the existing database team members and DBA to understand the existing schema
- Effectively coordinated and designed interactive dashboards with metrics and KPIs to ensure efficiency
- Successfully tuned several Tableau Dashboards and SQL queries to enhance user experience
- Skillfully involved in the design of policies to ensure High Availability of Tableau Server and good governance of self-service BI environment
Education
Bachelors of Science - Computer Science
Skills
- Technical Skills
- Tableau Desktop, Tableau Server, Alteryx, Python, Power BI, MS SQL Server, SSIS, SSRS, Visio, ERWIN, Advanced Excel
Additional Information
- About 9 years of experience working closely with senior VPs, directors, Project managers, and other technical teams to identify reporting needs, analyze requirements, determine the look and feel of reports, discuss wireframes, and provide expert recommendations regarding BI solutions. Around 9 years of experience designing, maintaining, and enhancing effective and interactive BI solutions utilizing Tableau, Power BI, Alteryx, SSRS, and Python Close to 8 years of experience using advanced features, tips, and tricks in BI and data analysis tools like Tableau, Power BI, SQL Server, Oracle, Hadoop, and Alteryx to automate reports, design high-performing dashboards and advanced security models (Row level security, authentications, and permissions) to enhance user’s experience. Expert level of experience using clean and visually appealing data visualization using Tableau, Power BI, and Pixel Perfect Over 7 years of leveraging advanced features in Tableau and Power BI to integrate dashboards with other applications and create workarounds as solutions for complex requirements and aggressive timelines. Around 9 years of expertly using advanced SQL features to write queries for data validation, ad-hoc analysis, data mining, data profiling, and data cleansing by leveraging Stored Procedures, UDFs, Materialized Views, Temp Tables, Snowflake, complex joins, Sub-Queries, Dynamic SQL, and CTEs Over 5 years of experience serving as a liaison with business users and technical/reporting teams, creating documents (BRD, FRD, User Stories, User Manuals, UML Diagrams), facilitating testing, and also presenting findings from thorough analysis to business leaders. Flexible and organized professional with the ability to work in on/offshore models, learn new technologies, and take on new tasks to help meet analytics need
Timeline
Sr Data Analyst / Tableau Developer
Fifth Third Bank
03.2023 - 01.2024
Sr Data Analyst / Tableau Developer
Parkland Health
09.2021 - 01.2023
Sr Data Analyst / Tableau Developer
Astoria Bank
10.2019 - 08.2021
Sr Data Analyst / Tableau Developer
SunTrust Bank
03.2018 - 10.2019
Sr Data Analyst / Tableau Developer
T-Mobile
07.2015 - 02.2018