Name: 12345
Email : 12345
Mobile : 12345
EXPERIENCE SUMMARY
v Having 3.5 years of Progressive and Dynamic experience in software analysis, design, development, testing and implementation of full life cycle web based software applications.
v Strong skills include Oracle 10g/11g, SQL, and PL/SQL in Unix Environment.
v Experience working in 24/7 Production Support.
v 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.
v Experience in developing External Tables, Joins, Indexes and Sequences.
v Experience in Query optimization, Performance tuning (PL/SQL) using Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, creation of Global Temporary Tables.
v Rich experience in writing SQL queries, Views, Materialized Views, PL/SQL Procedures, Functions, Packages, Triggers, Cursors and Ref Cursor.
v Extreme Use of Exception Handling methods along with Pragma Exception_Init in order to associate our own created exception names.
v Expertise in loading data from legacy systems using SQL*Loader.
v Experience in using several built-in database packages such as DBMS_JOB, UTL_FILE, and DBMS_SQL to name a few.
v Worked extensively in several projects in both OLAP and OLTP applications.
v Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.
v Bulk data Collecting of huge data with use of PLSQL collections and Records.
JOB PROFILE:
Working as a Software Engineer with bcd Chennai from July 2012 to till date.
ACADEMIC PROFILE:
B.E., (COMPUTER SCIENCE& ENGINEERING) 2012 FROM SARANATHAN COLLEGE OF ENGINEERING & TECHNOLOGY, TRICHY.
TECHNICAL SKILL:
v Languages : Oracle SQL, PL/SQL, Unix Shell Script
v Tools : Toad 9.2, SQL*PLUS,PL/SQL Developer Tool
v Operating Systems : Windows FAMILY,Unix
v Databases : Oracle 9i,10g,11g,
WORK EXPERIENCE:
Project #1:
Title : Credit Card Banking System.
Environment : Oracle 10g, SQL PLUS, TOAD 9.6.
Client : DBS Bank, Singapore
Roles & Responsibilities:
Ø Change and creation of new PL/SQL packages and procedure as per business requirement.
Ø Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures
Ø Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQL and import items program.
Ø Involved in development of shell scripts to send invoices to customer through mailing.
Ø Developed various reports ‘Customer Statement of Account’, ‘Core Debit memo’ and AR Invoice Report.
Ø Extensively used for all and bulk collect to fetch large volumes of data from table.
Ø Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
Ø Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
Ø Designed and developed various custom packages triggers and forms.
Ø Review and Analysis of Business Requirement.
Ø Debugging and deployment of coding and testing.
Ø Resolving issues and providing inputs for performance improvement.
Project #2:
Title : Pearl Life-Customization.
Client : CFF Bank, Canada.
Environment : Oracle 10g, PL/SQL, SQL PLUS, SQL Developer.
Roles & Responsibilities:
Ø Created Procedures, Triggers, Functions and Packages.
Ø Understanding the requirements and carrying out impact analysis.
Ø Prepared root cause analysis for problems occurred
Ø Code Walk Through, Review and Testing.
Ø Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
Ø Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures
Ø Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQL and import items program.
Ø Data loaded using PL/SQL and SQL*Loader.
Ø Supporting DIT, SIT and UAT Testing.
Ø Involved in resolving production problems for the applications and Ensure all support service level agreements are met.
PERSONAL PROFILE
Fathers Name : Chandran.
Date of Birth : 23-May-1990.
Marital Status : Single.
DECLARATION
I hereby declare that all the statements made above are true to the best of my knowledge and belief.
Date :
Place : Chennai (12345)