Charles Ofosu Appiah
Bronx,USA
Summary
Professional with strong background in transforming data into actionable insights. Adept at utilizing advanced analytical tools and techniques to drive business growth and efficiency. Known for fostering team collaboration and consistently delivering results in dynamic environments. Skilled in data visualization, SQL, and statistical analysis, while maintaining flexible approach to evolving project requirements.
Overview
5
5
years of professional experience
Work History
Business Intelligence Analyst
Memorial Sloan Kettering Hospital Center
New York, NY
01.2023 - Current
- Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
- Designed customized data collection models for specific visualization tasks.
- Participated actively in stakeholder meetings, presenting data-driven insights and recommendations to support business growth initiatives.
- Standardized best practices in report generation across departments to ensure consistency in presentation formats as well as analysis methodologies employed.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Facilitated seamless integration of disparate data sources into cohesive analytical frameworks for comprehensive reporting purposes.
Sr Information Analyst
University Rochester
Rochester, NY
01.2022 - 05.2023
- Maximized resource utilization by efficiently allocating tasks according to each analyst''s strengths, ensuring optimal outcomes across all projects.
- Streamlined reporting processes for improved efficiency and reduced turnaround time.
- Spearheaded initiatives aimed at improving operational efficiency through automation and process redesign efforts.
- Collaborated with cross-functional teams to identify data requirements and develop innovative solutions for complex problems.
- Proactively identified potential bottlenecks in workflows, implementing corrective measures to mitigate any negative impact on productivity levels.
- Mentored junior analysts, promoting a culture of continuous learning and professional development within the team.
- Developed customized analytical tools to provide accurate insights into business performance.
- Enhanced data accuracy by conducting thorough analysis and validation of information systems.
- Leveraged advanced data visualization techniques to communicate complex concepts effectively to stakeholders at all levels of the organization.
Data Analyst
Department of Health and Mental Hygiene
New York, NY
01.2021 - 01.2022
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools to effectively communicate business insights.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Used statistical methods to analyze data and generate useful business reports.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Enhanced business efficiency by identifying trends and patterns in complex datasets.
- Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Streamlined reporting processes, resulting in faster turnaround times for monthly performance reports.
Education
Master of Science - Data Analytics
Eastern University
PASkills
- Data manipulation using SQL
- Dashboard design expertise
- Proficient in Python programming
- Experienced with Tableau data visualization
- Data analysis and visualization
- Advanced analytics for large datasets
- Expertise in advanced Excel functions
- Data analysis
- Hadoop ecosystem
- ETL process design
- R programming proficiency
- Custom reporting
- KPI monitoring
- NoSQL databases
- SAS programming
- Dashboard creation
- Analytical skills in finance
- Tableau
Languages
English
Full Professional
Software
Python, R, SQL, Tableau, Excel, Power BI
Timeline
Business Intelligence Analyst
Memorial Sloan Kettering Hospital Center
01.2023 - Current
Sr Information Analyst
University Rochester
01.2022 - 05.2023
Data Analyst
Department of Health and Mental Hygiene
01.2021 - 01.2022
Master of Science - Data Analytics
Eastern University