The Advanced Metering Infrastructure (AMI) Program has been established in response to the Victorian State Governments proposed AMI mandate. The program is responsible for the solution definition and rollout of meters, communications and backend systems. Major Projects:• MSATS• Logical Conversion• Field Mobility Computing (FMC)• Market Management System (MMS)My job responsibility includes the following:• Execution of data extraction, manipulation and analysis of large data sets from high transaction enterprise systems (SAP IS-U) using tools such as, MS Access, MS Excel (Vlookup, Pivot table) and enterprise scale query tools that integrate with Oracle databases• Developed data cleanse dash boards for weekly meetings.• Co-Ordinate with the AMI Project Manager and Business Analyst in matters relating to Dash Board development• After each cycle review and develop sound procedures in the data cleanse procedure and present the files to the business.• MS Excel (advance user of pivot tables, Vlookups() ) and MS Access are used to manipulate, cleanse ,analyse and present data. Ability to write, modify and understand simple SQL queries.• Experience in working with variety of file formats.(csv, xls,xlsx)• Responding to various data related queries, communicating and actioning with the business stakeholders to remediate data issues. Highlighting the importance of data accuracy and integrity• Co-Ordinate the remediation of data cleanses items by the business.• Obtain business approval to proceed with cleanse activities.• Implement data cleanse fixes where appropriate• Interpretation of issues and risks registers as inputs to the analysis process• Detail options to remediate Data Quality issues• Plans to resolve Data Quality issues• Maintenance of risks, issues, dependencies and assumptions in SharePoint• Data uploads to SharePoint

AUBIT Consulting is a small, independent Melbourne-based consultancy who specialise in the delivery of process and system based solutions to clients in the Utilities and Infrastructure sectors. Hired directly by the Director of the company, my remit includes the following;• Specification Development including:o Functional and non-functional specificationso Process model documentation – maps, definition statement, activity diagramso Interface specifications – UI, reports, integrationo Data Model and Data definition documentso Preparation of RFI and RFT documentation for impending solution developmento Vendor Managemento Designing o Communication /Co-ordination with the offshore development team • Projects:o Specification Development and Vendor Management for the delivery of an enterprise class, portfolio management system (PRISM)o Design and vendor management for the up-coming re-development of a divisional website within the companyo Design and vendor management for the development of a mobile device application (native app) for Infrastructure Company enabling the purchase of services from this client well in advance of usage.o Design and vendor management for the development of a mobile device application (native app) for a swim suit brand enabling the customers to browse and purchase items through the app.

Data Analysis:o Design, construct, modify, integrate, implement and test data models and database management systemso Work in conjunction with other user groups to understand functionality, scalability, performance, security, and integration requirements of the datao Responsible for migration of data from legacy systems to newly developed systems through scanning, data entry and electronic data transfer mechanisms, after that load testing of the system is also carried out.Conduct research and provide advice to other information systems users regarding the collection, availability, security and suitability of datao Validate quality of existing data and performed gap analysis by comparing current state data with future business requirements and enhancements• System Design:o Interacting with user departments for presenting technical solutions, finalising requirements, demonstrating and trainings to concerned stakeholders.o Preparing technical and business development documentations for projects.o Preparing process and functional design and its transformation into overall system and database design based upon the complex business requirements collected from users during multiple requirement analysis sessions.o Develop and demonstrate the prototypes to user department based upon the functional designs.o Managed the overall development, testing and implementation activities.o Reviewing and participating in walk through meetings for documenting the requirements / deliverables with user departments and team members• Database Administration:o Responsible for providing day-to-day support and maintenance of Oracle databaseo Developing policies and procedures for database access and usageo Accountable for proper Backup and Disaster recovery procedureso Design and develop database architecture for information systems projects