DANIEL W. SCHUMACHER

S U M M A R Y

A high energy, self-motivated data management / reporting professional committed to providing IT solutions. Strong data warehousing skills. Team player focused on exceeding goals. Ability to work under pressure in multitask setting. Outstanding communication, leadership, organizational and problem-solving skills. Extremely adaptable to new environments and tools. Interested in using my experience to assist other companies via part-time opportunities.

E X P E R I E N C E

INTELEMEDIA, Plano, TX

Responsible for database, report and export development / troubleshooting (MS SQL Server, MS SQL Management Studio, MS SSRS and SQL Sentry). Create and manage database tables, indexes, views, stored procedures, and permissions (MS SQL Server, MS SQL Management Studio, Redgate SQL Compare and Redgate SQL Data Compare). Design, create, update, troubleshoot and deploy ETL packages (MS SQL Server and MS SSIS).

• Mentor and assist database / report developers.
• Optimize long-running / inefficient report and export stored procedures (MS SQL Management Studio and SQL Sentry).
• Design and build star schema data warehouses (MS SQL Server and MS SSIS).
• Help business analysts with query design, data questions and customer support.

VALUE OPTIONS, Coppell, TX

Responsible for report database development / troubleshooting (Oracle, MS SQL Server and TOAD) and creation of recurring / ad-hoc reports (MS Access, Crystal Reports, AVAYA CMS Reports, Business Objects and TOAD).

• Lead project to get phone data from AVAYA Informix database into Oracle data warehouse environment. Gathered table requirements, built Oracle tables, wrote insert scripts, and tested (TOAD). Worked with DBA to get Informix views in Oracle and scripts scheduled for daily, weekly, and monthly loads. Developed data dictionary and business rules.
• Converted Sybase reporting scripts to Oracle for migration (TOAD).
• Designed and programmed phone reports (AVAYA CMS Reports, Crystal Reports and MS Access).

THOUSAND TRAILS, Frisco, TX

Responsible for data warehouse development, reporting solutions, and management of DM&A team (2 direct reports). Role required daily hands-on IT development. Created and managed data warehouse tables, indexes, views, procedures, scripts, triggers, and sequences (SQL Loader, Oracle and TOAD). Programmed recurring and ad-hoc reports for analysis and decision-making (MS Access, Uforms and MS Excel). Coordinated downloads, system loads and system modifications to meet do not call legislation requirements (SQL Loader and Oracle).

• Developed and presented plan to migrate marketing information from MS Fox Pro / MS Access environment to Oracle data warehouse solution.
• Designed and programmed new / more efficient lead processing system (MS Access, Mailers Plus, Oracle and TOAD).
• Laid out and built web interface linked to Oracle data warehouse for data entry by remote call center (MS Front Page, Oracle and TOAD).
• Outlined and coded process to update lead records in data warehouse to determine what was currently available for mail, review what would be available in the future, record times mailed, and flag closest open sales park (Oracle and TOAD).
• Performed massive clean up of tables migrated to data warehouse (MS Access and Oracle).
• Designed and created systems to manage trade shows and premium fulfillment (MS Access and Oracle).

VALUE OPTIONS, Coppell, TX

Responsible for reporting solutions and management of reporting team (4 direct reports). Role required daily hands-on IT development. Created recurring and ad-hoc reports for internal and external customers (MS Access, Crystal Reports, Impromptu, Oracle, Sybase and AS400).

• Designed and built web-based reporting system to better manage report requests, track data validation, track timeliness, and note our progress (MS Access and MS Front Page). Tool allowed our internal customers to submit report requests via their web browser, view status of their requests, and review all notes regarding their requests. The system also allowed account services to track standard client deliverables from the first draft to final delivery.
• Drafted and programmed mental health / substance abuse reporting system for Public Sector accounts (MS Access).
• Worked with Corporate Migration team to prepare for migration of data from one legacy system to another and from an Oracle data warehouse to Sybase.
• Supported several corporate departments by providing special reports, validating data and doing end user testing (Corporate Finance, Data Management, Corporate Quality, Corporate IT and Eligibility) (Sybase and Crystal Reports).
• Assisted Long Beach and Falls Church service centers with reporting needs as necessary (Crystal Reports).

Responsible for report database development and troubleshooting (MS Access, MS Excel, Impromptu and AS400). Created recurring and ad-hoc reports (MS Access, Crystal Reports, Impromptu, Oracle, Sybase and AS400).

• Designed and programmed new EAP reporting system. Researched problems with original data pull, resolved issues with new query (Impromptu) and built all new reporting system to present accurate EAP data to clients in a professional, user-friendly format (MS Access).
• Gathered requirements and built new disability reporting system. Worked with care managers and account executives to develop specifications, redesigned data pull queries (AS400), built system to process data (MS Access) and designed / programmed reports (MS Access).
• Resolved data accuracy and consistency problems with quarterly client reporting system. Reviewed all queries, charted how system processed data, and modified the appropriate queries (Impromptu and MS Access).
• Programmed various reports for Falls Church service center. Reviewed user specifications and programmed / tested reports (Crystal Reports).
• Designed and created application to track and manage Medicaid cases (MS Access).

THOUSAND TRAILS, Frisco, TX

Responsible for providing database solutions, training, and troubleshooting (MS Access and MS Fox Pro). Created marketing reports (MS Access, MS Fox Pro, and Crystal Reports).

• Designed and programmed system to report on telemarketing performance at the park, regional and national levels (Crystal Reports, MS Access, and MS Fox Pro).
• Repaired telemarketing database and designed transport system to eliminate future transport problems and insure data integrity (MS Access, MS Fox Pro, and Telemation).

Responsible for database development, management, and administration (MS Access and MS Fox Pro). Managed telemarketing administrative and tech support staff. Developed and wrote marketing reports (MS Access, MS Fox Pro and Crystal Reports). Processed and presorted direct mail leads (MS Access and Mailers Plus). Formatted and distributed leads to telemarketing and field sales staff (ACT!). Maintained corporate Internet site (MS Front Page).

• Designed and coded database systems to process and manage incoming marketing leads from various sources. Documented and used consistent naming conventions for all tables, queries, forms, reports, macros, and VBA code (MS Access and MS Fox Pro).
• Gathered requirements and programmed database system to automate and streamline telemarketing commission reporting and tracking process - transformed weekly 2 person / 3 day task into 2 person / 1 hour task (MS Access and MS Fox Pro).
• Redesigned corporate Internet site - giving it a polished, professional look with efficient download times and smoother page transition (MS Front Page, Paint Shop Pro, and Image Styler).
• Designed and built data entry databases residing on network for multiple users. Included security features and individual production tracking (MS Access).
• Cleaned, repaired, and updated original data tables (MS Access).

U.S. SETTLEMENT SOLUTIONS, Plano, TX

Responsible for the sale and marketing of alternative dispute resolutions services to plaintiff attorneys and insurance professionals. Recruited and marketed ADR professionals. Designed and used custom case / contact management application (MS Access and MS Word).

• Successfully recruited and marketed six prominent Houston mediators.
• Designed and programmed custom case / contact management database system. System included: daily follow up, case management and compensation reporting; call history and notes recording; integrated confirmation and marketing documents; and invoicing (MS Access and MS Word).

E D U C A T I O N

UNIVERSITY OF NORTH TEXAS, Denton, TX

B.B.A. Major: Marketing GPA: 3.26