Sql Server Data

ANAND KUMAR GANNOJU

SQL Server Sr.DBA

*****************@*****.***

Mobile: 201-***-****

Authorised to work for any employer in US

Professional Expertise

* ***** ** ********* ********** as a SQL DBA working on L2 and L3 production support.

7 Years of excellent experience in Requirement analysis, Database Design, Development Testing, Migration, Reports Development, Documentation and Rollouts.

Expertise in Installation, Upgrade, Configuration and Migration of MS SQL Server in clustered and non-clustered environments.

Expert in trouble shooting and resolving SQL Server problems in line with the SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, Windows failover clustering, replication, Log shipping, Mirroring, AlwaysOn, backup/restore, database corruption, security and programming.

Expertise in Maintenance of databases, Performance Tuning and Troubleshooting.

Expertise in analyzing business needs And designing, Testing, implementing HADR models

Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.

Expert level of Skills in Data Analysis, KPI identification and dash boards design

Extensive experience in developing reports and dashboards using Crystal Reports & SSRS

Extensive work experience on SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.

Experience in Installation, configuration and maintenance of SQL Server 2000/2005/2008/2012

Expert in Data migration using SSIS and DTS services across different databases includes Oracle, MS access & flat files.

Exposure to complete life cycle of software development

Experience Design, development and Testing of software applications using Visual Studio 6.0,C# .Net

Experience in writing Distributed Queries using different heterogynous data sources in SQL Servers.

Worked extensively on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.

Expert in developing navigating reports, filtering reports, Formula Work Shop based Reports using Crystal Reports and SSRS.

Good Business and System analysis skills to understand the requirements and customize client applications.

Experience of working on different RDBMS like Oracle, MYSQL, SQL Server and MS Access.

expert domain knowledge in HealthCare, Accounting, Insurance, Emergency And Public Health

Appreciations:

POB for Best Support

POB for Best stakeholder Management

POB from Practice Head for Best support practices

Academic Profile:

Masters Degree in Information Technology, Sikkim Manipal University

Trainings & Certifications:

Microsoft® SQL Server™ 2012 - Administering Microsoft SQL Server 2012 Databases(070-462)

Project Management for Practitioners (TechM)

HIPAA Certification (TechM)

Post Graduate Diploma in Computers

Satyam Project Management Practices (SPMP)

Certificate of Training in Six Sigma

Quality Management System (QMS)

Data ware Housing (DWH)

C# .Net

SSIS Packages

Visual Source Safe and TFS

Employment Profile:

Company Name

Designation

Start date

End Date

Tech Mahindra

Senior Database Administrator

July’2008

Jan 2016

Alliance Consulting

Associate Architect

Feb’2008

June’2008

iSOFT R & D Ltd

Sr.Software Engineer

Feb’2006

Jan’2008

Wipro Technologies

Module Leader

Oct’ 2000

Jan’2006

Technical Skills

Operating Systems

Win 9x/NT/XP/2000/2003/2008/2012

RDBMS

SQL Server 7.0/2000/2005/2008/2012, Oracle 11i, MYSQL and MS Access

Languages

Visual Basic 6.0, Visual Studio .Net 2008,C# .Net T-SQL, PL/SQL

Web Technologies

ASP, VB Script, HTML, MS-Front Page, IIS

Development Tools

MS Visual Studio 6.0/. NET, VB.NET, VB 6.0, DTS, SSIS

Reporting Tools:

Reports 8/10/XI, SQL Reporting Services (SSRS), SSIS, SSAS

Configuration Tools

MS Visual Source safe, CVS, MS-TFS

Tools & Utilities

JIRA, i.Assist, BMC, ITSM, RedGate

Domains

HealthCare, Accounting, Insurance, Emergency & Public Health

Projects Experience:

#09

Project: Integrated Data Source

Role

Sr.Database Administrator

Organization

Tech Mahindra

Duration

Nov/2015 – Dec 2016

Client

Delta Dental of California, SFO,USA

Software

Database: SQL Server 2005/2012, MSQL,MS Access

O/S: Windows 7, 2003,2008R2

Project Description: The Objective of Integrated Data Store (IDS) project is to build an enterprise data store for Delta Dental of California and its affiliates using Party model which will store various operational, master and historical data for Delta Dental CA business. IDS will store consistent, cleaned, staged and managed data which will be highly scalable. IDS data warehouse acts as a Single Source of Truth (SSOT) for analytical and reporting requirements used across enterprise. Data from the various business functions are stored in this data store: Providers, Capitation, Contracts & Fees, Groups, Membership, Sales and Marketing, Benefits, Claims Processing, Pricing & Operations, Actuarial Data Mart, Billing & Invoicing, Financials, CRM Data, Federal & State Data, Historical claims data from legacy and data from other data marts for analytical & reporting purposes.

Responsibilities

Designed, Developed, Tested and implemented enterprise level DR plan

Configure, monitor Replication, Log shipping and AlwaysOn on multiple environments

Resolving issues related to creating & maintaining of databases, monitoring Disk Space, Database Security, Database integrity, Indexes management, blocking and daily checks.

Setup & Automated Key Alerts on daily/weekly maintenance Jobs, Data Loads Jobs, Disk Space and CPU Monitoring,

Monitoring of server performance, trouble shooting and fixing performance issues

Creating and managing unified database models.

Writing complex business stored procedures, function and triggers

Migrating databases from flat files, MySQL, Salesforce and Oracle.

Working with development teams in designing, finalizing and developing database schemas and objects

Monitoring and fixing of daily data loads

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.Configuring and troubleshooting high availability scenarios like Log Shipping, replication

Backup, Restore and verify the critical databases on regular intervals.

Resolving blocking processes related issues.

Validate and executing the scripts in test, UAT and Production environment.

Installation, configuration and upgrade of MS SQL Server 2008 R2, 2012

Updating Service packs and Security patches for the Servers.

Analyzing data, Defining KPIs and publishing dash boards

Preparing documentation and presentations on DB schemas, DB models and best practices

Revised the key business use cases to validate data integrity and created corresponding queries to test data processing, data transformations and data populations against the documented business and mapping rules.

#08

Project Name: Broadcom

Role

Sr.Database Administrator

Organization

Tech Mahindra

Duration

Jun/2013 – OCT/2015

Module

Manufacturing, SAP, Finance and IT operations

Client

Broadcom Corporation Houston –Texas

Software

Tools: BMC, RedGate

Database: SQL Server 2005, Oracle 11i,MS Access

O/S: Windows 7, 2003,

Project Description: Broadcom Corporation is one of the largest companies in wireless and broadband communication business. There are around 11000 employees around the world. The company is headquartered in Irvine, California. There are more than 400 Microsoft SQL Servers in different versions. Database team will maintain all the servers and support to developers and users.

Responsibilities

Around 400 database servers maintenance and implement the change control requests

Provide consultation on SQL Server questions/issues to development teams

Installing, configuring, administering and securing development and production servers using

SQL Server 2008R2 and SQL Server 2012

Create automated processes/jobs to automate repetitive tasks

Configure linked server & remote server to execute remote procedures

Performed daily tasks including regular database and servers health check

Migrate the data from heterogeneous data sources to SQL server

Standardize the process across all the environments

Troubleshooting server outages, as well as troubleshooting and monitoring job failures

Along with application issues

Deployments and refresh the databases in multiple environments

Create and schedule Database maintenance plans

Configure Mirroring and log shipping on development and testing servers

Configure Always on SQL server 2012 on development and production servers

Perform the Multi server administration

Provide proactive coordination across multiple teams

Responsible for applying patches by service pack installation and hot fixes

Build and update SSIS packages

Providing after hours on call support

Providing necessary recommendations on the HW and SW upgrades

Updating DB/Server/Jobs/Users/Roles artifacts on regular intervals

Comparing Schema/data in various environments while trouble shooting

#7

Project Name: Emergency Management System (1-0-8)

Role

Sr.Database Administrator

Organization

Tech Mahindra

Duration

Oct/2010 – April/2013

Module

ERO,DO,ERCP,AVLT,CTI

Client

GVK EMRI

Software

Database: SQL Server 2005, Oracle 11i,

Environment: ASP.Net, C#.Net, IIS,CTI,AVLT, GIS

O/S: Windows XP/7, 2003,2005

Tools: SSIS, SSRS

Project Description: Emergency Management System (108): Automates all the activities of the call center reaching the emergency site by Emergency Response Vehicle (Police, Fire, Medical), tracking the ambulance monitoring emergency care process, informing the police about the accident. Operational in 17 states/ provinces in India. The EMS call center based systems are integrated with CTI, AVLT and GIS technologies.

Responsibilities:

Implement and maintain high availability strategies via log shipping, transactional replication, clustering, and Availability Groups. Conduct disaster recovery exercises and ensure maximum up time with minimal latency between Active/Active data centers.

Created Database maintenance plans for Backup and Recovery.

Prepared data migration plan and developed scripts

Designed, developed, tested and implemented database archiving engine for production databases

Performance monitoring and fixing of critical dash boards

Created complex Stored Procedures, Packages, Triggers and Scheduled Jobs.

Dynamic Queries to address complex business logics involving in multiple Databases.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Created Stored Procedures and T-SQL Queries for SQL Server reporting services (SSRS).

Migrated Data Transfer Service (DTS) Packages to SQL Server Integration Service (SSIS).

Created Bulk Insert Packages to Retrieve Data from Flat Files using SQL Server Integration Services (SSIS).

Analyzing new Report requirements and designing specification documents.

Creating Reports from large Database using SQL server Reporting Services (SSRS).

Created parameterized Reports using charts, Matrix, List, Sub Reports, and Running Totals using SQL Server Reporting Services (SSRS).

Created Cascading Reports link giving hyperlink to a field and that will takes u to the another report or chart using SQL Server Reporting Services.

Responsible for performance tuning, optimizing the queries (TSQL statements), removing redundant and inconsistent data, joins from the database tables and normalizing them

Rewrote TSQL queries, removed unwanted columns, established joins and created indexes wherever necessary

Providing updated DB scripts for Schema and Data during Build preparations

Prepared documentation/scripts for tables, stored procedures, SSIS tasks and comprehensive commenting of all codes. Maintained technical documentation for operational support

#6

Project Name: PHMS

Role

Database Architect

Organization

Tech Mahindra

Duration

Jan/2010 – Sep/2010

Modules

Tele Health, Women Help Line, Mobile Medical Unit, HRMS and HMS

Software

Database: SQL Server 2005

Environment: Visual Studio 2010, ASP.net and IIS

O/S: Windows 7, 2008

Project Description: Public Health Management System having suit of projects providing information services to the citizens in India in association with Govt.of Andhra Pradesh, Gujarat, Assam and Tamilnadu. The PHMS software systems include 104-TeleAdvice, Mobile Medical Unit, Women Help Line, HRMS and Hospital Management System.

Responsibilities:

Studying existing database systems

Preparing Gap analysis

Proposing and demonstration of New Database designing to project teams

Standardizing the SQL coding practices across the projects

Logical and physical designing of Databases and documentation

Writing T-SQL code, Stored Procedures, Views, Functions and Triggers

Migration of Master data

Monitoring and Maintaining Development and Testing servers

Training the development teams on the SQL coding standards

Installation and configuration of development and testing servers

Review/recommendation on critical business functionality

Query optimization, performance tuning

Participating in project review meeting

Participating in domain and technology meetings

Publishing weekly report on DB development progress

Publishing ‘Tip of the Day’ for all the projects team

Managing and appraising DBA Team

Conducting training session for project teams on the new features and best practices

#5

Project Name: HMRI

Role

Database Administrator

Organization

Tech Mahindra

Duration

Jul/2008 – Dec/2009

Modules

104-Tele Advice, FDHS

Software

Database: SQL Server 2005

Environment: Visual Studio 2010, ASP.net and IIS

O/S: Windows 7, 2008

Project Description: Health Management and Research Institute (HMRI) is a non-profit organization working towards improved access and quality of healthcare services in Andhra Pradesh. HMRI is leveraging state-of-the-art information and communication technologies and modern management practices to transform healthcare delivery by creating the world’s largest integrated digital health network, in collaboration with Govt. of AP. 104 (toll free number) Tele advice is a health information help line deployed in Andhra Pradesh, catering for various health and other information for all sections of people of AP

Responsibilities:

Databases and Servers Monitoring

Managing and supporting 24/7 production activities

Configuring and managing Log-shipping, Replication for development servers

Configuring and managing database mirroring for production servers

Performance monitoring and tuning

Security Management of Servers and Database

Index Management

Scheduling and monitoring Jobs

Backup and restore/verify activities

Deadlocks and Blocks management

Disk space management

Patches and service packs installation

Installation and configuration of SQL DB servers

Planning & execution of weekly Maintenance activities

Co-coordinating with project team on the deployment activities

Stakeholders management

Generation of ad-hoc reports and dash boards

Shifts planning and managing

#4

Project Name: Master Data Management

Role

Database Administrator

Organization

Alliance Consulting Ltd

Duration

Feb/2008 – Jul/2008

Modules

MDM

Client

McAfee, USA

Software

Database: SQL Server 2005

Environment: C#.net, IIS and JIRA

O/S: Windows XP, 2003

Project Description: Master Data Management (MDM) provides organizations with a proven data integration solution for master data such as customer, product, vendor, materials, location and others.

MDM works with clients to develop both technical and business requirements for Master Data Management. In the business process area, MDM helps define the governance processes for customer, product, etc. and the roles required to support a future-state Customer Master, including the Data Stewardship function.

Responsibilities:

Leading the Database Team

Working with Development team for database design and development

Monitoring and maintaining 4 production and 3 development servers

Job Monitoring & publishing

Creating and Scheduling new Jobs

Monitoring disks statistics on production servers

Monitoring and sending reminders to team on CVS Difference and Data Integrity Checks.

Creating and maintaining users in Windows as well in SQL Server

Creating environments for testing

Verifying the Backup files status

Providing support to Client on Day-to-day activities on the product.

Creating and scheduling Windows Schedulers

Coordinating with onsite support team

Coordinating with CapGemini team for the Infrastructure support.

Logging and resolving issues that are raised by client on the MDM product.

Monthly maintenance of Address Doctor Database

Following Defect tracking and analysis (JIRA)

#3

Project Name: iPM

Role

Sr.Developer

Organization

i.Soft R & D Ltd

Duration

Feb/2006 – Jan/2008

Modules

iPM

Client

National Health Scheme - UK

Software

Database: SQL Server 2000

Environment: C#.net, IIS and Crystal Reports 8.5

O/S: Windows XP, 2000s

Project Description: National Health Services is a trust established by the Govt. of UK, which is responsible for providing health care services across the UK.

i-Patient Manager provides a highly intelligent data store for totally integrated patient information system. It has flexibility and functional breadth to extend beyond traditional care boundaries to support acute care, community care, mental health; child health, aged care and social services. Integrated information-access supports all those healthcare professionals involved in care delivery with the same accurate, timely information to enhance performance and improve communication.

i-Patient Manager module is an exhaustive and detailed patient tracking system which includes major modules like Registration, Referral, Appointment, ADT, Day-Care, Out Patient Management, Ward Management, Document Templates, MRD, Reports etc.

Responsibilities:

Acting as primary contact to the first line support.

Getting clarification from the client through first line support

Installing, configuring, administering and securing Development servers

Troubleshooting performance issues and fine-tuning queries and stored procedures

Backup and recovery management

Production support through on line quarries

Preparation of Build Request Documents

Allocation and follow-up of tasks status with the team.

Change Request Management

Dealing with VSS for any code changes

Preparing Unit Test Cases, Code Review Report Documents

Updating the online defect tracking system for the issues delivered

Supporting QA team

Participating in weekly/monthly/quarterly review meetings

Publishing status reports to PM

#2

Project Name: HIRePS - AMC

Role

Module Lead

Organization

Wipro Technologies

Duration

Oct/2004 – Jan/2006

Modules

Registration, ADT, Ward, IP Billing, OP Billing, Admin, HR, Payroll, Reports

Client

Apollo Hospitals

Software

Database: SQL Server 2000

Environment: VB 6.0, COM/DCOM and Crystal Reports 8.5

O/S: Windows 97/NT

Project Description: HIRePS (Hospital Information Resource Planning System) is an integrated suite of software systems that covers all aspects of managements and operations of a Hospital. It is designed to help achieve best clinical and financial outcomes, optimal financial performance and most importantly patient and employee satisfaction.

The HIRePS architecture is based on MS Windows three-tier model. The presentation layer consists of thin Windows Client applications developed in Microsoft Visual Basic 6.0. All the Client applications connect to the Business logic components hosted on Microsoft Transaction Server (MTS) in the Business Service Layer.

Responsibilities:

Production support

Query optimization, performance tuning

Writing Stored Procedures, Triggers and UDFs

Creating and updating tables

Configuration and managing database replication on production server

Generating daily operational reports

Disk space and security management

Creating, scheduling and monitoring jobs

Performing daily checkup activities on the databases

Environment setup for System testing & pre-production

Analyzing Change request and preparation of FD, TD and DB documents

Preparation of Impact analysis documents on the Change Requests

Monitoring and Maintenance of Database servers

Backup and restore databases

#1

Project Name: Hospital Information System

Role

Developer

Organization

Wipro Technologies

Duration

Oct/2000 – Sep/2004

Modules

HIS Integration with Financial Accounting Systems (Tally, Peachtree, Oracle Financials), Financial Accounting System

Clients

Century Hospital (Kerala), Apollo Clinics (New Delhi, Goa),MAX Hospital (Mumbai), Wockhardt Hospital (Mumbai), Fortis Hospital (Chandigarh), ISIC Hospital (New Delhi), Apollo Gleneagles Hospital (Kolkata) and Apollo Hospital (Chennai)

Software

Database: SQL Server 2000

Environment: VB 6.0, Printer Objects, Crystal Reports

O/S: Windows 97/NT

Project Description: Hospital Information System is a comprehensive solution that automates the clinical, administrative and supply-chain functions and enables the healthcare providers to improve their operational effectiveness, consequently reducing costs and medical errors, while enhancing quality of care. Hospital Information System has 20 robust functional modules all integrated seamlessly to each other and is deployed in some of the biggest hospitals across India, the Middle East and in APAC regions.

Responsibilities:

Demonstration of existing applications and features

Preparation of functional gap reports

Requirements gathering and analysis

Preparation of technical documentation

Code development using VB and T-SQL

Unit & Integration Testing

Functional testing

Production role out & support

Participating in weekly review meeting with PM,TL

Reports Development using Crystal Reports and Printer Objects

Updating the existing Printer objects w.r.t various models of Printers

Creating and scheduling jobs and reports

Interacting with customers, vendors for Integration and support

Designing and Developing integration engines for external accounting systems

Preparation of user manuals, installation documents and end user training guides

End user training and assessment

HIS Implementations at customer locations

Strengths Includes:

Excellent Domain knowledge on HealthCare, Accounting, Insurance, Emergency and Public Health with Excellent analytical and communication skills.

Excellent Presentation and Documentation skills

Self motivated with positive attitude

Can easily adopt into any kind of work environment

Contact this candidate