ORACLE PL/SQL DEVELOPER:

PROFESSIONAL SUMMARY

• 7 years of total experience as an Oracle PL/SQL Developer with design, development and
• Web based Client/Server architectures. Worked extensively on with Oracle 8i/9i, 10g/11g, PL/SQL, C/C , and HTML.
• Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, PL/SQL developer, SQL Navigator. Experience in designing ER diagrams, logical and physical Data Models. Use Case/Class /Sequence diagrams using tools like MS-Visio, Power Designer and Erwin
• Worked on export/import commands to move the structure and the data from development to production. Implemented the Usage of System Change Number SCN in order for getting the Flashback
• Database Having Good experience working with large kind of databases up to 10 terabytes of data. Extensive experience in performance monitoring and tuning in Oracle/MS SQL Server. Expertise in creating stored Procedures, functions packages, collections and bulk collections using PL/SQL. Experienced in optimization of SQL Statements using the Oracle 11g
• Worked on Oracle 10g Enterprise manager and Configured Listener and Network configuration.
• Optimization of SQL statements using SQL Trace, TKPROF and Explain Plan. Performance Tuning using various types of Hints, Partitioning and Indexes. Strong knowledge of the RDBMS concepts advanced Oracle queuing and Oracle Workflow. Deep understanding of Software Development Cycle SDLC and implemented various models like Spiral, Agile XP, SCRUM and Iterative models Interacted with Clients, Project Managers to gather the Business Requirements and
• developed the technical specification documents Good knowledge of UNIX, and Shell Scripting. Strong understanding of Data Warehousing Including Star Schema, Snowflake Schema and Extraction Transformation Loading ETL . Strong ETL experience in using Informatica Power Center 8.6.0/8.5.1/8.1/7.1/6.2/5.1, PowerMart, Power Exchange and Power connect.
• Assisted DBA in performing various DDL works like Creation of Schemas, tables, Indexes,
• Materialized Views, and Partitioning tables. Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions. Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents. Experience in Coordinating with offshore team on daily basis for project execution and Planning.
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Experience in Performance Tuning Optimization of SQL statements Extensively worked in Oracle database environments of up to 10 terabytes in size including Very large data set and partitioned data. Knowledge of Equity and Fixed Income business domain and also Knowledge of Market Data
• pertaining to Equity and Fixed Income. Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries Proficient in tuning queries used in the application. Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
• Experience in advanced PL/SQL concepts like Bulk collect and for all. Expertise in Dynamic SQL, Records, Arrays and Exception Handling. Possess excellent oral / written communication and interpersonal skills. Good ability to quickly grasp and master new concepts and technologies. Strong problem solving technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.

Confidential

Confidential, with 48 store locations between Austin and Houston Texas, and in Tennessee. We strive to be the most highly regarded T-Mobile Partner in the nation, with a focus around best-in-class sales and service.

ROLES AND RESPONSIBILITIES: Generate reports using oracle reports. Developed new complex stored procedures, packages, custom functions and triggers in oracle database. Develop new data warehouse tables and load data from different sources Analyze and configure databases for various database changes Extensively used SQL Loader to load data in the Extensively used UTL FILE to extract data into flat files from the database Used Data profiling to do source system analysis. Developed supported applications for company's client-server based strategic business systems integrate with existing applications Performance tuned SQL queries using Hints, AUTOTRACE, TKPROF, ADDM, AWR, Explain Plan and SQL advisor Used JDBC with Java for connection to database and run queries. Created Materialized views and presented to BI teams Performed bug verification, release testing and provided support for Oracle based applications Followed project plans and provide clear status of progress. May include participation in daily status meetings Participated in design meetings to gather user requirements from business units Followed the company software development life cycles and conform to best practices Reviewed business requirements, detailed software requirements and designs ENVIRONMENT: Oracle 10g,11g, Oracle Enterprise Manager 10g,WINDOWS , SQL, PL/SQL, SQL Developer and TOAD, Data pump, SQL Loader, VSS Outlook, and Unix.

Confidential

Confidential Provides a wide range of retail services geared toward revenue generation and product and services sell-through. Our expertise is in augmenting retail sales as a whole assisted sales, event sales, and kiosk sales and providing sales force management and retail consulting services.

ROLES AND RESPONSIBILITIES: Multiple oracle apex based Clients Projects - Designed, Delivered, Technical Lead role and hands on development Oracle Application Express 4.1/4.0/3.1, oracle 11.2.0. Functional and Technical understanding of the Telecom domain to validate the data. Extensively involved in writing procedures, functions, triggers and packages Involved in Analyzing and Performance Tuning of the SQL queries using optimizer hints for joins, parallelism and Explain plan. Involved in Unit Testing the codes. Involved in debugging and fixing the codes that had performance issues. Worked with the Table Partitions to further improve the performance while using tables containing large number of columns and rows. Used SQL LOADER to store data in the Oracle database from different types of flat files. ENVIRONMENT: Oracle10g, SQL, PL/SQL, TOAD, SQL LOADER, UNIX, Oracle Reports 10g, Forms10g, JAVA, ECLLIPSE, Linux, HTML, Lotus notes, PVCS.

Confidential

Confidential is an engineering design and construction firm and a U.S. federal government contractor. Headquartered in San Francisco, California, URS is a full-service, global organization with offices located in the Americas, Europe, Africa and Asia-Pacific.

ROLES AND RESPONSIBILITIES: Developed new complex stored procedures, packages, custom functions, triggers in oracle database. Extensively used SQL Loader to load data. Performance tuned SQL queries using Hints, AUTOTRACE, TKPROF, ADDM, AWR, Explain Plan and SQL advisor Performed bug verification, release testing and provided support for Oracle based applications. Correcting codes inside of the packages. Created Materialized views. Followed project plans and provide clear status of progress. May include participation in daily status meetings Participated in design meetings to gather user requirements from business units Followed the company software development life cycles and conform to best practices Reviewed business requirements, detailed software requirements and designs ENVIRONMENT: Oracle 10g,11g, Oracle Enterprise Manager 10g,WINDOWS , SQL, PL/SQL, SQL Developer and TOAD, Data pump, SQL Loader, VSS Outlook, and Unix scripting.

Confidential

• Confidential processes and systems components are essential for the success of this critical HealthCare initiative. The objective of Transformation Testing is to ensure the adequacy and accuracy of testing for each major component and release of Transformation. It will also
• ensure that sufficient testing has been done to show that Transformation meets its requirements as detailed in the business case and reflected in the design for each component.

ROLES AND RESPONSIBILITIES: Generate reports using oracle reports. Developed new complex stored procedures sometimes running up to 120 pages when printed , packages, custom functions and triggers in oracle database. Develop new data warehouse tables and load data from different sources Analyze and configure databases for various database changes Extensively used SQL Loader to load data in the Extensively used UTL FILE to extract data into flat files from the database Used Data profiling to do source system analysis. Developed supported applications for company's client-server based strategic business systems integrate with existing applications Performance tuned SQL queries using Hints, AUTOTRACE, TKPROF, ADDM, AWR, Explain Plan and SQL advisor Used JDBC with Java for connection to database and run queries. Created Materialized views and presented to BI teams Performed bug verification, release testing and provided support for Oracle based applications Followed project plans and provide clear status of progress. May include participation in daily status meetings Participated in design meetings to gather user requirements from business units Followed the company software development life cycles and conform to best practices Reviewed business requirements, detailed software requirements and designs ENVIRONMENT: Oracle 10g,11g, Oracle Enterprise Manager 10g,WINDOWS , SQL, PL/SQL, SQL Developer and TOAD, Data pump, SQL Loader, VSS Outlook, and OLAP/OLTP

Confidential

• Baxter Healthcare has numerous research laboratories and production facilities around the world. Each Facility may store thousands of chemicals in inventory. In conjunction with the installation of the Chemical Management System CMS , used for tracking chemical inventory, Baxter desires to utilize the services of Quality Assurance Analyst for testing the functionality and conduct users acceptance testing for the product CMS developed by ATRION.
• ROLES RESPONSIBILITIES Created PL/SQL interface Programs for data merging, log file generating and auto job scheduling using PL/SQL, UTL FILE and DBMS JOB Functional and Technical understanding of the Telecom domain to validate the data Extensively involved in writing procedures, functions, triggers and packages Involved in Analyzing and Performance Tuning of the SQL queries using optimizer hints for joins, parallelism and Explain plan Involved in debugging and fixing the codes that had performance issues Involved in Unit Testing the codes. Used Data profiling to do source system analysis. Worked with the Table Partitions to further improve the performance while using tables containing large number of columns and rows Used SQL LOADER to store data in the Oracle database from different types of flat files Involved in generating Ad-hoc reports and internal reports required for the analysis of the processes going on in the project and that are requested by the users Involved in running cron jobs at fixed times Involved in preparing technical documentation
• Worked closely with the testing team helping them in testing the codes ENVIRONMENT: Oracle10g, SQL, PL/SQL, TOAD, SQL LOADER, UNIX, Oracle Reports 10g, Forms10g, JAVA, ECLLIPSE, Linux, HTML, Lotus notes, PVCS, OLAP

Confidential

Confidential serving as an administrator in the individual health insurance markets and is committed to offering an exceptional level of quality services.

ROLES RESPONSIBILITIES: Created different schemas and maintained schema objects Created a script for loading data into to read data from flat files to dump to Oracle database using SQL Loader Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules Created scripts to create new tables, views, queries for new enhancement in the application using TOAD Created indexes on the tables for faster retrieval of the data to enhance database performance Created new packages and modified existing codes to resolve application bugs. Worked with DBA team to deploy the code changes into Test, Integration and later into Production environments and with Operations team to publish tasks in aforementioned environments Analyze bugs raised by user created necessary technical documents for resolving those bugs. Provide appropriate resolution for each bug by putting in data fixes, updating View definitions etc. APPS MODULES: General Ledger, Accounts Receivable, Accounts Payable, Account Hierarchy Editor AHE , Financial Statement Generator FSG ENVIRONMENT: Oracle 9i, SQL Loader, SQL, PL/SQL, TOAD, UNIX, Forms 6i, Reports 6i