• Optimized Paybox database for performance improvement of poorly running processes.• Redesigned Paybox database and developed new tables and stored procedures for Data Archiving. • Configured and updated Paybox database solution for Payment file (MFT) processing.• Migrated all NovaPark and Paybox SSIS packages from SQL Server 2005/2008R2 to 2014.• Updated all SSIS packages to add parameters so that they could be executed on Dev, Test or Prod.• Investigated and updated SAP Crystal Reports to fix issues raised during version migration.• Developed Data Obfuscation scripts to obscure personal information and pictures before migrating SQL Servers to Microsoft Azure Cloud.• Developed Data Migration scripts to update legacy 2005 data and migrate them to new 2014 server.• Designed and developed database optimization processes for all databases based on Index fragmentation. • Performed database performance tuning and optimisation of existing T-SQL stored procedures and functions.• Maintained NovaAnalytics DWH solution for successful ETL execution and Cube Refresh.• Developed and maintained NovaPark, Paybox and DBA database solutions using TFS 2013.• Monitored and maintained production SQL Servers and databases for all Local Government systems.• Setup and configured new 2014 NSUP SQL Servers for Prod, Test and Dev environments.• Migrated all production SQL Server 2005/2008R2 databases to SQL Server 2014 databases.• Successfully implemented AlwaysOn Availability Groups for all NovaPark solutions for Disaster Recovery (DR).• Designed and developed DBA Maintenance database for backup, SSIS execution and database update.• Worked on Windows Failover Cluster environment for administration and maintenance of production servers.• Implemented and maintained Transaction Log Shipping and Replication for NovaPark reporting databases.• Developed and maintained DBA Perfmon Collector database to collect performance related data.

• Successfully designed and developed many database solutions according to business requirements.• Implemented complex billing processes like Pricing, Tariffing, Tax, Invoicing and Apportionment using T-SQL stored procedures, functions and triggers.• Designed and developed database schemas and tables for many customized billing solutions.• Developed complex SSIS packages to load Telstra billing data using Visual Basic.NET and Visual Studio .NET.• Developed paginated, drill down, drill through, chart reports using SSRS, T-SQL and MDX. • Designed Dimensional Modelling for GDS Data Warehouse using bottom-up approach (Kimball method).• Developed SSIS packages to load data from CSV, Fixed Width and Excel files from different Telstra customers.• Designed and developed reports using SQL Server Reporting Services (SSRS), T-SQL and stored procedures.• Designed and developed SSIS packages to transfer data from Inventory database to GDS DW.• Developed SSIS packages to extract data from customer databases into CSV files and zipped them up.• Developed facts and various dimension tables using Star & Snowflake Schema for GDS DW.• Built SSAS solution for GDS DW with various dimensions, cubes, calculations and processed and deployed them.• Performed database optimization and performance improvement for ABRS solutions and GDS DW cubes.• Used MDX and Excel PowerPivot to query GDS DW cubes and developed customized reports.• Implemented Data Mediation processes in CLR stored procedures and functions using C# and Visual Studio .NET.• Designed and developed data validation module called Rules Manager using C# and Visual Studio .NET.• Developed XML schema collections and XML queries for Data Mediation Service Broker messaging.• Peer reviewed tasks and provided feedback to team members, also mentored them as a senior colleague.• Performed performance tuning for ABRS T-SQL stored procedures, functions and GDS cubes.

• Successfully completed system analysis, design and development of several projects.• Designed and developed Banking and Human Resource applications using Visual Basic 6 and Visual Studio 6.• Monitored and maintained Banking and Human Resource databases using SQL Server 2000/7.0.• Designed and developed Banks financial reports using Active Reports and T-SQL stored procedures.• Designed components (DLL) for inter-branch transaction and implemented them using COM+ and Microsoft Distributed Transaction Co-coordinator (MSDTC).• Developed large code bases for banking solutions interest calculation module• Designed and developed interest calculations mode for products like Saving, Fixed Term, Current and Loan.• Designed Banking solutions various modules like Cash Management, Customer Relationship, Accounting, Foreign Exchange and Loan Module.• Developed Win32 API(s) and integrated with banking application.• Used Visual Source Safe 2003 for source code control, development, and integration and release management.