SUMMARY

• Around 5+ years of experience in Analysis, design and development of database application.
• Experience in requirement analysis, coding and testing various modules in a software development life cycle (SDLC).
• Experience of working on Informatica Power center ( Mapping creation & Transformation)
• Experience in Client - Server application development using Oracle 11g/10g/9i.
• Experience in writing Stored Procedures, Triggers, Functions, Packages, Cursors using SQL and PL/SQL.
• Develop solutions to improve the performance and management of applications.
• Experience in developing various data models using SQL Developer Data Modeler, Erwin and MS Visio.
• Experience in Performance Tuning and Optimization techniques of SQL query statements using Explain Plan.
• Extensive knowledge of using DBMS Oracle supplied package.
• Experience using the latest features to optimize performance like Bulk Binds, Bulk collect, Inline views, Global Temporary Tables.
• Extensive experience in writing REF Cursors, Records, PL/SQL tables & Exception handlers.
• Experience using External Tables to read the flat file and log files into database.
• Experience with DATAPUMP utilities like EXPDP/IMPDP.
• Experience of working with different date models like PDM, LDM.
• Worked closely with DBAs for issues related to database setup & tuning, data fixes, code changes and code testing.
• Proficient in writing and tuning complex SQL statements, complex joins, sub-queries
• Strong understanding of Data Warehouse Concepts.
• Strong analytical, technical, Research, general business and functional skills, and good interpersonal skills, is self-motivated and a good team player.
• Working independently showed ability to absorb the development needs and perform the jobs successfully within the given timeframes.
• Excellent communication and interpersonal skills, with the ability to handle responsibilities individually or as part of a team environment.

TECHNICAL SKILLS

Databases: Oracle 11g, 10g, Oracle 9i.

Utilities: SQL * Loader, Export / Import, Explain plan.

Languages/Editor: SQL, PL/SQL, Shell Scripting

Tools: SQL * Plus, SQL Developer, Erwin Data Modeler, Toad, Oracle Report, Informatica Power center.

Operating Systems: UNIX, Linux, Windows NT/2003, Windows XP.

Project Management: Microsoft Office Excel, PowerPoint, Word, Visio

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Oracle PL/SQL Developer

Responsibilities:

• Actively Involved in Business Requirement, Technical Requirement, Detail Design, Development & Testing Phases of SDLC.
• Participation in weekly design reviews and walkthroughs with project manager and development team.
• Developed database objects like tables, views, indexes, triggers, stored procedures.
• Used SQL*Loader scripts to load the flat files into the Oracle Database.
• Worked on UNIX Shell Scripting for Scheduling Batch Jobs.
• Wrote complex SQL scripts and was responsible for Performance tuning of SQL Queries.
• Created Unit Test plans and involved in primary unit testing.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*PLUS, SQL*Loader, TOAD, Reports 10g, UNIX

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in Requirement Gathering and Business Analysis for creating a data warehouse
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML.
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.
• Monitored Workflows and Sessions using Workflow Monitor.
• Created complex mappings which involved Slowly Changing Dimensions.

Environment: Oracle 10g,Windows 2003, SQL Developer 1.1, Erwin Data Modeler, Informatica Power Center Tool

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Customized various Forms 10g and Reports 10g to make them user friendly and also based on the business Requirements for the client’s.
• Created PL/SQL procedures, functions and packages.
• Created and modified different Views as per requirement.
• Developed scripts to create tables, views, procedures, triggers and functions and executed them using SQL Developer.
• Created custom forms and reports using Toad
• Created indexes to improve the system performance
• Worked extensively on SQL queries to generate custom reports on a regular basis
• Improved the performance of the system by tuning queries
• Created database object using sql plus and executed them into Toad
• Involved in analysis of customer specifications

Environment: Oracle 10g,Windows 2003, SQL Developer 1.1, Oracle forms 10g,Oracle Reports 10g

Confidential

Oracle Developer

Responsibilities:

• Involved in gathering & analyzing database requirements.
• Created Logical and Physical Models using ERWIN Data modeler.
• Created SQL objects including tables, PL/SQL packages, Procedures, Functions, Triggers and Views
• Performed performance tuning and query optimization.
• Extracted data from Flat files to Oracle by using SQL* Loader.
• Managed tables, indexes, constraints, views sequences, synonyms and stored program units.
• Coded complex SQL queries to retrieve data from the database
• Involved in generate Oracle reports as per requirements.

Environment: Oracle 9i, Windows 2000, SQL Developer 1.1, Oracle forms 9i, Erwin Data Modeler