SUMMARY

• Over 8 years of IT experience in Database Development and Business Intelligence Technologies with expertise on ETL (SSIS), Reporting (SSRS) and Analyze (SSAS) using MS SQL Server 2008/2005/2000 as a MS SQL Server Developer.
• Experienced in client requirement Analysis, Physical and Logical design & development (using Erwin, normalization, and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, and Support.
• Maintenance of business applications using SQL Server 2008/2005/2000 , DTS, SSIS, SSAS and SSRS.
• Efficient in installation and migration from SQL Server 2005 to SQL Server 2008.
• Expertise in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server 2008/2005/2000 .
• Have good experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Experienced in developing T - SQL (DDL, DML) statements in Management Studio and Query Analyzer.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Excellent experience in migration of heterogeneous data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS.
• Well experienced in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
• Experience in writing script task for automation using C#.net and vb.net.
• Hands on experience in deploying and scheduling packages using SQL Server Agent Job.
• Expertise in designing complex reports like Cascading parameters, Drill-Through Reports, Sub-Reports, Parameterized Reports and Report Models and Ad hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Experienced in defining queries, generating drill-down report in SSRS based on sorting and grouping.
• Expert in designing and generating reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, matrix, dynamic reports and other features of reporting service.
• Deployment, Integration and Analysis of SSRS Reports on SharePoint Portal using SharePoint 2007.
• Hands on experience in developing & deploying reports and packages using SQL Server Reporting Services and SQL Server Integration Services.
• Versatile in writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS 2005.
• Good knowledge of defining and deploying Cubes using MS SQL Server 2005 Analysis Services (SSAS) using multidimensional data.
• Involved in performance tuning using SQL Profiler, Database Tuning Wizard and Index Tuning Wizard.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills with good work ethics.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000
• MS Access
• OLEDB
• SQL Server Management Studio
• Business Intelligence Development Studio
• SQL Enterprise Manager
• DataTransformation Services (DTS )
• SQL Server Integration services (SSIS)
• SQL Server Analysis services (SSAS)
• SQL Server Reporting services (SSRS)
• Crystal Reports
• SQL Profiler
• C
• C++
• Java
• SQL
• T-SQL
• PL/SQL
• C#.NET
• ASP.NET
• VB.NET
• Visual Studio 2005
• HTML
• DHTML
• UNIX
• VISIO
• ERWIN
• UML
• JAVASCRIPT
• XML and CSS

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

MS SQL Server /SSRS/SSIS/SSAS/ C#.NET Developer

Responsibilities:

• Participated in gathering the business requirements and Database Specifications.
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.
• Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
• Implemented new features in SQL 2008 like Policy based Management, Table Compression & backup compression, SQL Server Auditing and MERGE statement in T-SQL, Entity Framework and LINQ, and new date/time, FILESTREAM and spatial data types provide powerful and easy to use application development enhancements.
• Worked extensively on SSIS Packages for extracting the data of the customers from OLTP, transform that data and load it into OLAP.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Created reports and performed all Administrative activities. Also Installed and maintained SQL Server Reporting Services (SSRS) 2008. Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
• Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Managed migration from Crystal Reports to SQL Server 2008 Reporting Services (SSRS).
• Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS to show various payment plans like PPT (Preferred Payment Plan), Bill Pay, Transfer Funds, Confidential Easy Pay were displayed and labeled
• Used SQL Server 2005 to design, implement and manage data warehousesOLAPcubes and reporting solutions to improve asset management, incident management, data center services, system events support and billing to show Payment frequency such as Recurring, One-Time and Recurring and One-time.
• Buildcubeswith propermeasures & dimension and backup SSAS database after deployment.
• Managed the historical data in the data warehouse from various data sources.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Actively participated in creating web pages involving N-Tire .net application development using ASP.Net, VB.Net

Environment: MS SQL Server 2005/2008, Business Intelligence MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), visual studio 2005, MS Visio, SharePoint Server (MOSS) 2007, SharePoint Portal Server (SPS) 2003.

Confidential, Memphis, TN

MS SQL Server Developer/BI Developer

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database model design.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for the clients depending upon business requirement.
• Created and developed database objects like Tables, Stored procedures, Triggers, Views, Indexes, User Defined functions, T-SQL Statements and Cursors based on business requirements.
• Developed dynamic stored procedures for complex sub queries and joins using multiple tables based on the business needs.
• Transformed data from different heterogeneous data sources like Oracle, Excel and Access to SQL Server 2008 using OLE DB connection providers by creating various SSIS packages.
• Deployed and scheduled various packages using Sql server Agent Job in Management Studio.
• Created back up to maintain the data before loading into SQL Server 2008.
• Used multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS 2008 tasks.
• Send mails using send Mail Task upon successful deploy of the packages to manager.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Created package configuration in XML and used them to deploy packages into SQL server.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts using SSRS 2008.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Created report models for ad hoc reports when the end user wants to see the reports on fly.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Deployed various reports on Share Point Portal using Share Point 2007 Server.
• Involved in sending reports to subscribed users using SSRS 2008 and Share Point Server.
• Performed performance tuning by analyzing indexes, queries, and table size etc Database Engine tuning advisor and query execution plan tools.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: MS SQL Server 2008, SSIS, SSAS, SSRS, MS access, Oracle, Excel, Sql Profiler, Index Tuning Wizard, Share Point Server 2007, Erwin, Outlook Express.

Confidential, Richmond, VA

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Created Logical and Physical data models using ERWIN by gathering business requirements.
• Created stored procedures for the business logic using T-SQL and performed coding of several database triggers and stored procedures and maintained integrity constraints.
• Developed Tables, Procedures, User Defined Functions, Cursors, Views, Indexes, Joins and statements for applications.
• Designed and implemented stored procedures and triggers for automation tasks.
• Created Packages to extract, transform and load data from heterogeneous to SQL Server 2005.
• Compressed data files by removing empty database pages and updating index statistics.
• Used Data Conversion, Audit, Copy Column, Derived Column, Merge and Union Transformations while transforming data to destination.
• Deployed and Scheduled Packages using Sql Server Agent Job in SSIS 2005.
• Coordinated with source system, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Created Drill down, Charts, Sub-Reports and Ad-hoc Reports depending upon requirement.
• Designed and implemented reports with different layouts using SSRS 2005 and exported them into Excel, PDF and HTML.
• Configured snapshot replication for reporting, user acceptance test and development servers.
• Designed and implemented user log in and security.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profiler and SQL Server Agent.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling.
• Tested the code and fixed bugs in Stored Procedures, Tables and Triggers.

Environment: MS SQL Server 2005,T-SQL, SSRS, SSIS, SSAS, SQL Profiler, SQL Server Agent, HTML, Excel, Ms Access, Window 2003/XP.

Confidential, Chicago IL

MS SQL Server BI Developer

Responsibilities:

• Migrated database from SQL Server 2000 to SQL Server 2005 using Import/Export Wizard and have overcome transformation conflicts.
• Wrote stored procedures using Dynamic SQL, Cursor to handle special case which can't be handled using static T-SQL or set based operations.
• Created T-SQL queries, dynamic Stored Procedures that calculates the Product inventory and orders.
• Created views to develop new user-friendly result sets and restrict data access to users.
• Performed Data Cleansing by creating tables to eliminate the dirty data using SSIS.
• Created Various SSIS Packages to Extract, Transform and Load source data into SQL Server in a highly efficient way using SQL Server 2005.
• Created SSIS Packages to load data from Source like Excel, ORACLE, Flat files, SQL 2000, and MS Access.
• Wrote numerous stored procedures to perform data cleaning, loading task once data is loaded into staging area.
• Created diversified destinations from one standard database using SSIS packages.
• Scheduled and performed data transfers using SSIS including filtering appropriate to the data mart for data analysis to create appropriate reports.
• Created reports like Product Sales Summary, Product Auditing Reports, and Matrix Style Product Sales Trending Report by patients, time and region using Tabular data and Charts etc. for Business users using SQL Reporting Services.
• Created reports like Service Sales Summary, Service Auditing Reports, and Matrix Style Service Sales Trending Report by patients, time and region using Tabular data and Charts etc. for Business users using SQL Reporting Services
• Created report models for ad hoc reports when the end user wants to see the reports on fly.
• Generated reports using SSRS 2005 as per business requirements.
• Extensively used SQL server reporting services to generate reports on a weekly basis in given period.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Used tools like SQL Profiler, Performance Monitor to find out performance issues with queries or Application.
• Managed the consistency of the client’s database using DBCC commands.

Environment: MS SQL Server 2005, MS SQL Server 2000, SSIS, SSRS, DTS, Enterprise Manager, Import and Export Wizard, Query Analyzer, SQL Profiler and Windows 2003/XP.

Confidential, Columbus, OH

MS SQL Server SSRS/SSIS Developer

Responsibilities:

• Created databases for MS SQL Server 2000, MS Access.
• Designed and implemented processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Used Enterprise Manager for job scheduling and queries.
• Worked with DTS packages and installed and maintained MS SQL Server 2000.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Managed and monitored the use of disk space.
• Maintained the client relationship by communicating the tasks daily.

Environment: MS SQL Server 2000, SQL Profiler, Excel reports, Windows 2000.

Confidential

MS SQL Server Developer

Responsibilities:

• Created databases for MS SQL Server 2000, MS Access.
• Designed and implemented processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers.
• Created Stored Procedures, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Worked with DTS packages.
• Installed and maintained MS SQL Server 2000.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Managed and monitored the use of disk space.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed the consistency of the client’s Database using DBCC.
• Planned Backup strategy based on projects requirements.

Environment: MS SQL Server 2000, Excel reports, Windows 2000, Crystal reports.