SUMMARY

• Over 7 years of experience with MS SQL Server 2000/2005/2008 as SQL Server Database Developer in windows environment.
• Over 6 years of Proficient experience in writing and tuning Transact - SQL (DDL/DML) Queries.
• Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing/Client-Server/e-commerce applications.
• Extensive knowledge in Tuning SQL queries and improving the query performance.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate Functions, and effective Triggers to facilitate efficient data manipulation and data consistency. Expert in migrating of databases from older versions of SQL Server to SQL Server 2008.
• Extensive experience is creating interfaces using SSIS in MS SQL Server 2005.
• Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects.
• Experienced in upgrading from MS SQL Server 2000 to MS SQL Server 2005.
• Good at installing, configuring, managing, monitoring and troubleshooting SQL Server 2000 and SQL Server 2005 on Windows 2003 Enterprise servers.
• Experienced in developing and designing reports on Crystal Reports and SQL Server Reporting Services (SSRS).
• Experienced with all the phases of Software Development Life Cycle (SDLC) and Quality procedures and standards while executing projects.
• Developed Drill through/down reports using SQL Server Reporting Services (SSRS).
• Experienced in designing Database Models using Microsoft Visio and Erwin.
• Experienced in interfacing the Legacy Systems to SQL Applications using various Interfacing techniques.
• Worked extensively on system design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
• Good knowledge in developing and implementing Disaster Recovery Model, and Replication Models.
• Excellent communication and inter-personal skills with ability to work as a team member or independent player and ability to interact with clients.
• A multitasking analytical thinker with the ability to work on fast paced work Environment.
• Excellent communication skills, analytical skills, understand business requirements in various domains.
• Strong problem solving and analytical skills with ability to work independently as well as in a team.
• Efficient in teamwork, strategic planning & possess excellent communication skills.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008
• T-SQL
• ODBC
• DTS
• SQL Server Analysis Services (SSAS)
• SQL Integration Services (SSIS)
• SQL Server
• Reporting Services (SSRS)
• Computer Languages: C
• C++
• Java
• Intel 8086
• MotorolaM68HC11Arm Assembly Language
• MATLAB
• PSPICE
• MS Office
• Excel
• Power Point
• Windows 9x/NT/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

MS SQL Server Developer

Responsibilities:

• Participated in upgrading from MS SQL Server 2005 to MS SQL Server 2008.
• Worked closely with the DBA for successful preparing, planning and installation of the upgraded software and all its new tools.
• Wrote complex T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constraints to preserve data integrity.
• Upgraded SQL Server 2005 databases to 2008, using Detach/Attach, Back up & Recovery and by Replication.
• Scheduled Jobs to call SSIS packages and Stored Procedures.
• Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Increased query performance by performing monitoring, tuning, and Optimizing Indexes tasks using Performance
• Monitored SQL Profiler and Database Engine Tuning Advisor.
• Set up the Report Server and moved the existing SQL 2005 reports to Server using SSRS.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and Managers.

Environment: MS SQL Server Integration Services (SSIS), MS SQL Server 2005/2008, Windows, SQL Server Reporting Services (SSRS)

Confidential, Cupertino, CA

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into ETL Design Specifications and SSAS cube.
• Designed and implemented Sales Data warehouse star schema, Fact and Dimensions.
• Implemented type 1 and type 2 Slow Changing Dimensions.
• Using Control Flow elements like For each loop and Sequence container.
• Execute SQL task, Execute Process task, Execute package task and Script task, File System task Send Mail Task.
• Extensively used variables, package configurations, logging
• Designed and deployed Reports, Report Model using SSRS.
• Designed SSAS cubes, refine. Added calculated measures, KPIs, Actions and perspective to the cube. Process and Deploy cube using BIDs designer interface.

Environment: MS SQL Server 2008-R2/2005, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Windows XP, Windows Server 2003

Confidential, East Rutherford, NJ

MS SQL SSIS/SSRS Developer\DBA

Responsibilities:

• Conducted detailed analysis of each Legacy source system interface with Confidential Data warehouse (ADW) including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.
• Wrote Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each legacy system interface with ADW.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in MS SQL Server 2005.
• Developed Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables and also for Error handling during the ETL process.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional Modeling principles in SSAS.
• Designed and developed MOLAP and ROLAP cubes with SSAS.
• Developed and implemented partitioning and security in cubes based on user roles.
• Implemented Member properties, virtual Dimensions, Dimension custom rollups, write back, action and drill through.
• Designed MDX expressions/queries for accessing cubes; involved in query structuring and performance optimization.
• Performed API coding using VB for implementing cube at application level.
• Implemented VB.Net script and performed testing.
• Developed role based Dashboards to monitor KPIs and Ad hoc reports for Accounting and Claims using SSRS.
• Developed complex canned reports using SSRS 2005 from multiple data providers in Underwriting and Claims systems, User defined objects, Aggregate Aware Objects, Charts and synchronized queries.
• Conversion of Crystal Reports to Reporting Services and also existing SAS reports to Reporting Services 2005.
• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor, Execution Plan and Index Tuning wizard.
• Validated reports to ensure quality of data and conducted Meetings with business users to review reports and obtain continuous feedback.
• Coordinated the activities of subordinates in the Data warehouse Team and organized weekly status Meetings.

Environment: Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS) 2005, SQL Server Integration Services (SSIS) 2005, SQL Server Analysis Services (SSAS) 2005, Query Analyzer, Microsoft SharePoint, Microsoft Visio Professional 2005, Optimal Trace, SAS, Crystal Reports.

Confidential, Newark, NJ

MS SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Transformed data from MS SQL Server 2000 to MS SQL Server 2005 using OLE DB connection by creating various SSIS packages.
• Used the Execute DTS 2000 package task to execute DTS packages.
• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Designed a new schema for the Data Mart databases.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.
• Created MDX queries to extract data from the Data Mart.
• Generated Dynamic reports from Cubes (SSAS) using SSRS-2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Used HTML code to make Report manager more functional & customizable.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Environment: MS SQL Server 2005, SSRS, SSIS, SSAS, Crystal Reports XI, Business Object XI, DTS, T-SQL, VisualSourcesafe.

Confidential, Pasadena, CA

MS SQL /C#.Net Developer

Responsibilities:

• Created stored procedures, scripts, views in Oracle database design and create SQL Database, tables, indexes, and views.
• Create User Defined Functions, Stored Procedures, and Triggers.
• Suggested creating Clustered and Non Clustered indexes on tables
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.
• Fine tune complex SQL queries and Stored Procedures to increase performance.
• Created & used stored procedures for database transactions in SQL Server.
• Worked on Exception Handling with @@error and with Try/catch.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Experience in Database Capacity Plan.
• Extensively used XML documents to pass multiple parameters for Stored Procedures to read and write database table.
• Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Worked on DTS Package, DTS Import for Transferring data from Oracle and Lotus notes.
• Looked at the reports and fixing bugs in stored procedures, tables and ETL process.
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler
• Created custom and standard reports using Crystal Reports.
• Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals, and alerting.

Environment: MS SQL Server 2005/2000/7.0, DTS, SQL Management Studio, SQL Server Business Intelligence Tools, Windows 2003, SQL Server Query Analyzer, SQL Profiler