Software Developer Data
Resume:
JOHN BASTIN VEDAMUTHU **************@*****.***
PROFESSIONAL SUMMARY:
Having 3+ years of Experience in Analysis, Development, and Production Support Environment
Created Oracle Tables, Views, Constraints, Synonyms, Sequences, and Index Like
(B Tree, Bitmap and Function Based) to optimize the queries for minimum impact on database performance
Having Strong knowledge in Joins, View and M-view, Pseudocolumn
Experience in Retrieving data from External data Files and loaded into oracle database using tools like SQL*Loader and External Table files, UTL_FILE based on file formats.
Good Knowledge in writing Procedure, Functions, Packages, Triggers and using the latest features to optimize performance like Inline views and Global Temporary Tables
Work experience in Cursors, Collections, Ref cursor, Cursor Variables, System Reference cursor, Dynamic SQL.
Having knowledge in Bulk Collections for better Performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
Handled errors using Exception Handling extensively to debugging and displaying the error messages in the application
Ability to work individually as well as in a team with Excellent Problem solving and troubleshooting capabilities. Ability to Interact with People at all Levels.
TECHNICAL SKILLS
Operating System : Windows
Language : SQL, PLSQL, UNIX BASIC
Database : Oracle 10g / 11g
Oracle Developer Tool : SQL*PLUS, SQL DEVELOPER,
PL/SQL DEVELOPER
Ticket Tracking : SERVICE NOW
Version Control : SVN
Job Scheduling Tool : UC4 AUTOMIC
Reporting Tool : COGNOS
EDUCATIONAL QUALIFICATION
B. Tech (Mechanical Engineering) from SRM University, Chennai (2012-2016)
PROFESSIONAL EXPERIENCE
Worked at Thincle Soft Technologies Chennai, as Software Developer from December 2016 - till Now.
Project Details : Online Trading & Stock Exchange
Project Name : Halifax
Client Name : Lloyds Banking Group, UK
Role : Software Developer
Description
This project is designed and developed for Investment platforms in order to provide online stock brokerage services. Performed design and development of Web application using Java technologies, design patterns and Oracle database. We can check the trading limit, we can track the order and trade across borders through buy and sell shares. Having the right type of financing in place, with the right financial provider, The product includes extensive spanning Equity, Mutual fund, Insurance and derivatives trading .
Responsibilities
Working in Derivatives and Equity Module
Involved in Software Development Life Cycle SDLC.
Coordinating with Onshore People, understanding the Business need and preparing FSD and getting it signed off.
Preparing Impact analysis, Unit Test Case(UTC), SVN Documentation
Worked on Trigger as per business requirements for Auditing and Validation.
Created Materialized Views and Views where business requirements needed.
Experienced in SQL Joins and Sub queries.
Managed Performance and Tuning of SQL queries and Fixed the slow running Queries in production with Utilities like Explain plan
Developed SQL*Loader and External Table scripts to load data in the custom table.
Continuous Monitoring of the Alerts Received Through Emails to check if all application servers and web servers are up
Handled the Performance and Tuning by using Creating Indexes, Hints, Bulk Collect, Bulk Bind and Table Partitions to Maintain Historical Data.
Analysis and troubleshooting incidents raised by end-users within agreed time frame
Declaration
I hereby declare that all the statements made above are true to the best of my knowledge and belief.
Place: Chennai
Date: ( JOHN BASTIN V )
Contact this candidate