SUMMARY:

• Software and Capital Markets professional with over 18 years’ experience. Extensive experience in all aspects of the SLDC. Proven track record of successful projects, process improvement and production management.
• Over 10 years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2014/2012/2008/2005/2000 DTS/SQL Server Integration, Reporting & Analysis Services.
• Extensive SQL Development experience in Government, Insurance and Healthcare industries with a strong understanding of data & analytics.
• Hands on experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2014/2012/2008/2005/2000.
• Experience in Upgrading of SQL Server 2000/2005 databases to SQL Server 2005/2008.
• Extensive experience in using T - SQL (DML, DDL) in SQL Server 2014/2012/2008/20005/2000 platforms.
• SQL Azure 2014 in the Cloud
• Oracle 10g/9i/8/7
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
• Expert Experience in Normalization, De-normalization.
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio.
• Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.
• Installation of new SQL Servers and clusters.
• Design, develop and maintain DBA owned business critical functionality
• Design install and deliver applications, jobs, stored procedures, triggers etc.. for DBA owned business critical functionality
• 24/7 responsibility for all Production servers and processes.
• Upgraded and reengineered over 300 DTS to SSIS packages.
• Standardized SQL monitoring using Foglight, OpenView, Remedy and Tidal.
• Maintain uptime and transactional consistency on multiple replication targets
• Scheduled periodic rebuilds of indexes
• Responsible for all performance driven SQL tuning and index construction

TECHNICAL SKILLS:

Operating system: Windows 2008 R 2/2008/2003/2000/ XP, UNIX, LINUX

Clustering: Windows 2008/2003 Clustering w/ SQL 2014 & 2012

RDBMS: SQL Server 2014/2012/2008/2005/2000/7.0/6.5, Oracle 10g/9i//8/7.

ETL: SSIS/DTS, Informatica

Scripting: Kourn Shell, Bash Shell, PowerShell

GUI: C#, VB.NET, Visual Basic 6.0, Visual Studio 6.0

Web: ASP.NET, ASP 3.0/2.0, VBScript, JavaScript, XML

OLAP/Reporting: Analysis Services, SQL Reporting Services, Crystal Reports, ASP

.NET: C#.NET, ASP.NET, VB.NET, ADO.NET

Tools: SourceSafe, Litespeed, Spotlight, SQL Diagnostic Manager,: Jira, Jenkins, TFS, Git hub, SVN

PROFESSIONAL EXPERIENCE:

Sr Oracle Reporting Consultant

Confidential

Responsibilities:

• Data quality assurance within the FBO reporting requirements for the BHC.
• Using various DW design methods to ensure new multi-dimensional model maps to old flat system
• Ensuring the financial numbers match to each division, are submitted correctly to the GL.
• Working with each line of business to ensure correct processing procedures.
• Designing the Database, creating tables, Indexes, writing stored Procedures
• Involved in finding out ways of Query Optimization and in finding out bottlenecks using the SQL Server tools.
• Scheduled Tasks for daily reporting of data quality issues through ssrs reports used as a bases for jira tickets and project reporting
• Filtering Data by using Stored Procedures, views and user-defined Functions.
• Implemented Error Reporting in Stored Procedures, Triggers, user-defined Functions and Transactions.
• Maintained Data Validation through Rules and Defaults
• Involved in database schema design.
• Unit testing the application and bug fixing.
• Maintain, support and make enhancements to the application

Sr SQL Reporting Consultant

Confidential

Responsibilities:

• Working with the client to define requirements.
• Architected and designed all database projects in TFS and fully automated deploy methodologies
• Using various DW design methods to ensure new multi-dimensional model maps to old flat system
• Ensuring the financial numbers match to each division, are submitted correctly to the GL.
• Working with each line of business to ensure correct processing procedures.
• Designing the Database, creating tables, Indexes, writing stored Procedures
• Involved in finding out ways of Query Optimization and in finding out bottlenecks using the SQL Server tools.
• Scheduled Tasks for daily Backup, hourly Backup of Transaction log and Weekly tape backups
• Developed Triggers to maintain Referential Integrity through Primary Key and Foreign Keys
• Tuning and Optimizing Data access.
• Filtering Data by using Stored Procedures, Triggers, user-defined Functions and Views.
• Implemented Error Handling in Stored Procedures, Triggers, user-defined Functions and Transactions.
• Maintained Data Validation through Rules and Defaults
• Involved in database schema design.
• Unit testing the application and bug fixing.
• Maintain, support and make enhancements to the application

SQL Server Developer

Confidential

Responsibilities:

• Extensively involved with development onn MS SQL Server 2008 and MS SQL Server 2012
• Architected and designed all database projects in TFS and fully automated deploy methodologies
• Full support of offshore development and testing teams
• Designing the Database, creating tables, Indexes, writing stored Procedures
• Involved in finding out ways of Query Optimization and in finding out bottlenecks using the SQL Server tools.
• Scheduled Tasks for daily Backup, hourly Backup of Transaction log and Weekly tape backups
• Developed Stored Procedures and Scripts.
• Developed Triggers to maintain Referential Integrity through Primary Key and Foreign Keys
• Importing and Exporting Data was done extensively with the help of DTS.
• Created Stored Procedures and Queries with complex Joins.
• Created tables, indexes, and views.
• Tuning and Optimizing Data access.
• Filtering Data by using Stored Procedures, Triggers, user-defined Functions and Views.
• Implemented Error Handling in Stored Procedures, Triggers, user-defined Functions and Transactions.
• Maintained Data Validation through Rules and Defaults
• Involved in database schema design.
• Unit testing the application and bug fixing.
• Maintain, support and make enhancements to the application

SQL Server Database Administrator Consultant

Confidential

Responsibilities:

• Extensively involved with installations and providing production support on MS SQL Server 2008.
• Involved in finding out ways of Query Optimization and in finding out bottlenecks using the SQL Server tools.
• Scheduled Tasks for daily Backup, hourly Backup of Transaction log and Weekly tape backups
• Developed Triggers to maintain Referential Integrity through Primary Key and Foreign Keys
• Importing and Exporting Data was done extensively with the help of DTS.
• Tuning and Optimizing Data access.
• Maintained Data Validation through Rules and Defaults
• Involved in database schema design.
• Unit testing the application and bug fixing.
• Maintain, support and make enhancements to the application
• Designing and implementing standards for the department.

SQL Server, Sybase Database Administrator

Confidential

Responsibilities:

• Extensively involved with installations and providing production support on MS SQL Server 2008.
• Designing the Database, creating tables, Indexes, writing stored Procedures
• Involved in finding out ways of Query Optimization and in finding out bottlenecks using the SQL Server tools.
• Scheduled Tasks for daily Backup, hourly Backup of Transaction log and Weekly tape backups
• Developed Stored Procedures and Scripts.
• Developed Triggers to maintain Referential Integrity through Primary Key and Foreign Keys
• Importing and Exporting Data was done extensively with the help of DTS.
• Created Stored Procedures and Queries with complex Joins.
• Created tables, indexes, and views.
• Tuning and Optimizing Data access.
• Filtering Data by using Stored Procedures, Triggers, user-defined Functions and Views.
• Implemented Error Handling in Stored Procedures, Triggers, user-defined Functions and Transactions.
• Maintained Data Validation through Rules and Defaults
• Involved in database schema design.
• Unit testing the application and bug fixing.
• Maintain, support and make enhancements to the application

Corporate Database Administrator

Confidential . - Trevose, PA

Responsibilities:

• 24x7 Production servers availability w/ on-call pager participation
• 400 SQL Servers w/ 2000 user database. 200 TB of data.
• Install/Configure/Maintain/Administer SQL Server 2008/2005 instances
• Performance Tuning.
• Code reviews and implementation.
• Database Administration and development.
• Designing the Database, creating tables, Indexes, writing stored Procedures
• Query Optimization and resolving bottlenecks using the SQL Server tools.
• Scheduled Tasks for daily Backup, hourly Backup of Transaction log and Weekly tape backups
• Developed Stored Procedures and Scripts.
• ETL, Data migration/porting with SSIS & DTS.
• Tuning and Optimizing Data access.

SQL Server and Oracle DatabaseAdministrator

Confidential

Responsibilities:

• Creation of triggers, tables, and stored procedures, cursors, sub queries, joins, indexing, integrity constraints and views to enhance functionality of the project
• Involved in finding out ways of query optimization and bottlenecks through the usage of tools. Solved the problems by re-configuring parameters, creating/ rebuilding indexes, running DBCC commands, recompiling stored procedures and updating statistics page.
• Analyzing the database and backend objects requirements and designing the databases in the normalized forms
• Created a design document for solving their reporting needs with specific details to migration from Text files to SQL.
• Left state service for private industry

Application Developer II

Confidential

Responsibilities:

• Web design, various departmental applications.
• Promoted to DBA, DEP.

Application Developer I

Confidential

Responsibilities:

• ETL Monthly load process.
• Add new areas to star schema
• Promoted to Application developer II

Information Systems Auditor

Confidential

Responsibilities:

• Hired full time as information systems auditor