Sergio Insuasti Email & Phone Number

Sydney, Australia

- As part of the General Assembly Immersive course, I worked for Sellable to complete a project using Machine Learning to predict property valuations. My brief was to create a model that would use property features that were scraped from a number of real estate sites, then compare the predicted valuation to the mean website valuation.- Using image recognition also calculated the lot and built area. - Built a HTML page using flask as a Data Entry screen to enter the features to be used to predict, using the Machine learnt algorithm.

9/605 King Street

- Oversaw commercial and operational aspects of the restaurant, which included inventory control, purchasing, event management, book keeping, expense control, health and safety compliance, marketing, promotions, and customer service. - Daily administrative tasks including balancing cash and reconciling daily POS sales, analyzing and disseminating restaurant sales and customer bookings information, taking inventory and ordering stock.

347 Kent Street, Sydney 2000

Lead Data Analyst Sep 2007 – May 2016ANZ Wealth, Sydney, NSWANZ Wealth is one of Australia’s leading fund managers.- I provided strong leadership including resource management, risk mitigation, project planning, scheduling, contract negotiations, project documentation standards, quality assurance, and best practices.- Heavily involved with the migration of both Test and production Data Centers in Sydney to Melbourne, this included creating deliverable timelines, Data gathering and Infrastructures build. Mirror Imaging and Storage allocation of customer data, making sure replication was correct as well as regression testing was done.- Set up and build Test environments for Software system integration testing(SIT), user acceptance test (UAT), price verification testing(PVT) Environments, including populating with correct data from backups of all downstream systems involved. - Implemented Disaster Recovery of 128 applications making sure that all applications have the correct documentation and procedures to be recovered at all instances, also verifying that all the data and both batch jobs and online applications function correctly. - Reviewed and signed off on Functional Specifications(FS), Technical Design Reports(TDR), Program Change Requests(PCR), Test Summary Reports(TSR), Service Level Agreements(SLA), Warranties, Handover documents and Programming Source Code.- Promoted source code and data packages across environments with the correct source control procedures following the Software Development Life Cycle(SDLC).- Built and maintained strong working relationships with all stakeholders, including customers, suppliers, vendors, contractors, management, 3rd party contractors and internal & external staff.

347 Kent Street, Sydney 2000

- I was brought in for project Chrysalis which was to convert all MPE Applications from MPE to UNIX. Duties included writing Business Test Cases and Data models, gathering all required information for Level 1-3 total cost estimations, which included getting all program line counts, all files, all databases, total storage required, all virtual and Physical servers (rebuild, populate and deploy). I produced excel spreadsheets with system schedule flowcharts to orchestrate the sequence of events and changes making sure it doesn’t affect the day to day operation of the business. I wrote Business Cases from Initial briefs as well as Functional, Technical and Architectural specifications to fit the required data format to achieve the business outcome. I resourced the required SME with the appropriate Business Analyst against the required task and results required.- SME for all MPE Legacy systems, and system owner of APP application- Designed and implemented a Master Data application for the finance team to transitioned $30 Billion of Assets from IIM (ING Investment Management) to JP Morgan, Using Master Data and Excel Uploads to change configuration, with combined parallel testing.- Created prove of concept scenarios and brainstorming with the business, architects and SME’s to determine what data is required (to be massaged or to be created), what testing, what timeline is required to incorporate a new application or Fund, as well as generating and formatting new data received via data entry screens - I built a farm of work stations (Utopia) that automated the printing generation of prn file to be sent to IBM and Salmat for document printing, I later built a virtual server that was more efficient and cost saving.

Pennant Hills

- Maintaining main databases (Stock, Orders and Containers). - Re-writing systems as well as automating functions requests by Sales Department.- SQL scripting and report writing for financial reporting and new sale orders - Reconcile stock database for re-orders and stock on hand

North Sydney

- Traveled around the world analyzing Client Systems and Data bases- Cleaning and converting Client Policy Data to make the data compatible to be migrated to Ingenium (Life400) - Big Data files of 1 million to 50 million policies- Creating relational database and documentation- Developed Claims system using COBOL- Was involved in tender requirement gathering as well as documentation, - Business analysis and requirement gathering, writing functional and technical specifications.- Wrote SQL scripting to cater for client migration plus 24/7 Support

Sydney, Australia

- Developed a new Front End Application (APP) for accepting New Business- Liaised with downstream systems on the build requirements- Building consisted of screens and back-end programming and reporting- Looked after the MPE legacy Applications (Annuities, Policy, Accounts, Billing, Price, Agency, Trust and Integra). - Incorporated new takeover companies that Mercantile mutual took over- Data mapping fields to be compatible to Mercantile Mutual's Data- Re branding and transitioning to ING Australia which involved producing new rates and funds- Financial reporting for auditors usage- Report writing for business requirements and reporting plus adhoc programming and Keeping the lights on- Compensation calculation on specific policy holdersProducing Policy Documents and RenewalsMaintaining Agency, Memo, Doctors and Medical databases

Computer Programming, Diploma

Bachelor'S Degree, Computing & Operations

Lrea, Real Estate, Certificate Iv

Activities and Societies: Real Estate Agent and Auctioneer Gained my Certificate of Registration and my Real Estate Agent License.

Data Science

Health And Physical Education/Fitness, Certificate Iv

Activities and Societies: Master trainer

Massage Therapy/Therapeutic Massage, Certificate Iv