SUMMARY

• Over 8 years of experience in Database programming, System Analysis, Design, Development & Support of MS SQL Server 2000/2005/2008 on various domains like Retail B2B, Mortgage, Financial and Health and Equipped wif excellent communication and interpersonal skills and TEMPhas in - depth understanding of Trade life cycle and Trade settlement process
• Experience in writing complex queries involving Multiple Table Inner and Outer Joins, Temporary Tables, Table Variables
• Experience in creating, maintaining and tuning Views, Stored Procedures, Functions and Triggers and strong RDBMS concepts using SQL Server, T-SQL.
• Expert in Transact-SQL (DDL, DML).
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc)
• Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experience in extracting and transforming (ETL process) data using DTS/SSIS Import
• Export Data from various sources, Bulk Insert, BCP and DTS/SSIS Packages.
• Hands on migrating DTS Packages to SSIS packages.
• Experience in pulling data from DB2 to SQL Server using SSIS.
• Good Experience in creating Master Child Packages in SSIS.
• Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Modeling, and fact and dimension tables in SSAS
• Good experience in Designing Aggregations and pre-calculating the same in SSAS.
• Actively involved in Processing Cubes, adding KPIs and Calculated Members.
• Extensive experience in Optimizing Cubes using SQL Server Analysis Services (SSAS) 2005.
• Has good experience wif designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
• Extensive experience in the development of Reports using SQL Server 2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, drilldown reports and score cards in multiple formats using multi - dimensional objects.
• Deployment of SSRS Reports on SharePoint Portal and integrating Reports, Analysis Reports wif SharePoint 2007(MOSS).
• Good experience in ASP, C# VB.net, SQL Server tools DTS, SSIS, SSAS and SSRS.
• Having good knowledge on Backup and Recovery
• Proficient in maintenance and optimization of Database and Server.
• Using performance monitor/profiler to solve deadlock/long running queries
• Experience working in a clustered OLTP environment wif Very Large Databases (VLDB) and having version control (Visual SourceSafe and Team Foundation Server).
• Experience in logical and physical data modeling using ER Studio and Microsoft Visio.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2005, 2000, DB2, MS Access, Sybase, Excel

Database Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP

Reporting Tools: Microsoft SQL Server Reporting Services, SAP BO

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003

Programming Languages: Java, HTML, XML, UNIX C#.Net, Visual Studio, C++, ADO.NET

Design Tools: Data Modeling, Data Warehouse Design, Object oriented Design, UML

Data Warehouse/BI Tools: SQL Server Analysis Services 2005, Business Intelligence Development Studio

PROFESSIONAL EXPERIENCE

Confidential, IL

SQL Server Developer / ETL/SSRS

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005 and 2008.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and used configuration files and Environment variables for production deployment
• Developed/Monitored ETL packages wif different data sources (SQL Server, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked on Huge data Transform of XML and HTML Data in SQL server 2008
• Worked on XSLT transformation to convert XML to different form in SSIS packages
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Wrote T-SQL procedures to generate DML scripts dat modified database objects dynamically based on user inputs
• Developed indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Worked on the Performance improvement of stored procedures in Crystal and SSRS reports and also developed stored procedures as for the business logic

Environment: ASP .Net, SSRS, SSIS, MS SQL Server, 2008, SVN, Windows Server 2008, UNIX

Confidential, IL

SQL Server Developer / ETL/DBA

Responsibilities:

• Managed all indexing, debugging, optimization and performance tuning using SQL Profiler and created Scheduled jobs using SQL Server Agent Jobs.
• Created Maintenance jobs for the regular Backups of Production Databases.
• Worked wif Implementation and maintenance of Replication and Mirroring.
• Used Performance Monitor/Profiler to solve dead locks/long running queries.
• Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008.
• Developed/Monitored ETL packages wif different data sources (SQL Server, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed Scheduled Jobs to automate the packages. Created Master and Child Packages in SSIS
• Worked on SSIS Script task, Look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.

Environment: ASP .Net, ADO .Net, Crystal Reports, SSRS, SSIS, MS SQL Server 2005, 2008, Excel, Source control, Windows Server 2003, UNIX

Confidential

Sr. SQL Server Developer / ETL / SSRS

Responsibilities:

• CreatedSSIS Packages for Importing Data from CSV, Pipe Delimitedand Fixed Length Files.
• Worked onSSISfor transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Involved in creatingVB.NETcode inSSIS Script Componentand Scrip task for implement complex business rules.
• Created stored procedure for generating reports usingSQL Server Reporting Services (SSRS).
• DesignedSSISPackages by using various transformations like conditional split, script Component, lookup, merge join,oledb command, sort, union all etc
• Involved in creatingSSISPackages using various control flow tasks along wif variables.
• Involved in creatingDynamic SQLfor implementing various business rules.
• Experience in creating complexSSIS packagesusing propercontrolanddata flowelements.
• Used package configurations for running packages in various environments.
• Involved in created complexSSISpackages which calls set of child Packages.
• Generated reports by county wise using SSRS.
• Worked oncomplex data loading(implemented the batch data cleansing and data loading).
• Created indexes, constraints and rules on database objects. involved in process of extracting the data by using CORE FPT and stating the data by using QTP scripts
• Generated and debugged complex stored procedures and functions for performance tuning and Optimization
• Involved in validating source data and writing test scripts in SQL as per the mapping rules
• Setting up database backup and recovery procedures for quality and development servers.

Environment: MS SQL Server 2005, Windows Server 2003, SSIS, Erwin, SSAS, MS access, Excel, Oracle, C# .Net, ASP .Net, ADO .Net, Crystal Reports, ER Studio, SSRS, ER Studio.

Confidential, Sioux Falls, SD

Sr. SQL BI Developer/SSIS/SSAS

Responsibilities:

• Designed SSIS packages to migrate the data from DB2, flat files, excel documents and CVS files to the Staging Area in SQL server 2005
• Expertise in Using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and used configuration files and Environment variables for production deployment
• Developed drill down and drill through reports from multi dimensional objects like star schema and snow flake schema using SSRS.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Extensively involved in using of Formula fields, parameters, Group selection and record selection in Crystal reports.
• Designed and developed various types of Reports using SSRS and rendered them in front end applications like Excel and .net.
• Designed various MDX queries and multi dimensional OLAP cubes using SQL Server Analysis services (SSAS).
• Designed new Aggregations by creating Hierarchies and tan pre calculating the Aggregations using Aggregation Wizard in SSAS
• Analyzed database performance wif SQL Profiler and Optimized indexes to improve query performance.
• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005 and 2008.
• Scheduled Packages using SQL Server Agent Jobs.
• Analyzed business requirements and build logical and physical data models dat describe all the data and relationships between the data using Erwin.
• Designed various types of reports and deployed them into production server using Microsoft office share point services (MOSS).
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2005 Reporting Services (SSRS) and Crystal reports.
• Created many rich and highly interactive Web forms for user management module using ASP.Net 2.0, VB and DHTML.

Environment: SQL Server 2005/2008, SSIS, SSAS, SSRS, Erwin, .Net Frame Work, ADO.Net, VB.Net, XML, VB Script, Java Script, MS Access, Excel, Share point (MOSS), C# .Net, ASP .Net, Crystal Reports, ER Studio, Performance point Server, Cognos 8 BI.

Confidential, Raleigh, NC

SQL DEVELOPER/ BI DEVELOPER

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model using Erwin and ER Studio.
• Created SQL reports, Data extraction and Data loading scripts for different databases and schemas.
• Developed and maintained various cubes using MDX complex queries using SSAS.
• Designed and deployed various Reports using SSRS.
• Used Microsoft service broker for messaging purposes between various applications.Involved in Performance Tuning and monitoring of T-SQL blocks.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area using SSIS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Performed all aspects of database administration, including Data Modeling, Backups andRecovery. worked on Catalog Hierarchy pages wif product counts Side-by-Side Product Comparison extract price & availability data from various suppliers/distributors in real time and present them in side-by-side comparison format

Environment: SQL Server 2000, DTS, T-SQL, C/C++MS OLAP, CVS, Windows 2000, Sybase, Crystal Reports, C# .Net, ASP .Net, ADO .Net, ER Studio, SSIS, SSAS, SSRS, Erwin, Team Foundation Server.

Confidential

VB/SQL Server Developer

Responsibilities:

• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Coded Stored Procedures, functions and triggers at high level.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Participated in User Acceptance Testing for different modules.
• Implementing user training and providing technical support.
• Prepared proper backup and recovery plans.
• DBA activities like creating users, roles and granting and revoking privileges.
• Merging data into a single server for achieving better control, consistency & security of data.
• Designed the Logical and Physical design of database for projects on basis of user requirements.

Environment: Windows 2000 Server, MS SQL Server 2000, T-SQL, SQL Query Analyzer, Profiler.