PROFESSIONAL SUMMARY:

• Experienced techno - functional consultant with expertise in enterprise-wide transformations enabled by Oracle Applications ERP. 15 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.
• Certified from Confidential 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, Partitioning, Collections (bulk collect, FORALL) and Dynamic SQL.
• Good experience in E-Business Suite Financials, Supply chain and HRMS implementation and customization of GL,PO, INV, OM, AP,AR, Payments, AME, FA, iProcurement, iExpenses, WEBADI, TCA (trading community Architecture
• Expertise in entire P2P, O2C business cycle process and good experience in Development of CEMLI/RICEW
• 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.
• 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:

• ERP & E-Commerce developed, implemented
• Oracle Applied Implementation Methodology (AIM)
• Software Development Management
• Staff oversight / Team Management (technical & functional)
• Project meeting / presentation/ Workshops
• Project planning & control (MS Projects)
• Project implementation
• SCRUM Methodology
• Oracle Receivables
• Oracle Payments
• Oracle Purchasing
• Oracle General Ledger
• Oracle Accounts Payable
• Oracle Cash Management
• Procurement, Supplier
• Oracle Assets
• Order Management
• Oracle Project Accounting
• Oracle System Administration
• Master Data management, Customer Data Hub, Trading Community Architecture, Customer Online
• Oracle Discoverer (Release 2 - 4)
• Oracle HR
• Siebel, Salesforce, Custom Applications Oracle DB 7,8,9i, 10g, 11g, 11gR2, SQL Server 2005 and 2008, Oracle 9i Application Server ( 9iAS),Developer6i, Forms, SQL, PL/SQL, TOAD, SQL*Loader, SQL Developer, SQL trace, C, JAVA, Shell Scripting, Perl Scripting, HTML, DCL scripts, SERVLETS, C++, COBOL, FORTRAN, Visual Basic, JIRA, ServiceNow
• AWR Reports, Statpack reports,, Reports.XML Publisher, Crystal Reports, Discoverer Import/Export, Informatica, ERWIN, Datapump,
• DBMS PROFILER,Visio, Workflow Builder, Web Services, Share point
• Remedy, Kintana, SVN, PVCS, PPM(Project & Portfolio Management), TFS Quality Center,
• Enterprise ManagerNEON Rules, NEON Formatter, NEON Queue, Postgres SQL Microsoft Office (Excel, Word, Power Point, and Access), Label printing,, Vi Editor, PUTTY, LoadRunner, QuickTestPro, UNIX, LINUX, Windows, MS-DOS, Open VMS, MS Project, JIRA

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Developer

Environment: & Tools:, Oracle 10g, PL/SQL, Toad, UNIX, Sharepoint, Oracle eBusiness Suite R12,Accounts Payables, iExpenses, HRMS, iProcurement, AME,MKS, Quality Center, ALM, PPM, Sql*Loader, Oracle Developer Suit 10g, XML Reports, EssBase, SSO, Discoverer, ServiceNow, Workflow, Projects.

Responsibilities:

• Design, develop, test and implement PL/SQL package, function, procedures, triggers etc. as per the requirement for various modules like AP, AR, GL,HRMS, iProcurement, iExpenses, Fixed Assets and Cash Module.
• Work as a governance for all the changes in the application.
• Responsible for working with functional team for preparing MD50 and MD070 document for Employee upload process from external systems.
• User creation, granting access to users.
• Responsible for unit testing of the application.
• Performance tuning of the queries.
• Implement Requisition, PO approval and iExpenses using AME.
• Workflow customization for PO approvals.
• Support SOX auditing.
• Apply MKS tickets in various environments like DEV/INTG/UAT/PROD.
• Apply post refresh task in all the environments to remove the sensitive info.
• Grant hyperion reports access to users.

Oracle Apps Technical Consultant

Environment: & Tools:, 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, postgres SQL, ORACLE HR,Discoverer,GitHub, AME, Workflow

Responsibilities:

• Responsible for working with functional team for preparing the MD070 document for Employee upload process from external systems
• Designed and developed 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.
• Responsible for unit testing of the application.
• Performance tuning of the queries.
• Responsible for working with functional consultants to prepare XML report for dynamic discounting for AP invoice.
• Responsible for design and development of MD050 for Supplier and Invoice integration.
• Responsible for creating a custom desktop integrator for uploading Invoices using WEBADI.
• Implement iExpenses using AME.
• Workflow customization for Invoice approvals.

Oracle Apps Techno Functional Consultant.

Responsibilities:

• Responsible for working with business users, Functional consultants for requirements and gaps
• Responsible for creating design document for Integration
• Responsible for creating MD70, Migration docs, install file, UTP as per AIM methodology.
• Responsible for leading development to integrate orders from external systems.
• Extensively used Order Api’s, Advanced Pricing API’s (Qualifiers, Modifiers, Pricelists) TCA API’s for integration.
• Responsible for designing a process to purge more than one month data.
• Responsible for providing test scripts for Unit testing of the application.
• Mentor team members.
• Send weekly status report to the management.
• Responsible for working with oracle support on Issues/Patches.
• Responsible for performance tuning of the queries.
• Responsible for developing multiple reports in Oracle XML/ BI publisher reports.

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

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 ETRACE 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.

PL/SQL Developer

Responsibilities:

• Responsible for supporting Albertsons E-Business suite applications
• Responsible for working with functional team on addressing the technical questions and timelines for deliverables
• Responsible for preparing design documents for various project deliverables
• Responsible for converting fixed assets, Receivable invoices, AP invoices from external systems as part of M&A activity.
• Supported ETL activities.
• Responsible for designing & developing reports across financial modules
• 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 weekly effort reporting of team& billing to customer.
• Prepare periodic reports and evaluate the performance of the deliverables.
• Develop report to display all unpaid invoices of suppliers for a given date range.

Tech Lead for Oracle application migration and production support

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 - Oracle PL/SQL /Forms Development/DBA

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, Shell scripts, C++, JAVA, servlets, Crystal Reports

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.
• Develop Front end screens using SWINGS, Java applets and servlets.
• Prepare Web enable documents about business rules, functional and technical designs, test cases, and user guides
• 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.