A highly motivated computer engineering graduate currently working in Professional Services department of a well-reputed IT firm. Interests include data warehousing, Business Intelligence and Big Data applications.
Responsibilities include:
• Development of Procedures/functions for different modules of oracle application
• Extraction of information/data through PL/SQL according to the user requirement
• Oracle forms personalization at application level
• Developed an Email Notification System using oracle form
• Customized the joint Interest Billing Query using cursors in PLSQL
Responsibilities included:
• Troubleshooting system and network problems and diagnosing and solving minor hardware/software faults
• Handling queries of employees telephonically and generating daily complaint log.
• Involved in domain joining activity to join windows computer to OGDCL domain.
Learned the different ingredients of BI ecosystem with practical implementation of Data warehousing, Data Visualization, Data Science and Big Data Projects
- Gained hands on experience on different pillars of the modern DWH ecosystem starting from data ingestion techniques, architecture designs, operational excellence, performance-tuning, insights kindling by data visualization and data mining. Furthermore, also learn that how big data is transforming the conventional DWH systems in the modern era.
- Implemented complete End to End Data warehouse project on Teradata tool/ architecture on adventure works data set having huge transactional records. which includes
- Data loading from different source system into data staging layer through Fastload, writing BTEQ and Shell scripting also perform ETL
- Developed CDM and SDM layer and created BI visualization dashboard on Tableau
Learned the different ingredients of BI ecosystem with practical implementation of Data warehousing, Data Visualization, Data Science and Big Data Projects
- Gained hands on experience on different pillars of the modern DWH ecosystem starting from data ingestion techniques, architecture designs, operational excellence, performance-tuning, insights kindling by data visualization and data mining. Furthermore, also learn that how big data is transforming the conventional DWH systems in the modern era.
- Implemented complete End to End Data warehouse project on Teradata tool/ architecture on adventure works data set having huge transactional records. which includes
- Data loading from different source system into data staging layer through Fastload, writing BTEQ and Shell scripting also perform ETL
- Developed CDM and SDM layer and created BI visualization dashboard on Tableau
The RFID modules designed in the project, authenticate the people entering in the building/department, records the check in time and send the recorded file to the server wirelessly. Server uploads the received file from all the modules to RFID portal. RFID portal generates reports, updates new user data and deletes the existing if required. The project is ready-to-go solution and can be installed without any major wear and tear in the existing infra-structure.
A brief course offered by Industry Professionals on different ingredients of BI ecosystem such as different layers of data warehousing (Staging, Foundation, Access and Performance and Presentation Layer), Data Visualization, Data Science and Big Data. This course also provided opportunities for a hands on experience with different tools like Tableau and Teradata warehouse miner to see insights and hidden patterns in data.