SUMMARY

• Over 8 years of strong experience in the IT industry as a MS SQL Server Developer include experience in design, development, implementation and administration of database systems using MS - SQL Server 2012/2008R 2/2008/2005/2000 for both OLTP & Data Warehousing Systems applications with various business domains like Financial, pharmaceutical and manufacturing.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Good knowledge of System Development Life Cycle (SDLC).
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS).
• Excellent knowledge in creating Databases, Tables, DDL/DML Triggers, User defined data types, Cursors and Indexes using T-SQL.
• Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Having good knowledge in developing OLAP Cubes using SQL server Analysis services (SSAS) through MDX queries.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad hoc and Sub Reports.
• Experience in Performance Tuning and Query Optimization.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Used MDX to interact with the back end OLAP Services.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Expert in Scheduling Jobs and Alerts using SQL Server Integration Services.
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.

TECHNICAL SKILLS

RDBMS/DBM: MS SQL Server 2012/2008 R2/2008/2005, MS Visual Studio, SQL Server Profiler, SQL Query Analyzer, MS Access.

Web Technologies: HTML and XML

Operating Systems: Windows server 2008/2003, Windows 7, Windows Vista, Windows XP, and UNIX.

Application Tools: MS office, MS Project, Enterprise Manager, Rally, Red Gate, Share Point Designer.

Data Modeling Tools: Erwin, Microsoft Visio and ER Studio.

Languages: C and SQL

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sql Server BI Developer(SSIS/SSRS)

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Written dynamic SQL scripts in SQL server management studio (SSMS).
• Used Try catch block, Merge and Common table expressions in T-SQL.
• Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.
• Designed and developed efficient SSIS packages for processing fact and dimension tableswith complex transformation logic
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsiblefor ETL job scheduled to run daily. Solved the issues associated with ETL Data WarehouseFailure
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAPwith the help of SSIS.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments.
• Used Script Component and Script task to implement custom code using VB.Net in Sql Server Integration Services(SSIS).
• Created complex SSIS packages with logging and Error handling using Event Handlers, Variables and execute sql tasks.
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• Designed SSRS reports using different data regions like Table, Matrix, List, Sub-reports and Charts. Created Drill down and drill through reports for easy navigation with in the reports.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Created Subscriptions and Data-Driven Subscriptions on report manager to automate the generation of SSRS reports.
• Improved performance of Slow running SSRS reports using System tables in
• Reportserverdb and made necessary changes to the code and RDL.
• Worked on Production tickets with Agile-Scrum, Waterfall Methodology.

Environment: SQL Server 2012/2008 R2, BIDS 2008 R2, T-SQL, MS SQL Server Reporting Services, MS SQL Server Integration Services, Share point 2010.

Confidential, Herndon, VA

MS SQL Server SSRS/SSIS Developer

Responsibilities:

• Created logical and physical database design, data structures, and implemented databases using Erwin.
• Analyzed business recovery requirements and maintained strategies and plans for critical databases.
• Developed, designed and documented tables, view, stored procedures, advanced queries, triggers, indexes and functions.
• Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
• Improved performance of slow running queries and Stored procedures using Execution Plan and Sql Profiler.
• Created different type of SSRS reports including Cross-tab, Conditional, and Drill-down, OLAP and Sub reports.
• Experience in building reports through REPORT BUILDER and REPORT DESIGNER.
• Experience in creating reports using REPORT MODEL and applying row level security filters.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Involved in designing ETL(SSIS) as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Deployed and scheduled SSIS package to run Daily, Weekly and Monthly jobs using Sql Server Agent.

Environment: SQL Server 2008 Enterprise Edition, OLTP, ETL, MS Visual Studio, T-SQL, SSRS, SSIS and Visio.

Confidential, Alexandria, VA

MS SQL Server SSIS/SSAS Developer

Responsibilities:

• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2005 Analysis Services.
• Querying and manipulating multidimensional cube data through MDX Scripting (SSAS).
• Experience in writing MDX queries to add calculated members and measure groups.
• Worked on Multidimensional Expressions (MDX) to query multidimensional data or to create MDX expressions for use within a cube.
• Involved in partitioning of cubes in order to increase the performance of cubes (SSAS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad-hoc reports (SSRS).
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Worked on PERFORMANCE POINT SERVER to build advanced KPI’s for the cubes
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports.
• Have deployed packages on different servers by configuring it.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of T-sql and MDX queries.
• Worked with development teams in the design of physical databases and in modification.
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.

Environment: Microsoft Windows 2007 Advanced Server, Microsoft SQL Server 2005 and 2008, SSIS, SSAS, SSRS, SQL Lite Speed, OLAP.

Confidential, Philadelphia, PA

SQL Server BI Developer

Responsibilities:

• Worked closely with Business Analysts and data modelers in design of logical and physical design.
• Written T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers in SQL server management studio (SSMS).
• Used Try catch block, Merge and Common table expressions in T-sql.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Created different type of reports including Cross-tab, Conditional, and Drill-down, OLAP and Sub reports.
• Have deployed packages on different servers by using Package configurations.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Worked with development teams in the design of physical databases and in modification.
• Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.

Environment: Microsoft Windows 2003 Advanced Server, Microsoft SQL Server 2008 and 2008(R2), SSIS, SSAS, SSRS, OLAP.

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Expert in extracting data using SSIS from OLTP to OLAP.
• Performed Bulk data migration using DTS and SSIS from flat files.
• Designed and optimized all the SSIS packages.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Designed and implemented stylish report layouts.
• Identified and defined the Datasets for report generation and also included report parameters.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Implemented full and differential backups and also created and managed DB objects.
• Make recommendations for File group Creation and Placement.
• Scheduling backups and automating weekend maintenance tasks.
• Created users and roles for login authentication and validating permissions.
• Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.

Environment: MS SQL Server 2005/2000, T-SQL, MS Integration, Analysis and Reporting Services, Query Analyzer, Windows 2003 Server.