SELVA

SKLLS

STRENGTH

• Problem solving
• Willingness to learn - R&D
• Team player - Adaptability
• Self Confidence - Positive Attitude

BASIC INFO

PROFESSIONAL PROFILE  

Presently with E2open india Pvt Ltd as Enterprise Service Engineer in Planning Vertical - Demand Sensing Product
From 3 MAY 2023 to Present.

PROJECT EXPERIENCE:

PROJECT 1:

Description

    Demand Sensing - Accurate Forecasts Based on Real-Time Demand Signals. Estimating aggregated demand months in advance is an established practice, but accurately predicting customer orders over a time horizon of several weeks is next to impossible without advanced data science. E2open® Demand Sensing uses automation and machine learning technology to analyze real-time supply chain data, determine the influence of multiple demand signals, and produce an accurate daily forecast for every item at every location.

Roles & Responsibilities:

• Perform in-depth technical investigation, troubleshooting, root cause analysis and drive issue resolution (including config changes/fixes) escalated by customer support team within the agreed customer SLAs.
• Ensure periodic quality updates on tickets to share the latest status to customers and internal stakeholders.
• Work on identifying and implementing workaround for business continuity.
• Validate code fixes developed and coordinate/plan the UAT with customer for production fix rollout.
• Perform production patch deployment by following e2open’s deployment process.
• Be proactive in identifying and implementing preventative measures for customer problems with better understanding on the customer business processes.
• Collaborate and drive resolution with various internal teams namely Product Development, Professional Services, Cloud Operations, and Quality Assurance.
• The Enterprise Service Engineer will help and mentor Associate Enterprise Service Engineers to troubleshoot and resolve customer problems.
• Enterprise Service Engineer should manage allocated Customer solution independently.
• Participate in solution transition session from Professional Services to Enterprise Service organization to be self-sufficient with functional/technical skills on customer solution.
• Engage and participate in continuous improvement plan activities on assigned solution for a stable production environment and reduction on recurring issues.
• Constantly look for opportunities to automate repetitive or manual activities.
• Participate in creating, maintaining, and utilizing knowledgebase articles.
• Drive and coordinate the weekly review calls with customers.
• Ensure all relevant case details are updated accurately and timely.
• Continuous upskill of functional/technical knowledge on product and customer solution.
• Participate in on-call rotations as assigned.

PROFESSIONAL PROFILE  

Worked with Cubespace Technologies Pvt Ltd as PLSQL DEVELOPER
From 3 JUNE 2019 to 10th March 2023.

PROFESSIONAL SUMMARY

• Oracle PL/SQL developer with 3.9 years of experience in database development and L1/L2/L3 production support, database migration for Oracle databases.
• Expertise in Client-Server application development using Oracle 11g/10g/12c, PL/SQL, SQL Developer, SQL *PLUS and TOAD
• Involved in all phases of the SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle).
• Strong experience in creating and modifying database objects such as Packages, Procedures, Functions, Triggers, Views, Materialized Views, and Sequences.
• Proficient in using Ref Cursor, Bulk Collect, Pragma Autonomous Transaction, and Collections.
• Experience in using DDL, DML, and TCL commands.
• Experience in Joins, Subqueries, Single row Functions, Collections and Exception Handling.
• Import data with Oracle Tables using SQL Loader.
• Export retrieveddata from database as pdf, txt, csv, html, insert query using sql developer.
• Expertise in Troubleshooting database-related issues and working with other teams to resolve issues in a timely manner.
• Experience in Manual Testing and knowledge about Selenium automation testing using basic Java and Python.
• Strong experience in Writing Test Cases, Test Plans, and Test Scripts, and executing them using manual and automated testing methods.
• Experience in designing and executing Unit, Integration, Functional, Regression Testing.
• Excellent Problem-Solving skills and attention to detail.

PLSQL PROJECT EXPERIENCE:

PROJECT 1:

Description

    Humana Healthcare is a leading healthcare insurance provider in the United States. The company offers a range of health insurance products and services to individuals and organizations, including medical, dental, and vision coverage, as well as wellness programs and health management services. The project involves a team of specialists who troubleshoot and resolve issues, optimize code, and integrate new technologies to ensure that the applications are running smoothly and efficiently.

Roles & Responsibilities:

• Developing and maintaining PL/SQL code for healthcare member enrolment, provider enrolment, billing, verifying member status, contract status and claim status.
• Monitor the production environment and perform regular health checks.
• Troubleshoot issues reported by L1 / L2 / client / users and resolve them in a timely manner.
• Document the issues, resolutions and process updates to Create & maintain knowledge base for known issues and their resolutions like mini SOP.
• Collaborating with the front-end team to understand requirements and updating procedures, functions, and packages to validate and load data into target tables based on the current requirement.
• Creating and modifying tables, views, indexes, sequences, synonyms, materialized views, and constraints to implement business rules.
• Loading data from flat files into database tables using SQL Loader. If required, the direct path loader can be used, followed by normalization and constraint and index validation.
• Supporting SIT and UAT testing, fixing interface aborts, and solving tickets within SLA
• Fixing IRs in production support and coordinating with the team using ServiceNow.
• Carrying out impact analysis, preparing root cause analysis, and monitoring activity to exceed clients SLAs in terms of quality and productivity.

PROJECT 2:

Description

     Humana is an Oracle PL/SQL database development project that involves creating a website to access claim details, authorization information, eligibility information, and contract details. The website provides a user-friendly interface for managing the data and ensuring that the information is up-to-date and easily accessible. The project involves the use of PL/SQL development and enhancement of database.

Roles & Responsibilities:

• Developing and enhancing the PL/SQL database for accessing claim details, authorization information, eligibility information, and contract details.
• Completing development tasks assigned via Jira.
• Understanding the logical/physical data model and documenting Business Requirements provided by the Business Analyst.
• Creating an Impact Analysis document to assess the impact of proposed changes.
• Creating a detailed Design Document outlining the implementation plan.
• Designing and creating test cases for Unit Testing to ensure the code is thoroughly tested.
• Performing the coding process and ensuring it meets the design document and coding standards.
• Conducting Unit Testing and saving the results to validate the code.
• Maintaining the Coding Documents in git, and updating them with any changes made.
• Collaborating with the testing team to plan and design test cases for effective testing.
• Debugging PL/SQL code to identify and fix defects found during testing based on priority and severity, and providing support to testers as needed.
• Continuously learning and enhancing knowledge of the manual testing process to better support the testing team.

PROJECT 3:

Description

    As an Oracle PL/SQL developer working on a data migration project, Need to ensure that the data is accurately migrated from the source to the destination database. The project involves using provided build files to run the migration process step by step and fixing any issues or errors that occur during the migration process.

Roles & Responsibilities:

• Work closely with the data migration team to understand the requirements and goals of the project.
• Review and analyze the provided build files to understand the migration process.
• Execute the migration process step by step, ensuring that the data is accurately migrated from the source to the destination database.
• Monitor the migration process to identify and address any issues or errors that may arise.
• Perform unit testing to ensure that the migration process is successful and that the data is accurately migrated.
• Work with the testing team to identify any defects or issues that may need to be addressed during the testing process.
• Provide support and maintenance for the migration process after it has been completed to ensure the ongoing accuracy and reliability of the data.

PROFESSIONAL PROFILE  

Worked with PyungHwa Automotive (PHA) India Private Limited
Incoming inspector – Supplier Quality Assurance
From 1st June 2017 to 6th June 2018.

COMPANY PROFILE

• Indo, US, and Korean Joint venture Auto Component Manufacturing company
• Located at sriperumbudur and Employs 450 personnel
• Engaged in supplying of Door Latches, Strikers, Hinges, Checkers, etc to Hyundai Motor India Limited.

RESPONSIBILITIES

• Customer Coordination (Hyundai) Maintaining Single PPM.
• Checking the overall quality of the product and make a report before sending the product to the sales department / line.
• Stock management (both SAP and physical stock).
• Critical Part layout inspection.
• Supplier PPM display, Quality alert, organization chart, work instruction preparation.
• Conducting quality confirmation tests.
• Preparation of Defect Content Report.
• Containment action & Counter Measure for Supplier Quality Concern (Incoming / Line / Customer)
• Well versed commodity are Plastic / Rubber / Pin / Cable / Pressing / Welding / Switch / Plating / Heat treatment.

BASIC KNOWLEDGE ABOUT

• 3C, 5S, 4M, 7QC tools.
• 8D Problem solving methodology.
• Supplier audit plan preparation.
• Counter measure Verification audit / Process Audit / Product Audit / 4M Change audit.
• Commodity Wise Rejection Analysis & Monitoring the Supplier Performance.
• Weekly Basis Rejection Trend Updation.
• Daily Rejection Communicate to Supplier & Scrap Part Disposal.
• Preparation of Revalidation Plan & Verification.
• Knowledge about AOI, ISIR and PPAP Document Preparation like Process Flow Diagram, Control Plan, PFMEA.
• Process Knowledge about Plastic moulding process & Welding process.
• Process Knowledge about Electro plating and Electro painting process.

TECHNICAL SKILLS

SOFTWARE : Excel, PowerPoint, Word, SAP (essential), Creo 2.0, AutoCAD 2D.
PRECISION INSTRUMENTS : 2D Height gauge, Profile Projector.
TEST : Water Resistant test, Salt Spray Test, Hardness Test.

OTHER INDUSTRIAL EXPERIENCE

• Industrial visit to Integral Coach Factory, Perambur, Chennai, 2015.
• lnplant training at Chennai port trust, Chennai, 2016.
• Corporate visit to Barclays, DLF, Chennai, 2017.
• Undergone a project work on BHEL boiler auxiliary plant, Ranipet, 2017.
• Industrial visit to spring manufacturing industry ­ Action Spring Products, Perungudi, Chennai, 2018.
• Industrial visit to Plastic moulding industry ­ Esteem polymer Products, Chembarambakkam, Chennai, 2018.
• Industrial visit to Robotic welding industry ­ S.P. Engineers, Kakkalur, Chennai, 2018.
• Industrial visit to Plating industry ­ Bright Metal Finishers Unit II, Irungattukottai, 2018.
• Industrial visit to Electro Paint industry ­ Phorotech India Pvt Ltd, Irungatukottai,2018.
• Industrial visit to Casting and Machining industry ­ CRP India Pvt Ltd, Thirumudivakkam, 2018.

TECHNICAL EXPERIENCE

• Workshop on INDUSTRIAL AUTOMATION conducted by CAD Centre, Chennai.
• Workshop on ENTREPRENEURSHIP conducted by Madha Engineering College, Chennai.
• Presented a paper on “AUTOMATIC PNEUMATIC CENTRE STAND” in National level technical symposium TORQ 2K16 held at Loyola – ICAM, Chennai.
• Presented a paper on “OPTIMISATION OF FCAW PROCESS PARAMETERS” in National level conference NCAMMT’17 held at SRM university vadapalani campus, Chennai.

AWARDS & ACHIEVEMENTS

• Received number of award in school level DRAWING competition.
• Awarded 3rd price in district level DRAWING competition conducted by GOVT OF TAMILNADU.
• Awarded 1st price in AD FILM MAKING in college cultures during 2015.
• Awarded for 100 % ATTENDANCE in college cultures during 2015.
• Event COORDINATOR in Technospark 2k15 in National level college symposium during 2016.

PROJECT