SUMMARY

• Over 8 years of experience in SQL Serverdatabase development, extensively worked in OLTP, OLAP environment & development databases as a Developer/DBAin different domains including Travel, Utility, Telecom and Educational environments.
• Extensive experience with SQL Serverand T - SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Hands on experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to assist efficient data manipulation and data consistency.
• Well versed in Normalization/ Denormalization techniques for optimum performance in relational and dimensional database environments.
• Hands on Experience in using tools like Dynamic Management Views, Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL ServerIntegration Services ( SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Developed, monitored and deployed SSISpackages.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio
• Created Cross-Tab, Drill-down, Drill-through, Tablix, and Sub-Report using RDL.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) 2012/ 2008R 2/ 2008/2005.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Strong Experience in Report Development, Modeling (Relational, DMR) and Dash Board Report in Performance Point, Targit.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Serverand other heterogeneous relational database such as Oracle and DB2.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.

TECHNICAL SKILLS

Database: MS-SQL Server 2014/2012/2008/2005 , Oracle 10g/9i/8i, Sybase AES 12.5/15.0/15.5/15.7 , Quickbase, MS Access

Operating System: Windows Server 2012/2008/2003 , Windows 95/98/XP, UNIX.

SQL Server Tools: SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database Engine Tuning Advisor, SSIS, SSRS, Microsoft Clustering Services (MSCS)

Software: Embarcadero Change manager, Doubletake Replication, Apex SQL Log, OPCON Enterprise Manager, APPDynamics, IBM Rational Clearcase, ERwin, SAS, MySQL, Visual Studio, SQL Litespeed, TIBCO Spotfire, Netezza,VERITAS Net backup, Visual SourceSafe, TFS,VMware,Quickbase.

ETL Tools: IBM Datastage, MS-DTS, SSIS, BCP, Import/Export wizard.

Reporting Tools: SSRS, SSAS, Microstrategy, TIBCO Spotfire

Languages: T-SQL, PL/SQL, C/C++, HTML, XML,VB.NET

PROFESSIONAL EXPERIENCE

Confidential, Miami, Florida

Application SQL Server DBA

Responsibilities:

• Design and developed automated database refresh for all the system test and UAT environments from production backups for Scrum team’s development and testing.
• Design and develop data movements using SQL Server Integration Services, TSQL and Stored Procedures
• Work with the business to determine logical design for new business solutions.
• Hands on experience working with and troubleshooting databases in SQL Server 2014 Always-On Environment.
• Create and work with In-Memory OLTP Databases in SQL Server 2014 for Session State databases.
• Perform code reviews, analyze execution plans, and re-factor inefficient code
• Follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes
• Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements
• Collaborate with IT operations and testing organizations to ensure timely releases of projects and make sure database environments are sustainable
• Support IT staff and business users in the development, usage and troubleshooting of database-driven applications.
• Conduct system tests, troubleshoot customer issues and correct database defects.
• Worked on Exception Handling with @@error and with Try/catch and resolving locking/deadlocks
• Use customer requirements to improve functionality (speed, performance / usability)
• Work with several Scrum teams and troubleshoot bugs and SNAP incidents (P1/P2/P3) concurrently under aggressive deadlines
• Work with production DBA’s to test and implement SQL backup strategy based on the business needs, utilize the combination of full, differential and transactional log backup to ensure all necessary business data is properly backed up.
• Worked with webops team and pro-actively monitored expensive sql queries, blocking, timeouts and deadlocks using Appdynamics.
• Setup Transactional Replication to synchronize a subset of tables to multiple subscribers in real-time for reporting purpose which separates the readers and writers to avoid blocking issues.
• Define SQL profiler templates to capture different types of SQL activities, such as long running queries and deadlocking. Develop the process to invoke the SQL profiler trace to run in the background based on the schedule and import the trace files into SQL tables for sorting and further analysis
• Work with Production DBA’s and develop T-SQL scripts to perform index maintenance for very large SQL databases, which first checks the actual index fragmentation level and take different actions based on the average fragmentation level.
• Setup and Schedule jobs for SSIS packages in OPCON Enterprise Manager and troubleshoot upon failure of jobs.
• Provided 24x7 support on a rotational basis for weekends and during production code deployments.

Environment: SQL Server 2014/2008/2005/2000 , Windows Server 2012/2008/2003 , SQL Management Studio, SQL Profiler, SSIS, Performance Monitor, Appdynamics, OPCON Enterprise Manager, IBM Rational Clearcase, Sitecore, Splunk, Service Now(SNAP), Beyond Compare, Visio, MS Access,TFS

Confidential, New York

Sr. SQL DBA/ Developer

Responsibilities:

• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Created SSIS packages for data Importing, Cleansing, and Parsing. Extracted, cleaned and validated.
• Kimball Data ware house by ETL tool extract Data modeling in Star schema also work on full life-cycle BI implementation and Teradata.
• Configured report builder and trained business users so that they could create reports from the report models, I made
• Prepared the Layouts by placing the fields to the appropriate place of the final Report.
• Developed ETL, using SQL Server 2008 R2/2012 Integration Services to migrate data from Oracle data source into a SQL Server 2008 database and creating complex SSIS packages, DTS Packages.
• Wrote T-SQL queries, Store Procedures and used them to build packages and maintain the history of the data.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
• Used multiple join statements to retrieve data from multiple tables
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Deployed and configured reports in SharePoint Server.
• Developed collaboration and digital asset management system based on SharePoint 2008, and SQL Reporting Services
• Created standard & Data driven report subscriptions. Snapshots report and cache for better performance.
• Creating Logical, Physical data model using SQL server, Erwin, MS Visio.
• Involved in code reviews meetings and designing sessions and get mentored from the tech leads.
• Strong experience in Database design and multi-dimensional modeling (star schema and snowflake schema), data cleansing, scrubbing and integration.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status, MIS reporting & MDX Scripting experience with SSRS

Environment: MS SQL Server 2008/2012, T-SQL, SSIS packages, DTS Packages, VSS, SSRS, MS Excel, Visio, Erwin, SQL Server Analysis Services, SharePoint, Teradata, MS Office 2010/2007, Microsoft Office Share Point - 2010

Confidential, Irving, Texas

SQL DBA/ Developer

Responsibilities:

• Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon),Star and Snowflake schema design
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Bulk data migration using SSIS from flat files.
• Extensive knowledge of FTP and local file management
• Experience working with querying from linked servers inSQLServer
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created different Parameterized Reports (SSRS 2008/2012) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Upgraded GRS DB from SQL Server2005 to SQL Server2008.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters
• Closely worked with .Net, SharePoint developers.
• Collected business requirements from Stake holders and translated them as technical specs and design docs for development.
• Participated in Scrum meetings, Discuss with Architect’s regarding the Designs and frame works.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Created pages in the reports to display depend on Prompt values.
• Extensive working knowledge on ADO.Net connection managers.
• Developed Chart Reports, Drill through Reports, Master Detail Reports and Multiple Reports use the MDX for reporting.
• Good understanding of MDX concepts.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL Server2012/2008, SSIS/SSAS 2008, SSRS 2008/2005, Windows Server 2003, C#,ASP.NET, VB.NET, SharePoint,Agile and Waterfall.

Confidential, Tucson, AZ

SQL BI/SSIS SSRS Developer

Responsibilities:

• Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications
• Created Clustered and Non Clustered indexes on tables to speed up OLTP query performance
• Worked on Exception Handling with @@error and with Try/catch and resolving locking/deadlocks
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Evaluate and monitor database performance and carry out maintenance duties such as performance tuning, backup, restoration and disaster recovery.
• Experience in design and documentation of Logical and Physical data models using ERWin tool
• Administered all SQL server database objects, logins, users and permissions in each registered server.
• Managed Database files, transaction log and estimated space requirements for Capacity planning purposes
• Implemented and successfully tested Log Shipping in SQL Server 2000 and SQL Server 2005.
• Performance Tuning and Maintenance plan for consistency checks, backup/restore and Rebuild Indexes
• Administered creating user logins, monitoring the user accounts, granting the privileges to users and groups.
• Ran various DBCC commands like checkdb/checktable, showcontig, showstatistics for checking db consistency
• Involved in installing SQL Clustering for production environments, implementing Log Shipping
• Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment.

Environment: MS SQL Server 2005/2000,SSIS, SSRS, DTS, SQL Management Studio, SQL Server Business Intelligence Tools, Windows 2003, SQL Server Query Analyzer, SQL Profile