Rony Rajan

Account : TSB Bank

Projects : Financial Crime, Bounce Back Loans, Customer Breathing Space, Mortgages - Direct Debit Failure, Cards, Telephony, Data Quality Reporting Repository.

Responsibilities:

• Involve in Design, Development and Enhancements of ETL jobs using IBM Datastage.
  
• Continuous interaction and co-ordination with Business SMEs, Data Modelers, Operations team and Testing team for all project activities.
  
• Involve in analyzing issues raised by Business and fixing the ETL defects based on the JIRA and SNOW.
  
• Involve in analyzing requirements, effort estimations, design, and implementation of ETL solutions.
  
• Maintain documentation on change requests, unit tests, peer reviews and production releases.
  
• Provide support to team for analysis in Teradata SQL, ETL Jobs, Data Mappings and Deployment process.
  
  

Account : FedEx Express

Projects : Spotfire Migration

This project aims in migrating IBM Cognos packages, catalogues, powerplay cubes and reports to Tibco Spotfire deployed in Azure cloud.

Responsibilities:

• Involved in Design, Development, Unit Test, Code Review and UAT Support for Spotfire Reports.
  
• Involved in sprint planning and guide team in development activities.
  
• Co-ordination between business and offshore team for the CO2 Emission reports migration project at Netherlands.
  
• Involved in discussions with Tibco product team for the implementation of additional features in spotfire reports.
  
• Involved in automation of user access management activities and scheduling of spotfire reports using exposed APIs and tibco subscription tool respectively.
  
  

Account : FedEx Express

Projects :

Neo4J Data Lineage Application - A Graph Database application that provides insights on the relationship between BI applications, jobs , scripts and tables which reduces analysis efforts required in production issues and impact assessments of enhancements projects.

Modernization Accelerators - A self service web portal capable of handling certain business requests to reduce IT team dependencies.

Batch Failure Handling Application - A python application which handles the batch failures to avoid delays in business reports availability.

Real Time Consignments Solution (Proof Of Concept) - A predictive analytics application to track and calculate optimized route for consignments delivery.

Responsibilities:

• Involved in identifying service improvement areas and time consuming process for automation.
  
• Involved in design, development and implementation of automation tools and mentor team in project activities.
  
• Lead and co-ordinate the team in achieving the project goals by conducting regular team meetings, knowledge sessions and trainings.
  
• Primary point of contact for team engagements in Hackathons and Seasonal Automation events.
  
  

Account : TNT

Projects : TNT EDW Support, AMEA Sales, Germany Sales and Operations, UK Domestics.

Responsibilities:

• Lead and co-ordinate team in Business Intelligence applications support activities.
  
• Take complete responsibility on production support issues analysis and fixes, co-ordination between different teams and provide regular updates to business at United Kingdom for one year.
  
• Involved in finding the root cause for recurring issues, discussions with business and provide solutions.
  
• Ensure the closure of issues raised by the users, related to data disparity, within SLA.
  
• Maintain the documentation for the changes in EDW and ensuring appropriate communication across stakeholders.
  
  

Account : Gap Inc.

Projects :

GWiz - Revenue reporting system for business users.

Simple Suite - Inventory Management Data reporting system for business users.

Universal Installer - Tool which handles GAP business applications installations.

Responsibilities:

• Involved in gathering and analyzing business requirements.
  
• Involved in development of business applications using Excel\Access VBA and SQL.
  
• Involved in development of automation tools using Excel and Access Macro.
  
• Involved in analysis and fix of issues in BI applications raised by business users .