Business Intelligence Analyst

✓ 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.