- Featured in:
-
More Oracle Consultant Resumes
Use these Oracle Consultant samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
Oracle Consultant Resume Samples
No results found
0-5 years of experience
Successfully completed an Oracle DBA engagement for a large manufacturing company upgrading to Documentum 6.
- Completed an Oracle 9i to 10g upgrade of Test and Production database environments.
- Integrated HP Data Protector with Oracle 10g RMAN incremental backups to tape.
- Performed RMAN backup and recovery tasks as required, including configuration, monitoring, and troubleshooting.
- Documented Install, Upgrade, and Database Best Practice for the customer.
0-5 years of experience
Deployment team member for Oracle EBS implementation for client ([company name])
- Conducted various trainings for Sonoco manufacturing plant employees in the usage of Oracle EBS R12 (Manufacturing Suite) to improve inventory management
- Reconciled Sonoco plant inventory prior to Oracle implementation with previous obsolete system
- Assisted in the upload and transfer of primary data from previous system Baan to Oracle
- Conducted personalized trainings for Sonoco workers based on their day to day activity
- Trained and analyzed various inventory metrics with the use of Oracle reporting
0-5 years of experience
Designed, developed and implemented ETL process to convert vehicle history data from various agencies.
- Designed, developed and implemented various Business reports using OBI
- Developed Certified Pre Owner (CPO) program for Auto dealers writing Oracle Packages. Stored procedures and function.
- Designed, Developed and Implemented various customized interfaces using PL/SQL on Oracle 10g
- Tuned nightly batch processes to complete during nightly off time.
- Provided level 2 supports to business user and modified existing reports Oracle Business Intelligence.
- Wrote shell scripts to execute daily, weekly and monthly process through Control M.
0-5 years of experience
Implemented an email notification program to notify users of pending and completed tasks.
- Developed multiple custom reports in the areas of Accounts Payable, Accounts Receivable, Purchasing and Human Resources
- Researched and resolved Oracle software related issues resulting in patch application and/or setup changes.
- Developed a custom program to generate a nightly Citibank Positive Pay file.
- Provided end user support and training.
0-5 years of experience
Performed infrastructure review across the Oracle platforms throughout the IT organization.
- Performed Applications and Database tuning for Multiple databases
- Significantly improved performance and maintainability of major application (Solumina) through DB tuning and working with application support resources
- Led the upgrade and configuration of Oracle Enterprise Manger 12c which led to improved proactive DB monitoring for over 200 Oracle Database instances
- Helped to define processes and standards – specifically significant in the SAP DB landscape
- Tuned Database for 4 Diverse Applications – Product Life Cycle Management, Design and Engineering, Project Management and Manufacturing Design
- Implemented Oracle Enterprise Management and Cloud Control for over 200 Oracle Database instances
- Documented and created Oracle Performance tuning best practices for their business processes and mentored staff to continue the database performance initiative in place
- Designed and trained permanent staff on implementing Oracle Automatic Storage Management (ASM) to support all new environments and for future upgrades of existing database instances
0-5 years of experience
Consultant responsible to work on a large database conversion project for [company name].
- Worked on data models for telecomm equipments inventory and management
- Implemented data conversion from legacy databases into Oracle 7.x
- Designed and developed complex SQL scripts for data migration, error handling and reporting
- Designed and developed SQL scripts for data cleanup
- Created various forms and reports for the overall conversion process
- Managed the go live project
0-5 years of experience
Developed/Migrated Merchant ETL Credit Card Application Data Module with Scheduling.
- Developed Dynamic Scheduling report Engine process for customer transactions reporting.
- Developed Java FTP package for periodical transfer of generated merchant reports.
- Developed Thin Client J2EE JSF applications for Encrypted DSS Data Retrieval Testing.
- Used Oracle Warehouse Builder for creating dimensions, fact tables, materialized views, mapping, deployment and scheduled periodical merging of object dimensions from source schema.
- Implemented Streams/Change Data Capture (CDC) from server to server DSS data replication.
- Ensured Data Security by oracle Transparent Data Encryption (TDE) and VPD policy.
0-5 years of experience
Responsible for analyzing performance, recommending improvements and teaching improved techniques to the application development team for the Home Lending Operational Data Store.
- Analyzed the longest running queries and determined how to make them more efficient. Combined multiple sequential queries on a single table into a single query.
- Through direct system observation and analysis of AWR reports, determined that the system was dependent on outstanding SAN performance. When SAN response time was more pedestrian, application performance suffered badly. Analyzed bottleneck queries and determined that 4 index changes would eliminate table reads completely, reducing total required I/O. This change reduced the average sequential read rate per unit of work by 50% and improved the buffer cache hit rate from 79% to 95%. Application performance went from lagging several hours to current.
- Analyzed issues raised by business users, tied them to root cause and designed solutions.
- Designed and led implementation of a separation of the application into four parts to be run in parallel. This allowed it to scale as the volume increased.
- Led team through sessions on how to read AWR reports, how to use Toad Session Browser and how to spot performance bottlenecks
- Guided team members on process improvements and improved techniques for Oracle queries.
- Assisted the team in improving technical design document writing
0-5 years of experience
Worked on changes to custom Java and JSP interfaces to Oracle AR.
- Created Oracle PL/SQL reconciliation reports for financial compliance.
- Gathered requirements, designed, developed, tested and trained users on new functionality to ready to inject (RTI) drugs.
- Created technical documentation.
- Created interface for electronic claims submission. Designed new mappings between the HCFA 1500 paper claims and the electronic 837 XML standard.
0-5 years of experience
- Developed business areas, work books, implemented ad-hoc reports (oracle discoverer 9iAs Rel2) and uploaded to Microsoft xl spread required by concerned business users.
- Integrated oracle reports (9iDS) to oracle portal (9iAs Rel2).
- Designed and coded general database provider & portlets, which are used for portal integration.
- Environment: Oracle 9i database, Oracle Applications 11.5.8, Oracle 9I discoverer release2, Developer 6i (Forms & Reports), Discoverer 9i , PL/SQL Web tool kit, Unix, Windows XP and SQL Navigator.
0-5 years of experience
Performed analysis of migration tables from legacy system to Oracle based system.
- Prepared Cron jobs for implementing RMAN scripts.
- Wrote Oracle stored procedures for third party client.
- Created additional database instance for client data warehousing testing.
- Assisted in the development of an application using Oracle PL/SQL based stored procedures.
0-5 years of experience
Member of implementation team responsible for training and implementing Oracle 11i(11.5.6) Financials and HRMS
- Involved in the complete cycle of Development, Design to Production Phase (which involves, Unit testing, Integrated String Testing, Regression Test, and User Acceptance Test)
- Interacted with client to capture business needs, manage expectations, and reviewed deliverables to ensure a successful implementation
- Performed Testing, Data Gathering, and training for the following modules: OTA, iLearning, OTL AP, AR, GL, PSB, Grants Accounting, HR, Payroll, Self Service HR, Projects, INV, OM, iProcurement, iExpense, ADI, FSG, OFA and Purchasing
- Documented and tracked business processes, developed and deployed applicable Training materials to end-users using Oracle Tutor
- Updated Tutor procedures online and used the Web to distribute reference materials to employees
- Utilized Oracle iLearning to deliver scheduled offerings, content management (Tutor documents), target offerings to specific learner population, and track learner progress
- Responsible for coordinating and training 1800 end-users and providing post-production support
- Worked with functional groups to refine and document Discoverer 4i, FSG, and OFA reporting requirements
- Installed and configured Oracle ADI and Discoverer for end users
0-5 years of experience
- Worked on DB administration and maintenance of Oracle9i on Windows NT and Sun Solaris platforms
- Supported engineering and QA teams on performance and tuning issues while testing ActiveNet application for knowledge management.
- Helped engineering team by suggesting an optimal Oracle database configuration as a guideline for ActiveNet Installation handbook.
- Assisted QA team with load, performance and scalability testing and provided technical assistance for Tacit’
0-5 years of experience
Environment: Oracle 12c/11g/10g, Oracle Enterprise Manager (Grid Control), RAC, DataGuard, physical standby, logical standby, ASM
- Installed Oracle 12c on windows with container and pluggable databases
- Participated in day to day DBA tasks: installations, ongoing maintenance tasks, database updates, backup and recovery process for Oracle databases
- Worked in PL/SQL and SQL Tuning tasks, change management, database refreshes.
- Supported sales and marketing teams by providing technical Product expertise and creating write-ups for new product releases.
- Evaluated new Oracle 12c features for DBAs and Developers
0-5 years of experience
Led the configuration and implementation of the distribution module of OneWorld for Baxter, a major medical device manufacturer. Trained client staff for a successful on time, under budget installation.
- Provided strategy, planning and Fast Track OneWorld implementation for a multi-national eBusiness PC Distributor in Chile, Argentina, Brazil and Mexico resulting in a rapid implementation.
- Led the conversion process for a full-service web-enabled ERP implementation for an Internet retailer.
- Provided business requirements, project planning and system configuration from gap analysis to implementation including data conversions and training at several major California wine producers.
- Performed on-site business analysis and workshops for Dole and Pacific Coast Producers, two major California food producers and canning companies.
- Introduced mentoring and coaching programs for new consultants.
0-5 years of experience
- Designed, developed and maintained product movement and shipping applications using Oracle Forms and Reports 6i for Westinghouse Electric Company.
- As per written functional specifications created database tables, SQL queries, PL/SQL procedures and packages as prototypes for the client.
- Developed and maintained custom forms and reports to track nuclear fuel usage.
- Quick to respond to client requests in meeting DOE specifications and regulations.
0-5 years of experience
Assisted in the Oracle HR and Payroll Input implementation. The scope of work included requirements gathering, solution build, configuration, and testing and migrating legacy data.
- Implemented Oracle Financials 11i Inventory, Project Accounting, Accounts Receivable and General Ledger.
- Project management, architectural design, development & production support of mission-critical financial applications.
- Provided analysis, design, installation, and rollout of Oracle 11i General Ledger, Accounts Payable, and Purchasing for offshore and onshore projects.
- Worked in the enhancements and supporting clients remotely.
- Performed process analysis, solution design, build, test, delivery, and postproduction support for enterprise-wide General Ledger and related documentation/deliverables.
- Achieved the migration of Visual FoxPro 6.0 to SQL Server 2000, ASPNet, Visual.Net, for the communication among branches with an optimum output of 60% more efficient.
- Analyzed, designed and programmed new system for check cashing, money transfers, loan advance, etc., and maintenance of customer database.
- Worked on modifying existing applications and creating new applications using Visual Basic.Net, Oracle Developer 9i, Java with SQL Server 2000 using ADO.Net and XML.
- Developed new administrative system for the management staff, which allows having better control of the human resources and fixed assets of the company to support the new decisions making.
0-5 years of experience
Documented procurement process and trained 25 end-users for SPL, a utility software company, achieving the ROI in 3 months.
- Led team to provide production and help desk support for Procure to Pay modules for EMC, a hardware company, meeting the service level agreements.
- Led and managed the migration project from 5 legacy systems at GE Rail, to Oracle ver 10.7 to Oracle E-business Suite 11i, migrating AR, OM, INV, SHP , WMS Modules. The projects were deployed on budget and on time and included sites in U.S.A. and Mexico.
- Trained between 50 to 100 end-users and managers in all modules of Oracle E-business Suite (OM, PO, Iproc, etc) at PREPA, the power supply company in Puerto Rico
- Led implementation of Oracle E-business Suite and business intelligence model at Grupo Diagnostico Proa in Mexico City. The implementation included 10 different companies and was successfully deployed in 8 months. This project includes the modules of AR, AP, OM, QP, INV, PO, and GL modules.
- Implemented a business intelligence model using Oracle Financial Analyzer and Oracle Sales Analyzer products combined with Discoverer’s reporting tool at Bacardi & Cia located in Mexico City in 3 months
0-5 years of experience
Designed, developed, tested and implemented a Web enabled Order Entry system.
- Oracle E-Business Suite. Developed programs to load data from intermediate tables to interface tables.
- Unit Testing of the conversion/interface programs.
- Developed application to print complex commission checks using Reports 6i.
- Developed Reports Server and implemented a queuing mechanism to run or submit predefined reports.
- Mentored junior developers and assisted the development team technically in design, development and tuning.
- Developed validation procedures and error reporting on the data in the intermediate tables for interfacing.
0-5 years of experience
11.57 Implementation of GL, AP, AR, PO, OM, INV, WIP and WMS
- Led the Financials, Cost Management and WIP implementation effort
- Responsible for the conversion of Customers, Vendors, Items, On-hand inventory, AR Invoices and GL balances
- Designed and implemented WMS cost group assignment, picking and put away rules
0-5 years of experience
Gathered requirements, created design documents, and performed impact analysis for core and custom Oracle INV, WMS and PO standard and custom applications
- Developed solutions to leverage Oracle applications functionality for the Manufacturing and Supply Chain areas
- Worked with existing systems to track and manage requirements and issues
- Managed and resolved 3rd level support issues
- Provided on-call support off hours and weekend on a rotating basis
- Logged helpdesk tickets
0-5 years of experience
Consulted during all phases of the project and provided technical leadership and training to the project team
- Responsible for documenting functional and technical business processes using Oracle Tutor
- Designed customized forms and reporting with Oracle Discover and Crystal Reports
- Wrote UNIX shell programs with parameters and variables, I/O, looping, conditional testing, and signals
0-5 years of experience
Implemented Oracle Payments and Payables.
- Responsible for Analysis of exiting 11i customization and migration to R12.
- Developed Business Requirement Document (BRD30), Functional (MD70) and Technical design (MD50), Conversion Design ( CV40) and Testing Scripts (TE40) for EFT payment process, check printing process and i-expenses.
- Setup and implemented i-Expense and offline OIE spreadsheet template. Migration of custom code from Oracle version11i to R12.
- Implemented employee-paid credit card AMEX program for the company.
- Designed and developed lock box interface.
- Configured E-business tax(EBTAX) according to client’s requirement.
0-5 years of experience
Jdeveloper search Java Archived Files for certain classes, interfaces, SQL Queries.
- Orscheln client – created DB views, SQL queries for Accounting Department Excel VBA.
- Presentated Pro*C, Pl/Sql, Forms development standards, per Retek recommended manuals.
- Gander Mountain – created a form prototype to administer items allowed for Web Commerce.
0-5 years of experience
The project implemented a Clinical Trial Management System through Siebel Clinical Application that would helped Pfizer employees manage the studies, record visit activities and generate Trip Reports.
- Worked as QA Engineer to test Siebel Clinical Applications integrated with Oracle Business Intelligence.
- Identified the test cases for automation and automated the test scripts for the Functional, Data Driven, and Regression testing using QTP.
- Efficiently used QTP features to develop reusable generic scripts.
- Generated test status reports and test metrics.
0-5 years of experience
Manage Oracle and SQL server databases and lead the effort on database consolidation.
- Implemented 2 node Oracle 10g RAC on Test and Cert environment.
- Implementing business dashboard and business intelligence solutions using SSRS and MS SQL Server 2005
- In the process of acquiring and implementing a Predictive dialer system with a target to achieve a 100% improvement in call contact conversion rate.
0-5 years of experience
Oracle Financial Applications -Teckno- Functional Consultant (Team size 8)
- Implemented Oracle Financials GL, AP, AR, OE and FA modules.
- Defined descriptive flex fields to customize customers, vendors and invoice forms
- Defined transaction sources, quick codes, transaction types, receivable activities, customers, customer profiles, Banks, lock box and set the profile options for AR.
- Designed and defined for Sales Order Cycle, order Cycle for RMA.
- Defined pricing attributes, pricing rules, price lists, and Manual and Automatic order level and line level discounts, quick codes.
- Did planning and data conversion from the existing legacy system to Oracle financials applications Developed interface programs to import data from legacy system using SQL*Loader to upload data from the existing system into AR, AP, FA, OE and GL from fox pro database.Environment: Oracle Financials 10.7 (AP, AR, GL, OE, FA), SQL*Loader, Win NT
0-5 years of experience
Served on ARGUS (Advanced Roman Graphical User System) project development team that built a custom ERP for Accounts Receivable, Order Entry, Purchasing, and Warehouse.
- Built applications for the Order Entry Module using Developer 2000 Forms version 4.5 and 6.0. Tested data in the development environment. They were running Application Release 11.0 of Oracle Financials where the reporting tool used was Oracle Discoverer. The database version was Oracle 7.0 and was upgraded to Oracle version 8.0.
- Responsible for analyzing and enhancing existing Developer 2000 forms within the Order Entry, Accounts Receivable and Warehouse Modules. The forms version was 4.5 and was upgraded to version 6.0 Data modeling using Designer 2000.
- Built Forms from scratch (using Developer 2000 version 4.5 and 6.0), some dictionary and others that have a Master/detail relationship. This involved writing code using SQL and PL/SQL. The operating system was Windows NT version 4.0. This also involved client interaction as needed due to changing requirements.
- Enhanced Forms (mainly forms that needed a push-button functionality), enhanced Reports (using Developer 2000 version 6.0), wrote PL/SQL procedures, functions, triggers, and packages to support business logic, and documented the project from a business, as well as a technical perspective.
0-5 years of experience
Work with Risk Analysis and Assessment reporting team, which receives data from various internal and outdoor vendors and loads into datawarehouse/reporting system. Worked with Oracle, pl/sql, DB2 and unix shell scripting.
- Analysis, enhancement and support of existing ETL processes and reporting database.
- Performed Unit Testing and test data set up for QA.
- Created and enhanced existing ETL processes using the SQL loader, SQL, PL/SQL script.
- Created SQL script and SQL reports for data analysis and cleansing.
- Created DB2 procedures to fetch data set/reports from various federated databases.
0-5 years of experience
Designed and developed Web Forms and Web Reports for a Web-enabled, Internet-accessible database application to assist AT&T and other International Network Administrations in managing undersea cable networks. The application is based on Oracle Custom Development Methodology, and uses HTML, Javascript, PL/SQL Web Tool Kit, Web Forms and Web Reports powered by Oracle Application Server, Forms/Report Server 6.0 and Oracle 8i. Also installed and used tools such as TOAD and Exceed Hummingbird.
- Involved in all phases of this project by using Designer 2000 to data model and develop business logic, using CDM to write design documents, using HTML embedded PL/SQL to develop web Reports 6.0 and web Forms 5.0, performed unit tests, wrote test plans, and carried out system integration tests.
- Designed, developed and maintained a web based Problem Tracking System (PTS) to log bugs, track the status of bug fixing process, monitor the source code control process, and run reports to reflect the progress of the test phase.
- Converted data from legacy systems to MS Excel spreadsheets as a member of a two person conversion team. Responsibilities included extensive analysis of legacy applications and mapping of legacy data to desired reporting formats, using PL/SQL, database tools and MS Excel.
- Implemented the PMBOK (Project Management Body of Knowledge) strategies to a project team of 100 members, as a member of the PMO (Project Management Office).
0-5 years of experience
I was actively involved in software development, including gathering requirements, analysis, design, coding, testing, and implementing enterprise data warehouse.
- Validated specs, gathered and finalized business requirements through JAD sessions
- Assisted in data model design for customer dimension and clinical activity business area.
- Developed complex mappings for historical and refresh cycle loads
- Developed and implemented Unit testing strategies
- Assisted in migrating to production
0-5 years of experience
Functioned as Oracle billing consultant, service contracts administrator and strategic accounts specialist.
- Provided billing support to Danka Office Imaging customer base and their corporate associates
- Ensured correct and timely contract setup
- Provided root cause billing remediation to insure customer satisfaction
- Worked closely with Sales Executives and Account Managers to ensure a first class customer service experience of every client
- Received Chairman’s Award for achievements “Above and Beyond normal business practices that had a measurable impact on providing highest quality service to customers and associatesâ€.
0-5 years of experience
Prepared test methodology and helped in developing master test plan after analyzing system requirements specification document (SRS).
- Developed test cases, scenarios and organized them using Quality Center.
- Utilized Test Director for analyzing Test results and bug tracking.
- As a Consultant lead the testing team to interact with business and development team, designed and developed test plans and test scripts for testing web based applications.
- Involved in ETE manual and automated testing of the application.
- Defects and issues were logged in Test Director following Standard guidelines.
- Used various checkpoints to verify the expected behaviour of the application.
- Extensively worked on handling the application response for Positive and Negative sets of data using Data Driven Testing.
0-5 years of experience
Lead FMC Technologies in a reconfiguration of Oracle P6 v7.2 database for global IT PMO.
- Worked with global team to analyze current client installation and configuration of database
- Created and implemented optimized plan to configure database to meet end user requirements
- Provided platform to accurately manage projects and resource allocation across teams vertically and horizontally through the company
- Restructured EPS, OBS and Security profiles to streamline workflow and end user security
- Created new coding structure to improve accuracy and speed of KPI reporting to upper management
- Rewrote resource dictionary to align with corporate org charts
- Created project templates
- Restructured process for creating WBS to match workflow
0-5 years of experience
Managed multiple initiatives in Different Oracle Modules (Financials, Projects Costing and Billing, OM)
- Hired to deploy best practices, enhance reporting, and revamp business processes and flows.
- Worked with various Management Levels to decide where business processes needed improvement.
- Trained users while implementing process and set up changes to optimize Oracle and current integrated tools.
0-5 years of experience
Involved in analysis, design, development, maintenance and implementation in software applications.
- Involved in Production support for system issues to include support for software solutions.
- Work tickets as schedule for monthly releases and support daily incoming priority issues.
- Working on critical projects in a team and also handling individually.
- Developed and tuned PL/SQL procedures, triggers and Packages.
- Developed database objects like Tables, Synonyms, Views, Indexes, and Sequences
- Involved in business development life cycle, Oracle Forms, Oracle Reports and Oracle PL/SQL programs.
0-5 years of experience
Analyzed current business processes, gap analysis and solution design for the desired future to-be operating structure of client business units by defining business requirements and translating the requirements into system configuration.
- Led client team in the analysis of current As-Is business processes through a series of client interviews and key process owners sessions
- Responsible for the functional design, configuration, and implementation of the General Ledger and Accounts Receivable modules.
- Participated in key design decision making that included Global Chart of Account (COA), Multi-Org and Global Ledger for Oracle R12 solution design.
- A key player in the Sub-ledger accounting (SLA) design.
0-5 years of experience
Performed Oracle DBA and Security support on Solaris in aiding in the migration of EDS Purchasing and PCARD applications into the HP datacenter. Process included performing sunsets of certain applications and re-linking remaining applications together, recreating DDL and DML scripts to re-synch objects, performing data exports, and importing data into new environment.
- Used Tidal Scheduler to schedule nightly, weekly, and monthly purchasing jobs to load data from the EDS mainframe into the newly created Oracle Purchasing databases.
- Worked with other HP EDS application developers to provide any other Oracle functions that are needed to complete the migration.
- Recreated the End of Year data roll and archive process.
- Provided support documentation for several processes that were created are modified.
0-5 years of experience
Program Management Office Sr. Analyst managing portfolio of Interfaces and Data Conversions including monitoring and troubleshooting BPEL, working directly with FMO and SI (System Integrator), and authoring Sustainment and Scalability whitepaper for Director of the DEAMS program.
- Managed portfolio of legacy system interfaces to Oracle Federal Financials
- Worked with SI (System Integrator) and FMO (Functional Management Office) to monitor and expedite creating, testing, and deployment of SOA-based interfaces
- Provided Program Director with Sustainment and Scalability analysis of DEAMS
- Worked with USAF legacy system Interface Partners to assist in validation of DEAMS BPEL outbound interfaces
- Assisted System Integrator in troubleshooting of BPEL related errors including BPEL processes not archiving inbound files to NFS mounted directory
0-5 years of experience
- Installed, configured and performed development for Endeca / iStore integrated product solution, resulting in incorporation of eBusiness data within the Endeca environment, including customer-specific pricing and availability data.
- Developed strategic eCommerce roadmaps for mid-size manufacturers, working with managers and executives to align online strategy with business objectives and KPIs.
- Partnered with stakeholders to gather business and system requirements for eCommerce initiatives.
- Designed and developed world class eCommerce solutions, utilizing Oracle iStore, custom java and pl/sql programming, SOA Gateway, and Endeca.
- Implemented Oracle eBusiness Suite Release 12 modules including iStore, Order Management, Shipping Execution, Advanced Pricing, Purchasing, Accounts Receivable, Accounts Payable, Quality, SOA Gateway.
- Leveraged offshore developers to keep project costs within budget, while delivering products of the highest quality.
0-5 years of experience
Provided consulting services to manufacturing and healthcare clients.
- Worked closely with partners and senior management in implementing data warehouse and Oracle Financials solutions.
- Conducted analysis, design and web deployment of Oracle reports and forms.
- Involved in internal projects related to software enhancements.
- Wrote numerous reports and queries for operational and troubleshooting use.
- Teamed up in system maintenance and large upgrades with minimal business interruption.
0-5 years of experience
Redesigned IT department’s billing database, which was programmed in Visual Basic for MS access using ODBC connections to Oracle tables.
- Gather requirements from users for redesign.
- Created new screen, reports and queries.
- Programmed for imports and exports from other programs.
- Setup and implemented testing and production databases.
- Experienced full software engineering cycle.
0-5 years of experience
Performed Oracle consulting for Oracle clients in the Bay area and around the country.
- Performed performance and tuning, Oracle database administration, and application development.
- Consulted customers to migrate from mainframes to an Oracle based client/server environment.
- Performed project management for Oracle clients.
0-5 years of experience
Performed a full life cycle implementation on client’s Oracle R12 procure to pay modules.
- Acted as an advisory expert in Oracle application during an implementation, as clients had several gaps during the requirements gathering phase
- Actively involved in the AP module setup, configuration and implementation involving all mandatory and optional steps to meet the company’s business needs.
- Study of existing business processes, future business flows and identifications of gaps and workarounds in order to provide an integrated future processing procedure that meets the business needs of the company.
- Define user responsibilities and created several custom responsibilities with menus and request sets based on the user responsibilities.
- Created and follow up on Service Request (SR) with Oracle support.
- Developed several functional specification documents as needed to demonstrate design approach to client.
- Participated in testing, user acceptance testing in test instance and worked with certain key super users.
0-5 years of experience
Technology: Oracle EBS Applications 11.5.10 (D2B, Quality, OM), Sun Solaris, Windows NT, Oracle 10g, Reports 6i, Forms 6i, SQL, PL/SQL, SQL Navigator, Kintana, PVCS tracker, Serena Version Manager
- Responsible for technical design of D2B extensions. Expertise in MD50’s, MD 70’s, MD120’s, TE20.
- Development of Oracle Forms and Reports custom extensions for the D2B modules.
- Responsible for high severity production issues and Involved in Performance tuning of the scripts.
- Responsible for coordination with offshore team and prioritization of issues.
- Mentoring and training junior developers.
0-5 years of experience
Develop complex PL/SQL procedures and functions using bulk collections and methods for better performance and easy retrieval of data.
- Extensively used the advanced features of PL/SQL like Records, Tables, Object types and dynamic SQL.
- Used Pragma Autonomous Transactions.
- Experienced in Optimization and performance tuning of SQL and PL/SQL.
- Understanding of Oracle DB Internals.
- Developed Shell scripts for automation of jobs.
- Job scheduling in Autosys.
0-5 years of experience
- Technical lead responsible for design and development of Retirements and Separation module of Oracle HRMS (10.7 SC) for Air Force Personnel.
- Developed business rules as packages and procedures
- Developed custom forms and created task flows for Retirements and Separation Module
- Developed and tuned Views for ADE and created reports such as mail merge, labels and user-defined reports
- Developed Oracle Alerts for automatic actions
- Obtained client requirements to recommend re-design of Special Info, Person Extra Info, and Assignment Extra Info Flexi Fields.
0-5 years of experience
- 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.
0-5 years of experience
- Responsible for DESIGNING & CREATING an ETL Framework that works based on a table driven approach.
- Developed the entire ETL process using PL/SQL, which refresh’s the Staging area, Data Warehouse and Data Marts.
- Developed the scripts, which use the fuzzy logic for Data Quality on Patients name, address, zip, state and adverse events.
- Responsible for writing scripts for Daily, Weekly, biweekly and monthly refresh of data warehouse based on the data inputs.
- Involved in creating and maintaining Partitioned Tables and Indexes, public synonyms, read only user accounts and database links for remote database access.
- Project – WWSDW (World Wide Safety Data warehousing Project for Regulatory Dept). Conversion of data from AEM and ARISG.- ECLINICAL DATA and builts Data Warehouse and Data Marts for a product.
Data Systems Administration Cover Letter Examples
Rate This Article
[Oracle Consultant]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
