SUMMARY

7+ of IT Experience in Database Design, Development, Implementation and Support of Microsoft SQL Server 2008/2005/2000 in Development, Testing and Production Environments with various business domains like 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 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).
• Good experience in working with Agile Methods like Scrum, Open Agile, Lean.
• Experience in Configuring and Managing Linked Servers, Data Transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Good experience in Creating, Testing and deploying SSIS Packages.
• Excellent skills in High Level Design of and implementing ETL packages using SSIS 2008/2005 for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• 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 uploading files to a Report Server Catalog from the Report Manager and deploying reports on Microsoft Office SharePoint Server (MOSS).
• Experience in administrating the 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, C#, VB.NET, ADO.NET.
• 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

• Languages

: C, T-SQL, PL/SQL, JavaScript, C#.

• RDBMS

: SQL Server 2008/2005/2000, 7.0, MS-Access, Oracle Database 11g/10g/9i, DB2, MySql, and Teradata V2RX.

• Front End

: MS Visual Basics 6.0.

• Web Technologies

: HTML, XML, JavaScript, PHP.

• Version Controlling Tools

: Visual Source Safe, Rational ClearCase.

• SQL Server Tools

: SQL Server Management Studio (SSMS), Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio (BIDS), SSIS, SSAS, SSRS, Data Transformation Services.

• Web Server Technologies

: IIS 5.1/6.0.

• Data Modeling Tool

: ERwin r7.3/7x/4.0, MS Office Visio 2003/2007.

• Operating System

: Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7, Unix.

• Methodologies

: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE
Confidential,Newbury Park, CA April 2011 – Till date
Senior SQL Server BI Developer

Responsibilities:

• Involved in developing E-R diagrams, Logical & Dimensional Modeling, Development and Implementation of the system.
• Involved in Database Development 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.
• Migrated DTS packages to SSIS 2008 using DTS Package Migration Wizard.
• 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) 2008.
• Involved in Preparation/Author of ETL tools and packages to extract heterogeneous data from Excel, Flat file, OLE DB Source (Oracle, DB2) to SQL Server 2008.
• Wrote the ETL scripts to load the data into database from various sources like Flat files, XMLs etc. Involved in error handling and troubleshooting the scripts in failure to load the data into database.
• Used PIVOT/UNPIVOT operations to turn rows into columns and vice versa to normalize table structure of the database which doesn’t meet the desired reporting format.
• Populated Data Warehouse using SSIS Packages and implemented Kimball methodology.
• Implemented Type I, II, III changes in Slowing Changing Dimension (SCD) Tables.
• Migrated and recreated existing Dimensions and Cubes using Star schema on SQL Server 2008 to achieve the efficiency of Microsoft SQL Server Analysis Services (SSAS) 2008.
• Assisted in OLAP cube analysis and implementations.
• Created SQL Server reports using Microsoft SQL Server Reporting Services (SSRS) 2008.
• Worked with Reporting Services Report Servers in SharePoint Integrated Mode.
• Generated reports using Global Variables, Expressions, and Functions for the reports.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Sub-reports and Linked reports using SSRS and integrated into the web front end
• Developed and Deployed different types of reports like Drill Down, Drill Through, List, Tabular, Chart and Sub Reports etc.
• Monitored and Tuned SQL server Database Performance and Query Analysis for optimizing report performance.
• Involved in Documentation, testing and implementing solutions using applicable SSIS and SSRS technologies.

Environment: SQL Server 2008, 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.

Confidential,Los Angeles, CA Oct 2010-Mar 2011
SQL Server BI Developer

Responsibilities:

• Responsible for writing complex stored procedures to meet the business requirements.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment on SQL Server 2008.
• 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.
• Used SQL Profiler to estimate the Slow Running queries for Performance Tuning.
• 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 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.
• Created matrix and tabular reports with drill down, drill through and drop down menu option 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: MS 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.

Confidential,Billerica, MA Oct 2009 - Sep 2010
SQL Server BI Developer

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.
• Worked on importing data from MS-Access Database and XML to SQL Server Database.
• Worked with development teams in the design of physical databases and in modification.
• 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 Data Conversion, 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.
• Developed Master report template for application semantics.
• 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 2005 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, deployed and maintained various SSRS Reports in SQL Server 2005.

Environment: SQL Server 2005 Enterprise Edition, MS Visual Studio 2005 (SSIS, SSAS, SSRS), MOSS 2007 Dashboards, Oracle Database 10g, Enterprise manager, MS PowerPoint, MS Access 2007,Erwin 7x.

Confidential,Cleveland, OH Mar 2008-Sep 2009
SQL Server BI Developer

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.
• Worked on various financial products like equities, funds, fund of funds, derivates, bonds, treasuries, notes, warrants, currency contracts, futures, options etc.
• Involved in Data Warehouse design and imported data from various sources into a Staging area and merged the data into OLTP Data Model.
• Imported data from various sources into a staging area and merged the data in to the OLTP data model.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Created SSIS packages with error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis and tested them.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Run DBCC consistency checks, and fixed data corruption in application data bases.
• Extracted the data from SQL Server databases using SSIS and developed cubes in SSAS.
• Excellent report creation skills using SSRS.
• 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.
• Developed reports using SSRS 2005 and used table control, matrix control for cross tab reports.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, MS Visual Studio 2005 (SSRS, SSIS, SSAS), Windows Server 2003, MS Access 2007, Oracle 9i.

Confidential,Stamford, CT Oct 2006-Feb 2008
SQL Server BI Developer

Responsibilities:

• Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Tested and implemented Database Mirroring solution for Production critical application.
• Involved in Data Warehouse Design and analysis of various approaches for maintaining different Dimensions and Facts in the process of building Data Warehouse applications.
• Implemented Error Handling using Try Catch block introduced in SQL Server 2005.
• Migrated from DTS to SSIS 2005 using DTS xChange.
• Created SSIS Packages for testing and cleaning the standardized data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge Join, Sort, Union All, Lookup Transformation) in SSIS
• Populated Data Warehouse using SSIS Packages.
• Debug reports in SSRS and deploy reports on Report Server and MS Office SharePoint Server (MOSS).
• Created reports from cubes using SSRS 2005.
• Participated in the migration from SQL Server 2000 to SQL Server 2005
• Designed, managed and published various Dashboards, Score cards using SSRS.

Environment: T-SQL, SQL Server 2000/2005, Windows 2000 Server, MS Visual Studio 2005 (SSRS, SSIS, SSAS), Query Analyzer, MS Access 2003, Erwin 4.0.

Confidential,Chennai, India Jan 2004-Aug 2006
SQL Server Developer/DBA

Responsibilities:

• Involved in installation and configuration of SQL server 2000 on servers.
• 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 and maintained database security.
• 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.
• Data conversions and data loads from various databases and file structures.
• 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.
• Maintained User account administration for Different domains.

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

EDUCATION

• Bachelor of Engineering in Computer Science