SUMMARY
Insightful IT professional with a highly diverse background in programming, database design/administration, application architecture/development and implementation/support of development projects.

Excellent Team Leader; always able to plan and direct all phases of projects in accordance to the standards of (SDLC) System Development Life Cycle, while communicating, managing, motivating and giving proper levels of assistance and guidance to the members of my team.

Areas of Expertise:

- Application Development

- Contingency Planning

- Database Development

- Risk Assessment / Impact Analysis

- Database Administration

- Policy Planning & Implementation

Technical Proficiencies

Languages: Visual Basic .NET, VB Script, VBA, Transact-SQL, PowerShell

Platforms: Windows 9x/NT/2000/XP/Vista/7 Windows Server 2003, 2008

Database Tools: SQL Server 2005/2008R2, SQL Server Integration Services (SSIS),
SQL Server BCP & SQLCMD Utility, IBM QMF

Reporting Tools: Crystal Reports XI, Cognos 8, SQL Server Reporting Services (SSRS),
SQL Server Report Builder 3.0

Other Tools: MS Office Suite (Access, Excel, Word, PowerPoint, Outlook, Project)
Visio, Active Directory, MS Exchange

PROFESSIONAL EXPERIENCE

Confidential,Early Branch, SC Jun 2010 – Present
IT Systems Analyst

Data and system integration, reporting and database/system management.

Tasks

• Development of Dos Batch & PowerShell Scripts to interface and streamline data between multiple systems.
• Data integration and migration using a variety of techniques such as SQL Server BCP & SQLCMD command line tools.
• Development of SSIS packages to execute database maintenance tasks, various stored procedures and SQL statements.
• Extensive Ad hoc reporting for various departments using SQL Management studio, SQL Server Report Builder and via SQLCMD to output data from queries on the fly from the command prompt directly into flat files.
• Development of Data Dashboard s in SQL Reporting Services to display real time KPIs for the procurement, warehouse and sales team.
• Developed multiple reports within Cognos 8. Also managed the data models within the framework manager.
• Help Desk support for network users such as answering how to questions, installing software, remapping network drives, unlocking accounts, resetting network or phone passwords, etc.
• Build/manage database servers and SQL Server installations.
• Manage and monitor SQL Server System performance, backups and nightly jobs within the job agent.
• Monitors all systems backs and also manage the daily rotation of backup tapes in the tape library.
• Weekend systems maintenance, installing system updates, system testing and rebooting of all systems.

Confidential,New York, NY Feb 2010 – Jun 2010
Information Technology Specialist

Systems and end user support for a medium sized network consisting of approximately 200 onsite users and 50 remote users via Citrix.

Tasks

• Imaging new computers, installing and configuring software, installation of computers.
• Setting up new users and setting there permissions in Active Directory and on the Citrix Server.
• Help Desk support for network users such as answering how to questions, installing software, remapping network drives, unlocking accounts, resetting network or phone passwords, etc.
• Development of in-house applications via Visual Studio (VB), SQL Server 2008 to interface with our ERP application.
• Manage all SQL Server database. Create a variety of SQL scripts, SSIS packages and stored procedures to modify, fix, or move data.
• Create and setup all SQL Server maintenance and back jobs.
• Monitors all systems backups and also manage the daily rotation of backup tapes in the tape library.
• Weekend systems maintenance, installing system updates, system testing and rebooting of all systems.

Confidential,Myrtle Beach, SC Oct 2007 – Jan 2010
Sr. Software Developer / IT Supervisor

In charge of planning, developing, implementing and supporting all in-house developed systems.
Manages multiple enterprise database application systems and also oversees any changes or continual development or interfaces between systems.

Tasks/Key Achievements:

• Created baseline structure for all in house enterprise applications, all of which were developed in Visual Studio 2005.
• Setup users accounts and security access via Active Directory.
• Setup and managed all SQL Server databases running on multiple servers.

These databases supported 250+ (POS) point of sale systems throughout the campus.

• Created all T-SQL scripts and jobs that produced the nightly back-ups via the job agent.
• Maintain and develop documentation for the responsible area.
• Continuously test coding to improve application performance efficiency and reduce system resources.
• Oversee the software development teams’ process and development of projects to assure they follow the steps of the (SLDC) systems development life cycle.
• Setup and Configured SQL Server 2005 Report Server.
• Developed all end user reporting for windows based and web applications via Visual Studio, ASP.net and PHP.
• Extensive experience with data integration. Transformed data from multiple SQL Server databases via SSIS(SQL Server Integration Services) such as importing or exporting data from various systems to the report server or migrating from the databases to excel projects for the dashboard queries.
• Developed and managed triggers/stored procedures that executed based on specific actions that took place with the databases.

Projects:
Database Systems Conversion – Converted all company wide MS Access database applications into enterprise systems. Database back ends were developed in SQL Server 2005 and front end (GUI) graphical user interface were done in (.net) Visual Studio 2005.

Confidential,Columbia, SC Feb 2002 – Oct 2007
Operational Support Analyst ll
(TM Floyd & Company)
System Consultant

• Create/Modify Easytrieve, COBOL, and DB2 (SQL) or SAS programs to generate routine internal and external reports on a daily, monthly, quarterly and annual basis.
• Verify accuracy of data on reports. Analyze reports for correct balance of claims dollars and membership data.
• Interview customers to obtain ad hoc data requirements and specifications.

Maintain files for each client as assigned.

• Create/Modify COBOL programs to map HCFA-1500 claims data into the appropriate fields.

Projects:
Report Standardization Parser - Created a Visual Basic application that automatically converted text files into formatted Excel or Html web based reports. This application eliminated the time consuming process of manually formatting hundreds of reports.

Front End Applications - Developed several front end applications using MS Access and VB 6. These applications interacted with mainframe sessions creating a user-friendly environment.

Batch Job Processing - Created batch jobs in Rexx and JCL. These jobs executed 50 – 60 weekly SQL jobs and exported them to their own datasets. These batch jobs eliminated
the need for compiling programs individually; they also compiled faster and used a small amount of system resources.

Departmental Training - Instructed weekly classroom-training sessions in SQL. Helped team members learn to code efficiently and learn to join a multitude of tables using a variety of different join commands such as inner and outer joins. Also instructed users how use the (RDBMS).

Database Development - Produced several mainframe SQL jobs that queried eligibility data from 15 tables. Created a reconciliation database in MS Access that connected to the mainframe via ODBC (open database connectivity) to pull the eligibility data and perform checks against member information and rejection reason codes to adjudicate claims.

Process Automation – Coded several Rexx Procedures to run 250+ SQL jobs and write
them to individual datasets. Created a VB 6 application that parsed each dataset into and
a formatted Word document and automatically created trend analysis graphs in Excel.

Education

Computer Science