Sql Server Customer Service

Steve Sanderson

**** *********, *******, ** *****

469-***-**** ********@*******.***

Professional Goal:

To provide my employer with superior data, reporting and analysis using SQL Server, Access and Excel as applicable for a tool set enabling them to run their business with new insight and vision.

From there my goal is to become one of the star performers in that organization and help its management, employees and customers to be as successful as possible.

Technical Skills:

• 10 years experience analyzing the business, data, and user requirements for specific situations. Developing and maintaining applications which met various business needs. These applications have often mirrored complex production environments to validate the accuracy of the production throughput.

• Working knowledge of SQL Server including the creation of tables, views, stored procedures, scheduled jobs, assigning users and permissions etc.

• Experience in using Excel as a front end reporting tool for SQL Server data including pivot tables and charts.

• Programming Languages VBA, Visual Basic 5.0, 6.0, and some experience in VB.NET

• Working familiarity with DAO, ADO, ODBC and OLE.

• Database design and ability to interrelate MSOffice Suite--Access, Word, Excel and Outlook

• Have interactive knowledge of various back end databases including Teradata, SQL Server, Sybase and Oracle.

Professional Experience:

Securus Technologies Nov. 2006 to present

Primarily Sql Server to mine data and develop reports with development in Access and Excel.

• In December of 2010 was asked to assume a more active role as a data analyst with our Customer Service and Tech Support teams.

• Primary responsibilities over the last 15 months has been to create and maintain the accumulation and data structure of tables in SQL Server to provide reporting data access. Responsible for acquiring data on a daily basis from many different sources via automated processes that capture, interpret and relate data across many various platforms.

• Developed a network of Access databases that execute stored procs and gathers data from other sources during off hours, so the data is available for reporting when the team arrives in the morning.

• Developed several major Excel reporting tools that display the results of millions of records.

• Provided lead design and programming for an Excel CFO Dashboard which presents numerous high-level views by day for the last 180 days and a 13 month overview. The data is refreshed each morning when opened for the first time.

• Designed several tools to help team members with file manipulation to data reformatting.

• Produce various ad hoc SQL investigations as requested by management.

• Have been a data analysis resource, helping several departments evaluate the effectiveness of certain process with a view to creating change requests to improve where applicable.

Goodman Networks, Carrolton, TX Nov. 2005 to Nov.2006

Access Modules with a SQL Server back end to provide activity specific user interfaces for a variety of business functions.

• In this environment, the entire company information infrastructure was architected using SQL Server as a back end with interrelated Access modules on the front end.

• Primary area of focus was Bids and Quotes and Job Costing modules which handled most of the information related to each Job the company sold.

• Discovered extensive data anomalies between the two modules and proposed a merger of the two modules which would provide all of the necessary information for all viewers while maintaining the security of certain information. Implemented this major change over a two month period.

• Uncovered some abuses in labor and expense reporting that amounted to around a million dollars of annual payroll fraud.

• In SQL Server I have written stored procedures, created views, modified tables and permissions as necessary and added new tables to optimize database naturalization. I have also built processes which keep data synchronized across various SQL Server databases.

VarTec Telecom, Dallas, TX May 2001 to Nov. 2005

Development and maintenance of numerous applications to automate invoice audits.

• Developed two database applications to manage and report on reconciliation aspects of the company’s the chapter 11 negotiations with its vendors.

• Created and maintained over two dozen applications for various departments in the company that automated various audit, billing, customer account maintenance and production table update processes.

• These suites of applications accessed external data sources (text files, zip files, Excel spreadsheets, Sybase database tables, etc. to extract data, process data either as a validation of the accuracy of each individual record (on a regular basis validated over 70 million call detail records every month) or a summarization of the data for presentation in either an Access report or for export to pre-formatted Excel spreadsheets which may also contain charts.

• On two different occasions discovered over a million dollars in billing opportunities within the various billing streams for which I have researched and developed tools.

@Link, Richardson, TX Feb. 2001-Apr. 2001

Database development using Access 2000 (Contract to hire)

• Mined data from over 400 Excel Spreadsheets and migrated data to an Access database using normalized tables.

• Created front end that allowed several departments to add or update data as needed.

• Interfaced database with Excel to provide dynamic charts as needed.

• Ultimately migrated back end to Oracle but still utilized the Access user front end.

Microsoft Corp. Las Colinas, TX Oct. 2000 -Jan. 2001

Access 2000 Professional Support--phone support for Access 2000 (Contract)

• Received a months training at Microsoft in using and supporting Access 2000.

• Worked in their Access Support group for just over a month before they laid off about half of us.

Previous Job Experience:

• Wildernest Logistics, Grapevine, TX Dec. 1997 to Nov. 2000, Transportation Project Manager and Access application designer. Still maintain several applications built while working for them and do new design work as they require.

• Corporate Express, Dallas, Oct. 1996 to Nov. 1997, Driver Recruitment and Development

• Corporate Express, Grapevine, TX. Oct. 1992 to Sept. 1996, Operational Support and Customer Service

• Corporate Express (Eastway), Grapevine, TX. Feb. 1988 to Sept 1992 Contract Courier

• Evergreen Exteriors, Garland, TX June 1982 to Jan 1988 Entrepreneur/ Business Owner

• Lake Highlands Church of Christ, Dallas, TX. Feb 1982 to May 1982 Custodial Services

• Aftech, Dallas, TX. Telecommunication Sales Representative

• Eckerd Drugs, Garland, TX. Distribution Center/Labor and Management

• Lake Highlands Church of Christ, Dallas, TX. Youth Minister

• Sears and Roebuck, Dallas, TX. Visual Merchandiser

Education:

• Harding University, Searcy, AR BA in Speech and Art (double Major) 1970

• Richland Community College, Dallas, TX Various classes related to specific work needs--Horticulture, Human Resource (completed Continuing Education Human Resources Block, Nov. 1997) and Computer Programming (completed Continuing Education Visual Basic Block in Dec. 1999 and have taken several classes in Java in 2001 and 2002, HTML in 2001 and 2004 and a class in VB.net in November 2003, and XML during the month of July, 2004, In the spring of 2006 took a course in Programming SQL Server to add to my knowledge in working with SQL Server.

References:

• Chris Bradford. 972-***-**** Manager who hired me at Goodman Networks.

• Paula Howard. 972-***-**** The station manager at Seko/Wildernest Logistics Dallas.

• Paul Skinner. 817-***-**** Was a manager at Eastway and the person who first introduced me to computers

• George Dishman 214-***-**** Hired me as the first full-time employee of his landscape company.

Contact this candidate