data warehouse developer
- 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.
data warehouse developer
- 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
senior data warehouse developer
- 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.
data warehouse developer
- 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
senior data warehouse developer
- 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