Prashanth Kumar Ag Email & Phone Number

Sydney, Australia

TECHNICAL LEAD/SENIOR DEVELOPER(Jun 2012–Present)Loss Data System, Business Lending DevelopmentWestpac Banking Corporation, Sydney, Australia (in partnership with Infosys)The Loss Data System project involved the development of an application from scratch, to be used for recording corporate losses incurred by the bank as a result of bad debt and to make it possible to manage these debts to closure. The application also provides a robust way of integrating the application with the core system in order to identify and avoid bad debts early in their life cycle, and its holistic reporting provides users with a bird’s-eye overview of bad debts incurred by the bank, facilitating useful analytics. I was involved in the end-to-end life cycle from requirement-gathering stage through to the design of the database and reporting solutions, ensuring quality deliverables through responsibilities including:- Initiating kick-off meetings, requirements definition, preparation of effort estimates, client approvals, solution design, Statement of Work/Business Requirement documents, configuration and release planning, time-scaling for all projects, and coordination with development and testing teams- Analysing requirements; designing database and reporting components- Developing ETL components using Microsoft SQL Server Integration Services (SSIS) tool- Developing Reporting solutions using Microsoft SQL Server Reporting Services (SSRS)- Coordinating periodic activities such as Defect Prevention and Quality Control- Analysing performance-related issues and guiding rectification of faults to manage monthly minor releases and quarterly major change releases- Reviewing test plans, coordinating UAT and performance testing- Creating and maintaining Control-M jobs for periodic processes & interfacing with other core systems- Leading team members and client representatives in integration of technical methodologies

Sydney Area, Australia

TECHNICAL LEAD / SENIOR SUPPORT ANALYST (June 2010 – June 2012)Data Services Support, Business Lending DevelopmentWestpac Banking Corporation, Sydney, Australia (in partnership with Infosys)The Data Services Support project involved support and enhancement of various reports used by Tellers and Bankers in their daily activities. The project makes it possible to gather data from a number of revenue streams, applying calculations based on predefined Business Rules and consolidating data into one single format for reporting purposes. One of its major functionalities is the Performance Reward Scheme which captures and analyses the performance of Relational Managers against set targets. I was extensively involved in all aspects of the end-to-end life cycle of the project, including:- Developed ETL components using MS SQL Server Integration Services tool- Developed reporting solutions using MS SQL Server Reporting Services- Coordinated periodic activities including Disaster Recovery, Business Continuity Planning and Digital Certificate Renewal- Managed critical platform upgrades including SQL 2000/2005 to SQL 2012- Provided functional inputs about the legacy system and business logic- Oversaw the migration of servers from one Data Centre to another

Mysore Area, India

SENIOR DEVELOPER (April 2009 – May 2010)IT Service Management Online PortalTelstra, Mysore, India The Managed Services Online Portal supports Managed Service Customers, providing a full range of enquiry types including Service Levels for each type of enquiry. IT Services Management Portal serves as a single point-of-contact for managed customers to interact with Telstra’s products and services. My involvement was mainly in respect of customising the Configuration Management Database to handle additional feeds specific to Telstra. Also worked on customising Service Level Management module of BMC Remedy in order to tweak existing workflow as per Telstra’s requirements.- Worked with ITSM 7.5 (CMDB and SLM modules) - Developed web services to interact with SMEC CRM system- Created Test scripts and Unit Testing of developed code- Carried out peer testing and code review- Prepared estimation plans for new development- Provided training for new team members- Ensured the meeting of all client requirements by overseeing technical integrity of the design- Scheduled and anchored daily status call with client- Documented Business Flow and Business Requirements

Mysuru Area, India

DEVELOPER / SUPPORT ANALYST (October 2006 – March 2009)Commission Management SystemCOLT Telecom, Mysore, IndiaCMS, the corporate website of COLT, includes the details of Performance of Sales Persons and their bonus. Sales Reporting Portal, which gathers sales data from various heterogeneous sources and calculates bonuses based on complex calculations, allows users to view the reports uploaded to their accounts, is built on ASP and uses MS SQL as Database, MS SQL Data Transformation Services for ETL.- I worked with ASP, JavaScript, MS SQL and DTS- Provided production support- Monitored and reported on progress of enhancement process- Coordinated implementation of enhancements- Provided post-production support- Created technical notes and documentation- Developed business reports using MS SQL, and Crystal Reports- Developed and enhanced interfaces between MS SQL and legacy applications- Organised meetings with users and business analyst to facilitate understanding of current business flow and documentation of business requirements- Provided Server maintenance, CPU load monitoring and Cron/MS SQL scheduler maintenance - Actively participated in analysis, design, development and data modelling for enhancement requests

Bachelor'S Degree, Computer Science And Engineering, First Class

High School, First Class

Pre-University, First Class