Recruiters Blog: Excellent oracle forms and reports consultant available immediately

Sep 10, 2009

Excellent oracle forms and reports consultant available immediately

Thanks & Regards,

vic

contact:732-410-2100x202

Email: vic@sunmergesystems.com

Gtalk:vikramsunmerge@gmail.com

Ymsgr:vikramsunmerge@yahoo.com

Professional Summary

· Over 8 years of experience in analysis, design, Application Development and Production Support using Oracle SQL, PL/SQL and UNIX.

· Excellent working and conceptual knowledge of SQL, PL/SQL, Oracle Forms 10g/6i/4.5 and Oracle Reports10g/6i/2.5, C, Java, UNIX Shell Scripting, XML and HTML.

· Involved in all the phases of SDLC - Analysis and Design, Data Modeling - ER Diagrams and Normalization, System Testing, Development, documentation and implementation on both Client/Server as well as Web-based applications.

· Experienced in Finance, Pharmacy, Banking and Insurance domains.

· Proficient in developing Oracle PL/SQL Packages, Stored procedures, Functions, Triggers and Cursors. Also developed various applications using Oracle in-built packages

· Extensive Working Experience in Toad.

· Extensively used PL/SQL to built Oracle Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Views and Materialized Views for processing data.

· Used DBMS utility packages like DBMS_XMLGEN and UTL_FILE to generate XML Files for interfaces with other system.

· Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL.

· Data Conversion from Flat files to Oracle database using Oracle SQL* Loader.

· Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Partitioning and Indexes

· Performance tuning using Explain Plan, SQL-Trace, TK-Prof oracle utilities and creating relevant system and users documentation.

· Hands on Experience in UNIX Platform (HP-UX, AIX, Solaris) and expertise in Shell scripting Programming.

· Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema & Snowflake Schema used in dimensional modeling.

· Data modeling and Design using Erwin and MS Visio.

· Worked on Production Support, receiving production calls on troubleshooting the application and resolve bugs.

· Strong experience in client interaction and understanding business application, business data flow and data elements.

· Ability to work in teams and independently with minimal supervision to meet deadlines.

· Good communication, analytical and Interpersonal skills.

Technical skills:

Database : Oracle 10g/9i/8i/7.3, MS SQL Server, Sybase, MS-Access

Languages : SQL, PL/SQL, C, Java/J2EE, VB, XML, HTML, Shell Script.

Oracle GUI Tools : Oracle Forms 10g/6i/4.5,Reports 10g/6i/2.5,Discoverer 10g/6i

SQL Utilities : TKPROF, SQL*Loader, Export, Import

Reporting Tools : Cognos 7.3, Business Objects XI/6.5

Office Applications : Microsoft Office 2003/XP/2000/97 (Word, Excel, PowerPoint)