Oracle E-business Suite System Administrator Resume
Providence Rhode, IslanD
SUMMARY:
- 15+ years of professional computer industry experience working with many facets of the software development cycle.
- 15+ years of intensive programming and design experience using Oracle Technologies.
- 15+ years of multi - cultural (APAC, EMEA, and North America) and divert vertical (Financial, Technology, Entertainment, Broadcasting and Government) experiences in project delivery.
- Managing the development and implementation of small to large-scale solutions at strategic enterprise levels.
- Playing key roles in design and/or application development (Full Software Development Life Cycle) of projects and making recommendations for appropriate client solutions.
- Functioning as primary client contact, communicating frequently about status and schedules, milestones, deliverables, risk analysis and mitigation strategies and providing problem solving in complex situations to benefit the client.
EXPERIENCE:
Confidential, Providence, Rhode Island
Oracle e-Business Suite System Administrator
Responsibilities:
- Implement internal security structure to avoid audit issue within the e-Business Suite development team.
- Supervised the Database migration from 10g to 11g in preparation for the Oracle e-Business Suite upgrade from 11i to R12. Also lead the testing of the custom codes and seeded functionalities of the 11i instance.
- Provide and implement solutions to current and new requirements for RIDOT e-Business Suite environment.
- Construct requirements for future enhancements in our e-Business Suite environment.
- Guide junior staff members in resolving issues and lead them in implementing solutions.
- Create new extension programs (PL/SQL Packages) for new requirements and replaces old programs that are no longer functioning as previously designed.
- Provide interface programs to perform extractions, transformations, and loading of Oracle Purchasing, Payables, and Grants data for Third-Party applications.
Environment: Oracle 10g, Oracle 11g, Windows, UNIX HP, Oracle PL/SQL, Oracle SQL+, Oracle Developer 6i (Oracle Forms 6i and Oracle Reports 6i), Oracle Discoverer 10g, JDeveloper, TOAD, Oracle BI Publisher.
Confidential, Stamford, Connecticut
SR Applications Developer/Analyst
Responsibilities:
- Modified existing 11i extension programs (PL/SQL Packages) that were affected by the R12 upgrade.
- Modified Oracle iExpense and iProcurement seeded Workflows to fit to Confidential ’s functional needs.
- Development of new extension programs using PL/SQL to cater for the enhancement requests for iProcurement and Oracle Purchasing modules.
- Responsible for testing the current and new functionalities of Oracle iProcurement, Oracle Purchasing, and Oracle iExpense.
- Development of new program (PL/SQL packages) to extract Applicants information from Oracle Talent Management and interface with the service provider site.
Confidential, Stamford, Connecticut
Application Development lead
Responsibilities:
- Work with users through all Software Development Lifecycle phases.
- Write technical design documents for extractions, transformations, and interface with Hyperion Planning Enterprise.
- Write codes for the extractions, transformations, and interface with Hyperion Planning Enterprise using PL/SQL.
Confidential, Stamford, Connecticut
Development lead
Responsibilites:
- Design and development of new extension programs using PL/SQL to perform synchronization with Confidential ’s home grown applications.
- Design and development of new extension programs using PL/SQL for custom back-end processes for Oracle Projects to fit Confidential ’s functional needs.
- Development of custom pages using JDeveloper and PL/SQL to add functionalities to Oracle Projects.
- Development of reports using Oracle Discoverer 10g.
Confidential, Stamford, Connecticut
Development lead
Responsibilities:
- Development of new extension programs using PL/SQL to customize the distribution of Approvers for individual iProcurement transactions depending on the requisition type, total amount of requisition, and all other conditions.
- Development of new reports using Oracle Discoverer
- Responsible for supporting the iProcurement users and Purchase Order Buyers to resolve issues encountered by them. This includes the determining the causes of the issues, resolving these reported issues, and creating Service Requests to get help from Oracle support if the issues are applications bugs.
Confidential, Stamford, Connecticut
Application Development lead
Responsibilites:
- Development of new packages (PL/SQL programs) to extract HRMS records from Oracle HRMS application that will be sent to Confidential ’s service providers such as Fidelity for 401k information, Wageworks, Workforce, and Cigna Healthcare.
- Responsible for developing Payroll, Benefits and Requisition/Vacancy reports using Oracle Reports, PL/SQL Package, and Oracle Discoverer 4i.
Environment: - Oracle 10g, Oracle 11g, UNIX HP, Oracle PL/SQL, Oracle SQL+, Oracle Developer 6i (Oracle Forms 6i and Oracle Reports 6i), Oracle Discoverer 10g, JDeveloper, TOAD.
Confidential, Hartford, Connecticut
Systems Developer
Responsibilities:
- Responsible for identifying and assigning modules for fixes. Modules include PL/SQL Procedures, Reports, and COBOL programs
- Responsible to lead group of developers in implementing program fixes and enhancements.
- Responsible for identifying other possible solutions and strategies to improve programming issues like implementing packaged programs instead of standalone procedures, justifying the usage of Oracle utilities to replace COBOL modules when processing interface files and other back-end processes.
- Responsible for modifying programming standards that will take effect when the consultants hand over the responsibilities of maintaining and modifying the ITAS system.
Environment: - Oracle 9i, UNIX Sun Solaris, Oracle PL/SQL, Oracle SQL+, Oracle Developer 9i (Oracle Forms 9i and Oracle Reports 9i), SQL Developer.
Confidential, Bristol, Connecticut
Senior Analyst/Programmer
Responsibilities:
- Responsible to implement coding standards and program enhancements to make the programs run efficiently, especially during for the daily batch processing.
- Responsible in designing Packages to process General Ledger records in the GL Interface table to transform non-Oracle records into acceptable Oracle General Ledger records for importing and posting.
- Responsible for designing, coding, and testing custom Reports using Oracle Reports 6i and PL/SQL.
- Responsible for creating technical documents that serves as program specifications.
- Responsible for internal string testing of routines to make sure that there will be no surprise problems that will be encountered during the System Integration and implementation phases.
- Responsible for debugging and modifying custom extension programs for the company’s Oracle Accounts Payables module in their Oracle Financials Application11.5.8 version.
Environment: - Oracle Financials Applications 11.5.8 and 11.5.9, IBM-AIX UNIX, Unix Sun Solaris, Oracle 9i, Oracle PL/SQL, Oracle SQL+, Oracle Developer 2000 (6i), Oracle Forms 6i, Oracle Reports 6i, TOAD.
Confidential, Hartford, Connecticut
Senior Analyst/Programmer
Responsibilities:
- Responsible for coding Stored Procedures (PL/SQL), Oracle Reports and COBOL Interface programs.
- Responsible for testing and documenting the programs coded for the ITAS implementation.
- Tasked for reviewing other programmers’ codes and documentations prior to the modules’ Lead and Technical review.
- Tasked to perform Software Investigation Request for failing programs (Oracle Forms/Reports/Stored Procedures/Triggers/COBOL), perform and fix the problem(s) to make the programs run without errors.
- Responsible for performing internal string testing of module to make sure that problems will be solved if any were encountered prior to submission of programs to User Acceptance test stage.
Environment: - Unix Sun Solaris, Oracle 9i, Oracle PL/SQL, Oracle SQL+, Oracle Developer 2000 (9i), Oracle Forms 9i, Oracle Reports 9i, Microfocus COBOL, TOAD.
Confidential, New York, New York
Oracle Financials Technical Consultant
Responsibilities:
- Primary person responsible in resolving issues that would prohibit an application from going to full production mode.
- Primary person responsible for maintaining all customized Forms, Reports, and PL/SQL and SQL programs developed for RDA Oracle Financials 11.0.3.
- Primary person responsible in testing screens, reports, and SQL programs for RDA Oracle Financials version 11.0.3.
- Primary person responsible for debugging and creating SQL packages/procedures/functions customized for RDA Oracle Financials application.
- Primary person responsible for customizing AP checks for the company, which includes the translation of numbers into Spanish words.
- Primary person responsible for creating new reports for Oracle Application modules (AP, GL, PO, and Inv) and RDA Applications using ORACLE REPORTS.
Environment: - Unix Sun Solaris, Oracle 8i, Oracle PL/SQL, Oracle SQL+, Oracle Financials 11.0.3, Oracle Developer 2000, Oracle Discoverer, TOAD
Confidential
Oracle Financials Technical Lead
Responsibilities:
- Primary person responsible in resolving all technical issues for Oracle Financials modules (AP, GL, PO and Inventory). Responsible for TAR creations in Oracle Metalink until the technical issues are solved.
- Lead developer responsible in converting all existing Oracle Reports from Version 2.0 to 2.5, also involves customizing screens using Oracle Forms 4.5.
- Primary person responsible for customizing AP checks for the company.
- Primary person responsible for the creation/development of new Oracle Financials reports for GL, AP, Inventory and Purchasing.
- Primary person responsible for the modification/customization of new Oracle Financials reports for GL, AP, Inventory and Purchasing modules.
- Primary person responsible for the creation of new SQL programs such as Functions, Procedures, triggers, and SQL loader programs.
- Responsible for the testing of all screens, reports and processes, thus making sure that it adheres to the highest quality. Acted as the primary person for the Quality Assurance of each Oracle Financials modules.
- Lead technical support of the monthly GL transfer of data coming from other Oracle modules such as Payables, Purchasing and Inventory, and data coming from the legacy systems.
Confidential
Oracle Financials Development, Customization and Technical Support
Responsibilities:
- Primary person responsible for the development of all new programs such as Reports, Packages, Procedures, and Functions.
- Lead technical support of the monthly GL transfer of data coming from other Oracle modules such as Payables, Purchasing and Inventory, and data coming from the legacy systems.
Confidential
Oracle Financial Analyzer - Technical Support
Responsibilities:
- Primary person for the maintenance of Oracle Financial Analyzer which includes the Export / Import process of OFA database to ensure that there are no corrupted DB files.
- Responsible for resolving technical issues encountered in Oracle Financial Analyzer. Responsible for TAR creations in Oracle Metalink until the technical issues are resolved.
- Overlooks the OFA - GL transfer.
Environment: - UNIX Sun Solaris, Oracle Financials 10.x, Oracle Express Server 4, Oracle Financial Analyzer 4.8, Oracle Developer 2000, Oracle 8.x, Oracle PL/SQL, Oracle SQL+.
