SQL
Nimra Javed
Planning And Forecasting
Lahore
Overview
8
8
years of professional experience
5
5
years of post-secondary education
Work History
Senior Manager Transfer and Payments
MCB Bank (Digital Banking)
09.2023 - Current
- Spearheaded strategies to drive banking app growth by leveraging analytics and trends along with different marketing tools. Customer active ratio improved up to 14% in few revenue generating use cases.
- Initiated several high-budget promos (up to 25 Million) to boost app user growth, achieving a remarkable conversion rate of 14% compared to the previous rate of 3%.
- Developed business cases for partnerships on the MCB Live app, utilizing data trends and forecasting to justify proposals presented to senior management for decision-making.
- Successfully aligned partnership team with few impactful use cases, resulting in a remarkable 259% growth within the first month for a specific use case.
- Identified and resolved glitches and transaction failures in the app by actively engaging with customers through different mediums.
- Led the end-to-end execution of a P2M (RAAST) project with the State Bank of Pakistan, overseeing marketing, process development, communication with call centers, product testing, and coordination with SBP, culminating in a successful launch.
- Utilized industry analysis to identify and improve underperforming use cases on the app, aligning new product streams for MCB LIVE and adding significant value to the platform.
Business Support Expert
Jazz
03.2021 - 03.2023
- Successfully ensured achievement of all 3 KPI targets through implementation of reporting, analysis, visits, surveys, promos, and feedbacks, as well as planning, budget disbursements, reporting, analysis, trends, and resource allocation within region.
- Managed team of 5 BA supervisors and 4 RDS, providing guidance and support to ensure potential demand in the specific areas are met.
- Developed and implemented automated report to closely monitor RDO serving timings, which was presented to all 4 sales directors and applied in channel to save time and reporting issues.
- Created numerous reports and dashboards for KPI and promo monitoring, which were handed over to RDS and BA supervisors.
- Oversaw target allocation, budgets, commissions, and promo design in 4 regions, including ADC and SME channels, to maximize revenue.
- Developed and aligned BVS distributions to retailers for first time in ADC, achieving approximately 78% active ratio, and successfully recovered 98% of BVS devices from retailers within deadline.
- Handled target allocation among regions and focused on areas with potential for high KPI business, resulting in increased productivity and revenue.
- Ensured commission payouts to approximately 650+ employees and resolved any payment issues in Central A.
- Conducted weekly and monthly meetings to raise red flags and bottlenecks and provide solutions accordingly.
Data Analyst
Zameen.com
03.2020 - 03.2021
- Report creation for various projects via SQL queries
- Successfully achieved additional 10Million Revenue for Hyderabad region with help of coordination with internal team and various analytical approaches
- Conducted various studies through call center to gather insights on different issues and proposed solutions.
- Was able to reduce fake token percentage to 5% within month
- Proposed and collaborated with different departments to carry out different policies to structure tasks in future.
- Forecasting Quarterly plans and Revenues
- Handling of nationwide and UAE sale dispute cases which requires constant coordination and follow ups with senior directors and managers. Successfully able to reduce sale dispute resolution duration from 7 working days to 3 working days
- Constant coordination with inventory team to provide analytical help to sales team and pin point projects which needs more focus from marketing team
Channel Planning & Development Executive
Telenor Pakistan
12.2018 - 01.2020
- Target setting for FS (Financial Service-Easy Paisa) components
- Devised detailed strategy with regional sales team heads to achieve goal of 7 Million Mobile Wallet Accounts in 2020 through different campaigns/required rate of returns in achievement/team addition and re-deployment of various variables
- Proposed solutions based on market surveys carried out after successful market visits to gather insights from 3rd party (retailers / franchises) Constant follow up with franchise owners and retailers in central (Punjab)
- Involved in development and execution for different new products like Easy Paisa Load product/Power load Plus
- Constant follow ups/meetings with regional sales team to ensure transparency in company goals and gather feedback to ensure performance.
- Initiated re-deployment methodology for BVS devices by suggesting to move dormant devices to potential areas. (16% re-deployed, successful)
- Successful minimization of GREY % from 19% - 1% (through different workshops/penalties/warnings/market visits/campaigns)
Senior Officer Channel Planning
ZONG CMPAK
08.2017 - 12.2018
- Automated reports (through mail merge Macro) directly to 134 franchises for KPI Achievement and Commission
- Uploaded data sets on SQL Server for extraction of data to create daily reports
- Ad-hoc BI data requests through SQL queries
- Alternate Channel Target Setting and Commissions
- Supported/conducted weekly meetings with regional management through weekly performance of sales by identifying bottom and top employees
- Promo Designing to support company goals and visibility for channel
- Supply Chain Visibility, Bolt Stock Management (New Shipments, Stock Split & Stock. Movement)
- One Stop Visibility of all KPI Achievement in yearly Dashboard
- Market visits to gather insights and feedback from retailers on on-going projects
- Used critical thinking to break down problems, evaluate solutions and make decisions
Graduate Trainee Officer Channel Planning
ZONG CMPAK
09.2016 - 08.2017
- Performance Commission for Central Franchises
- Responsible for Channel Promo Designing and Visibilities
- Standardized Franchise Up-liftmen Project
- Stock Management of Bolt devices and SIMs
- Reporting of various KPIs and required analysis
Education
MBA - Finance
Lahore School of Economics
Lahore 09.2015 - 12.2016
Bachelor of Science - Finance & Accounting
Lahore School of Economics
Lahore 09.2011 - 06.2015
Skills
Data Analytics
Software
COGNOS
Power BI
Timeline
Senior Manager Transfer and Payments
MCB Bank (Digital Banking)
09.2023 - Current
Business Support Expert
Jazz
03.2021 - 03.2023
Data Analyst
Zameen.com
03.2020 - 03.2021
Channel Planning & Development Executive
Telenor Pakistan
12.2018 - 01.2020
Senior Officer Channel Planning
ZONG CMPAK
08.2017 - 12.2018
Graduate Trainee Officer Channel Planning
ZONG CMPAK
09.2016 - 08.2017
MBA - Finance
Lahore School of Economics
09.2015 - 12.2016
Bachelor of Science - Finance & Accounting
Lahore School of Economics
09.2011 - 06.2015
Similar Profiles
Jean Sebastien Didier Waren BarbeJean Sebastien Didier Waren Barbe
Customer Service Representative at The Mauritius Commercial Bank (MCB) Private Banking and Wealth ManagementCustomer Service Representative at The Mauritius Commercial Bank (MCB) Private Banking and Wealth Management
Salim IftkharSalim Iftkhar
Senior Relationship Manager at Wholesale Banking Group, MCB Bank LimitedSenior Relationship Manager at Wholesale Banking Group, MCB Bank Limited
TARANNUM ATHERTARANNUM ATHER
CSO at MCB BANKCSO at MCB BANK
Salman AhmadSalman Ahmad
Director, Technical and Marketing at Masafa Rice Mills Private LimitedDirector, Technical and Marketing at Masafa Rice Mills Private Limited
Arslan BarketArslan Barket
Assistant accountant at The TAQ OrganizationAssistant accountant at The TAQ Organization