Stewart Mac
About Stewart Mac
• Seasoned Business Intelligence/Analytic Manager with a robust history at Palo Alto Networks, adept with SQL and data visualization tools like Tableau. Spearheaded teams with a proactive approach, significantly enhancing workflows. Excelled in roles requiring meticulous requirement analysis, leveraging a blend of technical expertise and strategic partnership. • 7+ years of experience as Developer and Business/System Analyst with sound knowledge in different phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, documentation and maintenance. Perform other roles such as Technical Support, Tech Lead and Project Manager. • 15+ years of extensive experience in Business Intelligence tools using Business Objects, WebI, Xcelsius, Qlikview and Hyperion Reporting Studio. • Expertise in designing and modeling of Tableau/Qlikview with complex multiple data sources (SQL, Flat Files, Excel, Access, Salesforce and Teradata). • Good knowledge of Data Modeling using Entity-Relationship Model, Dimensional Data Modeling, Star schema and Snowflake schema, Fact and Dimension table design, physical and logical Data modeling. • Strong analytical, technical, logical, code debugging, problem solving, communication, time management and interpersonal skills. • Work with business stakeholders to understand business problem and opportunities in the context of requirements and recommend solutions that enable the organization to achieve its goals. • Experience in extraction, transformation and loading (ETL) using Sagent and BODI. • Aptitude to learn new things and ability to perform under stress. Specialties: Qlikview, Xcelsius, BO, Infoburst, Enterprise Manager, TOAD, Sagent, Remedy, Essbase, Excel, Word, Access, PowerPoint, Visio, Visual Source Safe, FrontPage, Projects, Adobe Illustrator, Adobe Photoshop, PageMaker, Oracle, SQL Server.