Project Manager Management
Resume:
Ankur Dogra Mobile: +91-971******* ~ E-Mail: *****.*****@**********.***
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