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 knowledge 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 the 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 knowledge 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 the 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 the Suspect and Damaged Databases.
• Worked with developers to do the database schema changes and database restore requests
• Analyzed the tables and rebuild the indexes whenever needed to improve the performance.
• Performing Full, Differential database backups and transaction log backup.
• Extensive interaction with the 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 the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Deployed and configured the reports in the 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 that 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 the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the 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 the 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 the Design of Summary tables required for efficient Report Design.
• Created complexSQL stored procedures using Microsoft SQL Server 2008 and 2008 R2
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2.
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.
• Performed the 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 the cubes by connecting to Analysis server from SSRS.
• Developed the 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 the 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 the data warehouse Analysis services and develops the different reports for the 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 the cube for analysis and validation of the data. Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• Extensively involved in the 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 the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the 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 the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Lead the 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 the 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 the reports in the Report Server.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Generated test data and tested database to meet the functionalities deliverables in the 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 the 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.