Solution Architect with a specialization in Business Intelligence, possessing extensive knowledge in AWS S3, Athena, 9Cloud, EMR, and AirFlow. Proficient in leveraging tools such as Power BI (DAX), QlikView, QlikSense, and Tableau for the creation of dashboards. Experienced in utilizing Splunk, Python, R, and SQL Server Integration Services. Skilled in managing and administering Qlik Server (QMC, QVW, QVD) and Power BI environments. Demonstrates a robust ability in ETL processes, data layout management, and transactional data handling. Well-versed in Azure SQL Server Integration Services, Data Warehouse, and Data Lake management. Capable of drafting comprehensive requirement specifications, including functional and technical details and AS-IS mapping. Proficient in developing procedures, functions, packages, triggers, and jobs for Oracle ERP projects and maintaining processes for Oracle jobs with necessary updates and alterations. Experienced in generating scripts for tables, indexes, and constraints for new ERP system versions and contributing as a developer on projects involving Oracle Forms and Oracle Reports. Skilled in the analysis and development of extractors and converters, testing, and loading data, and maintaining import/export files via Shell Scripting. Proven expertise in relational and dimensional data modeling, advanced SQL development with PL/SQL, and the creation of detailed reports.
