Dellali Kwadwo Ayivie

Email: adyp2z@r.postjobfree.com Phone: +1-347-***-****

PROFESSIONAL SUMMARY

Data / Business Analyst; 5 years consulting to retail banks, Health service and retail markets, specializing in Data Analysis, Data Extraction, Data Manipulation, Research & Reporting using tools like Tableau.

Lead business analysis, data analysis and project management tasks to deliver projects.

Extensive data validation, writing complex SQL queries, resolving data quality issues.

Excellent communicator and team player, proven ability to learn quickly, utilize in-house databases and systems to maintain strategic vision of the organization.

Strong time management, organizational and multi-tasking skills to meet demanding deadlines and the ability to find innovative ways to resolve problems.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2012, MySQL 5.2, 5.7, Oracle 10g, 11g

Querying Tools: SQL Management Studio 2008/2012, SQL Plus, SQL Developer (2014 version)

Business Intelligence Tools: Tableau 9.2, 9.3, 10.4, 2019.2, Excel and PowerPivot

Cloud Computing: Financial Service Cloud (FSC), Salesforce, Snowflakes

EXPERIENCE

Fulton Bank Lancaster November 2021- To date

Universal Banker/ Snr. Data Analyst

Responsibilities

Improving customer experience at the forefront of every initiative interaction and all requirement are customer focused. has an ability to convert both functional and technical requirements unto user stories for development

Lead the research, planning, designing, developing and deploying of various application systems. Design and modification of existing systems, ensuring components work together for the flow of data generating expected outcomes.

Generate adhoc report from existing databases and providing ongoing technical assistance for data display by creating interactive visualization for operational and top management utilization. Performing ongoing data analysis and outcome measurement activity utilizing various tools including control charts, graphics as well as narrative analysis

Interact and communicates with other divisions and team mates within and outside organization (via Phone calls, Microsoft Teams, Webex, emails and other social media interaction platforms) to formulate solutions that meet ongoing business demands and present very memorable customer experience for our clients giving them a reason to always want to bank with us.

Collecting, prepare, modeling and analysis of structured and unstructured data used for major business initiative outcomes and transporting them into the Cloud. A strong understanding of cloud computing that helps recent technologies in data management.

Lead my team in periodic data and system testing routines involving monthly operating premise alarm testing audit, monthly treat audit for fire safety, robbery, bomb and many others. Daily audit on data quality and requirement gathering to ensure standardization in all areas of operation.

CyberBeyond Solutions New York November 2020- October 2021

BI Analyst /Tableau Analyst

Responsibilities

Strong analytical skills with the ability to collect, organize, analyze and disseminate significant amount of information with attention to details and accuracy

Perform and document analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in data warehouses.

Attending group meeting where the business will share ideas of what they`re trying to build and any business questions that need to be addressed via data visualization and reporting

Communicate outcomes of required task to client and work with the client team to design the proper checks to address the data quality issues.

Design and create data visualization (reports and dashboards) as required to support user stories, including UI/visualization aspects Excellent Communication skills.

Detailed understanding in developing, maintaining and managing Tableau driven dashboards and analytics

Ensuring solution meet business needs and requirements by testing and coordinating with testing group for high-quality implementation

Sam’s Club Maryland January, 2019– October 2020

Produce Supervisor/ Team Lead

Responsibilities:

Prepare annual and monthly budget, cost analysis, employee performance review and additional quarterly report.

Maintain proper communication with management staff on operations of cost center and innovative ideas to improve overall performance of club

Interact daily with customers, marketing products, managing complaints and accepting feedback.

Oversee administrative tasks, including bookkeeping, training, maintenance and other needs as they arise.

Ensuring that proper levels of inventory are kept daily, and products are properly displayed for the members on a daily basis before the start of business.

Oversight responsibility of divisional performance (cost vs. income expenditure) and identifying KPI to help monitor growth and to forecast future business performance

Consolidate Bank Accra, Ghana May, 2018– December, 2018

Data Analyst

Responsibilities:

Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Explain, Stats, Cast and volatile tables on SQL server

Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.

Connected Tableau server to publish dashboard to a central location for portal integration.

Created visualization for overall day-to-day performance and departmental contribution analysis.

Generate KPI’s for customer satisfaction survey results.

Maintain test log and test evaluation summary reports.

Developed data visualizations and dashboards in Excel.

Developed Pivot Charts such as pie chart, line chart, bar chart, and bubble chart for monthly metrics.

Maintains departmental metrics in accordance with goal plan

Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom

Implemented hierarchies in Tableau within Portfolio at high level, followed by application and project details.

Consolidate Bank Accra, Ghana August, 2015– October, 2017

Client Relationship Manager

Responsibilities:

Lead staff of 12+ personnel by implementing training, engaging in proactive problem solving and ensuring company compliance

Supporting the banks strong relationship banking culture through ongoing customer contact, quality customer service and superior product knowledge.

Worked at bank front counter to assist customers with various banking needs including deposits, withdrawal and balance checks

Adhere to all company standards to ensure that customers received optimal care and service whiles banking at our branch

Followed guidelines for detecting and reporting fraudulent transaction including theft and impersonation

Monitor all balances and deposit to ensure that all money in the bank is accounted for and proper procedures are followed at all times

Cross selling bank products to customers, generating various business leads resulting in opening various types of accounts and closing business deals resulting in the high profits for the bank.

Frequent portfolio reviews to identify weaknesses, trends and alert management to deteriorating portfolio conditions

EDUCATION

Omega Risk Management, Canada - Credit Risk & Project Management Certification

Kwame Nkrumah University of Science and Technology, Ghana— Masters in Business Administration

October 2014 - August 2016

University of Ghana, Legon — Bachelor of Science

August 2003 - September 2008

REFERENCE

Available upon request.

Contact this candidate