Keywords
Skills
?
?
?Mayuresh Khismatrao
?PLSQL Team Lead / CRM Problem Manager
?
PROFILE
Result-oriented professional with 9+ years of comprehensive experience in automobile, BFSI, Telecom domains. I have worked in Application Support and Maintenance as a Consultant, Team Lead and CRM Problem Manager throughout my tenure in IT service industry
I love to explore new places around.
TOOL BOX
Tools??Version Controlling (SVN, PVCS), Job Schedulers (CA Unicentre, Autosys), Toad, SQL Developer, ETL (Datastage, OWB), SQL Loader, Ticketing Tool (Service Now)?
OS?Windows and Linux
Programming Languages? Oracle PLSQL, UNIX Shell scripting
Languages?English (fluent in speech and writing), Marathi (Native), Hindi (Speaking)
?
WORK EXPERIENCE
2015.07 – 2017.04??PLSQL Team Lead/CRM Problem Manager (Volvo Cars Corporation),
Capgemini Consulting, Mumbai, India
Team Lead : Overall Accountability including Planning and Execution of Spare Capacity, Change, Problem and Incident. Technical assistant to team and to ensure that the knowledge both functional and technical is distributed within the team. Responsible for all communications (internal and external) and to handle client escalations. Managing major incident and proactive monitoring.
Problem Manager: Publish new incidents in the Problem Management report. Host a call to investigate and follow-up with the technology team for more effective discussions on the problem root cause, work around and corrective actions. Verify problem information and related documents is complete and accurate. Generate bi-weekly status report and present it to the client.
Onsite Experience: Travelled to Sweden, Gothenburg for 1 month (Mid of Nov 2016to Mid of Dec 2016), Volvocars Corporation, Sweden.
Programming languages and tools: Oracle PLSQL, UNIX, ETL, SAP BO, SVN, Service Now,.
2014.02 – 2014.08 Technical Lead, iGate Global Solutions Pvt. Ltd., Mumbai, India
Extensive use of UNIX Shell Scripts, Cron jobs and Autosys to automate process. Used PLSQL to create packages, functions, and procedures. Used PLSQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables. Tuning of the SQL queries, which takes long time to process the request using Explain plan, Hints to reduce the response time. Involved in all phase of database development, from needs assessment to QA/QC, design and support.
Programming languages and tools:Oracle PLSQL, UNIX, Autosys, BMC Remedy, SVN
2010.07 – 2014.01 Oracle PLSQL/ ETL developer (General Motors, Canada), Capgemini Consulting Pvt. Ltd., ?Mumbai, India
Direct Interaction with Client regarding Minor Enhancement in Application.Attainted Daily Meetings with Client regarding Ticket Information, New Enhancement. Creating Procedures, Packages, Functions, Triggers. Writing UNIX Scripts. Monitoring Job Scheduling in CA Unicentre / Autosys. Involved in analysis and development of database Objects like Table Structure, Triggers, Synonyms, Sequence etc. Upload Large Amount of Flat File using SQL Loader, External Table utility in to the Database using ETL. Maintain Application Version Control in PVCS. Resolving tickets on daily basis and communicating with clients for closure of the tickets. Creating various Health Check reports and communicates the same to client on daily basis. 24*7 Application and DBA support.
Programming languages and tools: Oracle PLSQL, UNIX, Datastage, Autosys, BMC Remedy, PVCS
2009.11 – 2010.03 Software Consultant, Vodafone India, Net Connect Global, Pune, India
Documented all the development work and taking care of version control. Monitoring and providing L2 support for North India Vodafone Circles for prepaid operations. Responsible for all BSCS, CMS processes and Billing prepay loading processes issues. Reconciliation between EMG Vs BSCS Vs IN to reduce mismatches b/w systems time to time and hence removing root causes of complaints. Analysis of file Processing Errors or Job Abends if any.Application health check on daily basis
Programming languages and tools:Oracle PLSQL, UNIX.
2008.10 – 2009.11 Oracle PLSQL and Oracle Forms and Report 6i Developer, UTI Technology Ltd, Mumbai, India
Test Designing of oracle forms & reports for assigned modules. Coding and testing of the assigned modules. Integration and Unit testing of the entire application. Formulating SQL queries and stored procedures on assigned modules
Programming languages and tools: Oracle PLSQL, Oracle Forms and Report, UNIX
2007.10 – 2008.09 L2 Support Analyst, Flexcube, Flexce International Pvt Ltd., Mumbai India
Provided online Production (L2) Support to “Lord Krishna Bank” one of the leading clients of Flexcel. Analyzing issues reported by client. Creating patches (SQL Script) to resolve the incidents. Worked on the Data migration of “Lord Krishna Bank”
from Flexcube to Finacle as their core banking solution.
Programming languages and tools:Oracle PLSQL, UNIX
EDUCATION
?
2004 - 2007 ???K.V. Pendharkar College, Mumbai University.
Graduated in 2007 - Bachelors of Science in Computer Science.
?
OTHER
Citizenship??Indian
Year of Birth?1985
Driving License?Indian License
Certifications?ITIL v3 Foundation, Six Sigma Yellow belt.
Awards?Project Star for Q4 2010 and Q3 2012 in Capgemini.
?
?Mayuresh Khismatrao
?PLSQL Team Lead / CRM Problem Manager
?
PROFILE
Result-oriented professional with 9+ years of comprehensive experience in automobile, BFSI, Telecom domains. I have worked in Application Support and Maintenance as a Consultant, Team Lead and CRM Problem Manager throughout my tenure in IT service industry
I love to explore new places around.
TOOL BOX
Tools??Version Controlling (SVN, PVCS), Job Schedulers (CA Unicentre, Autosys), Toad, SQL Developer, ETL (Datastage, OWB), SQL Loader, Ticketing Tool (Service Now)?
OS?Windows and Linux
Programming Languages? Oracle PLSQL, UNIX Shell scripting
Languages?English (fluent in speech and writing), Marathi (Native), Hindi (Speaking)
?
WORK EXPERIENCE
2015.07 – 2017.04??PLSQL Team Lead/CRM Problem Manager (Volvo Cars Corporation),
Capgemini Consulting, Mumbai, India
Team Lead : Overall Accountability including Planning and Execution of Spare Capacity, Change, Problem and Incident. Technical assistant to team and to ensure that the knowledge both functional and technical is distributed within the team. Responsible for all communications (internal and external) and to handle client escalations. Managing major incident and proactive monitoring.
Problem Manager: Publish new incidents in the Problem Management report. Host a call to investigate and follow-up with the technology team for more effective discussions on the problem root cause, work around and corrective actions. Verify problem information and related documents is complete and accurate. Generate bi-weekly status report and present it to the client.
Onsite Experience: Travelled to Sweden, Gothenburg for 1 month (Mid of Nov 2016to Mid of Dec 2016), Volvocars Corporation, Sweden.
Programming languages and tools: Oracle PLSQL, UNIX, ETL, SAP BO, SVN, Service Now,.
2014.02 – 2014.08 Technical Lead, iGate Global Solutions Pvt. Ltd., Mumbai, India
Extensive use of UNIX Shell Scripts, Cron jobs and Autosys to automate process. Used PLSQL to create packages, functions, and procedures. Used PLSQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables. Tuning of the SQL queries, which takes long time to process the request using Explain plan, Hints to reduce the response time. Involved in all phase of database development, from needs assessment to QA/QC, design and support.
Programming languages and tools:Oracle PLSQL, UNIX, Autosys, BMC Remedy, SVN
2010.07 – 2014.01 Oracle PLSQL/ ETL developer (General Motors, Canada), Capgemini Consulting Pvt. Ltd., ?Mumbai, India
Direct Interaction with Client regarding Minor Enhancement in Application.Attainted Daily Meetings with Client regarding Ticket Information, New Enhancement. Creating Procedures, Packages, Functions, Triggers. Writing UNIX Scripts. Monitoring Job Scheduling in CA Unicentre / Autosys. Involved in analysis and development of database Objects like Table Structure, Triggers, Synonyms, Sequence etc. Upload Large Amount of Flat File using SQL Loader, External Table utility in to the Database using ETL. Maintain Application Version Control in PVCS. Resolving tickets on daily basis and communicating with clients for closure of the tickets. Creating various Health Check reports and communicates the same to client on daily basis. 24*7 Application and DBA support.
Programming languages and tools: Oracle PLSQL, UNIX, Datastage, Autosys, BMC Remedy, PVCS
2009.11 – 2010.03 Software Consultant, Vodafone India, Net Connect Global, Pune, India
Documented all the development work and taking care of version control. Monitoring and providing L2 support for North India Vodafone Circles for prepaid operations. Responsible for all BSCS, CMS processes and Billing prepay loading processes issues. Reconciliation between EMG Vs BSCS Vs IN to reduce mismatches b/w systems time to time and hence removing root causes of complaints. Analysis of file Processing Errors or Job Abends if any.Application health check on daily basis
Programming languages and tools:Oracle PLSQL, UNIX.
2008.10 – 2009.11 Oracle PLSQL and Oracle Forms and Report 6i Developer, UTI Technology Ltd, Mumbai, India
Test Designing of oracle forms & reports for assigned modules. Coding and testing of the assigned modules. Integration and Unit testing of the entire application. Formulating SQL queries and stored procedures on assigned modules
Programming languages and tools: Oracle PLSQL, Oracle Forms and Report, UNIX
2007.10 – 2008.09 L2 Support Analyst, Flexcube, Flexce International Pvt Ltd., Mumbai India
Provided online Production (L2) Support to “Lord Krishna Bank” one of the leading clients of Flexcel. Analyzing issues reported by client. Creating patches (SQL Script) to resolve the incidents. Worked on the Data migration of “Lord Krishna Bank”
from Flexcube to Finacle as their core banking solution.
Programming languages and tools:Oracle PLSQL, UNIX
EDUCATION
?
2004 - 2007 ???K.V. Pendharkar College, Mumbai University.
Graduated in 2007 - Bachelors of Science in Computer Science.
?
OTHER
Citizenship??Indian
Year of Birth?1985
Driving License?Indian License
Certifications?ITIL v3 Foundation, Six Sigma Yellow belt.
Awards?Project Star for Q4 2010 and Q3 2012 in Capgemini.
Project history
?
?
?Mayuresh Khismatrao
?PLSQL Team Lead / CRM Problem Manager
?
PROFILE
Result-oriented professional with 9+ years of comprehensive experience in automobile, BFSI, Telecom domains. I have worked in Application Support and Maintenance as a Consultant, Team Lead and CRM Problem Manager throughout my tenure in IT service industry
I love to explore new places around.
TOOL BOX
Tools??Version Controlling (SVN, PVCS), Job Schedulers (CA Unicentre, Autosys), Toad, SQL Developer, ETL (Datastage, OWB), SQL Loader, Ticketing Tool (Service Now)?
OS?Windows and Linux
Programming Languages? Oracle PLSQL, UNIX Shell scripting
Languages?English (fluent in speech and writing), Marathi (Native), Hindi (Speaking)
?
WORK EXPERIENCE
2015.07 – 2017.04??PLSQL Team Lead/CRM Problem Manager (Volvo Cars Corporation),
Capgemini Consulting, Mumbai, India
Team Lead : Overall Accountability including Planning and Execution of Spare Capacity, Change, Problem and Incident. Technical assistant to team and to ensure that the knowledge both functional and technical is distributed within the team. Responsible for all communications (internal and external) and to handle client escalations. Managing major incident and proactive monitoring.
Problem Manager: Publish new incidents in the Problem Management report. Host a call to investigate and follow-up with the technology team for more effective discussions on the problem root cause, work around and corrective actions. Verify problem information and related documents is complete and accurate. Generate bi-weekly status report and present it to the client.
Onsite Experience: Travelled to Sweden, Gothenburg for 1 month (Mid of Nov 2016to Mid of Dec 2016), Volvocars Corporation, Sweden.
Programming languages and tools: Oracle PLSQL, UNIX, ETL, SAP BO, SVN, Service Now,.
2014.02 – 2014.08 Technical Lead, iGate Global Solutions Pvt. Ltd., Mumbai, India
Extensive use of UNIX Shell Scripts, Cron jobs and Autosys to automate process. Used PLSQL to create packages, functions, and procedures. Used PLSQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables. Tuning of the SQL queries, which takes long time to process the request using Explain plan, Hints to reduce the response time. Involved in all phase of database development, from needs assessment to QA/QC, design and support.
Programming languages and tools:Oracle PLSQL, UNIX, Autosys, BMC Remedy, SVN
2010.07 – 2014.01 Oracle PLSQL/ ETL developer (General Motors, Canada), Capgemini Consulting Pvt. Ltd., ?Mumbai, India
Direct Interaction with Client regarding Minor Enhancement in Application.Attainted Daily Meetings with Client regarding Ticket Information, New Enhancement. Creating Procedures, Packages, Functions, Triggers. Writing UNIX Scripts. Monitoring Job Scheduling in CA Unicentre / Autosys. Involved in analysis and development of database Objects like Table Structure, Triggers, Synonyms, Sequence etc. Upload Large Amount of Flat File using SQL Loader, External Table utility in to the Database using ETL. Maintain Application Version Control in PVCS. Resolving tickets on daily basis and communicating with clients for closure of the tickets. Creating various Health Check reports and communicates the same to client on daily basis. 24*7 Application and DBA support.
Programming languages and tools: Oracle PLSQL, UNIX, Datastage, Autosys, BMC Remedy, PVCS
2009.11 – 2010.03 Software Consultant, Vodafone India, Net Connect Global, Pune, India
Documented all the development work and taking care of version control. Monitoring and providing L2 support for North India Vodafone Circles for prepaid operations. Responsible for all BSCS, CMS processes and Billing prepay loading processes issues. Reconciliation between EMG Vs BSCS Vs IN to reduce mismatches b/w systems time to time and hence removing root causes of complaints. Analysis of file Processing Errors or Job Abends if any.Application health check on daily basis
Programming languages and tools:Oracle PLSQL, UNIX.
2008.10 – 2009.11 Oracle PLSQL and Oracle Forms and Report 6i Developer, UTI Technology Ltd, Mumbai, India
Test Designing of oracle forms & reports for assigned modules. Coding and testing of the assigned modules. Integration and Unit testing of the entire application. Formulating SQL queries and stored procedures on assigned modules
Programming languages and tools: Oracle PLSQL, Oracle Forms and Report, UNIX
2007.10 – 2008.09 L2 Support Analyst, Flexcube, Flexce International Pvt Ltd., Mumbai India
Provided online Production (L2) Support to “Lord Krishna Bank” one of the leading clients of Flexcel. Analyzing issues reported by client. Creating patches (SQL Script) to resolve the incidents. Worked on the Data migration of “Lord Krishna Bank”
from Flexcube to Finacle as their core banking solution.
Programming languages and tools:Oracle PLSQL, UNIX
EDUCATION
?
2004 - 2007 ???K.V. Pendharkar College, Mumbai University.
Graduated in 2007 - Bachelors of Science in Computer Science.
?
OTHER
Citizenship??Indian
Year of Birth?1985
Driving License?Indian License
Certifications?ITIL v3 Foundation, Six Sigma Yellow belt.
Awards?Project Star for Q4 2010 and Q3 2012 in Capgemini.
?
?Mayuresh Khismatrao
?PLSQL Team Lead / CRM Problem Manager
?
PROFILE
Result-oriented professional with 9+ years of comprehensive experience in automobile, BFSI, Telecom domains. I have worked in Application Support and Maintenance as a Consultant, Team Lead and CRM Problem Manager throughout my tenure in IT service industry
I love to explore new places around.
TOOL BOX
Tools??Version Controlling (SVN, PVCS), Job Schedulers (CA Unicentre, Autosys), Toad, SQL Developer, ETL (Datastage, OWB), SQL Loader, Ticketing Tool (Service Now)?
OS?Windows and Linux
Programming Languages? Oracle PLSQL, UNIX Shell scripting
Languages?English (fluent in speech and writing), Marathi (Native), Hindi (Speaking)
?
WORK EXPERIENCE
2015.07 – 2017.04??PLSQL Team Lead/CRM Problem Manager (Volvo Cars Corporation),
Capgemini Consulting, Mumbai, India
Team Lead : Overall Accountability including Planning and Execution of Spare Capacity, Change, Problem and Incident. Technical assistant to team and to ensure that the knowledge both functional and technical is distributed within the team. Responsible for all communications (internal and external) and to handle client escalations. Managing major incident and proactive monitoring.
Problem Manager: Publish new incidents in the Problem Management report. Host a call to investigate and follow-up with the technology team for more effective discussions on the problem root cause, work around and corrective actions. Verify problem information and related documents is complete and accurate. Generate bi-weekly status report and present it to the client.
Onsite Experience: Travelled to Sweden, Gothenburg for 1 month (Mid of Nov 2016to Mid of Dec 2016), Volvocars Corporation, Sweden.
Programming languages and tools: Oracle PLSQL, UNIX, ETL, SAP BO, SVN, Service Now,.
2014.02 – 2014.08 Technical Lead, iGate Global Solutions Pvt. Ltd., Mumbai, India
Extensive use of UNIX Shell Scripts, Cron jobs and Autosys to automate process. Used PLSQL to create packages, functions, and procedures. Used PLSQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables. Tuning of the SQL queries, which takes long time to process the request using Explain plan, Hints to reduce the response time. Involved in all phase of database development, from needs assessment to QA/QC, design and support.
Programming languages and tools:Oracle PLSQL, UNIX, Autosys, BMC Remedy, SVN
2010.07 – 2014.01 Oracle PLSQL/ ETL developer (General Motors, Canada), Capgemini Consulting Pvt. Ltd., ?Mumbai, India
Direct Interaction with Client regarding Minor Enhancement in Application.Attainted Daily Meetings with Client regarding Ticket Information, New Enhancement. Creating Procedures, Packages, Functions, Triggers. Writing UNIX Scripts. Monitoring Job Scheduling in CA Unicentre / Autosys. Involved in analysis and development of database Objects like Table Structure, Triggers, Synonyms, Sequence etc. Upload Large Amount of Flat File using SQL Loader, External Table utility in to the Database using ETL. Maintain Application Version Control in PVCS. Resolving tickets on daily basis and communicating with clients for closure of the tickets. Creating various Health Check reports and communicates the same to client on daily basis. 24*7 Application and DBA support.
Programming languages and tools: Oracle PLSQL, UNIX, Datastage, Autosys, BMC Remedy, PVCS
2009.11 – 2010.03 Software Consultant, Vodafone India, Net Connect Global, Pune, India
Documented all the development work and taking care of version control. Monitoring and providing L2 support for North India Vodafone Circles for prepaid operations. Responsible for all BSCS, CMS processes and Billing prepay loading processes issues. Reconciliation between EMG Vs BSCS Vs IN to reduce mismatches b/w systems time to time and hence removing root causes of complaints. Analysis of file Processing Errors or Job Abends if any.Application health check on daily basis
Programming languages and tools:Oracle PLSQL, UNIX.
2008.10 – 2009.11 Oracle PLSQL and Oracle Forms and Report 6i Developer, UTI Technology Ltd, Mumbai, India
Test Designing of oracle forms & reports for assigned modules. Coding and testing of the assigned modules. Integration and Unit testing of the entire application. Formulating SQL queries and stored procedures on assigned modules
Programming languages and tools: Oracle PLSQL, Oracle Forms and Report, UNIX
2007.10 – 2008.09 L2 Support Analyst, Flexcube, Flexce International Pvt Ltd., Mumbai India
Provided online Production (L2) Support to “Lord Krishna Bank” one of the leading clients of Flexcel. Analyzing issues reported by client. Creating patches (SQL Script) to resolve the incidents. Worked on the Data migration of “Lord Krishna Bank”
from Flexcube to Finacle as their core banking solution.
Programming languages and tools:Oracle PLSQL, UNIX
EDUCATION
?
2004 - 2007 ???K.V. Pendharkar College, Mumbai University.
Graduated in 2007 - Bachelors of Science in Computer Science.
?
OTHER
Citizenship??Indian
Year of Birth?1985
Driving License?Indian License
Certifications?ITIL v3 Foundation, Six Sigma Yellow belt.
Awards?Project Star for Q4 2010 and Q3 2012 in Capgemini.
Local Availability
Only available in these countries:
India
