Sql Server Data

SRINATH KUMAR PANDA

E-mail:*************@*******.***

Mobile No: +1-973-***-****

Senior database professional, with 17 + years of experience encompassing a wide range of skill set, roles and industry verticals. Experience in leading and managing teams. Handled multiple roles - Project Lead, Database Architect, Developer and Database Administrator in various assignments till now.

Technical Expertise – (SQL Server 2016/2014/2012/2008/2008 R2/2005/2000)

Business Analyst\Technical Architect

1.Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow (logical and physical data base modeling), Process Models, E-R Diagrams.

2.Understand new requirement, prepared SRS document, involved in high level design, involved in physical design of database/data mart/data ware house, design document, implementation, Testing (unit testing, functional testing, system integration testing), Test cases, Release and test/production deployment, defect analysis/tracking/resolution etc.

3.Conceptual knowledge in Mongo DB,AWS, Data Analytics, RDS .

Senior Database Administrator

1.Extensive experience in Installation (SQL 2016/2012/2008/2005/200), Configuration and Updates of SQL Server on both STAND ALONE and CLUSTER server using batch script as well as manual procedure.

2.Expertise in Deploying and Consolidating Multiple Instances over Clustering Environment and Remote Installations.

3.Expertise in SQL Server Storage Structures, Security Architecture for databases residing on SAN storage and GPT migration process at multi node cluster environment.

4.Expertise and depth understanding on SQL server Cluster Administration (Active-Active, Active-Passive) MOUNT POINT, RESOURCE,ROLES, NODE, VIP, CORUM, MSDTC etc.

5.Strong experience in SQL Server 2016 Always-On: Distributed Availability Groups (DAG), Always-On Availability Groups (AAG), Mirroring, Log Shipping, Replication (Snapshot, Transactional & Merge), Backup/Recovery and Security Management operations with outstanding troubleshooting capabilities.

6.Implemented the new features like Distributed Availability Group (DAG), AAG,data compression, online indexing, Contained Databases, security principals in recent project(s).

7.Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.

8.Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and Foglight (third party tool from DELL).

9.Experience in using DMV and dynamic management functions for finding out long running queries.

10.Extensive experience in controlling the User Privileges (Resolve the Orphan user issue), Monitoring the Security and Audit issues as per Standards.

11.Expertise in database backup (Native – Disk backup, Lite speed, TSM Backup, Legato\EMC) process

12.Expertise in DB Integrity Check/Index &Statistics Maintenance using Ola Hallengren maintenance plan/script

13.Expertise in design/development/deployment/scheduling SQL server Jobs (Application, Maintenance)

14.SQL server patches\hot fixes (SQL 2008 SP4, SQL 2012 SP3 + CU3, SQL 2014 SP2, SQL 2016 CU2)

15.Experience on Data center servers and handling multiple TB databases (maintenance/troubleshooting).

16.Developed many utility using POWER SHELL and batch script for daily housekeeping of databases.

17.24 X 7 Production Database on Call Support

Database Developer

1.Experienced in programming tasks like Stored Procedures, Triggers, Cursors, Functions, Views, XML Parse, and Distributed Transactions using SQL Server 2016/2014/2012/2008/2005 with T-SQL.and extended C++ OR embedded SQL in C# . net programming language.

2.New Requirement

a.Understand new requirement

b.Prepare DEIGN document (new table structure, definition of new SP, Function, Triggers, Views )

c.Coordinate with principal data modeler to review the data base design/structure to implement new requirement

d.Developing stored procedure (input/out parameter, declaration, implementation of business logic, inner SP), unit testing of each stored procedure/function

e.Creating views/triggers as required

f.Involve in UIT/SIT at test environment.

g.Fix the bug, which noticed during SIT at test environment.

h.Release/deployment plan with all deliverables (DDL, DML, script for SP/Function/View/Triggers)from database perspective.

3.Reverse Engineering Project

a.Understand existing system

b.Prepare SRS, database dictionary (existing database structure – tables, FK, PK, Indexes, Usage of each table and column, SP, Function, Triggers, Views )

c.Prepare DEIGN document (new table structure, definition of new SP, Function, Triggers, Views )

d.Coordinate with principal data modeler to review the data base design/structure to implement new requirement

e.Developing stored procedure (input/out parameter, declaration, implementation of business logic, inner SP), unit testing of each stored procedure/function

f.Creating views/triggers as required

g.Involve in UIT/SIT at test environment.

h.Fix the bug, which noticed during SIT at test environment.

i.Release/deployment plan with all deliverables (DDL, DML, script for SP/Function/View/Triggers)from database perspective.

BI Developer\Data Migration Expert

1.Experience in BI Development/Deployment of DTS, SSIS packages from various source like MS-Access/ Excel/Oracle/DB2.

2.Involved in Huge data migrations projects (SQL 2000 TO 2005, SQL 2005 TO SQL 2008 and SQL 2008 TO SQL 2012) using utilities like DTS, SSIS, Bulk Copy Program (BCP) and Bulk Insert.

3.Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

4.Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

5.STAR and SNOW FLAKE schema.

6.Design and develop data migration script and procedure using T SQL

7.SQL Server Analysis Service (Designing &developing OLAP CUBE, DSV, dimension,MDX scripting)

8.Extensive experience in Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies.

Oracle DBA/Developer

1.I have worked as part time ORACLE DBA in BP (British Petroleum) GLOBAL assignment.

2.I had worked as Oracle developer and had been responsible for writing SP/Function/Triggers/Views etc using PL/SQL

Other Programming Language

1.Strong knowledge in VC++ and C++ for designing and developing of system programming (Windows API and simulation)

2.Client server support, Unified Messaging, LDAP, Interface

Other Area of Expertise

Anti-Virus Solution and Microsoft Exchange Server

System Programming (Using C++ and VC++ for NT Security, Access Control)

Exposure in CITRIX

Internal quality Audit-

Team\People management/ Client coordinator

Domain Experience

Electronics

Industry

Distribution – (Consumer Product)

Life Science,

Health Care and Pharmaceutical,

Logistics,

Material Management System

Work Experience

Currently Working as Technical Manager with IBM India Private Limited for UPS work location MAHWAH, NJ, USA

Worked as a Lead Technical Consultant with Enterprise System Solutions Pvt Ltd.

Worked as a RA in INDIAN INSTITUTE OF TECHNOLOGY, NEW Delhi

Education

Master in Computer Application from Utkal University (Session 1995-1998)

Certifications

PM-99G training certification

Got ISO Certified as an Internal Quality Auditor

Fundamentals of Lean Six Sigma

Achievements

Received SPARK and TCA award for year 2015 for my technical contribution across the organization

Received star performer award for year 2014 for my technical contribution across the organization

Received SPARK award for year 2013 for my technical contribution across the organization

Received Eminence and Excellence Recognition (E&E) award for year 2012 for my technical contribution across the organization.

Selected for best resource award (technical) on year 2010 and 2011 for my outstanding contribution on various project assignment.

Software Skills

Database : SQL2016/2014/2012/2008/2008 R2/2005/2000, Oracle 9i,

Tools : RATIONAL ROSE, MS-VSS, TOAD

Data Modeling Tools : ERWIN, Microsoft Visio, UML

ETL Tool : Microsoft DTS, SSIS, Data Stage

OLAP Tool : SSAS (SQL Server Analysis Services)

Reporting Tool : SSRS, Business Objects 6.0

Project Management Tool : Microsoft Project, RPM

CM Tools : Clear Case, VSS

Application Server : IIS

Programming/Scripting Languages

T-SQL, PL/SQL, VC++, C++, C, MDX Quires

Professional Experience

United Parcel Service

12/14 to Present

Technical Manager – MS SQL Server

The UPS Centerpiece Project worked to develop and deploy database system (systems, application and products in data processing) for all UPS businesses and geographies using manufacturing integration and intelligence. This project involved the design, analysis, development and deployment of a suitable database system, which will provide common global supply chain and financial process information to provide procurement leverage, improvement customer service processes, enable global logistics management and develop reports for tracking financial, inventory and sales, and information based on sales orders, deliveries, shipping, and profit centers.

As a Technical Manager in the SQL Server Database Administration/BI area, responsibilities include supporting various applications from a database perspective, including: SQL installation, automated batch creation, Always On, mirroring and replication.

Installed and administered 16 node cluster (Active-Passive) for 14 SQL 2016 instances on 2 data centers in Microsoft Windows Server 2012 Enterprise Edition on a SAN environment.

Implemented and troubleshot DAG (Distributed Availability Group)/ AAG (Always On Availability Group) between the primary and secondary data center (server/instance) for SQL 2016/2012 Test/Production environments.

Implemented and troubleshot SQL Server DB mirroring on cross data center for SQL 2012/2014 Test/Production environments.

Implemented and troubleshot SQL Server replication (Snapshot/Transactional), replication latency, subscription failure for various locations for SQL Server 2008 Test/Production environments.

Worked on Mirroring/Always On /DAG Switch Over/Back process within data center as well as across different data centers.

Migrated (side by side migration) SQL Server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) from a build/deployment perspective.

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012 in the Production environment.

Expert in using DMVs, performance dashboard, database snapshots and tracking performance counters.

Rebuilt and monitored the indexes at regular intervals for better performance.

Recovered the databases from backups in disasters and implemented point-in-time recovery solutions.

Troubleshot and fine-tuned databases for performance and concurrency.

Involved in source data analysis and analysis and designing mappings for data extraction. Responsible for the design and development of SSIS packages to load the data from various databases and files.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

Expert in implementing the snapshot isolation and DDL triggers.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved: index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Implemented data partitioning and error handling through try-catch-throw statement and Common Table Expressions (CTE).

Performed installation of SQL Enterprise 2012 SP3+CU3, SQL 2014 SP2, SQL 2008 SP4 (64bit version) on Windows 2012 SP1 Clusters (HP Servers in enterprise data centers).

Worked on deployment of SQL Server 2008 SP4 along with July 2015 security pack, SQL Server 2012 SP3 along with CU3, SQL Server 2014 SP2 and SQL 2016 CU2 on Test/Production environments.

Worked on the SSL-SHA Type-2 migration project for SQL 2012 instances.

Performed impact analysis and design of new requirements, creating technical specs for development and prepared an implementation plan.

Identified the process that needed to be improved/recreated and designed it in SQL Server database to meet the business requirements.

Performed system testing and ensured quality procedures were followed with the Development team.

Architected solutions for the business processes using SSIS and SSRS.

Environment: SQL Server 2000/2005/2008/2008 R2/2012/2014, T-SQL, MS DTS, SSIS, SSAS, SSRS

Medtronic, Inc.

08/11 – 11/14

Technical Leader – MS SQL Server

Served as a Technical Leader in the SQL Server Database Administration and MS-BI area and was responsible for build/installation/database setup, configuration of latest features ALWAYS-ON/MIRRORING/REPLICATION design/development of DATA WAREHOUSE/MART, Database migration (design/development of ETL/REPORTING process) for supporting around 200 application(s) across Medtronic.

Installed and administered SQL on multi node cluster (Active-Passive) for SQL 2012/SQL2008 instances across the data center in Microsoft Windows Server 2012/2008 Enterprise Edition on SAN environment.

Implemented, troubleshot and facilitated support for the switch over/back of SQL Server AAG and DB mirroring on cross data center for SQL 2012 Test/Production environments.

Migrated (side by side migration) SQL server 2005 to SQL Server 2008 in Microsoft Windows Server 2008 Enterprise Edition.

Extensively worked on SSIS and SSRS from a build/deployment perspective.

Expert in using DMVs, performance dashboard, mirroring, database snapshots and tracking performance counters.

Performed monitoring and made recommendations for performance improvement in hosted databases. This involved: index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Worked on deployment of SQL Server 2008 SP3, SQL Server 2012 SP1 on Test/Production environments.

Performed the impact analysis and design of new requirements, created technical specs for the development and prepared the implementation plan.

Performed testing of the system and ensured quality procedure were followed within the Development team.

Environment: SQL Server 2000/2005/2008/2008 R2/2012, T-SQL, MS DTS, SSIS, SSAS, SSRS

BP International

04/10 – 07/11

Technical Leader – MS SQL Server

BP Inc. is a global energy company headquartered in London, UK. It is the third largest energy company and the fourth largest company in the world. Our project team was responsible for development, enhancement and support of the complete suite of applications.

Served as a Technical Leader in the SQL Server Database Administration area, responsible for supporting various applications from a database perspective, including: SQL installation, mirroring and replication.

Installed and administered SQL on multi node cluster (Active-Passive) for SQL 2008 instances across data center in Microsoft Windows Server 2008 Enterprise Edition on SAN environment.

Worked on MS Analysis Service (OLAP) and MS Reporting Service build/deployment to assist the Microsoft Project Server team.

Migrated (side by side migration) SQL Server 2005 to SQL Server 2008 in Microsoft Windows Server 2008 Enterprise Edition.

Rebuilt and monitored the indexes at regular intervals for better performance.

Analyzed new requirements, captured the requirement into the requirement specification document, participated in the design phase and was involved in the DB designing, data analysis, purging, growth, etc.

Environment: SQL Server 2000/2005, T-SQL, MS DTS, SSIS, SSAS, SSRS

AmerisourceBergen Corporation

07/07 – 03/10

Technical Leader – MS SQL Server

AmerisourceBergen Corporation is one of the largest Pharmaceutical Distribution companies in US. Customers include retail pharmacies, chain stores, hospitals and clinics. Our project team was responsible for the development/enhancement and support of the complete suite of Supply Chain applications.

Served as a Technical Leader in the SQL Server Database Administration area supporting various applications.

Installed/administered SQL on multi node cluster (Active-Passive) as well as standalone for SQL 2008/2005/2000 instances across the data center in Microsoft Windows Server 2008 Enterprise Edition on a SAN environment.

Performed business analysis, technical analysis, systems design and application software programming.

Restructured the stored procedures and designed, coded and developed the same using T-SQL programming.

Managed the migration of SQL Server 2000 databases to SQL Server 2005.

Extensively worked on data partitioning and snapshot isolation in SQL Server 2005.

Prepared the project management and technical documentation.

Unit tested SSIS packages with respect to flow and performance issues.

Managed Veritas NetBackup, TSM Native and LiteSpeed backup.

Extensively worked on DBCC commands and dynamic management objects.

Analyzed long running, slow queries and tuned the same to optimize application and system performance.

Designed many numbers of critical SQL jobs and configured properties as per the business requirement.

Environment: SQL Server 2008/2005/2000, T-SQL, SSIS, DTS, Clear Case

Philip Morris International

01/07 – 06/07

Technical Leader – MS-OLAP

GENESIS Layer B is a product quality management application of PMI that has three applications: AQA (Analytical Quality Audit), PQA (Physical Quality Audit) and MQA (Material Quality Audit).

Served as a Senior OLAP Designer using the MS SSAS OLAP tool and analyzed new requirements, captured the requirements in a specification document and participated in OLAP design phase and OLAP design document. Implemented the requirement and obtained application sign-off.

Designed the data source views (DSV), Cubes, Dimensions, Fact Tables, Measure and Measure Groups as per the business requirement for each module.

Defined the dimension’s hierarchies and attribute hierarchies for each dimension and respective cube.

Environment: SSAS, SSIS, T-SQL, MDX

Ricoh Family Group

08/06 – 01/07

Technical Leader – ETL–DS

This assignment was an integration project for Ricoh Family Group (RFG). We have 3 different modules like Message Broker (MB), Oracle Apps and Data Stage and they are communicating with each other by different interfaces.

Served as a Technical Leader in the Data Stage team and involved in Data analysis (data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions), business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development activity.

Worked in design/development/testing/documenting of ETL jobs/mappings in server (using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector) and parallel jobs (using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML components) to populate tables in Data Warehouse and Data marts.

Worked with Data Stage Manager/Designer/Administrator/Director for integration of various data sources (DB2-UDB, Oracle,) into data staging area.

Worked as BUSINESS ANALYST (communicate with the client and collect the business requirement for each interfaces for the data migration, prepared the High Level Milestone Planning/ template for issue list/ detailed design document/ ETL coding standard for each interfaces or data conversion object ) role in this assignment

Environment: Data Stage, Oracle Apps, Message Broker, RPM, Clear Quest

Maersk Group

04/05 – 08/06

Technical Leader – MS SQL Server

The assignment was a re-engineering and conversion project of the existing module(s) which had developed using Silver Stream (Java) interface. We were assigned to understand the existing system and migrate the existing architecture to new environment C#.net and SQL Server and integration of various components.

Served as a Technical Leader in SQL design/development team and involved in client communication/collect the business requirement / map of those requirement to data architecture, prepared design document/ Milestone Planning/ template for issue list / Test cases/embedded SQL coding standard for each module in this assignment.

Worked in design/development/testing of embedded SQL COMMAND using various features of SQL 2005 version.

Designed database (physical) for the new requirement and was responsible for managing/supporting the database environment from SQL DBA perspective(backup/maintenance)

Worked on team management/task assignment/release procedure for each module.

Environment: SQL Server 2005, C# .net, DTS/SSIS, Microsoft Project

End2End, Inc.

08/03 – 03/05

Technical Leader – MS SQL Server

The assignment was a re-engineering and conversion various modules of ARMS (Automated Records Management System) product, which have been extensively used by US security agency in the smaller population cities, towns, college campuses, airports, etc. We were assigned to understand the existing system and migrate the existing architecture to new environment C#.net and SQL Server and integration of various components of this ARMS product.

Served as a Technical Leader/BUSINESS ANALYST and involved in client communication/collect the business requirement / map of those requirement to .Net Framework/data architecture, prepared design document for various components/stored procedure/database migration strategy/ High Level Milestone Planning/ template for issue list / Test cases/ SQL coding standard for each module in this assignment.

Worked in modules like CAD, Case Management, Master Name, Department Vehicles, Training, Crime Codes, Investigation, Arrest, Property etc

Worked in design/development/testing of SQL Server Procedure/function/view/data migration process using various features of SQL 2000 version.

Designed database (physical) for the new requirement and was responsible for managing/supporting the database environment from SQL DBA perspective (backup/maintenance).

Worked in DTS for the data migration activity from existing system to the new system.

Environment: SQL Server 2000, C# .net (7), DTS, Microsoft Project

H2H Solutions Inc.

04/03 – 08/03

Developer– MS SQL Server

The assignment was for developing a product (ADAPTER) for HIPAA to establish the required use of national transaction standards when performing the business transactions between organizations electronically. The product also addressed the security and privacy of health data.

Served as a database developer and involved in development/design of sql databases (physical design) for various interfaces using sql server 2000 version.

I had been assigned to analyze the business requirement and map those requirement in to sql server in the form of SQL Stored Procedure / Function/Views etc.

Worked in modules like 5 modules such as SUBSCRIBER, PROVIDER, DESTINATION PAYER, and CLAIMS and COMMUNICATION.

Environment: SQL Server 2000, Java, DTS, Microsoft Project

vCIS Inc., Australia

04/02 – 04/03

Developer– C++/VC++

The assignment was for developing a product next generation anti-virus solution. The approach used in this system was to attacking classes of viruses instead of individual viruses. Viruses belonging to a specific class have a common behavior pattern. It would use this behavior pattern to detect all the viruses (existing and new) in that class. Before any new executable code is allowed to run in the real PC, it is first made to execute in a Virtual PC or VPC.

Served as a C++/VC++ developer and involved in designing/developing the WRAPPER class and written interfaces for simulation of various windows API

I had been assigned to develop the simulation program for API group such as Access Control, Security, Communication, Internet & User Interface Resources, Data Conversion, COM and RPC using C++ with VC++ frame work.

I had written test program for several API and performed integration testing of wrapper/LLE/VMOS32 for the above group.

Environment: VC++ &C++ (SDK, Win32 API), Microsoft Project.

Reader's Digest Association, Inc.

11/01 – 04/02

Developer– C++/VC++

Readers Digest had implemented a Universal Marketing Database (UMD) to maintain all related customer information. Our team had been assigned for the development, testing and integration of transaction modules to validate transform and post specific vendor information regarding business events specific to the UMD data store.

Served as a C++/VC++ developer and involved in designing/developing the interfaces for Validation, Transformation and Posting modules.

I had written wrapper class for Singles Sales Order, Single Sales Cancel, Singles Sales Shipment and Posting using C++ with VC++ frame work.

Environment: VC++ &C++ (SDK), Oracle, Microsoft Project.

Blue-Silicon, Inc.

10/00 – 10/01

Developer– C++/VC++

This project was for designing the ADSI interfaces for messaging system and it architecture hosted by Blue Silicon in its data centers deployed across the whole world. Microsoft Exchange 2000 used as Messaging server and Active Directory Services as a Directory server.

Served as a C++/VC++ developer and involved in designing/developing the interfaces for ADSI objects, wrapper class to communicate between Cache Server and notification servers using C++ with VC++ frame work.

Environment: VC++, ATL, C++, COM, SQL-SERVER7.0, Microsoft Project.

Redsalsa Technologies Inc.

01/00 – 09/00

Developer– C++/VC++

This project was for designing and developing a product for HR operations like Human Resource, Global Staffing Service, Project Management, Infrastructure, and Finance & Accounting.

Served as a C++/VC++ developer and involved in designing/developing/testing the interfaces and wrapper class for various sub modules like Joining, Induction, Transfer, Promotion and Transit using C++ with VC++ frame work.

Environment: VC++, ATL, C++, COM, SQL-SERVER7.0, Microsoft Project.

Frontier Systems Consulting, Inc.

04/99 – 12/99

Developer– C++/VC++

This project was for designing and developing a product to automate all the functionality of TRAINING department.

Served as a C++/VC++ developer and involved in designing/developing/testing the interfaces, components and wrapper class for various sub modules like class, course, schedule using C++ with VC++ frame work.

Environment: VC++, ATL, C++, COM, SQL-SERVER7.0, Microsoft Project.

Indian Railway - S&T Department

10/98 – 03/99

Developer– C++/VC++

This project was for designing and developing an application to deal with the stock of the materials in engineering stores of Signal & Telecom Department of South Eastern Railway.

Served as a C++/VC++ developer and involved in designing/developing/testing the interfaces, components and wrapper class for various modules like Material storage, Overhead stock movement of the department, Purchase order, book keeping & its financial credibility using C++ with VC++ frame work.

Environment: VC++, ATL,C++,COM,SQL-SERVER7.0, Microsoft Project.

PERSONAL DETAILS:

Sex Male

Passport: Valid Passport till 2020

Contact this candidate