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, 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) Operating System : Sun Solaris10, Red Hat Linux 6, Windows XP/2000/NT/98 Scheduling Tools : Control-M, Autosys ER Design : ERWIN, MS Visio Query Tools : SQL Developer 1.5, SQL Navigator, TOAD 8.x/7.x, SQL*PLUS Version Control : PVCS7.0, CVS, VSS |