SUMMARY:

• Over 5 years of experience in Database Design, Development and Implementation of MS SQL SERVER 2005/2008/2008 R2/2012 with Business Intelligence tools MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS).
• Well versed in Installing, Upgrading, Managing, Configuring, Migrating and troubleshooting MS SQL Server and Database.
• Supported an internal team of Developers, Designers and Test Engineers.
• Hands on experience in Software Development Life Cycle (SDLC) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• Performed database development and maintenance tasks.
• Designs and develops databases structures, scripts, transformation (ETL) scripts and common components.
• Good understanding of ACID properties and Locks.
• Understanding of data warehousing concepts such as Cubes, Fact Table, Dimensions Table, OLTP, OLAP.
• Hands on experience in writing Queries, T - SQL, Stored Procedures, Views, Functions, Indexes, and database Triggers.
• Experienced in sub queries, joins involving multiple tables.
• Experienced in Clustered and Non Clustered indexes on Tables.
• Skillful in creating Parameterized Reports, Drill through and Drill Down reports, Tabular reports, Linked Reports, Sub-Reports using MS SQL Server Reporting Services.
• Experienced in Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) while transferring the data to target destinations from various sources like Excel, CSV, Oracle, Flat File, Raw File and XML File.
• Good understanding of developing Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS) on a Data Warehouse.
• Expert in creating packages for migration of the data from one source to different destination using SSIS and Handling error with Event handler using SSIS.
• Experience in the design, development and implementation of RDBMS using SQL.
• Quick Learner, Analytical, Problem Solving, and Time Management Skills.
• Excellent interpersonal skills, analytical, problem solving and presentation skills.

TECHANICAL SKILLS:

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows7, Windows Server 2008t, Linux

Databases: SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, MS Access, ORACLE 10g/11g, MS Visio, Netezza

Database Tools: Business Intelligence Development Studio, Data Transformation Service (DTS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), Netezza, Vertica

ETL Tools: SQL Server Integration Service (SSIS), Informatica Power Center 9.x/8.x/7.x

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

Reporting Tools: SQL Server Reporting Service (SSRS)

PROFESSIONAL EXPERIENCE:

Confidential, Mountain View, CA

SQL Developer / BI Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2008R2
• Designed ETL packages with the different sources as Flat Files, Excel, Text files, CSV Files, MS Access, Oracle and XML files and migrating the data into SQL Server using SQL Server Integration Services (SSIS)
• Worked with Data Scrubbing and Data Conversion while transferring data from different sources to different destinations
• Extensively worked on T-SQL code to create datasets
• Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server Reporting Services (SSRS).
• Worked with PL/SQL in oracle database which was read only, specially writing a Select queries and load that data into SQL Server 2008 R2 tables using SSIS
• Created SQL Server SSIS packages (ETL) to upload data to the database objects.
• Scheduled jobs to run the SSIS packages on daily basis and monthly basis using SQL Server Agent.
• Hand on experience on Oracle database wrote PL/SQL Packages, Store procedure, functions to manipulate data.
• Implemented Checkpoints, to rerun the failed package from the point of failure.
• Implemented Event Handlers in SSIS packages
• Designed and developed SSIS Packages (dtsx files) to import and export data from MS Excel, ORACLE 10g and Flat files
• SSIS packages to update tables with daily data/monthly data and automated it through scheduled jobs for the beginning of every day and month.
• Created Package Configurations to deploy packages from development to production server.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, XL Files, CSV Files and Oracle
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS, using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

Environment: SQL Server 2008 R2, Windows Server 2007, Windows 2008 Server, SQL Server BIDS, Oracle 10g/11g, MS Access 2003,MS Access 2010, SQL Profiler, SSIS, SSRS, SSAS.

Confidential, San Jose CA

SQL Developer

Responsibilities:

• Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
• Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Developed Strored Procedures for the DataSet to build the reports for the client requirements.
• Created SQL Joins, sub-queries and other SQL code to implement business rules.
• Performance tuning, and optimization of procedures and queries.
• Used DBCC commands for Database maintenance (Rebuilding Indexes).
• Installation and configuration of SQL Server 2008 R2
• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server 2008 and Flat files.
• SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008 R2.
• Designed packages that utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Developed packages in SSIS with error handling.
• Created Package Configurations to deploy packages from development to production server.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Involved in creating report models and applying row level security filters for report model.
• Experienced in participating meetings with business users to gather the requirements.
• Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.
• Worked with development teams in the design of physical databases and in modification.

Environment: MS SQL Server 2008/2008R2, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Microsoft Office 2010, OLAP, Oracle 10g,ASP.Net, VB.net, MS Visio.

Confidential, Detroit, MI

SQL Developer

Responsibilities:

• Participated in designing and normalizing the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, functions & triggers.
• Created complex SQL queries using table joins (inner and outer), temporary tables and table variables.
• Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server Reporting Services (SSRS).
• Experience in deploying and scheduling the reports based on quarter, month, and year reports.
• Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services (SSRS).
• Developed, monitored and deployed SSIS packages.
• Worked on Excels to upload the data from excels to database.
• Responsible for implementation of data viewers, error configurations for error handling of the packages.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Experience in developing ETL packages with the different sources as Flat Files, Excel, Text files, and XML files and migrating the data into destination using SQL Server Integration Services (SSIS).
• Implemented Event Handlers in SSIS packages
• Implemented Checkpoints to rerun the failed package from the point of failure.
• Responsible for creating user groups and assigning permissions.
• Created DTS packages to transfer objects from development server to production.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and maintained Linked Servers.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Linux.