Omair Mustafa

Data Enrichment, Integration and ETL from MSSQL/Oracle data sources and Stagings and setting up data pipelines, semaphores and services to control data flow and integrity. Design and development of Application for master data management and handling enrichment rules, transformations, aggregation logic and reporting. Project Management and mentoring Data Engineering Team. Technology stack: • Java • Spring • Talend Open Studio • Microsoft SQL Server 2014 • Oracle 11g • Linux • Liquibase • GIT

Extraction, Transformation and Loading of Big Data from SAP into MSSQL by auto generating DDL scripts from the data, including SQL Bulk Insert Technology stack: • C# • .NET Framework • Microsoft Visual Studio 2012 • Microsoft Business Intelligence Studio 2012 • Microsoft SQL Server 2008 • Microsoft SQL Server Integration Services • Workflows

Being a werkstudent Software Engineer, I was responsible for design & development of Importing Engine for CRM Dynamics for ETL of Legacy Systems Data, CRM customizations, Web Development, Analytical & Statistical Reporting. Technology stack: • C#, .NET • Javascript • ASP.NET MVC 4 • JSON & XML • LINQ, Lambda Expressions • Microsoft Visual Studio 2012 • Microsoft Business Intelligence Studio 2012 • Microsoft SQL Server 2008 • Microsoft SQL Server Reporting Services • Microsoft CRM Dynamics 2011

This interdisciplinary project "Patent Data Visualization" was part of Master's Program at Technische Universität München and was designed and developed with the collaboration of the Economics Department of the University under the supervision of Dr. Philipp Sandner, the Founder of the Munich Innovation Group. Among the Technologies used were: • Java, XML • J2SE Platform • GEXF • Gephi Library • Gephi Visualization Tool • mySQL Server, mySQL Workbench

Design and development of TRG Analytics Web Application for Business Intelligence solutions to many off shore clients to execute BI methodologies and processes on extremely huge data for enhancing and improving business activities.Developed Monitoring Tool for Fault Detection Technology stack: • C# • Javascript, jQuery • .NET Framework • Microsoft SQL Server • Visual Studio 2010 • Business Intelligence Studio 2008 • Reporting Services (SSRS) • Integration Services (SSIS) • MS Office Libraries

Design and development of a stand alone Engineering System for designing and assembling of heavy and complex electrical components such as Engines, Generators & Alternators. Besides automating extensive and multifarious engineering computations and calculations based on engineering processes, designed reporting module and 'Specifications Sheet Generation' in MS Excel. Technology stack: • C# • .NET Framework • Visual Studio 2010 • Microsoft SQL Server • Microsoft Excel • Microsoft Excel Libraries

Designed and developed 'CMS Performance Testing System' for Web UI testing, Load and Performance Analysis of the CMS System in Production by executing predeveloped test cases by 'Molybdenum' Firefox Plugin that records the web activity using xPaths. The result was extracted from XML and logged, archived and mailed to executives. Technology stack: • Java • Swing • Net Beans • HTML • XML • DOM API • Java Mail API (Gmail Server/SMTP Protocol/SSL) • MySQL • Molybdenum (Firefox Plugin)

Software Engineering

Software Engineering