Summary

• Over 8 years of experience in data warehouse development SQL, Stored Procedures, Indexes, ETL Development with experience in MS BI tools such as SSMS / SSIS / SSAS / SSRS.
• Excellent understanding of relational and multi-dimensional data design and development techniques including star schema, snowflake schema, cube design and creation, MDX and others.
• Extensive experience in writing MDX Scripting and MDX Queries using Multi-Dimensional Expressions MDX , mathematical formulas, and user-defined functions UDFs .
• Experienced in working with Star/Snowflake Schema modeling to develop ROLAP/MOLAP/HOLAP Cubes using SQL Server Analysis Services.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact- SQL queries, stored procedures, and triggers using SQL Servers.
• Expert in creating indexes, user defined functions, and common table expressions CTEs to facilitate efficient data manipulation and data consistency.
• Excellent knowledge in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Expert in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Experienced in ETL Processes. Worked extensively on data extraction, cleansing/data integration, and loading from different data source using SSIS.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Experienced in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experience in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning adviser, and Dynamic management views.
• Efficient in generating Tabular, parameterized reports, drill down, drill through, cascading parameterized, and matrix reports using SSRS 2012/2008R2/2005.
• Experienced in using global variables, expressions and functions for the reports.
• Proficient in Installation, Configuration and migrating and upgrading of data from MS SQL Server 2008 to 2008 R2 and 2008R2 to 2012.
• Experience of Developing web application on Java/J2EE, JSP, Servlet, HTML, CSS, JavaScript
• Experience and knowledge of various Java/J2EE development and deployment environments
• Experienced in Cube designing in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

Skillset: MS SQL Server 2012/2008/2005/2000, Oracle 9i/10g/11g, MS Access, Business Intelligence Development Studio BIDS , Qlikview, SQL Profiler, Enterprise Manager, Query Analyzer, MS SQL Server Integration Services, DTS, BCP Bulk Copy Program , MS SQL Server Reporting Services , Crystal Reports, Performance Point Server 2007, SharePoint, MS SQL Server Analysis Services, T-SQL, PL/SQL, C, C , .NET, JAVA,VB Script, VBA, Erwin, MS Visio, Windows NT/2000/XP/7/8 , soft Office, HTML, XML.

Projects Summary

Confidential

MS SQL Server/BI Developer

Responsibilities

• Involved in testing, bug fixing and documentation for the project.
• Worked with a DBA in creating complex Stored Procedures.
• Wrote complex T-SQL queries and used stored procedures, wrote new stored procedures and triggers and modified existing ones.
• Interacted with the officers for understanding the system requirement.
• Designed and tested packages to extract, transform and load data using SSIS
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of data.
• Writing connecting codes to connect VB.Net, Java and C to SQL.
• Used various SSIS tasks such as Conditional Split, Merge Join, and Derived Column on the data retrieved, Data conversion, OLE DB Command, performed Data Validation Checks during Staging, and then loaded the data into destinations.
• Generated parameters, sub report, drilldown, drilldown through, dynamic matrix, different charts, dashboard, KPI, tabular and pivot table using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2012, IIS, report builder, report services configuration manager.
• Setting catches and snapshots on the server, ensuring security like distribute and change different security roles for users, scheduling the reports delivery to clients email or shared files.

Confidential

SQL Data Modeler/ SQL Database Designer

Responsibilities

• Worked in Database programming, server side programming and Client Server computing in multi-threaded software systems using Java technologies.
• Performed analysis of existing Java and PL/SQL logic to facilitate new development.
• Designed Data warehouse schema like star schema and snowflake by using ERWIN
• Designed and tested packages to extract, transform and load data using SSIS
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of data.
• Used ETL to implement the slowly changing dimension to maintain historical data in data warehouse.
• Used various SSIS tasks such as Conditional Split, Merge Join, and Derived Column on the data retrieved, Data conversion, OLE DB Command, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Worked as a developer in creating complex Stored Procedures.
• Wrote complex T-SQL queries and used stored procedures, wrote new stored procedures and triggers and modified existing ones.
• Worked with system administrators to keep the database and reporting service environments are up to date and well maintained
• Generated parameters, sub report, drilldown, drilldown through, dynamic matrix, different charts, dashboard, KPI, tabular and pivot table using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2012, IIS, report builder, report services configuration manager and SharePoint designer.
• Setting catches and snapshots on the server, ensuring security like distribute and change different security roles for users, scheduling the reports delivery to clients email or shared files.
• Worked closely with the developers and testing team to resolve Bug Issues.

Environment: SQLServer2012, SQL Server BI Development Studio BIDS 2012, SSIS, SSRS, Crystal Report, ASP.Net, ADO.Net, Java, JavaScript, Oracle 9i/10g/11g, Clear Case, Clear quest, Visual SourceSafe, T-SQL, MS Access, Windows 7, Linux.

Confidential

SQL Data Modeler/ SQL Database Designer

Responsibilities:

• Involved in testing, bug fixing and documentation for the project.
• Interacted with the officers for understanding the system requirement.
• Designed data models, created ERD and database tables in SQL 2012.
• Created packages for bulk data migration using SSIS from MS Excel, flat files and XML, provided logging and error handling. Developed ETL Packages using SSIS to extract data from staging tables.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Conditional Split, Derived column in SSIS.
• Created various reports SSRS from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included various reporting.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Included Report Design and Coding for Standard Tabular type reports, including Drill Down, Drill through, Parameterized reports and Graphical presentations such as Charts and Dashboard type metrics.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services SSAS .
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard for managerial purposes.

Environment: MS SQL Server 2012/2008R2, SSIS, SSRS, SQL Profiler, Windows XP, Lotus Notes, Microsoft Word 2010, Visual Source Safe, .Net

Confidential

SQL Data Modeler/ SQL Database Designer

Responsibilities:

• Helped in translating business requirements into technical design specifications and preparing high-level documentation for the Database Design and Database Objects.
• Designing Snowflake and Star Schema Designs for the operational data.
• Involved in Designing cubes, calculations, KPI's and deployed cubes in SSAS environment
• Configured and Maintained Report Manager and Report Server for SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters depending upon the client requirements.
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports.

Environment: MS SQL Server 2005/2008,Business Intelligence Studio, SQL Server Reporting Services, SSIS, TSQL, PL/SQL, SQL Profiler, Windows XP/NT/2000/2003,SQLQuery analyzer, SQL Profiler.

Confidential

SQL Data Modeler/ SQL Database Designer

Responsibilities:

• Designed and developed SSIS ETL packages to validate, extract, transform and load data from OLTP system, DSR Staging Database to AMS.
• Created functional specification and technical specification from BRD.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Involved in integration of the front end with the SQL Server back end.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Involved in unit testing of Store Procedure and UI as per requirement on different server Dev, DIT, and SIT .
• Developed Test Cases bases on Requirement Specifications and Design Documents.
• Created reports to retrieve data using Stored Procedures that accept parameters.

Environment: MS SQL Server 2005/2008 Enterprise Edition, MS SSRS 2008, MS SSIS 2008, Visual Studio 2008/2010, T-SQL, VB Script, MS Access, Query Analyzer, BCP, SQL Profiler, ASP.NET v4.0, Crystal Reports 9.0, IIS, Source Control System TFS,VSTF , Windows 7, XML.

Confidential

SQL Data Modeler/ SQL Database Designer

Responsibilities:

• Upgraded MS SQL Server 2000 databases to 2005 using detach/attach, backup and recovery and by replication.
• Incorporated the DTS packages into SSIS 2005 by using package migration wizard and executed DTS 2000 Package task.
• Created Views to reduce database complexities for the end users.
• Designed and implemented stored procedures and triggers for automating tasks.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.

Environment: MS SQL Server 2005, T-SQL, SSIS 2005, SSRS 2005, MS SQL Profiler, SQL Query Analyzer, Index Tuning Wizard, MS Access, Crystal Reports 10/9, Visual Studio 2005.