SUMMARY

• Over 8+ 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 SQLServer 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, SSRSBusiness Intelligence Development Studio, Tableau.

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.

PROFESSIONAL EXPERIENCE

Confidential - Dublin,OH

Sr. SQL Server SSRS/SSIS Developer

Responsibilities:

• Prepared the complete data mapping for all the migrated jobs using SSIS
• Responsible for creating and designing SSIS package
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Use different control flow control like for each loop container, sequence container, execute SQL task, send email task
• Use package configuration to migrate SSIS package from one environment to other
• Use event handing to send e-mail on error events at the time of transformation
• Use login feature for analysis purpose
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
• Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups.
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Involved In writing Complex T-SQL Queries.
• Backing up master & system databases and restoring them.
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
• Involved in testing and debugging stored procedures.
• Designed, built and tested SSAS Cubes on SQL Server.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Process thecubes (SSAS), partitions as and when required.
• Writing the DAX statements for Cube
• Designing Visualizations in Tableau 9.2

Environment: MS SQL Server 2008/2012, SSIS, SSAS, TFS, Windows 2003/2008,Deployment Wizard, Visual Studio 2010, MS Excel 2007,Tableau,C#, ASP .Net

Confidential, Yardley, PA

SQL Server/T-SQL Developer

Responsibilities:

• Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
• Created SSIS packages to migrate the existing DTS packages.
• Scheduled and Maintained Multiple SSIS packages.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008/2012 (using SSRS, T-SQL, scripts, stored procedures and views)
• Designed ETL packages for different data sources (Excel, SQL Server, and Flat Files). Created indexes for the fast retrieval of data from the database.
• Create SSRS reports against Team Foundation Sever Database.
• Deployed SSRS reports using report server and TFS.
• Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups.
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Wrote customized Team foundation reports according to the companies’ customized workflow.
• Used SQL Server Reporting Services to generate different types of Ad-hoc Reports.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Involved In writing Complex T-SQL Queries.
• Backing up master & system databases and restoring them.
• Worked on Query Optimization through query Analysis and Index Optimization.
• Actively involved Normalization & DE normalization of database.
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
• Involved in testing and debugging stored procedures.

Environment: MS SQL Server 2005/2008/2012, SSIS, SSRS, TFS, Windows 2003/2008,SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle10g, 11g,Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net,ASP.NET, PowerShell Scripting, Visual Studio 2005, MS Access, Crystal Reports, MS Excel 2007.

Confidential, Jersey City,NJ

MS SQL Server/ SSRS /SSIS/SSAS Developer

Responsibilities:

• Created complex StoredProcedures, tables, views and other SQL joins and statements for applications by using T-SQL.
• Performance tuning, and optimization of procedures and queries.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Extensively created new reports and modified existing reports using SRSS
• Excellent report creation skills using Microsoft Reporting Services (SSRS). Extensively used SQL Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts based on the financial data; Wrote queries to generate reports for analysis of data; Used table control, matrix control to create cross tab reports; handled sub reports and defined query for generating drill down reports in SSRS.
• Extensively used T-SQL in creating and altering stored procedures, functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Writing reports using Microsoft Reporting Services (SSRS)
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packagesto runsequentially using SQL Server Agent job.
• Designed, built and tested SSAS Cubes on SQL Server 2005.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Process thecubes (SSAS), partitions as and when required.
• Enhanced performance using optimization techniques: normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Worked with development teams in the design of physical databases and in modification.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created packages in SSIS with error handling.
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Worked with different methods of logging in SSIS and advanced data mapping.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Have deployed packages on different servers by configuring it.
• Installed and configured SQL Server 2008/2005 in Test environment with latest service packs and migrated few databases.
• Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
• Implemented computational sensitive queries Stored Procedures.
• 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 queries.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Involved in migration from SQL Server 2000 to SQL Server 2005.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Written DDL / DML Triggers as per company policy.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Experience in installation, un-attended deployments, configuration and administration of Windows NT, 2000 and 2003 servers in very large environments.

Environment: MSSQL Server 2008 R2/2008/2005, SQL Server SSAS/SSRS/SSIS, MDX Cubes, OLAP,Microsoft Windows 2003 Advanced Server, ASP.NET, C#, ETL, Enterprise Edition, Microsoft Visual Basic 6.0, SQL LiteSpeed, OLAP.

Confidential, Little Rock, AR

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, Irvine, CA

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 StudioShare-Point, C#, TFS

Confidential, San Jose, CA

MS BI Developer

Responsibilities:

• Analyzing the FTA’s and the business requirements and building logical and physical data models.
• Creating high level design of the ETL process and data mapping.
• Creating three step ETL process to get the files from the server and load the data into database.
• Designing several ETL processes to Load data from Text or Excel Files
• Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Designing of SSIS Packages to get data files fromFTPandSFTPServer and decrypting thePGPfiles,batch processingof incoming data and purging of old files
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• 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)
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2005.
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multidimensional model.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Worked with different methods of Logging in SSIS.
• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created complex Stored Procedures to validate and process the incoming data.
• Generating Validation Reports to notify the client with the invalid data received.
• Used C# to merge multiple XML reports, convertXMLto HTML format usingXSLTfiles and sending Validation Report emails.
• WrittenPower shell scriptsto purge files
• Understanding of existing DTS packages and redesigning them into SSIS packages and facilitate batch processing
• Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files
• Scheduling execution of ETL Packages using SQL Server Agent.
• Creating detail design documentation of the packages and creating release notes for each installs.

Environment: SQLServer2008, Oracle, MS Access, Excel, Windows Server 2008, IIS, Visual Source Safe, Share point Server, Cold Fusion, Net Frame Work, ADO.Net, VB.Net, ASP.Net, XML Parsing, VB6, VB Script, Java Script and C#, SSAS, SSRS, SSIS, MDX Cubes.

SQL Server /SSIS Developer

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.