SUMMARY:

• Over 13 years of SDLC experience including analysis, development and testing.
• Expertise in Client/Server and Web technologies with Visual Basic, VBA and Data Bases.
• Experience in installation, configuration, maintenance, management, upgrading, monitoring and troubleshooting of MS SQL Server.
• Experience in Design, Development and Testing of relational databases (Normalization, Data Modeling, Tuning, Troubleshooting)
• Expertise in Query Optimization, Performance Monitoring, Security Administration, Trouble Shooting and using DBCC utilities
• Experience in establishing database disaster recovery, security, and management policies.
• Experience in creating, managing, monitoring automated jobs and data migration using DTS Services, ETL, Reports
• Highly analytical, great work ethic, excellent oral, written, interpersonal and communication skills.
• Dynamic team player, positive thinker, deadline aware, flexible easy going personality.

WORK EXPERIENCE:

(Software Consulting since 1997)

03/2011 - Present SQL Server DBA - Confidential, Patterson NJ
As part of DBA team worked on maintaining and administering various sourced DB Servers for assigned clients.

• Installed & Configured database servers for multiple environments (SandBox, Development, Test, Support & Production)
• Created SSIS packages to migrate Schema, Data and Logins across various servers, instances and versions.
• Managed several different programs used globally as an administrator providing troubleshooting support, educating end users, and escalating any bugs or errors.
• Setup profiler traces & analyzed load files and table data with SQL Server Profiler
• Created maintenance plans and setup jobs schedule to run at various times
• Established and maintained Security Integrity controls in conjunction with applications and security groups and maintained required level of security for all production and test databases.
• Carefully analyzed feedback and metrics reports from vendors to increase productivity, improve quality, and lower costs
• Periodically checked all databases with DBCC commands for maintaining data consistency and integrity
• Performance tuned Stored Procedures & long running queries by looking at query plans, IO Statistics, DB optimization.
• Documented database design and developed data dictionary updating SharePoint site with accurate and current information.
• Suggested Backup Strategies and scheduled Backups & Restoration for Databases and Transaction log
• Resolved SQL Server upgrade hurdles and successfully migrated DTS packages to SSIS using Upgrade advisor and Package Migration wizard
• Configured and implemented Mirroring and Snapshots
• Installed and configured SharePoint Server 2010.

Environment: SQL Server 00/05/08/08R2

09/2010 -03/2011 SQL Server DBA - Confidential, NYC.

• Set up & configured Test and Development servers
• Creation & migration of various DB objects (tables, Key constraints, Indexes, Views, Stored Procs, Triggers)
• Created Logins, users & roles and involved in Day to Day User Maintenance
• Performance tune Stored Procedures & long running queries by looking at query plans, IO Statistics, Joining Techniques , Outdated Statistics & Indexes
• Involved in Analysis & Implementation of Indexing for Large History Tables
• Created SSIS Packages & Jobs to load data from various User Input files
• Implemented Replication for availability of Standby server
• Developed and assisted in developing various reporting needs
• Help developers in tuning applications to attain optimal performance
• Monitor database growth activities & Troubleshoot Transaction Log & Space Issues
• Schedule Backup Jobs for Various Tape & Disk Backups
• Setup database maintenance jobs through Database Maintenance Wizard
• Written Custom Scripts & procedures to Extract, Transform & Load data through DTS/SSIS packages
• Designed SSIS Packages to Import and validate data from various User Input files like Flat Files, Excel files
• Set up SQL Profiler to trace various Database activities, application Responses and Performance tune them.
• Administer Procedures & Controls Audit Compliance
• Created Linked Servers between SQL Servers and other Heterogeneous environments like Mainframes

Environment: SQL Server 05/08

09/2008-09/2010 SQL Server DBA - Confidential, Network, (NYC)
Management and Administrated Development and QA RDBMS Environments.

• Set up & Configure database servers for multiple environments (Sand, Development, Test, Support & Production)
• Setup profiler traces for slow running queries & analyze load file thru query tuning wizard
• Setup maintenance jobs in all Servers schedule to run at various times
• Resolved SQL Server 2005 upgrade hurdles and successfully Migrated SQL 2000 DTS packages to SSIS using Upgrade advisor and Package Migration wizard
• Configured and implemented Log Shipping , Mirroring and Snapshot for SQL Server 2005
• Periodically checked all databases with DBCC command for maintaining data consistency and integrity
• Created Linked Servers between SQL Servers and other Heterogeneous environment
• Performance tune Stored Procedures & long running queries by looking at query plans, IO Statistics, Joining Techniques, Outdated Statistics & Indexes
• Documented database design and developed data dictionary.

Environment: SQL Server 00/05

04/2007-09/2008 Business Analyst/QA Analyst Confidential, (Paramus, NJ)
Koger is small Software company developing Back-office Hedge Fund Software (Agile Method). Being small company Koger offered high level of involvement in other areas of SDLC having developers and QA teams offshored in different countries. My area of responsibilities was in quantitative modules specific to Hedge Fund industry (Equalization methodology, Loads, Broker and Fund Manager's Commissions, performance bonuses, Hedge Fund structure, Effect of Dividends on equity).

• Created Test Scenarios and Test Cases for offshore testing team including selecting Test Data.
• Tested new releases and User requested changes (manual UAT testing after Black box process).
• Tested and analyzed SQL Server data-structure of new enhancements (tables and stored-procs.) for quality and data integrity.
• Communicated to users and clients about software needs and expectations, clearing questions and issues about functionality of existing software, resolved user issues and responded to user requests.
• Communicated with offshore IT departments requesting fixes and enhancements based on User feedback (QC and Instant Messenger and TestTrack).
• Analyzed business need of proposed changes, as part of developing technical business specs (FRD).
• Redesigned functionality and layout quantitative Crystal Reports coming out of system based on user requests.
• Created Use Cases, UML Diagrams, pseudo code as part of requirement management and communication process.
• Acted as subject matter expert assisting technical writers in preparations of user guides.
• Heavily involved in development of new implementations of equalizations methods.

Environment: Visual Basic 6.0, SQL Server, MS Excel, Mercury, TestTrac, Excel, Crystal Reports.

04/2006-04/2007 Business Analyst, Confidential, (Parsippany, NJ)
Inttra is an e-commerce B to B service provider for ocean carrier industry that connects shippers, freight forwarders, third-party logistics providers, brokers and importers to electronically plan, process and manage their shipments using in-house developed multi-platform technology.

• Lead effort in resolving issues with revenue cycle by working with IT department to identify existing problems.
• Designed and tested reengineered billing software process and patches customized to each client.
• Responsible for testing of new Oracle DB software releases and changes. (Excel and MS Access VBA based data comparison of output feeds).
• Routinely performed Excel/Access based data analysis to help improve processes identifying billable events.
• Developed complex Excel spreadsheets and Ms. Access VBA as part of BRD Measurement and Tracking process.
• Created logical, easy to follow specs for IT department (Word - Outlook).

05/2005 - 04/2006 - Confidential
04/2004 - 05/2005 - Confidential, Union NJ.

07/2003 - 04/2004 Software Developer Confidential, Newark, NJ
Participated in development of Customer Complaint System for Prudential C.R.M., software is designed to assist in remedying litigation on life insurance policies. This software processes "complaints system" from time it is recorded to time it is settled or challenged. CCS is an n-tier application that uses mostly Win Forms and some ASP, it consists of Intake, system which lets claim examiner process and record complaints, Scoring (as logical module), which automatically decides to settle or challenge some claims by rating paper work, Funding Worksheet for funds transfer, Letter Gen generates legal letters to complaining parties and Remedies in case settlement is appropriate.

• Developed Functionality based on Specs.
• Architecturally Resolved Complex Business layer issues.
• Data Analysis, Database Design and development, data modeling, Stored Procedures, Views, Functions and Triggers.
• Involved in Data transmission from different kind of input sources (Access Databases, Excel files) to SQL Server 2000 Database.
• Developing Entity, Data Access and Business Logic Components.
• Developed GUI including User Controls and Custom Controls.
• Developed and reused existing batch billing components.

Environment: VB6.0, ADO, MS SQL Serve 2kr, various Visual studio components, PVCS, MS Office integration.

07/2002 - 06/2003 Programmer Analyst Confidential, (Bridgewater NJ)
Responsible for Maintaining an existing VB6 and MS Access applications that supports call center QAing sales of Life Insurance policies, by evaluating efficiency and security of current components, recoding/redesigning components to ensure convertibility and integration with future versions. By fixing newly found problems and adding new components as pier business/client requirements. Ensuring constant uninterrupted data base connectivity to support end user applications.

• Automated manual Jet Engine realigning process.
• Responded to modification requests from call center.
• Used Datasets and Data Grid controls to add-in Process Report Functionality.
• Developed minor applications based on requisitions from other departments.
• Did and fixed some reporting.
• Responded to and assisted QA department.

Environment: VB6 (Win Forms), RDO, ADO,SQL Server, MS Access, Crystal Reports.

06/00 - 07/2002 Software Engineer

(Roseland NJ)
Development of 401k administration Software (20% of USA 401k retirement plans to be handled through PASS System.) Pass system is divided into Underwriting, (401k) and Various (IRA) subsystems, module layout change based on logic of product selected. validated data is processed through multitude of business layers, some check for required fields for approval of mainframe transactions, others assign data to appropriate share classes and portfolios, yet others establish business relationships and so on. approved data is formatted and ran up to mainframe at end of day. Financial Product's information and reformatting logic read from special Matrix tables which in most cases hold SQL string's for data.
• Worked closely with business analyst, recommended technical solutions to client requests.
• Provided technical leadership, responsible for software design and architecture.
• Researched and recommended best technology to fit software needs.
• Data Modeling, responsible for designed and architecture of database, created tables, stored procedures, triggers views thought out development process….
• Development of front end GUI, picked and recommended third party Tools, resolving technical problems and issues concerning speed and efficiency of data communications.
• Developed (Client side) business tears that resolve most of validation issues and do some reformatting.
• Designed and implemented security sub-system to provide access to users and administrators based on permission levels stored in specially designed DB tables. (Also involves server level GUI for assigning permissions)
• Designed and developed Templates subsystem for generating Transactions. (Server level GUI for Templating Transaction Data. Assigning Hard coded as well as soft coded values.)
• Transactions. (Approved plans are written to flat file and send to mainframe) Using COM for numerous business logic modules to format and secure transfer of gigabytes of data into flat files in order to later move it to Mainframe.
• Full project cycle, team environment.
• Testing and fine tuning and Reacting to QA issues (There was very little QA, so it was 90% developer tested, in lab, White box, Functional, Performance, Install/Uninstall, Data Testing, Compatibility Testing).

Environment: Visual Basic 6.0, ADO 2.1, COM, DCOM, MTS, MS SQL Server, ASP, DHTML

Between 1997 and 2000 worked in development of other projects (VB 3.0 - VB 6.0) and MS Access VBA with SQL Server and Oracle dbs and reporting.

EDUCATION:
C#, .Net 2.0 training.
MS from Kean