Maureen Zimmerman
Okahumpka,FL
Summary
Dynamic DBA and Sr Data Analyst with extensive experience at Valley Cities Behavioral Health, specializing in SQL database management and reporting automation. Proven track record in cross-department collaboration and developing impactful dashboards, enhancing data-driven decision-making. Adept at problem-solving and leveraging business intelligence tools to drive continuous process improvement.
Overview
32
32
years of professional experience
Work History
DBA/Sr Data Analyst
Valley Cities Behavioral Health
Federal Way, USA
01.2017 - Current
- Microsoft SQL DBA: SSMS, SSRS, Linked SQL servers, SNOWFLAKE OPENQUERY
- Developing automated metric reports/dashboards using Credible BI /Yellow Fin BI, Credible Export Builder, Excel VBA, and SSRS
- Data blending external data with Credible EHR data using Excel and MS SQL to support monthly reporting.
- Documenting Credible’s database and our agency’s Data Dict to best support other report writers within the BI team.
- Credible EHR: Data Dict, Import Builder
- Collaborating with multiple departments and vendors to upgrade legacy systems to obtain more manufacturing process data for more detailed reports.
Mill IT Manager
Westrock/RockTenn
Tacoma, USA
01.2014 - 01.2017
- RockTenn acquired Simpson Tacoma Kraft in 2016
- Westrock and RockTenn merged in 2016
- Promoted to Mill IT Manager when RockTenn acquired the mill from Simpson in 2014.
- Developed automated metric reports/dashboards using QlikView, Excel VBA, OSIsoft PI, Capstone PARCView, SQL, and PHD (Honeywell) to enhance data visibility.
- Collaborated with multiple departments and vendors to upgrade legacy systems, enabling collection of more manufacturing process data for detailed reporting.
- Coordinated onsite and remote collaboration via phone, email, web sessions, and chat to ensure effective communication and project progress.
Business Analyst
Simpson Tacoma Kraft
Tacoma, USA
01.2010 - 01.2014
- Automating metrics reporting to centralized dashboards.
- Developing automated metric reports/dashboards using Tableau, Excel VBA, Capstone PARCView, SQL, and PHD (Honeywell).
- Analyzed proprietary systems with a view toward identifying data and queries to generate metric reports.
- Functional requirements gathering from business decision makers and end users.
Data Analyst, IT Project Manager, Web Developer, Technical Writer
Freelance IT Contractor
Tacoma, USA
01.2009 - 01.2012
- Provided IT project management and web development services.
- Apache, PHP, JavaScript, HTML, MySQL, XAMPP, IIS
- PayPal integration.
Director of Support Services
Rebus Technology, Inc.
Seattle, USA
01.2003 - 01.2009
- Electronic filing/OCR/Search Engine/Paperless Office software development and support.
- Managed and supported information management/document management technologies.
- Helped grow the company’s customer base to over 2000 customers and resellers within 3 years. Much of this was through our solutions selling partner, Konica Minolta.
- Consulted customers on integration requirements, and documented functional specs for one-off development projects.
- Edited our public website, and managed access to reseller product pricing, sales tools, and marketing materials.
Software Development Project Manager – Portal Engineering
Digeo
Kirkland, USA
01.2001 - 01.2003
- Interactive Television (iTV) data portal development. Digeo was acquired by Arris.
- Communicated with multiple departments to understand project cross-departmental dependencies, requirements and deliverables.
- Reviewed technical requirement documents and consulted with engineering leads to make sure the requirements could be met within the time expected to complete with available resources.
- Managed project work schedules ensure milestones and target dates were met.
- Tracked issues affecting projects to ensure proper escalations for productive resolutions on such issues.
- Documented processes to ensure steps were completed in order for projects to progress smoothly.
Strategic Production Engineer
Commtouch
Sunnyvale, USA
01.1999 - 01.2001
- Ensured that high profile strategic customers were successful in launching their web sites with Commtouch’s SaaS: customized email, calendar, SMS, and WAP services.
- Supported external developers on integrating their web sites. This involved reviewing code from outside developers, bug reporting and replications/verification of issues.
- Ensured that the deployment of new site launches re-launches for content changes and service enhancement launches occurred in a timely manner.
- Assisted on several one-off development projects to meet customers’ needs while ensuring such work would not be impacted negatively by future product releases.
- Frequently managed up to 34 different customers with multiple websites, launch dates and deadlines while ensuring successful production site launches, resulting in increased revenue.
- Commtouch was a hosted email, calendar, WAP, and SMS SaaS provider until 2001 when it changed its business to security solutions SaaS provider in 2001. Commtouch was renamed as Cyren Corporate as of 01/07/14.
Technical Support Manager
MindWorks
Sunnyvale, USA
01.1994 - 01.1999
- Rebus Technology’s electronic filing/OCR/Search Engine/Paperless Office software development and support in the US.
- Managed changes performed on the company web site and support bulletin board system (BBS).
- Tested and documented scanner driver compatibility (TWAIN & ISIS)
- Prepared and deployed patch files for end-users and field representatives. This involved managing an FTP site and ensuring proper security was set to support internal company personnel separately from end-users (customers).
- Supplied documentation to marketing, sales and development with lost sales reports, request for changes and frequently asked questions.
- Performed replications of customer issues and proof of concept tests. This included very detailed documentation to ensure good understanding by customers, prospects, sales team personnel, and development team lead personnel.
Education
Advanced T-SQL -
QuikStart
Seattle, WA01.2013
Tableau - Fundamentals & Advanced Training
Tableau Certification
Seattle01.2012
Intermediate PHP and MySQL -
Tacoma Community College
01.2011
Software Development Project Management -
Bellevue Community College
01.2001
Certificate in Java Development -
UCSC Extension
01.1997
studied Computer Science -
Cabrillo College
01.1988
Skills
- Acceptance Testing
- Data Modeling
- Document Imaging
- EHR Administration
- Excel
- HTML
- Integration
- Requirements Documentation
- SDLC
- SQL
- OCR
- PHP
- Power BI
- Power Query
- PowerShell
- Snowflake
- Tableau
- QlikView
- Yellowfin BI
- XML
- XAML
- VBA
- Vendor Management
- SQL database management
- Reporting automation
- Data visualization tools
- Metrics development
- Business intelligence systems
- Cross-department collaboration
- Legacy system upgrades
- Requirements gathering
- Effective communication
- Problem solving
- Attention to detail
- Project management
- Cross-platform skills
- Database backup
- Root-cause analysis
- Query optimization
- Security report management
- Database documentation
- Microsoft SQL
- Data testing
- Compiling data
- Relational database management
- Microsoft powershell
- Database troubleshooting
- Stored procedures
- Database development
- Backup and recovery
- Continuous process improvement
- Document management
- Disaster recovery
- Data conversion and migration
- Data migration
- SQL proficiency
- Systems administration
- Writing queries
- Database administration
- Big data technologies
- System testing
References
Available upon request.
Timeline
DBA/Sr Data Analyst
Valley Cities Behavioral Health
01.2017 - Current
Mill IT Manager
Westrock/RockTenn
01.2014 - 01.2017
Business Analyst
Simpson Tacoma Kraft
01.2010 - 01.2014
Data Analyst, IT Project Manager, Web Developer, Technical Writer
Freelance IT Contractor
01.2009 - 01.2012
Director of Support Services
Rebus Technology, Inc.
01.2003 - 01.2009
Software Development Project Manager – Portal Engineering
Digeo
01.2001 - 01.2003
Strategic Production Engineer
Commtouch
01.1999 - 01.2001
Technical Support Manager
MindWorks
01.1994 - 01.1999
Advanced T-SQL -
QuikStart
Tableau - Fundamentals & Advanced Training
Tableau Certification
Intermediate PHP and MySQL -
Tacoma Community College
Software Development Project Management -
Bellevue Community College
Certificate in Java Development -
UCSC Extension
studied Computer Science -
Cabrillo College