SUMMARY

• Over 6 years of experience in IT industry with emphasis on Design, Development and Implementation of projects using Oracle (Sql, PL/SQL).
• Solid experience in translating business requirements into creation of Database Objects.
• Extensive experience in Relational database analysis, design, development, testing support, project management and implementation of applications primarily using Client/Server, Middleware, Enterprise Application Integration, RDBMS and Object Oriented technology to accommodate client’s distinct business needs
• Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle
• Professional experience in designing Logical and Physical data models using ERWIN.
• In depth knowledge and experience in new features like Analytic functions, Bulk Bind, Merge, Case and PL/SQL supplied packages.
• Programming work experience with Batch Scripting and shell scripting.
• Professional experience in using External Tables and Temporary tables.
• Solid experience Tuning of the SQL query, which takes long time to process the request using explain plan, auto trace and hints to reduce the response time.
• Extensive knowledge and experience in SQL Server 2000/2005
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.
• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS

RDBMS/Databases: Oracle 8i/9i/10g.

Operating Systems: Windows XP/2000/2003 Server, UNIX /LINUX

Languages: SQL, PL/SQL, Shell Script, Visual Basic, C, HTML, XML/XSL.

Tools: /Utilities: Forms 6i/10g, Reports 6i/10g, Discoverer 3i/4i/9i/10g, SQL*Loader, TOAD, Sql Developer, Exports and Imports.

PROFESSIONAL EXPERIENCE

Confidential, Addison, IL

Oracle Pl/Sql Developer

Responsibilities:

• Prepared technical specifications from business requirement document.
• Designed/developed tables, views, materialized view, stored procedures, packages and functions.
• Automized routine jobs using dbms job. On completion of these jobs an email will be sent out automatically (UTL MAIL).
• Involved in designing schemas and profiles.
• Creating synonyms to mask the owner of the object and easy management of privileges.
• Data extraction from files to intermediate tables using UTL FILE/DBMS FILE TRANSFER.
• Involved in partitioning of very large tables using List and Range Partitioning.
• Writing several PL/SQL subprograms (stored procedures, functions and packages) using PL/SQL records, PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Created database objects such as tables, views, indexes and sequences according to business requirements.
• Developed Discoverer Folders, Business Areas, Work books, Discoverer Administration, Discoverer Security and Discoverer Migration Procedure activities.
• Worked on creating BA’s, EUL, granting privileges in Discoverer Admin, creating and sharing the workbooks in Discoverer Desktop and Plus and running the reports using Discoverer Viewer.
• Expertise in Administration and User Edition of Oracle Discoverer. In Administration Edition, Created layer of metadata for End User Layer for hiding the complexity of the database from the users, created various business areas, user views, custom folders and joins for reporting in user edition.
• Developed several Discoverer reports using Oracle Reports to meet the business requirement.
• Developed PL/SQL functions and procedures to provide APIs for the front-end developers to manipulate the database efficiently.
• Developed Dynamic SQL using EXECUTE IMMEDIATE to build Complex Queries.
• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data to Data marts.
• Performed application SQL tuning using SQL Trace/Explain plan.
• Supporting other colleagues in developing the right SQL, PL/SQL script and query.
• Associated with DBA in monitoring the performance related issues.
• Create & maintained cron jobs using Shell Scripts.

Environment: Oracle 10g/11g, Reports, Discoverer, Forms, Sql Server, Windows, UNIX, TOAD

Confidential, Houston, TX

Oracle Pl/Sql Developer

Responsibilities:

• Gathering user requirements and designing Database accordingly which involves creating Logical Data model and Physical Data modeling.
• Used Oracle PL/SQL for implementing business rules and do performance tuning procedures.
• Creating many physical objects (table, constraints, index, function) to facilitate the smooth data retrieval
• Loading data into the intermediate tables using UTL FILE and Sql Loader.
• Designing, Developing & Fine Tuning data-retrieval & data-migration scripts.
• Automized sending the reports to bureaus and attorney using UTL SMTP..
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Used Pl/Sql tables, array structures as a part of oracle collections.
• Extensively developed complex PL/SQL packages and implemented Oracle Streams.
• Used UTL JOB to automate the plsql procedures and packages.
• Design and developed UNIX shell scripts for various batch and scheduling purposes.
• Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procs & functions.
• Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
• Developed comprehensive reports, cross reference listings and statistical reports using Oracle Reports/Graphics, complex SQL queries (with all kind of joins and groupings, etc.) and analytical functions feature built into Oracle9i.
• Created custom folders, item classes in Discoverer Administration, cross tab, page detail reports, conditions, parameters, sharing of workbooks in Desktop edition of 4i.
• Trained End User’s to familiarize with Discoverer Plus and Viewer Tool.
• Designed and developed the user interfaces in Forms 6i to maintain sale transactions, receipt generation and dealer wise reports.
• Closely worked with DBA in monitoring the performance related issues using SQL Trace and TKPROF utility
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Oracle 9.2, Reports 6i/9i, Forms6i, Discoverer, Windows, Linux, Toad, ER Win, Sql Developer and SQL * Loader

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Involved in the maintenance and enhancement of the application.
• Used the technical document to design the database tables.
• Involved in designing the database using ERWIN.
• The analysis of the existing system, definition of the requirements of the customers, setting of the task.
• The project also has a security feature to maintain special entry codes for most forms.
• Reports are generated at various levels to give information regarding the sales, stock levels, supplier details, item details, etc.
• Re-order level for each item is also given so that the client does not have the need to verify the stock level every day, and this re-order level can be changed by the client as per the requirement.
• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping
• Created control files for SQL*Loader.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
• Implemented Stored Procedures for data integrity and involved in the process of high-level design for the workflow module. Designed database for the workflow module.
• Done effective requirement gathering for creating new reports in Discoverer.
• Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Developed simple, custom and complex folders in Discoverer Administrator.
• Developed item classes using Discoverer Administrator.
• Maintained user security and privileges at business area level. Periodic backups of EUL and Export, Import of Business Areas from one instance to another.
• Created cross tab, page detail reports, conditions, parameters, sharing of workbooks in Discoverer Desktop/Plus.
• Communicate issues and progress to project manager.
• Developed PL/SQL coding standards.

Environment: Oracle 9i, Forms/Reports 6i, PL/SQL. Toad, Linux, Windows NT/2000, ER Win