Microsoft SQL Server, Microsoft Windows Server, MS Visual Studio
Years professional experience in IT industry
Yen Lam
Toronto,Ontario
Summary
Hardworking and passionate professional with experience in the field of Information Technology. Proven track record of successfully delivering projects for clients. Skilled in developing innovative strategies and solutions to a wide range of business challenges. Extensive knowledge of the software industry with a focus on client satisfaction, stakeholder relationships and driving process improvements.
Overview
19
19
10
10
Years SQL Server experience
8
8
Years enterprise SaaS Technology
6
6
Years Software Consultant
Skills
- Software Consulting
- Software Implementations
- Problem-Solving & Issue Resolution
- Organization and Time Management
- Configuration Management
- Customer Engagement & Relationships
- Client Requirements Assessment
- Project Documentation
- User Software Support & Training
Software
ASP Net, CSS, HTML, XSL, XML, Java
MS Office Suite, Google Office Suite, MS Project, MS Visio
Atlassian - JIRA/Confluence, FreshDesk, TestRail, Salesforce
Slack, MS Teams, Zoom, Cisco WebEx, GoToMeeting, Skype, TeamViewer
Trello, Drawio, Miro, SnagIT, Balsamiq, WinMerge
Work History
Senior Consultant
Oracle Corporation - NetSuite - Enterprise Resource Planning (ERP) Software
05.2022 - 09.2022
- Achieved 80% billable utilization with 15 projects for Standard and Premium clients, 1st month post training program.
- Ranked #1 group upon completion of Oracle NetSuite internal training program.
Implementation Consultant
CMiC - Construction Management Software
02.2020 - 05.2022
- Provided training and consulting services for CMiC Construction Management Software for Opportunity Management, Business Intelligence and Field - Project Management & Collaboration for all platforms PaaS, SaaS and Cloud facilitating on AWS Cloud Infrastructure.
- Achieved 80% - 100 % billable utilization bi-annually to 10 Enterprise and over 50 Cloud clients (on-site & remote) providing various stages of the Implementation Project Life Cycle from Business Process Mapping, Configuration, Training, Conference Room Pilot, Readiness Assessment, Mock Go-Live and Go-Live Readiness to Post Go-Live Support.
- Trained all users from super users to end users and on-site and remote clients in the construction industry including architects, general contractors, owners, subcontractors and operations (on job site) users on both cloud software and mobile applications.
Support Analyst/Deployment Specialist
White Clarke Group Ltd. - Automotive & Asset Finance System
12.2014 - 11.2018
- Responsible for providing application support to clients on CALMS (Customer Acquisition and Lifecycle Management System) suite consisting of Point-of-Sale, Loan Origination and Loan Servicing.
- Administered and maintained client CALMS system hosted on third party datacenter on VM and hardware servers.
- Utilized MS Project to plan/maintain new Support team initiatives and new client CALMS systems for go-live.
- Collected data and maintained controls for SSAE16 (SOC) monthly quarterly and annual audits.
- Installed and configured AppDynamics software monitoring tool to client CALMS system.
- Installed and configured CALMS system on client environments from UAT, Pre-Production, QAT-Live, Support, Training, Staging, Production and DR; non-client environments from Demo, Performance, INT and QAT.
- Setup of CALMS system includes VM setup, install/setup SQL Server, install/setup of application servers and install/setup of web servers.
- Installed release deployments as per system development life cycle and SSAE16 control by initiating client Production Change Form process.
- Participated as Deployment Specialist installing ongoing CALMS system releases on all client and non-client environments.
Implementation Consultant
Ceridian HCM Inc. - Human Capital Management - International Payroll Services
08.2013 - 07.2014
- Participated as part of the International Payroll Services (IPS) division as an Implementation Consultant for Dayforce Human Capital Management (HCM) SaaS (Software as a Service) software.
- Configured Dayforce HCM software and SQL Server 2012 database to utilize as a central repository for payroll for international clients and In-Country Providers (ICP) based on their requirements and business processes.
- Collaborated with IPS team working together in an Agile environment, remotely as a team.
- Generated client/ICP specific data for importing, exporting and forms for employee/payroll data utilizing XML and XSLT.
- Created SQL queries utilizing reporting features within Dayforce HCM software.
- Identified best practice processes for payroll setup for clients with international employees and payroll service companies globally.
- Frequent communication with various departments including Professional Services, Development and IT.
Project Consultant
Intelex Technologies Inc.- Environmental, Health, Safety and Quality System
02.2012 - 07.2013
- Analyzed client requirements and provided expertise in implementing Intelex's EHSQ (Environmental, Health, Safety and Quality) software.
- Participated as part of the Professional Services division as a Subject Matter Expert (SME) for Intelex's SaaS (Software as a Service) product.
- Configured Intelex's EHSQ system and utilizing SQL Server 2008 and Java to satisfy client requirements and business processes.
- Daily communication and interaction with clients to gather business requirements to document on Gap Analysis and Business Requirement Document documentations.
- Managed and coordinated multiple levels of projects; their timelines and allocating resources with client project managers from SDLC (System Development Life Cycle) stages after sales hand-over: on-site gathering requirements, configuration, UAT (user acceptance testing) and go-live.
Database Administrator/Software Administrator
Ed Mirvish Enterprises Ltd./TicketKing - AudienceView Ticketing System
02.2005 - 02.2012
- Implemented numerous major upgrades for TicketKing's ticketing software system (AudienceView Corporation) including upgrading external applications, platforms and systems to go-live.
- Administered and maintained TicketKing's ticketing software system (AudienceView Corporation) including providing daily application support, applying all fixes, upgrades and change requests.
- Daily SQL Server database maintenance to ensure the efficiency of all software and reporting applications including deploying scheduled jobs, replication and disaster recovery strategies.
- Database maintenance from SQL Server 2000 - 2008 R2 versions for standard, development and enterprise levels.
- Contributed and managed projects with Infusion Development Inc. in implementing a Business Intelligence reporting system utilizing SQL Server 2005 and 2008 Enterprise suites to create multiple data warehouses, cubes and application utilizing WSS 3.0/Windows Sharepoint Foundation.
- Implemented and configured all staging and production environments for all software and reporting systems including ASP .Net software application, SQL Server databases, Sharepoint and Crystal Reports.
- Collaborated with ThinData Inc in implementing an email marketing system by integrating data utilizing SQL Server and sFTP applications.
- Collaborated with AberGroup Ltd and AudienceView in implementing Adwords (Spotlight tagging) with Google Analytics.
Systems Administrator
Incubed Limited - Life & Casualty Insurance Software
06.2003 - 09.2005
- Developed a software compliancy proposal including estimated cost to achieve and maintain 100% compliancy.
- Established policies, recommendations, and guidelines to avoid any future software licensing shortfalls.
- Prepared pre-release notes & release notes for company's flagship product on a monthly basis for clients' review.
- Contributed to the optimal functioning of the computer system by troubleshooting/resolving problems within the PC-based network on a daily basis.
- Established and documented policies and procedures for Incubed's Employee Departure/Hiring processes
- Setup and prepared Windows staging environments for IN3 software testing purposes.
- Created daily network backups using Veritas Software.
Education
Bachelor of Commerce - Information Technology Management, Systems Development -
Toronto Metropolitan University (Ryerson Polytechnic University)
Toronto, ON06.2007
Business Computer Systems - Information Technology
Seneca College of Applied Arts And Technology
Toronto06.2002
Certification
- Certified iMIS Administrator (2023)
- Salesforce Certified Administrator (2020)
Timeline
Senior Consultant
Oracle Corporation - NetSuite - Enterprise Resource Planning (ERP) Software
05.2022 - 09.2022
Implementation Consultant
CMiC - Construction Management Software
02.2020 - 05.2022
Support Analyst/Deployment Specialist
White Clarke Group Ltd. - Automotive & Asset Finance System
12.2014 - 11.2018
Implementation Consultant
Ceridian HCM Inc. - Human Capital Management - International Payroll Services
08.2013 - 07.2014
Project Consultant
Intelex Technologies Inc.- Environmental, Health, Safety and Quality System
02.2012 - 07.2013
Database Administrator/Software Administrator
Ed Mirvish Enterprises Ltd./TicketKing - AudienceView Ticketing System
02.2005 - 02.2012
Systems Administrator
Incubed Limited - Life & Casualty Insurance Software
06.2003 - 09.2005
Bachelor of Commerce - Information Technology Management, Systems Development -
Toronto Metropolitan University (Ryerson Polytechnic University)
Business Computer Systems - Information Technology
Seneca College of Applied Arts And Technology
- Certified iMIS Administrator (2023)
- Salesforce Certified Administrator (2020)
Similar Profiles
Ameliayh OramAmeliayh Oram
Warehouse/Shipping and Receiving Associate at -Warehouse/Shipping and Receiving Associate at -
Adrine OhanyanAdrine Ohanyan
Pre-School Teacher at -Pre-School Teacher at -
Mahra AlkaabiMahra Alkaabi
File writer at -File writer at -