Ruben Rao Email & Phone Number

Port Coquitlam, Bc, Ca

Singapore

• Worked in capacity of Technical Lead for this project handling team of 10 resources split across Singapore and Malaysia.• Leading multiple projects at a time and providing directions whenever needed• Present the solutions to the Business users and obtain the concurrence before starting the implementation.• Active participation in the Brainstorming phase in order to get the requirements as most granular level. Provided a mockup of the solution proposed during the FSD approval phase. This helped the user to clearly foresee what is expected after the Go-Live• SPOC for the Data Hub team and working in close coordination with other stakeholders like Functional BA’s, Testing Team and Project Management team• Designing of the solutions involving external Data Providers like Bloomberg, Reuters, Super Derivatives etc.• Involved Planning of budget and allocation of resources for the Project • Implementation of AWS Cloud framework as a Golden source of data provider for all downstream applications • Responsible for task delegation to the peer members based on their bandwidth and tracking the progress• Providing regular updates to Project Management team, Tracking of milestones and highlighting/ addressing potential risk if any• Responsible for quality control including Code Review and approval before releasing to Testing environment• Ensuring the due diligence was followed in terms of quality and deployment process

Singapore

• Worked as Main contributor to the project in terms of both team lead and as Individual Contributor(Lead Developer)• Active participation in the Redesign discussions and provided valuable inputs in terms of reusing existing Data Marts, Data Re-piping etc• SPOC for the DWH team and working in close coordination with other stakeholders like Functional BA’s, Testing Team and Project Management team• Responsible for task delegation to the peer members based on their bandwidth and tracking the progress• Main contributor in the designing of the new systems addressing all the gaps in the current architecture.• Main Developer for all ETL, Reporting and Database related requirements• Providing regular updates to the Project Management and tracking of milestones• Responsible for quality control including Code Review and approval before releasing to Testing environment• Ensuring the due diligence was followed in terms of quality and deployment process

Singapore

• Worked as Main contributor to the project in terms of both team lead and as Individual Contributor(Lead Developer)• Active participation in the Redesign discussions and provided valuable inputs in terms of reusing existing Data Marts, Data Re-piping etc• SPOC for the DWH team and working in close coordination with other stakeholders like Functional BA’s, Testing Team and Project Management team• Responsible for task delegation to the peer members based on their bandwidth and tracking the progress• Main contributor in the designing of the new systems addressing all the gaps in the current architecture.• Main Developer for all ETL, Reporting and Database related requirements• Providing regular updates to the Project Management and tracking of milestones• Responsible for quality control including Code Review and approval before releasing to Testing environment• Ensuring the due diligence was followed in terms of quality and deployment process

Singapore

• Liaise with the Global team spread across Zurich and Singapore as part of requirement gathering activities• Work with the upstream and downstream systems to understand the gaps in the current system.• Conduct of feasibility study on the approach to migrate to Cloud and thereby providing the design solution to the Architecture team for approval.• Assisting the Project Management team for acquiring the needed approvals from the Procurement Team• Worked as a SPOC from the IT side for all items related to the Data Platform solution.• Introduced the various Big Data solutions like Kafka, AWS S3 and RDS to capture near Real-time Data Streaming and make it available to downstream systems in various formats like Tables, Text Files and various Serialized data files• Using Spark to replace the existing Informatica jobs and providing the result into both AWS S3 and RDS for consumption by the downstream systems.• Setup on Monitoring alerts to ensure the issues raised are addressed within the SLA • Directly interacted with the key stakeholders like BT(Business Transformation) team, BA, Testers etc. at various phases of the project from the Requirement gathering phase to the UAT signoff• Keeping track of timelines and change request and providing daily updates• Ensuring the due diligence was followed in terms of quality and deployment process

Singapore

Mainly responsible for handling client requirement in the BI space(ETL and reporting). Currently involved in one of the migration projects which needs the process to be transitioned from the legacy system. Worked on various projects addressing the regulatory requirement of the client involving ALM-FERMAT,RAy, FATCA compliance and BASEL-3• Been a part of SCB for over 2 years working of different projects• Leading a Team of 5 developers comprising of ETL, database and Tableau experts• Development of Tableau Dashboards for DLRR consisting of Global users. Setting up of row level security for each sets of users• Active participation in understanding the business requirements and managing expectations among the different stake holders including the various downstream systems.• Single point of contact between the developers(including me), the business team and the various downstream Application Systems• Responsible for the Database design, ETL design document, Reporting Framework and Implementation Strategy.• Management/tracking of WBS, Project timelines and Segregation of tasks among developers(including me)• Responsible for code management and document management in GIT• Coordination with the testing teams to ensure the defects are addressed and resolved within the stipulated SLA.• Conducted multiple dry runs to address any unknown issues that could occur and increase the comfort level for the business and key stake holders including the various downstream application systems• Was able to maintain good rapport with the stakeholders and kept them updated on regular basis.• Handover and knowledge transfer of the project to the MnE team after the successful delivery of the project• Ensuring the Design Document, ETL Mapping document, and various documents related to the releases are prepared and up to date from time to time

Mumbai Area, India

Joined JPMC as a BI Developer for handling the ETL and reporting requirements of Capital Markets team. This is one of the various LOB coming under the Investment Banking Domain of the Bank. Various tools worked on was Informatica, Business Objects, SSIS, Oracle, SQL, PL/SQL. Possess Business knowledge of Capital Markets, Investment Banking, Securitization, Asset & Liability Management(ALM) and Mergers and Acquisitions

Mumbai Area, India

Worked as a Business Objects Developer for addressing the reporting requirements of the Product

Mumbai Area, India

Worked on the Development, Maintenance and Support of the datawarehouse of the Stock Exchange. Work was involved both in the ETL as well as in the reporting space. Tools worked on Inclide Informatica, Oracle, Business Objects and Reveleus