SUMMARY:

• 8 years of experience in Project Design, Analysis, Development & Management using Microsoft SQL 2005/2008/2008 R2 and 2012. Good team player, strong interpersonal and communication skills combined with self - motivation, initiative and worked in a technically challenging environment.
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL server Analytical Services (SSAS) of MS SQL server 2005/2008/2008 R2/2012.
• Proficient in database modelling for OLTP, Data Marts, Operational Data Store (ODS) and OLAP.
• Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (MDS), and Reporting Services (SSRS).
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard and using SSIS, MDS.
• Generated the weekly, monthly, and quarterly reports by using SSRS, MDS
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and, Cross Joins.
• Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
• Experience in defining Query for generating drill down reports in SSRS.
• Experience in Iterative and Incremental software development.
• Experience in installing, upgrading and configuring MS BI pack.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Good knowledge in database and Data warehousing concepts.
• Excellent skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Cursors, DDL/DML Triggers, Temporary tables, User Defined Data types (UDF) and Functions.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS.
• Worked on OLAP Data warehouses, Modeling, Design, cube development including KPIs, working with slowly changing dimensions.
• Experienced in creating Perspectives, Partitions, Roles and Groups, Design Aggregations, Key Performance Indicators (KPIs) in cubes, working with Multidimensional Expressions (MDX) using SSAS.
• Developed various business reports. Reports are provided in PDF-format, HTML-format, and can be printed directly to the specified printer.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Worked extensively in developing DTS packages in SQL server 2000
• Experience in defining Query for generating Cross-Tab, Conditional, Drill-down and Sub reports.
• Experienced in writing scripts for Automation Testing on QTP and Selenium.
• Provided 24x7 production support to Batch, continuous flow process for daily, monthly and weekly job schedule

TECHNICAL SKILLS:

RDBMS: MS SQL server 2005/2008/2008 R2/2012, MS Access.

SQL Server Tools: SQL Server Management Studio, BIDS (SSIS, SSAS, SSRS), SQL Azure SQL server, Server Query Analyzer, DBCC, BCP, SQL Server profiler.

BI Tools: SSIS, SSRS, SSAS, DTS, MDS

Languages: VB Script, T-SQL, HTML, XML, Java Script, C, C++, MDX

Operating System: Windows 95/2000/2003/ XP/VISTA, Windows NT/LINUX

Tools: ERWIN, MS Visio, Power View, QTP, Selenium

PROFESSIONAL EXPERIENCE:

Confidential, Sanjose, CA

Sr. SQL Server developer

Responsibilities:

• Designed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for Migrating the SSIS packages from 2005 to 2008
• Experienced in EDM / MDM using tools like ER Studio & MS MDS / DQS, Caching Technologies, Data ware housing, BI and ETL
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database which has to be displayed in various forms.
• Created many SSRS reports with lots of metrics on it using row grouping and column grouping
• Created various database objects such as tables, indexes and views based on the requirements.
• Scheduling SSRS, MDS jobs and production support.
• Created daily, weekly, monthly reports for various categories and hierarchies based on business needs using SSRS
• Create reports such as parameterized, cascading, drill through/Drill down reports, charts and specialized in producing sub reports using relational data warehouse and OLAP cubes.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and Modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Configured Checkpoints on SSIS packages so that the package would restart from the point of failure.
• Configured SQL mail agent for sending automatic emails when SSIS package fails or succeeds.
• Successfully deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created jobs using SQL Server Agent and scheduled them to execute the SSIS Packages on a predefined time interval by the business.
• Created C#.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc. in SSIS packages.
• Used the SSIS Configuration files to make the packages connections, variables etc. configurable and maintained the same on Test and Production environments.
• Generated Sub-Reports, drill down reports, drill through reports, Tabular Report and Parameterized reports using SSRS.
• Involved in the implementation of Performance Point Server (PPS).
• Developed various forms of outputs like RTF, HTML, PDF files using SAS ODS facility.
• Modified OLAP Cubes to add Dimensions, Creating User Defined Hierarchy, created new calculated members using MDX Expression as per the business requirement.
• Worked on Migrating from SQL Server 2008R2 to SQL Server 2012.

Environment:: SQL Server 2008R2/2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), SQL Server Data Tools 2010, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2010, Windows XP, MS Office 2007/2013, MS Access.

Confidential, Summit, NJ

Sr. SQL Server developer

Responsibilities:

• Modified the existing stored procedures to get the new functionality depending on the client requirement.
• Created many tables with the clusters and non-clustered indexes on columns.
• Created various database objects such as tables, indexes and views based on requirement.
• Created daily, weekly, monthly reports for various categories and hierarchies based on business needs using SSRS
• Create reports such as parameterized, cascading, drill through/Drill down reports, charts and specialized in producing sub reports using relational data warehouse and OLAP cubes.
• Strong experience in Master Data Services Configuration Manager, tool use to create and configure Master Data Services databases and web applications.
• Strong experience in web application and administrative tasks (like creating a model or business rule), and that users access to update data.
• Experience with MDSModelDeploy.exe, to create packages model objects and data to be deploy in other environments.
• Created many SSRS reports with lots of metrics on it using row grouping and column grouping
• Created table valued functions and used in the report stored procedures on the fly Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved in planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization mechanisms for SSAS and OLAP databases.
• Developed Drill-down/thru, sub-reports, linked and Dashboard reports using SSRS
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Involved in Processing QNXT Healthcare Claims
• Worked on the summary of clinical data like Demographic, Adverse Events, Serious Adverse Events, and Related Adverse Events leading to Discontinuation.

Environment: SQL server 2012, SQL server Management studio, SQL server integration services (SSIS), SQL server reporting services (SSRS),MDS, SQL server Analysis services (SSAS), SQL server profiler, Microsoft visual studio 2010, Team Foundation server (TFS)

Confidential, Minneapolis, Minnesota

Sr. SQL/BI Developer

Responsibilities:

• Worked closely with the business Analyst for understanding the requirement and also involved in planning and designing data based on business requirements.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension, Data Conversion, OLE DB command, Union All, Flat file Source, Flat file Destination, Conditional Split and more. Performed ETL mappings using MS SQL Server Integration Services.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Created package dependencies by calling Child packages within Parent.
• Configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeed.
• Successfully deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS). Developed Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
• Generated SSRS Report through SSIS Package using script component as per business requirement.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Created jobs using SQL Server Agent and scheduled them to execute the SSIS Packages on a predefined time interval by the business.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Documented all the project work in support for maintenance.

Environment:: SQL Server 2008/2008R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2008, Windows XP, MS Office 2003/2007, MS Access, MDS.

Confidential, Huston, TX

SQL server Developer

Responsibilities:

• Involved in Data mapping, logical data modeling, created ER diagrams and used SQL queries to filter data within the database.
• Actively involved as part of a team for gathering and analyzing the needs of end User Requirement and System Specification.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Created complex ETL strategies to extract, clean and deliver data to OLAP environment.
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
• Created Sub-Reports, ad-hoc reports, Drilldown-Reports, Summary reports, and Cross Tab reports.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users, Documented and maintained history of changes for future reference.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Created complex SSAS cubes to support business reporting with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler/Query Analyzer/SSMS.

Environment:: SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, XML and Windows Server 2003.

Confidential, Pune, Maharashtra

SQL Server Developer

Responsibilities:

• Actively participated in gathering Business Requirements that are focused on providing a user-friendly System usage or ambience.
• Created new database logically and physically designed to fit new business requirements.
• Created various database objects Tables, Indexes, Views, SQL Joins and Triggers
• Writing T-SQL queries, Views, Stored Procedures and User Defined Functions.
• Filtered bad data from legacy system using complex T-SQL statements, implemented various constraints, and triggers for data consistency.
• Used DBCC Utilities for Performance Tuning, Query Optimization and Client Server Connectivity & Database consistency checks.
• Planned the complete backup (with the suitable recovery model) of various Databases.
• Creates technical specifications, test plans and test data to support ETL processes
• Customers Insurance Policies were formatted for creating reports that are deliverable to the policy holders and the manager.
• Developed different types of tabular reports, matrix reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS.
• Created OLAP cubes using KPI’s for analyzing financial trends before and after company mergers and also created calculated members using MDX.

Environment: MS SQL Server 2005/2008, T-SQL, SSIS, SSAS, SSRS, Business Intelligence Development studio, Erwin, Windows 2003, Visual Studio.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate Consistency Data entry into the database.
• Created reports from database onto excel spread sheet using DTS.
• Wrote complex stored procedures to process employee requirement and generating records between front End and back end.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Experience in Data Modeling using Erwin Design Tool
• Created Users and Roles, and managed security and permission of database.
• Managed and resolved design issues during development
• Worked to establish connectivity between VB applications and MS SQL server by using ODBC

Environment: T-SQL, MS SQL Server 2000, SSMS, DTS, Erwin, Windows NT server, VB, Visual Basic.net