Abeesh Nageswari Ravikumar Email & Phone Number

Sydney, Nsw, Au

Sydney, New South Wales, Australia

Sydney, New South Wales, Australia

Sydney, Australia

Sydney, Australia

Sydney

Sydney

Kochi

Roles : • Informatica & DataStage ETL developer, Production Support Team memberResponsibilities: ETL Jobs & Mapping development, ETL Design, Creating Interface,Design documents & Source to Target mappings, Data model modifications, Testing, Production Support, Shell scripting,Ticket tracking and closing,Extract data from various sources like Oracle,Informix,Netezza and Flat Files. Apply transformations, business logic and load data to Enterprise Data Warehouse.Applied multiple strategies for loading data in 2nf and 3nf forms for reporting data marts. Used complex transformations like java transformations in Informatica, XML transformation,Web service client etc in DatastageSystem Integration Testing and User Acceptance Testing support. Created customized scripts to identify long workflows,sessions and validation of various business scenarios by accessing repository metadata tables in Informatica

Sydney

• As ETL consultant worked on number of projects to build the enterprise data warehouse of Newscorp(NewsFACT) across multiple domains like Marketing,Adsales,Finance and Payroll. Lead the ETL team in CARE project to build Single customer view for Newscorp to be used for marketing. Implemented end to end flow for campaigning, from source systems to campaign platform (Unica) to various channels (EDM,Online,Salesforce) to response tracking in NewsFACT. • ETL developer in Subscriber Operations transformation project to adapt Salesforce as Newscorp's CRM platform. Used Salesforce connector of Datastage to push data into Salesforce to enable customer support and pull data from Salesforce into NewsFACT for Reporting.• Designed and developed customized ETL backup maintenance frameworks using datastage.• Built an ETL solution to generate automatic schema files using datastage and vertica, to be used for one to one table loads reducing development efforts by 50%. Won innovation champion award for 2014 from Cognizant for the same.• Created an ETL framework using datastage to generate projections for tables to be created in Vertica Production database during project deployment. • Experienced in Requirement gathering and analysis, creating technical specifications, source to target mappings, building audit frameworks for ETL processes, Agile methodologies including scrum , performance tuning , supporting UAT and production support.