Sql Server Project
Resume:
LIANNE (HAO DONG) JIN
Markham, Ontario
L3R 3Y3
********@*****.***
SUMMARY:
10+ years Programmer/Analyst experience with AS400 RPG,COBOL and CL programming,
experience with Client Access, expertise in ORACLE, SQL, C, BPCS, knowledge of network
concepts .
PROFESSIONAL SKILL: 10+ Years AS400 SYSTEM, strong in RPG/400,COBOL/400, CL/400, SQL/400, DB2/400 Working experience in Microsoft SQL Server Familiar with WEBQUERY, PORTALResponsible to design, develop, test and analyze new and maintain existing
applicationsSupport daily production operationDebug and trouble-shooting the production problemExcellent communication with Business Analyst to understand user’s requestCreate daily, monthly, quarterly and yearly reports Good interpersonal skills, ability to prioritize and strong organizational skillsAbility to handle multiple tasks and set working priorities effectivelyAbility to adjust in fast paced working environment
WORK EXPERIENCE:
1998 – Present Northbridge Insurance
Northbridge is a leading Canadian Commercial insurer with a long standing history
in the market place, with regional operation across the country.
Intermediate Programmer Analyst
PROJECTS:
2011 – 2012 Claim Inquiry ProjectDesign new batch programs to collect data to Microsoft SQL Server daily
2010 – 2011 Portal ProjectPortal project to make program to get the data from AS400, use portal to send
to web interface for high level management
2010 – 2010 Commercial Line Survey Letter ProjectDesign new batch programs to collect data to print Survey Letters to the insurer
2009 – 2010 HCAI ProjectRequest by Insurance Bureau of CanadaDesign for Accident Benefit Department Any change of information of AB Claimant need to report to IBCGenerate all data in XML File and submit to IBC
2008 – 2009 Performance Evaluation projectDesign new on-line multiple screen for all management level userEnter work performance for their staffCreate new query reports and schedule to run daily
2007 – 2008 HST ProjectModified current on-line programs, tables and reports to use the new HST
2004 – 2006 Expense Reserve Project Design new on-line screen for expense payments include edit checkingSupport Claims department all across Canada
2002 – 2004 Bulk Payment ProjectCreate all bulk payments in one check twice a month The benefit of this project to save company’s expense on Check printing dailyFeature to inquiry the Bulk payment on –line and the ability to reissue the Bulk
2001 – 2002 BI worksheet ProjectCalculate the reserve amount automaticallyDesign multiple new on-line screen for the litigation departmentFunction to print BI worksheet and create new version per request
2000 – 2001 Examiner Master File maintenance ProjectDesign new on-line screen to enter data in Examiner Master FileFunction to create, update, delete and copy
1998 – 2000 Year 2000 ProjectChange all the on-line screens and reports to include YYYY-MM-DD format
1997 – 1998 Radius information Inc.
Radius Information Inc. Provide the consultation to major Financial Company to
design, develop and maintain new and existing software application
Programmer/AnalystConsult to the Financial Institution to develop and maintain their systemsImplement projects from system test to production
1995– 1997 3M
3M is a diversified technology company serving customers and communities with
Innovative products services. Each of six business has earned leading global
Market position
Programmer/AnalystInvolve in BPCS system Support the logistic and on-line order systemProduction support
MEMBERSHIPS:
TUG Toronto Users Group For Power Systems
EDUCATION:
2012 SQL Course in IBM
2010 Insurance Course
2010 WEBQUERY Course in IBM
1987 – 1991 Shanghai University
Bachelor Degree of Computer Science
References are available upon request
Contact this candidate