SUMMARY

• More than 8+ years of experience in Software Analysis, Design, Development, Testing and Implementation of Business Intelligence/Data Warehouse Solutions using Microsoft SQL Server 2012/2008 R2/2008/2005
• Designed ETL packages using proper Loggings and Checkpoints, secured packages with Encryption in conjunction with passwords.
• Experience creating Tableau Dashboards connecting to multiple data sources like Oracle, SQL Server, Teradata and Excel Files Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Responsible for designing test cases for testing the ETL packages.
• Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.
• Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings).
• Performed data cleansing using different transformations within SSIS packages to eliminate redundant data from the pre - staging database.
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Hands on experience with Erwin to forward and reverse engineer data models.
• Actively involved in the enterprise Data Warehouse designing using Kimball design methodologies and following DW Design best Practices. (having 6+ years of exp. on Kimball)
• Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Experienced in all the stages of Software Development Life Cycle and in the migration and up gradation of databases.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization.
• Monitored and tuned the performance of Complex T-SQL queries and stored procedures by analyzing the execution plan and also using tools like SQL Server Profiler.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
• Optimized cubes by assigning appropriate storage modes to partitions, and created usage based optimizations for better query performance.
• Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
• Worked on data import from different file systems including XML, text, and CSV and Excel files.
• Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-view according to the business criteria.

TECHNICAL SKILLS

Data Modeling Tools: Erwin, MS Visio

ETL Tools: SQL 2012/2008 R2 /2008 Integration Services (SSIS)

Databases: MS SQL Server 2012/2008 R2/2008,MySQL

BI & Reporting Tools: Analysis Services / Reporting Services

Operating Systems: Windows 7/Microsoft Vista/XP/NT/2003

Language/Web technology: C#, ASP.Net, HTML, JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

SQL/SSRS /Tableau Developer/Crystal Report Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification
• Developed database objects like tables, views, stored procedures in SQL Server 2008
• Created Partition Tables based upon Partition Functions and Partition Schemas
• Involved in Performance Tuning of the Stored Procedures, User Defined Functions and long running queries.
• Created reports based on the format specified in the design document
• Documentation of all the processes involved in maintaining the database for future reference
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Involved in development and modification of existing Financial Reports and Marketing Reports, which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS
• Created reports using SQL Server reporting services SSRS, which is then exported as PDF. Reports variables are passed from ASP.NET web pages.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS
• Created reports using SQL Server reporting services (SSRS), which is then exported as PDF. Reports variables are passed from ASP.NET web pages.
• Experience creating Tableau Dashboards connecting to multiple data sources like Oracle, SQL Server, Teradata and Excel File.
• Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks
• Involved in Unit Testing, Integration and deployment in Production and Staging Servers.
• Data migration (import & export - BCP) from Text to SQL Server
• Used .Net Framework for creating Reports and also for customization of reports.

Environment: MS SQL Server 2005/2008/2008 R2/2012,Visual Studio 2005/2008, C#, MySQL, Windows 2003/8, Windows XP, T-SQL, ASP.NET, Visual SourceSafe, TFS,JIRA, XML, ER Studio, Tableau, Crystal Reports, SSAS, SSRS, ERWIN, Power Pivot, Power View, Cognos.

Confidential, Franklin Lakes, NJ

SQL/ETL-SSRS /Tableau/Crystal Developer

Responsibilities:

• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created tables, views, stored procedures and indexes in support of various databases and ETL applications.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• 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 SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS
• Implemented event handlers, logging and error redirection in SSIS to debug SSIS packages.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Actively involved in gathering system specification requirements for the project.
• Created complex stored procedures with proper error handling, transactions and performance tuning features.
• Used various integrity constraints for data integrity like Referential integrity using primary key and foreign key relationships.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Created Triggers to enforce data and referential integrity and defined Check constraints, Business Rules, Indexes, and Views.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships, aggregation KPIS’s for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
• Optimized cubes by assigning appropriate storage modes to partitions, and created usage based optimizations for better query performance.
• Created several reports using SSRS like drill through, drill down, linked, parametrized and sub reports and cubes along with its deployment on reporting server with various security measures
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
• Assess the risks and recommend/ install service packs or hot fixes when needed.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.

Environment: Microsoft SQL Server 2012,2008R2, SSIS,SSRS, Tableau, Cognos, SQL Profiler, SharePoint 2010, JIRA,TFS, XML, XSLT, XSD, Microsoft visual Studio 2010,SSAS, Power Pivot, Power View

Confidential, Philadelphia, PA

SQL/ETL Developer

Responsibilities:

• Implemented the Master Child Package Technique to manage big ETL Projects efficiently.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access and excel.
• Tuned and monitored the performance of T-SQL queries and SSIS packages.
• Implemented SSIS Packages to perform ETL Operations from multiple data sources including excel and text files.
• Was responsible for detecting errors in ETL Operation and rectify them.
• Implemented various types of SSIS Transformations in Packages including Aggregate, Fuzzy Lookup, Conditional Split, Row Count, Derived Column etc.
• Actively involved in gathering system specification requirements for the project.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis.
• Worked in conjunction with the data warehouse architect on the development of logical data models.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Extensively used System as well as User-Defined functions to enhance the functionality of my T-SQL code.
• Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the query execution time.
• Created several reports using SSRS like drill through, drill down, linked, parametrized and sub reports and cubes along with its deployment on reporting server with various security measures
• Written basic VB.Net scripts to implement Type 1 and Type 2 Slowly Changing Dimensions for Incremental load.
• Involved in the design of data marts using star schema and Kimball Methodology.
• Generated and partitioned the cubes and selected appropriate storage modes for the cubes that are used as sources for my reports
• Developed SSRS Reports like drill through, drill down, linked, sub reports and parameterized reports.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Formatted the reports by applying parameters, and assigned parameter defaults and data types and extended reports.
• Involved in Database Lifecycle Management Products (redgate) like SQL developer suit and SQL source control

Environment: Microsoft SQL Server 2008, SSIS, SSAS, SSRS, Erwin, T-SQL, TFS.

Confidential, Mclean, Virginia

SQL /ETL Developer

Responsibilities:

• Involved in designing and developing efficient ETL strategy to integrate existing and new data into newly created
• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Data Warehouse.
• Optimized procedures and functions utilized by ETL Packages to reduce ETL Process time.
• Created cover indexes and applied various work around methods to help improve processing time of ETL.
• Extensively created all data base objects like tables, views, stored procedures and indexes with optimization in point of view in support of the databases.
• Captured and documented data business rules and definitions.
• Created several reports using SSRS like drill through, drill down, linked, parametrized and sub reports and cubes along with its deployment on reporting server with various security measures
• Involved in designing and applying constraints and rules for data integrity.
• Created Indexes and Views on various entities of the databases.
• Responsible for monitoring all the packages which ran, were scheduled, completed or failed.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Involved in developing Package Configurations to test packages on different servers.

Environment: MSP, Microsoft SQL Server 2008 R2, SSIS,SSAS,SSRS, SQL Profiler

Confidential, Reinbeck, IA

SQL Developer

Responsibilities:

• Design/develop database using SQL SERVER 2005
• Created High level Normalized Database and Detail Design using Erwin.
• Wrote stored procedures, tables, triggers, indexes and views using Detailed Design Specifications.
• Fine-tuned queries, assigned proper Indexes for better performance.
• Data Migration with MS Access, Excel and Text files and scheduling tasks using DTS
• Used BCP and DTS utility for Meta data transfer across servers.
• Implementation of MS SQL database Replications methodologies.
• Configuration of client workstation with client operating system.
• Prepared trace files using SQL profiler to fine tune the application
• Used visual source safe as configuration management tool.
• Provided training sessions to the SQL developers to maintain the application integrity
• Created several reports using SSRS like drill through, drill down, linked, parametrized and sub reports and cubes along with its deployment on reporting server with various security measures

Environment: SQL Server 2005, SSIS, SSAS, SSRS, Windows XP/2003, Windows NT