SUMMARY

• Over 7 years of IT experience in database administration and development, system analysis, backup/recovery, testing, disaster recovery, Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) and development & support in production using SQL Server 2012/2008R 2/2008/2005/2000.
• Experience in planning and implementing MS SQL server security and database permissions.
• Experience of using various replication models like Snapshot, Transactional and Merge replication (Planning, Replication Tools, Implementing Replication).
• Experience in Storage Capacity planning, including system storage allocation, on - going capacity analysis and planning future storage requirements.
• Good experience and noledge in high availability and disaster recovery features like Clustering, Replication, Log shipping and mirroring.
• Expertise in MS SQL Server 2012/2008R2/2008/2005 and Business Intelligence including SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS 2008.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from /2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Hand on experience in day-to-day User activities like creating logins, granting permissions, applying security for new users and creating user Roles and Role Members to ensure Security.
• Handful experience in installing SQL Server 2000, 2005, 2008, 2008R2 &2012 applying service packs and patches on stand-alone and Cluster Environment and Configuring.
• In depth noledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views using SSMS and SQLCMD.
• Performed database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) using native and third party tools and also Restoring on requirement.
• Developed SSIS packages to Extract, Transform and Load data from various sources.
• Experience in upgrading SQL Server 2005 to SQL server 2008, 2008R2 Versions.
• Experience in migration of databases from lower to higher versions, between different data centers.
• Experience in using Indexes for improving query performance, lower storage and maintenance cost.
• Experience in creating and implementing maintenance plan with stored procedures, T-SQL Scripts to ensure smooth running of SQL server.

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Mac OS X, Windows 8/7/Vista/XP/2003/2000.

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, Visual Studio, ODBC, OLE DB, OLAP, OLTP, DBCC, BCP, PeopleSoft, Informatica, Teradata, TFS.

Other Tools: Lightspeed, Foglight, Spotlight.

DBMS/RDBMS: SQL Server 2014, 2012, 2008 R2/2005/2000, MS-Access 2000/2003/2007 , Oracle 9i & 10g.

Application Packages: MS Office, MS Outlook.

Architecture: Relational DBMS, Clustering, and Replication.

BI/Data Model Tools: Microsoft SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and Microsoft SQL Server Reporting Services (SSRS) on SQL Server 2012/2008R2/2008/2005, DTS, Crystal Reports, Tableau 7.0.

Programming Languages: T-SQL, C, C++, Visual Basics 6.0, VB Script, Shell Scripting, SQL, XML, HTML, JavaScript, Angular JS, CSS, JSON.

Database backup Tools: Red-Gate SQL Backup Pro.

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

SQL Server DBA

Responsibilities:

• Installed and maintained MS SQL Server 2012/ 2008R2/ 2008 on Windows 2008R2/ 2008 servers.
• Administrated teh SQL Server 2012/2008/2005 servers in production, pre-production, non-production databases, Front end Application support and Performance analysis/tuning.
• Using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA)
• Worked with QA on testing procedures and environment setup for testing.
• Worked with SQL Server utilities, backup procedures and recovery processes, SQL Transactional Replication and log Shipping
• Using third party tools such as Quest Lite Speed, Fog light Performance Analysis and Spotlight for backups and monitoring.
• Configured and managed log shipping between DC and DR servers for Disaster recovery solution.
• Configured Database Mirroring with high performance and high availability mode.
• Performed functions like Indexing, Backup Restore, and Query tuning, monitoring, optimization
• Troubleshooting and resolved Application issues, database performance and deadlocking issues.
• Created SSIS packages to Extract, Transform and Load data
• Responsible for disaster recovery/High Availability planning and backup/restore.
• Recovered teh Suspect and Damaged Databases.
• Worked with developers to do teh database schema changes and database restore requests
• Analyzed teh tables and rebuild teh indexes whenever needed to improve teh performance.
• Performing Full, Differential database backups and transaction log backup.
• Extensive interaction with teh end users and all levels of IT staff providing database related support.
• Running DBCC consistency checks and fixing data corruption issues.

Environment: MS SQL Server 2005/2008/2008 R2 64 bit, Enterprise, Windows server 20 bit, Business Intelligence Development Studio - SSIS, and SSRS Performance Monitor, Quest Lightspeed 7.1 & 7.5 and Spotlight Enterprise edition 10.0.2.7001

Confidential, St. Louis, MO

SQL BI Developer

Responsibilities:

• Key role in team of 4 in brining 2005 SQL database environment to SQL 2008R2 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
• Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Generated periodic reports based on teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
• Created On demand (Pull) and Event Based delivery (Push) of reports according to teh requirement.
• Deployed and configured teh reports in teh Report Server.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2008R2 using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with various SSIS packages dat involve Transactions, Restartability and roll back techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making teh system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Schedule teh packages to keep extracting teh data from OLTP at specific time intervals.
• Responsible for rebuilding teh indexes and tables as part of performance tuning.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Developed and maintained Mongo DB Database Servers on physical machines and Virtual machine’s with sharing and replication sets for high availability.
• Worked on Web Storm for better user interfacing experience.
• Worked on Mongo DB database concepts such as locking, transactions, indexes, Sharing, replication, schema design.
• Used SQL Server Agent for scheduling jobs and alerts.
• Configuration and Deployment of all reports across various SDLC environments.
• Deployed teh packages to production using XML package configuration.

Environment: SQL Server 2012/2008R2/2008/2005, SSRS 2008, SSIS 2008, DB2, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe.

Confidential, Orange, CT

SQL BI Developer/ Junior DBA

Responsibilities:

• Worked with Technical Architects and Database analysts for teh Design of Summary tables required for efficient Report Design.
• Created complexSQL stored procedures using Microsoft SQL Server 2008 and 2008 R2
• Designed teh functional and technical documents, report templates and reporting standards for teh developers to work on teh report development.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2.
• Created cubes and dimensions and measures and calculated measures according to teh business requirements.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.
• Performed teh task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Generated reports from teh cubes by connecting to Analysis server from SSRS.
• Developed teh SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to teh database.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• For teh data warehouse Analysis services and develops teh different reports for teh analysis.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
• Experience in creating snapshots of static reports and configure subscription.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing teh cube for analysis and validation of teh data. Processing teh cubes and dimensions on a daily basis using teh SSIS tasks.
• Built cubes for production application, Partitioned Cubes to decrease teh processing time and increase teh performance of teh queries running on front end application using SSAS 2008.
• Extensively involved in teh SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Extracting teh data from teh different sources (CSV files, oracle, and MS SQL 2000) and stored teh data into teh intermediate Staging Database using teh SSIS ETL tool.
• Transform teh data from teh staging database and perform teh transformation using teh Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled teh Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for teh testing team to test teh reports.
• Prepared teh reports for teh day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Lead teh team of developers to write efficient code.

Environment: SQL Server 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ProClarity, MS Excel.

Confidential, Dulles, VA

SQL BI Developer/ Junior DBA

Responsibilities:

• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Created logging, custom logging and error handling packages.
• Deployed SSIS packages and Reports to Production Servers.
• Maintained system monitoring jobs and provide high availability support.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Created and developed teh stored procedures, triggers, views, and user-defined functions to support application development.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Deployed and configured teh reports in teh Report Server.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making teh system more modular, secured and extensible.
• Generated test data and tested database to meet teh functionalities deliverables in teh project documentation and specifications.
• Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2008.
• Worked closely with IT project managers, programmers, and testers.

Environment: SQL Server 2008 Enterprise Edition, SSIS /SSRS 2008, C#, T-SQL, VisualStudio.net, XML, MS Excel, MS Access, Visual Studio 2008.

Confidential

Jr SQL Server DBA

Responsibilities:

• Installation of SQL server on Development and Production Servers, setting up databases, users, roles and permissions.
• Experienced in using SQL 2005 and 2008.
• Assisting development and application maintenance.
• Worked on upgrading teh SQL Server version from .
• Implemented automated backup and database maintenance / cleanup jobs.
• Imported Data from text files and excel spread sheet into SQL Server 2005 database using DTS package.
• Had good experience in 24/7-production support.

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008,Windows XP, Windows NT 4.0, Erwin 3.5.2, Enterprise Manager, SSIS, SQL Query Analyzer, SQL Light speed Backup Software.