Experience Summary

• IT Professional with over 7 years of experience in planning, analysis, design, implementation and management of databases utilizing strong skills in SQL Server, SSIS, SSRS, OLTP and OLAP.
• Expertise in creating various Database Objects like Tables, stored procedures, Indexes, Views, Triggers, functions using SQL Server 2005/2008/2012.
• Extensively worked on SQL Server 2005/2008/2012tools like SQL Server Management Studio SSMS , Business Intelligence Development Studio, Query Analyzer, SQL Server Profiler, Integration Services SSIS and Reporting Services SSRS
• Extensive knowledge of SQL Server and Index Architecture
• Expertise in Query optimization, performance analysis, performance tuning using SQL Server 2005/2008/2012.
• Expertise on ETL tools like DTS package and SQL Server Integration services 2008
• Expert in Data Extraction, Data Mapping Transforming and Loading ETL using various tools such as SQL Server Integration Services SSIS , DTS, Bulk Insert and BCP
• Experience in configuring Control Flow, Data flow, checkpoints, logging, package Configuration and event handling, error handling to redirect error rows and fix the errors in SSIS
• Experience in creating SQL Server Jobs to schedule SSIS packages using SQL Server Agent.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experienced in creating Data Driven, Drill Through, Drill Down, parameterized, Tabular and Matrix reports using SQL Server Reporting services.
• Good Knowledge of Teradata platform, architecture and its utilities.
• Experience in advanced MS Excel, MS Access, pivot-tables.
• Expert in design, development and delivery of high-performance technology solutions to meet challenging business demands
• Involved in Unit Test Case, Integration Test, User Acceptance Test UAT preparation and testing of the applications.
• Developed functional requirements with customers, impact analysis, design development, integration test and deployment of the solution profitably.
• Proven ability to analyze problems, root causes and develop innovative solutions to business challenges and streamlining operations.
• Team player with good communication skills, written skills, technical documentation skills and also a self-motivated individual with exemplary analytical and problem solving. A conscientious professional committed to excellence and continuous improvement.

TECHNICAL SKILLS:

Database: Microsoft SQL Server 2005/2008/2012

ETL Tools: SSIS Packages

Programming Languages: Java, C

Operating System: UNIX, Windows XP/Win 98/Win NT/ Win 7

Business Intelligence: SSIS, SSRS

Tools: Microsoft Office, SQL Advantage.

Versioning Control Tools: SVN

Business Process Modeling Tools: Microsoft Visio, Microsoft Excel

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Design and develop SSIS packages, store procedures, configuration files, Tables, Views, Indexes
• Created SSIS jobs for monitoring the jobs that depends on daily loads and loading DB2 Database Tables using SQL Server Agent.
• Developed Transact-SQL T-SQL Queries, Stored Procedures, Triggers, User Defined Functions UDF , Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.
• Created Windows Logins and privileges to User Accounts/Groups and objects
• Developed CTE's, Constraints, and Complex queries to fetch the data from different servers.
• Creating Tabular reports with SQL Server Reporting Services SSRS .
• Generating parameterized reports, drill down drill through reports
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS. Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Developed a thorough knowledge by working on Full Life Cycle of the Software Development Life Cycle SDLC phases namely Analysis, Design, Coding and Testing

Confidential

Responsibilities:

• Created functional and technical specifications for ETL Development based on business requirements.
• Develop SSIS packages for Extraction and Transformation processes and setup ETL Architecture setup, Standard Templates, Naming Conventions.
• Develop production ETL processes, Scheduling and maintaining SSIS Packages and batch jobs through SQL Server Agent on a day-to-day basis.
• Created SSIS packages to output SQL Data to various data sources.
• Documentation of the ETL processes, standards and naming conventions.
• Setup ETL environment to maintain Environment specific configurations, so that ETL packages can be easily deployed between Dev., Staging, Test and Production environments.
• Set up Audit for the configurations to be used for the ETL processes.
• Develop triggers to manage and monitor unwanted data loads and errors.
• Create and standardize User Defined Functions that were used by the App team in the process of Dev.
• Created reports using SSRS to assist users to track the Load processes information.
• Designed Report Layouts for Parameterized Reports and Drill Down reports, Tabular Reports, Hyperlink Reports.
• Configured transactional and snapshot replication
• Assist in optimizing query performance, Recommend Tuning Efficiency Improvements.
• Worked with Tabular reports, Matrix reports, Gauges Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services SSRS .
• Scheduled execution and delivery of end of the day report using SSRS.
• Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.

Environment: Windows2003 Server, SQL Server 2005/SQL2008, SSRS SSIS, T-SQL, BIDS, Team Foundation Server TFS , Erwin 7.2, SQL Server Profiler, C , VB.NET.

Confidential

Responsibilities:

• Created new tables, views, indexes and user defined functions.
• Designed the database to fasten certain daily jobs.
• Designed database maintenance plans to set up core maintenance tasks to make sure that the database performs well, is regularly backed up in case of system failure and is checked for inconsistencies.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and SSIS.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Wrote T-SQL statements for retrieval of data.
• As a Developer created Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications
• Created data model, logical design, and physical design of the database.
• Developed complex stored procedures to create various reports.

.

Environment: MS SQL Server 2005, T-SQL, DTS, Windows2003, MS Visio, Visual Source Safe and FTP Communication, Replication, Query Analyzer, Enterprise Manager, SQL Profiler, Index Tuning Wizard , Windows XP, MS Access, MS Word.

Confidential

Responsibilities:

• Creating Database objects like stored procedures, Indexes, Views, Function, Triggers using SQL Server 2008.
• Developing, rectifying and troubleshooting the existing discrepancies in the application using SQL Server 2008.
• Designing, developing new reports required by Business, updating existing reports as requested by business users.
• Creating, enhancing and publishing user reports using SSRS.
• Maintaining Defect Register: The in-process and post-delivery defects are recorded in the defect register. The defects are classified as per severity, defect type, occurrence and detection phase.
• Writing Tuning SQL Queries, Stored Procedures, Triggers, Views, Indexes, Performance Tuning, Query Optimization using SQL Server 2008.
• Creating Cross Tab, Sub Report, Parameterized reports as per the requirement.
• Data Import Export using automating Excel reports.
• Database administration activities like Backup, Restoration, Re-indexing, Updating Statistics, Performance related issues
• Database designing of the new modules implemented to automate the Employee and Account Management system.
• Creation and running unit test scripts.