Business intelligence Specialist - ST & IT Department of Government of Khyber Pakhtunkhwa - Peshawar
(2020-12)
Responsible for analyzing, and interpreting data to provide valuable insights that can guide business decisions and daily operations task of Power BI, Tableau, Python, SQL, Foris BI, Google Looker Studio.
- Design and Develop BI Solutions: Create complex reports, visualizations, cubes, and metadata models using Power BI, Tableau and , Google Looker Studio and Foris BI Analytics
- Troubleshooting and Optimization: Troubleshoot issues and recommend optimized design techniques for building reports and dashboards using Power BI, Tableau and Framework Manager, Foris BI, Google Looker Studio.
- SQL Proficiency: Expert in SQL, including writing and optimizing stored procedures for robust data analysis and reporting.
- Data Integrity: Ensure data integrity and consistency within the SQL databases, resolving data-related issues as they arise
- Dashboard and Report Creation: Develop dashboards and reports in Power BI, Tableau, and , tailored to organizational needs.
- Performance Optimization: Identify issues and enhance report performance using Power BI, Tableau, , Foris BI and Google Data Studio
- Ad Hoc Support: Respond to and fulfill ad hoc data and reporting requests with agility.
- End-to-End BI Development: Develop BI reports through the entire lifecycle, from discovery to deployment, ensuring quality and relevance.
- Translate business requirements into technical specifications for BI solutions.
- Extract data from various sources such as databases, data warehouses, APIs, and flat files.
- Cleanse, transform, and integrate data to create a unified view for analysis.
- Ensure data quality and accuracy in the integration process
- Database Queries: Write complex SQL queries to extract, update, and manipulate data in relational databases
- Design and develop data models and databases for efficient storage and retrieval of data.
- Create dimensional data models (star schema, snowflake schema) to support analytical reporting.
- Define relationships between data entities to enable meaningful analysis.
- Develop interactive and visually appealing reports and dashboards using BI tools (such as Power BI, Tableau, or Google Data Studio).
- Utilize various data visualization techniques to present complex data in an understandable format.
- Communicate findings and insights effectively to both technical and non technical stakeholders
Assistant Manager SAP/MIS - Herbion Natural Pakistan - Karachi
(2020-10 - 2020-12)
Responsible for analyzing, and interpreting data to provide valuable insights that can guide business decisions and daily operations task of Power BI, SQL, SAP BI.
- Analyze data to identify trends, patterns, and insights that can be used for strategic decision-making.
- Report Development: Create and maintain reports, dashboards, and visualizations using Power BI, SAP BI tools and SQL queries.
- Use Power BI & SAP BI to present complex data in a visually appealing and easy-to-understand format for stakeholders.
- Performance Monitoring: Monitor key performance indicators (KPIs) and business metrics to track organizational performance.
- Ensure data integrity and consistency within the SQL databases, resolving data-related issues as they arise
- Write complex SQL queries to extract, update, and manipulate data in relational databases
- Data Extraction: Extract relevant data from various sources, transform it into usable formats, and load it into the Power BI & SAP BI system.
- Implementation of a Secondary Sales system
- Implementation of a Primary Sales report in SAP BI & Power BI
- Configure and maintain Power BI & SAP BI tools and components to ensure optimal performance and reliability.
- Leading a team of developers and designers, fostering a collaborative work environment.
- Acting as the main point of contact for clients, ensuring their satisfaction throughout the project.
- Implementing quality assurance measures to deliver user-friendly mobile apps that meet industry standards.
SAP ERP & BI Analyst - FrieslandCampina Engro Pakistan - Karachi
(2013-04 - 2020-10)
Responsible for analyzing, and interpreting data to provide valuable insights that can guide business decisions and daily operations task of Power BI, Tableau, SQL, SAP BI & SAP SD, SAP MM Modules.
- Business Intelligence(Tableau, Power BI, SAP BI)
- Data Modeling: Design and implement data models to structure and organize data for efficient reporting and analysis.
- Data Extraction and Transformation: Extract data from various sources, transform it into a usable format, and load it into the BI system for analysis.
- Reporting: Create and customize reports and dashboards to provide actionable insights to decision-makers.
- Data Warehousing: Manage and maintain data warehouses to store and organize large volumes of structured and unstructured data.
- Performance Monitoring: Monitor the performance of BI applications and make recommendations for optimization.
- Data Governance: Implement data governance policies and procedures to ensure data quality, integrity, and security.
- User Training: Provide training to end-users on BI tools and reporting capabilities.
- Business Analysis: Work closely with business stakeholders to understand
- SAP SD Sales and Distribution): Order Processing: Manage the entire order-to-cash process, including order creation, delivery, and invoicing.
- Sales Support: Provide support for sales activities, such as pricing, availability checks, and credit management.
- Customer Relationship Management (CRM): Maintain customer master data and ensure accurate and up-to-date customer information.
- Shipping and Delivery: Oversee shipping and delivery processes to ensure timely and accurate delivery of products to customers.
- Billing and Invoicing: Manage billing and invoicing processes, ensuring accuracy and compliance with financial regulations.
- Sales Reporting: Generate and analyze sales reports to provide insights into sales performance, trends, and forecasts.
- Integration: Collaborate with other SAP modules and external systems to ensure seamless integration of sales and distribution processes.
- Training and Support: Provide training and support to end-users to ensure effective utilization of the SAP SD module.
- SAP MM (Materials Management): Procurement: Handle the procurement process, including purchase requisitions, purchase orders, and goods receipt.
- Inventory Management: Manage inventory levels, stock transfers, and physical inventory processes.
- Vendor Management: Maintain vendor master data and manage relationships with suppliers.
- Material Valuation: Oversee material valuation processes, including price determination and valuation area management.
- Logistics Invoice Verification: Verify invoices against purchase orders and goods receipts to ensure accuracy and compliance.
- Material Requirement Planning (MRP): Plan and optimize material requirements to ensure smooth production processes.
- Integration: Collaborate with other SAP modules, especially SAP SD and SAP PP (Production Planning), to ensure integration across the supply chain.
- Training and Support: Provide training and support to end-users for effective use of the SAP MM module.
- Assist to SAP Basis Administrator for daily operations task including: Transport management, User management, Role management, Backup monitoring, Monitor system logs
- Transport management system from DEV to QAS & from QAS to Production System.
- User management, Roles management, 1st & 2nd Level authorization through matrix for HCM, FICO, PP, MM, WM, PM, SD Modules.
- Daily monitoring of online backups, Performance analysis, error logs & troubleshooting.
- Maintain Profile Parameters (Applying Password Policy SAP Users).
- Departmental assistance to the Manager IS Service delivery that includes: PR creation and releasing in SAP and GRN posting after receiving of goods.
- Maintain the records of IT agreements, purchase job requests, and purchase work orders.
- Maintain Monthly and Yearly accruals.
- Create Monthly Accruals from SAP Tab Run
