Summary
Overview
Work History
Education
Skills
Accomplishments
Personal Information
Timeline
Hi, I’m

APURBA THAKUR

Bengaluru,KA
APURBA THAKUR

Summary

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

Timeline

Agile Coach and Senior IT Manager

IBM India Private Limited
04.2014 - 04.2018

Agile Scrum Master

IBM India Private Limited
01.2013 - Current

VISA EUROPE INC
02.2011 - 09.2013

STAPLES INC DB2 SUPPORT
07.2009 - 11.2009

VISA EUROPE INC
01.2009 - 05.2009

DBA

ROLES & RESPONSIBILTY
08.2007 - 06.2009

Asansol Engineering College (AEC)

B.Tech from Electrical Engineering
APURBA THAKUR