Senior Solution Architect
Visual Analysis Asia Pte Ltd
Total years of experience :28 years, 9 Months
Provide pre-sales, training and consultancy services for innovative investigative and analysis solutions to Law Enforcement, Federal & State Government Departments, Telecommunications, Defence, Insurance and Banking, Gaming Markets throughout Asia.
Pre-sales support to Sales Team including demonstrations, workshops, presentations and architectural development
Drive successful outcomes and sales by delivering presentations, white-board sessions and proof-of-concept activities with new prospects and existing clients.
Work with sales and marketing team to identify new opportunities and target audiences for solutions.
Analyse prospects’ requirements and propose the best possible solution.
Tender and proposal development in conjunction with technical sales presentation, architect solutions
Work with the development team to build and test new products and product versions.
Onsite and Offsite strategic consulting with customers.
Post sale product support to customers and partners.
Project Manage Product Implementations and Database builds.
Deliver instructor-led training for IBM products across Asia.
Work to skill up partners and provide pre-sales capabilities for large partner-lead deals across Asia.
Achievements - Identified, provided pre-sales assistance, customer workshops, training and responded to tenders that directly resulted in a revenue return of $800K SGD (gross) in 2014.
A member of the senior management committee
Managed development team consisting of junior and senior developers
Development resource planning and conduct recruitment interviews
Hand-on development on VB.Net, ASP.Net and SQL Server
Implement changes to improve accountability and increase productivity of the team
Liaise with internal and external customers to capture requirement, recommend and present solutions
Propose, design and manage system integration solution to other 3rd party software (HR to time management system)
Responsible for designing and developing solutions in SSIS, DTS, user defined function and stored procedures across the company.
Responsible for designing and developing reports in SSRS and Crystal Reports 11.
Recommended best coding practise, optimising SQL and undertake responsibilities throughout the SDLC.
Facilitate requirement gathering meetings, design, recommend and present solutions best-suited to customer needs.
Propose, design and manage system integration from in-house insurance system to order management system
Subject Matter Expert on SAP Classes and Characteristics migration.
Liaise with the team in local deploy countries on data migration issues and solutions.
Designed and developed a generic extraction, transformation and load (ETL) solutions for local deploy.
Administered staging SQL Server database and implemented multiple data files to enable growth and improve performance.
Designed, architected, developed and implemented VB.NET command line character conversions utility, SSIS & DTS solution to simplify table-level back up task for local deploys.
Lead a database migration project moving from SQL 2000 to SQL 2005 successfully.
Designed and manage the development of reports in MS Access, Crystal Reports 11 and SSRS.
Designed, enhanced and manage development of SAP interfacing application written in Visual Basic 6.0
Provide advice and guidance to team on SQL queries optimisation and enforce coding standards for all SQL queries.
Designed, architected, managed and implemented baseline and replication of SQL database to be use as reference across 10 local deploy countries at any one time to ensure data integrity and consistency.
Conducted meetings for requirements capture, designing and manage development of financial reports in SSRS such as fund performance portfolio, total managed assets and fund analysis.
Designed, architected, developed and implemented a RTF to text translation utility written as a COM object (VB.net) using MS Visual Studio 2003 and SSIS & DTS package to extract data for reporting.
Successfully migrated SQL Server 2000 database system to SQL Server 2005.
Deputise IT manager in managing the SQL development team.
Conducted recruitment for IT department.
Proposed and successfully gained the approval from management to acquire a third party tools to optimise development and provide additional functionality into SSRS.
Responsible for designing, developing COM class library to enable integration of third party functionality (Biller Wizard) into the internet banking application.
Designed, architected, developed and implemented reports using Crystal Report 10 and tools for use during disaster recovery to ensure BAU.
Responsible for designing and developing report solution using SSRS for use in World Wide Web.
Designed, architected, developed and implemented web services that integrates SSRS into the classis ASP application, thus encapsulating report server web engine from public access. At the same time, it enables XML level modification of the RDL dynamically to cater for specific requirement of each NHS primary care trusts.
Responsible for designing, developing and supporting PS enterprise HR and payroll application.
Enhanced and automated the payroll application to client requirement.
Liaise with business user in capturing requirement, designing and developing reports (Cognos Impromptu) and interfaces.
Responsible for leading an implementation of PSe system project.
Designed, architected and developed Pension interfaces (Penserver) on both Oracle and MS SQL for Department for International Development.
Desgined, architected and developed HR intranet website applications for Nottingham Trent University, Powergen, Diamond Trading, Scottish Water and HM Treasury
Designed, architected and developed solutions for various clients including Moore Stephens, Selfridges, Law Society and Trinity Mirrors.
Provide advice and guidance to clients such as Foster Wheeler, London Stock Exchange and Skandia.
Responsible for designing, developing and managing of data migration projects to its completion for clients such as Scottish Water and City & Guild.
Responsible for administering both Oracle and SQL Server databases in the team.
Subject matter expert on Oracle databases.
Responsible for designing and developing Pse software for international clients.
Responsible for capturing requirement, designing and developing PS enterprise application localisation project for Singapore.
Responsible for implementing and delivering PS enterprise to clients that includes Singapore Civil Defence Force, Levis Strauss Singapore and Singapore Press Holding.
Lead PS enterprise professional services team in Singapore.
Responsible for designing, optimising and maintaining shop floor hard disk tracking system.
Took sole responsibility for the transfer of the product tracking system from Minnesota, USA to Singapore for the manufacturing of the first-of-its-kind 10k rpm hard disk. Further develop and implements the tracking system to the shop floor and working closely with production and business colleagues to understand existing processes and identify additional data capturing station for the production line.