• Monthly loading 
• Trainee and supervise all IP’s Works 
• Implemented a tool to automate creation of external hana view.The tool reduce the development time and testing from 1 and half month to 2 weeks. 
• Won 2 awards for Innovation (Monthly and Quarterly), by creating tools for the local and global team.

•  designing and delivering data models used for organizational business intelligence and analysis
•  designing database objects to meet ongoing enterprise and departmental business intelligence and data warehousing solutions 
•  Design, develop, and test dimensional data models  
• Maintaining the code standards while writing and placing the scripts and credentials using GitHub, KeyPass, Vaults etc

• Supported multiple process areas (OTC,MDM and RTR).
• Led the data extraction for 3M’s divestiture.
• Provided incident analyses and resolutions.
• Provided solution on complex requirement from stakeholders.
• Created and enhanced HANA Calculation View (SQL or Graphical).
• Optimized Calculation Views that is dumping to just 1 minute runtime. 
• Converted multiple DSOs to ADSOs and provided a process that reduced data testing of all ADSOs to just 1 day.

•  Preparing Dashboard Design (Oracle Business Intelligence ) 
• SQL select query execution 
• Delivery Month end reports from DMU 
• BI reports Preparation 
• Support for IRF verification 
• Checking DMD report delivery (daily) 
• Checking daily IRF report generation SLA count

• Developed an Enterprise Data warehouse for the Organization
• Used data gathered to develop an understanding trends, patterns and relationships; predictive analytics, which seeks to predict customer behavior, equipment failures and other future events that helped guide decisions of the company
• Having experience on AWS cloud environment (S3, EC2, RDS, Redshift, Athena, Data pipeline and CloudWatch matrix).
• Currently working on developing an event driven ETL process for the company involving new technologies present in the market
• Hands on Experience on Amazon DynamoDB and Fivetran API connectors (Facebook Insights, Google AdWords)
• Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure
• Develop or maintain archived procedures, procedural codes, or queries for applications