Summary:

• 7 years of Strong experience in developing T SQL DDL DML and implementing Stored Procedures, Constraints, Triggers, Nested Queries, Common Table Expressions CTE Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Models, Creating Updating tables and checking the database consistency by executing DBCC Commands in SQL 2005/2008 /2012.
• Extensively worked on MS BI -Integration services SSIS , Microsoft SQL Server Analysis services SSAS , Microsoft SQL Server Reporting Services SSRS and MDX for data warehouse and data mart solutions in various domains.
• Knowledge in BI applications and tools involving Design, Development and Implementation using MS SQL Server Technologies.
• Performed various SSIS data transformation tasks like Lookup, Conditional Splits and Event Handlers, Error Handlers etc.
• Proficient in creating and deploying SSIS packages from heterogeneous sources like Excel, CSV, Oracle, flat file, text format data by using multiple transformations in SSIS such as data conversion, bulk insert, merge, aggregate, derived column and union all while using Bulk Copy Program BCP , Data Transformation Services DTS 2000 and SQL Server Integration Services SSIS .
• Familiar with OLAP cubes, star and snowflake schemas. High Knowledge in generating cubes and dimensions, defining many to many, referenced relationships in SSAS, defining granularity within a measure group and drill through actions, generated KPI's and calculations.
• Experience in designing, developing, deploying and processing dimensional cubes in SQL Server Analysis Services SSAS 2008/2008R2 and querying the data using MDX script and user defined functions for the Calculations and Optimization.
• Developed custom reports and deployed them on server using SQL Server Reporting Services SSRS . Experience in writing SQL/MDX scripts for the report generation using SSRS.
• Expert in resolving SSRS reports problems while exporting to MS Word, Excel and PDF.
• Extensively used SQL Reporting Services to generate and deploy reports: drill down parameterized and drill through reports.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Designed jobs, alerts, SQL mail agent, and scheduled DTS and SSIS packages, Knowledge in constraints, containers, variables, parameters in SSIS.
• Strong analytical, problem solving and excellent communication along with interpersonal skills. Able to work independently as well as in team.

Technical Skills:

Professional Experience:

Confidential

Role : SQL Server/BI Developer SSIS, SSRS, SSAS

Responsibilities:

• Created various Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Data Manipulation languages DML/DDL implementing constraints and triggers for data integrity in development database for Warehouse system.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Performance tuning of Queries and Stored Procedures.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Designed ETL structures for data imports from various sources such as Oracle, Excel, Access and DB2.
• Creating Tabular, Matrix, Drill through reports also called as crosstab or pivot , Charts and graphs as per customer requirements Using SSRS.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Implemented query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2/2012 Reports Services SSRS .
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard and also using SSIS.
• Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created several database constructs such as views, triggers and extensively worked on performance tuning.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Used ETL Transformations to meet the business requirements while created SSIS Packages.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.

Environment: Windows 2003 Server, MS SQL Server 2005/2008 R2/2012, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Service Broker.

Confidential

Role: SQL Developer

Responsibilities:

• Created and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Written different T-SQL scripts for automated execution of the tasks.
• 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.
• Extensively used SSIS to move data from heterogeneous data sources to SQL Server.
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Created SQL Server Profiler traces used with Database Tuning Advisor DTA for optimum performance of queries.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services SSIS
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered Non-clustered Indexes.
• Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files
• Scheduled and executed different automated and manual jobs once the package is executed.
• Managed the Clustered environment databases and was fixing the errors when they arose.
• Rebuilding the indexes at regular intervals for better performance.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Written complex stored procedures and functions and integrated it with the front end application.
• Created multi-dimensional cubes with different dimensions and measures in it using SSAS.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
• Prepaid user manual and technical support manual.

Environment: MS SQL-Server 2008 R2,2005, SQL Diagrams, Erwin, SSRS, SSAS, SSIS, Windows 2003 Server, MS Access, T-SQL, Outlook, DTS.

Confidential

Role : BI Developer

Responsibilities:

• Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Converted ETL from DTS to SSIS.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Worked with development teams in the design of physical databases and in modification.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Configuration files and deployment wizard.
• Created SSIS process design architecting the flow of data from various sources to target.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Actively engaged in client meetings in requirement gathering and development updates.
• Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Good understanding of Microsoft Reporting Service SSRS with Report authoring, Report management, Report delivery and Report security.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: MS SQL Server 2005/2008, Windows 2003/2008, SSIS, SQL Server, Management Studio, SQL Server Business Intelligence studio, Microsoft Excel and Access.

Confidential

Role: SQL BI Developer

Responsibilities :

• Create joins and sub-queries for complex queries involving multiple tables.
• Designed process for Push reporting using Data driven subscriptions.
• Created new schemas in data warehouse and OLTP databases to load data form production.
• Designing the SSRS reports using Table, Matrix and Sub reports with expressions.
• Designed flexible and rich report layouts using SSRS.
• Created Parameterized reports, Cross-Tab reports, Drill down, Drill-through reports using SSRS.
• Generated reports from cubes using MDX queries.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created dimensions and facts for the creation of the cubes using SSAS.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Created report models and deployed on report server.
• Intensively tested reports with Business users and implemented custom error formatting.
• Created windows forms using VB.net to manage configuration of the SSIS packages stored in SQL server Tables.
• Managed files using file system task and script task with C .net.
• Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like DB2 to SQL Server. Moved Data from flat files and Excel sheets using SSIS.
• Involved in partitioning large sized tables, to improve the performance of the queries running against them.
• Identified slow running query and optimized stored procedures and tested applications for performance, data integrity using SQL Profiler.

Environment: SQL Server 2005/2008, SSIS, SSRS, SSAS, DTS Designer, SSIS, SQL Profiler, Index Tuning Wizard, Windows 2003, XML, MS Access, MS Word.

Confidential

Role: SQL Developer

Responsibilities :

• Allow designated users to schedule particular job.
• Automatically generate and distribute Reports.
• User can activate, deactivate and force run the Jobs as per requirements.
• User can Edit / Update / delete any Job even if they are not the initiator
• Actively involved as part of a team for gathering and analyzing the needs of end User Requirements
• Used TSQL to create various stored procedures.
• Created Triggers, Check Constraint and Primary/Foreign Key to enforce data and referential integrity.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Managing of users including creation/alteration, grant of system/database roles and permission on various database objects.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking amp deadlocks /user counts and connections/locks etc.
• Involved in generating summary reports using SSRS.
• Created Ad Hoc reports by building models in Report Builder using SQL 2005 Model Designer and Report Builder. Created YTD, MTD sales reports.

Environment: Operating System Windows 2003, Languages -T-SQL, MS Access, Windows XP, Microsoft SQL Server 2005, SSRS, Microsoft Visual Studio 2003, VSS, MS Access