Post Job Free

Resume

Sign in

Software / Database engineer

Location:
Berkeley, CA
Posted:
June 24, 2017

Contact this candidate

Resume:

Sebastien Chouillet

ac0zxd@r.postjobfree.com **** Virginia St #2

+1-510-***-**** Berkeley, Ca, 94079

Multidisciplinary software engineer, jack-of-all-trades, with more than 15 years’ experience tackling a variety of projects and learning new skills on the job. Coding skills include VBA, php, C, Pascal. Excellent problem-solver.

Work Experience

2012-2015 Software Engineer, Portfolio Management Software, EFA, Hong Kong EFA is a Hong-Kong based software development SME, the main product of which is the EFA platform, a publishing tool for financial analysis reports, but branching into buy-side products with EFAdrin. Engineer responsible for EFAdrin, a nascent portfolio management system for hedge funds, with an Excel-based front- end and MS SQL Server back-end:

- Develop database analysis tools for the different ways of viewing the portfolio as required by the client such as live portfolio views, risk metrics, attribution analysis, performance analysis

- Client support

- Ad-hoc analysis as needed by client. See example projects. 2009-2012 Freelance Web Presence Consultant, Hong Kong Offering a variety of web-related services to SMEs in Hong Kong, mostly web design / development and web marketing, but also including system maintenance. Designed and developed web sites with custom CMS systems, integrating social networks such as Facebook and Twitter for social marketing. Some sites were based on existing frameworks such as Drupal or Wordpress, though most were built from scratch in Apache / php. Extensive use of jQuery for visual design elements. Clients included law firms, finance start-ups, photographers, online stores. 2008 I.T. Manager, Middle Island Capital, Hong Kong Middle Island Capital was an alternative asset management firm that actively sought Pan-Asian investment opportunities through the use of derivative instruments. Duties were:

- Define and implement I.T. Policies for new offices

- Liaise with vendors of software solutions

- Ensure maximum uptime of Trading and Risk Management systems

- Ensure maximum uptime of Servers and Network Systems, maintenance of intranet and Active Directory and Exchange servers.

- Development of custom vbscript and excel solutions to automate reporting, risk analysis, accounting and financials

- Maintenance of all technology services, including Sophis Value Risk Management system, Bloomberg terminals, Trading Screen terminals, email communicators (Blackberries and iPhones) and all PC and Mac desktops Late 2007 In-House Salsa DJ, Latinos Club, Beijing Full-time DJ at a popular Latin-themed hotspot in Beijing. 2005-2007 Adecco Hong Kong

2006 Systems Administrator

2005 Project Coordinator

Adecco is the world's leading recruitment agency.

As System Administrator, personal scope of responsibility was network, server and desktop support for Hong Kong and China offices, counting more than 60 users in seven distinct offices, as well as application maintenance and ad hoc project management such as web site development, setup of VPNs and participate in operational projects. Dual reporting to Country Manager for Hong Kong and to Director of Technology for NE Asia, based in Taiwan. As Project Coordinator, Duties were to coordinate a major software project, developed in Europe, with its implementation in the Hong Kong offices of Adecco. Responsibilities included user training, execution and follow-up of UATs, debugging, supervision of data entry efforts. Sebastien Chouillet

ac0zxd@r.postjobfree.com 2301 Virginia St #2

+1-510-***-**** Berkeley, Ca, 94079

Work Experience (continued)

2002-2005 Systems Consultant, Librodot.com, Hong Kong Librodot.com was a web site dedicated to the diffusion of author-right-free literature in Spanish, with over 220000 registered users and 1500 e-books.

Design of member registration system.

Setup and management of a 175000-name mailing list. Transfer of site to a dedicated server.

Complete setup of the system on Red Hat Linux.

2001-2002 Research Assistant, Information Systems Department, City University of Hong Kong.

Assistant to Professor Mohamed Khalifa, director of the Master of Arts in Electronic Business. Management and design of several web sites for Information Systems research projects and online communities, with SQL Server database management and development.

2001 I.T. Manager, Premium Industries Ltd., Hong Kong. Premium Industries is a small premiums trading company. Setup of time-punching and leave-management system for the employees in FileMaker, linked to statistical printouts. Setup of Communigate email servers, setup of network backup system with Retrospect. 1999-2000 Penntech Software Ltd., Paris and Hong Kong. 2000 Business Manager, Hong Kong

1999 Analyst Programmer, Paris

Penntech Software is a French company specializing in custom management solutions for trading offices. Most customers are Hong Kong buying offices for large French retail and mail-order groups. Setup of Computer network for HK office.

Customer relations management: analysis, specification and development. Upgrade of large management database from Visual Fox Pro to Oracle 8i. Design of large secured B2B web site on IIS/ASP for supply chain management. Crystal Reports-based web reporting area, with report parameters. Recruitment of software development staff.

Development for three Hong Kong projects and one in Paris. Development of B2B web site on Lotus Notes.

1998-1999 Analyst Programmer, FABmaster Ltd., Grenoble, France. FABmaster was a world leader in the field of CIM software. It has since merged with Tecnomatix-Unicam. Team development of software upgrade using C++ Builder and Borland Delphi. Programmer in customer support, with reponisiblities for troubleshooting. Sebastien Chouillet

ac0zxd@r.postjobfree.com 2301 Virginia St #2

+1-510-***-**** Berkeley, Ca, 94079

Technical Expertise

Troubleshooting and problem-fixing wizard.

MS Excel expert.

Database design and administration: Microsoft SQL Server, MySQL and Oracle. Windows-based development: Visual Fox Pro, Borland Delphi, Borland C++ Builder, Crystal Reports. Programming Languages include C/C++, Java, VB, VBA, VBScript, JavaScript, Pascal and derivatives. System Administration of MS Windows 2000/2003 servers, Exchange server, Active Directory Networks, as well as Windows, Macintosh and Linux systems.

Web site development on IIS/ASP and Apache/PHP; experience on CMS, Blogging and ERP systems such as Drupal, Wordpress, NetSuite.

Professional Aptitudes

Software Project Management Recruitment, training and supervision on a project involving an Oracle 8i- driven client-server management application and Business-To-Business web site.

User training, team supervision and technical coordination on international software implementation project.

Software Development Experienced in all aspects of software development, from preliminary analysis, through specifications to execution, both independently and as part of a software development team.

Data Analysis SQL, queries, views and scripting, on MS SQL Server, mySql, Oracle. Excel expert, including advanced VBA.

Financial Analysis Working closely with client hedge funds, built a comprehensive portfolio management system from the ground up, including advanced dashboards, performance analyses and ad-hoc analytical projects. Communication Skills Professional-level writing and presentation skills. Experience in technical documentation both for developers and for end users; occasional writer of short fiction.

Learning Skills Self-directed, always ready to acquire new skills. Self-taught SQL and Linux administration.

System Administration Network management of WinNT/2000 network. Varied troubleshooting experience on Windows, Mac and Linux. Setup of Linux dedicated server as multiple name-based server, ftp server, Mysql server, BIND DNS server using Webmin interface. Setup of MS Exchange server, disaster recovery procedures, VPN on Windows 2003 server.

Languages Native English and French.

Conversational Spanish.

Basic German and Portuguese.

Sebastien Chouillet

ac0zxd@r.postjobfree.com 2301 Virginia St #2

+1-510-***-**** Berkeley, Ca, 94079

Sample Projects

Stop/Loss Analysis – Portfolio scenario analysis to determine, based on a client hedge fund investment history, the optimal point at which to unload losing investments. Aggression Scenario Analysis – Ran multiple scenarios for a client hedge fund to answer the question “what would our performance since inception have been if we had fully committed X% of our AUM to every new investment?” Note that this analysis did take into account trading volume in terms of how long it would take to acquire (or unload) each investment.

Idea/Target Module – Created an optional and configurable add-on for EFAdrin that would track some pre-trade analytics, in the form of investment ideas and target prices and dates for those ideas Reconciliation Module – Built an Excel tool to assist reconciliation of EFAdrin data with fund administrator data on a monthly basis, saving the client’s Operations team days of work every month. Excel Ribbon Icon Badging – Found a way to have icons in the EFAdrin Excel Ribbon show iOS-style notification badges to inform users of required actions.

Attendance Tracking System of martial arts school – Built an online attendance tracking system for the aikido dojo to track eligibility for grading exams. It was originally designed for multi-user use, with data input by instructors via iPad- friendly interface. It also had an Excel interface to display reports and prepare printable statistics for eligible members, including a batch-print feature.

Education

1997 Bachelor’s Degree in Mathematical and Software Engineering, Grenoble University. 1995 Math-Sup and Math-Spé, Lycée Saliege, Toulouse. 1992 Cambridge English Proficiency Certificate.

1990 English Language GCSE.

Talking points

Black belt in Aikido.

Former member of the Hong Kong branch of the Mensa Association. Part-time Salsa DJ. Performed in various international events in cities such as Hong Kong, Shanghai, Beijing, Taipei, Singapore and San Francisco.

Member of Air Training Corps in London from 1990 to 1993. Activities included Glider Training, Leadership Course, First Aid training, and Duke of Edinburgh Bronze Award.



Contact this candidate