Zonera Tahir Email & Phone Number

Amsterdam, Nh, Nl

Amsterdam Area, Netherlands

Pakistan

• Worked on Teradata Job Control (TJC) for scheduling.• Developed TPT scripts for loading of data• Developed BTEQs for transformations • ETL process implementation • Deployed scripts to standardize all existing objects to have processing columns • Implemented Error and Exception handling to minimize the risk of job failure • Included Parameterization of database names to run in versatile environments • Performed Unit

Pakistan

• Verification of reports on MSTR (MicroStrategy) • Testified Business requirements for UAT environment • Updated ALM for Business requirements• Defect reporting & verification• Status Reporting

Pakistan

• Implemented algorithms to enhance contextual marketing features • Aggregating data from Hadoop as per requirement of NBO and bringing into TD database• Monitoring Internet Segmentation’s monthly run on SAS • Model customization with respect to business requirements• Worked on Analytical Data Set (ADS) to answer business related questions across various dimensions • Worked on Affinity Model, that gives the Analysis of customer behavior on provided context • Incorporated Internet Segmentation and Affinity as pre-requisites to NBO Model• Part of daily Scrum• Updating the SAS calls as per sprint requirements• Ensured timely delivery of Sprints• Incorporated structure of New Users and Rejoined customers in NBO existing Model • Performed Analysis on the effectiveness of NBO Model• Incorporated Behavioral Segmentation in already existing model of NBO• Performed production deployment of sprints • Provided support to client during testing and Production Deployment• Responsible for Sprint release package • Optimized queries and process • Performed Data Cleansing on SDM and CDM level due to Data Quality issues • Implemented analytical algorithms to cater multiple categories of customers’ behavior• Because of TD tools and utilities limitations, performed exception handling through shell scripting to make a robust process• Automated process using dynamic values • Morphed few test scripts according to the requirements • Performed Unit Testing of each module • Performed System-Integration Testing. • Performed Performance Testing • Actively involved in UAT with client for release package• Indulged into Real time reporting using RTDM (Real-Time Decision Manager) for the pitching of final offers to the customer through channels like Web, App, Facebook, WOWbox. • Extracted Responses of customers from RTDM to perform analysis to make the models more effective

Pakistan

• Worked as an ETL Consultant on an Internal Initiative• Performed Data Profiling to reconcile with the business logic • Built staging layer in Informatica using CSV files • Wrote Stored procedures for surrogate keys generation• Formulated SCD Type 1 tables to cater lookups• Transformed data according to SMX rules • Built up a Load Ready layer to have a safe side for data manipulation if needed• Loaded data into Core layer • Maintained Metadata for each load. Source and Target stats were also maintained. • Used SCD Type 2 table to maintain history on status change for a subscription • Developed everything in accordance with Telco data model• Performed Data Modeling • Formulated Fact-Dimensional model to answer business questions

Pakistan

• Worked as a DWH consultant from Teradata• Performed figures reconciliation by Digging into business rules and compliance of Figure reconciliation.• Acted as team lead for various streams.

Islamabad, Pakistan

 Performed manual remediation on WAVE 15 , Telenor's one of the biggest projects, in migration of sites from SP 2007 to SP 2013 Updated the Request Tracker for Change Requests and their respective schedule and source environments. Developed SharePoint newsfeed application in Android specific to Telenor's Newsfeed Portal Performed Certification Run, worked with employees from TIETO and DiGi Telecommunications Worked on Polaris to follow the responses from target users and extracted dump xml files to work on the stats. Worked on ORACLE SOA (Middleware)

I-9, Islamabad

• Worked on WAVE 15 for the upgrade of SharePoint from 2007 to 2013• Performed manual remediation• Updated the Request Tracker for Change Requests and their respective schedule and source environments. • Developed SharePoint newsfeed application in Android specific to Telenor’s Newsfeed Portal • Performed Certification Run, worked with employees from TIETO and DiGi Telecommunications • Worked on Polaris to follow the responses from target users and extracted dump xml files to work on the stats.

Islamabad, Pakistan

 Performed data extraction on basis of the given conditions provided by Sales and Marketing departments Organized data and produced reports for the respective Sales and Marketing departments which was further used by them to devise new strategies for business to boost

Nust-Seecs

 Worked on a Project started by SEECS in collaboration of Michigan University in order to develop a worldwide Twitter network with specifications Got Hands on experience to work on twitter dataset using a tool known as Processing