Mujeeb Syed

Working with ETL - SSIS:
I was involved in:
▪ Importing/extracting data from different DB's to Bespoke ERP Solutions.
▪ Designing of packages in SSIS to populate data from various sources and data extraction from Flat Files, Excel Files, OLEDB, and Import data into clients' Databases after proper validations.
▪ Creating ETL, Data Profiling, Data Quality Server/Client, and Cleanups for SSIS Packages. Cleanup tasks are implemented within SSIS packages to rectify erroneous data before it's loaded into the destination.
▪ Designing Sequence, For and For-Each Loop to Import and Using Variables to Export Multiple Files in different Formats. Used control flow elements in SSIS, such as sequence containers and loop constructs (For Loop, For Each Loop), to efficiently manage the execution of tasks, including the dynamic import and export of data across multiple files of varying formats. Variables are used within these loops to support file paths, names, and other dynamic properties during runtime.
▪ Data is loaded into the destination server using direct SQL commands through the Execute SQL Task, high-speed data insertion with Bulk Insert, and complex transformations such as lookups for data updates.
▪ Incremental loading techniques are applied to transfer only new or changed data, optimizing the ETL process's efficiency and performance.
▪ Creating the Connection Manager, Creating the Tables, Performing Inserts, Increment Updates, Using Database Schema for Multiple Tables.
▪ A variety of SSIS transformations are used to prepare the data for loading. This includes converting data types, creating new computed columns, cleaning data using Data Quality Services (DQS), and performing lookups to augment or validate the data. These transformations ensure that the data is consistent, accurate, and ready for analytical or operational use.

Working with SQL (Designing Data Warehouse):
▪ Designing the OLTP Database, Tables, Store Procedures, UDF and Triggers.
▪ Involved in fine-tuning, Performance and Query optimization of the Database as required by the application.
▪ Designing Stage Database and Data warehouse from scratch, creating DIM and Fact tables.
▪ Creating Star Schema based on client requirements

Working with POWER BI:
Data Modelling and Preparation:
▪ Connecting to various data sources (SQL, EXCEL, Websites), importing data into Power BI, and transforming data using Power Query.
▪ Designing and implementing data models that effectively represent business processes and requirements, including establishing relationships, calculated columns and measures.

Report and Dashboard Design:
▪ Creating interactive reports and dashboards that provide actionable insights using PowerBI visualization tools, such as charts, graphs, maps, and tables.
▪ Applying best practices in data visualization to ensure reports are clear, engaging, and accessible to end-users.

DAX (Data Analysis Expressions):
▪ Writing DAX formulas to create complex calculations, aggregations, and data analysis within Power BI
▪ models.
▪ Ensuring that DAX calculations are optimized for performance and accuracy.

▪ Configured and Managed IT infrastructure, NAS server and LAN network with scheduled backups.

▪ Enabled Remote working capabilities through IT/cloud solutions during Covid-19

▪ Managed rental accounts for the Landlords and Tenants using PropertyTree (Cloud CRM Applications)

▪ Managed Trust Accounts for Rentals and Sales portfolios

▪ Managed Annual Audits and compliances as per Consumer Affairs regulations

▪ Enabled Reconciliations and EOM report generations

▪ Worked in team and as well as independently to achieve desired results

▪ Managed network and system performance, conducting troubleshooting, security patching, and maintenance.

▪ Managed IT infrastructure on Windows and MAC systems

▪ Assisted in application for Re-registration for the RTO including scope under the regulators like VRQA

and ASQA

▪ Assisted in application and successful grant of Skills Victoria(SVTS) Funding –VTG for 2 years

▪ Successfully implemented IT systems including Microsoft Windows, Office and various other application software like VETTRAK and Accounting Software, including regular maintenance/upgrades.

▪ Very Proficient in using Student Management Software like VETTRAK 4.4.0/4.4.3 to perform all the

functions of creating student enrolments (database), Validation of data, uploading Student IDs and

reporting

▪ Implemented the AQTF compliance protocols with a keen eye for details

▪ Suggested and Implemented Continuous Improvement processes and recorded them.