My experience is based on date transformation, reporting and supply chain management. With my experience in the supply chain and Business intelligence, I can be a good asset to the company because I have the skills and experience and know the market well enough in which I will make sure you receive a positive result in your investment. Iβm also open to learn more by working with the company.
β Perform inventory of supplies to ensure accountability and prepare accurate reports for review.
β Manage supply chain operations for the unit and collaborated with cross-functional teams to coordinate logistics support, including transportation, storage, and maintenance of supplies.
β Manage supply chain operations for the unit, including procurement, inventory control, and distribution of supplies and equipment.
β Maintain accurate records of inventory levels, conduct regular inspections, and ensure compliance with regulations.
β Collaborate with cross-functional teams to coordinate logistics support, including transportation, storage, and maintenance of supplies.
β Conduct inventories and audits to ensure accountability and prepare accurate reports for higher-level review.
Assignment 1: Analytics Platform Implementation
β Conducted customer requirements assessment and created a book of requirements.
β Participated in the Power BI implementation strategy, User needs and opportunities, and subscriptions discussion.
β Studied, and analyzed business requirements in context to business intelligence.
β Designed and mapped data models to shift raw data into meaningful insights.
Assignment 2: JRS Foundation Executive Dashboard Development
ETL Process:
β Developed and maintained technical documentation related to migration.
β Assessed Excel-Macro environment and identified key reports/dashboards to migrate.
β Created a calculation-based file to store all the calculations from Excel reports.
β Archived all Excel reports/dashboards in a secured environment.
β Designed SSIS Packages in SQL Server to handle data migration (ETL Processes) from Excel.
β Performed activities like analyzing and improving the architecture of databases, creation of the tables.
β Used Transformation components to transform, split, merged, and map fields in SSIS.
β Used variables for row counts and data connection switch.
β Schedules Jobs through the SQL Agent to run SSIS packages.
β Configured Email notifications to get alerts on processing status.
β Used containers to organize workflows in the packages.
Power BI Dashboard Development
β Designed and developed two major Executive dashboards according to the standards:
– 2023 Approved Grants (Budget, Payments, and Projections)
– Grants Management (Grants by country, by year, and by Program)
β Actively supported Reporting project life-cycle activities including gathering new requirements, testing, issue tracking, documentation, and project write ups.
β Used Power Query and M language to recreate calculated fields and organize the data.
β Used Parameters to query the data source with values of date type.
β Created clear visualizations of various activity specific KPIs.
β Embedded Power BI dashboards in SharePoint.
β’ Executing price changes, product rotation, and special projects designed to improve how products are displayed to the customer and to meet our suppliersβ needs and expectations.
β’ Learn about products using service tools (i.e., computers, scanners, item generators) and provide information to customers to sell an entire project.
β’ Maintain the in-stock condition of assigned areas, and ensure it is clean, shop-able, and safe.
β’ Providing a safe working and shopping environment by following all safety policies & standards, completing specified safety training, immediately correcting hazards & unsafe conditions, or reporting conditions to the Manager on Duty.
β’ Expediting price checks, approving transactions and markdowns for mainline registers, Self-Checkout, Returns, Pro Desk, Special Services, and Tool Rental.
β’ Provide first level escalation for customer issues and assist in the supervision, coaching and training of other Front-End Associates.