Data Analyst Automotive Sales

SUMMARY

Senior Data Analyst with strong analytical, troubleshooting and communication abilities who is highly skilled at Data Management, Inventory Replenishment, Report Designer, Database Design and Administration, Technical Support, Data Mining, Marketing, Applications Development and Maintenance.

QUALIFICATIONS

Demonstrated ability in identifying system improvements and redefining procedures to improve proficiencies.

Successfully meets deadlines while maintaining an efficient workflow.

Served as liaison between several departments establishing protocols to ensure company business rules are in place and complied to.

Highly developed leadership skills requiring the ability to make independent decisions

resulting in positive outcomes.

Served as key customer satisfaction contact for major accounts to perform problem

analysis and resolution.

Keen ability in establishing audit and validation procedures.

Developed training manuals for new and existing employees.

Served as advisor for companywide ERP system updates and testing.

EDUCATION

Associate of Arts, Computer Science, Computer Learning Center, Anaheim, CA

Microsoft Certified Solution Developer Track, Software Education of America, Brea, CA

Certificate in Business Information, Santiago Canyon College Continuing Education, Orange, CA

Diploma in Micro-Computer Repair, Regional Occupational Center - Santa Ana, CA

TECHNICAL SKILLS

Microsoft (Excel, Power BI, DAX, SQL, VB.NET, VBA, Access, Dynamics, SharePoint)

Manhattan Associates & HighJump WMS

Adobe InDesign/Photoshop/Go Live/Dreamweaver

QlikView BI

Business Objects/SAS

Oracle/TOAD

Crystal Reports

PROFESSIONAL EXPERIENCE

Sr Data Analyst Jan 2014 - Aug 2022

Lakeshore Learning Materials, Carson, CA

Provided Data Management for Supply Chain Department creating and updating forecast and replenishment reports. Provided weekly Inventory reports to upper management tracking current sales, current inventory and retail performance. Maintained current and created new weekly Catalog sales reports for company usage. Provided picture/data reports for Merchandise department to track items performance for future Catalog inclusion/exclusion. Provided Overstock reports for Replenishment and Merchandise departments to avoid unnecessary inventory purchases and effectively monitor Warehouse usage. Improved reports performance reducing processing time up to 60%, achieving item level validation. Created inter-department protocols for efficient project implementation.

Sr Data Analyst Feb 2013 - Dec 2013

California State University, Fullerton, CA

Maintained financial reports in an Oracle environment. Created store procedures to send automatic email to end-users. Created new and maintained current Cristal reports for Advancement Department. Leverage from various data sources to maintain effective data flow. Provided Data structure control to protect sensitive data assuring correct information delivery schema. Created daily, weekly and monthly audits to assure data delivery efficiency.

Sr Data Analyst June 2012 - Jan 2013

Splatter Incorporated, Tustin, CA

Created effective Data Management procedures eliminating data redundancy and providing accurate and precise production information for a Telemarketing Company. Created daily/weekly and monthly operational, sales and financial reports using MS-Excel using Pivot Tables/Pivot Charts. Performed analysis to validate the accuracy of data being reported providing trend/early-warning analysis.

PROFESSIONAL EXPERIENCE

Data Import Specialist June 2011 - April 2012

Emida Corporation, Foothill Ranch, CA

Provided data management for prepaid global solutions customers. Validated and monitored of all data reporting methods to ensure data integrity. Developed maintained and presented analytical reports /dashboards to identify current and future problems. Designed data mining strategy to increase in house data leverage and reduce external data costs. Developed procedures to ensure that information systems products and services meet end-user requirements standards.

Data Analyst June 2006 – March 2011

American Honda, Torrance, CA

Provide custom financial, sales and forecast reports for Directors and Management Department using SAS and MS-Excel. Designed and administer MS-Access Database for Marketing and Accessory Departments. Provided quality control reports using Business Objects for Pricing department in large scale pricing changes completed using IBM-CICS. Identified data issues, proposing data processing efficiency strategies, and provided immediate and long-term solutions. Created new Database project using Business Objects SQL/Crystal Reports for future Implementation.

Database Analyst Dec 2005 – May 2006

Service Specials Direct, Irvine, CA

Designed and developed database for automotive dealerships marketing campaign using MS-Access, and Postal Manger. Provided custom software applications to automate department tasks using VB.NET. Created inter-department procedures for efficiency and to assure company’s goal completion. Verified record counts and created validation programs to check accuracy of data received. Lead test strategy sessions and test phases for development projects. Created new and updated existing reports utilizing MS Excel. Prepared and delivered data packages to be sent to outside printing company.

Senior Programmer Analyst June 1997 – Aug 2005

Reynolds & Reynolds, Irvine, CA

Provided mentoring and support for ODS/LEGACY programming teams in a Unix/Universe and MS-SQL environment. Performed data conversion and integration. Provided custom programming, support, and analysis for Automotive Sales Systems. Designed, implemented, and modified coding changes for Pick-Basic programs while monitoring system performance. Analyzed current system to comply with state regulations and meet customer requirements. Interacted directly with customers to test updates and to develop new applications and future changes. Designed and implemented custom software and provided complete support for Puerto Rican Customers.

*Prior experience available upon request

Contact this candidate