Ojas Indulkar Email & Phone Number

Heidelberg, Bw, De

Mumbai, Maharashtra, India

Maharashtra, India

• Worked as an SME Data Engineer for Unilever Plc on behalf of Teradata. Leading a team of 5 group members.• Wrote queries to provide one time data extracts to business users. Used BTEQ and Teradata Fast Export functionality to generate extract in text file format.• Built Sanity check Job in TWS and developed BTEQ script to check the number of records which got loaded into target tables. Introducing this job had increased service delivery efficiency by 50%.• Handling Indirect procurement spends, Media Spends, Electronic Point of Sales, Logistics and Suppliers related master and transaction data issues reported by business users in semantic layer.• Handled Transactional data issues reported in European sales and Forecast Accuracy and Category reports. Performing thorough root cause analysis had helped the client to resolve millions of euros variances in spend amounts.• Increased the work efficiency by 40% by developing the automation tool which identified the duplicates in the data resulting in prevention of job failures in production.• Optimized high CPU consuming queries by collecting stats on required columns, Dropping of Join indexes during query processing and creation of volatile tables and reference those volatile tables in joins by replacing derived tables. This action resulted into Optimized Runtime of critical SLA jobs by 85%.• Carried out impact assessment and done the required modifications in the existing logic in BTEQ scripts to accommodate changes in new master data hierarchies by following standard change management process.

India

• Worked as an ETL operations Support for P&G on behalf of Teradata.• Handled Campaign related data privacy issues as well as data inconsistency issues.• Used GIT version control tool to do deployments in Production.• Worked on extracting data from files and various API sources and loading it into Data Warehouse.• Wrote queries to check the status and data loading count of API jobs which resulted in issue reduction of sending Campaign to Opted out consumers which in turn helped my employer to save thousands of dollars in penalty cost.• Used Unix commands to transfer files for data loading purpose. Also scheduled data loading jobs using cron tab in Unix.• Increased work efficiency by 20% within a year by developing the automation using shell script to remove marketing programs data from EDW tables.

• Joined Teradata as a Fresher and acquired knowledge of Teradata Database and its Architecture.• Gained Practical Knowledge on Data Warehouse concepts.• As part of internal assessment, we had performed the tasks of loading Data from Flat Files into Staging tables through Fast load and TPT.• Once data got loaded into staging layer, applied transformation logics and loaded the data into EDW layer by using Teradata BTEQ functionality.• Presented the results of business queries through PowerBI to gain more insights from data.

Bachelor Of Engineering - Be, Computer Engineering, 7.71

Bachelor Of Engineering - Be, Computer Engineering, A