TECHNICAL SKILLS:

• ER/Studio Data Architect
• ERWIN
• System Architect
• VMware
• SQL Server 6.5 - 2014
• DTS
• SSIS
• Oracle 6, 7, 8, 9i, 10g, 11g
• Oracle Forms
• Oracle Reports
• TOAD
• SQL Navigator
• SQL*Loader
• DB2
• ASP.NET
• ASP
• VB.NET
• Visual Basic 4.5 -6
• VBScript
• VBA
• WMI
• ADO.NET
• DAO
• MAPI
• CDO
• ActiveX
• HTML
• Infragistics Ultra Web Suite
• Crystal Reports 4.5 - 11
• Active Reports
• Microsoft Access 2.0 - 2013
• PowerPoint
• Visio
• SourceSafe
• LiteSpeed
• Ignite Monitoring Tool
• ER/Studio Data Architect

PROFESSIONAL EXPERIENCE:

Confidential

Database Admistrator\Analyst

Responsibilities:

• Create Backup and Maintenance Plans and upgraded multiple databases
• Performance Tune and Optomize Databases
• Installed 32 and 64 bit drivers and created Linked Servers.
• Implemented TDE Encryption
• Implemented ER/Studio Data Architect to document extended properties

Confidential

DBA

Responsibilities:

• Performance Tune and Optomize Databases
• Created SSIS Packaged to import and process data from various sources
• Implemented TDE Encryption
• Managed Security and granted permissions
• Implemented ER/Studio Data Architect to make design changes and document extended properties
• Implemented Transactional Replication
• Supported Microsoft Dynamic Great Plains
• Maintain optimal database performance through monitoring, maintenance and tuning
• Reviewing configuration and maintenance plans of SQL database servers and processes
• Analyzing, solving, and correcting SQL issues, providing problem resolution end-to-end
• Troubleshooting and resolving SQL performance issues
• Using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools
• Detecting and troubleshooting SQL Server related CPU, memory, I/O, disk space, and other resource contention

Confidential

DBA\Data Systems Analyst

Responsibilities:

• Installed SQL Server 2008 R2 and upgraded SQL Server 2005 Databases to SQL Server 2008 R2 SQL Server 2012 and 2014
• Create Tables, Views, Function, etc. for new 2.2 TB Data Warehouse
• Performed performance and tuning of corporate databases
• Perform and monitored database backup and restorations
• Wrote detailed backup and recovery plan
• Managed Security and granted permissions based on best practices
• Created ETL Packages that loaded Data from AS400, Oracle into SQL Server Data Warehouse
• Configured Reporting Server, BI Application Server, Great Plains and various other Database Servers
• Develop SSIS and Reporting Services Solutions and managed the deployment, subscriptions, etc.
• Implemented Backup and Recovery Procedures, Maintenance Plans, performed other common DBA duties
• Supported Great Plans
• Monitored SQL Server Jobs.
• Mentored and assisted Developers and BA’s on an ongoing basis
• Supported Microsoft Application from an AS400 Data Sources for Insurance Claims processing
• Maintain optimal database performance through monitoring, maintenance and tuning
• Reviewing configuration and maintenance plans of SQL database servers and processes
• Ensuring high levels of SQL Database performance, availability, and security
• Analyzing, solving, and correcting SQL issues, providing problem resolution end-to-end
• Troubleshooting and resolving SQL performance issues
• Using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools
• Detecting and troubleshooting SQL Server related CPU, memory, I/O, disk space, and other resource contention
• Tuned MS SQL Server databases for optimum performance and assistance in capacity planning of servers
• Performed Data Mapping and Data Migration from multiple systems
• Created Excel Worksheets from SSIS. Implemented v-lookups and Pivot Tab;es
• Lead support for Mirtosoft Access

Confidential

Database Developer

Responsibilities:

• Converted DTS Packages to SSIS.
• Created scripts for deployments to Production.

Confidential

Database Developer

Responsibilities:

• Consolidated data from several Oracle Databases and SQL Server Databases into an Oracle 10g Operational Data Store Database for Reporting purposes

Confidential

DBA

Responsibilities:

• Created and maintained ERD Diagrams and implemented physical design
• Created SQL Server Traces, queried System Tables, stepped through C# and VB.NET code to identify deficiencies in the SQL Server Procedures and User Defined Functions.
• Installed 3rd party SQL Server 2005 Databases, decommissioned Database Servers and moved Database to different Servers to consolidate and optimize performance
• Monitored Database growth and identified space requirements for Database files and Backups
• Performed Database Backups and restored Databases to a Point in Time
• Created ETL Packages (DTS and SSIS) to transfer to between SQL and Oracle Databases and import and export data to and from various file formats
• Provided ongoing support to various departments with developing ad-hoc queries, performance and connection issues to include SQL Server, Oracle and Microsoft Access
• Supported, maintained and monitored and provided production support to a Mission Critical Access Database
• Created Analysis and requirements to include the Business Analyst sections for requirements and testing

Confidential

C# Team Database Analyst/DBA

Responsibilities:

• Performed Data Modeling and implemented physical Database
• Create Tables, Indexes, Constraints, Stored Procedures, UDF’s Triggers, DTS Packages
• Created scripts to Promote to create and modify objects from Development to QA & Production
• Tuned Stored Procedures and Monitored Production SQL Servers

Confidential

SQL Server Developer/DBA

Responsibilities:

• Converted Postgre SQL Database to SQL Server, wrote DTS Packages to load Database
• Modified existing DTS Packages and created deployment scripts
• Created SQL Scripts on a daily basis to perform updates of data
• Supported Microsoft Access ADP Projects

Confidential

SQL Server Development DBA

Responsibilities:

• Performed data modeling, database design and implementation
• Converted Access Tables, Access Queries, VBA Code into SQL Server Objects
• Created DTS Package to load SQL and refresh Several Tables from Sybase
• Integrated Data from various external data sources into single databases
• Created Staging Tables, DTS Packages and Stored Procedures to populate Operational Data Store

Confidential

Web Development Systems Analyst and Database Administration Team Leader

Responsibilities:

• Develop maintain and execute project plans
• Lead Development effort to transfer Legacy Application Data to SQL Server Databases
• Created the logical and physical design and implemented and promoted from the Development, QA and Production Environments
• Responsible for developing the team and infrastructure necessary to support the company’s revenue growth from $90M to over $300M annually in less than 3 years.
• Created queries from the legacy system to generate text files, created DTS Packages to load Tables from text files and created Stored Procedures and UDF’s for an ASP.NET/VB.NET SQL Server Application that interacted with Insurance Adjusters, TPA’s & Pharmacy Benefit Management System (PBMS) and customer service
• Translated conversations and quickly created functional Relational Databases
• Created Database Objects, Constraints, UDF’s, Stored Procedures, Views and Triggers
• Gathered requirements and created a Prototype using VB.NET for an application that provided the functionality to search and drill down on Insurance Companies and TPA Regions Adjusters, Patients, Claims and generate Pharmacy utilization Reports
• Gathered requirements and led the development effort for a ASP.NET /SQL Server component that processed Pharmacy Orders, rejects and overrides, generated e-mails to the adjusters for authorizations of medication outside the formulary, displayed and printed unpaid, overpaid or partially paid invoices and interfaced with a PBMS
• Created tables to store & report medical billing (HCFA 1500) data to include HCPCS, CPT & ICD 9 Codes.
• Created queries from Accounting Legacy Systems and imported into Great Plains
• Provided Technical Support for ADP and migration to Ceridian
• Implemented, administered and Supported Great Plains
• Implemented EDI
• Performed Data Mapping and Data Migration

Confidential

SQL Server DBA/Developer

Responsibilities:

• Worked in a SQL Server Environment with data feeds into SQL Server from Oracle, Teradata, DB2, and Informix Data Sources
• Developer for Confidential and Singular Small Business Marketing Rebates Applications
• Created Stored Procedures and wrote VB Modules to extract service orders to determine the number of activations and disconnects and generate excel objects that are e-mailed to the customer and posted to the STARS Web Site
• Developed project specifications Developed scripts to initiate FTP Sessions
• Developed Stored Procedures and Visual Basic Programs that dynamically created Excel Worksheets

Confidential

Systems Engineer

Responsibilities:

• Employee of the year for migrating the Canadian divion IT Sytems to a Confidential
• Responsible for the development of logical data models and the creation of physical database designs
• Created tables, Indexes, Constraints, Stored Procedure, Views and Triggers
• Created a program that captures Health Level 7 (HL7), Admission, Discharge and Transfer (ADT) messages and store into SQL Server to enable patients to automate their telephone/television services and provide billing information feeds to the vendor
• Developed an automated Simulcast (Phone and TV) Hospital Customer Satisfaction Survey Component for Confidential Jacksonville
• Developed Application that captures payroll and sales information extracts data from a locked down Excel Workbook and creates a text file, e-mails text file attachment using MAPI to a Server to import into SQL Server, validate and process the data and load into J.D. Edwards.
• Developed Crystal Reports for Digital Video on Demand System and Customer Satisfaction Reporting.
• Created Microsoft Access VBA/SQL Server Credit Scoring Program for Dunn & Bradstreet Application.
• Created Microsoft Application to retrieve archive data from an AS400 Database
• Created VB Application that would generate an Excel Workbook
• Supported multiple Access Application to include the Confidential
• Provided Technical Support for ADP Payroll and Human Resource System.
• Performed System Administrator duties.

Confidential

Systems Engineer

Responsibilities:

• Developed a VB 4.5/SQL 6.5 Server application by creating COM Objects and writing ADO
• Wrote code to Push Data to General Motors FTP Site