SUMMARY

• Over six years of IT experience in analysis, design, development, implementation and maintenance (Complete software development lifecycle) of application software in the 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 the tables, stored procedures.
• Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the 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 the 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 I/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 the 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 the business users’ readability and scheduled jobs for the reports to be emailed to the respective person.
• Wrote complex SQL queries using joins and correlated sub queries.
• Worked with the offshore team as a Team Lead. Assigned work and performed code check of the 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 the 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 the 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 the 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 the data in the 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 the Oracle forms and reports to production servers.
• Developed user interface screens using Forms 10g and developed Dynamic HTML reports by embedding HTML in the 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 the Oracle developed scripts.
• Used Oracle defined packages DBMS JOB, DBMS SCHEDULER for job scheduling.
• Modifying existing scripts for query performance using TOAD.
• Worked with the offshore team as a Team Lead. Assigned work and performed code check of the deliverables.
• Involved in Technical Documentation, Unit test, Integration test and writing the 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 the technical direction of the 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 the web sites by utilizing the 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 the performance of the jobs during the project. Utilized standard techniques for enhancing the 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 the deliverables created for future reference by Business Users and conducted training sessions.
• Various PL/SQL triggers were written to handle the 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 the 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 the 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.
• Gathered 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 the command scripts for inserting the 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 the 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 the 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 the 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 the 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 the 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 the 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 the 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 the enhancements.
• Automated the manual processes, which are running daily by us.
• Perform the unit testing, regression testing and place the code in UAT to check for any defects due to the 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.