Sriyantha Silva Email & Phone Number

New Zealand

Commerce Street, Whakatāne 3158, New Zealand

• Administration of SQL server databases (Database Performance tuning, build dynamic index re-building mechanism to Ozone database)• Administration of Objective ECM and setting up new TEST and Dev environment from the scratched• SCADA data extraction using SSIS packages for 3 water team.• PowerBI dashboard development/ Setup new Test environment from the scratched for new version migration testing• Large SSRS report development. mainly from using Ozone database objects• SSIS package design for Ozone to GIS data extraction.• Build WDC specific ETL development work using Star Schema • Administration of Ozone ERP• Fixing Ozone data issues.• IBIS Rate modeling application version migration• AlphaOne API data extraction using Python for NFP Metric• Currently working on Building DW space for Non Finance Performance Metrics

Colombo

Enterprise Reporting Team Project summary and achievements:• Microsoft SQL Server 2012/2016 (Database, SSIS, SSAS, SSRS)• Oracle 11g Package and Procedures• SQL (T-SQL, PL-SQL)• Pentaho Reporting tool• Tableau Business Analytic dashboards• Bash scripting • Linux• Spark, Hadoop and Machine learning– POC level works only

RADAR – Internal Reporting System, Virtusa (Pvt) LtdData warehousing Technical Lead Design, development, requirements management and testing in an enterprise data warehouse with ETL, OLAP, reports, dashboards and ad-hoc data analysis.BI tool evaluation• SQL Server 2005 Database administration• T-SQL, PL-SQL (with Oracle 11g)• SSAS – 2005/2008/2012 Analysis Services. (Cubes)• MS BI with Sharepoint 2010• SSIS – SQL Server Integration Services 2005/2008/2012• SSRS – SQL Server Reporting Services 2005/2008/2012• VB.Net• C#.Net • MDX – Multi Dimensional Queries.• Oracle ERP Integration to DW

Sri Lanka

Project summary and achievements:• Support for Virtusa internal applications• Designed and implemented SQL Server 2005 Backup/Recovery Strategy for EAG database servers• Tuned Databases for the optimum performance• Administer SQL Server security• Monitoring Database Replication• Monitoring and conflict resolving in data through SQL server • Preparing refreshable reports for management• Planning, managing and tracking the customer support team for completion of work orders • Patch release and version upgrade deployment in production environments • Team management, coordination, planning and execution of maintenance project workTechnologies:ASP.net, C#, Java, IIS, SQLServer2000/2005, Tortoise SVN

Sri Lanka

Hospital - MIS SystemResponsibility:Accountable for designing, maintaining and developing software applications to improve and enhance hospital operations. Interfaced closely with Management, Finance Department and Billing staff to Identified new requirements and articulated detailed software requirement specifications.Project summary and achievements:• Designed and developed various new application required by different department including Billing, Inventory Management system, Invoicing, Payment and Receipt modules, General Ledger Module• Integrate regional labs with main lab for online test result using SQL Server replication• Migrate SQL Server 2000 database to 2005• Developed reporting module for higher management• Maintenance of existing applications• Perform database administrative and performance management tasks Technologies:Window, MS SQL 2000/2005 databases, SQL Server 2005 replication, VB.6

Sri Lanka

ERP System - Villa Ocen View HotelAugust 2003 to January 2005I-Web Solution is one of the local software firm, who develop various Windows and Web base application for different clients.Responsibility:Communicated with clients regarding change requests, requirements verification, and identifying new requirements for articulating detailed software requirement specification. Planned and estimated development efforts for software systems in projects. Maintained source code structure, built system, and performed end-to-end development of software applications components. Created coding standards and oversee performance improvements and code refactoring, as well as module coding and unit test creation.Project summary and achievements:This project was to create ERP system to leading Hotel to automate it operations and worked on the below mentioned software modules,• Front Office Registration & Reservation • House Keeping• Stock Control System• Chart of Accounting System• General Ledger System• Debtor Control System• Creditor Control System• Payroll System• Invoicing SystemTechnologies:Window, MS SQL 2000, VB.6

Beng (Hons) Software Engineering, Computer Software Engineering

Professional Graduate Diploma, Information Technology, Pass

Diploma, Information Technology