Channaka Cooray available

Channaka Cooray

Infor Technical Consultant / StreamServe , OpenText

Profileimage by Channaka Cooray Infor Technical Consultant / StreamServe , OpenText from Colombo
  • Colombo Freelancer in
  • Graduation: not provided
  • Hourly-/Daily rates:
  • Languages: English (Native or Bilingual)
  • Last update: 07.08.2014
StreamServe, M3, Microsoft SQL Server, SQL, .NET, SSRS, ERP, T-SQL, C#, SharePoint, Crystal Reports, Software Project Management, Software Implementation, Business Analysis, PL/SQL, Business Intelligence, Systems Analysis, SSIS, VB.NET, Software Documentation, Databases
Brandix i3
Technical Consultant
04.2012 - today
• Instillation of Lawson products and solutions.
• Administration of Life Cycle Manager.
• Applying Fix’s and Modification to the M3 Business Application.
• Configuring systems and coping data, import/export on to multiple environments through LCM.
• Managing job and schedules on M3 application.
• Administrating M3 application, creating user profiles, providing permission, setting up printers.
• Design, Develop and Deploy StreamServe Reports on to environments.
• Administration and maintaining IBM AS 400 server.
• Performance tuning in DB2 and SQL Server Databases.
• Instillation of other products and solutions.
• Configuring and Administration SharePoint 2010.
Information Technology and Services
51-200 employees

Brandix Lanka Limited
Application Developer
04.2009 - 04.2012
? Designed and developed Requirement Specification Document Templates.
? Gathering and Documenting user requirements for new development for analysis of the AS IS process.
? Handling incidents which are reported by the user from different SBU’s.
? Extensive Transact-SQL programming in Microsoft SQL Server 2005/2008 and DB2 Environment.
? Developing Stored Procedures, Functions and Views in SQL Server 2005/2008 to manipulated data from MoveX database.
? Transact-SQL Query Optimization.
? Designed and developed reports for Lawson ERP System via SQL Server 2005 Reporting Services.
? Developing ETL tools for data cut over for Item Master, Supplier Master and Customer Master Files.
? Identifying solutions for teasing bottle necks.
? Administrating and developing SharePoint server 2007 and 2010.
? Maintaining, Backing up and monitoring server.
? Administrating AS400 servers
10,001+ employees

Cadenza IT
Software Engineer
08.2007 - 03.2009
? Played an active role in identifying the system requirement for new Logistics System.
? Analyzed company documents to identify the business scope and data requirements
? Design and Developed Relational Database Schemas, Table, Function, Views and Stored Procedures on Microsoft SQL Server Environment.
? Active core member of the programming team to develop the logistics system via C#.Net Business Object Model Standard.
? Designed and Developed report for the logistics system via Microsoft : SQL Server Reporting Services 2008
? Built test cases for each module in the system.
? Trained employees on how to use the new system after implementation.
Information Technology and Services

University of Moratuwa
01.2007 - 12.2007
? Developed lesson plans that help students to successfully complete their freshman year.
? Developed sample projects to introduce and familiarize to the .Net environment.
? Guided students to achieve their objectives in understanding OOP concepts to develop the first year project
Higher Education
1001-5000 employees