We provide IT Staff Augmentation Services!

Sr. Oracle Developer Resume

OBJECTIVE:

Sr. ETL Integration Developer ( MBA - PSM I )

SUMMARY:

  • IT Professional with extensive years of experience, mostly working as Technical Consultant focused on implementation of ERP systems (Oracle EBS, E-Business Suite), Benefit Card systems (pre-pay card) and I’ve been working with Business Intelligence around 5 years.
  • Extensive years of programming experience in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS)
  • Proficient in Oracle Data base design with relational and dimensional modeling.
  • Developed various interfaces and ETL process working with Oracle Tools,
  • Was responsible for the integration of the E-Business Suite with the diverse legacy and satellite systems of the company. The project's objective was to allow Ticket to process credit cards and free itself from the third-party processors Orbital and CSU

SKILLS AND LANGUAGES:

  • Pl-Sql, Pl-Developer, Forms, Report, Triggers, Tuning database, Sql (ORACLE), Packages, Procedures
  • Operational Systems - HP-UX - 10.20 (UNIX), Sun - Solaris
  • Relational Data Modeling - Erwin, Visio
  • MS-Project
  • Project Management (Clarify)
  • Portuguese
  • ETL Tools - Oracle Data Integrator (ODI)
  • QlikView
  • Design and Modeling in Business Intelligence (B.I)
  • Data Warehouse Build
  • Project lifeCycle in Data Warehouse
  • Oracle ERP Version 11i Modules (CRM, Sales Contracts, Quote, Lead, Territory, TeleSales, Accounts Receivable - AR, Accounts Payables - AP) .

WORK EXPERIENCE:

Confidential

Sr. Oracle Developer

Responsibilities:

  • I work as a Sr. Oracle Developer, and the goal of this short-term project for Department of Corrections is to create several views, procedures, functions, and packages for delivering data to external report system Telerik to build various different reports.

Oracle Tools: Pl-SQL, Packages, Procedures, Functions, SQL, Triggers, BULK (Insert/Select, FORALL) Types, Ref Cursors, Arrays, Views. TFS

Confidential

Sr. Integration Architect

Responsibilities:

  • My main role was the creation of robust ODI and PL-SQL solutions to address multiple business needs, Analysis and troubleshooting of database load plans and incident analysis (Support Systems).
  • Close interaction with development team, designed complex system integrations that achieved high levels of automation and reutilization of flat files using Control-M.
  • Resolved complex systems portability issues, and acted as a liaison between business areas and major telecom companies such as Claro, Vivo and Tim.

Oracle Tools: Pl-SQL, Packages, Procedures, Functions, SQL, Triggers, BULK (Insert/Select, FORALL) Types, Ref Cursors, Arrays,Views.

Alelo Brazil ( )

Project Leader

  • Project Leader, responsible for integrating the several suppliers with the product department and IT Alelo. The project consists in the evolution of Alelo WebSite and APP on iOS and Android platforms. Monitoring the settings requirements of new product features, integrator between IT and products department.
  • Managing the financial and payment providers preparing schedule of activities, managing scope, time and quality of packages delivered by several suppliers. For each delivered package I participated in project initiation, planning, execution and closure of the project.

Confidential

Sr. Technical Team Leader ( Oracle - EBS ) and Data Analyst ( Business Intelligence )

Responsibilities:

  • Consultant responsible for developing the integration between two portals Ticket with E-Business Suite modules (Accounts Receivable - AR, Sales Contract, Opportunity, Quote, Territory, Customer Master), HR, CRM, OKC, ASO, Tele Sales, and TCA.
  • I developed interfaces to load information from E-Business Suite to Data Warehouse, and performed Warehouse maintenance when it was necessary to adapt the information to the company s needs.
  • I integrated information in the E-Business Suite through interfaces in which the core API EBS were used - ensuring the integrity of information.
  • Responsible for supporting the information into the EBS, making adjustments in the modules mentioned above, and doing maintenance when it was necessary to adapt the information according to the requests of several departments.
  • Development of new features in the EBS system using forms, reports and PL/SQL to attend to the requests of several departments.

Oracle Tools: Pl-SQL, Packages, Procedures, Functions, SQL, Triggers, BULK (Insert/Select, FORALL) Types, Ref Cursors, Arrays, Forms, Reports.

Confidential

Data Analyst ( Business Intelligence )

Responsibilities:

  • Consultant responsible for extraction and transformation (ETL) from information contained in several Legacy systems to insert information inside Oracle OCDM BI System and other Data Warehouse. The ETL tool used was the Oracle Data Integrator (ODI) and SQL. Some experience with Oracle dashboard - OBIEE.
  • I also worked as a Function Analytic at Subscriptions and Account Contract modules and mapping the information in the OCDM system.
  • I participated in a dimensional module build of Data Warehouse (Stage and Target).

Confidential

Data Analyst ( Business Intelligence )

Responsibilities:

  • Consultant responsible for the extraction and transformation (ETL) of the information contained in the Legacy system Progress and integrating the information in the new BI system. The ETL tool used was the Oracle Data Integrator (ODI) and PL/SQL and SQL. Some experience with Oracle dashboard - OBIEE.
  • I worked as Project Manager organizing the activities, deadlines and assigning tasks to other members of team.

Confidential

Sr. Oracle Developer - EBS (E-Business Suite)

Responsibilities:

  • Consultant responsible for the development of the integration and migration of the Legacy system (SQL Server) to the E-Business Suite, modules (Contract, Opportunity, Quotation, Territory, Customer Registration), CRM, OKC, ASO, Tele Sales and TCA.
  • The information was integrated into E-Business Suite through the Oracle API ensuring data integrity.
  • Development of new features in the EBS system using forms and reports to attend the requests of several departments.

Oracle Tools: Pl-SQL, Packages, Procedures, Functions, SQL, Triggers, BULK (Insert/Select, FORALL) Types, Ref Cursors, Arrays, Forms, Reports.

Confidential

Sr. Oracle Developer

Responsibilities:

  • The objective of the project was to automatically register, in the Oracle E-Business Suite, the orders input via the web. Packages and procedures were developed for interacting with the database objects (API) of the core of the E-Business Suite.
  • This method ensured the integrity of the information as if the user had typed his contact information, address, quotation, opportunity and territory into the application screen. This guaranteed the complete integration of the orders from the web.
  • Technical consultant responsible for the integration of the E-Business Suite with the diverse legacy and satellite systems of the company.
  • The project's objective was to allow Ticket to process credit cards and free itself from the third-party processors Orbital and CSU.
  • The success of the project allowed for increased agility, reduced processing cost, greater control and more security of the information.

Oracle Tools: Pl-SQL, Packages, Procedures, Functions, SQL, Triggers, BULK (Insert/Select, FORALL) Types, Ref Cursors, Arrays.

Hire Now