Vikash Singh Email & Phone Number

Sydney, Nsw, Au

Sydney, Australia

Our true value lies in our people. Sourced from global markets, our talented team, looks at every challenge in the current IT space as a new opportunity to excel. Utilising a development operations model, our teams’ special technical and logical skills apply fresh enhancements to applications to ensure that your technology is always producing results, by proactively finding the areas of leverage and business improvement.Key Roles & ResponsibilitiesRobotic process automationData Analytics and Business IntelligenceData WarehousingWorkday HR, IPA/RPA CoE using BluePrismAWS Cloud Infrastructure ServicesSplunk Monitoring Alerts and Dashboards.

Sydney, Australia

Sydney, Australia

Project Title Customer Experience Survey (CES)Duration Dec 2015 - Aug 2017Client Commonwealth Bank Domain Marketing, Finance, ResearchRole Data Asset Analyst CES program is to ensure that CBA remain number 1 in customer satisfaction. We pull the data from different sources and for different channels. The samples are then washed for research exclusion rules and sent for Survey. The score given by customer get linked to staff KPI’s. This program aims to measure customer satisfaction regarding recent contact between customer and CBA, across different channels / touch pointsRole & Responsibilities: 1. Data Analysis.2. Project Estimation.3. Prepare design documents and program specification.4. Design and Build of the Data Marts, involved in Development, Design ETL and Performance tuning of new enhancement request.5. Defect support for Functional verification testing and regression testing.6. Assist Research Team and different channel owners for reporting requirements.7. Provide reporting assistance to Marketing and Research Team8. Monitoring CES metrics.

Sydney, Australia

Project Title: Campaign Operations & Analytics (Qantas Loyalty)Duration: Oct 2013 till DateClient: Qantas Airways Ltd, Sydney, Australia Domain: Marketing, CRMRole: BI Consultant Software Description: ARM/CIM, MRM, Teradata utilitiesReporting Tool: TableauDatabase: TeradataThis project is the part of Qantas Loyalty group. The team involved is Qantas, TechMahindra and Teradata. We are involved in Admin, support and development activities of Campaign and Marketing application and process. We work and provide assistance to Marketing and Campaign Analyst in Teradata SQL, Designing ETL, Performance tuning, Campaign design, debugging, reporting and implementation of best practices.Role & Responsibilities: 1. Project Estimation.2. Prepare design documents and program specification.3. Design and Build of the DWH objects, involved in Development, Design ETL and Performance tuning of new enhancement request.4. Defect support for Functional verification testing and regression testing.5. SPOC of Campaign and Marketing related issues6. Responsible for building a Loyalty support team.7. Provide reporting assistance to Campaign and Marketing Analyst.8. Admin and support activities for ARM, MRM and Tableau.9. Monitoring the Campaign progress, implementation, execution and reporting in Tableau.10.Design, development and implementation for marketing best process flow through MRM.11.Responsible for imparting functional and Technical training to the other team member in Loyalty.

Sydney, Australia

Project Title: Finance Data warehousing (FDW)Client: Qantas Airways Ltd, Sydney, Australia Domain: Business Intelligence in Finance domainRole: Administrator/Team LeadSoftware Description: Teradata Decision Expert (TDE), Teradata, UNIX, OracleTesting Tool: Mercury Quality Centre (MQC)Database: Teradata, OracleReporting Tool: OBIEEFDW was the part of Corporate Data warehouse. The team involve for the support of the FDW is Satyam, Teradata, Capiotech. We were involved in support, maintenance and minor enhancement. The main purpose of this was to build the Warehouse from the operational source system and load the data into the FDW. The FDW data is used for the financial reporting. The module involved was General Ledger (GL), Account Payable (AP) and AR (Account Receivable). The number of business user is 100+ in this application and expected to grow with the new enhancement to the application.Role & Responsibilities: 1. Responsible for imparting training to the other team member after completing training in TDE at NCR Teradata in Sydney.2. Involved in Design, Development, Testing and go live for FDW along with the Teradata, ASG (Capiotech) and Qantas. 3. Responsible for building a new team at offshore and transitioning the KT (Knowledge Transfer) to the offshore team.4. We moved the major piece of work from onsite to offshore for cost optimization and created better value for Qantas and Satyam.5. Admin activities.6. Monitoring and scheduling the project module progress and implementation.7. Documentation and maintenance of the project document and any configuration changes in a SharePoint portal.

Sydney, Australia

Project Title: Qantas Datawarehousing and BI Applications(Qantas AST)Domain: Business Intelligence in Airlines domainRole: Developer Software Description: Teradata, Datastage, OracleReporting Tool :CognosQantas AST is a Support and development project for Qantas Airways Ltd which is among the largest airlines in the world and the National carrier of Australia. This project involves more than 60 data warehousing and business intelligence applications. The Qantas AST project involves supporting these applications and enhancing these applications to suit business needs and to enable business to take futuristic decisions to increase revenue for Qantas Airways. The scope of the project also involves many enhancements and projects in ever expanding field of airlines industry. The various domains involved in the project were Freight, Sales and Ticketing, Payroll, Finance, Loyalty and Corporate businesses.Roles & Responsibilities:1. Studied the current airlines system to understand the existing data structures.2. Gathered Requirements and the reporting issues from the End user3. Analyzed Business requirements from the clients4. Preparation of Technical Specifications5. Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.6. Developed data mappings between source systems and warehouse components.7. Peer Reviews and Unit Testing. 8. Defect support for Functional verification testing and Regression testing.