PL/SQL Developer

John R. Habimana

Greater Atlanta Area

*************@*****.*** 677-***-**** linkedin.com/in/johnhabimanaoca

Experienced Oracle PL/SQL Developer, Data Analyst with DBA Background

Consistently deliver Business Intelligence solutions. Reduce reporting latency by performance tuning SQL queries, stored procedures, functions and applying effective indexes. Troubleshoot and resolve defects due to bad data or code malfunction. Complete SDLC by using ETL methodologies by extracting data from various source systems, transforming and loading into Data Warehouse and displaying on reporting dashboards.

PL/SQL Development

Performance Tuning

Database Administration

Client facing Technical Support

Data Modeling

Data Analyst

Professional Experience

ABB Enterprise Software (formerly Ventyx an ABB Company) 2012 – 2016

Technical Consultant (PL/SQL Developer) 2014 – 2016

Implemented Focal Point BI modules such as Outage Management and Asset Reliability. Developed ETL procedures using PL/SQL coding to move information from client’s data sources into the Data Warehouse. Installed and configured Oracle Databases to simulate production in-house. Delivered BI Dashboards to clients and configured based on client’s specification. Coordinated efforts with internal and external project members to ensure successful delivery.

Completed full cycle product delivery for new client, from data mapping, ETL and full configuration.

Wrote scripts and procedures to setup data model for data warehouses for Energy Utility clients.

Resolved most demanding defect as second level support for Customer Care team.

Sr. Technical Support Engineer 2012 – 2014

Provided technical support for Focal Point, a reporting application widely used in the energy industry. The product interfaced with Oracle database with ETL coded in PL/SQL to produce data warehouse fact tables and dimension tables to report on near real time analytical data. Investigated problem situations and reported problems and defects at a detailed level to determine appropriate method of resolution.

Resolved 100% of defect cases assigned by identifying workarounds or requirements to enable developers to easily replicate issues and fix software defects.

Reduced latency by 20% by adding indexes and/or rewriting functions and procedures. Also applied the use of Oracle hints when needed.

Installed Oracle and used Oracle Data Pump to populate database objects.

Modified base PL/SQL code to enable client to obtain desired custom reports.

Reviewed and improved SQL queries to display records in most efficient manner.

Achieved 100% of targeted number of solution documentations.

Aon eSolutions 2009 – 2012

Application Support Analyst

Provided analytical and technical support of RiskConsole, a reporting application used by the insurance industry, with the goal of satisfactory and timely response to client’s needs. Analyzed client data using Oracle SQL & PL/SQL and assisted in the creation of best workaround solutions. Acted as liaison between business/users and other groups during development and support efforts.

John R. Habimana Page Two

Aon eSolutions, Application Support Analyst, Cont.

Resolved over 95% of assigned cases by analyzing client data and determining root cause of error.

Troubleshot errors from data driven events (DDE) coded in PL/SQL and provided fix.

Optimized reports performance by identifying needed database table indexes.

Wrote distributed SQL queries to insure data consistency across Oracle database servers.

Assisted client with configuration of application to meet the desired setup.

Documented 100% of all gathered information and share with team members in lesson learned sessions.

Alltel Communications / Verizon Wireless 1998 – 2009

Oracle/Unix Programmer/Analyst II

Supported Virtuoso II (billing system) by ensuring the quality of code delivered through the Wireless Client Development Pipeline.

Refreshed test environments by extracting data using Perl scripts and SQL* Loader.

Scanned Oracle data dictionaries to fix objects with invalid status.

Troubleshot abends (abnormal end) of scheduled jobs due to data inconsistency.

Performed first level investigation to determine root cause of issues on all new code of Virtuoso II billing system, using C code with embedded SQL on a Unix platform.

Implemented complex SQL queries for the Testers in order to provide them with records that matched the test case criteria.

Performed on team effort 100% analysis on system to insure Y2K compliance.

Education

University of Alabama in Huntsville, Huntsville AL

BS Electrical Engineering

Certification

The Technology Center, Norcross GA

Oracle DBA 10g OCA Certification

Oracle DBA 10g OCP Certification

Technical Skills

Database

Oracle 10g, Sybase ASE 15.0

Operating Systems

MS Windows 2000 Professional, MS Windows XP Enterprise, HP-UNIX 11.1, Solaris –UNIX 10.0, Linux Red Hat 4.0

Programming

C, Perl 5.0, Unix Korn Shell Scripting, Oracle PL/SQL, Jasper iReports

Tools

Focal Point Web Client, Focal Point ETL, Focal Point Administrator, Remedy, SalesForce, Financial Force, Cybermation, Unison Maestro Workload Scheduler, MS Project 2007, MS Office 2007, MS Outlook 2007, PL/SQL Developer 7.1, Toad 9.7, Power BI Desktop, OEM

Contact this candidate