SUMMARY:

• Over 7 years of extensive experience in the IT industry as a SQL Developer in SQL Server 2012/2008R 2/2008/2005/2000 including 6+ years as Business Intelligence Developer (SSIS,SSRS,SSAS) and 1+ years as .Net Developer.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL queries, stored procedures, Indexes, CTE (Common Table Expressions) and triggers using SQL Servers to facilitate efficient data manipulation and data consistency.
• Experience across all phases of SDLC from project initiation to post-implementation.
• Excellent knowledge in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Expert in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Experience in ETL Processes. Worked extensively on data extraction, cleansing/data integration, and loading from different data source using SSIS.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, 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 warehouse.
• Experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.
• Strong experience in C#, VB.net, ASP.NET, Net frameworks 4.0/3.5/3.0/2.0/1.1 , Web Services, WCF, XAML, Win Forms, AJAX, ADO.NET, Windows Service, Generics.
• Strong experience in Web technologies such as HTML, JavaScript, XAML, XML/XSLT, CSS using .Net framework 4.0/3.5/3.0/2.0/1.1 .
• Extensive experience with OOAD and Service Oriented Architecture (SOA) complemented with excellent programming background using C#.
• Thorough knowledge with WPF, Model View Presenter (MVP), Model View Controller (MVC), MVC 2.0 and Model View View-Model (MVVM).
• Hands on experience with ASP.NET, AJAX, WPF, WCF, OO Design, Service Oriented .Net Enterprise Applications using Web Services.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experience in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning advisor, and Dynamic management views.
• Experienced in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Efficient in generating Tabular, parameterized reports, drill down, drill through, cascading parameterized, and matrix reports using SSRS 2012/2008R2/2005.
• Experienced in using global variables, expressions and functions for the reports.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experienced in sorting the data, defining data source and subtotals for the reports.
• Proficient in Installation, Configuration and migrating and upgrading of data from MS SQL Server and R2 and 2008r2 to 2012.
• Experienced in Cube designing in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Responsible for interacting with the client, understanding their requirements and implementing the necessary changes in the program.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

TECHNICAL SKILLS:

MS SQL Server 2012/2008/2005/2000 , MS SQL Server Integration Service (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Service (SSRS), T-SQL, PL-SQL, SQL Server Management studio (SSMS), MS SQL Server Index Tuning Wizard, SQL Profiler/Analyzer, Bulk Copy Program (BCP),Database Engine Tuning Advisor, SQL Agent, Service Manager, Visual Studio 2005/2008/2010 , ASP.NET, C#, Team Foundation Server(TFS), JavaScript, HTML, XML, MS Office (MS Visio, MS Word, MS Excel, MS PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential, Morristown, NJ

MS SQL Server Developer SSRS/SSIS/SSAS

Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Worked as a developer in creating Stored Procedures, triggers, function, tables, and other SQL joins and statements for applications.
• Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQL queries.
• Handled slowly changing dimensions to maintain the history of data.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Developed data access queries/programs using SQL Query to run in production on a regular basis.
• Created report snapshots to improve the performance of SSRS.
• Created report models for ad hoc reports when the end user wants to see the reports on the fly.
• Responsible for Monitoring and Tuning Report performance by analyzing the execution plan of the report.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Performed ETL process by pulling large volumes of data using SSIS, BCP into the staging database from various data sources like Access, Excel.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

Environment: MS SQL Server 2005/2008R2, SQL Server Integration Services 2008(SSIS), SQL Server Reporting Services 2008(SSRS), SQL Server Analysis Services 2008(SSAS), Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL, HTML.

Confidential, Houston, TX

SQL Server/SSRS/SSIS Developer

Responsibilities:

• Involved in planning, defining and designing data base using Erwin on business requirement and provided documentation
• Translating business requirements into technical design specifications
• Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server2005/2008
• Involved in building and maintaining SSIS Packages to import and export data from various data sources using BIDS based the design data models
• Applied various data transformations such slowly changing the dimensions, aggregates, sorting, multicasting, conditional split, and derived column
• Handled slowly changing dimensions to maintain the history of data
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints
• Wrote T-SQL queries, stored procedures, and used them to build packages
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008
• Created reports to retrieve data using Stored Procedures and parameterization
• Used SQL Server Reporting Services (SSRS) delivering enterprise, and Web-enabled reporting to create reports that drew content from a variety of data sources
• Generated sub-reports, drill down reports, drill-through reports and parameterized reports using SSRS
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored them in the script
• Used SQL Profiler TSQL Duration template for tracking execution time of TSQL Statements
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations
• Responsible for scheduling the SSIS packages and Jobs
• Played an active role in the development of a SQL Server maintenance plan, scheduling jobs, alerts, and troubleshooting
• Performed daily tasks including backup and restore by using SQL Server 2008 tools such as SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: MS SQL SERVER 2005, MS SQL Server 2008, SSIS, SSRS, DTS, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access, Oracle, Microsoft Visio, Erwin, MS Office 2003, Excel 2003, Oracle10g, Visual Studio 2005/2008/2010 , SQL profiler, Windows NT/2003, .NET framework 3.5, ASP.NET, C#, XML.

Confidential, Framingham, MA

MS SQL/SSRS Developer

Roles and Responsibilities

• Designed and developed ER diagrams (Physical and Logical using MS Visio) and mapping the data into database objects.
• Scheduled the reports to run on a daily and weekly basis in Report Manager and then provided them to the analysts to review in Excel Spread Sheet
• Expertise in developing advanced reports with functions, formulae, parameterized reports, sub reports, summary reports, cross tabs, ranking and conditional formatting.
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Involved in creating various scripts to load the data to and from production servers to the development servers.
• Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services, SQL Profiler, Query Analyzer, MS Office