Ammad Ahmad Email & Phone Number

Lahore, Punjab, Pakistan

Lahore District, Punjab, Pakistan

Project: Adamjee Insurance (AICL) Data Warehouse/BI• Data extraction, data wrangling and developing visualizations using SQL and BI to create intuitive sense out of the data for non-technical stakeholders and managers.• Working with business users to design and develop Cognos BI 10.2.2 reports using Report Studio with data drill-down and slice-and-dice options.• Designated as the first point of contact for the Data Analytics team for the client. Ensuring all client requests are appropriately handled by best-case scenarios.• Managing daily operations for the client relating to ad-hoc requests, Data warehouse, BI support, BI operations, ETL process implementations, DB optimization, and system administration.• Active participation in up-gradation and setup of database and ETL production environment for the client with all active monitoring to ensure smooth business operation.• Creating and maintaining complex SQL scripts for analysis and testing.• Nominated twice for the Employee of the Quarter award due to extraordinary performance and satisfactory feedback from the client’s management.• Providing support and analysis of issues related to Data warehouse and BI reporting• Implementing change requests from business users via modifications in ETL pipeline and BI reports• Capturing requirements and coordination with business users for further clarity• Maintaining and update Taiga tickets for progress information• Monitoring ETL activity to ensure its smooth execution; troubleshooting in case of failure• Tools: IBM Data Stage (ETL), IBM Cognos Analytics (BI reporting), Vertica DB (Aqua DBMS) and Taiga (Project Management)

Lahore, Pakistan

Developed and maintained different ETL jobs for extracting, cleaning, transforming and loading data as per the business requirement of the organization’s client.

Lahore, Pakistan

Worked at a co-working facility with an aim of self-development. Followed different self learning platforms to develop proficiency with the following:• Microsoft C# concepts and Development• Web Development using HTML5 and CSS3 Development• Database design and SQL

Lahore, Pakistan

• Worked with the internal and external stakeholders to define scope and to provide requirements at an appropriate level of detail• Gathered functional and non-functional requirements using appropriate techniques such as interviews, workshops, surveys, use cases, scenarios, competitor product analysis, task and workflow analysis• Conducting research and analysis of findings collected from field data

Pakistan

Centre for Technology in Governance (CTG), at the Information Technology University (ITU), Lahore.Worked on the GIZ Interactive Voice Response System (IVRS) Project; a joint collaboration between Information Technology University and GIZ, a representative organization of the Federal Republic of Germany. Roles performed during work include:• Assistance in designing of detailed implementation plan• Assistance in the recruitment of entire project with around 2000 applicants for 35 open positions• Scheduled and organized job interviews and liaison work with the applicants.

Pakistan

WWF-Beaconhouse internship program, research based work on renewable energy resources in Pakistan and environmental journalism.

Bachelor'S Degree, Computer Engineering

Activities and Societies: ▪ Managed a team of more than 150 volunteers working as Deputy Director Public Relations EME Olympiad 2013. ▪.

University Of Cambridge International Examinations Gce A-Levels, Mathematics, Physics, Economics, Chemistry

University Of Cambridge International Examinations Gce O-Levels, Additional Mathematics, Physics, Chemistry, Commerce, Business Studies