William R. Walentowski
************@*******.***
Objective: To work in a team environment while utilizing and enhancing my
analytical, technical, interpersonal and organizational skills.
Skills
. SQL and VBA programming languages
. Relational database reporting/querying tools, including Microsoft SQL
Management Studio, Cognos Impromptu and Crystal Reports 11.0
. Microsoft SQL Server, Access, Excel, PowerPoint, Word, Outlook and Visio
. Microsoft Windows 98/XP/Vista/2007/2008
Professional Experience
10/12 - 08/13 Caesars Entertainment
Las Vegas, NV
Database Marketing Coordinator
. Developed and maintained ad hoc Access databases utilizing
Cognos queries.
. Created PivotTables to compare and analyze data.
. Created campaign offer matrices and specs by defining the
recipient and collateral IDs.
. Uploaded campaign data into the offers management system.
. Proof read marketing campaign offers.
01/12 - 07/12 Healthcare Services Group, Inc.
Las Vegas, NV
Account Manager Trainee
. Performed regular administrative tasks, such as payroll,
staffing, job routines, and supply ordering by utilizing MS
Access and Excel.
. Monitored light and heavy housekeeping duties of 10 to 20
employees.
10/07 - 03/11 UnitedHealth Group, Inc. - Clinical Informatics (CI)
Department Las Vegas, NV
Family Home Healthcare and Hospice Subsidiaries
Associate IT Business Analyst
. Designed, implemented and maintained a relational MS Access
CI inventory database as well as required forms and reports
and queries to track equipment distribution, issues, repairs
and purchases.
. Developed and stored over 350 reports/queries in the
organization's proprietary system's query/report tool to
ensure proper assessments, regulatory compliance, quality
assurance, cost management and operational procedures.
. Extracted data from SQL Server using SQL Management Studio
and programmed VBA macros for MS Excel productivity and
trend spreadsheets.
. Analyzed data and compared systems and recommended
solutions.
. Troubleshot software and hardware issues as well as hands-on
training and testing of upgrades.
05/04 - 09/07 Shift4 Corporation
Las
Vegas, NV
Technical Support Floor Lead
. Escalation contact for support I techs.
. Configured point-of-sale threads on proprietary software.
. Troubleshot issues between proprietary and point-of-sale
systems.
. Trained end-users to monitor and manipulate proprietary
software.
. Logged case details in tracking system.
Education
University Of Nevada, Las Vegas
Las Vegas, NV
Bachelor of Science Degree in Business Administration, Management
Information Systems (MIS)
. Graduated Magna Cum Laude, 2002.
09/01 - 05/02 UNLV Teaching and Learning Center
Las Vegas, NV
MIS Intern, 1/02 - 5/02
. Designed and implemented a relational MS Access workshop
database, along with appropriate MS reports and queries, for
tracking workshop courses, attendance and instructor
productivity.
Research Assistant, 9/01 - 12/01
. Assisted staff in hands-on training courses.
. Compiled workshop material.