PROFESSIONAL SUMMARY:

• Overall 7 years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2012/2008 R2/2008/2005/2000 and Microsoft Business Intelligence Tools SSRS, SSIS, SSAS in Development, Data warehouse, Test and Production Environments on various business domains.
• Expert knowledge in Data modeling both normalized for OLTP and de-normalized for OLAP
• Profound Experience in T-SQL and stored procedures
• Proficient knowledge with concepts of Tables, Triggers, User Functions, Views, User Profiles, Joins, Relational Database Models, Data Dictionaries and Data Integrity
• Experience in administration activities like tuning and optimizing, Database securities, maintenance.
• Proficient in Creating, Configuring and Fine-tuning SSIS Packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Tuning advisor.
• Experience in MS Business Intelligence tools like SQL Server Integration Services and Reporting Services
• Expert on ETL concept/activities like Validate, Extract, Transform, Load, Error Handling, Rollback, B2B transformations.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Experience in using tools like Bulk Copy Program BCP and Data Transformation Services DTS .
• Expertise in migrating DTS 2000 packages to SSIS 2005/2008 by using DTS xChange tool.
• Proven proficiency in Data Transformations like Derived Column, Conditional Split, Aggregate, Union all, Merge join, Lookup, Sort Execute SQL Task to load data into Data Warehouse.
• Expert in creating different type of reports like ad-hoc reports, parameterized reports, dashboard reports, drill through report, and drilldown reports by using MS reporting services SSRS .
• Developed Reports using efficient data retrieval techniques
• Experience in Excel Services like ODS, Dynamic Excel export, Pivot Table.
• Strong experience in designing and developing more than 100 enterprise reports SSRS using the data from ETL Loads, SSAS Cubes, and various heterogeneous data sources.
• Expert in creating MOLAP Warehouse on SQL 2008 Server Analysis Services and created multiple cubes with dimensions and facts.
• Highly experienced in optimizing MOLAP Cubes by partitioning them, Designing Aggregations, implementing Hierarchies and Calculated Members.
• Strongly experienced in Database Installation, Database Backup, Restoration, Linked Servers and Database Maintenance Planning.
• Strong application development experience with .Net Architectures using different tools and technologies including VB.NET, C .NET, ASP.NET, ADO.NET, Web Services, HTML, JavaScript, VB Script, IIS and Visual Source Safe, Team Foundation server, SVN with both Web forms and Win forms.
• Functional Knowledge on MSCRM 2011 and Knowledge on Crystal Reports, SAP BI/BW, BO Business Objects .
• Experience in project management methodologies such as V-Process Model, Spiral, Waterfall, Iterative, and Agile Scrum.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

Technical Skills:

Professional Experience:

Confidential

Role: SQL BI/ETL Developer SSIS/SSRS/SQL Server

Western World Insurance Group formed in 1964 and successfully weathered several insurance underwriting cycles and has learned from each. Through difficult periods and years of spectacular growth, the company has built a record of profitability and capital accumulation an enduring reputation for underwriting expertise and a staff of seasoned professionals capable of providing our customers with quick, knowledgeable and thoughtful solutions, specifically tailored to classes of business.

System Usage Report SUR :

System Usage Report SUR is an application that facilitates to generate monthly user usage reports for insurance Applications. This application is very user friendly. Reports can be generated just by selecting the reporting period and Regions. This Application doesn't require any specific skills for generating the reports.

Responsibilities:

• Actively participated analysis and requirements gathering with customers.
• Involved in designing and developing the Business Logic and UI.
• Developed and implemented the Web application.
• Designed and developed GUI screens using C , ASP.Net Web Forms using Standard, Data and HTML controls.
• Created SQL Server Integration Services SSIS packages to import data from heterogeneous data sources like Oracle 9i, SQL Server Text files CSV, Xls, and XML .
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008/2012.
• Extract Transform Load ETL development Using SQL server 2008/2012,SQL 2008 Integration Services SSIS
• Developed the SQL Server Integration Services SSIS packages to transform data from MS SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Involved in design and development of ETL Jobs using SQL Server Integration Services SSIS for data migration between different maintenance systems.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Scheduling the SSIS packages and Jobs
• Created many drill through and drill down reports using SSRS.
• Generated custom and parameterized reports using SSRS.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Performed Data profiling tasks In SSIS using the Data Profile Viewer and then clean, optimize and standardize the data as appropriate for the Databases.
• Scheduled report and exported in PDF format.
• Used Lookups Transformation to get the data from reference data sets.
• Created SSIS Packages to migrate slowly changing dimensions.
• Deploying the reports in Report Manager, Creating new DataSources, Tesintg the reports values and documenting Test Scenarios, Test Case, Test Results.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Modified existing reports and made neccessary changes.

Environment: SQL Server 2008/2012, SSIS, SSRS, T-SQL, MS Excel 2007/2003, Business Intelligent Development Studio 2005, 2008, Query Analyzer, Query Optimizer, C .NET, ASP.NET, VisualStudio.NET 2012/2010/2008/2005.

Confidential

Role: SQL Developer SQL Server, SSIS

DaVita is the dialysis division of DaVita HealthCare Partners Inc., a Fortune 500 company that, through its operating divisions, provides a variety of health care services to patient populations throughout the United States and abroad. A leading provider of kidney care in the United States, DaVita delivers dialysis services to patients with chronic kidney failure and end stage renal disease. DaVita strives to improve patients' quality of life by innovating clinical care, and by offering integrated treatment plans, personalized care teams and convenient health-management services.

Insurance and Coverage:

A web application, which is facilitates the DaVita Inc., patients about Insurance and coverage. It provides all the demographics, dialysis and Policy details about all the patients in DaVita.

Responsibilities:

• Worked on complex data loading implemented the batch data cleansing and data loading .
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights.
• Wrote complex T-SQL queries and Created Tables, Views, Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database to SQL Server.
• Created linked servers between different SQL Servers and also created linked server with different access files used across various Used Data departments
• Performed DBA tasks through Enterprise Manager, Query Analyzer, English Query, Import Export wizard.
• Modification Language DML to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Experience in administrating activities like tuning and optimizing, Database securities, maintenance.
• Agile Development and Documentation.
• Created Triggers to enforce data and referential integrity.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created and managed users, roles and groups and handled database security.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Develop code that matches the prototype and specification, is maintain and, as necessary, portable to other environments.
• Created a VB Script file to execute Master Script file consists of all SQL files in different environments.
• Maintained a good client relationship by communicating daily status and weekly status of the project.

Environment: SQL Server 2005/2008, SQL Profiler, Query Analyzer, DTS, T-SQL, SVN, C .Net, Asp.Net, VB Script, JQuery, Agile Scrum, Performance Tuning.

Confidential

Role: SQL BI/ETL Developer SSIS/SSRS/SSAS/SQL Server

CRM360:

The new system CRM360 is the successor of SMIS. It is based on the Microsoft Dynamics 2011 platform. CRM360 is one of the major applications of Sales and Marketing domain of Ericsson. It mainly contains the Financial Data of Ericsson, used for analyzing the performance of the Company on Quarterly and Annual basis. CRM360 deals with Opportunity Management, starting with the Identification of Opportunity to converting it into Business.

Responsibilities:

• Create joins and sub-queries for complex queries involving multiple tables.
• Generated dynamic stored procedures, triggers for the database development.
• Involved in installation and configuration of SQL Server 2005 and SQL Server 2008 with latest Service Packs.
• Experience in administrating activities like tuning and optimizing, Database securities, maintenance.
• Created and managed users, roles and groups and handled database security.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source Oracle , Excel Spreadsheet to SQL Server 2008 R2.
• Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Expertise in migration of DTS Packages 2000 to SSIS 2005/2008 by using DTS xChange tool and troubleshoot migration issues.
• Experience in Excel Services like ODS, Dynamic Excel export, Pivot Table.
• Experience in creating SSIS packages using different type's task and with Error Handling.
• Designed SSIS Packages to extract, transfer, load ETL existing data into SQL Server from different environments for the SSAS cubes.
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Performance tuning and optimization of procedures and queries.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Created SQL server Reports using SSRS.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services SSRS .
• Expert in generating drill down Reports in SSRS 2005/2008.
• Report writing based on tickets submitted from front end people using SQL Server Reporting Services SSRS .
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.
• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Created SSIS Packages using SharePoint List source to retrieve data from SharePoint Lists.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Configure the report server and generated the report models for user interactions.
• Designed a new schema for the Data Mart databases.
• Build the dimensions and fact tables with star schema using SQL Server Analysis Services SSAS .
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.
• Deployed Cubes on Development Server and Production Server.
• Created MDX queries to extract data from the Data Mart.
• Generated Dynamic reports from Cubes SSAS using SSRS-2008.
• Building and writing MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence SSAS, SSRS

Environment: MS SQL Server 2005/2008 R2, MS SQL BI Suite SSIS, SSRS, SSAS , MS Access, Management Studio, SharePoint 2007, ETL, DTS, Notification Services, Crystal Reports, Data Modelling, Data ware Housing, T-SQL, SQL Profiler, IIS 6.0, Java Script, Replication, MSCRM Functional Knowledge.

Confidential

Role: SQL BI/ETL Developer SSIS/SSRS/SQL SERVER

Sales Management Information System SMIS :

Sales Management Information System SMIS offers user friendliness, simplification of administrative routines and mobility by Managing the opportunity throughout the Sales Process. SMIS application is used by 8000 users of Ericsson. It is a model for describing the C13 process and major activities related to the key sales stages of a customer contract. Sales Management Information System focuses on different parts of the sales process: Creation of opportunity sales and creating proposal and contract for that opportunity and complete approval process is defined in SMIS.

Responsibilities:

• Leading a Team of 5 members.
• Installed and Configured SQL Server 2005/2008.
• Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor.
• Performance Monitor to track the size of your SQL Server database transaction logs and set up alerts to notify the server before the transaction log fills, thus averting problems that might otherwise seriously affect users and applications.
• Created Stored Procedures, Triggers, Functions, client specific Views for the Application. Extensive testing on the Performance of the Stored Procedures.
• Optimized SQL queries for efficiency and provided queries and procedures for the front-end application.
• Imported and exported data to and from various heterogeneous sources using various techniques like BCP, DTS.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases.
• Wrote scripts to monitor backup and restore activities.
• Developed parameterized reports through Reporting Services SSRS from a variety of data sources including Analysis Services Cubes and prepare for Web publishing.
• Created ad-hoc queries and reports as requested and provide on-going analytical support for these requests.
• Generated reports with dynamic grouping and dynamic sorting as well as running values.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005.
• Experience in Excel Services like ODS, Dynamic Excel export, Pivot Table.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions etc. for better performance during package execution.
• Scheduled SSIS Packages for loading Facts and Dimensions.
• 24x7 Production support.

Environment: SQL Server 2005/2008, MS Access, SSRS/SSIS 2008, T-SQL, Replication, MSCRM Functional Knowledge.

Confidential

Role: .Net/ SQL Server Developer

Process Automation Team PAT :

This has features like work allocation, processing steps, quality control, reports. Automatic allocation with or without proficiency and manual allocation are the three types of work allocation available in this tool. Quality check Percentage is configurable at any instance and requests will be picked randomly according to the percentage. Productivity, Accuracy and Processor efficiency can be easily evaluated using this tool. The controls will be created according to the process specific configuration. This tool can be deployed easily for various types of processes without any code change by configuring the process specific details. The tools capture the metrics which are finally shown in the BPO dashboards.

Responsibilities:

• Actively participated analysis and requirements gathering with customers.
• Developed and implemented the Web applications.
• Involved in designing and developing the Business Logic and UI.
• Designed and developed GUI screens using C , ASP.Net Web Forms using Standard, Data and HTML controls.
• Installing and Configuring of SQL Server 2000/2005 on windows 2000/NT OS.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Managing of databases objects like Tables, views, indexes etc.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed scripts for maintaining administration tasks.
• Developed web applications to generate reports and to automate the work flow of the business.
• Creation and management of database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Performed validations through Java Script.

Environment: VB.NET, ASP.NET, SQL Server 2000/2005, SQL Profiler, VB Script, Java Script, DTS, T-SQL, IIS 5.0, VisualStudio.NET 2005.