• Extensive working experience in the Database Design while implementing Business Intelligence tools such as:
• Seven yrs. of experience in Information Technology as MS SQL Server 2005/2008R2 BI Developer.
• SSIS - SQL Server Integration Services

• SSRS - SQL Server Reporting Services
• SSAS - SQL Server Analysis Services
• Extensive experience and knowledge of ETL Extraction Transformation Loading tool using SSIS SQL Server Integration Services.
• Proficient in creating Views, Complex Stored Procedures, Indexes, and UDF's - User Defined Functions, Triggers to facilitate data manipulation efficiently and effectively.
• Experience in Data Transformation Services DTS in populating data from various data sources by creating packages for different data loading operations for each application.
• Expert in developing SSIS Packages to Extract, Transform and Load ETL /DTS data into the Data warehouse from Heterogeneous databases such as Oracle, 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.
• Creation of Cubes with Dimensions and Fact Tables in MOLAP Warehouse using SQL Server Analysis Services SSAS .
• Created calculated measures and dimension members using Multi Dimensional Expressions MDX .
• Design / develop database using SQL SERVER 2000 / 2005/2008R2.
• 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 working on different team projects with extensive project implementation, team skills, troubleshooting, presentation abilities and issue resolution capabilities.
• Excellent communication, analytical and interpersonal skills. Experienced in working as team in highly loaded environments efficiently in order to meet deadlines. Ability to adapt to new application upgrades and program tools quickly and efficiently.

Technical Skills

• Databases - SQL Server 2008R2 / 2005/2000, MS Access, Excel.
• Database Utilities - Enterprise Manager, DTS, SSIS, SQL Profiler, SQL Query Analyzer, SQL Agents, SQL Jobs, SSAS.
• Reporting Tools SQL Reporting Services SSRS , Crystal Reports.
• Languages - C/C , T-SQL, PL/SQL, VB.6, C , Java Scripts.
• Operating Systems - Win 2003, Win 2000, Win NT, XP.
• Application Packages - MS-Office 2003 / 2007 / 2008
• Other Tools - Microsoft Visual Studio 2008/2005/2003.

Professional experience

Confidential

SQL Server Developer

Responsibilities:

• Worked with business unit to understand SSRS reports requirements and to document business logic using Team Server Foundation 2012.
• Worked on Stored procedures, Views and UDF's in conjunction with SSRS reporting services.
• Worked on automating SSRS reports.
• Worked on many different SSRS reports for the client to view reports by Sales, Products, and Region, and viewing/analyzing Reports by fiscal year, quarterly, annually.
• Updated existing SSRS reports to add hierarchical viewing of the SSRS reports using cascading parameters.
• Worked on Tabular, Matrix Tablix Reports involving multiple columns and rows grouping, document mapping, Toggle, Sub Reports, Drill-Down and Drill-Through Reports options.
• Worked on automating SSRS reports.
• Report Configuration and Deployment to the Report Server.
• Performance Tuning of Stored Procedures involving extensive T-SQL Outer Joins, Views and Sub-Queries, Clustered Non-Clustered Indexes, Query Execution Plans.

Environments: MS SQL Server 2008R2, OLTP OLAP Databases, Visual Studio 2008 BIDS, EXCEL, Windows 2003 Server, Windows 2007 Professional

Confidential

SQL Server Developer

Responsibilities:

• Developed different Clients projects such as CIGNA, PNC, MetLife, CIT etc., by analyzing their Law Firm Data and writing T-SQL Stored Procs typically incorporating SQL Joins, CTE's, and Views to create KPI's Key Performance Indicators.
• Writing Debugging Standard and Custom Stored Procs utilizing Caching, Security, and Drill Downs.
• Utilize SSIS packages to propagate changes from one environment into another and creating database backups simultaneously.
• Utilizing SQL Profiler Trace to debug KPI's
• Updating Databases using Data and Schema compare

Environments: MS SQL Server 2008R2, SSMS 2008R2, OLAP Database, Visual Studio 2010, Visual Studio 2008 BIDS, EXCEL, Windows 2003 Server, Windows 2007 Professional

Confidential

SQL Server 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.
• Created complex Drill Down reports, Custom Code functions, Chart Reports, Parameterized and Matrix SSRS reports.
• Wrote and modified numerous Stored Procedures and Functions and created and modified existing SSRS reports and uploaded them on Repositories.
• Extensively worked on creating SSIS packages and have used For-each-loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• 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

SQL Server Developer

Responsibilities:

• Involved in gathering requirements from the finance department.
• Worked closely with business unit to understand key business drivers and then identify the individual business metrics and key measures that support them.
• Created and implemented the staging database prior to the final data warehouse.
• Extracted the data from the different sources Oracle and MS SQL and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Created Stored procedure, Views and user defined table type and functions to support application and for Reports back end code.
• 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.
• Created SSIS package to extract, validate and load data into Data warehouse. Have used Execute Package task to execute SSIS packages.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Created Web Pages using java Scripts.
• 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, Visual Source Safe TFS, EXCEL, Windows 2003 Server, Windows XP Professional, Visual Studio 2008, 2010, MS Visio 2010.

Confidential

SQL Developer

Responsibilities:

• Involved in gathering requirements from the finance department.
• Involved in identifying the source system and creating mapping documents based on the schema comparison from DB2, Excel, CSV and flat files.
• Created Stored Procedures, views and user defined functions. Extensively used joins in joining the data using T-SQL while designing the SSIS packages.
• Created complex SSIS packages for processing data and bringing down to staging area for massaging and data scrubbing.
• Used Conditional split, Derived column and Data Conversion task for cleaning the data.
• Used Sort task to merge the data and loaded in the final database and event handling and loggings to handle an error.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created reports, drilldown reports according to requirement for finance team and for day to day analysis purpose by creating store procedure and views and deployed them on SSRS server.
• Generating ad-hoc reports using Report Builder and Crystal Reports
• Used Subscriptions to deliver the reports.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job task by using Scheduled Jobs and Alerts using SQL Server Agent.

Environment: SQL Server 2005/2008 Enterprise Manager, SSIS, SQL Profiler , T-SQL, MS Access, SSMS, Business Intelligence Development Studio/SSIS, MS Excel, MS Word and SQL Server Reporting Services SSRS 2008 Crystal Report, Windows.

Confidential

Role: SQL Developer

Responsibilities:

• Gathered requirements from business analysts and documented them based on functional specifications.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed SSIS packages, architecting the flow of data from various sources such as MS SQL Server 2000, MS Access, MS Excel, CSV files to target MS SQL Server 2005 .
• Modified the existing SSIS packages to meet the changes specified by the users.
• Created stored procedures to incorporate the flow of business and called various stored procedures from SSIS packages to make the flow of the package effective.
• Rewrote the existing SQL queries according to the requests made by the clients and executed them to check the performance.
• Created Clustered and Non Clustered Indexes to optimize the queries performance.
• Wrote batch files and scheduled jobs to rename and change the location of the files received from the client.
• Scheduled jobs for executing the stored SSIS packages which are developed to update the database.
• Provide 24x7 support and ensure that all critical database problems are resolved in timely manner.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, T-SQL, MS Visual Studio 2005, MS Excel, Windows 2003/2000, VB 6.0, VB.Net.

Confidential

SQL Developer

Responsibilities:

• Involved in the requirement gathering phase.
• Involved in the team for identifying the source system and creating mapping documents and workflows from carrying out the migration of the existing system to the Data-warehouse solution.
• Used Data Derived task and, Data Mining Query for checking the data consistency in order to load it in Data warehouse dimension tables.
• Implemented ETL by creating several SSIS packages to load the historical and operational data using full load, sort task and merge as well as incremental loading.
• Created and designed stored procedure to extract data from different sources and transformed them by using SLOWLY CHANGING DIMENSION, LOOK UP task for comparing and checking if the data exist and merge the data to load in the final database in the staging environment.
• Designed and implemented SSIS package and stored procedure for loading aggregated and rollup table for cube processing.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Designed cubes and loaded aggregated tables for the finance team to create expense report and analysis and Deployed cube on the OLAP server.
• Generated periodic reports based on the statistical analysis of the data from various time frames and division using SQL Server Reporting Services SSRS and Developed stored procedures and views to generate Drill down reports.

Environment: MS SQL Server 2000/2005, Oracle 9i, T-SQL, SSIS, DTS, SSRS, SSAS, SQL/PLSQL, Profiler, EXCEL, Crystal Report, Windows 2003 Server, Visual Studio 2005.

Confidential

SQL Developer

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.