Alex Galan Email & Phone Number

Sydney, Nsw, Au

Sydney, New South Wales, Australia

- SME for SeQoya Salary Packaging, InfoOrganiser Electonic Records and Catch-e Software products.- Helping developers with all SQL Server Database issues. Stored Procedures, building & modifying database objects, Backup/Restore & maintenance Jobs including performance issues. - T-SQL scripting for data importing, massaging/cleaning and data querying.- Working with stakeholders to produce analytics and data extracts from SQL database to report on SLAs, Call and Emails actioned on a daily basis.- Maintaning leasing quotes Adobe PDF Template financial calculations using Javascript.- AdHoc Import and Export of Employee, Salary, Bank cards, and Superannuation data to and from SQL Server using SQL Server Integration Services.- Scheduled SQL Agent jobs to extract data to HTML Emailed data reports- Optimising SQL Stored Procedures.- Visual Basic 6/VBA Development.- Excel macro review and digital signing.- Add hoc backup and restores requested by the business.- Working on and updating tickets related to issues and projects on JIRA in Devops environment. (Atlassian)- Helping with and testing SQL server patching. - Documentation of all business process's and help topics on Confluence. (Atlassian)

Sydney, Australia

Sydney, Australia

- Full SDLC management of SeQoya (VB6) and MSG Salary Packaging Software development (VBA).- Microsoft Visual Basic 6, SQL Server 2008/R2/2012, TSQL, SSIS and SSRS. - ASP.NET development, VB, C#, Dotnetnuke, IIS, Microsoft Access, Excel.- Third level support, documenting functional and technical requirements.- Client Visits, Presentations and SQL Server Installation and configuration.- Requirements Analysis and Development work Quotation..- Mentoring a team of Developers and Business Analyst.

Sydney, Australia

- Full System Development Life Cycle Visual Basic 6 Software Development. - Ad hoc reporting using T-SQL and/or Crystal Reports xi- Functional Specifications & Technical Application Design documents for new applications for sign-off by business.- Managed UAT Deployment and Production Rollout of new and application upgrades- Built content management system using DNN, VB.NET and SQL Server 2008R2 - Worked with Help-Desk and First-Line Support to resolve daily technical issues for the user base.- Worked with key stakeholders in the Business to ensure that all deliverables met user criteria and dates.- Business requirement analysis and functional specification design and documentation- Extensive end user interaction for gathering requirements, design and UI approvals and User acceptance testing.- Experienced in Software Presentations and Training Sessions. - Designed, developed and administered SQL and Ms Access databases,stored procedures and Data manipulation and Querying.- Developed DTS/Integration Services packages to transfer data between different databases.

Sydney, Australia

- Worked on core Treasury product following standards and development practices- N-Tier product developed in Visual Basic 6 using DCOM, MTS- Microsoft SQL and Oracle support- Triggers, Stored Procedures, and Views

Group insurance and business analyst.

Graduate Diploma, Systems Development

Associate Diploma Of Computing (Certificate 1,2,And 3), Information Technology

Higher School Certificate