Application Developer Resume

SUMMARY:

Information Technology Professional with over 7 years of experience in Application development and Production support using Oracle SQL, PL/SQL, Forms and reports.
Good Experience in Software Development Life Cycle (SDLC) including analysis, logical design, Resource Planning, code development, testing, implanting and maintenance.
Subject Matter Expert in Oracle PL/SQL, Forms and Reports.
Strong Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
Expert in backend programming using PL/SQL and SQL.
Strong Experience writing interfaces, triggers, stored procedures and PL/SQL packages to provide database access and manipulate functionality.
Expert in Creating PL/SQL procedures, packages, functions, database triggers and other database objects like Lob’s to generate back-end and front-end reports.
Experience in Application Development using Forms, Reports and Discoverer.
Expert in Oracle Application Server 10g administration and installation.
Extensive experience in design and modeling database-using Designer/2000, Erwin.
Extensive experience in Relational Data Base Management Systems (RDBMS).
Strong experience in Oracle Workflows.
Knowledge in design, connectivity, basic usage of (Oracle, SQL, DB2)
Extensive web knowledge (html, .asp, mod/pl-sql)
Extensive experience on Designer-2000.
Basic DBA activities like creating of databases, users and table spaces and Logical export and Import. SQL loader, DB links, Materialized view creation, index creation and fine-tune queries.
Experience in Preparing of Checklists, identification of Test Cases, preparing Test Plans according to IEEE standards.
Knowledge in PRO*C.
Experience in SQR and Hyperion Reporting.
Through understanding in data warehousing concepts.
Experience in Migration oracle DB forms, Reports for 6i/7i/8i/9i and 10g versions.
Designed and developed various applications using oracle products/tools for process of automations software into database server using UNIX shell scripts, Perl scripts PL/SQL packages, procedures and database triggers based on client/server and multi-tier technologies.
Experience in using SQL *Loader and External Tables for Export/Import of data.
Experience using TOAD, SQL developer under UNIX and Windows NT/2000/XP/Vista, Sun Solaris operating systems.
Involved in writing complex queries to generate reports as per client requests as part of
production support.
Experience in optimization of SQL statements using Techniques like cost based and Role based optimization and accordingly Generated Explain plan.
Knowledge in DBA activities like creating of databases, users and table spaces, partitions, Indexes, constraints and permissions.
Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE,OEM etc.
Extensive use of TOAD for extracting scripts from the dictionary..
Extensively worked on Onsite-Offshore models. Participated in Requirements gathering onsite and transferred the knowledge to offshore.
Improve the performance of the slow SQL queries by implementing proper Index, using
FORALL and BULK COLLECT.
Use of Sequences to automate number generation.
Knowledge of Partitioned Tables & Indexes, creating Object types, LOBs.
Database design, E-R diagrams, Logical, Physical layout design using Erwin.
Schedule jobs via oracle jobs/TWS.
Use of LOVs, RG, Alerts, Object groups and other important features of Oracle Forms.
Knowledge in rapid sql, ER studio.
Strong experience in working with multiple projects in high pressure environment.
Excellent verbal and written communication and presentation skills and Strong interpersonal skills, ability to interact with people at all levels.

TECHNICAL SKILLS:

Languages

SQL, PL/SQL,T-SQL C, C++, Cognos, JAVA, Pro*C, HTML,.net XML

Databases

Oracle 6i/8i/9i/10g, SQL Server 2000, MS Access, RDBMS

Utilities

TOAD, SQL Navigator, SQL* PLUS, SQL*Loader

Operating Systems

Windows 95/98, Windows 2000/XP/ NT, UNIX, Sun Solaris, AIX

Tools

MS-Office 2000, MS-Excel, Outlook, IIS6.0, Visio, Designer 2000, Erwin, Crystal reports XI, ORACLE APEX

GUI\'s

Oracle Forms and Reports 6i/9i/10g, Developer2000, Portal

Casetools

Designer2000

Data Modelling

Erwin 4.0/3.5,Eagle Pace, Snow flake

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship