SUMMARY:

• Over Twenty years of IT industry experience with MS SQL Server 97/2000/2005/2008, SSIS/SSRS/SSAS as SQL developer.
• Expertise in scripting T - SQL queries, complex stored procedures, User Defined Functions (UDF), and Database Triggers.
• Experience with complete SDLC, which includes requirement gathering, analysis, design, development, maintenance and implementation. Experience with Agile and Waterfall methodologies in approach to project development.
• Extensive experience in Performance Monitoring and Tuning of SQL statements, Sub Queries, Joins, Cursors and Functions. Extensive experience in teh development of backup and recovery process plans.
• Experience in Data Modeling (Logical and Physical Design of Databases) using Visio/Erwin, Normalization and building Referential Integrity Constraints.
• Experience in Data Modeling, Database Design, Programming and Implementation of Client-Server Applications and Database systems using MS SQL 97/2000/2005/2008 for both OLTP (Batch Processing, Online Processing) and Business Intelligence (SSIS, SSAS, SSRS) applications.
• Experience using SQL Server DTS and SSIS for ETL process and constructing packages for deployment.
• Expertise in developing reports using SQL Server Reporting Services and MS Excel Spreadsheets.
• Over fifteen years of experience with .net development.
• Over twenty years of experience scripting and automation development.

TECHNICAL SKILLS

Microsoft Office: Microsoft Project - SharePoint - Microsoft Visio

SQL 2008 R2: SQL 2012, DB2 - Access - C# - VB .net - COBOL - 370 Assembler

Micro Med: NextGen - SAP - SSRS - SSIS – SSAS - CA Erwin - PowerShell

Network Engineering: MVS JCL, DOS JCL, VSAM, Easytrieve, Focus

PROFESSIONAL EXPERIENCE

Confidential, AR

Database Administrator

Responsibilities:

• Custom Program Development C# & VB .net (Automation & Interfaces)
• Agresso System Automation
• Electronic Funds Transfers – Around teh World
• Bank Rec Statements Import .
• VB.net and T-SQL Development
• Check Processing various Countries
• VB scripting and T-SQL Development
• Web Interfaces (ASP, API’s)
• Data Integration with Agresso from multiple packages (Red Carpet – SilkRoad, LaserFiche, BBEC, Kametrica etc.)
• Windows Development
• Database Administration
• Database Development
• Built visualizations utilizing tableau software
• SolarWinds

Confidential, AR

IT Manager

Responsibilities:

• Developed and Implemented Database Backup and Disaster Recovery strategies.
• Developed Documentation regarding Operating Procedures and Technical Manuals.
• Produced Documentation providing justification of technology implementation to executive staff.
• Was proactive in Database performance monitoring and fine tuning
• Analysis and Design of new Database with successful migration of existing data.
• Redesigned and Installed new Infrastructure
• Cross Functional Team Lead that included: planning, preparation, software development, installation and cash management. Teh team worked with on site technicians, network technicians and software specialists
• Development of Data Warehouse and Datamarts
• Collaborate with Business Owners, Application Developers and Architects in Design and Implementations.
• Research, Benchmark, Document and Introduce New Technologies
• Produced Conceptual, Logical and Physical Schemas of Databases
• Developed Documentation regarding Operating Procedures and Technical Manuals.
• Optimization and Performance Monitoring of Database
• Conduct Database Capacity and Availability Audits
• Developed and Implemented Database Backup and Disaster Recovery strategies
• Network Installations
• Network infrastructure design, performed needs analysis and system & security assessments.
• Risk analysis, capacity planning
• SharePoint installation and development.
• Network Evaluations - Maximization of Productivity through Technology
• Network Installation (Windows 2008, Windows 2003, Eleven Windows XP Workstations, Windows NT Workstation) File Servers, SQL Servers 2005, Exchange Servers, Switches, Cisco Routers, Symantec VPN's, Printers, Power Vaults, Active Directory 2003, Security Protocols, Third Party Software Analysis
• System Programming
• File Conversions, Database Conversions
• Hardware Interfaces, Software Automation
• Web Site Design and Development, Graphic Automation

Confidential

SQL Database Administration

Responsibilities:

• SQL Server Installation, Data Modeling, Importation and Extraction of Data, Reporting Capability, Administering Data Security, Architecture and Planning Recommendations, Develop teh Logical Data models and Physical Designs, Managed Performance, Performed Backups/ Restores and Archiving of Data, Developed necessary ETL packages needed to populate multiple tables, System Performance and optimization, Document and Standardize Data Structures, Procedures and Processes
• SMS, SCCM, SCOM, TMG
• Upgraded SQL Server 2005 to SQL Server 2008
• Used Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.
• Used teh graphical Integration Services tools to create solutions
• Developed SQL Reports utilizing SSRS
• Designed and Developed Data Mart Indexing and Extraction System for Data Mining
• Utilized BI tools in teh Design and Development of Collecting, Storing and Delivering Decision Support Data at teh Enterprise Level.
• Systems Analysis & Design with Auditing Capabilities
• Took a company that was originally up for sale and redesigned their entire infrastructure, set up production control system with scanning capability to enable tracking production. Through teh means of automation increase productivity to teh point of teh company being taken off teh market and clientele being booked a month and a half in advance. Teh President of teh company said that with teh investment of equipment and my time teh system would more than pay for itself in a year and a half.
• Developed an entire system for medical clinic that took a patient from teh time they entered teh doors all teh way through back-end billing.
• Developed interface with EKG machine used during surgery imported readings into SQL database and graphed teh readings out within teh patients chart.
• Developed Automation of Reporting through SSRS.

Confidential Rock, AR

Director Information Systems and Communication

Responsibilities:

• Recruit, train and motivate dynamic employees for optimum operations
• Developed and Implemented Database Backup and Disaster Recovery strategies.
• Developed Documentation regarding Operating Procedures and Technical Manuals.
• Project Management
• Research, Benchmark, Document and Introduce New Technologies
• Establish, Maintain and Evaluate following of Processes and Procedures.
• Proactive in Implementation of Database Performance Monitoring and Fine Tuning for Optimal Performance.
• Performance Reviews of associates
• Managed team of four individuals and acted as liaison to company of 240 associates
• Coded tracking systems for problem tickets and resolution process
• Established Information Systems Department from conception
• Installation of VPN Clients, Cisco Switches, Routers
• Developed EOB system allowing migration of collections into multiple clinics, improving collections by 35%
• SMS – Pushed Updates to Workstations from teh Server
• Oversaw legality of licensing issues saving teh company millions in possible fines
• Upgraded Servers allowing much greater access speed increasing work-flow
• Assisted in automation of payroll process
• Evaluation and implementation of third party software

Confidential, AR

Senior Systems Analyst

Responsibilities:

• Membership Eligibility for Data Warehouse
• Trained team members in DB2 class training sessions
• Analysis and Design
• On-call Rotation
• Maintained and Developed programs in COBOL, Focus, and Assembler (370), DB2, VSAM, MVS JCL, Easytrieve, Focus
• Project Lead for Membership Eligibility System
• Taught DB2 Class
• Core System modifications in 370 Assembler