SUMMARY

• Over six years of IT experience in analysis, design, development, implementation and maintenance (Complete software development lifecycle) of application software in teh Client/Server environment on UNIX & Windows NT/2000 Platforms.
• Experience in application software analysis, design, development, implementation, maintenance, and documentation of commercial applications throughout various phases of project life cycle.
• Experienced in System Analysis, design and implementation. Logical and physical data modelling.
• Monitor database performance & Tuning.
• Proficient knowledge in creation of database objects like tables, views, synonyms, sequences, Indexes, Triggers, Table partitions, Sub - partitioning, Database links etc.
• Enforcing security by creating roles, granting system and object privileges on teh tables, stored procedures.
• Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing teh Entity-Relationships.
• Good understanding of Oracle data dictionary and normalization techniques. Experienced in Oracle 11i/10g/9i/8i/8.x/7.x systems, SQL*Loader, Export, Import and SQL*Plus.
• Expertise in Oracle distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF and Hints provided by oracle.
• Expertise in using Oracle PL/SQL Collections (PL/SQL Tables and Varray’s), Bulking techniques, Partition utilization to increase performance.
• Experience in Oracle BI Apps that include ETL tools and DAC in Pharmaceutical, Insurance Domains.
• Worked with multiple data providers such as Universes, Personal Data Files, Stored Procedures, Freehand SQL, and VBA Procedures in development process.
• Automating data loading, extraction, reports generation using UNIX Shell scripting.
• Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server.
• For optimization process actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc.
• Experience in developing applications using forms (10g/9i/6i) and reports (10g/9i/6i). Well experienced in backend programming (Triggers, Procedures, and Functions) using Oracle 10g/9i/8i/8.x and web enabled application development and deployment using Oracle application server.
• Knowledge of Database Architecture for OLAP and OLTP Applications, Database designing, Data Migration, Data Warehousing Conceptswith emphasis on ETL.
• Proficient in using Oracle development tools like SQL Navigator, TOAD and PL/SQL Developer.
• Hands on experience Implementing Oracle Transparent Data Encryption TDE.
• Written complex SQL’s using joins, sub queries and correlated sub queries.
• Wrote Test cases and performed data validation and process testing for application moving into production.
• Worked as onsite coordinator for offshore.
• Highly motivated with excellent team spirit to achieve targeted goals well within deadlines.

TECHNICAL SKILLS

Operating System: Windows 95/98/NT/2000/XP, UNIX, Linux, IBM AIX 4.1, Oracle Enterprise.

Languages and Web Technologies: C, C++, Java, Unix Shell Scripting, .NET, XML, HTML/XHTML, DHTML, SQL and PL/SQL.

RDBMS and Application Server: Oracle 11g/10g/9i/8i/, Developer 11g/10g/9i/6i suite (Forms 10g/9i/6i, Reports 10g/9i/6i), Oracle Designer 2000/6i, Discoverer 9i, Erwin, SQL*PLUS, SQL*Loader, Oracle Enterprise Manager.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

SQL Editors: Toad, SQL Navigator and PL/SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in different phases of software development including gathering requirements, development of database objects, developing code and validating programs.
• Developed back-end PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Extensively used advanced technologies like Collections for optimal performance.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
• This project includes Process Monitoring, Scheduler and running back jobs through application, UI Development, Integration of code with existing system. PL/SQL work like create or update procedure, functions or execution of query.
• Involved in developing Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Improved teh performance using Global Temporary Tables, Ref Cursors, Dynamic SQL such as EXECUTE IMMEDIATE for data load and updates.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk me/O and Sorts.
• Used pl/sql collections, Bulking techniques, Table Partitioning to increase database performance.
• Worked in Oracle Cursor, Exception Handling, Collections like REF, Nested tables, VARRAYS & IOTs.
• Hands on experience in messaging/notifications applications and other web services/interfacing systems.
• Involved in data migration from CSV format into teh respective Oracle Database tables using TOAD.
• Hands on experience working with Perl scripting.
• Supported and maintain current applications by providing expert technical advice, debugging, and troubleshooting pre-production and production issues, responding rapidly to such events.
• Analyzing performance of database objects and suggesting DBA for Indexes, statistics gathering and partitioning. Analyzing explain plan, TK PROF and giving further solutions to solve performance issues.
• Extensively worked with developing reports using Oracle Report 10g for teh business users’ readability and scheduled jobs for teh reports to be emailed to teh respective person.
• Wrote complex SQL queries using joins and correlated sub queries.
• Worked with teh offshore team as a Team Lead. Assigned work and performed code check of teh deliverables.
• Loaded and unloaded data sets from or to Oracle Databases using various kinds of data loading tools such as SQL*Loader and Oracle Import/Export Utility.
• Created scheduled batch jobs in Oracle
• Involved in Technical Documentation, Unit test, Integration test and writing teh Test plan.

Environment: Oracle10g, SQL, PL/SQL, UNIX, Toad, Sql * Loader, Perl, Putty, UNIX Shell Scripting, Microsoft Office Tools.

Confidential, Monroeville, PA

Oracle PL/SQL Developer

Responsibilities:

• Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
• Developed back end interfaces using PL/SQL stored procedures, packages, functions, Object Types, DB triggers, Indexes and Collections.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of teh system.
• Involved in accomplishing automated data extraction from various RDBMS via scripts, ETL in database usage and especially in data warehousing.
• Involved in development of User Interface Objects (Forms9i and Reports9i) and Testing of entire module.
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Hands on experience working with error handling and performance tuning in Teradata queries and utilities.
• Developed Database objects like tables, Indexes, triggers for Reporting Database.
• Documented all teh packages, procedures and functions involved in ETL process.
• Maintained performance tuning by using SQL-Related Performance Tools like EXPLAIN PLAN, SQL Trace and TKPROF, Indexes and Clusters.
• Worked in Oracle Cursor, Exception Handling, Collections like REF, Nested tables, VARRAYS & IOTs.
• Hands on experience working with Oracle Transparent Data Encryption to encrypt some of teh data in teh database.
• Good in optimizing SQL queries by reading Explain plan statistics.
• Experience is working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD and PARTITION OVER.
• Used UNIX Shell scripts to deploy teh Oracle forms and reports to production servers.
• Developed user interface screens using Forms 10g and developed Dynamic HTML reports by embedding HTML in teh PL/SQL stored procedures using PL/SQL web toolkit.
• Implemented SQL*Loader direct path option for bulk inserts into database.
• Involved in designing new universes and modify existing universes using features like aliases, loops, contexts, joins. Creating dimensions, measures and detail objects which are grouped into classes.
• Worked on Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 10g.
• Involved in development of User Interface Objects (Forms and Reports) and Testing of entire module.
• Involved in Unit testing teh Oracle developed scripts.
• Used Oracle defined packages DBMS JOB, DBMS SCHEDULER for job scheduling.
• Modifying existing scripts for query performance using TOAD.
• Worked with teh offshore team as a Team Lead. Assigned work and performed code check of teh deliverables.
• Involved in Technical Documentation, Unit test, Integration test and writing teh Test plan.

Environment: Oracle10g, SQL, PL/SQL, UNIX, Toad, Sql * Loader, Forms 10g, Reports 10g, Business Objects XiR3, Visual Studio, UNIX Shell Scripting, Microsoft Office Tools.

Confidential, King of Prussia, PA

Sr.Oracle PL/SQL Developer

Responsibilities:

• Involved in understanding teh technical direction of teh programming staff from a Back end database design and development perspective.
• Created and managed many objects in large Oracle Databases containing millions of records.
• Created logical and physical database objects - table spaces, tables, indexes, referential integrity constraints and triggers to development needs.
• Performed Fine Tuning of SQL, PL/SQL Procedures.
• Developed PL/SQL packages for Customer tracking, summary of sales order, Shipment and invoice, Sales Order information by customer, order, PO number, part number etc.
• Created screens using Forms 6i for Order Entry, Stock availability, Sales history tracking with respect to part number, customer, order, PO number, Summary of sales orders were done using Developer 2000 suite of products.
• Developed screens using oracle forms for data entry and loading data from Excel sheets.
• Developed web contents and enhance teh web sites by utilizing teh languages like CSS and .NET.
• Worked in Oracle Cursor, Exception Handling, Collections like REF, Nested tables, VARRAYS & IOTs.
• Worked on ETL tools from source to target business objects by using Transformation Manager.
• Used SQL*loader and Export/Import extensively to load and port data from one database to another.
• Design, development and implementation of web-based applications using developer 6i to enable customers to make sub payments through internet & to receive up to date information about their client and their payment schedule etc.
• Created business-related reports and migration database tools from oracle 8i to Oracle 9i.
• Analyzed teh performance of teh jobs during teh project. Utilized standard techniques for enhancing teh performance.
• Wrote shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Authored User reference documents on all teh deliverables created for future reference by Business Users and conducted training sessions.
• Various PL/SQL triggers were written to handle teh automatic order issuing
• Worked on database tuning and optimization using Analyze, EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Created job sequences and schedules for automation.
• Implemented shell scripts for trouble shooting Oracle Errors with teh halp of trace files and scheduled them through cron jobs.
• Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.
• Tuned teh SQL statements using execution plans generated using TOAD and SQL*Plus.
• Responsible for technical support for Oracle databases related issues.

Environment: Oracle 9i, Forms 6i/6I, Reports 6i, SQL, PL/SQL, IBM - AIX, Shell Scripting (Korn), Toad, Data Modeler, UNIX, SQL*Navigator.

Confidential, Ada, MI

Oracle Developer

Responsibilities:

• Responsible for requirement Analysis, Coding, Testing and Implementation of various modules.
• Gatheird and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Developed PL/SQL procedures and functions to migrate data between Oracle Databases.
• Extensively used PL/SQL Developer for creating database objects, running teh command scripts for inserting teh configuration data items.
• Used Oracle Forms to create new forms and also maintain existing forms.
• Automated data loading, extraction, reports generation using UNIX Shell scripting.
• Loading data by using SQL* Loader to custom tables.
• Troubleshoot jobs using teh debugging tool.
• Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
• Involved in reverse engineering of teh application using Erwin.
• Used Erwin to transform data requirements into data models.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
• Involved in teh setup of Oracle Financials which include, setting up Profile Options, Configuration Setups, Calendar, Sequencing, Checks, Payment Methods and Types.
• Conducted performance tuning of applications through tuning pack and SQL*Navigator, SQL*TRACE, TKPROF utilities.
• Implemented shell scripts for trouble shooting Oracle Errors with teh halp of trace files and scheduled them through cron jobs.
• Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.
• Used Oracle Enterprise Manager, TOAD for developing and managing pl/sql scripts.
• Worked on technical documentation and status reports of teh application.

Environment: Oracle 8i, IBM AIX 4.1, Pl/Sql, SQL *Plus, .NET, ASP, TOAD, Oracle Forms 6i, Oracle Reports 6i, Ms Office, SQL*Navigator, shell scripting (Korn).

Confidential

Oracle Developer

Responsibilities:

• Wrote PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into teh application.
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Developed numerous programs using PL/SQL and many packages to do teh validations as per requirements.
• Developed and maintained lot of batch scripts in UNIX shell scripts, like scheduled data loading, Create, databases, dblinks and backup and Recovery.
• Responsible for running weekly and monthly reports and running EOD jobs.
• Taken responsibility to do teh enhancements.
• Automated teh manual processes, which are running daily by us.
• Perform teh unit testing, regression testing and place teh code in UAT to check for any defects due to teh code changes.
• Migration of code into production.
• Post production run verification.

Environment: Oracle 8i, PL/SQL Programming, UNIX, SQL*Loader, Unix/korn/Perl, TOAD, Shell Scripting.