PROFFESSIONAL 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 in server side programming like Stored Procedures, Stored Functions, Database Triggers, Packages using PL/SQL and SQL.
• 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.
• ­­Knowledge of finance management and call center management Reporting.
• 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.xand 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.
• Experience in web development using HTML, DHTML, XML, VBSCRIPT, and JAVA SCRIPT.
• Sound experience in SQL *net and troubleshooting the network related problems.
• Data conversion from legacy systems using SQL*Loader, PL/SQL and SQL*Plus.
• Proficient in using Oracle development tools like SQL Navigator, TOAD and PL/SQL Developer.
• 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.
• Highly motivated with excellent team spirit to achieve targeted goals well within deadlines.

EDUCATION
Bachelor’s of Engineering in Computer Science and Engineering

TECHNICAL SKILLS

Operating System

UNIX (HP, Solaris), Windows 95/98/NT/2000/XP, Oracle Enterprise, Linux, Redhat Linux, MS-DOS

Languages and Web Technologies

C, C++, Java, .NET, Pro*C, Unix Shell Scripting, XML, HTML/XHTML, DHTML, SQL and PL/SQL, JavaScript, JSP and ASP 3.0

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 SQL*PLUS, Server Manager/SQL*DBA, Export/Import, SQL*Loader, Erwin, Toad, Oracle Enterprise Manager.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK,

ETL & OLAP

Informatica Power Center 8.1, AB INITIO, SQL*Loader

SQL Editors

Toad, SQL Navigator and PL/SQL Developer

Web Designing Tools

MS Front Page, Visual Interdev 6.0 and Dream weaver.

WORK EXPERIENCE

Client: Confidential,PA Aug’09 to Present
Position: 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.
• Written many database triggers for automatic updating the tables and views.
• 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.
• 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.
• Create reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae.
• Created reports using data providers like universes, freehand SQL.
• Used pl/sql collections, Bulking techniques, Table Partitioning to increase database performance.
• Good in optimizing SQL queries by reading Explain plan statistics.
• Used UNIX Shell scripts to deploy the Oracle forms and reports to production servers.
• 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.
• 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.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: Oracle10g, SQL, PL/SQL, UNIX, Toad, Sql * Loader, Forms 9i, Reports 9i, Business Objects XiR3, UNIX Shell Scripting, Microsoft Office Tools.

Client: Confidential, MI Nov ’08 to July ‘09
Position: 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 help 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, .NET, Toad, IBM AIX 4.1, Shell Scripting( Korn), Data Modeler, UNIX, SQL*Navigator.

Client: Confidential,Atlanta, GA Aug’07 to Oct ‘08
Position: 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 help 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).

Client: Confidential,India Sept ’06 to July ‘07
Position: Oracle Developer

Responsibilities:

• Created stored procedures, functions and packages for applying the business rules.
• Created database scheduler scripts and applications using Unix shell scripts, SQL *Plus script.
• Maintained performance tuning by using SQL-Related Performance Tools like SQL Trace and TKPROF, Indexes and Clusters.
• Implemented SQL*Loader direct path option for bulk inserts into database.
• Involved in writing data conversion programs using PL/SQL.
• Strong know ledged in Oracle Cursor management, Exception Handling, Collections like REF Cursors, Nested tables, VARRAYS & IOTs.
• Involved in creating PL/SQL procedures for writing the data into a flat file.
• Built Internet access and GUI interfaces to Relational Database Management Systems (RDBMS).
• Created of Adobe forms that combine high presentation with XML data handling.
• Developed graphical interface of Adobe Designer enables users to quickly design forms, maintain form templates.
• Used features like PL/SQL record inserts and updates.
• Worked on PL/SQL, SQL, Oracle, DB2, Java Security and Oracle performance expertise, BI tools, Pro C, PL/SQL, OOPS methodology.
• Used Java for database connectivity by using JDBC
• Modifying existing scripts for query performance using TOAD.
• Involved in generating new reports using Reports 6i and Report Templates.
• Performance tuning and optimization achieved through the management of indices, query execution plans and optimizing the SQL scripts.
• Developed single form to run all the Reports as central point.
  

Environment: Oracle 10g, PL/SQL Programming, PL/SQL, Oracle Forms 6i/10g, Oracle Reports 6i/10g, Discoverer, Adobe Designer, Java Components, OOPS methodology, DB2, VB.net, UNIX, PL/SQL, SQL*Loader, Oracle Forms and Reports and 11i, MS Office.

Client: Confidential,India. July‘05 to Aug‘06
Position: Oracle Developer

Responsibilities:

• Identifying functional and non-functional requirements, analyze the system, provide suggestions, and design as per requirements and test the design.
• Identifying database requirements and was involved in designing of database for various modules.
• Developed various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder, and Application Object Library.
• Developed screens using Forms 6i
• Developed PL/SQL modules-Administration Manager (AM), Cession Manager (CM), Report
• Manager (RM), Database Utility (DU) modules
• Extensively involved in SQL Tuning of PL/SQL modules developed
• Used PL/SQL web toolkit to develop programs for web enabling,
• Used Web request broker and PL/SQL agent for the connection to the Oracle database.
• Created reports in Oracle Discoverer by importing PL/SQL functions on the Admin Layer, in order to meet the sophisticated client requests.
• Developed Billing and Policy exhibit reports using Reports 6i which are sent to reinsures on regular basis.
• Worked in Oracle Cursor, Exception Handling, Collections like REF, Nested tables, VARRAYS and IOTs
• Developed graphical interface of Adobe Designer enables users to quickly design forms, maintain form templates.
• Involved in writing Pro*C scripts based on the business requirements.
• Implemented shell scripts for scheduling batch jobs, diagnostics
• Responsible for Performance tuning of the Forms and Reports code modules using EXPLAIN
• PLAN, SQL*TRACE, TKPROF and TOAD utilities Conducted Unit and Functionality Testing of the above modules.
• Performed the documentation of the modules and reports generated

Environment:Sun Solaris 8.0, Oracle 9i, PL/SQL, TOAD, Forms 6i/6I, Reports 6i, Data Modeler, SQL, C, PRO*C, Web logic 9,9.1,10, Adobe Designer, K-shell, SQL*Loader, Windows NT 4.0/2000.

Client: Confidential,India. May ‘03 to June ‘05
Position: Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering the requirements by conducting meetings and prepared the technical design documents.
• Installed new databases, upgraded existing databases, created new database instances
• Involved in creating PL/SQL Packages, Procedures Triggers and Cursors.
• Involved in creation of database objects like tables, views, stored procedures, Indexes and Collections.
• Implemented SQL*Loader direct path option for bulk inserts into database.
• Written many database triggers for automatic updating the tables and views.
• Designed logical and physical database layouts to minimize I/O contentions among data files.
• Used UNIX Shell scripts to deploy the Oracle forms and reports to production servers.
• Involved in loading the data from flat files to Oracle tables using SQL*Loader and C.
• Involved in creating user documentation and providing End user training.
• Involved in creating complex queries Using joins, sub queries and correlated sub queries.
• Involved in creating the forms from the scratch using PLL’s and objects groups.
• Performed Unit testing for the Developed component.

Environment: Sun Solaris 2.5, Oracle8.1.5, Forms 4.5 and Reports 2.5, SQL, SQL*Plus, PL/SQL, SQL*Loader, Toad, Windows 2000 and Windows NT.