Adel Bernardino

Technology/Software Used: Microsoft Stacks (Office/SSMS/SSAS/SSIS), Power BI/Report Builder, Power Query, Tabular Editor (TE), Jira/Confluence

• Collaborated with cross-functional departments to create Power BI Reports/Dashboards on Budget/Forecasting versus Actuals Analysis (OPEX/CAPEX), Inventory Movements and Trend, Product sales analysis, Store Traffic and Conversion analysis, OOH/Sales Order/PO data analysis, Sell-Through/Sell-Out data
• Lead in creating data cubes and OLAP models to improve data analysis for APAC subsidiaries that encompasses defined data points for analyzing different aspect of company's business
• Provided technical support for troubleshooting analytics and reporting issues.
• Provided training to business users on the usage of reports and created documentations for future references

Technology/Software Used: SQL (MSSQL), Power BI Desktop, Power BI Service, Screensteps

• Lead company in expanding and growing BI awareness, implementation and training
• Managing over 90 active Pro users across all subsidiaries globally and for cross functional teams
• Managing over 30 published Power BI reports ranging from sales vs budget to stock replenishment
• Developing new business analytic reporting, Dataflows and Data Modelling in line with requirement from Sales/Supply Chain/Logistics/Finance/Product Team
• Lead a small team in building pragmatic data governance and management plan focusing on enabling business value by ensuring data breadth, depth, and quality
• Introduced "Screensteps" which is a knowledge base software that enable data owners to create manuals or to document important procedures efficiently
• Testing and unlocking several system features to block certain user access and standardized system-wide object-security settings per user classification/hierarchy for 150+ active users
• Provide reports routinely to data owners to maintain integrity on mandatory fields set in the system
• Supported in several databases merging activities and post-merge data clean-up involving hundreds of master tables and documents

Technology/Software Used: SQL (MSSQL), Power BI Desktop, Power Query, Microsoft Office

• Managed 5 major product lines which accounted for over 30% of total annual revenue
• Provided monthly Point-of-Sales (POS) data and inventory report
• Provided annual budget/forecast, stock replenishment plan and market intelligence
• Provided internal training to sales department for new products and/or pricing strategy
• Created PowerPoint presentations and product brochures
• Lead the introduction of Business Intelligence platform (Power BI) to the organization to help empower the sales team and product line managers in managing their business and to focus resources more intelligently
• Worked with sales directors/managers to determine important KPIs to track
• Worked with IT department to set-up back-end infrastructure, set-up dedicated SQL server and databases, Power BI Gateways, acquiring pro licenses
• Created reports and dashboards to track high-level sales KPIs

Technology/Software Used: Pentagon P2000(SQL), Excel

• Managed request for quotations, order processing, returns and after-sales support for all major Airlines and MROs in the Philippines, Thailand and Myanmar
• Sold an average of $10million annually; around 15% increment compared to prior years
• Introduced over 15 new customers vertically expanding to General Aviation and OEM customers
• Responsible for sourcing parts that were out of company's product catalog
• Over 50% of total revenue were outsourced including helicopter blade repairs and GA engines ($500K)
• Responsible for reporting sales pipelines and projects
• Traveled and participated in Airshows and sales conferences

• Analyzed requirements and specification from a testing perspective
• Create, execute and verify Test Plans, Test Cases and report Bugs
• Performed regression testing to verify closure of defects / issue
• Supported Application Releases and provide input into Implementation Plans
• Supported and committed to established QA processes, metrics and methodologies
• Managed and prioritize workload; escalate conflicting schedules to Lead / Manager