SQLiaison - Business Intelligence and Data Warehousing Planning and Implementation Experts.


	2008-06-30 A NEW FellowDSS SOLUTION! FellowDSS, the most utilized analytical applications for the insurance industry in Canada, is proud to introduce yet another solution for insurers: FellowDSS Optimal Risk Sharing (ORS). This new FellowDSS solution provides insurers with better management of risk sharing pools. ORS helps insurers select with more precision the risks to be ceded to risk sharing pools. To find out more about ORS, visit FellowDSS ORS on our wed site 2008-06-23 SQLIAISON MANAGING DIRECTOR GIVES CYBERPRESSE.CA INTERVIEW ON MICROSOFT HYPER-V TECHNOLOGY Jacques Charland, General Manager, Professional Services of SQLiaison gave an interview to Cyberpresse.ca on the Microsoft Hyper-V Server technology. For the complete article Cyberpresse - Microsoft Hyper-V 2008-05-12 SQLIAISON PRESIDENT INTERVIEW IN PME MAGAZINE Philippe Torres gave an in-dept interview for the May 2008 issue of PME magasine explaining the value of business intelligence for small and medium companies. 2008-03-27 SQLIAISON IN TOP 250 CANADIAN IT COMPANIES OF BRANHAM 300 As a result of the commitment of our experts to deliver the best solutions in business intelligence for our clients, SQLiaison has been selected in the rankings of the 2008 Branham 300, an annually updated list of the top performing Canadian IT companies. The results were released in the Canadian technology magazine Backbone. Backbone Top300 Branham300 2008-02-15 SQLIAISON PRESIDENT GIVES INTERVIEW ON CANAL ARGENT SQLiaison President Philippe Torres gave an interview on Business Intelligence on Canal Argent. View the interview 2008-01-28 YVAN DUPONT JOINS SQLiaison AS EXECUTIVE DIRECTOR, PROFESSIONAL SERVICES SQLiaison is proud to announce the nomination of Yvan Dupont as Executive Director, Professional Services. Mr. Dupont is an authority in BI in Canada with more than 25 years experience in IT, 13 of which in BI. Throughout his career, he has supervised many complex projects for large conglomerates and managed many professional services teams and BI centers of excellence in different countries (Canada, U.S.A, France, Portugal and Egypt). He brings with him an impressive knowledge of different industries such as telecommunications, retail, insurance and banking. His strategic expertise and complex projects experience will be a considerable advantage for SQLiaison’s clients. 2008-01-23 SQLiaison AT THE SALON DE LA BUSINESS INTELLIGENCE 2008 The third annual Salon de la Business Intelligence, organized by the FiQ, will take place on Wednesday, April 9th at the Palais des congrès de Montréal. As a major sponsor, SQLiaison will be present in force with multiple presentations and conferences as well as many of its experts to answers BI question specific to the different industry sectors. For more information about the Salon, click here. 2008-01-14 INSURANCE BUSINESS INTELLIGENCE SQLiaison offers complete business intelligence professional services for insurers in Toronto and Montreal. SQLiaison has the foremost experts in insurance business intelligence. With more than 11% of all Canadian premiums being processed through analytical sytems planned and implemented by SQLiaison, we are the absolute leader in insurance BI in Canada. insurance BI 2008-01-05 BUSINESS INTELLIGENCE EXPERTS SQLiaison is the Canadian leader in Business Intelligence solutions. We are experts at leveraging data quickly, seamlessly and powerfully to create business advantage for our clients. Since its creation in 1994, SQLiaison has designed, developed and implemented some of the most sophisticated informational systems available today. Building on years of providing solutions, our experts are experienced with, and understand, the challenges and problems specific to each industry. Our clients add up to an impressive roster, including prominent banks and insurance companies, major manufacturers, pharmaceutical companies, retailers, telecommunications and other large Canadian corporations. SQLiaison is also the creator of FellowDSS™, an enterprise-scale Business Intelligence suite of analytic applications designed specifically for the insurance industry and leveraged by leading Canadian insurers. The FellowDSS™ framework enables rapid and cost-effective deployments that deliver tangible short-term and adaptive long-term business intelligence solutions. Because we understand that ensuring accurate and up-to-date information is the cornerstone of every successful business, SQLiaison also offers the most effective Data Quality solutions as an integral part of its offering. SQLiaison has offices in Toronto, Montreal and New York. 2007-10-26 SQLiaison WINS A FLECHE D OR FOR FELLOWDSS^TM OLA DIRECT MARKETING CAMPAIGN The Quebec Relationship Marketing Association has attributed a Gold Flèche in the Direct Advertising category for a campaign created by 2B Interactive for the FellowDSS^TM On-Level Analytics solution. The strategy supervised by Director of Marketing Pierre Breton aimed at obtaining meetings with the chief actuaries at the top insurance companies in Canada. The campaign consisted of sending actuaries a quality wine bottle encased within a locking puzzle. The solution to the lock was available on-line through a unique user code where the person could also learn about the OLA solution. This multi-media campaign triggered many meetings with potential clients as well as increased greatly the notoriety of FellowDSS^TM with potential clients. .Infopresse "That win came as a double surprise! One in the major Direct advertising category, and second winning the gold in front of TD Bank and Transcontinental!" commented Pierre Breton. 2007-10-22 FELLOWDSS^TM ON-LEVEL ANALYTICS IS A FANTASTIC RATING SOFTWARE A NEW DECISION SUPPORT SOLUTION FOR ACTUARIES. FellowDSS^TM On-Level Analytics is a suite of integrated tools that perform On-Level Rating Analytics (segmentation, rating and experience analysis). FellowDSS^TM On-Level Analytics has been developed with the specific needs of Actuaries in mind and eliminates many of the issues with today's Rating Analytics environment and with the rate development process. MORE INFO ON FELLOWDSS^TM OLA 2007-10-12 MAJOR GROWTH AT SQLIAISON - 10 NEW HIRES IN SEPTEMBER! Business is brisk at SQLiaison. Due to an ever increasing number of mandates from our clients, human resources hired 10 Business Intelligence Experts over the month of September. As well as top-level architects, analysts and developers, we also hired senior project managers and subject matter experts in order to better serve our insurance, financial services and pharmaceutical clients. 2007-09-2 FELLOWDSS^TM ON-LEVEL ANALYTICS IS A FANTASTIC RATING SOFTWARE A NEW DECISION SUPPORT SOLUTION FOR ACTUARIES. FellowDSS^TM On-Level Analytics is a suite of integrated tools that perform On-Level Rating Analytics (segmentation, rating and experience analysis)for insurance companies. FellowDSS^TM On-Level Analytics has been developed with the specific needs of Actuaries in mind and eliminates many of the issues with today's Rating Analytics environment and with the rate development process. It is the insurance on-level rating software solution. MORE INFO ON FELLOWDSS^TM OLA 2007-09-06 FONDACTION CSN INVESTS $1.5 MILLION IN THE GROWTH OF SQLIAISON Fondaction, the development fund of the CSN for the cooperation and employment, invests $1.5 million in SQLiaison. SQLiaison creates and implements softwares for the Insurance industry and offers professional services in Business Intelligence, enabling its clients to use their data to make strategic decisions. This investment will contribute to develop new products and new markets. About Fondaction Fondaction invests development capitalm in order to keep and create jobs in Quebec. Its assets of about $550 millions on Mai 31, 2007, stem from the retirement savings from 77 000 shareholders. It is the financial partner of close to one hundred companies and partner or specialized funds. It assigns a particular attention to firms in a process of participatory management, of social economy (coop and others) and those more preoccupied by the environment. Fondaction is the first quebec financial institution having obtained the Organisational Stakeholder status of the Global Reporting Initiative (GRI), a UN program for the environment. Fondaction.com REERvert.com 2007-07-17 MANY GREAT JOBS AVAILABLE NOW AT SQLiaison! We are looking for the best in Business Intelligence. SQLiaison has presently many positions open for ETL developers with Oracle+PL/SQL, experts in Business Objects, Data Modelers, MicroStrategy and many others... List of openings To schedule an interview, call Shruti at 514 333-6600 #108 2007-07-04 FELLOWDSS IS THE MOST UTILIZED DECISION SUPPORT SYSTEM BY INSURANCE COMPANIES IN CANADA There is now more than C$4,53 billion in direct written premium processed through FellowDSS in Canada. This represents a 11.41% Canadian market share. No other Business Intelligence suite of analytics has such an impact in the Canadian insurance industry. This makes FellowDSS simply the best software for Insurance companies. More on FellowDSS 2007-06-12 BUSINESS INTELLIGENCE CANADA SQLiaison is the foremost Business Intelligence Expert in the Canadian market. SQLiaison offers professional services in planning, developing and integration of data for analysis and reporting purposes. With offices in Montreal and Toronto, our experts have been helping Canadian companies for more than 14 years! 2007-06-06 DENIS R. TREMBLAY, Ph.D. JOINS SQLiaison AS SENIOR EXECUTIVE CONSULTANT SQLiaison is proud to announce the nomination of Denis R. Tremblay, Ph.D.as Senior Executive Consultant. Mr. Tremblay is a project director with more than 25 years of experience in the management of the development and the implementation of strategic plans aimed at introducing national systems , corporate performance management systems, and strategic business solutions specific to industry sectors. 2007-05-04 SQLiaison TO PRESENT CLOCKWORK DATA QUALITY SOFTWARE AT MICROSOFT EVENT At free a lunch event taking place at Microsoft in Montreal, SQLiaison will present Clockwork, its Data Quality Steward tool on June 6th. Agenda : 11:30 am - 12:00 pm - Welcome 12:00-12:15 - Introduction 12:15-12:45 – Microsoft Presentation 12:45- 1:30- SQLiaison Presentation 1:30-1:45 – Questions and conclusion This is a great opportunity to learn more on Data Quality. More on Clockwork 2007-04-18 CORPORATE MEMORY - THE FUTURE OF BUSINESS INTELLIGENCE Philippe Torres, President of SQLiaison, presented at the 2007 Salon du BI a conference on the future of business intelligence. This conference was a reflexion on a possible corporate memory management model. The most valuable assets of companies are now the knowledge of the employees and not what they produce. Preserving an heritage of information and knowledge and making it available for futur decision makers requires more than just data and information. It requires different approaches to the managing of knowledge, data and processes. This conference was very well received by the numerous attendants and provideds a convincing vision of what could be in store to improve the performance of business intelligence users. Corporate Memory Presentation (french) 2007-03-05 SQLiaison BUSINESS INTELLIGENCE CONSULTANTS SQLiaison benefits from the best business intelligence consultants in the business. All full time employees, garanteed certified experts on your preferred BI tools. Call on the SQLiaison consultants to plan and integrate your BI solution. SQLiaison - 1.866.333.8184 2007-03-01 SQLiaison CLOCKWORK DATA QUALITY SOFTWARE NOW AVAILABLE! Clockwork is a powerful and flexible software solution that helps guarantee the information accuracy and completeness of your Business Intelligence applications. In other words, Clockwork closely monitors and maintains Data Quality. Learn more about Clockwork. 2007-02-26 SQLiaison at THE SALON de la BUSINESS INTELLIGENCE The second annual Salon de la Business Intelligence, organized by the FiQ, will take place Wednesday April 4th at the Palais des congrès de Montréal. As a major sponsor, SQLiaison will be present in force with multiple presentations and conferences as well as many of its experts to answers BI question specific to the different industry sectors. For more information about the Salon, click here. 2007-02-05 LOTO-QUÉBEC PICKS SQLiaison! SQLiaison is picked by Loto-Québec as priviledge supplier for database management and BI systems implementation.Loto-Quebec 2007-02-05 WORKOPOLIS SIGNS SQLiaison FOR ITS BI IMPLEMENTATION Workopolis.com, Canada's biggest job site has decided to partner with SQLiaison to implement state-of-the-art Business Intelligence. Workopolis.com 2007-01-11 Wine Puzzle Solution Please click here to view the solution. 2006-10-03 SQLiaison IS A PARTNER OF TOP BI SOFTWARE PROVIDERS SQLiaison has experts for Oracle, Informatica, MicroStrategy, Business Objects, Sybase, Ascential and many others. Oracle Sybase Microsoft Business Objects Informatica MicroStrategy 2006-09-21 SQLiaison IMPLEMENTS A BI SOLUTION AT GILDAN SQLiaison will take part in the implementation of an information solution within a business intelligence program created by its experts. Through this project, SQLiaison strenghtens its position as an expert in manufacturing-specific BI with the candian leader in clothes manufacturing. SQLiaison combines expertise in Business Intelligence, manufacturing information challenges and manufacturing-specific technologies. Gildan 2006-09-14 SQLiaison ADVISES CBC / RADIO-CANADA ON BI GROUP ORGANIZATION The CBC/Radio-Canada IT group reorganized last winter and decided to form an official BI group, known as the Data Management Group. The broadcaster turned to SQLiaison to help them organize that group, define its structure, the roles and responsibilities of the players, define their processes and toolset. SQLiaison used its SMART eBI BICC service and organized the group as requested. The customer was so pleased with SQLiaison's services that he spontaneously gave us a letter of commendation for this work! CBC 2006-09-14 SUCCESSFUL BI PROJECT COMPLETED AT CBC / RADIO-CANADA The mandate, started in 2005, consisted in helping CBC / Radio-Canada finish their BI project. The project was part of a much larger project than just BI, encompassing the replacement of the whole broadcasting system, their bread and butter. A small part of that major effort is reporting and that is where SQLiaison helped. The existing BI architecture presented a few major issues which we had to either work with, circumvent or replace altogether, when feeding the data warehouse and the datamarts. CBC 2006-07-19 KUEHNE + NAGEL DELIVERS CUSTOMER KPI PACKAGES THROUGH DATA MODEL AND ETL DESIGN CHANGES Kuehne + Nagel is one of the world’s leading logistics providers. The experts at SQLiaison were mandated to help them deal with serious delays in delivering their Customer KPI packages. The work was accomplished in record time and helped produce 18 customer packages while making data model and ETL design changes. Kuehne + Nagel 2006-06-12 SQLiaison reporting solutions Altough Business Intelligence competitors such as Odesia, Keyrus and Adastra offer similar services, SQLiaison has the best experts to solve all data management and data quality challenges. SQLiaison is especially knowledgeable of the in insurance and financial services such as banks and brokers. 2006-06-12 BUSINESS INTELLIGENCE CONSULTING SQLiaison benefits from the best business intelligence consultants in the business. All full time employees, garanteed certified experts on your preferred BI tools. Call on the SQLiaison consultants to plan and integrate your BI solution. SQLiaison - 1.866.333.8184 2006-06-12 BUSINESS INTELLIGENCE CONSULTING SQLiaison benefits from the best business intelligence consultants in the business. All full time employees, garanteed certified experts on your preferred BI tools. Call on the SQLiaison consultants to plan and integrate your BI solution. SQLiaison - 1.866.333.8184 2006-06-02 SQLIAISON WAS PRESENT AT THE ANNUAL MEETING OF THE CANADIAN INSTITUTE OF ACTUARIES Philippe Torres, President and André Giroux, Senior Client Executive of SQLiaison, Business Intelligence Experts, were present to discuss Using Business Intelligence in the Insurance industry. Counting among their clients industry leaders such as Aviva, AXA and Industrial Alliance among others, they are the foremost experts in Business Intelligence that specifically adresses the special challenges of the Insurance industry. To learn more: 2006 Canadian Institute of Actuaries Annual Meeting 2006-05-10 AVIVA CANADA COMPLETING AN ORGANIZATION-WIDE ROLL OUT OF FELLOWDSS BI REPORTING SYSTEM more info 2006-02-12 Solution to the SQLiaison puzzle Click on the link below to visualize the SQLiaison Iron Maiden puzzle solution. Solution 2005-06-06 SQLiaison has the best Experts in Business Intelligence in Canada SQLiaison, the canadian leader in Business Intelligence planning and implementation hires the best experts to satisfy the demands of its clients. Contrary to its competitors, SQLiaison does not use freelancers. This garantees our clients that only proven people who are known to be qualified and fully certified will work on their projects. SQLiaison Home Page Here is a list of all the experts we have working for you:¸ Data Warehouse Senior Analyst Responsible for strategic guidance in decision support initiatives and plays the role of a trusted advisor. „X Business Opportunity Assessment „X Detailed Requirements Analysis „X Strategic Plan Review Data Warehouse Architect The Data Warehouse Architect is a very seasoned individual whose mandates generally revolves around data warehouse and analytical application architecture. „X Architecture Assessment Plan „X Project Management Plan „X Integration Test Plan „X Security Integration Deployment „X Testing Strategy Plan Data Warehouse Data Modeling Specialist The Data Warehouse Modeling Specialist is an expert in the art and science of data modeling for analytical applications. This individual is fluent with data warehouse ER modeling and dimensional modeling. „X Detailed Data Analysis „X Data Model Review, „X Data Model Analysis „X Data Model development Data Warehouse DBA The Database Administrator is an expert in the configuration, development, administrative and maintenance aspects of Data warehouse RDBMS environments such as IBM, Microsoft, Oracle and Sybase. „X Security Integration Plan „X Data Model Analysis „X Production Cycle Integration „X Performance & Tuning DSS Analyst The Decision Support System Analyst provides specifications to the development team for the Report Objects to be developed and implemented. This consultant is an expert in development, deployment and administration DSS Developer The Decision Support System Developer is an expert in the development of analytical applications using Business Intelligence platforms such as Business Objects, Cognos, MicroStrategy, SAS, etc... This consultant is familiar with the development, deployment and administrative aspects of these platforms. „X Analytical Object Development „X Metadata Model Documentation „X Performance & Tuning ETL Analyst The Extract, Transformation and Load Analyst provides specifications to the development team for the data integration logic to be developed and implemented. „X Data Integration Analysis „X Data Integration Development „X ETL Administration ETL Development The Extract, Transformation and Load Developer is an expert in the development of data integration logic and with specific data integration platforms such as DataStage, Informatica PowerCenter, Oracle Warehouse Builder, Microsoft SSIS. „X Data Integration Development „X Integration and Acceptance Testing „X Metadata Model Documentation Project Manager The Project Manager is responsible for the successful management and execution of the project. Project management responsibilities Include tactical project management, implementation and support of technical staff. „X Project Integration Management „X Time, Cost and Quality Management „X Resources & Procurement Management „X Risk Management „X Communications Management For more info: Call 1 866 775-5242 Email 2005-03-22 SQLiaison PROVIDES A NEW ANALYTIC APPLICATION FOR THE INDUSTRIAL ALLIANCE GROUP SQLiaison, a Canadian leader in decision-making and business intelligence environments, announces that it has recently finished the development and the installation of the analytical application Flexible Business Intelligence for Industrial Alliance Insurance and Financial Services. Industrial Alliance 2005-03-15 SQLiaison PICKS KALLEO.COM SQLiaison has picked Kalleo.com for its IT support. 2005-03-08 SQLiaison BUSINESS INTELLIGENCE EXPERTS IN MONTREAL SQLiaison is the foremost business intelligence expert in Montreal. With its offices in Montreal, SQLiaison can offer its Montreal and Quebec clients the upmost quality in service. SQLiaison is the canadian leader in business intelligence and data warehousing solutions. SQLiaison offers, since 1994, specialised consulting services in designing, developing and implementing decision support tools and systems for its clients in specialised industries such as insurance, financial services, pharmaceuticals, manufacturing and many others. In Montreal, call 514 333-8583 2005-03-08 SQLiaison BUSINESS INTELLIGENCE EXPERTS IN TORONTO SQLiaison is the foremost business intelligence expert in Toronto. With its offices in Mississauga and Markham, SQLiaison can offer its Toronto and Ontario clients the upmost quality in service. SQLiaison is the canadian leader in business intelligence and data warehousing solutions. SQLiaison offers, since 1994, specialised consulting services in designing, developing and implementing decision support tools and systems for its clients in specialised industries such as insurance, financial services, pharmaceuticals, manufacturing and many others. In Toronto, call 905-306-3440 2005-02-05 Pierre Breton joins SQLiaison as Director of Marketing Pierre Breton joins SQLiaison, experts in Business Intelligence in Canada as Director of Marketing. Previously, Pierre was account director at BBDO in Saudi Arabia, account director at Cossette and advertising and marketing manager for Allied-Domecq Canada's retail division, which includes Dunkin' Donuts, Baskin-Robbins and Togos.