Marion Smith Email and Phone Number
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.
The Provato Group
View- Website:
- theprovatogroup.com
- Employees:
- 52
-
The Provato GroupCleveland, Oh, Us -
Professional DevelopmentCareer Break Aug 2023 - PresentUpdating my skills, achieved Prompt Engineering certificate, ChatGPT. Open to business side employment opportunities.
-
It Data AnalystThe Provato Group Mar 2023 - Jul 2023Independence, Oh, UsShort-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. -
Supply Chain Data AnalystResideo Aug 2020 - Mar 2023As 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.
-
Supply Chain Data Integration AnalystDealer Tire Jun 2006 - Apr 2020Cleveland, Ohio, UsDealer 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. -
Inventory Management Reporting AnalystOffice Max 2002 - 2006Us
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial