SUMMARY

• 7 years of strong experience with Demonstrated success in the Database Design, Development and Deployment of large - scale enterprise applications.
• Expert in MS SQL Server 2008/2005/2000 suite of products like SSIS, SSAS and SSRS.
• Hands of experience on Database development in OLTP (Online Processing) and OLAP(SSIS, SSRS and SSAS)
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Views, Indexes, User profiles query writing and SQL joins.
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP and experience with Working on SSIS, SSAS, SSRS, Data Analysis, Data Cleansing/Data Scrubbing and Data Migration.
• Worked with T-SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys.
• Proven ability in Performance Tuning, Query Optimization and Running Database.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated Transformations to be used in SSIS packages.
• Used DTS/Integration services (SSIS) to migrate data from one system to another and performed several transformations to ensure data integrity and validity.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS)
• Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Experienced in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server.
• Excellent Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).

TECHNICAL SKILLS

Relational Databases: SQL Server 2008R 2/2008/2005/2000 , MS Access.

Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe and SQL Query Editor

Languages: T-SQL, HTML, XML,SQL,C, VB.Net, ASP.Net

Operating Systems: Windows 98/NT/2000/XP, Windows Server 2003/2008, UNIX, LINUX

Web Technologies: HTML, XML, XSL, IIS(4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL BI(SSIS/SSRS/SSAS) Developer

Responsibilities:

• Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between Oracle to SQL Server. Moved Data from flat files and Excel sheets using SSIS.
• Imported data from text files and excel spreadsheets into SQL Server 2008 database using SSIS package.
• Created packages using Error handling mechanism and used variables to handle package dynamically.
• Moving data to staging tables using SSIS.
• Developed complex reports using SSRS for HR and other Business users.
• Extensive experience in the development of Reports using SQL Server 2005, 2008 R2 reporting services.
• Expert in analyzing Business requirements, gathering information from business users and develop reports accordingly.
• Designed data warehouse with required facts and dimensions using Star schema.
• Designed and developed efficientSSIS packagesfor processing fact and dimension tables with complex transform.
• Used SSAS in BIDS to create new facts and dimensions.
• Created calculated measures using MDX implementing business requirement.
• Created and processed cubes that support new organization structure.
• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data to meet the company specifications.
• Extensively used Joins, Functions and Correlated Sub-Queries to simplify complex queries involving multiple tables.
• Involved inPerformance Tuningof Code using execution plan and SQL profiler and addedIndexesto improve performance on tables.
• Developed the end-user documentation and performed periodic updates of the design documents.

Environment: SQL Server 2005/2008, SSIS, SSRS, SSAS, Windows Server 2003,Visual Source Safe 6.0, VB.net, MS- Access.

Confidential, DE

SQL BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Created User Defined Functions (UDF’s) to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Responsible for developing, monitoring and deploying SSIS packages in BIDS.
• Created and tuned Event Handlers, Checkpoints and logging to maintain active packages.
• Extensively utilized SSIS packages functionality to create complete ETL Process using scripts, stored procedure, Functions and Transformation of Data in BIDS.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Experience in using XMLA protocol for SQL Server Analysis Services 2008 for interaction between client application and instance of Analysis Services.

Environment: SQL Server 2008, T-SQL, SSRS, SSIS, SSAS, TFS, Management Studio 2005/2008, Query Analyzer.

Confidential, WA

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created Star schema Dimension Modeling for the Data Mart using Visio and created dimension and fact tables based on the Business requirement.
• DesignedSSIS packages to Extract data from different sources like SQL server 2008,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS in BIDS
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, Dashboard and Matrix reports. Responsible for ETL through SSIS and loading Data to DB from different input sources in BIDS.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Used MDX Expressions to optimize the cube design process in SSAS
• Created Dimension types such as Standard dimension, Parent - Child dimension and Role Play dimension in SSAS.

Environment: MS SQL Server Management Studio 2008, Query Analyzer,, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visual source Safe, Share Point.

Confidential, NY

SQL Server Developer

Responsibilities:

• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub reports using SQL Server Reporting Services 2008.
• Experience in writing MDX queries for cubes and Performance optimization of MDX queries.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Experience in creating Ad-hoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Experience in using XMLA protocol for SQL Server Analysis Services for interaction between client application and instance of Analysis Services.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.

Environment: SQL Server 2005, T-SQL, SSIS, SSRS, SSAS, TFS, Windows Server 2003.

Confidential

SQL Server Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development, change management, deployment and User training
• Involved in ER diagrams and mapping the data into database objects.
• Design of the Database and the Tables.
• Build table relationships and wrote Stored Procedure’s to clean the existing data.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery,
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Worked on Stored Procedures and Database Triggers. Worked on large number of Business Analytical Functions.
• Developed SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Involved in Job scheduling and alerts.
• Generated database SQL scripts and deployed databases including installation and configuration.

Environment: SQL Server 2000/2005, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5, ASP/VB.NET