Oracle Database Developer,

Roop A

Oracle Developer

Email: *******@*****.*** Phone: 559-***-****

Professional Summary

• Over 2 years of experience as a Software Programmer and Oracle PL/SQL Developer/Programmer.

• Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.

• Strong in using tools such as TOAD, Benthic, SQL*Plus, SQL Developer and SQL*Loader.

• Experience using Bulk processing, ETL operations, REF cursors, collections, DBMS packages.

• Extensive experience in Analysis and Design of Database. Created ER Diagrams on ERwin, Microsoft Visio and SmartDraw using Normalization Techniques.

• Experience in schema structure design and involved in estimation and optimization of data storage.

• Experience in utilizing Oracle tools and methods like the use of External Tables, merge statement, Pipelined functions.

• Expert in Performance Tuning & Query Optimization of SQL statements using EXPLAIN PLAN, SQLTRACE, TKPROF and HINTS.

• Comfortable with working with Composite Data Types.

• Experience in Debugging, Testing, and Deploying the Applications.

• Experience in different phases of Software Development Life Cycle which include Analysis, Design, Development and Testing.

• Successfully utilized performance enhancements features of Oracle to optimize the batch processes.

• Strong technical aptitude, ability to rapidly assimilate and design practical applications of new technology.

• Good team player and ability to work independently.

• Excellent logical and analytical skills, enthusiastic, excellent interpersonal & communication skills.

• Commitment to excellence proven by an outstanding career track.

Technical Skills

• Databases: Oracle 9i/10g, MS-SQL Server 2008, 2005 & 2000, MS-Access.

• Database Tools: Toad, SQL * Plus, Benthic.

• ETL Tools: Informatica 7.x, 8.x

• OS: Windows Vista, Windows 2000/2003/NT/XP professional.

• Web Design Tools: Adobe Dreamweaver CS3, Eclipse, XML Notepad.

• Management Tools: MS Project 2007, Visual Project Maps.

• Documentation: MS Office 2003, MS Office 2007.

• Other tools: Microsoft Visual Studio 2003/2005, Microsoft Visio.

Education

• Masters in Computer Information Systems from University of Denver, CO.

• Bachelor of Engineering from Anna University, Chennai, India.

Relevant Courses

• Database Design and Programming, T-SQL Programming, Perl, Website Design and Management, .NET Technologies, C#, Basic knowledge in TCP/IP, Network Management Systems, Computer Architecture, Enterprise Architecture, Software Engineering, IS Project Management, Customer Relationship Management, XML Programming, Object Oriented Programming, Data-warehousing Concepts.

Professional Experience

o Client: Virtela Communications, Denver, CO Jul ‘09 – Till Date

Oracle PL/SQL Developer

Virtela is a premier global network integrator, enabling business solutions for multinational organizations. They design, build and manage complete network solutions to meet customer’s global requirements in the most competitive ways possible. This project is aimed to improve the services provided by Virtela. It includes handling client requests, failure of connectivity, security services and overall performance.

Responsibilities:

• Created Database Objects such as indexes, sequences, synonyms, materialized views, PL/SQL packages and procedures.

• Designed and Developed GUI front-end using Oracle Forms 9i for User interaction with the database.

• Wrote stored procedures/functions/packages/triggers while developing forms.

• Wrote PL/SQL procedures for creating batch processes, used to calculate claim information and summarize data which run at the end of each month.

• Conducted extensive performance tuning using TKPROF utilities.

• Developed various reports using Oracle Reports 9i.

• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting.

• Involved in the Analysis and Data Modeling of Logical to Physical data models.

• Wrote Pipelined functions to migrate data from the External tables into the oracle Database.

• Analyzed the whole process flow, log files, error files, locations and descriptions, PL/SQL packages, process codes and descriptions.

• Involved in Code Review and User Acceptance Testing (UAT) of the application.

• Tested new enhancements and fixed various bugs before Deployment into the Production environment.

• Involved in creating System documentation such as Technical Specification, Unit Test Plan, System Flow Diagram and Data Flow Diagram using MS-Word, Visio.

• Involved in preparing functional specifications, release notes and other documentation.

Environment:

Oracle 9i, Oracle Forms 9i, Oracle Reports 9i, SQL *Loader, Oracle Tuning Pack, Erwin, Toad, Visio, ETL, Perl, Visio, HTML and UNIX.

o Sky Medical Tourism, Chennai, India Jun ‘07- Dec ‘07

Oracle PL/SQL DeveloperJr.

Sky Medical provides access to world-class Provider Network- connecting to a network of hospitals and healthcare solutions on the globe. Database consist information regarding specialty hospitals in domestic and international chain, doctors, enquiries and providers data.

Responsibilities:

• Developed Stored procedures, Functions, Packages and Triggers.

• Wrote PL/SQL procedures for creating batch processes, used to calculate claim information and summarize data which run at the end of each month.

• Involved in the Analysis and Data Modeling of Logical to Physical data models.

• Developed various PL/SQL procedures, using Oracle's features such as Bulk binding/Bulk collection, REF Cursors, Dynamic SQL, Nested Loops and VARRAYS.

• Analyzed the whole process flow, log files, error files, locations and descriptions, PL/SQL packages, process codes and descriptions.

• Involved in Code Review and User Acceptance Testing (UAT) of the application.

• Tested new enhancements and fixed various bugs before Deployment into the Production environment.

• Involved in creating System documentation such as Technical Specification, Unit Test Plan, System Flow Diagram and Data Flow Diagram using MS-Word, Visio.

• Involved in preparing functional specifications, release notes and other documentation.

• Troubleshoot business critical applications using Siebel.

Environment: Oracle 10g, Benthic, Toad, Erwin, Visio, HTML, Java and Windows XP.

o Access Technologies, Chennai, India Aug ‘06 – Feb ’07

The assignment involves performance improvement of the product, deploying the developed product at the client side with user configurations, developing new components as per the client requirements and resolving implementation problems.

Responsibilities:

• Installed and configured Oracle 9i/8i.

• Analysis, Design of the Database Model using Erwin, Definition of Data Model, Data Flow, Functional Hierarchy, Entities & Relations, Prepare Layout Formats.

• Involved in the design meeting for designing DB for the system.

• Created Tables, Views, Constrains, Synonyms, Sequences.

• Designed & Developed PL/SQL procedures, functions & packages to modularize and interface from web.

• Created Materialized Views.

• Created and used DB-Links to connect to other local & QA databases.

• Solved implementation problems in PL/SQL and database related issued with ETA less than 30 minutes.

• Provided hands on support to users.

• Involved in a team which provided training to all IAS officers in secretariat.

• Coordinated with different vendors to resolve any manufacturing or part issues.

• Developed new functionality to the existing application as part of change requests.

• Developed a tool for configuring base data setup and access control levels in the system.

• Documented the change requests and submitted to change control team.

Environment: Oracle9i, Forms 4.5, Reports 3.0, SQL*Plus, PL/SQL 2.3, Windows NT.

References

Available upon request

Contact this candidate