$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Elite Database DBA / Developer / Project Manager
Mark Brown
,
VEYRIER, Switzerland
Experience
Other titles
Skills
I'm offering
Oracle DBA, Project Manager, Javascript Developer
Markets
United Kingdom
Language
English
Fluently
French
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2018 - 2019
job
Web Developer, Roussel Perier
unknown.
2018
• Developed a Progressive Web Application (PWA) enabling users to create and manage
simple sound sequences.
• Explored the use of Indexed DB on popular web browsers to store significant volumes of application data (>25MB).
Technologies: PostgreSQL HTML5 CSS3 PWA Service Workers
• Developed a Progressive Web Application (PWA) enabling users to create and manage
simple sound sequences.
• Explored the use of Indexed DB on popular web browsers to store significant volumes of application data (>25MB).
Technologies: PostgreSQL HTML5 CSS3 PWA Service Workers
Html5, Css3, PostgreSQL, Service, Developer, Web
2018 - 2018
job
Migration of Client Documents to an Outsourcing Partner (Development)
Work Distribution.
• A distributed team with a project manager in Geneva
• My main colleagues in Liverpool
• An outsourcing partner in Bioggio
• A testing team in Zurich
• The client in London
• I was working from home between Geneva and Chichester
Following an audit, the client had to convert all of its paper folders--containing confidential client
documents--into electronic form and they needed to be subject to a thorough review process within the
organization prior to the selection of those belonging to active clients being securely transferred to the outsourcing partner.
My role was at first to provide a simple solution enabling the business to centrally register these
documents (once scanned into PDF form). Using an Oracle APEX framework, within three months, I
provided a URL to all account managers (~30) through which they were automatically logged on using a
configured SSO module.
Account managers could package documents into zip files and upload these through the app, greatly
accelerating the process which was completed within six months. Documents were reviewed and
authorized using functions built into the app, which remains in use two years after migration in order to respond to legal requests.
Migration of Client Documents to an Outsourcing Partner (Development)
The original project requirement was to identify documents belonging to this Swiss bank's active clients and securely transfer these to the outsourcing partner.
The documents were held in a product called IBM Content Manager OnDemand. Over the years some
100 million documents (3TB) had been uploaded.
Following the migration, a new project was planned that would archive 100% of the documents prior to decommissioning OnDemand; the scope of the original migration project was "active" clients only--
about 10% of the document population. IBM quoted $500,000 to complete the archive.
I extended the scope of the initial project to extract the entire universe of documents in chronological
order to an Oracle encrypted tablespace. This took three months to complete, but at cut-over, it was a
simple task to identify the relevant set of "active" documents and transfer these to the outsourcing
partner.
What remained in-house was the complete archive of documents on technology that had already been
paid for, making the second project redundant and saving the bank $500,000 in the process.
This project shows that by thinking more broadly about the problem it is possible to achieve far more with much less.
Shrink the Database (Other amazing things)
Following a significant systems transformation project, the bank's technical architect was concerned
that the size of the production Oracle database doubled in size following each end of day process.
In response, a weekly shrinking database process was put in place whereby a member of staff would
spend one day each weekend making arrangements to shrink the database before the start of the following week.
The technical architect asked me to investigate when it became clear that a weekly database shrink
process was becoming a business constraint.
It became clear that the cause lay in an application design flaw whereby individual table fields were
stored as an XML CLOB. After every update, internally, Oracle was maintaining two copies of each row.
After a week spent researching the issue, the solution involved compressing each XML table to reduce the size of the database by 50%, eliminating the need to perform a regular "shrink" process. Once
implemented, the database size remained roughly the same at 50% of its original preshrink dimensions.
This experience showed how thinking outside the parameters of the immediate problem can not only
resolve the main issue but lead to other opportunities for improvement.
• My main colleagues in Liverpool
• An outsourcing partner in Bioggio
• A testing team in Zurich
• The client in London
• I was working from home between Geneva and Chichester
Following an audit, the client had to convert all of its paper folders--containing confidential client
documents--into electronic form and they needed to be subject to a thorough review process within the
organization prior to the selection of those belonging to active clients being securely transferred to the outsourcing partner.
My role was at first to provide a simple solution enabling the business to centrally register these
documents (once scanned into PDF form). Using an Oracle APEX framework, within three months, I
provided a URL to all account managers (~30) through which they were automatically logged on using a
configured SSO module.
Account managers could package documents into zip files and upload these through the app, greatly
accelerating the process which was completed within six months. Documents were reviewed and
authorized using functions built into the app, which remains in use two years after migration in order to respond to legal requests.
Migration of Client Documents to an Outsourcing Partner (Development)
The original project requirement was to identify documents belonging to this Swiss bank's active clients and securely transfer these to the outsourcing partner.
The documents were held in a product called IBM Content Manager OnDemand. Over the years some
100 million documents (3TB) had been uploaded.
Following the migration, a new project was planned that would archive 100% of the documents prior to decommissioning OnDemand; the scope of the original migration project was "active" clients only--
about 10% of the document population. IBM quoted $500,000 to complete the archive.
I extended the scope of the initial project to extract the entire universe of documents in chronological
order to an Oracle encrypted tablespace. This took three months to complete, but at cut-over, it was a
simple task to identify the relevant set of "active" documents and transfer these to the outsourcing
partner.
What remained in-house was the complete archive of documents on technology that had already been
paid for, making the second project redundant and saving the bank $500,000 in the process.
This project shows that by thinking more broadly about the problem it is possible to achieve far more with much less.
Shrink the Database (Other amazing things)
Following a significant systems transformation project, the bank's technical architect was concerned
that the size of the production Oracle database doubled in size following each end of day process.
In response, a weekly shrinking database process was put in place whereby a member of staff would
spend one day each weekend making arrangements to shrink the database before the start of the following week.
The technical architect asked me to investigate when it became clear that a weekly database shrink
process was becoming a business constraint.
It became clear that the cause lay in an application design flaw whereby individual table fields were
stored as an XML CLOB. After every update, internally, Oracle was maintaining two copies of each row.
After a week spent researching the issue, the solution involved compressing each XML table to reduce the size of the database by 50%, eliminating the need to perform a regular "shrink" process. Once
implemented, the database size remained roughly the same at 50% of its original preshrink dimensions.
This experience showed how thinking outside the parameters of the immediate problem can not only
resolve the main issue but lead to other opportunities for improvement.
Outsourcing, ME, Manager, Framework, Audit, Production, App, Oracle APEX, Development, Testing, Transformation, PDF, Design, It, Content, Technology, Less, Oracle database, SoMe, Database, Audit, XML, Oracle, Project Manager
2016 - 2018
job
Applications Migration Lead
Deutsche Bank.
Reverse-engineered the bank's SAGE and Nexus applications to successfully migrate its
active client data to Avaloq.
Built a multi-user Oracle APEX application for 20 users to upload zipped PDF documents into
a central database for subsequent review, annotation, and approval.
Convinced management to convert insecure, poorly performing Microsoft Access trade
blotter application to Oracle APEX.
Liaised closely with the bank's cloud partner to archive all obsolete UK applications to DBaaS within three months of the migration end date.
Took the initiative to replace an outdated replication process with a simple XML-based
solution, saving the cost of three Oracle instances and a costly leased line.
Eliminated the Oracle Discoverer system (two servers, two instances, one software license, 0.2 FTE) by identifying the reports actually used and porting these to Oracle APEX.
Technologies: Oracle, Avaloq, Nexus, SAGE, Unix, Control-M, HTML5, JavaScript, XML, Microsoft
Access
active client data to Avaloq.
Built a multi-user Oracle APEX application for 20 users to upload zipped PDF documents into
a central database for subsequent review, annotation, and approval.
Convinced management to convert insecure, poorly performing Microsoft Access trade
blotter application to Oracle APEX.
Liaised closely with the bank's cloud partner to archive all obsolete UK applications to DBaaS within three months of the migration end date.
Took the initiative to replace an outdated replication process with a simple XML-based
solution, saving the cost of three Oracle instances and a costly leased line.
Eliminated the Oracle Discoverer system (two servers, two instances, one software license, 0.2 FTE) by identifying the reports actually used and porting these to Oracle APEX.
Technologies: Oracle, Avaloq, Nexus, SAGE, Unix, Control-M, HTML5, JavaScript, XML, Microsoft
Access
Javascript, Html5, Oracle, XML, Unix, Database, Cloud, Management, PDF, Software, Oracle APEX, Performing
1999 - 2003
freelance
Oracle Informatica Consultant
Citibank Zurich.
Built a comprehensive ETL solution to load investment bank data using Informatica
Powercenter into an Oracle database.
• Trained internal staff to appreciate how a basic understanding of the underlying database
technology could improve their effectiveness as Informatica developers.
• Implemented several performance improvements int the ETL process, reducing elapsed load
time by over 30%.
Technologies: Oracle, Informatica, Unix
Powercenter into an Oracle database.
• Trained internal staff to appreciate how a basic understanding of the underlying database
technology could improve their effectiveness as Informatica developers.
• Implemented several performance improvements int the ETL process, reducing elapsed load
time by over 30%.
Technologies: Oracle, Informatica, Unix
Oracle, Unix, ETL, Database, Oracle database, Technology, Basic
My education
?
-
2019
n/a
Bachelors, Geography
Bachelors, Geography
Mark's reviews
Mark has not received any reviews on Worksome.
Contact Mark Brown
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Mark directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark