Oracle Analyst / Developer
Applicant Tracking System (ATS) Comparison
.
The purpose of this was to:
- Compare an internet advertised job description with my Microsoft Word CV.
- Confirm that my CV was ATS compliant.
- Produce a Microsoft Excel spreadsheet of the results.
Each word in the job description was searched for in my CV along with a count of how many times it occurred. The results were output into a generated Microsoft Excel spreadsheet.
Oracle Analyst / Developer
Enigma Machine
.
The purpose of this was to produce my own version of the Enigma Machine. Background: The Enigma machine is a physical encryption and decryption device, resembling a typewriter, developed and used in the early to mid-20th century. The basic form consisted of 3 rotors with 26 values, the letters of the alphabet, on each rotor. Initially, the rotors are positioned in a pre-determined state.
When each value to encrypt is selected:
- Each rotor subsequently substitutes it for a different value.
- The rotors shift in their relative positions ready for the next value to encrypt.
So, for each value to encrypt, the number of possible outcomes is:
(number of rotor values) ^ (number of rotors) = 26 ^ 3 = 26 x 26 x 26 = 17,576
Where ‘^’ means ‘raised to the power of. To decrypt an encrypted message the process is reversed.
Oracle Analyst / Developer
Data Comparison and Data Visualisation Generator
.
The purpose of this was to:
- Compare two large data sets contained in pipe delimited text files.
- Produce a Microsoft Excel spreadsheet of the results.
The text files contained millions of lines of data. Group Codes (synthetic data) were counted in the first file and the second file. The results were compared and a Microsoft Excel spreadsheet was generated with the results in a number of worksheets.
These contained:
- Tabular forms of results.
- Chart forms of results.
- Conditional formatting.
- Aggregates and calculations.
- Distinct data and sorted data.
- Column filters.
Principal Software Engineer
с 11.2021 - По настоящий момент |Oracle
Oracle RDBMS, SQL, PL/SQL, SQL Developer, SQL Data Modeler, XML, CSV, Perl, JIRA, GIT, Confluence, SharePoint, Linux, MS Office
Oracle Corporation is an American multinational computer technology corporation. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization.
As Principal Software Engineer (PSE) for the Fusion Release Engineering Database Build Team (FRE) my activities and achievements included:
- Developed new reports with Perl, Linux and XML showing which Artifacts were rejected during an FRE build.
- Designed and developed new database applications for:
- The Registration and Classification of FRE builds.
- The management of FRE Artifacts and their Product Owners.
- The management of Issues with Artifacts in FRE builds.
The main technologies used were Oracle RDBMS, SQL Developer, SQL, PL/SQL and SQL Plus.
Oracle database development methods included, but were not limited to:
- Bulk processing.
- Dynamic SQL.
- Dynamic PL/SQL.
- Bind variables.
- Analytic functions.
- Array / Data collection processing.
- Types declared in packages and the database with query constructors.
- Exception handling and DML error logging.
Minimum requirements for all work delivered included:
- Software development life-cycle (SDLC) methods.
- Requirements and bug tracking.
- Peer reviews of designs and code.
- Unit Testing.
- GIT version control for High Water Mark (HWM) deliveries.
Additional duties included:
- Helping colleagues with design and code peer reviews.
- On-going application support and ad-hoc bug fixes.
Senior Developer and Data Designer
10.2020 - 11.2021 |The AA
Azure Databricks, Basic Spark SQL, Basic Spark Python, Oracle RDBMS, SQL, PL/SQL, SQL Server Management Studio 18, JSON, XML, CSV
The AA is a British motoring association founded in 1905, which provides roadside services and assistance, vehicle insurance, driving lessons, breakdown cover, loans, motoring advice, road maps and other services.
As a Senior Oracle Developer and Data Designer, I facilitated the successful delivery of The AA’s Smart Breakdown and Operational Patrol Service Reporting Projects.
This included:
- Produce data platform designs for AVRO and PARQUET to facilitate data science, insights and analysis.
- Produce data warehouse designs to support end-user business reporting in BI Publisher.
- Develop Oracle and SQL Server software to generate source-to-target mappings in Excel of AVRO data.
- Develop MS-Windows software to amalgamate JSON files for Azure Databricks import and analysis.
- Perform analysis of various data types including: Oracle, SQL Server, Azure Databricks AVRO and PARQUET, JSON, XML and CSV.
Senior Oracle Developer
04.2019 - 03.2020 |ELEXON via CGI
Oracle 12c, Toad, JIRA, Pro C / C++ , UNIX, LINUX, SQL Loader, WinSCP, Putty, SQL, SQL Plus, PL/SQL
As a Senior Oracle Developer, I facilitated the successful delivery of ELEXON’s Trans European Replacement Reserve Exchange TERRE Project. Operating within the Utilities sector, ELEXON administers the Balancing and Settlement Code BSC and provides and procures the services needed to implement it. They compare how much electricity generators and suppliers say they will produce or consume with actual volumes. They then work out the price for the difference and transfer funds which involves taking 1.25million meter readings every day and handling over £1.5 billion of their customers funds each year.
Project TERRE implementation into the GB Market changed the BSC systems to facilitate the settlement of exchanged GB balancing Energy Products within TERRE.
New data loaders were required to manage the Replacement Reserve RR Bids and Auction Results from National Grid. Settlement Reports were required for issue to relevant participants.
My role as a Senior Oracle Developer included successfully:
- Designing and developing a bespoke data comparison tool in Oracle. This was primarily used to perform intelligent comparisons between reports, each containing many millions of lines. Open-source products and UNIX ‘diff’ were unable to perform such comparisons with such large files. Analysis was done: by row; by column; by specific data items and in any order. It was fast, efficient, multi-file, multi-user, multi-instance, scalable and effective.
- Developing the new data loader for the RR Bids. RR Bids data was: received in an XML file from National Grid; loaded into an Oracle database in XML format using legacy Pro*C; validated against an XSD schema; queried, validated and processed in XML format using the latest Oracle SQL and PL/SQL in the new Oracle database package.
- Developing the new Settlement Administration Agent SAA Settlement Report for Virtual Lead Participants VLP.
Senior Oracle Developer
04.2019 - 03.2020 |ELEXON via CGI
.
Senior Oracle BI Developer
04.2017 - 03.2019 |RIVER ISLAND
Oracle 12c, Materialized Views , Data Warehouse, ETL, Agile Scrum, SQL, PL/SQL, UNIX , LINUX
As a Senior Oracle Business Intelligence Developer, I facilitated the successful delivery of River Island’s Product Reclass Project. This automated River Island’s reclassification of Product Hierarchies for the Merchandise Planning Reporting MPR Data Warehouse and the Merchandise Forecast Planning MFP Data Warehouse. In addition, I optimised and remedied the ETL processes between the Data Warehouses. Previously, the ETL activities would fail due to the processing of very high-volumes of data running on servers with insufficient storage capacity.
Achievements included:
- Efficient processing of Data Warehouse Fact tables each containing *** billions *** of rows.
- Data Warehouse ETL optimisations and remedies.
- Developing with the latest Oracle RDBMS technologies.
- Developing new Oracle database software.
- Developing highly advanced methods and techniques for fast and efficient processing of data in Oracle.
- Advanced Oracle data processing methods and techniques included:
- Partition Exchange Load.
- Partitioning and dynamic Partitioning.
- MERGE and dynamic MERGE.
- DBMS-PARALLEL-EXECUTE CHUNKS-BY-ROWID / CHUNKS-BY-SQL
- TEMP / UNDO database storage usage management at runtime.
- Dynamic database table management.
- Dynamic database index management.
- Parallel processing.
- Cursors / Associative arrays / Bulk processing.
- In-memory processing.
- Hints.
- Materialized Views / Logs / Fast Refresh management.
- Data Warehouse Fact / Dimension table management.
- Unit Testing.
- Deploying software into System Test which was then deployed into Production.
- Provide DevOps Support to:
- ODBMS Oracle Database Merchandising Systems – Retail Solution.
- CMS Core Merchandising System.
- Enactor POS Point of Service.
Senior Oracle Developer
10.2016 - 03.2017 |GOVERNMENT via CGI
Oracle 12c, VoltDB, SQL Developer, SQL, SQL*Plus, PL/SQL, Agile Scrum, Global Protect, LINUX, Jenkins, Unit testing, Test Automation, UNIX
As a Senior Oracle Developer, I facilitated the successful delivery of the UK Government’s Smart Metering Implementation Program SMIP. The national rollout of electricity and gas smart meters to domestic and small business customers is key in the UK Government’s strategy for achieving its carbon reduction commitments. Achievements included:
- Developing new Oracle database software.
- Fixing live defects.
- Unit Testing.
- Deploying software into System Test which was then deployed into Production.
- Producing Low-Level Design LLD documentation.
- Developing with the latest Oracle RDBMS technologies.
- Developing highly advanced methods and techniques for fast and efficient processing of data in Oracle.
- Advanced Oracle development methods and techniques included:
- Pipelined Table functions.
- Analytic functions.
- In-memory processing.
- Cursors / Cursor variables / Associative arrays / Bulk processing.
- Partitioning.
- Type Constructor Functions / Type Body Constructor Functions.
- Parallel functions.
- Parallel processing.
- Interfacing and synchronizing Oracle RDBMS data with VoltDB data: VoltDB is an in-memory operational database used for high speed data access. VoltDB supports SQL access from within pre-compiled Java stored procedures. The Java was sourced from Oracle Ref Cursors and Database Packages.
Senior Oracle Analyst / Developer and Data Modeler
10.2015 - 09.2016 |MINISTRY OF JUSTICE / WORKING LINKS via SOPRA STERIA
Oracle 11g, Microsoft SQL Server, Toad Modeler, JIRA, MDM, DevOps, SQL Server , Agile Scrum, SQL
As part of the recent Ministry of Justice MoJ Transforming Rehabilitation TR programme, Working Links acquired three Community Rehabilitation Companies CRCs. CRCs are newly privatized organizations responsible for managing low and medium risk offenders on behalf of the National Probation Service NPS.
As the principle Data Modeler and Senior Oracle Analyst / Developer successfully achieved:
- Produced new Conceptual Data Model, Logical Data Model and Physical Data Model PDM.
- Analysed PDM of a source Oracle database.
- Produced entity and attribute lifecycle mappings in Excel.
- Implemented the new PDM into Pega and the SQL Server database.
- The new SQL Server database also facilitated Master Data Management MDM between each satellite CRC.
- Persisted application data into the SQL Server database.
- Documented Process Flows in swim-lane format.
- Configured Pega Data Model, definitions, mappings and transforms for Pega IDM, Pega ODM and Pega PDM.
- Pega IDM - used to hold an XML Schema Dictionary XSD to facilitate acceptance of XML Messages via SOAP protocols through a Strategic Partner Gateway SPG.
- Pega ODM - the logical representation of the business data model. This facilitates a more flexible, dynamic and Object Orientated approach to application development.
- Pega PDM - the physical or common database representation of the business data model.
- Regular customer facing meetings for Business Analysis and Data Modelling of Requirements.
- Regular customer facing demonstrations of deliverables at the end of each Agile Sprint.
- JIRA: Browser based tool used for tracking Agile Sprint tasks and sub-tasks.
Senior Oracle Analyst / Developer
07.2015 - 09.2015 |VODAFONE GROUP PLC via SOPRA STERIA
Oracle 11g, SQL, Microsoft VBA
Vodafone Group PLC is a multinational telecommunications company. As a Senior Oracle Analyst / Developer:
- Successfully optimised very complex SQL query reports.
- Remedied complex queries for very large data sets that were taking hours to complete; reduced their runtime from hours to seconds.
- Technical methods used included Oracle Analytic functions facilitating in-memory row format processing to excellent effect.
- Facilitated the successful delivery of the project into production for the Vodafone Italy Market.
- Designed and developed reports in HP ALM: Excel reports and Business View reports.
- Developed new complex SQL reports.
- Fixed existing complex SQL reports that contained defects.
- Updated Report High-Level Design HLD.
- Introduced Low-Level Report Specifications.
- Documented High-Level Process Flows for Report Version Control and Release / Configuration.
- Documented Low-Level Process Flows for Report Version Control and Release / Configuration.
- Change Request CR Management.
Senior Oracle Analyst / Developer
01.2005 - 07.2015 |MINISTRY OF JUSTICE via SOPRA STERIA
Oracle,Database, SQL, PL/SQL, UNIX,LINUX
ACHIEVMENTS
Providing products and services to The Ministry of Justice MoJ, the National Offender Management Service NOMS and the National Probation Service NPS. As a Senior Oracle Analyst / Developer:
- Future Enhancements FE: Delivering further updates to the key applications that are required for Community Rehabilitation Companies CRCs ‘Share Sale’:
- Anonymised data and PII: Successfully supplied anonymised PII data for use by MOJ security cleared staff during the development and test phases of the project. This was an Oracle ETL Extract, Transform and Load process. The process anonymised a self-consistent and large Oracle database of restricted PII data for use in unrestricted environments. The technical methods that I used included: parallel processing DBMS-PARALLEL-EXECUTE; in-memory processing associative arrays; data caching cursors and variables declared in stored database package headers, bulk processing and non-database files UTL-FILE. All processes were accredited by MOJ Security and Offender Management National Infrastructure OMNI Security.
- Technical Consultant: Application support; System Integration Testing Support according to Agile and Scrum methods.
- Transforming Rehabilitation TR: The TR programme transforms the management of offenders in the community to achieve a reduction in the rate of re-offending whilst continuing to protect the public. Under TR, probation management is divided between the NPS run by the MOJ and the CRCs:
- Anonymised data and PII: Supply anonymised PII data for use by security-cleared staff during the development and test phases of the project. All processes were accredited by MOJ Security and Offender Management National Infrastructure OMNI Security.
- Technical Consultant: Data Migration support and operation; Application support; System Integration Testing Support according to Waterfall methods.
Senior Oracle Analyst / Developer
01.2003 - 01.2005 |CISCO SYSTEMS
Oracle 11g, Microsoft SQL Server, Toad Modeler, JIRA, MDM, DevOps, SQL Server , Agile Scrum, SQL
Cisco Systems is a leading supplier of networking equipment and network management for the Internet. As a Senior Oracle Analyst / Developer:
- Produced e-Marketing Effectiveness modules using Business Objects, Siebel Analytics and Oracle. Designed Star and Snowflake schemas for the modules to give views into the performance of E-Marketing Campaigns.
- Produced complex ETL routines in PL/SQL. Legacy data was provided in different formats such as Microsoft Excel, Microsoft Access, CSV files and other Oracle databases.
- Maintained ETL routines in Informatica. Customer data based in multiple external sources was transformed and loaded into the Data Warehouse. The transformation process used Informatica’s objects as well as calling Oracle database objects to complete the task.
- Provided support to KANA and Salesforce.com. Cisco’s chosen marketing and e-sales applications.
Senior Oracle Analyst / Developer
06.2002 - 12.2002 |EUROSTAR
Oracle,Database, SQL, PL/SQL, UNIX,LINUX
Eurostar is the high-speed rail service directly linking the UK to France and Belgium via the Channel Tunnel.
Full project life cycle duties were performed in this role as Senior Oracle Analyst / Developer to produce the Eurostar Loyalty Program Application LPA:
- Produced routines to extract CRM data from legacy system files and manipulating the data into an Oracle database.
- Produced an interface between Oracle CRM and separate multiple Oracle databases.
- Produced a front-end application to allow maintenance of reference data and the extracted Oracle CRM data. The interface process would subsequently and automatically run on a daily batch basis.
- Documented and coordinated each stage of analysis, design, development and testing unit, system and user-acceptance.
Senior Oracle Analyst / Developer
04.2000 - 05.2002 |FUJITSU
Oracle 12c, VoltDB, SQL Developer, SQL, SQL*Plus, PL/SQL, Agile Scrum, Global Protect, LINUX, Jenkins, Unit testing, Test Automation, UNIX
FUJITSU services in the UK offers a complete range of IT Services and Products across multiple industries in both the Public and Private sectors:
- Senior Oracle Analyst / Developer responsible for performance of full project life cycle to produce a web-based Magistrates Court system. Tasks included liaison with client, function analysis, specification, design, development, installation, testing, implementation, regression testing and performance tuning of this module.
Senior Oracle Analyst / Developer
07.1999 - 03.2000 |SANDERSON via CAPITA
Oracle,Database, SQL, PL/SQL, UNIX,LINUX
Capita is a leading UK outsourcing company. Since it was established in 1860, Sanderson has been creating classic, timeless and inspirational fabrics and wall coverings and has been awarded the Royal Warrant as Purveyors of Wallpapers:
- As Senior Oracle Analyst / Developer, duties included analysis and development in preparation for Y2K. Converted existing Fortran and C programs into PL/SQL. Ad-hoc development of forms and reports for a sales order processing system using Oracle Designer and Developer technology. Responsible for building an interface to an external accounting system based in New York.
Senior Oracle Analyst / Developer
10.1998 - 06.1999 |ANITE SYSTEMS LIMITED
Oracle 12c, VoltDB, SQL Developer, SQL, SQL*Plus, PL/SQL, Agile Scrum, Global Protect, LINUX
Anite provides a comprehensive range of business-critical IT solutions to private and public sector organisations:
- As Senior Oracle Analyst / Developer I was responsible for the development of a Travel and Reservations system that is now being used by major household names such as P&O Cruises. Tasks also included bespoke development to this system, and development of new functionality using Oracle Developer technology.
Senior Oracle Analyst / Developer
02.1998 - 09.1998 |INDUS INTERNATIONAL LIMITED
Oracle 12c, VoltDB, SQL Developer, SQL, PL/SQL
Indus International is a leading provider of Enterprise Asset Management EAM solutions, providing the systems, products and services to help customers improve business performance through better management of their assets:
- As Senior Oracle Analyst / Developer and Technical Team Leader to a team of 5 developers, I was responsible for upgrading an existing asset management system for the BP Exploration organization. Duties also included specification, design, development, installation, testing, implementation, regression testing, and performance tuning of this application.
Senior Oracle Analyst / Developer
01.1996 - 01.1998 |THE NATIONAL HOUSE BUILDING COUNCIL - NHBC
Oracle 12c, VoltDB, SQL Developer, SQL, PL/SQL
NHBC is a leading warranty and insurance provider for new and newly-converted homes in the UK:
The NHBC offer a wide variety of insurance policies and warranty covers to builders with their appropriate housing associations:
- As Senior Oracle Developer, I was involved in developing a new product, Buildmark Choice, specifically tailored to the housing association market. Main tasks included specification, design, development, installation, testing, implementation, regression testing and performance tuning of this application
Senior Oracle Analyst / Developer
01.1995 - 01.1996 |XEROX
Oracle 7,C, SQL,PL/SQL
EDS, an HP company, is a leading global technology services provider delivering business solutions to its clients.
Xerox is a global leader in document management, offering the widest range of technology, consulting services and solutions in the industry:
- This project was to produce interfaces to extract data from an IBM based legacy system into a Market Database.
- Data was then loaded into a Market Customer Database for use by a Sales Force Automation system.
- Main tasks as Senior Oracle Analyst / Developer included specification, design, development, installation, testing, implementation, regression testing and performance tuning of this application.
Senior Oracle Analyst / Developer
06.1994 - 01.1995 |NATIONAL INSTITUTE FOR HEALTH AND CARE EXCELLENCE - NICE
Oracle 7,C, SQL,PL/SQL
The National Institute for Health and Clinical Excellence NICE, previously known as The Health Education Authority, is England's lead body in health promotion, helping people nationally and internationally to make sustainable improvements in health, and working to reduce health inequalities. Two systems were built for this project:
- A Consultant’s database that maintains all information about contract and permanent consultants who have worked for NICE.
- A Project Information database that maintains all information about Projects undertaken by NICE.
- The two systems interfaced with each other. Main tasks as Senior Oracle Analyst / Developer included specification, design, development, installation, testing, implementation, regression testing and performance tuning of this application.
Senior Oracle Analyst / Developer
06.1993 - 06.1994 |EUROTUNNEL
Oracle 7, PL/SQL, SQL
Eurotunnel operates the Channel Tunnel infrastructure and makes available paths to train operators who are licensed to operate cross-channel rail freight services:
- This project involved building a Customer Management System. As Senior Oracle Analyst / Developer, duties included specification, design, development, installation, testing, implementation, regression testing, and performance tuning of this application.
Oracle Analyst / Developer
08.1990 - 06.1993 |THE PARSONS CORPORATION
Oracle 7, PL/SQL, SQL, DCL
Parsons is an engineering and construction firm with revenues exceeding $3.4 billion. Clients included BP and Mobil:
- Duties included developing VAX based financial systems. Namely, Cost Management CMS, Materials Management MMS, a Purchase Order application and an interface to a 3D CAD system. Main tasks as Oracle Analyst / Developer included specification, design, development, installation, testing, implementation, regression testing and performance tuning of these applications.
Powerhouse Analyst / Developer
08.1988 - 08.1990 |THE HEADLAND GROUP OF COMPANIES
PH Dictionary, PH Graph, Quick, PowerHouse PC, Qdesign , QDD
The Headland Group of Companies is an I.T solutions provider:
- As Technical Team Leader and Powerhouse Analyst / Developer, duties included producing a variety of applications including Financial Accounts, Inventory Management, Sales Order Processing, Purchasing Order Processing, HR Recruitment and Personnel Management. Clients included Royal Society for the Prevention of Accidents RoSPA, Hammersmith Hospital, Queen Charlottes Special Health Authority SHA and Cable & Wireless.
