- Featured in:
More ORACLE Developer Resumes
Use these ORACLE Developer samples as a guideline or visit our extensive library of customizable resume templates.
High Quality
The best examples from thousands of real-world resumes
Expert Approved
Handpicked by resume experts based on rigorous standards
Diverse Examples
Tailored for various backgrounds and experience levels
Additional Computer Software Resume Samples
ORACLE Developer Resume Samples
No results found
0-5 years of experience
Spearheaded formation, development, and deployment of SysAdmiral software for the migration of Unix shell scripts for crontab to GUI interface. Supported management in automating night processes, reports development, and ITS hierarchy. Served as lead ITS deployment manager and analyst charged with development and oversight of 4 person team, establishment of key operating capabilities, and creation of performance metrics. Provided 24/7 support for Unix Korn and Bourne shells within data warehouse environment.
- Organized and rewrote cycle process UNIX and Dos batch scripts on Third Party Tool (SysAdmiral).
- Designed/modified/implemented stored procedures, triggers in Oracle 8.0.6 using PL/SQL.
- Increased performance, speed, and error handling of process by 60%.
- Designed, developed, coded, tested, documented, and implemented data modeling features using TOAD and other third party tools.
- Oversaw troubleshooting UNIX macros, SQL scripts, and SQR reports.
0-5 years of experience
Spearheaded formation, development, and deployment of SysAdmiral software for the migration of Unix shell scripts for crontab to GUI interface. Supported management in automating night processes, reports development, and ITS hierarchy. Served as lead ITS deployment manager and analyst charged with development and oversight of 4 person team, establishment of key operating capabilities, and creation of performance metrics. Provided 24/7 support for Unix Korn and Bourne shells within data warehouse environment.
- Organized and rewrote cycle process UNIX and Dos batch scripts on Third Party Tool (SysAdmiral).
- Designed/modified/implemented stored procedures, triggers in Oracle 8.0.6 using PL/SQL.
- Increased performance, speed, and error handling of process by 60%.
- Designed, developed, coded, tested, documented, and implemented data modeling features using TOAD and other third party tools.
- Oversaw troubleshooting UNIX macros, SQL scripts, and SQR reports.
0-5 years of experience
Developed and managed multiple full-lifecycle projects related to shipping farm - P&O Nedlloyd (load list, discharge list, package tracking etc.) and mortgage farm (Yorkshire Building Society).
- Served as technical point of excellence for many company-wide projects. Successfully lead the development of a terminal manager system (part of a larger system) that streamlined load list, discharge list for vessels. Played a crucial role during application architecture and system design.
- Developed, reviewed, and recommended systems and procedures for developing applications using Computer Aided Software Engineering (CASE).
- Developed a number of forms and reports using Developer/2000.
- Developing the Attached Library (PLL).
- Developing the Batch Programs in PRO* C
- Module Testing and Supporting the Pre-Acceptance as well as User Acceptance Testing for the Life Insurance module of the YBS application system.
0-5 years of experience
Team partner in setting up and managing Oracle's OTM software in their EBS system.
- Responsible for the construction of Bradford White's logistics website, which brought customers and shipping partners
- Helped increase the efficiency of Bradford White's EBS by improving queries and reducing user's resource load.
- Identified and reduced LTL damages and shipping errors with the creation of a damage tracking system that linked directly both into their EBS and quotation systems.
0-5 years of experience
Installed, upgraded, and configured SQL Server 2000, 2005, 2008 and 2012 for production and test databases environments.
- Created SQL Server tasks, wrote script for heath check, backup, and installed and supported transactional replication
- Involved in reviewing third party code for performance issues using SQL
- Planned, tested and implemented data migration from MS Access database to SQL server and optimized application access.
0-5 years of experience
PBGC is in the process of implementing Oracle E-Business Suite for Premium and Practitioner System (PPS). PPS contains plan data of all Pension Benefit program participants and is updated with information, plan terminations, and coverage determination. Depending on the information retrieved, PPS may stop sending notices to Plan Administrators or change the plan status.
- Designed and Developed interfaces.
- Gathering requirements from the client
- Coordinating the work within the team and presenting demos to the client for every stage of the project
- Created new custom Reports, Forms and modified existing Reports according to the requirement.
0-5 years of experience
Designed, developed, implemented, and maintained new corporate website using ASP and IIS technology that better promoted the Lumenos brand
- Created COM object for web application and database access using Visual C/C++ and Visual Basic as well as Configured Eprise as Content Management tool that reduced the time required for maintainence
- Installed and maintained MS Biztalk Server for Business-to-Business data transfer as well as applied XML to create data structure for Biztalk application that increased the number of businesses with which data transfers could be made
- Maintained and administered SQL Server and Oracle databases using SQL and PL/SQL
0-5 years of experience
This project is intended to develop a customer data warehouse to understand customer behavior to various Loans related programs and identify critical customers in support of improved decision-making across the organization.
- Maintained and developed user requested features to a web based Warehouse Catering System.
- Designed and developed the interface program to Import item master using SQL*Loader, PL/SQL package and Import through Concurrent program.
- Created views, procedures, and functions, packages in the Oracle Database using PL-SQL, T-SQL, DML, DDL, SQL/PLUS on MS SQL Server 2005.
- ETL development using PL/SQL, analysis of the existing database, BULK loading, Data Partitioning in order to load the data in Oracle Database.
- Performance Tuning using HINTS to improve performance of the Oracle database.
0-5 years of experience
This project is intended to develop a customer data warehouse to understand customer behavior to various Loans related programs and identify critical customers in support of improved decision-making across the organization.
- Maintained and developed user requested features to a web based Warehouse Catering System.
- Designed and developed the interface program to Import item master using SQL*Loader, PL/SQL package and Import through Concurrent program.
- Created views, procedures, and functions, packages in the Oracle Database using PL-SQL, T-SQL, DML, DDL, SQL/PLUS on MS SQL Server 2005.
- ETL development using PL/SQL, analysis of the existing database, BULK loading, Data Partitioning in order to load the data in Oracle Database.
- Performance Tuning using HINTS to improve performance of the Oracle database.
0-5 years of experience
The project was involved in the re-engineering and automation of the merchandising transactions among warehouses, vendors and stores of the client.
- Conducted a seminar on how to use Designer and Develop 2000 to both development and testing teams.
- Established standards in programming.
- Analyzed the Information and System Architecture to come up with the detailed design of the system.
- Developed moderate to complex objects for core records.
- Coached junior programmers in development.
- Provided support to users during UAT (User Acceptance Test) and post go-live.
- Prepared the technical specifications and user's manual.
- Examined change requests to come up with the impact analysis.
0-5 years of experience
Managed five Visual Basic 6.0 developers, three Oracle 8 developers and four QA Testers in the pre-production, QA phase of a mission-critical, Editorial Management System.
- Developed and documented software tasks in the Test Director tool.
- Managed and prioritized the last 300 tasks created by developers, users and QA people.
- Coded VB 6.0 code and Oracle PL/SQL to fix 10 software bugs.
0-5 years of experience
Responsible for writing technical requirements and creating design documents for JAM. Creating, troubleshooting and enhancing complex forms and reports for JAM. The application (JAM) is AT&T's Construction and Management tool. In a single application JAM provides a standard platform for creating high level preliminary cost estimates, creating detailed project cost estimates, ordering and inventorying material and services, reporting construction time and material disbursement and tracing job progress
- Created Database triggers, and also wrote database triggers to avoid mutation of tables.
- Wrote a procedure to skip a locked record while performing DML operations on a table.
- Designed and created new admin forms to meet the new requirements due to the merger with other telecom companies.
0-5 years of experience
- Developed and customized Oracle Forms and Reports for the Invoice Processing System and Equipment tracking modules.
- Designed database schema, custom Forms and developed server-side PL/SQL (ETL) modules to map data from the Dreyer's Ice Cream GL in Oracle Applications into SAP (Nestle GLOBE system). Maintained Unix cron entries for shell/perl scripts.
- Customized and enhanced Oracle forms for the Partner Brand Promotion and Billbacks module.
- Development environment: Toad, PL/SQL, Oracle Forms 10g and 11i, Forms Generator Reports, Designer, Shell Script, SQL*Loader, XML, Perl, Appworx, CRON.
0-5 years of experience
Enhanced existing procedural source codes as dictated by business rules
- Analyzed and used Constellar hub to ETL source data for datawarehousing
- Enhanced existing process of Constellar interfaces as dictated by business rules
- Modified UNIX script files
- Developed and executed AppWorx chains to schedule and run various modules
- Created test data to run and evaluate enhancements and interfaces
- Documented and produced test summary results
0-5 years of experience
DSS Health applications using Oracle 9(i), Sun Solaris, MS Access, Windows 2000, Emberkadero, VSS.
- Developed OLAP reports writing complex SQL scripts, PL/SQL packages, procedures, functions for Business Objects reports on the operating system unix and Windows2000.
- Wrote Database triggers for business rules.
- Involved in data mapping for tables and columns in multiple databases for ETL transaction using Informatica
- Used MS access for data checks before loading into destination tables.
0-5 years of experience
Part of the global implementation team responsible for implementing Oracle E-Business Suite 11.5.10 CU2 with multi-language and multi currency requirements. The modules involved are Financials, Inventory, Purchasing, Order Management.
- Designed check printing programs using XML Publisher to print checks on both pre-printed and blank checks stock for HSBC Bank (Mexico), Bank of America (US and Canada) in English and Spanish languages. Nearly 10K checks were printed per month using these programs.
- Designed and developed solutions for paying global vendors electronically through Oracle Payables using EFT/ACH file formats for HSBC bank, Bank of America, CommerzBank.
- Designed and developed interfaces for importing vendors, invoices, tax information (VAT & Withholding), banks, journals from other systems into Oracle 11i
- Created email notifications using Oracle Workflow Builder 2.6.3 for alerting certain individuals who are not part of the PO requisition approval hierarchy, for emailing some custom revenue and inventory reports
- Setup Purchase Requisition approval using Approval Management (AME) as per the complex business rules.
- Setup AME based approvals for Oracle Payables and modified the standard workflow to satisfy the need of parallel approval mechanism
0-5 years of experience
Insurance Related industry
- Designed and Developed Java applets for Database as a part adding the new Carrier and Policy in the Database by using JDeveloper and JBuilder tools.
- Tested the final Application for the quality assurance and performance purpose.
- Wrote dynamic SQL scripts to populate the data in different schema.
- Coordinated all design, development, integration, testing and documentation for Web Based application enabling competitive pricing option for user's Insurance needs.
- Wrote procedure for getting the list of questions based on Exchange, Jurisdiction and Policy for Insurance Industry.
- Involved in the design phase of prototype model for the Underwriting Engine, Warehouse design Projects.
0-5 years of experience
Developed a PL/SQL program for a banking client to generate complex credit information on a monthly basis. This accelerated the process of credit information extraction and presentation by 90%.
- Gathered report requirements, customized existing reports, designed, developed and deployed new reports in Oracle E-Business Suite 11i modules such as Payables, Receivables, General Ledger, Order Management, Inventory, Purchasing and Work in Process. These reports increased user accountability and understanding of complex technical and business concepts in clear and simple terms.
- Outlined steps in the creation of scripts used to accurately migrate financial data from Microsoft Navision to Oracle E-Business Suite. Ensuring Data validity, successful data loading and generation of reports on the processes. This allowed for a centralized financial reconciliation from Oracle E-Business Suite.
- Provided development support for interfacing data from legacy systems to Oracle Financials utilizing SQL*Loader, SQL*Plus, PL/SQL.
- Interacted with clients to help them in understand complex technical and business concepts, convinced management on beneficial propositions, assigned work to team members and ensured work was done.
- Provided both Functional and technical support on Oracle Financial, Order Management and Discrete Manufacturing modules.
- Trained new and existing users on Oracle E business suite payables and order management modules
- Developed and maintained documentation for various ERP processes and operations.
0-5 years of experience
Perform all DBA and system administration tasks in an Oracle 9i, 11g and MS Hyper-V environment. Setup virtual servers and installed Oracle 11g databases utilizing Oracle ASM for storage.
- Converted Oracle 6i Forms/Reports client/server applications to Oracle 11g Forms/Reports
- Migrated existing applications and database from Oracle 9i to 11g.
- Programmed ETL applications using SQL*Loader and PL/SQL to load data from external sources.
- Created PL/SQL procedures and functions to support Ecommerce on company website.
- Designed and installed PL/SQL package to allow external dental offices to check member eligibility.
0-5 years of experience
Involved in identifying and analyzing user requirements, preparing testing specs, database designing.
- Involved in development of online intranet Leave application & Time sheet management /HR payroll is for board wide use.
- Involved in designing database schema and implementing the software.
- Developed User Interface screens (GUI's) with Visual Basic.
- Created Stored Procedures and triggers.
- Involved in analyzing user requirements.
- Created the Tables, Views, Stored Procedures, Triggers and generated DDL and DML scripts.
- Involved in design, development and modification of PL/SQL stored procedures, functions, packages, and triggers to implement business rules into the application.
- Performance tuning of SQL queries, checking the most expensive queries using Explain Plan.
0-5 years of experience
Identification of the base tables/columns in 11.0.3 of the entities mentioned.
- Mapping the TMAPI columns to the ERP columns.
- Register concurrent programs.
- Knowledge transfer of the Oracle Applications SCM and Manufacturing modules to the third party.
- Involved in mapping the legacy system database columns mapping to the Oracle Applications table columns and prepared the mapping documents for the same.
- Developed custom programs for loading the data from the staging tables into the Oracle Open Interfaces tables
0-5 years of experience
Participated and contributed in planning, designing and developing major enhancements to the Customer Service and Billing System. Primary liaison between development team and other organizational units to ensure flow of accurate information to and from development team
- Extensively involved in various activities of the project like information gathering, analyzing and documenting the functional or business requirements using the SDM Methodology.
- Interacted with external vendors in finalizing the business requirements.
- Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
- Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
- Implemented security measures to the screens depending upon the profile of the user.
- Used the TWS/Maestro Job Scheduler to schedule the batch runs.
0-5 years of experience
As part of the Post R6 Priority Project Team, we were responsible to implement all the projects and incident tickets that have been pending due to Amisys upgrade from R4 to R6. This project involved working with PL/SQL, Unix Shell scripting and COBOL.
- Gathered requirements from Users and Business Analysts to perform technical analysis.
- Update existing data model to accommodate changes required for new projects.
- Update existing code to make sure that they are more developer friendly.
- Utilized UTL_FILE packages to create RAPS files to send to CMS on a monthly basis.
- Performance tuned the existing modules using Explain Plan and SQL Trace to reduce the execution time by fixing sql queries, using partitioning concepts, indexes and hints.
- Performed unit testing and user acceptance testing.
- Present changes to the governance team for approvals and coordinate with the admins for the changes to be promoted to production.
0-5 years of experience
Participate in the Unit and QA process through code review, test case and release notes preparation.
- Perform a variety of tasks that include: running stored procedures, creating functions, tuning, writing, updating and deleting SQL queries to improve productivity and batch process.
- Support existing applications and develop new applications using PL/SQL and Oracle Developer.
- Managed communication between Finance and IT. In charge of variances between all pawn stores and the financial books.
- Respond to discrepancies and corrected the data when necessary or request a Journal Entry for un-explicable variances. On call system support 24/7 for production issues affecting the batch process.
0-5 years of experience
Member of the VN-FAS development team responsible for providing a system to perform hedge effectiveness testing as per FAS133 regulations on stand-alone derivative portfolios.
- Interfaced with users to determine requirements for database design, screen layouts, backend processes and reports generation.
- Designed logical and physical data models using Oracle Designer 2000.
- Designed and built front-end web interfaces using Oracle PL/SQL, Java, Java Server Pages (JSP), HTML, JavaScript, and JDBC.
- Developed backend processes including stored packages/procedures, servlets, database triggers and Unix Korn Shell scripts, using Oracle 9i/10g, PL/SQL, Oracle XML API's, Java.
- Developed complex web reports using Oracle Reports 9i, OracleBI Discoverer Plus, PL/SQL and Oracle XML.
0-5 years of experience
Technical environment includes: Oracle 10g, PL/SQL, Triggers, Procedures, HTML, SQL*Loader
- Responsible for optimization of internal Application express productivity applications.
- Worked with a fairly large dataset (50MM+ Records)
- Distil the data down to the individual level for supervisors and managers.
- Perform Tuning process on database
- Developed data models to help track location of tables that are no longer in use.
0-5 years of experience
- Servigistics project goal is to consolidate 3 Xelus regional systems into single cloud based solution in partnership with vendor. Estimated saving of $20 million and consolidate ~200 regional planner/buyer to 50 global planner/buyers with global visibility of parts inventory. This can result into lean inventory and global streamlined business processes.
- Architected ETL solution, data model, data standards and development solution for 10+ developers. This database contains all Dell active asset warranty components for parts planning to meet Dell customer NBD/SBD warranty contracts.
- Worked with Golden Gate team to perform real time ER replication of all Service Tag related information into SVG repository. This Oracle database solution is 10-20 TB in size.
- Developed complex PL/SQL scripts in short time period to help team.
- Oracle SQL tuning to process 1 billion plus Dell active components from 72+ hours to <15 min. Many more cases of optimizing Oracle database bulk data processing.
- Trip to Brazil to onboard junior developers and solution architecture overview.
- Data interlock contact person for 20+ Dell upstream and downstream applications.
6-10 years of experience
Oracle ERP suite 10g and major player of Implementation of Oracle ERP suite 11i. Plan and design interface tables as well as developing all necessary procedures to extract, verify and load data into interface tables using ETL methodology.
- Design and modify seeded Oracle Order Management workflows to best satisfy organizational needs.
- Worked on a project to upgrade Oracle application EBS from 11i to R12. I have identified all differences between 11i and R12. All designs and coding were finished and Performed successful unit testings.
- One man Oracle Production support team to support all Oracle order to cash processes. Identify and fix all order issues. Make sure all orders are processed without any delays.
- Design and implement an automatic procedure to load forecast data into MRP interface table, and then use Oracle planning manager to generate forecast data for company purchasing department.
- Design and print locator labels for all company warehouses using Loftware.
- Design and implemented customized Forms using Oracle Forms, and registered the Forms in Oracle Application 10g and 11i ERP modules.
- Design and implemented customized Reports using Oracle Reports, and registered the report in Oracle Application 10g and 11i ERP modules.
0-5 years of experience
Wall Street -ORD is a key middle / back office settlement system for Money Market and FX trades and is also used to settle cash-flows from various internal/external systems.
- Involvement from production support, BAU enhancements to full life cycle project development.
- Enhanced various ORD interfaces for Finance, Data Warehouse, and Risk systems as a part of Ulster integration project.
- Developed a real-time XML messaging feeds in Java/Oracle to publish trade lifecycle data to the Finance department's accounting system.
- Designed and developed reconciliation data feed for finance, counterparty static data feed for Nucleus, and trade data for Calypso.
- Troubleshooting, performance tuning, bug fixes and process improvements.
- Looking after the ORD Second line support mailbox for any reported user issue, queries and enhancements requests.
- Dev/UAT database environment maintenance, UAT support, overnight batch support.
- Technologies: Oracle 10g, PL/SQL, SQL, Java, Unix/Linux, Unix Shell Scripts, Oracle APEX, Oracle 9iAS, Oracle Discoverer 9i, Autosys, MQ / Argon messaging.
0-5 years of experience
Oracle developer using TOAD, Tivoli, PL SQL on UNIX/Linux servers on Data Warehousing/EDI/Financial projects.
- Populated Oracle staging tables with the data form the ASCII files, using sql loader utility, with the conventional and direct path load.
- Created Oracle External tables to load data into the database.
- Developed Oracle PL SQL stored procedures, functions, packages using the debugging features of TOAD and SQL Navigator.
- Developed Microfocus Cobol programs and Korn shell scripts that manipulate data that resided on UNIX servers.
- Extensive use of UNIX utilities (awk, sed, grep, sort ) and vi editor.
- Developed reports in Cognos for Novartis Marketing department.
10+ years of experience
Data Feeds Five Project
- Developed tables, packages, and procedures to deliver on-demand XML based files that include all information on individual Lipper Funds. Process uses Oracle XML functions, Oracle file system manipulation procedures, and XMLType tables.
- Built a financial Securities Master database for the Lipper Mutual Fund Analysis division. System managed equity and fixed income security information for all the securities on all the
- Technical Lead for the Lipper Portfolio Renewal Project. Designed and developed a Fund Holdings identification application that matched securities to unidentified holdings. Used auto-code matching, intelligent name recognition using Oracle Text (Context & Catalog Domain Indexes), and a front-end user Holdings Recognition application. Built schemas, tables, indexes, PL/SQL procedures, functions, table partitions, packages, external tables, queries, ETL, and tuned queries and procedures using DBMS explain plan and the DBMS profiler.
- Lead Database Developer. Integrated an acquired product to use Lipper Databases and re-developed analytics front-end application. This product is used to connect Plan Sponsors with Investment Managers and Pension Fund Consultants.
- Built and supported the ETL and replication of fund and portfolio data throughout the entire lifecyle (collection, data massaging, replication, client distribution). Used Oracle DBMS technology such as streams, change data capture (CDC) , DB Links, pipelined table functions and materialized views to ensure premium performance. Lipper is the database of record for all [company name] fund and portfolio information, so these databases feed high-profile products such as [company name] Eikon, Thomson One, Datascope, Reuters 3000Xtra, Lipper for Investment Management, and Wealth Manager.
- Built and supported portfolio holdings data feed to the Thomson One product's Ownership Module. Developed IDN price feed that provided hourly fund prices to [company name] applications and various Lipper clients. Design and developed multiple custom feeds for Merrill Lynch.
- Developed price control system with rules validation to automatically hold prices outside of normal range and a system for end users to validate and push through prices. Developed a price estimation routine that used Oracle bulk processing and analytic functions.
0-5 years of experience
Oracle developer within the National Oilwell Varco Oracle EBS advance team responsible for development of [company name] workflows and Oracle stored procedures.
- Developed part duplicate analysis workflows and RDD stored procedures to ensure conversion of NOV's sites to Oracle EBS were accurate and issue free as possible.
- Developed, tested and QA-ed ETL workflows and Oracle stored procedures.
- Developed complex [company name] workflows that read in a conversion site's raw data files to perform many data validation and business rule checks to ensure errors were resolved early in the Oracle EBS conversion process.
0-5 years of experience
Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
- Implement PL/SQL Logging concepts across the team using LOG4PLSQL.
- Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
- Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and
- Used Bulk Collect feature to improve performance.
0-5 years of experience
Integral member of the Default IT Data architecture team providing database support to the ETL and other application development teams.
- Created PL/SQL Stored procedures, database tables, views, synonyms, DDL scripts.
- Work with application development team to develop and refine database architectures, coding standards and best practices.
- Performance tuning of a PL/SQL code using Bulk Processing.
- Involved in data modeling and database design of staging tables
- Responsible for migrating code from Development to UAT and Production environments. Worked closely with DBA's to resolve production/UAT database issue.
- Lead the project of migration of application database from one database environment to the other. Involved in database design, object creation and sizing.
- Responsible for managing, coordinating tasks with the offshore team and reviews on the design and code frequently to ensure the site standards are being adhered to.
0-5 years of experience
Creating new responsibilities and defining the required system profile options.
- Developing and Customising various reports and forms in Oracle Financials using Oracle Reports 6i and Oracle Forms 6i.
- Worked on Oracle Financials and Oracle Purchasing Modules AP, AR, GL, PO and Inventory to provide support to the clients and solving the issues.
- Enabled and defined various Key Flex fields and Descriptive Flex fields.
- Creating the user, printers, responsibilities, request groups and creating value set and assigning its values.
- Using FNDLOAD for Messages and Responsibilities templates migration from one instances to other instances.
0-5 years of experience
Developed a new Application/Database systems using Oracle 8i/9i Database and Oracle SQL , PL/SQL, Program Units (i.e. Functions, Procedures, Packages, DB Triggers) as well as Oracle Developer Suite 6i/9i(Forms/Reports)
- Developed, Supported, Maintained, Tested, migrated and integrated the new and old Database system/applications that have been developed Oracle DB 8/8i , Oracle DB 9i and Oracle Developer Suite 2000/6I/9I (forms, report)
- Developing the business rules According to functional requirements - code scripting using Oracle DB, SQL, PL/SQL, Program Unit (Functions, Procedures, Packages , DB Triggers)
- Migrated Oracle database and data/application from Oracle 8i to Oracle 9i backend and from Oracle Developer Suite 2000 (Form/Report) 2.5 to Oracle Developer Suite 6i (Form/Report) 6I and from Oracle Developer Suite 6i (Form/Report) to Oracle 9i Developer 9i Suite (Forms/Report)
0-5 years of experience
Supported Virginia Department of Environmental Quality (DEQ) in Oracle applications development and performed unit testing
- Used Oracle Form6.0, Report6.0 to accomplish full life cycle development of Virginia Petroleum Storage Tank Fund Reimbursement application module
- Coded in PL/SQL Triggers, Procedures, Functions, and Packages
- Used Designer 2000 to generate Entity Relationship Diagram (ERD) for tables in database
- Used SQL*Loader to load large amount of data from flat files in Oracle tables on development database
- Used SQL*Plus, Toad tools to write SELECT statements, DML statements, DLL statements
- Worked with quality assurance testers to resolve defects reported in Quality Center.
- Written and executed test scripts to verify corrective code changes; used SQL to manipulate test data
- Performed walkthrough of test plans, cases, scripts, data, and execution to ensure correctness.
- Tested claim-processing cases, and security logs in different applications
6-10 years of experience
Served as an integral member of a skilled team of five developers and three support personnel for a proprietary enterprise resource planning (ERP) system. Build software packages for in-house customers and users that encompass receiving, purchasing, inventory, sales, invoicing and shipping.
- Created and maintained extensive stored procedures (PL/SQL) and functions for an Oracle Forms/Reports application against an Oracle data warehouse. Created views, triggers, synonyms, and grants for new objects within the database for new features to enhance the credentialing product Created and maintained Oracle 6i forms and reports for a client server application. Convert 6i forms/reports to 10g forms/reports for the web.
- Approve and review development designs, recommend improvements, and provide guidance during the testing process. Estimate requests as received and plan work to meet desired deliverables and milestones.
- Provided support to over 1000 users for all aspects of the application pertaining to access, reporting, or use.
- Design documentation deliverables such as application online help, process flows, and release notes to provide to users and the IT staff for future reference.
- Perform conversions of new company data into our propriety ERP system utilizing data transformation tools such as data junction, Oracle PL/SQL, Oracle SQL loader, and Microsoft Access.
- Participated in the integration of a vehicle routing and dispatch solution for product delivery. Created logical and physical data models to enhance our current shipping process. Created extensive data mapping processes and file transformations to handle thousands of transactions daily.
0-5 years of experience
Involved in the development, enhancement, and maintenance of various projects. Maintaining and enhancing the Customer Service system, which is developed in Oracle 8 using PL/SQL
- Engineering the Loyalty and Rewards system with both the front and backend in Informix 4GL and a web interface written in ASP
- Developing all loyalty system reports using Crystal Reports, web locator sites for Group Sales system using HTML and ASP, and many Intranet sites for HR and the Hotel system using ASP, VBScript, JavaScript, and ADO accessing the Informix database
- Re-engineering the Group Sales system using Vantive 7, Oracle PL/SQL, and MS Visual Basic 6
- Mentoring junior programmers and web and application developers on using ASP
0-5 years of experience
Working as an Oracle PLSQL developer and Support Analyst for Single family and Multi family technologies
- Taking technical specifications directly from the clients to put it into business logic
- Fine tuning of queries for performance enhancements
- Available on 24/7 support desks when high alert tickets were generated
0-5 years of experience
- Created and modified over 24 Oracle Reports, Oracle Forms, and multiple complex PL/SQL Packages and Functions for Multi-Language electronic transaction processing of credit card information using a 10G Oracle Database.
- Created and maintain nine tables needed for Multi-Language capabilities for Oracle Reports and Java GUI screens. Each screen and report would automatically show the language of the specific customer's location in the world.
- Created global temporary tables and indexes needed for Oracle Forms and Reports to tune PL/SQL scripts to handle the hundreds of millions of records.
- Created Excel Spreadsheets, Procedures and Oracle Form Tools used to assist in Development, Quality Assurance, and Production releases.
- Created and modified Design Documents from Function Documents and change control items for modifying Forms, Reports, or PL/SQL scripts.
- Managed two other Senior Oracle Developers and tracked status of their work making sure we were all staying within the PL/SQL and Oracle Reports Standards.
0-5 years of experience
Project Software Quality Engineering Assignment
- PLSQL code Development as per detailed design spec
- Unit Testing and validations
- Defect resolutions
- Code Optimization to improve performance to bring down execution time from 12 hours to 5 hours
- Deployment in production environment
0-5 years of experience
Monitoring and troubleshooting Computer Engineering labs.
- Perform software installations and upgrade the existing systems.
- Experience in writing Oracle SQL database queries for ongoing projects in Computer Science department.
- Design an Android and Website application for stock trading using Android, Java and HTML
- Created a database for maintain records of all the professors in Southern California who is teaching all the Universities and Schools.
- Design a lot of Graphical User interfaces (GUI), for example, ATM machine, School enrolling system, etc., using C#.
0-5 years of experience
FISS (Fixed Income Settlement System) is the Barclays primary securities settlement and accounting system. FISS handles international trade settlement. The primary functions of the system are Trade Enrichment - Settlement Netting - Clearing/Settlement - Position Management - Books & Records keeping.
- Analyze Business Requirements, design logical data models using ErStudio Embarcadero
- Responsibilities include developing and tuning of Oracle code to achieve system performance requirements by reviewing SQL Trace, Tkprof, explain plan results. Identify and communicate system deficiencies.
- Enhance/Modify business logic implemented in pl/sql & pro*c processes.
- Play as a technical analyst role and facilitate on-going change request enhancements of the settlement system.
- Implement processes to send data extracts to regulators, Intellimatch for compliance.
- Liaise with Front/Middle office teams for Trade/Settlement Support to resolve any QA/UAT issues.
- Mentor and train team members to facilitate various FISS development project activities.
- Plan, delegate & Review code written by other team members, build productive working relationships with other IT groups, business users and support teams in global regions.
- Devised and enhanced the settlement confirms logic to differentiate domestic and international confirms thereby avoiding compliance breaches involving mail returns.
- Facilitated the Settlement Netting process between FISS and TD Waterhouse, thereby saving a few thousand dollars per day in swift messaging costs.
0-5 years of experience
Develop, execute, and manage Oracle PL/SQL as well as T-SQL stored program units such as a procedures, functions, packages and database triggers
- Create and deploy database objects to the new schema to support new clients.
- Automate data purge process depending on the configured retention period.
- Optimize the queries and view codes to get better performance
- Worked with xml types to display data in the dashboard to monitor SLA's for all the client deliverables.
- Performance tune using indexes.
- Participate in code review and test case reviews with development and QA team.
- Support ESP client issues and requests.
- Have good understanding of AGILE development approach.
- Have done POC on Oracle Golden Gate.
0-5 years of experience
Applications development, eRev software for airline industry. Revenue accounting system.
- Design and development of Oracle database objects and procedural code, including writing Stored Procedures, Functions, Triggers, Packages and Jobs.
- Debugging, testing of critical aspects of the application and fixing.
- Data modeling (Table, Views, Indexes).
- Create Extract, Transform and Load (ETL) processes. Load data from several formats (xml, cvs, txt). Monitoring and optimizing processes
- Design, develop and testing of new Forms and Reports.
- Data analysis and correction. Report generation in several formats.
- Support and troubleshoot application issues.
- Develop Visual Basic Scripts for automatic daily load process.
- Queries optimizing. Plan execution analysis.
- Oracle Forms & Report (versions 6i, 10g), SQL Loader, SQL Developer, Visual Basic, XML.
0-5 years of experience
PeopleSoft Human Resources Application Implementation and Enhancements
- Business Requirements gathering and definition
- User Acceptance Testing
- Process and Run Control documentation
- PeopleSoft Application Designer online and batch AE and SQR process design and coding for Job and Benefits Administration conversion and processing
- PeopleSoft Security access modifications including Tree Structure and User Group creation and updates, and Role, Permission List, Operator Id maintenance
- PeopleSoft Internet Architecture Component, Page and Run Control creation for conversion processes
- Run Control Security, Process Permissions, and Parameter creation.
0-5 years of experience
Responsible for daily reporting and backups via Oracle and Unix-based systems.
- Main contact for backup and disaster recovery systems.
- Maintain timely responses for Help Desk inquiries: troubleshooting user PCs, laptops, and SUNRAY machines.
- Experience with Server 2008 and adding, removing, and editing user information via Active Directory.
- Experience utilizing Korn shell, Oracle SQL, and Business Intelligence tools (Qlikview and B.I. Publisher).
0-5 years of experience
One Call Medical, Highmark BCBS, DressBarn
- Oracle developer using TOAD, Tivoli, Citrix, PL SQL on UNIX/Linux servers on Data Warehousing/EDI/Financial projects.
- Populated Oracle staging tables with the data form the ASCII files, using sql loader utility.
- Created Oracle External tables to load data into the database.
- Developed Oracle PL SQL stored procedures, functions, packages using the debugging features of TOAD and SQL Navigator.
- Developed Microfocus Cobol programs and Korn shell scripts that manipulate data that resided on UNIX servers.
- Extensive use of UNIX utilities (awk, sed, grep, sort ) and vi editor.
- Developed reports in Cognos for Novartis Marketing department.
0-5 years of experience
- Migration of the application from Forms 3.0 to Forms 5.0
- Coded Shell Scripts in Sco-Unix platform.
- Ensure quality assurance by implementing various testing methodologies
- Integration testing
Computer Software Cover Letter Examples
