| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate..PROFILESEDUCATIONMaster of ArtsEconomicsCentral Michigan University, MountPleasant, MIDec. 2020Bachelor of ScienceMathematical Science (Statistics)University for Developing Studies,Tamale, Ghana.May 2011CERTIFICATIONSSAS CertifiedSpecialist: BaseProgramming UsingSAS 9.4
Issued Aug 2020. (NoExpiration)Certified TableauDesktop Specialist:Issued July 2023. (NoExpiration)Atlanta Georgia, UnitedStates 30135PHONE NUMBER AVAILABLEEMAIL AVAILABLESHADRACK BENNSUMMARYA professional business intelligence developer with over 7+ years of experience in SQL and BI reporting tools such as Tableau, SSRS, SSIS. Currently seeking growth-oriented opportunities in Business intelligence in industries like Manufacturing, Health, Education, Logistics, Retail, Technology etc. Enthusiastic team player, dedicated to streamlining processes and efficiently resolving project issues with experience and understanding of SDLC.SKILLSAdvanced: SAS, SQL, SQL ServerIntegration Services (SSIS).Data Visualizations (Advanced):Tableau, Excel, SQL ServerReporting Services (SSRS), SAS.Data WarehousingETL DeveloperSDLCWarehouse Management System(WMS).Shipping Connects.EXPERIENCEDATA ANALYSTGlobadigm Consulting (Consultant) Saginaw, Michigan April. 2023 Present Utilizes SAS, and other software, to provide ad hoc reporting, tables and listings and graphs for clinical trial data, regulatory submissions, Risk-Based Monitoring, and publications. Utilizes data visualization tools, including Power BI and Tableau, to provide an easy-to-understand interface to end-users for quick identification of key themes within data. Demonstrates strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted. Developed and executed a data analysis solution for a financial services client that boosted customer retention. Per client requirement, I design and create reports using Excel file, SQL Server, and Oracle databases. Develops and produces peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS...LEAD DATA & BUSINESS INTELLIGENCE ANALYSTKeyBank Cleveland Ohio April 2022 March 2023 Sourcing, manipulation, preparation, and validation of data consumption. Queries and data mining to produce reports and score carding involving moderately complex descriptive analysis that provide answers to questions. Reoccurring reporting and analysis of more complex data. Source data for reports/dashboards based on understanding of business partners garnered by proactive communication and asking the right questions. Automate and standardize reports/dashboards for production. Translate data into consumable reports / business intelligence solutions and answer the why question. Develop performance analytics, scorecards, and dashboard of internal KPIs & metrics.DATA ANALYST/ TABLEAU DEVELOPER/ DATA VISUALIZATION State Of Michigan Project- Remote Mt. Pleasant, MI Mar. 2021 Feb. 2022 Designing and developing dashboards using Tableau for various ROI metrics. Developed reports indicating KPIs (Sales, Revenue, Profit, etc.,) for decision making by management or stakeholders. Provided ad-hoc reports and analysis to support business needs. Mastered the ability to design and deploy rich graphic visualizations with drill down and drop-down menu option and parameters using SSRS and Tableau. Worked extensively with advance analysis actions, calculations, parameters, background images, maps, trend lines, statistics, and table calculations. Utilized tableau server to publish and share reports with the business users. Developing BI reports with SSRS and Tableau to assist business make critical and strategic decisions.BUSINESS INTELLIGENCE ANALYSTCode Analytics Remote (Part time) Dallas, TX Jan 2019 - Feb 2021 Developing various SSIS packages for ETL in accordance with business requirements. Integrating different internal and external source systems (SQL server, flat files, XML files etc.). Performing database validation by developing complex SQL / TSQL queries. Performing data validation, integration and E2E testing. Designing and developing organizational and departmental business intelligence(BI), data warehousing and reporting solutions. Understanding the organization systems and identifying opportunities for efficient data management and data integration... Developed SSIS packages to load data from multiple sources to data warehouse. Produced Ad-hoc SSRS Dashboard based on user requirements. Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer. Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports. Strong Experience in creating Ad Hoc, parameterized reports, linked reports, Snapshots, Drilldown and Drill through reports using SSRS. GRADUATE RESEARCH ASSISTANTCentral Michigan University Mount Pleasant, MI Jan 2019 Nov. 2020 Collected, analyzed, and presented visualized data research on Dual Enrollment in Michigan to professors and the director of the College of Education and Human Services which increased enrollment by 35%. Prepared tables, graphs, fact sheets and written reports summarizing research results on projects assigned to my team. Arranged and entered data into Excel for tracking and modeling purposes. Prepare and deliver lectures to undergraduate or graduate students on topics such as econometrics, statistics, and mathematics. CREDIT ANALYSTJ.O Microfinance Ltd Kumasi, Ghana. Sept. 2012 - Nov 2018 Built dashboards to visualize core business KPIs (e.g., Operating Expenses, Active/Dormant Clients) saving hours per week ofmanual reporting by branch management. Prepared financial ratios and spreads using computer programs (Excel, etc.) to evaluate customer financial status to enhance productivity of credit officers by 40%. Conducted data analysis in CRM to prepare forecasts and identify trends of customer needs for credit to assist the branch marketing team increase sales/clients in a dormant market by 50% within 4 months. Analyze applicants' financial status, credit, and property evaluations to determine feasibility of granting loans. Obtain and compile copies of loan applicants' credit histories, corporate financial statements, and other financial information. |
