HIGHLIGHTS OF QUALIFICATION

• Approx. ** years of Progressive experience in Microsoft SQL Server and .NET Framework technologies

• Experienced in Both Functional Design and Test Planning in the Software Development Life Cycle

• Effective in dynamic and challenging environment

• Excellent verbal and written communication skills; work well with co-workers

• Extremely dependable in completing assignments accurately and before deadlines

• Quick and self-learner to learn new technologies

• Knowledge of Test Driven Development

TECHNICAL SKILLS

• Programming Languages: ASP.NET, C#.NET, VB .NET, VB 6.0, JSON, HTML5, XML, CSS, JavaScript, T-SQL,NetBeans For Java

• Operating Systems: Windows 2000/Xp/Vista/Windows 7

• Software Tools: Crystal Reports, Remedy, Clearcase, Team Foundation Server, Visual SourceSafe, Alloy Navigator, Visual Source Safe, Winmerge Code Comparison and Code Merging Tool, Subversion Versioning Tool, UltraEdit Text Editor, KENDO Telerik Web Controls For ASP.NET

• Technical Documentation: UML(Use Case), Functional Design, Test Planning

• Database: MS SQL 2014, 2012, 2008/2005/2000, MS ACCESS 2010, SQL Server Reporting Services, SQL Server Integration Services, Oracle Sql Developer, Microsoft Oracle Data Modeler

• Content Tools: Sharepoint 2007, Sharepoint 2010

• Reporting Tool: Information Builders WebFOCUS 8.003

• UIPath Process Automation Tool

PROFESSIONAL EXPERIENCES

Analyst – IT, Business Applications, Surface Apps. June 2021 – May 2023

CNOOC International Limited (Formerly NEXEN)

• Support and maintenance of various Surface Applications including but not limited to MI3, HCA and PHD Historian and other custom developed systems ensuring high availability and data quality is upheld.

• Maintain outstanding customer satisfaction metrics with the business stakeholders.

• Apply critical thinking skills to resolve user requests, incidents and issues.

• Responsive to the needs of both projects and operations, as both are focused on different

deliverables in their life cycle.

• Follow development methodologies, change management policies and processes, and ensure these

are adhered to according to the Company's IT Methodology.

• Communicate effectively with the business stakeholders to identify requirements and evaluate

alternative business solutions.

• Identify risks to business processes and data related to the systems and environments he/she

supports.

• Develop mitigation strategies to handle these; work with team and business to implement these strategies.

• Effectively communicate relevant information to stakeholders and IT management and provide alternatives for problem resolution.

• Provide input to application support strategies as part of the wider team; participate in ensuring the strategies are communicated effectively to the business and other stakeholders.

• Coordinate and execute planning for new releases, service packs and hot fixes as well as custom development and configuration.

• Keep up to date on new developments and tools that will foster improvements, both from a

performance and feature basis.

• Work with Infrastructure teams to ensure stable and effective technical solutions and related interfaces.

• Establish and support relationships with vendors, manage correlating tickets and service requests.

• Point Person and Coordinator for different stakeholders which are involved for The On-going Field Data Capture (FDC) replacement project.

• In charge of any change management that needs to be coordinated to the Global Change Management Team

• Assisted for Administering user’s in some Sharepoint Sites in the Company

Database Administrator and Application Developer September 2020 – March 2021

Richmond School District SD38 (Richmond British Columbia)

• Responsible for maintaining and Troubleshooting of Daily Scheduled jobs using SSIS that the school district uses for operational purposes

• Worked with school district employees, teachers and administrators on providing Ad-hoc data as requested

• Provide Security Override using Atrieve ERP application for Finance and HR Purposes

• Maintained Multiple databases and perform necessary backup and maintenance if needed

• Provided SSRS and Ad-Hoc reports being used by school administrators and teachers

• Modified and maintained the District Program Options Draw application (DPO)

Consultant October 2016 – September 2020

CGI (Canadian Western Bank Place, 10303 Jasper Ave, Edmonton)

• Municipal Affairs of Alberta – 3/18 to September 2020

o Planning and implantation in Migrating of The content of S Drive to Ensemble Site (using sharepoint)

o Took over Duty Analyst Role for the Municipal Affairs which include the following tasks:

• Triage tickets that Come in the JIRA tool and assign the ticket accordingly to Team members that are currently working to support the application affected

• Make sure that Monthly Patch and maintenance tickets that will affect the Municipal Affair’s portfolio of applications are known to our group so that relevant smoke testing are done to make sure there are no stoppage/issues resulting from the monthly maintenance

• Send out weekly survey to the end users to be used in creating the Monthly Operational and Annual Operational reports

• Make sure that the tickets are all being worked on and assigned to a team member so that tickets won’t be idle in our end.

• Make sure Outages from that are announced from the client’s side are relayed to the CGI Team.

o Create a data model by using the Oracle Data Modelling tool and provide it to our clients for their work

o Performed minor support and modifications on python based applications included in the Municipal Affairs Application Portfolio.

• SiteView Upgrade 3 to 5.2, Encana Corporation – 12/17 to 3/18

o Collaborated with Senior Technical Analysts to have a good overview on how the Re-Platform would be done in the new version of SiteView.

o Coded the Changes based on the specifications provided in the Technical Document in C#.net

o Test the Module individually before passing on to the Business Analyst for Testing

o Made sure that the changes made were reflected in the client’s Code Repository

o Provide Additional Information on the JIRA Ticket Assigned to the Add-In

• BIEU Release 2.2 Mobius, Alberta Human Services – 10/17 to 12/17

o Collaborated with an SME to do data mapping for Various Mobius Information Products.

o Document the Data Mapping and gap analysis that will be used later to create the objects specified by the client within the scope

o Moving Forward, will be involved in the Data Loader Task currently being done by a single resource in this project

• BIEU Upgrade Phase 1, Alberta Human Services – 10/16 to 10/17

o Designed Codes,Objects,Applications in .NET that utilizes the Business intelligence Stack for Reporting(SSRS) and Data Transformation and Extraction(SSIS) based on the Design Documents by the Client.

o Unit Tested the Synthesized objects that was created in Multiple Environments.

o Provided guidance to other developers in terms of Coding and testing The Business Intelligence Objects in .NET

o Provided Immediate support during UAT while the Clients where testing the reports/Information Products

o Was involved in implementing the Information Products/Reports in Multiple Environments while working with other teams.

o Involved in Drafting the Technical Implementation for deploying the Business Intelligence Piece for the deployed Reports/Information Products

Tools Used (Technical)

• Visual Studio 2015, T-SQL, MS SQL Server 2012, 2014, Microsoft SQL Server Reporting Services, Microsoft SQL Server Integration Services C#.NET, VB.NET, DevExpress Version 15, TOAD for Oracle, CVS Versioning Tool, Microsoft Team Foundation Server, JIRA, UI Path, Python 2.5, Oracle SQL Developer 2.5.6, GitHub, Keepass

Software Developer July 2015 – August 2016

KADE Solutions (Formerly Singletouch Inc., Calgary Alberta Canada)

• Designs/codes applications following specifications using C#, .NET, SQL Server & Visual Studio.

• Collaborate with Developers, QA, Production Support and Account Team to provide technical direction

on systems analysis, design, development, testing and deployment.

• Participate in the architectural design of the software and its functionality.

• Participate in the architectural design of the database for the software using SQL Server.

• Research and experiment with latest technology for product enhancement and development.

• Assist client with technical questions and advice.

• Review documented technical requirements, development and project plans to ensure adherence to define standards and to facilitate the transfer of knowledge throughout the development staff.

• Facilitate code reviews, software design sessions, and architectural reviews.

• Participate in technical advisory roles, as required.

• Interact with customers at the technical level, as required.

• Effectively communicate technical concepts to other technical and non-technical staff members and collaborate in a team environment.

• Ensure timely and effective delivery of the solution into production.

Tools Used (Technical)

• Visual Studio 2013, T-SQL, MS SQL Server 2012, Microsoft Report Builder, Microsoft SQL Server Reporting Services, C#.NET, VB.NET, Crystal Reports, Viewpoint Construction Suite

System Integrator September 2014 up to January 2015

Isolutions Incorporated (Calgary, Alberta Canada)

• Worked with Historian Databases(PI System From OSISOFT)

• Create Custom Application to do extraction of Data from Historian Data To RDBMS( e.g. SQL Server Database)

• Create Custom Reporting With Excel Macro And Sql Server 2008 Database

Tools Used (Technical)

• Visual Studio 2013, T-SQL, MS SQL Server 2012, OSI Soft Historian Database Suite, ParcView Data Historian

Environment

• Microsoft Word, Microsoft Excel

• Microsoft Outlook(E-Mail)

• Google Drive

Programmer Analyst December 2012 to April 2014

Trimac Transportation (Calgary, Alberta, Canada)

• Supports application software by solving problems and making enhancements

• Assists in analysis by undertaking information gathering and basic analysis

• Develops specifications to modify/maintain complex existing applications using releases and utilities from the

Vendor

• Develops, codes, tests, debugs, and documents new software or enhancements to existing software

• May be involved in application support activities

• Assists in the development of major system modules/programs

• Designs supplementary programs to interface with existing systems, load start-up data and fulfill any

Special reporting requirements subject to tight deadlines

• Provides on-call support

• Knowledge of TMW Dispatch Systems

• Knowledge of Test Driven Development Acquired and Applied in Some of The Systems in the Company

• Applied Kimball’s Data Warehousing Concept on the New Report System

• Lead Developer For Implementing The New Information Builders WEBFocus Reporting Tool

• Provided Support and Made Changes to Some of The Existing Java Interface Used by The Company

Tools Used (Technical)

• Visual Studio 2013,ASP.NET 4.5 Framework, Kendo TELERIK Web Controls For ASP.NET, NetBeans For JAVA, Javascript, JSON, HTML5, Subversion Code Merging and Versioning Tool, T-SQL, MS SQL Server 2012, Information Builders WebFOCUS Reporting Tool 8.003.

Environment

• Microsoft Word, Microsoft Excel, UltraEdit(Code Comparison And Merge Tool)

• Microsoft Outlook(E-Mail)

Application Developer July 2012 to November 2012

Stars Air Rescue (Calgary, Alberta, Canada)

• Maintained and Developed software Codes for Electronic Patient Care Record (E-PCR) that is being used by flight paramedics for recording Patient information

• Worked with Business analyst to do enhancements on the E-PCR application and make the necessary changes

• Document and execute Test plans for every Release of the E-PCR application

• Troubleshoot any tickets/issues regarding the EPCR applications and deploy fixes/changes into production environment

• Performed Software versioning for the E-PCR application for the releases involved

• Created reports internally for Stars using A Reporting tool and also manage the deployment of the reports

• Developed SQL queries to pull data from the database and then transform these data to reports

• Developed an Excel Driven Macro To Secure Immunization Records of People Working In Stars

Tools Used (Technical)

• Visual Basic 6.0(for The E-PCR), T-Sql, Team Foundation Server, Visual Source Safe, MS SQL Server 2000 and 2008, SQL Server Reporting Services 2005 and 2008, Alloy Navigator 6.0(Ticketing System for Issues)

Environment

• Microsoft Word, Microsoft Excel, Winmerge(Code Comparison And Merge Tool)

• Microsoft Outlook(E-Mail)

Analyst / Solution Developer July 2011 to March 2012

Avanade Canada Inc. (Calgary, Alberta, Canada)

1# ECO Upgrade of WCB (Workers Compensation Board of Alberta)

• Created and Executed Test Plans For the Modules involved

• Created Web Forms using ASP.NET and DB2 Database as the Backend

• Experience In QA Test, Developed Code, Shooting For Zero Bugs

• Experience Writing Code in VB.Net in A Multi-Tiered Application

2# Shell Heavy Oil (SAP Blue Print)

• Involved in the preparation of Data for the SAP Blue Print Implementation

Tools Used(Technical)

• ASP.NET(4.0 Framework), VB.NET, T-Sql, Clearcase Rational Tool, MS Access 2010,Javascript, JSON,HTML5, Microsoft Excel,DB2 Database

Environment

• Microsoft Word, Microsoft Excel, Microsoft Project, Winmerge(Code Comparison And Merge Tool)

Analyst Programmer October 2005 to December 2010

Accenture Incorporated (Makati City, Philippines)

• Researched and synthesized technical information for designing, developing and testing clients’ web based system.

• wrote, modified, and integrated medium to complex software codes for building web applications using .Net and Database Technologies to meet client’s needs.

• identified and communicated technical problems and solutions with clients to create awareness of project and its modifications

• Documented discussions with clients to clarify and solidify proposed software specifications.

• discussed clients’ requirements clearly with four programmers prior to delegating software coding tasks.

• Tested software on daily basis to eliminate errors before delivery to client.

• Coached and Mentored Junior And Senior Programmers regarding day to day tasks and activities in the project

• Created and implemented .NET based web software using C#, VB.NET and MSSQL

• Tasked on Maintenance and Enhancement works on the Established Web Applications used by our clients.

• Translating wireframes, Data Specifications, And Use Cases into Working C#.Net Or VB.Net Code

• Experience in working within a small team both collaboratively and independently with minimal supervision.

• Experience in QA test developed code, shooting for zero bugs

• Experience In Maintenance Support For Our Clients

• Experience Writing Code in C#.Net or VB.Net in A Multi-Tiered Application

• Manage/Administer different builds and versions of a site through its life cycle. From the development server through pushing build iterations through to staging server to pushing final build to live server for site launch.

Tools Used(Technical)

PROFESSIONAL EXPERIENCES (Continue...)

• ASP.NET(4.0 Framework), VB.NET, T-SQL, Clearcase Rational Tool, MS Access 2010, JavaScript, JSON, CSS, XML C#.Net, Rational Clearquest, Microsoft Team Foundation Server, Microsoft SharePoint 2007, SQL Server Reporting Services(SSRS), SQL Server Integration Services(SSIS), Microsoft Visual SourceSafe(VSS), Microsoft SQL Server 2000 And 2005,

Environment

• Microsoft Visio, Microsoft Word, Microsoft Excel, Microsoft Project, WinMerge(Code Comparison And Merge Tool)

Programmer April 2004 to August 2005

Nissan Motors Philippines Corporation (Sta.Rosa Laguna, Philippines)

• Provided application and back end support to enhance company’s internal supply chain system

• Created and implemented .NET Forms Based software using VB.NET and SQL Server 2000

Environment

• Microsoft Word, Microsoft Excel

EDUCATION

Bachelor of Science in Computer Science June 2000 – April 2003

Laguna College of Business and Arts, Calamba City Philippines,

Trainings

AWS Cloud Practitioner Essentials December 20, 2022

CNOOC Office, Calgary Alberta Canada

Introduction to Power BI and DAX December 14, 2021 – December 15, 2021

CNOOC Office, Calgary Alberta Canada

35481 –Report Painter Part 2 Version WF8 (Online) November 12, 2013 – November 13, 2013

Trimac Office, Calgary Alberta Canada

35181 –Report Painter Part 1 Version WF8 (Online) November 5, 2013 – November 6, 2013

Trimac Office, Calgary Alberta Canada

Rapid ReadinessTraining(Sharepoint 2010) February 2012 – March 2012

Avanade GLD, Calgary Alberta Canada

Employability Skills Training April 2011 – June 2011

Employment Solutions Incorporated, Winnipeg Manitoba Canada

Contact this candidate