gaqsoc.blogg.se - Pl sql developer resume 2 years experience

Other Skills:Oracle Applications 11i- Oracle Projects (Project Accounting)Ĭlient: Confidential, CT Oracle PL/SQL Developer January 2007-August 2009 Roles and Responsibilities: Tools:Oracle SQL*Plus, Forms/Reports 9i/6i/2000, Discoverer 3.1, MicroStrategy, Cognos, SQL Navigator, VI Editor, TOAD, Crystal Reports, PowerBuilder, Business Objects, NetBeans, MS Visual C#, Mathcad, Eclipse, MS Project, Samba Languages:PL/SQL, SQL, XML/HTML, Unix Shell Script, C++/C,Java, C# Operating Systems: Windows XP/2000/98, HP-UX, LINUX (Fedora 4.0), MS-DOSĭBMS:Oracle 10g/9i/8i, MS SQL Server 2005/2000, MS Access Performed dimensional modeling and have very good understanding of Data Warehouse Techniques using MicroStrategy and Cognos.

Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables.Performance Tuning of Oracle Applications using TKPROF.Created programs to transform data from Legacy systems into Oracle database.Used Materialized Views, Packages and Dynamic SQL.Automated SQL*Loader to load the data from the flat files.Used SQL*Loader, Import/Export, UTL_FILE, DBMS_XMLQUERY, DBMS_PIPE and other Oracle built-in packages.Wrote Audit programs for data consistency check and validation.Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization.Granted resources, privileges and roles to users.

Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, synonyms.

Applied Database Tuning and Optimization, Normalization in the new database design.

Created logical and physical Database Design, data structures, Data Modeling, Schema Design.

Feasibility study, planning, implementation, testing, deployment and close-out.

Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing.

Over 2 years of experience in DW/ETL Technologies.Ĭreated Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment 5+ years of experience with expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment using Client/Server.