Professional Summary:

• Overall 8 years of experience in SQL Server 2012/2008R2/2008/2005/2000, Business Intelligence in SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Analysis Services.
• Skilled professional with experience in all stages of SDLC: planning, analysis, design, implementation and Worked with SDLC methodologies like Waterfall, RUP, Agile Scrum .
• Proficient in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions CTEs and Triggers to facilitate efficient data manipulation and data consistency.
• Created DDL and DML triggers.
• Proficient in Developing SSIS Packages to Extract, Transform and Load ETL data into the Data warehouse from databases such as Oracle, DB2, Sybase and MS Access.
• Experience with ASP. Net, C and VB .Net.
• Expert in Creating, Configuring and tuning MS SQL Server Integration Services SSIS .
• Skilled in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Expert in Creating, Configuring and tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning Advisor.
• In-depth Knowledge in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN 7.1 and Visio
• Experience in creating OLAP cubes using SQL Server analysis services SSAS ..
• Experience in Data Marts, Data warehousing, Operational Data Store ODS , OLAP, and Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
• Expertise in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports, creating on demand and scheduled reports in SSRS 2012/2008r2/2008/2005
• Strong in ETL Extracting, Transforming and Loading , Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Expert in designing reports using SQL Server Reporting Services SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services SSRS based on client requirement.
• An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills with good work ethics

Technical Skills:

SQL Server 2012/2008R2/2008/2005, SQL Server Enterprise Manager, Transact-SQL T-SQL , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , MS SQL Server Integration Services SSIS , Data Transformation Services DTS , SQL Server Management studio SSMS , Business Intelligence Development Studio BIDS MS Access, MS Visual Studio, Microsoft Office, MS Visio 2003/2007/2010, ASP.NET, C , VB.Net, HTML, XML, Perl, VBScript, Java Script, XSL, Oracle 11g/10g, Crystal Reports 8.5/9/10/11, Erwin Data Modeler 7.3/4.1/4.0, Experience with ASP. Net, C and VB .Net

Professional Expereince:

Confidential

Role: SQL Server/SSIS/SSRS Developer

The goal of project was to load data from OLTP server to Data Warehouse server.

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
• Developed SSIS Packages using Lookup Values implementing rules provided by Business in the mapping document.
• Developed SSIS packages using Fuzzy Lookup and Fuzzy Grouping for data cleansing purpose.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2012
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools Technologies:

Microsoft SQL Server 2012, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , Query Analyzer, Microsoft SharePoint, Erwin

Confidential

Role: MS SQL Server Developer/SSIS/SSRS

Gathered user requirements to develop the business logic and created SSRS reports and contributed in migration of existing data.

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Wrote standard complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Accountable for Backup and Recovery Strategy and Planning.
• Created ETL packages with different data sources SQL Server, Flat files, Excel source files, Oracle and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension SCD , Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008R2.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008R2.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager
• Deployed the generated reports on to the server.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools Technologies:

SQL Server 2008R2, SSIS, SSRS, Report Builder, Java Script, Oracle, T-SQL, ETL, ASP.Net, C .Net, Erwin r 7.3,.Net 4.0/4.5.,TFS 2010.

Confidential

Role: MS SQL Server Developer/SSIS/SSRS

The Project is to extract data from various sources like DB2, Oracle and load into SQL Server 2008 using various transformations in SSIS. Project was to develop and load data warehouse and maintain ace of it.

Responsibilities:

• Designed data architecture, data model and Mapping Process to load data based on business requirement and provided documentation.
• Implemented Table, Views, Function, Stored Procedures and Triggers for load data and validation purpose.
• Worked with Agile Methodology tracking the product backlog and resolved the defects/Solution assigned in daily scrum.
• Created SSIS package to load data from XML Files, Excel, CSV file, Ftp server and SQL Server to SQL Server 2008 by using Derived Columns, Condition Split, Data Conversion, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data Ware House.
• Converted DTS Package to SSIS package for synchronizes existing process DTS migrations .
• Used Team Foundation Server to retain Project code during deployment process.
• Part of Code review during Production deployment and QA deployment.
• Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House.
• Designed Console application to generate Single .CSV and text file from Different relational Database table using SSIS and C .
• Created Process for Error Details in Application system, Control-M Job, SQL agent Job to easily identify Issue for Support and Solution.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Tools Technologies:

MS SQL Server 2008, SSIS Package, SQL BI Suite SSMS,SSIS, SSRS,SSAS , XML, MS Excel, MS Access 2007 Windows Server 2008, SQL Profiler, Erwin r 7.3,.Net 4.0/4.5.,TFS 2010.

Confidential

Role: MS SQL Server/SSIS/SSRS Developer

This project is involved in building a data warehouse to analyze transactions across all the departments. Data is sourced from oracle, flat files and Access database.

Responsibilities:

• Defined and Designed data based on business requirement and provided documentation.
• Worked with Agile Methodology tracking the product backlog and resolved the defects assigned in daily scrum.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Developed Validation Plans for SSIS packages for checking the functionality of each component and Code review.
• Planned and executed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House.
• Modified the existing SSIS packages, Script Component Task to meet the changes specified by the users and adding column to the newly design table and to the existing table.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Job overlap alert
• Worked in setup auditing, logging environment to track the status of the events like error raise, task fail.
• Designed tool to Automatic added Derived column, Parameter and Configuration value to the package.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008
• Created reports to retrieve data using function, views, cube and Stored Procedures using parameters.
• Created various database objects like stored procedures, functions, tables, views, triggers.
• Configured the report viewing security for various users at various levels using Report Manager
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds SSIS packages.
• Designed and implemented Stored Procedures and Triggers DDL DML for automating tasks.

Tools Technologies:

MS SQL Server 2008, SQL BI Suite SSMS,SSIS, SSRS , XML, MS Excel, MS Access 2007 Windows Server 2008 Access 2003 Windows Server 2003, SQL Profiler, Data Analyzer, Erwin r 7.3,.Net 4.0/4.5,TFS 2005/2008/2010

Confidential

Role: MS SQL Server Developer

The project is about to create logical model as per business requirement and creating solution regarding it and create different types of reports and creating cubes.

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Defined Technical Design Specifications, ETL workflows and Source to Target Mapping STTM spreadsheets for each Vendor system interfacing with the High Point system.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in SQL Server 2005.
• Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor and Execution Plan.
• Generated SQL Server Database objects including Tables, Views and Indexes.
• Created and modified stored procedures, triggers and queries for automating various interface tasks using T-SQL.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2005.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Supports the development, implementation and daily administration of SQL Server databases, performs database design, modeling and implementation of new database structures, as required.

Tools Technologies:

SQL Server 2005, SSIS, SSMS.