Frank Wei

Frank Wei Email and Phone Number

Business Intelligence Analyst @ Downer
australia
Frank Wei's Location
Greater Sydney Area, Australia
Frank Wei's Contact Details

Frank Wei personal email

n/a
About Frank Wei

PROFESSIONAL SUMMARY• An IT Professional with over 15 years’ experiences in local government, IT, Enterprise Services and Not for Profit industries.• Supporting Australian Taxation Office and Commonwealth Bank for almost 10 years on service management forecasting as well as service level agreement (SLA) reporting• Australian Tax Office Security Clearance (currently through Hewlett Packard)• ITIL V3 Foundation for IT Service Management (certified)• High-level analytical and excellent numeracy skills, strong attention to detail and commitment to provide an all-round positive customer experience by understanding and addressing their needs, continuous process and delivery improvement, combined with a collaborative approach and can do attitude.• Well-developed interpersonal and communication skills, and the ability to build highly effective relationships and work collaboratively with stakeholders at every levelPROFESSIONAL COMPETENCIES• Professional report design and development skills with SSRS, Microsoft Power BI, Crystal Report (includes SAP BusinessObjects Web Intelligence), ITSM/ServiceNow, Xtraction, BMC Analytics and Excel PivotTable• Strong database, data warehouse and ETL skills in SQL Server and Oracle databases• Professional skills in creating complex queries, views, stored procedures, functions, derived tables and business objects across optimization techniques• Strong analytical, problem solving and reporting skills• Proven ability to manage end-to-end service management forecasting as well as Service Level Agreements (SLAs) reporting and monitoring• Strong Service Desk tool (ITSM) skills in HPSM, MyService, BMC Remedy and SM9• Strong knowledge on reporting and dashboard solution tool Xtraction• Strong HTML, JavaScript, VB Script programming, including proficiency in Microsoft Word and Excel• Good communication and interpersonal skills with the ability to address needs at all levels• High learning agility with a keen interest in taking on additional and new responsibilities

Frank Wei's Current Company Details
Downer

Downer

View
Business Intelligence Analyst
australia
Website:
downergroup.com
Employees:
11468
Frank Wei Work Experience Details
  • Downer
    Business Intelligence Analyst
    Downer Apr 2021 - Present
    Sydney, New South Wales, Australia
    Key accountabilities include:• Gathering requirements for data insight projects and produce a statement of work and scope documentation• Hosting requirements gathering discussions/workshops with both technical and non-technical stakeholders• Communicating progress and requirements to both business and technical stakeholders• Design reporting content based on user requirements• Developing new Power BI reports and dashboards (on-prem & cloud)• Developing new reporting content in SSRS (paginated & mobile reports)• Support existing Power BI & SSRS reporting content• Write queries in T-SQL to be consumed by reporting content
  • Mosman Council
    Report Analyst
    Mosman Council Sep 2017 - Dec 2020
    Civic Centre, Mosman Square | Spit Junction Nsw 2088
    Responsibilities • Consult with stakeholders to understand requirements and critically evaluate information from multiple sources • Develop and write business requirements for the design of report solutions • Develop and generate reports solutions • Perform analysis for a wide range of requests using data in different formats and from various platforms • Perform Information Quality Assurance duties including data verification, de-duplication and consolidation of data across multiple platforms • Provide input to new technology opportunities that will have an impact on the strategic objectives • Promptly and accurately register and record all IT and corporate related correspondence and documentation including emails into Council's electronic Corporate Information Management System (ECM) as required • Ensure all work is carried out in accordance with legislative, industrial and Council policy requirements and standards in the area of Equal Employment Opportunity
  • Dimension Data
    Reporting Analyst
    Dimension Data Dec 2016 - Jun 2017
    121-127 Harrington St, The Rocks Nsw 2000
    Responsibilities • Assist with the delivery of an agreed level of IT service as contained in the Service Level Agreement with the client.• Analyze ticket information specific to breached status, ensuring a deep dive is completed and reported in clear written standard• Complete Monthly/Quarterly/Bi-annual Reporting in a timely basis, all recognized/requested Client SLA Reporting. Ensure that all missed SLA's are reviewed to determine the reasons why and if SLA has been met due to Client that the SLA data is updated correctly. Preparation of Graphs and Services Levels within the Client Report.• Assess the environment (people, process, calls, etc.) to determine trends and problem areas. • Identify sources of data for existing and new reports. • Work closely with the internal clients to define what would add value to existing reports. • Enable valid business decision making by ensuring that the data published is valid, accurate and correct.
  • Hp
    Information Analyst - Service Level Information Management
    Hp Sep 2009 - Oct 2016
    Level 5, 410 Concord Road, Rhodes Nsw 2138, Australia
    Responsibilities • Microsoft Business Intelligence report design and creation• Service management forecasting as one of the functions in capacity management• Interpret customer requirements based on agreed SLAs and ensure gaps are addressed and mitigated• Customize and design data extracts and prepare data for reporting period as required ensure data integrity• Design and implement effective customized reporting solutions and improvement initiatives• Create stored procedures, functions, views and any queries as required• Manage root cause analysis and address issues identified to resolution• Data mapping, mining and migration for reporting purposed• Onboarding - create repositories, configuration and definition of metrics• Change Management where relevant to reporting• Willingly share and leverage tools, resources, experiences and personal networks• Ensure standard procedures and processes are followed, and standard tools and processes are utilized• Deliver process improvement through innovation
  • Electronic Data Systems
    Information Analyst - Service Level Information Management
    Electronic Data Systems May 2007 - Sep 2009
    Level 4, 36-46 George St Burwood Nsw 2134 Australia
    Responsibilities• Creation, maintaining and following standard reporting procedures including documentation and design• Stayed current on emerging tools, techniques and technologies• Translated client business needs into system/application requirements. Proactively identify and manage changes to requirements and identify risks for EDS/client. Effectively manage client expectations• Creation of ITSM reporting for Executive, Business Stakeholder and Operations or ad-hoc as required by• Service Management to identify root cause, analysis• Performed the phases of the Systems Life Cycle from design/construct solution through optimization of the solution to meet client’s business requirements, within the defined technical environment, optimize code, and perform testing• Initiated, influenced and supported the planning and implementation of programmers needed to successfully achieve a business objective• Assessed the specific set of testing tasks and deliverables. Ensure valid and complete test plans and test cases are available for execution. Ensure timely completion of independent testing focusing on the quality of the solutions• Delivered Process Improvement through Innovation• Documented Detailed Report Requirements from Requirement gathering • Developed/System tested/Implemented solutions• Provided production support and Application admin to MSRS
  • The Australian Council On Healthcare Standards
    Analyst Programmer
    The Australian Council On Healthcare Standards Feb 2005 - May 2007
    5 Macarthur St, Ultimo, Nsw 2007
    Responsibilities• Designed and built various reports in MS CRM with SQL Server Reporting Services• Customized, develop, fix and maintain callouts, entities and database in MS CRM• Designed and built the user interface objects, data entry validation and database objects for creating the solution for applications• Performed IT applications development, management and support• Coded stored procedures, DTS, triggers, and integration checking procedures in the development• Provided the database performance tuning for client support projects• Designed, built and updated client-server reports using SQL Server Reporting Service

Frank Wei Skills

Sql Microsoft Sql Server Oracle Requirements Analysis Databases .net Vb.net Sdlc Crystal Reports Incident Management Itil Pl/sql Ssrs Software Development Life Cycle Sql Server Reporting Services Asp.net Business Objects Transact Sql Itil Certified .net Framework Sap Businessobjects It Service Management Visual Basic .net It Management It Strategy Integration

Frank Wei Education Details

  • Exin
    Exin
    Itil V3 Foundation For It Service Management (Certified)
  • The University Of Auckland, New Zealand
    The University Of Auckland, New Zealand
    Computer Science

Frequently Asked Questions about Frank Wei

What company does Frank Wei work for?

Frank Wei works for Downer

What is Frank Wei's role at the current company?

Frank Wei's current role is Business Intelligence Analyst.

What is Frank Wei's email address?

Frank Wei's email address is frank.wei@hp.com

What schools did Frank Wei attend?

Frank Wei attended Exin, The University Of Auckland, New Zealand.

What skills is Frank Wei known for?

Frank Wei has skills like Sql, Microsoft Sql Server, Oracle, Requirements Analysis, Databases, .net, Vb.net, Sdlc, Crystal Reports, Incident Management, Itil, Pl/sql.

Who are Frank Wei's colleagues?

Frank Wei's colleagues are Phillip Wang, Stephen Todd, Kevin Mackay, Aron Jones, Christiana Wonohusodo Mit, Cpa, Anna Kucerova, Stephen Sherman.

Not the Frank Wei you were looking for?

  • Frank Wang

    Accounting Manager At Oz International Investment Pty Ltd
    Greater Sydney Area
  • Frank Wei

    Ecommerce Manager At Amer Sports Anz
    Melbourne, Vic
  • Frank WEI

    Deputy Head Of Treasury - Treasury Department At Industrial And Commercial Bank Of China (Sydney Branch)
    Greater Sydney Area
    1
    icbc.com.au
  • Frank Wei

    Greater Sydney Area

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

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.