Visualization: Tableau, Power BI, Excel
Amena Shahid
Data Analyst & Development Specialist
Tampa Bay Area,Florida
Summary
A Business Intelligence professional with 4.5 years of experience as an Analyst and Data Engineer who undertakes complex assignments, meets tight deadlines and delivers superior performance. Known by the management and peers for smart and hard work, problem-solving skills, exceptional understanding of business requirements and analytical, technical, stake-holder management and interpersonal communication skills. Core competencies include: Query Optimization, Quality Assurance, EDW Architecture, Data Warehousing, Documentation, Report Development, Stakeholder Management, Information Mapping, Insights Discovery, Requirement Gathering, Data Extraction, Advanced SQL, Data Analysis and Dashboard Design. Currently pursuing Masters with majors in Data Science at University of South Florida.
Overview
9
9
Languages
11
11
Certificates
7
7
years of post-secondary education
4
4
years of professional experience
Work History
BI and Analytics Development Specialist
Telenor
Islamabad, Pakistan
10.2017 - 05.2018
- Worked on Teradata Communications Logical Data Model, Star Schema and Snowflake Schema and troubleshot production issues and proposed solutions to resolve them.
- Used deep understanding of conceptual and semantic data model to source multiple project related KPIs to DWH.
- Analyzed source data to create system flows and depict current state dependencies.
- Developed architect and performed dimension modeling to integrate new sources into current data warehouse design using agile/waterfall approach.
- Performed technical writing to document project flow, data issues and/or any changes.
- Developed complex and high-performance SQL queries for user requests, testing protocols and enhancing efficiency Reduced load on ETL by 75% and ensured data synchronization across all trackers by creating data marts with core KPIs improving reporting efficiency
- Increased daily customer acquisition numbers by 37% by identifying data issues, re-visiting rules and identifying gaps to modify existing procedure of marking new customers and their activity accurately
- Increased monthly active base by 10% by troubleshooting asset termination & creation rules and reconciliation and analysis of most critical KPI figures and trends on daily bases from staging to business layer (source to CDM and SDM layers)
- Reduced run time by 50% for dashboards supporting live applications by optimization and tuning of scripts to ensure performance benchmarks.
BI and Analytics Data Analyst
Telenor
Islamabad, Pakistan
12.2013 - 10.2017
- Worked closely with business to gather and understand requirement and effectively managed stakeholders to develop efficient enhancements, customizations, weekly, monthly and ad-hoc reports using high-quality solutions (OLAP and Ad-hoc).
- Ensured quality of data by notifying Operations and Quality teams of any issue for timely rectification.
- Lead biometric base verification project in 2015, turning point in history of Pakistans’ telecommunications industry. This was a high paced project developed using agile methodology with Pakistan Telecommunications Authority as direct stakeholder.
- I also conducted project success analysis and internal and external audit Efficiently developed and automated reports using SQL and Linux Scheduling utility to provide data for Daily Stats Dashboard (in SAP Business Objects), Campaign Management (resulting in 9% additional turnover), text prompts (alerting top layer of daily stats) and various trend reports reducing hours of daily effort.
- Launched one of main and proprietary offer in portfolio with 1 Mil Daily Subscribers causing revenue increase by 17% and 5% during campaign and post campaign period respectively
- Decreased churn on one of offers by 8% and increased 4 million of recharge by developing major trackers with subscriber movement analysis w.r.t. Subscriber engagement, migrations and revenue engagement amongst other cuts. The trackers are also used to identify patterns, anomalies and underlying trends in data such as Churn and Quality of Service(QoS) on daily basis
- Delivered insights for 100+ offers, pre-post campaign, demographical and regional analysis including The Telenor APP which covers 6 Million of subscriber base and has significantly enhanced and digitized customer experience
- Assisted internal stakeholders finance, marketing/commercial, regulatory,Customer Services and Sales & Distribution with customized analysis for campaign launches, new product designs, revenue leakage investigations and periodic reporting
- Analyzed data to develop dashboards on excel and automated excel dashboards, analysis and presentation procedures bringing monthly effort down by considerable hours
- Liaised with industry's leading consultant JUMO to implement credit scoring model for Financial Services where I conducted Base Fragmentation and Profiling, designed reports to answer basic analytical and business questions for project scope evaluation and analyzed base on GSM patterns leading to building credit scoring model for Financial Services
- Monitored and ensured data quality and ensured data privacy with 3 step Encryption algorithm
Education
Master of Science - Business Analytics & Info Systems
University of South Florida
Tampa, FL 08.2019 - Current
Bachelor of Engineering - Computer Engineering
National University Of Science & Technology
Pakistan 09.2009 - 07.2013
Graduate Projects
- Data Mining
- Data Warehousing
- Advanced Database Management
- Distributed Information System
- Data Science Programming
- Data Visualization
- Big Data for Business
- Stats Prog for Bus Analytics
- Analytical Methods for Business
Skills
Teradata Technologies: SQL,Sourcing of Data, Query Optimization, Data Modeling, Teradata Loading Utilities, Teradata Viewpoint, BTEQ writing
Visualization Tools: Tableau, Power-BI for Analysis, Dashboards, Story-Boarding
Databases: Teradata, MS Access, SQL Server, Oracle
Data Analysis: Monthly Trackers, Insights Extraction, In depth analysis, Pre Post campaign analysis
Languages: Unix, SQL, R, Python, C#, C, SAS, Html, CSS, Linq
Data Mining, Data Science Programming, Advanced Analytics
Project Management: Stakeholder Management, Requirement Gathering and Analysis, Resource and Bandwidth allocation, Design and Implementation
Microsoft NET Framework
Certification
Python for Everybody 5 course Specialization
Software
Statistical Analysis: SAS
Data Mining: SAS Enterprise Miner, Microsoft Azure Machine Learning Studio
Additional Information
- Employee of the Quarter Award (Telenor Pakistan)
- SQL Champion Award (Telenor Pakistan)
Timeline
Python for Everybody 5 course Specialization
08-2020
ASP.NET MVC 5 Essential Training
03-2020
LINQ with C# Essential Training
03-2020
Learning Entity Framework Core
03-2020
Master of Science - Business Analytics & Info Systems
University of South Florida
08.2019 - Current
Creating Dashboards and Storytelling with Tableau
12-2018
Visual Analytics with Tableau
11-2018
Essential Design Principles for Tableau
11-2018
Fundamentals of Visualization with Tableau
11-2018
BI and Analytics Development Specialist
Telenor
10.2017 - 05.2018
BI and Analytics Data Analyst
Telenor
12.2013 - 10.2017
Bachelor of Engineering - Computer Engineering
National University Of Science & Technology
09.2009 - 07.2013