Professional Summary:

• Over 9 years of strong experience in the IT industry as a MS SQL Server 2008/2005/2000 Developer/BI Developer in various domains like Financial, Healthcare and Banking. Maintained positive communications and working relationship at all levels.
• Expert knowledge of all phase of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development and Implementation.
• Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.
• Skillful in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Expert in developing and modifying multi dimensional cubes using MS SQL Server Analysis Services SSAS .
• Hands on experience in implementing Key Performance Indicator KPI Objects and partitions in SSAS 2008/2005.
• Strong in developing and modifying cubes using SSAS and transform into pivot table.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2008/2005.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services SSRS
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
• Expert in using Bulk Copy Program BCP , Data Transformation Services DTS packages and SSIS integration services with MS SQL Server 2008/2005/2000.
• Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2008/2005.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Quick learner, excellent communication skills and good performer both in team and independent job environments.

Business/Technical Skill:

MS SQL Server 2008R2/2008/2005/2000/7.0, MS SQL Server 2008/2005 Analysis Services SSAS , MS SQL Server Integration Service SSIS , MS SQL Server Reporting Services SSRS , Business Intelligence Development Studio BIDS , BCP, SQL Profiler, Enterprise manager, Management studio, Microsoft Access 2000, ERWIN 4.0/4.1/4.2/7.2,Microsoft Visio 10.0/11.0, T-SQL, ASP.NET, C , VB.Net, HTML, XML, XSL, Oracle 9i/10g, Crystal Reports 8.5/9/10/11, Visual source safe 2005, MS office 2007/2003, Windows 2003/2000 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

Professional Experience:

Confidential

Role: MS SQL Server Developer/BI/ETL Developer/SSIS/SSRS Developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Very good 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.
• Expertise in Master data Management for design/ creation of MDS components. Configure the rules and data governance on DQS server.
• Used Visual Intercept Manager, the premiere bug tracking system for the Microsoft development environment, which is project oriented, scalable and optimized.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Expert in Created/Updated database objects like tables, views, stored procedures, function, packages,
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008R2 Reporting Services SSRS .
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Tools and Technologies:

MS SQL Server 2008R2, T-SQL, SQL SSIS, SSRS, SSAS, Windows server 2003 Visual Source Safe, SQL Profiler, Visual Studio 2008,Visual Intercept Enterprise Edition, Oracle 10g, VB.Net

Confidential

Role: SQL/SSIS/SSRS/SSAS/ETL Developer

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 2008 and Management tools using SQL Server Setup Program.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
• 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.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Designed the SSIS package for matching data to remove the duplicates from Supplier List using DQS and storing the supplier data in MDS.
• 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.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Performed daily tasks including backup and restore by using MS SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• 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 2008.
• Supported production operation activities, with focus on integration and development of new and existing products and services.

Tools and Technologies:

MS SQL Server 2008, MSSQL Server Integration services SSIS ,MS SQL Server Reporting Services SSRS , MS SQL Server Analysis Services SSAS , BIDS, Visual Studio 2005, VSS 2005, Erwin v7.3, Windows NT/2003, Microsoft .NET framework 3.5.

Confidential

Role: MS SQL Developer/SSAS/SSIS/SSRS Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Experienced in developing T-SQL DDL, DML statements using dynamically generated SQL.
• Designed an OLAP with the help of ERWIN to visualize data structure.
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using MS SQL Server Integration Services SSIS 2008.
• Developed MDX expressions for cube calculations and KPIs.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Improved query performance and reduced down by cube partitioning.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2008.
• Generated reports using SSRS 2008 as per business requirements.
• Developed measures and dimension members using multi dimensional expression MDX to meet additional needs that were calculated from existing measures.
• Implemented the calculations to aggregate physical measures using management studio.
• Identified and defined the scoped assignments using script commands.
• Defined Referenced relationships with the measure groups and fact tables.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Established a sound backup and recovery policies and procedures.

Tools and Technologies:

MS SQL Server 2008 Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005, DTS, T-SQL, VB Script, Windows Server 2003, Erwin 4.0.

Confidential

Role: MS SQL Server Developer/BI Developer/ SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Created OLAP cubes and dimensions for the analysis of student's registrations in specific areas using SSAS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2005 with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Established backup and recovery of MS SQL server 2005 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Used Visual Source Safe VSS for version control.

Tools and Technologies:

MS SQL Server 2005, SSAS 2005, SSRS 2005, SSIS 2005, T-SQL, Visual studio 2005, DTS, Data Analyzer, MS Access, Excel, SQL Profiler, Windows XP, Erwin v4.2, VSS 2005

Confidential

Role: MS SQL Server Developer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Import Export of data from one server to other servers using tools like Data Transformation Services DTS .
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Managed rollback segments, and table spaces to ensure less space used by the database.
• Created documentation on the all the tables, stored procedures, views and user defined functions.

Tools and Technologies:

MS SQL Server 2000, Windows Server, Windows NT, Erwinv4.0, Visual SourceSafe, Crystal reports, DTS