CAREER SUMMARY

• An enterprising & focussed professional for about 7 years with knowledge on SQL Server 2008/2005/2000, SSIS, SSRS, C# .Net 2.0, Oracle 9i.
• Over Five years of extensive experience in translating the business requirements into SQL Server 2008/2005 as a SQL developer.
• Hands - on experience and in depth knowledge in SQL Server 2008/2005 BI tool and T-SQL programming.
• Extensive experience working with Data Transformation Services (DTS), SQL Server Integration Services (SSIS) involved in importing and exporting the data between homogenous and heterogeneous systems using various Extraction Transformation and Loading(ETL)
• Experienced in designing and developing reports in SQL Server 2005 Reporting Services by translating the requirements into technical specification and creating reports with respect to business requirement.
• Good knowledge in Data warehousing, DBMS and ETL concepts.
• Proficient in using T-SQL queries (DDL and DML). Worked extensively with multiple relational databases like MS SQL 2008/2005/ 2000.
• Expert in implementing business logic in backend using dynamic Stored Procedures, appropriate Functions, and effective Triggers to facilitate efficient data manipulation and data consistency.
• Experience in creating packages, Scheduling Jobs, Sending Alerts using SQL Mail Agent.
• Extensive experience in performance tuning and optimization, data integrity and statistics.
• Migrating Databases from SQL Server 2000 to SQL Server 2005.
• Work with developers to move all dynamic SQL into stored procedures.
• Able to work independently and collaborate proactively & cross functionally within a team.
• Highly motivated and possess ability to think, to analyze and to communicate with users and discuss their data, application and project requirement in a team environment.

TECHNICAL SKILLS

Databases: MSSQL Server 2008/10.0, MSSQL Server 2005/9.0, MSSQL Server 2000/8.0, Oracle 9i

Database Utilities: SQL Server Management Studio, Enterprise Manager, Query Analyzer,SQL *PLUS

Languages: T-SQL, PL/SQL, C, C++, C#.NET, VB Script

BI Tools: MS BI SQL Server 2008/2005 Integration Services, MS BI SQL Server 2005 Reporting Services.

Web Related: HTML, XML

Operating Systems: MSDOS, MS Windows XP, 98, 2000

Application Packages: MSOffice, Visio

PROFESSIONAL EXPERIENCE

Confidential, CO

T-SQL Developer

Responsibilities:

• Responsible for addressing the tickets raised by the clients whether data related or UI related
• Involved in providing data fixes using T- SQL, including handling XML through SQL
• Involved in providing business logic fixes in stored procedures or in the .NET C# UI code
• Prioritize the tickets to address them more effectively
• Coordination with the client engagement team to communicate and migrate the fixes

Environment: SQL Server 2008/2005, SQL Server Management Studio, Team Foundation Server (TFS), C#.Net, Visual Studio 2010, XML, MS Office Excel, Windows XP.

Confidential, MI

Title: ETL Developer

Responsibilities:

• Analysed the legacy Oracle database schemas and mapped the tables, relationships and columns in to SQL Server 2008.
• Involved in development of processes that populate the Data Warehouse, and then loading into Data Marts using SSIS
• Designed ETL to extract from external data source
• Used some of the important tasks like Send Mail, Execute Package, Script Task, Dataflow Task and important transformations like Slowly Changing Dimension
• Took over the responsibility to ensure that million records were accurately migrated.

Environment: SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Business Intelligence

Confidential, MI

SQL Server Developer

Responsibilities:

• Responsible for development of processes to populate the Data Warehouse, and loading into Data Marts using SSIS
• Designed Packages to extract and load data using appropriate connection managers, data sources and data source views
• Analysed business requirements and translated them into technical design solutions.
• Improved the process to save time in performing the task. E.g. written a script to validate CSV files before running the package
• Developed reports using SSRS 2005. Used table control, matrix control for cross tab reports.
• Created Report templates, bar graphs and pie charts based on the financial data
• Optimized the query performance by normalizing database, creating useful clustered index and non-clustered indexes.
• Updated statistics using Query Analyzer and Enterprise Manager on the existing servers, to improve T-SQL query performance

Environment: SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting ServicesSQL Server Business Intelligence Development Studio, SQL Server Management Studio, XML, VB ScriptWindows XP.

Confidential, MI

SQL Server Developer

Responsibilities:

• Developed the end user documentation and performed periodic updates of the design documents
• Stored Procedures and functions were written to handle major business crucial calculations.
• Defined Check constraints, rules, indexes and views based on the business requirements.
• Created necessary triggers on tables to ensure data and referential integrity incorporating business logic.
• Documented all the procedures involved in the database for future reference.
• Designed dynamic SSIS Packages to transfer data across different platforms, Oracle, DB2
• Developed SSIS packages to extract data from various data sources - Access, Excel and flat files
• Consolidated data using various Components like Derived Column, Fuzzy group, copy column, Look up transformations etc.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Involved in the various phases of system testing such as unit, integration and regression testing.

Environment: SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting ServicesSQL Server Business Intelligence Development Studio, SQL Server Management Studio, XML, VB ScriptWindows XP.

Confidential

SQL Server Developer

Responsibilities:

• Analyzing Business Requirements and translating them into technical solutions. Involved in requirements gathering. Designing the User Interface.
• Developed the application using C#.Net. Designed and implemented Business and data access objects using C#.
• Performed client side validation using Java Script.
• Developed stored procedures to reduce the network traffic, functions, views, triggers, Joins and Correlated Sub-Queries to improve database performance
• Developed test cases, test plans and performed Unit Tested various functions of the application. Involved in Integration Testing of the project. Handled the change requests for the application.
• Worked on the application during production support.

Environment:C#.Net, SQL Server 2000.

Confidential

PL-SQL Developer

Responsibilities:

• Analysis of the specifications provided by the clients.
• Developed stored procedures, functions, indexes, views and triggers.
• Extensively used Joins, Functions and Correlated Sub-Queries to simplify complex queries involving multiple tables.
• Adding the new features to the existing stored procedures.
• Developing the new stored procedures and Queries according to the requirement.
• Involved in the various phases of system testing such as unit, integration and regression testing.
• Documentation of the Module using Satyam standards. Responsible for overseeing the Quality procedures related to the project.

Environment:Oracle 9i (PL/SQL), Windows 2003.