10th January 2008 onwards, NIIT Technologies Ltd.
Designation: Senior system engineer
Platforms: Oracle 9i, PL/ SQL, D2k

Responsibility
Requirement Analysis, Documentation, Designing, Development, Tuning of Database objects (Table, Index, Function, Procedure, Trigger, Package), writing technical and functional documents & helping other team member Technically, functionally, logically and deliver quality output to client
Title : Toyota Business Reform(Kaizen) In a group of 7
Client: : Toyota Motor (Thailand)
Duration : August 2008 to 31st Jan 2009
Role in the project : R/ A, Designing, Documentation, Development(Leading), IFT, Unit testing & Closers using Oracle and Developer 2000
Modules : Pre-Allocation, Product hierarchy, Switching, BTO

Highlights

Did Requirement Analysis for all four modules in Thailand (Onsite)
Developed database objects on oracle (Function, Procedure, Index, view Trigger, Package)
Developed forms using developer 2000
Developed Complex batches(Package)
Proper indexing of tables using various types of indexes.
SQL query optimization using Hints and utilities like Explain Plan.
Unit testing done for all code developed
Assist team member functionally and technically whenever required
Wrote HLD(High Level Design) Document for all modules
Wrote LLD (Low Level Design) Document for all Modules
Wrote IFT (Integrated Functional Test) Document for all modules
Wrote BCT(Business Component Test) Document for all Modules
Created sample data for IFT & BCT
Also worked as QM for the Project(code and S&G)
Communicate progress and problems appropriately to project management
Implemented the project successfully in Thailand (Onsite)

Title : Regional export order management In a group of 22
Client: : Toyota Motor (Thailand)
Duration : February 2008 to July 2008
Role in the project : R/ A, Designing, Documentation, Development, Unit testing & Closers
Highlights
Developed database objects on oracle (Function, Procedure, Index, view Trigger, Package)
Developed Complex batches(Package) for client
Proper indexing of tables using various types of indexes.
SQL query optimization using Hints and utilities like Explain Plan
Unit test for all code developed
Provide technical Support to other team member
Documenting each phase of development (HLD, LLD, PT, IFT, BCT)
Communicated progress and problems appropriately to project management

17th April 2006 to 8th January 2008, Qualtech Consultants (P) Ltd.

Designation: Engineer Analyst
Platforms: Oracle 9i, PL/ SQL

Responsibility
Analysis, Designing, Development, Tuning & Controlling the promotion of Database objects (Table, Index, Function, Procedure, Trigger, Package) and Crystal reports
Maintaining status of work for the reports and documents teams and Communicate TL and Project Manager on the same

Title : Tech Support on database(Oracle, PL/ SQL ) &Crystal Reports In a group of Five
Client: : Max New York Life
Duration : November 2006 to January 2008
Role in the project : Analysis, Designing and Coding, Unit testing & implementation
Highlights
Developing database objects on oracle (Function, Procedure, Index, view, Materialize view, Trigger, Package) to meet user requirements
Database design with proper future plan (setting pctfree, pctused, initrans, maxtrans).
Proper indexing of tables using various types of indexes.
Implemented IOT for better performance.
Extensively used PL/ SQL blocks Collection, Procedures, Functions, Packages and Triggers.
SQL query optimization using Hints and utilities like Explain Plan, Auto Trace.
Rewritten the query to improve the performance.
Performance tuning of PL/ SQL blocks.
Worked on PL/ SQL reporting.
Used Toad 8. 5 and PLSQL Developer 7. 0. 3 for development and debugging the database.
Unit test for all code developed
Providing technical Support to user
Analysis of logic incorporated with the report and business logic if any mismatch found rectify them
Analysis of production data if user got wrong output
Analysis of root cause if any problem arise during execution of any database object
Communicate progress and problems appropriately to management & user

Title : De normalization of database (Oracle, PL/ SQL ) In a group of Five
Client: : Max New York Life
Duration : Six Month(May 2006 to October 2006)
Role in the project : Analysis, Designing and Coding

Highlights:
De normalize database back to first normal forms
Reports table are created to make faster execution of very complex report
Materialize view used where needed
Incremental script for data refresh
Data mart used to reduce calculation time of complex report