Summary:

• Over 7 years of IT experience as a MS SQL Server Developer 2000/2005/2008 with Integration Services and Reporting Services in Physical and logical Database Design in different domains.
• Extensive knowledge and experience in working with RDBMS, Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Views, Cursors, UDF and Data integrity.
• Strong ability in defining query for generating drill down/drill thru reports, handling parameterized reports, Cascade type reports and Ad-hoc Reports in SSRS.
• Extensively worked on Design, Development, Deployment Maintenance of ETL process using SSIS to Extract, Transform and Load ETL data from different sources Flat/Excel/Access/XML /SQL/ Oracle to different targets DB/Files .
• Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services DTS and SSIS with MS SQL 2005.
• Expert in calculating measures and dimension members using Multi-Dimensional Expression MDX , mathematical formulas, and user-defined functions.
• Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans.
• Experienced in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery.
• Used tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as a proactive team member.
• Excellent analytical, communication and inter-personnel skills with exceptional ability to learn new concepts, adaptable to ever changing priorities.

Skills Set:

T-SQL, SQL, PL/SQL, .NET Framework, VBScript, XML, HTML, DHTML, Shell Scripting, SQL Server 2008/2005/2000, Oracle 10g/9i, MS Access, ERWIN, SSRS, SSAS, SSIS, BIDS, Visual Studio, DTS, Crystal Reports, Web Services, Import/Export data, BCP, MS Visio, Windows Vista/XP/2003/2000 NT

Projects Summary:

Confidential

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

• Migrated data from Heterogeneous data Sources and legacy system to centralized SQL Server databases using SQL Server Integration Services to overcome transformation constraints.
• Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
• Designed and tested packages to extract, transform and load data using SQL Server integration services SSIS .
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, sequence Container, conditional split, data conversion, derived column and multi casting.
• Used configuration files for migrating SSIS packages from development stage to Quality Analysis without having to reconfigure the packages.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.
• Worked in creating and executing complex Stored Procedures, user defined functions and SSIS packages.
• Created Triggers, Cursors, Tables, and Views and SQL Joins to generate statements for application.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used MS Integrated Services to establish OLEDB connection from SQL Server databases to front end web applications.
• Implemented Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events and Log Providers.

Environment: Microsoft SQL Server 2005/2008, SSIS, SSRS, BI, DTS, SQL Profiler, MS Access, ODBC, Oracle 10i, Microsoft Visio, Erwin, MS Office 2007.

Confidential

MS SQL Server Developer

Responsibilities:

• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Analyzed Reports and deployed reports in SSRS. Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Generated standard parameterized Tabular and Matrix Reports for the Business users using SSRS.
• Experience in creating multiple reports SSRS in Drill mode using tables, cross tabs and charts. Rebuilt reports and fixed bugs in Stored Procedures, Tables and Triggers.
• Involved to implement OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Involved in creating relationships and hierarchies between attributes and measure groups and defined granularity with in a measure group and drill through actions in SSAS SQL Server Analysis Service .
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.

Environment: MS SQL Server 2000/2005 Enterprise Edition, MS Access, DTS, Query Analyzer, BCP, SQL Profiler, Import Export Data, Windows 2000 Server.

Confidential

MS SQL Server/SSRS/SSIS Developer

• Confidential formerly Bancshares of Florida is the holding company for its eponymous Bank of Florida subsidiaries, which operate about ten branches in southeastern and southwestern portions of the state, as well as the Tampa Bay area. Subsidiary Bank of Florida Trust offers trust, estate planning, and investment management services.onsibilities:
• Worked as a developer on MS SQL Server 2000/2005, MS Access databases using DTS, T-SQL, scripts, stored procedures and views .
• Developed stored procedures, functions and database triggers. Executed SSIS packages to populate data from the various data sources.
• Migrated DTS packages to SSIS packages and modified those packages.
• Designed ETL packages dealing with different data source and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Created Logical and Physical data models using ERWIN data modeling tool.
• Worked as a developer in creating complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Transferred data into various formatted files and automated email systems after the completion of the entire process.
• Created/Modified SQL Joins, Sub queries and T-SQL code to implement Business rules.
• Enhanced the performance of several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Involved in documenting the project steps and presenting to the team members.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.

Environment: T-SQL, SQL Server 2005 Management Studio, SQL Analyzer and Enterprise Manager, SQL Agent, SSIS, SSRS, Erwin3.5, Windows Performance monitor

Confidential

MS SQL Server Developer

Responsibilities:

• Designed, developed, modified and enhanced the database structures and database objects. Wrote several complex stored procedures for the ease of application.
• Created several SSIS packages in Microsoft SQL Server 2005. Designed and tested packages to extract, transform and load data using SQL Server integration services SSIS .
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Transferred data into various formatted files and immediately updated my managers with the automated email systems.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Generated various Report models on Views and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.

Environment: Microsoft SQL Server 2000/2005, Business Intelligence tools SSIS, SSRS, SSAS, DTS, MS Access, T-SQL programming.

Confidential

MS SQL Developer

Responsibilities:

• Mostly involved in gathering business Requirement and Online System Specification and building up a solution to implement in CAIS.
• Implemented batch processing for approval process by creating a wrapper driver which used I SQL conducting various BCP, select out and select into commands.
• Wrote stored procedures Created views to process prospective customer information and balanced the processing load between front end and back end.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2000.
• Developed interface store procedure to upload customers driving record from DMV in CAIS
• Used SQL profiler to optimize remote procedures and queries by creating workload files and setting various filters and parameters like cash hit ratios.
• Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.

Environment: MS SQL Server 2000, Windows 2000, MS Access, DTS Data Transformation Service , BCP, text files, Windows XP.