Data Analyst Business Intelligence

JOHN WATTS

515-***-**** *********@***.*** http://www.linkedin.com/in/johnwatts22

Summary

Detail-oriented and results-driven Data Analyst with 5 years of managerial experience, specializing in data analysis, reporting, and business intelligence solutions. Skilled in analyzing complex data sets, creating actionable reports, and leveraging analytical tools such as SQL, Excel, Power BI, and Tableau to drive business decisions. Proven track record in streamlining data processes and improving operational efficiency. Strong communicator with moderate proficiency in Spanish and a collaborative approach to team leadership and problem-solving. Demonstrated expertise in developing and maintaining reporting systems that support business growth and operational excellence.

Skills

Database management

People management and leadership

Data Analysis and Statistics

Time management and Communication

Critical thinking and problem-solving

Data Wrangling and Cleaning

Data Mining and Modeling

Data Governance and Data Quality

Project Management and Agile Framework

Dashboard and Visualization Development

Business Intelligence and Reporting

Programming and Web Development

Experience

Senior Data Analyst 03/2023 to Current

RELIGroup Remote

Collaborate with the TSA under active Public Trust security clearance, tracking, and evaluating progress against technical initiatives and project plans.

Develop and automate reports and deliverables using SQL, Access, Power BI, PowerPoint, and Excel, including advanced formulas and macros for enhanced efficiency.

Validate and cleanse data from multiple sources before ingestion into proprietary databases, ensuring accuracy and consistency.

Conduct comprehensive data analysis, queries, testing, and extractions using SQL to support decision-making processes.

Analyze program costs, schedules, risks, and resource allocations, aligning project outcomes with strategic business objectives.

Research, create, update, and maintain program documentation, including remediation and infrastructure reports, to ensure compliance and accuracy.

Collaborate cross-functionally to provide insights and support for informed business decisions to technical and non-technical audiences.

Senior Reporting Analyst 08/2022 to 03/2023

HCSC Chicago, IL

Partnered with business stakeholders to design, develop, and maintain business intelligence solutions, enabling data-driven decision-making across healthcare operations.

Created reporting, tracking, mapping, trending, and analytical tools leveraging SQL, Snowflake, Tableau, Power BI, ServiceNow, and Azure, while adhering to HIPAA, federal, and state standards for healthcare data usage.

Designed and implemented user-friendly databases to meet diverse reporting and analytical requirements, streamlining processes, and reducing manual efforts by automating workflows.

Extracted, cleansed, and manipulated large data from multiple data sources for standardized reporting.

Conducted quality assurance reviews for reports and analyses, ensuring accuracy and compliance with organizational and regulatory standards.

Delivered actionable insights to support operational effectiveness in healthcare exchange processes.

Business Data Analyst 04/2022 to 8/2022

GUGGENHEIM INVESTMENTS Chicago, IL

Collected, documented, and analyzed business and end-user requirements, translating them into actionable data solutions using SQL and Excel.

Conducted ad-hoc data analyses to address business changes, ensuring accuracy and relevance to operational needs.

Gathered and refined requirements through collaboration with stakeholders, ensuring alignment with organizational objectives.

Managed and resolved support tickets in JIRA within an Agile framework, delivering timely updates and corrections to datasets.

Collaborated cross-functionally to enhance data accuracy and streamline workflows for improved business outcomes.

Data Analyst 01/2022 to 4/2022

INVESTORS BANK

Ran SQL queries and generate reports to support bank security, financial, risk, anti-money laundering (AML), and fraud investigations within the business banking sector.

Utilized SQL Server and T-SQL to analyze large datasets, identifying potential risks and fraud patterns.

Leveraged Excel for data analysis, providing actionable insights from both structured and unstructured data to support decision-making processes.

Conducted risk assessments and developed data-driven strategies to enhance the bank's data security protocols and fraud prevention measures.

Collaborated with cross-functional teams to ensure data integrity and compliance with industry regulations.

Data Analyst 09/2021 to 12/2021

MOODY'S Remote

Documented and optimized SQL queries within stored procedures to assess functionality, identify risks, and align with business needs within the financial services sector.

Utilized SSMS, Excel, VBA, Git, SharePoint, and AWS to perform data analysis, generate reports, and support decision-making processes.

Developed and maintained complex Excel models and VBA scripts to automate reporting processes and streamline data workflows.

Collaborated with cross-functional teams to ensure seamless integration of data from multiple sources and improve data accessibility and reliability.

Data Analyst 05/2021 to 09/2021

ABBVIE Remote

Conducted an in-depth analysis of pharmaceutical and training data including claims using SQL, Workday, and Excel (including Power Query) to support data-driven decision-making.

Developed comprehensive documentation and user manuals to ensure clarity and maintain data integrity across reporting processes.

Utilized SharePoint as a data repository and reporting hub.

Collaborated with cross-functional teams to assess business needs, providing actionable insights to improve operational effectiveness.

Trained colleagues on data protocols

Data Analyst 02/2020 to 12/2020

VERIZON

Analyzed and reported on large datasets, including HRIS data, specifically within the Environmental and Safety domains, utilizing SQL, Enablon, Excel, and Power BI.

Developed and maintained dashboards to visualize key metrics, ensuring effective decision-making and reporting across teams.

Leveraged data to calculate metrics and produce business reports.

Troubleshot and resolved data inconsistencies, prepared datasets for updates to the new system, ensured data integrity, and system alignment.

Collaborated cross-functionally to support business requirements and enhance data management processes.

Senior Business Data Analyst 01/2014 to 01/2020

STATE OF IOWA Des Moines, IA

Conducted complex queries, models, visualizations, and reports on Microsoft SQL Server databases to identify and fix errors and implemented system and process improvements—NET-based user interface.

Created and maintained SQL queries, generating ad-hoc analytical reports using Excel (v-lookups, pivot tables, charts, graphs, VBA and macros), Tableau, SSRS, and other tools, focusing on healthcare data (including client updates, claims, and other monetary updates) for management decision-making.

Developed interactive dashboards in Tableau that provided managers with actionable insights, helping to optimize resource allocation based on healthcare trend statistics and patterns.

Collaborated with division managers and stakeholders to gather and translate requirements into data-driven solutions, improving reporting processes and data warehousing..

Worked closely with non-technical audiences to ensure clarity in requirements, meeting expectations for government officials, and translating technical concepts into accessible terms for stakeholders.

Designed and maintained web-based applications using Azure, C++, HTML, JavaScript, Git, Visio, Drupal, and Visual Basic, enhancing user interface usability for both internal and public-facing web pages.

Integrated data from multiple sources using SQL for intergovernmental reporting and data management, ensuring data consistency, accuracy, and quality across platforms and reconciled inconsistencies.

Prepared and conducted surveys to improve performance and customer satisfaction

Built data models to support decision-making processes, leveraging business intelligence tools and methodologies.

Implemented a data governance framework include data remediation, data mapping, and identification to ensure data quality and establish uniform standards for reporting, processes, and documentation.

Adhered to HIPAA, federal, and state healthcare exchange standards, ensuring compliance and privacy in all data handling and reporting processes.

Consultant 01/2013 to 01/2014

CONSULTING Chicago, IL

Provided IT consulting services, focusing on updating SQL databases, and running complex queries to support business operations.

Utilized Tableau to create and update visualizations, helping clients make data-driven decisions.

Worked with customer surveys, ensuring they were up to date and effectively gathering relevant feedback.

Performed routine updates and maintenance on PCs and printers, improving operational efficiency for clients.

Technical Analyst 01/2012 to 01/2013

MAIL SERVICES, LLC. Urbandale, IA

Analyzed and developed customized client solutions for communication channels, including physical mail and web presentations, utilizing Adobe Studio (InDesign, Illustrator), and MS Office Suite (Excel, Word).

Processed and analyzed client data for publication, ensuring compliance with postal regulations using BCC Mail Manager, CASS (Coding Accuracy Support System), and NCOALink (National Change of Address) for accurate mail sorting and delivery.

Leveraged Linux systems for data processing and management, improving workflow efficiency, and ensuring timely delivery of client communications.

Provided ongoing support for clients to optimize their communication strategies across digital and physical mail platforms.

Senior Reporting Analyst 01/2011 to 01/2012

SEARS HOLDINGS CORPORATION West Des Moines, IA

Ensured timely and accurate reporting of operational metrics, KPIs, and business data, including dashboards and visualizations in MS Excel, pivot tables, and VLOOKUPs.

Utilized ETL processes, Access, and SQL Server (SSIS, SSRS) to extract, transform, and load data for analysis.

Collaborated with call center leadership to develop weekly, monthly, and year-end sales/e-commerce trending statistics and personnel reports, providing qualitative and quantitative analysis to support various business initiatives, including voice, chat, and email.

Served as webmaster for the company intranet/wiki site, overseeing the design, development, and implementation to improve operational effectiveness, customer satisfaction, and revenue generation.

Mentored junior associates to suggest task improvements.

Created, updated, and designed customer surveys and pages using HTML, CSS, and ColdFusion for the company intranet.

Education

Bachelor of Science: Web Development

Kaplan University Urbandale, IA

Associates of Applied Sciences: Information Technology

Kaplan University Urbandale, IA

Asian Studies: Japanese

University of Iowa Iowa City, IA

Certificate: Foundations: Data, Data, Everywhere

Google Data Analytics

Technical Summary

MS Office, Access, Excel, Project, PowerPoint, Power BI, MS Fabric, Tableau, Python, Visio, Snowflake, Databricks, Azure, Azure Data Factory, Azure Data Studio (Azure SQL), TFS, AWS, Docker, Agile, Outlook, Business Objects, Visual Studio, Drupal, SharePoint, C#, Waterfall, Adobe Suite, Adobe Analytics, Project, InDesign, Illustrator, Photoshop, PHP, VBA, ColdFusion, CFML, HTML, XHTML, XML, ETL, Project Management, SQL, SQL Server, and CSS.

Contact this candidate