SSRS SSIS Developer
Resume:
Nihal Mallankanda Apt * **** Keele St. North York ON M3M 2H2
*************@*****.**
A Challenging Position as a SSIS/SSRS Developer.
OBJECTIVE:
PROFILE:
• Architect and technical lead for web applications and database developments
• 8 years of system design and development experience with extensive business
knowledge in financial applications with Object Oriented Programming Concepts and
database development with success in every area of endeavor
• Demonstrated leading edge skills relevant to the software development constantly
evolving requirements including design and implementation of databases, complex
problem solving, customized software applications, and verification data as required
SUMMARY
• SQL Server 2005 and 2008 – 8 Years
• Stored Procedures – 8 Years
• SSIS and SSRS – 8 Years
• ASP.NET – 6 Years
• C# - 6 Years
• ADO.Net – 6 Years
• .Net Framework and Visual Studio 2010 – 6 Years
• Object Oriented Programming – 6 Years
• HTML, HTML5, CSS – 6 Years
• JavaScript, XML – 5 Years
• Crystal Report - 6 Years
• Web Services – 2 Years
PROFESSIONAL EXPERIENCE:
Scienter Technologies Colombo
Software Developer 2009 February to 2014 March
•Project: Saving banking system integrated with ATM
This is a web based solution for day to day savings transactions like counter
withdrawals, deposits, executing pre authorized payments, executing reports against all
transactions, passing data to account system. Backend is intergraded with the ATM
listener console application. I was the system architect and main developer with another
three developers. System design, database design, test cases were developed by me.
ASP.Net 4.0, C#, Web Services, SQL Server 2008 R2, SSIS, JavaScript, Crystal Report,
Ajax and Telerik controls were used to develop this system.
1
•Project: Fixed Deposit banking system integrated with saving system
Web based solution is for banks who have their customers to make deposit for long
period. It includes deposits, withdrawals, pre mature withdrawals, cheque realization,
cheque cancellation, teller handling, auto renewals, Interest processing and transferring
interests to saving system. I designed and developed almost all of modules except
some reports modules usingASP.Net 4.0, C#, SQL Server 2008 R2, SSIS, SSRS,
JavaScript, Crystal Report, Ajax and Telerik controls.
•Project: ATM listener console application.
This is a multi-thread windows service console application developed to capture ATM
requests coming through an ATM machine. It handles withdrawals, balance requests;
accounts detail requests, withdrawal reversals. Technology behind this application is C#
and SQL Server 2008 R2. I was responsible for developing this whole application.
•Project: Personal Loan System
This is a web based complete loan management system. This allows to customers to
get a loan with a security deposit. It includes auto loan, mortgage loan and gold loan.
This huge system was developed by 4 developers including me. I was the main
developer and technical lead. I did most complex modules like auto setting off,
receipting, loan granting and approvals. Used ASP.Net 4.0, C#, SQL Server 2008 R2,
SSIS, SSRS, JavaScript, Crystal Report, Ajax and Telerik controls.
•Project: Integrated Account system.
Integrated Account System is a complete account system integrating Saving, Fixed
Deposit and loan systems for bank’s accounts department, also includes all functions
like general receipts, general cash/cheque payments, journals, standard journals.
Trial Balance, P &L (Profit and Loss) and Balance Sheet were automated reports and
can be generated at any time. Database is getting updated online and all teller details
are visible to the management. Used ASP.Net 4.0, C#, SQL Server 2008 R2, SSIS,
SSRS, JavaScript, Crystal Report, Ajax and Telerik controls.
OneTouch Direct St Catharine’s, Ontario
Software Developer 2004 October to 2009 February
•Project: Sale Processing and report generating.
I was responsible for processing marketing data into SQL Server 2005 and generated
Excel reports for more than 46 sales projects for CIBC, Verizon, BMG Music,
EarthLink and Centex. I designed and developed all back ends writing complex
stored procedures and developing complex SSIS for automating FTP data
downloading and daily Excel reports. SQL Server 2005, VB.Net and C# were used.
•Project: TMobile admin and online reporting application.
TMobile admin is an online application that allows to the management to check sales
status and generate sales related reports. Employees can requests leaves and
vacations through TMobile admin and then must be approved by the management.
ASP.Net 3.5 and C#, SQL Server 2005 and SSRS were used to develop this system.
I developed all modules coordinating with software manager.
•Project: Automated QA Process
I was responsible to design and implement data verification process for all sales data
coming through outsource venders. This includes very complex stored procedures
running very fast to very data file. It loads the file to SQL Server and process the
data. SQL Server 2005and VB.Net were used for this.
Mind Management Consultancy Ltd Toronto, Ontario
Software Developer 2002 May to 2003 December
• Utilized Visual Basic 6.0, Crystal Report and SQL Server 2000 to create a
Membership Administration Database that featured flexible reporting capabilities, well
organized screen windows, navigation and well-structured data entry functions.
Electricity Board Colombo
Programmer Analyst 1999 February to 2002 March
• Utilized Informix, Visual Basic 6.0, Classic ASP and Crystal Report to design, develop
and implement a Heavy Supply Billing and Point of Sale database applications.
.
EDUCATION:
Seneca College Toronto, Ontario
Database Application Developer Post Graduate Diploma 2004
University of Colombo Colombo, Sri Lanka
Post Graduate Diploma in Computer Technology 1997 to 1998
University of Colombo (1st class honors) Colombo, Sri Lanka
Bachelor of Science Degree in Computer Science 1992 to 1996
Certifications
Oracle Certification (first 2 exams)
Microsoft .NET Certification (only 70-728)
REFERENCES: Available upon request
3
Contact this candidate