We provide IT Staff Augmentation Services!

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

Hire Now