RECRUITER SUMMARY

 

Name:   

Hot HK_IT SQL C# System Analyst

Age:

40’s

Nationality

Hong Kong

Residence

Hong Kong

Experience

 More than 9 years working experience in the IT industry.

 

Currently working in XXX as System Analyst from May 2019-present

Education

Degree: B. Eng Computer Engineering

XXX University

 

Motives & Seeking

He is actively looking for other job opportunities because his current company will soon be liquidated among share holders early this February.

Languages

English

Cantonese

Mandarin-native

Current Salary

$ 492k HKD Per Year

$ 41k HKD Per Month Fixed

+  Bonus

+ Medical

Expected Salary

Negotiable

Notice Period

2-3 Weeks

Interview Availability

1 Week

Key Criteria Notes

  1. His strongest technical skill is Microsoft platform in database like SQL and in programming is C# because he has more exposure on to these.
  2. Has 5-6 years working experience on C#. He used it in web development and in desk top programming. For web development, he builds an in-house platform when he was in XXX and XXX. He rates himself 4.
  3. Has 1-2 years working experience on Java. He used it for desktop and web programming. He has done a web-based project where he builds a web scraper on some financial data and pull them so that in-house staff can extract the details according to criteria. He rates himself 3.
  4. Has working experience on Python and SAS.
  5. Has 4 years banking and financial experience.
  6. Currently, he studies the data structure for customers. Find out some discrepancies. Discuss to customer some issues regarding their database and develop some prototype or reports for enhancement.

 

Recruiter

Victor Chen

Contact

+852 6700 6472

Victor.chen@svarecruitment.com

Any questions regarding this CV or the inviting the candidate for interview, please contact the Recruiter. Terms and conditions apply to all requests, offers and agreements regarding the provision of services, and available upon request.

         

 

 

 

 

Resume

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

 

 

 

               

 

 

 

 

 

Professional Qualifications

 

 

 

CFA level 3 passed (pending Chartered)

Oracle SCJP 6 passed (82%)

 

 

 

•Scholarship

 

 

 

 

Bank of China – OUHK Scholarship 08

 

 

 

Education

 

 

 

 

Year

2006 - 2007

 

 

 

Institution

XXX University

 

 

 

Qualification

Msc Financial Engineering (Distinction. GPA= 3.5)

 

 

 

 

Year

1992 - 1996

 

 

 

Institution

XXX University

 

 

 

Qualification

B. Eng (Computer Engineering) (2nd Class 1st Division)

 

 

Year

2006 -2009

 

 

 

Institution

XXX University

 

Qualification

BA(Hons) Accounting   (2nd Class 1st Division)

 

 

 

 

 

 

Computer Skills

 

 

 

 

Statistics Package :

E-view , SAS, R

 

 

 

Programming :

Excel Macro and VBA, VB.NET, ASP.NET ( Web Form , MVC) C# ,Java(JavaSE,Swing,JSP) , PHP(dreamweaver, Zend Framework) , Javascript, Ajax ,JQuery, T-SQL, Web API(Ebay , Amazon), Python, R

 

Programming IDE :

Visual Studio, Eclipse

 

Accounting/ERP :

SAP(CO)

 

Database :

SQL Server , MySql ,Access

 

Database Tools:

SSIS, SSRS, SSAS, SSMS, SQL Profiler

 

Financial Database :

Bloomberg , Datastream , Reuters Xtra

 

Data Science/ Automation:

VBA, Vbscript, Shell Script, Python, R

 

 

 

 

 

 

Language

 

 

 

 

English, Cantonese , Mandarin

 

               

 

 

To get updates and more, Subscribe Now! Register Now