SUMMARY

• Over 8 plus years of IT experience with exceptional skills in all phase of SDLC, which includes Requirement gathering, Analysis, Database Design, Development, Administration and Support of Microsoft SQL Server 2000/2005/2008 R2/2012 in Development, Test and Production Environments with various business domains like Financial, Education and Healthcare
• Extensive working experience in Database Administration, Implementation, T - SQL Scripting, Reporting Services, Integration services, database design and development in SQL Server 2000/2005/2008 R2/2012
• Failover cluster testing and resolution on production servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration. Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Worked in USA, UK and India.
• Developed & supported various mission Critical Client Server applications by handling Database requests for various application development teams involving complex business logic, functionality.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.
• Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
• Experience in Diagnosing and Troubleshooting performance issues in SQL Server Databases
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Test & Deploy code across various SDLC Environments like DEV, TEST, UA/UT, and Production.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) ( 2000/2005/2008 R2/2012).
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Created SSIS Packages using Pivot Transformation, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files etc.
• Extensive knowledge of Designing, Developing, Atomization and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Experienced administrator for development and maintenance of database.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Expertise in creating Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Very Strong on tools such as Erwin Data Modeler used for logical and physical data modeling and have full understanding of the Software Development Life Cycle (SDLC)

TECHNICAL SKILLS

Operating Systems: Windows All Versions and Windows Server

Databases: MS SQL Server 2005/2008 R2/2012, My SQL, Oracle

Languages: T-SQL, PL/SQL, C, C++

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2005/2008/2012 , Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, OSQL, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS), VMWare, Jupiter network

Report Tools: MS Reporting Services, SAS

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard

Version Control: Team Foundation Server (TFS), Visual Source Safe (VSS)

PROFESSIONAL EXPERIENCE

Confidential - Tampa, FL

Lead Database Administrator / Developer

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Responsible for the contribution to the smooth running of a business, leading a team in a positive manner by providing best solutions of technical and functional problems.
• Coordinating with the Systems Administration team, install and maintain application software and system that integrate database systems.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Creation of new databases, planning the location of data, index, and Transaction log files on disks.
• Planning and scheduling backups and developing recovery procedures.
• Worked on Integrity, blocking, Locking and Deadlocking related Security Issues
• Develop scripts to automate administration and management
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard with fully atomization.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Migrating Databases from SQL Server 2008 to SQL Server 20012.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Responsible to Monitor and troubleshooting Log Shipping.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.

Confidential - Arlington, VA

Database Administrator / Team Leader

Responsibilities:

• Handled 8 database developers including their day to day activities, Daily assignments and their technical problems.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio and monitor it on live environment and troubleshoot errors within timeline
• Responsible for create/maintain well optimized queries, stored procedures, views and triggers
• Database tuning and performance monitoring
• Implemented disaster recovery solution at the remote site for the production databases using Log Shipping.
• Setup backup and restoration jobs for development and QA environments
• Take care of the Database design and implementation
• Plans and implements backup and recovery of the databases
• Responsible for technical documentation, user documentation and requirements specifications.
• Developed flow diagrams, documented the high level and user level documentation, developed user guides.
• Participated in requirements gathering and design sessions based on business processes, requirements and system designs.
• Developed Requirement specifications and process diagrams including context, dataflow diagrams in MS-Word and MS-VISIO.
• UML was used for Visual modeling and a detailed Use Case Specification was developed to describe the design, architecture and dynamic behavior of the system.
• Use Case analysis using UML and RUP was done to meet the changing Customer Requirements and complexity of the project.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Analyzed requirement document by identifying ambiguous, incomplete and incorrect requirements.

Confidential

Senior Technical Analyst & Administrator

Responsibilities:

• Extensively utilized SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing application.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations to transfer the data from Facility to Progresso using SSIS
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table and E-mail notification for success and failure for each package.
• Implements System activities related to long-range plan.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Involved in code review for existing T-SQL code and SSIS Packages.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Actively involved Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio
• Created Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views, Joins and other T-SQL code for applications following SQL code standards.
• Performance Tuning for Existing T-SQL code to retrieve the data faster.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Responsible for developing, monitoring and deploying T-SQL Code and SSIS packages in production.
• Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services
• Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security.
• Created weekly and monthly reports as per requirement using SSRS.

Confidential - New York. NY

Sr. Developer / Technical Analyst

Responsibilities:

• Configured SQL server Reporting services (SSRS)
• Configure and maintain auto email system as per client requirement
• Used the Microsoft BI Stack tools like some of the components Excel, Power Pivot for Excel, Data Mining and Visio.
• Used the Microsoft BI stack tools like Share Point Server, and BI tools like integration services, reporting services and analysis services.
• Participating in all phases of software development lifecycle: requirements analysis, technical design, implementation, acceptance testing, and warranty support.
• Created queries and manipulated the data
• Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2008.
• Created various SSIS/DTS Packages as per business requirements. Modified existing packages to in corporate changes and to improve performance.
• Database Developer for Development, Test and Production servers with MS SQL Server 2008 on Windows XP/Vista.
• Installed, configured, administered and secured SQL Server 2008 on Server and Clients.
• Data migration is done by cleansing the data
• Using SQL SERVER created complex Queries for Data Migration and Transformation.
• Involved in Querying (SQL queries) and updating records and validate Database records as expected.
• Working extensively on the data warehouse and analyzing for cleansing the data.
• Used Performance Point Server to provide users with rich dashboard filters to dynamically filter all the report views displayed on the dashboard.
• Set naming conventions for objects based on SQL standards.
• Proactively identifying and resolving application performance issues.
• Communicating with both technical and non-technical staff to support analysis, design, testing, and troubleshooting of project issues.

Confidential

Database Architecture

Responsibilities:

• Responsible for technical documentation, user documentation and requirements specifications.
• Developed flow diagrams, documented the high level and user level documentation, developed user guides.
• Participated in requirements gathering and design sessions based on business processes, requirements and system designs.
• Developed Requirement specifications and process diagrams including context, dataflow diagrams in MS-Word and MS-VISIO.
• UML was used for Visual modeling and a detailed Use Case Specification was developed to describe the design, architecture and dynamic behavior of the system.
• Use Case analysis using UML and RUP was done to meet the changing Customer Requirements and complexity of the project.
• Analyzed requirement document by identifying ambiguous, incomplete and incorrect requirements.