PROFESSIONAL SUMMARY:

• Around 7 years of experience in IT Industry, in Design, Development & Support, this includes Finance, Healthcare, Manufacturing, and E - Commerce businesses.
• Experience in Database Installation, Configuration, Management, Monitoring, and Development which includes Design, programming and supporting the production environments.
• Experienced in Transact-SQL (DDL, DML, and DCL) and in Design and Normalization of the database tables.
• Experienced in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on).
• Experience with tools like SQL Server management studio and SQL Server 2008 integration services
• Proficient in Tuning T-SQL queries to improve the database performance and availability.
• Experienced in Query tuning and performance tuning.
• Experience in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Ability and willingness to learn new technology and deliver results in a timely manner. experience in design techniques, ETL processes, relational database theory, N-Tier development
• Created and scheduled Jobs, Alerts, SQL Mail Agent and DTS/SSIS Packages
• Experience on relational databases (RDBMS), data models and technical architecture
• Proactive team player with fast learner with a desire to grow skills and expertise.
• Expertise in Transforming Logical Database designs into Physical Databases.

TECHNICAL SKILLS:

Databases: SQL Server 2008 R2, MySQL, Oracle 9i

Programming Languages: SQL, T-SQL, PL-SQL

Scripting Languages: PERL, PHP, Unix Shell script

Operating Systems: UNIX, Windows

Tools: SSMS, MSBI (SSIS, SSAS, & SSRS)

Scheduling Tools: Windows scheduler, MS SQL Agent

Version Control: TFS2013/2010, SVN, Git-hub

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Microsoft BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Gather requirements from business user and create requirements and/or design documents in accordance with the changes in Health Insurance rules and regulations.
• Understanding functionality and coordinate with technical analysts, system analysts, business analysts, process owners and other functional team members to ensure quality
• Involved in preparing high level and low level design documents, also test design documents for various functionalities
• Improve the performance of applications using various performance techniques
• Support the development team, and resolving any issues which arise during the deployment of the application
• Provide support during pre and post deployment phases
• Developed SQL Server Stored Procedures, Tuned SQL Queries
• Developed User Defined Functions and created Views
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Worked on various SSIS packages to prepare files from the database and send them to downstream system for various processing.
• Worked on Performance tuning of existing and new SSRS reports, by verifying Execution Log etc.
• Also have good knowledge on Deploying SSRS reports.

Technologies Used: SQL Server Tools: SQL Server Management Studio, Profiler, Query Analyser, SSIS, SSRS, DOT Net, Java, SQL, T-SQL, TFS2013/2010

Confidential, Portland, OR

Microsoft BI Developer (SSRS)

Responsibilities:

• Responsible for gathering and analyzing End User Requirements and System Specifications.
• Involved in identifying data and design issues and procedures to improve/maintain quality along with data warehouse architect.
• Wrote complex T-SQL code and Stored Procedures to load dimensions and to enable data extractions and changed data capture.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to perform load operations to speed up the ETL processing.
• Created complex ETL strategies to extract, clean and deliver data to OLAP environment.
• Designed and developed SSIS packages to extract the data into the system from multiple upstream data sources.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created SSRS reports using both SQL Database and Analysis Services database.
• Worked on Tuning existing and new SSRS Reports
• Built data marts, databases, tables, indexes, views, functions, triggers and stored procedures.
• Involved in Production Support for SSIS/SSAS/SSRS.

Technologies Used: SQL Server Tools: SQL Server Management Studio, Profiler, Query Analyser, SSIS, SSRS, SSAS, Java, SQL, T-SQL, SVN

Confidential, Miami, FL

SQL Developer

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Created SSIS packages to load data from Oracle to Sql Server using various transformations in SSIS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Analysed the existing tool and participated in meetings with the business users to gather
• Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.

Technologies Used: SQL Server Tools: Microsoft SQL Server 2008R2/2005, Microsoft Office 2010/2007, ODBC, Erwin, Team Foundation Server, Crystal Reports 10 and SSRS/SSIS/SSAS 2008R2/2005

Confidential, Los Angeles, CA

SQL Developer

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL
• Database and DB2 Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data from Oracle to Sql Server using various transformations in SSIS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Analyzed the existing tool and participated in meetings with the business users to gather Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.

Technologies Used: SQL Server Tools: SQL Server Management Studio, Profiler, Query Analyser, SSIS, SSRS, DOT Net, SQL, T-SQL, TFS2013/2010

Confidential

SQL Developer

Responsibilities:

• Responsible for gathering and analyzing End User Requirements and System
• Designed the Tables and columns
• Worked on creating Tables, Stored Procedures
• Worked on updating the existing Stored procedures
• Worked on Tuning the SQL Queries
• Created Test case documents and unit testing the application
• Worked on various reports used in the application.

Technologies Used: SQL Server Tools: SQL Server, C#, .NET