Jai Angle Email & Phone Number

Australia

Sydney, New South Wales, Australia

Sydney, New South Wales, Australia

Responsible for transforming, mapping and migration of data into FastTrack version 11 for whole of Australia. Involved in writing SQL processes, working with the business users as well as the vendor, creation of migration processes, working through the exceptions, and creating reports for the business, and ensuring the deliverables are achieved within the timelines for each rollout.Automation of migration processes and maintaining the dependencies is the highlight of whole migration process.

Sydney, New South Wales, Australia

This role entailed setting up TVSN reporting architecture, designing and writing interfaces, interacting with different levels of business users and building reports, developing end-to-end processes, and managing upgrades of Data Mart and Reporting environment.Designed reporting database and all the reporting processes and schedules, created static and dynamic SSRS reports, developed interfaces with external data source Google Analytics, internal Warehouse as well as with the TVSN TV program scheduling tool.Developed a Forecasting tool which enabled the different departments to forecast their earning based on the upcoming TV shows.Also built the system for the user management of the reports, extraction and backing up of the SSRS reports and schedules for housekeeping tasks.Environment: MS-SQL Server 2017/2014, R, SSRS 2017, Visual Studio & RStudio

Alexandria, Nsw

This was a hands-on role on MS SQL Server and MS SQL Reporting Services, including design and development of entire Data Warehouse, creation of ETL processes for Data Marts, setting up of Log Shipping/Replication/Reporting Environment and liaising with different Business user groups for Internal and External(Ministry of Transport, NSW Police, Councils, etc) reporting.Designed, developed and implemented an Archiving strategy for IVR and Dispatch databases single handedly, and subsequently created a tool to monitor the progress on a daily basis. Also wrote data migration and mirroring/synching process to reduce downtime during system outages.Environment: MS-SQL Server 2008 R2 and 2005, MS SQL Reporting Services 2008 and Visual Studio 2008.

Chatswood

This role entailed liaising with the core CRM program & relative business units to both identify & deliver the data migration components from old Collection system and Gemini into the new Regional Collections system. All old systems are migrated into the completely new systems as part of the program ‘SAM’ within Vodafone. Within this role, I am involved in documenting requirements and process solutions as well as liaise with both technical and business resources to explain and obtain approval for solutions in a process that is appropriate to each party. The new systems are implemented in Australia, New Zealand and Fiji.As this is a data migration project, one of the key element of this role is reconciliation of migrated Tallyman(Collections) data with CRM Siebel and Billing System Infranet and ensuring the variances are within acceptable tolerance levels. Reconciliation is done for both financial and non financial data via Oracle PL SQL, Unix Shell Scripts, MS Access and Brio reports. Have successfully lead this project for AUS and Fiji market.Environment: Oracle 9i on HP Unix, SQL Loader, Toad, MS Access, Siebel, Brio, etc.

As Research Applications Support Analyst, my responsibilities included supporting of the UBS developed Equities Research Applications to create and publish time critical research data about stocks/equities to internal site as well as UBS external and other external sites such as Bloomberg, Reuters, TheMarkets.com, etc.The role involved analyzing/resolving the issues reported by the research analysts worldwide, monitoring and ensuring the availability of the systems, managing the system incidents, testing/coordinating the releases, Unix shell scripting, writing Sybase SQL/Oracle PL SQL queries, etc. Within this role, I lead the Quarterly Infrastructure project globally for UBS Equities Research, participated in ERD Monitoring strategy, conducted benchmarking of research applications within Asia Pacific regions, testing/coordinating of Windows patch upgrades to desktops/laptops and Research servers worldwide, etc. Lead and Manage team on project basis.Environment: Sybase 12.5, Oracle 9i, Toad, PL/SQL Developer, Linux, Unix Shell Scripting, MS-Word, MS-Excel, Documentum Software, MS SQL 2000

Within the role as Programmer Analyst, I was involved in supporting the Web based product ‘TRAMADA’ which is designed and developed to cater for the needs of Travel Agents across Australia and New Zealand. As the system ‘TRAMADA’ is web based, the front-end is developed in HTML, JavaScript and CL4 and the database back-end is supported by 4GL CL4. The system runs on an ASP model and is used widely in Australia and New Zealand. The role involves analysis, design changes, new developments, bug fixes, etc.Environment: Linux, CL4, HTML, JavaScript.

As a lead on this project, I was responsible for launching of empowIR system in UK and in countries within Europe, defining of the interfaces between new and existing systems, and providing all the necessary application support primarily for empowIR. Within this role, I have lead and mentored the team successfully working on this project. Post-implementation of empowIR system, I worked in a support role for the same system, ensuring paying of commissions/promotions to reps on a timely basis, data integrity between empowIR and other systems (including US systems), writing PL SQL procedures/packages, Unix shell scripts, etc. Developed interfaces to Sybase, Oracle Financials, CRM and US based empowIR system. Also performed Sybase DBA role and database management for Oracle.Initially worked with Excel Telecommunications Ltd, UK, for the period Nov 2000 – Nov 2001 as IT Systems Manager doing the same as described above. Excel then got bought over by Vartec Telecom and the role continued with Vartec Telecom.Environment: Oracle 8i/9i on Sun Solaris, Oracle 8i/9ias, Oracle SQL Loader, Toad, Sybase 11.9.3, C, PHP, Sybase 12, MS Access, CRM (internal designed), Siebel, etc.

As a lead on this project, I was responsible for launching of empowIR system in UK and in countries within Europe, defining of the interfaces between new and existing systems, and providing all the necessary application support primarily for empowIR. Within this role, I have lead and mentored the team successfully working on this project. Post-implementation of empowIR system, I worked in a support role for the same system, ensuring paying of commissions/promotions to reps on a timely basis, data integrity between empowIR and other systems (including US systems), writing PL SQL procedures/packages, Unix shell scripts, etc. Developed interfaces to Sybase, Oracle Financials, CRM and US based empowIR system. Also performed Sybase DBA role and database management for Oracle.Environment: Oracle 8i/9i on Sun Solaris, Oracle 8i/9ias, Oracle SQL Loader, Toad, Sybase 11.9.3, C, PHP, Sybase 12, MS Access, CRM (internal designed), Siebel, etc.

Project : ECCOWorking as a Replication Server DBA in a Data Infrastructure group, I was responsible for leading and setting up and supporting of the data replication between Btrieve to Sybase, Sybase to Sybase and, Sybase to Oracle based systems. The systems that were replicated involved Customer Care, Arbor based Billing, legacy system, etc. Unix scripts and SQL’s were written to automatically check the integrity between different systems.During the first ten months at Excel’s site, worked as Lead Sybase DBA for Customer Care system called ECCO. Responsibility included setting up and maintaining the Sybase database server for efficient handling of large volume of database connections, performance monitoring, database backups and recovery, day to day operations and maintenance.Environment: Sybase SQL Server 11.9.3, Sybase Replication Server 11.5.1, HP Unix 10.0 , MS Access, DBArtisan 5.2, C, PowerBuilder 5, etc.

As a main Sybase and Powebuilder developer, I was involved in analyzing, designing and developing of the screens, writing stored procedures, UNIX shell scripts etc. This development was on ad hoc basis to support the needs of Fidelity’s Investments systems. I was also working as backup/support DBA for the project. Environment: Sybase SQL Server 11.1, HP Unix 10.0, Powerbuilder 5.0, Windows NT, etc.

Austin, Texas, United States

Teleworth, Austin TX, U.S.A. Sep 1997 - Oct 1997Project : LatticeInvolved in development of Internet based application in PowerBuilder, setting up and database administration of SQL Server and data transfer from SQL Anywhere to MS SQL Server 6.5, development of scripts, triggers, stored procedures, etc.Environment: MS SQL Server 6.5, SQL Anywhere, PowerBuilder 5.0. S-Designor, Web.PBDell, Austin, TX, U.S.A Jul 1997- Aug 1997Project : Latin America Sales Reporting SystemDeveloped the services, objects and class library in PowerBuilder which was used as the main reporting library for Dell’s Latin America Sales reporting application. Also involved in setting up of MS SQL Server for performance and stability, development of stored procedure, triggers, etc.Environment: MS SQL Server 6.5, PowerBuilder 5.0. S-Designor.Texas Department Of Human Services, Austin, TX, U.S.A. Aug 1995 - Aug 1997Project : Special Nutrition ProgramRole included Sybase/SQL Server database administration, design of the data model using Erwin, creating/maintaining databases, tables, development of triggers and procedures, data migration across remote system, etc. for both Sybase, MS SQL Server, and Watcom. Also involved extensively in developing the applications in PowerBuilder. Environment: Sybase 10.0.2 on Novell Netware 3.12, MS SQL Server 6.5, Watcom SQL 4.0, PowerBuilder 4.0a., Procom Plus,Wildcat BBS, Erwin

Lancaster, Pennsylvania, United States

Role included managing of Sybase database and administration, design of the data model using Erwin, design of objects, development of stored procedures, triggers and scheduling and maintaining the jobs on Unix.Environment: Sybase 10.0.2 on AIX

Master'S Degree, Computer Science, 8.6

Activities and Societies: Represented Goa University in Soccer. Represented Goa University in All India MCA meet held at Trichy.

Bachelor'S Degree, Mathematics, First Class

Activities and Societies: Represented Goa University in Soccer