Professional Summary:

• 7+ years of IT experience in Data Design and Development on Microsoft SQL Server 2008/2005/2000, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
• Experience in using Business Intelligence tools(SSIS,SSAS,SSRS) in MS SQL Server 2008
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server2008/2005/2000.
• Great ability to create and manage various database objects like tables, views.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008,MS SQL 2005 and DTS in MS SQL 2000
• 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.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Experience with logical and physical data modeling and database design using Erwin.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

Technical Skills:

Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2008,SQL Server 2005 Management Studio, DTS, SSIS, SSRS, iReports, SSAS,

Database

MS SQL Server 2008R2,2008,2005, 2000, MS-Access

Language

C , C++, T-SQL, VB.Net

Operating System

Windows XP/NT/2000, DOS, Windows Server 2003

Tools

Erwin, Microsoft Visual Studio 2008/2005,Share Point Server 2007, Microsoft Project Server 2007, ProClarity

Architecture

Relational DBMS, Client-Server Architecture, OLAP, OLTP

Reporting Tools

SSRS (SQL Server Reporting Services), Crystal Reports

ETL Tools

SSIS (SQL Server Integration Services), DTS

ProfessionalExperience:

SQL Server (SSIS, SSRS) Developer

Confidential, is one of the largest kidney care companies in theUnited States, Their offerings include in-centerhemodialysis, in-centernocturnal dialysis,peritoneal dialysis,home hemodialysis,vascular accessmanagement,chronic kidney diseaseeducation, andrenal diet assistance.

Responsibilities:

• Responsible for building and supporting Patient Access applications such as: Patient Registration, Payer Contracting, and Insurance Verification.
• Designing Logical and Physical Data Model with Erwin tools.
• Worked with installing, designing and managing MS SQL Server 2008.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server.
• Developed a Tabular Reports , ad-hoc reports using SSRS Report Designer.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Migrated SSIS Packages from SQL Server 2005 to SQL Server 2008.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Work with project teams for upgrading SQL Server 2005 to SQL Server 2008.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Conducted data import and export operations using the DTS wizard.

Environment: MS SQL Server2005/2008, Team Foundation Server, Microsoft SharePoint Server(MOSS 2007), Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2005, Windows XP, T-SQL, VB.Net

Confidential,, Dallas, TX May 2010 - July 2011
SQL SSIS/SSRS/SSAS Developer

Confidential, is an Americanmultinationalbanking andfinancial servicescorporation headquartered inCharlotte, North Carolina. It is the second largestbank holding companyin the United States by assets.

Responsibilities:

• Involved in Migration of SSRS 2005 to SSRS 2008.
• Created Triggers, Views for Audit and security purposes.
• Created different types of User-defined functions.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Integrated SQL Server 2008reporting services with MOSS (Microsoft Office Share Point Server) to automatically deliver reports to the Share Point portal
• Created mapping tables to find out the missing attributes for the ETL process.
• Used the row count transformation and event handlers control flow to populate the special Log tables with high level SSIS package execution results
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server and DB2 Database
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Created SQL Jobs to schedule SSIS Packages
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Configured and deployed SSRS reports to Share point
• Configured Active/Active and Active/Passive clustering for failover
• Scheduled the SSIS packages to run at different intervals to load the data.
• Used data profiling task in SSIS 2008 to identify poor data and repair it.
• Transformation etc. using SSIS.
• Created report snapshots to improve the performance of SSRS.
• Improved the accuracy of the source data by implementing data validation on the source Data for reporting
• Created subscriptions in SSRS to deliver reports to a shared file.
• Implemented logical and physical modelingusing ERWIN data modeler
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub
• Reports using SQL Server Reporting Services 2008
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Involved in migration of crystal reports to SSRS 2008.
• Hands on experience in using different transformations like fuzzy lookup, derived column
• Identified the dimension, fact tables and designed the data warehouse using star schema
• Created Complex reports using IREPORTS tool.
• Used Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and created various dynamic reports using SSRS and Ireports.
• Worked with MDX to query cube's data.
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Designed reports and tuned them for optimal performance when using multiple Parameters
• Used Report Manager to assign roles, permissions and to create report schedules.

Environment: SQL Server 2005/2008, Microsoft SharePoint Server (MOSS), T-SQL, SQL Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, MDX, Erwin, SQL Profiler, MS Excel 2003, MS Visio, Visual Studio 2008-2005, .Net

Confidential,Bloomington, IL Feb 2009 - May 2010
BI Developer (SSRS/SSIS/SSAS)

State Farm Insurance is a group of insurance and financial services companies

Responsibilities:

• Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2005.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Used Lookup Transformation to get the data from reference data sets
• Migrating SQL Server 2000 databases into SQL Server 2005.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Worked on advanced dimension Design and Cube design.
• Used MDX to define KPI's, calculated members in the cubes.
• Created partitions of the Analysis Services cube to improve performance.
• Conducted Data Analysis and did Data Modeling and Created the ER diagrams using Logical Schema and Star Schema.
• Generated ad-hoc reports using MS-Excel and Crystal Reports.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.

Environment: SQL Server 2005/2008, SSIS, VBScript, XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Crystal Reports, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), MS SQL Server Analysis Services(SSAS).

Confidential,NJ Dec 2007 - Feb 2009
BI Developer (SSRS/SSIS/SSAS)

Confidential, is the world\'s premier jeweler.

Responsibilities:

• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on theSharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created cubes and defined the dimensions and Responsible for defining calculated members
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Worked with data extraction using SSIS and Data Warehouse staging, and loading.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures.
• Developed reports that deliver data from cubes.
• Created and managed subscriptions for the reports.
• Defined specific read/process permissions for the users in SSAS instance.
• Implemented user based security in SSRS reports to limit the access of reports.
• Responsible for identifying and defining Data Source and Data Source views.
• Created SSIS packages to move data from oracle to SQL Server which involved using
• Various transformations, developing SQL queries.

Environment: SQL Server 2005 / 2000(2003 ,64 bit edition of SQL server 2000), SharePoint, DTS, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS.

Confidential,India June 2005 - November 2007
SQL Server Developer

Logica is a business and technology service company. Logica deliver business consulting, systems integration and outsourcing across all industries and business functions.

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Involved in the analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that they perform well.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.
• Designed, developed, and tested stored procedures, views and complex queries forReports distribution.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Effectively used views to prevent unauthorized access.
• Tuned SQL queries using execution plans for better performance.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
• Created DTS packages for transforming data from various data sources.
• Discussed business requirements and mapped business needs.
• Used Query for ad hoc Reports and Users design Custom Queries.
• Developed various Charts and Graphs like bar charts, line charts, pie charts etc by using Chart experts

Environment:
MS SQL Server 7.0/2000, Windows 2000/NT/XP, DTS, Query Analyzer, SQL Profiler and Enterprise Manager