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 is complete, and the system is live in Azure. I was involved in the team that implemented all aspects of the data migration part of the project.Duties included:• 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 BA’s.o Load the staging data into an on-premise SQL Server database that was an exact replica of the Azure D365 target database.• 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 on-premise D365 replica database table-data into the Azure D365 database (entity by entity).o Turn on D365 workflows and plugins.• 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 required stored procedures and SSIS packages to perform a complete data migration run from source to target system – including deleting target system data before reloading.• Unit testing data in the source and target UI’s to gauge the success of each migration.• Working with the BA’s to gain an understanding of the structure of the source and target databases, diagramming these in ER diagrams, and working out the source to target field mapping and transformations.• Maintaining data dictionaries.• Working out of DevOps.• Working out of DevOps Git Repository.• Working using an Agile/Scrum methodology.

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 point for my documentation work.• 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 programmatically copying the correct PowerQueries into workbooks where required to ensure consistency of code among different workbooks.• Manually completing the explanatory documentation in the Word document I had created.• Creating E-R diagrams to show the linkage-structure of the data being queried.Technology Used:• Word, Excel 2016, .Net, Toad for SQL Server, Visio.

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; simple mapping of fields from source to target; applying of cleansed address information to source data as it was migrated to the target database; documenting all mapping, business rules, and the reasons for decisions made about the data; actual coding of some of the data migration.I also had to identify and document: simple and complex transformation of data; which fields would not be migrated and why; default values for target fields that required data where no source data existed; any other business rules that needed to be applied to migrated data; where de-duplication of records in the source database had to occur as the data was migrated, and how the re-mapping of related entities to the de-duplicated records should occur.The above activities involved a large amount of time liaising with the relevant subject matter experts within the department to get information on the source data to be migrated, the business rules for data migration, and to get all of the mapping and business rules signed off by the business.Technology Used:• 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 to make government data more accessible to the public and other external entities. My main task was to examine a legacy survey application, extract and document business rules and data validations embedded within database tables of the application, and undertake detailed data requirements analysis and document business rules as derived from SQL code within the application. The results of my work were then delivered to a small team of business analysts to assist them in the development of a new survey application.Technology Used:• 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 country as well as performing local and interstate removals for companies and private individuals. This was my second stint at Pedemonts. I was called back to enhance the bespoke client/server system that I built for them in 2011. Aside from the numerous smaller projects that I completed, the highlights of the enhancements created were:• 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).• .NET4; VB.NET 2010; MS Excel 2013.

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 cannot be handled by Telstra’s normal billing systems. COBS is an SQL Server and .NET environment with over 30 servers and over 1600 customer databases.Tasks:• 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:• SQL Server 2005/2008/2008 R2.• .NET4; VB.NET 2010; IIS6/7.

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 country as well as performing local and interstate removals for companies and private individuals. I joined Pedemonts to build a bespoke system that would allow for easier control, tracking and reporting of their company operations and their administration department.Project Highlights:• 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:• Perform business analysis. Design, build, test and deploy databases and client software.• Implement automated nightly database backups and maintenance plans.Technology Used:• SQL Server 2008 R2 (databases, tables, triggers, functions, stored procedures, logins, permissions).• .NET4; VB.NET 2010; MS Access 2010; MS Excel 2010.

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 cannot be handled by Telstra’s normal billing systems. COBS is an SQL Server and .NET environment with over 30 servers and over 1600 customer databases. I was one of four people in the DBA team.Project Highlights:• 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.• Setting up and monitoring database log shipping to the disaster recovery environment.• Monitor server usage, free drive space, db sizes, db fragmentation, db backups.• Granting and removing user access to customer databases.• Running regular scripts as requested by operations staff to modify customer data as required.Technology Used:• SQL Server 2000/2005/2008; DTS; SSIS; Powershell.• .NET3.5; .NET4; VB.NET 2008; VB.NET 2010; MS Access 2007; MS Excel 2007.

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 programmer; .NET programmer, and TSQL programmer.Project Highlights:• 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 data; and output the data to a new XML file with a different structure that was easier for the DOC1 application to handle. This saved hours of DOC1 processing time for all large XML files and made the DOC1 programmers’ tasks much easier.• 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 folder records and link them to the Locations, and link document records to the folders.Tasks:• 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.• Use the TRIM Enterprise Manager to add new datasets for new customers.• Configure TRIM datasets - Document Access Permissions, User Defined Fields, Locations, Record Types, Lookup Sets.• Create custom SQL Server stored procedures to search the TRIM database directly to extract required data.• Support in-house .NET applications written in VB.NET and C#.• Write applications to facilitate data migration between systems and Fund transfers-in from external Administrators.• Write small MS Access applications to assist Business Analysts in performing their tasks.Technology Used:• SQL Server; DTS.• VB.NET 2008; C# 2008; MS Access 2007; MS Excel 2007.• DOC1; XML; XSD; TRIM; XML Marker; XML Spy.

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 find on the supermarket shelves and in bottle shops. They had five significant multi-user MS Access databases that had been developed over the previous four years to run their quotation, ordering, and stock control systems. They had upsized the back-end databases from MS Access 2000 to SQL Server 2000.Tasks:• 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, orders, service and warranty data.• 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 dialled in.• 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 contractors fixing Daikin equipment are also logged and analysed. The centralised database provides instant visibility to Channel Managers and Senior Management on all projects, quotes, orders and service/warranty status across the business.• Note: from 01-Apr-2005, SAP R3, and SAP CRM Sales & Service have been operational at Daikin. I was involved in the ten-month implementation – from blueprint discussions to go-live, extracting the data out of our existing systems and loading it into R3 and CRM using SAP BAPIs.Tasks:• Perform business analysis, design, build, test and deploy databases and client software.• Implement automated nightly jobs and database backups.Technology Used:• SQL Server 7/ 2000; VB6; IIS; Classic ASP; Frontpage 2000; Excel 97/2000; Access 97/2000.

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).