JAVA, SQL, Python, JSP

Qifei%Wang%

rd

***W%*** %Street%Apt%*F,%New%York,%NY%10027% % % % % % % % % % % % % % % % % % % % % % % % (646)%932;5938>******@********.***%

https://www.linkedin.com/in/qifeiwang%

%

Education%

Columbia%University,%Fu%Foundation%School%of%Engineering%and%Applied%Sciences% % % % % % % % % % %% % % % % % New%York,%NY%

MS%in%Electrical%Engineering% % % % % % GPA:%3.7% % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % Dec.%2014%

Relevant(Coursework:(Intro(to(Database,(Cloud(Computing(&(Big(Data,(Analysis(of(Algorithm,(Modern(Internet(Application(

Development,(Embedded(System,(Advanced(Logic(Design,(Formal(Verification,(System(on(Chip(

(

Tianjin%University,%Electrical%and%Automation%School% % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % Tianjin,%China%

BS%in%Electrical%Engineering% % % % % % Major%GPA:%3.8% % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % Jun.%2013%

Relevant(Coursework:(Database(System,(Assembling(Language(&(Computer(Architecture,(C(Programming,(Java(Programming( (

(

Working%Experience%

Ace%Group% % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % Stamford,%CT%

Assistance%Administrator%&%Developer%of%SQL%based%TAI%Reinsurance%Database%System% % % % % % % % % % % % % % % % % % % % % % Jun.%2014;Dec.2014%

Familiarized%with%the%base%framework%of%TAI%and%SQL%codes%used%in%reinsurance%calculation%procedure%

•

Conducted%monthly%reinsurance%processing.%Maintained%TAI%system%by%running%SQL%to%check%the%tables%and%corrected%

•

abnormal%premium%data,%decreasing%the%financial%lost%of%company.%

%

Academic%Project%Experience%in%Columbia%University%

Design'a'Web'App'combining'CRM'System'and'E8commerce'CMS'(Content'Management'System)' ' ' ' ' ' ' ' ' ' Aug.%2014;Jan.%2015%

Built%CMS%by%combining%Redis,%DynamoDB%and%S3%for%products/session%management%of%E;commerce%App.%

•

Set%up%CRM%system%from%the%bottom%up%and%structurally.%Used%composition%and%delegation%in%Java%OOD.%Separated%business%

•

logic%from%data%access%service.%Implemented%MVC%model%in%AngularJS.%Exposed%Agent/Customer%facades%to%different%roles.% '

Surfaced%the%business%logic%with%RESTful%call.%Utilized%ApacheWink%JAX;RS%to%define%the%uniform%RESTful%interface,%enabling%

•

ad;hoc%query,%pagination,%and%asynchronous%request.'

Realized%message%driven%processing%by%designing%queues%by%SQS%with%multi;thread%listeners%translating%messages%to%REST%calls.%

•

Implemented%RabbitMQ%in%CRM,%providing%customer;related%topic%subscription%and%notification%by%AWS%SNS%service%for%agent.%

•

%

Implemented'a'Stock'Searching'&'Analyzing'Android'App' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' % % % % % % % % % % % % % % % % % % % Apr.%2014;Jun.%2014%

Utilized%Yahoo%Finance%API%to%search%stock%information%and%store%them%into%AWS%DynamoDB.% %

•

Enabled%user%to%search%by%stock%code,%obtain%future%trend,%and%discuss%at%forum%of%this%stock.%

•

%

Designed'a'Twitter8Map'Application'in'Python'based'on'Google'App'Engine'Pas'Service% % % % % % % % % % % % % % % % % % % % % % % % % % % Apr.%2014%

Coded%a%background%program%gathering%twits%by%Twitter%API%and%parsing%and%storing%results%(with%location%and%keyword%info)%

•

into%GAE%DataStore%with%Memcache%accelerating%data%loading.%

Designed%UI%in%JavaScript%enabling%keyword%filtering%and%rendering%twits%in%a%heat%map%to%show%the%their%(twits)%distribution.%

•

%

Developed'an'Online'Video'Chat'Application'based'on'Amazon'AWS' % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % Mar.%2014;Apr.%2014%

Separated%the%App%into%some%unit%blocks%which%could%be%implemented%by%AWS%services%and%conducted%unit%tests.%

•

Familiarized%with%AWS%services%by%implementing%them%in%Java.%The%main%business%logic%is%a%pipeline%that%transcoding%the%

•

uploaded%videos%by%Elastic%Transcoder,%storing%them%in%S3%with%chat%logs%in%DynamoDB,%finally%sending%notification%by%SNS.%

Deployed%the%App%at%Elastic%Beanstalk,%which%monitored%and%distributed%the%App,%avoiding%set%up%costly%servers.%

•

%

Built'NBA8related'Database'on'Oracle'10g'and'developed'J2EE'web'application'based'on'it' ' ' ' ' ' ' ' ' ' ' ' ' ' Sep.%2013;Dec.%2013%

Mapped%real%NBA%relationship%to%ER%Diagram%which%is%then%converted%by%SQL%commands%to%tables%in%DBS.%

•

Developed%a%server%on%Tomcat%and%Eclipse%to%dynamically%generate%HTML%pages%by%JSP.%Linked%the%server%to%the%NBA%database%

•

on%Oracle%by%JDBC%in%order%to%support%queries%and%other%services%like%searching%players,%voting%and%logging.%

%

Skills%in%programming%language%and%Honors%

Java,%JSP,%SQL,%Python,%JavaScript,%AngularJS,%HTML,%Microsoft%Access,%Microsoft%Excel%

Honorable%mention%in%Mathematical%Contest%Modeling%(MCM),%North%America% % % % % % % % % % % % % % % % % % % % % % % % % % % % % Feb.%2012%

Contact this candidate