Asqar Mehdi

• Developed and implemented a dynamic surge algorithm, aligning with market trends, resulting in increased fulfillment efficiency for ride-hailing services. • Developed a comprehensive Fraud Detection Dashboard for monitoring driver activities. This dashboard included real-time tracking of suspicious behaviors, identification of potential fraud patterns, and detailed reporting to aid in decision-making and risk management. • Performed RFM analysis to segment customers based on usage patterns and spending behavior. Leveraged insights from RFM to optimize targeted marketing campaigns, enhancing customer retention and and engagement. • Analyzed the driver registration workflow to pinpoint potential issues and pain points, then created an insightful dashboard to identify and address challenges faced by drivers. As a result, enhanced driver registration. • Designed and executed A/B tests to assess the effectiveness of new features and initiatives, providing invaluable data-driven recommendations for product and business strategy. These tests contributed to an improvement in customer satisfaction scores. • Generated visualizations and dashboards to effectively communicate complex data insights, facilitating informed decision-making across the organization. This effort resulted in an increase in data-driven decision-making adoption rates among stakeholders.

• Developed and maintained ETL processes using Talend for data integration from multiple data sources including Oracle and files. • Created reports and dashboards using IBM Cognos for data analysis and visualization. • Worked closely with business analysts to understand business requirements and translate them into technical solutions. • Monitored daily ETL processes to ensure accurate and timely data processing and identified and resolved issues as needed. • Participated in data modeling and data architecture discussions to ensure data integrity and optimal data processing performance.

AWS - REDSHIFT • Modeling data into dimensional model using Ralph Kimball Design AWS - DMS (On S3 & RDS) • Data migration service Project that includes date partitioned data on more than 250 physical tables and data volume approaching to Terabytes scale • ETL using AWS Lambda function on python scripts to move data from S3 source in parquet format to AWS Data Warehouse Redshift ERP System MANTIS - Data Integration, Mapping and Dashboarding.

• Database testing • Automates the web applications using java and provides test results • API testing and automation using postman • Validation of requirements, when approving the drafted documentation with business requirements included, assures compliance of the development outcomes with a customer’s business goals. With both sides on the same page, everything goes in the right direction. • Active team player, test design, development and write, review, revise, and verify quality standards and test procedures for program design and product evaluation. Participate in review of standards, procedures, tools, process execute test cases.

* Coordinating internal work-force i.e Development, Creative & Digital Marketing Departments * Ensuring that all projects are delivered on-time & within scope. * Project Planning, Monitoring & Generating Project Track Reports. * Measuring project performance & Reporting and escalating to management as needed. * Managing the relationship with the client and all stakeholders. * Managing Daily Co-ordination with Clients and with Work-Force * Meeting with clients to take briefs and clarify specific requirements of each project. * Performing risk management to minimize project risks. * Documenting test cases, Creating test plans, Testing standards and procedures to determining product quality, Discovering bugs within software, Perform manual and automation testing