Seeking a challenging and innovative career in Oracle Applications software development and Integration for which I can utilize my extensive technical and interpersonal skills that support business requirements and to excel my skills through smart work, perseverance and learn new technologies. • 7+ years of IT experience in developing cost effective solutions as an Oracle Technical Consultant using Oracle Applications and experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. • Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER. • Effectively made use of Table Functions, Indexes, Collections, Analytical functions, Materialized Views, Query Re-Write. • Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based). • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. • Developed materialized views for data replication in distributed environments. • Experience with Dynamic SQL, Records and PL/SQL Tables and Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE. • Extensive experience in Ref Cursor, External Tables and Collections, Dynamic SQL, Exception handling. • Extensive experience in Oracle Applications e-Business Suite Applications- Supply chain management Modules (OM, INV, SO, PO, BOM), Application Object Library (AOL). • Expertise in extending and customizing Oracle EBS using SQL, PL/SQL, Shell Script, Oracle Forms & Reports, SQL*Plus, SQL*Loader, Workflow builder. • Extensive Experience in CEMLI: Customizations, Extension, Modification, Localization and Integration of Oracle Applications using Oracle SQL/PLSQL, Oracle Application Framework (OAF), Shell Scripting, Oracle Forms/Reports Builder. • End to End implementation including analyze business requirements and user requirements, design, document and CRP, Integration and UAT testing using AIM methodology. • Extensively worked on AIM documents like MD050, MD070, CV040, BR100 and TE010. • Expertise with migration tools and test management tools like Kintana and HP QC. • Experience in defining processes relative to Order to Cash (O2C), Procure to Pay (P2P) cycles. • Extensive experience in development and customization of Oracle Application modules, which involves Oracle Forms6I/10G, Reports 6I/10G and Interfaces. • Experience in developing new forms with great complexity and customizing standard Oracle forms with the use of TEMPLATE.fmb, Custom.pll. • Proficient in mapping business requirements, use cases, scenarios, business analysis, and workflow analysis. Act as liaison between business units, technology and IT support teams. • Proficient in conducting requirements GAP analysis, Solution Design, Test Methodologies, Implementation, Knowledge Transfer and Application Support. • Has exposure in working with Onsite – Offshore models. Experience working under extreme stress and delivered desired performance levels within the designated timeline. • Self-motivated, excellent team player with proven leadership skills & analytical skills. • Excellent communication and interpersonal skills. TECHNICAL SKILLS Oracle Applications: Oracle Apps R12, 11i, Order Management (OM), Purchasing (PO), Inventory (INV), Sales Order (SO) BOM (Bill of materials), Application Object Library (AOL) and Sys Admin Database Tools: PL/SQL Developer, SQL*PLUS, SQL*LOADER, TOAD Oracle Tools: Reports 6i/10g, Forms 6i/10g, Developer 10g, Workflow, WebADI, FTP, WinScp374, SSH Client. Databases: Oracle 12c/11g/10g. Languages: SQL, PL/SQL, XML, UNIX, HTML Scripting Language: UNIX Shell Scripting Management tool: HP QC, PVCS, HP PPM Migration Tool: Kintana Operating Systems: UNIX, Windows NT/2000/XP/ Windows 7/Windows 8.
* Click the button to send an offerSend offer