SUMMARY:

• Around 6+ years of professional IT experience in Oracle environment in all aspects of Software Development Life Cycle (SDLC) - in Data Modeling, Designing, Developing, and maintaining database related applications.
• Extensive knowledge and work experience in System Analysis, design and development of database applications in Client/Server applications using Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Loader.
• Proficient in developing concurrent programs using SQL, PL/SQL and UNIX Shell Scripting.
• Experienced in developing Master-Detail and Transaction Forms in Oracle Forms Builder (6i/10g
• Experienced in developing Simple and Matrix reports in Oracle Reports Builder (6i/10g) on Windows and Linux platforms.
• Proficient in PL/SQL programming - Stored Procedures, Functions and Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers,
• Experienced with SQL performance tuning and optimization using execution plans.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Hands-on experience with Oracle Reports, SQL, PL/SQL, Open Interfaces, and APIs.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills and a Very Good Team Player.
• Ability, willingness, and passion to learn new technologies and acclimatize to diverse work cultures.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UNIX and UNIX Shell Scripting, C, C++, Java,.NET, HTML, XML, VXML, WML, Visual Basic 6.0

Operating Systems: HP-UNIX, Windows 98/2000/NT/XP, Linux, MS DOS, MAC OS

GUI: Oracle Forms 6i/9i, Oracle Reports 6i/9i, Developer 2K, Discoverer 9i

RDBMS: Oracle 7.3/8/8i/9i/10g, Sybase 11.x, MS Access

Oracle Apps: Financials - Accounts Payable (AP), General Ledger (GL); System Administration

Tools: Toad, SQL Navigator, SQL*Plus, SQL*Loader, Import, Export, HP Quality Center 9.2, IBM Data Stage 8.1.2, Talend Open Studio 4.1.2.

Modeling Tools: DIA, UML, Rational Rose

Statistical Packages: SPSS, SAS

Web Packages: MS FrontPage, Dreamweaver MX, Photoshop

Servers: ApacheTomcat4.2, IIS

PROFESSIONAL EXPERIENCE:

Confidential, Sanjose,CA

Oracle Pl/SQL Developer

Responsibilities:

• Worked for designing Logical and Physical data models for Master Data and Transactional Data.
• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Data modeling for client specific requirements.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Developed complex queries on SAP data and developed PL/SQL procedures to give in nice strategic plans to higher level of management.
• Understanding the flow of data from end to end and developed packages.
• Loaded the oracle tables using csv/txt files .had good experience on excel.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
• Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
• Developed PL/SQL scripts for Data cleansing.
• Made timely changes and fixes to all the modules on reported problems from the database administrator.
• Used TOAD, PL/SQL developer tools for faster application development.
• Performed SQL tuning using Explain Plan, Hints and indexes.

Jr.Oracle Applications Developer

Responsibilities:

• Worked in service billing contracts project .
• Changed the reports according to the requirements coming from business and implemented the logic on worldwide reports.
• Used the BI publisher and oracle reports to implement the report changes.
• Created triggers on oracles tables.
• Check the functionality of data in the front-end whether it is displaying properly or not.

Environment: BI Publisher, Oracle Reports, Sql Developer, Oracle 11g, PL/SQL, TOAD and Windows

Oracle Developer

Responsibilities:

• Worked in migrating UFCW claims and benefits tool from Desktop version to Browser Version using PL\SQL Procedures and Functions.
• Recreated many stored procedures to meet the business requirements like claim details, benefits details, pension details and member details etc.
• Supported users with many adhoc SQL reports
• Generated many validation scripts for testing browser version
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Processing and filtering member files using UNIX scripting(KORN SHELL)
• Worked on generating different formats file outputs like CSV, XML, EXCEL, TXT using UTL File package
• Good exposure onto Performance tuning activities

Environment: PLSql Developer, Oracle 11g, PL/SQL, Windows, Excel, Access

Oracle Pl/SQL Developer

Responsibilities:

• Created data mapping files for the data coming from different web services.
• Worked for designing Logical and Physical data models for Master Data and Transactional Data. knowledge and experience in structured systems analysis and design techniques
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Worked with ETL team and architect to build data model for staging area.
• Did performance tuning of PL/SQL code of a stored procedure which migrates data from source table with multi-million records to destination table and reduced migration time from over 3 hours to 45 minutes using Bulk Collect and Bulk Bind (FORALL) features with collections. Performed SQL Query tuning by using hints in DML statements.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support
• Performed SQL tuning using Explain Plan, Hints and indexes
• Involved in handling the batch jobs using UNIX shell scripting.
• Responsible for performing code reviews.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Utilized SQL*Loader to load flat files into database tables.
• Created data validation test cases and test scripts for Unit Testing and Integration Testing and documented the same.

Environment: Oracle 11g/10g, SQL, PL/SQL, Toad, Oracle RDBMS, SQL Developer.

Oracle Pl/SQL Developer

Responsibilities:

• Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Worked on various backend Procedures and Functions using PL/SQL.
• Developed the forms and Reports as per the requirements.
• Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.
• Involved in Shell scripts to automate the loading, balancing and extraction process
• Check the functionality of data in the front-end whether it is displaying properly or not.
• Managing Version Control Tool like Clear Case and Start Team.
• Developed SQL scripts to be used for producing ad hoc reports in Enterprise Data Warehousing & Reporting environment as well as in Oracle Apps as concurrent programs.

Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, TOAD, Java, HTML, MS Office