System & Data Specialist
Heavy Machinery Viqa
Total years of experience :11 years, 8 Months
Data Ingestion and Collection:
• Develop and manage data ingestion pipelines to collect data from various sources, including databases, IoT devices, logs, and external APIs.
• Ensure data is gathered securely and efficiently, adhering to best practices for data acquisition.
Data Transformation and ETL (Extract, Transform, Load):
• Transform raw data into structured and usable formats by performing data cleansing, enrichment, and aggregation.
• Implement ETL processes using Azure Data Factory, Azure Databricks, or other relevant tools.
Data Storage and Management:
• Design and implement data storage solutions on Azure, such as Azure SQL Database, Azure Data Lake Storage, Azure Cosmos DB, or Azure Synapse Analytics (formerly SQL Data Warehouse) Dataverse, SharePoint Lists.
• Manage data warehouses and data lakes to optimize storage and query performance.
• Making Power apps for custom solutions and requirements.
Data Integration:
• Integrate data from different sources, ensuring data consistency and reliability.
• Set up real-time data streaming and batch processing solutions using Azure Stream Analytics, Azure Event Hubs, or Azure Logic Apps.
Monitoring and Performance Tuning:
• Monitor data pipelines and data storage systems for performance, availability, and reliability.
• Optimize data processing and storage for cost efficiency.
Data Quality Assurance:
• Establish data quality checks and validation processes to identify and rectify data quality issues.
• Create data quality dashboards and reports.
Automation and Orchestration:
• Automate data workflows and pipeline orchestration using Azure Data Factory, Azure Logic Apps, or Azure Functions.
• Implement DevOps practices for continuous integration and continuous deployment (CI/CD) of data solutions.
Scalability and Performance Optimization:
• Design data solutions to be scalable and capable of handling growing data volumes.
• Optimize data solutions for performance and cost-effectiveness.
Adaptability and Innovation:
• I thrive in dynamic and challenging environments, consistently adapting to emerging technologies and industry best practices. I am committed to staying updated on the latest trends in application support and utilizing innovative solutions to drive continuous improvement.
Documentation and Knowledge Sharing:
• I prioritize comprehensive documentation of support processes, issue resolutions, and best practices. This approach promotes knowledge sharing within the team and facilitates the training of new staff members.
Stay Current with Azure Services:
• Continuously update knowledge and skills related to Azure data services,
staying informed about new features and best practices.
Data Analysis and Interpretation:
• Collect, clean, and preprocess data from various sources. Requirements Understanding and Tracking the data sources.
• Apply statistical and analytical techniques to identify trends, patterns, and
insights within the data.
• Analyze large datasets to provide actionable recommendations to stakeholders.
Data Visualization:
• Create visually appealing and informative dashboards, charts, and graphs to micro level and present self-explaining data-driven insights to non-technical audiences.
• Use tools like Tableau, Power BI Desktop, Power BI Service, or others to effectively communicate findings.
• Automating the reports to fetch latest data and embed reports and dashboards to Power Apps, SharePoint.
Data Modeling and Forecasting:
• Build predictive models and conduct forecasting using statistical methods.
• Collaborate with data scientists and engineers to develop and refine models for better accuracy in a timely manner.
Performance Tracking and Reporting:
• Develop and maintain key performance indicators (KPIs) to monitor business performance.
• Generate regular reports and updates for management and other stakeholders.
Developing Applications in C#, VB, DOT NET, DOT NET Core, Web API, MVC using MS Visual Studio, SQL Server. SSRS, BI, Azure Development, Docker, Crystal reports, Entity Framework, JavaScript frameworks i.e. Angular and jQuery, Data Analyses and Analytics, Data Scientist, Visual Presentation of Data and Dashboards with Power BI, Power Automations and flows, Microsoft O365 Administration, SharePoint Online Administration and Development. Arinc (Collins) Systems Support
Data Analysis and Interpretation:
• Collect, clean, and preprocess data from various sources. Requirements Understanding and Tracking the data sources.
• Apply statistical and analytical techniques to identify trends, patterns, and
insights within the data.
• Analyze large datasets to provide actionable recommendations to stakeholders.
Data Visualization:
• Create visually appealing and informative dashboards, charts, and graphs to micro level and present self-explaining data-driven insights to non-technical audiences.
• Use tools like Tableau, Power BI, or others to effectively communicate findings.
• Automating the reports to fetch latest data and embed reports and dashboards to Power Apps, SharePoint.
Data Modeling and Forecasting:
• Build predictive models and conduct forecasting using statistical methods.
• Collaborate with data scientists and engineers to develop and refine models for better accuracy in a timely manner.
Performance Tracking and Reporting:
• Develop and maintain key performance indicators (KPIs) to monitor business performance.
• Generate regular reports and updates for management and other stakeholders.
Projects & Dashboards
• CRM development and Dashboard.
• HR System with Leave Management with HR Dashboard
• Tendering System development and support with Dashboards.
• Airport Financial Statistics and Dashboards.
• Duty-free Sales Analysis and Dashboards.
• Airport Flights Operations system (ARINC) Integration,
• Check-in Counters Pages Creation and FIDS Management.
• Flight information handling and Staff Training.
• Airport Portal - Intranet Application.
• Airport Inspection System (SORS) development with Power Platform and Dashboard.
• SharePoint Online Development and Administration
• Microsoft O365 Administration
• Azure AD Management
• Arinc vMUSE L1 support includes CUTE components ATP, BTP, BGR testing and installation, DCS operational support, AirDB and AirViewPages flights creation, Flight Creation in AirDB support and training to Passenger Services Agents. FIDS support.
• IT Annual Budget Planning and Designing, CAPEX and OPEX. New Equipment/Products procurement Planning to run smooth IT operations 24/7.
• Work closely with other departments such as marketing, finance, operations, and IT to support their data needs and contribute to their projects.
• Support for Microsoft Dynamics Retail Management System(MRMS), Finance Sage 50 Application Support (Role):
• Providing Complete Training and Support for MRMS and Finance Application Sage 50 to Accounts and Finance Department and Retail Store, Duty Free Staff and Procurement Department.
System(MRMS), Finance Sage 50 Application Support
(Role):
• Providing Complete Training and Support for MRMS and Finance
Application Sage 50 to Accounts and Finance Department and Retail Store, Duty Free Staf and Procurement Department.
Worked as IT Lead in UAE Mobiles FZC from June 2013 to June 2014.
• Technical Documentation writing and User Trainings.
• Software Installation, Training and Safe run at Customer End.
• Managing assigned projects and program components to deliver services in accordance with established objectives.
Worked as Software Engineer in National Communication Services from May 2010 to Jan 2011.
• Responsibilities in National Communication Services as Software
Engineer were:
• Developing Web and Desktop Applications in ASP.NET and C#.NET using MS Visual Studio 2005, AJAX and Database MS
SQL 2005.
• Projects include Election Database Website, Distributed
Desktop Application DNPS (News Production System).
• Getting Requirement from the customer and Design Use Cases and Class Diagram.
• Graphics and Web designing using CSS, Jquery, Javascript.
• Researching, designing, documenting, and modifying Software specifications throughout the software development life
cycle.
• Analyze and Remove software Errors in a specific time and accurate way.
Good communication skills in English, Arabic and Urdu.