Michael Walker Email & Phone Number

Horsley, NSW, AU

Civic, Canberra, ACT Australia

• For the latest three of my six years in the Dept. of Infrastructure I have been part of a project that took a major SQL Server based application and migrated it to Dynamics 365 in Azure. The first stage of the project.
• Writing TSQL stored procedures to:o Extract data from the source system and land the data in an SQL Server staging database.o Cleanse and transform the staging database data, incorporating all the requirements of the.
• Writing SSIS packages (including the 3rd party KingswaySoft SSIS objects) to:o Turn off D365 workflows and plugins.o Execute D365 jobs to delete all the appropriate data in the Azure D365 database.o Migrate the.
• Deploying all migration artefacts to the DEV/TEST/PROD environments.
• Creating SQL Server Agent jobs to perform various tasks including:o Executing an SSIS package to bring down the latest structure of the D365 target database to the on-premise DEV environment.o Executing all the.
• Unit testing data in the source and target UI’s to gauge the success of each migration.

Civic, Canberra, NSW Australia

• I worked at the Dept. of Industry on a ten-week contract to document an existing Excel PowerQuery BI reporting setup created by a former permanent employees who was a Business Analyst. My duties included:
• Bringing myself up to speed on how the reporting system worked and what its ultimate purpose was.
• Understanding how the PowerQueries and their data sources (sql statements, other PowerQueries, & other workbook data) worked and what their goals were.
• Understanding the spreadsheet calculations that were based on the PowerQueries.
• Writing a.Net application to programmatically extract around 100 Power Queries (data source and step code) from multiple Excel workbooks and load them into an appropriately formatted Word document to use as a starting.
• Programmatically comparing multiple sets of PowerQueries located in different workbooks and identifying PowerQueries that were meant to function the same – but had differences (due to manual updates), and then.

Civic, Canberra, NSW Australia

• I worked on a project to migrate a large internal system from SQL Server to a new database platform. In the course of my duties I was responsible for: creating data dictionaries for the source and target databases.
• Word, Excel, Access, SQL Server 2014.

Civic, Canberra, NSW Australia

• I worked in the Dept. of Agriculture on a short fourteen week assignment to assist in the delivery of Phase 1 of their Agricultural Intelligence Transformation Project, which is a part of the Federal Govt’s initiative.
• Toad for Oracle; Oracle SQL Developer; Oracle 10g; MS Access 2013.

Chipping Norton, Sydney, NSW Australia

• Pedemonts is Australia’s largest family-owned furniture transport company. They are a nation-wide carrier that moves furniture by road and rail from hundreds of manufacturers and suppliers to retailers around the.
• A customised invoicing system, as no off-the-shelf system existed that could handle the specific requirements of this removal and storage company.
• A customised costings system that allocated company income and costs (including wages, sub-contractors, vehicle and rail costs) against the various cost centres and depots in the company.
• Integrating the bespoke client/server system with Exchange Online using Exchange Web Services.Tasks:
• Perform business analysis. Design, build, test and deploy databases and client software.Technology Used:
• SQL Server 2008 R2 (databases, tables, triggers, functions, stored procedures, logins, permissions).

Bruce, Canberra, Australia

• Complex Billing Services (COBS) is a department within Telstra set up to handle the billing requirements for large customers who have negotiated contracts with Telstra where the billing conditions of those contracts.
• Write application to create/edit/delete users in Active Directory, add/remove users from AD groups; iterate through all the AD properties for a user and extract relevant data.
• Write application to iterate through IIS on all Web Application Servers, extracting and comparing customer website data.
• Create/edit users in Active Directory, assigning them to AD groups where required.
• Create/edit users and permissions in customer databases.
• Upload documents to customer websites.Technology Used:

Chipping Norton, Sydney, NSW Australia

• Pedemonts is Australia’s largest family-owned furniture transport company. They are a nation-wide carrier that moves furniture by road and rail from hundreds of manufacturers and suppliers to retailers around the.
• Create a client/server application for the Sydney office (around 20 users), soon to be rolled out to depots across Australia, that caters for:
• Document scanning/OCR/storage/retrieval: stores proofs of delivery and other documents. Currently containing over 190,000 multi-page documents and growing by several hundred per day.
• Container tracking: container locations, weights, movement histories; vehicle configurations, overweight breaches; wireless touch-screen tablet pc’s in forklifts.
• Household removal quoting: multiple quote versions; pdf output; email capability; reporting.
• Debtors; Employee Timesheets; Employee Leave; Daily Work Diary.Tasks:

Bruce, Canberra, Australia

• Complex Billing Services (COBS) is a department within Telstra set up to handle the billing requirements for large customers who have negotiated contracts with Telstra where the billing conditions of those contracts.
• Creating Powershell scripts to automate SQL Server deployments of new customer databases – reducing deployment times for each customer from one day to two hours.
• Developing VB.NET utility applications to provide automation and a user interface to the most common DBA tasks.Tasks:
• Deploying new customer databases to test and production environments.
• Deploying change requests to databases in the test and production environments.
• Restoring production database backups to the development and test environments.

Rhodes, Sydney, NSW Australia

• AAS is one of Australia’s largest superannuation administration service providers. It hosts the computing facilities for over thirty large Australian superannuation and pension trusts. My roles at AAS were as a DOC1.
• Create an application comprising a VB.NET service and SQL Server database to read in large XML files and transfer their contents to database tables; perform data manipulation, aggregation, and summing operations on the.
• Create a VB.NET service to read CSV files containing data on employers and members and then use the TRIM SDK to create Locations in TRIM to represent those employers and members, populate User Defined Fields, create.
• Program DOC1 to create member superannuation & pension statements using XML files as input.
• Create and validate XSD schema files; and then XML files against the schema files.
• Maintain TRIM using the TRIM GUI and the TRIM SDK.

Mulgrave, Sydney, NSW Australia

• Le Mac Australia is a printing company located at Mulgrave in North-Western Sydney (near Windsor). They are specialists in tamper-evident packaging and decorative shrink labels for all kinds of products that you would.
• Convert all the MS Access front-end queries to SQL Server 2000 views and stored procedures.
• Walk through all the front-end code in the MS Access applications correcting programming errors and making improvements.
• Impart my SQL Server knowledge to the resident programmer in the company.
• Implement nightly database backups and log shipping every 15 minutes to disaster recovery databases.Technology Used:
• SQL Server 2000; MS Access 2003.

Chipping Norton, Sydney, NSW Australia

• Daikin Australia Air Conditioning is a major player in the Australian air-conditioning market and has branches in each state in Australia. I joined Daikin to build a bespoke CRM application.Project Highlights:
• Produced a system for Daikin that allowed all of its pre-sales projects, sales and service affairs to be tracked on a centralised SQL Server database that is integrated with its accounting system.
• Every branch in Australia and New Zealand now use Internet Explorer, Excel and Access to communicate with the centralised SQL Server database to insert and maintain customers, contacts, opportunities, projects, quotes.
• The application produces regular email reminders and alerts about customers; projects, etc.
• The sales team also uses a custom MS Access application that allows them process quoted and won projects offsite, and then synchronise this information with the main SQL Server database when back in the office or when.
• The service team can now cross-check all service requests and warranty claims with previous claims. All history on units serviced, including parts used, is also maintained. Service technical calls place by 3rd party.

Wollongong, Australia

From January 1990 to September 2000 I spent my time employed by BHP-IT in Wollongong working my way up from computer operator (IBM mainframes), to IT helpdesk & network support (IBM mainframes and VAXes), to applications programmer (SAP/R3).