SUMMARY

• Over 8 years of experience in database development, and support of Microsoft SQL Server for Production/Development environments.
• Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) in diverse industries.
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, Execute SQL Task, Script Task and Data Conversion Transformations
• Experience in creating SSIS packages, Migrating DTS packages to SSIS and Storage Management.
• Automated manual process with SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Experience in Error and Event Handling, Break Points, Check Points & Logging.
• Designing and implementing data warehouse ETL using SSIS and building SSAS cubes with complex data (dimensions, measures, data source views)
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi - dimensional modeling.
• Knowledge in developing cubes using Partitions, KPI's, and Perspectives, slow moving dimensions etc. and created various user roles.
• Experience in designing report layouts and developing Custom Reports and different types of Tabular/Matrix/Ad-hoc/Sub/Drill down/Drill through Reports and Charts in multiple formats using SQL Server Reporting Services
• Designed complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table which make use of multiple value selection in parameters pick list, cascading prompts of reporting service.
• Strong communication and team skills with proven ability to work on projects with minimum guidance and specifications.

TECHNICAL SKILLS

Database Tools: MS SQL Server (2014, 2012, 2008R2, 2008 & 2005), SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) & MS Access

Programming Languages: T-SQL, PL/SQL & VBScript

ETL Tools: DTS, SSIS (SQL Server Integration Services), Reporting Packages, SQL Server Reporting Services, MS Excel.

Databases: Microsoft SQL Server & Oracle 8i 9i.

Processes: Agile and Waterfall

Microsoft Suite: MS Word, MS Excel (Lookup, Macros & Pivot), MS PowerPoint & MS Visio

PROFESSIONAL EXPERIENCE

Confidential

SQL BI Developer

Responsibilities:

• Designed complex SSIS ETL packages to load the data from different sources like OLEDB, EXCEL & Flat Files into various Servers and Databases
• Worked on Control Flow items like Execute SQL Task, Script Task, Containers, Send Mail Task, FTP tasks, Bulk Insert Task and Execute Process Task.
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Conditional Split, Aggregate, Derived Column, Multicast, Sort, Merge Join, Union All, Lookup and Data Conversion Transformations.
• Scheduled Jobs for executing the stored SSIS packages which are developed to update the Database.
• Experience in Error Handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of stored procedures
• Created Database objects - Tables, Views, and Functions and developed procedures for implementing application functionality at the database side for performance improvement.
• Experience in designing report layouts and developing custom reports and different types of Parameterized/Tabular/Matrix/Ad-hoc/Sub/Clickthrough/Drilldown/Drillthrough Reports using SSRS
• Designed complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table which make use of multiple value selection in parameters pick list, cascading prompts of reporting service.
• Knowledge in developing cubes using Partitions, KPI's, and Perspectives, slow moving dimensions etc and created various user roles.
• Analyzed and created Tabular Cubes in Facts and Dimension Tables using SSAS.
• Worked closely with business users daily in defining new requirements. Acquired appropriated approvals, documented these requirements, and communicated to all the parties involved.

Environment: MS Visual Studio 2012, MS SQL Server 2012, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analytical Services (SSAS) and MS Office suites, T-SQL, Team Foundation Server (TFS), SQL Profiler.

Confidential, Irving, TX

SQL BI Developer

Responsibilities:

• Worked on Control Flow items like Bulk Insert Task, Execute SQL Task, Script Task, Containers, Send Mail Task, FTP tasks and Execute Process Task.
• Worked with SSIS packages involving Fuzzy Lookup, Fuzzy Grouping, Aggregate, Conditional Split, Derived Column, Merge, Merge join, Sort, Pivot and Unpivot Data Flow Transformations.
• Extracted Data from various Databases such as Oracle and Access database to SQL server using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various users
• Designed Data Stage ETL jobs for extracting data from different source systems, transform and finally load into the Data Marts.
• Created Cluster/Non-Cluster Indexes, Views, Stored Procedures &Triggers.
• Optimized stored procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used Text Files, SQL Server & SQL Server Profiler Logging for SSIS packages.
• Configuration and Deployment of all reports across various SDLC environments.
• Experience in designing report layouts and developing custom reports and different types of Tabular/Matrix/Ad-hoc/Sub/drill down/drill through Reports using SSRS
• Designed complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table which make use of multiple value selection in parameters pick list, cascading prompts of reporting service.
• Deployed and configured the reports in the Report Server.

Environment: MS SQL Server, SQL Services Integration Services, SQL Reporting Services and MS Office suites.

Confidential, Thousand Oaks, CA

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Designed Complex SSIS ETL packages to load the data from different sources like OLEDB, EXCEL & Flat Files into various Servers and Databases
• Created packages in SSIS with Error handling
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the Database on Daily basis
• Worked on Script Task, Bulk Insert Task, Send Mail Task, FTP Tasks, Execute SQL Task and Execute Process Task.
• Worked with packages involving Aggregate, Conditional Split, Derived Column, Merge, Merge join & Sort Transformations.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of stored procedures
• Performance tuning of the stored procedures, user defined functions and long running queries
• Developed different types of Tabular reports, Matrix reports, Chart and Graphs, reports that aggregate data using SQL Server Reporting Services
• Embedded the reports on to application using MS Report Viewer in Visual Studio
• Responsible for keeping system and databases up to date by making necessary changes
• Developed cubes using Partitions, KPI's, and Perspectives, slow moving dimensions etc and created various user roles.
• Performance tuning, deploying and processing SSAS cubes
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Troubleshoot & research data issues that arise during cube development and validation.
• Maintaining proper security procedures.

Environment: SQL Server 2012, SQL Services Integration Services 2012, SQL Services Analysis Services 2012, T-SQL, XML, MS SQL Reporting Services 2012, Oracle 9i, TOAD, Team Foundation Server (TFS), SQL Profiler & MS Office.

Confidential

SQL Server Developer

Responsibilities:

• Installed and Maintained MS SQL Server
• Involved in creating clustered and non-clustered Indexes to improve the database transactions performance.
• Developed stored procedures, views and User Defined Functions using T-SQL statements.
• Actively participated in gathering of user requirement and system specification.
• Responsible for Design and Normalization of the database tables.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Experienced in performance tuning using SQL profiler and monitored SQL server error logs and application logs.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Rebuilding the indexes at regular intervals for better performance.
• Written various stored procedures for the purpose of application development.
• Used joins and sub-queries to simplify complex queries involving multiple tables.
• Worked on Crystal reports with many complex stored procedures.
• Created multi-format reports using Crystal report.
• Created and automated regular jobs Daily/weekly Report Generations.
• Monitored Performance and optimized SQL queries for maximum efficiency.

Environment: Windows 2005 Server, SQL Server 2005, SQL profiler, Enterprise Manager & Crystal report