Kasun Herath Email & Phone Number

United States

Hartford, Connecticut, United States

United States

• Client management – Daily/weekly status update• Requirements elicitation and documentation• Estimations on MSBI components – SSIS/SSRS and data transformations • Responsible for design SSIS packages and SSRS reports• Development and maintenance of SSIS packages to load data from various data sources such as SQL Server, Excel documents, Quick Base and text files• Integration of SQL jobs with web applications• Responsible for automated processes – Uploading a document to be loaded and generate reports with complex data transformations• Development/maintenance/deployment of SQL Server Reporting services• .Net support on various integration activities – use of script tasks to increase performance/maintain environments

Sri Lanka

• Project estimations on DWBI stream of the project• Manage the project members and train them on different aspects such as ETL development and complex SQL/MDX queries• Development/Maintenance of SSIS packages to load data from various data sources such as Oracle, SQL Server, Excel documents and text files• Write complex T-SQL procedures to clean and transform data• Create and Modify existing dimensional models to cater to new requirements and changing requirements• Cube design on SSAS to facilitate end-user BI via pivots and dashboards through SSRS and SharePoint Performance services.• Responsible for technical documentation (DSTD/KDD/RDD/Physical and Logical diagrams)• Conduct reviews of T-SQL procedures, SSIS packages, Cube development, Dashboards and reports• Client management, requirements elicitation and documentation, client presentations, end-user training and help the client on prioritizing work• Different POCs are being done for the growth of the project and the account – such as Social Media integration, Data mining and statistical analyzing on top of the data warehouse

Sri Lanka

Specialized DW/BI concepts, SSIS, SSAS, SSRS SharePoint• Develop ETL Jobs for different sections of the industry (Passenger feedback, Finance, Flight Operations and other aviation specific services)• Develop Cubes for enable advance analyzing of data• Develop Dashboards and reports• Design ETL/Cube/Dashboards/Reports• Documentation of the Details system technical document/ KPI Definition Document/ Report Definition Document• Unit testing on ETL/Cube/Dashboards/Reports using complex SQL/MDX queries• Visit client site to gather requirement/ Presentations and end user training• Perform knowledge transfer session to the piers • Pier reviews

Sri Lanka

• Develop SSIS Packages and write transform packages for the data migration from the old system to Virtusa proposed feedback system• Develop SSIS packages. write stored procedures and create cubes for the feedback solution• Develop dashboards and unit testing• Participate in requirement gathering session for the DW/BI stream• Documentation on KDDs and RDDs• Pier reviews • Research on Performance Point services on SharePoint 2010 and create dashboards to showcase the capabilities of each and every feature of SharePoint 2010• Develop Data warehouse generating the sample data on Airline domain• Project estimates on DWBI component of the project and the dashboards• Unit testing and documentation• InfoSphere Support administration which included user management, scheduling and ERP connector configurations• Maintaining/Tuning ETL Jobs• InfoSphere patch impact analysis, verifications and rollout

Bachelor'S Degree, Management Information Systems, General, Second Class Upper

Education record