Resume

Sign in

Business Intelligence, Reporting, SQL, Data Manager

Location:
Renton, WA
Posted:
March 29, 2021

Contact this candidate

Resume:

Linda Ann Glasscock

*** ********* *** **

Renton, WA 98059

734-***-****

adk9k5@r.postjobfree.com

https://www.linkedin.com/in/linda-glasscock-a3b5877/

Summary

I am an experienced professional with a unique skill set developed during my career of working with Data Management, Business Intelligence reporting and implementation in both the automotive manufacturing logistics and healthcare software development industries. I have worked with data warehouses collecting and collating disparate data streams for comparison and analysis. I have a keen awareness of the fact that data alone will not provide guidance or create savings. Extracting information from data to guide business decision making has been the goal of all of the analyses I have performed and the reporting tools I have developed. I also have experience in mapping processes and developing documentation, including writing to ISO formatting requirements.

Microsoft Database tools (SSMS, SSIS, SSRS and SSAS) to create databases, cleanse and combine data streams (ETL); aggregate data and apply complex business rules (SSMS, TSQL); generate a wide variety of Business Intelligence reports in a variety of formats (SSRS, MS Access, MS Excel)

Create and maintain SSAS OLAP data cubes

Interactive dashboard/user interface creation (MS Access, Dundas Dashboard)

MS Excel, with an emphasis on use as a front end tool for SSAS OLAP data cube sources

Some DBA experience; job scheduling, query tuning, error diagnosis and repair; indexes

Currently employed in the Health Care field creating applications and reporting to manage employee performance evaluations and business segment statistics.

Experience in the Automotive Logistics and Supply Chain Management field, beginning with front line operations and moving into creating automated systems to optimize material flows, including using data drawn from OEM systems such as CMMS.

Active learner looking for opportunities for flexibility and new learning environments.

Software Applications

MS SSMS

MS SSIS

MS SSAS

MS SSRS

MS BIDS

MS Visual Studio

MS Access

MS VBA

MS Excel

pivot tables

VLOOKUP function

macros

MS Word

MS PowerPoint

Dundas Dashboard

CMMS

Work Experience

Blue Cross Blue Shield of Michigan – March 2016 to February 2020

Application Developer Blue Cross Blue Shield of Michigan – Perform ETL transactions using data in SQL tables to extract correct dataset for analysis, Use SQL to aggregate data and apply complex business rules. Create SSAS OLAP cubes with MS Excel front ends to provide high performance platforms for interactive data analysis. Create reports in SSRS to display specified metrics. Gather requirements from internal customers for new o r enhanced analysis and reporting. Maintain contact with internal customers during development to ensure that all needs are met and customers are delighted.

Epitec, Inc. – September 2014 to February 2016

Dashboard Developer (Blue Cross Blue Shield of Michigan) – Research existing SQL databases to identify data elements required for reporting and then validate the resulting datasets. Develop SQL stored procedures and SSIS packages to extract and combine datasets from source databases and perform aggregations to create final reporting data. Using Dundas Dashboard and C# based Dundas Scripting Language, create interactive dashboards to support Operations Management decision making and operational productivity. Work closely with customers to identify and refine reporting requirements. Collaborate on projects with team members.

Phoenix Data Systems – May 2013 to September 2014

Project Manager – Created and maintained MS Access database with user interface to extract data from proprietary MS SQL platform Work Order system containing software development design and tracking data. Continue to expand business intelligence reporting from database to provide real time management metrics. Create processes and process documentation of current and proposed programming and technical support staff functions. Cost and frequency analysis of various aspects of operation. Tracking of and reporting on new customer implementations.

Ryder Logistics – May 1995 to April 2013

January 2008 to April 2013 – ACH/Faurecia Account.

Senior Logistics Consultant – ACH/Faurecia Logistics Designer. Managed financial projection process using SQL tools developed by programming team in previous position. Maintained and enhanced SQL applications in conjunction with Ryder IT personnel. Designed and developed new MS Access tools and provided maintenance and enhancement support for existing databases for local team. Worked closely with customers to optimize inbound material movements to 2 Faurecia automotive parts plants. Used Ford/ACH proprietary CMMS system, Microsoft Access and proprietary Ryder databases to design Just In Time direct truckload and multi-supplier routes for inbound shipments. Emphasis on providing cost savings by optimizing ship frequencies and transportation mode. Worked with Ryder site managers, Faurecia suppliers and motor carriers to implement designed routes. Provided training and leadership to less senior team members not under my direct supervision.

January 2006 to December 2007 – Visteon/ACH Account

Senior Logistics Consultant – Visteon/ACH IT Business Project Manager. Managed team of two software developers and one data analyst. Provided project management leadership and business rules design for development of financial projection and tracking software applications in house customer use. Worked closely with customers and developers to create project specifications and lead on-going modification of applications to serve changing customer requirements. Continued to design and maintain suite of MS Access databases to support main Logistics Design team operations, including Premium Freight application and processes.

July 2003 to January 2006 – Visteon/ACH Account

Logistics Consultant – Visteon/ACH Premium Freight Analyst. Design and development of MS Access database to manage many Premium Freight related data streams and consolidate in one central data warehouse. Design, development and distribution of complex monthly and weekly analysis reports to aid Visteon in managing and controlling premium freight costs (40 active reports at peak). Ad hoc analysis and data condensation and distribution upon customer request. Customer education and clarification concerning premium freight processes. Familiarity with data and trends to enable identification of points of concern and emerging issues. Majority of time located on-site at customer location.

July 2002 to July 2003 – Visteon Account

Senior Logistics Analyst – Similar to previous position. Responsible for inbound design support for all Visteon Mexico plants. Designed consolidation project for all southbound LTL freight. Implemented design for freight through El Paso border point. 2002 savings $1.4 million identified, $834,000 implemented; 2003 savings (first six months prior to current position) $2.5 million identified, $2.4 million implemented (second highest team total for 2003). Developed MS Access database to manage and report on freight flows and costs.

April 2000 to July 2002 – Visteon Account

Logistics Analyst – Analyzed inbound material shipment volumes and geographic locations of suppliers to 4 Visteon automotive parts plants. Used CMMS, Microsoft Access and proprietary Ryder database and routing software to design Just In Time direct truckload and multi-supplier routes for inbound shipments. Emphasis on reducing levels of inventory in plant by increasing ship frequencies and on creating overall logistics cost savings for Visteon. Worked with Ryder site managers, Visteon suppliers and motor carriers to implement designed routes. Maintained databases to ensure current data and provide reports to customers and management.

January 1998 to April 2000 – Ford Account - Ford Motor Company Michigan Truck Assembly Plant, Wayne, MI.

Parts Analyst, Ford Motor Account – Monitored flow of a subset of inbound material into the largest volume Ford main assembly plant. Using MSIII maintained material in plant at lowest possible levels while adjusting incoming shipments to match upcoming production requirements. Worked extensively with Ford, supplier and carrier representatives to ensure flow of Just in Time material. Ordered expedited shipments when regular transportation modes would not deliver freight in time to avoid an assembly line shutdown. Maintained databases with various performance metrics and provided reports for management. Trained new personnel in duties of the position.

May 1995 to January 1998 – Automotive Business Development Account

Proposal Coordinator – Responsible for development of bid responses and presentation materials for the Automotive Sales Team. Used Microsoft Office applications to format documents, edit and generate content, proofread, develop spreadsheets and tables, and create graphics. Some original writing and editing. Performed all printing, collating and binding functions to produce finished documents and presentations for over 135 projects per year. Maintained extensive library of past projects from which to draw for future needs. Researched and coordinated purchase of major new color production equipment. Also responsible for supply ordering and Accounts Payable functions for the team.

January 1995 - April 1995 - Manpower Automotive, 140 S., Saginaw St., Suite 140, Pontiac, MI, 48329, 810-***-****. On assignment to General Motors, Vehicle Development and Technical Operations Group, 30200 Mound Rd., Engineering Building West, W1-13, Warren, MI 48090, 810-***-****.

Learning Coordinator – Assistant to OED/Personnel representative on team directing new vehicle development. Coordinated development and collection of materials for a set of presentation material for new car program team orientation. Investigated and began implementation of on-line library services for off-site vehicle development centers. Conducted research and interviewed functional area leaders to determine status of knowledge transfer within the vehicle development process. Conducted general research and fact-finding surrounding knowledge transfer. Assisted in setting up a series of training workshops. Used Microsoft PowerPoint and Microsoft Word extensively to create presentation materials, graphics and correspondence.

October 1993- January 1995 - Super Sales of America, Ann Arbor, MI

Regional Manager of Operations – Responsible for all operational details for one to three major public attendance events per week with attendance ranging from 7,000 to 40,000 over a two to four day event. Booked and coordinated venues, hired on site security and ticket handling personnel, rented on site equipment and coordinated union requirements in union venues. Primary responsibility for Eastern U. S., but also covered events in other regions. Worked with supervisor to develop computerized database in Filemaker Pro on Macintosh network for use in tracking and producing of events.

Prior to the positions listed above, held various retail and banking industry clerical positions and completed free-lance graphics design projects.

Education

University of Phoenix – Phoenix, AZ – Graduated 2002. BS/BM degree.

Washtenaw Community College - Ann Arbor, MI - Graduated 1993 - Associates Degree, General Studies, specialty in Mathematics and Natural Sciences.



Contact this candidate