Sankar.M
[email protected] +60186651756 Career Summary Solutions focused, meticulous result oriented B. Tech (Information Technology) professional offering 5.4 years of experience in IT (Software) arena; Persuasive communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management; highly ethical, trustworthy and discreet; · Demonstrated excellence in tackling the issues of IT (Software) arena and other related lines · Proactive approach in initializing and accomplishing the tasks · Adept at working in high-pressure environments with strict deadlines and multiple deliverables · Sound communication skills through patient and persistent dialogue; Disciplined, versatile and big picture thinker; Technical Skills · Technical skills include PL/SQL, SQL. · Date Base: Oracle 8i/9i/10g/11g. · Tools: Oracle Forms/Reports (6i, 10g, 11g), SQL navigator, PLSQL Developer, TOAD, Golden32. Certification · OCA10g (Oracle Certified Associate (SQL, PL/SQL)). · OCP10g (Oracle Certified Professional (Forms & Reports). Education · BTECH Information Technology in Cape Institute of Technology Levengipuram with 71% Year 2009 · 12th, TamilNadu state Board SMRV.Hr.Sec.School, Vadasery with 69%. Year 2003 · 10th, TamilNadu State Board SMRV.Hr.Sec.School, Vadasery with 86% .Year 2004 Academic Experience · Undergone 6month Certification Training on SQL, PL/SQL and FORMS & REPORTS from JUNE 2010 to NOV 2010 in SQL STAR INTERNATIONAL, Chennai. Working Experience · Currently working as Oracle Developer in Talent2 HRO Sdn Bhd, Malaysia. Oct 2014 To Present. · Worked as Analyst Programmer in Aetins Sdn Bhd, Malaysia. Oct 2011 To May 2014. · Worked as Junior Programmer in Information Dynamics India Pvt Ltd, Chennai. Nov 2010 To Sep 2011. · Worked as Trainee Programmer in Antza Technologies, Chennai. March 2009 to April 2010. Project Details Talent2 HRO Sdn Bhd, Malaysia. Oct 2014 to Present PROJECT: 1 ALESCO Talent2 is basically Human Resource Management System provider offers a single end-to-end HRMS Solution. Roles & Responsibilities: · Developing most of the complex Mod PLSQL code using Oracle10g Relase2 and Java Script. · Modifying existing Forms with the New additional requirements from Users for support issues. · Debugging and fixing the bugs in existing Forms. · Developing New Forms for generating new Text , CSV and Excel Files. · Developing New Forms for reading data from Text ,CSV and Excel Files. · Developing complex ETL scripts (PL/SQL) · Performance tuning of PL/SQL programs (Oracle 10g) · Developing Object Types, ref cursors, packages, PL/SQL tables. · Developing and modifying the reports · Hands of experience to lead the people. · Attending client meetings and gathering requirements from clients · Developing Solution Design and Functional Specification Document based on the requirements gathered from client and developing the application based on the approved requirements. Client/industry: â CSC, British Council Malaysia, Symantec, Verizon and Timberland Aetins Sdn Bhd, Malaysia. Oct 2011 to May 2014 PROJECT: 2 ISF (Insurance Solution Framework) AETINS is basically Insurance Software Solutions provider offers a single end-to-end Insurance Solution that covers all lines of business: Individual Life, Group Life, Investment Linked and General. It spans across functions like illustration, quotation, new business, policy servicing, claims, agency management, commission and benefits, accounting and services. Roles & Responsibilities: · Developing most of the complex Multi Window Forms in Insurance Finance domain based on Customer Requirement. · Developing online SL-GL checking tool in PLSQL coding using Object Types, ref cursors, packages, PL/SQL tables. · Developing and maintaining Automated Credit card bill generation tool using Forms and PLSQL. · Developed Auto credit option in payments for HLA,MZ,HLTMT using Forms & PLSQL. · Modifying existing Forms with the New additional requirements from Users for support issues. · Debugging and fixing the bugs in existing Forms. · Developing New Forms for generating new Text , CSV and Excel Files. · Developing New Forms for reading data from Text ,CSV and Excel Files. · Developing complex ETL scripts (PL/SQL) · Performance tuning of PL/SQL programs (Oracle 10g) · Developing and modifying the reports · Hands of experience to lead the people. · Attending client meetings and gathering requirements from clients · Handled SL-GL issues. · Worked Account Receivables, Account Payables, Payment Control Accounts and Premium realization account holding · Worked on Electronic/Auto payment system to create file and handled through application · Doing onsite support for customers like MCIS Zurich , HLA Etc, handling customer live and dumb data through web-ex, VNC , VPN and remote desktop connections. Client/industry: MCIS ZURICH , HONG LEONG ASSURANCE BERHAD â INSURANCE Information Dynamics India Pvt Ltd, Chennai. Nov 2010 to Sep 2011 Project: 3 Afsys Plus(Agent Freight Forwarding System) AFSYS+ is an Integrated System, which provides complete solutions for shipping liner agents. It integrates the process of line agents with, terminals/depots for handling container movements. Yang Ming Agents across different countries access this system by having centralized database at Yang Ming HQ office in Keelung, Taiwan. System covers all-important processes of shipping industry spread into number of modules such as Customer Management System, Quotation. Cargo booking, Export documentation, Import/Transhipment documentation, Equipment Control system (containers), Logistics, Accounting (AR & AP) and work order. Each module is designed to provide the whole working process of the corresponding department. As this is centralized database, the securities of different locations data are maintained effectively. Functions for granting/revoking access for other locations provided. Roles & Responsibilities: · Developed New Forms based on Customer Requirement. · Modified existing Forms with the New additional requirements for support issues. · Debugged and fixed the bugs in existing Forms. · Developed New Forms for generating new Text , CSV and Excel Files. · Developed New Forms for reading data from Text ,CSV and Excel Files. · Developed various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder, and Application Object Library. · Create extensions using Oracle recommended frameworks. Report against Applications data model. · Possess experience in Migrating Oracle database from 8i to 10g/11G. · Coded, tested, debugged, documented, and maintained programs. · Created detailed project outlines, application design specifications, and test plans. Client/industry: YANG MING LINE (SHIPPING AND LOGISTICS) Project: 4 SRM (Specification And Resource Management System) The SRM system is workflow system to handle various activities of a Software project with reference to Customer requests like New requirements, Bugs in the existing programs, Changes/enhancements, Data Problem, Clarifications, Document Preparation, Performance Tuning, etc. In each customer request to create a specification and automatically work assigns to the idle developers. Each specification of the program source move automatically to the developers work area and return from work area to source. In our system maintaining In, Out time and Working, Idle hours calculated for each user. System sending various auto mails such as Developers activities, reminder of customer delivery schedule date and user idle list. Roles & Responsibilities: · Developed New Forms based on Customer Requirement. · Modified existing Forms with the New additional requirements for support issues. · Debugged and fixed the bugs in existing Forms. · Developed New Forms for generating new Text , CSV and Excel Files. · Developed New Forms for reading data from Text ,CSV and Excel Files. · Developed various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder, and Application Object Library. · Create extensions using Oracle recommended frameworks. Report against Applications data model. · Possess experience in Migrating Oracle database from 8i to 10g/11G. · Coded, tested, debugged, documented, and maintained programs. · Created detailed project outlines, application design specifications, and test plans. Antza Technologies, Chennai March 2009 to April 2010 Role and Responsibilities · In-depth knowledge of PL/SQL with the experience in constructing the triggers, tables, collections, functions, user defined data type, procedures etc. · Modified, maintained and developed the SQL codes to develop new enhancements. · Exceptionally good and experienced in handling the problem and troubleshooting. · Excellent organizational and presentation skills. Personal Details Passport No : H1261720 DOB : 11/05/1988 Marital Status : Married Sex : Male Languages known : English, Tamil and Malayalam Permanent Address : 18/12A, Ravivarman New Street, Vadasery, Nagercoil, Kanyakumari Dist, Pin-629001, Tamil Nadu, INDIA. Temporary Address : Block A-3-1, Sri Manja Court, Jalan Sri Manja, Petaling Jaya, Selangor, Malaysia. Declaration I hereby declare that above mentioned information is correct to the best of my knowledge and I bear the responsibility for the correctness of above-mentioned particulars. Place: Signature Date : Sankar.M Page 4 of 4