Vinicius Viana, PL/SQL Tuning Developer in Porto Alegre, RS, Brazil
Vinicius Viana

PL/SQL Tuning Developer in Porto Alegre, RS, Brazil

Member since November 23, 2018
Vinicius is an IT professional with extensive experience in system development, project management, and production application support. For over 18 years, he’s worked as an Oracle DBA (specializing in tuning) and for the past six, as an apps administrator for Oracle EBS (upgrading EBS from 11i to R12 and from R12 to R12.2). On a personal level, Vinicius is resourceful and proactive, is self-possessed during emergencies, and excels at teamwork.
Vinicius is now available for hire

Portfolio

Experience

Location

Porto Alegre, RS, Brazil

Availability

Part-time

Preferred Environment

Oracle and Oracle EBS 11i and R12

The most amazing...

...and useful thing I do on a regular basis is fine-tune reports and queries that use to take hours and make them execute in seconds.

Employment

  • Application Support Senior Advisor

    2008 - PRESENT
    Dell EMC
    • Supported the company's global general ledger and finance system.
    • Created a dashboard to monitor the main health indicators for Dell's finance system.
    • Upgraded the EBS system from 11i to R12.1 and from R12.1 to R12.2.
    • Implemented SQL tuning of several queries and reports using hints, SQL profiles, and SQL baselines.
    • Created multiple SQL extractions for audit purposes.
    • Maintained proactively the database to ensure that the system had an optimal performance.
    Technologies: Oracle Database, Oracle EBS, PL/SQL
  • Software Engineer

    2001 - 2008
    TeleNova Communications
    • Acted as the product owner and developer for the company's call router system based on Cisco technology and developed it using C.
    • Fulfilled the role of Oracle DBA.
    • Developed the company's SIP platform using C.
    • Built the company's billing platform using PL/SQL and ASP.
    • Developed the distributed call billing platform for prepaid calling.
    Technologies: C++, Java, Oracle
  • System Analyst

    2000 - 2001
    RGE | Rio Grande Energia
    • Developed and analyzed the company's billing system based on Oracle and PowerBuilder technologies.
    • Worked with the team responsible for developing the standard pattern for the company.
    • Developed the testing framework for the billing system—reducing the total effort to complete regression tests related to changes to the billing system.
    Technologies: Powerbuilder, Oracle
  • Programmer

    1998 - 2000
    Cumerlato & Schuster (Consulting Company)
    • Developed a general ledger system.
    • Built up a payables/receivables system.
    • Implemented the general-ledger-and-payables system on a customer's premises.
    • Developed several integrations between the general-ledger-and-payables system with other systems based on customer needs.
    Technologies: Oracle, PowerBuilder, PL/SQL

Experience

  • SQL Tuning (Other amazing things)

    I´m known for being the go-to guy to help development teams to tune their SQL queries and reports. Reports that used to take hours or days are tuned to complete in few seconds or minutes—and sometimes without it being necessary to change any code.

    In this particular field, I've won quite a few awards for this type of work because nobody else in my company was able to fix or suggest fixes for some of the queries that I ended up solving.

  • Oracle E-Business Suite Monitoring System (Development)

    On this project, I developed an Oracle E-Business Suite monitoring system to help troubleshoot E-Business suite issues. The system was developed using an Oracle database as the back-end and Perl and Apache for the front-end. By using the system, users are able to monitor the overall health of E-Business instances and can deeply inspect what sessions are doing at a database level with SQL plans and some other statistics.

  • Oracle EBS 11i to R12 Upgrade (Development)

    Here, I worked on a project to upgrade the company Oracle E-Business Suite from 11i version to R12 (including an upgrade of the Oracle database from 11i to 12c). I also helped on the custom code retrofitting and with Oracle patches and upgrades. In addition, I worked with the business to identify and fix production issues after it went live with new E-Business suite version

  • Call Billing System (Development)

    Here, I developed a call-billing system based on CDRs (call detail records) provided by Cisco gateways. The system was developed using an Oracle database as the back-end and ASP (IIS) for the front-end. The final system was able to bill more than 18 million minutes per day

  • General Ledger and Payables System (Development)

    Here, I developed a general ledger and payables system used by several customers in Brazil. I implemented the system, integrating it with other systems used by customers, and provided level 2 user support.

  • Distributed Prepaid Calling Card Billing Platform (Development)

    This project involved a distributed prepaid calling card platform responsible for the billing of more than 3 million minutes per day. The system was developed using Oracle database distributed in three different physical locations and Cisco gateways. I handled the integration between databases using database links and achieved almost real-time full synchronization between all three locations.

Skills

  • Tools

    EBS11i, Oracle E-Business Suite (EBS) R12, EBSr12, Oracle E-Business Suite (EBS), Oracle EBS General Ledger, Shell
  • Storage

    PL/SQL Developer, Oracle PL/SQL, PL/SQL
  • Other

    PL/SQL Tuning, Scrum Master, Oracle Application R12 EBS, ShellScript, Shell Scripting, Certified Scrum Master
  • Languages

    Java, Perl, C++, PowerBuilder
  • Platforms

    Linux, Windows

Education

  • Bachelor's degree in Computer Science
    1994 - 1999
    UFRGS | Universidade Federal do Rio Grande do Sul - Porto Alegre, Brazil

Certifications

  • ITIL v3 Foundation
    JUNE 2012 - PRESENT
    EXIN

To view more profiles

Join Toptal
Share it with others