• About 6 years of experience in IT, as MS SQL Server 2012, 2008/2005Database Developer in Windows environment.
• Extensive experience knowledge in ETL using SQL Server Integration Services2005 /2008 SSIS .
• Experience inBanking,HealthCare domains with expertise in MS SQL Server 2012/2008/2005/2000 suite of products like SSIS, SSRS.
• Experience in Designing and Implementation of Business Intelligence applications using SQL Server 2005 and 2008 Integration Services SSIS , Reporting Services SSRS and Analysis Services SSAS .
• Expert in Creating stored procedures, Views, Indexes and effective User Defined functions and appropriate Triggers to facilitate data manipulation using T-SQL.
• Experience with Data Transformation Services DTS an Extract Transform Load ETL tool of SQL Server to populate data from various data sources by creating packages for different data loading operations for each application.
• Implemented SSIS data updating using tools such as SSIS Slowly Changing Dimension Task controls.
• Expert in developing SSIS Packages to Extract, Transform and Load ETL /DTS data into the Data warehouse from Heterogeneous databases such as Oracle, Netezza, MS SQL, Excel and MS Access.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL 2008/2005
• Experienced in designing and developing large number of enterprise reports SSRS using the data from ETL loads and various heterogeneous data sources.
• Created calculated measures and dimension members using Multi-Dimensional Expressions MDX .
• Expert level skills in Data Modeling,Normalization,Optimization and Performance Tuning.
• Experience in using tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and Tuning MS SQL Server Performance
• Experience in different team projects with extensive project implementation, team skills,troubleshooting, presentation abilities and issue resolution capabilities.
• Involved in Agile Methodologies to produce high quality results.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts. Experienced in working effectively under pressure in order to meet deadlines in a rapidly changing environment.
• Ability to learn new languages and tools quickly and efficiently with the ability to work under high pressure distinguishes me from my peers.
• Technical Skills
• Databases - SQL Server 2012 / 2008/2005, MS Access, Excel.
• Database Utilities - Enterprise Manager, DTS, SSIS,SQL Profiler, SQL Query
• Analyzer, SQL Agents, SQL Jobs, SSAS.
• ReportingTools SQL Reporting Services SSRS , Crystal Reports, Business Object.
• Languages -C/C , SQL, T-SQL, VB.6, C .
• Operating Systems - Win 2003, Win 2000, Win NT, XP, Mainframes.
• Application Packages - MS-Office 2003 / 2007 / 2008
• Web Tools - MS-Front Page, Internet Information Server IIS , MS-Outlook Express.
• Other Tools - Microsoft Visual Studio 2008/2005/2003

Professional experience

SQL BIDeveloper

Description:Bank of America provides a comprehensive line of banking, brokerage, insurance, Investmentbanking, mortgage, and trust and payment service. This project involves loading different client's data, designing and developing various types of reports for the marketing group.

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions
• Created SSIS Packages to import and export from Excel Spreadsheets, Text files and CSV files through FTP.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load ETL packages for data warehousing
• Worked on building several new SSIS packages and updating existing packages and created related scheduled jobs.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS. Back end experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers.
• Responsible for creating the reports basing on the requirements using SSRS .Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Using SQL server reporting services SSRS delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Used Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Created jobs maintenance plans for rebuilding of indexes and updating statistics.
• Troubleshoot SQL Server performance issues for internal and external customers.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.

Environment: SQL Server 2012/2008 R2 Enterprise Edition with Clustering, OLTP OLAP environment .Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, and Teradata

Confidential

SQL BI Developer

Description: Confidential is one of the nation's leading health insurance companies. The project was called Enterprise Reporting where the team strived to produce an effective reporting system in place for providing day-to-day reporting solutions to their clients.

Responsibilities:

• Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Involved in full Software development life-cycle SDLC followed by Agile methodologies to produce high quality software model.
• Utilized Integration Services SSIS to produce a Data Mart for reporting.
• Strong experience in working with BCP, SSIS DTS, DTSX packages for Data Integration Services.
• Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages.
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008 via SQL Server Integrated Services
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Developed custom reports and deployed them on server using SQL Server Reporting Services SSRS .Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services SSRS .
• Implemented the complex query techniques of Passing Multi-Valued Parameters and cascading parameters in MDX.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes SSAS .
• Extracted data from various sources like SQL Server 2012/2008, .CSV, DB2, Excel and Text file from Client servers and through FTP.
• Worked with Report Builder 2.0, Report Models and Ad Hoc Reports.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: SQL Server 2012/2008R2/2005 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS, SSAS, ProClarity, OLAP, XML, SharePoint, Agile, Microsoft Visual Studio 2008 w/.NET Framework 3.5, Windows XP.

Confidential

SQL Developer

Project scope: Developed various projects, processes and reports per day to day requirements. Automate the old processes from sources like Mainframes, Access, and BO and converted in SQL platform.

Responsibilities:

• Gathered requirements from Business and documented them based on functional specifications.
• Created SSIS packages to extract data from OLTP to Data warehouse and scheduled jobs to call the packages.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuration of SSIS packages.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Created Stored procedure, Views and user defined function. Extensively used Joins also Cross join on the tables for extracting desired data.
• Extensively worked on creating SSIS packages and have used Foreach Loop containers, Sequence Container for developing processes and loadeddata using different transformations such asDerived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Wrote and modified numerous stored procedures and Functions and created and modified existing SSRS reports and uploaded them on Repositories.
• Created complex Drill Down reports, Custom Code functions,Chart Reports, Parameterized and Matrix SSRS reports.
• Involved in analyzing, designing, building , testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Worked on various ADHOC reports request and generated results on Excel and CSV file Reports.
• Provided support by troubleshooting and solving the issues.
• Actively participated in review team meetings with Manager to ensure that the development of projects meet business and system requirements also Received appreciation for dedication to service and overall excellent management of assigned duties.

Environment: MS SQL Server 2005,2008,SSMS 2005,2008, Visual Source Safe, EXCEL, Access, Mainframes,Windows 2003 Server, Windows XP Professional, Visual Studio 2005,2008.

Confidential

Role:SQL Developer

Project scope: Developed and monitored various projects and processes on day to day requests.

Responsibilities:

• Implemented multiple grouping into several reports using visibility and toggle options.
• Created Stored procedure, Views ,Cursors and functions to support application
• Designed and implemented complex SSIS package to migrate data from multiple data sources.
• Gathered requirements from Business and documented them based on functional specifications.
• Created SSIS package to extract, validate and load data into Data warehouse.
• Extensively worked on creating SSIS packages and have used Foreach Loop containers, Sequence Container for developing processes and loadeddata using different transformations such asDerived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Extensively created SSRS reports Executive Summary report for Annual and Quarterly and Configured Report Server on all the environments. Also automate deployment for SSRS reports for all the environments.
• Actively supported Business users for change requests and provide support to team members.
• Provided support by troubleshooting and solving the issues.

Environment: MS SQL Server 2008 R2,SSMS 2008, Neteeza,DB2, EXCEL, Windows 2003 Server, Windows XP Professional, Visual Studio 2008, 2010, MS Visio 2010, Star Team.

Confidential

SQL Developer

This project was about migration of data from the old legacy system, which was MS Access to the new system SQL server 2005. The first part of my project was to clean up the database, which is called 'data scrubbing'. This state involved making the data compatible for the import into SQL server 2005. The second stage in this migration project was 'data massaging'. This stage is about validation of the data and mapping the old fields into the new fields of the new system and finally generating reports.

Responsibilities:

• Involved in Creation of database, tables and procedures to update and clean the old data.
• Involved in writing scripts to check for duplicate records, delete/modify them depending on the business rule
• Created Indexes and Triggers to maintain data referential integrity using T-SQL.
• Created various parameterized, linked sub reports using MS Reporting Services SSRS .
• Implemented ETL by creating the SSIS packages to migrate and load the data
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Actively supported business users for change requests.
• Identified and defined datasets, added parameters for the report generation and wrote the queries for the drill down reports.
• Uploaded reports on to the report manager and organized them in folders.
• Delivered reports using 'pulled' and 'pushed' methodologies and formatted them using Global variables and expressions.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Monitored performance and fine-tuned the database objects and server to ensure efficient data retrieval.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.

Environment: MS SQL Server 2005 SSIS, SQL Profiler , T-SQL,MS SQL Reporting Services 2005 SSRS , MS Access 2003, MS Excel, Window 2003.