Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sameera Dodanthenna

Lead SQL Developer
Angoda

Summary

Dedicated Database professional with history of meeting company goals utilizing consistent and organized practices. Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.

Experienced in Database Development with over 11 years of experience in Database Development. Excellent reputation for resolving problems and improving customer satisfaction. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

11
11
years of professional experience
5
5
years of post-secondary education
2
2
Languages

Work History

Lead SQL Developer

Rusada
Colombo
04.2022 - Current
  • Exceeded goals through effective task prioritization and great work ethic.
  • Demonstrated respect, friendliness and willingness to help wherever needed.
  • Offered friendly and efficient service to customers, handled challenging situations with ease.
  • Onboarded new temps by entering employee information into systems.
  • Delivered services to customer locations within specific timeframes.
  • Used critical thinking to break down problems, evaluate solutions and make decisions.
  • Worked with customers to understand needs and provide excellent service.
  • Proved successful working within tight deadlines and fast-paced atmosphere.
  • Worked flexible hours across night, weekend and holiday shifts.
  • Prepared variety of different written communications, reports and documents.
  • Saved Money by implementing cost-saving initiatives that addressed long-standing problems.
  • Created plans and communicated deadlines to complete projects on time.

ASSOCIATE TECHNICAL LEAD

CAMMS MANAGEMENT SOLUTIONS
Colombo
01.2022 - 06.2023
  • Presented business leaders with ROI estimations to drive project planning.
  • Researched and adopted new technologies to add value to existing offerings.
  • Improved systems with addition of new features and infrastructure.
  • Developed technical requirement documentation for new software products.
  • Developed diagrams to describe and lay out logical operational steps.
  • Managing 5-member Team
  • ETL
  • Presented business leaders with ROI estimations to drive project planning.
  • DB Warehousing
  • Developed Complex Dataset
  • Developed Complex reports
  • Modify databases according to requests and perform tests.

SENIOR SOFTWARE ENGINEER

CAMMS MANAGEMENT SOLUTIONS
Colombo
03.2020 - 10.2022
  • Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance.
  • Trained and mentored junior developers and engineers, teaching skills in SSRS,SSIS,SQL and working to improve overall team performance.
  • Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
  • Provided technical support using knowledge of complex technology to solve problems and support new projects.
  • Worked with project managers, developers, quality assurance and customers to resolve technical issues.
  • Introduced agile methodologies and development best practices to division to enhance product development.
  • Analyzed proposed technical solutions based on customer requirements.
  • Developed Complex Dataset
  • Developed Complex reports
  • Modify databases according to requests and perform tests
  • Modify databases and products as per clients' specifications
  • Re-optimizing the existing and new database structure
  • (Query Optimization, Re Indexing)
  • Design stable, reliable and effective databases and datasets
  • Develop technical and training manuals
  • Data Integration Project with SSIS.

SENIOR DATABASE DEVELOPER

CONTENT MANAGEMENT AND SOLUTIONS
11.2018 - 03.2020
  • CMS provides a broad range of IT consulting, IT professional offshore sourcing services to the
  • Belgium and US Clients
  • RESPONSIBILITIES
  • Modify databases and products as per clients' specifications
  • Re-optimizing the existing and new database structure
  • (Query Optimization, Re Indexing)
  • Developed and sharing the complex data-sets with Developers
  • Design stable, reliable and effective databases
  • Optimize and maintain legacy systems
  • Modify databases according to requests and perform tests
  • Solve database usage issues and malfunctions
  • Liaise with developers to improve applications and establish best practices
  • Gather user requirements and identify new features
  • Develop technical and training manuals
  • Provide data management support to users
  • Ensure all database programs meet company and performance requirements
  • Research and suggest new database products, services and protocols
  • Developed Complex reports
  • Managing and Maintaining Customer database
  • (permissions, recovery, security and monitoring)

SENIOR IMPLEMENTATION ENGINEER

HSENID BUSINESS SOLUTION
01.2016 - 11.2018
  • Worked with technical staff on system audit to execute implementations on time and within functional parameters.
  • Assisted clients with monitoring all software implementation lifecycles.
  • Configured and executed system software changes.
  • Inspected changes before client performed user acceptance testing.
  • Built databases and table structures for web applications.
  • Designed and developed analytical data structures.
  • Loaded baseline security data to client databases.
  • Created statistical reporting policies and procedures currently serving as optimal performance benchmarks.
  • Wrote SQL scripts for daily maintenance, indexes and tables analyses.
  • Conducted data modeling, performance and integration testing.
  • Tuned systems to boost performance.
  • Documented software development methodologies in technical manuals to be used by IT personnel in future projects.

IMPLEMENTATION ENGINEER

HSENID BUSINESS SOLUTION, Sameera Pradeep Dodanthenna
Colombo
01.2014 - 01.2016
  • Implement hSenid HRIS to Client Environment
  • Assisted clients with monitoring all software implementation lifecycles.
  • (On-Premise, Cloud)
  • Managing Customer Requirements, and deployed the changes from Database level
  • (SQL/ Oracle)
  • Managing and optimization customer Database
  • (SQL/ Oracle)
  • Create functional requirements, and reports on databases
  • Designing and sharing various data set with client
  • Perform analysis on gathered data
  • Create Oracle MSSQL Tables, Indexes etc
  • Organize and improve functionality of data
  • Created statistical reporting policies and procedures currently serving as optimal performance benchmarks.
  • Loaded baseline security data to client databases.
  • Inspected changes before client performed user acceptance testing.
  • Developed and maintained courteous and effective working relationships.

Education

Bachelor of Science - Software Engineering

Cardiff Metropolitan University
Sri Lanaka
01.2014 - 08.2016

High School Diploma -

Edexcel International – UK
Sri Lanka
01.2012 - 01.2014

Skills

Data Warehouse

undefined

Timeline

Lead SQL Developer

Rusada
04.2022 - Current

ASSOCIATE TECHNICAL LEAD

CAMMS MANAGEMENT SOLUTIONS
01.2022 - 06.2023

SENIOR SOFTWARE ENGINEER

CAMMS MANAGEMENT SOLUTIONS
03.2020 - 10.2022

SENIOR DATABASE DEVELOPER

CONTENT MANAGEMENT AND SOLUTIONS
11.2018 - 03.2020

SENIOR IMPLEMENTATION ENGINEER

HSENID BUSINESS SOLUTION
01.2016 - 11.2018

Bachelor of Science - Software Engineering

Cardiff Metropolitan University
01.2014 - 08.2016

IMPLEMENTATION ENGINEER

HSENID BUSINESS SOLUTION, Sameera Pradeep Dodanthenna
01.2014 - 01.2016

High School Diploma -

Edexcel International – UK
01.2012 - 01.2014
Sameera DodanthennaLead SQL Developer