Summary
Overview
Work History
Education
Skills
Timeline
Generic

ANNA WARD

Warner Robins,GA

Summary

Motivated and proactive IT professional with about 4 years of experience as a data analyst. Excels in identifying pain points and solving problems to drive business value using data software applications. Expertise lies in streamlining data processes, improving accuracy, and saving time for users. Adaptable and efficient in reviewing requirements and translating them into clear and concise specifications. Strong ability to extract and manipulate data from RDMS, enabling informed decision-making for organizational success. Proven track record of working effectively in both independent and team environments. Eager to learn new material and techniques quickly, with excellent communication skills. Exceptional attention to detail even when working under pressure. Diverse skill set includes project management, data analysis, cloud migration, ETL development, data cleansing using Excel and Power Query, as well as visual analytics with business intelligence tools such as PowerBi and Tableau.

Overview

9
9
years of professional experience

Work History

Associate Business Systems Analyst

Thrivent Financial (Kelly Services Assignment)
07.2023 - 06.2024
  • Coordinating with the DevOps and/ or IT Support teams to deliver business and user system support while overseeing project execution
  • Manage the 'go live' deployment process ensuring seamless launch and continuity of business operations
  • Consult on requests from clients/customers on requirement specifications to make updates using HTML on their web contents
  • Execute data migration through SharePoint and add supporting documentation to Confluence
  • Build strong cross-functional relationships with department leaders across the organization, utilizing data-driven insights to support business decisions
  • Helped deploy system enhancements to improve field operations.
  • Estimated work hours and tracked progress using Scrum methodology.
  • Facilitated smoother communication between IT and other departments, bridging gap with regular updates
  • Gathered, reviewed and reported on findings.

Data Analyst/BI developer

Citizens Bank (Contractor SwiftLearn IT Solutions)
06.2022 - 07.2023
  • Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
  • Increased efficiency in data storage and retrieval by implementing robust database management systems.
  • Executed data cleansing activities using Microsoft Excel functions and power query, ensuring accurate data flow by removing duplicate datasets and bulky information before data migration
  • Performed queries to extract data from Microsoft SQL Server and Azure Database and conducted data preprocessing tasks on database logs to prepare them for exploratory and inferential analyses
  • Formulated complex SQL queries to retrieve data from disparate tables, employing techniques such as Joins, Sub-queries, CTEs, in SQL Server databases
  • Developed DTS Packages and utilized DTS for migrating tables to the Data Warehouse, as well as migrating data to cloud databases like Microsoft Azure SQL

Data Analyst

Boss Media Production
12.2015 - 06.2018
  • Performed market analysis to efficiently achieve objectives, increasing sales by 24% in 4 consecutive quarters
  • Developed new reports using excel spreadsheet and pivot tables to design, develop and establish KPIs to monitor analysis and provide strategic insights to drive performance
  • Introduced PowerBi as a BI tool to the company to perform an in-depth analysis of department records and create impactful dashboards to market products to clients such as Coca Cola Ghana, GTP Textiles
  • Responsible for creating Databases, creating tables and manipulated and updated Tables and columns using SQL Server Management Studio
  • Performed ad-hoc data extraction through queries in SQL to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying Tables and columns from which data is extracted

Education

Master of Science - Food Sciences and Technology

UNIVERSITY OF CAPE COAST
03.2017

Bachelor of Education - Foods, Nutrition and Wellness Studies

UNIVERSITY OF CAPE COAST
05.2010

Skills

  • Microsoft 365
  • Data Analysis
  • ETL techniques
  • SSMS
  • SSIS
  • Power query
  • SDLC methodologies
  • Waterfall
  • Agile
  • SCRUM
  • CSM (ServiceNow)
  • Jira
  • Slack
  • Data Migration
  • Sharepoint
  • Confluence
  • SQL proficiency
  • Quality Assurance
  • Business Intelligence
  • HTML

Timeline

Associate Business Systems Analyst

Thrivent Financial (Kelly Services Assignment)
07.2023 - 06.2024

Data Analyst/BI developer

Citizens Bank (Contractor SwiftLearn IT Solutions)
06.2022 - 07.2023

Data Analyst

Boss Media Production
12.2015 - 06.2018

Bachelor of Education - Foods, Nutrition and Wellness Studies

UNIVERSITY OF CAPE COAST

Master of Science - Food Sciences and Technology

UNIVERSITY OF CAPE COAST
ANNA WARD