Marion Smith

Marion Smith Email and Phone Number

Data Specialist | Microsoft Access and Excel Expert | SQL coding @ The Provato Group
Cleveland, OH, US
Marion Smith's Location
Cleveland, Ohio, United States, United States
About Marion Smith

To support analyses, business decision support and day-to-day operations, I enjoy developing/automating repeatable processes in a variety of common tools such as SQL Server Management [SSMS], Microsoft Access and Excel. SSMS: Intermediate to Advanced SQL coding skills: SELECT, WHERE, GROUP BY, HAVING, CREATE TABLE, CREATE VIEW, CREATE STORED PROCEDURE, CREATE FUNCTION, ALTER, CURSORS, IF dynamic and static variables etc.Recently obtained core-certification in a new favorite: alteryx (GUI-based tool used to combine multiple data sources, automate data prep, facilitates blending and analysis tasks)Expert in VBA coding (Visual Basic for Applications-"I program the buttons people click"), expert at dynamic SQL, static and dynamic variables, FOR..NEXT, DO..UNTIL loops , both MS Excel and MS Access. Expert in Excel formulas and functions such as VLOOKUP and pivot tables. Expert level MS Access, have created multiple dynamic business support database applications, i.e. menu choices change based on user selections, report/analysis outputs to Excel. As required, act as a liaison between ‘the business’ and IT department. Expert on obtaining knowledge of business data and ability to interpret end user needs.

Marion Smith's Current Company Details
The Provato Group

The Provato Group

View
Data Specialist | Microsoft Access and Excel Expert | SQL coding
Cleveland, OH, US
Employees:
52
Marion Smith Work Experience Details
  • The Provato Group
    The Provato Group
    Cleveland, Oh, Us
  • Career Break
    Professional Development
    Career Break Aug 2023 - Present
    Updating my skills, achieved Prompt Engineering certificate, ChatGPT. Open to business side employment opportunities.
  • The Provato Group
    It Data Analyst
    The Provato Group Mar 2023 - Jul 2023
    Independence, Oh, Us
    Short-term contract position at a large retail jewelry company headquarters:Customer Contract Unprocessed records cleanup: * I created a script using SSMS (SQL server) to parse multi-level JSON data into actionable extracts consumable by Excel and Microsoft Access * I used business logic to identify and reduce the ‘noise’ and row count by approximately 73% (38,688 to 10,600).Customer Contract ‘Rejects’* I created a standard weekly process for correcting contract ‘rejects’ in production to enable acceptance by the contract vendor.
  • Resideo
    Supply Chain Data Analyst
    Resideo Aug 2020 - Mar 2023
    As part of a customer-embedded team, I developed innovative ways to combine data from the customer and my employer to facilitate order tracking and analysis using SQL Server, Microsoft Access, and Microsoft Excel. I built a SQL server database in QA to accept customer data (received in various forms, Excel, csv, etc.). I collaborated with my employer's IT department setting up regular uploads to production SQL Server to enable near-time reporting and analysis.
  • Dealer Tire
    Supply Chain Data Integration Analyst
    Dealer Tire Jun 2006 - Apr 2020
    Cleveland, Ohio, Us
    Dealer Tire is an international tire, maintenance and light-repair product distributor that partners with automobile manufacturers including Audi, BMW, Chrysler, Dodge, Ford, Hyundai, Infiniti, Jaguar, Jeep, Kia, Land Rover, Lexus, Mazda, Mercedes-Benz, MINI, Nissan, Tesla, Toyota, Volkswagen and Volvo to create complete replacement tire, maintenance and light-repair programs for their dealerships. We put safe vehicles on the road and help vehicle manufacturers and dealerships increase profitability.As Data Integration Analyst, I created custom solutions for business decision, auditing, and reporting needs. With extensive use of SQL server, I was able to effectively generate relevant data by building tables, views, stored procedures, and functions. I efficiently produced information tools needed by the Inventory Management department. I utilized data-mining (real-time and near real-time) from the JDE production system, the Operational Data Store, and OBIEE (Oracle Business Intelligence software). In addition I became alteryx core-certified, and am highly skilled in advanced techniques of both Microsoft Access and Microsoft Excel. I have used all of these tools to create user-friendly business support solutions.
  • Office Max
    Inventory Management Reporting Analyst
    Office Max 2002 - 2006
    Us

Frequently Asked Questions about Marion Smith

What company does Marion Smith work for?

Marion Smith works for The Provato Group

What is Marion Smith's role at the current company?

Marion Smith's current role is Data Specialist | Microsoft Access and Excel Expert | SQL coding.

Who are Marion Smith's colleagues?

Marion Smith's colleagues are Genaro Chero, Tom Sova, Jack Von Duhn, Anthony Zielinski, Don Sing, Pj Leyden, Daryl K. Jackson, Jr..

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.