SUMMARY

• 7 years of IT experience in the use and development, design, support of Microsoft SQL Server 2008/2005/2000 database.
• Designing, testing and implementation of high availability solutions for databases for large, medium and small customers.
• Experience in SQL Stored Procedures, Triggers, Indexes, Views, Data Transformation Services and Reporting services.
• Coding of Database objects like Triggers, Procedures, Functions and Views
• Experience in T - SQL (DDL and DML).
• Experience in migrating from SQL Server 2005 to SQL Server 2008
• Expert in MS SQL Server suite of products like SSIS and SSRS of MS SQL Server 2005
• Experience in Database Backup, Recovery and Disaster Recovery procedures for large, medium and small database instance.
• Exposure to T-SQL programming and Architecture, and translated complex legacy process with T-SQL procedure, functions and package.
• Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity.
• Extensively worked on developing and deploying applications using: SQL Server 2005/2000, Microsoft office, VBA and macros.
• Very good experience in developing reports using SQL Server 2005 Reporting Services (SSRS).
• Experience in creating DTS/SSIS packages for transferred data modifications.
• Hands on experience in creating ETL packages using SQL Server 2005 Integration Services (SSIS).
• Experience in the installation and configuration of SQL Server 2005.
• Experience in Medical and Life Claims.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• A Team-Player with motivation and ability to work independently, Worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams.
• Worked with performance tune the complex queries using the Microsoft Query analyzer and used to support batch process.
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issuaes.
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.

TECHNICAL SKILLS

Programming Languages: T-SQL, C#, ASP.NET, VB 6, PHP, HTML,CSS, XML

Database Application Software: SQL Server 7.0/2000/2005/2008 , MS Access.

DB Utilities: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Reporting Server.

GUI DTS: Import/Export, MS SQL Server Integration Services.

Reporting Tools: MS Access, Excel, MS SQL Server Reporting Services 2005/2008, Crystal reports, IBM Cognos, Business Objects.

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), Import Export Data, Bulk Copy Program (BCP).

Methodologies: Business Analysis, Object-Oriented (Use Case) Analysis, Database Design and Normalization, Data Modeling.

Operating Systems: Windows Vista/XP/NT/2000/7,UNIX

PROFESSIONAL EXPERIENCE

Confidential, WI

SQL Server BI Developer

Responsibilities:

• Involved in creating new reports and add enhancements to the existing reports.
• Involved in creating dynamic SQL scripts in the stored procedures for obtaining best performance for the reports.
• Converting classic reports (coming from old system) into EDR reports (Coming from recently migrated new system.
• Created Tabilx Reports, Matrix Reports, Parameterized Reports and Drill-Down Reports.
• Created SSRS reports using report parameters, Drop-Down Parameters, and Multi-Valued Parameters.
• Built effective queries and stored procedures for high performance reporting and rendered them to HTML,PDF and EXCEL formats using reporting services.

Environment: Windows 2003 Advanced Server, MS SQL Server 2005/2008, MS Outlook, T-SQL, QC9.2, SSRS,BIDS 2005/2008.

Confidential, CA

SQL Server BI Developer

Responsibilities:

• Worked with the developers and provide necessary SQL Scripts using T-SQL.
• Create new tables, views, indexes and user defined functions.
• Actively designed the database to fasten certain daily jobs and some stored procedure.
• Optimized query performance by creating indexes.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
• Involved in performance tuning of T-SQL queries and Stored Procedures. Developed Reports in QC 9.2 using Excel Report Generator.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters, created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, Drill Down, Parameterized and sub-reports using SSRS.
• Used Try catch and @@error for exceptional handling.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Performance tuning of existing database objects including Stored Procedures.
• Prepare documentation related to database design, objects security and rules.
• Involved in Administration of the SQL Server by creating users & login ids with
• Appropriate roles & grant privileges to users.

Environment: Windows 2003 Advanced Server, MS SQL Server 2008, MS Outlook, T-SQL, QC9.2, FLEX SSRS, SSIS.

Confidential, St. Louis, MO

SQL Server SSIS/SSRS Developer

Responsibilities:

• Developed SQL Reports using Optiva system data for Manufacturing Process.
• Developed Crystal Reports for Technical Data used in Optiva.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Migrated from Oracle to MS SQL SERVER 2005.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of, <>, statement & using the TOP operator to limit the Select Statement in certain Queries
• Created views to restrict access to data in a table for security
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using SSRS 2005.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Supported Application Development team with any database issues, updates or new releases.
• Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc

Environment: SQL Server 2000, 2005, XML, MS Project, MS Access 2000 & Windows 2000 platform, MS Share Point, Crystal reports.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked closely with BA, DBA to analyze business model, gather project requirement.
• Loaded and mapped data into Staging Database using SSIS packages.
• Performed data analysis for reports and presentations for senior management and external recipients.
• Populated data for Test environment.
• Developed, modified, and optimized very complex queries to data retrieval and modification
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Migrated SQL server 2000 to SQL Server 2005 in Microsoft Windows Server 2003 R2 Enterprise Edition SP2.
• Generated reports using SQL Server Reporting Services and Excel spreadsheet.
• Created Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Comprehensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Performed installation of SQL Enterprise bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers.
• Involved in migration of SQL Server 2000 databases to SQL Server 2005 databases.
• Supported Development UAT, System Test, Training, Staging and Production.
• Documented the procedures and process.

Environment: SQL Server 2005, SSIS, Packages, Windows Enterprise Server 2003, IIS Server, Oracle 9i, Informatica.

Confidential

SQL Server Developer

Responsibilities:

• Creating Database Stored Procedures.
• Requirement analysis of the proposed system.
• Creating and maintaining Triggers, Packages, Functions and Procedures.
• Interacted with users to collect and analyze the specs and designed documents
• Prepared Test Cases and Test Plan for the different modules of the application.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed scripts for maintaining administration tasks.
• Developed Packages to transfer the data between SQL server database and files
• Creation and management of database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
• Responsible for design of the Schema and finalization of naming and coding standards.
• Performed Unit and System Testing.

Environment: SQL SERVER 2000, Windows 2000, Enterprise Manager, SQL Profiler, T-SQL, Replication, Test Director