Senior Software Engineer
Dubai Statistics Center
Total years of experience :18 years, 6 Months
• Projects:
o Household Expenditure Survey System: Redesigned and implemented the solution from Legacy ASP.NET 2.0/Oracle System to SPA App with offline mode for windows tablets and developed a WCF for Mobile App Consuming and Bi-Directional Data Synchronization.
o Financial Reports System.
o Labor Force Survey System (with online/offline mode).
o E-Sources (DSC Solution for Customers and Partners Data Collection Reporting): Users Management Module.
o Developed Proof Of Concepts (POC):
Master Data Management (MDM) Customized interface using MS SQL Server Master Data Services 2012 and ASP.NET MVC.
Lime Survey ETL to convert OLTP LimeSurvey Tables to OLAP structure.
IBM Cognos 8: Package Generation Automation for LimeSurvey using ASP.NET MVC, XML AND SSAS 2012 OLAP Cubes.
Designing a Dashboard Prototype for Labor Force Survey KPIs using QlikView and Power BI Desktop.
• Responsibilities:
o Involved in complete life cycle including Requirement Gathering, Analysis, Design, Development and Testing.
o Designing and developing web based solutions and SPA Applications with Offline-Online mode using ASP.NET MVC5/SQL Server20012/Oracle11 and Bi-Directional Data Synch for windows tablets(Technologies used: Microsoft Sync Framework, WCF).
o Designing the Relational and Dimensional Models (Snowflake and Star schemas) to support the requirements for Business Intelligence and reporting tools.
o Created IBM Cognos Metadata Models, Packages and Reports using Cognos Framework Manager and Report Studio.
o Designing and Developing ETL process (SSIS packages), Data Integration, Data Analysis, Data Validation, Data Cleansing, Data Verification and Identifying Data mismatch suing TSQL and PL/SQL.
o Involved (working closely) with systems end-users, business analysts and technical staff to translate complex business requirements into effective reporting solutions.
• Involved in the non-ERP HR system enhancements:
o Total Rewards Module.
o Warning Module.
o Educational Benefits System Module.
• Development of change requests of the non-ERP HR system and other web based applications for HR using ASP.NET(C#/VB.NET), PL/SQL, Crystal Reports, and HTML/CSS/JavaScript.
• Developing of SharePoint 2010 Collaborative Intranet Portal:
o Gathered and analyzed SharePoint project requirements.
o Installed SharePoint 2010 on Windows 2008R2 VM in Windows Azure.
o Customizing Master page using SharePoint Designer 2010.
o Creating Portal site, site collections, custom lists, document libraries, and media library.
o Creating Custom web parts using Visual Studio 2010.
o Developing SharePoint Approval and Review Workflow using SharePoint Designer 2010.
o Configured Business Catalog Services (BCS) to read the external data from MS SQL Server 2008R2.
o Automated backup process using windows PowerShell and windows task scheduler.
• POC implementation of a Microsoft BI Solution based on PerformancePoint Services 2010 (display the built in SharePoint 2010 capabilities for the generation of KPIs, scorecards and Dashboards):
o Installed SharePoint 2010 and enabled PerformancePoint Services on Windows 2008R2 VM in Windows Azure.
o Developed PerformancePoint KPIs and Dashboards using Dashboard Designer.
• Designing and Developing of HR application:
o Gathered and analyzed SharePoint project requirements.
o Developed the application using ASP.NET MVC3/SQL Server2008R2, Entity Framework 4, LINQ, Razor, jQuery and jQuery UI.
o Designing and Developing Reports using Reporting Services 2008(SSRS 2008/2008R2).
o Developing of ETL packages using SQL Server Integration Services 2008 and jobs to schedule the SSIS packages and databases backups.
• Developed a CMS using ASP.NET/SQL Server 2008R2, jQuery and jQuery UI.
• Developed a web based decision support system:
o Gathered and analyzed the requirements.
o Developed the system using ASP.NET/MS SQL Server.
o Designed and developed reports using Crystal Reports with PDF and MS Excel rendering generation.
o Created, Deployed and Scheduled ETL Packages using SSIS 2005.
• Worked on Mol eForms project using ASP.NET/MS SQL Server: developed forms for Managing Owners, Creating & Modifying Companies electronically, Refunding Bank Guarantees and Complaints.
• Gov Services Reports System: business reports rendering web application for other governmental entities using ASP.NET/MS SQL Server.
• Designed and developed several web based applications using ASP.NET/MS SQL Server and dhtmlx suite JavaScript UI Library:
o Survey system.
o Vehicle management system.
o Suggestions system.
o Self-evaluation module for the inspection system.
o CMS for legal affairs department.
o Centralized SQL Server jobs and users logins monitoring system.
• Wages Protection System: Designed and developed reports using Stimulsoft Reports 2009 with PDF rendering generation.
• Re-engineered the decision support system from ASP.NET application to QlikView Application.
• Administrated Security Matrix: MOL Applications Security Management, users and authorizations administration.
• Coordinated with outsourcing companies for the implementation of outsourced projects:
o SharePoint 2010 intranet portal.
o QlikView BI platform.
o Jupiter document management system.
o IBM System Architect.
Software Engineer:
• Developed web and mobile application for companies geolocation:
o Gathered requirements and developed the application.
o Coordination with ministry of labour for the implementation.
Used Tools:
HTML, XML, CSS, JavaScript, AJAX, ASP, ASP.NET, VB.NET, ADO.NET, XML Web Services, Visual Studio 2003/2005, Sql Server 2000/2005, IIS, Visual Source Safe and Crystal Reports 11.
Software Engineer:
• Developed and maintained several medium-to-large sized web applications.
• Web Administrator: Linux web hosting.
Used Tools:
HTML, XML, ASP.NET, ADO.NET, JavaScript, AJAX, CSS, PHP/MySQL, CakePHP, Dreamweaver 8/CS3, IIS, Apache and CPanel.
Junior Software Engineer:
• Developed and maintained several medium-to-large sized web applications.
• Re-architected and developed B2B Web portal using ASP.Net / MS SQL Server.
• Administrated Windows 2003 Dedicated Server for web hosting, domain registration and redirection.
• Administrated IMail Server.
Used Tools:
HTML, XML, CSS, JavaScript, AJAX, ASP, ASP.NET, ADO.NET, PHP/ MySQL, Dreamweaver 8/CS3, Windows 2003 Server, IIS6, Imail Server, MS SQL Server2000/2005, MS Access and CPanel.
Junior Software Engineer:
• Developed a healthcare management system for the local city hospital:
o Gathered requirements and analysed the legacy system.
o Developed the backend system using Ruby on Rails.
o Designed and Implemented the PostgreSQL database schema.
o Developed the user interface using backbase Ajax framework.
Used Tools:
HTML, XML, CSS, JavaScript, AJAX, Ruby on Rails, Backbase, PHP/MySQL, Dreamweaver 8, Rational Rose 2003, RUP, UML, Apache 2.2, PostgreSQL 8.1.