SUMMARY

• 7+ years of experience in IT, Financial Insurance and Healthcare environments with primary skill on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2012.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• In - depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• SQL Server 2000/2005/2008/2012 RDBMS database development including T-SQL programming.
• SQL Server 2005/2008R2 OLAP database development including KPIs, Data mining, working with changing dimensions
• ETL implementation using SQL Server Integration Services (SSIS).
• Good ETL skills, Data modeling, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages and Transact SQL, design and support/enhancements/maintenance
• Developing reports on SSAS & SSRS on SQL Server ( 2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP CUBES and Architecture
• Expert in creating the MDX CUBES and dimensions (SSAS).
• Good understanding ofMicrosoft ReportingService(SSRS)with Report authoring, Report management, Report delivery andReport security.
• Experience in developingUser reports and management reports using MS SQL Server Reporting Services (SSRS).
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Experience in writing Distributed Queries between SQL Servers.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
• Involved in DBA activities such as backups, restores, replication etc.
• Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions and Cursors and Triggers etc.
• Extensive experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP, Bulk Insert, ActiveX).
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expert in using tools like MS SQL Profiler, Query execution plan, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.

TECHNICAL SKILLS

Databases: SQL server 2000/2005/2008 R2/2012, MS Access

Languages: Transact- SQL, SQL, HTML, C.

Operating Systems: Windows NT/98/ 2000/XP/Vista/2003, MS-DOS

OLAP/Reporting Tools: SSAS, (SSRS), MDX, Crystal Reports.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, ETL Informatica.

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio.

Data Modeling Tools: Microsoft Visio 2000/2003,Altova tool

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler

Programming languages: C,SQL,PL/SQL,T-SQL,.NET,C#

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSRS, SSAS, Access Manager, SQL Server2008 Analysis Services and SQL Reporting services, DTS, ProClarity, PPS-2007, MOSS

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Experience in database design process and data modeling process for Billing Method using Erwin.
• Involved in migration of SQL Server /2012.
• Installation and configuration of SQL Server 2005/2008R2.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports and Sub reports using Sql Server Reporting Services R2.
• Experience in creating Adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS).
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Created Data-driven Packages in SSIS as part of the automating the process for billing method.
• Built various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages.
• Backup of CUBES by building custom package having Script task.
• Build a data CUBES around the existing offer click, impression and revenue statistics from redirectors
• Build a set of reports which includes historical same-period comparisons.
• Enhance and build selected redirect reports with the flexibility of an OLAP service
• Created SSIS packages to load data into staging table and data mart and also Performed logging in SSIS packages to capture error data and for error handling.
• Involved in analyzing, designing, building and testing of OLAP CUBES.
• Sound Experience and understanding of SSAS, OLAP CUBES, Data mining and Architecture.
• Involved in SSAS storage and partitions and aggregations, calculation of queries with MDX, data mining models; developed reports using MDX and SQL.
• Querying and manipulating multidimensional CUBES data through MDX Scripting in SSAS.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Experience in using XMLA protocol for SQL Server Analysis Services 2008for interaction between client application and instance of Analysis Services
• Write T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries.
• Created Package to support parallel processing using Multithreading.
• Involved in Data Modeling of data warehouse to model 35 tables to move data from staging.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Extract data from flat files which comprised of header and input files to SQL server 2008R2 and Created Testing scripts for staging validation.
• Involved in Installation, configuration of SQL Server 2008 on Windows 7.
• Created trace in SQL Profiler for Performance tuning on stored procedures and remove deadlocks using deadlock graphs.
• Published reports on to SharePoint and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one Page.
• Extracted data from various sources like SQL Server 2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP
• Experience in developing Life Cycle using Agile Methodology

Environment: MS SQL Server 2008R2, MS SQL Server Analysis Services 2008R2, Integration Services (SSIS), T-SQL, MS Excel, Tortoise SVN, Waterfall Environment, Agile environment, T-SQL, SQL profiler, MDX, OLAP, SSAS, SSRS, SSIS Expression Language, CMD prompt, SQL Server Configuration Tools, Toad for SQL Server, Sharepoint, SQL Compare and Ervin Data Modeling Tool.

Confidential, Los Angeles, CA

SQL BI Developer

Responsibilities:

• Created SQL Server Integration Services (SSIS) packages to import data from heterogeneous data sources like Oracle 9i, SQL Server Text files (CSV, Xls, and XML).
• T-SQL programming for writing stored procedures, user-defined functions, Triggers, Cursors, Views, set up and management of linked servers to non-SQL server Databases.
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed CUBES with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Created several dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Involved in design and development of ETL Jobs using SQL Server Integration Services (SSIS) for data migration between different maintenance systems (VMS, VTrak, and D7i).
• Worked on scheduling data loading and transformations using SQL Server Integration Services (SSIS) between different maintenance systems.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Experienced in developing Drill down reports, Drill through reports using SQL Server Reporting Services, Crystal Reports, and Excel spreadsheet
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Generated different reports using MS SQL Reporting Services and Crystal Reports
• Migrated report system from a custom Crystal Reports system to SQL server 2005 Report Services.
• Designed, Build the Dimensions, CUBES with star schema using SQL Server Analysis Services (SSAS).
• Experience in working on CUBES structure optimization for MDX query performance in Analysis Services 2005(SSAS).
• Published dashboards on an intranet site using SharePoint Server
• Generated reports using SSRS Reports for front end and OLAP data.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional CUBES data through MDX Scripting in SSAS.
• Performed partitioning of CUBES as well as CUBES optimization in order to increase the performance of CUBES.
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP CUBES.
• Scheduling the SSIS packages and Jobs
• Developed perspectives to simplify the process of browsing the CUBES.
• Used Lookups Transformation to get the data from data sets
• Created SSIS Packages to migrate slowly changing dimensions

Environment: SQL Server 2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, ETL SSIS, MDX, Windows Server 2008, Oracle 9i, OLAP, Ms excel 2003, SharePoint, Microsoft Visual Studio 2008.

Confidential, Chicago

BI Developer

Responsibilities:

• Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).
• Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).
• Analyzed the requirements and selected the appropriate fact tables/created fact tables
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
• Created the storage type (ROLAP), Created CUBES for Business Intelligence.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Utilized Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Fact and Dimension tables, and OLAP CUBES while adhering to enforced development methodologies.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Experience in designing and managing SSAS projects.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Experience in building and maintaining Data marts. Created roles for using the CUBES
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Responsible for migrating DTS packages to SSIS.
• Created SSIS packages to download data from FTP sites and populating into different databases and tables.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
• Developed data model based on the BA’s and the reporting Team using SSAS, SSRS
• Transferring data between XML document and SQL server
• Performed activities such as database creation, database tuning, performance planning, backup planning and database administration
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), MDX, OLAP, Enterprise manager, Crystal Reports, Erwin, XML, VB.NET, MS PowerPoint, MS Project, MS Access 2000 & Windows Server 2000, Oracle.

Confidential, NJ

SQL BI Developer

Responsibilities:

• Installed and Configured SQL Server 2005.
• Logical and Physical design of SQL Server databases
• Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor.
• Performance Monitor to track the size of your SQL Server database transaction logs and set up alerts to notify the server before the transaction log fills, thus averting problems that might otherwise seriously affect users and applications.
• Created Stored Procedures, Triggers, Functions, client specific Views for the Application. Extensive testing on the Performance of the Stored Procedures.
• Optimized SQL queries for efficiency and provided queries and procedures for the front-end application.
• Imported and exported data to and from various heterogeneous sources using various techniques like BCP, DTS.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases.
• Administered database users/profiles and security (Managing Security).
• Wrote scripts to monitor backup and restore activities.
• Developed parameterized reports through Reporting Services (SSRS) from a variety of data sources including Analysis Services CUBES and prepare for Web publishing.
• Created ad-hoc queries and reports as requested and provide on-going analytical support for these requests.
• Converted existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products.
• Generated reports with dynamic grouping and dynamic sorting as well as running values.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions etc. for better performance during package execution.
• Scheduled SSIS Packages for loading Facts and Dimensions.

Environment: T-SQL, SQL Server 2008/2005, OLAP Services, Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.net 2003, Erwin Data Modeler, Informatica.

Confidential

SQL DEVELOPER

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spread sheet using DTS.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to backup the database.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Worked with development teams in the design of physical databases and in modification.
• Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: SQL Server 2005, Windows Enterprise Server 2003, Service 2.0, IIS 6.0, Erwin, Crystal Report 10, Crystal Enterprise 10, Microsoft Visio 2000, Unix.

Confidential

SQL DEVELOPER

Responsibilities:

• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Developed several database objects such as tables, triggers and views and also stored procedures.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Created and scheduled jobs and alerts.
• Studied the existing environments and accumulated the requirements by interaction with various aspects.
• Successfully loaded data from an EXCEL, Access, Flat files into a SQL Server database.
• Developed & executed several optimized queries.
• Written several stored procedures to achieve various functionalities of the system.
• Created packages using DTS for moving data from MS Access to SQL Server.
• Assisted the Application team in data modeling and T- SQL coding.

Environment: SQL Server 8.0, Windows NT, T- SQL, EXCEL, Access.