SQL BI Optimization Strategies in Finance and Banking

Authors

  • Sai Krishna Shiramshetty Independent Researcher, USA.

DOI:

https://doi.org/10.55544/ijrah.1.1.15

Keywords:

SQL, BI optimization, banking and financial, transaction monitoring

Abstract

To this end, this paper examines the best practice in making the finance and banking industry SQL BI more efficient and effective in terms of query execution and real-time analysis. Techniques such as Indexing, partitioning, query rewriting, parallel processing, in memory tables are explained practical to large financial data sets. These strategies were identified to enhance techniques such as transaction monitoring, customer analysis, financial reporting, and risk management since their execution duration is time-consuming. The paper will also focus on the role of the optimized SQL queries in the decision-making process and the issues, seen when seeking constant performance in financially volatile demonstrative systems.

Downloads

Download data is not yet available.

Metrics

Metrics Loading ...

References

Amini, M., Salimi, S., Yousefinejad, F., Tarokh, M. J., & Haybatollahi, S. M. (2021). The implication of business intelligence in risk management: a case study in agricultural insurance. Journal of data, information and management, 3, 155-166. https://doi.org/10.1007/s42488-021-00050-6

Brozović, V. (2020). Utilization of business intelligence tools and advanced analytics in systemic risk supervision (Doctoral dissertation, University of Zagreb. Faculty of Economics and Business). https://repozitorij.unizg.hr/islandora/object/efzg:5862

Ceaparu, C. (2021). IT solutions for big data processing and analysis in the finance and banking sectors. In Intelligent Methods in Computing, Communications and Control: Proceedings of the 8th International Conference on Computers Communications and Control (ICCCC) 2020 8 (pp. 133-144). Springer International Publishing. https://doi.org/10.1007/978-3-030-53651-0_11

da Costa, M. M. M. (2021). How to hire in finance and banking: The case of a human resources consulting firm (Master's thesis, Universidade Catolica Portuguesa (Portugal)). https://www.proquest.com/openview/6c326cd8be7b199f4759420b793ed977/1?pq-origsite=gscholar&cbl=2026366&diss=y

Doko, F., Kalajdziski, S., & Mishkovski, I. (2021). Credit risk model based on central bank credit registry data. Journal of Risk and Financial Management, 14(3), 138. https://doi.org/10.3390/jrfm14030138

Fejzaj, J. (2021). Portfolio optimization modeling through real time reports and analytics. International Journal of Computer Science and Information Security (IJCSIS), 19(4). https://d1wqtxts1xzle7.cloudfront.net/67611195/05_Paper_01042106_IJCSIS_Camera_Ready_pp36_42-libre.pdf?1623570917=&response-content-disposition=inline%3B+filename%3DPortfolio_optimization_modeling_through.pdf&Expires=1731225659&Signature=ZLpTJredYkrkrqTJ-Q3iYAoPcs3rfudHP0Oyj2PJox~dUBX5tVaL83w-8W~eujBMjpiJDszqUxQ-IjC28QLAwfyYEAX0a4ikSOtQnnrXdQSd9ZvTPTf5DsC3SSzCFYMWKbZ7XXBhOtUREi4gLyFeAzGI8zZ~Jpp4RvMXVsmmUG0jBEDbgzQlArsu9PZuygdquOZ6-6dKVqvsXbYdC6XL3cbXdl4f565YqSAOAyrnRcIZ4ovS4zQVW~pgdtMit2quzSo72WQveLBBhUnjmMciYX2b9Jl-MODNCs~~4prNMrKxb1IORAm8HrIrKzP25SPlEiJ1Pi-HLltARob-lu7TFw__&Key-Pair-Id=APKAJLOHF5GGSLRBV4ZA

Kumar, S., & Aithal, P. S. (2020). Banking and Financial Analytics–An Emerging Big Opportunity Based on Online Big Data. International Journal of Case Studies in Business, IT and Education (IJCSBE), 4(2), 293-309. https://doi.org/10.47992/IJCSBE.2581.6942.0097

Massardi, A. E., & Utama, D. N. (2018, September). Business intelligence design of rural bank performance assessment using financial ratio analysis. In 2018 International Conference on Information Management and Technology (ICIMTech) (pp. 143-148). IEEE. https://doi.org/10.1109/ICIMTech.2018.8528107

Muñoz-Sánchez, T., & Espinoza-Mejía, M. (2021, October). Proposal of a Real Time Microservice Architecture Applied to Business Intelligence for the Financial Sector. In International Conference on Applied Technologies (pp. 456-468). Cham: Springer International Publishing. https://doi.org/10.1007/978-3-031-03884-6_33

Osuagwu, J. (2020). Exploring Best Practices to Address Readiness Challenges Triggered by Implementation of Business Intelligence Solutions in Banking Industry. Colorado Technical University. https://www.proquest.com/openview/2a403ce694983bd774b5f9e04f5e9dd3/1?pq-origsite=gscholar&cbl=18750&diss=y

Skyrius, R., Giriūnienė, G., Katin, I., Kazimianec, M., & Žilinskas, R. (2018). The potential of big data in banking. Guide to Big Data Applications, 451-486. https://doi.org/10.1007/978-3-319-53817-4_17

Cherukuri, H., Singh, S. P., & Vashishtha, S. (2020). Proactive issue resolution with advanced analytics in financial services. The International Journal of Engineering Research, 7(8), a1-a13.https://tijer.org/tijer/viewpaperforall.php?paper=TIJER2008001

Cherukuri, H., Goel, E. L., & Kushwaha, G. S. (2021). Monetizing financial data analytics: Best practice. International Journal of Computer Science and Publication (IJCSPub), 11(1), 76-87.

Mehra, A. (2021). The impact of public-private partnerships on global educational platforms. Journal of Informatics Education and Research, 1(3), 9-28. Retrieved from http://jier.org

Ankur Mehra. (2019). Driving Growth in the Creator Economy through Strategic Content Partnerships. International Journal for Research Publication and Seminar, 10(2), 118–135. https://doi.org/10.36676/jrps.v10.i2.1519

Swethasri Kavuri, Suman Narne, " Implementing Effective SLO Monitoring in High-Volume Data Processing Systems, IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 6, Issue 2, pp.558-578, March-April-2020. Available at doi : https://doi.org/10.32628/CSEIT206479

Swethasri Kavuri, Suman Narne, " Improving Performance of Data Extracts Using Window-Based Refresh Strategies, International Journal of Scientific Research in Science, Engineering and Technology(IJSRSET), Print ISSN : 2395-1990, Online ISSN : 2394-4099, Volume 8, Issue 5, pp.359-377, September-October-2021. Available at doi : https://doi.org/10.32628/IJSRSET2310631

Swethasri Kavuri, " Automation in Distributed Shared Memory Testing for Multi-Processor Systems, International Journal of Scientific Research in Science, Engineering and Technology(IJSRSET), Print ISSN : 2395-1990, Online ISSN : 2394-4099, Volume 6, Issue 3, pp.508-521, May-June-2019. Available at doi : https://doi.org/10.32628/IJSRSET12411594

Shivarudra, A. (2021). Enhancing automation testing strategies for core banking applications. International Journal of All Research Education and Scientific Methods (IJARESM), 9(12), 1. Available online at http://www.ijaresm.com

Shivarudra, A. (2019). Leveraging TOSCA and Selenium for efficient test automation in financial services. International Journal of All Research Education and Scientific Methods (IJARESM), 7(10), 56–64.

Shivarudra, A. (2021). The Role of Automation in Reducing Testing Time for Banking Systems. Integrated Journal for Research in Arts and Humanities, 1(1), 83–89. https://doi.org/10.55544/ijrah.1.1.12

Bhatt, S. (2021). Optimizing SAP Migration Strategies to AWS: Best Practices and Lessons Learned. Integrated Journal for Research in Arts and Humanities, 1(1), 74–82. https://doi.org/10.55544/ijrah.1.1.11

Sachin Bhatt , " Innovations in SAP Landscape Optimization Using Cloud-Based Architectures, IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 6, Issue 2, pp.579-590, March-April-2020.

Bhatt, S. (2021). A comprehensive guide to SAP data center migrations: Techniques and case studies. International Journal of Scientific Research in Science, Engineering and Technology, 8(5), 346–358. https://doi.org/10.32628/IJSRSET2310630

Balachandar Paulraj. (2021). Implementing Feature and Metric Stores for Machine Learning Models in the Gaming Industry. European Economic Letters (EEL), 11(1). Retrieved from https://www.eelet.org.uk/index.php/journal/article/view/1924

Alok Gupta. (2021). Reducing Bias in Predictive Models Serving Analytics Users: Novel Approaches and their Implications. International Journal on Recent and Innovation Trends in Computing and Communication, 9(11), 23–30. Retrieved from https://ijritcc.org/index.php/ijritcc/article/view/11108

Vaidya, H., Nayani, A. R., Gupta, A., Selvaraj, P., & Singh, R. K. (2020). Effectiveness and future trends of cloud computing platforms. Tuijin Jishu/Journal of Propulsion Technology, 41(3). https://doi.org/10.52783/tjjpt.v45.i03.7820

Aravind Reddy Nayani, Alok Gupta, Prassanna Selvaraj, Ravi Kumar Singh, & Harsh Vaidya. (2019). Search and Recommendation Procedure with the Help of Artificial Intelligence. International Journal for Research Publication and Seminar, 10(4), 148–166. https://doi.org/10.36676/jrps.v10.i4.1503

Sagar Shukla. (2021). Integrating Data Analytics Platforms with Machine Learning Workflows: Enhancing Predictive Capability and Revenue Growth. International Journal on Recent and Innovation Trends in Computing and Communication, 9(12), 63–74. Retrieved from https://ijritcc.org/index.php/ijritcc/article/view/11119

Sneha Aravind. (2021). Integrating REST APIs in Single Page Applications using Angular and TypeScript. International Journal of Intelligent Systems and Applications in Engineering, 9(2), 81 –. Retrieved from https://ijisae.org/index.php/IJISAE/article/view/6829

Sachin Bhatt , " A Comprehensive Guide to SAP Data Center Migrations: Techniques and Case Studies, International Journal of Scientific Research in Science, Engineering and Technology(IJSRSET), Print ISSN : 2395-1990, Online ISSN : 2394-4099, Volume 8, Issue 5, pp.346-358, September-October-2021. Available at doi : https://doi.org/10.32628/IJSRSET2310630

Bhatt, S. (2021). A comprehensive guide to SAP data center migrations: Techniques and case studies. International Journal of Scientific Research in Science, Engineering and Technology (IJSRSET), 8(5), 346–358. https://doi.org/10.32628/IJSRSET2310630

Rinkesh Gajera , "Leveraging Procore for Improved Collaboration and Communication in Multi-Stakeholder Construction Projects", International Journal of Scientific Research in Civil Engineering (IJSRCE), ISSN : 2456-6667, Volume 3, Issue 3, pp.47-51, May-June.2019

Saoji, R., Nuguri, S., Shiva, K., Etikani, P., & Bhaskar, V. V. S. R. (2019). Secure federated learning framework for distributed AI model training in cloud environments. International Journal of Open Publication and Exploration (IJOPE), 7(1), 31. Available online at https://ijope.com.

Savita Nuguri, Rahul Saoji, Krishnateja Shiva, Pradeep Etikani, & Vijaya Venkata Sri Rama Bhaskar. (2021). OPTIMIZING AI MODEL DEPLOYMENT IN CLOUD ENVIRONMENTS: CHALLENGES AND SOLUTIONS. International Journal for Research Publication and Seminar, 12(2), 159–168. https://doi.org/10.36676/jrps.v12.i2.1461

Saoji, R., Nuguri, S., Shiva, K., Etikani, P., & Bhaskar, V. V. S. R. (2021). Adaptive AI-based deep learning models for dynamic control in software-defined networks. International Journal of Electrical and Electronics Engineering (IJEEE), 10(1), 89–100. ISSN (P): 2278–9944; ISSN (E): 2278–9952

Chinta, U., Aggarwal, A., & Jain, S. (2020). Risk management strategies in Salesforce project delivery: A case study approach. Innovative Research Thoughts, 7(3).

Bhimanapati, V. B. R., Renuka, A., & Goel, P. (2021). Effective use of AI-driven third-party frameworks in mobile apps. Innovative Research Thoughts, 7 (2)l Li.

Bhimanapati, V. B. R., Renuka, A., & Goel, P. (2021). Effective use of AI-driven third-party frameworks in mobile apps. Innovative Research Thoughts, 7 (2).

Nadukuru, S., Antara, F., Chopra, P., Renuka, A., & Goel, O. (2021). Agile methodologies in global SAP implementations: A case study approach. International Research Journal of Modernization in Engineering Technology and Science, 3(11), 1592-1605. https://doi.org/10.56726/IRJMETS17272

Mangal, A. (2021). Evaluating planning strategies for prioritizing the most viable projects to maximize investment returns. ESP Journal of Engineering & Technology Advancements, 1(2), 69-77. https://doi.org/10.56472/25832646/JETA-V1I2P110

Mangal, A. K. (2013). Multithreaded Java applications performance improvement. International Journal of Advanced Research in Computer Science and Software Engineering (IJARCSSE), 3(3), 47-50.

Mangal, A., Jain, V., Jat, R. C., Bharadwaj, S., & Jain, S. (2010). Neuro pharmacological study of leaves of Camellia sinensis. International Journal of Pharmacy and Pharmaceutical Sciences, 2(3), 132-134.

Mangal, A., Gaur, U., Jain, A., Goyal, U., Tripathi, R., & Rath, R. (2007). Alkaline phosphatase and placental alkaline phosphatase activity in serum of normal and pregnancy-induced hypertensive mothers. Journal of the International Medical Sciences Academy, 20, 117-120.

Mangal, A., Shrivastava, P., Gaur, U., Jain, A., Goyal, U., & Rath, G. (2005). Histochemical analysis of placental alkaline phosphatase in hypertensive disorders complicating pregnancy. Journal of the Anatomical Society of India, 54(2), 2005-12.

Mahimkar, S., & Lagan Goel, D. G. S. K. (2021). Predictive Analysis of TV Program Viewership UsinMaCreative Research Thoughts (IJCRT), ISSN, 2320–2882.

g Random Forest Algorithms. IJRAR-International Journal of Research and Analytical Reviews (IJRAR), 309–322.

Arulkumaran, R., Mahimkar, S., Shekhar, S., Jain, A., & Jain, A. (2021). Analyzing Information Asymmetry in Financial Markets Using Machine Learning. International Journal of Progressive Research in Engineering Management and Science, 1(2), 53–67. https://doi.org/10.58257/IJPREMS16.f

Shekhar, S., SHALU, J., & Tyagi, D. P. (2020). Advanced Strategies for Cloud Security and Compliance: A Comparative Study. IJRAR-International Journal of Research and Analytical Reviews (IJRAR), E-ISSN 2348–1269, P-ISSN 2349–5138, 396–407.

Chintha, V. R., & Priyanshi, P. Sangeet Vashishtha. (2020). 5G Networks: Optimization of Massive MIMO. IJRAR-International Journal of Research and Analytical Reviews (IJRAR), 7(1), 389-406.

Vishesh Narendra Pamadi, Dr. Priya Pandey, Om Goel. (2021). Comparative Analysis of Optimization Techniques for Consistent Reads in Key-Value Stores. International Journal of Creative Research Thoughts (IJCRT), 9(10), d797-d813. http://www.ijcrt.org/papers/IJCRT2110459.pdf

Pamadi, V. N., Chaurasia, D. A. K., & Singh, D. T. (2020). Comparative Analysis OF GRPC VS. ZeroMQ for Fast Communication. International Journal of Emerging Technologies and Innovative Research (www.jetir.org), 7(2), 937-951.

Pamadi, V. N., Chaurasia, D. A. K., & Singh, D. T. (2020). Effective Strategies for Building Parallel and Distributed Systems. International Journal of Novel Research and Development (www.ijnrd.org), 5(1), 23-42.

Nadukuru, S., Antara, F., Chopra, P., Renuka, A., & Goel, O. (2021). Agile methodologies in global SAP implementations: A case study approach. International Research Journal of Modernization in Engineering Technology and Science, 3(11), 1592–1605. https://doi.org/10.56726/IRJMETS1727

Avancha, S., Khan, S., & Goel, O. (2021). AI-driven service delivery optimization in IT: Techniques and strategies. International Journal of Creative Research Thoughts (IJCRT), 9(3), 6496–6510. Retrieved from http://www.ijcrt.org/

Avancha, S., Chhapola, A., & Jain, S. (2021). Client relationship management in IT services using CRM systems. Innovative Research Thoughts, 7(1).

Khair, M. A., Avancha, S., Gajbhiye, B., Goel, P., & Jain, A. (2021). The role of Oracle HCM in transforming HR operations. Innovative Research Thoughts, 9(5), 300. doi: 10.36676/irt.v9.i5.1489

Mahadik, S., Kolli, R. K., Eeti, S., Goel, P., & Jain, A. (2021). Scaling startups through effective product management. International Journal of Progressive Research in Engineering Management and Science, 1(2), 68–81.

Eeti, S., & Goel, P., & Renuka, A. (2021). Strategies for migrating data from legacy systems to the cloud: Challenges and solutions. TIJER (The International Journal of Engineering Research, 8(10), a1–a11.

Khatri, D. K., Chhapola, A., & Jain, S. (2021) AI-enabled applications in SAP FICO for enhanced reporting. International Journal of Creative Research Thoughts (IJCRT), ISSN: 2320-2882, k378-k393

Cherukuri, H., Pandey, P., & Siddharth, E. (2020). Containerized data analytics solutions in on-premise financial services. International Journal of Research and Analytical Reviews (IJRAR).

Pakanati, D., Goel, B., & Tyagi, P. (2021). Troubleshooting common issues in Oracle Procurement Cloud: A guide. International Journal of Computer Science and Public Policy, 11(3), 14-28. https://rjpn.org/ijcspub/papers/IJCSP21C1003.pdf

Pakanati, D., Goel, B., & Tyagi, P. (2021). Troubleshooting common issues in Oracle Procurement Cloud: A guide. International Journal of Computer Science and Public Policy, 11(3), 14-28. https://rjpn.org/ijcspub/papers/IJCSP21C1003.pdf

Kushwaha, G. S. (2021). Monetizing financial data analytics: Best practice. International Journal of Computer Science and Publication (IJCSPub), 11(1), 76-87. https://rjpn.org/ijcspub/papers/IJCSP21A1011.pdf

Cherukuri, H., Pandey, P., & Siddharth, E. (2020). Containerized data analytics solutions in on-premise financial services. International Journal of Research and Analytical Reviews (IJRAR), 7(1), 150-159. https://www.ijrar.org/papers/IJRAR19Y3150.pdf

Cherukuri, H., Goel, E. L., & Kushwaha, G. S. (2021). Monetizing financial data analytics: Best practice. International Journal of Computer Science and Publication (IJCSPub), 11(1), 76-87. https://rjpn.org/ijcspub/papers/IJCSP21A1011.pdf

doi:10.1109/TCC.2019.2904046

A deep reinforcement learning approach for green task scheduling in cloud computing with multiple objectives. Zhang, Y., Wang, Z., Chen, L., & Li, Y. (2020). IEEE Transactions on Services Computing, 13(2), 315-328. doi:10.1109/TSC.2019.2903323

A deep reinforcement learning approach for green task scheduling in cloud computing with energy and cost constraints. Wang, Z., Zhang, Y., Chen, L., & Li, Y. (2020). IEEE Transactions on Cloud Computing, 8(2), 322-336.

doi:10.1109/TCC.2019.2910078

Rajkumar, V., and V. Maniraj. "PRIVACY- PRESERVING COMPUTATION WITH AN EXTENDED FRAMEWORK AND FLEXIBLE

ACCESS CONTROL." 湖南大学学报 (自然科学版) 48.10 (2021).

A deep reinforcement learning approach for green task scheduling in cloud computing with uncertainty. Zhang, Y., Wang, Z., Chen, L., & Li, Y. (2020). IEEE Transactions on Sustainable Computing, 5(4), 721-733.

doi:10.1109/TSUSC.2019.2949822

A deep Q-learning approach for green task scheduling in cloud computing with multiple objectives and uncertainty. Wang, Z., Zhang, Y., Chen, L., & Li, Y. (2020). IEEE Transactions on Services Computing, 13(4), 691-704. doi:10.1109/TSC.2019.2940153

Rajkumar, V., and V. Maniraj. "RL-ROUTING: A DEEP REINFORCEMENT LEARNING SDN ROUTING ALGORITHM." JOURNAL OF EDUCATION: RABINDRABHARATI UNIVERSITY (ISSN: 0972-7175) 24.12 (2021).

A deep reinforcement learning approach for green task scheduling in cloud computing with energy and cost constraints and uncertainty. Zhang, Y., Wang, Z., Chen, L., & Li, Y. (2021). IEEETransactions on Cloud Computing, 9(1), 133

Rajkumar, V., and V. Maniraj. "HYBRID TRAFFIC ALLOCATION USING APPLICATION-AWARE ALLOCATION OF RESOURCES IN CELLULAR NETWORKS." Shodhsamhita (ISSN: 2277-7067)12.8 (2021).

Rao, P. R., Chhapola, A., & Kaushik, S. (2021). Building and deploying microservices on Azure: Techniques and best practices. International Journal of Novel Research and Development, 6(3), 1–16. IJNRD.

Pattabi Rama Rao, E. O. G., & Kumar, D. L. (2021). Optimizing cloud architectures for better performance: A comparative analysis. International Jou

rnal of Creative Research Thoughts (IJCRT), ISSN 2320-2882.

Nittala, S. R., Mallikarjun, L., Bhanumathy, V., et al. (2014). Studies on the impact of road traffic noise inside selected schools of Tiruchirappalli city, Tamilnadu, India. Noise & Vibration Worldwide, 45(11), 19–27. https://doi.org/10.1260/0957-4565.45.11.19

Mokkapati, C., Jain, S., & Jain, S. (2021). Enhancing site reliability engineering (SRE) practices in large-scale retail enterprises. International Journal of Creative Research Thoughts (IJCRT), 9(11). https://www.ijcrt.org/

Alahari, J., Tangudu, A., Mokkapati, C., Khan, S., & Singh, S. P. (2021). Enhancing mobile app performance with dependency manag

ement and Swift Package Manager (SPM). International Journal of Progressive Research in Engineering Management and Science, 1(2), 130-138.

Vijayabaskar, S., Tangudu, A., Mokkapati, C., Khan, S., & Singh, S. P. (2021). Best practices for managing large-scale automation projects in financial services. International Journal of Progressive Research in Engineering Management and Science, 1(2), 107-117. https://doi.org/10.58257/IJPREMS12.

Salunkhe, V., Ayyagiri, A., Musunuri, A., Jain, Prof. Dr. A., & Goel, Dr. P. (2021). Machine learning in clinical decision support: Applications, challenges, and future directions. Available at SSRN: https://ssrn.com/abstract=4985006 or http://dx.doi.org/10.2139/ssrn.4985006

Voola, P. K., Murthy, K. K. K., Cheruku, S. R., Singh, S. P., & Goel, O. (2021). Conflict management in cross-functional tech teams: Best practices and lessons learned from the healthcare sector. International Research Journal of Modernization in Engineering, Technology, and Science, 3(11), 1508–1517. https://doi.org/10.56726/IRJMETS16992

Cheruku, S. R., Renuka, A., & Pandian, P. K. G. Real-time data integration using Talend Cloud and Snowflake. International Journal of Creative Research Thoughts (IJCRT), ISSN 2320-2882, g960–g977.

Voola, P. K., Gangu, K., Pandian, P. K. G., Goel, D. P., & Jain, P. (2021). AI-Driven Predictive Models in Healthcare: Reducing Time-to-Market for Clinical Applications

Alahari, J., Tangudu, A., Mokkapati, C., Khan, S., & Singh, S. P. (2021). Enhancing mobile app performance with dependency management and Swift Package Manager (SPM). International Journal of Progressive Research in Engineering Management and Science, 1(2), 130-138.

Vijayabaskar, S., Tangudu, A., Mokkapati, C., Khan, S., & Singh, S. P. (2021). Best practices for managing large-scale automation projects in financial services. International Journal of Progressive Research in Engineering Management and Science, 1(2), 107-117. https://doi.org/10.58257/IJPREMS12

Rambabu, S., Sriram, K. K., Chamarthy, S., & Parthasarathy, P. (2021). A proposal for a correlation to calculate pressure drop in reticulated porous media with the help of numerical investigation of pressure drop in ideal & randomized reticulated structures. Chemical Engineering Science, 237, 116518. Pergamon.

Hidayah, R., Chamarthy, S., Shah, A., Fitzgerald-Maguire, M., & Agrawal, S. K. (2019). Walking with augmented reality: A preliminary assessment of visual feedback with a cable-driven active leg exoskeleton (C-ALEX). IEEE Robotics and Automation Letters, 4(4), 3948-3954. IEEE.

Hidayah, R., Jin, X., Chamarthy, S., Fitzgerald, M. M., & Agrawal, S. K. (2018). Comparing the performance of a cable-driven active leg exoskeleton (C-ALEX) over-ground and on a treadmill. In 2018 7th IEEE International Conference on Biomedical Robotics and Biomechatronics (Biorob) (pp. 299-304). IEEE.

Jin, X., Hidayah, R., Chamarthy, S., Fitzgerald, M. M., & Agrawal, S. K. (2018). Comparing the performance of a cable-driven active leg exoskeleton (C-ALEX) over-ground and on a treadmill. In 2018 7th IEEE International Conference on Biomedical Robotics and Biomechatronics (Biorob) (pp. 299-304). IEEE.

Srinivasan, K., Siddharth, C. S., Kaarthic, L. V. A., & Thenarasu, M. (2018). Evaluation of mechanical properties, economic and environmental benefits of partially replacing silica sand with biomass ash for aluminium casting. Materials Today: Proceedings, 5(5), 12984-12992. Elsevier.

Salunkhe, V., Ayyagari, A., Musunuri, A., Jain, A., & Goel, P. (2021). Machine learning in clinical decision support: Applications, challenges, and future directions. International Research Journal of Modernization in Engineering, Technology, and Science, 3(11), 1493–1506. https://doi.org/10.56726/IRJMETS16993

Ayyagari, A., Goel, P., & Verma, P. (2021). Exploring microservices design patterns and their impact on scalability. International Journal of Creative Research Thoughts (IJCRT), 9(8), e532–e551. https://www.ijcrt.org/

Murthy, K. K. K., & Gupta, V., Prof.(Dr.) Punit Goel. Transforming legacy systems: Strategies for successful ERP implementations in large organizations. International Journal of Creative Research Thoughts (IJCRT), ISSN 2320-2882, h604–h618.

Voola, P. K., Murthy, K. K. K., Cheruku, S. R., Singh, S. P., & Goel, O. (2021). Conflict management in cross-functional tech teams: Best practices and lessons learned from the healthcare sector. International Research Journal of Modernization in Engineering, Technology, and Science, 3(11), 1508–1517. https://doi.org/10.56726/IRJMETS16992

Mahadik, S., Kolli, R. K., Eeti, S., Goel, P., & Jain, A. (2021). Scaling startups through effective product management. International Journal of Progressive Research in Engineering Management and Science, 1(2), 68-81.

Upadhyay, A., Oommen, N. M., & Mahadik, S. (2021). Identification and assessment of Black Sigatoka disease in banana leaf. In V. Goar, M. Kuri, R. Kumar, & T. Senjyu (Eds.), Advances in Information Communication Technology and Computing (Vol. 135). Springer, Singapore. https://doi.org/10.1007/978-981-15-5421-6_24

Musunuri, A., Goel, O., & Agarwal, N. (2021). Design strategies for high-speed digital circuits in network switching systems. International Journal of Creative Research Thoughts (IJCRT), 9(9), d842–d860. https://www.ijcrt.org/

Salunkhe, V., Ayyagiri, A., Musunuri, A., Jain, Prof. Dr. A., & Goel, Dr. P. (2021). Machine learning in clinical decision support: Applications, challenges, and future directions. Available at SSRN: https://ssrn.com/abstract=4985006 or http://dx.doi.org/10.2139/ssrn.4985006

Arulkumaran, R., Mahimkar, S., Shekhar, S., Jain, A., & Jain, A. (2021). Analyzing information asymmetry in financial markets using machine learning. International Journal of Progressive Research in Engineering Management and Science, 1(2), 53-67. https://doi.org/10.58257/IJPREMS16

Arulkumaran, R., Mahimkar, S., Shekhar, S., Jain, A., & Jain, A. (2021). Analyzing information asymmetry in financial markets using machine learning. International Journal of Progressive Research in Engineering Management and Science, 1(2), 53-67. https://doi.org/10.58257/IJPREMS16

Alahari, J., Tangudu, A., Mokkapati, C., Khan, S., & Singh, S. P. (2021). "Enhancing Mobile App Performance with Dependency Management and Swift Package Manager (SPM)." International Journal of Progressive Research in Engineering Management and Science, 1(2), 130-138.

Vijayabaskar, S., Tangudu, A., Mokkapati, C., Khan, S., & Singh, S. P. (2021). "Best Practices for Managing Large-Scale Automation Projects in Financial Services." International Journal of Progressive Research in Engineering Management and Science, 1(2), 107-117. https://doi.org/10.58257/IJPREMS12.

Alcaide, R., Agarwal, N., Candassamy, J., Cavanagh, S., Lim, M., Meschede-Krasa, B., McIntyre, J., Ruiz-Blondet, M. V., Siebert, B., Stanley, D., Valeriani, D., & Yousefi, A. (2021). EEG-based focus estimation using Neurable’s Enten headphones and analytics platform. bioRxiv. https://doi.org/10.1101/2021.06.21.48991

Agarwal, N., Thakur, D., Krishna, K., Goel, P., & Singh, S. P. (2021). LLMS for data analysis and client interaction in MedTech. SSRN. https://ssrn.com/abstract=4982700

Agarwal, N., Chinta, U., Bhimanapati, V. B. R., Jain, S., & Jain, S. (2021). EEG-based focus estimation model for wearable devices. SSRN. https://ssrn.com/abstract=4982710

Chandramouli, A., Shukla, S., Nair, N., Purohit, S., Pandey, S., & Dandu, M. M. K. (2021). Unsupervised paradigm for information extraction from transcripts using BERT. ECML PKDD 2021. https://doi.org/10.48550/arXiv.2110.00949

Dandu, M. M. K., & Kumar, G. (2021). Composable NLP workflows for BERT-based ranking and QA system. UC San Diego. Retrieved from [https://gaurav5590.github.io/data/UCSD_CASL_Research_Gaurav_Murali.pdf].

Voola, Pramod Kumar, Gangu, K., Pandian, P. K. G., Goel, Dr. Punit, & Jain, Prof. Dr. Arpit. (2021). AI-driven predictive models in healthcare: Reducing time-to-market for clinical applications. Available at SSRN: https://ssrn.com/abstract=4984971 or http://dx.doi.org/10.2139/ssrn.4984971

Balasubramaniam, V. S., Vijayabaskar, S., Voola, P. K., Agarwal, R., & Goel, O. (2021). Improving digital transformation in enterprises through agile methodologies. International Journal for Research Publication and Seminar, 13(5), 507-537.

Voola, Pramod Kumar, Murthy, K. K., Cheruku, S. R., Singh, Dr. S. P., & Goel, O. (2021). Conflict management in cross-functional tech teams: Best practices and lessons learned from the healthcare sector. Available at SSRN: https://ssrn.com/abstract=4984973 or http://dx.doi.org/10.2139/ssrn.4984973

Vijayabaskar, S., Tangudu, A., Mokkapati, C., Khan, S., & Singh, S. P. (2021). Best practices for managing large-scale automation projects in financial services. International Journal of Progressive Research in Engineering Management and Science, 1(2), 107-117. https://doi.org/10.58257/IJPREMS12

Rambabu, S., Sriram, K. K., Chamarthy, S., & Parthasarathy, P. (2021). A proposal for a correlation to calculate pressure drop in reticulated porous media with the help of numerical investigation of pressure drop in ideal & randomized reticulated structures. Chemical Engineering Science, 237, 116518. Pergamon.

Hidayah, R., Chamarthy, S., Shah, A., Fitzgerald-Maguire, M., & Agrawal, S. K. (2019). Walking with augmented reality: A preliminary assessment of visual feedback with a cable-driven active leg exoskeleton (C-ALEX). IEEE Robotics and Automation Letters, 4(4), 3948-3954. IEEE.

Hidayah, R., Jin, X., Chamarthy, S., Fitzgerald, M. M., & Agrawal, S. K. (2018). Comparing the performance of a cable-driven active leg exoskeleton (C-ALEX) over-ground and on a treadmill. In 2018 7th IEEE International Conference on Biomedical Robotics and Biomechatronics (Biorob) (pp. 299-304). IEEE.

Jin, X., Hidayah, R., Chamarthy, S., Fitzgerald, M. M., & Agrawal, S. K. (2018). Comparing the performance of a cable-driven active leg exoskeleton (C-ALEX) over-ground and on a treadmill. In 2018 7th IEEE International Conference on Biomedical Robotics and Biomechatronics (Biorob) (pp. 299-304). IEEE.

Srinivasan, K., Siddharth, C. S., Kaarthic, L. V. A., & Thenarasu, M. (2018). Evaluation of mechanical properties, economic and environmental benefits of partially replacing silica sand with biomass ash for aluminium casting. Materials Today: Proceedings, 5(5), 12984-12992. Elsev

Cherukuri, H., Singh, S. P., & Vashishtha, S. (2020). Proactive issue resolution with advanced analytics in financial services. The International Journal of Engineering Research, 7(8), a1-a13.https://tijer.org/tijer/viewpaperforall.php?paper=TIJER2008001

Cherukuri, H., Goel, E. L., & Kushwaha, G. S. (2021). Monetizing financial data analytics: Best practice. International Journal of Computer Science and Publication (IJCSPub), 11(1), 76-87.

Downloads

Published

2021-11-30

How to Cite

Shiramshetty, S. K. (2021). SQL BI Optimization Strategies in Finance and Banking. Integrated Journal for Research in Arts and Humanities, 1(1), 106–116. https://doi.org/10.55544/ijrah.1.1.15

Most read articles by the same author(s)