Liliana A
SQL Developer
Burnaby,BC
Summary
SQL Developer with more than 15 years of experience in database development and application programming. Microsoft Certified in SQL queries, deeply knowledgeable in all aspects of acquiring, storing, transmitting and processing data sets. Proficient at data architecture design and at emerging data warehouse concepts. Skilled programmer and complex problem-solver experienced in data analytics and report writing. Proven ability to efficiently balance competing demands, resolve difficult challenges, and quickly master new technologies and environments
Overview
16
16
years of professional experience
5
5
years of post-secondary education
3
3
Certificates
Work History
Application Developer
Canadian Western Bank Group
Vancouver, BC
09.2011 - Current
- Analyzed, designed, developed, implemented, documented, maintained and supported software applications in MSSQL, Oracle and Web environments
- Developed and maintained Windows scripts to interface between different applications as per business requirements
- Developed applications, reports, scripts, batch process using SQL, PL/SQL, C# , VB, Oracle, MSSQL Server, SharePoint
- Developed custom database objects, stored procedures and reports
- Designed and developed customized extract, transform and load (ETL) applications per client specifications
- Developed, implemented and maintained complex T-SQL queries, views and stored procedures in multi-database environment
- Documented logical models ( diagrams, flowcharts) that allows stake-holders to identify errors and make changes in designing phase of software lifecycle
- Participated in third party change management process through analyses, development or deployment tasks
- Technologies and platforms used: MSSQL Server 2005/2008, SSIS, SSRS, SSAS, SQL, Oracle, Visual Studio Net, SharePoint, Office, Windows, Linux
System Analyst and Developer
RDH Building Engineering
Vancouver, BC
05.2007 - 07.2011
- Planned and implemented migration of existing Access database into MS SQL database architecture to automate report generation and correspondence for all offices and create new business opportunities
- Involved in all phases of software development life cycle of Contacts Management System, Project Management System and Marketing Search Reports System
- Interconnected 3-tier by using ASP.NET and web services and built application layer by using .NET C# web modules
- Researched and prototyped new technologies and techniques to increase efficiency and provide high quality results
- Worked in partnership with business analysts to build business requirements and software specifications for each project stage
- Designed data models, developed and implemented stable relational databases and complex stored procedures, queries, triggers, views for maintaining business rules
- Applied sharp critical thinking abilities toward analyzing and fine-tuning database performance for real-time data insertion, data retrieval and reporting
- Researched and prototyped new techniques to increase efficiency and provide high quality results
- Technologies and platforms used: SQL Server, MySQL, Access, T-SQL, SQL, C#, VB, PHP, ASP, JavaScript, HTML, XML, Ajax, CSS, Visual Studio 2005/2008/2010, Share Point 2007/2010, Office, IIS6, IIS7, Windows, Linux
Application Developer
BCTC
Vancouver, BC
01.2006 - 04.2007
- Identified impediments and conflicts of non-functioning system modules, to overcome inconsistencies in implementation of business requirements
- Improved functionality of existing Access application and developed new routines
- Successfully commissioned new version on time
- Wrote technical documentation, product specifications and technical training materials
- Technologies and platforms used: ER, UML, SQL, VB, MS Access, Windows
Education
Database Administration And Design Certificate - Database Application Developer
BCIT
Burnaby, BC 09.2007 - 06.2009
Master of Science - Applied Informatics
Faculty of Computer Science
Galati, Romania 09.2002 - 06.2004
Bachelor of Science - Computer Science
Faculty of Computer Science
Galati, Romania 09.2000 - 06.2002
Skills
Data extracting
undefinedTimeline
Microsoft Certificate - Exam 461 SQL Queries
10-2015
Application Developer
Canadian Western Bank Group
09.2011 - Current
SharePoint Development Certificate
06-2010
Database Administration And Design Certificate - Database Application Developer
BCIT
09.2007 - 06.2009
System Analyst and Developer
RDH Building Engineering
05.2007 - 07.2011
Application Developer
BCTC
01.2006 - 04.2007
Developing Microsoft.Net Applications Certificate
05-2005
Master of Science - Applied Informatics
Faculty of Computer Science
09.2002 - 06.2004
Bachelor of Science - Computer Science
Faculty of Computer Science
09.2000 - 06.2002
Certification
Microsoft Certificate - Exam 461 SQL Queries
Similar Profiles
KAREN ALBINKAREN ALBIN
Sales and Service Representative at Canadian Western Bank / National BankSales and Service Representative at Canadian Western Bank / National Bank
MANPREET KAUR GILLMANPREET KAUR GILL
CLIENT SUPPORT AGENT at CANADIAN WESTERN BANK(NATIONAL BANK NOW)CLIENT SUPPORT AGENT at CANADIAN WESTERN BANK(NATIONAL BANK NOW)
Grainne MulhollandGrainne Mulholland
Manager, Motive Sales and Client Relations at Canadian Western BankManager, Motive Sales and Client Relations at Canadian Western Bank
Tyler ChangTyler Chang
Medical Equipment Assembler at VerathonMedical Equipment Assembler at Verathon
Leo PolanskiLeo Polanski
Sales Associate at Moores Clothing for MenSales Associate at Moores Clothing for Men