About
This is about us, Alice & Alex, travelling around the world. Since we met each other 7 years before, we were meant to be the other part of each other. When we told our friends that we got married, a lot friends feel happy for us and it was not easy to get to this. You are my only precious honey. I will do all my best to turn our life to a better tomorrow everyday.
About me, you could call me Alex. I studied Software Engineering for in my university, Beihang University. Then I become one of Richfit Company right after graduation. It was very luck for me to have a chance to study in NTNU, Norway for a Master Degree of Project Management. It’s one part of the program that I can study abroad again for one semester, so I chose Skema Business School, Paris, France.
Here is a list of my professional skills.
ABAP is an internal programming language with SAP R/3 System. I’m a certificated Development Consultant by SAP A.G.
SAP R/3: My job was to lead SAP ERP development team. So I worked on this system for 3 years full time. I used developed more than 500 different ABAP programs and I was always the one who cope with the most difficult requirements and issues. I have experiences in two big projects. In the largest one, I have 18 developers in my team, providing developing and technical support to more than 300 functional consultants.
C# programming since .NET Framework 1.0, now working on 3.5. Most of my projects are done with Visual C#.
PHP is my recent and most used web programming language, I’m familiar with it but not using too much for projects.
SQL, PL/SQL: While working with database, you can never miss this. So can’t I.
Drupal: Since Version 4.7, now working on 6.15. It is my most used website engine. I’m able to do installation, configuration, theming, trouble shooting and developing modules. I’m familiar with most of popular modules.
Wordpress: Same as Drupal, I’m able to do installation, configuration, theming, trouble shooting and developing plug-ins.
MySQL Database: My most frequently used database system. Most of my websites runs on MySQL Database.
Performance Tuning: Being able to do this on both programming algorithm and database level, especially in SAP R/3 system.
Web Crawling: My dream was to beat google but obviously I’m not the person. But I’m still good at this. Some of my projects are about collecting information on the websites.
SEO: I know most of the SEO theories and how to carry out. Including keywords, link building, Page Rank, Alexa ranking, back links, comment marking, etc.
Windows: I’m not an expert on Linux or Mac. I’m a “Microsoft School” tech-person so far. I develop softwares for Windows OS.
Office: I’m able to develop plug-in for Office 2007 and Automation for Office 2003 & 2007, including Access, Excel, Word and Outlook.
SNS: I’m familiar with some popular social media networks such as facebook, twitter, etc.
Besides my major skills above, some others that I’m able to work with are also listed below:
Database System: Microsoft Access 2003 & 2007, Microsoft SqlServer 2000, Oralce 10g
Web Programming: Html, Javascript, Some Ajax framework, ASP.NET(C#), ASP, Rss developing, Web Service developing
Other Programming: VBA in Office, Java, JavaEE
Here is a list of my recent projects.
Data Analysis(large amount data)
2009-09 Visual C# on .NET Framework 3.5, Microsoft Access 2007
This was my first job on Elance.com. I was supposed to find some relations on a two dimension dataset. The initial dataset contains about 200 thousands elements. The initial results contains about 20 millions line of data. Finally the results is about 1 million line. It took a couple of minutes to run.
Data Analysis 2(even larger amount data)
2009-09 Visual C# on .NET Framework 3.5, Microsoft Access 2007
Similar to the first one. But the amount of dataset is about 100 times larger than the first one. The result database file(Access 2007) is about 200 MB large. It took more than one hour to run.
Convert PDF file content to database
2009-10 Visual C# on .NET Framework 3.5, Microsoft Access 2007, PDFBox 0.7.3, IKVM, FontBox 0.1.0
This project was to extract contents from several different PDF reports and design a database to store them. extracted data need to be put into corresponding database tables. The most difficult part was to identify different data elements.