SUMMARY:

• Collaborate with business analysts, business users and other developers in conceptualization and development of new technical objects within the Oracle applications environment.
• Create/Modify/Review the Reports RDF or Forms in Oracle 10g.
• Evaluate requirements from functional specifications and create efficient technical designs and give Technical download to the Developer.
• Design, develop, deploy, test and maintain technical objects that exist in Oracle applications production environment, e.g., reports, interfaces, conversions and custom applications extensions.
• Review Code for Coding standards and from Performance, reusability, modularity prospective
• Do Tuning of the code such as SQL queries and PLSQL code.
• Provide support to System Administrators relating to custom responsibilities, security profiles, menus, and user account provisioning.
• Provide customer support for business critical application problems and issues.
• 13 years of IT Professional experience as Tech Lead / Application Analyst / Developer in Internet and Client/Server applications using Oracle Database (8.8i and 9i), Oracle 9iAS, Oracle Developer/2000 (Forms 6i, Reports 6i/9i), Discoverer 10g, Oracle Warehouse Builder 10g, PL/SQL, SQL, Java Application Programming, Java Applet, Java Servlet, JDBC and JSP on different platforms like SUN Solaris, Unix, Windows NT/2000/98/95.
• Extensively worked with developing Forms and Reports using Oracle Forms/Report 6.0/6i/9i/10g.
• Experience in creating Inbound and Outbound Interfaces to/from Oracle Application system using APIs.
• Experience in creating conversion interface from legacy system to R12.
• Developed Data Warehouse using Oracle Data warehouse builder for Confidential .
• Worked on Oracle Financial Application 10.7 module such as AP, AR and GL.
• Extensively worked with Financial Reports for the State of Michigan.
• Extensive knowledge of conversion of COBOL to PL/SQL
• Performed Data Conversion from legacy system into Oracle DB for State of Florida
• Performed Data Conversion for Confidential and developed POWER BUILDER reports for Confidential .
• Extensive knowledge of Finance Reports, Wagner Pyser Program Reports, Workers Investment Act (WIA) Program Reports, Welfare Transition (WT) Program Reports of State of Florida / Tennessee.
• Extensively worked in deploying application into Web - enabled environment using Oracle 9i Application Server.
• Expertise in deploying reports on Reports Server and troubleshooting Reports Server and Report Security issues.
• Experience in Leading a Team for development of reports and Backend Development.
• Performed Data Conversion from diverse systems into Confidential Financial Systems.
• Proven skills in SQL tuning and enhancing application performances.
• Proficient in server side programming like Procedures, Functions, Database Triggers, Packages using PL/SQL and SQL.
• Worked extensively with SQL Loader using control files for data ware housing and data loading into oracle database tables.
• Experience in leading a team of 3 to 5 developers.
• Proficient in Tuning SQL using Explain plan, SQL*Trace and Auto Trace utility.
• Experience in using Oracle Utility like Export, Import and SQL*Loader
• Experience in Migration and Upgrade Oracle Database
• Experience in all phases of Software Development Life Cycle (SDLC) like Requirement Capturing, Data Modeling and Designing, Developing, Testing, Quality Assurance, Implementing, Documenting and User Training for various business applications.
• Used Discoverer to create business areas against oracle database
• Experience in developing Internet application using Java Programming, Java Applet, Java Servlet, JDBC, JFC, Java Swing, PL/SQL web toolkit, JSP and JavaScript.
• Proficient in Data Modeling using Rational Rose Data Modeler.
• Experience in Development Database Administration activity such as
• Installing and Configuring Oracle Software and Databases like Oracle 8.x and 9i
• Creating and Managing Logical and Physical Structure of the database
• Estimating size and creating schema objects like tables, indexes, views etc.
• Performance Tuning of application
• Managing SQL*Net and Net8 for database connectivity
• Team-oriented professional with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Specialization: Oracle 8/8i/9i/10g / Developer D2k (6/6i/9i/10g) / Oracle Warehouse Builder 10g

Platforms: Windows 95/98/NT, DOS 6.0, UNIX

Modules: AP, AR, GL, Inv, OM

Languages: C, C++, C#, Pro* C, JAVA 2

DBMS: FoxPro 2.6

RDBMS: Oracle 8 / 8i / 9i / 10g, Access 2000

ETL: Oracle Data Warehouse Builder 10g (Release 1), Datastage, Oracle Streams

Middle Tier: Report Server 6i, 9i, 10g, Forms 6i Server, EJB, OC4J, Oracle App. Server 9i, 10g

Front End: Developer 6.0(Forms 6 & Reports 6.0),Forms/Reports 6i/9i/10g, Crystal Reports, Power Builder JSP

Other Application: Toad, SQL Navigator, ERWIN, PVCS, JDeveloper, Discoverer 4i

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Engineer

Technical Environment: Oracle Apps R12, Oracle Developer 10g, TOAD

Responsibilities:

• Develop/Enhance Procedures / Function and Triggers
• Developed In bound Interfaces and conversions to transfer the data from different systems.
• Create and resolve Service Requests in collaboration with Oracle Support.
• Developed outbound interface to extract supplier details data including Payment details with Check for a wide range of dates using UTL FILE Package.
• Developed supplier Conversion to load vendor details from legacy system into Oracle Applications base tables.
• Developed interface program to Upload items into GL interface tables from Legacy System in Oracle General Ledger and Used SQL * Loader to upload data from Flat Files to Pre-interface table and wrote PL/ SQL Procedures for all the business validations.
• Tune PLSQL/SQL code for performance.
• Assist in production support.
• Coordinate work efforts with the DBA and middleware teams for application change controls and system performance issues.
• Assist vertical team in designing and building their application
• Maintain the Replication system (YURI) across databases.
• Build Database from application perspective.
• Prepared and reviewed MD070 documents based on MD050 document.
• Involved in Preparations of MD0120, MD070 documents
• Involved in BI publisher(XML Publisher) Reports
• Involved in customizing and developing the Reports.
• Involved in Discoverer Reports

Confidential

Sr. Oracle Developer

Environment: Oracle apps 11.5.10.2(PO, AP, AR, OM, INV, GL), Developer 2000 and Oracle 9i

Responsibilities:

• Develop forms and reports in Oracle Forms 10g and reports 6i/10g.
• Convert SQR Reports in Oracle Reports 6i
• Involved in the development of interfaces and Conversions to import the data from legacy systems into oracle application base tables.
• Involved in sysadmin activities related to all Concurrent Processing and Programming, Custom Application Development, System Administration, Flex field, Value sets etc.
• Participate in planning and execution of conversion of 6i Reports to 10g
• Participate in meetings with the users
• Coordinate with other programmers to develop individual modules.
• Provide generalized production technical support.
• Tune the forms and reports query for Performance.
• Partner with business analysts and application super users to successfully complete projects.

Confidential

Technical Team Lead - Code Architect

Technical Environment: Oracle Database 9i, Oracle Forms and Reports in an UNIX Environment and Oracle 10g Application Server

Responsibilities:

• Lead a team of 3 to 5 developers depending upon the size of Enhancement request/change request.
• Assist Project Manager with Time estimates
• Gather Business requirements from the Business Analyst. Give feedback and clear doubts with the BA.
• Create a prototype
• Custom report to obtain details on Purchasing, Receiving and Payables with in specified dates.
• Customized the Invoice Aging Report to display only not paid Invoices with invoice status should be approved.
• Customized Invoice History Report by adding few more details related to Bank (Bank Name, Branch Name and Account Number).
• Customized Order Discount Detail Report by adding up two more fields (List Price Subtotal & Selling Price Subtotal) for existing List Price & Selling Price.
• Prepare Technical Specifications or give download to the Developer to prepare the Technical Doc.
• Give review comments and sign off on Technical Specs.
• Perform Data Conversion from diverse systems into NADB.
• Review Code for Coding standards and from Performance, reusability, modularity, etc. prospective
• Do Tuning of the code such as SQL queries and PLSQL code
• Review/Create/Modify the Reports RDF or Forms in Oracle 10g depending on the work load
• Design/Review process for data cleanup
• Migrate the code in different environments
• Responsible for meeting deadlines for the change request or enhancement
• Responsible for Sign offs from the customer
• Responsible for rollbacks incase of issues in Production
• Responsible for smooth rollout and keeping a check for the first cycle of Production runs

Confidential

Technical Team Lead - Code Architect

Technical Environment: Oracle Database 9i release 2, Oracle Forms/Reports 6i/10g in Unix Environment and Oracle 10g Application Server

Responsibilities:

• Lead a team of 2 developers
• Assist Project Manager with Time estimates
• Give review comments on the coding and layout
• Convert all the forms which were creating excel files from 6i to 10g
• Convert report RDFs from 6i to 10g
• Responsible for Comparison testing and delivery.

Confidential

Software Engineer (Reports / Data Warehouse Architect)

Technical Environment: Oracle Database 10g, Crystal Reports, PowerBuilder (9)

Responsibilities:

• Gather Requirements from the User
• Create Documentation
• Create Reports in Crystal Reports
• Create Technical Specs for Power Builder Programmers
• Convert Crystal Reports to Power Builder Reports
• Create/Review PLSQL process, scripts for Data cleanup
• Create/Review Procedure/Functions/Triggers
• Perform Data conversion from the legacy system.

Confidential .

Sr. Software Engineer (Reports / Data Warehouse Architect)

Technical Environment: Oracle Database 10g, Oracle Warehouse Builder, Oracle Discoverer, Oracle Reports

Responsibilities:

• Trained myself on Oracle Data warehouse Tool and gave other Team members training to create resource backup.
• Captured Requirements and Designed Data warehouse database Tables, Views and Dimensions and Cubes etc.
• Developed Oracle mappings, Process flows and deployed them on Oracle Workflow.
• Involved in direct discussion with the Functional/End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements
• Developed Reports using Reports 10g, PL/SQL and SQL, Discoverer 10g and Crystal reports.

Confidential .

Sr. Software Engineer (Reports / Data Warehouse Architect)

Technical Environment: Oracle Database 10g, SQL, PL/SQL, Mainframe - COBOL, Crystal Reports.

Responsibilities:

• Analyzed COBOL Mainframe system.
• Designed the Oracle Process
• Created ER Diagram using Erwin.
• Created Documents
• Created Proof of Concept
• Created Objects and PLSQL procedures in Oracle 10g
• Migrated the old Data from Mainframe to Oracle Database
• Created Reports in Crystal
• Supported the system for 3 cycles of Production run.
• Responsible for Production Sign off.

Confidential

Sr. Software Engineer (Lead Reports Architect)

Technical Environment: Oracle 9i Application Server, Apache Web Server, Oracle 8i Database Server, Rational Rose Enterprise 2000 for UML Design and code generation, Rational Test Suite for Functional & load testing

Responsibilities:

• Captured Requirements and Designed database tables, views, indexes etc.
• Created schema objects like partitioned tables, views, indexes etc.
• Developed store procedures to move data from staging table into online tables using PL/SQL
• Interacting with users to gather requirements and mapping the same with PL/SQL, Stored Procedures and Functions and Triggers for various validations in the application.
• Lead the team of four as Lead Developer for reports
• Handled the deployment of reports on the reports server and made the necessary changes to the CGIcmd file.
• Involved in data correction and Process corrections of the application.
• Handled the reports security and issues related to calling of reports on web.
• Tuned SQL for performance improvement using Explain plan and SQL*Trace.
• Developed application reports using Reports 6.0/6i/9i/10g, PL/SQL and SQL
• Developed SQL scripts to create database tables, synonyms, sequences and created users, roles and granting privileges for them
• Written several Procedures, Functions and Packages using PL/SQL.
• Perform Data Conversion from the legacy system into OSMIS.
• Written Scripts for Loading ASCII/Flat files onto the Oracle database using SQL * Loader.
• Utilized tools TOAD during development of the application.
• Involved in direct discussion with the Functional/End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.

Confidential

Analyst Programmer

Technical Environment: Oracle 8i, EJB1.1, JSP 1.0, OC4J 1.0.2.2, Reports 6i, Reports Server.6i

Responsibilities:

• Created schema objects like partitioned tables, views, indexes etc.
• Developed store procedures to move data from staging table into online tables using PL/SQL
• Interacting with users to gather requirements and mapping the same with PL/SQL, Stored Procedures and Functions and Triggers for various validations in the application.
• Lead the team as Lead Developer for reports and back end procedure and functions and triggers.
• Handled the deployment of reports on the reports server and made the necessary changes to the CGIcmd file.
• Tuned SQL for performance improvement using Explain plan and SQL*Trace.
• Developed application reports using Reports 6.0, PL/SQL and SQL
• Developed SQL scripts to create database tables, synonyms, sequences and created users, roles and granting privileges for them
• Written several Procedures, Functions and Packages using PL/SQL.
• Written Scripts for Loading ASCII/Flat files onto the Oracle database using SQL * Loader.
• Utilized tools TOAD during development of the application.

Confidential

Analyst Programmer

Technical Environment: Oracle Form Server 6i, Developer 2000 Release 6, Oracle 8i 8.1.6 Database Server, Designer 2000 Release 6, Windows NT workstation, Sun Solaris 2.6.

Responsibilities:

• Created schema objects like partitioned tables, views, indexes etc.
• Interacting with users to gather requirements and mapping the same with PL/SQL, Stored Procedures and Functions and Triggers for various validations in the application.
• Developed application reports using Reports 6.0, PL/SQL and SQL
• Developed SQL scripts to create database tables, synonyms, sequences and created users, roles and granting privileges for them
• Written several Procedures, Functions and Packages using PL/SQL.
• Utilized tools TOAD during development of the application.

Confidential

Programmer

Technical Environment: Oracle 8i and Forms and Reports 6i on Windows NT

Responsibilities:

• Created schema objects like partitioned tables, views, indexes etc.
• Interacting with users to gather requirements and mapping the same with PL/SQL, Stored Procedures and Functions and Triggers for various validations in the application.
• Developed application reports using Reports 6.0, PL/SQL and SQL
• Developed SQL scripts to create database tables, synonyms, sequences and created users, roles and granting privileges for them
• Written several Procedures, Functions and Packages using PL/SQL.
• Utilized tools TOAD during development of the application.