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
2011.09 - 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
2007.05 - 2011.07
- 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
2006.01 - 2007.04
- 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 2007.09 - 2009.06
Master of Science - Applied Informatics
Faculty of Computer Science
Galati, Romania 2002.09 - 2004.06
Bachelor of Science - Computer Science
Faculty of Computer Science
Galati, Romania 2000.09 - 2002.06
Skills
Data extracting
SQL analytics and development
T-SQL, PL/SQL, JavaScript, HTML, XML, CSS, Excel, Power Pivot, Access , VB, C#
SSRS, SSIS, SSAS
Agile Methodology
Data visualizations
Requirements gathering
Timeline
Microsoft Certificate - Exam 461 SQL Queries
2015-10
Application Developer
Canadian Western Bank Group
2011.09 - Current
SharePoint Development Certificate
2010-06
Database Administration And Design Certificate - Database Application Developer
BCIT
2007.09 - 2009.06
System Analyst and Developer
RDH Building Engineering
2007.05 - 2011.07
Application Developer
BCTC
2006.01 - 2007.04
Developing Microsoft.Net Applications Certificate
2005-05
Master of Science - Applied Informatics
Faculty of Computer Science
2002.09 - 2004.06
Bachelor of Science - Computer Science
Faculty of Computer Science
2000.09 - 2002.06
Certification
Microsoft Certificate - Exam 461 SQL Queries