• More than 7 years of experience in all phases of Project & Product development life cycle that includes System Study, Analysis, Design, Development, Integration, Testing, Deployment, Maintenance, Re-Engineering, and Documentation.
• More than 7 Years of extensive experience in Front-End Database Development using Oracle Developer (Oracle Forms 10g, 9i, 6i, 6.0, 4.5 / Reports 10g, 9i, 6i, 6.0, 2.5).
• More than 7 Years of Strong Coding and Designing Experience in Oracle PL/SQL & SQL.
• Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace, v$sqlarea data dictionary & TKPROF utilities and rewriting the poor SQL queries.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Synonyms and Database Link.
• Around 2 years of experience in Oracle Discoverer Administrator and Discoverer Desktop.
• Experience in oracle application server Administration and Configuration.
• Experience in Configure the webutil stub in application server and standalone.
• Experience in Oracle forms and reports migration (4.5 to 6i then 6i to 10g) from client-server (character-based interface) to 3 tier (browser based interface).
• Handled the large no’s (1256) of oracle reports in single hand.
• Experience in using UNIX platform with shell scripting.
• Experience in EDI Development using TEXT_IO, Regular Expressions for ports / banks / customs / partners / yard operators / Terminals.
• Experience in Using SQL*Loader, Forms Data Loader Utilities.
• Experience in manage the oracle AS via enterprise manager.
• Experience in data format conversion using the oracle.sql.* classes to convert to Java native types.
• Experience to use java methods and handled the exception using the java in plsql programs.
• Experience in EXCEL Report and Data Conversion using OLE and Webutil CLIENT_OLE Utility.
• Oracle University Certified as Oracle Certified Professional (OCP) in SQL, PL/SQL, FORMS 9i.
• Extensive experience in developing the technical specifications from business requirements.
• Extensive experience in day-to-day maintenance/on call support using Skype, MSN.

Technical Skills

Database: Oracle 8i, 9i, 10g, Ms Access.

GUI: Oracle Forms10g, 9i, 6i, 6, 4.5, Reports10g, 9i, 6i, 6, 2.5, Oracle Designer.

BI: Oracle Discoverer (Administrator, Desktop) 10, 9.

Tools: SQL Plus, SQL Navigator, TOAD 9, 7.6, SQL Developer, PL/SQL Developer

Operating Systems: Windows NT/2000, Unix (Linux – Debian), Mandriva-Linux, IBM AIX 5L

Scripting Tools: Unix Scripting – sh

Utilities: Webutil, Export/Import, Explain Plan, SQL*Loader, Forms Data Loader

Web / MS Product: HTML / MS Outlook, MS Excel, MS Word, MS Project.

Work Experience

Confidential, Windsor Locks, CT Aug 2008 to current EIS – Engineering Information System Oracle Programmer/Analyst Confidential is among the largest global suppliers of technologically advanced aerospace and industrial products. Their three major businesses are Aircraft Systems (Commercial and Military), Industrial, and Space, Land & Sea. Confidential has been the prime contractor to NASA for the space suit since the Shuttle era began in 1981. A unit of United Technologies, Confidential accounts for more than 10% of United Technologies\' sales.

EIS is an Engineering Information system, its purpose to capture all the relevant information concerning all engineering documentation in one system and to have this information available on on -line for anyone to use. The engineering documentation included in this system. Its includes drawings, specifications, parts lists, engineering reports and engineering changes. The system also tracks all parts and software. The system contain information relevant to these items including revision history, engineering change in process, document use etc. Its validates the every part with government specification and rules. The background process of the system speaks with applications like JDE, Supplier\'s application and new companies application which one is newly own by HS.

Roles and Responsibilities:-

• System Study, analysis, development, unit testing and documentation.
• Migrated the entire system from client-server technology (character-based interface) to 3 tier (browser based interface).
• Created the new character, Web Oracle Forms programs using the tab, stacked canvases, popup menus, webutil, validates the Unique check on a single or multi field. multi row using Kevin D Clarke\'s method also record group method etc..,
• Created the new Oracle Reports like matrix, group etc.. reports using the wizard and manual.
• Involved in Oracle Forms and Reports migration from 4.5 to 6i then 6i to 10g and debugging the migration problem.
• Involved in oracle application server Administration and Configuration.
• Involved in setting up the Forms and Reports Services on standalone 10g App Server.
• Configured the webutil stub in application server and Used the webutil package to extract data into client side excel sheets (client_ole), client side open dialog box, handle the client side file, directory from forms,
• wrote procedures/functions at the back end which are called from the front end forms.
• Created and modified the Stored packages, procedures, functions, triggers, db objects (test environment) like table, views, synonyms etc....
• Created the automatic process using the oracle jobs.
• Involved in report modification to reduce the time of execution and changes the layouts for web(HTML, pdf).
• Involved in data conversion & validation from Access to the Oracle staging using the regular expression functions, text_io package, validates the business rules via user defined package.
• Experienced to design the new matrix reports (without wizard), group reports.
• Experienced to install the oracle AS on IBM AIX and windows 64bit OS.
• Experienced to converts the 32 bit fmb, pll, mmb files to 64 bit for IBM AIX.
• Experienced to manage the oracle AS via enterprise manager.
• Involved in import and export the data from sub system to JDE.
• Provide day-to-day maintenance/supportfor old client server eis system.
• Involved in documentation for new screens.

Environment: ORACLE DB 10g, Oracle Forms and Reports 10g, 6i, 4.5, 2.5, SQL, PL/SQL, TOAD 9, Oracle Application Server 10g, Oracle Enterprise Manager, Java Classes, Oracle Forms Service, Report Service, Webutil, Windows XP/2003, Scripting, IBM AIX 5L 64bit o/s, MS Outlook, MS Excel, MS Word.

Confidential. Iselin, NJ Apr 2007 to Aug 2008 Management Activity Reporting System (MARS) Oracle Programmer/Analyst

Confidential offers medical billing solution to all types of physicians working in a variety of specialties, currently supporting Hospitals and physician offices. Its full-service solution covers the life of the claim, from submission of the claim, to posting payments, balance billing patients and following up with insurance companies. Confidential realizes that the ability of its clients to remotely access the billing data on Confidential system, allows its clients to run its office efficiently and effectively.

MARS is the tracking system that renders hands-on information via Patient, Provider, Insurance, Charge and Payment details of a particular claim. It also tracks and displays the detailed history of a claim. The reporting module of MARS provides various Claim Reports. Data is fed from billing to tracking system on a regular scheduled intervals using custom generated synchronization scripts.

Roles and Responsibilities:-

• Extensively involved in Analysis, Design, Development and Testing and created design documents.
• Involved in creating the oracle forms using the 10g, 9i versions, attach libraries, menus and object libraries.
• Involved in Report design and development using Reports (manually only).
• Created the Stored Procedures, Triggers and Complex Queries.
• Creating indexes on the columns based on the Explain plan, TKPROFand on analyzing the tables.
• Created views on the tables for every reports based on the user requirements.
• Involved in planning and performance tuning related to DB Views, indexes, functions and stored procedures.
• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.
• Provided a client-server reporting solution for dumping data into Excel spreadsheets from Oracle Forms.
• Responsible for developing new reports using Oracle Discoverer.
• Created Business Areas, folders, custom folders, item class, changed the conditions, made the joins, set the security, privileges in Administrator and created workbooks, sheets, graph in desktop.
• Involved in Performance tuning and rewriting the queries using the ANALYZE, DBMS_STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Involved in defining the database Job Schedule programs for routine bases activities using DBMS_JOB and PL/SQL.
• Developed Shell scripts for the execution of the Packages/Procedures.
• Modification of existing Shell scripts.
• Involved in writing and executing scripts for importing data from the billing system to tracking system database.
• Debugging / editing the existing programs.
• Provide day-to-day maintenance/supportfor application software\'s.

Environment: ORACLE db 9I, 10g, SQL, PL/SQL, Developer 10g (Forms and Reports), Discoverer 10, 9, PL/SQL Developer, SQL Navigator, Oracle Application Server 10g, Java Classes, Oracle Enterprise Manager, Oracle Forms Service, Report Service, MS Outlook, MS Excel, MS Word, WEBUTIL, TKPROF, Windows NT/XP/2003, UNIX.

Confidential, Jersey City, NJ Aug 2006 – Mar 2007
AFSYS + (plus) Oracle Programmer/Analyst

Confidential is provide to customers with multiple choices and rapid shipping service, our managing policy includes unceasingly fortifying our strategic alliances with shipping partners like K-line, COSCO and Hanjin, enlarging the shipping service network and increasing calling ports. In addition, through continuously using new information technology, upgrading computer systems, unifying the relevant information, and modifying working process, we provide electronic service to our customers and promote our working quality and quantity as well.

AFSYS PLUS was customized for Young Mine Line Corporation for it’s shipping transactions, It covers all the functionality of shipping such as customer management, booking of containers, release of containers form the port, generating bill of exchange, loading of cargo, export activities, import activities, accounts. 
Features of AFSYS PLUS:

• Container Status and movement.
• Initial default Setup for every fields in every screens based on the users.
• Capability of EDI, XML interface with any third party application like ports/customs/partners/terminals/yard operator/banks etc…
• Multi – language support.
• Its running based on tree concept and image concept.
• Cross Booking – Booking the container form any place andElectronic data exchange for easy communication. Quality control checking according to the condition of the location.
• Various leaves of report for the carrier and line (Oracle and Excel).

Customization of the product is performed for implementation in USA, Germany, China and Netherlands.

Roles and Responsibilities:-

• System Study, analysis, specification creation using SRM tool, assign the job based on the specification, hard development, unit testing and documentation.
• Designed, developed and customized forms by using Oracle Forms 6i and Reports 6i.
• Developing and maintenance the application using SQL/PL-SQL by creating necessary database objects including tables, functions, procedures and packages.
• Responsible for developing new reports using Oracle Discoverer.
• Created Business Areas, folders, custom folders, item class, changed the conditions, made the joins, set the security, privileges in Administrator and created workbooks, sheets, graph in desktop.
• Responsible for modifying & creating Business Areas using Oracle Discoverer Admin for changed & new reports.
• Post-production online Support using MSN.
• Performance tuning business critical processes by re-coding and creating/adding indexes.
• Monitoring DBMS jobs for their success and failures.
• Debugging the online programs using VNC.
• Import the data using SQL*Loader.
• Run the scripts of new oracle objects and modified objects.
• Import / Export the data using TEXT_IO for exchange the data about arrivals and departures International vessels between world agents.
• Involved in migration from Oracle db 9i to 10g.
• Delivery the modified programs usingmail and FTP.
• Creating views for report data model and checking the integrity of Data.

Environment: SQL, PL/SQL, ORACLE 9I/10g, Developer 6i (Forms 6i and Reports 6i), Discoverer 10, 9, TOAD, PRO*C, SRM (Specification Creation and Resource Maintain System), UNIX, Windows NT/XP/2003.

Confidential Mar’ 2004-Jul\' 2006
AFSYS - Agent Forwarding Shipping System Oracle Programmer/Analyst

CONFIDENTIAL is privately owned company, founded in 1970, one of the leading global shipping of the world. CONFIDENTIAL Mediterranean Shipping Company together with Maersk and CMA - CGM, the world\'s three major shipping operators, are reorganizing their respective services between chinaand the US West Coast with the launch of three separate joint services to be introduced in April 2008. CONFIDENTIAL was voted Best Ocean Carrier of the Year for 2007 by the Canadian International Freight Forwarders Association at an awards ceremony in Montreal on 31st May 2007.

The World class product under the flag of AFSYS. AFSYS is a suite of modules designed to provide complete business technology that enables and controls the total work flow in accordance with the business processes of the shipping industry. Core Modules are Documentation, Import, Export, Costing, Capital, Operation, Payroll, EDI (Electronic Data Interchange), CMS, Equipment Control, Auto Email. This solution is used by Carrier Agents, Freight Forwarders, Logistics Companies. AFSYS includes a full-fledged Customer Management system to create, maintain and monitor the business growth with Customers. 
Core benefits:-

• Modularized Integrated System.
• Adaptability to local requirements of any country.
• Invoicing/Receipts.
• User defined auto Email alerts for various exception.
• Auto Calculation of brokerage and rebates payable and receivable.
• Improving Container turnaround.
• Container tracking.
• Single invoice creation for multiple jobs.
• Minimize the vessel turn time…..

Roles and Responsibilities:-

• System Study, analysis, specification creation using tool, assign the job based on the created specification, hard development, unit testing and documentation.
• Developing and maintenance the application using SQL/PL-SQL by creating necessary database objects including tables, functions, procedures and packages.
• Involved in Creating the complex Nested Matrix, Matrix, grouping reports using inline view, place holder, formula column, lexical parameters with Oracle Report 6i.
• Designed, developed and customized forms by using Oracle Forms 6i and Reports 6i.
• Designed, developed and customized EXCEL Report using OLE Utility.
• Import / Export data using the TEXT_IO for exchange the data’s between banks and system, Instead of Cheque Payments.
• Involved in developed and maintained data model for various clients from single file.
• Involved in Catch the poor queries using SQL Area.
• Handled the entire ( 1256 ) Reports in single handle.
• Performance tuning business critical processes by re-coding and creating/adding indexes.
• Migrated data from Flat Files to Oracle database using SQL*Loader. Wrote Oracle PL/SQL programs for backend processing.
• Creating views for report data model and checking the integrity of data.
• Delivery the modified programs using mail and FTP.
• Managing day to day problems – Online Support using MSN.

Environment: SQL, PL/SQL, ORACLE 9i, Developer 6i (Forms 6i and Reports 6i), PL/SQL Developer, SQL Navigator, SRM (Specification Creation and Resource Maintain System), SQL Expert, UNIX, Windows NT/XP/2000.

Confidential Jun 2002 - Feb 2004
ESAS – Expenditure Suspense Account System Oracle Developer

Confidential is a leading services provider delivering technology driven business solutions that convene business objectives of its clients throughout the country. CONFIDENTIAL believes in providing Information Technology solutions, enhancing competitive advantage of customers, founded on contemporary technologies and practices, innovation, empowered people and enduring relations. By virtue of its technology. Its providing the solutions for Constructions Companies to manager there accounts, Materials and human source.

ESAS is an Expenditure Suspense Account System which is used to maintain the suspense a/c expenditure of leading construction (p) ltd. This is system inserts all the summed expenses into appropriate particular suspense heads and finally it tallies the account. It creates a temporary account which must be closed within specified period.

Roles and Responsibilities:

• Involved in design and development using Oracle Forms and Reports.
• Involved in planning and performance tuning related to DB objects like views, statements...
• Involved in debugging Stored Program Unit, Statement and views with complex JOINS.
• Involved in UTL_FILE Utility.
• Involved in debugging / editing the existing programs.
• Involved in migration of an MS Access application to oracle.
• Involved in design, programming and long-term support of Microsoft Access database programs to meet information.
• Involved in script running based on new creation.
• Involved in documentation of the objects.

Environment: SQL, PL/SQL, ORACLE 8i, MS Access, Developer 6i (Forms 6i and Reports 6i), TOAD, Windows NT/98/2000.