Professional Experience

Confidential

Role: Oracle Developer

Responsibilities:

• Understanding the Business and Technical Requirements from the client.
• Converted the flat files data in Oracle staging tables using SQL Loader.
• Creating Procedures and Packages to extract data and load it in the target base tables.
• Creating Test cases for validation checks.
• Understanding the Business and Technical Requirements from the client.
• Designing, Modifying design of database tables, keys, indexes, grants, triggers, packages, procedures and functions.
• Creating and modifying database objects.
• Developing and modifying Oracle Developer 10g Forms and Reports.
• Developing and modifying PL/SQL Packages, Functions and Procedures.
• Testing and Debugging keeping performance aspect in mind.
• Query optimization and troubleshooting.
• This was a Conversion project to integrate the BellSouth's systems to AT T system after their acquisition.
• The data of all the modules were required to be archived as flat files which would be then stored in the main frames servers.

Confidential

Software: Oracle 10g/9i, PL/SQL, SQL, Forms 10g/6i, Reports 10g/6i, TOAD

Role: Oracle Developer

• Confidential is a cost effective information system that combines proven commercial best practices with support for the unique challenges of the independent aircraft heavy maintenance and modification, complex assembly MRO and component repair industry segments.
• The system enables operational efficiency by integrating, automating and streamlining all aspects of heavy maintenance as well as assembly and component repair.
• The modules include Planning Scheduling, Maintenance Execution, Maintenance Engineering, Supply Chain Management and Performance Reporting Analytics.

Responsibilities:

• Writing Stored Procedures, user defined functions, views for implementing complex business logic in PL/SQL.
• Creating data entry forms using Oracle Forms.
• Creating and customizing analytical reports using Oracle Reports.
• Tuning of SQL queries using EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Involved in overall trouble shooting and support.
• Responsible for writing Triggers.
• Analyzing the problems and resolving the same.
• Involved in Design review and code review.
• Providing support, maintenance, enhancement and modification of the system.
• Confidential

Software: Oracle 9i, PL/SQL, SQL, Forms 6i, Reports 6i, TOAD, SQL Loader

Role: Oracle Developer

This System consists of 5 Operational Modules, Accounts, Students, Articles, Members and Firms. I was responsible for handling the entire Students Module and got promoted as a Module Leader.

Responsibilities:

• Creating Database Objects and Indexes.
• Writing Stored Procedures, Functions and Triggers keeping the performance aspect in mind.
• Overall trouble shooting and support.
• Creating stored procedures, functions and views to implement various levels of data security and on going maintenance of the database.
• Generating Triggers to enforce data integrity and consistency in maintaining business rules.
• Analyzing problems and resolving the same.
• Conducting design review and program review.
• Creating reports with validations using Reports.
• Providing continuous support and resolving queries raised by the end users in all locations.
• Providing maintenance and modification of system.
• Resolving issues with the team and coordinating with my team.
• Preparing checklists for different tasks, reviews of PS UTC.
• Logging of defects and CR, analyzing and fixing them.
• Involved in data migration using SQL Loader flat files to Oracle tables .
• Implementing the Module at client side and imparting training to the end users at the Regional offices in Chennai, Mumbai, Delhi, Kolkata and Kanpur.

Confidential

Software: Oracle 9i, PL/SQL, SQL, Forms 6i, Reports 6i, TOAD, SQL Loader

Role: Oracle Developer/Consultant

• The above Project is an Integrated System developed in Oracle and Developer 2000, by customizing the standard ERP Product named ORION of 'ICICI InfoTech Ltd.', where by the Institute is allowed to store all the data and information of each and every student who comes for registration, till he becomes the member of the institute and hold a firm authorized by the institute. Students all over from India, come under the roof of ICAI to be a Chartered Accountant. On completion of the respective PE-1 and PE-2 exam they are entitled to carry out Article ship practice. On successful completion of the Article ship and after passing the Final CA Exam the student becomes a Chartered Accountant, and he is entitled to become a member of the institute by paying the membership fees. Once he becomes a member he can establish his own firm on his name or be a member in the reputed firm on approval of the ICAI institute.
• This System consists of 5 Operational Modules, Accounts, Students, Articles, Members and Firms.
• Along with these modules, standard modules of an ERP System like Purchase, Sales Inventory and Payroll are also included in this product

Responsibilities:

• Designing and developing entry forms and transaction forms in Oracle Forms 6i.
• Designing and developing Reports in Oracle Reports 6i
• Writing Procedures, Functions, Packages and Triggers
• Continuous debugging and overall support
• Handling UAT and giving user training and demo to the end users.
• Implementing the system at client side and imparting training to the end users at the Regional office in Chennai
• Later on judging my capability and performance I got hired by 3i InfoTech Ltd in March 2005.

Confidential

Software: Oracle 9i/8i, PL/SQL, SQL, Forms 6i, Reports 6i, TOAD

Role: Software Engineer

• The above product is an ERP developed for Sunrise Containers Ltd. It is an automated solution for various departments like Accounts, Production, Purchase, Sales etc.
• The main modules covered in this project are Accounts, Sales, Purchase, Stores, Job Work, Production, Exports, MIS, Fixed Assets, Payroll and Common Masters.
• Out of the above modules I have worked on Sales, Purchase, Production and Common Masters.

Responsibilities:

• Designing and developing entry forms and transaction forms in Forms 6i.
• Writing validations
• Preparing Reports
• Writing Procedures, Functions, Packages and Triggers

Confidential

Software: Oracle 8i/7, PL/SQL, SQL, Forms 6i/4.5, Reports 6i/4.5, TOAD, HTML

Role: Programmer

• The above project is an In house product developed for Thermax Ltd.
• This System consists of Financial Modules like Bank, Cash, Purchase, Sales, Journal Voucher, Accounts Receivables and Accounts Payable.

Responsibilities:

• Designing and developing entry forms and transaction forms in Forms 6i.
• Writing Packages, Stored Procedures, Functions and Triggers.
• Creating reports using Reports 6i.
• Providing continuous user support and resolving queries raised by the end users in all the 12 divisions at all the Regional locations.
• Created conversion of forms from Forms 4.5 to Forms 6i.
• Have done a lot of debugging and resolved the same for the problems involved in conversion of Forms.
• Developed many static as well as dynamic HTML pages through code for Information portal.

Confidential

Software: Oracle 8i, PL/SQL, SQL, Forms 6i, Reports 6i, TOAD

Role: Programmer

PRISM Procurement Resource Information System Management is an In house product developed for Thermax Ltd.

Responsibilities:

• Designing and developing forms in Forms 6i.
• Writing complex queries in SQL and spooling the output to files.
• Designing and developing reports to meet the business processes.
• Writing Stored Procedures and Triggers.
• Implementing the system and imparting training to the users.
• Assisting the users in data entry operations and solving queries raised by them.
• Providing maintenance and enhancement to the system.
• Responsible for creating users and giving them grants and privileges on the system.

Confidential

Software: Oracle 8i, PL/SQL, SQL, Visual Basic 6.0

Role: Programmer

• This is an In house product developed for the Engineering department of Thermax Ltd.
• This System generates a unique drawing number depending upon the category of drawing along with the job type and paper size. Earlier this was done manually.
• This System was developed in Visual Basic 6.0.

Responsibilities:

• Interacting with the Business users to understand requirements.
• Creating the requirement specification documents.
• Creating the data flow diagrams.
• Analysis of the Specification document and creating design document for the same.
• Designing the database along with the team and UI design as per design documents.
• Writing Validations, procedures, functions and triggers.
• Developed entry forms in Visual Basic 6.0.
• Designed and developed reports using data reports.
• Successfully conducting the UAT and getting sign-off.
• Responsible for testing and implementations of the system.
• Conducting demos of the system and training the users.