Nilanka Samarasinghe

Background

About Nilanka Samarasinghe

Highly analytical and process-oriented Business Intelligence Engineer with 8+ years experience in interpreting and analyzing data to enable evidence-based decision-making and support to drive successful business solutions. • Possess a Bachelor’s (Information Technology), professional certifications, courses (Designing BI Solutions with MS SQL Server 2012, Introduction to Analytics and Big Data, Oracle Database SQL Expert) and reading for Data Science certification program at Sheridan College, Canada. • Hands full experience in collaborating with senior decision-makers, business stakeholders, internal stakeholders to understand the business requirement, creating and documenting detailed technical specifications and designs. • In-depth knowledge of data modeling and mapping; and design using UML, Lucid chart • Well versed with RDBMS (MS SQL, Oracle), Data Warehouse concepts, Data Modeling, ETL development (SSIS), data cleansing, data quality testing, finally creating analytical reports and interactive dashboards.(Power BI, Excel Power Pivot, Power View, SSRS, Cognos). • Proficient in developing BI solutions with Microsoft suite of products: SQL Server, SSIS, SSAS, SSRS. • Reviewing solutions and code and ensuring the delivery of quality products. • Highly proficient in writing complex TSQL/ PLSQL code to pull data from multiple transactional sources. • Proficient in Microsoft Office/Excel/ Bash Scripting, Linux environments • Experience in driving development through Agile/ Waterfall software development practices (Scrum, Kanban) and familiar with Jira and Confluence for effective project management. • Ability to work in a fast-paced environment and deal with challenging issues, meet tight deadlines • Experience on a timely escalation of production incidents and troubleshooting to support business 24 *7. • Ability to work independently with minimal supervision as well as within a team environment. • Excellent communication, analytical, interpersonal, and presentation skills; expert at managing multiple projects simultaneously.