SUMMARY:

• 16 years of IT Programming/System Analysis/DevOps/Data Analysis/DBA combined experience
• 8+ years of MS SQL Server DB Administration/Maintenance - SQL Server 2005,08R2,12 & 14
• 7+ years of Database Programming - T-Sql/PL-SQL, Index and Trigger Programming
• 8+ years of system maintenance and administration experience including automations of jobs
• Expert knowledge of Microsoft Technology Programing, Reports Development in Client Server and Web Technologies using Crystal Report & SSRS
• Excellent Server Management skills including code deployment and maintenance using SCOM.
• Excellent in Production, Staging and Development Servers installation and maintenance.
• Web Farm Server setup, Citrix Servers maintenance including production support.
• Excellent troubleshooting and communication skills with Project Execution skills.
• Managed production support and then started rotation methods in it by mentoring the support team. Excellent troubleshooting experience in server issues including network issues.
• 2+ years of Microsoft Azure, AWS Cloud Services experience

TECHNICAL SKILLS:

Languages: Java 1.2, HTML, XML, VB, PERL, C#, VB and JavaScript

Software: SSRS, SSIS, Crystal Reports 8.5/10, CF, Install Shield and BizTalk Server 2000

Technologies: ASP, XSLT, IIS, ADO, ASP.NET, VB.NET, WPF, WCF, DevOps and J2EE

OS: Windows 95/98/2000/03/08/2012/ XP/7, Win NT 4.0/2003/2008, UNIX

Tools: Red Gate, Rational Robot, Tableau, VB 6.0, Cloud Tools, Toad, SVN, Git, Idera, MS Visio, MS VISUAL STUDIO, MS Project, SSRS and Dell Spotlight.

Databases: SQL Server 2000/2005/2008 R2/2012/2014, Oracle 8.x/9.x/10g, and IBM DB2

ETL Tool: ODI, SSIS, Informatica 5.1, Cognos, Oracle Apps.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database Administrator/Cloud Migrations & Maintenance

Responsibilities:

• Database Administration and Maintenance of Database servers including Patching/Upgrades.
• Cloud Migration, Cloud Database Administration - Azure, AWS
• Participating in Support Rotation and take care of Support Week activities.
• Server DB Script promotion, Job scheduling in various DB Servers for FF team.
• Monitor database growth activities & Troubleshoot Transaction Log & Space Issues
• Operational DBA activities like monitoring, backup/restore and performance tuning.
• Replication, Mirroring &Log Shipping support. Started working on migrating few to Always ON.
• Work with developers and give them support on their issues or DB restoration or Permissions requests. DevOps Tasks including Continuous Integration and Deploy of DB Scripts.
• Helping build new DB Server setup and installation of softwares/patch management. Setting up SQL Server maintenance jobs - including Index maintenance jobs

Environment: SQL SERVER 2005/2008 R2/2012/14, SSIS, RedGate, Idera, AWS, Spotlight, Visual Studio.

SQL Server DBA

Responsibilities:

• Database Administration and Maintenance of CED’s 570+ profit center Production Database servers.
• Support Developers in Irving Service Center, Maintaining Dev., QA DB servers.
• Client and Server Build Support and installing the build in various DB Servers for QA team.
• Monitor database growth activities & Troubleshoot Transaction Log & Space Issues
• Operational DBA activities like monitoring, backup/restore and performance tuning.
• Supporting Production Server DB restore at the time of hard disk crashes.
• Involving with Development design and support in maintenance of code standards.
• Helping build new DB Server setup and installation of softwares.
• Schedule Backup Jobs for Various Tape & Disk Backups

Environment: SQL SERVER 2005/2008 R2/2012, SSIS, RedGate, MS Excel, Visual Studio.

SQL Server DBA

Responsibilities:

• Optimizing database performance through database performance tuning and creating maintenance jobs. Database Administration and Maintenance.
• Analyzing business data requirements and designing database solutions including writing stored procedure, triggers and functions with SSRS reports development.

SQL Server DBA

Responsibilities:

• Supporting the business 24*7, maintaining 99.9 uptimes, depending on the application and business SLA requirements.
• Monitor database growth activities & Troubleshoot Transaction Log & Space Issues
• Database Administration and Maintenance.
• Operational DBA activities like monitoring, backup/restore and performance tuning.

Environment: SQL SERVER 2005/2008 R2 SSIS, RedGate, Cognos, TeraData, MS Excel

Confidential, Overland park, KS

SQL Server DBA/ Sr DevOps Engineer / Server Administration/Production Support Role

Responsibilities:

• Experience in installation and configuration of MS SQL Server 2005/08 for Confidential Acrosoft.
• Have good experience in Release/Change/Configuration/Service Request/Incident Management with Good documentation
• Experience in Migration from SQL Server 2000 to SQL Server 2005 and 2005 to 2008R2.
• Strong experience in performing database consistency checks, planning and scheduling Backup, Restore and Recovery procedures. Experience in backup and disaster recovery procedures.
• Experience in Query Optimization, Tuning of Stored Procedures, and Performance Tuning.
• Automating manual jobs in DB/ Web Server maintenance & administration of assigned flood system.
• Proactively involved in SQL Server Performance tuning at Database level, T-SQL level and operating system level. Maintained database response times, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Used SQL Profiler, Execution Plan and Performance Monitor.
• Experience in Database Mirroring, Database Snapshot and Isolation Levels.
• Has excellent experience in setting up all types of replication - Snapshot, Merge and Transactional.
• Involved in data modeling for the application and created ER diagram using Erwin.
• Planning and Documenting the current configuration and worked on regaining disk space
• Supporting the business 24*7, maintaining 99.9 uptimes, depending on the application and business SLA requirements.
• Worked on Compression, Index maintenance. Always testing all the activities in Test system before Prod move.
• Monitor database growth activities & Troubleshoot Transaction Log & Space Issues
• Schedule Backup Jobs for Various Tape & Disk Backups
• Extensively worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Excellent T-SQL Programming skills. Maintaining coding standards across the board in all SQL Server environments. Experience in query optimization & performance tuning.
• Extensively worked and had good knowledge on Integration and Reporting Services and good experience in data migration from Oracle/Access/Excel /Flat Files to SQL Server 2005/2008 R2
• Strong experience in Database authentication modes, creation of users, configuring permissions and assigning roles to users. Having good experience in ETL using DTS, SSIS, SSAS and SSRS Reporting.
• Very good understanding in SDLC (Systems Development Life Cycle) with development in .Net technologies
• Good Experience in SCOM 2007 R2 - Deployment, Configuration and using SCOM for Monitor ASP.NET Application, Monitor Network Devices, Monitoring VMware Servers and Monitoring Non-Windows Devices.
• Using Toad, Writing/Debugging Oracle PL/SQL. Good experienced with Oracle DB Development for Reports.
• Having good experience in ETL using SSIS and SSRS Reporting. Familiarity with SSAS.
• Worked closely with web developers, Architects, Quality Analyst and other stake holders.
• Started rotation methods in production support by mentoring the support team. Excellent troubleshooting experience in server issues including network issues.
• Created new Reporting Systems using SQL Server 2005 Reporting Services, Report Viewer controls in VS.Net.
• Modularized and designed a reporting system which can be enhanced and developed independent of the current Flood System.
• Development and Maintenance in existing Crystal Reports using Crystal Report 10.
• Web/Web Farm, Batch and Citrix server configuration and maintenance (using SCOM). IIS Management.
• Lead team in Production Batch Supports by automating batches, problem solving (24x7) and mentoring with experience gained all these years in batch support.

Confidential, Baltimore, MD

Senior Consultant - Database Programming and Report Development

Responsibilities:

• Developed highly complex and customized reports for Federal Govt. by using Crystal Reports/SSRS for Mid-Atlantic Career Consortium Project.
• Involved in SQL Server database administration and maintenance activities along with Database Programming.
• Provides estimates to complete a desired modification; analyze the client’s requirements and suggested and developed the best possible reports keeping in the mind the cost and the feasibility with DLLR’s unique architecture with PDF export facility.

Environment: Crystal Reports 10, Crystal Enterprise Server, SSRS, ASP, XML, XSL, MTS, IIS and .Net Tech using ASP.Net and ADO.Net with SQL Server 2000 Installation, configuration and maintenance of Windows 2000/NT 4.0, FORTE and SQL 6.5 servers

Confidential, Plainsboro/Hopewell, NJ

Business analyst / Tech Lead

Responsibilities:

• Played business analyst, Tech lead roles, collected requirements from business, analysis design including detailed design document preparation with proto type design.
• Supporting offshore teams, functional and system testing by using Rational Robot automated testing tool and delivery of those test scripts. Worked with offshore model and implemented successfully.
• Developed Portfolio Management Reporting reports for MLIM.

Environment: Crystal Reports, MS Project and Rational Robot and SQL Server 2000

Confidential, Plainsboro, NJ

Team and Tech Lead

Confidential

Responsibilities:

• As a Team Lead: Risk Enhancement project involved enhancements to the existing application with the addition of Risk Module. This included a web based interface for maintaining counterparty and the related data regarding its group, credit rating, and capital and risk information.
• The project also involved implementing a reports module (pdf reports) for current and historic dates. Automatic daily pdf reports are created through batch jobs in UNIX.
• Certain jobs were created in PERL for storing historic prices, exchange rates and loan related information. These run at specified time intervals.
• Full responsibility from requirement analysis to development. Lead a 4 member technical during the development of this application with onsite-offshore model
• Client/Onsite Business Analyst- interaction, process implementation and documentations in various stages of the project with on-time successful quality development.

Confidential, Hopewell, NJ

Senior Analyst

Responsibilities:

• Confidential Investment Managers (MLIM) has implemented MOSP (Middle Office Strategic Platform) for supporting their middle office business process
• Analysis and Design including Use case preparation and Unit Test Plan preparation with Development.
• CMM documentation for IT our project SDLC

Confidential, Baltimore, MD

Senior Analyst

Responsibilities:

• Module Lead in Development group in Java Technology Web Programming for TRowePrice.
• Worked for CitiBank Singapore - Java we programming in this period in the same project group
• Project planning and tracking using MS Project 2000 and Reports preparation for CMM

Confidential

Senior Analyst / Team Lead

Responsibilities:

• Requirement collection, Analysis, Effort Estimation, Working Prototype Development in Crystal Report.
• Team Management with Effective Client Interaction with Testing Management
• Technical support to Team Members in ASP, VB/JavaScript, COM, MTS, Crystal Report 8.0 and Oracle

Confidential

System Analyst / Project Lead

Responsibilities:

• Project Lead for Enterprise HealthCare Solution VB product with SQL Server with 5 member team
• Requirement Collection, Design, Estimate, Schedule Preparation/Task Assignment and Development

Confidential

System Analyst / Developer

Responsibilities:

• Doing Client Server Programming with VB & Oracle or Sql Server