SUMMARY

• Over 8+ years of IT experience in BI using MS SQL Server and Microsoft Technologies, Experience manipulating various data sources to support senior management decisions, Ability to accomplish tasks under minimal direction and supervision.
• Experience in Data Warehouse and RDBMS concepts as SQL Server database &BI Developer.
• Involved in all the phases of software development life cycle SDLC process (Design, Development and Unit Testing, System Integration Testing and Functional Testing).
• Designing and developing OLAP dimensions, cubes, measures, and calculated members with SQL Server 2005/2008/Analysis Services 2005/2008.
• Expertise in SQL Server 2005 Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Designing and developing SSRS reports using both SQL and MDX for retrieving data.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features.
• Performed CDC and Change tracking on OLTP systems.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS and also prepared ETL mapping processes and maintained the mapping documents.
• Converting existing SQL queries from a proprietary database system to run against Microsoft SQL Server Analysis Services SSAS cubes using theMDXquery language.
• Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).
• Experienced in SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services).
• Experienced in developing Interactive Reports using SSRS (SQL Server Reporting Services).
• Experienced in developing Custom Report and different types of Chat Reports, Tablix Reports,Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services.
• Extensive Experience in Data modeling, Database Design, Back End Development using Stored Procedures.
• Implemented sub reports&dynamic cascading prompts for parameter passage.
• Created Parameterized reports, Cross - Tab reports, Drill down reports& Summary reports.
• Deploy and manage the reports to a report server and securing and managing the reports with Reporting server.
• Experienced in creating Views, Stored Procedures, functions and Triggers using T-SQL.
• Experienced in ETL - Extract Transform and Load experience using DTS&SSIS (SQL Server Integration Services) in SQL Server 2005 and 2008.
• Designed SSIS to extract appropriate records and output them to DM Warehouse.
• Developed several scripts to synchronize stored procedures, SSIS to log messages and outputs.
• Created SSIS tasks to email output and log messages using Script task.
• Through knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Written stored procedures for AutomaticScripting to backup transaction logs, log files, maintain archive of objects.
• Experienced in writing complex T-SQL quires and stored procedures.
• Experienced in performance tuning of T-SQL queries and procedures.
• Experienced in different kinds of OLTP and OLAP Systems.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Used tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Good knowledge of UNIX/LINUX and shell scripting.
• Also have knowledge on C, C++, and C #, ASP.net, VB.net, IIS, HTML, VBScript, JavaScript,XMLand JAVA. Proficient in Object Oriented Programming Technology
• Excellent communication and presentation skills, self starter, quick learner and team player.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003/2008 Windows XP/Vista

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

Tools: /Utilities: Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * Plus, Toad, Ervin

Databases: MS SQL Server 7.0/2000/2005/2008, Oracle10g/9i, MS Access

Data Modeling Tools: Microsoft Visio, UML

Software: MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, OBIEE.

PROFESSIONAL EXPERIENCE

Confidential, MN

Senior SQL Server Developer /SSIS/SSAS/SSRS

Responsibilities:

• Interacted with various parties including the users of the system, Database engineers and reporting manager to understand the requirements of the project and follow it up with a detailed Requirement Specification Document.
• Designed the Database schema on MS SQL Server. Various tables, views, indexes and Stored Procedures were created in the process.
• Developed a windows service in Visual C# .NET for automatic retrieval of flat files from pre-defined locationto capture the results of server build by parsing the file and storing the same in database.
• Developed a windows form application in Visual C# .NET which would be used to load pre-defined data into the database by allowing users to browse for CSV files.
• DevelopedASP.NET web application which allowed users to generate server build reports based on selection criteria of the users. Used JQuery API for client side scripting.
• SSRS was used to generate reports dynamically via the web application. Created complex stored procedures in T-SQL to retrieve the data from the database based on user input.

Confidential, CA

SQL Server Developer /SSIS/SSAS/SSRS

Responsibilities:

• Actively participated in interactions with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T - SQL, scripts, stored procedures and views).
• Designing and developing OLAP dimensions, cubes, measures, and calculated members with SQL Server 2005/2008/Analysis Services 2005/2008.
• 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.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Designing and developing SSRS reports using both SQL and MDX for retrieving data.
• Created Stored Procedure using T-SQL to evaluate result for the reports to implement using Management Studio.
• Used DTS/SQL Server Integration Services and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Designed and architected of OLAP cubes to support business reporting and forecasting processes.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Created stored procedures to build the Fact tables in the data mart cubes for Multi-Dimensional analysis.
• Worked on different kinds of transformations in SSIS as per the client s Requirement.
• Converting existing SQL queries from a proprietary database system to run against Microsoft SQL Server Analysis Services SSAS cubes using theMDXquery language.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Analyzed existing Stored Procedures & Triggers and took actions to increase the performance in modularization.
• Wrote stored procedures to get the fields required for the reports.
• Extensive Experience in Data modeling, Database Design, Back End Development using Stored Procedures.
• Implemented database consistency and security by creating groups, roles, users, and triggers on views
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.
• Performed system testing and debugging, creating test case and reporting the bugs.
• Deployed the reports in to the report server.
• Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Deployed the databases from old servers to new servers using Replication, based on the business goal.

Environment: SQL Server 2008/2005, SSAS, SSIS, SSRS, Management Studio, XHTML, XML, Windows 2000/2003 Server, IIS 7.0.

Confidential, Atlanta, GA

SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexesrules and defaults on MS SQL server.
• Involved with Transact SQL (T-SQL)Coding, writing queries, cursors, functions, views, & triggers.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• 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.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Designing and developing OLAP dimensions, cubes, measures, and calculated members with SQL Server 2005/2008/Analysis Services 2005/2008.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2000.
• Converting existing SQL queries from a proprietary database system to run against Microsoft SQL Server Analysis Services SSAS cubes using theMDXquery language.
• Created DTSpackages to transfer objects from development server to production.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and Maintained Snapshot Replication across multiple server environments.
• Setup and maintained Linked Servers.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Through knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in creating Cubes using SQL Analysis Services (SSAS).

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports.

Confidential, GA

SQL Server Analyst/ BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Involved in Build cubes up to 200 gigabytes in size and over many partitions to include cube architecture (SSAS).
• Experienced in configuring the data sources and data source views, defining dimensions and measure groups, building measures and calculate measures in SSAS.
• Designing and developing OLAP dimensions, cubes, measures, and calculated members with SQL Server 2005/2008/Analysis Services 2005/2008.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Extensive Experience in Data modeling, Database Design, Back End Development using Stored Procedures.
• Performed source/ Confidential analysis of data structures & content.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Published reports and dashboards on WEB.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Designing and developing OLAP dimensions, cubes, measures, and calculated members with SQL Server 2005/2008/Analysis Services 2005/2008.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Extensive Experience in Data modeling, Database Design, Back End Development using Stored Procedures.
• Used the SSIS Script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Performed intent locking to reduce the concurrency considerably in OLTP.
• Created package configuration using environment variables.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Performed Documentation for all kinds of reports and SSIS packages.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: T-SQL, SQL Server 2005/2008, Visual Studio 2005/2008, Performance Tuning, SSIS, SSRS, XML, HTML, VBScript,C #, ASP.net.

Confidential, Brisbane, CA

SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Gathered Requirements from the users and checked the structure of the schema and data with the Data Modular.
• Create database objects in SQL Server 2005 including Tables, Triggers, Views, Stored Procedures, User Defined Functions (UDF) and Indexes.
• Converting existing SQL queries from a proprietary database system to run against Microsoft SQL Server Analysis Services SSAS cubes using theMDXquery language.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintained Referential Integrity.
• Migrated database from SQL server 2000 to SQL server 2005.
• Designed high level ETLarchitecture for overall data transfer from the OLTP to OLAP with the help of SSIS and also prepared ETL mapping processes and maintained the mapping documents.
• Extensively used SSIS for transferring data manually from DTS to SSIS packages using SSIS 2005.
• Through knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Create SQL ServerIntegrationServices (SSIS) Packages.
• Designing and developing SSRS reports using both SQL and MDX for retrieving data.
• Generated reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2005.
• Design Reports Using SQL Server Reporting Services (SSRS)
• 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 as per client’s requirements using SSRS 2005.
• Created parameterized, drilldown and aggregationreports in MS SQL environment using SSRS.
• Generated daily, weekly and monthlyreports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery and track reporting history using SSRS 2005.
• Designing and developing OLAP dimensions, cubes, measures, and calculated members with SQL Server 2005/2008/Analysis Services 2005/2008.
• Tested the reports and fixedbugs in the storedprocedures.
• Maintained the physical database by monitoring performance, integrity and optimized SQ L queries for maximumefficiency using SQL Profiler.
• Extensive Experience in Data modeling, Database Design, Back End Development using Stored Procedures.
• Established backup and recovery of SQL reporting services.

Environment: SQL Server 2005 Enterprise Edition, SQL Server Reporting Services, SQL Server Analysis Services, SQL CLR, XML, Windows 2000, IIS 5.0