SUMMARY

• 8+ years of experience as Oracle Developer/Report Writer in Information Technology with specialization in the Analysis, Design, Development and Testing of Oracle Reports and PL/SQL based applications.
• Written and modified number of stored procedures, functions, packages to handle logical units of development effort at a back end side using PL/SQL.
• Experience in Oracle (SQL, PL/SQL, Stored Procedures, Functions, Packages, SQL Loader, DATA Loader)
• Good knowledge in Data Definition Language, Data Manipulation Language and Transactional Control Language commands in SQL.
• Familiar in Performance tuning of reports, SQL & PL/SQL code.
• Experience in unit testing and integration testing.
• Expertise in GUI development using Developer 2000/6i/9i (Reports).
• Used Report scheduling and XML Publisher Reports for retrieving data in EXCEL SHEET.
• Expertise in Generating Auto Email System.
• Adequate knowledge of FORM Personalization.
• Strong interpersonal communication skills with the ability to communicate effectively across all levels over complete development cycle.
• Expertise in working in fast paced, high tech environments requiring skills in scheduling, management and team building.
• Excellent technical and organizational skills, ability to communicate and effectively impart technical information.
• A hard worker, dedicated and a fast learner with problem solving, analytical and logical skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, MS Visual Basic 6.0, C, C++, Core JAVA

Internet Tech: HTML, DHTML,XML

Operating Systems: Windows9x/2000/XP/NT & UNIX

RDBMS / Databases: Oracle 8i/9i/10g, MS Access

Familiar Software: Report Builder 6.0, Form Builder

Application: Oracle E - Business Suite 11.5.10.2

Reporting Tools: Oracle Report Builder 6i,BI 1-Key Agile Tool, ETL Informatica

Oracle Module: OM/INV/PO/BOM/WIP/AP/AR/GL/FA/MPS/MRP

Utilities: Toad, SQL*Loader, DATA Loader,WSFTP

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

RESPONSIBILITIES:

• Worked in creation of new oracle reports as well as modification of existing reports according to specification.
• Analyzing user requirements and build SQL queries and PL/SQL Blocks.
• Assigning reports to appropriate request groups.
• Troubleshooting reports and SQL Tuning.
• Developed Views, Functions, Stored Procedures, Packages, Synonyms.
• Extensively used PL/SQL, Tables, Cursors and exception handling.
• Write complex SQL queries and PL/SQL procedures to extract data from source tables of data warehouse.
• Used SQL* Loader for Data Conversions and to load the flat files.
• Used Oracle Export/Import utility Exported Oracle Inventory, Purchase, Planning data into FLAT files.
• Assigning appropriate responsibilities to users as per the requirement.
• Creating users, Scheduling, LOV and Responsibilities in System admin module.
• Create new Report and Register Reports in Oracle Applications using SysAdmin.
• Assigning reports to appropriate request groups.
• Build a Data model and Layout model.
• Installation of Desktop BI Publisher11.1.1.3 and design number of XML reports using XML PUBLISHER 5.0.0 that retrieves data directly in EXCEL SHEET and scheduled them, that was the biggest success of reports that finally decreases data manipulation time in excel.
• Customization of ORACLE standard Reports as per user requirement.
• Customized ORACLE standard form using FORM PERSONALIZATION in E-Business Suite 11.5.10.2.
• Assigning appropriate responsibilities to users as per the requirement.
• Administering and defining Concurrent Managers.

ENVIRONMENT: Reports 6i, Oracle 10g, SQL, PL/SQL, SQL*Loader, Import/Export utilities, Toad, Oracle E-Business Suite 11.5.10.2, WSFTP, Windows NT/2000/XP, DATA Loader, XML Publisher 5.0.0

Confidential

RESPONSIBILITIES:

• Analyzing user requirements and built SQL queries and PL/SQL Blocks.
• Built a Data model and Layout model.
• Registering Reports in Oracle Applications using SysAdmin.
• Assigning reports to appropriate request groups.
• Installation of Desktop BI Publisher11.1.1.3 and design number of XML reports using XML PUBLISHER 5.0.0 that retrieves data directly in EXCEL SHEET and scheduled them, that was the biggest success of reports that finally decreases data manipulation time in excel.
• Troubleshooting reports and SQL Tuning.
• Developed Views, Functions, Stored Procedures, and Packages using PL/SQL & SQL.
• Extensively used PL/SQL, Tables, Cursors and exception handling.
• Writing complex SQL queries and PL/SQL procedures to extract data from source tables of data warehouse.
• Worked in Creation of new Oracle Reports as well as modification of existing Reports According to Specification.
• Customization of ORACLE standard Reports as per user requirement.
• Customized ORACLE standard form using FORM PERSONALIZATION.
• Used SQL* Loader for Data Conversions and to load the flat files.
• Worked on DATA Loader for Data conversion like item detail, supplier & category conversion.
• Writing complex SQL scripts and PL/SQL packages, procedures to extract data from various source tables of data warehouse.
• Used Oracle Export /Import utility Exported Oracle Inventory, Purchase, Planning data into FLAT files.
• Creating users, Alert, Scheduling, LOV and Responsibilities in System admin module.
• Assigning appropriate responsibilities to users as per the requirement.
• Administering and defining Concurrent Managers.
• Creating SR and follow-up for the same in Oracle Metalink.
• Generated number of AUTO Email System in ORACLE E-Business Suite using PL/SQL programming.
• Also worked on to generate data from SQL query, wrapped them in Excel sheet, attached it to Auto Email and finally scheduled that application in end user log in.
• Team members were working on ETL Informatica tool for making summarized reports that are to be submitted to management for analysis. I was also one of the member of the said team and understand some basic concepts of ETL.

Environment: Reports 6i, Oracle 10g, SQL, PL/SQL, SQL*Loader, Import/Export, Toad, Oracle E-Business Suite 11.5.10.2, WSFTP, Windows NT/2000/XP, DATA Loader, XML Publisher 5.0.0, ETL Informatica

Confidential

RESPONSIBILITIES:

• Worked in creation of new Oracle reports as well as modification of existing reports according to Specification.
• Analyzing user requirements and build a SQL query and PL/SQL Block.
• Build a Data model and Layout model.
• Registering Reports in Oracle Applications using SysAdmin.
• Assigning reports to appropriate request groups.
• Developed Views, Functions, Stored Procedures, Packages using PL/SQL & SQL.
• Customization of ORACLE standard report as per user requirement.
• Writing complex SQL scripts and PL/SQL packages, procedures to extract data from various source tables of data warehouse.
• Regular AOL activities like creation of Value Sets, Enabling Flex Fields, and Registration of Reports.
• Testing and Debugging.
• Loading data from external source flat files into database tables using SQL* Loader (SQLLDR).
• Used Oracle Export /Import utility Exported Oracle Inventory, Purchase, Planning data into FLAT files.
• Assigning appropriate responsibilities to users as per the requirement.
• Creating users, Alert, Scheduling, LOV and Responsibilities in System admin module.
• Installation of Desktop BI Publisher11.1.1.3 and design number of XML reports using XML PUBLISHER 5.0.0 that retrieves data directly in EXCEL SHEET and scheduled them.

ENVIRONMENT: Reports 6i, Oracle 9i/10g, SQL, PL/SQL, SQL*Loader, Import/Export, Toad, Oracle E-Business Suite 11.5.10.2, WSFTP, Windows NT/2000/XP, DATA Loader

Confidential

RESPONSIBILITIES:

• Responsible for Admin activity like Install and maintain BI Tool software, Design & Control Role/User, Assign responsibility to Role, back up of Live instance of BI and Regular maintenance.
• Responsible for Training of BI Tool for new reports, Design PL/SQL Block in database to Developers, retrieve data & design data sheet according to functional requirements from system to end users.
• Responsible for analysis, design, management, development, testing and deployment for report to live system.
• Actively participated in Database Development, Design SQL & PL/SQL for third Party system like Elecon Eimco Web supplier PO System, MRN WIP System, Purchase Order Details, OSP Detail, Supplier Detail List, Check Printing System, MDA Label system
• Interaction with the users at all stages of development to ensure that development was as per user specifications
• Worked on the database design, normalization, PL/SQL programming
• Involved in testing, debugging, performance tuning, bugs fixing and documentation of the system

ENVIRONMENT: Oracle 9i, TOAD, SQL, Oracle E-Business Suite 11.5.10.2, 1 Key BI Agile Report Tool, PL/SQL

Confidential

RESPONSIBILITIES:

• Interaction with the users at all stages of report development to ensure that development was as per user specifications.
• Actively participated in Database Development for the entire system.
• Only responsible for making Reports, Requirement analysis, design, management, development, testing and deployment as report writer.
• Creating a Oracle Reports based on the requirements.
• Customization of ORACLE standard reports.
• Worked on the database design, normalization, PL/SQL programming.
• Involved in testing, debugging, performance tuning, bugs fixing and documentation of the reports.
• Involved with study of existing system, preparing the technical design to extract data from legacy system into Oracle Applications open interface tables.
• Interacting with Business users, gathering and analyzing requirements.
• Developing a query according to user requirements using SQL in TOAD.

ENVIRONMENT: Reports 6i, Oracle 9i, SQL, PL/SQL, SQL* Loader, Toad, Oracle E-Business Suite 11.5.10.2, WSFTP, Windows NT/2000/XP

Confidential

RESPONSIBILITIES:

• Responsible for making Reports, Requirement analysis, design, management, development, testing and deployment as report writer.
• Participated in Database Development for the entire system.
• Designing SQL queries.
• Identifying problems and taking corrective action.
• Interaction with the users at all stages of development to ensure that development was as per user specifications.
• Worked on the database design, normalization, SQL, PL/SQL programming.
• Involved in testing, debugging, performance tuning, bugs fixing and documentation of the system.

ENVIRONMENT: Oracle 9i, Report Builder 6i, Toad, SQL, PL/SQL