Apollo Wandrekar

Experience

• 

  SoftDotCom Technology

  Oct 1999 - Jan 2000

  Software Engineer
• 

  3i Infotech Ltd.

  Feb 2000 - Jun 2006

  • Comprehensive Oracle Database Administration• Automating various processes by modifying shell scripts that required human intervention • Oracle database administration on Windows, UNIX, SOLARIS & Red Hat Linux platforms

  • Senior Technology Engineer

    Apr 2004 - Jun 2006

  • Technology Engineer

    Feb 2000 - Mar 2004
• 

  Atos

  Jun 2006 - Oct 2007

  Technical Team Lead - Senior Database Administrator

  KEY ACHIEVEMENTS:• Maintain an average of 2 Priority 1 incident per month• Improved database performance• Successful Disaster Recovery Drill for the banking applicationRESPONSIBILITIES INCLUDE:• Manage staff training, availability, shift patterns, rosters and shift handover processes• Install and configure Database Tools, e.g. monitoring, tuning, statspack, SQL scripting• Monitor and report on the performance of each database and recommend enhancements• Work with the customer application support teams and other third party vendors on Problem investigation and optimization of the application level of each database• Perform analysis and diagnosis on Assigned Problems, including a level of root cause analysis appropriate to the circumstances of the Problem - i.e. for Severity Level 1 and Severity Level 2 Problems root cause is identified and addressed• Ensure team participation in pre-implementation testing of Changes where required• Ensure backup restoration using VERITAS Netbackup Show less

• 

  Capgemini

  Oct 2007 - Sept 2020

  Key Achievements:-• Developed and executed a project to establish 1 WOW – 1 Way Of Working• IMOC transition – shift left routine activities performed by L3 resources• Alignment of resources to responsible towersResponsibilities Includes:-• Development for standard processes• Implement best practices from other customers for Eneco• Develop and implement project for IMOC transition• Front end customer meetings for technical and SLA related discussions.• Successfully implemented cross technology support for niche technologies.• Manage a team of 25+ resources for Database and Middleware technologies Show less KEY ACHIEVEMENTS:• Forecasted and realized 15% productivity saving year-on-year by running initiatives such as Pyramid Optimization, Automation & Incident Reduction. Saved € 50K in year 2015.• Standardized work instructions and database monitoring across customers.• Conversion of prospective customer based on technical inputs & discussions. Organization earned contract of M€ 90 for an Electric generation company.RESPONSIBILITIES INCLUDE:• Managing transformation programs such as IMOC movement and Rightshoring.• Implement projects for mutualizing resources across technologies and geographies.• Ensure implementation of appropriate service level measures to guarantee expected service from each provider.• Managed the IT SOX program and ensured compliance with all the defined general computing controls. Reduced the year-over-year SOX gaps by 89% by ensuring login restrictions.• Drive increased productivity and decreased cost through focus on deployment of technology by use of advanced Oracle features such as Auto Healing and Automated RCA.• Preparation of financial dashboard covering information of actual and resource forecast for multiple technologies.• Successfully implemented cross technology support for niche technologies.• Run SIPs for productivity improvements.• Manage a team of 30+ resources consisting of Database and ERP Administrators.• Front end customer meetings for technical and SLA related discussions.• Active involvement in the solutioning for prospective customers across geographies which involves the following:i. Understanding customer requirement and defining FTE requirement per technology.ii. Generating proposed cost as per the baselines defined.iii. Run feasibility check for the technologies available at various locations.iv. Preparation of job description for the solutioned technologies.v. High risks and mitigation plans to customer.vi Define resource mutualization plan to benefit resource optimization. Show less KEY ACHIEVEMENTS:• Devised reporting for ticket reduction and automation capabilities.• Evaluate and propose to customer use of Oracle new features such use of Oracle Enterprise Manager for Automated Root Cause Analysis and Auto Healing.• Automate routine database administration activities using advanced UNIX shell scripting.RESPONSIBILITIES INCLUDE:• Manage staff training, availability, shift patterns, rosters and shift handover processes in addition to the BAU work.• Guide team to install and configure Database Tools, e.g. monitoring, tuning, statspack, SQL scripting. • Provide recommendations based on the history/trend and potential problems observed using Pareto analysis.• Ensure that team performs regular housekeeping, maintenance and performance tuning tasks to maximize the performance of each database.• Setup and maintain documentation and standards.• Interfacing with Oracle technical teams and client for upgrades, latest version and utilities.• Create client/database specific work instructions that are distributed amongst team members.• Database administration.• Ensure that the project to compatible to ISO 20K standards. Show less

  • Project Delivery Manager

    Aug 2017 - Sept 2020

  • Technical Application Manager

    Jul 2016 - Jul 2017

  • Delivery Manager - Strategy Initiatives

    Jan 2013 - Jun 2016

  • Technical Team Lead - Senior Database Administrator

    Oct 2007 - Dec 2012