$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Ecommerce Web & Database Engineer
Simon Ward
,
Durban, South Africa
Experience
Other titles
Skills
I'm offering
Recent projects have strengthened my C#/MVC portfolio. Having a very strong background in database technologies including MS SQL and MySQL, this puts me a very good position to take on more advanced CRM and ERP system development.
Currently really working on both Angular 2 stack and Asp.Net MVC (framework and core).
Recent projects include:
http://**********.**
http://**********.**
http://**********.**
Currently really working on both Angular 2 stack and Asp.Net MVC (framework and core).
Recent projects include:
http://**********.**
http://**********.**
http://**********.**
Markets
United States
(Remote
only)
United Kingdom
(Remote
only)
Denmark
(Remote
only)
Norway
(Remote
only)
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2014 - ?
job
DWH / DBA Team Lead
Ignition Group.
My main focus at Ignition is to provide leadership for my team and others in the space of data warehouse and SQL Server DBA activities.
Objectives:
• Implement SCM via TFS using SRUM
• Implement company wide security model for all database systems
• Implement infrastructure design to segregate development, testing and production systems
• Build a team to provide production support for database systems to the business and other development teams
• Stabilise consistently failing databases
• Implement continuous integration via TFS, YAML and PowerShell.
• Implement change control processes for database changes to production environments
• Build a SQL Server DBA / Development team
• Re-design, architect and rebuild data warehouse
Other functions:
1. Web Dashboard development
2. C# Web Services (Web API)
3. JQuery and Angular development
Objectives:
• Implement SCM via TFS using SRUM
• Implement company wide security model for all database systems
• Implement infrastructure design to segregate development, testing and production systems
• Build a team to provide production support for database systems to the business and other development teams
• Stabilise consistently failing databases
• Implement continuous integration via TFS, YAML and PowerShell.
• Implement change control processes for database changes to production environments
• Build a SQL Server DBA / Development team
• Re-design, architect and rebuild data warehouse
Other functions:
1. Web Dashboard development
2. C# Web Services (Web API)
3. JQuery and Angular development
Web API, Processes, Production, SCM, Web, Server, Testing, Infrastructure, Development, Support, TFS, Web Services, Security, Design, Leadership, PowerShell, Integration, C, API, Data Warehouse, Database, Angular, SQL Server, Sql, Jquery
2012 - 2013
freelance
Senior Technical Lead Consultant (SSIS & SSRS)
Talota, Dimension Data, EThekwini Municipality.
Main Project: Data warehouse Reporting
Position: Senior Technical Lead Consultant (SSIS & SSRS)
Responsibilities:
• Installation and configuration of reporting services and instances thereof on SQL 2008 r2 and SQL 2012
• Working with users, business analysts and other stake holders to prepare, develop, maintain and deliver reports for the data warehouse. Reporting include: The Metro Bill - delivered to millions users others include: finance, utilities, control checks, operational reports and many more categories.
• Manage and mentor a fairly young team with tasks and activities to ensure all the reports are delivered on time and are accurate through the use of standard practises such as quality control checks, milestones, and resource allocation activities.
• Chairing team meetings, delegating actionable tasks to team members, and ensuring progress reports and updates are completed each week.
• Managing expectations in both directions to provide as much transparency as possible.
• Mentoring the team, providing one-on-one training and advice on best practises for developing reports on SQL 2008 r2.
• SharePoint 2010 implementation for the team and department. Awareness workshops promoting the use and future use of SharePoint.
Position: Senior Technical Lead Consultant (SSIS & SSRS)
Responsibilities:
• Installation and configuration of reporting services and instances thereof on SQL 2008 r2 and SQL 2012
• Working with users, business analysts and other stake holders to prepare, develop, maintain and deliver reports for the data warehouse. Reporting include: The Metro Bill - delivered to millions users others include: finance, utilities, control checks, operational reports and many more categories.
• Manage and mentor a fairly young team with tasks and activities to ensure all the reports are delivered on time and are accurate through the use of standard practises such as quality control checks, milestones, and resource allocation activities.
• Chairing team meetings, delegating actionable tasks to team members, and ensuring progress reports and updates are completed each week.
• Managing expectations in both directions to provide as much transparency as possible.
• Mentoring the team, providing one-on-one training and advice on best practises for developing reports on SQL 2008 r2.
• SharePoint 2010 implementation for the team and department. Awareness workshops promoting the use and future use of SharePoint.
Sql, Data Warehouse, SharePoint, Training, Ssis, Mentoring, Mentor, SSRS, Finance, Workshops, Implementation, Utilities, Tech lead, Many more
2007 - 2011
job
Senior Technical Lead (SSIS & SSRS)
HSBC PLC (UK).
Responsibilities:
• Hardware / infrastructure acquisition and configuration
• Installation and configuration of all 10 application servers with Integrations and Reporting Services on SQL 2008 R2
• Requirement definition and creation of SSIS packages to collect source data from approx. 50 internal HSBC systems via SFTP, NAS locations, Connect Direct services and https services
• Loading of these data sources to the Staging databases using SSIS
• Data cleansing and transformation processing using SSIS workflow and dataflow tasks.
• Management of the staging databases for all regions (UK, Hong Kong, France and Treats (in Europe)
• Typical SSIS package used package configurations (from SQL Server), OLE DB connections, WMI Event Watcher Tasks, Loop containers (for each, sequence and loop), OLEDB Command Tasks, Auditing Tasks, aggregation's, multicasts, merge joins, union all joins, lookups, row counts, copy columns, derived columns and cache transformations.
• Created SSRS reports to extract data for presentation using the standard HSBC themes
• Provided dynamic using parameter selections on all reports
• Generated cached snapshots for reports to be run against at the end of the ETL process to improve response times and performance.
• Used Rational Team Concert (RTC) for source control and task management.
Other Projects and teams worked in at HSBC
Project Name: Triple Application Support & Development (6 Months)
Responsibilities:
• SQL 2000 DTS package management & ad-hoc development
• User support queries for finance back office in-house systems
• Telephone, ticket and email support
• Ad-hoc MS access and Excel VBA programming
Project Name: Triple SQL 2005 Migration Project (9 months)
Responsibilities:
• Lead development for the SQL 2000 to SQL 2005 migration of the Triple application
• Development of SSIS 2005 packages
• Migration and upgrading from DTS 2000 to SSIS 2005
• Migration from SQL Server Agent scheduling to Control-M scheduling
• Built over 3500 packages and Control-M jobs for this migration
• Acquisition on new hardware, software installations and licensing
• Infrastructure architecture and resource planning
Project Name: Market Business Information - Sybase 15 Migration Project (3 months)
Responsibilities:
• Managed the migration project resources (both hardware and team members)
• Created project schedules for delivery, time lines, and milestones
• Liaised with middle and senior management on key milestones and cost
• Ran testing cycles, deployment of upgraded code and DR testing
• Implemented new Control-M schedule
Project Name: RAD Team - Excel 2003 VBA Tools for Finance (3 Months)
Responsibilities:
• Developed various MS Excel and Access 2003 systems for product control users
• Use a mixture of SQL 2005/2008 database servers for data storage
• Built systems in c# and VB.Net using Visual Studio 2005
• C# systems included OO techniques in order to maintain code re-usability
• Includes interfaces, classes, objects, inheritance and the ADO.NET framework for data access.
• Hardware / infrastructure acquisition and configuration
• Installation and configuration of all 10 application servers with Integrations and Reporting Services on SQL 2008 R2
• Requirement definition and creation of SSIS packages to collect source data from approx. 50 internal HSBC systems via SFTP, NAS locations, Connect Direct services and https services
• Loading of these data sources to the Staging databases using SSIS
• Data cleansing and transformation processing using SSIS workflow and dataflow tasks.
• Management of the staging databases for all regions (UK, Hong Kong, France and Treats (in Europe)
• Typical SSIS package used package configurations (from SQL Server), OLE DB connections, WMI Event Watcher Tasks, Loop containers (for each, sequence and loop), OLEDB Command Tasks, Auditing Tasks, aggregation's, multicasts, merge joins, union all joins, lookups, row counts, copy columns, derived columns and cache transformations.
• Created SSRS reports to extract data for presentation using the standard HSBC themes
• Provided dynamic using parameter selections on all reports
• Generated cached snapshots for reports to be run against at the end of the ETL process to improve response times and performance.
• Used Rational Team Concert (RTC) for source control and task management.
Other Projects and teams worked in at HSBC
Project Name: Triple Application Support & Development (6 Months)
Responsibilities:
• SQL 2000 DTS package management & ad-hoc development
• User support queries for finance back office in-house systems
• Telephone, ticket and email support
• Ad-hoc MS access and Excel VBA programming
Project Name: Triple SQL 2005 Migration Project (9 months)
Responsibilities:
• Lead development for the SQL 2000 to SQL 2005 migration of the Triple application
• Development of SSIS 2005 packages
• Migration and upgrading from DTS 2000 to SSIS 2005
• Migration from SQL Server Agent scheduling to Control-M scheduling
• Built over 3500 packages and Control-M jobs for this migration
• Acquisition on new hardware, software installations and licensing
• Infrastructure architecture and resource planning
Project Name: Market Business Information - Sybase 15 Migration Project (3 months)
Responsibilities:
• Managed the migration project resources (both hardware and team members)
• Created project schedules for delivery, time lines, and milestones
• Liaised with middle and senior management on key milestones and cost
• Ran testing cycles, deployment of upgraded code and DR testing
• Implemented new Control-M schedule
Project Name: RAD Team - Excel 2003 VBA Tools for Finance (3 Months)
Responsibilities:
• Developed various MS Excel and Access 2003 systems for product control users
• Use a mixture of SQL 2005/2008 database servers for data storage
• Built systems in c# and VB.Net using Visual Studio 2005
• C# systems included OO techniques in order to maintain code re-usability
• Includes interfaces, classes, objects, inheritance and the ADO.NET framework for data access.
Workflow, Hardware, Infrastructure, Transformation, Software, Testing, Storage, Office, Server, Data Storage, Usability & UX, Development, NAS, Tech lead, Vb, Framework, Task management, Agent, Sybase, Processing, RTC, Sftp, VBA, Excel, .Net, SQL Server, Database, C, Event, Visual Studio, Usability, ETL, Management, Sql, Net, Vb.net, Ssis, Access, SSRS, Finance, Architecture, Support, Deployment
2006 - 2007
job
Microsoft Office Developer
JP Morgan Chase.
Responsibilities and function:
This position, in the Client Documentation Group of JP Morgan Chase, was to develop 2 MS Access 2002 databases to improve productivity, automate manual processes and to achieve data consistency across departments using the information from the databases for KYC regulatory functions within the bank.
Development Projects:
Both projects worked on we MS Office based, in particular, MS Excel 2002 and MS Access 2002. These projects included extracting information from bank wide applications and databases (Sybase, Oracle (Business Objects) and Lotus Notes). Most of the data extraction was done by writing VBA services and direct connections to relevant databases.
Project Name: KYC Trade Reconciliation Tool
Basic Project Requirements:
• Create and enable daily reconciliations of trades against KYC business rules validating that each client account traded on has the required regulatory documentation in accordance with FSA requirements.
• Enable the reconciliation to be performed on any set of data. (Not just trade information)
Responsibilities:
• Gather application requirements
• Develop the data structure and VBA code for the reconciliation
• Liaise with the project sponsors, contributing data managers and users of the tool
• Training and documentation
Work Done:
• Gathered business requirements
• Produced documentation that includes representational views of the system using Microsoft Visio
• Wrote Excel VBA code based on approved and signed-off requirements specification
• VBA Code includes: Standard modules, class modules, forms.
• Regional testing of the application
Project Name: Remediation Database
Basic Project Requirements:
• Create an Access database to enable Remediation Analysts to keep accurate records of client information and references to quality control documentation.
• Enable both London and Bangalore teams to remediate and QA work done by both teams.
Responsibilities:
• Manage Excel VBA portion of the project
• Liaise with business sponsors regarding the business requirements and documentation
• Liaise with Bangalore remediation teams on how the database should function and what the interface(s) should look like in order to enhance their productivity and help keep tighter measures on remediation projects assigned to them.
• Develop Excel VBA code and create the database
• System Testing and migrating the existing Excel based application to the new database
• User Training
Work Done:
• Gathered business requirements
• Produced documentation on the new features written in MS Word and MS Visio
• Developed Excel VBA code: Standard modules, class modules, XML parsing and data validation
• System testing
• User Training
This position, in the Client Documentation Group of JP Morgan Chase, was to develop 2 MS Access 2002 databases to improve productivity, automate manual processes and to achieve data consistency across departments using the information from the databases for KYC regulatory functions within the bank.
Development Projects:
Both projects worked on we MS Office based, in particular, MS Excel 2002 and MS Access 2002. These projects included extracting information from bank wide applications and databases (Sybase, Oracle (Business Objects) and Lotus Notes). Most of the data extraction was done by writing VBA services and direct connections to relevant databases.
Project Name: KYC Trade Reconciliation Tool
Basic Project Requirements:
• Create and enable daily reconciliations of trades against KYC business rules validating that each client account traded on has the required regulatory documentation in accordance with FSA requirements.
• Enable the reconciliation to be performed on any set of data. (Not just trade information)
Responsibilities:
• Gather application requirements
• Develop the data structure and VBA code for the reconciliation
• Liaise with the project sponsors, contributing data managers and users of the tool
• Training and documentation
Work Done:
• Gathered business requirements
• Produced documentation that includes representational views of the system using Microsoft Visio
• Wrote Excel VBA code based on approved and signed-off requirements specification
• VBA Code includes: Standard modules, class modules, forms.
• Regional testing of the application
Project Name: Remediation Database
Basic Project Requirements:
• Create an Access database to enable Remediation Analysts to keep accurate records of client information and references to quality control documentation.
• Enable both London and Bangalore teams to remediate and QA work done by both teams.
Responsibilities:
• Manage Excel VBA portion of the project
• Liaise with business sponsors regarding the business requirements and documentation
• Liaise with Bangalore remediation teams on how the database should function and what the interface(s) should look like in order to enhance their productivity and help keep tighter measures on remediation projects assigned to them.
• Develop Excel VBA code and create the database
• System Testing and migrating the existing Excel based application to the new database
• User Training
Work Done:
• Gathered business requirements
• Produced documentation on the new features written in MS Word and MS Visio
• Developed Excel VBA code: Standard modules, class modules, XML parsing and data validation
• System testing
• User Training
Access, Basic, Sybase, Processes, KYC, Regulatory, Visio, Office, Testing, Development, QA, Excel, Developer, Word, VBA, Training, MS office, XML, Oracle, Database, Writing
2004 - 2006
job
Research Application Support Analyst
UBS Investment Bank.
Responsibilities and function:
This position, in the Research Application Support team is to support in-house global applications and develop tools to help Equity Research Analysts. The role is split into 30% support, 30% production support, 30% development and 10% RAS Representative Application management.
Development Projects:
All major projects worked on we MS Office based, in particular, MS Excel 2000, MS Word 2000 and MS Access 2000. These projects included extracting information from bank wide applications and databases (Sybase and Oracle). Most of the data extraction was done via XML services and direct connections to relevant databases.
Project Name: Equity Research Model Lockdown Tool (Excel Add-in)
Basic Project Requirements:
• Enable Equity Research Analysts to protect company models, allowing Sales Teams (IBD) to review the models.
• Enable Equity Research Analysts to email protected and UBS branded company models to contacts held in RADAR (In-house interaction management system)
Responsibilities:
• Manage project
• Manage developers and develop code
• Liaise with the project sponsor and managing directors on project status and business requirements
• Conduct and mange testing in all business regions (Sydney, Hong Kong, London, Stamford)
Work Done:
• Gathered business requirements
• Produced documentation that includes representational views of the system using Microsoft Visio
• Wrote Excel VBA code based on approved and signed-off requirements specification
• VBA Code includes: Standard modules, class modules, forms, SQL to extract information from Sybase
• Regional testing of the application
Project Name: VCAM XML Feed Extension (Valuation Cash Accounting Model)
Basic Project Requirements:
• Create and integrate an XML feed from WIRE (Warburg Investment Research Environment) for all the financial information for this model
Responsibilities:
• Manage Excel VBA portion of the project
• Liaise with business sponsors regarding the business requirements and documentation
• Liaise with Stamford development team on how the XML feeds should be presented and it's functionality.
• Develop Excel VBA code
• System Testing
Work Done:
• Gathered business requirements
• Produced documentation on the new features written in MS Word and MS Visio
• Developed Excel VBA code to import the XML feeds: Standard modules, class modules, XML parsing and data validation
• System testing
Below is a list of other projects I have worked on in a similar capacity:
• Contextual Diary (MS Word)
• Million Dollar Reporting (MS Excel, trading)
• Research Contributions Project Tool (MS Access XP)
• DocBook Migration Project (Unix, ClearCase, DocBook)
• Supervisory Analyst Database (MS Access 2002)
Older Working History
This position, in the Research Application Support team is to support in-house global applications and develop tools to help Equity Research Analysts. The role is split into 30% support, 30% production support, 30% development and 10% RAS Representative Application management.
Development Projects:
All major projects worked on we MS Office based, in particular, MS Excel 2000, MS Word 2000 and MS Access 2000. These projects included extracting information from bank wide applications and databases (Sybase and Oracle). Most of the data extraction was done via XML services and direct connections to relevant databases.
Project Name: Equity Research Model Lockdown Tool (Excel Add-in)
Basic Project Requirements:
• Enable Equity Research Analysts to protect company models, allowing Sales Teams (IBD) to review the models.
• Enable Equity Research Analysts to email protected and UBS branded company models to contacts held in RADAR (In-house interaction management system)
Responsibilities:
• Manage project
• Manage developers and develop code
• Liaise with the project sponsor and managing directors on project status and business requirements
• Conduct and mange testing in all business regions (Sydney, Hong Kong, London, Stamford)
Work Done:
• Gathered business requirements
• Produced documentation that includes representational views of the system using Microsoft Visio
• Wrote Excel VBA code based on approved and signed-off requirements specification
• VBA Code includes: Standard modules, class modules, forms, SQL to extract information from Sybase
• Regional testing of the application
Project Name: VCAM XML Feed Extension (Valuation Cash Accounting Model)
Basic Project Requirements:
• Create and integrate an XML feed from WIRE (Warburg Investment Research Environment) for all the financial information for this model
Responsibilities:
• Manage Excel VBA portion of the project
• Liaise with business sponsors regarding the business requirements and documentation
• Liaise with Stamford development team on how the XML feeds should be presented and it's functionality.
• Develop Excel VBA code
• System Testing
Work Done:
• Gathered business requirements
• Produced documentation on the new features written in MS Word and MS Visio
• Developed Excel VBA code to import the XML feeds: Standard modules, class modules, XML parsing and data validation
• System testing
Below is a list of other projects I have worked on in a similar capacity:
• Contextual Diary (MS Word)
• Million Dollar Reporting (MS Excel, trading)
• Research Contributions Project Tool (MS Access XP)
• DocBook Migration Project (Unix, ClearCase, DocBook)
• Supervisory Analyst Database (MS Access 2002)
Older Working History
Access, Basic, Sybase, XP, Production, Visio, Application Management, Office, Testing, Development, Analyst, Support, Unix, Sql, It, Sales, Word, VBA, Management, MS office, XML, Oracle, Database, Research, Excel
2002 - 2003
job
EUC Database Development & Support
Morgan Stanley.
This contract was to analyse, construct, document, test and deploy MS Access 97/ 2000/XP database applications. All database applications were front-end processing engines with Sybase back-end databases.
Database, Test, Access, Support, Development, XP, Sybase, Processing
2001 - 2002
job
Website & Database Developer
Easy Exchange (Ltd).
Develop the backend database management system for the companies trading system and develop the ASP / PHP / MYSQL website, integrating the current design and company branding. This was a new development project that was put through the complete development lifecycle.
Php, Design, Mysql, Branding, Backend, Database, Management, Website, Developer, Development, ASP, Backend
2000 - 2001
job
Analyst Programmer
Morley Fund Management (CGNU).
Develop, maintain and support various applications in VB6 / SQL server, managed in Visual Safe Source. All applications used Component Object Models, Microsoft Transaction Server technology and ActiveX data objects for database connectivity.
Sql, SQL Server, Database, Technology, Safe, Support, Analyst, Server
2000 - 2000
job
Analyst Programmer
NCR UK.
Redesign, maintain and support a new upgrade for the management accounting reporting tool for the financial department of National Cash Registers. Development and scope of the project utilized Excel 2000 and Access 2000. Excel 2000 was used as a front end to the access database, the information server. The front end included the use of filets and pivot tables that extracted the data from the database via ADO.
Excel, Database, Management, Support, Analyst, Development, Server, Redesign
1999 - 1999
job
Analyst Programmer
OSI Services (UK).
This position was to develop, in Excel and Access budget forecasting system that could be used by analysts for query the forecast database via an Excel Add-In. The development life-cycle stages used here where initial scope, prototyping, development/coding and UAT Testing. Other projects included were cash flow and budget import utilities.
Excel, Prototyping, Database, Forecasting, Budget, Analyst, Development, Testing, Forecast, Utilities
Simon's reviews
Simon has not received any reviews on Worksome.
Contact Simon Ward
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Simon directly in Worksome.
38200+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark