Summary of Experience:

• Over 7 Years of IT Experience in Business Intelligence Technologies and Database with Extensive Knowledge in ETL Process and Reporting Services using SQL server 2008/2005, SSIS and SSRS.
• Experience in creating SSIS packages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle). By using multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert and Merge Join.
• Experience in writing complex TSQL Queries involving various tables using Inner and outer joins.
• Experience in writing Complex T-SQL Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity, SQL joins and writing Sub Queries.
• Expertise in optimizing the queries by creating Index views, clustered and non-clustered indexed views.
• Extensively worked on VMware workstation. Deployed SQL server.
• Expertise in various phases of project lifecycles (Design, Analyzing, Implementation and testing).
• Extensive knowledge in Extraction, Transforming and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert.
• Experience in migration of databases from Oracle and non-oracle sources to SQL databases using 2008 SSIS (SQL Server Integration Services).
• Expert in creating various types of reports like complex drill down reports& drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Extensive knowledge in designing reports using cascading parameters, Parameterized reports, report models for Adhoc reports using SQL server Reporting services (SSRS) based on Requirement.
• Constructed Cubes based on data volumes mostly adhering to Star Schema using strong knowledge of Data Warehousing, Star Schema, Snow-Flake Schema, Fact and Dimension Tables.
• Experience in the performance tuning using SQL profiler identified slow running queries and optimized the queries to see that it will not affect the server performance.

Technical Summary:

MS SQL Server 2000/2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Analysis Services 2005/2008, MS SQL Server Integration Services 2008/2005, MS Access, C++, HTML, VMware, MS Visio 2003, Windows server 2000/2003, Crystal Reports XI/8.5/8.0, Visual Studio 2005/2008, MS VISIO 2000/2003 Remote Desktop, DreamWeaver, Flash, Ms Office, Ms Frontpage

Education:

Bachelors in Computers Science

Detailed Experience:

Confidential,CA
MS SQL Developer SSRS/SSIS Developer
Jan/2011 – Present
Responsibilities:

• Extensively involved in the full lifecycle of ETL software development-analysis, design, building, documentation and testing for the project using SQL Server Integration services.
• Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence container and Conditional split, Data conversion, Derived column and Multi casting.
• Scheduled the jobs to streamline and automate cumbersome repeated tasks using SSIS.
• Involved in all phases of System Development Life Cycle (SDLC).
• Developed, executed and maintained SQL queries/scripts and to validate completeness, integrity and accuracy of data.
• Extensively wrote and edited existing Stored Procedures, User Defined Functions and Triggers using T-SQL.
• Created the Best Coding Practices Document for stored procedures & functions for the developers.
• Created new database files and database file groups in SQL Server 2008 using SSMS and T-SQL.
• Configured report server in development and production and also created SQL Server Reports using SSRS 2008 from initial stage.
• Created Sub Reports and Drill down Reports as per the client requirements using SSRS.
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Responsible for deploying reports to Report Manager and Troubleshooting for errors occurring in execution.
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing of the reports.
• Transferred data from various OLTP data sources, such as Oracle, Teradata, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
• Created and rebuilt multi-dimensional cubes using SSAS to support business reporting and forecasting process.

Environment: MS SQL Server R2 2008, MS SQL Server Reporting Services 2005/2008, Integration Services (SSIS), DTS, T-SQL, Crystal Reports, VB, C#, MS Excel, DB2, Access and Excel

Confidential,
MS SQL Developer SSRS/SSIS Developer
June/2009 - Nov/2010

• Studied the current transactional database in order to understand the existing system and created the approach documents for the migration task.
• Responsible for generating claims ranking reports using the migrated data.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and parameterized and Linked reports.
• Identified and worked with parameters for creating cascading parameterized reports in SSRS 2008.
• Involved in Debugging and Deploying reports on the production server
• Analyzing reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Deploying and scheduling Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created report models and configured the report builder for building Adhoc reports.
• Migrated data from MS SQL Server 2005 to MS SQL Server 2008.
• Create store procedure specifically for cleansing and managing data and used the same in SSIS Execute SQL Task.
• Created Complex Stored Procedures, Triggers, Functions, Tables, Views and other T_SQL code and SQL joins to ensure efficient data retrieval.
• Created SQL Agent Jobs for scheduling SSIS Packages, SSRS reports and alerts.
• Configured and fine-tuned all the ETL (Extract, Transform and Load) workflows.
• Create C# code for to implement variables with the use of SSIS script task
• Created SSIS script task with C# code for obtaining parameters from the applications.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.

Environment: MS SQL Server R2 2008, MS SQL Server Reporting Services 2005/2008, Integration Services (SSIS), DTS, T-SQL, Crystal Reports, VB, C#, MS Excel, DB2, Access and Excel

Confidential,CA
MS SQL Developer, SSRS/SSIS Developer
June/2008- May/2009

• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
• Created Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Involved in Performance tuning and Query Optimization by using SQL profiler.
• Resolved deadlocks issues with the databases and servers on a realtime basis.
• Worked with business analysts to identify, design and implement solutions for extraction and integration of data to and from databases and data marts for the purposes of data extraction and reporting using SSRS.
• Migrated SQL Server databases to latest version 2008 from SQL server 2005.
• Integrated data from homogeneous, heterogeneous sources and legacy systems (SQL, DB2, Excel sources) to SQL server database.
• Create C# code for to implement variables with the use of SSIS script task.
• Experience in application development using the.NET framework 3.5 along with C# and VB.Net.
• Designed many different modules like data parsing which was develop by using C#
• Generated performance based reports using SSRS for the managers to show holdings against various measures like time, area and price-range.
• Created Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Implemented OLAP Cubes, Facts and Dimensions for providing summarized.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Extensively worked on star schema for building the OLAP cubes.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Created scripts components to write customer functions in dataflow used data grids to display the data in a customized way.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases
• Designed, developed, modified and enhanced the database structures and database objects.
• Updated the existing Business Objects Universes as requested by the users with the new requirements to add new universe classes and objects for new database entities and attributes.

Environment: SQL Server 2005/2008, MS SQL Server Reporting Services 2005/2008, Integration Services (SSIS), DTS, T-SQL, VB, C#, MS Excel, DB2, Access and Excel.

Confidential,Pleasanton, CA
MS SQL server 2005, SSIS/SSRS
Jan/2007 - May/2008

• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created SSIS script task with C# code for obtaining parameters from the applications
• Developed and improved company C# Windows forms for updating the company\'s database using LINQ queries
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Scheduled reports and exported in PDF, Word and Excel format.
• Worked on error handling a module consisting of data from bank, transactions, currencies, countries, master, static etc.
• Designed, deployed and maintained various SSRS Reports in SQL Server.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Involved in designing a cube which helped to show balances and profits of each region bank all over the nation.
• Managed and coordinate with remote user for change request and optimization of application

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, Visual Studio 2008, Crystal Reports, VMware Enterprise Manager, SQL Server Management Studio (SSMS) and SQL profiler.

Confidential,India
MS SQL Server DBA
July/2004 - August/2006

• Gathered technical and functional specifications and created the approach documents for the tasks involved.
• Created database objects like tables, views, indexes, triggers and stored procedures.
• Developed stored procedures and views for managing efficient data retrieval
• Wrote various Stored procedures for the purpose of application development
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Extensively used SSRS to create reports as per user requirements
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Performed some DBA Tasks like checking the jobs that fail and troubleshooting the issues.
• Worked closely with developers, end users and Administrator in designing database and creating
• Developed the data warehouse to design the business process data representation, dimensions and fact tables using SQL Analysis services.
• Extensively worked on star schema and snowflake schema
• Responsible for enhancements and Maintenance of the product
• Prepared the detailed project layout, analyzed existing technology involved and documented work performed and stored in VSS
• Worked in Development, Testing and Production environment.

Environment: MS SQL Server 2005, SQL Server Reporting Services 2005, SQL Server Integration Services 2005, C#, SQL Server Analysis Services 2005, T-SQL, Windows XP, MS Excel and SQL profiler.