Personal Particulars
|
|
|
|
|
•Name
|
XXX
|
|
|
|
|
|
|
|
|
•Job Description
|
|
|
|
|
Assist in tender response preparation, technical presales, feasibility studies, SDLC documentation, Agile prototype development and UAT test cases compilation, rapid application development (RAD) and ad hoc data retrieval and preparation. Project highlights include Data Standardization ,Integration and Warehousing Studies and Implementation for XXX (Tools worked : SQL Server , Oracle ,SSIS, Talend,VB6, Microsoft Dynamics, T-SQL, Power BI, ER Modelling , Dimensional Modelling) , Document Approval Workflow design RAD for a subsidiary of XXX (Tools worked : SQL Server ,ASP.NET MVC, Entity Framework, Linq, Jquery, Webix libraries, VBA, Git) , Technical Presales and documentation for Data Mart and Analytics Studies for XXX, Module Enhancement and User Support for Outpatient Administration Portal for XXX (Tools worked : ASP.NET MVC , Sql Server, Trello) Web scraping and Data Integration / Cleansing for XXX (Tools worked : Python , beautiful soup, selenium, Sql Server)
|
|
|
|
|
|
|
|
•Period
|
2018 –2019
|
|
|
•Company
|
XXX
|
|
|
•Title
|
Contract Senior BI Developer
|
|
|
•Job Description
|
|
|
|
|
Project based. Develop/Maintain/UAT Corporate wide Business Intelligence Reporting and Visualization for Asia Pacific Offices/Shops using Microsoft BI Stack (SSIS/SSRS/SSAS/Power BI/SQL Server/Microsoft Dynamics/Sharepoint) migrating from Oracle/Brio Reporting Suite. Liaise with various local and overseas users/technical teams/vendors/contractors on data requirements and governance. Hands on experience in T-SQL, PL/SQL , Query performance tuning and troubleshooting , Database Monitoring. Develop and test on star schema dimension modelling on data mart to pilot local power BI prototypes. Develop scripts to help automate code generation for database maintenance tasks.
|
|
|
|
|
|
|
|
•Experience
|
|
|
|
|
•Period
|
2016 – 2018
|
|
|
|
•Company
|
XXX
|
|
|
|
•Title
|
Contract Senior Developer
|
|
|
|
Job Description
|
|
|
|
|
Project based. Enhance XXX Betting Intelligence and Reporting Applications. Follow SDLC procedures for development and documents. Collaboration in system audit , DR Drills , database restore/archive planning and execution, UAT setup , assist and monitoring . Perform adhoc queries and impact analysis using vba/vbscript and sql. Automation script maintenance and development for system admin tasks like hotfix deployment,user-requested data patching, continuous log monitoring. VBScript. Jobflow design for Control-M and SQL Agent Job automation. Database used : Sql server. Automation tools: Intelligence tools: SSIS , SSAS. Development tools: TSQL, ASP. NET C#, vbscript.. Collaboration Platform: Team Foundation Server , Sharepoint
|
|
|
|
|
|
|
|
|
|
|
|
|
|
•Experience
|
|
|
|
|
•Period
|
2015 –2016
|
|
|
|
•Company
|
XXX
|
|
|
|
•Title
|
Contract System Specialist
|
|
|
|
Job Description
|
|
|
|
|
Maintain and enhance XXX Banking Regulatory Reporting Application. Follow SDLC procedures for development and documents. Collaboration in system audit and DR Drills. Perform AD hoc queries and data analysis for other departments using vba and sql. Daily automation job monitoring and troubleshooting. Automation script maintenance and enhancement including linux shell script and powershell, VBScript. Database used include Sql server, mysql, Teradata(for ETL). Reporting tools: SSRS. Development tools: TSQL, ASP. NET C#
|
|
|
|
|
|
|
•Period
|
2014 - 2015
|
|
|
|
•Company
|
XXX
|
|
|
|
•Title
|
Database Programmer
|
|
|
|
Job Description
|
|
|
|
|
|
Design , build and maintain Access and mysql database for daily fund positions and transaction data from XXX daily statement files. Automate the daily maintenance , control and data parsing/import/export with VBScripts and Excel VBA scripts. Communicate with analysts to build custom queries and management reports for decision making. Assist quant analyst to maintain and enhance R templates. Build fund analysis templates with Bloomberg API. Simple ASP.NET intranet website to present fund performance data and key powerpoints for client presentation and internal use.
|
|
|
|
|
|
|
|
|
|
|
|
|
•Period
|
2014 – 2014
|
|
|
|
•Company
|
XXX
|
|
|
|
•Title
|
Contract Analyst Programmer
|
|
|
|
Job Description
|
|
|
|
|
|
Project based. Support Brand Management Controllers in revising / upgrading/ amending VBA macros and pivot tables to automate the variance analysis / validation / forecasting /reporting of various lines of XXX Consumer Products and evaluation of Promotion Campaigns on various outlets. Hands on experience on SAP CO module on maintenance of overhead cost accounts and cost allocation exercises. Export data to excel for further analysis.
|
|
|
|
|
|
|
|
|
|
|
|
|
•Period
|
2012 –2013
|
|
|
|
•Company
|
XXX
|
|
|
|
•Title
|
Contract Analyst Programmer
|
|
|
|
Job Description
|
|
|
|
|
|
Support and maintain the Internal Cash Fund management systems and first line support of related softwares(SAS, Bloomberg Terminal). Enhance and support the Business Valuation Analytic System of Housing Projects (developed in VBA and SQL Server). Performance Log Monitoring. Documentation maintenance and update. Assist in user requirement studies and acceptance tests. Assist in Disaster Recovery Drills and System Audits
|
|
|
|
|
|
|
•Period
|
2010 – 2012
|
|
|
|
•Company
|
XXX
|
|
|
|
•Title
|
Financial Software Officer/Senior Dealer
|
|
Job Description
|
|
|
|
|
|
Handle the training ,business development, technical and operation support of the online trading platform , MetaStock Software , DDE Quote Server and Stock data feed service. Assist in system upgrade and rehearsals. Maintenance of Sql Server database for client billing and management reports.
|
|
|
|
|
|
|
•Period
|
2008 – 2010
|
|
|
|
•Company
|
XXX
|
|
|
|
•Title
|
Teaching Assistant(Accounting and Finance)
|
|
Job Description
|
|
|
|
|
|
Assist lecturers in tutorials, research, assignment and student consultation on finance subjects. Enhance and maintain the student Quiz/Exam Scores Analysis Online System (developed in .Net using Visual Studio 2008 and SQL Server). Write Java Swing programs for finance tutorial demos. Research data maintenance via Excel VBA.
|
|
|
|
|
|
|
•Period
|
2007 – 2008
|
|
|
|
•Company
|
XXX
|
|
|
|
•Title
|
Research Assistant(Accounting and Finance)
|
|
Job Description
|
|
|
|
|
|
Assist lecturers in research and tutorial in finance subjects. Use SAS to generate statistical reports Research data maintenance via Excel VBA.
|
|
|
|
|
|
|
•Period
|
2007 – 2007
|
|
|
|
•Company
|
XXX
|
|
|
|
•Title
|
Financial Reporter
|
|
|
|
Job Description
|
|
|
|
|
|
Write online financial news/abstracts on results announcements, stock trend commentary and conduct interviews with analysts
|
|
|
|
|
|
|
•Period
|
2006 – 2007
|
|
|
|
•Company
|
XXX
|
|
|
|
•Title
|
Corporate Account Executive
|
|
|
|
Job Description
|
|
|
|
|
|
Serve company clients on trading stocks and futures . Provide market commentary and education.
|
|
|
|
|
|
|
|
|
|
|
|
•Period
|
08/2005 – 08/2006
|
|
|
|
•Company
•Title
|
XXX
Account Executive
|
|
|
|
Job Description
|
|
|
|
|
|
Serve clients on trading stocks and futures . Provide market commentary and education.
|
|
|
|
|
|
|
|
|
|
|
|
|
•Period
|
08/2011 – 01/2016
|
|
|
|
Job Description
|
Finance Blogger /Online Tutoring and Programming Projects
|
|
|
Teach courses on trading softwares (Metastock , MT4..) and programming for trading/market analysis/backtesting (Excel VBA , MFL, SP Trader API , IB API, MT4 API) . Also take on related ad hoc programming projects. Held online seminars on ActivTrade (Online Brokerage)
Blog url : http://tradealgo.blogspot.hk
|
|
|
|
|
| |
|
|
|
|
|
|
|