SUMMARY

• Over 8 years of IT Experience in Database Design, Development, Implementation and Support of Microsoft SQL Server 2012/2008/2005/2000 in Development, Testing and Production Environments with various business domains like Manufacturing, Financial, Banking, Communications, and Healthcare.
• Solid knowledge of Relational Database Management System RDMS , Data Warehouse Concepts, OLTP OLAP and experience with MS SQL Server in writing T-SQL, Working on SSIS, SSAS, SSRS, Data Analysis, Data Cleansing/Data Scrubbing and Data Migration.
• Experience in writing Complex Stored Procedures, Indexed Views and DDL/DML Triggers for data consistency and manipulation.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
• Hands on experience in installing, configuring, managing, upgrading, monitoring and troubleshooting SQL Server 2012/2008 R2/2008/2005/2000.
• Experience in MS SQL Server Database Administration including Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
• Experience in migrating from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to SQL Server 2008.
• Extensive experience in Monitoring and Performance Tuning SQL Server database using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Windows Performance Wizard for optimal performance.
• Experience in Analyzing Execution Plan, managing indexes and troubleshooting deadlocks.
• Hands on experience with Load Testing, Integration Testing and User Acceptance Testing UAT .
• Good knowledge of Software Development Life Cycle SDLC .
• Experience in working with Agile Methods like Scrum, Open Agile, and Lean.
• Hands on experience in deployment of SQL Server applications.
• Good experience in Creating, Testing and deploying SSIS Packages.
• Excellent skills in High Level Design of and implementing ETL packages using SSIS 2008/2005.
• Experience with ETL framework standards including error processing, validation and data reconciliation.
• Experience in Designing and Building the Dimensions and cubes with star schema using SSAS 2008/2005.
• Experience in Data Warehouse Design and analysis of various approaches for maintaining different dimensions and facts in the process of building a data warehouse application.
• Experience in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using ERwin Tool and MS Office Visio.
• Good experience in trouble shooting the SSRS Report Servers in SharePoint Integrated Mode.
• Proven ability in generating Drill down and Drill through reports with Drop down option, Ad-Hoc Reports, Parameterized reports, sub reports, linked reports, sorting the data and defining subtotals in SSRS 2008/2005.
• Excellent hands on experience in reports on Microsoft Office SharePoint Server MOSS .
• Experience in configuring and administering crystal reports and assigning permissions to the valid users for executing the reports.
• Hands on experience in writing MDX queries in Analysis Services and Reporting Services.
• Experience in Designing, Developing and Maintaining Web Applications using Visual Studio .NET, ASP.NET MVC 3, C , VB.NET, ADO.NET.
• Significant experience in 24/7 Production Environment Support.
• Experience in working in tight schedules, result oriented committed to meet the goal.
• Have relevant Technical skills, Analytical skills, Managerial skills, Interpersonal skills, and Organizational skills.
• Have very strong verbal and written skills.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Tech Lead, SQL Server Developer DBA

Responsibilities:

• Involved in implementing Agile Scrum Methodology for EREV 120K Expansion project including Extreme Programming and Test-Driven Development.
• Involved in developing E-R diagrams, Logical Dimensional Modeling, Development and Implementation of the system.
• Developed Databases using complex Stored Procedures, Triggers, Functions, Constraints, Indexes and Views as required in a SQL Server environment.
• Performed backup/restore the database objects and User Security Management.
• Dealt with Fine-Tuning stored procedures to improve performance with a Query Plan using SQL Tuning Advisor.
• Created, loaded, and modified new packages added and configured components by using Control Flow Tools and Data Flow Tools in Microsoft SQL Server Integration Services SSIS .
• Created ETL tools and packages to extract heterogeneous data from Excel, Flat file, XML, OLE DB Source Flexnet, PMC to SQL Server.
• Implemented error handling and resolved issues by troubleshooting the scripts in failure to load the data into database.
• Populated Data Warehouse using SSIS Packages and implemented Kimball methodology.
• Implemented Type I, II, III changes in Slowing Changing Dimension SCD Tables.
• Deployed SSIS packages dynamically into Development, Testing and Production environments by creating Environment variables and Windows variables.
• Developed SQL Server Reporting Services SSRS reports using Global Variables, Expressions, and Functions and worked with Report Servers in SharePoint Integrated Mode.
• Developed and deployed different types of reports like Drill Down, Drill Through, Parameterized, List, Tabular, Chart, Linked and Sub Reports etc. using SSRS and integrated into the web front end Predisys .
• Converted existing crystal reports to SSRS.
• Monitored and Tuned SQL server Database Performance and Query Analysis for optimizing report performance.
• Configured and administered and SSRS Reports and Crystal Reports for PR T MSDB Web reporting.
• Configured and monitored Cimplicity screens.
• Analysis and documentation of SSIS packages and existing reporting system
• Designed test plans in Quality Center and written test cases for unit level, functional and integration testing.

Environment: SQL Server 2012/2008 R2/2008/2005, T-SQL, Cimplicity, Crystal Reports 2011, MS Visual Studio 2008 SSIS, SSRS , Query Analyzer, Enterprise Manager, Dashboards, C , ASP.Net, Star Team, ERwin r7.3.

Confidential

Senior SQL Server BI Developer

Responsibilities:

• Involved in Data Warehouse Design and analysis of various approaches for maintaining different Dimensions and Facts in the process of building a Data Warehouse application.
• Designed logical and physical database structure to facilitate data analysis from both operational and customer perspectives.
• Installation, Configuration and Security of SQL Server production servers.
• Used SQL Profiler to estimate the Slow Running queries for Performance Tuning.
• Deployed SQL Server applications, including installation, fail-over, disaster recovery and overall management.
• Migration: Copied production SQL Server 2005 databases to test server running Windows 2003 Advanced Server and SQL Server 2008
• Developed automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Developed SSIS solution for developing a full-fledged data warehouse solution.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB source Oracle , Excel Spreadsheet to SQL server 2008 and deployed the packages.
• Migrated existing SSIS 2005 packages into SSIS 2008 using SSIS Upgrade Wizard.
• Involved in Designing, Processing and Partitioning Cubes using Microsoft SQL Server Analysis Services SSAS .
• Created Measures, Key Performance Indicators KPIs and defined Actions, Translations and Perspectives.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Scheduled reports for daily, weekly, monthly reports for Executives, Business Analysts and Customer Representatives for various categories and regions based on business needs using SSRS.

Environment: SQL Server 2008 R2/2008/2005, T-SQL, MS Visual Studio 2008 SSIS, SSAS, SSRS , Query Analyzer, Enterprise Manager, Dashboards, Windows 2003, MS Access 2007, C , ASP.Net, Oracle Database 11g, Rational ClearCase 7.1.2, ERwin r7.3.

Responsibilities:

• Created the complex stored procedures, user defined functions to meet the business rules.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Used Visual Source Safe for version control.
• Involved in Incremental Loading of Data Warehouse using SSIS and Change Data Capture.
• Developed High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources Excel, CSV, Oracle, Flat File, Text Format Data by using multiple transformations provided by SSIS such as Conditional Split, Bulk Insert, Merge and Union All.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Designed high level ETL architecture for overall data transfer using SSIS from the source server to the Enterprise Services Warehouse, which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Migrated and recreated existing Dimensions and Cubes using Star Schema on SQL Server 2008 to achieve the efficiency of SSAS.
• Created Drill down reports, Ad-hoc reports, Drill through reports using ROLAP as source.
• Customized the reports using Java Script as per the client requirement.
• Responsible for creating the reports using the SSRS and maintained them. Used the various parameter-passing techniques to create input for reporting parameters.
• Created multiple reports SSRS in Drill mode using financial tables, cross tabs and charts.
• Designed test plans and test cases for User Acceptance Testing UAT

Environment: SQL Server 2008/2005, T-SQL, MS Visual Studio 2008 SSIS,SSAS,SSRS , Visual Basic 6.0, ASP.NET, C .NET, DB2, Oracle Database 11g, MS Excel, MS Power Point, ERwin 7x.

Responsibilities:

• Extensively used T-SQL in constructing Stored Procedures, triggers, cursors, tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Performance tuning and optimization of Stored Procedures and Queries.
• Developed administrative tasks for SQL Server for performing Backups and Recovery Procedures like Log Shipping.
• Involved in Data Warehouse design, imported data from various sources into a Staging area, and merged the data into OLTP Data Model.
• Debug reports in SSRS and deploy reports on Report Server and MS Office SharePoint Server MOSS .
• Migrated from DTS to SSIS 2005 using DTS xChange.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS and send the reports via email.
• Defined report layouts for formatting the report design as per the needs.
• Created SSIS packages with error handling and worked with different methods of logging in SSIS.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Run DBCC consistency checks, and fixed data corruption in application databases.
• Extracted the data from SQL Server databases using SSIS and developed cubes in SSAS.
• Developed reports using SSRS 2005 and used table control, matrix control for cross tab reports.
• Debug reports in SSRS and deploy reports on Report Server and MS Office SharePoint Server MOSS .
• Worked on querying data and creating on-demand reports using Report Builder in SSRS and send the reports via email.
• Defined report layouts for formatting the report design as per the needs.

Environment: SQL Server 2008/2005, T-SQL, MS Visual Studio 2005 SSRS, SSIS, SSAS , Windows Server 2003, MS Access 2007, Oracle 9i.

Responsibilities:

• Involved in installation and configuration of SQL server 2000 on servers.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Defined various facts and dimensions in the data mart including Fact less Facts and designed the Data Mart defining Entities, Attributes and relationships between them.
• Implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Fine-tuned Stored Procedures, using Execution Plan in T-SQL for better performance.
• Troubleshoot and minimize production down issues.
• Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.
• Created, Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Generated reports using Crystal reports.
• Monitored failed and long running MS SQL Server jobs.
• Monitored, tuned, and analyzed database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2005/2000, T-SQL, DTS, MS Visual Studio 2005 SSIS, SSRS , Crystal reports 7, Windows 2000 Server, .Net Programming, VSS 4.0.