Rahul K Gupta Email & Phone Number

Melbourne, Victoria, Australia

Melbourne, Australia

Roles at ANZ Institutional Banking Group.Retail Analytics and Transaction banking are part of Institutional Analytics Platform, which has insights and intelligent signals for customers, collected from multiple data sources. • Analyzing huge amount of Retail data, approx. 2 Billion records, for Demographic, competitor and Loyalty analysis• Analyzing transactions, balances, billing, customer relationships and SLA data to create insights• Development in JavaScript, React, PostgreSQL, Google Big Query, git, .NET APIs, and microservices to create Analytical product• Creating data pipelines using Python Apache Airflow and C# .NET Core pipelines• Creating end to end development in Google Cloud infrastructure using Kubernetes, Terraform and Gitlab CI/CD pipelines• Creating minimum viable product using a lean methodology to get initial customer feedback• Using Stack Driver, Splunk and Grafana for logging and monitoring SLI/SLO dashboards• Development of new features and unit testing using Jest and React Testing Library• Working in Agile Scrumban sprint methodology with experience of iteration manager

Bengaluru Area, India

Order Inventory Data Warehouse | Feb 2016 – Jan 2017Business Intelligence Support for SKFOrder Inventory Data warehouse is an enterprise warehouse and data mart which manages the orders and inventory globally. This includes getting the transactions from DOH (Dispatch Order Handling) System, moving to iSeries AS400 DB2, SQL server for staging & data warehouse, to Sybase IQ Data marts. IBM Cognos to create data mart reports and Cube operations for end users.• Handling of incidents from SKF users using HPSM tool for L2 and L3 technical support• Monitoring of Daily loads and total loads for errors or delays• Look for data consistency and if exist then propose resolution for the same• Development of new changes and tasks related to Improvement • Working in collaboration with Other teams which includes DOH, ICSS, iSeries, SQL BDAs, Informatica Admin, Cognos and SybaseInventory Accounting 2 | March 2016 – Jan 2017Informatica Application Owner, Business Intelligence Support for SKFIA2 deals with - in and out flow of inventory data. It generates the Cognos report to show the Inventory count and data in SKF physical warehouse. IA2 has daily loads, reloads and Monthly loads which gets the data from multiple sources. The daily loads get data on daily basis, which is used to run the monthly reports.• Single point of contact from BI Team• Handling the loading of files in Monthly Load• Check for IA2 related queries and Incidents• Active involvement in all IA2 meeting, and development tasksProject – LISA | March 2016 – Jan 2017Application Owner, Business Intelligence Support for SKFLISA System handles the service structure, price list, customer master and currencies. LISA administrator verifies and loads local charge files into Oracle Database and LISA master Application. Trigger is initiated from Informatica end to refresh Cognos Cubes• Handling the loading of files• Single point of contact from BI Team• Check for All LISA related queries and Incidents

Bangalore

Project – Fleet Phoenix Driver Automation Transformation | Jun 2015 – Nov 2015Senior Software Engineer, ETL Development for GE CapitalUK Fleet business has various contract from Customers. It is updated in Phoenix Ingress database on daily and weekly basis. This process is automated using Informatica Power Center.• Project Management - Working as Single point of contact with client GE Capital. Responsible for organizing daily and weekly calls with maintenance of project tracker. • Designing - Dealing with analysis of source and target systems, Designing the high-level design, architecture, logic and database model.• Development – Responsible for creation of Mapping, transformation, workflows and Shell Scripts. Ensuring compliance of Informatica Standards and IDQ rules.• Testing – Dealing with creation the test case, migrating the code from DEV to UAT and operating end to end testing for UAT.Oracle R12 Consumer Migration - Global Banking Phase III | Sep 2014 – May 2015Oracle R12 Consumer Migration - Global Banking Phase II | Dec 2013 – Aug 2014Senior Software Engineer, Business Intelligence Developer for GE CapitalGE Capital EMEA biz has various banks and financial services. It loads daily/monthly transactions to General Ledger Data warehouse in Oracle 12 Database using Informatica & Oracle Apps.• Responsible for Creating Workflows, Mappings, Mapplets, sources, targets and transformations for Interfaces.• Delivering the design documents and follow up with clients for approval.• Providing the best and suitable solution as per the Business Requirement considering existing architecture.• Managing validation, reconciliation of data, Tracking, Monitoring, Performance Tuning, Optimization and Usage of Standardized Best Practices for Interfaces.• Responsible for creating shell scripts based on requirements, scheduling the workflows, handling the Database lookup.

Mumbai Area, India

Founder | Jun 2012 – May 2013Ehubz provides information regarding various E-Commerce websites in India. It has listed thebest websites in each category based on different parameters.Nature of Work• Responsible for developing the pages using HTML5, CSS3, PHP, MySQL and JavaScript. • Used standards like jQuery, Modernizr and CSS boilerplate. Created media queries – fluid media, mobile first approach for mobile, tablet and desktop versions • Registering the Domain name, hosting and complete setup of website environment in LAMP, which includes the configuration of MySQL, PHP and Apache web server. • Responsible for Setup of Google Ad sense, Google Analytics, Cloud CDN, Google & Bing Webmaster tools, Parallel Plesk Panel and setting DNS name servers. • Migrated the code from shared hosting to virtual private server. • Created different 160+ pages during its launch, currently it has around 350+ Pages. • Responsible for documenting the work, handling email communication, maintaining the folders and backups.

Masters, Analytics, 3.6/4 Gpa

Bachelor Of Engineering (B.E.), Information Technology, A