Professional Summary:

• Over Seven years of IT experience in analysis, design, development, implementation and testing of applications in data warehousing and client/server environment.
• Experience with Oracle SQL and PL/SQL programming and used Database utility tools like SQL Navigator, SQL Plus, TOAD, SQL Developer.
• Hands on experience working with SQL Loader to load data from external source like flat files into Oracle database tables.
• Experience in Oracle SQL and PL/SQL including all database objects: Stored procedures, functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• Proficient at working as a team player with an aim of contributing towards the team's success. Involved in unit testing, systems integration testing and documented the same.
• Experience in Tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
• Extensive Knowledge and Experience in ETL tools like SQL Loader, Informatica to transfer the data between different databases.
• Good Understanding of various transformations in Informatica like Union, Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Experience in Data Analysis and managing data warehouse and data marts.
• Strong knowledge in implementing table partitions using Range, Hash, Composite techniques
• Proficient in using Erwin tool for data modeling and MS Visio to create the flow chart and to show the process flow.
• Experience in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams using Erwin tool.
• Good understanding of Oracle data dictionary, RDBMS and normalization techniques.
• Experienced in Oracle 11g/10g/9i systems. Created new databases and users: set up backups, export and other monitoring scripts.
• Expertise in working with built-in packages like DBMS LOB, DBMS SQL, DBMS SCHEDULER, DBMS DDL, UTL FILE, UTL MAIL.
• Excellent problem solving skills with a strong technical background. Creative, adaptive and result-oriented professional with avidness to learn.
• Possess good communication and inter-personal skills, able to adapt quickly to new technologies and environments.

Business/Technical Skill:

Oracle 11g/10g/9i/8i, MS Access, MySQL, SQL, PL/SQL, UNIX Shell Scripting, SQL Loader, SQL Plus, SQL Developer, HTML, ETL, Informatica, OLAP, OLTP, TOAD 8x/9x/10x, Auto trace, Explain Plan, Tkprof, SQL Trace, Microsoft reporting tools, Autosys, ERWIN, Star Schema/Snowflake Schema Modeling, MS Visio, UNIX, Windows 95/98/2000, Windows NT 4.0, Red Hat Linux, Oracle PL/SQL, VBA, Possess knowledge in Computer Networking Concepts.

Projects Summary:

Confidential

Oracle PL/SQL developer

Responsibilities:

• Analyzed the business requirements for the enhancements needed in the contract Administration application and related policy modules.
• Performed several DDL, DML and TCL operations.
• Created huge database packages with related functions and procedures.
• Developed views by joining multiple cash flow tables to show output as a report to the user.
• Extensive PL/SQL programming including Development of new backend packages, procedures and functions to incorporate advanced modules.
• Worked on BULK COLLECT for bulk loading the data into various transaction tables.
• Implemented various UNIX scripts to generate the data in CSV format.
• Used UTL FILE to load the data into oracle tables from FLAT, CSV and Text files.
• Added database triggers to some history tables of the database for keeping track of updates to values in a history table.
• Used file handling in Oracle to read and write into files associated with the modules.
• Refreshed the development and test databases using export/import utilities.
• Tuned several Oracle SQL statements using tkpr of, Explain Plan, Auto Trace utilities.
• Worked on external hints during the SQL optimization to fast up the SQL process.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored procedures, functions and packages.
• Associated with physical and Logical Data Modeling using Erwin. Created models based on the dimensions, levels and measures requires for analysis.
• Assisted in working with Informatica Design of ETL mappings
• Worked on inline and correlated Sub queries based on business context.
• Implemented various customized Oracle reports using different techniques in Oracle SQL/PLSQL like SQL Plus reports.
• Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.
• Provided 24 7 on call support to production environment.
• Involved in Impact analysis of the defects to the associated functionalities and modules in the Production environment.
• Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.

Tools Technologies:

Oracle 11g/10g, PL SQL, SQL Developer, SQL Plus, Export Import Data, UNIX, Toad 9.6/9.7, Erwin 8, Informatica 9.1

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.
• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality. Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Encapsulated error handling and use of autonomous transaction for logging. Used UTL FILE for exporting data and UTL MAIL to generate E-mails. Extensively used PL/SQL features like collections, nested table, Varray and bulk collection for high performance of stored procedures.
• Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade.
• Created database objects such as tables, indexes, views, materialized views, triggers, sequences, synonyms, etc.
• Extensively worked on writing complex SQL queries cursors, ref cursors, sub queries, correlated sub queries .
• Modified XSD to validate incoming XMLs which improved efficiency and overall system Performance. Suggested and implemented improvements to legacy systems.
• Developed multiple reports for IT needs to identify and improve performance.
• Responsible for SQL tuning using explain plan, tkpr of utility, optimizer hints. Involved in RDBMS design and developed ER-diagrams using Erwin.
• Involved in creation of various indexes on relational tables, which are BTREE, BITMAP, FUNCTION BASED.
• Created various user defined EXCEPTIONS to control the process based on the business requirement.
• Involved in generating numbers for PRIMARY KEY VALUES using Oracle SEQUENCE objects.
• Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATMENT.
• Performed supported DBA activities involving User management and table space management.
• Effectively documented and archived historical data for future auditing purposes.
• Responsible for production support and troubleshooting production issues. Experience working with huge database size of 5 TB.

Tools Technologies:

Oracle 11g/10g, UNIX, SQL, PL/SQL, SQL PLUS, SQL Loader, TOAD 9x, XML, Erwin7.2, Subversion

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL functions and procedures for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
• Used advanced Bulk techniques FOR ALL, BULK COLLECT to improve performance.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, and TKPROF and hints utilities.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in working with INLINE CURSORS, EXPLICIT CURSORS, REF CURSORS.
• Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
• Used various oracle pl/sql collections VARRAYS, NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
• Designed and created new customized reports using Crystal Reports 8.5. Interacted with the client IT team and the business team to resolve issues and dependencies.
• Involved in upgrade database from Oracle 9i to 10g database.

Tools Technologies:

Oracle 10g/9i, SQL, PL/SQL, SQL Loader, SQL Navigator, TOAD, UNIX, Crystal Report 8.5

Confidential

PL/SQL developer Support DBA

Responsibilities:

• Analyzed business, functional and technical requirements to make sure project met expectations.
• Designed and developed GUI modules with VB 6.0 as front end.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS SQL, DBMS PIPE, DBMS JOBS, UTIL FILE, and DBMS OUTPUT.
• Participated in performance tuning of existing SQL statements and PL SQL code.
• Experience in understanding conventional and traditional data structures.
• Used DBMS UTILITY, DBMS SMTP, and DBMS MAIL to perform various tasks in project.
• Developed Oracle packages involving cursors and composite data types for backend functionalities.
• Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Worked on parameterized cursors and dynamic cursor to perform dynamic operations.
• Added extensive exception handling to the primitive packages to enhance error handling.
• Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.
• Designed the structure of new database tables incorporated for module enhancement.
• Performed support DBA tasks for taking hot and cold backups.
• Loaded data in new tables using SQL LOADER.
• Provided 24 7 supports to Production environment.

Tools Technologies:

Oracle 9i/10g, PL/SQL, SQL Loader, Export Import Data, Oracle Enterprise Manager, Toad, UNIX.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Developed user defined functions based on requirements. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages.
• Responsible for query optimization and performance tuning using Explain Plan, Auto Trace utilities. Created the integrity constraints and Database Triggers for the data validations.
• Generated relevant staging tables to load the CSV files, identified the business validation rules.
• Created the tables and sequences for the experimental data load capture. Loaded the data into the tables using TOAD and SQL plus.
• Created metadata validation lookup tables and pre populated them using SQL Loader generator application.
• Designed competent pl/sql programs using pl/sql collections, Records types, Object types.
• Involved in working on Oracle Psuedo columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, USER etc.
• Implemented various UNIX scripts to generate the data in CSV format.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.
• Performed intensive testing for verification of the defects existing in the Production.

Tools Technologies:

Oracle 9i, SQL Plus, PL/SQL and Windows XP, UNIX, Oracle SQL Developer, TOAD 7.6, MS Access 2000/2002.