As a seasoned Senior Business Analyst with over a decade of experience in the industry, I have a proven track record of conducting a thorough analysis, developing actionable insights, and driving impactful organisational changes through strategic project management. I thrive on solving complex problems, developing scalable solutions, ensuring data integrity, and supporting compliance requirements.I excel at gathering and prioritising requirements, translating business processes into technical functions, and merging disparate data sets to deliver meaningful insights. I have a knack for developing SOPs aligned with best practices and creating dashboards that report on sales, forecasts, and market share.I have a well-rounded background in conducting comprehensive SWOT and stakeholder analyses to address business operations reporting. I played a pivotal role in identifying and implementing fit-for-purpose BI solutions, reconstructing business reports, reducing reporting times, and cutting cross-functional task duplication costs.My expertise extends to ITIL change management, where I have successfully implemented iterative delivery of BI products, evaluated solution efficacy, and communicated necessary changes to stakeholders using ServiceNow and Confluence.My ability to translate complex data into actionable insights has enabled me to support business-as-usual (BAU) activities, deliver insightful presentations on sales and market share, and contribute to new dealer assessments through financial modelling and data analytics.With an MBA and advanced certifications in cybersecurity, project management, and business analysis, I bring a comprehensive skill set to every project I undertake. I am passionate about leveraging my analytical acumen and project management expertise to drive business growth and operational excellence.I am excited about the opportunity to join a forward-thinking organisation where I can continue to make a meaningful impact, drive strategic initiatives, and foster a culture of continuous improvement. Feel free to connect with me here or at erick.zambrano@ymail.com, I will be delighted to answer any enquiries you may have.
-
Senior AnalystSeven NetworkSchofields, Nsw, Au
-
Senior Business AnalystInchcape Australia 2019 - PresentNorwest NswRESPONSIBILITIES:♦ Implemented iterative delivery of BI products to evaluate solution efficacy.♦ Captured functional and non-functional requirements to develop detailed user stories.♦ Defined and documented acceptance criteria user stories, ensuring delivered solution meets business needs.♦ Identified, documented, and tracked issues discovered during UAT.♦ Coordinated and participated in verification testing activities to ensure business readiness. ♦ Logged and categorised changes to prevent scope creep.♦ Prepared and communicated change processes with stakeholders, tracked issues with ServiceNow, and evaluated critical system changes.♦ Applied advanced techniques to extract actionable insights, facilitating data-driven decision-making.♦ Provided ongoing business and technical advice, developed training content, and tracked solution efficacy and enhancements with Confluence and Jira.♦ Ensured requirements were validated in the test phase before scheduling for delivery in production.Key Highlights:♦ Minimised reporting times by 40% and saved $150K annually by mitigating reporting and data security risks and implementing data analytics solutions in collaboration with solution architects.♦ Improved data integrity by 27% using BPMN to identify interconnected data process dependencies, opportunities to automate data migration and implement cleansing processes.♦ Developed detailed SOPs and policy documents, improving post-implementation support for data transformation projects and refining insights for claims reconciliation and forecasting.♦ Implemented ITIL change management processes and facilitated iterative delivery of BI products, ensuring solution efficacy and preventing scope creep.♦ During the Takata Air Bag incident, prepared user stories, refined business rules, and addressed reporting gaps using Jira to facilitate immediate reporting ASIC mandated insights to support ACCC industry audit for Takata Air Bag remediation. -
Senior Business Analyst / Business Intelligence AnalystSubaru Australia 2013 - 2018Norwest, Nsw AustraliaRESPONSIBILITIES:♦ Gathered and analysed reporting artifacts and prepared data dictionaries and relationship diagrams.♦ Captured functional / non-functional requirements, to develop user stories.♦ Defined & documented acceptance criteria user stories, ensuring delivered solution meets business needs.♦ Identified, documented, and tracked issues discovered during UAT.♦ Coordinated /participated in verification testing activities.♦ Collaborated with solution architects to design scalable, compliant solutions.♦ Delivered BI standards, interface user guides, and reporting structure to ensure security and access.♦ Provided regular project updates to the product owner and executive team.♦ Organised stand-up meetings and product reviews as well as developed training programs for non-technical stakeholders. ♦ Tracked BAU activities using Trello and delivered data analytics reporting.Key Highlights:♦ Performed SWOT analysis and stakeholder analysis to evaluate BI solutions and delivered enterprise analysis of global BI solution alternatives, highlighting limitations of the SAP suite for local use.♦ Conducted information sessions with stakeholders and prepared As-Is and To-Be analyses, consolidating process documentation and promoting improvements.♦ Saved $850K by selecting alternative BI solutions and reduced infrastructure complexity costs by 40%, saving $150K.♦ Completed BI systems security assessment and addressed security risks of third-party reporting platforms, while also developing new internal security measures.♦ Secured a $1M budget increase for local data warehouse development and design work.♦ Improved user workflow by 70% through tailored training programs and super-user training.♦ Identified and forecasted unprofitable dealerships using geo-location platforms and metrics.♦ Produced insights on sales and market share and contributed to new dealer assessments and Greenfield projects through business case generation and financial modelling. -
Commercial AnalystChep 2012 - 2013North Ryde, Nsw AustraliaRESPONSIBILITIES:♦ Communicated budget schedules and solicited year-end P&L forecasts from service centre managers.♦ Consolidated forecasts to support evidence-based decision-making through financial analysis and reporting.♦ Delivered requirements elicitation and documentation for necessary finance and year-end activities.♦ Developed process documentation to manage workflow, including schedules of tasks, stakeholders, dependencies, business rules, and process steps.Key Highlights:♦ Improved budget management and cost forecasting by supporting evidence-based decision-making through comprehensive financial analysis and reporting.♦ Created and delivered detailed process documentation, ensuring workflow continuity and addressing knowledge gaps, which facilitated smooth finance operations during staff absences.♦ Contributed to future process improvement activities by producing thorough documentation of tasks, stakeholders, dependencies, business rules, and process steps, adding valuable artifacts to the project repository. -
Business IntelligenceMckey Distribution 2010 - 2012Kings Park Nsw, AustraliaRESPONSIBILITIES:♦ Prepared weekly KPI reports, including DIFOT, service satisfaction, throughput, and unit costs. ♦ Conducted GAP analysis and GL reconciliations, while also supporting ongoing reporting and analysis operations. ♦ Contributed to cost planning and month-end reporting processes. ♦ Led contractor costing analysis projects, organising project assessments with subject matter experts for review and validation of next steps. ♦ Reported gaps in the existing ERP system and addressed data issues by collaborating with DevOps. ♦ Conducted business assessments to address warehouse inefficiency.Key Highlights:♦ Developed solution requirements for data flow automation and data integrity and prepared business cases supporting investments to improve warehouse operations.♦ Achieved $0.8M in inventory savings and $970K in pallet racking space savings with a 1.5-year payback period by optimising inventory management.♦ Improved the finance accrual methodology for Australia and NZ, enhancing issue tracking for P&L reporting from JDE.♦ Enhanced P&L reporting granularity and improved control over a $10M cost base by delivering specifications for enhancing reporting capabilities through the JDE report manager.♦ Streamlined reporting processes and avoided unnecessary infrastructure costs for a new system by developing specifications for data flow automation and improving data integrity.♦ Realised $700K in yearly operational savings by enhancing warehouse space utilisation, including the reorganisation of staging bays and replacement of outdated equipment. -
Business AnalystWattyl Australia Pty Ltd (Wapl) 2007 - 2009Norwest, Nsw, Australia -
Senior Business AnalystTnt 2004 - 2007Strathfield Nsw, Australia
Erick Zambrano Education Details
-
Fortinet Training InstituteNse 1 & 2 Network Security Associate -
Seek LearningBusiness Analysis
-
Qtc Consulting Pty Ltd (Australian Institute Of Project Management Endorsed Program)Project Management
-
Business Administration / Finance
Frequently Asked Questions about Erick Zambrano
What company does Erick Zambrano work for?
Erick Zambrano works for Seven Network
What is Erick Zambrano's role at the current company?
Erick Zambrano's current role is Senior Analyst.
What schools did Erick Zambrano attend?
Erick Zambrano attended Tafe Nsw, Tafe Nsw, Fortinet Training Institute, Tafe Nsw, Tafe Nsw, Seek Learning, Qtc Consulting Pty Ltd (Australian Institute Of Project Management Endorsed Program), Murray State University, Campbell University, Norman Adrian Wiggins School Of Law.
Not the Erick Zambrano you were looking for?
-
2fanatics.com, tcco.com -
2ventura.org, lids.com -
-
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial