The current project is basically to integrate the LaSalle and the countrywide banks that Confidential has acquired. Platforms: Windows (7, Vista, XP, 2000, 98, NT), UNIX, Red Hat Linuxĭata Modeling Tools: Erwin 3.5/4.0/4.5, Designer 2000, Microsoft Visio 2003, Oracle Designer 10.1.2.3, Data Analysisĭatabase Tools: Toad, SQL*Loader, PL/SQL Developer, SQL Developer, SQL Tool, SQL Navigator, Developer 2000 (Reports 6i/9i/10g, Forms 6i/9i/10g), SQL*Plus EXPERIENCE: Oracle Tools: Toad, SQL*Loader, PL/SQL Developer, SQL Developer, SQL Tool, SQL Navigator, Developer 2000 (Reports 6i/9i/10g, Forms 6i/9i/10g), SQL*Plus Possess good communication skills and quick learning ability.Strong Trouble-shooting, Problem solving, Analytical & Design Skills.Experience in Installing Software's and Configuring Databases.Improve the performance of the slow SQL queries by implementing proper Index, using FORALL and BULK COLLECT.Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking back Confidential.Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.Wrote unit test cases for some critical SOA composites.Oracle EBS experience in a functional role supporting the following modules (finance, supply chain, quality, projects and manufacturing).Middleware: Oracle Fusion Middleware 10g/11g (Oracle SOA Suite, Oracle Web logic, OSB, BAM). Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.Extensively Worked on Extraction, Transformation and Load ( ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data warehouse Environment.Reorganized databases and sized database objects to meet standards and improve performance 30%.Oracle Application - E-Business Suite R12 and 11i.Experience on system study, design, development, post implementation maintenance and support of Oracle EBS.Experience good Knowledge/experience on Oracle EBS or any ERP.Expertise in configuring, administering, and troubleshooting Web logic domains, clusters and servers in distributed environments for SOA. Experienced in data analysis, data modeling, development, testing and documentation of Projects.Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.Experience in application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.Experience in SQL performance using Rule Based Optimization (RBO).Experience in SQL performance tuning using Cost-Based Optimization (CBO).Extensively worked in Client-Server application development using Oracle 11g/10g/9i/8i Forms 9i/6i, Reports 10g/6i/6.0, SQL, PL/SQL, Oracle 9iDS, Oracle Import and Export Utilities.Very strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing PL/SQL code, modifying database parameters.Expertise in performing Data export, Import and various operations using TOAD.Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by Oracle.Good understanding of Oracle Data Dictionary and Normalization Techniques.Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database Triggers, Shell- Scripts and SQL Loader scripts.Over 6+ Years of Software Development Life Cycle experience in Software Design, Development and Implementation of Oracle, SQL, PL/SQL applications.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |