Albert Mensah Dallas, TX • 646-***-**** • ad10zb@r.postjobfree.com

Experienced Data Analyst

Detail-oriented and analytical professional with hands-on experience administering data-management systems, collecting, and analyzing data, and documenting reports.

Strong history of performing extensive statistical analysis of financial data and preparing narrative analysis; demonstrated talent to leverage exceptional communication skills to foster productive relationships.

Proven ability to adapt to new roles, tasks, applications, and environments, and conduct effective liaison with internal and external stakeholders.

TECHNICAL PROFICIENCIES

Platform & Tools: Windows, SQL, SAS and Oracle Database, Teradata, Tableau, AutoSys, R, Alteryx,

Professional Experience

Wells Fargo, Plano TX Lead Analytic Consultant (3/15/2021- 10/30/2023)

Perform data mining across disparate tools and data sources

Proactively identifying data trend and highlighting issues to the Senior Management team

Partner with Conduct Risk teams and other key stakeholders to identify and document reporting needs and partner with the Reporting Production team to develop ad hoc and recurring reports and dashboards.

Act as a conduct and complaints data expert covering specific topics.

Strong knowledge of SQL, data warehousing concepts, various data management systems

Implement various technologies to automate and streamline report generation and distribution.

Partner with oversight functions, including various compliance and risk groups, to provide insight for various management, executive and board-level reporting.

Performed data profiling and analysis of incoming data sources in scope for the MDM project and prepared reports of findings to share with MDM program and project team members. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.

Partner with data, analytic and governance teams to deliver “best in class” information.

Ensure the reports produced are accurate and timely.

Experience building partnerships, collaborating, and influencing at senior levels and across lines of business as well as with corporate partners.

Experience creating Business required documents for variety of projects.

Enforce Data Standards, Policies, and Processes.

Experience using Business Intelligence architecture and development skills, preferably Tableau.

Extensive knowledge and understanding of research, reporting and analysis

Experience working in a risk management or compliance function

Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for various projects.

Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.

Experience using advanced excel skills such as Functions, Advanced Formula, VLOOKUP, PIVOT Tables

Created & manage technical system procedure documentation & ensure it is updated and current in Salesforce

Signature Consultants – Bank of America, Richardson TX Data Consultant III(10/2019-10/2020)

Working closely with key stakeholders to understand business needs and define requirements.

Experience creating Business required documents for variety of projects.

Developing and delivering data analytics and reporting capabilities that allow for multiple reporting uses including scheduled, prescriptive reports as well as ad hoc queries.

Strong knowledge of SQL, data warehousing concepts, various data management systems

Completing data analytics that will be used to guide business decisions, interpreting analysis into strategic and tactical recommendation, and presenting results in a professional/compelling manner.

Documenting process and training end users on reporting/analytics tools. Design and develop ETL workflows and datasets in Alteryx.

Preparing Dashboards using calculations, parameters in Tableau. Developed data mappings and workflows in Alteryx to extract data files used as source for various Tableau reports.

Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for various projects.

Worked on JIRA for tracking and updating the JIRA tickets and per assigned.

Performed quality review and validation of SAS programs generated by other SAS programmers. Followed good programming practices and adequately documented programs.

Strong knowledge of SQL, data warehousing concepts, various data management systems

Performed data profiling and analysis of incoming data sources in scope for the MDM project and prepare reports of findings to share with MDM program and project team members. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.

Worked with a list of assigned clients to manage their data conversion project to completion.

Research and analyze operational and compliance data, reports, and performance metrics.

Assist with the development of Compliance MI metrics, such as Key Risk Indicators (KRIs) and Key Performance Indicators (KPIs)

Independently complete software conversions, including data mapping, data analysis, data conversion including follow up work.

Extensive knowledge in various reporting objects like Hierarchies, Filters, calculated fields, Sets, Groups and Parameters etc., in Tableau

Experience with developing and implement procedures that enhance the performance of the Kafka platform.

Maintained and develop ETL specifications for healthcare business and clinical users.

Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT

Experience using advanced excel skills such as Functions, Advanced Formula, VLOOKUP, PIVOT Tables .

Pyramid Consulting – Southwest Airlines, Dallas, TX Cass Analyst /Data Analyst (01/2019-05/2019)

Maintain and continually develop data collection/input system for CASS using the root cause analysis process.

Experience designing and developing Tableau reports and dashboards for data visualization.

Compilation of data for and timely issuance of, CASS reports, agendas and minutes to company personnel and FAA.

Interface with maintenance, operational and reliability departments to determine root cause of system deficiencies of

Utilize available applications/tools to develop adhoc/automated reporting for all levels of the organization.

Demonstrate a solid understanding of Data Quality concepts and practices for profiling, quantifying, and managing data quality.

Developing and Built Tableau reports and dashboards for data visualization.

Conduct analysis of operational, quality audit(s), investigation(s) and safety data to present trends, assess risk, and provide mitigation recommendations to management through MDAG.

Interfaces with audit departments to identify and prioritize audit areas using risk assessment methods.

Responsible for the Company's Security and Safety Management System (SMS) and associated Safety Risk

Created and monitored projects on Jira.

Prepared scripts to ensure proper data access, manipulation, and reporting functions with R programming languages.

Willis Towers, Watson, Dallas, TX Associate (5/2018 –01/2019)

Drove data management functions, while ensuring compliance to standards for documentation by liaising with base team. Configured systems on ad-hoc basis and created test plans and tested system improvements to optimize efficiency. Oversaw databases to process metadata files for multiple projects. Built Tableau dashboards for measures with forecast, trend line, and reference lines, and undertook SQL Query tuning; provided tuning recommendations to ERP jobs.

Key Achievements:

Built interactive dashboards for clients to increase revenue for fiscal year 2019.

Discovered patterns and delivered actionable insights by leveraging SQL and analysis of large data sets.

Design and develop ETL workflows and datasets in Alteryx.

Worked on JIRA for tracking and updating the JIRA tickets and per assigned.

Analyze, design, optimize and enhance EDI applications in various formats that include HIPAA standard formats such as Electronic Data Interchange (EDI) 278, 834, 837 and other proprietary formats.

Design mappings (extracting, transforming, and loading data) and ETL transformations from a variety of data formats like JSON, XML, BSON, CSV, TXT, HL7 and EDI and structure into enterprise-scale databases.

Experience of ETL tools, data conversion and migration of large-scale data between systems

Designed, created, and maintained DB2 database objects.

Working experience of healthcare claims data, Medicare data, etc.

Strong experience of SQL, data warehousing concepts, various data management systems

Proficient in Microsoft Excel. Utilized paid RX data to perform a series of Reviews ranging from the Dr. who wrote the RX, to the Pharmacy who filled the RX to the PBM who processed the RX, to the Patient who used the RX.

Preparing Pharmacy Claims Data that is essential for Rebate Reviews and prospective Rebate Consulting.

Worked with business management to identify, formulate, and implement compliance risk policies, procedures, and controls.

Prepared scripts to ensure proper data access, manipulation, and reporting functions with R programming languages.

UnifyHR LLC, Irving, TX EDI/ Data Analyst (10/2016 –3/2018)

Steered full-scope data analysis tasks, including writing SQL queries to retrieve, consolidate, and present results, as well as providing second-level quality reviews of acquired data in all reports. Processed and maintained incoming and outgoing data files, while evaluating current processes and recommending improvements to streamline operations. Provided quality support with research, problem solving, root cause analysis, and ongoing technical support. Ascertained and proposed remediation for recurring data quality issues.

Key Achievements:

Provided on-going technical support to client service team to decrease turnover time to 25%.

Created and deployed program reports for assigned client-base regarding ACA (Affordable Care Act).

Used Teradata to manage large data warehousing operations. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.

Extensive knowledge in various reporting objects like Hierarchies, Filters, calculated fields, Sets, Groups and Parameters etc., in Tableau

Analyze, design, optimize and enhance EDI applications in various formats that include HIPAA standard formats such as Electronic Data Interchange (EDI) 278, 834, 837 and other proprietary formats.

Transferring of files using SFTP and FTP

Working experience of healthcare claims data, Medicare data, Provider Data etc.

Education and Training

Southern New Hampshire University, Manchester, NH Master of Science in Data Analytics (10/2019)

Baruch College, New York, NY Bachelor of Arts in Mathematics

Contact this candidate