JAMES R CONAWAY

Mid-Atlantic, USA

804-***-****

ad35vp@r.postjobfree.com

PORTFOLIOS

LinkedIn.com/in/JimRConway

Github.com/jimrconaway-Data

public.tableau.com/app/profile/jim.conaway

SKILL SET

Full Stack Data Analyst: SQL, Tableau, Python, AWS, Git.

Ancillary Skill Set: Access, ACBS, Agile Methodology, API, Cloud Analytics, ChatGPT4 Prompt Engineer, Duo, Excel, Google Analytics, Jupyter, Quicksight, Machine Learning, Quicksight, Salesforce, Smartsheet, SSMS, Snowflake, Touchpoint, Turing, Watson Studio

CERTIFICATIONS/CERTIFICATES

MS Technology Associate (MTA 98-364) Database Fundamentals SQL Server (2021)

Certificate: IBM Data Science Professional (2021)

Certificate: IBM Data Scientist Foundations Specialist: (2020)

Cloud Analytics Practitioner, Architect, and Master Certification: Cloud Analytics Academy (2019)

Google Ads Fundamental, Search, and Digital Sales Certification: Google Analytics (2018)

EXPERIENCE PORTFOLIO

Compendium Analytics, Inc., Data Analyst/BI 02/23-Present

Macro Economics (WIP): The purpose of this project is to create a database for use in analyzing Federal and Corporate taxes as they relate to multiple macro-economic indicators. Additional analysis will center on Presidential administrations in office during specified time frames. Primary skill set are SQL, SSMS, Python, and Tableau.

Food as a Service (FaaS): This project involved the development of an organic snack using a variety of nuts as the product. My role was to model for anticipated sales/customers based on a very informal survey the clients had commissioned prior to my involvement. The situs of this project is in Bogota, Colombia thus there have been some difficulties due to language differences. Clients had predicted 100 new customers while my analysis suggested a maximum of 55 new clients. Primary tools here are Excel, SSMS, Python, and Tableau. Significant machine learning analysis using Sci-Kit Learn (Decision Trees/Random Forest)

Logistics Organization: Using SQL scripts, extracted data from third party vendor. Passed to Excel (Data Model) for data analysis. Pivot tables and calculated fields were used for monitoring KPI’s. Passed data to Tableau for interactive storyboard use with ROI increasing by 19%.

Marketing Analysis:

Extracted, cleaned, and analyzed data from database of ~200 attributes, using Python’s Pandas library. This resulted in a metadata report related to charitably inclined individuals from identification of independent variables to establish positive correlations for detailed analysis.

Real Estate Valuation: Wrote Python program to calculate real-estate values for a commercial brokerage firm with values passed to Salesforce enabling sales team to leverage value-accurate-data for competitive sales transactions for local acquisitions. Increased sales by 18%.

Swiss Post Solutions, Inc., Business Intelligence Engineer (BIE)-Virtual 01/22 – 12/22

Member of a 12-person National Team embedded with Amazon providing strategic business functions to Amazon corporate. Serviced 175 Amazon corporate offices throughout the US and Canada.

Utilized SSMS to write SQL queries to extract data necessary for more than 18 reports detailing KPI’s and SLA’s used by C-Suite.

Integrated disparate systems using AWS S-3 account for seamless interaction.

Automated report builds utilizing Python’s Pandas. Significantly reduced runtime.

Provided business intelligence analysis for special projects and ad hoc requests.

.

Capital One--Data Analyst-Sales Data Control-Contract 01/19-01/21

Team member of the Sales Data Control team with Salesforce super-user access; managed and authenticated financial data (Quality Control) for Capital One Commercial. Implemented Salesforces’ back-end/object-mapping data-load functionality for bulk data management processes.

Salesforce: Identified and catalogued data lineage and system failures; recommended enhancements for increased Salesforce functionality.

Wrote and invoked SQL query scripts in Snowflake’s data warehouse as a service to mine thousands of rows of data used for analysis.

Developed dash boards-story boards for executive management review.

Daily interaction with downstream systems ACBS, WCIS, Snowflake, and TouchPoint to ensure data accuracy for federal and state banking compliance guidelines.

Participated in development of Service Level Agreement (SLA) best practices to increase achievability for system resolutions goals resulting in reduction of SLA timeframe by 31%.

Career Change: Academic Sabbatical-Full-Time Student 01/16 – 12/18

Enrolled and completed more than 50 data centric self-study courses.

Wrote and published 5 data focused articles posted on LinkedIn.

Completed three data certifications.

Data-Financial Modeling, Triad Capital Group, Richmond, VA 11/05– 12/15

Financial/Data Analysis: Provided financial and tax advice to businesses and high net worth indiviuals.

FORMAL EDUCATION

Business, The College of William and Mary, Williamsburg, VA

Business, Enterprise State Junior College, Enterprise, AL

General Studies, Troy State, Troy, AL-attended at night.

General Studies, Chapman College, Orange, CA-attended at night

OTHER PROFESSIONAL EXPERIENCE

US Army-Explosive Ordnance Disposal (EOD) attached to Secret Service, Ft. Rosecrans, CA

US Army-Nuclear Emergency Response Team (NETEX) member, Sandia Base, NM

US Army-Air Traffic Controller (ATC): Rated tower controller, Cairns Army Airfield, Ft. Rucker, AL

US Army-Rotary Wing Flight School: Total hours 145: 60 hrs/turbine, Ft. Rucker, AL

Contact this candidate