Ramesh Samiappan
ERODE,TN
Summary
An Experienced IT Oracle Professional with around 10+ years of global experience in End-to-End ERP Implementations and development/support with exceptional database skills. Have the ability to work independently as well as good team contributor on group projects. Well versed experience with End-to-End Shop floor ERP application implementation including planning, requirement, design, development, testing & support with oracle as database and forms & report front end application. Proficient in Oracle 10g /11g/12c and Good Knowledge on PHP, HTML. Extensive experience in developing packages, stored procedures, Functions, Views and Indexes as well as use of Exceptions, Joins, Sub queries and set operators. Experienced Using PL/SQL Bulk collects. Work Experience in rotational shifts 24/7 Production support. Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines and exposure writing complex SQL Queries. Have good experience in IT industry in broad range of functions & Involved in development of various software projects. Bulk data Collecting, Performance tuning of huge data with use of PLSQL collections and records. Proficient in Requirement Analysis, Project Planning Documentation Reviews. Developed Database Triggers for audit and validation purpose. Export and Import Database level or Schema level by using WINSCP. Involved in PL/SQL Programming and developed a Form that can access an Oracle Database. Perform in Personalized Roadmap Technology and efficient in Forms and Reports. Performed functional testing for the procedures and packages. Working with UNIX commands and involved in fixing Production issues. Effectively made use of Pragma Autonomous transaction, Pipeline functions and exceptions. Experienced in working in production support projects. Experienced in developing Joins, Indexes and sequences.
Overview
10
10
years of professional experience
Work History
D2K Developer
Prodware Solutions Private Limited-Client(Piaggio Vehicles Private Ltd)
01.2023 - Current
- Primarily responsible for working on end to end Oracle ERP solution delivery management for Improvement Projects inclusive of Complete shop floor management – Covering Fabrication / Paint shop / assembly for 2 Wheeler (2Wh) and commercial vehicles (CV) with key operation as Chassis and VIN number generation for domestic & export vehicles, Chassis number engraving with compliance to domestic as well export norms with country specific VIN plate generation, Process enhancement with RF /Bluetooth / wired scanners to absolute the human errors
- For Engine / Gear box plants –Engraving management, scanner based catcon linkage with gear box and engine
- HRMS payroll & attendance – Attendance process, salary processing, employee master, shift & leave management
- Vehicle warranty system – Managing pre delivery inspection (PDI), free service coupons (FSC), warranty claim settlement and processing, generating Credit & Debit notes against claims and transfer to SAP, auto mail intimation to Dealers along with monthly reports
- Complied with GST norms for all warranty processes
- Spare parts division management CV and 2Wh – Box pre packing system, printing management such MRP sticker printing, case box sticker printing with 2D and QR code formats, integration with cross legacy system for MRP pricing updating
- Other application management and point of Escalation for all IT application related function / technical issues at Piaggio as below – Canteen Management system ( CMS ), Contract labour management system ( CLMS), Ascent payroll management, SCADA PLC, Massaging queue (MQ – IBM Web Sphere), Canteen Management system ( CMS ), Quick view BI, Microsoft power BI, Dyno Meter / HOT & COLD / ABS testing, Access Manager Pro (ACM PRO), ECU flashing, Twist durability testing, Torque management, Vehicle fleet management
D2K Developer
SKM Animal Feeds and Foods (India) Private Limited
11.2021 - 05.2022
- Involved in the whole life cycle of the project
- Develop and deploy Forms applications
- Create Form and Reports for customized purpose
- Supports to technical team if any problem occurs solve the issues immediately
- Analysis the requirements from Business and functional team
- Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL
- Built complex queries using SQL and wrote stored procedures using PL/SQL
- Involved in development of interface programs to import parts information to inventory base tables
- Atomized routine jobs using DBMS_JOB
- On completion of these jobs an email will be sent out automatically with the help of UTL_MAIL
- Loaded the data into database tables using SQL
- Loader from text and excel files
- Developed data model, SQL Queries, SQL Query tuning process and Schemas
- Developed various RDF and XML Publisher and Apex Reports.
Oracle PL/SQL Developer
VTB Bank international ltd
10.2019 - 09.2021
- The Trade and Export Finance trading is an online trading business which involves in providing product support application commodities market, currency market and equity market
- Responsible for the designing the advance SQL queries, procedure, cursor, triggers
- Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
- Experienced in Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE
- Worked extensively on Ref Cursor, External Tables and Collections
- Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
- Created indexes on the tables for faster retrieval of the data to enhance database performance
- Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
- Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
- Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Oracle PL/SQL Developer
Honda Cars India
06.2017 - 09.2019
- Involved in the whole life cycle of the project
- Analysis the requirements from Business and functional team
- Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL
- Built complex queries using SQL and wrote stored procedures using PL/SQL
- Involved in development of interface programs to import parts information to inventory base tables
- Atomized routine jobs using DBMS_JOB
- On completion of these jobs an email will be sent out automatically with the help of UTL_MAIL
- Loaded the data into database tables using SQL
- Loader from text and excel files
- Developed data model, SQL Queries, SQL Query tuning process and Schemas
- Developed various RDF and XML Publisher and Apex Reports
- Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
- Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE
- Responsible for developing technical specifications from business requirements.
Future Group
01.2016 - 05.2017
- Involved in the whole life cycle of the project
- Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements
- Conduct research and find solutions for complex technical problems
- Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL
- Built complex queries using SQL and wrote stored procedures using PL/SQL
- Developed data model, SQL Queries, SQL Query tuning process and Schemas
- Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
- Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE
- Developed UNIX Shell scripts to automate table creation, execute procedures
- Involved in Production support for fixing bugs, UAT and Live support
- Involved in development of interface programs to import parts information to inventory base tables
- Extensively used Ref cursor, Bulk collects, PL/SQL Collections, dynamic SQL, Unit and System Testing
- Involved in resolving production problems for the applications and Ensure all support service level agreements are met.
I Publish Central
03.2015 - 12.2015
- Understanding of Code to update the product
- Responsible for modification of existing components as per requirement
- Responsible for creation of few layouts of the application
- Coordination with development team to discuss modification of new features.
Integration with Sterling Payment Gateway
01.2014 - 02.2015
- Discussion with the client to get detailed requirements
- Understanding of payment gateway APIs and discussion with their technical team for clarifications
- Worked as key player in the project and lead the team
- Responsible for functional study of the application
- Designed the GUI design layout for the application including the internal modules.
Education
Master of Science in Information Technology -
Anna University
Bachelor of Science in Computer Science -
Bharathiar University
Skills
- SQL Developer, Toad, SQL
- Plus
- UNIX, WINDOWS
- Oracle 10g/11g/12c
- SQL, PL/SQL, UNIX, PHP
Timeline
D2K Developer
Prodware Solutions Private Limited-Client(Piaggio Vehicles Private Ltd)
01.2023 - Current
D2K Developer
SKM Animal Feeds and Foods (India) Private Limited
11.2021 - 05.2022
Oracle PL/SQL Developer
VTB Bank international ltd
10.2019 - 09.2021
Oracle PL/SQL Developer
Honda Cars India
06.2017 - 09.2019
Future Group
01.2016 - 05.2017
I Publish Central
03.2015 - 12.2015
Integration with Sterling Payment Gateway
01.2014 - 02.2015
Master of Science in Information Technology -
Anna University
Bachelor of Science in Computer Science -
Bharathiar University