Data Analyst, Analytics Instructor, and Software Dev PM with over twenty years of industry experience. Harvard-educated, I am certified in multiple Microsoft technologies, with an achievement in building a comprehensive public database of 200+ resources for Analytics education. I am passionate about data and its patterns, how you prepare, manage, and visualize it, and how you communicate around it. I am currently enriching the Citizen Data Analyst community through a course I developed at Lasell University. I seek opportunities to contribute my expertise in data analytics, project management, and strategic communication. Discover more about my professional journey at LinkedIn:(_Website not available. Sign in: https://www.twine.net/signup_ Technical Skills • Analytical Tools: Power BI, T-SQL, MySQL, Excel 365 • Languages: DAX, T-SQL, VBA, ASP.NET, HTML, CSS • Database Management: SQL Server 2008, Access 365 Work Experience Instructor, Lasell University (4/2023 – present) • Teach "Analytics in the Workplace," with Power BI, to students and professionals, for Citizen Data Analysts who are not developers or analysts. • Preparing data, modeling data, and developing dashboards using Power BI. • Exploratory Data Analysis, DAX. Developed the entire course using my database of 2,000 resources. Data Analyst, EagleRidge Technologies, Inc. (6/2017–present) • Develop SharePoint websites and a public database to support Data Analytics education: _Website not available. Sign in: https://www.twine.net/signup_ with over 2000 resources. Senior Manager, Programs, Engility Corporation (7/2007–8/2016). Acquired by SAIC in 2019. • Managed SQL Server, SharePoint, and Project Server farm for 90+ project managers running 190 schedules. Implemented Hyper-V and VMware networks for testing. • Maintained and enhanced a suite of ASP.NET/ASP/JavaScript/SQL Server Web applications I originally developed while at L3 Communications. When a larger enterprise-wide system replaced it, wrote an ASP.NET Security module in the new system. • Administered SharePoint site collections for 430 users working on 70+ projects. Designed SharePoint applications. Analyzed SharePoint data with Excel. Project Manager, L3 Communications/The Titan Corporation (6/1999–7/2007) • Managed a $2 million clinical laboratory project with a six-member team using ASP, VB, and SQL Server 2000. I did the requirements gathering, project plans, budgets, elements of the software architecture, and testing procedures. The final system earned third-party approval and went into active use by laboratory professionals. • Did requirements analysis, design, and development of a suite of ASP.NET/ASP/SQL Server office Web applications.

Data Analyst, Analytics Instructor, and Software Dev PM with over twenty years of industry experience. Harvard-educated, I am certified in multiple Microsoft technologies, with an achievement in building a comprehensive public database of 200+ resources for Analytics education. I am passionate about data and its patterns, how you prepare, manage, and visualize it, and how you communicate around it. I am currently enriching the Citizen Data Analyst community through a course I developed at Lasell University. I seek opportunities to contribute my expertise in data analytics, project management, and strategic communication. Discover more about my professional journey at LinkedIn:(_Website not available. Sign in: https://www.twine.net/signup_ Technical Skills • Analytical Tools: Power BI, T-SQL, MySQL, Excel 365 • Languages: DAX, T-SQL, VBA, ASP.NET, HTML, CSS • Database Management: SQL Server 2008, Access 365 Work Experience Instructor, Lasell University (4/2023 – present) • Teach "Analytics in the Workplace," with Power BI, to students and professionals, for Citizen Data Analysts who are not developers or analysts. • Preparing data, modeling data, and developing dashboards using Power BI. • Exploratory Data Analysis, DAX. Developed the entire course using my database of 2,000 resources. Data Analyst, EagleRidge Technologies, Inc. (6/2017–present) • Develop SharePoint websites and a public database to support Data Analytics education: _Website not available. Sign in: https://www.twine.net/signup_ with over 2000 resources. Senior Manager, Programs, Engility Corporation (7/2007–8/2016). Acquired by SAIC in 2019. • Managed SQL Server, SharePoint, and Project Server farm for 90+ project managers running 190 schedules. Implemented Hyper-V and VMware networks for testing. • Maintained and enhanced a suite of ASP.NET/ASP/JavaScript/SQL Server Web applications I originally developed while at L3 Communications. When a larger enterprise-wide system replaced it, wrote an ASP.NET Security module in the new system. • Administered SharePoint site collections for 430 users working on 70+ projects. Designed SharePoint applications. Analyzed SharePoint data with Excel. Project Manager, L3 Communications/The Titan Corporation (6/1999–7/2007) • Managed a $2 million clinical laboratory project with a six-member team using ASP, VB, and SQL Server 2000. I did the requirements gathering, project plans, budgets, elements of the software architecture, and testing procedures. The final system earned third-party approval and went into active use by laboratory professionals. • Did requirements analysis, design, and development of a suite of ASP.NET/ASP/SQL Server office Web applications.

Available to hire

Data Analyst, Analytics Instructor, and Software Dev PM with over twenty years of industry experience. Harvard-educated, I am certified in multiple Microsoft technologies, with an achievement in building a comprehensive public database of 200+ resources for Analytics education. I am passionate about data and its patterns, how you prepare, manage, and visualize it, and how you communicate around it. I am currently enriching the Citizen Data Analyst community through a course I developed at Lasell University. I seek opportunities to contribute my expertise in data analytics, project management, and strategic communication. Discover more about my professional journey at LinkedIn:(Website not available. Sign in: https://www.twine.net/signup

Technical Skills
• Analytical Tools: Power BI, T-SQL, MySQL, Excel 365
• Languages: DAX, T-SQL, VBA, ASP.NET, HTML, CSS
• Database Management: SQL Server 2008, Access 365

Work Experience

Instructor, Lasell University (4/2023 – present)
• Teach “Analytics in the Workplace,” with Power BI, to students and professionals, for Citizen Data Analysts who are not developers or analysts.
• Preparing data, modeling data, and developing dashboards using Power BI.
• Exploratory Data Analysis, DAX. Developed the entire course using my database of 2,000 resources.

Data Analyst, EagleRidge Technologies, Inc. (6/2017–present)
• Develop SharePoint websites and a public database to support Data Analytics education: Website not available. Sign in: https://www.twine.net/signup with over 2000 resources.

Senior Manager, Programs, Engility Corporation (7/2007–8/2016). Acquired by SAIC in 2019.
• Managed SQL Server, SharePoint, and Project Server farm for 90+ project managers running 190 schedules. Implemented Hyper-V and VMware networks for testing.
• Maintained and enhanced a suite of ASP.NET/ASP/JavaScript/SQL Server Web applications I originally developed while at L3 Communications. When a larger enterprise-wide system replaced it, wrote an ASP.NET Security module in the new system.
• Administered SharePoint site collections for 430 users working on 70+ projects. Designed SharePoint applications. Analyzed SharePoint data with Excel.

Project Manager, L3 Communications/The Titan Corporation (6/1999–7/2007)
• Managed a $2 million clinical laboratory project with a six-member team using ASP, VB, and SQL Server 2000. I did the requirements gathering, project plans, budgets, elements of the software architecture, and testing procedures. The final system earned third-party approval and went into active use by laboratory professionals.
• Did requirements analysis, design, and development of a suite of ASP.NET/ASP/SQL Server office Web applications.

See more

Skills

Da
Data Visualization
Mi
Microsoft SQL
SQ
SQL
Fr
Freelance Gig
AI
AI Data Labelling

Experience Level

Data Visualization
Intermediate
Microsoft SQL
Intermediate
SQL
Intermediate
Freelance Gig
Beginner
AI Data Labelling
Beginner

Language

English
Fluent
Spanish; Castilian
Advanced
French
Advanced

Education

Add your educational history here.

Qualifications

Microsoft Certified: Power BI Data Analyst Associate
July 5, 2023 - July 5, 2024
https://learn.microsoft.com/en-us/users/chesterking-5621/credentials/592701f47b69f805

Industry Experience

Software & Internet, Healthcare, Education, Computers & Electronics
    uniE621 Teach Power BI to Citizen Data Analysts - 8hr course
    I teach up to 4 students with no programming or analytics background how to do data analytics using Power BI. We can do this over a day, a week, or several weeks. I will teach you how to do a portfolio or work with you on your company data, if all students are from the same company. Become a Citizen Data Analyst in 8 hours, using Power BI Citizen Data Analysts, who are not professional analysts or developers, know their chosen field and have a key role in today's organizations. They are essential to creating value from data. This course will put you well on your way to becoming one. I'll give you an introduction to Power BI and teach you how to learn more. The concepts apply to other tools. Even if you are a complete beginner, in the end, you will be able to create a simple report with different visuals and publish it online. This will be a start on your own portfolio or on the work you need to do using your company data. Learn how to learn, with access to our database of over 2,000 data analytics and Power BI resources. All you need is to download Power BI Desktop on your machine, and I can help with that. No other prerequisite, other than a desire to learn. Process • Install Power BI on your computer, with my help. • Connect to different data sources, import data into Power BI • Clean and transform sample data. Automate this process. • Create a data model, essential to creating your reports • Learn Visual Design, create visuals • Do Exploratory data analysis, the key to making sense of your data • Start learning DAX, Power BI's formula language • Share reports and dashboards • Learn how to build a portfolio to showcase your work. Learn how to tackle reporting in your organization. • Learn how to learn, with access to our database of over 2,000 data analytics and Power BI resources. See 8 hr course] (https://www.twine.net/signin
    uniE621 Data Analytics in the Workplace, Lasell University
    This is a Zoom course geared to working folks and undergraduate college students for 1.5 credits. Citizen Data Analysts, who are not professional analysts or developers, know their chosen field and have a key role in today's organizations, essential to creating value from data. They could be anyone from an HR specialist to a medical doctor. The number of citizen analyst jobs being created is several times that of expert data analysts, which is already at record highs. This course will put you on your way to becoming a Citizen Data Analyst with a solid grasp of how to do analyses using Microsoft Power BI, which you can use to create a portfolio and show your work. You will have long-term access to a database of over 2,000 web resources in Analytics. For more info, see Lasell Course Announcement] (https://www.twine.net/signin
    uniE621 Bicycle Sales Reports
    I developed this for my students from one of the many Excel Dashboard projects on the web, using their data set and basing the Power BI reports on the Excel ones to show some of the differences with the Excel approach. This is part of teaching them how to do their own portfolio. The interactive Power BI version of this is available on line at CKing Portfolio] (https://www.twine.net/signin
    uniE621 Crenshaw University
    Based on data I created to show various approaches to cards, KPIs, and basic reporting for a university case study I use in my course. The report has two pages; you can navigate them from the bottom when you go to the link at CKing Portfolio] (https://www.twine.net/signin The data goes by quarters, from 2020 to 2023, and the quarters you select determine the data you see via some DAX formulas.
    uniE621 Human Resources at Fenocorp - Power BI reports
    There are several HR dashboard examples on the web. I took this data from one of them and the inspiration for the visuals from several others. The report has four pages - you can navigate them from the bottom. The data covers 2006 - 2023. Thanks to some DAX, you can pick a range of years to get headcounts, retention, and turnover. See CKing Portfolio] (https://www.twine.net/signin for interactive Power BI app version.