Overview

• Around 8 Years of Experience as an Oracle PL/SQL Developer with Proficiency in Oracle 11g/10g/9i/8i, SQL, Oracle PL/SQL, Oracle Form Builder 10g/9i/6i, Report Builder 10g/9i/6i, C,Java,UNIX Shell Scripting.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 Forms, Reports Oracle Developer Suite 10g and other front-end tools.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Extensive working knowledge in developing Database Triggers, Stored Procedures, Functions for developing Forms and Reports.
• Experience in Performance Tuning Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility TKProf.
• Extensive experience in using Cursors and Ref-cursors for processing of data.
• Good Knowledge on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records and Types.
• Strong programming skills on Oracle SQL, PL/SQL indexes, bulk collects and bulk variables.
• Extensive experience in data migration techniques using Oracle External Tables, SQL Loader, Import/Export, bulk and batch processing.
• Experience in UNIX Shell Scripting.
• Worked with query tools like Toad, SQL Plus, PL/SQL Developer,Sql Developer.
• Enforcing experience in data integrity using integrity constraints and database triggers.
• Expertise in handling errors using Exceptions.
• Experience in creating Materialized Views and DB links.
• Good knowledge on ETL and data integration developing ETL mappings and scripts using Informatica PowerCenter 9.x.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.

Technical Skills

• Databases : Oracle 11g/10g/9i/8i,MS-Access
• Languages : PL /SQL, SQL,C, Java, JSP, HTML, XML,CSS
• Operating Systems : Windows XP/2000/2003/2007/NT, UNIX, Red Hat Linux
• Oracle Tools : SQL developer, TOAD, SQL Loader, SQL Plus, PL/SQL Developer, Oracle Forms and Reports 10g/9i/6i, ireports
• ETL Tools : Informatica Powercenter 9.0

Professional Experience

Confidential

Role : Oracle PL/SQL Developer

Technology Used : Oracle 11g, Windows XP/2003,SQL Developer, Toad, Informatica Powercenter 9.0

Responsibilities :

• Develop other ad hoc queries based on need for OIA/OIM clean up.
• Analysis and generation of mainframe commands to add users to missing mainframe groups as well as analysis of RACF permission sets and reporting of access that users may lose based on the cleanup process.
• Cleanup of data initiative for the mainframe. This involves data ETL of both data from mainframe reports and OIM/OIA data.
• Data analysis to determine discrepancies between the two systems and generation of SQL to correct issues as they are found as well as reporting trends in those discrepancies.
• Develop queries/stored procedures to analyze and correct issues in the Oracle OIM/OIA provisioning system.
• Created and maintained Tables, procedures, and Indexes .
• Tuned PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.
• Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
• Exporting and Importing the data into the database as and when user provided the data and do analysis.

Confidential

Role : Application Developer

Technology Used : DCLink tool, Oracle 10g, Pl/Sql, Windows XP/2003

Responsibilities :

• Designing, developing the enhanced custom Forms and Script workflows according to the Design specification.
• Developing Script work flows, Forms using the DCLink tool according to the Client requirements.
• Analyzing, creating new and modify existing forms.
• Helping Team members in tuning queries and programs and trained them to write well-tuned code.

Confidential

Role : Oracle PL/SQL Developer

• Project 1 : JIRA Issue Tracking System
• JIRA Issue Tracking System will be a web-based application that tracks and resolves issues. The application will have multiple features and capability like data upload, work flow, various reports, dashboards and filters that enable to get data for required criteria. The aim of the system would be to provide status of issue as on time to the teams and management across the various geographies working locations.
• Project 2 : Associate Productivity Tracker
• The Associate Productivity Tracker is used to capture the Time on System of the agents who take calls. The System also handles the attendance and maintains Leave Balance. The system provided multiple benefits to the Organization as well as the agents for their appraisal. It is a dynamic system, which has the capability to add on any number of agents in the future.
• Technology Used : Oracle 10g Forms Reports , SQL,PL/SQL,Windows XP/Linux

Responsibilities :

• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors etc.
• Involved in analysis, system design documentation.
• Created and maintained Tables, views, procedures, functions, packages, DB triggers, and Indexes.
• Successfully manipulated Stored Procedures, Functions, Triggers and Packages using TOAD and SQL Navigator.
• Tuned PL/SQL Packages and PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.
• Extensively involved in data migration.
• Used UTL FILE built-in package to generate files as per the requirement.
• Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
• Implemented Exception handling, Autonomous Transactions, Pragma Exception Init, Locks, used save points, commits rollbacks to maintain Transactional consistency database integrity.
• Wrote complex in-line Views which summarized the business needs to the fullest.
• Involved in Migrating the entire database setup from test environment to production.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL and UNIX utilities.
• Designed Reports that had complex SQL, PL/SQL code and stored procedures using Reports 10g.
• Designed Forms that had complex stored procedures and PL/SQL code using Forms 10g and did some personalizations.
• Involved in the continuous enhancements and fixing of problems.
• Involved in creating Detail Design Documents for the requirements.
• Involved in formulating general methodologies, Naming conventions and Coding standards for various procedures and packages

Confidential

Role : Oracle PL/SQL Developer

• IMIS Integrated Mill wise information system is the ITC - PSPD's in-house software application catering to business requirements of the unit. It has 32 Sub modules categorized according to the business needs. All the below projects are the enhancements of different modules.
• Project 1 : Agri waste Project
• This Aim of this project is the reduction of Global warming effect on the environment by using the Agri waste products as the fuel in the boiler instead of coal for steam generation process. Hence in this contest there are some enhancements in the Utilities daily consumption transactions and reports by the addition of GREEN BOILER.
• Project 2 : Digital Image Capturing
• This project is an enhancement for Raw material Stores system to capture the image of the vehicle when it is getting weighed during Gross, Partial unloading and Tare weighment.
• Project 3 : Weigh Bridge Application for FG in PM6
• New application is developed to capture the weight of the FG material weighed at go down and to calculate the difference in total invoice quantity net weighbridge quantity.
• Project 4 : TWA Team Working Allowance Payroll system
• TWA is to benefit the employee whenever he works with a substitute called Badli provided in place of absentees to makeup the sanctioned strength to manage the shift operations. Having worked with a substitute, the employee will get a team working allowance as agreed upon in the LTA Long Term Agreement .
• Project 5 : MPR Mill Performance Review Costing System
• To meet the expanding business changes all the MPR Packages Procedures are modified to incorporate the new logic's. MPR reports contain the actual performance of the unit vs. budgeted performance. The reports are generally related to production and usage of raw materials, utilities, downtime's and loss.
• Project 6 : PINNACLE Project New Pulp Mill
• A new pulp mill is added to meet the demand for pulp required for new Paper machine PM6 . New pulp Mill includes new chipper house, Super batch digesters and new fibre line washing, screening and bleaching units . Stock preparation is to make the fiber suitable for the production of paper or paperboard. The existing IMIS module is enhanced to incorporate these facilities.
• Project 7 : Private Vouchers
• This project was modified mainly to incorporate the PBU Process Based Unit WISE Master in IMIS, Personnel Information Form modification with linkup of PBUs to generate PBU wise reports- like the current PBU Vacancies, Confirmation dues, monitoring the retirements, joining , transfers , long services awards purpose ,Male / Female Reports for Statutory and other purpose, Campus recruitment, monitor the previous history , to link up the leave master and other purpose like medical reports, Promotions frequency etc.
• Project 8 : Spot Audit Safety System TPM Module
• Spot Audit Safety System TPM Module is a user-friendly system to recommend safety measures for implementation to help the mill management in monitoring the spot audit recommendations.
• Project 9 : Cheque /DD Inward Register Finance Module
• Cheque /DD Inward Register Finance Module is developed mainly to track Cheque or DD inwards available at various departments and receiving at Mill accounts and meeting the statutory needs.
• Project 10: InfoBhadra Technology used : HTML, CSS, Windows.
• Role : Developing and enhancing the Web Pages and updating the monthly reports in the site.
• Infobhadra is an internal Website, which provides the up-to date information of IS Department of ITC Limited-PSPD at Bhadrachalam. The main purpose of this site is to monitor the Monthly report of IT operations by the HOD's it gives the latest news in the department and information of new projects, Service providers etc.

Confidential

• This project developed mainly to monitor the movement of vehicles inside the mill. Each and every vehicle is given one unique number. Based on that number vehicles will enter into the mill by giving details like time of arrival, leaving time, full load/ half/empty, materials coming and going through the various security gates. The system is mainly developed to extend the weighbridge operations to security gates in order to provide better control on the weighment transactions. Module will be capturing the functionality of following operations
• Raw Material, Stores Material Receipts Issues
• Plantation
• Building Materials
• Contractor's materials coming inside factory premises.
• Dispatch of finished Goods from warehouse
• Visitors pass generation for all the visitors.

Responsibilities :

• Designed, developed and enhanced custom Forms and Reports according to the functional specification.
• Analyzed, created new and modified existing forms, reports, scheduled reports, Oracle 6i,PL/SQL, Stored Procedures, Functions, Packages, Triggers etc.
• Did code reviews of other developers and provided suggestions to improve performance
• Wrote high performance queries/programs using Bulk Binds, REF Cursors etc.
• Helped other developers in tuning queries or programs and trained them to write well-tuned code.
• Provided expertise to development managers in design or preparing proof-of-concept testing.
• Converted Forms Reports from 6i to 10g.
• Wrote complicated stored Procedures, Functions, Database Triggers and Packages, Shell Scripts.
• Involved in handling Exceptions through PL/SQL Blocks.
• Created various feeds/downloads, nightly batch jobs and other daily/monthly reports/downloads.
• Developed SQL Loader scripts to load data from flat file to Oracle 10g database tables.
• Tuned batch jobs and other daily/monthly reports/downloads.
• Used Toad for creating and modifying procedures, functions and triggers.
• Developed complex Oracle Forms providing extensive GUI features multi-selects drag and drop, graphical charts, automated system alerts and notifications etc .
• Created Test Plan for QA and implementation plan for Production implementation once the unit test is done.
• Performed SQL performance tuning using Explain plan, Trace utility TKProf.
• Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.
• Maintaining different version of software version control using CVS.
• Providing production support solving Tickets created using the software ElemenTool.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Preparing test plan for QA for testing before moving from PreProd to Production environment.

• Trouble shooting the day to day problems in the areas of Costing, Process Raw materials and Raw material accounting, Security system, Stores, Private vouchers, OptiVISION OTIF .
• Doing month end activities.
• Providing data to corporate auditors and to the users as per their requirement.
• Modifying forms, reports and stored procedures packages, triggers, functions etc to meet the business requirements.