Katie Schmidt
Manager of Data Quality at Container Centralen, Inc- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
Topline Score
Bio
Eric Springer
Katie’s dedication to Simpluris and her work has been unwavering since her first day. Her persistence and willingness to learn has enabled her to consistently take on the company’s most difficult challenges and obstacles quickly identifying process improvement opportunities and establishes a
Eric Springer
Katie’s dedication to Simpluris and her work has been unwavering since her first day. Her persistence and willingness to learn has enabled her to consistently take on the company’s most difficult challenges and obstacles quickly identifying process improvement opportunities and establishes a
Eric Springer
Katie’s dedication to Simpluris and her work has been unwavering since her first day. Her persistence and willingness to learn has enabled her to consistently take on the company’s most difficult challenges and obstacles quickly identifying process improvement opportunities and establishes a
Eric Springer
Katie’s dedication to Simpluris and her work has been unwavering since her first day. Her persistence and willingness to learn has enabled her to consistently take on the company’s most difficult challenges and obstacles quickly identifying process improvement opportunities and establishes a
Experience
-
Container Centralen, Inc
-
United States
-
Transportation, Logistics, Supply Chain and Storage
-
1 - 100 Employee
-
Manager of Data Quality
-
Jun 2022 - Present
-
-
Data Architect
-
Jan 2020 - Jul 2022
-
-
-
Simpluris, Inc.
-
Legal Services
-
1 - 100 Employee
-
Special Projects Analyst
-
Mar 2018 - Jan 2020
-
-
-
AssistRx
-
United States
-
IT Services and IT Consulting
-
300 - 400 Employee
-
Manager, Data Steward
-
Apr 2017 - Mar 2018
-
-
Data Quality Analyst
-
Oct 2016 - Apr 2017
-
-
-
Massey Services, Inc.
-
United States
-
Consumer Services
-
700 & Above Employee
-
Tier 3 (Senior) Database Administrator
-
Jan 2015 - Oct 2016
Massey Services provides an environment of learning and technology edge that I have the opportunity to explore daily. Primarily working with the Microsoft SQL Stack (2012), I have experience in the following areas: SSIS Package creation and troubleshooting; Responsible for 100 + production packages across several servers. SSRS report creation, changes, troubleshooting data, and often times having to fix data on the backend that was incorrectly assigned via third party software. Third party application support and working with developers on a weekly basis to push projects forward, help define requirements, and complete the software lifecycle internally before going live. SQL programming to optimize slow running stored procedures/queries. Recently was involved in an Always On upgrade where we converted a 2008 SQL Database(s) to SQL 2012 with Always On Availability. Personally responsible for testing the conversion/restoration process as well as fixing any SSIS packages with configuration settings. Show less
-
-
-
Simpluris, Inc.
-
Legal Services
-
1 - 100 Employee
-
Senior Data Analyst
-
Aug 2009 - Jan 2015
At Simpluris, I enjoyed many roles which created a challenge and a diverse work environment. I played the roles of Manager, Project Manager, Data Analyst, DBA, SQL Programmer, Report Developer, Help Desk Support Agent, Excel Enthusiast, and Business Process Analyst. Manager/Project Manager: Help team develop goals, team meetings, workload analysis. Data Analyst/Excel Enthusiast: Responsible for all incoming data for mail campaigns; cleansing data and preparing it for internal database insertion. Reviewing & interpreting legal documents to develop project definition for each mail campaign communicating data issues to internal staff & attorney’s. Performing data audits before and after the mailing & at the time of disbursement to ensure 100% accuracy. Prepare & analyze lists for disbursement, presenting any issues to the project manager for review. Adhoc DBA/SQL Programmer/Report Developer: Analyze performance issues & errors with in-house software application utilizing SQL Profiler & SQL Activity Monitor rewriting code as necessary. Responsible for production database support issues to 50+ users with in-house software application, writing administration type store procedures in order to fix common user issues. When possible utilize SSIS to perform ETL and automate other processes. Business Process Analyst: Help teams find commonalities in business process flow. Create diagrams of workflow. Make suggestions to senior management where improvements need to be made. Cross train in other departments to gain expertise. Help Desk Support Agent: Act as 1 of 2 main support personnel for all IT issues for 50+ users. Perform system administration type responsibilities such as: - Resetting passwords for user accounts in Active Directory. - Shadowing terminal service accounts to trouble shoot issues live. Support all users (internal/external) with the secure transfer site. Show less
-
-
-
-
Marketing Research & Analytics
-
Aug 2008 - Jan 2009
Market research for all new and existing markets. Segmented raw data down to the community level. Stayed within budget on all projects. Utilized public information and analyzing the data to predict the market type. Transformed and loaded data sets from external data dumps to MS Excel & Access to create ad hoc reports. Reports included penetration, commission, churn, customer reconciliation, installs. Established several 3rd party relationships for direct marketing campaigns from start to finish. Supported sales with event management, daily sales literature, contracts, customer support. Offered support to all departments on an as needed basis. Managed workload and time of receptionist. Created easy to read complicated graphs from results downloaded from Visual Ware. Created DOS scripts to run tests from remote machines and output the result in a text file. Updated company website. Helped all departments establish protocols for different processes. Show less
-
-
-
Kforce Inc
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
CRM Data Analyst for Universal Studios
-
2009 - 2009
Customer profile analysis utilizing shopping cart data matched with purchase history and survey information. Customer profile analysis utilizing shopping cart data matched with purchase history and survey information.
-
-
-
-
Vice President
-
Nov 2004 - Aug 2008
Repaired computers/laptops, created mass e-mails for promotions, process flow, managed & trained staff, removed spyware & viruses, created & maintain website, ad hoc programming, merchandise placement & pricing, and all assigned tasks. Repaired computers/laptops, created mass e-mails for promotions, process flow, managed & trained staff, removed spyware & viruses, created & maintain website, ad hoc programming, merchandise placement & pricing, and all assigned tasks.
-
-
-
-
Manager, Systems Implementation
-
Apr 2003 - Nov 2004
Developed CRM type system for a multimillion dollar client. Communicated with the senior programming staff on new development and testing issues. Analyzed and developed utilities to automate user tasks. Worked closely with marketing departments developing technological solutions and creative ideas for direct mail. Created analytic reports to show response analysis to direct mail campaigns. Implemented techniques for data manipulation and integration from several silos. Several projects requiring data transformation and consolidation techniques. Worked with hospitality industry doing marketing analysis and automating trend reports. Completed user manual for in-house software. Worked primarily with FoxPro 5.0 for all database utilities. Trained and supported users on software products. Show less
-
-
-
-
Systems Programmer
-
Jul 2002 - Apr 2003
Extensive application development with VBA in Access 97/XP. Communicating with MS SQL Server to run stored procedures in order maintain current and new data. Successfully maintain multiple databases for multimillion dollar client. Work in a team environment to organize projects and deliverables Extensive application development with VBA in Access 97/XP. Communicating with MS SQL Server to run stored procedures in order maintain current and new data. Successfully maintain multiple databases for multimillion dollar client. Work in a team environment to organize projects and deliverables
-
-
Education
-
University of Missouri-Saint Louis
BS, Computer Science -
Saint Louis Community College
Associates, General Studies