1. Currently working as a Solutions Architect at Gosaas Labs as a permanent employee,
since 9th May 2022.
2. Worked as Application Operations and ETL Consultant (level II) at Teradata, from 11th
May 2020 till 30
th Apr 2022.
3. Worked as a Database Architect consultant for Gosaas Labs from 1
st Sep 2021 till 30
th
Apr 2022.
4. Worked as Data Analyst Specialist at Telenor Pakistan, from 03rd July 2017 till 30th April
2020.
5. Worked as a Senior Database Developer at Xavor from 08th July 2015 to 21st April 2017.
6. Worked at Netsol Technologies as a DBA and Database Developer since 08th July
2013 to 01st July 2015
7. Worked as an SQA Engineer and Database Developer for AIMINSIGHT since 15th
January to 23rd June 2013.
8. Worked as a freelancer SQL Server Developer for 3 years during graduation.
9. Has taught Olevels (All science subjects), Alevels (Computer), Intermediate
(Computer and Mathematics), Bsc (Computer)
1. Managing and building BI Team.
2. Training resources specifically for BI related tasks.
3. Developing OTBI and SSRS reports.
4. Design and development of databases in Oracle and SQL Server.
5. Database development for multiple clients.
6. Database optimization and data migrations
1. My first project at Gosaas labs was to develop and design ETL of American based
clients’ Legacy Oracle Agile PLM database to custom built implementation. Both source
and destination databases were Oracle based. Destination database was single
handedly developed by me.
2. Developed SSRS on an Oracle based database.
3. Did database tuning of different clients of Gosaas Labs.
4. Develop DB objects (Materialized Views, Views, Stored Procedures, Triggers, Functions
and Packages) as per customers’ requirements.
5. Providing Oracle Agile PLM database side support, ranging from rectifying functional
bugs to database optimization, rectifying file based indexing and custom enhancements
of current implementation.
6. Client management of different projects
Providing DBA and DB dev support on teradata CIM application deployed for multiple clients. Automating manual tasks using auto hokey. As a DBA I have to manage space usage and optimize queries that are taking too much time or locking other processes. As a database developer I have to develop new functionalities as per customer requirements using the most relevant DB objects (macros, triggers, stored procedures, functions etc)
My task here is to create complex reports using queries developed in Oracle/SQL Server for the purpose of business insights. Design and develop ETLs. Perform data sciences operations on raw data. Create automations on AutoHotkey for downloading files from CRM based Web interfaces in order to load data in databases. Optimizing previously developed DB objects and create new ones when required.
Core responsibility is to provide database support to front end developers and client for Oracle Agile PLM database. Currently working on database migration from Oracle database to SQL Server.
Worked as a database developer and administrator. Also did database migration and database modeling.