Frank Wei Email & Phone Number

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

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

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.

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

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

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

Itil V3 Foundation For It Service Management (Certified)

Bachelor’S Degree, Computer Science