Amber Hasham

• Managing core Hospital Management Information system of AFIC, Pindi by providing all rounded application development and support using Oracle/PLSQL. • Providing solution for multi-location based HIS system all over Pakistan in the module of Cardiology • Producing high quality code by writing backend procedures, functions, triggers, packages, views, complex data structures, object oriented database models etc. • Backend query optimization • Development of new forms(table, views and procedure based) and reports of various modules of HIS using either oracle 6i, 10g or 11g • Converted successfully application’s major modules into 11g from 6i version and implemented the system all over Pakistan • Front end and back end code management for various modules of AFIC like OrderEntry, PhysicianMenu, MMS, Library, Cardiology, Registration, Pharmacy, Surgery, etc • Responsible for smoothly functioning of Donation Management System at Namal Education Foundation. • Involved in development of web based collection center information system of the hospital • Modification of existing application functionality by changing front-end and back-end objects • Development of automated unit test cases to validate defect-free code • To create processes and procedures with input from business teams, development, and IT Support • Utilizing design patterns that comply with security policies and guidelines • Managing and completing full life cycle projects around all Oracle activities

• Development and maintenance of the Investment Management product, AssetConnect, using very high level of PL/SQL programming Database Triggers, Stored Procedures, Views, Sequences, Forms, Reports etc. • Performed ASP.NET and C# development, using SQL Server as backend database for the web portals Elearning portal and ExamConnect. Coded business objects, web services, etc. and designed front-end screens using javascript, html, CSS, xml, photoshop, infragistics for various modules. • Maintaining the documentation to support the team and business. • Responsible for the fixation of the errors in data by utilizing the GUI interface of application and SQL scripting. • Designed database tables, stored procedures, functions and triggers in SQL Server 2005 and Orcle. • Produced detailed level design documents. • Performed unit testing for the scripts.