Marion Smith Email & Phone Number

Cleveland, Oh, Us

Updating my skills, achieved Prompt Engineering certificate, ChatGPT. Open to business side employment opportunities.

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.

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.

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.

Us