PROFESSIONAL SUMMARY:

• 7 years of Strong experience in IT Industry as SQL Server Developer Administrator in Finance, Healthcare and Insurance domains
• Highly experienced in MS SQL Server 2008 R with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
• Expert in creating traditional as well as Web - based interactive reports using SSRS.
• Highly experienced in creating complex Views, Stores Procedures, DDL DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Experienced with SQL Server and T-SQL in constructing triggers, tables, user defined functions, views, indexes, user profiles and relational database models with data integrity.
• Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Experienced in developing and modifying cubes and dimensions in cubes using SSAS.
• Experienced in working with MDX queries using SSAS.
• Extensively performed database administration tasks: Installing, Configuring, Managing, Monitoring and Troubleshooting MS SQL Server R2 on Windows NT 2008 servers.
• Skilled in developing Data Warehouses, Data marts using Star Schemas and Snow Flake Schema.
• Experienced in creating reports using SQL Server Reporting Services sourcing OLAP cubes and data warehouse, data marts as well as transactional systems.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities and an extremely diligent strong team player with an ability to take new roles.
• Experience with MS SQL server 2012 and created database objects such as tables, views, stored procedures, functions and triggers.
• Created database schemas to organize tables into the different folder.
• Design, code and test new Windows and web software applications.
• Performed application vulnerability assessments
• Performed code review across a variety of programming languages

TECHNICAL SKILLSET:

MS SQL Server, SQL Server Integration Services SSIS, SQL Server Reporting Services SSRS, SQL Server Analysis Services SSAS, MDM, SQL Server Management Studio SSMS, Visual Studio 2010, Import Export Wizard, DB2, MS-Access, Sybase, C, PL SQL, T SQL, Asp.net, C, Microsoft CRM 4.0, Java Script, VB Script, XML, HTML, Microsoft Visio 2007, ERWIN, Windows NT 4.0 XP Vista, Windows Server

PROJECT SUMMARY:

Confidential

Sr. MS SQL/BI Developer

Confidential sells 13 major lines of insurance, including auto, property, life and commercial. All state is widely known through the you are in good hands with Allstate slogan .All State also offers retirement and investment products and banking services. The projects aimed at Upgrading from SQL Server 2008 to SQL Server 2012 and support the Production Server.

Responsibilities:

• Performed Migration of SQL Server 2008 to SQL Server 2012.
• Generated Logical and Physical Data Models using Erwin.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions by writing complex queries and joins.
• Migrated Stored Procedures from 2005 to SQL Server 2008 to refer to Dynamic Management Views.
• Created and Deployed of Ad-hoc and Customized Reports to satisfy business needs using SSRS.
• Created SSIS Packages to ETL Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Developed menu and functions for Oracle Enterprise Manager.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services SSRS .
• Created database schemas and organized tables, views and stored procedures into multiple schemas.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Maintained all the SQL documents include installation and data conversion Procedure documents.
• Monitored Indexes, file growths and analyzed blocking locking issues to remove the performance bottlenecks
• Utilize established development tools, guidelines and conventions including but not limited to ASP.NET, SQL Server, HTML, CSS, JavaScript, and C /VB.NET
• Maintain existing software systems by identifying and correcting software defects.

Tools and Technologies: MS SQL Server 2008 R2, ER-WIN, windows platform, T-SQL, Excel, DB2, Access, Crystal Reports 9.0 and Windows NT, DTS, SSIS 2012, SSRS 2012, Asp.net, C .

Confidential

Sr. MS SQL/BI Developer

Confidential a part of the U.S. Department of Health and Human Services, is the nation's medical research agency making important discoveries that improve health and save lives. The objective of the project was to design physical and logical models with the help of ETL tool and to transfer data from different sources like text files, flat files, Oracle, excel and access to MS SQL server 2012 using SSIS 2012 and build the SSAS Cube for the Analysis.

Responsibilities

• Extracted the data from Oracle, Flat Files, Transformed Implemented required Business Logic and Loaded into the target Data warehouse using SSIS SQL Server 2005 .
• Installed MS SQL Server 2008 and Management tools using MS SQL Server Setup Program. Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. SSIS on MS SQL Server 2008.
• Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules.
• Created complex reports using Gathered requirements from the business users, created technical specification documents.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2008.
• Used SQL Server Analysis Services SSAS 2008.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes SSRS 2008 from the OLAP cubes for end user analysis.
• Created reports using complex MDX queries as per requirements.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2008 using data from a variety of sources.

Tools and Technologies: MS SQL Server 2012, SSRS 2012, SSIS 2008/2012, SSAS 2012SSMS, T-SQL, DB2, Oracle, Access, Excel

Confidential

MS SQL/BI Developer

Confidential is a world-leading financial services company, advising clients in all aspects of finance, around the world. Bank is organized into three divisions Investment Banking, Private Banking, and Asset Management. The scope of the project was to create various reports as per user requirement, creation of SSIS packages for transforming data and put it into staging area and maintaining OLAP cube.

Responsibilities:

• Based on business requirements, developed the complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger to implement the business rules and transformations.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Connected various applications to the database.
• Created databases and schema objects including tables, indexes, views and applied constraints.
• Created reports from complex SQL queries and MDX queries.
• Created and implemented the staging database prior to the final data warehouse.
• Involved in Migration of different DTS packages to SSIS packages.
• Expert in FTP task, ETL script task, look up transformation and data flow tasks to load staging databases.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
• Created and scheduled SSIS packages to load the data form OLTP source system to data staging environment and then to data warehouse environment.
• Designed the SSIS Package for the Scheduling the task for the different operations like extracting the data, to perform appropriate transformation and Loading purposes.
• Involved in the performance tuning for the OLAP Cube.
• Worked with SharePoint Server 2007 while deploying SSRS reports.
• Performed daily tasks including backup and restore by using SQL server 2005/2008 tools.
• Responsible for maintaining UAT User Acceptance Testing and Production environment.

Tools and Technologies: MS SQL Server 2000/2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, SQL Server Analysis Services 2005, Windows XP, Excel, Acrobat Reader, Microsoft Office SharePoint Server.

Confidential

MS SQL/BI Developer

Confidential is among the largest global providers of insurance, annuities, and employee benefit programs, with 90 million customers in over 60 countries The project involved data analyzing of different products like life insurance, retirement planning, dental insurance, long term care insurance, mutual funds, disability income insurance, home insurance, banking and financial insurance etc. and deploying OLAP .

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• 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.
• Analyzed database performance with SQL Profiler and Optimized indexes to improve query performance.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio BIDS
• Extracted the data from Flat Files, Transformed Implemented required Business Logic and Loaded into the target Data warehouse using SSIS SQL Server 2005
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel.
• Developed SSIS Packages to perform Data loads from various types of sources files EXCEL, Access, Flat files .
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML and CSV using SQL Server 2005 Reporting Services SSRS and Crystal reports.

Tools and Technologies: SQL Server 2005/2008, SSIS, SSAS, SSRS, Erwin, MS Access, Excel, Crystal Reports.

Confidential

MS SQL/BI Developer

Confidential is one of the world's leading media, entertainment and communications companies. The main objective of project was to develop the reports based on the OLTP database for ticket management and the activity analysis of the user and automate the report delivery as per the requirement.

Responsibilities:

• Created Stored Procedure, User-defined Functions to take care of back end validations when transferring data to Production Server.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality Implemented backup and database maintenance plans.
• Built SQL Server Integration Services SSIS Packages for data transfer from heterogeneous data sources using T-SQL Stored Procedures.
• Created and monitored SQL Server automated jobs to transfer data between various data sources. Created sophisticated SQL Server database to responsively handle complex queries T-SQL, DTS, triggers, stored procedures, functions, and optimization .
• Involved in Query Optimization using extensive use of Index implementation and Index Tuning Wizard SQL Server 2005
• Designed and implemented ETL Extraction, Transform and Load for data migration and data staging from heterogeneous environment like MS Access and MS Excel using SQL Server Integration Services SSIS / Data Transformation Services DTS .
• Generated periodic reports based on the statistical analysis of the data using SQL Server reporting Services SSRS, and Crystal reports.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects

Tools and Technologies: MS SQL Server Reporting Services, SQL Server Integration Services, MS SQL Server 2005, Windows Server 2003, C, VS 2005, MS Access, MS Excel 2005