Faiq Absar Email & Phone Number

Lahore, Punjab, Pakistan

• Lead annual meeting with Chairman for annual operational review and future annual projections• Leading team of 8 Business Analyst to ensure data availability for smooth business operations. • Managing operational dashboards using Power BI tool for enhanced decision making. • Perform diagnostic i.e., Date-wise, Route Wise, and Terminal Wise dashboards on Power BI for enhanced decision-making. • Automate & restructure raw data received nationwide terminal using power query for route wise and P2P analysis. • Using agile methodology, improved in-house management system for inventory, fuel & ticketing by 5% on average. • UAT designing for Daewoo app and integration of gateways through SQL.• Integration of Database into SQL for Dashboard making and Tracking system.• VBA coding with macros for Drivers analysis and ASKM analysis.• Trimming, data cleansing & capturing groups on REGEX for Buses, drivers & Hostess Driver match sheets. • Designed AI model for Route Optimization to reduce 10% Fuel cost.• Proposed cost-benefit analysis for Electric vehicle on short routes for trial purpose.• Define risk factors & implemented the most cost-effective methods for scheduling without sacrificing efficiency and timeliness.• Single handedly developed, maintained & sustaining transportation Intelligence dashboards for KPI’s like Rev/ASKM & Rev/USKM.• Responsible for data integrity by setting check points. Consolidate & devise operational plans for all terminals across nation• Evaluate potential revenue from all sites and set monthly sales target• Development of Track & Snap tracking system, fuel sensors, & dash cams.• Matillion ETL for data modeling, scheduling, & automation into Snowflake.• Demonstration of data modeling, data structuring in SQL for Power BI, & route optimization. • Ratio analysis, financial planning & forecasting on SAP

Lahore, Punjab, Pakistan

• Effectively managed continuous improvement process of Daewoo app development through agile methodology, set a quarterly time frame for update • Liaison between business staff and technical staff to articulate business needs, issues, and concerns.• Developed and maintained dashboards and reports to monitor key performance indicators (KPIs) such as delivery times, vehicle utilization, and fuel consumption.• Lead a project with IT team using Agile methodology to develop WIMS and ensure seamless data integration & proper implementation.• Conducted root cause analysis of operational issues and recommend data-driven solutions.• 5% reduction in cost through workshop analysis of Tyres, Lubes and Spare parts. • Integration of FASTEX(cargo) CMS with Daewoo app

Lahore, Pakistan

• Developed logistics & maintenance dashboards on Power BI. • Automated Tolls dashboards through VBA. • Execute Point to Point occupancy analysis, RW-DW occupancy analysis through VBA.• Run balance sheet analysis using various tools like VBA & macros for Top Management review. • Assist in CMS and Daewoo app integration for tracking of tickets and cargo slips.• Perform code check in Point to point fare making. • Run Fleet wise analysis for asset utilization.

United States

• Interacting with business users to identify their needs, gathering requirements and authoring Business Requirement Documents (BRD), General System Design (GSD), Functional Requirement Documents (FRD), and Software Requirement Specification (SRS)across the deliverables of a project.• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MSProject for data migration into the CI System Knowledge Data Base in Microsoft SharePoint.• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.• Demonstrated experience & understanding of methodology testing in DevOps environment.• Experienced with multiple Relational databases like MySQL, SQL server and in-depth knowledge in ETL tools (Pentaho, SSIS).• Experienced in Logs the bugs in JIRA and assisting the developers in the resolution of bugs.• Working knowledge of Amazon Web Services (AWS) and Cloud Data Management• Worked on the validation of connectivity between the external systems. • Strong Data Mapping experience using ER diagrams, Dimensional/Hierarchical data modeling, & Snowflake modeling using tools like E/R Studio & Sybase PowerDesigner.

Lahore, Pakistan

Woocommerc, Leeds Development, Engagement with professional fighters, Wholesale clients Engagements & E-mail Marketing.Conducted market research to identify potential customers, competitors, and emerging trends in the boxing equipment industry. Analyzing market data to identify gaps and opportunities for Infinitudefight products.Identifying and pursuing new business opportunities and partnerships. Includes reaching out to potential clients, attending industry events, and networking with relevant stakeholders.Building and maintaining strong relationships with existing clients to ensure their satisfaction and loyalty. Addressing client inquiries and concerns promptly to enhance customer retention.Collaborating with the product development team to understand customer needs and preferences. Providing feedback and insights to guide the development of new and improved boxing equipment.Developing strategies and tactics to meet revenue targets. Negotiating contracts and pricing agreements with clients to secure business deals.Collaborating with the marketing team to develop campaigns and promotional activities. Creating materials & collaterals to support business development efforts.Monitoring the activities of competitors in the boxing equipment market. Analyzing their strengths and weaknesses to develop strategies that differentiate the firm's products and services.Exploring opportunities for expanding the firm's market presence globally. Assessing potential markets and developing entry strategies for international markets.Negotiating and finalizing contracts with clients, distributors, or suppliers to ensure mutually beneficial partnerships. Generating reports and providing regular updates to the management team on business development activities, progress, and achievements. Participating in industry events, conferences, and trade shows to promote the firm's products and build industry connections

Dera Ismail Khan

Help in maintaining the institution’s general ledger. Assist changing in accounts with existing clients. Transforming Data in hard form into digital form.

Dera Ismail Khan

Generating and analyzing reports. Help in preparing financial statements. Also, helping customers with banking related queries such as filling forms, cheque, etc.

Master Of Business Administration - Mba, Human Resources Management/Personnel Administration, General

Activities and Societies: Captain of Fast Badminton Team. Part of the executive body in Softec Fast Lahore. A grade in Final year thesis.

Bba(Hons), Finance, General

Activities and Societies: Team member of Fast Badminton. Softec & Fast Care Society. Research Work in Final Year Thesis. Comprehensive.