Crop Picture
NOTE: Do not upload any image that violates our Picture Policy. Doing so will result in the removal of the concerned image without prior notification.
概要
MS Excel (advance skills)
MS Power BI (Microsoft Business Intelligence)
SQL, BIGQUERY, Power Pivot/Query
SPSS (statistical package of social sciences- advance skills)
Data cleansing, mining, big data
Excel macro programing (dashboards) analytical research solutions for the dynamic reporting of survey data through developing dynamic dashboards. connecting MS Excel on front MS Access as backend database.
Advance statistical analysis: (hypothesis testing (anova, chi-square, correlation & regression analysis), time series analysis, perceptual maps 'PM', brand penetration meter 'BPM', key driver analysis 'KDA', penalty analysis, jaccard analysis, turf analysis, pareto analysis, price sensitivity meter 'PSM', brand usage pattern, snake graph, distribution analysis, factor analysis, classification, clustering, etc.) also analyzed various MS & PHD theses quantitative & qualitative studies
Questionnaire design, project briefings, instructions/guidelines, translations, report writing.
Worked on variety of researches ranging customer satisfaction surveys (CSS), product/concept/packaging tests, ad testing, consumer segmentation, U&A (usage & attitude studies), H&P (habits and practices studies), BHT(brand health tracking), mystery shopping, consumer panel (household panel), outlet/store audits and social media researches.
工作经历
Senior Data/Business Intelligence Analyst
- To manage day to day assignments of Data Transformations & Analysis.
- Generating highly interactive and professional reports in Excel Dashboards and MS Power BI of Procurement Process, Purchases, Sales, Inventory, HR and Finance etc.
- Working on large amounts of Retail transactional and surveyed data and turning it into meaningful outputs.
- Data Extraction (ETL), Transformations, through different sources like Odoo, SQL Server, MySQL, Excel etc. Reports and Dashboards designing in MS Power BI & MS Excel.
- Timely provision of assistance to other colleagues in their day to day assignments.
Team Lead Data Analysts/Scientists (Online Platform)
- To manage day to day assignments of Data Transformations & Analysis
- Online platform therefore managing team from KHI and reporting to Chevron Houston USA
- Data related tasks transformation and automated excel sheets
- Responsible to prepare and train local team to fulfill day to day assignments
- Conducting meetings with HO Houston for meet day to day assignments with 100% outputs - Data Extraction (ETL) from different sources and Analysis Report designing in MS Power BI
- Timely provision of expert inputs to HO team
Statistician
- Advance Analysis
- Info Graphic / Analytical Reports
- Excel Macros/Dashboards
- Statistical Tabulation
- Data Collection/Desk Research
- Developed Database of all Important Social Indicators of all Districts of Pakistan with Authentic Sources to Plugin into Information Systems (With References)
- Developed Databases General & Bye Elections from 1971 to 2013 to Plugin into Information Systems (With References)
- Handling Data Cleaning Issues
- Helping in Urdu & English Content/Speeches/Instructions/Guidelines
Deputy Manager DP & Analysis
- Advance Analysis
- Excel Macros/Dashboards
- Statistical Tabulation
- Sampling Extractions
- Data Processing in Quantum, Quanvert, Minitab, Excel & SPSS
- Operational Management of a Price Tracking Study
- Training & Development (Softwares: SPSS, Ms Office & Analysis Concepts)
- Time Sheets Management of DP Department
- Timely Providing IT Solutions
SOCIAL PROJECTS WORKED ON:
- Attitudes and Practices regarding Female Mobility in Karachi and Islamabad (2010)
- Gender Equality Self-Assessment (GESA)
- Systems for Employment Outcomes: An Assessment of Pakistan's Technical Education and Vocational
Training Sector
- The scope and nature of work place learning in Sindh
- Baseline Report on Women's Empowerment Using Perceptual Mapping Technique in Seven Districts of
Pakistan
* All the above mentioned reports could be found on Academia.edu
Asst. Manager Data Processing & Analysis
- Advance Analysis
- Operational Management of a Price Tracking Study
- Excel Macros/Dashboards
- Statistical Tabulation
- Data Processing in Quantum & SPSS
- Training & Development (Softwares & Analysis Concepts)
- Timely Providing IT Solutions
Data Processing Executive
- Advance Analysis
- Project Execution Of Customized & Tracking Studies
- Statistical Tabulation in SPSS
- Timely Providing IT Solutions
Research Executive
- Project Execution of Tracking Studies (DTP)
- Directly Communication with Clients
- Questionnaire Translations
- Field Training
- Taking Care of Overall Project Process
