SUMMARY

• Experienced techno - functional consultant with expertise in enterprise-wide transformations enabled by Oracle Applications ERP. 12 years of professional experience, performing various levels ranging from individual contributor to supporting teams to team-lead in implementation and upgrade projects.
• Performed various aspects of consulting including requirement gathering, project planning, project management, project execution including application configuration, customization, extension, implementation, system testing, documentation, user training and production support and maintenance.
• Good experience in ASCP and implementation and customization of SCM modules like PO, INV, OM, AP,AR and GL, Advance Pricing, Fixed Assets and good understanding of the entire P2P, O2C business cycle process and good experience in Development of Interfaces and Conversions to validate and load data from legacy and feeder systems to Oracle applications.
• Strong experience in development/maintenance/Testing /conversion and migration projects in ORACLE database (PL/SQL) under UNIX/LINUX/Windows environment.
• Strong knowledge of Application Implementation Methodology (AIM).
• Good experience in Data Conversion, Data migration, interface development, Report generation, Sql*Loader scripts, Unix and Shell Scripting.
• Hands on experience in technical analysis, development, implementation integration and maintenance support for 24x7 production environment.
• Good experience in all phases of SDLC, exposure to CMM process, Testing, Quality and change management procedures.
• ORACLE certified Associate (OCA) with experience in database design, Database administration, data conversion, data integration, data warehousing, performance tuning, creation of database objects, developing PL/SQL stored Procedures, Packages, Functions, Triggers, Materialized view, SQL*Loader, export/import/data pump utilities and Dynamic SQL.
• Good knowledge and experience in Oracle Forms, Oracle Reports, XML reports,JAVA, Pro*C, Developer/2000, TOAD, SQL*Plus.
• Extensive experience in daily batch jobs, report monitoring, space management, and index rebuilds statistics collection and other Oracle housekeeping tasks.

TECHNICAL SKILLS

Databases: Oracle DB 7,8,9i, 10g, 11g, 11gR2, SQL Server 2005 and 2008, Oracle 9i Application Server ( 9iAS)

Operating Systems: UNIX, LINUX, Windows, MS-DOS, Open VMS

Languages: SQL, PL/SQL, C, JAVA, Shell Scripting, Perl Scripting, HTML, DCL scripts, SERVLETS, C++, COBOL, FORTRAN, Visual Basic

Tools: SVN, SQL Developer, Oracle Forms, Reports, SQL*Plus, SQL*Loader, Import/Export,, Informatica, TOAD, PVCS, Enterprise Manager, NEON Rules, NEON Formatter, NEON Queue, Crystal Reports, Microsoft Office (Excel, Word, Power Point, and Access), Visio, Install Shield, Label printing software(Printware), Vi Editor, Exceed, Kintana, CVS, SQL Navigator, LoadRunner, QuickTestPro, ERWIN, MS Project, PUTTY, Teamcity, JIRA, PPM(Project & Portfolio Management), Quality Center, Datapump, SQL trace, SQL developer, ORACLE APPS R12, AWR Reports, Statpack reports, DBMS PROFILER

PROFESSIONAL EXPERIENCE

Confidential, SFO

Oracle Apps Technical Consultant

Environment: Oracle 10g, PL/SQL, Toad, UNIX, Sharepoint, Oracle eBusiness Suite R12,Accounts Payables, GUS, Perforce for version control, Sql*Loader,Oracle Developer Suit 10g, Oracle Reports, XML Reports

Responsibilities:

• Develop concurrent program to Upload the employee details from HR department to Oracle EBS and Extract outbound employee and department details from Oracle EBS and SFTP that to Tangoe systems.
• Documentation of MD70, RUNLIST, UTP as per AIM methodology.
• Unit testing of the application.
• Understand MD 50, design and develop PL/SQL code, Shell script, control file as per Salesforce coding standards.
• Performance tuning of the queries.
• Prepare XML report for Dynamic discounting for AP invoice.

Confidential, Dallas

Oracle Apps techno functional Consultant

Environment: Oracle 10g, PL/SQL, Toad, UNIX, Sharepoint, PPM (Project & Portfolio Management), Quality Center, SVN, Oracle, Oracle Apps R12, Order Management, Advanced pricing

Responsibilities:

• Upload transfer orders from DC to staging tables and archive the data file.
• Validate data and insert into custom tables.
• Purge more than one month data.
• Document MD70, Migration docs, install file, UTP as per AIM methodology.
• Unit testing of the application.
• Mentor team members.
• Send weekly status report to the management.
• Performance tuning of the queries.
• Develop report to display all the cash payments made to suppliers between the given date range.
• Used Order upload API’s to load the order data.

Confidential, CA

Oracle DB Architect/Consultant

Environment: UNIX, Oracle 11g Express Edition, PL/SQL, Windows 7, TOAD, JIRA, SQL Developer, SVN, JAVA,AWR report, DBMS Profiler

Responsibilities:

• Design/Develop/Test/Implement PL/SQL procedures, triggers, functions and packages for the Time Track application using Agile Scrum methodology.
• Migration of SQL server DB to Oracle DB.
• Define Data Retention Policy and implement policy.
• Requirement analyses, design, develop, test and implement the back end database enhancements required for the Confidential product maintenance request.
• Mentor database developers to deliver work on time for each sprint.
• Performance tuning of the queries based on AWR report and DBMS profiler.
• Do Export/ Import of the tables to extract and Load Data.
• Writing control files to load data into table using SQL Loader.
• Prepare test cases, test data and execute the testing of the change request.
• Testing the backend changes through the JAVA front application.
• Developed PL/SQL procedures using dynamic SQL.

Confidential, Confidential

Technical Lead

Environment: & Tools: Oracle eBusiness Suite, GL, AP, Oracle 10g PL/SQL, Forms 9i,Reports 9i, Toad, Accounts Payables, Order to Cash, Procure to Pay,SQL Developer, UNIX, and XML Publisher, Oracle Apps 11i, RICE

Responsibilities:

• Prepare MD 70 artifacts for the project.
• Prepare various metrics for the project.
• Develop the PL/SQL package and concurrent programs for the apps project.
• Check the status on issues and prepare report on the same.
• Coordinate with onsite team and offshore team.
• Allocate work to team members and update the status to clients.
• Coordinate the deliverables and track the schedule.
• Performance Analysis of the deliverables.
• Identify the resource requirements in the project.
• Conduct Business Meeting and conference calls with the client.
• Responsible for validating the weekly effort reporting of the team and billing that to the customer.
• Prepare periodic reports and evaluate the performance of the deliverables.
• Develop a report to display all the unpaid invoices of suppliers for a given date range.

Confidential

Project Lead

Environment: Oracle EBS, XML Publisher, PL/SQL, Forms, Reports, RICE Components, Oracle Apps Oracle Apps 11i, Accounts Receivables

Responsibilities:

• Prepare CV60 Documents after completion of the component.
• Develop new forms by using TEMPLETE.
• Customize Oracle Standard forms by using CUSTOM.pll
• Develop Supplier open interface to load supplier details from old system into Oracle Apps Supplier base tables.
• Using Sql*Loader to load data from flat files to staging tables and write PL/SQL procedure for all the validations. Data is then loaded into the supplier base tables using standard import program.
• Status monitoring and Weekly calls.
• Workflow customization for PO approvals.
• Execute concurrent programs from PL/SQL.
• Creation of Value sets in various Modules of the application.
• Develop outbound interface in PO module to extract the po details from Oracle Apps base Tables to the Flat file using UTL File utility.
• Prepare test cases and conduct Testing of the application

Confidential

Oracle Apps consultant

Environment: HP UNIX, Windows XP, Accounts Receivables, TOAD, EBS, Putty, SFTP, Oracle, PL/SQL, Shell scripts, Oracle Apps 11i

Responsibilities:

• Develop concurrent program, pl/sql package and shell script for the package
• Prepare mapping of the flat file
• Validate data and insert into AR base tables .
• Document MD70, Migration docs, install file, UTP as per AIM methodology.
• Unit testing of the application.
• Help team members in resolving technical issues.
• Coordinate with onsite team and offshore team.
• Allocate work to team members and update the status to clients.
• Performance Analysis of the deliverables.
• Conduct Business Meeting and conference calls with the client.
• Prepare test cases and conduct Testing of the application

Confidential, Longview, WA

Tech Lead

Environment: Oracle 9i Administration, Forms9i/6i/5.0/3, Oracle Reports 9i/3.0/1.1, Oracle Developer; PL/SQL; PL/SQL web Tool kit; SQL*Plus; Oracle 9i; Sun Solaris UNIX; Shell scripts, Open VMS, Windows NT/XP, TOAD, Visio.

Responsibilities:

• Provide 24 x 7 production supports to the application as per the SLA.
• Lead team of 12 through the analysis, design, development, testing and implementation life cycle of a conversion/migration project.
• Conversion of DCL scripts to UNIX shell scripts.
• Assist the DBA in Database administration of Oracle 9i and 10g databases.
• Involved in the installation and customization of Oracle 9i application server
• Conversion of character based forms/reports/menus to Web based forms/reports/menus.
• Assist in installing and setting up the Forms and Reports Services on 9iAS.
• Trouble shoots the database performance issues and bugs within packages, forms, and reports using dbms output, explain plan etc.
• Conversion of COBOL and FORTRAN programs to PL/SQL and Pro*C programs.
• Design and develop Web-enabled Oracle Forms & Reports.
• Develop and document standards for Coding and development.
• Participate in Implementation, System/Stress testing and UAT.
• Created new interfaces to the Application like Label printing, core tag printing (barcodes) and Accusort scanners.
• Documented business rules, functional and technical designs, test cases, and user guides.

Confidential, MN

Tech Lead

Environment: Oracle Forms/reports 9i/6i, Oracle PL/SQL, SQL, SQL*Plus, Oracle 9i, Sun Solaris, UNIX,Shell scripts, informatica, Windows XP, TOAD, PVCS, Exceed.

Responsibilities:

• Write PL/SQL packages, procedures, and database triggers to calculate missing information and determine the eligibility in the processing of an interface to I2 applications. This data is then loaded into I2 Applications.
• Use Informatica ETL tool to load the data to I2 applications.
• Prepare test cases for material master and Item master.
• Create new Pro*C programs for the batch jobs using cron tab.
• Document, functional and technical designs, test cases, and user guides.
• Generate Oracle Forms and database objects through forms 6i.
• Involved in the System testing, stress testing and UAT.

Confidential

Module leader

Environment: Shell scripts, C++, Oracle Forms 6i; Oracle Reports 3.0; Oracle Developer; PL/SQL; SQL;SQL*Plus; Oracle 8i; Sun Solaris Unix; Windows NT; NEON tools, PVCS; TOAD, Pro*C, PERL

Responsibilities:

• Develop PL/SQL packages for data exchange in the application.
• Upgrade Forms and Reports from 3.0/1.1 to 6i.
• Debug PERL programs for daily upload process.
• Design, create and maintain Web-enabled Oracle Forms & Reports.
• Generate SQL and PL/SQL scripts to send transaction files.
• Create database objects like tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Troubleshoot performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
• Prepare Web enable documents about business rules, functional and technical designs, test cases, and user guides

Confidential

Oracle/Java Developer

Environment: JAVA, Servlets, Crystal Reports, Rational Rose, PL/SQL; SQL; SQL*Plus; Oracle 7/9i; SQL*Loader; Sun Solaris UNIX; TOAD

Responsibilities:

• Develop Front end screens using SWINGS, Java applets and servlets.
• Develop new Crystal reports for month end /week end billing information and several custom reports for invoicing and auditing.
• Develop PL/SQL procedures for the user interface like data load using SQL*Loader, cron jobs calling UNIX scripts to download and manipulate files.
• Document user guides, design document and train the end users.
• Do analysis, design and development of purging module for Teleprodigy project.
• Co-ordinate with various module leaders of the project.