Developer Sql Server

Pahan R. Bentota Mahakumara

** ****** ** **** ******** West New York, NJ 07093 917-***-**** ***************@*****.***

Application/database Developer

SUMMARY OF QUALIFICATIONS

Over 8 years of experience designing, developing and supporting corporate tools and applications, including lease lifecycle management, US and foreign finance accounting systems and billings.

Apply in-depth understanding of business and IT requirements to streamline administrative and internal processes, resulting in enhanced automation and operational efficiency.

Manage multiple projects simultaneously.

Learn and apply new technologies quickly.

Expert knowledge of multiple programming languages, including C++, C#, ASP, PHP and Visual Basic.

Good communication, presentation, analytical, and problem-solving skills.

SKILLS

Technologies/Languages: T SQL/SSIS/ Classic ASP/VB6/PHP/Java Scripts/HTML/CSS

.NET/CodeIgniter/C++/C#/ SVN

Databases: SQL Server 2005, 2008R2, 2012/ MySQL/ Microsoft Access

Tools: SSMS/BIDS/OutSystems/PhpMyAdmin/Visual Studio/Aptana Studio/Atom

PROFESSIONAL EXPERIENCE

HPE Financial Services/HP/HPE/DXC: 2013-Present

Senior Application Developer/Tech Lead

Over 4 years of experience in working with HPEFS lease lifecycle management application (Pyramid).

Tech lead and individual developer of multiple local finance accounting book/general ledger projects including Brazil, Peru, Argentina, Indonesia and Ireland accounting systems.

Identified various bugs/defects on existing finance accounting books and took initiatives to fix them.

Designed and implemented ACH (Direct Debit) file processing between HPFS and Bancomer (Mexican financial institution).

Managed production support, ongoing releases and innovation works simultaneously.

Lead training and transitioning of production support of applications from US to offshore.

Experienced and successfully adapted to major organizational changes including company split from HP to HPE, and later transformation to DXC.

Successfully migrated all of India portfolios to follow recent India GST tax treatment.

Air Sea Land Shipping & Moving Inc.: 2011-2013

Application Developer

Designed and developed an open source solution for company’s limousine department to manage customers, drivers and reservations using PHP/MySQL.

Rewrote the limousine application using Codeigniter framework with mobile compatibility and integrated account receivables and payables along with invoice PDF creation.

Designed and personalized complex reports for company’s limousine department.

Wrote customer shipment tracking system with mobile compatible back office and a customer dashboard with automated shipment updates for easy tracking.

Softwave Printing and Packaging (Pvt) Ltd: 2010-2011

Jr. SQL Server Developer

Modelled client/vendor contracts from MS Excel/Access to MS SQL Server to support brand-new back office application.

Developed SQL queries for application backend support and custom reports.

Created checks and constraints to ensure data integrity across databases.

Developed ETL processors using SSIS.

Improved application performance by monitoring and tuning queries using SQL Server Enterprise Manager and Query Analyser tools.

Created stored procedures and functions to support efficient data storage and manipulation.

Designed flow charts and data flow diagrams for upper management usage in business analytics and finance control.

EDUCATION

Bachelor of Science in Computer Science, College Of Staten Island NY (2012)

Contact this candidate