Description
EXPERIENCE SUMMARY * 5 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). * Expertise in design and development of Data Conversions and Migrations using Interface tables and APIs from Legacy systems to Oracle Applications (EBS) 11i/R12 suite using PL/SQL, Oracle API and Oracle Open Interfaces * Substantial development experience in creating Stored procedures, Functions, Packages, Triggers, Indexes, Views, UNIX Shell Scripts, SQL * Loader scripts. * Oracle Application E-Business suite System Administration activities like application user setup, defining responsibilities, values sets, flex fields, lookups, registering menus, concurrent programs, and providing support to apps users for any technical issues. * Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, SQL Developer, TOAD and SQL*LOADER. * Good working experience in Exception handling, PL/SQL Tables, Record type, Ref Cursor and Dynamic SQL. * Experience with Oracle supplied packages such as UTL_FILE and DBMS_JOB * Hands on experience on Oracle HRMS (Core HR) tables * 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. * Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based). * Developed materialized views for data replication in distributed environments. * Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes. * Experience with Performance Tuning for Oracle RDBMS using Explain Plan. * Experience in preparing Conversion Mapping Documents (CV050) * Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Tableau, OTBI. * Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team. * Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work around, interfaces, user training. * Excellent analytical and communication skills. Highly motivated and able to absorb new technologies quicker and interested to keep up to date in specialized areas.
Accomplishments
Highlights:
Keywords
