Kwadwo Amansie-Boateng

• Develop new and modifies/supports current cloud data warehousing infrastructure ( Microsoft Azure Data Factory), database programs, and ETL processes, with primary focus on enhancement of data
  integration, normalization and standardization for business intelligence and reporting.
• Build, manages and monitors data pipelines and ETL processes along with documentation and usage statistics/KPIs to improve processing performance, database capacity issues, data replication and other distributed data issues.
• Responsible for designing and building dashboards, alerts, and reports on both recurring and ad-hoc basis with our BI tools and platforms(Cognos Analytics). Develops reports as needed against multiple types of data sources.
• Develops, implements, and maintains new and existing data models within our BI tools and platforms for use ni report building and dashboard generation.
• Provides business analyst support by evaluating departmental procedures with the primary focus of recommending reporting solutions that will improve users ability to track and report data

SalesForce Administrator

• All aspects of user and license management including new user setup/deactivation, roles, profiles, permissions, public groups, sharing rules.
• Salesforce configuration changes, including (but not limited to): Flow, assignment rule Responsible for designing and building dashboards, alerts, and reports on both a recurring and ad-hoc basis in conjunction with our BI tools and platforms. Develops reports as needed against multiple types of data sources, approval processes, fields, page layouts, record types, dynamic layouts, apps, actions, custom settings, mobile administration.
• Responsible for designing and building dashboards, alerts, and reports on both a recurring and ad-hoc basis with our BI tools and platforms. Develops reports as needed against multiple types of data sources. Develops, implements, and maintains new and existing data models within our BI tools and platforms for use in report building and dashboard generation.
• Define priorities, work with stakeholders to provide
  accurate and actionable reports to grow admissions. Provides business analyst support by evaluating departmental
  procedures with the primary focus of recommending reporting solutions that will improve user's ability to track and report data, analyze trends and eliminate manual, labor intensive task
• Data management to improve Salesforce data quality, implementing rules and automation as needed
• Respond to User support tickets
• Monitor and improve user adoption
• New user and ongoing user training

• Monitor & measure the health of the business through identifying and deploying success metrics.
• Coordinate with Sales, Processing, Cultivation, and project management teams to forecast new products volume and to align plans with supply & production capacity also identify, analyze, and interpret trends or patterns in complex data sets.
• Develop and manage company-wide key performance indicators also used salesforce to improve retail and wholesale process
• Create dashboards for farm, wholesale, retail using Trifacta and Google data studio
• Improving data warehouse through adoption Big Query and the overall quality of data across all inventory platforms

• Designed and built machine learning models to predict asthma severity index by aggregating data from EPA, IQVIA and WTI sources, analyzing 10 years of time series data using SQL, Python, R, and Azure to predict demand for asthma related products.
• Optimized models with VIF, feature selection method using Python and decreased error rate by 21%.
• Created Dashboards and presented results, insights and recommendations with Tableau dashboards to senior management to reveal that air pollution and weather impact asthma severity index and that severity index levels can be predicted. Thus, the outcome can be used by Weather Trends International to predict sales for pharmaceuticals to manage with demand and inventory and optimize their overall sales operations.

• Conduct analysis of feedback from customers’ complaints, identify root causes of persistent complaints and recommend service improvement initiatives to forestall/minimize occurrence.
• Prepare periodic reports and dashboards, score cards and dash boards using Tableau and Qlik.
• Use trends and reports to identify service delivery and process gaps and recommend areas of improvements in service, process and product standards where appropriate.
• Conduct periodic customers’ survey and as directed by the bank’s management.
• Review service performance reports (dashboard, complaints, customer feedback, and internal reports) against service targets set and distil key service improvement areas to the stakeholders.
• Develop queries to retrieve data for analyses as well as Collect, validate and store all process and policy documents in a centrally accessible location i.e., the bank’s portal.