| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Greater Atlanta AreaEMAIL AVAILABLE PHONE NUMBER AVAILABLE LINKEDIN LINK AVAILABLEExperienced Oracle PL/SQL Developer, Data Analyst with DBA BackgroundConsistently 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 AnalystProfessional ExperienceHitachi Energy (formerly ABB Enter Software) 2018 - 2024Software Technical Support / Customer Experience RepresentativeProvide technical support for industry propriatery applications Focal Point and Lumada APM (Asset Performance Monitoring). Also was assigned Customer Advocate Role for North America customers who used CTRM and ER Suite applications. Was responsible for gaging the customer experience satisfaction with delivered products. Engaged customers to assess their needs and liaised with Developers and Management to initiate required escalations through Jira and/or Service Now. Performed preliminary troubleshooting and documentation of the issues the customers were experiencing.WorldPay 2016 - 2018Sr. Production Systems AnalystProvide technical support for in house applications designed to provide solutions for payments processing industry. Responsibilities include troubleshooting, data configuration through scripting in SQL Server, level 2 on call rotation. Collaboration with developers, and DBA to ensure client satisfaction.ABB Enterprise Software (formerly Ventyx an ABB Company) 2012 2016Technical Consultant (PL/SQL Programer, DBA) 2014 2016Implemented 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.
Wrote scripts and procedures to setup data model for data warehouses for Energy Utility clients. Resolved defects as second level support for the 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 clients to obtain desired custom reports. Reviewed and improved SQL queries to display records in the most efficient manner. Achieved 100% of targeted number of solution documentations.Aon eSolutions 2009 2012Application 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. Resolved over 95% of assigned cases by analyzing client data and determining root cause of error. Troubleshoot 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 ensure data consistency across Oracle database servers. Assisted client with configuration of application to meet the desired setup. Documented 100% of all gathered information and shared with team members in lesson learned sessions.Alltel Communications / Verizon Wireless 1998 2009Oracle/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. Troubleshooting abends (abnormal end) of scheduled jobs due to data inconsistency. 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 the system to ensure Y2K compliance.
EducationUniversity of Alabama in Huntsville, Huntsville AL: BS Electrical EngineeringCertificationThe Technology Center, Norcross GA: Oracle DBA 10g OCA Certification
Coursera : Google Data Analytics ( In Progress)Technical SkillsDatabaseOracle 10g, Sybase ASE 15.0Operating SystemsMS Windows 2000 Professional, MS Windows XP Enterprise, HP-UNIX 11.1, Solaris UNIX 10.0, Linux Red Hat 4.0ProgrammingC, Perl 5.0, Unix Korn Shell Scripting, Oracle PL/SQL, Jasper iReportsToolsFocal 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 |
