PROFESSIONAL EXPERIENCE

• Around 8.5 years of experience in Database Development - MS SQL Servers 2012/2008/, Oracle 9i/10g, in Production, QA, and Development environments.
• Expert in developing T-SQL DDL, DML , PL/SQL scripts.
• Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions UDF , Cursors, Derived Tables, Views and Triggers.
• Advance knowledge in RDBMS concepts, logical/physical data models, indexes and data integration routines
• Experience with MS SQL Server 2012/2008 with Business Intelligence using SQL Server Analysis Services SSAS , SQL Server Reporting Services SSRS and SQL Server Integration Services SSIS .
• Experienced in different phases of SDLC Software Development Life Cycle including requirements analysis, design, development, documentation, deployment and system support.
• Strong experience in SQL Server DTS and SSIS Integration Services package design, constructing, and deployment.
• Experienced in Performance Tuning, Query Optimization and maintaining database systems.
• Experience in migration of Data from Excel, Flat files, Oracle RDBMS to MS SQL Server by using MS SQL Server DTS and SSIS packages/tasks.
• Experience with C and VB.Net scripting when using SSIS packages.
• Able to install, upgrade and configure Microsoft SQL Server and Oracle Databases.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Proficient in developing Parameterized, Ad-Hoc Reporting, Linked Reports, Sub Reports, Drill down and Drill through reports using SSRS.
• Extensively used Report Builder and Report Manager for developing and deploying reports with SSRS.
• Expert in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process BCP , SSIS with MS SQL 2012/2008.
• Experience in backup and disaster recovery procedures and creating packages, Jobs, Sending Alerts using SQL Mail.
• Worked on administration tasks such as data loading, batch jobs, data uploading, backup recovery, Database mirroring, Log shipping, user and application table management, upgrades, database partitioning, databases/file groups/files/transaction logs.
• Familiar with OLAP cubes, dimension tables, fact tables, star and snowflake schemas.
• Knowledge of .NET Frame Work, Windows/Web technologies, C , VB.NET, ASP.NET, ADO.NET, XML, Web Services.
• Experience in System testing, Functional testing, Integration testing, Regression testing, UAT User Acceptance testing , Load and Stress testing.
• Flexible, enthusiastic and project oriented team player with excellent communication and leadership skills to develop creative solution for challenging client needs.
• Positive attitude towards superiors peers.
• Able to manage changing responsibilities and deliver time critical projects on schedule.
• Strategic vision, analytic, imaginative and procreativity ability to formulate and validate solutions.

TECHNICAL SKILLS

WORK EXPERIENCE

Confidential

MS SQL Server Developer

Responsibilities:

• Expertise in Database creation DDL, DML, DCL , database tuning, SQL tuning, performance planning.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, Indexes, tables, and views and other SQL joins for building various applications.
• Installed and Configured SQL Server 2008 successfully.
• Involved in gathering requirements in conceptual data modeling phase.
• Involved in designing database using MS Visio.

• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.

• Used MS Access for creating the tables.
• Extracted data using complex queries and table joins in Oracle source systems.
• Implemented High availability concepts, Data base Mirroring, Replication and log shipping.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in Data Modeling ER and dimensional involving tables/ indexes/ triggers/ procedures/ functions for Reporting data warehouse
• Involved in development, enhancement, testing and performance tuning of the application.
• Perform unit and integration test for all components of code and user acceptance testing.
• Resolved various performance issues by running DBCC command.
• Efficiently used Microsoft SQL server 2008/2005, SQL server management studio and BIDS. And participated in designing a data warehouse to store all the information from OLTP to Staging and Staging to Enterprise data warehouse at the center to do better analysis.
• Built SSIS packages/jobs to support ETL type 1 and type 2 slowly changing dimensions, facts of the data warehouse.

• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Worked on different kinds of Transformations like Import Column, Export Column, SCD and Lookup in SSIS as per the client's Requirement.
• Involved in writing stored procedures and User Define scalar Functions UDFs to be used in the SSIS packages and SQL scripts.
• Importing data from multiple databases like My Sql, DB2 and oracle.
• Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints and protection levels.
• Used C and VB.Net scripting when performing SSIS packages

• Utilized SSRS reporting services to generate different types of reports from the database.
• Created Report Subscription using SSRS 2008.
• Performed Data Analysis for automating various Customers Order Reports utilizing SQL Reporting Services.
• Developed user requested reports using Crystal Reports
• Manipulate information using MS Access and Excel for reporting.
• Building dashboards using SSRS 2008.
• Involved in performing Functional, Application, Integration, System, Regression and Performance tests.
• Responsible for reporting and tracking the bugs using Quality Center.

Environment:

MS SQL Server 2012, SSIS, SSRS, SSAS, T-SQL, Oracle 11g, MS-Excel, MS Access, MS Visio, QTP, Load Runner, Quality Centre

Confidential

SSIS/SSRS/SSAS Developer

Responsibilities:

• Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union etc in SSIS packages.
• Analyzed database performance with SQL Profiler and Optimized indexes to improve query performance.
• Dimensional and ER Data Modeling involving tables/views/indexes for the date warehouse.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.

• Implemented Complex Logging in SSIS Packages.
• Created package configuration in XML and used them to deploy packages into various servers.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Triggers to implementing the business rules and transformations.
• Developed SSIS packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration services SSIS to populate the data warehouse.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations scheduled the same SSIS packages by creating the corresponding job tasks.
• Perform ETL operations for Business Intelligence reporting solutions using custom VBA and Excel web queries.
• Generated reports from MS Access and sharepoint
• Development and automation of ETL using SSIS from source to PPS
• Generated parameterized/Drilldown reports using SSRS.
• Created Report Snapshots to improve the performance of SSRS.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed reports to Reporting Services.
• Used to support the data processing engine in database intensive operations like query Performance tuning, parallel query algorithm, and data mining by writing Stored Procedures.
• Involved in performing Functional, Application, Integration, System, Regression and Performance tests.
• Created Scorecards/Dashboard Pages in Performance Point Server PPS

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, T-SQL, MS Access, VB.NET, C , Performance point Server, QTP, Load Runner, Quality Centre.

Confidential

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Worked as part of the Database Engineering team to design and develop ETL solutions that will provide data to operational and analytical reporting systems used by AHM internally as well as AHM clients.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc for Export and Import Packages.
• Involved in the design of patient-care data mart and OLAP enhancements of the system.
• Interacting with Business users and BA's to gather requirements for creating ETL Packages/jobs to populate the patient-care data warehouse and Reports.
• Performed Report writing according to business requirment using SSRS.
• Expert in creating Tabular reports, Matrix reports, List report, Parameterized reports, Sub reports, Adhoc reports SSRS . Generated database monitering and data validation reports in SSRS.
• Deployed Reports to Report Manager and also formatted report to render them into a PDF, Excel and Word formats.
• Generated stored procedures, triggers, Cursors, Joins for the database development.
• Responsible for writing highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Used Microsoft Sub Version for version control and configuration management.
• Produced Technical Design Documents based on the standards and policies.
• Monitored jobs to provide production support.
• Involved in Unit testing process.

Environment: MS SQL Server 2008, Sub Version, MS Visual Studio 2008, SSRS, SSIS, T-SQL.