SUMMARY

• Over 8 Years of Experience in complete Software Development Life Cycle that includes analysis,software Design, Development,implementation, maintenanceand migration on Unix, Linux, Windows environment with proficiency in Oracle technologies like Oracle database 9i/10g/11g, Oracle Application server 10g, forms 9i/10g, Oracle reports 9i/10g, Oracle Discoverer, Teradata.
• Expertise inORACLE database development languages like SQL and PL/SQL; IDEslike SQL developer, PLSQL developer, SQL navigator, TOAD, SQL developer data modeler, ESF data migration tools, eclipse, SSIS, Teradata Sql Assistant.
• Transforming business requirements into technical specifications, involved in creating and implementing Technical Documentation.
• Development usingtools such as ORACLE Forms,Reports, Discovereretc.
• Database backup using Oracle Import/Export, RMAN utilities.
• Installation and configuration of Oracle Database, App server, Developer suite.
• Application Development inClient - Server (App server) Architecture environment.
• Creating database, tablespace, datafiles,tables, views, materialized views, roles, indexes,DB Links, Cursors, Stored Procedures,Packages and Database Triggers.
• Tuned SQL queries using Tkprof, EXPLAIN PLAN, optimizer Hints and Indexes.
• Developed Windows batch processes and Unix shell scripts (corntab) to automate processes e.g. exporting data form specific schema, importing millions of rows using SQL*Loader and External tables from flat files to Oracle tables.
• Performing data migration using ESF toolkit, SQL*LOADER and Import/Export scripts.
• Extensively used scalar, group and analytical functions like ROW NUMBER, RANK and DENSE RANK.
• Used bulk binding techniques like BULK-COLLECT,FORALL and BULK-DML operations (BULK-insert/update/delete) to process thousands of rows in Oracle tables.
• Knowledge of advanced features in PL/SQL such as Nested Tables, Records, Types, Varrays, Dynamic SQL; packages such asUTL FILE, UTL MAIL.
• Experience in Entity Relation (ER)diagram using SQL Developer data modeler.
• Developed master-detail, drill down, matrix, nested summary detail reports using Oracle Reports Builder which pulled thousands of records in different formats.
• Creating complex Forms usingOracle forms Builder templates and called reports from the form environment.
• Experience in production support and trouble shooting of database applications.
• Excellent communication, quantitative, analytical and leadership skills; Ability to work individually as well as in team environment.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Shell-script, C/C++, Matlab, Java, Python, XML, HTML

Operating systems: UNIX(Solaris, HP-UX),Linux (Red Hat), Windows (Server 2008/XP)

Development Tool: ORACLE9i/10gForms, Reports, Discoverer, Enterprise Manager

RDBMS: ORACLE database 9i/10g/11g, Teradata-14, MS Access

IDE: SQL developer, PLSQL developer, SQL navigator,TOAD, ORACLE Development Suite, SQL*LOADER, Teradata Sql Assistant,Eclipse, ESF data migration toolkit, SQL Developer data modeling

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Senior ORACLE PL/SQL Developer & Data Analyst

Responsibilities:

• Constantly interacted with the business analysts and managers for their requirements
• Transforming business requirements into Technical Documentation, involved in analysis, database design, coding and implementing
• Loaded Giga-bites of data into oracle tables using external table, SQL*Loader, Sql-Server Integration Services (SSIS) and wrote windows batch scripts to automate the process.
• Extensively used Oracle PL/SQL language to develop complex stored packages, procedures, functions, triggers etc. to process raw data and prepare for the statistical analysis.
• Extensively used statistical language like R, software like Spotfire, spread-sheet like MS-excel (statistical functions, pivot table etc.) to perform statistical analysis.
• Generated different kinds of reports e.g. drill down, nested summary detail reports as per management and business-analyst request using Oracle Report builder.
• Automated jobs using oracle supplied package DBMS SCHEDULER.
• Frequently used advanced Oracle and PL/SQL features like Dynamic SQL, Ref-Cursor, Bulk collect, Analytic functions (e.g. ratio-to-report, rank etc.) in the new routines as well as to modify the existing routines work more efficiently.
• Partitioned tables and created index to increase performance of large database (~ 5 TB).
• Tuned SQL queries using EXPLAIN PLAN, Optimizer Hints and Indexes.
• Frequently interacted with the business-analysts to understand their requirements, the problems they faced and providing necessary technical support.
• Held several quality control meetings to enforce standards, fixing bugs, presenting results, providing .
• Actively involved in Testing, Integration, Implementation and documentation of the project.

Environment: Oracle-11gR2, Teradata- 14.00.03.09 , MS SQL-Server 2008, TOAD-11.5.0.56, SQL Developer-3.1.07, Teradata Sql Assistant-13.11.0.3, R-2.15.2, Windows 7, MS Excel 2010

Confidential, Phoenix, AZ

ORACLEPL/SQL Developer& Administrator

Responsibilities:

• Involved in analysis, database design, coding and implementing.
• Installed and configured Oracle Database 10g/11g, Oracle Application server 9i/10g, Oracle Developer suite 10g in production environment.
• Created Windows batch processes to automate loading data from flat file into Oracle table using SQL*Loader.
• Regularly performed SQL query tuning using EXPLAIN PLAN, optimizer Hints and Indexes, Tkprof, Autotrace.
• Wrote numerous DBA scripts using V$ views (e.g. V$sessions, V$parameters) to analyze the system load, monitor number of users logged on.
• Used Oracle Import/Export, RMAN utilities to backup database.
• Extensively used SQL, PL/SQL to develop packages, stored procedure, functions and database triggers.
• Used Oracle Forms, Reports to customize according to the customer’s need.
• Extensively used ORACLE Discoverer for ad-hoc querying and reporting.
• Developed drill down, group above, matrix, nested summary detail reports, using Reports 10g, which pulled the thousands of records in different formats.
• Designed & developed major input screen using Forms 10g.
• Created complex forms which called reports; usedstacked, tab canvas on a content canvas; used master-detailsrelationship triggers in several forms.
• Migrated data from non-Oracle such as MS Access database to Oracle database using ESF data migration tool kit.
• Interacted with end user for problems faced and providing necessary technical support by fixing the bugs.
• Testing, Integration System test, Implementation (test with users) and documented the entire project.

Environment: Oracle 10g/11g(SQL, PL/SQL), SQL Navigator 5.0, ORACLE Forms and Report builder 10g, ORACLEDiscoverer 10.1.2, SQL Developer data modeler 3.0, Windows server 2008,XP Professional.

Confidential, Madison, WI

Oracle PL/SQL Consultant

Responsibilities:

• Involved in writing complex SQL statements to implement the business requirements.
• Heavily involvedin developingPL/SQL packages, DMLtriggers, stored procedures to insert data in Oracle tables, checkdata consistency, calculate tax etc.
• Wrote Corn jobs to automate SQL Loaderto load data from text files into the database.
• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT/UPDATE/DELETE features.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Wrote complex SQL query with various Joins, sub-query, and nested query to create new reports and modified existing reports (group above, matrix) using Oracle Reports.
• Involved in cleaning and maintaining migrated databy using Partitioned Tables and Indexes.
• Involved in developing proceduresusing oracle supplied UTL FILE package to read, write from ASCII files load it into Oracle forms through database tables.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and package.
• Involved in daily monitoring and maintaining the IPAS database using Performance Analyzer,AWR snapshot and ADDM reportin OEM.
• Extensive experience working with users/vendors and turning their requests into results.

Environment: Oracle 9i/10g(SQL, PL/SQL), Oracle Forms/Reports 9i, SQL developer 2.1PL/SQL developer 8.0, SQL Developer data modeler 2.0, HP-Unix, Bash/C shell

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Incorporating all the business rules, writing code using SQL, PL/SQL.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• Used SQL Loader to load data into different tables from flat files.
• Wrote stored procedures, functions and database triggers to perform and verify accounting.
• Extensively used complex SQL queries with various Joins, sub-queriesto validate data.
• Created reports using MS access tool according to specific guideline.

Environment: Oracle database 9i, SQL, PL/SQL, SQL*PLUS, SQL*Loader, MS Access, Red Hat enterprise Linux, Bash shell.

Confidential

ORACLEPL/SQL Intern

Responsibilities:

• Configured and maintained Red Hat enterprise Linux systems to streamline the day-to-day operations in the GMRT observatory, e.g. automatic astronomical data accusation, signal processing etc.
• Installed and configuredOracle database 9i in development environment and monitor database performance using OEM.
• Used SQL Loader to load big (millions of rows) astronomical data set from ASCII files into different Oracle tables.
• Wrote Linux shell scripts to automate data loading process.
• Extensively coded in SQL and PL/SQL to develop stored procedures, functions and database triggers for data entry and validation.
• Wrote software in C/C++ to process, analyze and visualize scientific quantities.
• Role also included designingand testing Oracle database.

Environment: Oracle database 9i,SQL*Plus, PL/SQL, SQL Loader, Exp, Imp,C/C++, Redhat enterprise Linux, Bash/C shell