Professional Summary:

• Over 7 years of experience in IT industry as a SQL Server Developer working in different domains including HealthCare, Retail, Insurance and Financial services.
• Expert in developing reports in SQL Server 2008/2005 Reporting Services (SSRS) and deploying them using web applications onto web servers.
• Extensive experience in creating Parameterized, Linked, Tabular, Matrix, Drilldown, Drill through, Subreports, Geographic map as a subreport and Ad hoc reports using SSRS. In depth experience in creating multiple levels cascading prompt for both static and dynamic parameter.
• Expert in ETL (SSIS) and DTS packages to perform data transfers from OLTP to OLAP, different server locations and heterogeneous sources like Oracle, Excel, XML, CSV, flat file, Text Format Data.
• Extensive experience in Data Migration between homogeneous & heterogeneous systems using various tools like DTS Import Export Data, Bulk Insert and BCP, SSIS.
• Expert in creating SSIS Packages using various transformations to generate underlying data for the reports and to export them as per the requirement of the client.
• Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2008/2005.
• Expert in Dimensional Data Modeling and Cube Design in SQL Server 2008/2005 Analysis Services (SSAS) and deploying them.
• Expertise in creating and implementing Key Performance Indicator (KPI), Calculations, Aggregations, Hierarchies, Partitions, Perspectives in cubes using MDX queries.
• Extensive experience in developing Functions, Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2008/2005/2000. Excellent experience in Analyzing, Coding, Implementing SQL queries and procedures using various Relational Database Management System (RDBMS).
• Proficient in developing Process Models, Dimensional Data Models, Ad-hoc reports using Business Objects.
• Experience in analytical Database Design, Data Flow Diagrams, ER diagrams and Data Modeling skills using MS Visio and ERWIN.
• Experienced with Business Objects XI Infoview and Central Management Console (CMC). In-depth knowledge in working and implementation of Crystal Reports 8.0/9.0/10/Xi.
• Proficient in database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler, and SQL Server Debugger.
• Involved in all phases of Software Development Life Cycle (SDLC): analyze, design, implementation, testing and maintenance.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Recovery procedure and involved in the migration and upgrade of databases.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.

Education Qualifications:
Masters in Computer Science

Skillset: 
MS SQL Server 2008/2005/2000, Reporting Services (SSRS), Crystal Reports 8.0/8.5/9/10/Xi, Crystal Enterprise Xi, Business Object Xi r2, Integration Services (SSIS), DTS, Analysis Services (SSAS), T-SQL, PL/SQL, Business Intelligence Development Studio (BIDS), SQL Query Analyzer, Visual Studio, MS Visio, Erwin 3.x/4.x/7.x, ER-Designer, TOAD, Oracle 9i/10g, InfoView, C, C++, Java, .Net Framework, ASP.Net, VBA, HTML, XML, CSS, PVCS, Visual Source Safe, Datastage, Remote Desktop, Windows NT, Windows XP/2003/2000/98, Microsoft Office Suite.

Projects Summary:

Confidential,NJ 5/2009 - Present
MS SQL Server / BI Developer 
PNC Mortgage(formerlyNational City Mortgage) is themortgagedivision of PNC. Acquired through theNational Citydeal, PNC Mortgage is credited with the first mortgage in theUnited States, and has offices across the country. The project mainly focused on migration of oracle 10g database from client server to Sql Server 2005/2008 database and to maintain, design and develop new reports using various Business Intelligence tools against their existing reports. 
Hardware/Software:
MS SQL Server 2008/2005, SSRS, SSIS 2008/2005, Crystal Report Xi R2/2008, VBA, Business Object Edge, Xcelsius, MS Access 2003, Excel 2003/2007, Oracle 10g, Remote Desktop, ASP.Net, SQL Profiler.

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Responsible for managing and executing SSIS packages to transform the data from the client server. 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, Column Mapping, Data dictionary and Metadata.
• Analyzed VB codes running behind the access reports and captured the required scripts necessary for creating new reports.
• Extensively involved in the design and development of DHCF, Internal, and Finance Reports based upon the requirement sheet.
• Extensively involved in the design and development of Internal and Finance Reports based upon the requirement sheet.
• Involved in building report models in order to access them by the analysts over the web through SQL 2005 report builder.
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler.Generated reports using SSRS and Crystal Reports from both OLTP and OLAP data sources.
• Developed medium to complex reports like detailed list report, summary reports, Matrix reports, drill through reports, Sub-reports, ad-hoc reports to meet various business needs using SSRS.
• Involved in Business Intelligence design including Entity Relationship Diagrams, Data Modeling, Systems Design, and User-Interface Design.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008
• Created Database Objects: Tables, Index, Views, User Defined Functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Analyzed the query used for access reports, converted into T-SQL and fixed errors using MS SQL Server 2008.
• Keeping track of the features and bug fixes being deployed and producing issue logs.Created detail design documentation for the reports for future reference.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimizeperformance.
• Keeping track of the features and bug fixes being deployed and producing issue logs. Created detail design documentation for the reports for future reference.

Confidential, Wichita, KS 5/2008 - 4/2009
MS SQL Server Developer / BI Developer
Koch Industries, Inc is the second largestprivately held companyin the United States as per Forbes (2008) with subsidiaries involved in manufacturing, trading and investments. Koch companies are involved in core industries such as the manufacturing, refining and distribution of petroleum, chemicals, energy, fertilizers, finance as well as other ventures and investments. The project involved designing a new database schema, extraction of data, performing various transformations and then loading all the relevant data into a data mart and generate reports to analyze company performance.
Hardware/Software:
MS SQL Server 2005, MS SQL Server Integration services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), BIDS, Visual Studio 2005,SharePoint Designer 2007, VSS 2005, Erwin v7.3, Windows NT/2003, Microsoft .NET framework 3.5.

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Developed logical and physical data models for schemas using Erwin. Installed MS SQL Server 2005 and Management tools using SQL Server Setup Program.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
• Created complex stored procedures to calculate interest for Fixed Income banking products such as Term Deposits, CD accounts etc.
• Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio. Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data. Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005. Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters. Developed reports of Fixed Income securities trading and processing for bank management.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script. Set up DMZ SharePoint environment using SQL logins for SharePoint.
• Performed daily tasks including backup and restore by using MS SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Developed management system based on SharePoint 2007 and SQL Reporting Services.
• Implemented and configured Microsoft SharePoint Portal 2007, Windows SharePoint Services and MS SQL Server 2005.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Supported production operation activities, with focus on integration and development of new and existing products and services.

Confidential, Cambridge, MA6/2007 - 4/2008 
MS SQL Server Developer / BI Developer
Novartis is one of the largest healthcare companies in the world and a leading giant among pharmaceutical companies committed to discover, develop and successfully market innovative products to prevent and cure diseases. The project focused on maintaining the database and designing, developing, and maintaining report for Clinical and Financial department on Distribution and sales of the disease specific drugs for better analysis.
Hardware/Software:
MS SQL Server 2008/2005, T-SQL, PL/SQL, MS SQL Server Reporting Services, MS SQL Server Integrating Services, MS SQL Server Analysis Services, Oracle 10g, Access, Excel, PVCS, TOAD,XML, HTML.

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Involved in Installation and Configuration of MS SQL Server 2005.
• Created a number of cubes, dimensions and business critical KPIs using SSAS.
• Wrote several MDX queries to create name sets and calculated member and created reports by manipulating data from cubes in SSAS.
• Worked on star schema by extending Fact and Dimension Tables.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Developed Unit Test Plans for SSIS packages.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated Sub-Reports, Drill down, Drill through, and Parameterized reports using SSRS. Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Involved in the development and designing of XML, HTML using Cascading Style sheets for displaying the reports on the Report Server.
• Configured the report viewing security for various users at various levels using Report Manager
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Confidential,Northbrook, IL 6/2006 – 5/2007
MS SQL Server Developer / SSRS/SSIS/SSAS Developer
The Allstate Corporation is the largest publicly held personal lines insurer in the United States and the second-largest of all personal lines insurers in the U.S. This project involved analysis, design, development and testing of reports using MS SQL Server Reporting Services, maintenance of database for faster query of data and performance tuning.
Hardware/Software:
MS SQL Server 2005/2000, T-SQL, SSRS, SSIS, SSAS, DTS, Oracle 9i, PVCS, CMC, SQL Profiler.

Responsibilities:

• Gathered user requirements, drafted specifications, and documents used to create reports.
• Upgraded MS SQL Server 2000 databases to 2005, using Detach/Attach, Backup and Recovery, and by Replication.
• Identified slow running query and optimized stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Developed the cubes using the data from different servers for the analysis using SSAS.
• Wrote MDX queries for pre calculated measures and created report model on SSAS cubes as well as changing default configuration on existing cubes.
• Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and executed DTS 2000 Package task.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created reports by building complex SQL multi-tables joins with sub-queries in views.
• Designed and developed various Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS.
• Designed, developed and tested stored procedures, views and complex queries for Reports distribution.
• Created various formula fields, running totals, parameters and groups at report level.
• Involved in Creating Users, Folders and Groups in CMC.
• Created high level Operating & Working Capital, Budget Development, Cash Flow Management & Modeling reports by Year, Quarter, Month, weekly and day to day.
• Tuned lots of ad-hoc queries and stored procedures, by creating indexes, making proper joins.

Confidential,Philadelphia, PA 6/2004 – 5/2006
MS SQL Server / SSIS/SSAS Developer 
A diversified financial services organization which provides comprehensive financial solutions that helps customer secure their retirement and manage life transitions. This reporting application is web-based application that displays the clients that are held in various reports. All the required data is present in a centralized enterprise database. The application takes the Clients Social Security Number or name and displays their holdings. Extensive Search functionality was developed. The advisor(s) will be able to search for a client using their SSN or by using the first or last name fields.
Hardware/Software:
MS SQL Server 2000, SSAS, SSIS, Crystal Reports Xi, Crystal Enterprise Xi, T- SQL, MS Visio 2003, Clarity Software, DB2.

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse.
• Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that stored and maintained the data.
• Involved in the complete data warehouse development life cycle.
• Debugged the mappings extensively, hard coding the test data ids to test the logics going instance by instance.
• Performed various transformations, aggregations and ranking routines on the data to be stored in the application reporting mart.
• Handle the Migration process from Development, Test and Production Environments.
• Developed and maintained data cubes using ODBC to access heterogeneous data sources and defined Data Source Name.
• Created MDX queries for data retrieval and manipulation of OLAP DB.
• Designed and maintained a web reporting environment including portal, dashboards, scorecards and presentations using SQL Server 2000 and Crystal reports.
• Implemented transactional replication among different servers
• High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, flat file, Text Format Data)
• Provided technical guidance and support to end-users by developing documentations required.
• Performed production SQL release final verification procedure to production.
• Documented all database changes and follow and enforce change and release management processes.