MADHANKUMAR M

Strategic Management

1. Consult client and advise on different business optimization opportunities in the DB2 environment.
2. Resolve complex database issues, maintenance as well as implementing changes.
3. Assist the clients with avoiding different risk scenarios, predict issues that could have impact on client business.
4. Needs to attend client meetings as requested (client facing job role).
5. Working with a team of different professionals including management, sales and engagement experts as well as different client representatives, where extensive business communication skills are required.
6. Leading and synchronizing activities of a very diverse team via multiple channels (mail, phone, meetings, etc.)
7. Project management insight of different parallel projects run in cooperation with the clients.
8. Creating / Publishing reports and dashboards (Key Performance Indicators) to the senior leadership team
9. Handling multi-Cultural & Virtual team across the global team
10. Oncall rota Preparation and support in cooperation with other team members

Technical Strategic

• Lead DB2 Systems: Performed, monitored and managed the following set of tasks L3-L4 Tasks Develop and maintain an IBM DB2 for z/OS estate Install, configure, monitor and maintain database software products Perform upgrades like Mainframe DB2,DATADRIVE and IDAA upgrade to N version Migration of DB2 Regions from Version 11 to Version 12 Completed multiple DB2 DR(Disaster Recovery) drills for multiple clients Maintained local group buffer pools of all production Data-sharing environments
• IBM DB2 for z/OS RSU maintenance rollouts (Shopz ordering, SMP/E processing etc) Used automated monitoring tools(SYSVIEW, OMEGAMON) to monitor performance Monitor the availability, resource utilization, and performance of DB2 and user processes Implement system-level security on DB2 and other platforms Providing On Call support for (24/7) for SEV1 and SEV2 incidents Performed IDAA upgrade IDAA V5.1 PTF8 successfully L1-L2 Tasks Resolve DB2 Incidents or cascade it to L3 team for closure Perform health checks on a daily basis Validate the DB2 subsystem start up during an IPL process Create PMR /tickets with ISV Provide 24 x 7 on call support for incidents Apply Maintenance PTFs for DB2 and related vendor products CATMAINT UPDATES through RSU Maintenance HOLDDATA Review Team Management Oncall Rota Preparation Publish the DASHBOARD / SLA Metrics to leadership team Handling multi-Cultural & Virtual team across the globe
• Improved communication skills among students through regular group projects and presentations.
• Continually pursued professional development opportunities to stay current with educational trends and research, ensuring high-quality instruction for all students.
• Established a positive learning environment by fostering strong relationships with students, parents, and colleagues.

• Optimized customer experience by delivering superior services and effectively troubleshooting issues.
• Frequently inspected production area to verify proper equipment operation.
• Collected, arranged, and input information into database system.
• Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
• Resolve DB2 Incidents or cascade it to L3 team for closure
• Perform health checks on daily basis
• Validate DB2 Subsytem start up during IPL process
• Create PMR /tickets with ISV
• Provide 24 x 7 on call support for incidents
• Apply Maintenance PTFs for DB2 and related vendor products
• CATMAINT UPDATES through RSU MaintenanceHOLDDATA Review

• Established effective communication channels between IT support staff and end-users, leading to improved issue resolution times overall.
• Enabled smooth transitions during hardware and software upgrades, minimizing disruptions to endusers.
• Improved security measures by conducting vulnerability assessments and applying necessary patches.
• Evaluated emerging technologies for relevance within organization infrastructure, making recommendations based on potential benefits or risks involved with adoption/integration processes.
• Increased efficiency in workplace by ensuring seamless integration of new applications into existing systems.
• Assisted in capacity planning efforts to ensure sufficient resources were available for future growth while avoiding unnecessary utilized CPU
• Apply Maintenance PTFs (Program Temporary Fixes) for DB2 and related vendor products.
• HOLDDATA review, Tools Compatibility and CATMAINT UPDATES through RSU Maintenance
• Migration of DB2 Regions from Version 10 to Version 11 CM mode and from V11 CM mode to V11 NFM mode.
• Extended RBA coversion of BSDS, Catalog & Directory table spaces and indexes.
• DB2 early code update.
• DB2 tools customization and upgrades such as SYSVIEW, File-Aid for DB2.
• Create service requests / tickets with vendor for issues.
• Online ZPARM update.

• Troubleshot database issues effectively, minimizing system downtime and maintaining optimal performance levels.
• Improved database efficiency by optimizing queries and implementing indexing strategies.
• Reduced data redundancy and improved integrity by designing and implementing normalization techniques.
• Established efficient backup procedures and disaster recovery plans to protect critical business data from loss or corruption.
• Installing, refreshing, and updating Databases into Mainframe server for more than 150 clients
• Scheduling jobs in OPC for Data bases.
• Knowledge in troubleshooting error jobs in OPC.
• Experience in JCL’s and TSO Screens
• Updating and executing operational procedures, while applying strong technical, theoretical skills to perform research and analysis for quick TAT.

• Taking care of Radio Issues and Excess Billing Issues, User Activation, deactivations and performing UAT before launching new products to customer
• Mitigated potential risks by proactively identifying potential issues and implementing appropriate countermeasures or contingency plans as needed.
• Established effective relationships with key stakeholders both internally and externally for increased collaboration opportunities.
• Improved overall department efficiency by streamlining processes and implementing new policies