Professional Summary:

• MS SQL Server Developer over 8 years of strong experience in various domains like Financial, Healthcare, Retail and insurance with expertise in MS SQL Server 2012/2008R2/2008/2005/2000 and SSIS, SSRS, SSAS.
• Worked on the entire software development life cycle SDLC including analysis, design, programming, testing and documentation.
• Proficient in installing, configuring, managing, monitoring and troubleshooting MS SQL Server 2012/2008/2008R2/2005.
• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Strong MS SQL Server 2012/2008/2008R2/2005 Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.
• Expert in Microsoft Business Intelligent Studio 2010/2008 SSIS/SSRS/SSAS .
• In-depth knowledge of T-SQL, SQL DDL, DML, and DCL .
• Extensive experience in Migration of data from Oracle, DB2, and Sybase to MS SQL Server.
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services SSIS .
• Experienced in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Mastery in extracting and transforming transactional information using DTS Import/Export wizard, BCP Bulk Copy Program DTS Data Transformation Services and SSIS Packages from SQL Server.
• Good understanding in Database Backup, Recovery and highly experienced in investigating and applying necessary MS SQL Server database Service packs, hot fixes and Security Patches.
• Expert in developing and modifying multi-dimensional cubes using MS SQL Server Analysis Services SSAS .
• Expert in Microsoft Business Intelligence Studio 2010/2008 SSIS/SSRS/SSAS .
• Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
• Defined and administered database standards, controls, procedures and documented the same.
• Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support.

Business Skills / Technical Skills:

MSSQLServer 2012/2008R2/2008/2005/2000, Visual studio 2010/2008 SSIS/SSRS/SSAS , Microsoft Access 2007/2003, Microsoft Excel, Outlook, MS SQL Profiler, SQL Server Query Analyzer, IndexTuningWizard, ASP.NetFrameWork 2.0, C , Oracle, DB2, Crystal report, Erwin8/7.3/3.5,Windows 2007/2005 Advanced Server/Professional, Windows XP, MS Access, Java, My SQL, HTML, CSS.

Professional Experience:

Confidential

Role: SQL Server TSQL/SSIS Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Tools Technologies:

MS SQL Server 2012, 2008R2, T-SQL, SSIS 2008 ,SSRS 2008, TFS 2010, Advanced Server, SSMS , Erwin v7.2, ASP.Net, C .

Confidential

Role: SQL Server TSQL/SSIS/SSRS

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Designed and developed web based ecommerce application.
• Worked with Oracle Server to extract, load information of Customers.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Wrote standard complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Accountable for Backup and Recovery Strategy and Planning.
• Created ETL packages with different data sources SQLServer, Flat files, Excel source files, Oracle and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension SCD , Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Used Packages by testing and cleaning the Standardized Data by using tools in Data.
• Data flow Transformations Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more for existing and new packages.
• Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008R2.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2.
• Generated daily, weekly and monthly reports for the managers.
• Used sub reports functionality for complex report calculations.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Responsible for database tuning using normalization and application tuning.
• Documentation for all kinds of reports and SSIS packages.

Tools Technologies:

MS SQL Server 2008 R2, T-SQL, SQL server Integration service 2008r2, SQL Server Reporting Service 2008 R2, Erwin7.3, Query Analyzer, Index Tuning Wizard, and SQL Profiler Windows Server 2003.

Confidential

Role: SQL Server T-SQL Developer/SSRS/SSIS/SSAS/DBA

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Generated Performance reports on SSIS packages, Stored Procedures and Triggers.
• Created OLAP cubes using SSAS to analyze the business condition of the sales.
• Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
• Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2005.
• Formatted reports for various Output formats as requested by the management using SSRS.
• Actively supported business users for changes in reports as and when required using SSRS.
• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.

Tools Technologies:

MS SQL Server 2005, MS Analysis Services 2005,Erwin,MS SQL Reporting Services, T-SQL, Crystal Reports, Windows XP, Query analyzer, SQL Profiler, MS Excel.

Confidential

Role: MS SQL Developer/ SSRS, SSIS Developer

Responsibilities:

• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in given period.
• Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports using Global Variables, Expressions and Functions using SSRS 2008.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Wrote T-SQL queries, created dynamic Stored Procedures by using input values.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Applied monthly patches and hot fixes.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
• 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.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Using ETL to build the required data mart.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Tools Technologies:

MS SQL server 2008, SSRS, SQL Profiler and T-SQL, Windows 2003 server, and Visual Studio 2005, Microsoft Office, Index Tuning Wizard, Query Analyzer, SQL profiler.

Confidential

Role: SQL Server Developer/ SSIS Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Designed database, tables and views structure for the new data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005 using SSIS Packages.
• Generated ETL packages with different data sources and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension SCD , Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Performed unit testing and SQL performance tuning.
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.

Tools Technologies:

SQL Server 2005, SSIS, Windows 2003 server, MS Access, Excel, Erwin