SUMMARY

• 7+ years of extensive experience in the complete Software Development Life Cycle (SDLC) covering Requirements Management, System Analysis, Architecture and Design, Development, Testing and Deployment of business applications.
• Proficient in Data Base Design, Data ware house, Application Development and Production Support in Client/Server Environment using Oracle 11g/10g/9i/8.x, SQL, PL/SQL, and Oracle Data Integration.
• Strong Data Modeling experience using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snowflake modeling using tools like Erwin.
• Extensive experience writing Stored Procedures, Functions, Packages, PL/SQL routines, Database triggers, Shell - Scripting, unit testing integrity and also involved in complex backend data extraction, transformation and loading operations on oracle using INFORMATICA, SQL Loader and DATA PUMP utilities.
• Created multiple customized PL/SQL Procedures & Packages for various businesses’ needs, to transform data before the loading process, and to manipulate and sort data for the Reports specifications.
• Well experienced in Query Optimization and Tuning using bulk collections, Hints, Explain Plan, SQLTRACE. Experienced in creating External tables, Uploading/Downloading data using SQL*Loader control files.
• 24/7 Production support and involved in implementation of coding standards security, attending audits at various levels by using coded security module, database change requests.
• Self-motivated and results oriented person with good analytical and problem solving skills
• Creative, independent, good team player with and ability to accept responsibilities and meet tough deadlines.
• Expertise in writing Packages, Stored procedures, functions, Triggers Creating tables, views, Indexes, Constraints, partitions etc. Expertise in using cursors, collections, records, Dynamic SQL, Object Types, bulk operations, exception handling, analytical functions, DBMS packages, XML-DB and HTML-DB etc.
• Good Experience in PERL Shell scripting, Autosys, JIL, CA Workload control Center, GTI Distributed scheduling.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, UNIX Shell Programming and PERL.

RDBMS: Oracle 11g/10g/9i/8.x, SQL server 2007/2005, DB2, and MS Access.

Front-End Tools: Oracle Enterprise Manager, Forms Builder, Schema Builder.

GUI: Oracle Forms 9i/6i/5.0, Oracle Designer2000, SQL*Loader.

Database Tools: SQL Navigator 4.1/5.1, TOAD, SQL worksheet, and SQL developer.

Operating Systems: Windows NT/2000/98/XP, UX-HP, and Linux and Sun Solaris.

Web Applications: JAVA, JSF, JSP, ASP, XML, and HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Sr Oracle Pl/SQL Developer

Responsibilities:

• Generating forms and reports for clients using Oracle APEX. Create and define Row Sets, Columns Sets and Content Sets.
• Implemented the Authorization and Authentication schemes for the application.
• Involved in remediation of the non-standard DB links to standard and secure database links between the databases.
• Involved in implementing the privileged access of the Roles and grants.
• Provide the clarification to the users, Data fixes and stored procedure fixes, generate the new reports as per business user’s requests. Provide the work around for the production issues.
• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Analyzed the design and developed a JavaScript for the application. Modified the CSS as needed.
• Worked as oracle DBA and managed the application and scheduled memory and migrated the code.
• Analyzed the existing database structure for better understanding the relations, associations and dependencies within the database and database design for new requirements.
• Developed and modified Oracle packages, stored procedures, functions, Scripts, synonyms, tables and indexes to implement business requirements and rules.
• Created Oracle Apex Application from Scratch for few applications.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Implemented Performance Tuning by using Explain Plan for Query tuning.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Batch jobs Design using PL/SQL, SQL* Plus, SQL*Loader, Unix Shell programming.
• Used SVN version control management software’s for maintaining the code version standards and security.

Environment: Oracle APEX 3.2, Oracle 11g, SQL, PL/SQL, SQL Developer, SVN, JavaScript, CSS, XML

Confidential, Phoenix, AZ

Sr Oracle Developer/APEX Developer

Responsibilities:

• Implemented the conversion of security from http to https in all 78 applications
• Involved in conversion of DBMS JOBS to control-m jobs to maintain SLA and to implement more options.
• Involved in implementing the privileged access of the Roles and grants.
• Provide the clarification to the users, Data fixes and stored procedure fixes, generate the new reports as per business user’s requests. Provide the work around for the production issues.
• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Analyzed the existing database structure for better understanding the relations, associations and dependencies within the database and database design for new requirements.
• Developed and modified Oracle packages, stored procedures, functions, Scripts, synonyms, tables and indexes to implement business requirements and rules.
• Created Oracle Apex Application from Scratch for few applications.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Implemented Performance Tuning by using Explain Plan and TKPROF tools that included Optimizer hints, using Indexes and also Query tuning.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Batch jobs Design using PL/SQL, SQL* Plus, SQL*Loader, Unix Shell programming.
• Prepare and execute unit and integration test cases and support the build and releases activities. Support the QA and UAT testing.
• Provided production support and 24/7 support for resolving the critical production issues.
• Involved in the solving the tickets that are raised by the end users.
• Responsible for creating PLSQL Programs and UNIX Scripts for Data Validation and Data Conversion.
• Prepared UNIX shell script for the transfer of files from FTP to SFTP.
• Used SVN version control management software’s for maintaining the code version standards and security.
• Responsible for Oracle DBA role and worked on Schema changes and Database Software patches and upgrade.
• UTL FILE utility used to write the debug information and also for saving the data to a flat file.
• Used multiple parameterized cursors and complex loops for extracting the data.

Environment: Oracle 11g, SQL, PL/SQL, SQL*Plus, Toad, UNIX, Shell, SVN, Putty PSFTP, SQL Developer, Oracle APEX 4.2, Control-M (Third-party tool).

Confidential, Denver, CO

Oracle Developer/PL/SQL Developer/Analyst

Responsibilities:

• Worked on implementing the data movement strategy using the Oracle 10g to Oracle 11g and Oracle Export/Import process.
• Worked with Subject Matter Experts to understand business perspective of the processes.
• Generate Data Model for modularized business segment using Erwin and Toad.
• Involved in design, development and testing of applications as part of application enhancement.
• Took 6 APEX Applications through the entire Systems Development Lifecycle;
• Added new features to 8 existing applications and facilitated 6 projects dealing with data audit, information processing and implementing efficient business practices;
• Created Oracle Apex Application from Scratch for few applications.
• Created sign in and signup process for the user login.
• Created Custom authorization and authentication for the application.
• Created documentation, design and implemented rich user interfaces using Oracle Apex.
• Created database objects like Tables, Indexes, Sequences and Views etc.
• Involved in design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.
• Used extensively Cursor Expressions for data retrieval and manipulation in Oracle Database.
• Developed Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on Table Partitioning and deploying various methods of indexing like local Indexes and Global Indexes on portioned tables.
• Used UTL file package to read and write to external files.
• Analyzed Business Documents, Internal & External Source systems and Reporting Requirements to develop new reports as per modified user requirements.
• Prepared use cases, test plans and involved in unit testing.
• Trained business users on the functionality and operability of the application using interactive demo sessions.

Environment: Oracle APEX 3.2, Oracle 11g, SQL, PL/SQL, SQL*Plus, PL/SQL Developer, XML, XML Spy, UNIX, PERL.

Confidential, Dubuque, Iowa

Oracle Developer/Analyst

Responsibilities:

• Developed Stored Procedures, Packages, and Functions using PL/SQL for the batch framework.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, triggers, packages, stored procedures, roles and granting privileges.
• Responsible for 24/7 Production support during loads.
• Writing PERL shell scripts to massage the data before loading into the database tables.
• Used SERENA pvcs version control management software’s for maintaining the code version standards and security.
• Implementing quality control techniques for bug fixing & troubleshooting the existing batch jobs dependencies and code modules, also used BUGZILLA bug tracking tool.
• Extensively used TOAD, SQL Loader, Materialized views.
• Involved in major code rewrite effort to increase performance by normalizing the data and using index organized tables.
• Performed application SQL tuning using Explain plan, TKPROF, Indexes, Partition Pruning, Bulk Processing and Hints.
• Extensively worked with SQL* LOADER, XML style sheets, global temporary tables to load data into the database.
• Implemented Export/Import Oracle utilities using External tables to move data to different schemas.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Involved in tuning the long running PL/SQL queries for maximum efficiency in various business schemas of batch processing.
• Worked with Business teams to make sure requirements were converted correctly and the correct logic was implemented in the technical design and code.
• Worked with CFM files for the application frontend.

Environment: Oracle 10g, SQL, PL/SQL, SQL Navigator 5.5, Shell scripting, PERL, Adobe Cold Fusion and Windows XP.

Confidential, MO

Oracle PL/SQL developer

Responsibilities:

• Developed various code modules like Procedures, Packages, Triggers, functions, views, materialized views and other database objects using PL/SQL to meet the business requirements in maintaining the right data and reporting purposes to support decision supporting system.
• Identifying business specifications into technical requirements and development is major functionality of the position performed.
• Developed many UNIX Shell scripts for data massaging and setting up batch jobs, also used AUTOSYS.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Worked with various functional team experts to implement their functional knowledge into working Procedures.
• Worked on optimizing existing code modules with changing business functionality using PL/SQL.
• Developed control files, SQL*Loader scripts for ETL (Extracting Transforming and Loading) Jobs. Oracle import and export scripts for data loading, migration and backup of Oracle data.
• Using EXPLAIN PLAN, SQL trace and TKPROF utilities, assessed the efficiency of the code modules.
• Used PVCS version control management software.
• Created Partitions and Indexes whenever required to enhance performance.
• Used FORALL, BULKCOLLECT and ref cursors to improve performance for bulk loading
• Implemented Materialized views for faster processing and ROLL - UPS and CUBES.
• Generated reports using Oracle UTL FILE package.
• Prepared DML/DDL scripts for Unit and System testing and provided technical support for QA team.
• Documented technical designs, test cases, and user guides.

Environment: Oracle 9i/8i, Designer/2000, PL/SQL, Sql*Loader, Windows NT 4.0/ 98.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Created database triggers, cursors, procedures/functions and packages using PL/SQL.
• Written complex SQL (Sub queries and Join conditions), in PL/SQL.
• Experience in trace errors from stored procedures/functions, Packages and fixed.
• Used TOAD to check Explain plan and Tune fun/proc and Packages to improve the performance.
• Involved in performance tuning (SQL, PL/SQL) using oracle tools Explain Plan, TKPROF, auto trace, AWR etc.
• Responsible for loading multiple forms of data from multiple sources using SQL* loader.
• Developed Stored Procedures, packages, Functions and Database-Triggers using PL/SQL to implement day to day modified business rules into the current system.
• Design logical and physical data models using Erwin 6.0
• Involved in scheduling the batch jobs using Autosys.
• Created Database Tables, Global Temporary Tables, Cluster Tables, Partition Tables and Index-by Tables.
• Create Indexes (Bitmap, Btree), DB Links, Snapshots/Materialize Views and add table spaces (temporary TS, undo TS).
• Oracle Database Administration on 24x7 critical production and large databases(4TB) using Oracle 11g, 10g & 9i
• Developed slowly changing dimensions of Type 1, 2, 3 through Wizard and manually to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Developed Unix Shell scripts to automate repetitive database tasks.
• Developed several procedures, packages, triggers and ref cursors to handle backend data processing and data requests.
• Developed and scheduled PL/SQL Jobs using Oracle Scheduler.
• Written shell scripts to automate loading files into database using CRONTAB.

Environment: Oracle 10g, PL/SQL (stored procedures, functions, packages, Cursor, triggers, etc.), SQL*Plus, SQL Loader, TOAD, Erwin, Import/Export, UNIX scripting.

Confidential

Jr. PL/SQL developer

Responsibilities:

• Developed user interfaces using Java Server Pages.
• Implemented client side validations using Java scripts.
• Involved in tuning SQL statements and PL/SQL processes.
• Loaded flat files by using SQL Loader according to the business requirements.
• Created External table to access flat files.
• Used UTL File to load data from flat files, modified data according to the business logic and saved back in to flat file OR into table.
• Created database triggers, cursors, procedures/functions and packages using PL/SQL according to business requirement.
• Written complex SQL (Sub queries and Join conditions), in PL/SQL.
• Experience in trace errors from stored procedures/functions, Packages and fixed.
• Used SQL Navigator to check Explain plan and Tune fun/proc and Packages to improve the performance.
• Involved in performance tuning (SQL, PL/SQL) using oracle tools Explain Plan, TKPROF, auto trace, AWR etc.
• Created Sequences for automatic generation of voucher numbers and views for hiding.
• Created Indexes (Bitmap, Btree), DB Links, Materialize Views.
• Worked both environments (windows, UNIX) with oracle.

Environment: .Oracle 8i, PL/SQL (stored procedures, functions, packages, Cursor, triggers, etc), SQL Loader, TOAD, SQL Navigator, Winscp, Import/Export

Confidential

Developer

Responsibilities:

• Requirement Analysis by studying the existing system and discussion with HR department and management.
• Technical design, coding, debugging, unit testing, integration testing, QA and UAT testing.
• Database design and developing new tables, procedures, indexes and modifying the existing procedures as per the business requirement.
• Developed the frontend application using VB6.
• Designed the tables, indexes, triggers, stored procedures, functions and packages to implement the requirement.
• Packaging and installing the application. Provide the support after production release.
• Documented the various rules and calculations involved and also documented the various parameter to set for configuring various calculations.
• Design the various reports using Crystal reports.
• Optimized the queries using the various turning techniques.
• Designed the oracle forms for user maintenance and generated various reports.

Environment: Oracle 8i, Visual Basic 6.0, Crystal report, Solaris, Windows 95/98, PL/SQL developer, SQL*PLUS, SQL*Loader, Forms 6i, Reports 6i