Senior Systems Analyst
- Carried forward the design, coding and implementation of the safest of the recommended restructuring strategies using SQL Server 2008 R2. Used SSIS to import data from AS400 iSeries Equation database (the bank’s source data) and redeveloped the entire “Overnight Process” (gathering and computation of data downloaded from DB2 database for the core bank’s reporting system), using mainly stored procedures, triggers, UDFs, and tested for performance and integration of zero-impact on the remaining reporting system. This was successful with a performance increase, without exaggerating of 2400% !
- Designing various reports using SSRS to replace numerous reports.
- Developed web based systems, Hotel Management System (HMS), Technical Support System (TSS) and Staff Holiday Planner (e-planner) using ASP.NET/VB.NET 2008, .NET framework 3.5 and SQL-Server 2005 backend (stored proc./triggers using T-SQL).
- Developed an intranet system, Referral and Approval System (RAS), for Bank of Cyprus using ASP.NET/VB.NET 2005, .NET framework 2.0 and SQL-Server 2000 backend (stored proc./triggers using T-SQL).
- Developed the Warehouse Inventory Tracking System (WITS), an intranet system focused on automating Warehouse Inventory flows with barcode readers in order to provide inventory management in more efficient and controlled way. The system track Goods In, Goods Out, and Goods Moves along with checks/confirmations, exceptions and reports on shipments received and moved. ASP.NET/VB.NET/C#.NET 2005, .NET framework 2.0 and SQL-Server 2000 backend was the technology used.
Extra years of experience not listed above: None