SUMMARY

• Information Technology Professional with over 8 years of experience in Application development and Production support using Oracle SQL, PL/SQL, Forms and reports.
• Good Experience in Software Development Life Cycle (SDLC) including analysis, logical design, Resource Planning, code development, testing, implanting and maintenance.
• Subject Matter Expert in Oracle PL/SQL, Forms and Reports.
• Strong Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Expert in backend programming using PL/SQL and SQL.
• Strong Experience writing interfaces, triggers, stored procedures and PL/SQL packages to provide database access and manipulate functionality.
• Excellent understanding of Iterative/RUP and Waterfall methodologies in Software Development Life Cycle (SDLC) and actively participated in all its phases.
• Excellent approach in gathering business requirements, analysing and interpreting with excellent skills in translating the business requirements into functional requirements in collaboration with business and technical subject matter experts
• Expert in Creating PL/SQL procedures, packages, functions, database triggers and other database objects like Lob’s to generate back - end and front-end reports.
• Expert in Oracle Application Server 10g administration and installation.
• Extensive experience in design and modeling database-using Designer/2000, Erwin.
• Extensive experience in Relational Data Base Management Systems (RDBMS).
• Strong experience in Oracle Workflows.
• Extensive experience on Designer-2000.
• Basic DBA activities like creating of databases, users and table spaces and Logical export and Import. SQL loader, DB links, Materialized view creation, index creation and fine-tune queries.
• Experience in Preparing of Checklists, identification of Test Cases, preparing Test Plans according to IEEE standards.
• Knowledge in PRO*C.
• Experience in SQR and Hyperion Reporting.
• Through understanding in data warehousing concepts.
• Experience in Migration oracle DB forms, Reports for 6i/7i/8i/9i and 10g versions.
• Designed and developed various applications using oracle products/tools for process of automations software into database server using UNIX shell scripts, Perl shell scripts PL/SQL packages, procedures and database triggers based on client/server and multi-tier technologies.
• Experience in using SQL *Loader and External Tables for Export/Import of data.
• Experience using TOAD, SQL Navigator under UNIX and Windows NT/2000/XP/Vista, Sun Solaris operating systems.
• Knowledge in DBA activities like creating of databases, users and table spaces, partitions, Indexes, constraints and permissions.
• Strong experience in working with multiple projects in high pressure environment.
• Excellent verbal and written communication and presentation skills and Strong interpersonal skills, ability to interact with people at all levels.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, T-SQL C, C++, Cognos, JAVA, Pro*C, HTML,.net XML.

Databases: Oracle 6i/8i/9i/10g, SQL Server 2000, MS Access, RDBMS.

Utilities: TOAD, SQL Navigator, SQL* PLUS, SQL*Loader.

Operating Systems: Windows 95/98, Windows 2000/XP/ NT, UNIX, Sun Solaris, AIX

Tools: MS-Office 2000, MS-Excel, Outlook, IIS6.0, Visio, Designer 2000, Erwin, Crystal reports XIORACLE APEX.

GUI's: Oracle Forms and Reports 6i/9i/10g, Developer2000, Portal.

Case Tools: Designer2000

Data Modeling: Erwin 4.0/3.5,Eagle Pace, Snow flake.

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NY

Senior PL/SQL Developer

Responsibilities:

• Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, publishing model to PDF and HTML format, generating various data modeling reports etc..
• Installed and configured Oracle 10g right from the scratch by working closely with DBA and configured to various tools as per the requirement.
• Involved in documenting process using Doors.
• Designed UML diagrams such as Use Case Diagrams (UCD’s), Activity Diagrams in accordance with UML standards making use of MS Visio.
• Created database objects like tables, views, procedures, packages using Oracle Utilities like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions
• Designed and developed complex forms and crystal reports as per the clients requirement in Oracle 6i, 9i and 10g.
• Implemented RDBMS concepts in Data modeling.
• Corrected & modified existing application according to user requirements.
• Supported Oracle Financials module team.
• Used Oracle Financial Module to improve productivity by accessing multiple data sources at the same time.
• Did high level Coding and GUI Standards, Implementing java classes in PL/SQL procedures.
• Designed Oracle workflows for automation of business processes.
• Implemented Designer2000 exclusively for SDLC process and Dataflow Diagrams.
• Built physical data structures like tables, views, constraints & Indexes.
• Implemented sync sort for the backup purpose of large volumes of data.
• Worked on Proc Pre complier to recognize the SQL statements embedded in program.
• Documented design specifications and architecture using Microsoft Visio, Microsoft outlook, Microsoft Excel.
• Configured oracle reports and crystal reports with internet information services (ISS).
• Involved in Complex table joins as per the requirement.
• Experience in data extraction from heterogeneous sources using Informatica power center.
• Involved in Code Reviews and preparing unit test cases.
• Did performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions for optimal query performance.
• Did high level coding using T-SQL for complex joins.
• Exclusively developed Oracle Forms and Reports like crystal reports with extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with the use of Cursors, REF Cursors and loops.
• Preparation of Checklists, identification of Test Cases, preparing Test Plans
• Prepared Function Requirement Documents and documented the process events and best practices.
• Wrote cursors and control structures using PL/SQL.

Environment: PL/SQL, SQL, Pro*C,SQL LOADER, Toad, java, Oracle APEX,T-SQL Oracle database 10g; Oracle Forms 6i, 10g; Oracle Reports 6i, 10g, Oracle Application Server 10g; Oracle portal 10.1.2, Oracle Discoverer, Oracle Applications: Purchasing and WMS modules, Sun Solaris OS, Linux and Windows.

Confidential, Rochester, NY

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Worked as part of the development team, along with the Systems Analysts/Business Analysts.
• Analyzed and fixed the data discrepancies between various systems and identified bad data caused due the data migration from various legacy systems.
• Created PL/SQL Stored Procedures, Functions, Packages, and Triggers; extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance
• Improved performance by creating Unique and Range Indexes based on the cost returned by EXPLAIN PLAN.
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers
• Effectively used Triggers to track the user profile updates and to send the messages to downstream systems
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases
• Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, db links and privileges.

Environment: Oracle 10g/9i, PL/SQL, SQL Server, Informatica 8.5, Cognos, UNIX Shell Scripting, Toad, ER-Win Windows XP.

Confidential, Hoboken, NJ

PL /SQL Developer

Responsibilities:

• Analyzed business requirements and coordinated with the business analyst to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems.
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards. Developed Unit Test Plans.
• Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and Oracle Objects including Collections, Types and creating objects.
• Prepared the procedures to update the internal structures to reflect the newly loaded data.
• Used batch scripts to loop from database to database, to perform system-wide functions.
• Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.

Confidential, Topeka, KS

Oracle Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Creation of database objects like tables, views, procedures, packages using Oracle utilities like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions
• Prepared program specifications for PL/SQL Procedures and Functions to do the conversion.
• Implemented RDBMS (normalization) concepts in Data modeling.
• Designed the front end interface for the users, using Forms 6i
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Participated in Performance Tuning using Explain Plan and TkProf.
• Developed number of Reports using Reports 6i and Crystal Reports.
• Created Unix Shell Scripts for automating the execution process.
• Created business area, new custom folders, complex folders, summary folder, hierarchies, item classes and list of values using Discoverer 10g.
• Worked on Perl scripts to transfer files using FTP to all the UNIX servers at one time.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: SQL, PL/SQL, Oracle 10g, Toad 8.5, SQL*Plus, SQL*LOADER, UNIX shell scripting, Reports 6i, Forms 6i, MS SQL Server 2000, Discoverer 10g.

Confidential

Programmer

Responsibilities:

• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing
• Performing the tests on the newly coded procedures and documenting the same.
• Writing technical documents using the functional specifications.
• Writing PL/SQL code using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Automated sqlldr using shell scripting.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application.

Environment: Oracle 8.3, SQL * Plus, TOAD, SQL*Loader, Forms 4.5 & Reports3.0 and Windows 2000 professional, UNIX shell scripting.