Arvind Ganotra

***** ***** ***** **

Ashburn VA *0148

703-***-****. aceatf@r.postjobfree.com

Over 15 Years of IT experience

●

Certified in MS SQL Server, Sybase and Java

●

Lead Project Developer for complete Software Development Life Cycle.

●

Provided 7x24 support for fortune 50 company mission critical applications

●

Great problem solving capabilities

●

Self-motivated and innovative

●

Experience with mentoring and leading people both IT and non IT

●

Summary: Over 15 years of IT experience with main focus in database management using multiple RDBMS including

latest versions of MS SQL Server, Sybase, Oracle and UDB DB2 and server. I worked on several projects from initiation

to deployment covering complete SDLC.

I have supported various mission critical production applications as Lead Developer, Solution Architect and Production

Support DBA on various platforms. I’ve expertise in data modelling, design, ETL development, high availability, cluster

server, disaster recovery, release and deployments, performance tuning, data capture and data transfer, migrations from

Oracle, Sybase and UDB to MS SQL Server, upgrades and change management.

I am self-motivated and innovative. Having versatile experience with great communication skills enables me to be a great

team player and quickly resolve complex problems.

Technical Skills

Platforms .Net Framework 4.5, 4 and 3.5

RDBMS: MS SQL Server 2012, 2008 R2, 2008, 2005 and 2000, SQL Server 7.0 Oracle 8, 10g,

Sybase 15.0/12.5.3/12.1/11.9.2, Sybase Replication Server, UDB DB2 Version 9

ETL: SQL Server Integration Services (SSIS), BO Data Integrator, WebSphere Federation Server

Languages: C#, T-SQL, PL/SQL, C#, .Net, ADO, OLE DB, ODBC, JAVA, PERL, C/Born/Korn Shell,

HTML, JavaScript, JSP, JDBC, Servlets, RMI,

Tools: Visio 2003, Crystal Reports 8.5 and 2008, Excelcius, ERWin Data Modellar, autosys,

DBArtisan, ClearQuest, ClearCase, Dreamweaver MX, WinSql, Tivoli, Remedy,

PCAnywhere, Veritas Cluster, Oracle Enterprise Manager (OEM), MS Office, MS Project

2000. Quest Foglight and Spotlight

BI Tools: SSIS, SSRS and BO

OS : Windows 2003//2000/98/NT/3.1, Sun Solaris 2.10/2.9/2.8/2.6, HP-UX 10.0/11.0

Web Server: IIS, Weblogic and Apache

Education and Trainings

BS in Engineering (Bangalore University) Jun 1986-90 Bangalore, India

Performance and Tuning: Configuring Adaptive Server Enterprise May 2007 Bathesda, MD

Advanced Replication Server Admin: Sybase Education Services Jun 2003 Washington DC

Microsoft SQL Server 2000 for Experienced Database Professionals Oct 2002 Washington DC

Oracle 9i for Experienced SQL Users: Oracle University Aug 2002 Washington DC

Oracle 8i Database Architecture and Admin: NIIT Mar 2002 Delhi, India

Sybase Performance and Tuning Configuring ASE: Sybase Aug 2001 Washington DC

Microsoft SQL Server DBA Nov 2000 Delhi, India

Resume of Arvind Ganotra Page 1

Computer Course covering Relational Database Design June 1997 Delhi, India

Using Oracle 7.0 with Forms 4.5 and Reports 2.5 June 1997 Delhi, India

Certifications

MCSA: SQL Server 2012

●

MCITP DBA: Microsoft SQL Server 2005 and 2008

●

MCITP DEV: MS SQL Server 2008

●

Sybase Certified Adaptive Server Administrator Version 12.5 (ASEV12.5)

●

Sun Certified Programmer Java 2 from Sun Microsystems

●

Work Experience:

MicroPact Duration: December 2013 to Current.

MicroPact specializes in commercial off the shelf (COTS) solutions for US Government agencies and Fortune

500 corporations. Today MicroPact product entellitrak is used by more federal agencies than any other BPM

product.

Role: Database Engineer

Environment:

SQL Server 2005 to 2012, Oracle 10g and 11g, Symantec Backup Exec, Tomcat 6, SSIS

Projects in Hand:

1. Redesign of Database Architecture for Reports using Column based storage.

2. Migrating all databases to SQL Server 2012

3. Automation of Database Restores

4. Planning for Disaster Recovery

5. Virtualization of Database Servers

6. Implementation of Domain Authentication instead of SQL Authentication for Databases

7. Redesigning Data Model for Multiple ORGs, Teams and Role based authentication, somewhat similar to

Microsoft Dynamics design principals.

Department of Homeland Security (DHS) Component Duration: Jan 2013 to November 2013

Employer: Insight Global, McLean VA

Project Assigned to: Hewlett-Packard, USA

Role: Data Migration Lead and Data Tier Solution Architect

Project: Microsoft Dynamics CRM Solution to improve logistics.

Environment:

.Net 4.0, Visual Studio 2010, Microsoft Dynamics CRM 2011, SQL Server 2008, 2012

Projects in Hand:

1. Installation, deployment, data migration for COTS product DefenseReady.

2. Design infrastructure for the Microsoft Dynamics CRM 2011/ SQL Server 2008/2012

3. Migration of the existing data from Oracle, MS Access to Microsoft Dynamics CRM 2011/ SQL Server

2008/2012

4. Data modelling using ERWin and Visio.

5. Data mapping of the interfaces using business transformation rules.

6. Documentation of Data Migration and System Engineering Plan.

7. Identify and Map CRM entities to entire Data and Process Flow diagrams.

8. Design, develop and deploy SSIS ETL packages for initial one time load and incremental processing of

the data changes.

9. Migration of existing reports to SSRS and MS CRM.

Resume of Arvind Ganotra Page 2

Rhode Island DMV Duration: August 2012 to Feb 2013

Sub on the Contract: Ventera Corporation, Reston VA

Project Assigned to: Hewlett-Packard, USA

Role: Data Integration Team Lead and BI Solution Architect

Project: Upgrade, migration and deployment of Rhode Island DMV on .Net/SQL Server platform

Environment:

.Net 4.0, Visual Studio 2010, BI 2008 R2, MS SQL Server 2008 R2, Windows 2008, .Net, Broker Service, SSAS,

SSRS 2008 and SSIS 2008, Clustering Service (High Availability), ERWin r7.3, Visio 2010.

Projects Completed:

Translated business vision and strategy into enterprise change by creating, communicating and improving the

1

key requirements, principles and models that describe the enterprise's future state and enable its evolution

Complex analysis of business structure and processes

2

Requirement gathering and completing User Stories

3

Data designing, planning, development of data model, stored procedures, function, views, etc.

4

Designed SSIS (ETL) packages for scheduled and on demand extraction, processing and reporting of the data.

5

Skills Used:

Visual Studio 2010 and 2008 BIDS, .Net 4, MS SQL Server 2008 R2, SSIS, SSRS, SSAS, Report Builder 3.0, CA ERWin

Data Modeller r8, Visio 2010, Team Foundation Server.

Employer: Randstad

Project Assigned to: American Systems, Chantilly VA

Project Assignee: Department of Defence

Role: Data Tier Solution Architect and SQL Server SME

Duration: April 2010 to Oct 2012

Project: Synchronized Pre-deployment and Operational Tracker (SPOT), an application development project at the

defence Manpower Data Centre (DMDC). The application development project is a redesign of a government contractor

operations tracker application- Synchronized Pre-deployment and Operational Tracker (SPOT). SPOT provides authorized

users throughout the Federal Government with secure access to historical and near-real-time information that allows

insight and the capability to dynamically affect ongoing contractor operations, and perform comprehensive analytics of

prior activities.

Environment:

MS SQL Server 2008 R2, Windows 2008, .Net, Broker Service, SSAS, SSRS and SSIS, Clustering Service (High

Availability)

Projects Completed:

Data designing, planning, development of data model, stored procedures, function, views, etc. of 5 application

1

enhancement release.

Data designing, planning, development of data model, stored procedures, function, views, etc.

2

Architecture and implemented Three Node Cluster Architecture to host 2 applications for High Availability.

3

Designed Mirroring architecture to support reports with 5 minute latency.

4

Leveraged broker service for transferring data from NIPR to SIPR...

5

Custom dashboard for Performance Analysis of OLTP databases and monitoring Data Transfer through broker service.

6

Migrate from SQL Server 2005 X86 to SQL Server 2008 R2 64 bit server.

7

Migration of SQL Server Reports from SSRS 2005 (with Dundas Charts) to SSRS 2008 with Report Viewer 2010 without

8

Dundas Charts.

Resume of Arvind Ganotra Page 3

9 Fix bugs with SSAS cubes received from development done by the old organization.

10 Designed architecture for 3 node Windows cluster to support two SQL Servers with failover capability. This architecture

saved the cost of one additional server normally required for conventional architecture.

Implemented SQL Server Mirroring with new architecture that has snapshots and dynamic views on mirrored site for

11

Reporting capability.

Designed and implemented transactional replication for Reports.

12

Design and setup of Dashboard for Database Usage, Broker Service monitoring, index usage and Performance Monitoring

13

using SQL Server dynamic views.

Enhance Production server Monitoring and Notification.

14

Disaster Recovery, Design, documentation and setup for disaster recovery.

15

Built and maintain the Data dictionary using Red Gate Docs.

16

Prepare scripts for Build automation and deployment for the Release.

17

Built repository of all databases in Visual Studio 2010 Team Foundation Server and synchronized schemas in all

18

environments.

Prepared Visual Studio project for Database build automation and deployment.

19

Designed package for automation of Document Load in database using SSIS Package and Excel 2010.

20

Project Environment:

SPOT Enterprise System: SPOT ES stands for Synchronized Pre-deployment and Operational Tracker – Enterprise Suite.

It is the joint enterprise suite of systems employed for the management, tracking and visibility of contracted capability and

contractors authorized to accompany U.S. forces overseas.

Four systems comprise SPOT ES:

SPOT NIPERNet and SPOT SIPERNet are the .NET based applications. Application provides access to search

and mange deployments of the contractors.

JAMMS Joint Asset Management System: supports data feed from web services, data scans converted to XML

files from site and loaded to SPOT NIPERNet via SSIS packages.

TOPSS – Total Optional Picture Support System: Extends the capabilities of SPOT and JAMMS with advanced

analytics and reporting. It is a Business Intelligence Solution that provides dynamic, ad hoc reporting on a Service

Oriented Architecture.

Role: Database Solution Architect, Design, Development, Deployment and assisting OPS DBA during major issues.

Performance analysis: physical modelling, index tuning, query analysis, load analysis, reducing network chatting.,

NIPR/SIPR Architect.

Skills Used:

MS SQL Server 2005/2008, SSIS, SSRS, SSAS, Visual Studio 2010 and 2008 BIDS, Report Builder 3.0, RedGate

SQLCompare and SQLDoc, CA ERWin Data Modeler r8, PowerShell, SQL Profiler, SQLSentry, Visio, Team

Foundation Server, Windows 2008 Cluster and VMWare.

Employer: Princeton Information

Project Assigned to: SRA International, Inc.

Project Assignee: Department of Justice

Duration: June 2010 to November 2010 (Part Time)

Project: Data Migration across the platform from Oracle/UDB to SQL Server 2008 R2.

Major challenge: Throughput degraded when compared to UDB database. The single insert was taking 21

seconds on SQL Server as against just over 1 second on UDB. After I joined the issue was resolved within 3

days. Inserts time reduced to 20 milliseconds on the 570 GB table that involved insert of the documents.

The database went in production within 3 months with all the testing.

Resume of Arvind Ganotra Page 4

Technology used for migration: Build custom SSIS package to extract data from Oracle/UDB and load to SQL

Server.

Role: SQL Server Consultant.

Environment: SQL Server 2008 R2, SSIS, and Windows 2008 R2 Clustered.

SharePoint Portal Server 2007, NetApp, Oracle 9, UDB 7

Skills Used:

MS SQL Server 2008 R2, Windows 2008 R2 Cluster, NetApp, SSIS, Oracle 9i and UDB 7

Major Accomplishments:

SSIS package design for migrating data across the platform from Oracle/UDB to SQL Server 2008 R2.

Tune performance within 3 days that halted the project from over 6 months.

Configure NetApp with SQL Server 2008 R2 for differential backups.

Employer: USM Business Systems, Inc.

Project Assigned to: Agilex Technologies, Chantilly VA

Project Assignee: Customs and Border Petrol

Duration: Dec 2009 to March 2010

Project: Solution Design for Data Integration and Service Oriented Architecture under guidelines from DHS and Chief

Technology Officer of CBP.

CBP System Design Documentation of Solution Design categorized under Gold, Silver and Bronze – Enterprise SQL

Server for provisioning or multiple tenancies.

The Gold Solution Design is based on Microsoft’s Always On solution. This design not only utilizes a database

cluster solution but also storage replication for disaster recovery (DR).

Role: Principal Consultant and Sr. SQL Server DBA for.Net stack of technologies.

Environment: SQL Server 2008, SSIS, Informatica and Windows 2008 R2 Clustered and Geo dispersed availability.

SharePoint Portal Server 2007, .NET Framework 3.5, ASP.Net, C#, ADO.Net, ESB Service Oriented Architecture (SOA),

Single Sign On (SSO)

Skills Used:

MS SQL Server 2008 R2, MS Windows Server 2008 R2

Resume of Arvind Ganotra Page 5

Cvent Inc. Apr 2009 to Dec 2009

Environment:

MS SQL Server 2008, MS SQL Server 2005, Windows 2008/2003,.Net, SSAS, SSRS and SSIS, Clustering Service

(High Availability)

Projects Completed:

Move applications from SQL Server authentication to windows authentication.

1

SQL Server 2008 certification and documentation for server setup.

2

Design and setup of Dashboard for Database Usage and Performance Monitoring.

3

Enhance Production server Monitoring and Notification.

4

Disaster Recovery, Design, documentation and setup for disaster recovery.

5

Projects Supported:

Event Management: A .NET based solution for with an assortment of all the tools necessary for managing events and meetings. Like

Event Registration, Email Marketing, Contact Management, Budget, Housing and Travel and Data Security Management….

Supplier Network: Cvent Supplier Network and integrated Request for Proposal (RFP) tool streamlines event sourcing and site selection

process.

Web Surveys: Provides tools for survey management, data collection and reporting tools.

Role: Production support and Database Infrastructure Design. Database security and engineering support for new developments.

Skills Used:

MS SQL Server 2005/2008, SSIS, SSRS, PowerShell

Freddie Mac Aug 2005 to Mar 2009

Sr. DBA: SQL Server

Environment:

MS SQL Server 2008, MS SQL Server 2005, SQL Server 2000, Windows 2003 (X64 and 32), WSUS, .Net, SSAS,

SSRS and SSIS, Guardium, Sybase ASE 15.1, 12.5.3, Replication Server 12.6, Solaris 2.8 and 2.10, Clustering

Service (High Availability), EMC SRDF for disk based replication, Autosys, Clear Case and Clear Quest, Remedy.

Projects Supported:

NetOxygen Loan Origination Software (COTS Application): is multi-tier architecture, designed to provide automated

lending components include a Product and Pricing engine, Loan Selection engine, Fees engine, and Business Entities and

Contacts engine.

Responsibility: Production support, performance tuning, infrastructure and version upgrade, designing archiving strategy,

scripting specific maintenance jobs, coordinating with vendor, business users, application delivery and gave presentations

to VPs and CIO.

NetOxygen's uses load-balancing and automated rules-based routing on 8 IIS servers.

Database : SQL Server version 2000. Application: .Net and VB6.

High Availability: Windows 2003 Cluster Service.

Storage: EMC Symmetrix with SRDF replication to remote server.

Replication: Transaction Replication (snapshot) and EMC SRDF disk based replication.

Archiving and Purge: Managed using DTS packages, move data from Production to Archive and Log databases.

Internet Security: VeriSign SSL 128 bit.

Role:

Conducted JAD sessions for Requirements gathering and analysis for data Intensive projects.

●

Design and create Logical and Physical data Models using ER/Studio.

●

Resume of Arvind Ganotra Page 6

Conducted Stakeholder Reviews and Data Model walk through with Developer and DBAs.

●

Lead the efforts for Standardization of data and naming standards for Data Elements

●

Create Data Definition and Meta Data repository.

●

Designed Architecture for Data Warehousing to fulfill Reporting Requirements.

●

Analyzed existing SQL Servers and Databases and made suggestions for better standards and performance

●

tuning/query performance.

Used MS SQL Server 2005 for data objects deployment.

●

Deployed physical objects including tables, views, triggers, stored procedures and Indexes.

●

Published project document and Data Models using MS Share Point.

●

Used EPLC lifecycle in compliance with Federal Govt.

●

Designed and developed Crystal Xcelsius 4.5 dashboard to monitor the data quality load for ETL

●

Skills Used:

MS SQL Server 2005, SSIS, SSRS, SSAS, ER/Studio, MS Share Point 2007

North Shore is loan pipeline system for Freddie Mac's Multifamily that track and report all phases of a loan from

seller/servicer origination to Freddie Mac asset management. Database: SQL Server version 2005.

Responsibility: Infrastructure design, data architecture, understanding operational applications and reporting requirements,

proof of concept, development, testing, migrating data, writing stored procs for data aggregation, conforming,

deployment, documentation and maintenance.

Storage: EMC Symmetrix with SRDF replication to remote server. Data Conversion: TSQL code from Sybase to SQL

Server.

Replication: EMC SRDF disk based replication.

Role:

Participate in requirements gathering sessions for data marts and other Corporate Data Warehouse (CDW) and Master

●

Data Management (MDM) efforts.

Design and create Logical and Physical data Models using ERWIN.

●

Worked on designing OLTP staging areas, OLAP data marts using star schema and dimensional modeling.

●

Presented and participated in Data Model reviews with other Data Architects and Data Management group.

●

Followed and facilitated in enhancing abbreviations standards.

●

Creates physical database objects from Model to physical database like Tables, indexes, views, and triggers.

●

Used SQL Server, Sybase, and DB2 as source databases and SQL Server 2005 and DB2 as target database.

●

Used SQL Server Integration Services (SSIS) for gathering data from multiple sources for Data Mining.

●

Used Clear-Case and Clear-Quest for configuration management.

●

Proof of Concept for using Crystal Reports 8.5 and 2008, SSRS and SSIS.

●

Skills Used:

SQL Server 2005, T-SQL, PL/SQL, ERWIN 4.1.4, TOAD, Windows 2003 Server, UNIX, ER Studio, Rapid SQL 7.3.0,

Clear Case, Clear Quest, Crystal Reports 8.5 and 2008, SSRS and SSIS

Other COTS application supported from planning to deployment:

RTS: Rule based engine uses jRule. Intranet multitier application requires 2 phase commit. Used by 46 distributed

applications in Freddie Mac.

Remedy: Service Support Tool and for change management, problem management.

CORPTAX Compliance and Fin 48 software. This was my first deployment on SQL Server 2005. Data encryption of PPI

Resume of Arvind Ganotra Page 7

data was done initially using Symmetric key and later using CA certificate. Access to database only through Active

Directory domain accounts.

Responsibilities:

SQL Server installation, upgrades, replication, log shipping, mirroring, High Availability Cluster Server setup.

●

Plan for BCP (Business Continuity Plan) and Disaster Recovery scenario. Write documentation and execute policies and

●

procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Support application for OLTP, reporting and data warehousing. Write DTS/SSIS packages for data archiving, ETL and

●

scheduled maintenance like rebuild indices, purge archive data etc.

Write TSQL code including but not limited to stored procedures, triggers, functions, rules etc.

●

logical/physical data modeling, storage capacity planning, ETL processing and optimization

●

Implement and administer SQL Server and windows security principals. Assist application team in configuring application

●

for SSPI authentication, encryption and installing SSL certificates.

Project database infrastructure requirement and Capacity planning.

●

Documenting Standard Operation Procedures.

●

Design and implement installation, migration, upgrades, business continuity plan and routine maintenance processes.

●

Database conversions and re-platform from Sybase to SQL Server.

●

Infrastructure planning, release management and performance testing.

●

Develop long-term strategic goals for production databases BPS (Business Production Support) and Project Managers.

●

Work with application development team to develop database architectures, SQL coding standards, and quality assurance

●

policies and procedures.

Assist in designing data models for new database development and changes to existing ones.

●

Network component configuration to ensure database connectivity and integrity.

●

Resolve database access and performance issues.

●

Write scripts for automation of SQL Server maintenance.

●

Develop, implement, and maintain change control procedures for modifications to databases.

●

Assist in creation of reports for business user needs.

Conduct research and make recommendations on database products, tools, services, protocols, and standards in support of

●

procurement and development efforts.

MBNA April 2005 – August 2005

DBA Quality Assurance Newark Delaware

Projects Supported:

Process Deployment Control, Auditing and Performance Improvement.

This application was designed on Native Java code using swings. Data repository was on Sybase IQ 12.5

Purpose of the project is to capture each activity of the deployment process and insert audit transaction in the database for

future analysis.

Responsibilities:

SQL Code testing.

●

Physical Modeling and versioning.

●

Capacity planning and performance tuning.

●

Refresh UAT and Test environment from Production databases, by reverse engineering the schema and data load.

●

Infrastructure planning, release management and performance testing.

●

Fannie Mae: June 2001 – February 2005

Sr. Database Administrator Washington DC

Projects Supported:

Resume of Arvind Ganotra Page 8

MORNET MBS Pool Submission System: Fannie Mae's nationwide MORNET network, runs on a heterogeneous

network of approximately 100 Unix and Windows servers. Application is developed on J2EE architecture.

Entire business logic and web interface managed through weblogic servers.

Database: OLTP on Sybase 11.9.2 and then upgraded to 12.5. All data analysis done on SQL Server 7 that

upgraded to version 2000.

Replication: Sybase Warm Standby and Peer to peer replication.

ETL: Sybase to SQL Server using DTS packages.

Internet Security and data encryption: VeriSign SSL

Other Responsibilities and departmental projects:

Providing 24X7 production support for SQL Server, Sybase and Replication Server

●

Install AND Upgrade Servers

●

Database infrastructure design, implementation, and maintenance

●

Setup principal security database and application roles to provide secure, reliable, and responsive database access.

●

Participate and provide input in application profiling for new applications; provides expert advice to application team,

●

lead developers and database/systems administration staff during the design and implementation of applications.

Coordinate the activities of other database/systems administrators as part of larger projects.

●

Prepare documentation on Database environment, as well as operational plans and procedures.

●

Automation and maintenance of scripts for routine database administration activities, full, differential and transactional

●

backups, dbcc, rebuild indices and update stats.

Database Tuning, Security Monitor and provide recommendation for performance improvements and alert for risks.

●

Perform security and version upgrades to production systems and develop procedures.

●

Hunt Technologies Jan 01 – May 01

Sr. Developer

Desktop and web based application for Order Collections

Responsibilities:

Worked closely with analysts to conceive the requirement.

●

Designed and deployed database.

●

Developed desktop GUI and web interface using JSP/Servlet.

●

Tested and Launched the application.

●

Environment: Java/RMI, SWING, JDBC, ER-Studio, MS SQL Server 2000, JSP, Servlet, JavaScript, HTML, Tomcat

Apache,

Webcom Technologies India Feb 00 - Dec 00

Developer

Purchase Order and Inventory Control

Migration of Purchase Order and Inventory Control application to web based application using JSP/MS SQL Server.

Responsibilities:

Worked closely with analysts to conceive the requirement.

●

Design and deploy database.

●

Develop desktop GUI and web interface using JSP/Servlet.

●

Resume of Arvind Ganotra Page 9

Test and Launch the application.

●

Environment: MS SQL Server 2000, JDBC, Weblogic 7, Tomcat Apache 4.0, Java Swing, Visual Café, JBuilder

Voltas Ltd, India Sep 96 - Jan 00

Project Lead Delhi, India

Service Call Scheduling

Application developed on Windows NT server for entering Customer Complaints, Generating Reports for Call attending

and entering Field Reports.

Responsibilities:

ISO 9001 implementations

●

Performed requirement analysis, database designing

●

Developed Oracle forms and reports.

●

Trained end users and performed implementation.

●

Environment: Oracle 7.2, Developer Forms 4.5 and Reports 2.5, Windows NT

Service Record Management

For maintaining Annual Maintenance Contract schedule servicing, customer calls, plan major services and sending offer

letter for renewal of the maintenance contracts. Application was designed for dBase III and implemented using clipper.

Responsibilities:

Gathered requirements from Finance, Accounts and Sales department.

●

Generated Flow charts and discussed logic of the application.

●

Generated E-R diagrams for database designing.

●

Participated in application development.

●

Data transfer and data getting data entry done from 3 rd party.

●

Environment: dBase III, Windows NT, Clipper

Resume of Arvind Ganotra Page 10

Contact this candidate