SUMMARY OF QUALIFICATIONS

• Over 11 years of IT experience consisting of responsibilities of Oracle Developer on Oracle v11g/10g/9i/8i in Multi Operating Systems and multiple years as Web Developer using all the latest technologies.
• Strong expertise in designing and building OBIEE repository and creating business centric dashboards and scorecards.
• Extremely experienced with managing Oracle Discoverer Administrator EUL and creating Oracle Discoverer reports and converting them into portlets and incorporating these portlets in Oracle Portal.
• Strong background in Database Management Systems and Client/Server Architecture for developing large Oracle RDBMS applications using tools such as SQL LOADER, TOAD, SQL Worksheet and used Ultra Edit for compiling and debugging the PL/SQL and SQL Plus codes.
• Experience in SQL, PL/SQL, Forms 6i, 9iDS, Oracle Web Forms, Reports 6i/9ids, Oracle Web Reports , Dynamic HTML, HTML Forms .
• Strong expertise in Oracle APEX formerly known as HTMLDB v 1.5, 1.6 and few years of experience in developing new applications as well as making enhancements to existing applications.
• Extremely proficient with Oracle Portal and building web applications for various needs and requirements.
• Proficient in writing Server side programming viz. Procedures, Functions, Packages and database triggers.
• Experience on Logical Physical Designing of Databases. Data Modelling, Conceptual Design Data Architecture.
• Data loading from other databases and text files into Oracle Database using SQL LOADER.
• Experience in writing Procedures, functions, triggers and packages in Oracle database server and also for Oracle Application Server using PL/SQL, JavaScript, HTML and JAVA.

TECHNICAL SKILLS

Database Tools: Oracle 7.3, 8.0 8i, SQL Plus 3.0 8.0, SQL Worksheet, SQL Loader, TOAD,SQL Navigator 4.0, Erwin, Oracle Developer 2000 tools such as Oracle Forms 4.5, Oracle Reports 3.0, and Oracle 11i Financial Apps

Database Skills: Developing ETL processes manually with Oracle PL/SQL SQL programming, loading Data Warehouse Data Marts with Oracle PL/SQL Stored Procedures, Packages, Functions, Materialized Views, PL/SQL Cursors, Triggers. Data Mining, Data Analysis, Data Mapping, Data Modelling, DDL DML coding, Developing Database Reports specifically comma-delimited Report Writing, Data Cleansing, Analyzing Data Integrity Accuracy, Developing Unit Regression Test Scripts. Expertise in Star Schema or the snow flake design, De-normalizing data for Data Warehouse system Normalizing for a 3-tier architecture from a de-normalized form

Reporting Tools: Crystal Reports 7.0 8.5, Oracle Reports 3.0, Info Viewer, Info Designer, Info Desktop, and Excel

Other Tools: Visual Source Safe PVCS for source control Configuration Management, Lotus Notes for correspondence, DBA tools such as Oracle Enterprise Manager Console, DBA Studio, SQL Server 7.0 2000 System Administration

O/S: Windows NT 4.0, Windows 2000 Professional, and Windows XP Professional

Networking/Web Server: - Oracle 9iAS, Apache Server SSL IIS etc.

Work Summary

Confidential

Senior Consultant

Achievements:

• Interfaced with clients to gather requirements and presented solutions to their issues related to ado-reporting.
• Collaborated with team and configured OBIEE environment and to build a prototype for clients to visualize OBIEE strengths in building dashboards and scorecards.
• Wrote advanced and optimal SQL queries to retrieve data from complex and large databases.
• Provided technical support in release deployments and tested ADHOC environments for impact and issues.
• Crafted data extracts requested by clients using complex SQL scripts and stored procedures and stored data in text files.
• Using Oracle Discoverer 10g/11g, Created new Business Areas in the End User Layer and made changes to existing structure to meet client's needs and requirements.
• Resolved various customer issues that involved server patching and tuning of other configuration parameters on the server.
• Trained and wrote instructions for end users/developers on how to use Discoverer viewer/Plus.
• Analyzed ETL mappings using Oracle Warehouse builder and helped the team debugging some ETL issues.
• Worked on writing project plans to stand a Portal to host all the web applications and provide single staging place for all the applications.
• Customized Discoverer Viewer header with client's Logo and a search box and removes Oracle copyright and places client's standard footer in Discoverer Viewer.
• Enhanced Query performance in Discoverer reports using hints, indexes, explain plan and by setting appropriate Discoverer environment values such as records per fetch and etc.

Confidential

Senior Consultant

Achievements:

• Created and redesigned Informatica mappings and workflows to load data into data marts.
• Created Portal pages and Page Groups in Application Server Portal for these reports and to display these reports.
• Created Users in Oracle Portal and managed controlled access of these users to all the pages in that application.
• Created EUL and populated EUL with various types of objects folders, Item classes, hierarchies, summaries and etc .
• Exported/Imported EUL objects between different Application Server Instances Dev, Pre-Prod and Production .
• Created complex Discoverer reports Detail and Summary involving complex logics and calculations with both Discoverer Desktop and PLUS.
• Customized Discoverer Viewer header with client's Logo and a search box and removes Oracle copyright and places client's standard footer in Discoverer Viewer.
• Enhanced Query performance in Discoverer reports using hints, indexes, explain plan and by setting appropriate Discoverer environment values such as records per fetch and etc.
• Designed and implemented appropriate Database Role level security and sharing of reports between users.

Environment: - Discoverer, 9.0.4 10g, Discoverer 10.1.2, ,Oracle version 9i,10g database, Oracle 10g DS, Windows 2000/NT 4.0 SP6 . Oracle Developer 6i Tools, Oracle Portal

Confidential

Data Warehouse Developer

Achievements:

• Using Discoverer Administrator, created, imported and exported End User Layers EUL and Business areas to meet the reporting environment requirements.
• Using Discoverer Administrator, set standards for scheduled workbooks and queries and registered objects in already defined EUL.
• Assigned user specific privileges and assisted to rectify any issues with their accounts.
• Developed new reports and also maintained and enhanced existing discoverer reports.
• Developed application in Oracle APEX to develop data dictionary for the management to facilitate exploring table structures and updates on Data warehouse project.
• Created Discoverer portlets and incorporated these portlets with Oracle Portal.
• Designed and developed pages in Portal and displayed Discoverer reports on these pages.

Environment: - HTMLDB 1.6, Discoverer 10g , Oracle version 9i,10g database, Oracle 10g DS, Windows 2000/NT 4.0 SP6 . Oracle Developer 6i Tools

Confidential

System Developer

Achievements:

• Supported efforts as lead resource and developed complete customized Web applications in Oracle APEX and provided training to end users.
• Using 11i Application, designed a customized application OCS / MIS to fully meet the client's specifications.
• Designed and developed Oracle Reports and Implemented Parameters to generate the required data set of the end user.
• Designed master-detailed Oracle Forms and applied these forms inside the skeleton of Oracle 11i APPS .
• Using Discoverer Administrator, created business areas and assign security and privileges to multiple discoverer users.
• Designed Discoverer Reports and integrated these reports into the Application.
• Using TOAD , developed PL/SQL procedures for forms 6i and reports 6i and integrated these forms and reports into 11i APPS.
• Designed web based applications using 9i DS HTP utility provided for PL/SQL integration with HTML to convert into procedures.
• Designed and developed extensive user friendly forms and generated reports to visualize and analyse the data.

Environment: - HTMLDB 1.6, Oracle APPS 11i , forms and reports 6i, Discoverer 3.1 4.1 9i , Oracle version 8i 9i database, Oracle 9i DS, Web Alchemy, Windows 2000/NT 4.0 SP6 . Java, HTML, JavaScript , Oracle Developer 6i Tools

Confidential

Oracle/Web Developer

Achievements:

• Developing Stored Packages to validate and populated data to interface tables.
• Developed PL/SQL Packages, Functions, and triggers for various web applications.
• Imported and Exported databases across different RDBMS such as Oracle, Mysql and Access using ODBC.
• Developed and enhanced Discoverer reports and managed scheduling and sharing of these reports.
• Imported and Exported databases across different versions of Oracle such as 8i and 9i.
• Designed web pages in HTML / XHTML using Macromedia Homesite and Dreamweaver.
• Wrote JavaScript to manage pop-ups and also to control the page flow.

Environment: - Oracle version 8i 8.1.7.1.5 Windows 2000/NT 4.0 SP6 . Oracle version 8i 8.1.7.0.1 Linux. Java, HTML, JavaScript , Oracle Developer 6i Tools, Discoverer 4.1.

Confidential

System Developer

Achievements:

• Designed and built applications in Microsoft Access to manage customers and sales.
• Edited and maintained web sites and updated several pages to show latest products and promotions.
• Researched and tested several tools to conduct inventory management.
• Generated various reports like inactive customer list, new customers, monthly detail of new customer's bill slips and inventory management reports.
• Performed data entry task to store information of customers and sales.

Environment: - Microsoft Access, Excel, Word, Dreamweaver Homesite, PHP, Windows 98.