Description
Summary Highly qualified, Oracle developer with solid history of designing, developing and deploying innovative solutions to highly complex software needs. Deep knowledge of SQL, PL/SQL, database design and data modeling, performance tuning, Oracle Forms, Reports, Designer and development lifecycles and practices. Thorough understanding of business logic in developing comprehensive software solutions. SQL & PL/SQL Programming * Systems Analysis & Design * Application Development Oracle Forms & Reports 6i/9i/10g * Data Modeling & Relational DB Design * Business Intelligence * Database Administration * Performance Tuning * Oracle EBS (HCM, SCM, FIN, AP, AR, GL, FA, & CE) Technical Proficiencies * Over 13+Years of Experience as an Oracle PL/SQL Developer with Proficiency in SQL, Oracle PL/SQL, Oracle Forms Builder, Oracle Reports Builder 10g/9i/6i, Java, UNIX Shell Scripting. * Hands on experience in designing and developing of end user screens and reports using Oracle Developer/2000 (Forms, Reports) Oracle Developer Suite 10g and other front-end tools. * Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases. * Extensive working knowledge in developing Database Triggers, Stored Procedures, Functions for developing Forms and Reports. * Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf. * Extensive experience in using Cursors and Ref-Cursors for processing of data. * Good Knowledge on advanced PL/SQL constructs such as Oracle supplied packages and Collections including PL/SQL Records, Associated Array, Nested tables and Varray. * Strong programming skills on Oracle SQL, PL/SQL indexes, bulk collects and bulk variables. * Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing. * Worked with query tools like Toad, SQL*Plus, PL/SQL Developer. * Enforcing experience in data integrity using integrity constraints and database triggers. * Expertise in handling errors using Exceptions. * Experience in creating Materialized Views and DB links. * Strong understanding of Object Oriented Analysis and Design. * Extensively worked on Materialized Views, Database links and Table partitioning Oracle 11g. * Experience in logical and physical design of Databases, Data Modeling and Data Architecture. * Excellent experience in Performance tuning SQL queries to optimize system performance. * Proficient experience in optimization of ETL procedures and packages. * Experienced in Systems Analysis & Design, Application Development, Data Modeling, Business Intelligence, Database Administration and Performance Tuning. * Excellent analytical and interpersonal skills, oral and written communication skills. * Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities. * Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work. Injazat Data Systems (Owned by Hewlett-Packard HP) FL An industry recognized market leader in the region for IT Data Center and Managed Services in Consulting Outsourcing and Cloud Services.
Accomplishments
Highlights:
Keywords
