| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
ResumeCandidate's Name
PHONE NUMBER AVAILABLEPROFILESenior developer using Oracle SQL and PL/SQL, SQL Server SSMS/T-SQL. Experience with Oracle database technology, as well as Oracle products such as Apex and GoldengateAzure data factory (admin/developer)Devops (admin)PRIMARY SKILLSOracle Database : 8i through 19c Oracle Fusion ERP/CX/HCM OCI and OIC
Exadata 12c Oracle SQL and PL/SQL BI Publisher Goldengate 12c DW/Business Intelligence Apex 3.2, 5 and 23.2 (including JQuery) Data modelling dimensional and OLTP Application DBA Linux (20 years) scripting etc Deployment methodologiesOther Python - intermediate Passed Core and Advanced Alteryx exams Tableau training through company SQL Server T-SQL development SQL Server DBA T-SQLAzure Azure Data Factory (pipelines) Devops (administrator) Git basedPERSONAL DETAILSLocationChattanooga TNCell PHONE NUMBER AVAILABLEEmail EMAIL AVAILABLECERTIFICATION Oracle Certified Apex Expert(2013 v3.2) Teradata Certified Master 2009 Alteryx Designer Advanced 2019QUALIFICATIONSTechnical ability in developing complex PL/SQL code (more than 15 years).
Oracle database, SQL and PL/SQL knowledge. I have over 20 years in this areaSkilled in tuning Oracle SQL and PL/SQL
Full time on Oracle 8i through all versions to 12c and ExadataHands on experience at designing and exploiting advanced Oracle database functionalityProven capability at developing end to end applications including PL/SQL back-end and Apex front-endExperienced in Oracle VLDB development (eg partitioning, materialized views, indexing strategies)Database design - experience includes dimensional modelling
Installed, configured and administered Oracle products (including Apex/Goldengate)Problem solving, issue identification, analytical and technical documentation skills.PROFESSIONAL EXPERIENCETechnical lead for large scale system conversion from SQL Server to Oracle FusionOracle REST APIs for various implementationsOracle Cloud Infrastructure/Oracle Integration CloudOracle BI Publisher reportingAzure Data FactoryImproved consultant developed ETL workflows into well architected Alteryx/Tableau/SQL Server solutionDesigned complex Oracle BI solutions, including for multi-country (+20) deploymentDeveloped comprehensive PL/SQL framework for rapid BI developmentManaged all Oracle application DBA requirementsDesigned and developed a few hundred Apex pages for various applicationsProvided mentoring and training to a couple of levels of staffSome other technologies, roles and coursesTrained by Ralph Kimball in data warehousing dimensional modelling (advanced level)Senior Technical Architect responsible for Vodacom s DW Oracle solutionData modelling experience including tools like Erwin and PowerDesignerKnowledgeable in ETL processing methods and code design patterns (Oracle specific)Alteryx and Tableau, and replaced Alteryx extracts (175 tables) with SSIS parallel processing
EDUCATIONVictoria Park High School. Port Elizabeth, South AfricaMatriculationUniversity of South AfricaDiploma in Datametrics (with distinction)Bachelor of Commerce incomplete Major in Information Systems III completed and also Accounting II passed. Decided not to continue studies.WORK HISTORY
Freelancer .. Sep 2023 currentMultiple small projects using Oracle SQL (19c) and PL/SQL, Apex (23.2), Azure, SQL Server and Python.I am currently completing projects for analysis of several million words of text in reference material, as well as an aircraft records database.Astec Industries .. Aug 2022 Jul 2023Project Helix Technical Team LeadMy responsibilities included:Infrastructure requirements staging SQL Server database, sftp servers etc.Design and development of T-SQL/Python data conversion framework from SQL Server to Oracle Fusion.Development of the more complex conversions for Product Hub Data (all inventory related data) for the first site to be migrated (this was successfully achieved).Training for the migration development team on the framework, how to develop T-SQL procedures, how to code data mappings.Quality review of all OIC integration, BI Publisher artifacts and Oracle ATP database objects.Oracle Autonomous Database (ATP) administrator.Azure devops administrator for OIC artifacts, Oracle ATP objects, Oracle BI Publisher reports.Central administrator for all OCI credentials and security.I was the Astec liaison with the contracted Price Waterhouse Cooper Fusion implementation team.I developed and also corrected many Oracle BI Publisher reports for Oracle HCM.I developed the Helix exchange rate request and load mechanism in Python and T-SQL for Bloomberg exchange rates.Astec Industries .. Mar 2020 Jul 2022Senior Technical ArchitectI was responsible for architecture of the Astec EDAP DW (Electronic Data and Analytics Platform Data Warehouse),and for guiding the development initially outsourced to Dell.
This incorporated many key areas including Inventory, Procurement, Sales, Finance (corporate CoA mapping to +-20 subsidiaries for GL reporting), Accounts Payable and Accounts Receivable.It included all data modelling for EDAP (using Erwin), both for the dimensional models and staging area.I liaised on a daily basis with the initial Dell development team during design and development of the EDAP ETL processes (using Azure pipelines, functions, T-SQL and some Python).I developed a comprehensive solution for auditing all data changes to the Oracle Fusion applications (ERP, CX and HCP) using Azure pipelines to invoke Oracle REST APIs.I designed and developed multiple smaller subprojects such as analysis of procurement information in depth (Proxima) for cost saving initiatives.Astec Industries .. May 2019 Feb 2020Data Analyst (9 months)
Comprehensive redesign and rewrite of all consultancy (Maine Pointe) developed Alteryx procurement workflows.Development of multiple Tableau dashboards.Vodacom Cape Town . . Oct 2014 Feb 2018Senior Oracle Exadata Developer - 160Tb Operational Data Store (ODS)Initially head-hunted for ODS tuning (SQL, PL/SQL and database, as the solution was plagued by performance issues. Resolved all issues to the client s satisfaction.Substantial tuning of both SQL and PL/SQL on a database of 160Tb.Developed an ODS PL/SQL framework model and solution together with the ODS architect and Oracle in countryDeveloped a substantial amount of custom PL/SQL development eg for billing reconciliation, Mpesa systemGuided a team mostly of seniors, but which was experienced in Sybase IQ but had no prior Oracle knowledge.
Trained the team (8 developers) to OCA level in Oracle SQL and PL/SQLSole ODS resource for Goldengate implementation , management and support.Mentored and guided the team s APEX developers, using Apex v4Introduced solutions for problems such as interfacing to Teradata and MySQL databases, decoding of JSON/BSON, rapid development of PL/SQL where this followed generic patterns5 day Oracle GoldenGate 12c: Advanced Configuration course at Oracle Johannesburg campusAGILE training course (2 days) the Vodafone group is committed to AGILE as a corporate imperative, and the team adhered to thisPrescient Business Technologies .. . Jan 2009 Sep 2014Senior Oracle BI Developer and Consultant
Employed initially as a general Oracle resource as part of a small teamWe developed an in-house comprehensive template and metadata driven framework that far surpassed the functionality of commercially available products such as Informatica, Oracle OWB and ORACLE ODI (in fact, the company phased out all use of their Informatica solutions when the framework matured sufficiently)Introduced and developed many of the key framework features, including range processing of datasets, CDC methods, pattern tasks, dimensional modelling capabilities, fully automated deployments including simulations, master data management and user data facilitiesDeveloped all flat file loading, also using a template driven approach. Used standard Unix commands, shell scripting and OS_COMMAND packageIntroduced APEX for the metadata management and operations console application, and from then on was the sole developer for several years of the framework GUI of more than 300 pages (until two team members were added for this role)The team grew to +40 members but the core development remained with myself and the technical directorFaritec . . Sep 2009 - Dec 2009Teradata ArchitectTeam leader (of 4 members) for the Vodacom Enterprise Data Warehouse solution, using Teradata and Oracle Data Integrator (the previous DW was supposed to be retired according to Vodacom policies, but is still running today as far as I know)
The team developed all ODI modules for maintenance of about 120 dimensions, some of which were complexDecided to leave after 4 months as there was no exposure to Oracle (above development was complete by then)Previous IT experienceSPLOld MutualAmdahlNorwich Life InsuranceAtlantis Diesel EnginesWella SAEastern Province Building SocietyFord Motor Company
|
