Sr. Programmer/Analyst Resume

SUMMARY:

Experience with ColdFusion, SQLServer, Java, Oracle 8i and 9i,10g SQR, PDFLib, T - SQL, Visual FoxPro, Visual Basic, C# and .net technologies
Crystal Reports, Erwin, TOAD, Jrun, Apache, Tomcat, ANT & SVN, Backup Exec., Windows 98, 2000 Professional, XP and Server 2003,2008 as well as teh aptitude to learn any type of software package
Object Oriented Programming in Java and successful completion of Learning Tree Course 570 Java for Web Application Development, SQL Server 2000 Transact-SQL Course 532, Securing Web Application Course 940

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Programmer/Analyst

Responsibilities:

Planned, designed, implemented and maintained a HADR SQL Server 2012 infrastructure between 2 subnets with automated functionality to sync Logins, Roles and Procedures.
Troubleshot deadlocks and long running queries and procedures and handled accordingly.
Maintained SQL Server 2012/2008 DBs and developed in house customizable applications using Java and .NET technologies.
Created complex custom T-SQL stored procedures & jobs to provide data across numerous applications in multiple environments.

Confidential

DBA/Sr. Programmer/Analyst

Responsibilities:

Created SQL Server 2008 DBs and designed and developed MHW CF9 web applications. Deployed applications on servers to be used company wide. Migrated data using SSIS and transformed databases to be optimized for web applications and custom queries.
Performed DBA tasks including complete installation of SQL Server, Backups/Restore, creation of DB Triggers and Stored Procedures, index optimization, and database maintenance. Created SQL user Login’s and applied security settings and Server Roles. Managed full high availability tasks in SQL 2008 including mirroring with automatic failover. Implemented database mail, configured notifications and alerts in SQL Versions 2000, 2005, 2008 & and 64 bit machines.
Created linked servers for use in queries spanning different versions of SQL Server to acquire data from and integrate several 3rd party applications.
Used SQL Profiler to run traces on long running queries and troubleshot db deadlocks.
Extensive work with SQL, DML, DDL
Experience with database replication, log shipping and mirroring maintaining a high availability solution.

Confidential

Analyst/ DB Programmer

Responsibilities:

Created SQL Server 2000/2008 DBs and designed entire back end for multiple applications through extensive use of SS Management Studio. Deployed applications on servers to be used company wide. Migrated multiple databases from SQL Server
Created many parameterized stored procedures in Transact-SQL pertinent to teh success of teh application. Used BCP with format files to parse text files and customize data. Written extensive queries for DML commands from complex databases
Developed a full scale Timesheet Tracking Intranet web application used to track employee hours across various projects and tasks using MS SQL Server & Coldfusion
Used XML datatype to parse multiple gig files and insert information to tables efficiently. Supported legacy Perl program used as import tool before migration to SQL Server 2008
Maintained and revised many aspects of several ColdFusion applications used by third party clients as well as in-house executives. Worked remotely to deploy code, database objects, and files to corporate wide servers

Confidential

Programmer/Analyst

Responsibilities:

Development of a Cold Fusion reporting module CFMX7/Oracle based intranet application for all reports related to teh National Institute of Standards and Technology’s Advanced Technology program
Cold fusion code enhancements and design of modules for creation of a user interface
Implemented custom CF security module throughout Cold Fusion Web pages for enhanced object based security
Independent configuration and implementation of teh CFMX7 server
Configuration and connections to Oracle 9i and 10g with Cold Fusion
Javascript, CFC and CSS integration throughout Cold Fusion Web pages

Lead Programmer/Analyst

Responsibilities:

Responsible for development of a full scale Java/Oracle based intranet application which tracks offenders, solicitors and processes requests in teh DFB program
Responsible for security through a Cisco Pix Firewall as well as granting permissions and shares for a secure database
Responsible for full installation, implementation and integration of Windows 2000 Server with existing Novell network
Troubleshot and repaired any network related hardware/software issues including work with TCP/IP, DNS and all other software
Performed maintenance and rebuilds on existing FoxPro and Clipper based programs as well as any necessary database adjustments

Confidential

Programmer/Analyst/Report Writer

Responsibilities:

Analyzed and converted Crystal Reports to SQR to be used in Report-Mart viewing tool for intranet
Designed SQL to retrieve desired information from Sybase Database
Created shared procedures to be used globally for standardized report headers and footers