Ankur Dogra Mobile: +91-971******* ~ E-Mail: acpddz@r.postjobfree.com

To grow intellectually and technically while providing outstanding technical services .

Executive Summary

7+ years in IT; development of conceptual, logical, and physical information systems; data quality; SQL and PL/SQL

development; extract, transform, and load (ETL) strategies; tuning; replication; and solving object -relational mapping

challenges; analysis of business and technical requirements, and mapping them to implementation strategies and design .

I am well-known for my thoroughness, persistence, attention to technical detail, focus on long -term objectives, and commitment

to my project, team, peers, and management. I am frequently assigned to new initiatives, difficult, behind-schedule projects

because of my ability to focus on project objectives, ability to gain new skills and get the job done.

Certifications

IBM Certified Specialist - IBM Optim Implementation for Distributed Systems

IBM Information Management Optim Technical Sales Professional

IBM Certified Advance Database Administrator for DB2 9.0 LUW

Academic Credentials

2008 B.Tech. (Electronics and Tele-Communication) from IMS Engineering College, Ghaziabad, Uttar Pradesh

Technical University, Lucknow

Professional Experience

Since Nov ‘09 – Till date

Dibit Computing Systems Pvt. Ltd., Delhi

Solution Architect

Functional:

Managing the implementation, support and training of customers on data management solutions such as Business

Intelligence, Database Optimization, Database Archival, DR architecture and Backup – Recovery policy.

Configuring the IBM and Oracle middleware, system integration and building such mission critical systems.

Planning and executing development, unit, integration and acceptance testing of Data Systems.

Creating the specifications for IT Infrastructure Management systems to meet business demands.

Providing consultation and support to organizations in the area of Disaster Planning.

Driving and implementing initiatives for application and database performance monitoring and ma nagement tools.

Doing complex proof of concepts for application and database monitoring, migration and multi-site replication.(systems

such as Oracle, DB2, SQL Server)

Highlights:

Proficiently started a new business unit beyond company’s existing vision .

Was responsible for enabling both the sales and technical team.

Successfully managed multiple services accounts single-handedly.

Introduced new technologies in the process of servicing and consulting; reducing t he total sales time and increasing total

bandwidth of team.

Projects Undertaken

Project: DB2 Database Replication, Maintenance and Performance Tuning

st

1 December 2009 – Till date

Duration:

Technologies: AIX, DB2, TSM, CDC, Oracle, SQL Server and Optim Performance Manager

Client: IFFCO-TOKIO

Designation: Solution Architect and Project Manager

Role:

Enterprise Database Administrator supporting various applications backend of Siebel, Cordys, Documentum and

Cognos containing 1+ TB of current and historical da ta. Responsible for peering into the future with regard to d ata

and databases, and planning expansions and upgrades.

Worked on data and database sections of overarching Technical Architecture document. - Designed and led

database work for deployment in terms of performance, high-availability, fail-over, and backup/restore capabilities

of databases.

Analysis of disaster recovery (DR) capabilities. Inventoried existing systems and business functions and level of

recovery planning already in effect. Compared to exist ing DR capabilities at DR site and developed detailed deltas

for hardware, software, personnel, facilities, et al. Developed plan to incrementally improve DR and HA

capabilities.

Conducted successful proof-of-concept tests for my team's architectural ideas.

Skills Used: Past DB2 experience, SAN designing and AIX scripting. Extensive documentation, client

management and resource management.

Project: DB2 10.5 Pure-scale Database and HADR (Maintenance and Performance Tuning)

st

1 May 2014 – Till date

Duration:

Technologies: AIX, DB2 10.5 Pure-Scale, Pure-Scale HADR, TSM, Guardium Encryption Expert and Optim

Performance Manager

Platform: AIX

Client: Bank of Maharashtra

Designation: Solution Architect and Project Manager

Role:

Lead Database Administrator supporting first-of-its-kind database topology implemented worldwide. Back end

serving various applications like ATM Switch, fraud detection and clearing system.

Leading a team with no-past experience in creating and managing such a system.

Working on data and database sections of overarching Technical Architecture document. - Designed and led

database work for deployment in terms of performance, load-balancing, high-availability, fail-over, and

backup/restore capabilities of databases.

Analysis of disaster recovery (DR) capabilities. Inventoried existing systems and business functions and level of

recovery planning already in effect. Developed plan to incrementally improve DR and Near-DR capabilities.

Conducted extensive system testing for system crash recovery and system stability . Applied learning to augment

BCP and system integrity.

Skills Used: Past DB2 experience, SAN designing and AIX scripting. Extensive documentation, client

management and resource management.

Project: Real Time data Integration between Life-Asia and Agent Portal

th

25 December 2014 – Till date

Duration:

Technologies: AIX, Oracle 11g, IBM CDC and DB2/400

Platform: DB2 for i and Oracle

Client: Aviva Life Insurance

Designation: Project Manager

Role:

Replication Architect supporting integration between Policy Issuance systems with Agent Portal.

Replication of 150+ tables in real time and performing data transformation on the fly .

Skills Used: Past DB2 experience, SAN designing and AIX scripting. Extensive documentation, client

management and resource management.

Project: Tivoli Service Automation

th th

9 September 2014 – 12 September 2014

Duration:

Technologies: AIX, iLog, WAS ND, Tivoli Service Automation

Platform: AIX

Client: CRIS - FOIS

Designation: Solution Architect and Consultant

Role:

Analysis of disaster recovery (Near-DR) capabilities. Inventoried existing systems and business requirement and

level of recovery planning required. Developed plan to implement Near-DR capabilities.

Led a team with no-past experience with the technology and completed without any OEM support.

Created complex Active-Passive fail-over policies and service dependencies automation and scripted the same.

Conducted extensive system testing for system crash recovery and system stability.

Skills Used: Project Management and past scripting experience.

Project: DR creation

th

20 December 2014 – Till Date

Duration:

Technologies: AIX, DB2, WAS ND, Tivoli Directory Server, HADR, HACMP, TSM

Platform: AIX

Client: CRIS - CMS

Designation: Solution Architect and Consultant

Role:

Lead Database Administrator supporting back end serving railways applications.

Worked on data and database sections of overarching Technical Architecture document. - Designed and led

database work for deployment in terms of performance, load-balancing, high-availability, fail-over, and

backup/restore capabilities of databases.

Migrated customers LDAP and application server to new infrastructure.

Analysis of disaster recovery (DR) capabilities. Inventoried existing systems and business functions and level of

recovery planning already in effect. Developed plan for DR capabilities.

Conducted extensive system testing for system crash recovery and system stability . Applied learning to augment

BCP and system integrity.

Skills Used: Project Management. Past LDAP, WAS and HACMP experience.

Project: Tivoli Backup Monitoring and Maintenance

st

1 April 2011 – till date

Duration:

Technologies: DB2, SAP, Tivoli Storage Manager

Platform: Windows

Client: Insecticides India Ltd.

Designation: Solution Architect and Project Manager

Role:

Point Contact for customer. Oversaw the daily reporting sent to the customer. Responsible for proactive issue

resolution and performance management.

Skills Used: Project Management and past TSM experience.

Project: DB2 performance tuning

th th

15 July 2013 – 25 July 2013

Duration:

Technologies: DB2, HADR, Tivoli Storage Manager

Platform: AIX

Client: OCM India Ltd.

Designation: Solution Architect and Project Manager

Role:

Infrastructure setup, performance audit and tuning of DB2 production database for third party application.

Maintenance and redesigning of database logical as well as physical structure.

Responsible for client management, quality control and sending regular reports of work done to client.

Undertaking complex tasks related to moving of database tables without impacting production. Responsible for

system stabilization post restructuring and architecting SLA for database.

Skills Used: Past DB2 experience, SAN designing and AIX scripting. Extensive documentation, client

management and resource management.

Project: DB2 performance tuning

th th

20 March 2013 – 25 June 2013

Duration:

Technologies: DB2, SAP, HADR, Tivoli Storage Manager

Platform: AIX

Client: Vardhman Group Ltd.

Designation: Solution Architect and Project Manager

Role:

Infrastructure setup, performance audit and tuning of DB2 production database for third party application.

Maintenance and redesigning of database logical as well as physical structure.

Responsible for client management, quality control and sending regular reports of work done to client.

Undertaking complex tasks related to moving of database tables without impacting production. Responsible for

system stabilization post restructuring and creating SLA for database.

Skills Used: Past DB2 experience, SAN designing and AIX scripting. Extensive documentation, client

management and resource management.

Project: DB2 performance tuning

th th

8 January 2013 – 24 January 2013

Duration:

Technologies: DB2, W AS ND, Tivoli Storage Manager

Platform: RHEL

Client: Bluestar Ltd.

Designation: Solution Architect and Project Manager

Role:

Performance Audit and Tuning of DB2 production database for in-house application.

Maintenance and redesigning of database logical as well as physical structure.

Responsible for client management, quality control and sending regular reports of work done to client.

Undertaking complex tasks related to moving of database tables without impacting production. Responsible for

system stabilization post restructuring and architecting SLA for database.

Skills Used: Past DB2 experience, SAN designing and AIX scripting. Extensive documentation, client

management and resource management.

Project: Tivoli Storage Manager & Fastback Implementation

th th

13 December 2012 – 4 January 2013

Duration:

Technologies: Tivoli Storage Manager and Tivoli Fastback

Platform: Windows

Client: J.K. Paper Ltd.

Designation: Project Manager and Team Leader

Role:

Built solution and oversaw the project implementation.

Involved in deployment of backup server to backup their ERP, Mail and Deskto p Backup server on a central

server.

Skills Used: Project Management, past Tivoli experience and Tivoli automation concepts.

Project: Implementation of Manufacturing application

th th

11 October 2012 – 18 October 2012

Duration:

Technologies: DB2, W AS ND, HTTP, AIX, Tivoli Storage Manager

Platform: AIX and Windows

Client: Koyo Bearings India Ltd.

Designation: Project Manager and Team Leader

Role:

Built solution and oversaw the project implementation.

Involved in deployment up of HTTP, WAS, AIX and DB2 server for their in-house application.

Skills Used: Project Management, past AIX, WAS, HTTP and DB2 Experience.

Project: DB2 Database crash recovery and system stabilization

th th

13 March 2010 – 15 April 2010

Duration:

Technologies: DB2, AIX, SAP

Platform: AIX

Client: RUPA & Co.

Designation: Technical Consultant

Role:

Recovered and maintained DB2 production database of SAP R/3.

Involved Crash Recovery of database at table level due to storage failu re.

Maintained and redesigned database logical as well as physical structure.

Responsible for client management, quality control and sen t regular reports of work done to client.

Undertook complex tasks related to recreation of database tables o ne by one using OS and database tools. Post

recovery system stabilization and SLA management.

Skills Used: Past DB2 experience, SAN designing and AIX scripting. Extensive documentation, client

management and resource management.

Project: Support migration of Sybase ASE to DB2 V8.2 running on HP-UX

st th

1 December 2009 – 5 December 2009

Duration:

Technologies: DB2, HP-UX

Platform: HP-UX

Client: CBEC

Designation: Technical Consultant

Role:

Installation of DB2 on HP-UX and creation of relevant databases and instances.

Setting up of security and database structure. Automation of Backup and Maintenance activity.

Involved maintenance and redesigning of database logical as well as physical structure.

Creating relevant table design and database parameters for successful porting of sybase schema into db2.

Undertaking complex tasks related to data governance (such as designing backup – restore policy, data archival

and BI analysis).

Skills Used: Past DB2 experience, SAN designing and Unix scripting. Extensive documentation, client

management and resource management.

Previous Assignment

Since Oct ‘07 – Nov '09

Trident Information Systems Pvt. Ltd., Delhi

Solution Architect (IBM Contractor)

Key Deliverables:

Functional:

Managing the implementation, support and training of customers on data management solutions such as Business

Intelligence, Database Optimization, Database Archival and Backup – Recovery policy.

Imparting training to enterprise customers like CRIS, IFF CO-TOKIO and KML for various data governance solutions.

Analyzing complex business problems to be solved with supply chain planning.

Setting sales & operations planning process, KPIs and analytic required for enabling the S&OP Process.

Configuring the system settings and options, system and integration development.

Planning and executing development, unit, integration and acceptance testing.

Creating the specifications for systems to meet business requirements.

Providing consultation and support to users in the area of supply chain planning.

Driving and implementing initiatives for supply chain planning tool and business process innovations.

Highlights:

Proficiently started a new business unit beyond company’s existing vision.

Was responsible for enabling both the sales and technical team.

Successfully managed service accounts single-handedly.

Projects Undertaken

Project: Information Management Tools Design and Support

st st

1 December 2008 – 1 December 2009

Duration:

Technologies: DB2, AIX, Business Object XI, DB2 Warehouse, Optim Data Archival, Data S tage, Cognos

Platform: AIX, DB2, Windows Server

Client: IBM

Designation: Technical Consultant

Role:

Supporting IBM Information Management Sales and Technical Team in pre -sales or post-sales.

Responding to RFP and effort estimation requests to support sales team.

Project planning and execution to ensure profitability.

Skills Used: Past experience of Information Management Tools and Client management.

Project: DB2 Database Maintenance and Performance Tuning

st st

1 December 2008 – 1 December 2009

Duration:

Technologies: DB2, AIX

Platform: AIX

Client: IFFCO-TOKIO

Designation: Team Leader

Role:

Administration and Maintenance of DB2 databases of various applications, such as Siebel, Documentum and

Cognos.

Involves maintenance and redesigning of database logical as well as physical structure.

Handling the client management, quality control and sending regular reports of work done to client. Tracking the

issues pro-actively and database health management.

Undertaking complex tasks related to data governance (such as designing backup – restore policy, data archival

and BI analysis). SLA management and support service call management.

Skills Used: Past DB2 experience, SAN designing and AIX scripting. Extensive documentation, client

management and resource management.

Project: Production setup for railways application

th rd

11 April 2008 – 3 July 2008

Duration:

Technologies: DB2, HP-UX

Technologies: DB2, AIX, Tivoli Storage Manager

Platform: AIX

Client: CRIS

Designation: Technical Consultant

Role:

Technical Consultant responsible for Installation and configuration of Tivoli Storage Manager and DB2 in a

HACMP AIX cluster.

The objective of the project was to design and implement production database infrastructure and design policies

of backup & restore process of database. Leading a team of two for designing and implement ing the solution.

Managing customer relationship and quality control of solution deployed.

Skills Used: Past DB2 experience, Linux and AIX scripting experience.

Project: Installation of Tivoli License Compliance Manager

th nd

10 January 2008 – 22 January 2008

Duration:

Technologies: DB2, HP-UX

Platform: Windows Server 2003

Client: CRIS

Designation: Technical Consultant

Role:

Setting up of Rational's License Server and Tivoli License compliance manage r. Generating usage reports of

license from client systems. Handling the instal lation and setting up of entire project.

Skills Used: Client management, quality assurance and troubleshooting ability to integrate different product s to

achieve necessary solution.

Previous Assignment

Jan ’07- Sep ’07

Dibit Computing Systems, Lucknow Technical Consultant for DHV (DB2)

Accountabilities

Handling the installation and setting up of DB2 server along with conducting the Performance Tuning and integratio n of

DB2 with ArcSDE (GIS product from ESRI).

Backup and restoration of database through DB2 backup utilities.

Troubleshooting of DB2 system due to system crash or other reasons.

Importing GIS Data to DB2 through ArcCatalog.

Maintaining different forms of Geo-Databases and validating at time of merging & deploying GIS solution on WAS.

Highlights:

Proficiently integrated DB2 v8.2 with ArcGis 9.1. (In version 9.1 there was not set/clear procedure to integrate DB2 with

GIS).

Project: Implementation of JAVA based GIS application

th nd

10 January 2003 – 22 January 2005

Duration:

Technologies: DB2, ArcGIS, WAS Portal Server, Rational Software Architect,

Platform: Windows Server 2003

Client: UPID

Designation: Technical Consultant

Role:

Setting up of Rational's SDLC toolkit, database server and portal server.

Created schema and tables as per application requirement.

Skills Used: Client management, quality assurance and troubleshooting ability to integrate different product s to

achieve necessary solution.

Personal Dossier

th

Date of Birth: 29 July 1985

Address: 70, Sreshtha Vihar, Trans Yammuna Area, New Delhi - 110092

Contact this candidate