SUMMARY:

To obtain a position that will utilize my strong existing skill set and experience, educational background and ability to work well with others in a team environment in order to enhance an existing IT infrastructure enabling business to make effective viable decisions in a timely manner.

WORK EXPERIENCE:

SQL Developer/DBA

Confidential, Peapack, NJ

Responsibilities:

• Automated archiving of decommissioned pharmaceutical systems and databases
• Maintain compliance with State and Federal regulations with regards to data retention
• Convert existing iSeries DB2 databases to MS SQL Server 2005/2008R2/2012
• Work closely with business SME’s to develop data points for data retrieval and document the DRP (Data Retrieval Plan)
• Build data retrieval queries and procedures in accordance with data retention policies outlined in DRP
• Execute archived data retrieval requests on demand in response to federal/state audits, etc.

SQL Developer/DBA

Confidential, Warren, NJ

Responsibilities:

• Maintained and/or enhanced existing database systems, MS SQL 2000/2005/2008/2012 ; assisted in conversion from /2008 & 2012; served as backup Database Administrator (DBA)
• Supported ad hoc user report requests, systems & requirements analyses, optimized performance and ensured overall database integrity
• Responsible for all reporting for the enterprise, including:
• Consolidated Reporting System (CRS) - web based ASP.Net & IBI WebFocus reporting tool consisting of over 100 high-level reports with sophisticated selection criteria
• Managed Reporting Engine (MRE) - ad hoc reporting interface supporting 50+ user reports
• ReportCaster - IBI report scheduler distributing 100+ scheduled reports thru out the enterprise
• User/Configuration management including installation, tuning, security & upgrades
• New report development with IBI WebFocus scripting, including front-end UI and back-end database T-SQL
• Developed & maintained several Extract-Transform-Load (ETL) projects using SQL Server Integration Services (SSIS)
• Tested all applications and documented test results across a three-tiered environment; including unit, regression & integration testing
• Responsible for maintaining User Acceptance Testing (UAT) environment; ensured integrity of test database and managed system architecture
• Provided first level support for all nightly Production job streams (when on call)
• Maintained SAS70 compliance and provided Requirements Analyses and Design specifications in adherence to Software/Project Development Life Cycle (SDLC/PDLC)

SQL Developer/DBA

Confidential, Fort Monmouth, NJ

Responsibilities:

• Automated loading of all hardware/software purchase orders into Oracle 10G database for Army Small Computer Procurement program (ASCP)
• Developed & maintained repository of automation staging/conversion scripts and tuned for performance improvement
• Supported Extract-Transform-Load (ETL) from flat file/Excel spreadsheet to Oracle 10G and ensured database integrity
• Responsible for adherence to existing policies & budget requirements as dictated by Department of Defense (DOD) standards
• Developed reports & analyses using Cognos and variety of other automation hardware/software tools
• Responsible for running Order Processing & Account Balancing on a periodic basis, including briefing and advising management for presentation to DOD
• Successfully processed over $1 Billion in orders

Systems/Software Engineer

Confidential, Princeton Junction, NJ

Responsibilities:

• Responsible for off-site engineering, development & testing of all software products at Morgan Stanley for integration into enterprise client/server infrastructure on Windows 2000/XP/2003 & Unix/Linux platforms
• Designed implementation plans & procedures, and interfaced with existing configuration management policies
• Planned, designed, developed & implemented software test plans, descriptions & reports using IT Governance & Perl scripting; prepared detailed test reports and maintained repository
• Maintained & coordinated lab systems performance, including Unix/Linux shell script code & Windows Management Instrumentation (WMI) VBScript code
• Directed, monitored & coordinated electronic delivery of software products across the enterprise
• Designed software modifications, developed coding structures & specifications using Perl & Java
• Administered Sybase, SQL Server & DB2 database for several client/server systems, including Scheduler & Metrics (internal distributed test lab & infrastructure tool to measure performance & quality metrics) and Quality Center (HP IT Governance tool)
• Oversaw design, implementation & maintenance of distributed database systems for client, including physical and logical design schema (using Erwin), T-SQL development (Triggers, I-SQL and Structured Procedures) and distributed database coding implemented as web technology services using Perl & Java
• Successfully built inquiry website for Scheduler back-end database using Model/View/Control (MVC) design, T-SQL and Perl Template Toolkit and distributed across the enterprise
• Created automated solution for database auditing & maintenance and saved approximately 200 man-hours per month in reports preparation resulting in average monthly savings of $10,000
• Responsible for training other consultants in use of Metrics & Scheduler database systems
• Developed comprehensive reporting system across MS SQL Server & Sybase ASE using T-SQL, Perl, Business Objects Crystal reports (BOCR) and Excel for risk management criteria presentation to upper management

Senior Test Engineer/System Administrator

Confidential, Eatontown, NJ

Responsibilities:

• Planned, designed, developed & implemented software test plans, descriptions & reports in accordance with Defense Information Systems Agency (DISA) COE Integration & Runtime Specification (I&RTS) guidelines
• Provided Test Lab support and periodic status reports on activity to management, via Video Teleconferencing (VTC) to Fort Hood and other Army facilities
• Developed & implemented reuse architecture repository for all Test Lab Common Software products & upgrades, including commercial off-the-shelf (COTS) products as well as external software support from Army Reuse Center, Fort Belvoir, VA
• Installed and configured all Test Lab operating systems (OS) upgrades
• Performed systems administration & user/group security implementation including Unix/Linux shell script coding & WMI VBScript coding
• Planned, directed, monitored, coordinated, analyzed and troubleshot secure networks, including routing and DNS/DHCP IP telecommunications configuration for a classified test lab environment
• Designed & wired existing Test Lab; installed & configured Netscape Directory Services for Lightweight Directory Access Protocol (LDAP) software in a Command & Control environment, including creating/maintaining LDAP Data Interchange Files
• Served on various systems support and managerial committees; developed requirements analyses & technical solutions for compliance with Army/DISA regulations
• Oversaw implementation & fielding of ABCS 6.5 & 7.0 revisions