Data Integrity Manager Resume Profile

Objective To obtain a more focused role in SQL database administration and reporting. Skill Set

Expert in MS SQL Server with over ten years of experience in Database development, administration, T-SQL statements, and report writing.
Practical application of T-SQL statements of all natures: SELECT, INSERT, UPDATE, DELETE, TRUNCATE, MERGE, CREATE, ALTER, DROP, EXEC, DECLARE, sub-queries, temporary tables, batches, stored procedures, triggers, functions, control-of-flow, and error handling.
I excel at complex queries that require multiple sub-queries and aggregation to produce a desired data set. An example of this would be a report that detailed purchases, inventory, sales, and GP summarized by product and month over the past year.
Ability to determine and set primary keys and indexes to optimize query execution in conjunction with identifying and resolve problematic queries and/or system performance issues
Able to quickly construct SSRS reports. Parameterized reports with multiple filters available on demand or scheduled with the ability to be presented to the end use in several formats, most notably MS Excel.

Expert 15 years experience MS Access database creation, VBA, and application development.

Expert 15 years experience in MS Excel. Pivot tables, Charts, Graphs, external data sources, VBA and formulas.

Experience Confidential Data Integrity Manager Manager two staff responsible for handling a large portion of the data needs and requirement for a national paint distribution company. The department's primary responsibility is to obtain, maintain and validate product data and pricing for the 17,000 products, 350 vendors and 12,000 customers. This position is in addition to my prior role. Data Specialist

I use my abilities and knowledge of SQL Server Management Studio, SQL Server Report Writer, SQL Integration Services, Eclipse, ASP, IIS, MS Access, and MS Excel to collect, prepare and present data.
Develop, implement, and manage processes and applications to:

Calculate monthly commission on a very high volume of sales to several dozen

sales reps based on a diverse set of business requirements

Calculate, and track vendor and customer rebates
Bring visibility to aging inventory for several warehouses

Created technical manuals on each process and application for reference

Deployed, upgraded, and manage a SQL Server 2008 Report Server SSRS

Created four hundred distinct SSRS report templates in the past year

Manage and instruct staff on accessing the reports

Schedule SSRS to generate reports and email staff, customers and vendors

Setup and managed the SQL Server.

Created and manage the Kourier integration process.

Created and manage a couple hundred SSIS integration packages From data transformations to complex scripts that handle loading binary data into SQL and manipulating images.

Created and manage four asp.net web applications

Confidential Database Administrator Programmer

Managed four SQL Server's that contained several databases ranging in size from 10GB to 100GB SQL Server 2000 and SQL Server 2005

Managed an IIS Web Server

Designed, built, and modified:

Applications in MS Visual Studio 2005

MS Access Databases
DTS/SSIS packages

Reports in a multiple of mediums: MS Excel, MS Access, Crystal Reports, and SQL Server 2005 Report Services

MS Word merger documents

Project planning and documentation. Drafted project outlines, and technical documentation on the project along with documented each step through to completion.

Created and implemented the forms and process for the IT departments standard operating procedure along with being an active participant in the program

Maintained a data center that contained approximately fifty servers
IT Customer Support for four companies

Billing Specialist Confidential
Designed, built, and managed MS Access database applications
Wrote tutorials and help files for each application

Confidential Data Specialist Designed, built, and managed database applications Software MS SQL Server 2000, 2005 2008 MS Windows 2000, 2003 2008 Server MS Office Suite 2000, 2003 2007 Citrix Metaframe XP Citrix XenServer XenApp Prolaw, Eclipse

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship