SUMMARY

• Oracle Professional wif 7+ years of experience in Analysis, Design, Development, testing, Production Support, Implementation and maintenance of various software applications in Client/Server & Web applications using Oracle databases 11g/10g/9i/8i.
• Experience in RDBMS development including coding using SQL*Plus, Oracle SQL Developer, SQL*Loader, TOAD and good understanding of Oracle data dictionary.
• Experience in development of SQL Queries, Stored Procedures, Functions, Cursors, Triggers and Packages.
• Experience in development of database objects like tables, indexes, Materialized Views, Procedures and synonyms.
• Extensively involved in developing programs to import data from legacy system into oracle database using SQL*Loader.
• Experienced in handling different databases like Oracle, Ms Access and SQL Server 2000.
• Experience in Query Optimization, Debugging, Tuning and improvising performance of teh database, using teh Oracle tools like Oracle Hints, TKPROF and Explain Plan etc.
• Performance Tuning of database by creating and usage of indexes and gathering table and index statistics.
• Experience in advanced PL/SQL constructs like Oracle supplied Packages, Nested tables, Varrays, Records, Types, Dynamic SQL.
• Expertise in SQL and PL/SQL programming, in developing complex code units, Database Triggers and using teh latest features to optimize performance (Bulk Binds, Materialized views, Inline views).
• Experience in creating Forms and Reports using oracle tools like Oracle Forms (10g/6i/5.0/4.5) and Oracle Reports (10g/6i/3.0/2.5).
• Exposure to Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Expertise in Shell Scripting, setting teh cron tab jobs for automating production task and Autosys batch job processing in UNIX.
• Experience in writing Explicit Cursors and Handling Exceptions while developing teh applications.
• Demonstrated expertise in SDLC on various phases dat includes Requirements Analysis, Software Specifications, and High/Low Level Design, Testing and Deployment.
• Excellent analytical, problem solving, communication and inter - personal skills to manage and interact wif individuals at all levels.

TECHNICAL SKILLS

Oracle Tools: PL/SQL, Forms Builder, Reports Builder, Schema Builder, Procedure Builder, UTL FILE, SQL*LOADER, SQL Trace, Export, Import, Oracle Query Builder, SQL Navigator, SQL *Plus, Erwin, TOAD, VI Editor, Win Runner.

Languages: SQL, PL/SQL, T-SQL, C, C++, Java, HTML, COBOL, XML, UNIX, Shell, PERL.

Operating Systems: UNIX, Windows 2000/2003/XP/ 98/95/Vista/07, LINUX.

RDBMS: Oracle 11g/10g/9i/8i/7.x, SQL Server and Ms-Access.

GUI: Developer/2000 Forms 9i/6i/5.0/4.5,Reports 9i/6i/3.0/2.5, VB.

Testing Tool: Win Runner, QTP, Load Runner.

Version control tools: Subversion, Clear Case, MS Visual Source Safe.

Protocols: HTTP, TCP/IP, FTP.

Office Tools: MS Word, Excel, Power Point, Visio, UML, Erwin, MS Project.

Reporting Tools: Crystal Reports, Oracle Reports & Excel Reports.

ETL Tools: Informatica 9.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Oracle developer

Responsibilities:

• Worked on Daily Refresh project to capture and transform teh daily transactions dat move from Legacy to teh Vision Integration Platform (VIP) system.
• Review and understand teh Business Requirements, ER diagrams, HLDs and LLDs.
• AGILE SCRUM process is followed during developing and maintenance phase.
• Participated in daily scrum meetings to update progress.
• Supported development and test environments and production environments.
• Coordinate wif teh Business Analyst and ETL development team.
• Understand teh overall functionality of VIP and Conversion process and prepare teh test data.
• Gatheird and documented business requirements. Created teh initial conceptual design and entity relationship diagrams and created teh database objects.
• Developed sql scripts for Extraction, transformation and Loading of Data and also using Informatica and designed, developed source Entities for Oracle.
• Write and execute SQL queries, Stored Procedures to validate data flow from Source to Target tables as part of conversion for different clients and counties.
• Developed Stored Procedures for various validations while inserting data into teh tables and developed PL/SQL Packages for incorporating teh business rules.
• Worked on various backend Procedures, Functions and Cursors.
• Wrote PL/SQL procedures & triggers to validate database records.
• Developed many PL/SQL Triggers to monitor teh database activities and to implement some database constraints.
• Wrote Scheduler Scripts in UNIX to run teh developed PL/SQL scripts.
• Created various SQL and PL/SQL scripts for verification of teh required functionalities.
• Oracle PL/SQL procedures used for migrating data between teh schemas.
• Developing control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.
• Involved in teh development of teh entity relationship diagrams for teh source and target tables.
• Involved in performance tuning teh application. Analyzed results to tune SQL for improved performance of teh stored procedures and created indexes on tables on a case-by-case basis.
• Used bitmap indexes and partition tables to optimize teh queries.
• Application tuning for slow running queries using Explain plan (Auto trace).
• Involved in Database Testing (Oracle), loaded teh test data into Oracle database by writing SQL queries and PL/SQL procedures.
• Set up scenarios and related datasets for weekly batch tests and reported/fixed issues encountered.
• Used Toad to rerun queries for database validation of updates.
• Wrote automated test scripts for GUI, Functional, Data Driven, User acceptance and Regression tests using Win Runner.

Environment: Oracle 10g/11g, SQL, PL/SQL SQL*PLUS, Putty, SQL*Loader, TOAD, SQL Developer, Linux, UNIX, Windows 7, Informatica 9.0.1, Subversion.

Confidential, Louisville, KY

Oracle developer / Report Developer

Responsibilities:

• Interacting wif teh Business Users and Project Management for analyzing teh business needs and develop Design Specification.
• Created numerous web based Forms and Reports using Oracle Developer 6i.
• Involved in teh Implementation of Agile(SCRUM) Methodology for teh Application process development, and also was a team player in completing tasks in a Sprint/ product backlog.
• Upgraded Older Version Forms and Reports to Forms 6.0/Reports 6.0
• Designed and developed procedures and functions and encapsulated intoPL/SQLpackages to extract teh data specific to customers like customer plan, plan type, coverage TEMPeffective date, and premium amount.
• Expertise in creating Packages, functions and triggers in teh database to explicitly handle various feeds
• Worked extensively inOracle Toolslike Oracle Reports 10g /Forms 10g.
• Developed Pharmacy, Utilization Summary, Medical Trend scorecard, Large Claimants, Clinical info Reports involving complex graphs (Bubble Graph, Dual Y bar Graph) and modified teh existing SQL reports using Oracle Reports 10g.
• Developed DDL Scripts for Database Objectslike Tables, Views, synonyms, sequences, Indexes etc.
• Skills and experience in a very-large-database environment (VLDB).
• Involved in teh optimization of query performances usingOracle Hints, SQL Trace/Tk Prof,Explain Plan,partitioningof tables and creating indexes
• DevelopedSQL Loaderscripts and PL/SQL statements to extract data from teh legacy application in teh form of flat files and load teh extracted data into teh new application.
• Worked wif front end application developers wif their queries/stored procedures while building User-Interface for teh project.
• Worked on PL/SQL tools like TOAD, VI Editor to run SQL queries to validate teh data.
• Assisted in modifyingexisting web application GUI as per teh need from teh look and feel point of view using HTML, Java script.
• Adept Knowledge in using teh tool Oracle Applications Express (OracleAPEX) 3.0 for building interactive webApplications.
• Worked on FTP extensively by using teh manual process and also using teh FTP tools.
• Developed and modified several UNIXshell scripts, and managed importantAUTOSYS/CRONTABjobs
• Involved in maintaining theVSS check inandcheck outfrom VSS and updating teh design documents for teh code changes. Also designed Flow Diagrams using MS Visio.

Environment: Oracle 9i/10g/11g, SQL, SQL*PLUS, SQL*Loader, TOAD, VI Editor, SQL Developer, PL/SQL, Oracle Reports6i, UNIX.

Confidential, Florence, SC

Oracle Consultant

Responsibilities:

• Gathering teh requirements from teh business users and analyzing them to implement.
• Analyzing teh business needs to make it better TEMPthan what it is now.
• Creating and implementing teh various interface programs dat act as integration tools between teh different systems.
• Extracted teh data from teh legacy systems and performed teh validation of data.
• Extracted data from legacy systems to create new reports to support teh business users’ activities in teh system.
• Maintaining teh data to be available to generate reports on back end tables.
• Created teh various processes dat are integrated wif teh front end tools for various purposes.
• Extensively used teh Procedures, Functions, Views, Materialized views, Packages, Triggers, and Indexes etc to fulfill teh business requirements.
• Created teh various Shell scripts to interact wif teh back-end databases.
• Extracted teh data from various servers by using UNIX commands and performed teh data validations.
• Automated teh various jobs to run on teh servers on specific day and time.
• Scheduling teh various jobs and testing them until it will work fine in teh production.
• Developed teh various scripts to read and write teh data to files.
• Upgraded teh current version of teh system to higher levels.
• Performed teh tuning of queries to run faster and get teh data from back-end tables.
• Created and tested various complex reports in different styles in oracle 10g.
• Developed teh reports to view account holders’ expenditure to track teh most valuable customers’ needs.
• Reports showing Credit card issuing rates and demand for credit cards were created and deployed on server.
• Customized teh various reports to meet new requirements.

Environment: UNIX, Windows NT, Oracle 10g/9i, SQL, PL/SQL, TOAD, Erwin, SQL *Plus, SQL*Loader, Forms6i, Reports 6i,JSP, HTML, Xml.

Confidential, Portland, Oregon

Oracle Developer

Responsibilities:

• Involved in different phases of System Development Life Cycle (SDLC).
• Created PL/SQL packages, procedures and functions dat extensively used PL/SQL cursors, exception handling. Developed complex SQL and PL/SQL queries using joins, sub queries, and correlated sub queries.
• Contributed in developing, testing and migration of oracle objects from development to testing and production environments.
• Used ERWIN for logical and physical database modeling and database scripts.
• Involved in optimization process through creation of partition tables, views, indexes etc. Also tuned and optimized SQL statements.
• Used Ultra Edit, SQL*Loader to validate and load data from flat files using both teh direct path as well as teh conventional path.
• Developed and fine-tuned PL/SQL stored procedures to increase teh performance.
• Developed database triggers to enforce security. Also implemented materialized views for remote instances.
• Fine tuned SQL for teh maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and SQL Trace sessions.
• Generated UNIX Shell scripts to automate jobs and loading process for staging, transformation and loading of teh data into base tables.
• DBMS utilities were used to extend teh functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL FILE to read and write from database to generate data file, DBMS SQL to write Dynamic SQL etc.
• Involved in customizing existing forms and developed forms using Oracle Forms 6i and also developed reports using Reports 6i based on business requirements.
• Performed unit and integration testing. Wrote test plans and test cases for performing testing on developed features and dat modifications have no adverse impact on overall system.
• Planned version control of production source code using Concurrent Version System (CVS).
• Participated in unit testing and prepared unit test documents.
• Involved in supporting/fixing post production defect fixes.
• Attended Design meetings, code review and test review meetings.
• Interacted and communicated wif team members to solve/resolve issues.

Environment: Oracle 9i, UTL, SQL Developer, Forms 6i, SQL Plus, Reports 6i, SQL, PL/SQL, TOAD 7.0, SQL * Loader, Windows XP, UNIX.

Confidential

Oracle Programmer/Analyst

Responsibilities:

• Involved in gathering user requirements.
• Teh project involved detailed design using E-R Diagrams, Data Flow Diagrams, Data Dictionary, and System flow Charts.
• Wrote PL/SQL packages consisting of procedures and functions.
• Created Views, Triggers, Sequences.
• Involved in teh Design of User interfaces
• Involved in tuning database and SQL statements and schemas for optimal performance.
• Query Optimization and tuning of database.
• Utilized tools like TOAD during development of teh application.
• Involved in direct discussion wif teh End-Users to study teh system requirement and develop Functional and Technical specifications to meet their requirements.

Environment: Oracle 8i, SQL, PL/SQL, SQL*PLUS, TOAD and Windows 2000.

Confidential

Oracle Developer

Responsibilities:

• Wrote stored procedure and triggers.
• Developed Stored Procedures for various validations while inserting data into teh tables and developed PL/SQL Packages for incorporating teh business rules.
• Developed many PL/SQL Triggers to monitor teh database activities and to implement some database constraints.
• Developed PL/SQL Functions, Cursors for various calculations in teh application.
• Used bitmap indexes, materialized views and partition tables to optimize teh queries.
• Reviewing user application requirements.
• Developed GUI forms (screens) in Visual Basic according to teh user requirements.
• Application tuning for slow running queries using TKPROF, Explain plan (Auto trace).
• Involved in Database Testing (Oracle), loaded teh test data into Oracle database by writing SQL queries and PL/SQL procedures.
• Set up scenarios and related datasets for weekly batch tests and reported/fixed issues encountered.
• Involved in teh code walk through, Involved in creating Process workflow using Visio.
• Analyzed teh business requirements and wrote Test Plans.
• Used Toad to rerun queries for database validation of updates.
• Wrote automated test scripts for GUI, Functional, Data Driven, User acceptance and Regression tests using Win Runner.
• Developed Test Scenarios, Test Process Flows and DTC’s (Detail Test Conditions).
• Involved in System Interface Testing, Regression Testing, Exception Testing, and Product Testing on corporate releases.

Environment: Oracle 8i, Developer/2000 (Forms 6i, Reports 6i), PL/SQL, Win Runner, Quick Test Professional, SQL*Plus, Reports, SQL *Loader, Win NT, Visual Basic 6.0, WINDOWS and LINUX.

Confidential

Oracle Developer

Responsibilities:

• Involved in gathering user requirements.
• Teh project involved detailed design using E-R Diagrams, Data Flow Diagrams, Data Dictionary, and System flow Charts.
• Wrote PL/SQL packages consisting of procedures and functions.
• Created Views, Triggers, Sequences.
• Involved in teh Design of User interfaces
• Involved in tuning database and SQL statements and schemas for optimal performance.
• Query Optimization and tuning of database.
• Utilized tools like TOAD during development of teh application.
• Involved in direct discussion wif teh End-Users to study teh system requirement and develop Functional and Technical specifications to meet their requirements.

Environment: Oracle 8i, SQL, PL/SQL, SQL*PLUS, TOAD, and Windows 2000.