| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Mid-Atlantic, USAPHONE NUMBER AVAILABLEEMAIL AVAILABLEPORTFOLIOSLINKEDIN LINK AVAILABLEGithub.com/jimrconaway-Datapublic.tableau.com/app/profile/jim.conawaySKILL SETFull 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, Machine Learning, Quicksight, Salesforce, Smartsheet, SSMS, SharePoint, Snowflake, Touchpoint, Turing, Visio, Watson StudioCERTIFICATIONS/CERTIFICATESMS Technology Associate (MTA 98-364) Database Fundamentals (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 PORTFOLIOCompendium Analytics, Inc., Data Analyst/BI 02/23-PresentMacro 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 Prep.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 Tableau Prep for metadata analysis and cleaning. Pivot tables and calculated fields were used for monitoring KPIs. 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 Pythons 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/22Member 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 KPIs and SLAs used by C-Suite.Integrated disparate systems using AWS S-3 account for seamless interaction.Created data stewardship required for standardization of disparate systems.Automated report builds utilizing Pythons Pandas. Significantly reduced runtime.Provided business intelligence analysis using Tableau for special projects and ad hoc requests..Capital One--Data Analyst-Sales Data Control-Contract 01/19-01/21Team 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.Wrote and invoked SQL query scripts in Snowflakes data warehouse as a service to mine thousands of rows of data used for analysis with significant attention to AML guidelines.Gathered metadata information for data governance best practices on special asset data. Identified corrupt data lineage and mapped to Single Source of Truth.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/18Enrolled and completed more than 50 data centric self-study courses.Published 5 data focused articles posted on LinkedIn.Completed three data certifications.Data-Financial Modeling, Triad Capital Group, Richmond, VA 11/05 12/15Financial/Data Analysis: Provided financial and tax advice to businesses and high net worth indiviuals.FORMAL EDUCATIONCollege of Financial Planning (CFP)BA, The College of William and Mary, Williamsburg, VAAA, Enterprise State Junior College, Enterprise, ALGeneral Studies, Troy State, Troy, AL-attended at night.General Studies, Chapman College, Orange, CA-attended at nightOTHER PROFESSIONAL EXPERIENCEUS Army-Explosive Ordnance Disposal (EOD) attached to Secret Service, Ft. Rosecrans, CAUS Army-Nuclear Emergency Response Team (NETEX) member, Sandia Base, NMUS Army-Air Traffic Controller (ATC): Rated tower controller, Cairns Army Airfield, Ft. Rucker, ALUS Army-Rotary Wing Flight School: Total hours 145: 60 hrs/turbine, Ft. Rucker, AL |
