Sql Server Project

Mayuresh Borkar

_______________________________________________________________________

SUMMARY OF EXPERIENCE

• Over 10+ years of experience in delivering optimal technology solutions and business value in high-growth environments and specialist in Healthcare domain.

• Highly experience SQL Database Administrator and Developer with strong academic background and certifications – MS SQL Server 2008 Administration, MS SQL Server 2005 Administration and MS SQL Server 2005 programming from Brainbench, offering rich and diversified experience in Data Modeling (Logical & Physical), Software Development life cycle, Application Management, Quality Assurance, System / Database Administration, Project Management - hands on exposure Healthcare and Retailing Domain (WM, MM, SD).

• Versatile technocrat with comprehensive experience in Windows Application, Client-Server Technology, Intranet, Database Projects, using MS SQL Server 7/ 2K/ 2005/2008, SSIS, SSRS, SSAS, Oracle8i, Oracle Financials (AR/AP - Interface), ABAP/4, VB6, Crystal Reports, MS Access, FoxPro 2.6, ASP and (UML) over Windows.

• Professional record demonstrates excellent knowledge and understanding of

Installation, Configuring, Administration, database Architecture, Designing, Managing, Monitoring, Performance Tuning, SSIS, SSRS, SSAS, Optimization and troubleshooting of SQL Server 2008/2005/2k.

Backend Programming in creating SQL Objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults and User Defined Data Types & Functions.

T-SQL Programming, Query Optimization & Performance tuning using SQL Profiler.

Database backup and disaster recovery procedures.

Experience in T-SQL queries (DDL, DML), DTS/SSIS, creating and managing the databases and all the database objects.

SAP – ABAP - successfully implemented SAP at Radhakrishna Foodland Pvt. Ltd.

Expertise in Data Management, Database Designing, Data Warehousing and Data Modeling using Microsoft SQL Server, SSIS, SSAS, OLAP Cubes using various dimensions, reports using SSRS.

Setup of an SSIS ETL framework from scratch

Expertise in Microsoft SQL Server Integration Services – SSIS

• Experience in Microsoft SQL Server Replication – Snapshot and Transactional and extensive knowledge in Merge replication.

• Involved in Migrating the SQL Server 2000/2005 to SQL Server 2008/Oracle 10G

• Experience in Data Transformation Services (DTS), ACCESS 97/2000, EXCEL 97/2000.

• Proficient with SQL Server tools including Enterprise Manager, Management Studio, Business Intelligence Development Studio, Query Analyzer, and SQL Profiler and SQL Server Agent.

• Skilled in SQL 2005/2008 Business Intelligence tools, Data Warehousing and ETL processes and strategies using SQL server Integration Services and Reporting Services.

• Extensive use of DTS/SSIS Package and BCP Utility including extensive knowledge of exporting and importing data to and from SQL Server to any OLEDB Provider.

• Professional competencies in Need Assessment, Business Process Understanding, Business Analysis, Data Mapping & Analysis, developing Data Management Process and designing Data Extraction & Load Process; experience in complete Database Design, Data Mapping & Conversion and data Load, and creating complex DTS Packages for Data Migration & Transformation.

• Sound understanding of the Software Development Processes in line with the industrial standard; seasoned professional with a unique blend of Managerial, Technical, Functional and Qualitative skills.

• Hands-on experience with analyzing query plans, using extended Stored Procedures, managing indexes & locks and troubleshooting deadlocks.

• Ability to work in a fast paced environment, good team player and can work independently. Helped the database developers on technical issues

• SQL Server code version and release management, patching and upgrade management

• Data replication through transactional replication, log shipping or database mirroring

• Database administration, maintenance, SQL Server health check, monitoring, automation and maintenance

• Domain Experience in Hospitals & Health care, Healthcare Insurance, Finance, Accounting and Materials Management System (MMS)

Educational Qualification

• Master of Computers Management (MCM) from Pune University

CERTIFICATION

• Brainbench certification in MS SQL Server 2008 Administration

• Brainbench certification in MS SQL Server 2005 Administration

• Brainbench certification in MS SQL Server 2005 programming

• Brainbench certification in Crystal Report

TECHNICAL SKILLS

Databases Microsoft -SQL 2008/2005/2K, MS Access 97 & 2000 &2007 , Oracle 8i

Reporting Tools Microsoft SQL Server Reporting Services(SSRS), Crystal Reports 8.5/XI

ETL SQL Server Integration Services(SSIS)

Languages T-SQL, PL/SQL, Visual Basic 6.0, SAP-ABAP

Operating System Windows NT 2000 Server/ Server/ Server 2003/Professional/ 4.0, Win XP Prof/Standard.

Internet tools VBScript, HTML, XML

Protocols TCP/IP, HTTP

Web servers IIS / Personal Web Servers

Domain Services Hospital / HealthCare, Retailing (WM, MM, SD), Finance

Methodology Unified Modeling Language (UML), VISIO, ERWIN, DFD

BI Tool 1Key Agile, Tableau

Professional Experience:

Wockhardt Pharma/Hospitals (Committed Systems & Software) , NJ Oct’07 – till date

Project Title: W!RE - Wockhardt Integrated Resource for Employees

Client: Wockhardt Hospitals/Pharma Ltd

Role: SQL Server DBA /SSIS/SSRS/Database Architecture/Designing

Tools/Technologies: MS Visual Studio 2005 (ASP.net), MS SQL server 2005, SSRS, SSIS, IIS, JavaScript, VBScript, HTML, Win2003, XML, Upgrade to Ms SQL server 2008.

Project Description

A complete HR related intranet application covering all the processes like manpower budgeting, creating multiple job positions, registering new candidate, allowing candidates to enter their like basic information, address, personal information, family details, education, work experience, etc. Candidate screening, Interview management, Candidate selection, Pre-employment checklist, Employee creation, update employee profile, training, appraisal, transfer, attendance and leave management.

Responsibilities:

Lead a team of people to architect and manage complex, large, globally distributed databases as a member of high energy teams.

Responsible for all the health, maintenance and monitoring of our clients Microsoft Servers and SQL Databases.

Provide technical support and guidance to conforming to Microsoft best practices for installation, configuration and maintenance of system components, problem analysis and resolution.

Provide senior technical administrative support related to Microsoft SQL Databases and environments

Provide technical leadership in the planning, design and architecting of system improvements.

Analyzing and preparing design document of the project using UML.

Analyzing and resolving online and production application and database issues to ensure no operational delays.

Lead teams and write complex stored procedures, functions and queries in T-SQL for various business requirements.

Database creation, Database Designing, writing T-SQL stored procedures, triggers, views & indexes, Database & Query optimization, Performance Tuning, Data migration, SQL Database Script Generation in highly interactive environment

Writing SQL stored procedures and queries for data analysis and reporting.

Developing data conversion scripts using DTS/SSIS, SQL Server 2000, 2005, ACCESS, and Oracle for system conversions of 20-50 tables and 5-40 million records per conversion.

Providing functional knowledge for designing database architecture

Establishing Link Servers for connecting different hospital sites/ locations.

Involved in creating customized reports using Reporting database layer as per client needs.

Modifying the database structure, as necessary, from information given by application developers.

Controlling and monitoring user access to the database.

Monitoring and optimizing the performance of the database.

Planning for backup and recovery of database information.

Data replication through transactional replication, log shipping or database mirroring

Maintaining archived data on tape and backing up & restoring the database.

Programming and implementing Crystal Reports for MIS using SQL Server Database.

Dimensional Data Modeling and Cube development in SQL Server 2005 Analysis Services (SSAS)

Developing and delivering dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)

Managing migration from Crystal Reports to SQL Server 2005 Reporting Services (SSRS) and Create ad-hoc queries from SQL Server databases for custom reporting needs

Monitor processing environments and resolve issues or escalate to appropriate teams.

Problem analysis and resolution, monitoring and documenting environment problems/resolutions.

Perform and/or manage daily/weekly/monthly maintenance duties for supported environments.

Performance Tuning, system testing and upgrade management of SQL Server Databases.

Participation in full life cycle development of our Business intelligence implementation project using Microsoft SQL Server, SSIS, SSAS and SSRS.

SSIS Control Flow and Tasks -- Design/Creation

SSIS Workflows -- Design/Creation

Design SSIS Containers

Participate in the entire lifecycle of the Product - design, documentation, coding, testing and deployment.

Project Title: AR/AP - Accounts Receivable and Accounts Payable

Client: Wockhardt Hospitals Ltd

Role: SQL Server DBA /SSIS/SSRS/Database Team Leader

Tools/Technologies: MS Visual Studio 2005 (ASP.net), MS SQL server 2005, SSRS, SSIS, IIS, JavaScript, VBScript, HTML, Win2003, XML, Upgrade to Ms SQL server 2008.

Project Description

This module captures all the vouchers like Daily IP/OP bills, Free Bills, Pharmacy Bills, IP/OP Discounts, Deposits, Receipt Settlements, TDS and Refunds on the daily basis and then, in turn, transfers to oracle financials. Create Oracle Interface in SQL Server using DTS, SSIS and Job Scheduling etc…

Responsibilities:

Analysis of Business logic implementing same in technical specifications.

Involved in high level design document by interacting with the client for the understanding of the raw business requirements and translating them for designing technical requirements.

Lead teams and write complex stored procedures, functions and queries in T-SQL for various business requirements.

Database creation, writing T-SQL stored procedures, triggers, views & indexes, Database & Query optimization, Performance Tuning, Data migration, SQL Database Script Generation in highly interactive environment

Writing SQL stored procedures and queries for data analysis and reporting.

Developed Complex SSIS package for development of OLAP database from OLTP source.

Configured and maintained Report Manager and Report Server for SSRS.

Identified and added the report parameters and created the reports based on the requirements using SSRS 2005.

Created Cross-Tab, Drill-down, Sub-Report, Customized and Ad-hoc reports using SSRS.

Developed complex SQL queries, stored procedures, and Job scheduling using server agent

Worked on optimization and tuning of SQL queries and indexes

Assisted in the application development, debugging, configuration, and optimization from database perspective

Data replication through transactional replication, log shipping or database mirroring

Reviewed applications and database design for compliance with best practices standards.

Assisted in troubleshooting and resolution of database issues

Modifying the database structure, as necessary, from information given by application developers.

Controlling and monitoring user access to the database.

Monitoring and optimizing the performance of the database.

Planning for backup and recovery of database information.

Systems Plus Solutions Pvt. Ltd. Feb 2007 – Aug 2007

Project Title: Doctor Accounting & Operation Theater Module

Client: Lilavati Hospitals & Research Centre

Role: IT Consultant / SSRS / SSIS

Tools/Technologies: MS Visual Studio 2005(VB.net), MS SQL server 2005, IIS, JavaScript, VBScript, HTML, Win2000, XML and Microsoft Visio, SSIS, SSRS.

Project Description

Doctor Accounting Module calculates doctor’s payments as per hospital’s rules and regulations. This module is linked with In-patient and Outpatient modules. Operation Theatre module covers various chapters like Enterprise scheduling (Used for resource, OT scheduling), OT requisition and confirmation, OT charges (individual and multiple surgeries), Post operative Notes.

Responsibilities:

Responsible for providing functional knowledge and implemented SRS (Software Requirement Specifications)

Handled the entire team and guided the developers to develop programming modules as per SRS.

Involved in creating database level objects like stored procedures, triggers, views etc.

Established Link Servers for connecting different hospital sites/ locations.

Implemented both the modules at Lilavati Hospital & Research Center

Database creation, writing T-SQL stored procedures, triggers, views & indexes, Database & Query optimization, Performance Tuning, Data migration, SQL Database Script Generation in highly interactive environment

Developed Complex SSIS package for development of OLAP database from OLTP source.

Writing SQL stored procedures and queries for data analysis and reporting.

Created Cross-Tab, Drill-down, Sub-Report, Customized and Ad-hoc reports using SSRS

Data replication through transactional replication, log shipping or database mirroring.

Developed complex SQL queries, stored procedures, and Job scheduling using server agent

Worked on optimization and tuning of SQL queries and indexes

Assisted in the application development, debugging, configuration, and optimization from database perspective

Planning for backup and recovery of database information.

Participation in full life cycle development of our Business intelligence implementation project using Microsoft SQL Server, SSIS, SSAS and SSRS.

Radhakrishna Foodland Pvt. Ltd. Jun 2006 – Jan 2007

Project Title: Retail Project Implementation (SAP)

Role: Assistant Manager – IT (Project Leader for ABAP)

Tools/Technologies: SAP ABAP4+, SQL Server2005, Oracle 10G, UNIX and Win2003, DTS, SSIS, SSRS, IIS, SAP Scripts, Smart Forms, BDC etc.

Responsibilities:

Actively involved in working in ABAP/ 4 including Data Conversion Program, Dialog Programming, Smart Forms, BDC, SAP scripts, LSMW

Designed technical program specifications based on business requirements

Generated various client specific Layout sets and form letters using SAP Script and Smart forms

Developed a print program and SAP Script form for printing WM/ MM/ SD Layouts

Implemented both Call Transaction & Session Method of BDC (Batch Data Communication) accordingly, depending upon the size, type, state and need of the data, once the batch input was generated.

Used LSMW (Legacy System Migration Workbench) for mapping fields from the legacy system and created routines for data upload using extracts of data for sequential files on the application server and UPLOAD/ WS_UPLOAD for local files on the presentation server

Successfully implemented various SAP modules like Warehouse Management, Material Management, Sales & Distribution, and Finance & Controlling.

Generated reports like Purchase Requisition Analysis using ALV (Advanced List Viewer), Purchase Order pricing details, Purchase Requisition to Goods Receipt cycle analysis, pending export sales order.

Developed complex SQL queries, stored procedures, and Job scheduling using server agent

Implementation for heterogeneous distributed data environments using DTS/SSIS, and custom scripts/batch programs

Data replication through transactional replication, log shipping or database mirroring.

Aditya Birla Memorial Hospital, Pune Feb 2006 – Jun 2006

Project Title: Hospital Information System

Role: Manager – IT

Tools/Technologies: Win2003Server, Microsoft Projects, SQL Server2005, Microsoft Visio, SSIS, SSRS, IIS, MS Visual Studio 2005

Project Description

This is a hospital with 500 beds facility. HIS (Hospital Information System) application is an integrated package covering about 28 modules for all Front Office and Back Office. I was responsible for steering committee member and instrumental in total identifying operations, functional errors and getting them resolved.

Responsibilities:

Instrumental in identifying operations, functional errors and resolving them.

Lead a team of people to architect and manage complex, large, globally distributed databases as a member of high energy teams.

Lead teams and write complex stored procedures, functions and queries in T-SQL, SSRS and SSIS etc for various business requirements.

Conducted Training program for higher authority users and other users.

Involved in development of multiple HIS modules and Implementation of HIS

Provided round the clock support for the products

Involved in Computer Networking, User Acceptance & Testing and preparing Customization Requirement

Implementation for heterogeneous distributed data environments using DTS/SSIS, and custom scripts/batch programs

Data replication through transactional replication, log shipping or database mirroring

Participate in the entire lifecycle of the Product - design, documentation, coding, testing and deployment.

Database administration, maintenance, SQL Server health check, monitoring, automation and maintenance

Wockhardt Hospitals Sep 2003 – Feb 2006

Project Title: Hospital Information System

Role: System Analyst (PL for Healthcare Project)

Tools/Technologies: Ms Visual Studio 2005 (VB.Net), MS SQL server 2000/2005, Crystal Reports, Oracle10G and Win2003, SSRS, SSIS, DTS, ERWIN 4, IIS.

Project Description

HIS (Hospital Information System, a product from Wipro, which is quoted as Asia’s # 1 software in healthcare) application is an integrated package covering about 30 modules for all front office and back office. I was responsible for support and implementation of HIS System at different locations, administration of SQL Server Database.

Responsibilities:

Responsible for support & implementation of HIS System 2.0 at different locations of Wockhardt Hospitals administration of SQL Server Database.

Lead teams and write complex stored procedures, functions and queries in T-SQL, SSRS and SSIS etc for various business requirements.

Participated in in-house MIS reports for the Management including Clinical Data, Inventory, billing, Cross Tab Reports, Sub Reports, SSRS etc., using Crystal Report 8.5 and SQL Server 2005 objects like views, stored procedures, triggers, functions etc.

Developed numbers of other useful add-on modules like Time Attendance system, Food Order Management System, Income Tax Calculation, TDS Calculation, Oracle financial interface etc.

Participation in full life cycle development of our Business intelligence implementation project using Microsoft SQL Server, SSIS, SSAS and SSRS.

Play a lead role in developing, implementing and executing IT Disaster Recovery Plans

Monitor processing environments and resolve issues or escalate to appropriate teams.

Provide senior technical administrative support related to Microsoft SQL Databases and environments

Provide technical support and guidance to conforming to Microsoft best practices for installation, configuration and maintenance of system components, problem analysis and resolution.

Problem analysis and resolution, monitoring and documenting environment problems/resolutions.

Data replication through transactional replication

Lilavati Hospital Research Center Nov 2000 – Sep 2003

Project Title: Hospital Information System

Role: Programmer (Module Lead-Database Analyst)

Tools/Technologies: Visual Basic 6, MS SQL server 2000/2005, Crystal Reports, Win2000 and Oracle 8i, SSRS, SSIS, DTC, ERWIN, IIS.

Project Description

HIS (Hospital Information System) application is an integrated package covering different modules for all Front Office and Back Office. I was responsible for In house development of various projects in the different departments of the Hospital, like Laboratory Information Systems (LIS), In Patient Billing (IPB), Out Patient Billing (OPB), Material Management System (MMS), Pharmacy Management System (PMS), Chemist Management System (CMS), Appointment System, CSSD Inventory System, Payroll (HR Management & Salary) System, FOMS – Food Order Management System and Lilavati Hospital Web Site etc.

Responsibilities

Database administration, maintenance, SQL Server health check, monitoring, automation and maintenance

Developing database schemas, utilizing database best practices

Lead teams and write complex stored procedures, functions and queries in T-SQL, SSRS and SSIS etc for various business requirements.

Performance tuning and Indexing strategy design

T-SQL Optimization

implementation for heterogeneous distributed data environments using DTS/SSIS, and custom scripts/batch programs

SQL Server code version and release management, patching and upgrade management

Data replication through transactional replication, log shipping or database mirroring

Performing analysis of the system

Preparing design document of the project using UML

Generating reports using Crystal Reports, SSRS.

Receiving user acceptance and manual testing of each module

Involved in continuous support process

Participated in in-house MIS reports for the Management including Clinical Data, Inventory, billing, Cross Tab Reports, Sub Reports, SSRS etc., using Crystal Report 8.5 and SQL Server 2005 objects like views, stored procedures, triggers, functions etc.

Contact this candidate