Summary

• Over 7 years of extensive experience in the IT industry as a SQL Developer in SQL Server 2012/2008R2/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 2000 to 2005 and 2008 to 2008 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 Accomplishments:

Confidential

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

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

MS SQL/SSRS Developer

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 incorporate 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.

Confidential

MS SQL Server Developer SSRS/SSIS/SSAS

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• 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 .
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Actively supported business users for change requests.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Identified and added the report parameters.
• Uploaded reports on to the report manager and organized them in folders.
• Delivered the reports using 'pulled' and 'pushed' methodologies.
• Formatted the reports using the Global variables and expressions.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed the generated reports on to the server.
• Fine tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2008 Query Analyzer, SSIS, SQL Profiler , MS SQL Reporting Services 2005, ASP.Net, MS Excel, Window XP.

Confidential

SQL Server/Dot Net Developer

Responsibilities

• Extensively worked on SQL, ASP.NET and C .
• Involved in Analysis, code development, code review, testing, bug-fixing, preparation of program specifications and unit test plans, production support.
• Analyzed and Prepared the Software Required Specification of the programs.
• Designed and documented Functional and Technical documents using MS Visio.
• Worked as a developer in creating different data object like Functions, Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in deployment, trouble shooting, problem solving and complete application support.
• Responsible for interacting with the client, understanding their requirements and implementing the necessary changes in the program

Environment: ASP.Net, VB.Net, ADO.Net, SQL Server 2005, Visual Studio .Net, Visual SourceSafe, IIS, Windows.