Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Personal Information
Hobbies and Interests
Timeline
Generic

H.M. Asanka Hemachandra

Nawala

Summary

I am a well-qualified and experienced IT professional possessing high potential for working together with teams towards success. Expertise Knowledge and proven track record in BI, Data analysing, Data visualising and Data analytics remains my key competencies. Enabling Data driven decision making for the betterment and enhancement of business operations and, for the improvement of mode of operations, stands demonstrated highlights of my career. Further, experience in developing software solutions to cater common business practices using modern methodologies and technologies has enhanced my career scope. Thorough experience I have gained, over enterprise level software solutions such as ERP systems, enterprise HRM solutions etc. In scopes of business solution architecting, Implementation project management, analysing and visualising data to support decision making, analysing and modelling business requirements to match with IS functionalities and collaborating closely with different levels of system users, has uplifted my carrier to a better suited one for modern day business and technological challenges. Team playing played the utmost vital role, when I have to lead the successful Implementation of such business solutions, in sophisticated enterprise setups, with multiple wings globally and locally.

Overview

21
21
years of professional experience
1
1
Certification

Work History

Assistant Manager IT

Nortel International (Pvt) Ltd
05.2014 - Current
  • BI / Data Analyst / Data Analytics
  • Data Analyzing / visualising / BI/ Dashboards
  • Sales and operation forecast model
  • Financial Dashboards
  • HRM dashboards / KPIs / Skill matrixes
  • Test data analysis
  • Data Science / Machine Learning Models
  • Data ownership/ Data analysis / Data Security / Data modelling / Data migration and transformation.
  • Solution Architect /ERP Consultant / Application Consultant
  • Streamlined internal processes for increased efficiency through automation and workflow improvements.
  • Managed IT projects from inception to completion, ensuring timely delivery within budget constraints.
  • Developed and maintained comprehensive documentation for IT systems, policies, and procedures.
  • Collaborated with cross-functional teams to identify business requirements and align technology solutions accordingly.
  • Led and assisted technical upgrade projects for clients by working and coordinating with consultants and developers for integrations.
  • Enhanced data-driven decision-making by developing and implementing advanced business intelligence solutions.
  • Optimized data processing for faster insights by designing efficient ETL processes and data models.
  • Collaborated with cross-functional teams to gather requirements and create tailored BI reports for stakeholders.
  • Streamlined data analysis by creating customized visualizations, dashboards, and KPIs using BI tools.
  • Increased accuracy of forecasted trends by incorporating predictive analytics into business intelligence solutions.
  • Identified patterns and trends in complex datasets, enabling informed strategic decision-making for management.
  • Ensured data quality and integrity by implementing rigorous validation methods within the business intelligence framework.
  • Provided training to end-users on best practices for utilizing BI tools, increasing adoption across departments.
  • Developed a scalable business intelligence architecture to accommodate future growth and changing requirements.
  • Maintained proficiency with latest database technologies.
  • Monitored and optimized SQL server performance.
  • Handled massive quantities of business intelligence data, personally managing as much as [Number] terabytes.
  • Conducted data modeling, performance and integration testing.
  • Optimized data warehouse architecture, resulting in faster query response times and increased user satisfaction.
  • Developed custom ETL solutions to automate data extraction and transformation, reducing manual effort and human error.
  • Managed end-to-end development lifecycle of multiple BI projects, ensuring timely delivery within budget constraints.
  • Collaborated with stakeholders to define clear objectives and establish realistic project timelines, ensuring alignment with overall business goals.
  • Facilitated successful data migrations from legacy systems to new ERP platforms, maintaining data integrity throughout the transition period.
  • Provided ongoing support for clients after go-live, troubleshooting issues and delivering post-implementation enhancements as necessary.
  • Leveraged industry best practices in guiding clients through change management processes, fostering a smooth transition to new systems.
  • Developed comprehensive test plans and conducted rigorous testing activities to validate system functionality prior to deployment.

Senior Software Engineer

Nortel International (Pvt) Ltd
05.2008 - 05.2014
  • Job flow monitoring and incentive calculations
  • Quality management for manufacturing
  • Finish good, Packing and row materials handling
  • Automation of testing
  • Development of middle tire for system integrations
  • Enhanced software functionality by identifying and resolving complex technical issues.
  • Collaborated with cross-functional teams to design innovative software solutions.
  • Developed scalable applications using agile methodologies for timely project delivery.
  • Implemented robust security measures to protect sensitive data and ensure system integrity.
  • Integrated cutting-edge technologies into existing systems for enhanced functionality and user satisfaction.
  • Led architecture discussions, driving innovation in software design and implementation strategies.
  • Streamlined development workflows, increasing team efficiency and reducing time spent on repetitive tasks.
  • Managed multiple projects simultaneously while maintaining strict deadlines and high-quality standards.
  • Delivered exceptional client support by promptly addressing concerns and implementing requested changes or enhancements to software solutions.
  • Demonstrated experience and good hands-on programming experience C#. NE, Python and Angular.

Software Engineer

Nortel International (Pvt) Ltd
05.2004 - 05.2008
  • Improved software performance by identifying and resolving bottlenecks in the code.
  • Enhanced user experience with intuitive interface design and responsive web applications.
  • Collaborated with cross-functional teams to deliver high-quality software products on schedule.
  • Optimized algorithms for faster processing, reducing overall computation time.
  • Developed scalable and maintainable code, ensuring long-term stability of the software.
  • Streamlined development processes to increase efficiency and reduce production time.

Analyst Programmer

Pro Venture Technologies Pvt Ltd
03.2003 - 05.2004
  • Developed user-friendly interfaces that improved customer experience and increased product adoption rates.
  • Supported business growth by researching and implementing cutting-edge technologies into existing systems.
  • Provided exceptional customer support, resolving technical issues quickly and effectively for endusers.
  • Delivered high-quality software products on time by adhering to strict project deadlines and prioritizing tasks accordingly.


Education

M. Business Administration (MBA in IT) -

University of Moratuwa (Dept. of Computer Science Engineering)
01.2010

B.Sc -

University of Kelaniya
01.2003

Higher Diploma in Computer Based Information Systems -

National Institute of Business Management (NIBM)
01.2001

Diploma in Computer System Analysis and Design -

National Institute of Business Management (NIBM)
01.2000

Skills

  • In-depth understanding of how modern technology and applications can be put in place for the growth of business
  • Expert in architecting, designing and development of Business Intelligence and analytics solutions on top of ERP and other enterprise scale information systems
  • Exceptional skills in Data Warehousing, ETL, Business Intelligence, data models, data analysis, Data analytics, visualizing and Data Reporting Using Power BI, Azure services and other tools
  • Proficient in Implementing ERP, HRIS and other enterprise level IS / business solutions across Industries and have led many end to end implementation and upgrade projects
  • Specialized In Microsoft SQL and vastly experienced in Database design, Query optimization and tuning , schemas, indexing, keys, writing complex SQL scripts and Stored Procedures, Cloud Databases, database design techniques, working with structured and non-structured data, SSIS, SSRS and even backups and data transferring tools
  • Excellent communication and presentation skills with Stakeholder Engagement Skills and ability to collaborate with different levels of stakeholders including end users
  • Profound ability to understand the expectations of different business domains, for deriving, architecting and implementing solutions and expertise in project documenting (BSD, Gap Documents, test plans, User manuals etc)
  • Knowledge in Cloud Database management and configurations and well experienced in DB Performance, Cost Optimization, Multiregional, Scalability, Replication, and Security concepts
  • Expertise in entire software development lifecycle (SDLC) activities including documenting and testing and familiar with agile development practices
  • Exceptional project management and solution developing skills with the ability to manage multiple priorities within targeted timeframes
  • Well experienced in enterprise data architecture concepts, data governance and setting up data driven decision making process to enhance business operations
  • Formulating and implementation of IT policies and procedures to comply with business continuity goals and with requirements of the regulatory bodies
  • ISO certified systems auditor for ISO 9001: 2015 & ISO 14001: 2015
  • ERP and Enterprise software solution consultant
  • Business solution architecting
  • Project management
  • IT leadership, strategies
  • IT policies and Planning
  • Process improvement and automation
  • Full stack software development
  • Solution Design and architect
  • Software Project Documentation
  • Development of test cases and testing
  • Mange development and implementation teams
  • Business Intelligence
  • Data analysis and visualization
  • Data warehousing, data cleaning, Standardising and data modelling
  • Data analytics , ML
  • Data governance and security
  • Statistical Analysis
  • On Prem And cloud services
  • Power BI
  • SQL
  • SSRS
  • SSIS
  • Python
  • ETL
  • Azure infrastructure
  • Azure Data Factory
  • C#Net
  • Azure Synapse Analytics
  • Azure DataBricks
  • Apache spark
  • Scala
  • MS excel
  • Data warehouse
  • DAX
  • SharePoint
  • Crystal Reports
  • ERP
  • Infor ERP
  • HRM
  • EAM
  • VBNET
  • Data Modelling
  • Data Profiling
  • Data Mapping
  • PL/SQL
  • AWS
  • Agile Methodologies
  • System Integration
  • Application Support
  • Data Analytics

Certification

Microsoft DP-500 - Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

Languages

English & Sinhala

Personal Information

  • Date of Birth: 04/17/77
  • Marital Status: Married

Hobbies and Interests

Cricket, Travelling, Music

Timeline

Assistant Manager IT

Nortel International (Pvt) Ltd
05.2014 - Current

Senior Software Engineer

Nortel International (Pvt) Ltd
05.2008 - 05.2014

Software Engineer

Nortel International (Pvt) Ltd
05.2004 - 05.2008

Analyst Programmer

Pro Venture Technologies Pvt Ltd
03.2003 - 05.2004

M. Business Administration (MBA in IT) -

University of Moratuwa (Dept. of Computer Science Engineering)

B.Sc -

University of Kelaniya

Higher Diploma in Computer Based Information Systems -

National Institute of Business Management (NIBM)

Diploma in Computer System Analysis and Design -

National Institute of Business Management (NIBM)
H.M. Asanka Hemachandra