Business System Analyst with experience working in Information Technology, Banking and Retail sector.I am experienced in Tableau, SQL, and Power BI, Azure and snowflake cloud computing, Oracle, Python, Power Point, MS Access, MS Word, JIRA, Strategic Planning, Data Analysis, Data Modeling, and Database Administration.
Lpl Financial
-
Tableau Server AdminLpl Financial May 2022 - PresentBoston, Massachusetts, United States● Developed executive dashboards (scratch) and maintained dashboard used by analysts to improve performance and derive deep insights after gathering requirements. ● Wrote and tuned SQL queries that were used to create database objects like Views, Stored Proc, and functions.● Leveraged SQL to perform extensive and detailed data analysis, data validation, and data mapping to help identify patterns in the data, the structure of the data, and data quality.● Build and published standardized data sources to Tableau server by performing several data cleaning operations using ETL tools such as Alteryx, SSIS and stored procedures to transform raw data from different data sources into insightful analytics. ● Leveraged complex workarounds, advanced features, and customized charts to meet user’s requirements.● Redesigned complex reports and dashboard from other tools such as PowerPoint, and PowerPivot into Tableau and Power BI.● Create design documents, requirement documents, user manuals, mapping documents, and other project documents.● Managed Tableau Server for a mid – sized organization, overseeing user access, permissions, and security.● Optimized Tableau Server performance by implementing caching strategies and optimizing data extract refresh schedules.
-
Tableau DeveloperChase Bank Nov 2019 - Apr 2022New York, United States● Designed and enhanced clean dashboard after meeting with business users. ● Leveraged advanced features like Parameter Actions, Filter Actions, and Web (URL) Actions to integrate other systems with Tableau and provide drill down capabilities.● Utilized Tableau to design, develop, enhance, and support visualizations including highly interactive dashboards, scorecards, and reports with drill down capabilities, and analysis pathways. ● Worked in collaboration with business users, business analyst, project leaders, and other business leaders to gather requirements and build wireframes.● Developed Tableau dashboard with complex workarounds to meet complex business requirements.● Expertly utilized SQL to perform data validation, data mapping, data discovery, data profiling, and data mining by leveraging and creating database objects like Views, Materialized Views, Stored Procedures, and advanced features like CTEs and Temp Tables.● Create design documents, requirement documents, user manuals, mapping documents, and other project documents.● Troubleshoot and resolved Tableau workbook issues, addressing data inconsistencies, and improving performance.● Troubleshoot and resolved Tableau Server issues, including performance optimization, connectivity, and authentication errors
-
Tableau DeveloperEbay Jul 2017 - Sep 2019Draper, Utah, United States● Comfortably addressed questions from senior managers and other stakeholders regarding reporting needs, Tableau, and data analysis in general. ● Effectively combined data from multiple sources using ETL tools (Alteryx, SSIS, and Tableau Prep), Blending, Joins, and Relationship (Noddle) to provide rich analytics and meaningful insights. ● Leveraged SQL for extensive data analysis, file comparison, data profiling, and data mining.● Build database objects such as Stored Procedures, Functions, Materialized Views, Views, and Tables to be used as data sources for reporting needed.● Created relevant project documents such as Requirement Documents, User Manuals, Mapping Documents, and Gap Analysis.● Effectively Collaborated with SMEs, Directors, and business-side stakeholders to develop KPIs and reports and ensure performance and risk mitigation.● S successfully tuned many Tableau and Power BI dashboards, as well as SQL queries and Alteryx workflow. -
Tableau / Sql DeveloperFifth Third Bank Feb 2016 - Jun 2017Cincinnati, Ohio, United States● Developed ad-hoc queries and reports for after querying database using CTEs, Sub-queries, complex joins, and Temp Tables ● Heavily involved in the establishment and enforcement of standards for development, documentation, and deployment of dashboard and reports.● Identified and worked closely with critical stakeholders to understand their data needs and use cases.● Translated requirements into mapping documents, reports, and interactive dashboards. ● Designed interactive dashboards in Excel from data generated from complex SQL queries and Stored proc.● Designed automated ETL process in SSIS and Alteryx● Optimized SQL queries and Alteryx workflows
Charles O. Education Details
-
Computer Science
Frequently Asked Questions about Charles O.
What company does Charles O. work for?
Charles O. works for Lpl Financial
What is Charles O.'s role at the current company?
Charles O.'s current role is Tableau Server Admin..
What schools did Charles O. attend?
Charles O. attended University Of Ghana.
Not the Charles O. you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial