SUMMARY

• Around 8+ years of IT experience in developing software applications using Oracle 11g/10g/9i and its products in wide range of applications including Manufacturing, Banking and Telecommunication applications.
• Solid experience working on Oracle 10g/9i/8i/8.0/7.x, Developer 2000/6i (Oracle Forms 6i and Reports 6i), PL/SQL, UNIX and Discoverer.
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi - tier and client/server architectures.
• Developed database centric web applications with (APEX) Oracle Application Express. Developed and deployed professional applications that are fast and secure.
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers.
• Designed database schema's using Entity relationship modeling with ER diagrams & database normalization principles.
• Knowledge about Oracle Business Intelligence (OBI) Applications which are complete, prebuilt BI solutions that delivers intuitive, role-based intelligence throughout an organization. These solutions enable organizations to gain more insight and greater value from a range of data sources and applications including Oracle E Business Suite, PeopleSoft, JD Edwards, Siebel, and third party systems such as SAP.
• Used data modeling techniques and methodologies in order to manage the data as a source for designing databases/datawarehouses.
• Developed and used Crystal Reports business intelligence application to design and generate reports from a wide range of data sources.
• Used key files to hold licensing information, which is periodically reviewed to ensure currency and compliance.
• Used Query tuning techniques for better performance and execution through suitable indexes, primary-foreign key constraints.
• Performed query optimizations through Oracle Hints for parallel execution and join operations.
• Created materialized views that which contains the results of the queries and made query execution faster.
• Used MS Access to import or link the data stored in other applications and databases.
• Used MS Access, for report creation features that can work with any databases.
• Having experience in working with SQL Server Reporting Tools (SSRS) and SQL Server Integration Management (SSIS).
• Experienced in SQL Loader, Export and Import and enforcing security by creating roles, granting system and object privileges on the Tables and Stored procedures.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Knowledge on Oracle Forms, Reports and Menus.
• Solid experience in writing and debugging stable and robust PL/SQL code, handling various kinds of Exceptions, SQL, Dynamic SQL, C, and UNIX shell scripts.
• Supported advance PL/SQL using Cursors, REF Cursors, and Native Dynamic SQL.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Implemented Autonomous transaction and Distributed transaction processing in PL/SQL, Non-Distributed transactions, Distributed transactions, Remote transactions.
• Moved columns of data into and out of database tables using PL/SQL program units by passing collections as parameters to program units.
• Experienced with SQL performance tuning and optimization using execution plans.
• Improved performance of PL/SQL program units by using Bulk Collect and Bulk Bind (ForAll) features with Collections instead of using cursors and FOR loops, and DBMS PROFILER package and GET TIME in DBMS UTILITY package.
• Excellent analytical, verbal & written communication, interpersonal, team work skills and assertive leadership abilities with a high degree of professionalism and dedication to exceptional quality.
• Ability, willingness, and passion to learn new technologies and acclimatize to diverse work cultures.
• Solid managerial and administrative skills with good business understanding and excellent versatility and adaptability to manage multiple tasks.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading in a corporate-wide-ETL Solution using Oracle.
• Used Oracle’s Embedded SQL environment (Pro*C), a method of combining the computing power of a high-level language like C/C++ and the database manipulation capabilities of SQL.
• Used Pro*C at server side for greater performance and throughput.
• Experienced in OLTP and OLAP System Study, Analysis and E-R modeling.
• Enforcing data integrity using integrity constraints & database triggers.
• Good understanding of Oracle Data Dictionary and Normalization Techniques.
• Expertise in Database Design, Database programming and SQL.
• Experience in using SQL TRACE and TKPROF tools for SQL tuning.
• Extensively worked with Oracle Utilities like UTL FILE, DB Links, and FNDLOAD,TOAD, UNIX Shell Scripting, Imports/ Exports and SQL * Loader.
• Self-motivated and enjoy working in a technically challenging environment.
• Ability to work under stringent deadlines within a team as well as independently.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, MS SQL Server 2000, DB2, MS ACCESS 2007

Languages: SQL, PL/SQL, C, C++, Java 1.4/1.5

Tools: TOAD, SQL Developer 3.0, Oracle Enterprise Manager 10g, SQL*Plus, SQL*Loader, Oracle Forms and Reports 10g/9i/6i, Pro*C, Oracle Framework, MS Office 2007, Open Office 3.3

Internet Technology: HTML 5.0, JavaScript, XML, PHP 5.0, CSS 3, DHTML, .NET

Scripting: Unix Shell Scripting, Java Script

Operating Systems: HP-UX 11.0,UNIX, Windows 95/98/2000/NT/XP/Vista and AIX

PROFESSIONAL EXPERIENCE

Confidential, Southlake, TX

Oracle PL/SQL Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Worked with Data warehouses, Data marts and subsets of data for reporting and data analysis purpose. Dealt with Data warehouse architectures and various concepts in data warehouses.
• Involved in writing backend Packages extensively in PL/SQL.
• Involved in Code Reviews and preparing Unit test cases.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate the costly bugs and functional errors and used right data model for the data mart based on the requirements.
• Used web services manager for policy management and security of service infrastructure.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Used Oracle Exadata database storage servers to reduce IT costs through consolidation, store up to ten times more data, improve performance of all applications, deliver a faster time-to-market by eliminating systems integration trial and error, and make better business decisions in real time.
• Defining and reviewing the coding standards besides reviewing the code.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• Used Oracle forms 9i to create applications to enter, access, change and delete data from Oracle databases
• Extensively involved in preparing Detailed Technical Documents from the functional specifications.
• Used Key files to hide certain parameters from users and added key mapping entries to a key map file.
• Preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Actively Involved in Integration and Deployment in Production Environment.
• Customization of code as per the user requirements.
• Involved in the analysis of the existing database.
• Designed and extensively worked on Project Documentation.
• Separating Tables and Indexes on different locations for reducing Disk I/O Contention.
• Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.
• Used Bulk Binds and Bulk Collect.
• Designed Pragma Autonomous Transactions.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

Environment: Oracle Database 11g, TOAD, Microsoft Windows Server 2008 R2, UNIX, PUTTY, PVCS, WinSCP, UNIX

Confidential, Washington D.C.

Oracle PL/SQL Developer / ETL Developer

Responsibilities:

• Design Technical Specifications from Functional Specification (Detail Design) documents.
• Mapped the extracted data from source systems and load it into the target systems after applying the required transformations using ETL tool Informatica Power Center.
• Use SQL*Loader/Perl Script to load data from various sources into an Oracle database.
• Validate data using functions and procedures.
• Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling.
• Wrote PL/SQL Packages, Functions and Procedures to implement the Business Logic.
• Created database triggers for data security.
• Verified coded logic by testing and correcting programs via unit tests.
• Involved in Integration test, System test and Implementation.
• Proficiently developed test cases in Quality Center.
• Extensively developed complex PL/SQL packages for Pricing.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and Update strategy.
• Used debugger to test the mapping and fixed the bugs.
• Worked with pmcmd to interact with Informatica Server from command mode
• Applied Performance Tuning logic to optimize session performance.
• Attended business user sessions to make changes in warehouse loads.
• Developed UNIX Korn shell scripts to process file feeds.
• Involved in production support during deployment.
• Examined, reviewed, and/or changed code to adapt to changes in requirements.
• Developed shell scripts for batch processing and database transactions.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
• Involved in Database performance tuning using Explain plan.

Environment: Oracle 9i/10g, Oracle Application Server 10g, PL/SQL Developer, TOAD, MS-Windows 2003, UNIX, PUTTY, PVCS, WinSCP, Unix Shell Scripting, Quality Center, etc.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Involved in Requirement Analysis and developing the Project Definition Document.
• Responsible for developing XML documents to generate SQL dynamically for all the business roles.
• Used XDB UTILITY packages to load XML documents into database tables.
• Worked with CLOB and LOB data types to load large XML documents into database tables.
• Responsible for developing PL/SQL database objects like Functions, Procedures and Packages.
• Developed a PL/SQL conversion program and SQL*Loader program for validating and migrating the legacy agents information into Oracle base tables.
• Involved in Performance Tuning of various custom PL/SQL reports and PL/SQL packages.
• Involved in migrating the application from Oracle Database 9i to Oracle Database 10g.
• Extensively wrote PL/SQL code to customize various forms pertaining to Contracts and data load.
• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using Erwin and identified key features for scalability of the application.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Used Dynamic SQL and autonomous transactions for error handling.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexed to gain performance.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Created Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.
• Developed Unix shell scripts for job scheduling.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Involved in unit testing the application code and database code for data integrity and application functionality.
• Conducted meeting with System Analyst to explain the application functionality.
• Debugged Packages, Procedures, and Functions and fixed them according to the business requirement.
• Tuned the existing SQL queries to improve the performance.
• Involved in the Data Modeling phase of the application.
• Used ETL tools like SQL Loader to load the flat file data into database tables.
• Also written UNIX shell scripts to automate the nightly data load from third party servers.
• Extensively involved with end users to make the enhancements.

Environment: Oracle Database 10g, SQL, PL/SQL, Oracle Reports, Oracle Forms, PL/SQL Developer, SQL* Plus, Windows 2000, Java, Shell / PERL Scripting, UNIX, XML, FTP, SQL*Loader, Discoverer 4i.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Created numerous web based Forms and Reports using Oracle Developer 6i.
• Defined Editors, created List of Values and Record Groups in Oracle Forms 9i.
• Designed, developed and tested Reports using Report 6i and Discoverer 4i.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts.
• Developed Forms, Packages, Triggers and Shell Scripts to load the staging table data into Traffic Mart System.
• Writing scripts to create partitions, exchange partitions, analyze for performance tuning.
• Responsible Co-ordination with Client.
• Analyzing the Design and functionality.
• Developed packages, functions, procedures, database triggers as part of the ETL process.
• Worked with Star schema and Snow Flake schema.
• Used UTL FILE (file handler), DBMS JOB, DBMS ALERT and other utility built-in Packages in PL/SQL.
• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, developing, coding and testing.
• Creation of database objects like tables, views, procedures, packages using SQL* Plus and PL/SQL.
• Performed Data validations and mappings at staging table level.
• Created Complex Dynamic / Static / Parameterized Reports and Charts using Report 6i.
• Assessed the efficiency of the SQL statements using SQL Trace and TKPROF

Environment: Oracle 9i/10g, SQL, PL/SQL, Developer 2000 (Forms 6i, Reports 6i), Sun Solaris, TOAD, XML, HTML 4, UNIX, and Windows XP/2000/NT, SQL*Loader, Discoverer 4i.

Confidential

Oracle Developer

Responsibilities:

• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using Erwin and identified key features for scalability of the application.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Used Dynamic SQL and autonomous transactions for error handling.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexed to gain performance.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Created Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.