Software Development Ms Sql
Resume:
Kasun Dhananjaya
Athurugiriya, Western Province, Sri Lanka
********@*****.***
linkedin.com/in/kasun-dhananjaya-a1ab771b
Summary
I have almost 15 years of experience in solution designing, solution developing, Data Analytics, BI Dashboard Designing, Report Designing, SQL querying, DBMS, Development banking and finance systems, Health Management Systems, and Title Insurance Systems.
Roles and Responsibilities:
•Analyzing system users' and management staff's new requirements and designing solutions
•MIS reports designing and development.
•Developing and maintaining online dashboards.
•Developing and maintaining system APIs for payment gateways and other systems.
•Maintaining a computerized general ledger.
•Managing Progress/ OpenEdge, Ms Sql databases.
•Automation of business processes (Batch Processing).
Programming Languages: Progress Openedge 4GL 9 - 11.7 (GUI, PASOE, WebSpeed, ADM2) Methodologies: Agile, Waterfall
Database: OpenEdge, Progress, MySQL, MS SQL, Oracle
Tools: Appbuilder, OpenEdge Developer Studio, Netbeans, Visual Code Version Control Tools:- Bitbucket, Git, Tortoise SVN
Project Management Tools:- Version one, Task Portal
OS: Windows
Experience
Senior Consultant
JK Tech
Feb 2022 - Present (1 year 2 months)
•Member of one of the software development teams - Greenway Health Project (Cashkings). Requirement Analysis.
Development and work with code review comments. Update Confluence pages.
•Member of the software development team - Alliant National Title Insurance Project
Get the requirement, Develop, code testing, respond to code reviews, and commit to BitBucket.
as the recent assignment actively participated to convert server-side procedure files to class files and tested them with Postman.
•Participated Trainings: - Advanced OpenEdge development, Angular, Node.Js
Associate Architect
Abans Finance PLC
Apr 2016 - Feb 2022 (5 years 11 months)
•Analyzing system users' and management staff's new requirements and designing solutions
•MIS reports designing and development.
Daily Collection Reports (Branch wise, Product wise, Officer wise, Arrears Bucket wise). Marketing Reports (Branch wise, Product wise, Officer wise).
Daily impairment reports (Branch wise, Product wise, Arrears Bucket-wise).
Call Center's performance monitoring report (Branch wise, Officer wise, Arrears Bucket-wise).
•Developing and maintaining online dashboards with BIRD tool.
Daily Collection Reports (Branch wise, Product wise, Officer wise, Arrears Bucket wise). Marketing Reports (Branch wise, Product wise, Officer wise).
Daily impairment reports (Branch wise, Product wise, Arrears Bucket-wise).
Call Center's performance monitoring report (Branch wise, Officer wise, Arrears Bucket-wise). File activation timeline-related dashboards.
•Developing and maintaining system APIs for payment gateways and other systems.
•Maintaining a computerized general ledger.
Identified and corrected front-end and back-end differences.
•Managing Progress/OpenEdge, MS SQL databases.
•Automation of business processes.
Developed and monitored APIs to update daily and monthly status to dashboards. Daily MIS reports processing and emailing to relevant parties.
Automated file activation workflow.
Designed, developed, and implemented CR reports monitoring system. Designed, developed, and implemented customer files monitoring system.
•Batch process and scheduled tasks.
Daily process for update the arrears status of Leasing and Loan facilities and API to transfer those data to MS SQL database (BI dashboards, Mobile app).
Batch process to generate moratorium loans for given list of leasing and loan facilities.
Analyst Programmer
Singer Finance
Apr 2015 - Apr 2016 (1 year 1 month)
•Analyzing system users' and management staff's new requirements and designing solutions.
•MIS reports designing and development.
•Maintaining a computerized general ledger.
•Maintaining and monitoring the DR server.
•Managing Progress/OpenEdge databases.
•Done a version upgradation of the system Progress 9.1D to OpenEdge 10.2B.
•Monitored the automated system EOD processes.
IT Executive - Senior OpenEdge Developer
Merchant Bank of Sri Lanka & Finance PLC
Jun 2012 - Mar 2015 (2 years 10 months)
•Member of the team of software development and maintenance of the Core banking system (Leasing, Savings, Hire Purchases, Fixed Deposits, and General Ledger).
•Analyzing system users' and management staff's new requirements and designing solutions
•Managing OpenEdge Database
•Managing System EOD, EOM, and Annual processes
•Designed, developed, and implemented an SMS reminder-generating process
•MIS reports designing and development.
•Maintaining a computerized general ledger.
•has Been an active member of the Data migration team.
Senior Programmer - OpenEdge Development
OpenArc Systems Management (Pvt) Ltd.
Nov 2008 - Mar 2012 (3 years 5 months)
•Developing programs for given requirement specs.
•Onsite coordination and system maintenance support
•Planning and coordinating data migration processes
Education
ANC - NetAssist International
MS 20486 C: Developing ASP .NET MVC4 Web Applications, Computer Software Engineering
Jan 2019 - Jun 2019
Successfully completed theory and practical course.
Openarc School of Business and Technology
Industrial Diploma in Software Development, Computer Software Engineering
Feb 2008 - Nov 2008
It is all about Software Development using Microsoft.Net, JAVA, PHP, Progress MSSQL, and MySQL Object Oriented Concepts and Good Practices
Management Information Systems with System Analysis and Design Microsoft Office Applications
Computer Science Business English
Vocational Training Authority of Sri Lanka
Computer Applications Assistant, Computer Software and Media Applications
Aug 2006 - Jun 2007
K72S003U01 - Use the computer and manage files within the standard operating system. K72S003U02 - Perform word processing.
K72S003U03 - Prepare spreadsheets.
K72S003U04 - Prepare computer-aided presentation resources. K72S003U05 - Set up and use databases.
K72S003U06 - Perform internet and electronic mail operations.
Karandeniya Central College
GCE AL, Business/Commerce, General
1993 - 2006
Business Studies - A Accounting - B Economics - C General English - S
Licenses & Certifications
SSMI PwC Certificate in Business Process Excellence (CBPE) - Dr. Mikel J Harry Six Sigma Management Institute Asia
Skills
Git BASH · ARC · Bitbucket · Sourcetree · Business Process · Confluence · API Development · Postman API · Angular · Node.js · Operating Systems · AngularJS · Cascading Style Sheets (CSS) · Computer Science · SQL · Databases · Microsoft Office · Software Development Life Cycle (SDLC) · Software Development · OpenEdge · Progress 4GL
Non-related Referees
Mr. Nuwan Priyadarshana,
Technical Architect,
JKTech, Orion City,
Dr. Danister De Silva Mw,
Colombo 09,
Sri Lanka.
Mobile:- +94-71-534-****
Mr. Nalaka Hettiarachchi,
Senior Consultant,
JKTech, Orion City,
Dr. Danister De Silva Mw,
Colombo 09,
Sri Lanka.
Mobile:- +94-77-768-****
Contact this candidate