My immediate career objective is to take on a
leadership position in the software development space utilizing
Agile software development and the Scrum / kanban / Safe framework, in the role of
Agile Coach / Scrum Coach / Agile Transformation Lead, engineering
manager, program manager/project manager or Scrum Master working on market
leading products.
Overview
17
years of professional experience
Work History
VISA EUROPE INC
01.2009 - 05.2009
Job overview
List of Significant Projects
1) MIDAS( Merrill Lynch ) - September'07 to August'08.
2) CATERPILLAR DWM - September'08 - December '08., Staples INC is a very big name in Retail market space, its primary
business is to supply any office assecories to the big MNC clients.
For the purpose they are having some web based portals to
facilitate the customers for selecting and placing the order through
these portals i.e staples dot com , staples link etc.
Also they have
some retail shops for which they have some other applications , all
these applications are having DB2 as the database and they
require support for 24.
7 for their up and running purpose.
Leverage DB2 Support :- Most challenging role for a DBA ever is to work in a leverage DBA
support, here I am supporting as many as 280+ production
servers across various platforms from LINUX, UNIX, WINDOWS
and SUN SOLARIS.
Working total for 14 clients, to name a few
STATE FAM INSURANCE, Daimler Financial Services, GOODYEAR,
PHEONIX WHEATH MANAGEMENT, SABER,AFFINIA, MAZDA
MOTORS , Coca Cola etc.
All clients are housed and run from our
HP Datacenter providing a 24.
7.
365 availability.
VISA as the name speaks for itself , is a giant banking partner which
is working with more than 700 + partners Banks in / around
world , and providing the IT infrastructure interms of
application support , MQ and Database support for the
smooth and continued operations of all the banks in their
BAU.
I being a part of VISA, work as a DBA DB2 LUW and
support all the projects which houses all most 400+
databases , which includes all types of databases from
single node to multi node / partition , Buisness data
warehouse , microstrategy etc.
We used to manage a total
data of about 360 TB +.
ROLES & RESPONSIBILTY
DBA
08.2007 - 06.2009
Job overview
Worked as DB2, For LUW environments in Satyam Computers Services, As a Project Manager is responsible for :-.
Estimate the effort and prepare the project schedule plan based on the inputs from developers, testers,
functional lead, SMEs.
Communicate the effort details and estimates to Business Leads and Executive.
Define and manage the project initiation, planning, execution, control & monitor and closing phase.
Responsible for Project Planning, estimating, risk management, team management.
Managing stakeholder expectation by providing reports on effort, schedule and quality measures.
Project Plan Execution and People Management.
Risk Management.
Ensure on-time completion of all the tasks with no quality compromise.
Timely escalations where required to get the required management attention.
Highlight the Risks/Issues/Dependencies/Assumptions to the stakeholders and arrive the mitigation
plans.
As an agile coach responsibility :-.
Coach team members in a fast-paced environment through our transformation to Agile, with the
successful development in commercial projects in Distribution , retail and telecom.
Foster an Agile culture throughout, including the team and senior management, which has led to better
communication and lean thinking at all levels.
Facilitate Release and Sprint events and ensure customer requirements are captured, prioritized,
communicated, and properly sized by the team.
Identify and remove impediments to team success, and
ensure teams have everything needed to build and deliver value to the customer.
Enable teams to identify areas for improvement, then adapt and change as needed to support
continuous improvement.
Achieved a 40%-50% reduction in development costs, while continuing to deliver products with similar
business value, by improving our agility and developing minimum viable products.
As a DB2 DBA, was responsible for:.
24x7 Production Support.
Involved in database installation.
Handling DBA Tickets.
Support for Production, SNAP, Implementation, Report, etc.
databases.
Version up-gradation.
Fix pack installation.
Changes in Database Manager and Database Configuration.
Database Maintenance for Production, Testing, Development.
Database,tablespace and DB objects creation and maintenance.
DB user creation.
Analyze and implement DB2 Reorg utility based on the need for database reorganization.
Monitor DB2 UDB databases for space utilization and performance degradation and tune as needed.
Monitoring Backup, Refresh, Log shipping, Roll forward,HADR etc.
Determine need for DB2 UDB utilities (i.e.
Reorg, statistics gathering) develop and implement to
enhance performance.
Generate DDL statements for database objects, move database objects to and from test and production
environments.
Backup and Recovery Procedures planning and implementation.
Performance tuning.
Shell scripting and SQL query writing (based on requirement).
Report rotation support.
Daily monitoring of Archive log files, database backup operation and health alerts along with space
management for tablespaces and log files.
Database partitioning and redistribution of database partition groups.
Database creation and database partitioning in AIX.
Database and tablespace monitoring along with log files monitoring.
Close interaction with IBM and SAP premium support managers via PMR and OSS messages.
Software system refresh for creation of development database.
User/Group creation and maintaining their permissions and authorities along with database security and
password management.
Monitoring tape retention strategy and editing crontab according to need.
Monthly outage of system for collecting statistics of tables and for checking database consistency.
Involved in the DB2 database administration and AIX system administration for IBM pseries servers.
I
held the key responsibilities to fix all the data issues to help the migration team.
Performed the backup strategies of online backup and offline backup.
Monitored the database at table space level.
Increased the size of table space by increasing the size of
the containers and also by adding new containers.
Moved tables from one table space to another table space.
Involved in buffer pool tuning by maintaining the buffer pool hit ratio at 95%.
Created new buffer pool exclusive for some table spaces.
Access privilege to the databases is maintained at different levels.
Executed the Runstats utility to update the access plan.
Used the utilities of Reorgchk and Reorg to expedite the performance of the database.
Working closely with the data migration team in related to the generation of the base database and data
modeling for this project.
STAPLES INC DB2 SUPPORT
07.2009 - 11.2009
Job overview
Worked as Lead DB2 DBA For LUW environments in Mphasis - an HP company from December 2009 to
till date.
Presently working as Agile Coach and Iteration manager in IBM INDIA PVT.
LTD from January 2010 till
date.
Training
Is have taken under entry level courses while his stay in satyam in all the subjects like DS and
Algorithm, OS, RDBMS, SE ORIENTATION, ORACLE, UNIX BASICS AND INTERNAL, AIX operating
system.
Successfully completed his DB2 UDB Training under project based condition for Merill Lynch ADC
while working in satyam.
Have taken training from IBM on DB2 DBA, and also attended some of the Boot camps hels by
IBM.
Successfully completed the Advanced Backup and Recovery workshop help by IBM for partitioned
and non - partitioned environments., 6) Leverage DB2 support - December '09 - December 2010.
VISA EUROPE INC
02.2011 - 09.2013
Job overview
IGA Accounts - Product Support - Septembe'13 - till date.
Project Details
MIDAS( Merrill Lynch ):- The MIDAS Data Warehouse is one of Merrill Lynch's largest aggregators
of data, a repository leveraged throughout Global Private Client and other
divisions to satisfy the business community's decision support
requirements.
The breadth of MIDAS data spans most of the businesses
and activities of the firm and it is the single source for most of the core
financial metrics reported to Merrill Lynch's executive management.
Business Intelligence Services (BIS), the technology group responsible for
supporting MIDAS, collects and consolidates data from both internal
systems and external sources.
Its processes transform the source data
according to business rules defined by its clients and load the results to a
distributed platform for access by authorized users.
BIS continually
updates the Data Warehouse in response to changing business, regulatory,
and legal requirements.
Now considered an Enterprise-wide resource,
MIDAS has over 500 registered users who query the Data Warehouse to
monitor clients and FAs, analyze data relationships, and report on specific
activities.
MIDAS users can also receive scheduled reports and automated
e-mail alerts when issues arise.
CAT DB2 UDB Support :- Caterpillar is the World's largest maker of construction and mining
equipment, diesel and natural gas engines, and industrial gas turbines.
The data related to the manufacturing, inventory and shipping resides on
DB2 UDB databases.
The objective is to maintain this data as per the
service level agreements.
The databases are built in DB2 and the software used is Peregine Tool.
Satyam provides the Database Administration Support, which includes the
maintenance by handling the tickets and production support (24x7) with
onsite/offshore model with three resources at onsite and three resources
at offshore.
The scope of services delivered to the Caterpillar team and their clients
(the application development and support community) include the
maintenance, administration and support of DB2 services, maintenance of
the DB2 V8 and V9 databases with SAP as the application base with
modules like R3 and BW, using the DB6 cockpit for DBA to schedule the
DB13 maintenance jobs.
IBM India Private Limited
Bengaluru, KA
Agile Scrum Master
01.2013 - Current
Job overview
Mentored and coached four teams new
to Agile in Scrum and Lean Best Practices developing firmware for hardware
integration and shipping
Led strategic Release Planning and tactical Iteration
Planning sessions
Conducted daily stand-ups in two-week Iterations,
facilitated sprint reviews, retrospectives, and sprint planning
Communicated and presented weekly updates to
stakeholders and program managers
Coordinated software development with product and
marketing groups to ensure feature release based on manufacturing
commitments
Developed the roadmap for all teams to evolve toward
predictive velocities
Ensured the RTP and off-shore teams are practicing the
core agile principles of collaboration, prioritization, team
accountability, and transparency - lead by example.
Assisted as needed to help remove impediments and
distractions that interfere with the ability of the team to deliver on the
Sprint goal.
Adapted Scrum implementation as needed to work within a
gated waterfall funding and release model, all while allowing the team to
practice true Scrum as much as possible.
Key role in researching, gaining approval for, and then
using tools such as Pivotal Tracker and JIRA w/Greenhopper to successfully
support Scrum implementations.
Performed an active coaching role for a program wide Agile
implementation.
IBM India Private Limited
Bengaluru, KA
Agile Coach and Senior IT Manager
04.2014 - 04.2018
Job overview
Facilitated the transition of the
applications (200+ people) from waterfall to Agile as a Coach, while also
acting as the Scrum Master of two mixed on/off shore teams
.
Developed and delivered team and organization training
materials and workshops, building knowledge and skills to facilitate the
Agile transformation.
Established and supported communities of practices to
promote organizational understanding of Agile roles and to help
individuals develop into them.
Wrote Agile FAQs, articles and success stories which
were distributed via newsletter and posted on a SharePoint site to improve
the Agile maturity level.
Coached teams, Scrum Masters, Business Analysts,
Managers and Executives on Agile values and principles to promote
continuous improvement in practices and artifacts.
Championed cultural change and collaborated with other
Coaches on plans and techniques for accelerating and advancing the organization's
transformation.
Mentored teams, leading them to be self-directed with
strong accountability, decision making, conflict resolution and
transparency.
Focused primarily on training the teams to write good
user stories, prioritize the work based on business value and handling of
the tasks by the team.
Placed substantial efforts on team member role
training, time-boxing and providing strong metrics for all players
Brought in Agile best practices such as time-boxing,
continuous integration, code/design reviews, transparency, accountability,
rally tracking, product visioning, technical debt reduction,
self-management, empowerment and role training resulting in realized
velocity improvement of more than 100%As a Scrum Master for three products and three separate
cross-site teams (200+ people), identified process changes required to
accelerate development and remove major impediments. In eight weeks,
reduced time to ship by approximately 30%.
To achieve these results,
updated group's processes to conform to Agile Scrum standards
Facilitated Scrum of Scrum calls for seven different
billing applications following Agile process
Education
Asansol Engineering College (AEC)
B.Tech from Electrical Engineering
University Overview
West Bengal in 2007 with first
class.
High School qualifying examination (10+2) from Burnpur Riverside School, West Bengal in the year 2003 with.
High School qualifying examination (10) from Burnpur Riverside School West Bengal in the year 2001 with
71.4% marks, Web Technologies: VB script .
GUI: VC++,DB VIZ,Replication center,optim.
Database: DB2(UDB 7,8.1,8.2,9.1,9.5), Oracle(9.1),M.S.Acess
DOMAIN KNOWLEDGE : AIX/Unix/LINUX/ , Agile Methodology .
OPERATING SYSTEMS : Windows98,2000,XP,Unix,Solaris 10,linux Z .
Skills
DB2 Load, Import, Export, Reorg, Runstats,
Reorgchk, Backup, Restore, db2move, db2look, db2dart, inspect, db2expln and
db2advis,db2 data studio, replication center and Rational Data architect
Managing a team of 15 DBA and Developers and as Subject matter expert in IBM
Skill sets
Programming Language: C,C,VC, PL/SQL,Shell
Program / Project / Change Management: 11 years
Agile / Scrum / Kanban: 8 years Agile, professional certifications (CSM, SAFE45, KMP1 , IC Agile coach )
Agile Transformation & Coaching: 5 years at - CIO IBM (very large scale transformation in a 850 person engineering group)& smaller groups at different commercial customers like citi , shop direct , Anthem , Citrix
Scaled Agile Framework (SAFe): Attended the complete 4 day Implementing SAFe course, which covers all of the SAFe details including courseware from Leading SAFe and Implementing SAFe Undergoing implementation for Anthem which is a large focused account in IBM
Waterfall / Ad-hoc: 6 years - IBM PM certified (based on PMI PMP), trained & experienced in many methodologies
Cloud: 4 years; IaaS, PaaS, Bluemix, VMware
DevOps, CI/CD: 4 years; Led transformations; Automation
Software Engineering Background: 10 years of Database Administration and Architect , started career as software engineer
Acclaim Link :- https://wwwyouracclaimcom/user/apurba-thakur
Linked In :- wwwlinkedincom/in/apurba-thakur-a749a91a
Accomplishments
IBM 000-700 certification "DB2 9.1 Family Fundamentals Associates".
IBM 000-731 certification "DB2 9.1 LUW DATABASE ADMINISTRATOR".
IBM 000-734 Certification "IBM Certified Advanced Database Administrator DB2 9 for LUW".
IBM 000-614 Certified - Advanced DB2 10.1 certified.
Certified scrum Master - Scrum Alliance.
Safe4.5 Agilist.
IC Certified Agile coach.
Kanban system Design - KMP1, DUPONT SAP BW R&M & ETL SUPPORT :- Founded in 1802, DuPont puts science to work by
creating sustainable solutions essential to a better,
safer, healthier life for people everywhere.
Operating
in more than 70 countries, DuPont offers a wide
range of innovative products and services for
markets including agriculture, nutrition, electronics,
communications, safety and protection, home and
construction, transportation and apparel.
For ETL support we have There are more than 50
databases across ETL landscape in DuPont.
All the
databases are running on AIX 5.3 with DB2 V8.2
FP12.
The current product is running in AIX 5.3 and DB2
UDB V9.1 FP 4 of 17TB in size.
This is a DB2 ESE
edition with 47 partitions.
This is 24X7 support
project.
I do hereby declare that to the best of my knowledge and belief what is stated above is correct,
Complete and is truly stated.
Yours truly
(APURBA THAKUR).
Personal Information
Personal Details
, Date of Birth: November 13, 1984.
Marital Status: Married.
Permanent Address: C/o Ashok Thakur; P.o + Vill :- Hirapur
Burnpur, Asansol, Dist :- Burdwan
West Bengal, Pin :- 713325
CURRENT LOCATION :- Bangalore.
Passport: Valid UPTO 06/24/2017