SUMMARY

• Over 8 years of experience in Database Design and Development as MS SQL Server 2008/2012/2014 Database/ ETL/Warehouse Developer in Windows environment.
• Excellent knowledge in creating Databases, Tables, StoredProcedure, SQLJoins, DDL/DMLTriggers,Views, User defined data types,CursorsandIndexesusingT - SQL.
• In-depth knowledge on SQL Server, SSIS, OLAP, OLTP, Reporting services.
• Experience in supporting huge databases, troubleshooting problems, and documenting root cause analysis.
• Implemented and maintained database security by creating and maintaining users, roles and assigning privileges. Involved in Database tuning and performance monitoring.
• Knowledge of T-SQL to perform batch processing and implement business logics into backend. Hands on experience in Querying Data, Formatting Result Sets, Modifying Data and Worked on Transactions.
• Created and designed various database objects and elements like tables, joins, views, stored procedures, triggers, indexes and partitions.
• Extensive experience in creating Clustered, Non-Clustered, Covered indexes and indexed views.
• Extensive experience in Working with SQL Server Agent Jobs, Monitoring and Troubleshooting SQL Server Performance, Performance Tuning, Maintaining Database Snapshots.
• Experience in Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS - Sequel Server Integration Services).
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations and involved in package configurations and deployment process.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS).
• In-depth knowledge about Extracting and Loading Data, Using Data Flow Transformations, Managing Control Flow, Scripting Tasks, Debugging Packages and Managing Package Execution.
• Domain expertise in Finance Applications, Health care applications and Retail applications.
• Exceptional leader with excellent interpersonal skill, communication finesse and Team management skill with strong expertise in analyzing the requirements and preparing the specifications document based on the requirements.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2008/2008 R2, MS-SQL Server 2012, MS Access and Excel.

Database Technologies/Tools: SQL Server Management Studio, T-SQL, Data Transformation Services (DTS), Business Intelligence Studio, Query Analyzer, Performance Monitor, OLTP, OLAP, Sequel Sever Integration Services(SSIS), Sequel Server Reporting Services (SSRS)

Microsoft Tool: MS POWER BI

Operating Systems: Windows 2008/2000/XP/Vista/7, MS-DOS, Unix

Software Development Methodologies: Agile Methodology, Waterfall Methodology, Software Development Life Cycle (SDLC)

Applications: OLAP,OLTP, HTML, XML, Visual Studio

Microsoft Tools: MS Office Suite, Word, Excel, Access, PowerPoint, Outlook

Testing Tools: Quality Center, Selenium

Languages: T-SQL, SQL, MDX, C#, ASP (.NET), XML, JavaScript, Html

Database Design tools and Data Modelling: ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Kimball & Inmon Methodologies, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Langhorne, PA

SQL/BI Developer

Responsibilities:

• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. To generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Extracted data from XML to SQL server.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Created complex queries to automate data profiling process needed to define the structure of the pre-staging and staging area.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Generated reports using SQL Server Reporting Services 2014 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Designed ER diagrams and mapped the data into database objects
• Experience in developing and extending OLAP Cubes, dimensions and data source views.
• SSAS storage and partitions, aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL
• Built reports for the analysis services using SQL Analysis services 2014 using different reporting tools
• Developed different types of tabular reports, matrix reports (cross tab or pivot) reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services
• Developed both the drill down and drill through reports
• Designed reports with grouping/sorting and parameters (including multi-value parameters) using SQL server reporting services
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications. Provided knowledge transfer to the company’s SQL programmers.
• Created several materialized views and UDF’s to be accessed by the new front-end applications.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.

Environment: SQL Server 2014/2012,SSIS,SSRS, MS 2003, SharePoint, C#, Visual Studio 20015 & 2013.

Confidential, Cranbury, NJ

SQL/BI Developer

Responsibilities:

• Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Experienced in slowly changing dimension in SSIS packages. Performed incremental data load packages in SSIS.
• Developed, monitored and deployed SSIS packages. Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• Generated multiple Enterprise reports (SSRS/Crystal) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP)..
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.

Environment: SQL Server 2008 R2/2012,SSIS,SSRS, MS 2003, SharePoint, PL/SQL, C#, Visual Studio 2008 & 2013.

Confidential, Los Angeles, CA

SQL/BI Developer

Responsibilities:

• Understanding the report design Requirements and Constraints.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate useful indexes.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity of data.
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all, Script component, etc.
• Providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Used Report Designer as well as Report Builder for report creation using Microsoft Reporting Services (SSRS).
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Promoted RDLs to Reporting Service Server (SSRS).
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis(SSAS) and used the SSAS as source for generating parameterized reports in SSRS.
• Used ROLAP tools to access the data in arelational database and generateSQLqueries to calculate information at the appropriate level when an end user requests it.
• Created SSIS Packages to pull data from Online Database Server to Data-warehouse Server.
• Performed administration tasks of Database Mirroring, database backups and restore servers in SQL Server 2005.

Environment: SQL Server 2008 R2/2012,SSIS,SSRS, MS 2003, SharePoint, PL/SQL, C#, Visual Studio 2008 & 2013.

Confidential, Tampa, FL

MS SQL Server-BI Developer

Responsibilities:

• Created Configurations to make package portable and created Event handlers for handling package error.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 asSSISPackages.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Designed Cubes with star schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
• Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Tuning SQL query for better performance using SQL Profiler.

Environment: Windows server 2008, MS SQL Server 2012/2008R2, SQL Server Management Studio, SQL Profiler, SQL Server 2012, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services(SSAS), AS400.

Confidential

SQL/BI Developer

Responsibilities:

• Understanding the Business requirements and Created new database objects like stored procedures
• Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well-documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Involving in creating packages in SSIS Designer using various Control Flow Tasks and Data Flow Transformations to implement Business Rules
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Wrote stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various tabular, matrix, drill-through reports, parameterized reports and linked reports using SSRS.

Environment: Data Transformation Services (DTS), SQL Server 2008, ODBC, BIDS, Business Objects, XML, SSIS, T-SQL.

Confidential

SQL Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram.
• Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes).
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.

Environment: SQL Server 2005/2008, Query Analyzer, SQL Profiler.