John Watts

John Watts Email and Phone Number

Data and Reporting Analyst @ Health Care Service Corporation
Chicago, IL, US
John Watts's Location
Chicago, Illinois, United States, United States
John Watts's Contact Details
About John Watts

QUALIFICATION OF SKILLSSolution-oriented, creative, and resourceful developer/ analyst seeking opportunities looking to further my skills and career.SQL developer/ reporting/ data analyst Specialties: SQL, SSRS, ETL, Web development, analysis, reporting

John Watts's Current Company Details
Health Care Service Corporation

Health Care Service Corporation

View
Data and Reporting Analyst
Chicago, IL, US
John Watts Work Experience Details
  • Health Care Service Corporation
    Data And Reporting Analyst
    Health Care Service Corporation
    Chicago, Il, Us
    View
  • Religroup
    Religroup
    Chicago, Il, Us
  • Religroup
    Senior Data Analyst
    Religroup Mar 2023 - Present
    Function as part of a team working with the TSA (current security clearance). Review, analyze, measure, track, and evaluate weekly progress against the technical initiative and project plans. Create reports and deliverables in SQL Access, Power BI, and Excel, including macro creations and report automation. Validate data from multiple sources prior to ingestion into proprietary database. Conduct data analysis, queries, and extraction of information using SQL. Facilitate the analysis of program costs, schedules, risks, resources, and timelines and highlight attainment to business and strategic objectives for program activities. Research, develop, update, and maintain program of record documentation, including the preparation of remediation and infrastructure reports.
  • Blue Cross And Blue Shield Of Illinois, Montana, New Mexico, Oklahoma & Texas
    Data Analyst
    Blue Cross And Blue Shield Of Illinois, Montana, New Mexico, Oklahoma & Texas Aug 2022 - Mar 2023
    Chicago, Il, Us
    Consulted with business stakeholders to design, develop and maintain business intelligence solutions. Produced reporting, tracking, trending, and analysis to support operational effectiveness in healthcare using SQL, Tableau, Power BI, ServiceNow and Azure. Designed, implemented, and maintained user-friendly databases for various areas to meet reporting and analysis requirements. Streamline reporting to minimize manual efforts.
    View
  • Guggenheim Investments
    Business Data Analyst
    Guggenheim Investments Apr 2022 - Aug 2022
    Collected and documented business/end-user requests using SQL and Excel. Prepared ad-hoc analyses of data and business changes. Requirements gathering from business and end-users. Worked support tickets in JIRA to correct and update data.
  • Investors Bank
    Data Analyst
    Investors Bank Jan 2022 - Apr 2022
    Short Hills, Nj, Us
    Ran queries and reports for bank security and fraud investigations using SQL server, T-SQL, and Excel.
    View
  • Moody'S Financial Consultancy Limited
    Technical Analyst
    Moody'S Financial Consultancy Limited Oct 2021 - Dec 2021
    Documented SQL queries in stored procedures and VBA code to determine functionality and business needs using SSMS, Excel, VBA, SharePoint and AWS.
    View
  • Abbvie
    Business Data Analyst
    Abbvie Jun 2021 - Oct 2021
    North Chicago, Illinois, Us
    Contribute to the data and business needs through analysis of pharmaceutical data using SQL and Excel.
    View
  • Consulting
    Data Analyst
    Consulting Jan 2019 - Dec 2020
    Consult on IT projects including performing SQL tests in SSMS using T-SQL and creating a team-oriented SharePoint site for use in reporting and as a showcase for Tableau documents for upper management and analyzing and reporting on Environmental and Safety data using SQL, Excel, and PowerBI.
  • State Of Iowa - Executive Branch
    Sql Data And Reporting Analyst
    State Of Iowa - Executive Branch Aug 2014 - Jan 2019
    Us
    Perform queries and running reports on Microsoft SQL Server 2012 databases, fixing errors, and implementingsystem improvements in .NET based user interface. Develop, monitor, and document stored procedures and adhoc queries. Perform system/data maintenance tasks and perform restoration tasks when necessary.Update web based user interface HTML, JavaScript, and visual basic code to implement procedural changesand improve usability for end users. Create and maintain queries and produce ad hoc reports according to userrequests. Develop simplified procedures and arrange software enhancements that will enable users to generatead hoc reports, mailing labels, and other documents independently. Utilize C#, HTML, SQL, JavaScript,Access, Excel, SSIS and SSRS.
    View
  • Various
    Consultant
    Various Aug 2013 - Oct 2014
    Consult on IT projects including working with and updating surveys and performing updates on PCs and printers
  • Mail Services, Llc
    Technical Analyst
    Mail Services, Llc Aug 2012 - Aug 2013
    Analyzes and develops client solutions for customer communication channels, including physical mail and web presentations using Planet Press, SQL and Adobe Studio including InDesign and Illustrator and MS Office including Excel and Word. Analyze and process client data for publication using Bell and Howell BCC Mail Manager with CASS and NCOALink.
  • Sears Holdings Corporation
    Sr. Reporting Specialist
    Sears Holdings Corporation Sep 2011 - Jun 2012
    Ensure timely, accurate and quality reporting of operational metrics and business data including dashboards using MS Excel, Access and SQL Server (SSIS). Work closely with the call center business leaders to develop weekly/monthly/year-end reports (detailing qualitative and quantitative analysis) for the various business initiatives including e-commerce, voice, chat and email. Serve as "webmaster" and is responsible for the design, development and implementation of the business intranet and/or wiki site, enabling leaders and associates to maximize operational effectiveness and achieve customer satisfaction and drive revenue. Analyze and document customer surveys. Manipulate data through use of SQL Queries. Create and update SQL databases. Design pages using HTML, CSS and ColdFusion for company intranet.
  • Sears Holdings Corporation
    Retail Tech Support
    Sears Holdings Corporation Aug 2006 - Aug 2011
    Provide quick, courteous, and comprehensive customer phone support to resolve technical problems. Perform advanced troubleshooting and resolution for issues concerning Microsoft Outlook, Windows 2003/NT/VISTA, servers, printers, and desktop computers. Open/track trouble tickets for Level 1 requests. Diagnose website and network issues, administer user accounts, and upgrade/maintain systems. Code web pages for internal customers. Train new employees on company standards, regulations, and computer systems.Consistently maintained top scores in overall performance and quality of work. Continually learned the best troubleshooting methods and kept abreast of the newest technologies.Successfully led a weekly meeting with the home office to review ads.

John Watts Skills

Troubleshooting Databases Management Recruiting Leadership Networking Microsoft Office Customer Service Sql Access Sdlc Microsoft Excel Microsoft Word Customer Satisfaction Training Account Management Database Administration Consulting Business Analysis Policy Analysis Outlook Project Management Microsoft Sql Server Visual Basic Software Development Life Cycle Microsoft Access Html Css Php Photoshop Flash Excel Word Typing Web Design Spanish Telephone Skills Problem Solving Coldfusion Data Analysis Analysis Windows Transact Sql Visual Studio Analytics Jira Business Intelligence Sharepoint Database Development

John Watts Education Details

  • Kaplan University
    Kaplan University
    Web Development
  • Kaplan University
    Kaplan University
    Information Technology
  • University Of Iowa
    University Of Iowa
    Asian Studies

Frequently Asked Questions about John Watts

What company does John Watts work for?

John Watts works for Health Care Service Corporation

What is John Watts's role at the current company?

John Watts's current role is Data and Reporting Analyst.

What is John Watts's email address?

John Watts's email address is du****@****att.net

What is John Watts's direct phone number?

John Watts's direct phone number is +151597*****

What schools did John Watts attend?

John Watts attended Kaplan University, Kaplan University, University Of Iowa.

What are some of John Watts's interests?

John Watts has interest in Arts And Culture, Science And Technology, Computers, Languages.

What skills is John Watts known for?

John Watts has skills like Troubleshooting, Databases, Management, Recruiting, Leadership, Networking, Microsoft Office, Customer Service, Sql, Access, Sdlc, Microsoft Excel.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.