Sql Server Customer Service
Resume:
ROGER A. NIGG
Rocklin, CA *****
*********@*******.***
TECHNICAL SKILLS
Languages: SQL, T-SQL, VBA, VB
Reporting: Microsoft Access, SQL Server Reporting Services (SSRS)
Software: Microsoft SQL Server (2008, 2000, 7.0 and 6.5), Microsoft Access
(2007, 2002, 2000 and 97), Microsoft Office (2007, 2002 and 2000), Crystal
Reports 7.0, VB.Net, Visual Basic 2008 and 6, Visual Basic Source Safe,
Visual InterDev 6.0, Microsoft FrontPage 2002, Adobe Photoshop 5.0 and
ArcView 8.1
EMPLOYMENT SUMMARY
United Domestic Workers of America, San Diego, CA 12/2002 -
11/2009
Client/Server Programmer Analyst (Telecommuted from Centennial, CO)
( Processed and verified monthly billing of approximately 2 million
dollars from over 60,000 union members.
( Reconciled billing data from State Controller's Office by creating and
processing analytical accounting reports.
( Provided daily management assistance on requested reports and list
requests that require complex queries and reports, ranging from cross-tab
reporting to T-SQL programming in stored procedures.
( Created SQL Server billing program based on State Controller's Office
specifications to calculate dues related to hours worked, medical plans
selected and initiation fees per union member by county.
( Established accurate tracking of historical union dues billed and paid
through SQL Server table normalization.
( Improved employee efficiency and data validation by eliminating data
entry duplication through restructuring of a billing database and worker
activity database which allowed data interaction between them.
( Improved employee customer service by creating a worker activity
database to track union member activity.
( Established database functionality for users to import data, ran
billing process, created reports, ran customized list requests, tracked
employee activity, administered database logins and view historical data.
( Created MS Access programs with login security functionality to allow
user to interact with all databases.
( Maintained client workstations related to software issues, network
connections and troubleshooting.
Left Coast Case and Sound, San Diego, CA 2/2002 -
11/2002
Web Designer
( Created and maintained Web site which features case manufacturing, a
recording studio and Left Coast band.
Cornerstone Wealth Management, San Diego, CA 10/2001 -
11/2001
Microsoft Access Programmer Analyst
( Designed analytical reports to reconcile investment portfolios using
Microsoft Access.
( Created an automated reporting menu that allowed users to customize
reports based upon report type, time periods, portfolio categories and
individual combinations.
( Improved employee time efficiency by replacing manual calculations
with automated reporting which created more consistent and accurate
results.
ECloser, San Diego, CA 2/2001 -
9/2001
SQL Server Programmer Analyst
( Structured and optimized stored procedures in SQL Server for an online
mortgage-lending program.
( Developed and implemented data manipulation processes which involved
the design and analysis of tables, stored procedures, views and indexes.
( Created online processing by working with Web designers to interact
ASP scripts to stored procedures.
Telephia, San Francisco, CA 9/2000 - 10/2000
SQL Server Programmer Analyst
( Designed and maintained data marts within a data warehouse environment
in SQL Server.
( Created DTS packages to import and export data within data marts.
( Created data analysis environments for departments for customized
reporting by creating data marts.
Roger Nigg (Cont.)
ConfirmNet Corporation, San Diego, CA 4/2000 -
8/2000
SQL Server Programmer Analyst
( Structured and optimized stored procedures, triggers, indexes and
tables in SQL Server for an online insurance certificate program.
( Improved business activity analysis by creating an accurate reporting
system.
( Modified ASP scripts to interact with stored procedures for online
processing.
( Provided system administration on SQL Server data objects.
LPL Financial Services, San Diego, CA 12/1999 -
4/2000
Microsoft Access Programmer Analyst
( Enhanced an investment brokerage database used by over 3,000
independent U.S. representatives.
( Developed the following types of applications: reporting, user
interface screens, database merging, importing and exporting data,
database conversion and database upgrade service pack releases.
( Provided analysis on database structure to improve reporting scope and
efficiency.
( These enhancements resulted in a higher level of customer service and
sales commissions.
Household Financial Corporation, San Diego, CA
10/1999 - 12/1999
SQL Server Programmer Analyst
( Reconciled financial data to the AS400 mainframe data by creating
analytical accounting reports in MS Access 2000 using stored procedures
in SQL Server 7.
Draft Worldwide, Chicago, IL 9/1998 -
6/1999
SQL Server Programmer Analyst
( Designed and implemented a relational marketing database that tracks
and reports consumer preferences and responses to various advertising
channels using SQL Server.
( Developed import program automation, import validation, data
accountability and remote reporting.
( Generated various analytical reports using Microsoft Access. Improved
product marketing and sales by utilizing market research survey
information through the designed relational marketing database.
American Express, San Diego, CA 6/1994 - 8/1998
Client/Server Programmer Analyst
( Developed and maintained a student loan management application using
SQL Server and Microsoft Access.
( Structured and optimized code in stored procedures, triggers and
Microsoft Access for processing data.
( Created an automated report menu that allowed users to create complex
managerial reports.
( Analyzed database performance while creating and managing SQL Server
data objects.
( Developed importing and exporting processes, user interfaces,
application printing and customized reporting.
Pro-Tax Executive Search, San Diego, CA 2/1996 -
8/1998
Microsoft Access Programmer Analyst (Part Time)
( Researched and designed the company's recruiting database using
Microsoft Access. Provided user database functionality to create and
edit, merge data into MS Word documents and MS Outlook e-mail, track
recruitment activity, search and view selected criteria, print reports
and document results.
( Enhanced client-to-candidate matching efficiency for all recruiters.
Cost Accountant Positions, 1987 - 1994
EDUCATION
Bachelor of Science in Accounting, 1986
California State University, Chico
REFERENCES
Available on request.
Contact this candidate