SURENDIRAN VEERABATHIRAN

Email:ad5btq@r.postjobfree.com Mobile: 240-***-****

Professional Summary

●19 Years of experience in full Software Development Life Cycle (SDLC) specializing in the areas of business requirement analysis, data model, database design, Coding and implementation.

●Experience with Data flow diagrams, Data dictionary, Database normalization theory and techniques, Entity relation modeling and design techniques.

●Experience in creating oracle objects Tables, Views, Triggers, stored procedures, packages and functions.

●Experience in writing DDL queries, DML commands, SQL Queries, Analytical functions and set operators.

●Experience in Import and Export data, XML data type, and XML script.

●Experience in writing Cursor, dynamic SQL using PL/SQL with advanced PL/SQL techniques such as REF Cursor and Bulk Operations.

●Experience in Performance Tuning, Query Optimization, and Sending mail using oracle procedures.

●Experience in Oracle Databases using the Oracle Rest Data Services (ORDS)

●Experience with Oracle Supplied Packages such as DBMS_JOB and UTL_FILE.

●Experience in Exception handling and error Logging.

●Experience in SQL Server, TSQL, Sybase, DB2, MS-SQL, Oracle Forms and Reports, Crystal Reports.

●Worked on Unix/Linux Shell scripting, CRON Jobs, ETL Methodologies, BI Publisher, OBIEE reports.

●Experience in Table Partitioning, Collections, Analytical function, materialized views.

●Experience in generating AWR reports and reading AWR reports and ADDM and ASH reports.

●Designing and Deployment of Reports using SSRS.

●Experience in Agile/scrum methodologies.

●Experience in converting COBOL program in to Oracle stored procedures and functions.

●Experience in converting DB2 procedures into Oracle stored procedures.

●Experience in creating SSRS Reports, Oracle Forms designing and oracle Reports designing.

●Experience in Oracle Apps modules like HRMS, Inventory, Purchase, and Order Management.

Skills

Database

Oracle 7.x, 8.x, 9.x, 11g,12c, MS SQL SERVER 2005,2008,2012

Development tools

SQL, PL/SQL, Oracle utilities.

Designer tools

Oracle Forms, Oracle Reports, BI Publisher, Power BI, Oracle Database

Designer, SQL Data Modular, MS-Visio, MS office.

ETL Tools

SQLLDR and UTL Packages, SSIS, SSRS

Database tools

SQL Developer, PLSQL Developer, DB2, DB query tool & TOAD, Oracle APEX.

Job Schedulers

ORACLE Schedulers / SQL agent

Operating System

Windows, Unix, Open VMS

Oracle Apps Modules:

Oracle EBS, HRMS, Inventory, Purchase, Order Management.

Internet Technology

HTML, Java Script, Java, .Net, HPSD, Jira, CA Clarity, Apache Tomcat, SVN.

Projects

Title : MPP data migration

Type : Application Development and Enhancement.

Client : JPMChase, (Virtusa)

Duration : Apr 2022 – Till date

Role : Lead PL/SQL Developer

Responsibilities:

Worked closely with Project Team, SME and Internal Business Partners (IPs) to understand the existing system functionalities and business requirements.

Involved from the beginning of the project to post implementation of full SDLC process.

Involved in all phases of database design, development, Testing, End user Training and support.

Created oracle database objects like Table, Views, synonyms, procedures, functions and packages.

Extensively worked in Tuning procedures, functions and packages to improve performance of the application.

Involved in Unit and parallel testing with existing system.

Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.

Data Migration from Traditional database to Oracle database.

Designed SSRS Reports to replace existing Reports.

Environment: Oracle 12c, SQL, PLSQL, PL SQL developer.

Title : NEBF Enterprise Application Suite (NEAS)

Type : Application Development and Enhancement.

Client : National Electrical Benefit Fund (NEBF), Maryland.

Duration : Nov 2017 – Mar 2022

Role : Sr. PL/SQL Developer

Responsibilities:

Worked closely with Project Team, SME and Internal Business Partners (IPs) to understand the existing system functionalities and business requirements.

Involved from the beginning of the project to post implementation of full SDLC process.

Involved in all phases of database design, development, Testing, End user Training and support.

Created oracle database objects like Table, Views, synonyms, procedures, functions and packages.

Extensively worked in Tuning procedures, functions and packages to improve performance of the application.

Involved in Unit and parallel testing with existing system.

Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.

Data Migration from Traditional database to Oracle database.

Converting legacy programs like COBOL, DB2 programs into Oracle stored procedures.

Generating AWR reports and reading AWR reports and ADDM and ASH reports.

Designed SSRS Reports to replace existing Reports.

Environment: Oracle 12c, SQL, PLSQL, PL SQL developer, Toad, SSRS, UNIX.

Title : Material Tracking System

Type : Application Development and Enhancement.

Client : Arab Tech Constructions, Chennai, India (CSC)

Duration : Jan 2015 – Nov 2015.

Role : Sr. PL/SQL Developer

Responsibilities:

Oracle Forms Developer, designed forms of Custom screens and Modifying Existing forms.

Oracle BI Publisher, Custom Reports designed using this tool.

Oracle PL/SQL Developer, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Requirement Analysis, Designing, Development.

Designing new tables using Normalization.

Developing Stored Procedures, Triggers, Functions and Packages.

Involved in Tuning Existing Queries, Views, Packages.

Used SQL*Loader to load the flat file data to Oracle Tables.

Extensively worked in Tuning procedures, functions and packages to improve performance of the application.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Oracle performance related features such as Query Optimizer, Execution Plan and Indexes.

Involved in Oracle SQL Query Tuning and Procedures and Functions and Packages Tuning.

Preparing SOW and updating the modifications in the procedures, packages and database.

Involved in Performance Tuning for existing procedures, functions to improve the query performance.

Environment: Oracle 11g, SQL, PLSQL, Oracle Forms and Reports, Shell script, Toad, SVN.

Title : Loyalty Program (Skywards)

Type : Application Development and Enhancement.

Client : Emirates Airlines, Dubai

Duration : Dec 2012 - Dec 2014.

Role : Sr. PL/SQL Developer

Loyalty program also called as Skywards. Every time skywards members fly with Emirates, they will earn Skywards Miles, even on a special fare. In addition, unique Miles Accelerator feature can help to find flights that give bonus Skywards Miles, especially if skywards can be flexible with member’s travel dates and timings. The Skywards Miles earn when flying Emirates are calculated using four basic inputs: route, fare type, class and tier.

Responsibilities:

Production Support for different clients like JET Airways, Aero Mexico, Philippines Airlines etc.

Loading new member details, Cancellation details from flat file to oracle tables using SQL Loader and generating acknowledgement for that.

Loading the Skywards Miles, fare details from flat files to the respective tables.

Maintaining Family member details like family head and family members. Based on Percentage definition travelled member/family member points may change.

Calculating the points based on the miles travelled. Maintaining the member levels based on points earned.

Designing different types of report to generate the acknowledgement for data loading.

Generating the report to the client about the member travelled in different airlines other than the member registered.

Writing backend procedures to populate details in the front-end screens.

Scheduling jobs like daily/monthly/yearly.

Preparing SOW and updating the modifications in the procedures, packages and database.

Involved in all phases of database design, development, Testing, End user Training and support.

Production Support for Clarity Tool (Resource, Project, Timesheet), Added new features in the existing functionality.

Involved in Performance Tuning for existing procedures, functions to improve the query performance.

Involved in query tuning, database performance tuning. Used different techniques like Explain plan, TKPROF.

Environment: Oracle, PL/SQL, TOAD, SVN, .Net, UNIX

Title : Resource Planning Management (RPM)

Type : Application Development and Enhancement.

Client : Kaiser Permanente, Chennai, India (CSC)

Duration : Sep 2008 – Nov 2012.

Role : PL/SQL Developer

CA Technologies’ software helps with many business functions like task management and scheduling, however, CA Clarity PPM goes further than most to ensure maximum efficiency and productivity. CA Open Workbench is a Windows-based application for designed for offline use. Kaiser using this Clarity tool to keep Resource information and their project assignments and tracking hours against daily tasks.

Responsibilities:

Understanding the existing system and providing support for the users.

Adding new functionalities and features in the existing system.

Providing support for the Clarity users by Interacting with CA Technical team.

Preparing SOW for the new changes and updating the changes in existing database objects like Table structure, procedures, functions and packages.

Involved in all phases of database design, development, Testing, End user Training and support.

Created oracle database objects like Table, Views, synonyms, procedures, functions and packages.

Extensively worked in Tuning procedures, functions and packages to improve performance of the application.

Creating queries for the Ad-hoc reports.

Environment: Oracle 11g, SQL, PLSQL, PL SQL developer, Toad.

Title : Human Resource Direct Service system

Type : Application Development and Enhancement.

Client : Emirates Airlines, Dubai (CSC).

Duration : Dec 2006 – Apr 2009.

Role : Sr. PL/SQL Developer, Forms & Reports Developer

Appreciation and warning module is one of the HR Direct Self Service initiations that will be developed to cater to growing number of employees in the company and to provide better service to the work group. Current manual process of issuing and capturing appreciation and warning details has many short coming. Mainly there is no standard template followed for issuing of warning and many a times the details do not get updated into HRMS.

Responsibilities:

Involved in Developing Oracle Apps Forms and Reports.

Adding Oracle forms and Reports in Existing Oracle Apps Menu and Developed few Crystal Reports.

Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.

Designed new forms for warning and appreciation Module.

Preparing SOW and updating the modifications in the procedures, packages and database.

Involved in all phases of database design, development, Testing, End user Training and support.

Involved in Performance Tuning for existing procedures, functions to improve the query performance.

Warning module will have different warning category like verbal/written warning.

Appreciation module will have different types of appreciation.

Extensively worked in Tuning procedures, functions and packages to improve performance of the application.

SQL*Loader to load flat file data to Oracle Tables.

Designed Forms and Reports for Time monitor (Attendance) system.

Designed Reports to show Tardy and Overtime Reports based on shift timings entered in the database.

Developed procedures to send mail to immediate reporting supervisor.

Developed memo based on daily Roaster attendance data.

Used different techniques to improve query performance like creating index based on the requirements.

Environment: Oracle EBS, SQL, PL/SQL, Oracle Forms & Reports, UNIX.

Title : Product Automation

Type : Application Development and Enhancement.

Client : British Telecom Communication, UK (Tech Mahindra Pune India).

Duration : Jan 2006 to Dec 2006.

Role : PL/SQL Developer, Forms & Reports Developer

Responsibilities:

Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.

Loading flat file data to corresponding oracle database tables.

Developed procedures, Functions, and Packages for analyzing the E2E activities like number of enquiries, fault complaints, resolved complaints, in progress and repeating same complaints for different type of connection ex. PSTN.

Calculating the percentages based on the number of fault calls and resolved calls.

Developed SQL report and Dashboard to show all the above details.

Used External table to do calculation outside database to improve performance.

Extensively worked in Tuning procedures, functions and packages to improve performance of the application.

Created many reports using Crystal Reports for display the different products enquiry and show the product wise issues reported and resolved details.

Environment: Oracle, PL/SQL, Java

Type : Application Development, Enhancement and Support

Client : LuK India Pvt Ltd, Bangalore, India

Duration : Jan 2001 to Jan 2006.

Software/Technology : SQL, PL/SQL, Oracle Forms & Reports.

Role : PL/SQL Developer, Forms & Reports Developer

Route Sheet Preparation:

Responsibilities:

Designed front end form to enter the link between main product and sub products/items and quantity.

Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.

Developed Report to show the main product and sub products/items.

Tool History:

Responsibilities:

Designed front end form to enter the link between machine and component.

Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.

Developed Report to show machine and corresponding component list.

Designed front end form contains types of projects, types of components details.

Automatic tool number creation for new tools to corresponding projects.

Linking the component with corresponding tool, Linking the main tool with its child tool according to change over parts, New tool status i.e. design level, manufacturing level or in use, Generating the complete report of the tool.

Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.

Capacity plan:

Responsibilities:

Worked as Business Analyst. Involved in requirement gathering, design, development, product delivery and user Training.

Designed front end form to enter the link between machine and component and capacity of machine produce the component.

Designed front end to enter the BOM (Bill of Material).

Designed report to show capacity of the machine based on the above 2 table details.

Designed the report to show required manpower and time to produce the product.

Developed the final report for forecasting future month requirement.

Payroll Preparation: Responsibilities:

Designed front end form to enter employee personal details, Salary, Loan, saving and attendance

details.

Developed procedures and functions to generate monthly pay slip based on the above table details.

Designed report to show the employee with corresponding departments.

Designed different types of reports PF, ESI and Canteen deductions and Generating Form16, Form24, Form3A, ESI statement, PF statement, Loan statement.

Inventory System: Responsibilities:

Designed front end forms to enter store materials (component list), stock, Goods received (GRN),

Goods Quality Check (GRIN), Material issue receipt (MIR), purchase order, Gate pass details.

Developed reports to show the details of stock in hand, required component based on the capacity plan for next month.

Developed procedures and functions to update the stock based on the Goods quality check pass, Material issue receipt.

Developed report for the Sales order, Gate pass, Purchase order.

Developed financial reports based on Payment order, Sales order.

Environment: Oracle, PL/SQL, Open VMS, Oracle Forms and Reports. Education

●Master of Computer Application (1996-1999) from University of Madras.

●Bachelor of Science (1993-1996) from University of Madras.

Contact this candidate