SUMMARY:

• Over 7 years of SQL Server Development experience in SQL 2005/2008/2012 with an emphasis on design, development, automation, tuning, optimization, Performance and Security.
• Extensive experience in SQL Server 2012/2008/2005, Business Intelligence tools - SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , and SQL Server Analysis Services SSAS .
• Highly proficient in constructing Triggers, Tables, stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity using T- SQL.
• Extensive knowledge of Normalization and Relational Database Management Systems. Experienced in supporting web based, mission critical applications including Logical and Physical Database Design, Development and Performance Tuning.
• Handled different types of encryption and decryptions in SQL as per client requirements to secure data.
• Experienced in migrating Data from Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services SSIS , BCP and DTS utility. Expert in Creating, Configuring and Fine-tuning ETL workflows in SSIS.
• Experienced in Designing, maintaining and building Cubes, Dimensions, and Data source views, data mining Models, Deployment and Processing using SSAS. Proficient in writing MDX queries and use Client tools like Excel to provide visualizations on Multidimensional or Tabular model Cube data.
• Created stored procedures for generating reports using SQL Server Reporting Services SSRS , Crystal Reports. Good command in generating on demand and scheduled reports for business Analysis and Management decisions using SSRS 2012/2008/2005.
• Experienced in writing expressions and fine tuning reports. Created many Drill through, Sub, Parameterized and Drill Down reports using SSRS.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.
• Efficiently helped in Software Development Life Cycle SDLC processes including Analysis, Design, Development, Testing and Implementation.
• Experienced in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.
• Experienced in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling SQL Server Agent Jobs
• Very good communication and interpersonal skills desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS:

• Operating Systems: Microsoft Windows XP/2008/2003/2000/NT, DOS.
• Languages: C, C , T-SQL, SQL, PL/SQL, ADO.NET, ASP.NET, HTML, XML.
• Tools: SQL Server Management Studio, Enterprise Manager, SSIS, SSAS, SSRS, Business Intelligence Development Studio.
• Utility: SQL Profiler, Query Analyzer, Windows Performance Monitor, Data Base Engine Tuning Advisor.
• Database: MS SQL Server 2012/ 2008 R2, /2005//7.0,MySQL, MS Access 2007.

Confidential

Sr. MS SQL Server SSIS/SSRS /ETL Developer

Responsibilities:

• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS packages.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on different kinds of Transformations in SSIS like Slowly changing dimension SCD's , Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as per the client requirement.
• Implemented Logging and Event Handlers on SSIS packages for trouble shooting.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services SSRS with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2012.
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for monthly Statements.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services SSRS .
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS .
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005 SSAS
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems response delay, locking, server down time, etc to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C .NET, ProClarity Analysis.

Confidential

Sr. MS SQL Server SSIS/SSRS /ETL Developer

Responsibilities:

• Involved in Normalization of the database and bringing it to 3NF.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Created SSIS Packages to migrate slowly changing dimensions.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005 SSAS
• Highly responsible for development and management of PPS, SSAS, SSRS and SSIS projects.
• Building KPI reports for the cubes and optimizing the reports.
• Involved in partitioning of cubes in order to increase the performance of cubes SSAS .
• Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services SSRS with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Created complex reports which involve more number of groupings and multi-value parameters
• Using Sql server reporting services SSRS delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Design and create report models based on users' requirements, explain and train users to use report builder to generate their own personalized reports.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS .
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services SSRS .
• Rendered the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Worked on Logical and physical database development using ER-win, Normalization, Dimension modeling and Enterprise manager .

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C .NET, ProClarity Analysis.

Confidential

SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Designed packages using Transformations Sort, Merge, Merge Join, Union, Union ALL, Lookup, Aggregate, OLE DB Command and Derived Column.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Developed forms on share-point to show data from data-sources to Clients and enabling them to edit the data and update the data in the data-sources and allowing inserting data into the data-sources.
• Created reports on to Share-Point and Report Server and set the data-driven subscriptions for these reports.
• Deployed generated reports of each quarter onto the Report Server to access it through browser.
• Designed and developed Data Warehouses, Data marts using Multi-dimensional models such as Star Schema and Snow Flake Schema for developing cubes.
• Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star Schema structure.
• Created a cube and enable write back to write to cube using excel 2010.
• Created Write back functionality in SSAS to write the data back into the cube to make changes to the data those changes return back in to the cube.
• Maintained the consistency of data by performing Data Profiling and Data Cleansing.
• Involved in developing Life Cycle using Agile Methodology.
• Created the documents and packages in Team Foundation Server as a version control.

Environment SQL Server 2008/2005, T-SQL, SSIS, SSAS, XML, MS Excel, MS Access, .Net, Visual Studio,

Share-Point, C , TFS

Confidential

SQL Server BI Developer

Responsibilities:

• Generated Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps using SSRS.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS .
• Managed Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Generated Sub-Reports, Drill down-Reports, Summary Reports, and Parameterized Reports in SSRS.
• 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 2005.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Developed custom selection of reports ordering using SQL Server Reporting Services SSRS .
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Deployed reports in to Report Manager.
• Created Ad-Hoc reports using Report Builder.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services SSRS to schedule reports to be generated on predetermined time.

Environment MS SQL Server 2008R2, 2008/2005 SSIS, SSRS, SSAS, Visual Studio 2008, T- SQL, Windows Server 2008 R2, Visual Source Safe 2005 VSS , XML, ADO.NET, ERWIN, PL/SQL, MS-Access, MS-Excel

SQL Server /SSIS

Confidential

Responsibilities

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Wrote Ad-Hoc T-SQL queries for analysis purposes.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS-DTS packages for executing the required ETL tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spread sheet using DTS.
• DTS Packages are created to export and import data from CSV files, text files and Excel files.
• Involved in creating maintenance plans in SQL Agent to back up the database.
• Worked with development teams in the design of physical databases and in modification.

Environment SQL Server 2000/7.0, Windows 2000 Server, SQL Profiler, DTS, T-SQL, BCP, System monitor/Performance Monitor, Query Analyzer.