Lydia K. Schumacher

Vista, California *****

www.linkedin.com/in/lydia-schumacher• 760-***-**** • ac97t0@r.postjobfree.com

Software Developer/Analyst

Senior Software Developer with proven expertise in enterprise system support, deployment and design.

Outcome-focused IT professional with extensive experience in business processes and procedures. Uniquely skilled in technological development and management of software through all phases. Adept at collaborating with all levels of management and users, analyzing systems and needs, creating unique solutions, and developing and implementing software.

Software Development Management / Systems Analyst / Website Designer

Solutions Innovator / Project Software Architect

TECHNICAL PROFICIENCIES

Platforms/Databases:

Windows, DOS, NT, Novell, SQL Server (6, 7, 2000, 2005, 2008), Oracle 8

Tools:

Visual SourceSafe, Microsoft Project, Microsoft Office Suite, Adobe, PVCS, Crystal Reports (8), Lotus Notes, Remedy, Service Now

Languages:

Network Automation:

Microsoft Visual Basic (5, 6, 2005), SQL Server (6, 7, 2000, 2005) which includes triggers, DTS packages and stored procedures; Microsoft Visual Studio 2005, Microsoft Access and Visual Basic for Applications

AutoMate, Computer Associates InfoPump, Active Server Pages, Visual InterDev, HTML, Active X Controls, ADO, GoldMine Integration, VB Script, VB 3rd Party Applications and Great Plains Architecture

PROFESSIONAL EXPERIENCE

Senior IT Engineer (11/2008 – 8/2019) Kaiser Permanente, San Diego CA

Technical Scope: SQL (SSIS), Visual Basic, SharePoint, AutoMate, Excel, ServiceNow, T-SQL, Data Warehouse

Provide support for various systems that monitor member information. Implemented software to track network changes and deployments. Primarily supported the Medicare Department.

Key Achievements:

Developed SQL database and application in Visual Basic supporting the Medicare Department.

Employed T-SQL development skills including stored procedure, function, and trigger creation.

Created DTS/SSIS packages to load data from various formats using Visual Studio.

Developed tasks using “AutoMate” software to import and export data from diverse formats.

Worked closely with users throughout production to fulfill requirements while staying within regulatory guidelines.

Employed change control software to track all modifications and deployments.

Supported multiple work management systems.

Received award for Effectiveness in August 2018

Received Performance Excellence Award in June 2019.

Senior Software Developer/Business Analyst (08/2005–2008) Jenny Craig, Carlsbad, CA

Technical Scope: SQL (SSIS), Visual Basic, DOS

Provided resolutions and process implementation to mitigate roadblocks. Recommended software development and lifecycle plans to management.

Key Achievements:

Developed SQL stored procedures to support current processes and modified others when necessary.

Created tasks on scheduling software (AutoMate) implementing SQL stored procedures

Created timely application using Visual Basic that enabled a workaround upon malfunctioning of the new order management system.

Migrated both member and product programs to new software platforms.

Produced tasks using Visual Studio 2005 to import and manipulate data from various platforms.

Senior Software Developer (02/2004–08/2005) INTERIOR SPECIALISTS INC, Carlsbad, CA

Technical Scope: SQL (SSIS), Visual Basic, Crystal Reports

Senior developer with additional duties such as deployment of application, and policy and procedure documentation. Worked with departments to identify issues and to propose new methods as applicable.

Key Achievements:

Developed and maintained Visual Basic application that supported designers and generated reports for installation and accounting.

Created and maintained stored procedures, views and user defined functions in SQL 2000.

Created and modified Crystal Reports 8.0.

Deployed application to four Citrix servers along with reports.

Created complex accounting reports interfacing with Great Plains accounting system.

Senior Technical Officer/Manager 05/2001–02/2004) CHASE HOME FINANCE, Rancho Bernardo, CA

Technical Scope: Oracle, Visual Basic, SQL

Lead developer for company-wide and site specific applications. Performed on-site evaluations and defined requirements. Succeeded at developing solutions through implementation. Managed team of developers, tracked projects, budgeted.

Key Achievements:

Managed group of developers responsible for moving critical data to and from disparate platforms (AS400, text files, Excel spreadsheets, FTP, secure web-sites).

Developed tracking application for employees’ vacation and personal days encompassing entire site. The application also tracked overtime adjustments relating to FLSA issues.

Designed Oracle database, collected requirements and performed as lead developer for application which tracked borrower’s checks through Chase Home Finance default divisions

Software Developer (05/1999–05/2001) Self Employed, Carlsbad, CA

Technical Scope: Crystal Reports, R:Base for DOS

Designed and implemented integrated business solutions for many different types of businesses

Key Achievements:

Developed Internet "Telephone Directory" for non-profit organization which allowed members to set up new directory information with logos, ad banners and links to their sites.

Created web interface to collect membership information, allowed members to apply for classes, make payments over a secured line and obtain immediate credit authorization.

Generated aging reports using Crystal Reports from developed R:Base factoring application.

Developed Help Desk program which tracked hardware/software issues, associated personnel and status of each ticket.

Senior Software Developer (03/1997–05/1999) CYBEROFFICE TECHNOLOGY, Carlsbad, CA

Technical Scope: Microsoft Access, SQL, Visual Basic, GoldMine

Developed commercial software specializing in complete business management products

Key Achievements:

Developed modules including accounts payable, contact management, integration to Microsoft Outlook, check book/check register/reconciliation, purchasing/receiving, accounts receivable, inventory, and order entry.

Set up Sales, Marketing, Technical Support and Documentation on an integrated contact management system interfacing with GoldMine, Visual Basic and SQL Server

Manager IT Department (1/1996–03/1997) TEL.N.FORM INTERACTIVE CORP. - San Diego, CA

Responsible for all areas of IT including support for multiple network protocols, web-sites and IVR systems, and for installation and support of all hardware/software and relevant user issues.

Software Developer (01/1995–01/1996) ARES DEVELOPMENT GROUP - Marina del Rey, CA

Developed third party add-ons for use with Symantec ACT! contact management application.

Manager IT Department (05/1992–01/1995) INTERCON SECURITY SERVICES, INC. – Alhambra, CA

Developed and installed timekeeping application for security guards at ten sites throughout southern California supporting financial/payroll areas. Administered all aspects of 50 user Novell network including workstations, printers and backups of system.

EDUCATION AND TRAINING

Bachelor of Arts, 1983 – Industrial Psychology

California State University, Sacramento, California

Contact this candidate