Senior Oracle Consultant Resume Samples

Description :

1. Assisted clients on the implementation and upgrade of Oracle Financial systems.
2. Conducted Oracle Accounts Receivable, Accounts Payable and General Ledger training for the client and their implementation team.
3. Assisted in post-implementation support of an Oracle Receivables Implementation.
4. Responsible for Analysis and evaluation of receivable and general ledger data.
5. Designed and built financial reports.
6. Worked on a variety of different development projects for clients in Cleveland Ohio.
7. Performed upgrades from 11i to r12 implementations along with conversions from legacy applications.

Experience

0-2 Years

Level

Entry Level

Education

Bachelor's

Description :

1. Led efforts for requirements gathering, business process documentation, test script development, data conversion and implementation for General Ledger, Payables and Cash Management in an R12.0.6 environment.
2. Oversaw four testing cycles for the financial applications prior to go-live.
3. Responsible for training content development via User Productivity Kit.
4. Managed R12 implementation of General Ledger, Payables, Receivables, Purchasing, Fixed Assets, Cash Management and iExpense.
5. Responsible for project management across all implemented applications.
6. Led requirements gathering, solution design, documentation and data conversion for Payables, Purchasing, Cash Management and iExpense.
7. Managed the reimplementation of General Ledger, Payables, Receivables and Cash Management.
8. Led requirements gathering, documentation, data conversion and implementation for organization structure, General Ledger and Payables.

Experience

2-5 Years

Level

Junior

Education

Bachelor's

Description :

1. Involved in Requirements gathering, Data Analysis, Design and written technical design documents.
2. Actively participated in the whole life cycle of the project.
3. Developed and maintained a reporting database application utilized in AT&Ts Global Customer Care and Provisioning System.
4. Coded database triggers, packages, functions, procedures using PL/SQL and maintained the scripts for various data feeds.
5. Performed the uploading and downloading flat files from UNIX server using FTP.
6. Optimized and tuned PL/SQL to reduce the loading process - Utilized SQLLoader to perform bulk data loads into database tables from external data files.
7. Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
8. Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
9. Worked on Performance tuning by using Explain Plan, hints and also worked on Partition tables using the Range method.

Experience

5-7 Years

Level

Executive

Education

M.Sc.

Description :

1. Responsible for developing, directing, analyzing, and implementing enterprise-resource planning solutions for the U.S.
2. Directed the migration of Oracle Federal Financials from Release 11.5.9 to 11.5.10.2 that includes Project Scope Planning, Process Design, Oracle Critical Patch Migrations, Configuration Management, Testing, Deployment, and Post Go-Live Support.
3. Responsible for Functional SME for the implementation of Oracle Time & Labor (OTL), Purchasing, and Accounts Payables which includes strategic and communication planning, test script development, functional documentation, and training content development.
4. Led the implementation of the DoD Defense Travel System (DTS) which deployed.
5. Led the development and management of a configuration management process to standardize policies and procedures, implement proper audit controls, and create an implementation strategy for managing change requests.
6. Served as a functional integration owner for multiple P2P processes including day-to-day help desk operation support and system optimization/customizations.
7. Experienced in requirements gathering, requirements analysis, business process analysis, object-oriented analysis, and business process flow diagrams.
8. Performed configuration work as needed to support new and existing database functionality.

Experience

2-5 Years

Level

Junior

Education

Master's

Description :

1. Worked with business users to refine Business Requirements Documents, Functional Design and Testing documents.
2. Converted business requirements into technical design documents, develop and implement the solution.
3. Developed test plans and scripts.
4. Led projects and enhancements efforts from conception through deployment.
5. Delivered solutions on-time and ensure satisfy internal customers and external parties (e.g. auditors).
6. Participated in peer code/design reviews to ensure the delivery of quality solutions.
7. Created forms 10g parking agreement forms to track parking leases, payrolls and direct debit accounts. Developed over 20 oracle 10g reports for parking revenue reconciliation, statistics, unit utilization and rates.

Experience

5-7 Years

Level

Executive

Education

Master's

Description :

1. Worked with an active secrete clearance.
2. Involved converting legacy applications and manual processes over to a complete solution that meets the shipyard needs.
3. Worked primarily with PL/SQL, BI Publisher, and ADF for WEB and mobile solutions.
4. Worked with end users to conceptualize innovative solutions to complex business problems.
5. Extensively experienced in design, development, and implementations.
6. Developed application that tracks over $240 million annual receipts and payments for government-owned and leased buildings using oracle forms and reports 10g.
7. Led the enhancement and support of alberta government’s infrastructure and transportation building, lands information management system (blims).

Experience

7-10 Years

Level

Management

Education

B.S.

Description :

1. Worked with Application team to trouble shoot and provide solutions for performance improvement.
2. Analyzed the database after running the Soasta stress test.
3. Supported Datastax Cassandra search engine.
4. Prepared the database for the upcoming holiday.
5. Worked on enabling central monitoring of databases using OEM.
6. Supported the Oracle Goldengate environment.
7. Performed switchover test for the DR readiness.
8. Worked on the new generation E commerce platform for Wal-Mart.

Experience

2-5 Years

Level

Junior

Education

Bachelor's

Description :

1. Responsible for enhancements and large development projects for McKesson Clinicals.
2. Responsible for Developer of applications in PL/SQL, Oracle Forms, .Net and C#.
3. Responsible for gathering requirements, writing technical specifications and estimating work in an Agile development environment.
4. Maintains internal documentation, training material and customer help documentation.
5. Resolves customer support escalations for McKesson clients.
6. Responsible for creating views, materialized views and triggers for an ETL process to populate a SQL Server datawarehouse for client's ARRA reporting.
7. Performs data loading from flat files in multiple formats using sql loader.

Experience

5-7 Years

Level

Executive

Education

AAS

Description :

1. Designed forms and various stages of work flow for routing the document using ETQ-Reliance tool (Custom tool designed by ETQ, Based on Python scripting) Work on Reliance Integrations - to send and receive data from Oracle.
2. Created Interface (using packages and Staging tables) between Reliance and other systems to create or update ASLs (Approved Supplier List) Modify Jsps and reload as per requirements.
3. Created dynamic procedures to accept data from ETQ form.
4. Responsible for performance Tuning and enhancements to the Application Promote the code from DEV- STG, PROD ensure the new code, views and reports are working as expected.
5. Effective and timely issued resolution for GE Transportation Business.
6. Identified the reports that are taking longer time and change the underlying query.
7. Created column mappings between Oracle and Reliance, create and run workflows in Informatica ETL.
8. Developed queries and generate Reports and Dashboards in Tableau to visually analyze data.

Experience

5-7 Years

Level

Executive

Education

Master's

Description :

1. Designs and Builds End to end custom interfaces from various sources (including EBS) to Custom data repository using SOA middleware.
2. Designs and Builds End to End SOA web services from SharePoint portal to ASR repository.
3. Plans and Manages project tasks and team deliverables Knowledge transition to client team Production support for entire solution Provided user training for the portal functionality Contributions.
4. Involves in Designing entire solution for interaction between the portal and ASR database Designed and built web service that pulls expenses from Oracle Iexpense and presents it to portal for editing Designed and built web service to post expense corrections from portal to ASR database.
5. Actively involves in Integration testing, cut over and production rollout.
6. Expenses report extract program from Oracle EBS 11i system, to extract all eligible HCP expenses into staging area.
7. Works with the cleveland sewer district to improve their oracle implementation and worked with sherwin williams on several oracle r12 implementations.

Experience

0-2 Years

Level

Entry Level

Education

Bachelor's