Senior System Analyst - BI
FMCG
Total years of experience :15 years, 10 Months
1.Design, Develop ETL and Data Warehouse
2. Lead and mentor the team
3. Experience in SAP HANA & SQL Data Warehouse
4. Experience in SAP HANA Modelling
5. Migrating from SAP HANA to SQL Data Warehouse
Installing, troubleshooting and administration of different QAD ERP products as well as maintaining of databases like Oracle and OpenEdge.
• Installation, Creation & Configuration of Oracle 10g on Redhat Linux 5
• System and User Maintenance
• Managing log files and rollback segments
• Monitor File Systems Growth, Backup and Restore procedure
• Managing physical and logical volumes
• Backing up and restoring the database (using OS scripts, RMAN).
• Bulk loads and data migrations (i.e. import/export and Data Pump).
• Overall maintenance of PROD, TEST and DEV instance.
• Monitoring the Performance, and tuning the system to improve the performance
• Supporting application development users and end users
• Remotely resolving client’s database as well as application issues
Installing, troubleshooting and administration of different QAD ERP products as well as maintaining of databases like Oracle and OpenEdge.
Was a key member of development team, role involves developing web-based application using Java, JSP, Servlet and oracle 9i as database.
• Database Design
• Maintaining and administrating existing web-based applications.
• Implementing and demonstrating application on client side.
As part of academic project was involved in module development and initial testing of online project developed using JAVA, JSP, Servlet and Oracle 9i for a client into shipping services. Module involves developing screens for tracking the status of consignment, reports showing orders placed on a period by a user, data entry screen for different reporting ports to update the status.
Post Graduate Certificate Program in Artificial Intelligence and Deep Learning
Installing, troubleshooting and administration of different QAD ERP products as well as maintaining of databases like Oracle and OpenEdge. • Installation, Creation & Configuration of Oracle 10g on Redhat Linux 5 • System and User Maintenance • Managing log files and rollback segments • Monitor File Systems Growth, Backup and Restore procedure • Managing physical and logical volumes • Backing up and restoring the database (using OS scripts, RMAN). • Bulk loads and data migrations (i.e. import/export and Data Pump). • Overall maintenance of PROD, TEST and DEV instance. • Monitoring the Performance, and tuning the system to improve the performance • Supporting application development users and end users • Remotely resolving client’s database as well as application issues