Mehul Kumar Email & Phone Number

Bengaluru, Karnataka, India

Karnataka, India

Masterdata Management, Business Domain: PLM In Veoneer, as Masterdata Management Associate, I am responsible for managing & maintaining all interaction of the 308 informatica workflows responsible for inbound & outbound integrations of PLM and to maintain data consistency between all the business application in Veoneer ecosystem Achieved 60% reduction in incident tickets related to integration issues, resolved critical integration issues by coordinating with Sales, Purchasing, Database and Informatica teams Innovated and developed a technical solution using Java SE8 and Oracle DB connector to monitor the execution of the informatica workflows externally and to notify the Business Intelligence in case of failure Successfully split the PLM integrations based on the product lines and currently supporting the production related issues Extended my support to ALM team for DOORS – CB Migration project, innovated and executed a technical solution utilizing Java SE 8 and JSON to automate the migration process of DOORS projects to Codebeamer using REST API of DOORS-CB bridge. Reduced manual effort by 80% by building this solution Extended my support to PLM infrastructure project, designed and built the entire infrastructure setup for the Enovia PLM 2013x test environment independently. Created detailed documentation, including comprehensive installation and maintenance guides. Oversaw the installation and configuration of web servers, application servers, File Collaboration, Oracle 11g DB instance, Exalead server, and Report server for the Enovia PLM test system Demonstrated my expertise in Oracle DB administration by implementing the disaster recovery solution for PLM DB using TVD Backup & Standby in test environment

Bengaluru Area, India

Project: 3DExperience Enovia 2018x UpgradeClient: Texas Instruments, Business Domain: PLMCollaborated with Consultants, Architects, Project Managers & various internal/external stakeholders to develop a comprehensive plan for Go Live activities, project release, pre-production rehearsals and rollback strategies. Ensured the successful delivery of the 3DExperience 2018x environment by incorporating industry best practices & principlesDesigned & documented the architecture for 3DExperience 2018x based on thorough analysis of business requirements & a deep understanding of the existing application architectureImplemented software load balancing & reverse proxy using Apache 2.4 to optimize the accessibility of 3DExperience services such as 3Dpassport & 3DspaceConducted a detailed analysis of database upgrades during the proof-of-concept phase, proactively identified & resolved upgrade-related issues, & provided effective solutionsCollaborated closely with the database team to facilitate the seamless installation & configuration of Oracle 12c DB. Successfully executed the database migration from the existing AS-IS environment to TO-BE environmentImplemented SSL certificates to ensure secure data transmission & encryption during transitInstalled & configured 3DExperience 2018x, including essential services such as 3DPassport, 3DSpace, 3DDashboard, 3DComments & 3DNotificationsAnalyzed the technical gaps between the AS-IS & TO-BE environments, focusing on areas such as application installation process, DB upgrades, software version compatibility & system requirementsIdentified & documented potential risks associated with the implementation, evaluating their impact on the application ecosystem & the scheduled project objectivesEstimated & documented the necessary effort and time required for application server readiness, database server readiness, 3DExperience installation, DB upgrade, Fix pack (1912) installation, & Mid-Market application installation

Bengaluru Area, India

Project: 3DExperience Enovia 2018x UpgradeClient: Halliburton, Business Domain: PLMConducted a comprehensive analysis of the gaps in DB configuration and application architecture between the existing environment and the upgraded environment, documenting the findingsThoroughly estimated efforts and planned the Go Live activities for the Enovia 2018x upgrade, ensuring a well-structured and documented approach.Constructed a dedicated training environment for the internal team and end-users, enabling effective training sessions on the 3DExperience 2018x platform.Provided guidance and supervision to a team of two system administrators, overseeing the installation and configuration of Oracle 12c DB instances. Managed the seamless migration of the database from Oracle 11g to Oracle 12c DB and implemented RMAN backup for the Enovia 2018x DB environment.Proficiently worked with HTTP/HTTPS protocols and employed SSL encryption to secure data traffic over HTTP.Effectively resolved issues related to HP Autonomy Search, troubleshooting and implementing solutions to ensure smooth functionality.

Bangalore, India

Project: HP ALM/QC Version Consolidation & UpgradeClient: Nokia Networks, Business Domain: ALMSuccessfully delivered the QC consolidation and upgrade project within the specified deadlines, following industry best practice patterns and principlesConsolidated the HP ALM/QC versions 10 & 11.52, upgraded it to HP ALM/QC 12.01 and then upgraded it to HP ALM/QC 12.53Shared knowledge with the team regarding activities such as Oracle DB migration, integration setup, HP ALM/QC version and patch upgrades, DB upgrades, and QC project upgradesLed the end-to-end QC consolidation and upgrade project, starting from technical analysis and proof of concept to the setup of production and disaster recovery environments.Developed a disaster recovery solution for the upgraded QC environment, meeting the agreed recovery point objective and recovery time objectivePlayed a critical role in customer meetings by providing project status updates, managing and tracking business requirements, and clarifying technical queries from clients, management, and team membersProvided valuable technical inputs and responded to technical queries to support customers in decision makingProactively identified, analyzed, and mitigated technical risks during the proof of concept phaseWorked on Oracle DB migration, file repositories migration, QC project upgrade from 11.52 to 12.53, followed by patch upgrades to 12.53, and documented these processes in simple languageCollaborated and coordinated with internal teams and third-party vendors for activities such as server requisition, firewall enablement, integration setup, and database installation.Planned and implemented the proof of concept for the QC consolidation and upgrade project, documented the results, estimated the efforts required and developed work breakdown structures in both production and non-production environments

Bengaluru Area, India

Project: Pronto Database Development & AdministrationClient: Nokia Solutions & Networks, Business Domain: ALMFunctioned as a proficient database administrator overseeing MySQL 5.6.32 enterprise editionAccountable for ensuring the smooth operation of database replication, database backup and restore processes, database performance tuning, and efficient database deploymentCoordinated and executed database refresh activities multiple times to prepare the QA environment for UAT (User Acceptance Testing)Shared comprehensive knowledge on MySQL database administration with a team of three system administrators, fostering collaboration and skill developmentContributed to the development of stored procedures to implement critical functionalities, aligning them with specific business requirementsSuccessfully resolved critical database-related issues across production, disaster recovery, and QA environments, demonstrating a proactive troubleshooting approachConstructed a robust development environment for MySQL databases, facilitating analysis and development of functionalities to fulfill business requirements

Bengaluru Area, India

Project: HP ALM/QC 11.52 Infrastructure MovementClient: Nokia Solutions & Networks, Business Domain: ALMSuccessfully migrated the application infrastructure, including file storage, DB storage, integration setup, and application setup, to re-host the HP ALM/QC application using industry best practicesLed the end-to-end movement of the HP ALM/QC infrastructure, from conducting technical analysis and proof of concept to setting up production and disaster recovery environments in a new data centerPrepared and executed a comprehensive go-live plan for the HP ALM/QC 11.52 application, including the migration of large-sized database instances from old DB instances to new DB instancesEfficiently planned the infrastructure movement activity for the HP ALM/QC application and documented a detailed work breakdown structureThoroughly documented the process of re-hosting the application and shared knowledge with the teamProject: HP ALM/QC 11.52 Application Performance Tuning & MaintenanceClient: Nokia Solutions & Networks, Business Domain: ALMCreated a proof of concept (POC) command line interface utility that leveraged the REST API of HP ALM/QC 11.52, enabling end users to interact with the application more efficientlyImplemented optimization strategies in four phases to enhance the performance of the legacy QC workflow source code, delivering significant improvements to clientsConducted in-depth analysis of AWR and ADDM reports for Oracle DB instances, performing descriptive data analysis and implementing Oracle 11g DB tuning techniquesResolved application performance issues at the application server level by fine-tuning Java heap memory allocation and optimizing application cachesDesigned and developed Unix shell scripts to automate weekly maintenance tasks for HP ALM/QC 11.52, such as clearing stale (FINWAIT_2) connections, cleaning temporary workspaces, and restarting the application

Bengaluru Area, India

Project: HP ALM/QC 11.52 Application Customization & AdministrationClient: Nokia Solutions & Networks, Business Domain: ALMWorked effectively in DB migration across the environments to troubleshoot production issues for HP ALM/QC 11.52Fixed application performance issues at application server by tuning Java heap memory & by tuning the application cachesPerformed Oracle 11g DB tunning by generating & analyzing reports like AWR & ADDM using descriptive data analysis techniqueOptimized the legacy QC workflow source code and shown the remarkable improvements to the customersWas responsible for implementing latest application patch for HP ALM/QC 11.52. Successfully planned , implemented & configured pactched in fixed timelines & with no reworkWorked on horizontal scaling of HP ALM/QC 11.52 infrastructure by adding new application & integration nodes to extend services for increased no. of end usersProject: Enovia V6 Application Maintenance & SupportClient: Nokia Siemens & Networks, Business Domain: PLMHandled QC application integration (SOA) effectively with PLM & Requirement management application and troubleshot production related in runtimeDeveloped desktop application using core Java & swings concepts to monitor the URLs of critical enterprise applicationsDeveloped enterprise applications for Nokia Siemens Networks & Johnson Control Inc. to monitor web application availability and status of the integrations with other systemsWas responsile to maintain & support service-oriented architecture for eMatrix V6 application troubleshot integration issues in productionDeveloped executable jars to push data to PLM application eMatrixV6Worked in application management & support in PLM application eMatrixV6. Used Tool Command Language & Matrix Query Language to automate technical processWas responsible for technical process improvement and developed several scripts in TCL, Java and UNIX shell to automate the manual processes

Master’S Degree, Computer Software Engineering

Bachelor'S Degree, Information Technology

High School, Science, A