Responsibilities:

• Facilitated requirements elicitation sessions with different stakeholder groups
• Produced Software Requirement Specification – SRS – and Business Requirements – BRD – documents
• Produced and delivered Power Point presentations for internal and external clients
• Worked in close collaboration with User Centered Design team
• Performed database analysis and queries
• Produced User Guide updates
• Supported Quality assurance , User Acceptance Test , and Production environments
• Reviewed and provided sign off for QA and UAT test plans
• Supported internal and external clients
• Assessed project’s feasibility with architects and lead developers
• Used SharePoint as company repository for BA documents and coordination with translation team
• Modeled the business team process definition and interaction with PMO
• Worked with geographically dispersed stakeholders and development teams

Roles and Projects:

• Prime Business Analyst for Inquiry application
• Inquiry is the single point of information for Client Services, Call Centre Staff, Business Analysts performing a Production Support role, Claim Assessors and Plan Administrators that work with Health Insurance systems
• Inquiry provides information for Multi Benefits – Dental, EHC, H.S.A. and Costplus – and Drug adjudication engines.

Main Projects:

• Multi Benefits and Drug Integration projects
• GAMA Updates via Inquiry and DECM
• Inquiry Modernization efforts including data analysis and mapping among different database schemas
• Inquiry Drug Claim simulation project involving Simulation and Drug Adjudication Engine components
• Carrier Preferences for Multi Benefit and Drug systems
• Programs: Preferred Product Pricing, Glucose Blood Test Strip, Prior Authorization
• Medical Recommendations and Grace Period
• Business analyst for DECM – Data Entry and Claim Management – and GAMA – Group and Member Administration – applications
• User work flow improvement by allowing the capture of recipient data – essential for adjudication – in Inquiry and DECM applications using GAMA application.
• Business analyst with Business Intelligence Software
• Project to report on health provider’s system adoption. This project involved Switch component, ETL (Extract, Transform, Load), data warehouse and cubes with Business Intelligence Strategy Companion tool.
• Performed demonstrations for users.
• Business analyst for eClaims application
• eClaims allows the electronic data entry for Multi Benefits – Dental and EHC – claims
• Main projects:
• Electronic client acceptance of the eClaims provider’s agreement contract
• Electronic enrollment for electronic payment. Collects and stores health provider’s electronic fund transfer information among other information

Responsibilities:

• Implemented change requests using Java, Oracle, and PL/SQL
• Implemented ETL projects using Web Methods tool
• Performed data analysis, modeling and mapping in all the projects
• Produced stored procedures and XML files using Oracle XML functions
• Produced web services
• Produced Software Design documents
• Used SharePoint as company repository for Software Design documents
• Lead developer for CPR application
• CPR maintains the National Provider Registry that supplies information to various TELUS systems – WSIB system, Multi Benefit, and Business Intelligence – as well as external Clients.

Main projects:

• National eClaims adoption phases I and II
• Integration of WorkSafeBC in CPR involving web service component
• Multi Benefit eClaims and Switch Engine Enhancements
• Led the unification of provider’s work information improving data entry and data management processes
• Creation of the XML provider file data for distribution to the health insurers
• Automation of the load of CDA, ACDQ and denturist associations information into the CPR system

Company oriented to provide travel services for high school, college and university students. Used MS Visual C++ and MS SQL Server

Responsibilities:

• In charge of the Travel Booking web application, delivering the 70% of IT support for the business. This application allowed clients to book their trips, link their trip to friends through room reservation, specify start and end trip's cities, including automatic cost modification, and perform electronic payment. The application also allowed managing of client accounts where clients could see their booked trips, their payment status and buy available tours associated to specific trips.

Main Projects:

• Electronic payment through web service with Moneris Solutions facilitating the payment's collection
• Web service to expose as produced, the changes of back-end trip prices in the static company web site
• New web application to allow school teachers manage the allocation of rooms and busses for the students registered in the school trip booked with the company allowing Breakaway Tours a better use of their administrative resources

Company oriented to produce and sell software security services to other companies. Used MS Visual VB and MS SQL Server.

Main Projects:

• Use of technologies for encryption, virus protection and programmatic email
• Maintenance of C++ application to avoid expending in expensive external resources
• Plug-in for MS Outlook using VB6 as part of DABRA client side solution
• Maintenance of the main web application

Coordinated two work teams in the development and implementation of this insurance company’s main operational application, using MS Project

Analyzed and developed marketing applications using MS VB, Oracle and MS SQL Server