renjith rameshan

associate consultant

About

Renjith is a Data analytics consultant using industry leading platforms including Informatica, Teradata, Oracle Business Intelligence , Hadoop and SAP BODS. He has worked on large-scale data integration solutions in the banking and financial services industry, and is experienced in requirements gathering, ETL development and performance optimization. In addition to his Data warehouse and SQL experience, Renjith has also acquired skills in Big Data, Data Science and Advanced Analytics.

Country

australia

City

melbourne

Industry

information technology and services

Skill

sql, data warehousing, informatica, etl, teradata, pl/sql, oracle, unix, shell scripting, sdlc, microsoft sql server, business analysis, databases, requirements analysis, business intelligence, obiee, data integration, systems analysis, big data, requirements gathering, data modeling

Experience

associate consultant

servian

2017-11 - Present · 8 yrs 11 mos

data warehouse consultant

united overseas bank limited (uob)

2016-8 - 2017-10 · 1 yr 3 mos

* Being a part of IFRS9 Computation project and platform engineer for EDAG * EDAG : Enterprise Data Architecture & Governance * Building a DL and EDW on Hadoop and TD Platforms * Acted as the POC for TAS (Teradata Analytics for SAP) for the GL systems * Conducted POC on IBM CDC IFRS9: A regulatory reporting project * Computing EAD, LGD and Dimensions for versatile segments (SME, NNR and PFS) * Worked closely with the business in understanding the existing Basel system. Technologies: Informatica, Big Data, Hadoop, Teradata, Oracle, SQL,Data Quality, Metadata Manager, Mainframe DB2, Flat Files, Unix Scripts, Control M, CDC

informatica consultant

maybank

2015-6 - 2016-6 · 1 yr 1 mo

* Developed a Risk Data Mart and an Operational Risk Dashboard for Maybank Overseas units * Engaged in all phases of the data warehouse development lifecycle * Dynamic nature of the project was achieved through the use of parameter variables * Concurrent job execution and performance tuning resulted in the optimal execution time Technologies: Informatica, Teradata, Oracle, PL/SQL , SQL,OBIEE, Flat Files, Unix Scripts, Zena

data warehouse developer

tata consultancy services

2012-12 - 2015-5 · 2 yrs 6 mos

* Completed 2 DWH and 1 Data Migration Project for a Re insurance company * Created views, SP and unix scripts for the re-usability and automated run of the jobs. * Efficient logs capturing were made available through the ETL audit tables. * Scripts were developed for FTP process, Monitoring and autonomous control of the jobs. Technologies: Informatica, SAP BODS, Oracle, MS SQL Server, Flat Files, Unix Scripts, Autosys, PL/SQL, SQL, T-SQL