Summary:

• Over 7 years of IT experience as SQL Server Developer by SQL Server 2000/2005/2008 with special prominence on SQL Server Integration Services, SQL Server Reporting Services.
• Expertise on all actions related to the development, implementation and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS, and Building complex reports using SSRS.
• Extensive experience on migrating data between various versions of SQL Server systems using various tools (Import Export Data, Bulk Insert and BCP, SSIS).
• Solid experience on evaluating existing DTS packages on SQL Server 2000 and upgrading them to SQL Server 2005 SSIS packages.
• Proficiency in SQL Server reporting services (SSRS) 2005/2008 in generating complex reports: cascaded, parameterized and Ad Hoc reports, Drill-Down Reports and Matrix Reports.
• Hands on experience in managing subscriptions, creating reports with report builder, report snapshots and report cache.
• Expertise in SQL Server 2000/2005/2008 Development Skills including writing Stored Procedures, User-Defined Functions, Triggers and proficiency in Joins and Indexes.
• Extensive experience in data base design and development using different tools of ER diagram, normalization techniques, T-SQL (DDL and DML coding).
• Highly experienced in upgrading MS SQL server 2005 to MS SQL server 2008.
• Expertise in designing and implementing Dimensions and Measures according to business requirements and creating OLAP Cubes using SSAS 2005/2008.
• Extensive development experience in Microsoft .NET based application using C#.net, ASP.Net and in database access using ADO.Net (Data Adapter, Reader and Dataset).
• Highly experienced on all activities related to the development, implementation and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.
• Excellent communication, fast learning capability, problem solving and conceptual skills, ability to work effectively in a team environment.

Education: Master of Science in Computer Science

Skill Set:
MS SQL Server 2000/2005/2008, SSIS, SSAS, SSRS, Windows NT, Windows 98/2000/XP/2003/2008, UNIX, ERWIN, SQL Query Analyzer, ADO.NET, MS SQL Server Profiler , DTS, ASP.NET(3.5), HTML,XML,VB Script , MS Visio 2003, Crystal Reports, Oracle 8i/9i, MS Office, Visual Source Safe (2005) ,Tortoise Sub Version, MS Visual Studio 2005/2008.

Projects Summary:

Confidential, Cleveland, OH 3/2010 - Present
MS SQL Server Developer SSRS/SSIS/SSAS
Confidential, was a regional bank, acquired by PNC Financial Services, which provides commercial and retail banking, mortgage financing and servicing, consumer finance, and asset management. The main objective of the project was to collect data from various database sources to perform analysis and then integrate them with the existing systems and creating reports in SSRS, also migration of data from SQL Server 2005 to SQL Server 2008.

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements, Data Migration from SQL Server 2005 to SQL Server 2008 and provided documentation
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area, then used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, and finally transfer into data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Created SQL server configurationsfor SSISpackages and experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
• Responsible for creating reports based on the business requirements using SSRS 2008
• Identified the database tables for defining queries to generate reports for analysis of data using SSRS in Report Builder.
• Created various reports including Cross-tab, Conditional, Drill-down, Sub reports, parameterized reports and also created number of complex formulae in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Implemented Star Schema for OLAP cubes using SSAS.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Designed both logical and physical data models in Erwin 7.2

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2008(SSRS), SQL Server Analysis Services 2008(SSAS), SQL Server Integration Services 2008(SSIS), VSS, Microsoft Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL, Erwin, C#.

Confidential, Newark, NJ 8/2008 - 2/2010
MS SQL Server Developer/ BI Developer
Confidential, is a State Agency provides compensation to innocent victims of violent crime for some expenses they suffer as a result of violent crime. The project goal was to develop and design an enterprise data warehouse, creating ETL packages to load data from OLTP, Homogeneous and Heterogeneous sources like flat files, excel and oracle to SQL Server using SSIS.

Responsibilities:

• Designed and Developed Complex SSIS packages using SQL Server 2008 Integration Services(SSIS), XML Web services, OLEDB, file system task in SSIS to upload and download the ETL Data.
• Imported/Exported data from homogeneous and heterogeneous sources also designed and automated various FTP Processes and Email using SSIS.
• Developed several detail and summary reports including pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Creation and development of SQL reports, reporting structure, which includes financial and composite reports for existing and new clients and also supported the team with expert needs of creating and maintained the companywide reporting structure in SSRS.
• Created List Reports, Cross-tab Reports, Drill-down Reports, and ad-hoc Reports, Charts, Functions and Formulas using expressions.
• Worked with users for gathering new requirements and understanding existing issues.
• Created Web pages using ASP.NET as front end to display reports and allowed functionalities like logins, searches etc.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front-end application.
• Actively involved in Normalization & Demoralization of database, performance tuning to optimize SQL queries using SQL profiler and query analyzer.
• Installed SQL Server 2008 and established connectivity with the database created, configured and maintained database backup and recovery.
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.

Environment: Windows XP, MS SQL Server 2008, MS Access, SQL Query Analyzer, MS SQL server Reporting Services 2008(SSRS), MS SQL server Integration Services 2008(SSIS), SQL server Analysis Services 2008(SSAS), SQL Profiler, ASP.NET, Microsoft Excel, ODBC, Microsoft Visio.

Confidential, San Jose, CA 1/2007 - 7/2008
MS SQL Server Developer / SSRS/SSIS
Confidential, manages eBay.com, an online auction and shopping website in which people and businesses buy and sell a broad variety of goods and services worldwide. The aim of the project was to develop a web based application called Compass for customers to conveniently submit, manage and track the details of their products, for Equipment Vendors and leasers to submit applications, view status, print reports and download documents securely over the internet on a 24/7 basis.

Responsibilities:

• Responsible for Installation, Configuration, Security, Maintenance, Restoration of SSRS on Windows Server 2003.
• Created ad-hoc, parameterized, drill down and cascaded parameterized reports in SSRS 2005.
• Uploaded SQL Server 2000 Reporting Services (SSRS) RDL files to SQL Server 2005.
• Migrated and modified all DTS packages to SQL Server Integration Services (SSIS) accordingly using its SSIS advanced features.
• Extracted data from Oracle and migrated data from various sources (text based files, Excel spreadsheets, and Access) into SQL Server 2005 SSIS
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Gauged the effectiveness and efficiency of existing reporting systems. Developed and implemented strategies for improving and further leveraging these reports in order to transfer/convert existing Reports to SQL Server Reporting Services.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and worked with database objects like Tables, views and indexes.
• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Responsible for transferring packages using SSIS on to production Server.

Environment: Windows XP, MS SQL Server 2005, MS SQL Server Reporting Services 2005,MS SQL Server Integration Services, Excel, Acrobat Reader.

Confidential, Hartford, CT 7/2005 - 12/2006
MS SQL Server SSIS / SSRS Developer
Confidential, offers a wide variety of property and casualty insurance, surety on products and services to businesses, organizations and individuals.The scope of the project was migrating data from various heterogeneous data sources such as Oracle, MS SQL Server, MS Excel and Flat files into SQL Server 2005 and maintain database for the Facility search and Provider search.

Responsibilities:

• Used SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Used SSIS transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
• Identified and worked with multi-valued parameters for parameterized reports in SSRS.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly, also scheduled, maintained, and supported the distribution and access to reports through Crystal Server.

Environment: MS SQL Server 2005, SSIS, SSRS, T-SQL, Crystal Reports, MS Visual Studio 2005, MS Office, SQL Profiler

Confidential, Hyderabad, INDIA 2/2004 - 6/2005
MS SQL Server Developer
Confidential, Government of India Enterprise was established to create a strong indigenous base in Electronics. The software package 'Materials Management System (MMS)' was developed to suit the requirements of a general manufacturing functions of the Indian industry especially, the government sector, taking into consideration the different procedures and approvals in a hierarchical and step by step process.

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications.
• Developed stored procedures and views for managing efficient data retrieval.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Used DTS Packages for data import and export data from SQL Server to Access, text and Excel files.
• 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.
• Developed the data warehouse to design the business process data representation, dimensions and fact tables using SQL Analysis services.
• Designed and built the Data Access Layer Components and Business Classes in C# and performed unit testing, path testing of web forms and code to test their functionality.
• Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in VSS.

Environment: MS SQL Server 2000 Enterprise Edition, Microsoft Analysis Services, SQL Server Reporting Services, SQL Enterprise Manager, C#, ASP.NET, Erwin 4.1, Windows XP, MS Access, MS Excel, HTML.