Thushara Senaratna Email & Phone Number

Adelaide, Sa, Au

Adelaide, Sa, Au

Adelaide, South Australia, Australia

Automated the process of handling invoices of the leased vehicles to DHS using SQL and SSRSInvolved in a project to migrate IBM Cognos reports to the SSRS platformDeveloped ETL processes to bring in vehicle invoice data and NDIS data into a specific data mart using SSIS and Sql server bulk load

Australia

Worked with large data sets to create stored procedures to schedule in sql server agentAnalysed sql queries and optimized performanceBuilt SSIS packages to extract and transform data, to load into the data warehouse or create flat filesUsed SSRS to create reports for the usersFunctioned as the primary person to investigate and provide solutions for their old booking system and worked as the sql developer for the replacement project of that booking… Show more Worked with large data sets to create stored procedures to schedule in sql server agentAnalysed sql queries and optimized performanceBuilt SSIS packages to extract and transform data, to load into the data warehouse or create flat filesUsed SSRS to create reports for the usersFunctioned as the primary person to investigate and provide solutions for their old booking system and worked as the sql developer for the replacement project of that booking systemProvided support to the other teams in the organization (Revenue, Travel centre, Finance, etc) when issues raised with data loading, reports, etc Show less

Adelaide, Australia

Adelaide, Australia

Analyse customers'​ report requirements and help them preparing the report requirement specification. Develop new reports or modify the existing reports for Core Banking, Loan or Internet Banking systems according to the customer requirements (Some reports to provide information for APRA and ASIC).Provide estimates and quotes for the report enhancements and new reportdevelopments.Do trouble shooting of any errors or performance issues related to… Show more Analyse customers'​ report requirements and help them preparing the report requirement specification. Develop new reports or modify the existing reports for Core Banking, Loan or Internet Banking systems according to the customer requirements (Some reports to provide information for APRA and ASIC).Provide estimates and quotes for the report enhancements and new reportdevelopments.Do trouble shooting of any errors or performance issues related to reports.Provide instructions to our supporting staff to setup new reports on an internally developed intranet based web site.Attend estimate and design review meetings. Show less

Colomo, Sri Lanka

Developed applications and reports for Data Warehouse and Management Information System (MIS) using C#.net, VB 6, Crystal Reports, Oracle, MS SQL and UNIX Shells.Automated a lot of manual processes such as applying for leave, claiming medicals, claiming fuel, reimbursing telephone bills and claiming Over Time.Designed and developed an application to capture exceptional ATM transactions.Developed an automated solution in VB6 and Oracle to to replace the manual process of… Show more Developed applications and reports for Data Warehouse and Management Information System (MIS) using C#.net, VB 6, Crystal Reports, Oracle, MS SQL and UNIX Shells.Automated a lot of manual processes such as applying for leave, claiming medicals, claiming fuel, reimbursing telephone bills and claiming Over Time.Designed and developed an application to capture exceptional ATM transactions.Developed an automated solution in VB6 and Oracle to to replace the manual process of drawing winners for the bank's most popular lottery "Pathum Vimana"Played a key role in developing the software change management system of the bank, designing tables structures and most of the interfaces.Implemented a web based solution to collect income and expenses of all 220 branches and prepare the overall budget of the bank.Modified some programs and oracle stored procedures to increase the efficiency. Show less

Colombo, Sri Lanka

Involved in program enhancements and report development in Management Information Systems (MIS)Maintained and added enhancements/improvements to the bank's Data Warehouse.Actively participated in standardizing interfaces and reports in the Management Information System.

Colombo, Sri Lanka

Monitored the Core banking system and ATM network and took preventive measures.Provided technical support to resolve IT related issues at bank branches over the phoneCoordinated with vendors to resolve system related issues.Performed End of the Day operations of the Core banking system, ATM system, leasing system, loan recovery system and other small systems.Handled customer inquiries related to salary payment via Sri Lanka Interbank Payment System (SLIP) and ATM… Show more Monitored the Core banking system and ATM network and took preventive measures.Provided technical support to resolve IT related issues at bank branches over the phoneCoordinated with vendors to resolve system related issues.Performed End of the Day operations of the Core banking system, ATM system, leasing system, loan recovery system and other small systems.Handled customer inquiries related to salary payment via Sri Lanka Interbank Payment System (SLIP) and ATM related transactions.Trained juniors on relevant operations Show less

Colombo, Sri Lanka

Conducted lectures for DICS (Diploma In Computer Studies) students.Worked in the computer lab helping students in completing their practical assignments on programming and Microsoft Office.

Professional Graduate Diploma, Information Technology

Activities and Societies: British Computer Society

Advanced Diploma In It, Information Technology