Mahreen Kalani PMP, CSPO®

Experience

• 

  Interasia textile Pakistan

  Aug 2002 - Jun 2003

  Software Developer
• 

  Gem Internet Services Private Limited

  Jul 2003 - Mar 2004

  Web Application Developer
• 

  Millennium Systems & Consultants Pvt. Ltd.

  Apr 2004 - Jun 2007

  Software Development Team Leader

  Platform/Skills: VB 6, SQL Server 2000, Crystal Reports v 10As a team leader, I was responsible to assign tasks to the team members and to test, validate and integrate upon completion. After completion of the project I was responsible to implement Change Management System by analyzing changes, assessing risk factors, assigning tasks (Programs and MIS Reports) to the team members in association with the project manager, to validate, test and integrate them in to the system and to ensure that work is completed as scheduled and within budget. My efforts were rewarded in the form of bonus at the completion of testing phase Major Projects (and more):• RMCS®: Revenue Management Complete System for Karachi Water and Sewerage Board• Mail Tracking System for Managing Director of Karachi Water and Sewerage Board As: Systems Consultant Projects:• Developed, modified and implemented VB/SQL baed software called PMCS®: Project Management Complete System. Provided Project Management Services to Export Promotion Bureau, Pakistan (Fair & Exhibition Projects, Trade Policy Projects)• Maintenance of GIMS®: Garment Information Management System Show less

• 

  Deutsche Bank

  Dec 2007 - Aug 2010

  Business Analyst

  Platforms/Skills: MS SQL Server, VBA, MS Excel, MS AccessAs MIS Analyst:• Analyzed, developed and delivered daily dashboards and MIS for derivative operations for Asia Pacific region. • Prepared daily, weekly and monthly cash-flow, settlements and trade documentation reports, running fire-drill exercise for specific counterparties and provide reports based on trade reconciliation to Singapore, Japan and other Asia Pacific regions.• Created OTC Asia Pacific Settlements dashboard to control risk and help control managers to analyze capacity based on cash flow by linking Access database with multiple Excel applications using VBA Macros. Graphs and named ranges in excel output was programmed to updated automatically. • Successfully developed Asia Pacific RTB Cost Allocation database to calculate cost per trading book code and the Cost Pools required to run a dive Cost per Trade for Asia pacific region. This project was developed in Access using input files such as Excel file, Text (csv files). The underlying premise of the project was to take the 7-8 raw data files. Uploading them to an automated access database platform, which performs all necessary calculations to replicate the manual working. Deutsche Bank AG, London UK (2 months)As Business Analyst:After Successful implementation of Cost Allocation Project for Asia Pacific, Business Management team in London offered me a project to implement similar project for Global Cost Allocation • Project: Global RTB Cost Allocation: This project was analyzed, developed, tested and deployed in London. The project includes auto-calculating cost per book code calculation for Deutsche bank’s global derivative ops regions based on Volume files containing trade details. Regions include New York, London, Bangalore, Frankfurt, Sydney, Manila etc. This project was built on SQL Server 2005 by creating stored procedures and designing and developing SSIS Packages. Show less

• 

  CBHS Health Fund Limited

  Apr 2011 - Sept 2015

  Senior Business Analyst

  Platforms/Skills: Microsoft Excel, Microsoft Access database, SQL Server 2008, Hyperion OBIEE, SSRS, SSAS and SSIS.• Subject Matter Expert for ad-hoc/scheduled data extraction, cleansing & formatting, analysis, testing and delivering reports for stakeholders (including internal and external auditors) by communicating complex data in comprehensible ways.• Represented analytical team in leading projects by gathering data requirements and presenting valuable recommendations. Projects such as Claims Leakage and Recovery Project, Termination retention Project, Benefit Reviews and more.• Successfully achieved claims recovery targets by assisting Operations in identifying fraud indicators and trigger factors• Leading SQL to Oracle migration project by migrating SSRS reports to Hyperion OBIEE Platform. This includes creating data warehouse, identifying patterns and creating cubes, reports and dashboards.• Developed and managed internal metrics/dashboards to increase organizational productivity and effectiveness for different departments within organization.• Identifying data trends required for creating end of month reports and presentations for the CFO using advanced skills in SQL, Microsoft Excel and PowerPoint such as Pivoting, Data Tables, & Drawing Tools.• SME for CBHS Ad-hoc analysis and Regulatory reports, continuous assistance to analytics team to support OBIEE, Dashboard, Hyperion reports and cubes. Identified user needs and developed strategies by which to meet those needs. Show less

• 

  Aprio

  Apr 2017 - now

  Automation, Innovation, Analytics and Software

  • Data & Analytics Manager

    Sept 2021 - now

  • Senior Data & Analytics Consultant

    May 2019 - Aug 2021

  • SQL Analyst

    Apr 2017 - Apr 2019