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 teh 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 teh 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 teh application.
• Understand MD 50, design and develop PL/SQL code, Shell script, control file as per Salesforce coding standards.
• Performance tuning of teh 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 teh 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 teh application.
• Mentor team members.
• Send weekly status report to teh management.
• Performance tuning of teh queries.
• Develop report to display all teh cash payments made to suppliers between teh given date range.
• Used Order upload API’s to load teh 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 teh 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 teh back end database enhancements required for teh Confidential product maintenance request.
• Mentor database developers to deliver work on time for each sprint.
• Performance tuning of teh queries based on AWR report and DBMS profiler.
• Do Export/ Import of teh tables to extract and Load Data.
• Writing control files to load data into table using SQL Loader.
• Prepare test cases, test data and execute teh testing of teh change request.
• Testing teh backend changes through teh 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 teh project.
• Prepare various metrics for teh project.
• Develop teh PL/SQL package and concurrent programs for teh apps project.
• Check teh status on issues and prepare report on teh same.
• Coordinate with onsite team and offshore team.
• Allocate work to team members and update teh status to clients.
• Coordinate teh deliverables and track teh schedule.
• Performance Analysis of teh deliverables.
• Identify teh resource requirements in teh project.
• Conduct Business Meeting and conference calls with teh client.
• Responsible for validating teh weekly effort reporting of teh team and billing that to teh customer.
• Prepare periodic reports and evaluate teh performance of teh deliverables.
• Develop a report to display all teh 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 teh 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 teh validations. Data is then loaded into teh 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 teh application.
• Develop outbound interface in PO module to extract teh po details from Oracle Apps base Tables to teh Flat file using UTL File utility.
• Prepare test cases and conduct Testing of teh 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 teh package
• Prepare mapping of teh flat file
• Validate data and insert into AR base tables .
• Document MD70, Migration docs, install file, UTP as per AIM methodology.
• Unit testing of teh application.
• Help team members in resolving technical issues.
• Coordinate with onsite team and offshore team.
• Allocate work to team members and update teh status to clients.
• Performance Analysis of teh deliverables.
• Conduct Business Meeting and conference calls with teh client.
• Prepare test cases and conduct Testing of teh 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 teh application as per teh SLA.
• Lead team of 12 through teh analysis, design, development, testing and implementation life cycle of a conversion/migration project.
• Conversion of DCL scripts to UNIX shell scripts.
• Assist teh DBA in Database administration of Oracle 9i and 10g databases.
• Involved in teh 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 teh Forms and Reports Services on 9iAS.
• Trouble shoots teh 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 teh 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 teh eligibility in teh processing of an interface to I2 applications. This data is then loaded into I2 Applications.
• Use Informatica ETL tool to load teh data to I2 applications.
• Prepare test cases for material master and Item master.
• Create new Pro*C programs for teh 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 teh 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 teh 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 teh 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 teh end users.
• Do analysis, design and development of purging module for Teleprodigy project.
• Co-ordinate with various module leaders of teh project.