PROFESSIONAL SUMMARY:

• 8 years of Strong experience in IT Industry as SQL Server Developer /Administrator in Finance, Healthcare and Insurance domains.
• Experienced in all SDLC phases related to ETL processes within MS SQL Server environment.
• Excellent in data cleansing and analysis, using pivot tables, formulas v-lookup and others , data validation, conditional formatting, and graph and chart manipulation.
• Excellent in translating business requirements into technical specifications design, ETL, and reporting.
• Experienced in data modeling, System/Data Analysis, Design, and Development for both OLTP and Data Warehousing environments.
• Highly experienced in MS SQL Server 2012/2008R2/2008/2005 with Business Intelligence in SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS and SQL Server Integration Services SSIS .
• Highly experienced in creating complex Views, Stores Procedures, DDL/DML Triggers, Spatial Data Functions, and User-Defined Functions to implement Business Logic and Data Protection.
• Experienced with SQL Server and T-SQL in RDBS architecture and design, performance optimization, and constructing triggers, tables, user defined functions, views, indexes, user profiles and relational database models with data integrity.
• Excellent in High Availability optimization solutions including AlwaysOnFailOver Cluster Instances, AlwaysOn Availability Groups, Database Mirroring, and Log Shipping.
• 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 building cubes and dimensions with different architectures and data sources for business intelligence and writing scripting.
• Expert in calculating measures and dimension members using Multi-dimensional Expression MDX , mathematical formulas, and user-defined functions.
• Skilled in optimizing large cubes by creating partitions, usage based optimization, and using proper storage like MOLAP, HOLAP, and ROLAP.
• Extensively performed database administration tasks: Installing, Configuring, Managing, Monitoring and Troubleshooting MS SQL Server 2000/2005/2008/2008R2 on Windows NT/2000/2003/2008 servers.
• Expertise in Database activities like Data Modeling, Database Design, Development, Database Creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication, and Documentation.
• Skilled in developing Data Warehouses, Data Marts using Star Schemas and Snow Flake Schema.
• Experienced in tabular modeling and multidimensional modeling is SSAS.
• Experienced in creating reports including KPI and Dashboards using SQL Server Reporting Services, SharePoint.
• Excellent in Excel 2010/2013 Power Pivot, Power Query, and Power View.
• Expertise in MS Office Suit like MS Project, MS Excel, MS Visio, MS Word, and MS PowerPoint.
• 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.

TECHNICAL SKILLSET:

MS SQL Server 2000/2005/2008, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , SQL Server Management Studio SSMS ,Informatica 8.6.1, MS SharePoint Server MOSS ,Visual Studio 2005/2008, Import/Export Wizard, DB2, MS-Access, Sybase,C, C , ASP.Net, PL/SQL, T/SQL, JAVA, Java Script,VB Script,XML, HTML,Microsoft Visio 2012, ERWIN, Windows NT 4.0/XP/Vista, Windows 2003 /2008 Server, Pentaho Design Studio, Pentaho Data Integration PDI/Kettle .

PROJECT SUMMARY:

Confidential

Sr. MS SQL Server Developer SSIS/SSAS/SSRS

• All state sells 13 major lines of insurance, including auto, property, life and commercial. All State also offers retirement and investment products and banking services. The projects aimed at up gradation of SQL Server 2008R2 to SQL Server 2012 and support the Production Server.
• Performed Migration of SQL Server2008R2 to SQL Server 2012.
• Migrated DTS packages in SQL Server 2008R2 to SSIS in SQL Server 2012.
• Analyzed requirements and designed development plan.
• Conducted data analysis and data modeling in Excel Power Pivot.
• Generated Logical and Physical Data Models using ErWin to design OLTP system.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Spatial Functions, user defined data types and functions by writing complex queries and joins.
• Created data layer for applications using data transfer objects and data access objects in .Net.
• Optimized SQL performance using storage like MOLAP, HOLAP, and ROLAP.
• Optimized queries performance for High Availability using Log shipping and High Availability Groups.
• Used recursive CTE, CTE, temp tables and DDL/DML triggers to manipulate data.
• Scheduled jobs and alerts to keep track of data migration using SQL Server Agent.
• Created packages in SSIS using transformations to generate underlying data for the reports and to export data from excel, flat file, MS Access, and CSV files.
• Lead team in technology planning and implementation, including capacity management, database and query optimization and SSIS performance package optimization.
• Oversaw data load error recovery efforts.
• Tuned performance in SSIS packages using row transformations, blocking and unblocking transformations.
• Deployed projects to SSIS Server using Project Deployment in SSIS 2012.
• Used excel PowerPivot tables to manipulate large amounts of data to perform data analysis and reports.
• Compiled weekly migration updates metrics using Excel workbooks and proprietary databases.
• Wrote MDX Scripts in order to create datasets to perform reporting.
• Created and Deployed Ad-hoc and Customized Reports to satisfy business needs using SSRS.
• Deployed the SSIS Packages to the MSDB as well as File System depending on the requirements.
• Designed Data Warehouse using start schema methodology and converted data from various data sources to target Data Warehouse.
• Maintained all the SQL documents including installation and data conversion Procedure documents.
• Supported and troubleshot the existing webform-based system using C /ASP.Net, SQL 2008R2.

Environment: MS SQL Server 2012/2008R2, Erwin, MS Visio 2012, windows 2003/2005 platform, T-SQL,ASP.Net, Excel Power Pivot, Excel Power Query, Excel Power View, Access, Crystal Reports 9.0 and Windows NT, DTS, SSIS, SSAS, SSRS, Cognos 8.2/3/4, Pentaho design studio.

Confidential

MS SQL Server/SSIS/SSAS Developer

• 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 .
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Found, transformed, and cleaned up data using Excel Power Query.
• 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.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in designing, reviewing, and 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
• Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2008.
• 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 .
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2008 database
• Involved in Tabular and Multidimensional modeling using SSAS to create star schema and snowflake schema.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2005 Reporting Services SSRS and Crystal reports.
• Analyzed, developed and tested new system using MVC3 with C /ASP.Net.

Environment: SQL Server 2005/2008, SSIS, SSAS, SSRS, Informatica, Erwin, ASP.Net Frame Work, XML , MS Access, Excel Power Pivot, Excel Power Query, Excel Power View, Share point MOSS , ASP .Net, Crystal Reports, ER Studio, Performance point Server

Confidential

MS SQL Server / SSRS /SSIS Developer

• GE Capital Realty Group is involved in Loan Servicing, Financing, asset management, corporate outsourcing services and Real Estate Business. This Project involved the preliminary assessment of the Business process, analyzing requirements for up gradation and migration.
• 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.
• Developed and implemented automated batch processing jobs, running in numerous development, test and production environments.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Identified dimension, fact tables and designed the Data Warehouse using star schema.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Identified and added the report parameters.
• Uploaded reports on to the report manager and organized them in folders.
• 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.
• Generated Visual report with Power View in Excel.
• Fine-tuned the database objects and server to ensure efficient data retrieval.

Environment:SQL Server 2005 Query Analyzer, SSIS, SQL Profiler , MS SQL Reporting Services 2005, MS Excel Power Pivot, Excel Power Query, Excel Power View, SSAS, SSRS

Confidential

MS SQL Server Developer

• Pfizer is the world's largest research-based biomedical and pharmaceutical company. Pfizer also continues to be one of the world's largest animal health businesses. They're focused on disease prevention: animal vaccines and animal prescription medicines. The Project aim was to evaluate database objects and to maintain the database.
• Optimized performance of T-SQL queries using clustered index, non-clustered index, SQL profiler, and DTA.
• Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions by writing complex Queries and Joins.
• Developed and delivered dynamic reporting solutions using Crystal Reports 4.0.
• Tuned SQL queries using execution plans for better performance.
• Remediated database objects including triggers, stored procedures, functions, user-defined functions,
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes, views and user security management.
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Designed cubes, star schema, and snowflake schema through tabular modeling and multidimensional modeling in SSAS.
• Created reports like tabular, matrix, ad-hoc, KPI. drill down and drill through reports and Dashboard using SSRS.
• Extensively used Database Tuning Advisor to improve the performance of Query
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: MS SQL Server 2000 Enterprise Edition, SQL Server 2005 Enterprise Edition, SSIS, SSAS, SSRS, Crystal Reports 4.0, ODBC, VBScript, Windows 2000/2003 Server

Confidential

MS SQL Developer/BI developer

• Confidential is one of the nation's leading pharmacy benefit management PBM companies, provides comprehensive prescription benefit management services to over 2,000 health plans, including corporations, managed care organizations, insurance companies, unions and government entities. The main objective of the project was to collect data from various database sources to perform analysis and then integrate them with the existing systems.
• Created Logical and Physical data models using Erwin 4.0 data modeling tool.
• Developed complex Stored Procedures, Functions, DTS Data Transformation Service packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Migrated the data from various sources using DTS.
• Scheduled and performed data transfers using DTS including filtering appropriate to the data mart for data analysis.
• Compressed data files by removing empty database pages and updating index statistics.
• Developed and edited many complex reports with Crystal Reports 9.0.
• Designed and implemented user log in and security.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
• Planned the complete back-up of databases for disaster recovery scenarios.
• Reorganized database structures as needed, automated procedures at regular intervals. Optimized long running Stored Procedures and Queries for effective data retrieval. Involved in project planning, scheduling for database module with project managers. Designed multidimensional modeling using SSAS packages for end-user. Provided the technical guidance and knowledge transfer of effectively using BODS 4.0.

Environment: MS SQL Server 2000 Enterprise Edition, MS Access 2000, DTS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2000 Server, SSIS, SSAS, SSRS Crystal Reports 9.0, BODS 4.0