Udari Pathirannehe Email & Phone Number

Västerås, Vastmanland County, Sweden

Finland

Develop interactive and visually compelling reports and dashboards using Power BI in Azure environment, Power Query and Dax to visualize trends and KPIs’ to stake holders. (Production disturbances, operations and maintenance, Balance sheets, income statements, etc.)Gather and structure the data related requirements from different departments of the organization by facilitating effective communication with departments and working close with the stake holders. Design and implement SQL queries to extract data from relational databases and carry out cleaning and transformation.Collaborate with cross functional teams from Sweden, Finland, Ukraine, and Bangladesh to gather, process, and analyze different data from production operations.Enhance existing BI systems by continuous improvements and using industry best practices and new technologies. Identify root causes for underlying issues and provide production support for issues from cross functional teams.

Borlänge, Dalarna County, Sweden

*An analysis of the housing market in Västerås and Börlange based on Hemnet website.Automated the data mining process using web scraping tools Beautiful Soap, Selenium and JSoup in IntelliJ to gather data into csv files.Data cleaned and processed using Python Pandas in Jupyter Notebook.Designed the data model according to cleaned data set and the requirements.Developed interactive and visually compelling dashboard using Power BI with DAX, Power Pivot, and Power Query.Presented findings and suggestions to senior tech lead through clear and concise data visualizations and presentations.*An analysis on production process of French Nuclear Power Plants.Designed the dimensional data model according to star schema for cleaned data set.Automated the data transform pipeline (the data extraction, transformation, and loading) (ETL) using SSIS (SQL Server Integration Services) and Power Query.Developed interactive and visually compelling dashboard using Power BI with DAX, Power Query, Power Pivot.Analyze the data and presented findings and suggestions to senior tech lead through clear and concise data visualizations and presentations.*An analysis of Programming languages usage in GitHub.Utilized data workflows and processes using python, Pandas, in Jupyter Notebook to automate extraction of data from CSV files, clean and, transform them to SQL Server database.Designed the implemented a star schema dimensional data model according to star schema for cleaned data set to achieve comprehensive analysis.Developed interactive and visually compelling dashboard using Power BI.Analyzed the data and presented findings and suggestions to senior tech lead through clear and concise data visualizations and presentations.

Sri Lanka

GoWireless - An application to handle the mobile devices insurance process.Served as a tech lead for a team of 5 software engineers, guiding the development process and ensuring successful project implementation.Created a Logic App in conjunction with an on-premises data gateway to process newly created files, save them to blob storage and clean up the source directory.Designed, developed, and maintained scalable web-based solutions using .Net core, Azure cloud solutions and Microsoft SQL Server including stored procedures, schema diagrams, Functions, and joins, etc. ensuring reliability and security.Utilized Agile methodologies for project management in the team including JIRA, sprint planning, daily stand-ups and achieved project goals within planned timelines.Implemented cloud-based solutions using Microsoft Azure including Azure Logic Apps, Azure storage (Blob), Azure SQL Server and achieved availability, and reliability.Used GitHub for version control, project hosting, code repositories managing, branches and pull requests managing effectively. Achieved continuous integration and continuous deployment (CI/CD) pipelines using GitHub Actions, build automation tests, and deployments for development workflows.Prepared developer test cases and carryout end to end testing using methodologies including unit testing, integration testing and functional testing and carried out API testing using PostMan and Soap UI.Collaborated with business stakeholders to gather requirements, define technical design, confirm the objectives, and deliver the business solution. Conducted code reviews and provided technical guides to the team members according to best practices and coding standards.

Sri Lanka

Vodafone Group Plc - A project to migrate legacy system data in to online.Led a team of 3 software developers in designing, developing, and maintaining the desktop solutions using C#.Net and SQL Server by achieving reliability and speed.Implemented a solution to migrate on premises data files to Share Point online and create a tracing system to show the progress in Power BI dash boards.Worked as a business analyst parallelly with the developments by facilitating communication and collaboration between business stakeholders and technical team throughout the project. Prepared developer test cases and carryout end to end testing using methodologies including unit testing, integration testing and functional testing. Prepared technical documentation for the software development project requirements to ensure delivering stake holders expectations by attending requirement clarification meetings.Prepared and delivered presentations to the stake holders by communicating findings and the progress of the projects for further decisions.*Health Care Solutions - Internal Project An in-house project on full Health Care Solution from registering the patient to discharging from the hospital. Designed, implemented, and maintained Pega applications including business process automation, data models, workflows, user interfaces, integrations between Pega platform tools with SQL and other technologies.Participated in all the phases of software development life cycle from requirement gathering to deployment.Used GitHub for version control, project hosting, code repositories managing, branches and pull requests managing effectively. Achieved continuous integration and continuous deployment (CI/CD) pipelines using GITHub Actions, build automation, test, and deployment for development workflows.Utilized Agile methodologies for project management in the team including JIRA, sprint planning, daily stand-ups and achieved project goals within planned timelines.

Western, Sri Lanka

*Tele Interview Processing System/ CAS Production Support A system to provide all the facilities from taking a call from a customer to paying out all the benefits to the customersDesigned, implemented, and maintained Pega applications including business process automation, data models, workflows, user interfaces, integrations between Pega platform tools with SQL and other technologies.Designed and implemented the front end of the web site using HTML, CSS, Java Script, and Regular Expression (RegEx).Participated in all the phases of software development life cycle including requirement gathering, design, develop, test, and deploy.Used GitHub for version control, project hosting, code repositories managing, branches and pull requests managing effectively. Achieved continuous integration and continuous deployment (CI/CD) pipelines using GitHub Actions, build automation, test, and deployment for development workflows.Prepared developer test cases and carryout end to end testing using methodologies including unit testing, integration testing and functional testing. Utilized Agile methodologies for project management in the team including JIRA, sprint planning, daily stand-ups and achieved project goals within planned timelines.Collaborated with business stake holders for requirement gathering, business process analyzing and defining solution architect. Contributed to the documentation of technical specifications and user manuals to transfer the knowledge to the customer.

Master'S Degree, Data Science

I received university scholarship for outstanding educational endeavours for my master's studies.

Bachelor'S Degree, Management Information Systems, Special, First Class

Education record