Andrejs Zuravels
Toronto, ON
Tel: 416-***-****
E-mail: *********@*******.***
Senior Java/Oracle Developer with over 14 years of extensive experience in software designing and constructing, GUI development, database management, providing user support. Proficient in all stages of the Software Development Life Cycle. Quick learner, able to grasp new ideas, methods and procedures with minimum effort. Work well as part of a team or independently, able to meet deadlines and work under pressure. Excellent communication and interpersonal skills and involved in client interactions for scoping, effort estimates and status reporting. Hardworking, self-starter and enthusiastic.
AREAS OF EXPERTISE
Java/J2EE Technologies: Servlets, JSP, Java Beans, JDBC, JNDIJ2EE Frameworks: Struts, Spring 3.x, Log4J, JSP, JUnit, iBatisWeb Technologies: XML, XSL, Java Script, HTML, Web servicesApplication Servers: OC4J, WebLogic 9.x, Tomcat 5.xProgramming Languages: Java, SQL, PL/SQL, VB5/6Database: Oracle 9i/10g/11g, MS Access IDE: Eclipse 3.x, JDeveloper, PL/SQL Developer, Embarcadero Rapid SQL, Oracle Developer 2000, Oracle Developer Suite – 10gds, Reports/Forms 6i/10gOperating Systems: Windows, Unix, LinuxSource Control: CVSOthers: Microsoft Visio, ANT, Maven, SQL*PLUS, JIRA, Infra, Data Quality Center
CAREER EXPERIENCE
Senior Programmer/Analyst 2001 – 2012
CIHI (Canadian Institute for Health Information) – Toronto, Canada
Technical Environment: Java, Eclipse, JDeveloper, JSP, Oracle Report Server, Oracle DB, Struts, Spring, HTML, XML, CVS, JIRA, Infra, DQC(Data Quality Center), Infra, WebLogic, ANT, Maven, JUnit, PL/SQL Developer, MS Windows, Unix
Developed applications to help hospitals to submit data for further analysis.Participated in project planning sessions with business analysts and team members to analyze business IT Requirements and translate business requirements into working model.Contributed significantly to the following projects: CJRR, NACRS, CMDB, NPDB, DAD, DQ.Created DDR statements to modify database structure for CMDB (Canadian MIS Database) re-engineering project to accommodate new project requirements.Developed and deployed reports for CJRR, NACRS (National Ambulatory Care Reporting System), CMDB, NPDB(National Physician Database), DAD(Discharge Abstract Database) projects using Oracle Reports.Designed and developed new functionality under the latest clients’ requirements including back-end and interface development and improvement.Developed PL/SQL packages responsible for analyzing and processing submitted data as well as for ETL.Was involved in initial designing and creating Use case diagrams, Sequence Diagrams and class diagrams using the MS Visio Tool.Developed web application using Struts Framework and user interfaces using JSP, JavaScript and HTML.Used Eclipse and JDeveloper as IDE tools to develop the application and, JIRA, Infra and Data Quality Center for bug and issue tracking.Used CVS for software configuration management and version control.Used data mapping framework (iBatis) to map Java Objects to the results of SQL Queries.Designed and developed web survey forms using Oracle Forms.Used JavaScript and struts validation framework for performing front end validations for CJRR (Canadian Joint Replacement Registry)Took a proactive role in solving technical problems/issues.Trained and mentored junior programmers in programming methodologies and best practices.Progressed through promotions, culminating in responsibility for Web-based application programming within high-volume setting. Became adept in analyzing code for system testing and debugging.
Software Developer 1999 – 2001
I.K.A – Richmond Hill, Canada
Technical Environment: Oracle Developer 2000 (Forms 5.0, Reports 3.0), Visual Basic 6.0, SQL*PLUS, PL/SQL Developer, MS Windows NT/ 98, MS Access 97/2000, Seagate Crystal Reports 7.0.
Developed projects for Human Resources.Responsibilities included Database design and business logic clarifications with users, coding in PL/SQL, Oracle Developer 2000, Visual Basic 6.0, and MS Access 97/2000.Wrote DDL scripts for creation table spaces, tables, views, constraints and sequences.Developed Oracle Reports and Seagate Crystal Reports.Designed forms, coded triggers, functions and stored procedures.Front-end development using Oracle Developer 2000(Forms 5.0, Reports 3.0), VB6.0.Coordinated between business analysts and developers.
Programmer/Analyst 1998 - 1999
TRICOMM - Bradford, Canada
Technical Environment: Oracle Developer 2000, SQL*PLUS, PL/SQL, MS Windows 95, UNIX (Sun OS 5.6)
Real Estate Administration System development, under Client/Server environment.Responsibilities included data modeling, database design, coding in Developer 2000, creating PL/SQL blocks, triggers, and stored procedures for Oracle7.X, testing and debugging.Graphical User Interface, as a front end, was developed using Developer 2000 (Forms 5.0, Reports 3.0); RDBMS was Oracle7.X on UNIX operating system.
PROFESSIONAL DEVELOPMENT
Oracle course RTU Institute (Riga, Latvia) - 1997Course for Building web sites (HTML, URL) – 1998Java Programming - Oracle University (Toronto, Canada) - 2003Developing Applications for the J2EE Platform - DesTech Consulting & Education (Canada, Mississauga) 2004Developing ASP/NET Web Applications - Learning Tree International (Canada, Toronto) 2007Spring Framework Web Applications - Learning Tree International (Canada, Toronto) 2010
EDUCATION
Technical Engineering diploma from LJA/RTU(Institute of Technology), Riga, Latvian Republic (1994 - 1998)