SUMMARY

• Over 7+ years of extensive experience in database design, development and administration with MS SQL Server versions 2008/2005/2000/7.0 using SSIS, SSAS, SSRS (BI Tools) in Financial, Retail, Insurance and Banking industries.
• Proficient in Installing SQL Server 2008/2005/2000 and configuration of their tools.
• Excellent Transact - SQL/ T-SQL (DDL/DML) programming skills.
• Good Business and System Analysis skills to understand the requirements and customize client applications.
• Excellent back-end skills in creating SQL objects like Tables, complex Stored Procedures, effective functions, Views, Indexes, appropriate Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and data consistency.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience with Business Inelegance Studio 2005. (SSIS/SSAS/SSRS)
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema forDeveloping Cubes usingMDX.
• Developed Multidimensional Objects (Cubes, Dimensions) usingSQLServerAnalysis Services (SSAS).
• Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Worked as a SQL Server DBA in a data warehouse environment; responsible for developing, support and maintenance for the ETL processes.
• Expertise in Creating Databases based on Functional Requirements and System Design.
• Extensively worked with QA, release team and developers to give the required environment.
• Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

• MS-SQL Server 2008R2/2005/2000
• SQL Server Enterprise Manager
• Query Analyzer
• Transact-SQL (T-SQL)
• MS SQL Server Reporting Services (SSRS)
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Integration Services (SSIS)
• Data Transformation Services (DTS)
• SQL Server Management studio (SSMS)
• Business Intelligence Development Studio (BIDS)
• MS Access
• MS Visual Studio
• Bulk Copy Program (BCP)
• Microsoft Office
• MS Visio 2003/2007
• C
• HTML
• ASP .NET
• Crystal Report
• Erwin 7.3/4.1/4.0
• Performance Point Server
• Visual SourceSafe (VSS)

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, join and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical database model on SQL Server 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.
• Worked with development teams in the design of physical databases and in modification.
• Created Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2008 R2 Reports Services (SSRS).
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Proficient in SSIS process design architecture the 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 and process SSAS cubes.
• Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Generated and Deployed ETL SSIS packages both design and code to process data to target databases.
• Developed complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Exceptional ability in calculating fields with 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.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition SP3, SSMS, SSIS, SSRS, SSAS, BIDS, Microsoft Visual studio 2005, Windows server 2003.

Confidential, Burlington, NJ

SSIS/BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Designed SSIS Packages to transfer data from various sources like Informix Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server 2008.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP systems and scheduled Jobs to call the packages and Stored Procedures using SQL Server Agent.
• Authored stored procedures to move data through the ETL subsystem into the Property subsystem.
• Implemented model changes required by business changes.
• Defect remediation of the ETL and Property subsystems.
• Developed SSIS packages for extracting the data from Staging Database, Perform the QC Rule Check and loading into the National Property Database.
• Performance tuning of complex SQL queries and Stored Procedures to increase the performance and Worked on Exception Handling.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing. Extracted, cleaned and validated.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis.
• Data warehouse model implementation.
• Creation of extended properties for database columns.
• Authored SSIS packages for Data Importing, Cleansing, parsing and validation.
• Creation of stored procedure and triggers for automating tasks.
• Creation of tunes SQL Queries for maximum efficiency and performance.
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Created reports to retrieve data using Stored Procedures that accepts parameters.

Environment: MS SQL Server 2008, SSRS, T-SQL, SSIS, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v7.2, ASP.Net, C#.

Confidential, Dallas, TX

SQL Developer/SQL Server DBA

Responsibilities:

• Involved in design, development and implementation of OLTP databases, to enhance their e-commerce and supplier network, using Microsoft Visio.
• Contributed to capacity planning for the Existing back-end OLTP & Warehousing database requirements to meet current and future customer requirements
• Created and maintained indexes and clustering of existing OLTP databases to scale up performance to meet increased customer network traffic demands across the SAN.
• Configured and implemented replication OLTP databases to support disaster recovery and business continuity of the existing back-end database network for E-commerce, supplier network and other back-end databases
• Performed data analysis of existing operational and customer data, data modeling and design with Microsoft Visio, implementation and importing of existing data into newly built high-performance databases in SQL Server 2008R2
• Updated statistics and Execution plans, for existing Stored Procedures and Queries, Cursors, to meet performance expectations with increased demand
• Created new Stored Procedures, Triggers, Views, User-defined Functions, Power-shell scripts in T-SQL and interfaced them with front-end ASP.net pages as well as Software applications, using C# to support E-Commerce and Supplier network, for high availability.
• Responsible for Performance Tuning of OLTP operational databases, stored procedures, triggers, User-defined functions, Views and Tables using SQL Server Profiler
• Back-up and maintain transaction logs, implement standby servers, perform point in time recovery plans and solve critical production problems.
• Implemented and maintained version control using Visual Source Safe on all existing OLTP & OLAP databases and Data Warehouses.
• Created documentation for maintenance of existing operational databases and data warehouses, business continuity and disaster recovery efforts, stored procedures, views, tables, indexes and clusters, interfaced ASP.net Pages & user applications
• Created jobs for periodic backups of existing Databases, transaction logs and execution plans, as well as migration from Oracle, and other Database systems into MS SQL Server 2008R2 using SSIS.
• 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 the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, MultiCast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2008 R2 and develop and unit test SSIS load processes for performance check.
• Developed various complex reports and manage those using SQL Server Reporting Services (SSRS 2008 R2).
• 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 a time restricted environment.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Deployed designed PPS dashboards & reports in a MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.

Environment: MS SQL Server 2005/2008, SSRS, T-SQL, SSIS, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v7.2, ASP.Net, C#.

Confidential, Minneapolis, MN

BI Developer

Responsibilities:

• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Understood user requirements and Data Model defined and developed by the business analysts and data architects.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on a 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 of the models.
• Managed indexes, statistics and tuned queries by using the execution plan for optimizing the performance of the databases.
• Maintained the 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 with SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Developed logging for ETL load at the 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.
• Proficient in gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimally stored procedures and queries to create datasets for reports.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Worked on performance tuning on existing stored procedures and existing reports for faster processing of reports.

Environment: MS SQL Server 2005/2008, SSRS, T-SQL, SSIS, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v7.2, ASP.Net, C#.

Confidential, Kansas City, MO

SQL SSIS/SSRS Developer

Responsibilities:

• Installation of MS SQL enterprise servers to 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 in a production environment.
• Optimizing Database Queries for performance enhancements and writing T-SQL Views and Triggers.
• Tested backup and recovery strategies in a test environment before and after moving to a production environment.
• Extensive use of Stored Procedures. Created new stored procedures and modifying existing ones.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Developed ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at the package level and task level to a large number of records processed by each package and each task in a package using SSIS.
• 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.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation.
• Queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Understanding the OLAP processing of changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Environment: Microsoft SQL Server 2005, T-SQL, Windows Server 2003, SSIS, SSRS, VB Scripting, Erwin, Visual Studio 2005.

Confidential

MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of data source and data flows.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin 4.2 to design a new database after discussion with technical team and application.
• Analyzed data quality, by working in conjunction with the data warehouse architect on the development of logical data models.
• Designed and developed SSIS packages to move data from the production environment in different environments within the organization.
• Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamically configuring of SSIS packages.
• Migrated database from MS SQL Server 2000 to MS SQL Server 2005 using SSIS packages.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP sources like MS SQL Server 2000, Oracle, Text Files, Excel and Access to OLAP with the help of MS SSIS.
• Used SSIS to manually transfer DTS packages 2000 to SSIS packages 2005 using MS SSIS 2005
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2005.
• 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.

Environment: MS SQL Server 2000, SSRS 2000, SSIS 2000, T-SQL, ETL, C#, .NET 2.0, Visual studio 2005, Erwin 4.2