SUMMARY

• Over Eight years of IT experience which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server 2008/2005/2000 ) in production environments.
• Involved with Microsoft SQL Server architecture and design since the initial versions using Microsoft tools to implement relational and dimensional database solutions.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
• Expertise with continuous integration and nightly deployments using TFS with a Test Driven Design approach
• Extensive experience developing and implementing Microsoft SQL Server integration services (SSIS), Microsoft SQL Server Reporting Services (SSRS), SSAS (analysis services) and MDX for data warehouse and data mart solutions.
• Experience in migration of DTS packages in to SSIS packages.
• Extensive experience in writing and debugging complex stored procedures, cursors, triggers, Inner Joins & Outer Joins, views and user - defined functions.
• Possesses extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report authoring, report management, report delivery and report security.
• Installed, configured and maintained SSRS server.
• Experience in creating new reports and ad-hoc reporting in SQL Server Reporting Services (SSRS).
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Excellent understanding of data mining algorithms, high performance and optimal algorithms.
• Experience with .NET framework using ASP.NET, C#, XML and ADO.NET database connectivity.
• Experience in designing the logical data model and physical data model.
• Experience in supporting large databases up to a size of two terabytes.
• Experience with design and implementation of Star Schema and Snowflake Schema Dimensional model.
• Delivered 24/7 support including scheduled and emergency night and weekend work.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C#, C, C++, Java, UNIX shell scripts, XML, HTML, MDX

Databases: MS SQL Server 2008R 2/ 2008/2005/2000 , Oracle 8i/9i and 10g, DB2, MS Access, Nettezza.

ETL Tools: DTS, SSIS, Informatica, Power Center 6.2/7.1.x/ 8.1.1/8.6.1 , DataStage 6.0

Reporting Tools: MS Reporting Services, Crystal Reports XI, Business Objects XI r2/6.x

Database Tools: TOAD, PL/SQL Developer, SQL-Navigator, SQL*Plus, Test Director, Win Runner

Data Modeling Tools: Physical and Logical Data Modeling using ERWIN

Operating Systems: Windows NT, Windows 2000, XP, UNIX

.NET Framework: MS VISUAL STUDIO 2005, C#.NET,IIS 7, ADO.NET,ASP, VB.Net

PROFESSIONAL EXPERIENCE

Confidential, Carmel, IN

SQL BI Developer

RESPONSIBILITIES:

• Actively participated in interaction with users, Team lead and technical managers to fully understand the requirements of the system.
• Developed a data model and implemented the same using source safe.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints.
• Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Designed SSIS (ETL) Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2008.
• Created the packages in SSIS (ETL) with the help of Control Flow Containers, Tasks and Data flow Transformations.
• Developed Slowly Changing Dimensions (SCD) in SSIS (ETL) to perform the Incremental and Historical loads of data in the data warehouse.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes
• Worked with Inbuilt Transformations in SSIS (ETL) like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
• Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database which provides efficient and granular level of control.
• Performed Data profiling tasks In SSIS (ETL) using the Data Profile Viewer and then clean and standardize the data as appropriate for the Databases.
• Conducted the Error handling in SSIS (ETL) using the Event Handlers.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.
• Analyzed and created Facts and Dimension Tables using SSAS.
• Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
• Developed Multi dimensional Objects Cubes, Dimensions using SSAS.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

ENVINORMENT: MS SQL Server 2008R2, SSIS, SSAS, SSRS, T-SQL, OLAP Services, Share point 2010, MS Access, Oracle10g, ASP.NET, XML, Microsoft Source safe.

Confidential, IN

SQL Server BI Developer

RESPONSIBILITIES:

• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS
• Logical and Physical design of database for projects on basis of user requirements using ERWIN.
• Created new tables, wrote stored procedures for application developers and some user defined functions. Created SQL scripts for tuning and scheduling using T-SQL.
• Defined Check constraints, Indexes, Views, Created Triggers to enforce data and referential integrity.
• Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL) Packages.
• Worked on SSIS (ETL) Packages, Import/Export for transferring data from Heterogeneous Databases to SQL Server.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse.
• Enabled Logging, Database mirroring, Replication for the SSIS (ETL) packages.
• Configured Server for sending automatic mails to respective people on SSIS (ETL) process failure or success.
• Generated various reports based on business requirements using SSRS that could be used to send information to diverse group of users, clients and managers.
• Created various Weekly and Monthly reports showing detailed information in SSRS.
• Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using Report definition Language (RDL).
• Defined Star Schema, OLAP Cubes and Dimensions with SSAS.
• Created the Data source views to analyze the metadata based on multiple data sources during development without an open connection to any underlying data source using SSAS.
• Analyzed the Cubes by performing calculations, perspectives, actions and Key Performance Indicators (KPI’s) in SSAS.
• Modified the measures, dimensions, attributes, hierarchies, measure groups and deployed the changes to the deployed cube in SSAS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Advisor.

Environment: MS SQL Server 2008, SSIS, SSAS, SSRS, T-SQL, OLAP Services, MDX, Share point 2010, MS Access, Netezza, ASP.NET, XML, Microsoft Source safe.

Confidential, Indianapolis, IN

Sr. SQL Server BI Developer

RESPONSIBILITIES:

• Logical and Physical design of database for projects on basis of user requirements using ERWIN.
• Created new tables, wrote stored procedures for application developers and some user defined functions. Created SQL scripts for tuning and scheduling using T-SQL.
• Defined Check constraints, Indexes, Views, Created Triggers to enforce data and referential integrity.
• Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL) Packages.
• Worked on SSIS (ETL) Packages, Import/Export for transferring data from Heterogeneous Databases to SQL Server.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse.
• Enabled Logging, Database mirroring, Replication for the SSIS (ETL) packages.
• Configured Server for sending automatic mails to respective people on SSIS (ETL) process failure or success.
• Generated various reports based on business requirements using SSRS that could be used to send information to diverse group of users, clients and managers.
• Created various Weekly and Monthly reports showing detailed information in SSRS.
• Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using Report definition Language (RDL).
• Defined Star Schema, OLAP Cubes and Dimensions with SSAS.
• Created the Data source views to analyze the metadata based on multiple data sources during development without an open connection to any underlying data source using SSAS.
• Analyzed the Cubes by performing calculations, perspectives, actions and Key Performance Indicators (KPI’s) in SSAS.
• Modified the measures, dimensions, attributes, hierarchies, measure groups and deployed the changes to the deployed cube in SSAS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Advisor.

ENVIRONMENT: SQL Server 2008/2005 SSIS, SSRS, SSAS, Visual Studio 2005, Windows Enterprise Server 2003, ADO.NET, Team Foundation Server(TFS), XML, HTML, Erwin.

Confidential

Database Developer

RESPONSIBILITIES:

• CreatedSSIS Reusable Packagesto extract data fromMulti formatted Flat files,Excel,XML files intoSQL Server tables
• Extract Transform and Load (ETL)source data into respective target tables to build the required datamarts
• CreatedSSIS packagesto load data fromOracleto SQL Server using varioustransformationsin SSIS.
• Worked on the Reports module of the project as a developer on MSSQL Server 2005(using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports fromOLAP,sub reports, bar charts and matrix reports usingSSRS
• Identified thedimension,fact tablesand designed thedata warehouseusingstar schema.
• UsedSQLCMDto write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches.
• DevelopedAggregations,partitionsand calculated members forcubeas per business requirements.
• Defined appropriate measure groups andKPIs&deployed cubes.
• CreatedParameterized reports, Cross-Tab reports,Drill down reports& Summary reports by UsingSSRS.
• Created report snapshots to improve the performance ofSSRS.
• Created T-SQL Functions, Cursors,views, indexes,stored proceduresand triggers.
• Migrateddatabase from SQL server 2000 to SQL server 2005 using utilities i.e.exp/impand attach/detachfor SQL servers 2005 futures.
• CreatedETL metadata reportsusingSSRS, reports include like execution times for theSSIS packages, Failure reports with error description.
• Developed an automated report subscription process usingSSRS.
• Applied conditional formatting inSSRSto highlight key areas in the report data
• Used Report Builder to doAd-hoc Reporting.
• Resolved anydeadlocks issueswith the Databases/Servers on a timely basis.
• Handled Underwriting and pricing of renewal accounts within underwriting authority for
• Created multiplehierarchical aggregatesfor faster performance.
• Worked on solving issues by doingdata recoveryin existing database.
• Used various formatting techniques likeinteractivesorting,groupingto created user friendly reports.
• CreatedER diagramsusing Visio.
• CreatedViewsto enforce security and data customization.
• CreatedNon-Clustered indexesto improve query performance and query optimization.
• Involved in theperformance tuningand optimization ofT-SQLqueries.

Environment: SQL Server 2005/2000, Microsoft office 2003,XML,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005.

Confidential

SQL BI Developer

RESPONSIBILITIES:

• Developed System Standards, System Architecture, Scenarios, detailed Screen Specifications and documented Logical and physical Data Model.
• Worked Extensively with SSIS to import, export and transform the data between the linked servers
• Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.
• Created databases and specified automatic growth options.
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
• Designed and developed a dimensional model for the OLAP Cube by an in depth study of the user requirements and the existing database schema.
• Used the UDM Model to create Named Queries in the Data Source View.
• Designed relationships between the dimensions and measures. Resolved complex many - many relationships and referenced relationships between the dimensions and the measures.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created Ad-Hoc reports using Report Builder.
• Designing and building data load procedures, using MS SQL Server
• Generated database SQL scripts and deployed databases including installation and configuration
• Created Packages using Integration Services.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Provide 24 X 7 supports to all production, development, staging and clustered servers.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.
• Used Microsoft Source Safe for version control and configuration management.
• Supported front-end applications under .Net framework.

Environment: SQL Server 2000/2005, SSIS, SSRS, SSAS, DTS, T-SQL, Active X, .Net, MS Reporting Services, Windows 2003