Project Manager Data

Alvin Jing ******.********@*****.***

Alvin Jing

** ***** **** ** +1-902-***-****

Wolfville, NS ******.********@*****.***

Profile

Master of computer science graduate with 3 years of working experience in investment

banking and technology industries. Highly self motivated individual and fast learner with excellent

past academic and work performance

2 years experience in business intelligence technologies such as reporting, OLAP, data mining

and predictive analytics

2 years experience in database management, proficient in Oracle, PL/SQL (Bulk collect,

execution plan, index, SQL tuning)

5+ years experience in Java/C programming, solid in Core Java

Experience and solid understanding in Kimball data warehousing, such as dimensional modelling,

change data capture, ETL sub systems

In-depth understanding and practices in machine learning algorithms and applications

Experience in implementing business intelligence and analytics solutions using SAS Enterprise

Guide, Microsoft Excel, Jasper iReport and Actuate

Strong in data structure and algorithms

Skills Summary

Talent Highlights: http://mvp.plum.io/profile/AlvinJing

Business Intelligence: Reporting, OLAP cube, statistical analysis and modelling (correlation, sampling,

distributions, Bayesian inference etc.), VBA, pivot table, business understanding

Database/Data warehousing: SQL, stored procedure, triggers, aggregation functions, collections,

cursor, exceptions, SQL tuning, star schema, ETL, slowly changing dimension (type 1,2,4), change data

capture methodologies, dimensionally modelling (role playing, drill across, denormalization etc.), Hadoop

Java: Core Java, Servlet, JSP, Struts 2, Hibernate, jQuery, Ajax, EJB, Javascript, design patterns (Singleton,

Factory, Delegate), HTML, CSS

Data science: data preprocessing, Naive Bayes Multinomial, decision tree, expectation maximization,

information theory, topic models, text mining, linear regression, logistic regression

Tools: Oracle SQL Developer, Microsoft Excel, SAS Enterprise Guide, SSIS, Jasper iReport, Actuate, R

Studio, NeuroShell, Weka, Matlab, IBM Cognos Insight, MySQL, Eclipse, Rational Application Developer

UNIX (Sun Solaris), Linux, Lotus Notes, JIRA, HP quality centre, Clearcase, Latex

Certificates: Certified Associate in Project Management, Oracle Certified Professional Java SE 6

Languages: English (fluent), Mandarin (fluent), German (intermedia)

Academics

Master of Science - Computer Science (Co-op Option) 2012/09 - 2015/05

Acadia University, Wolfville, Nova Scotia

Recipient of Acadia Graduate Award for both academic years

Valid open work permit to Jan 2018

Bachelor of Engineering - Software Engineering 2006/09 - 2010/06

Hebei University of Technology, Tianjin, China

Three-time repeat recipient of academic excellence scholarship

Project: Finding economic effect of an event using topic modelling and event reference

Achievements:

Developed a complex system using Eclipse (Java) in order to find the economic effect of an event within a

time period. Large archives (3000+) of news articles (text corpus) are analyzed. Research covers a variety of

topics such as topic models, web content mining, Bayesian statistics, information theory, human annotation etc.

Project: Sentiment analysis using Naive Bayes Multinomial and EM algorithms

This projects intends to classify the sentiment towards cameras using data from twitter.

Achievements:

Researched and combined Naive Bayes Multinomial and EM algorithm that developed a model with

prediction accuracy of 89.6% for unlabelled dataset.

The only student that is able to take advantage of the unlabelled data (semi-supervised learning).

- Page 1 of 3 -

!

Alvin Jing ******.********@*****.***

Professional Work Experience

Statistics Methods Analyst 2013/09 - 2013/12

Blackberry Ltd. - Waterloo, Ontario

Blackberry is the Canadian tech giant that specializes in the telecommunication and wireless equipment

industry. Its best known products are Blackberry smartphones and tablets. Its smartphone market share in

the US reached 43% in 2010.

Project: Business intelligence report automation project

The department would like to automate one of the business intelligence reporting process in order to

improve productivity and reduce the amount of work allocated to team members.

Contributions:

Analyzed the node structure in the program flow, estimated resources and time (4 months) in order to

determine the feasibility of the project within constraints

Restructured the program flow and implemented designed solution by programming in SAS, provided

data visualization using Proc tabulate, Proc SgPanel, SgPlot, SgScatter etc.

Provided “one-click” solution to reformat and structure layout in Microsoft powerpoint

More than 80% of the overall manual work is automated. Human resources allocated to generating

weekly report reduced from 3 to 1.

Received outstanding evaluation for the work term. Finished the project one month ahead of

schedule. By adopting the new process, average time of generating individual report reduced over 80%.

Manager commented very favourably on problem solving skills, communication skills and leadership

abilities.

Provided training to fellow co-workers regarding programming paradigm and written communication.

Programmer Analyst 2013/05 - 2013/08

Scotiabank Ltd. - Toronto, Ontario

Scotiabank is the third largest bank in Canada. It serves more than 21 million customers in over 55 countries

around the world and offers a broad range of products and services including personal and commercial

banking, wealth management, corporate and investment banking.

Project: Fee Calculator

Fee calculator is an application that advisors use to calculate fees for Scotiabank clients. It uses some related

toolboxes, developers deploy standalone applications or software components that integrate with Java based

applications. Deploying standalone executable and Web components helps reduce the risk of user error and

provide validation.

Contributions:

Primary developer and program analyst in Fee Calculator application support.

Analyzed data models

By investigating business rules, fixed logistics in Oracle stored procedures as well as in front end code

(Java), in order to correct the client fees or provide explanation of the cause of client fee change.

Composed solution promotion documents, coordinated promotion process from development to IST,

UAT and production by communicating with project manager, production support, change control and

senior managers.

Worked closely with project manager, business analysts and developers during all phases of solution

delivering process, including requirement analysis, solution design, implementation and delivery.

Project: Vacation Calendar

Project manager and senior manager needs an application to track absence records for team members.

Contributions

Developed the application using Microsoft Excel (VBA) and formulas. Uploaded to share point as team

asset.

Finished the Vacation Calendar project one and a half months ahead of schedule. Facilitated

management work of tracking and updating absence records of team members. Managers is able to

view visualized weekly, monthly and overall report of absence; View absence by type such as sick,

vacation, time in-lieu; Manage employee (add, delete) etc.

- Page 2 of 3 -

!

Alvin Jing ******.********@*****.***

Software Engineer 2012/03 - 2012/08

State Street Bank - Hangzhou, China

State Street Corporation, known as State Street, is a US-based international financial services holding

company. It was founded in 1792 and is the second oldest financial institution in the United States. Its

headquarter is in Boston and has offices in 25 countries around the world.

Project: 401K maintenance project

Contributions:

Proposed project plan using Microsoft Project. Estimated resources needed, time needed and conducted

cost analysis.

Composed configuration solution document about user access control in Unix

Designed test cases as well as wrote test documents in team.

Project: Business intelligence report migration project

The company has to pay license fee every year to Actuate in order to use its system to generate report. A

one time solution would be to move the entire application to another platform that is free to use. Therefore,

the company decides to move its entire reporting system from Actuate to Jasper. The number of reports to

be converted is over 1000.

Contributions:

Retrieved necessary data for reports using complex SQL queries, aggregation functions.

Analyzed code structure regarding business logic in Actuate and provided corresponding conversion to

Jasper.

Migrated business intelligent report from Actuate report system to Jasper iReport system using iReport,

Actuate, Oracle SQL Developer and javascript.

Testing Support Analyst to Associate Consultant 2010/10 - 2011/08

Capgemini FSGBU Ltd. - Hangzhou, China

Cap Gemini is a French multinational corporation headquartered in Paris, France. It provides IT services and

is one of the world's largest consulting, outsourcing and professional services companies with more than

130,000 employees in over 40 countries.

Project: Application support for Deutsche Bank

Provided technical support to testing of Deutsche Bank's trade life cycle in day and night shifts using Unix,

eSpear banking system and JIRA.

Traced trade records following trade flow diagram in Unix and eSpear

Analyzed missing or incorrect calculations on eSpear.

Find the root cause (data format, processes) for incorrect information on the front end

Monitor batch, Health check

Provided training to testing support analyst

Update knowledge base with validated technical solutions

Teaching Assistant 2012 - 2014

Acadia University, NS, Canada

Mark assignments for students

Assist students for their courses (office hours and personal tutoring)

Substitute to teaching as required

Volunteer Experience

Instructor 2012/09 - 2013/01

SMILE Program, Acadia University - Wolfville, Nova Scotia

Participated in the program, aid children in developing motor skills in the pool

Reference:

Will provide upon request

- Page 3 of 3 -

!

Contact this candidate