SUMMARY:

• Fifteen (15+) years of experience in Oracle analysis, design, and development under different Oracle Database 9i, 10g, 11g R1/R2, Oracle 12c Cloud
• Efficient, dedicated, intelligent and quick learning, with great problem solving abilities and own techniques.
• Skilled in software engineering and application development.
• Oracle Application Development: such as analyzing, designing and developing variety of business applications using Agile and SDLC Methodologies.
• Developed and accomplished many back end projects using Oracle PL/SQL database packages, triggers, stored procedures and functions.
• Key resource for supporting Hyperion Technology using Interactive Reporting (IR), SQR, and Informatica PowerCenter.
• Proficient in PL/SQL, SQL, Hyperion, Oracle Forms 10g/11g and Oracle Reports 10g/11g, Oracle APEX ver. 4.2, APEX 5.0 Adopter; Oracle FUSION Middleware 11.1, WebLogic Server 10.3, OBIEE 11.1 Analytics/Dashboards, BI Publisher
• Business Applications developed: Inventory/Purchasing/Manufacturing control, Job Scheduling, Cost Analysis, Banking System, Hotel/Reservation Management control, Payroll System, Manpower Resources, Cash Management System (CMS), Mobile Application (CRM), Timekeeping System and Clinical Trial Management System ( Confidential ), Email Campaigns, Marketing Online.
• Database Security using database encryption technology and byte - shifting programming method using object encryption and decryption. Build automated access rights by granting roles base on title levels, department and division. Advance security control using Fine-Grain-Auditing, Row-Level Security and Transparent Data Encryption.
• Developed ETL Applications using Informatica PowerCenter and Oracle Datawarehouse Builder (OWB) with varied applications from Staging, Object mappings and Data Transformations.
• Implemented ETL Automation process for Data Warehousing using Informatica PowerCenter, UNIX Scripts and Oracle Schedulers.
• Skillful both in front-end and back-end applications.
• System Developer: Develop various Oracle Applications using Advance PL/SQL programming, SQL, Oracle Forms and Oracle Reports, APEX 4.2/5.0, and SQL Server.
• ERP modules: Oracle E-Business Suite applications for accounts payable/accounts receivable, general ledger, fixed assets, and cash management.
• Data modeling using Entity Relationship diagram logical and physical model using Oracle Designer, Toad Data Modeler, Visio ER Diagram and CA ERWin application.
• Data Warehouse: Star Schema/Snowflakes, SQL Loader, PL/SQL, UTL FILE, data-pump, CUBE, ROLLUP, data extraction, filtering, validation and Oracle Analytical Function.
• Database Administration: Oracle Enterprise Manager (OEM), Single Sign-On, Data security like transparency encryption/decryption of databases, Oracle Application Server (AS 10g) configuration, creating database roles, building schemas and granting access rights to users.
• Performance Tuning using large databases, Tuned VLT, TKPROF, Explain Plan, SQL Hints, BULK collection, table functions, REF cursor, Indexes, table partitioning, pipeline and parallel processing.
• PL/SQL Performance tuning, tuned complex SQL queries, Materialized Views, Re-write complex SQL queries and debugging.
• UNIX Shells Scripting (BSH and KSH), DOS scripting and VB scripting.
• SQL Server 2014 Ver. 12; T-SQL using SSMS (Management); SSRS (Reporting), SSIS (Integration) and SSAS (Analysis) using Visual Studio SSDT (DataTools)
• UNIX, LINUX, COBOL, VMWare, Oracle VirtualBox, VM Manager/Server, Vista, XP, 2000, NT, Access, ODBC, Word, Excel, FrontPage, MS Outlook, Money, PowerPoint, MS Project, ADOBE Photoshop, etc.
• HP-UX, SUN Solaris, SUN 6800 Enterprise, SCO UNIX, AS/400, IBM S/36, Prime Information Plus, VAX/VMX, Red Hat Linux, DB2, COBOL Mainframe, UNISYS Clearpath IX4400 mainframe, Novell, Windows environment.

TECHNOLOGY VERSION:

Oracle: Database version 11g R2 latest.

Backend: SQL, PL/SQL, TOAD for Oracle version 11.5/12

Data Architecture: TOAD Data Modeler version 11.5/12

Version Code Control: VMS, Tortoise and Plan View Enterprise Management.

ETL: Data Warehouse Admin Console version 10.1.3 (DAC), Informatica PowerCenter version 9.6.1

OBIEE version 11.1: Analytics, Enterprise Management, WebLogic Server version 10.3, BI Admin Tool and BI-Publisher.

Oracle Business Intelligence: BI Admin Tools, OBIEE Analytics/Dashboards and WebLogic.

Oracle EPM: Enterprise Performance Management version 11 - Hyperion Financial Report (FR), Web Analysis, Interactive Report Studio (IR), SmartView, SQR programming and Essbase Cubes. SQL Server 2014 Ver. 12; T-SQL using SSMS (Management); SSRS (Reporting), SSIS (Integration) and SSAS (Analysis) using Visual Studio SSDT (DataTools)

Scripting: DOS batch scripts, VB Scripts and HPUX - Unix Shell scripts.

WORK EXPERIENCE:

Oracle Systems Analyst/Application Developer

Confidential, Whippany, NJ

Responsibilities:

• Developed and accomplished many back end projects using Oracle PL/SQL database packages, triggers, stored procedures and functions.
• Key resource for supporting Hyperion Technology, specifically Interactive Reporting (IR) and SQR.
• Developed multiple projects for PSI, FuelPak and ADDS systems;
• Integrated Inergy Application into ADDS System and FuelPak System.
• Built projects for ATLAS in SQL Server 2014 Ver. 12; Using SQL Server Tools: T-SQL using SSMS (Management); SSRS (Reporting), SSIS (Integration) and SSAS (Analysis) using Visual Studio SSDT (DataTools)
• Migrated PeopleSoft 9.1 to Data Warehouse for OBIEE 11.1 HR Analytics;
• Performed Data Warehousing, Performance Tuning, Data Architecture, Database Design, Data Modeling and Application Development.
• Develops applications using SDLC and Agile methodologies
• Facilitate meetings with managers, business users and end-users for new project plans;
• Study Business requirements and technical specifications for the project;
• Performs regression testing, QA and support migration plan plus build batch scripts for test/production migrations;
• Performs production support and fix remedies.
• Design exception handlers, data validations and error trapping, system control logs, error logging, trigger alerts, and send automated email alerts to application users (using PL/SQL)
• Build Front-End Application using Hyperion Interactive Reports (IR) and BI Publisher.
• Build Multi-Dimensional Database using OBIEE Admin Tool RPD.
• Build SQR, BI Publisher, Dashboards and KPI Reports
• Build extract files for Budget and Financial Planning in Oracle Database into Essbase Cubes.
• Build Automation Scripts for UC4 and other Job schedulers for the enterprise.
• Transported data from OLTP into OLAP environment;
• Built ETL using PL/SQL and Informatica PowerCenter for Enterprise Management and Financial Planning.
• Performs SQL Tuning, PL/SQL package profiling debugging and tuning.
• BI Publisher:
• Build Templates for National Accounts, ADDS, FuelPak and Position Sheets in different formats and layouts.
• Build Data Models and database connections, define joins and build data sets.
• Build custom reports for Accounting, Marketing departments and top Managers.
• Build custom prompts such as Accounts, Date range and other variables to filter the results
• Created reports using grids, custom aggregations, expressions, and measures.
• Created Scheduled reports daily, weekly, monthly or quarterly basis.
• Export reports into different formats such as XML, PDF, XLS and RTF files
• Created Burst reporting and deliver final report to different network location.

Tools: Various applications using Oracle Technologies - PL/SQL, SQL, Triggers, JavaScript, Hyperion FR, Web Analysis, SmartView, BI Publisher, InterActive Reports-IRs, SQRs and SQL Server.

Senior Oracle Consultant

Confidential, Trenton, NJ

Responsibilities:

• Responsibility is to develop data-warehouse for different pharmaceutical clients to load and extract customer's information, orders, surveys, email campaigns and others that are specific to client's brand names. This process involves data conversion, analysis and transformations from different environment such as mainframe-COBOL, DB2, SQL Server and others into Oracle Database 10g/11g.
• Translates business requirements into functional application requirements and logical data model requirements.
• Data migrated to Oracle Database are stored in standard tables used by Oracle Apps 11i Marketing for data analysis, budgeting, forecasting, state reporting and other data mining.
• Other technical jobs are to produce effective codes written in PL/SQL packages, applied UNIX scripts to facilitate the loading process from raw files and create database objects.
• ETL Data loads and Transformation using IBM InfoSphere DataStage 8.1
• Develop data base objects using PL/SQL to support the study specific requirements in Clinical Studies.
• Perform effective code reviews, maintaining standards and good practices.
• Assist in trouble shooting operational issues, resolve while maintaining good compliance practices.
• Document activities and work according to SOPs.
• Work with development team and users to enhance study development process
• Participate in creation, maintenance and update of development standards and best practices.
• PL/SQL Stored procedures using Fast Bulk collection, REF Cursor, UTL file, pipeline, transformation, autonomous blocks, others UNIX shell scripting: KSH Shell, Bourne Shell and Cronjobs.
• PL/SQL Performance tuning, tuned complex SQL quires, Materialized Views, Re-write complex SQL queries.
• Database: Administration like create schema, grant roles, create objects, Job scheduling, SQL*Loader, external tables, Triggers, SQL-99, SQL statement in file scripts, Other Technology: TOAD for Oracle v10, FTP: WinSCP3 and WS FTP Putty, MS Office/Visio, E-R win, EditPlus, BI Publisher and Adobe Photoshop.

Oracle Consultant

Confidential

Responsibilities:

• Primary job responsibility is developing an application for Clinical Trial Management System or Confidential .
• Confidential is an application designed to capitalize on enterprise data from the Oracle Clinical database or entered through the clinical data management process.
• Confidential provides managers with critical information necessary to successfully manage clinical trial projects.
• The system provides a robust set of tracking functions to enable informed decisions and is designed to be highly configurable to meet the needs of many different types of clinical sponsors as well as regional organizations within a single large corporate sponsor.
• Oracle Forms 10g Advanced Programming with WebUtil
• Create and developed complex Oracle Forms and Oracle Reports 10g
• Create and developed complex PL/SQL packages.
• Configured Oracle Application Server 10g (middle Tier).
• Integrate Java Program into Oracle Forms AS 10g, WebUtil, JAR files and Java Beans.
• UNIX Shell Scripting, Data Modeling.
• Knowledge transfer of finished project.
• Technology: Oracle Forms 10g, Oracle Reports 10g, ORACLE Database 10g, PL/SQL Developer, ORACLE AS 10g, PVCS Version Control, TOAD for Oracle v9.0.1, VMware Virtual Machine, ERWin Data Modeler, Linux OS, Windows XP, Vista and Windows 7

Oracle Consultant

Confidential, New York, NY

Responsibilities:

• Providing and developing a strategic set of intelligent controls for companies using Oracle based systems through the company's products/package services.
• Worked on the MENTIS' iCatalog, iAudit, iDocument, iMask, iScramble products/package services which create entirely dynamic, custom applications for organizations whose labor intensive processes make compliance difficult and/or which are no longer cost effective. The MENTIS pre-built framework components work independently from customizations and are built on the Oracle technology stack.
• Write technical design documents for conversions, extensions, interfaces, and reports.
• Works on iAutomate product which converts PDF reports into oracle database;
• Doing the needed enhancements and other maintenance to all of Mentis products/package services.
• Also working on MENTIS iScramble which is the only enterprise-class, full-security data scrambling product that protects non-production databases while maintaining full database functionality. A cost-effective solution for compliance, it provides safeguards that encryption cannot and without the performance load.
• Data modelling
• Adding new forms and stored procedures, PL/SQL codes for all of the Mentis products/package services.
• Technology: ORACLE E-Business Suite, ORACLE PL/SQL, SQL Loader, ORACLE Forms and Reports 6i/9i/10g, TOAD for Oracle, RDBMS, ERWin Data Modeler, Windows, UNIX

Senior Oracle Consultant

Confidential, New York, NY

Responsibilities:

• Build new applications to enhance Unified Timekeeping System (UTS) for their Business Enterprise using Oracle Forms, Reports, PL/SQL and RDBMS.
• Optimized written applications to accommodate large database. Fine tune source codes, PL/SQL packages & SQL scripts and re-engineer front-end applications thru Oracle Forms/Reports and back-end database structures to speed-up multi-processing tasks.
• Develop and support Unified Timekeeping System in an integrated Application Systems namely: 1. RTO - Rapid Transit Operations (Subways) Hourly/Bi-weekly schedule 2. DOB - Department of Buses (Buses) Hourly/Bi-weekly schedule
• Designed, developed and maintained Unified Timekeeping System for RTO (Department of Subways) and DOB (Department of Buses) using Oracle Forms, Reports, PL/SQL for following modules: PICK, CREW, TIMEKEEPING, LPC, ADMIN;
• Built codes thru Forms, Triggers, Procedures and object libraries;
• Created standards alerts, visual attributes, GUI (Graphics User Interface) used across all oracle forms;
• Built complex Oracle Forms, PLSQL, Forms triggers, multi-forms, REF cursor, dynamic record group, LOV and database objects;
• Passed multiple parameters to reports, forms, and PL/SQL packages and vice versa;
• Written heavy PL/SQL packages, implementing pipe line table functions, autonomous procedures and triggers.
• Built complex SQL, involving very large tables, tuned SQL using explain plan, TKPROF using TOAD (Tools for Oracle Application Developer).
• Create complex reports like hours of service reports, code summary reports and matrix reports.
• Used all features of PL/SQL like REF cursor, dynamic SQL, bulk collects, bulk binds.
• Performed lots of SQL tuning and PL/SQL code optimization techniques by using table functions, bind variables, bulk collects etc.
• Optimized database by using partitioned tables, using parallel SQL hints, indexes both bitmapped and binary, materialized views and dimension tables.
• Interact with different users to provide expert solutions for their application system.
• Design and develop security control thru Forms interface. To create and grant roles as a group user and grant these roles to individual users.
• Designed and developed data conversion programs based upon data mappings and conversion rules for EIS-HRMS and OnTrac-IVR applications.
• Design, develop and test routines and any necessary procedures before porting the modules to production.
• Identified candidate index fields based on reporting needs, and made recommendations, as required, for fields to be indexed; Indexed certain selected key fields to maximize reporting capabilities and provide efficient retrieval.
• Reports and ad-hoc queries launched under the GUI environment have optional capabilities to provide a variety of download or extract capabilities to permit data imports into MS Office products such as Excel, Access or Word.
• Developed lookup functions bases on UTS standards and business rules.
• Coordinate with technical and business staffs to review problems, develop solutions, assess progress and keep the project and all deliverables on schedule.
• Knowledge transfer of project deliverables and expertise to UTS staffs.
• Prepared user guide documentation for RTO and other reporting applications.
• Technology: Oracle AS 9i/10g: Forms 9i/10g, Reports 9i/10g, Oracle PL/SQL, Oracle RDBMS 10g and TOAD V8.6.1

SENIOR ORACLE Consultant

Confidential, New York, NY

Responsibilities:

• Convert Business logics from DB2 / COBOL programs to Oracle 10g on a WEB environment.
• Built Oracle Forms, Reports, PL/SQL codes on 3-Tier architecture using Oracle 10g.
• Designed and developed database architecture for Integrated Application Systems: • EPIS - Employees Payroll Information System (EPIS): 1. Pension/Loans System; 2. Budget System; 3. Manpower Analysis System (MAG); 4. Overtime System for EMS, Fire Dispatchers, FDNY Uniforms, Civilian Payroll
• Designed and developed GUI for EPIS using Oracle Forms and Reports for Pension, Budget, MAG and Overtime EMS, FDNY Uniforms/Civilians Payroll system.
• Design and create database structures in Oracle RDBMS 10g using Designer 2000 repository and E-R Diagramming/Data modeling.
• Building Database Schemas in data warehouse and data marts.
• Data warehousing: Transform flat files into staging tables using SQL*Loader, Oracle Import/Export and external tables.
• Data warehouse tuning: UTL FILE, Using dynamic cursor, REF Cursor, PL/SQL collection method e.g. BULK collection, FORALL, RETURNING.
• Built codes thru Oracle Forms, Triggers, Procedures and object libraries.
• Created standards alerts, visual attributes, GUI (Graphics User Interface) used across all oracle forms.
• Built complex Oracle Forms, PLSQL, Forms triggers, multi-forms, REF cursor, dynamic record group, List of Values (LOV) and database objects.
• Written lots of shell scripts to access SQL files, data loads from flat files, used SQL loader extensively.
• Build UNIX shell scripts and interact with ORACLE database and Forms/Reports.
• Shell scripting using Bourn shell, C shell and Korn shell; UNIX string manipulation like GREP, LS, PIPES and AWK utilities.
• Build PL/SQL packages for ETL. Created logical programs for extensive validation during extraction and loading of data into the data warehouse.
• Built Forms-Triggers, Procedures, attached libraries and PL/SQL Packages.
• Created standards alerts, visual attributes use across all oracle forms.
• Built complex oracle forms, triggers, stored procedures, multi-forms, matrix reports and package calls.
• Passed parameters to reports, forms and stored procedures.
• Interact with different users to provide expert solutions for application system;
• Designed and developed Security Control such as: Encryption and decryption of primary data like social security numbers and passwords.
• Single Sign-on thru Oracle Application Server using thick and thin clients method.
• Forms interface to create roles and grant these roles to individual users.
• Designed and developed data conversion programs based upon data mappings and conversion rules
• Designed, developed and tested routines, and any necessary procedures to load the data warehouse with operational data on an ongoing basis.
• Test and validate summary and detail reports based on production parallel run reports.
• Created external tables for intricate data validation based on Fact tables in data warehouse.
• Tuned the physical Oracle database for optimal performance of data loads and documented reports.
• Developed a graphical user interface GUI to create, modify and distribute reports and queries.
• Identified candidate index fields based on reporting needs, and made recommendations, as required, for fields to be indexed.
• Indexed certain selected key fields to maximize reporting capabilities and provide efficient retrieval.
• Developed a set of "canned" reports that permits screen display and provides an option to print to a specified printer.
• Shell scripting using Bourn shell, C shell and Korn shell; UNIX string manipulation like GREP, LS, PIPES and AWK utilities.
• Reports and ad-hoc queries launched under the GUI environment have optional capabilities to provide a variety of download or extract capabilities to permit data imports into MS Office products such as Excel, Access or Word.
• Developed lookup functions specified by the FDNY standard Business Rules.
• Prepared user guide documentation for reporting application.
• Setup meetings which informs about the progress of the project; Bi-weekly status meetings which assess progress, review problems, develop solutions, and keep the project and all deliverables on schedule.
• Knowledge transfer of project deliverables and expertise to developers.
• Conducted training and presentation to developers and end-users.
• Performed Data Analysis.
• Terabytes of data: maintain at least 10 years of historical data.
• Logical Data Model (Entity Relationship Diagram), and described entities, attributes, data relationships (including the "as-is" scenario data).
• Network Users: Approximate 1000 users.

Technology: Oracle 10g, COBOL, DB2, Sun 6800 Enterprise, UNISYS ClearPath IX4400 mainframe, UNIX Sun Solaris version 8, Apache Web Server, VAX Unisys, Windows NT/2000, TCP/IP, IPX/SPX, CISCO, Netware, UNIX, NT, Intranet and Web Internet, Oracle Developer Suite 10g: Forms 10g, Reports 10g, Enterprise Manager 10g, Designer 2000, Discoverer 10g, TOAD Version 8.0.1, PL/SQL Builder, SQL Navigator, Unix Shell Scripts, SQL Loader, ERwinData Modeler, Oracle RDBMS 10g - Applications used in performance Tuning: Materialized Views, TKPROF, SQL Hints, Indexes, table partitioning and Data pump.

Senior Oracle Developer

Confidential, Naples, Florida

Responsibilities:

• Responsible for design and development of assigned functional areas of Confidential products
• Developed Oracle Forms 10g, Reports 10g and PL/SQL packages for Confidential -Fidelio Products: 1. Opera Product Management System; 2. Opera Vacation & Ownership System; 3. Opera Sales & Catering System
• Tasks include writing functional specifications, design documentation, coding, unit testing, debugging, integration, performance tuning, and maintenance of assigned software modules
• Provides information to documenters, testers and customer service personnel on features and functionality of software modules

Technology: ORACLE RDBMS 9i/10g, Windows 2000 Professional, Windows XP, UNIX, SUNS Enterprise, HP-UX, ORACLE FORMS 6i/9i/10g, REPORTS 6i/9i/10g and SQL Navigator

Oracle Consultant

Confidential, Chicago, Illinois

Responsibilities:

• Data Warehousing: Building Database Schemas using SQL*Loader, Oracle Import/Export and Dimensional Database Design using Oracle Designer 9i for email campaign and catalog campaign.
• Data warehouse tuning: UTL FILE, Using dynamic cursor, REF Cursor, PL/SQL collection method e.g. BULK collection, FORALL, RETURNING.
• Deployed applications on web using Oracle Forms and PL/SQL packages in 9iAS and 10g
• Worked on periodic in-house email campaigns as a means of marketing to their customer base. Within each email campaign various offers are made to consumers in an effort to generate additional sales.
• Added multiple brands under the Confidential umbrella to process need to be updated so that subscribe and unsubscribe address multiple brands.
• Directly supports FTD company goals by allowing retention marketing to market to individual brands.
• Develop a process by which a customer can be subscribe or unsubscribe from one or many brands.
• Shell scripting using Bourn, C and Korn shells; UNIX string manipulation like GREP, LS, PIPES and AWK utilities.
• Develop a process by which the customer subscribe information is in sync across all Confidential platforms - Novator, HP system, DW system running in Oracle RDBMS.
• Deployed applications for executing the Stored Packages
• Involved in PL/SQL programming for Store Procedures.
• Wrote quality PL/SQL procedure, functions, Triggers to maintain data integrity.
• Wrote quality Oracle PL/SQL code, created database schemas and scripts to make necessary tables, views, indexes, synonyms and assign privileges; also included comments in the code and additional documentation to support design, development and testing
• Worked directly with user groups, management and other team members to analyze, review, evaluate business system or user's requests, and wrote detailed description of user needs, program functions and steps required to develop or modify computer programs; provided support for other business analysts, programmers, and user groups.
• Provided daily production support of various systems and business applications.
• Performed various ad-hoc reporting on demand.
• Involved in data manipulation; data structures; testing.
• Created detailed unit and system test plans for all system modifications

Technology: Oracle RDBMS 9i, PL/SQL, SQL, Stored Procedures, Oracle Forms 9i, Reports 9i, Designer 9i, SQL*Loader, Oracle Import /Export, Unix Shell Scripting, Oracle Enterprise Manager, SQL Navigator 4.0, UNIX and Win NT, Novell, Sun Solaris, HP UX

Oracle Programmer Analyst

Confidential, Tampa, Florida

Responsibilities:

• Involved in building Enterprise wide Logical and Physical database design using the Designer 6i/9i.
• Configured and deployed Forms and Reports to the Forms 6i and Reports Server.
• Installation and set-up of Oracle 9i/8i database.
• Created and developed Oracle Schema objects like Tables, Indexes.
• Involved in process of normalization. Developed Entity relational Diagrams (ERD).
• Involved in SQL & PL/SQL programming for stored procedures.
• Involved in extraction and loading of data from legacy system (Mainframe) to Oracle database.
• Worked on performance tuning of SQL queries involved in the reports, indexes, and partitioned tables to improve overall system performance.
• Deployed applications on web using Oracle 9i/AS Portal and Application Server.
• Worked on creating interfaces using PL/SQL process and Pro*C and created load programs to load data from flat files with necessary business validations.
• Extracting and Loading the data from previous VAX/VMS based systems. (SQL Loader, Import/ Export, Batch programs) loading into temporary tables and cleaning/correcting data using PL/SQL and transferring to respective production tables.
• Generated Triggers for data integrity, Created views to resolve complex queries.
• Designed and created Oracle database objects, Roles/Privileges and schemas.
• Used SQL*Loader to load data from Mainframe into Oracle database.
• Wrote PL/SQL procedure, functions, Triggers to maintain data integrity.
• Involved in assisting front-end development in JSP to create user reports fetching data.
• Worked on creating batch programs using C-Shell and developed Oracle jobs.
• Developed Oracle JOBS for executing the Stored Packages.
• Assisted the DBA while designing and creating database schemas
• Performed regular Database Administration tasks like Backup & Recovery, Server Fine Tuning and Maintenance.
• Fine tune SQL queries and resolve performance issues.
• Web enabled Oracle reports using Reports 6i and put it on the Intranet for the managers

Technology: Oracle RDBMS 9i AS, PL/SQL, SQL, Pro*C, XML, HTML, Oracle Forms 6i, Reports 6i, Designer 6i, Stored Procedures, SQL*Loader, Import/Export, Shell Scripts, SQL Navigator 4.0, UNIX and Win NT

Oracle Consultant

Confidential

Responsibilities:

• Developing Oracle Forms/Menus/Reports 6i with extensive used of PL/SQL programming, SQL*Plus, Database Functions, Stored Procedures and Database Triggers for customized systems applications
• Perform system analysis and design using Oracle Designer
• Data modeling and E-R diagramming.
• Database migration and integration to new Oracle applications using oracle tools: SQL*Loader, Procedure Builder, SQL*Net and Oracle Enterprise Manager
• Involve in Oracle DBA installation and configuration to speed-up major applications. Build WEB Portals, libraries of functions and stored procedures. Built customized security control for multi-user environment attached to automated job roles and individual access rights.
• Building business applications in Oracle Forms, Reports, event triggers, stored procedures, and functions in PL/SQL for entire systems life cycle in development process.

Technology: Oracle RDBMS 8, Oracle FORMS 6, Oracle REPORTS 6, and Oracle Workflow Designer, Oracle Enterprise Management, PL/SQL, SQL*Plus, SQL*Loader, Procedure Builder, SQL*Net, Oracle e-Business Suite, MS Access, FrontPage, JDeveloper, HTML, XML, EXCEL, Windows XP and UNIX Shell Scripts