SUMMARY

• Over 8 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2008 R2/2005 in Production, QA and Development Environments.
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2005.
• Experience in Managing Security of SQL Server 2005/2008 R2 Databases by creating Database Users, Roles and assigning proper permissions according to teh business requirements.
• Strong experience wif T - SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking teh database consistency by executing DBCC Commands.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005 Reporting Services (SSRS), SQL Server 2005 Integration Services (SSIS) and in SQL Server 2005 Analysis Services (SSAS) in Business Intelligence (BI).
• Hands on experience wif performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2).
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled teh Reports in Report Manager.
• Integration of SSRS Reports using various web parts into Sharepoint (MOSS 2007) and various delivery mechanisms.
• Experience in Interacting wif Business users to analyze teh business process and transforming requirements into screens, performing ETL, documenting and rolling out teh deliverables.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Worked wif Business Analysts, Web development team, and users on database solutions.

TECHNICAL SKILLS

Operating System: Windows NT 4.0,Windows 2000/2003/2008 R2 Enterprise/Datacenter Server, XP Professional, UNIX.

Databases: MS SQL Server 2008 R2/2005/2000, MS Access, My SQL

Programming Languages: T-SQL, C, C++, Shell Scripting, SQL, XML, C#, VB.NET, MDX

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook.

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS,SSAS,Index Analyzer, SQL Client Utility.

Reporting Tools: Reporting Service (SSRS) 2000/2005/2008 R2

ETL Tools: DTS, SSIS.

MS Tools: Management Studio, Visual Studio.

Internet Tools: Internet Information Server (IIS 5.0 / 6.0), FTP, TCP/IP

Other Tools: Source Depot, Octopus.

PROFESSIONAL EXPERIENCE

Confidential, SAN JOSE, CA

Senior SQL Server/BI Developer

Responsibilities:

• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for teh application.
• Involved in designing teh physical databases model on SQL Server 2005/2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• me Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked wif development teams in teh design of physical databases and in modification.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Good understanding of Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services (SSRS).
• Worked on various complex requirements of developing monitoring dashboards wif multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.
• Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting teh flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created ETL SSIS packages both design and code to process data to target databases.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Constructed OLTP and OLAP Databases.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Created calculated fields wif MDX code to meet additional measures needs that are calculated from existing measures.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Used Notification services to generate error messages and send them to teh user through e-mails, pager messages, and PDA as well as window messengers.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Windows 2003/2008 R2 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Service Broker,Source Depot.

Confidential, Austin,TX

Sr SQL/BI Developer

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across teh organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for teh Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including Sharepoint/Moss2007 integration.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy LookUp, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2005 and develop and unit test SSIS load processes for performance check.
• Designed OLAP cubes wif star schema and multiple partitions using SSAS.
• Understanding teh OLAP processing for changing and maintaining teh Warehousing Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Involved in writing MDX queries and performance optimization of teh SSAS cubes for calculated members and measure groups.
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Involved in migration and Conversion of Reports from SSRS .
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models wif multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate teh special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards wif multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cognos, Business Objects, SharePoint,MOSS 2007,Octopus.

Confidential, Iselin, NJ

MS SQL Server/BI Developer

Responsibilities:

• Extract, Transform and Load source data into respective target tables to build teh required data marts.
• Understand user requirements and Data Model defined and developed by teh business analysts and data architects.
• Constructed OLTP and OLAP Databases.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for teh models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing teh performance of teh databases.
• Maintained teh physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Migrated data from SAS environment to SQL Server 2005 wif SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for teh faster processing of reports.
• Designed SSAS cube to hold summary data for Targit dashboards.
• Developed Cube wif Star Schema.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2005/2000, DTS, T-SQL, XML, Flat File, SQL Server Reporting Services, Visio, IIS, Windows XP/2000

Confidential, Seattle, WA

SQL/SSIS/SSRS Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Monitored and scheduled existing/new jobs on production environment.
• Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers.
• Worked to tune teh SQL queries using SQL Profiler.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Extensive use of Stored Procedures. Created new stored procedures and modifying existing ones.
• Migrated data from SAS environment to SQL Server 2005 wif SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for teh faster processing of reports.
• Designed SSAS cube to hold summary data for Targit dashboards.
• Developed Cube wif Star Schema.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2005, MS SQL Server 2000, Windows 2003 Server, T-SQL, SSIS, SSRS,SSAS, ASP .Net, VB.net

Confidential, VA

SQL Server,SSIS/SSRS Developer

Responsibilities:

• Involved in all teh phases of SDLC.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used Stored Procedures for updating Servers.
• Managed Premier Bankcard Inc staging database to load teh fact Tables and handled calculations and Data Validation.
• Used tools like SQL Profiler to Monitor Performance issues wif queries or Application (me.e. Opening/Closing Connections by application, Read/Write etc.)
• Analyzed and tuned Database Growth and Space Requirement as data were growing day by day.
• Standardized company reports by implementing SQL Server Reporting Services (SSRS).
• Generated teh Reports wif all teh subcategory Information to Business users.
• Interviewed Clients and management to identify additional reporting needs Develop report requirements and specifications to meet Reporting needs.
• Developed and Deployed different types of Reports like List, Drilled Down, Matrix, and Chart and Sub Reports etc.
• Created and Executed teh Stored Procedures and Complex Queries for Reports.
• Deployed and Scheduled teh Reports in Report Manager. 7
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House and for OLTP side.
• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa.
• Creation/Modified complex stored procedures which are used for various reports.
• Created/Maintained clustered/non clustered Indexes for fast and efficient reporting process.
• Used DDL and DML to writing Triggers, Stored procedures to check teh Data Integrity and payment verification at early stages before calling them.
• Optimized teh performance of T-SQL Queries by modifying teh existing Index Tuning system and rebuilding indexes again wif respect to teh me/O.
• Documented teh Stored Procedures and User Defined Functions (UDF) for future references and maintenance.

Environment: SQL Server Reporting Services, SQL Server Integration Service (SSIS), Microsoft Access 2003, Microsoft Excel 2003, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Visual Studio 2005, DTS, Enterprise Manager, DTS wizards, DTS Designer and DTS programming interface.

Confidential

SQL Server Developer

Responsibilities:

• Involved in planning & design.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Fine-tuned teh logic in Procedures, Functions and Triggers for optimum performance.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Wrote Transact SQL utilities to generate table insert and update statements.
• 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.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform teh Data and worked extensively in T-SQL for various needs of teh transformations while loading teh data.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Client side validations taken care by using VBScript.
• SQL Server used for database and ADO used for database interaction
• Created Procedures, functions, indexes, tables, triggers in SQL Server2000.
• Coding, debugging and testing of teh application

Environment: SQL Server 2000, Windows 2000, HTML, VB Script.

Confidential

SQL Server DBA /Developer

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program.
• Tested teh Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for teh Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored teh Database from Disaster Recovery.
• Worked on replication server and managed.
• Fine tuning of database objects and server.
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Used DTS to migrate teh tables to teh Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring teh servers using spot light third party Quest software.
• Recovering teh databases from backup in disasters
• Maintaining teh database consistency wif DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and dead locks.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Enterprise manager, VBS, MS Office & Windows 2K platform.