Summary: 7 years of experience in IT, Financial and Healthcare environments with primary skills on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.

• Good hands on exposure with SQL Server 2008R2/2008/2005/2000.

• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, BI suite.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical management.
• Involved in full Software development life-cycle (SDLC) followed by Agile methodologies to produce high quality software model.
• Extensive development experience in Microsoft .NET based application using .net, ASP.Net and in database access using ADO.Net (Data Adapter, Reader and Dataset Classes), and best practices.
• Experience with Microsoft Active Directory, Exchange 2007, SQL 2008 Clusters
• Experience in administration of SQL 2000 – 2005 and install, setup and manage windows products and install, setup and manage Linux servers
• Experience with AJAX for interactive communication with a database.
• Experience in setup and manage IIS and Other IT need

SQL Server Services (DTS, SSIS, SSRS, SSAS)

• Good ETL skills ,Data modeling, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages and Transact SQL, design and support/enhancements/maintenance.
• SQL Server 2005/2008/2008R2 RDBMS database development including T-SQL programming.
• ETL implementation using SQL Server Integration Services (SSIS).
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience with file transfer protocols, including standard FTP and SFTP
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail. Used Microsoft Source Safe for version control.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Expert in creating the MDX cubes and dimensions (SSAS).
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Good knowledge with Data-warehousing concepts, MOLAP/ROLAP cubes structure.
• Developing reports on SSAS & SSRS on SQL Server (2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Sub reports, Ad hoc reports and formatting them.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Good understanding of system tables in Oracle 10g and performance tuning them.

Stored Procedure, Functions, Views, Joins and Cursors, linked Server

• Experience in creating indexed views, cursors, indexes, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Created linked server for load balancing and increasing the performance of the Database.
• Experience in using Try Catch block introduced in SQL Server 2005.

Query Optimization and Tuning

• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
• Good Knowledge in managing Data and Transaction log files, Files Groups.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server

Database Design and Implementation

• Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Good knowledge of System Development Life Cycle (SDLC).
• Good in implementing SQL Server Security and Process Control.
• Experience in Creating Roles and Assigning Permissions to the users.
• Good team player, strong interpersonal and communication skills combined with self-motivation and the ability to think outside the box

Certification:

• 70-448:Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
• 70-452:PRO: SQL Server 2008, Business Intelligence Development and Maintenance

Technical Skills:

Languages

SQL, Transact SQL, PL/SQL, HTML, XML, C, C++,VB.Net, WCF

Databases

SQL Server 2008/2005/2000/7.0, MS Access, oracle

Reporting Tools

SQL Server Reporting Service (SSRS),crystal Reports

ETL Tools

SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Web technologies

.Net, ASP.Net, Ado.Net ,Silver light

Data Modeling Tools

Erwin, Visio

Other Software

MS Office- 2007/2003/2000, Adobe Professional.

Operating Systems

Windows /98/2000/2003/XP/Vista , UNIX, Perl

Database Tools

SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

WORK EXPERIENCE:

Confidential,PA March 2012 – till date
SSIS DEVELOPER
HarperCollins is a broad-based publisher with strengths in literary and commercial fiction, business books, children\'s books, cookbooks, and mystery, romance, and reference, religious and spiritual books. With nearly 200 years of history, HarperCollins has published some of the world\'s foremost authors and has won numerous awards including the Nobel Prize, the Pulitzer Prize and National Book Award, the Newbery Medal and the Caldecott.
Responsibilities:

• Translated business requirements onto technical designs to map and load data from source systems to the data warehouse
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experienced in creating complex SSIS packages using proper control and data flow elements.
• Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Created and maintained SQL Server Agent jobs for automated processes.
• Experienced in documentation of packages.
• DesignedSSIS Packages to perform Data profiling, Data Cleansing, and Data Transformation.
• Designed and developed SSIS ETL processes, test, deploy and quality assure the content.
• Worked on SSIS configuration and trouble-shooting.
• Participated in enhancing processes for ETL design, source code control, integration testing, defect management, database standardization and tuning.

Confidential,Bethesda, MD June 11 – Jan 12
Role : SSAS/SSRS BI DEVELOPER

Empower IT is a business intelligence and data analytics firm. Empower IT provides web-based business intelligence and data analytics tools to range a clients including Fortune 500 companies, governments, as well as associations & non-profits. Empower IT helps clients identify their most profitable customers, accelerate product innovation, optimize supply chains and pricing, and identify the true drivers of financial performance. Empower IT provide fast, accurate and timely fact-based web tools to gain visibility into business drivers without needing Excel. The specialties of Empower IT include: Business Intelligence, Data analytics, Military point of sale (POS) data collection and analysis, Category Management.

Responsibilities:

• Responsible to create customized reports in SSRS using SQL Server 2008 R2 with different type of properties like Chart Controls, filters, interactive sorting, SQL Parameters
• Creating MDX Query or expression for retrieving and manipulating the multidimensional data stored in OLAP Cubes in SSAS as well as for various calculated members and generating parameterized/Drilldown reports usingSSRSand Crystal Reports and Using dynamic parameters inSSRSto enable/disable the parameters based on user selection.
• Rewrites existing Legacy reports into SSRS 2008R2.
• Responsible for developing graphically rich dashboard reports on the Microsoft SQL Server 2008 R2 platform in a way that users can access, based on role or business function within the organization and user skill sets.
• Design and build custom integrated reporting solution to optimize fast information transfer across all business functional areas, supporting strategic and tactical objectives.
• Involve in Agile Methodologies to produce high quality results
• Created Report Models for Ad Hoc reports on different perspective.
• Creating Dynamic Drill-down, Drill- through, toggle and filtering capabilities to provide insights into specific areas of interest
• Wrote VB script for user define functions in SSRS.
• Applying conditional formatting inSSRSto highlight key areas in the report data by using custom code using VB script and developing an automated report subscription process usingSSRS.
• Created PowerPoint reports in SSRS with the dynamic parameters.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS 2008 R2.
• Done strong architecture and programming inVisual Studio 2010
• Used Report Builder or Report Designer in Business Intelligence Development Studio (BIDS) to create new reports based on PowerPivot workbooks.
• Created new ad hoc reports based on PowerPivot workbooks that are published to the same location.

Environment: SQL Server 2005/2008 /2008R2, SSAS, T-SQL, SSRS, MDX Cubes, .Net, Visual Studio 2010

Confidential,Chicago, IL Mar 10 – May 11
Role: SQL BI Developer (SSIS/SSRS/SSAS)

Village Health is comprised of a dedicated team of specially trained nurses and professionals providing integrated care management to patients with kidney disease throughout the US. We provide services to help improve the lives of our patients by working with them to prevent complications, reduce the number of avoidable hospitalizations and improve overall health. Village health is not a one-size-fits-all approach, but our integrated care management services are formulated to meet theunique needs of each patient. We work with you, your PCP and the entire care team to develop a personalized plan of care. Working together we can enhance the care of patients with kidney disease.

Responsibilities:

• 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.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Expertise in Designing and implementing stored procedures and triggers for automating tasks.
• Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Created Indexes, Constraints and Rules on database objects.
• Created Linked Server to transfer data to legacy systems
• Involved in scheduling the backups
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Involved in ER diagrams and mapping the data into database objects.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in administrative jobs like Back-ups, data loading and unloading.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in creating DTS packages to copy tables, schemas and views and to extract data from Flat files, Excel and Oracle using SSIS.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Worked on other packages of the SQL server 2005 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Created data mapping between two distinct models.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Designed and developed Star and Snow Flake Schema as a data analyst.
• Reviewed Cube with End user and changing the cube and documentation according to their requirements.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2005 Reporting Services.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Experience in constructing cubes dimensions, DSV’s, fact tables, aggregations, KPI’s, Perspectives etc.
• Used Microsoft Visual Studio to develop console and graphical user interface applications along with Windows Forms applications, in both native code together with managed code for all platforms supported by Microsoft Windows, .NET Framework, .NET Compact Framework.
• Involved in providing information to functional segments of the organization using Data marts.
• Created new XML tags in order to execute new business rules.
• Involved in Installation, Configuration of Share Point Form in Cluster Environment.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
• Used Performance Point Server to create interactive reports with an ability to drill down into details
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Implemented site information architecture utilizing various SharePoint resources including Document Libraries, Lists, Form Libraries, Content Types, Column, Information Management Policies and Version Controlling.
• Used and developed Visual Basic for Applications (VBA) routines in Excel and Access.

Environment: SQL Server Reporting Services 2005/2008, SSAS, MS SQL Server 2005/2008, ,SSIS, Front Office 8.3 / 10.2 / 10.3, MDX Cubes, Windows XP / NT / 2000/2003, MS Office 2003/2007,.Net

Aithent is a leading software firm that delivers tangible value to leading organizations worldwide by designing, developing and implementing innovative software solutions to stream line complex business processes or replace high maintenance legacy applications. Aithent has developed products, which helps customers generate an emotional response that will define the future brand identities. It is expertise in providing customized software development and delivering innovative high-end solutions and consultancy as well as R&D.

Responsibilities:

• Involved in converting all existing DTS packages of MS SQL 2000 to 2005 by adding SSIS task using the different tools like SSMS (SQL Server Management Server), BIDS (Business Intelligence Development Server) and SQL Server Manager.
• Involved in data warehouse development environment using Microsoft DTS, SSIS, and SSAS technologies and developing system Entity Relational (ER) diagrams.
• Migrating SQL Server 2000 databases into SQL Server 2005.
• Involved in designing Data marts.
• Involved in converting DTS to SSIS and development and implementation of SSIS on an enterprise level.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for complex Databases up to 1 Terabytes.
• Created ER diagrams (physical and logical using Erwin) and mapping the data into database objects.
• Expertise in SQL Server Analysis Services.
• To analyze complex queries and tune the same to optimize application and system performance
• To set up SQL Server configuration settings.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Developed complex stored procedures using T-SQL to generate reports using Crystal Reports 9.0.
• Monitored and modified Performance using execution plans and Index tuning.
• Using log shipping for synchronization of database.
• Developed Complex Stored Procedures and Views to generate various Drill-through, Drill-down reports, Custom Groups, Dynamic, Parameterized reports and linked reports using SSRS.
• Extracting the fixed length format files from DB2 databases.
• Maintaining the database consistency with DBCC at regular intervals.
• Involved in database design process and data modeling process using Microsoft Visio 2003.
• Involved in creation of data modeling techniques.

Environment: SQL Server 2000/2005, T-SQL, Windows 2003, ASP.net, Windows 2003, Oracle, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, .Net

Confidential,Pittsburgh, PA Oct 07 – Nov 08
Role: SQL/SSIS Developer

Bayer AG defines common values, goals and strategies for the entire Group. The three subgroups and three service companies operate independently, led by the management holding company. The Corporate Center supports the Group Management Board in its task of strategic leadership. It is well-known for its original brand of aspirin. Bayer is currently the third largest pharmaceutical company in the world.

Responsibilities:

• Experience in Data Management processes, modeling and standards
• Experience in Data validation, standardization, consolidation, enrichment, cleansing and Data warehousing concepts, including information management and decision support
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Worked with development teams in the design of physical databases and in modification.
• Managing the use of disc space, memory and connection.
• Running DBCC consistency checks, and fixing data corruption in application databases
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Maintain disaster recovery strategies for the database and failover methods.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Have deployed packages on different servers by configuring it.
• Installed and configured SQL Server 2005 in Test environment with latest service packs and migrated few databases.
• Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
• Implemented computational sensitive queries Stored Procedures.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.

Environment: SQL server 2005, Windows 2000 Advanced Server, Windows 2000 Datacenter, Lumigent Log Explorer, VSS, SQL Diagnostic Manager, SQL LiteSpeed.