• Gather and document client requirements and translate these into process/system architecture designs and involved in requirements analysis, design, development, deployment and support• Work in fast paced Agile team and work with Product Owners, Business Owners for PI planning, story creation from requirements and provide estimates.• Perform statistical analysis and deliver Insights and key KPIs on the data• Designed and created data interfaces between multiple applications to pull and transform the data using Python, Trifacta, Hive, BigData, PL SQL & Shell scripting• Developed functionally rich user-friendly dashboards to empower decision-makers of clients to effectively track and gather insights of business KPIs using tableau’s calculated fields, parameters, LOD & table calculations, sets, groups, actions etc.• Created intuitive what-if analysis dashboards bringing down the complexity of analysis and easily deliver insights to strategic planning leads of the organization• Evaluated and improvised multiple existing systems/procedures to enhance the efficiency by reducing the reduce the run around time, manual effort & errors• Created interactive Business Intelligence reports & dashboards to the leadership using Tableau• Developed machine learning models for forecasting budget, resources & their utilization• Created dashboards with row level security ensuring the data security is enforced

• Develop automation for business-critical interfaces between applications using Core Java, PLSQL, JavaScript and Shell Scripting• Design and develop packages, stored procedures, functions, triggers, materialized views, views and other DB objects to support custom objects for application interfaces and BI Reporting• Develop custom reports using PL SQL & Jasper Studio as per business requirements• Involved in developing, unit testing and deployment of the modules and preparing test plans to test the business functionalities of the modules• Automated bulk data loads, month end data loads and repetitive data changes and uploads to the applications

• Developing portlets, portlet pages using SQL to provide snapshot of the application data on the dashboards• Create or configure the objects for providing new/customize the functionality of the application to business needs• Develop processes using Jelly scripting to automate the application functionality and manual work• Develop stored procedures, functions, triggers, and packages in Oracle as per business requirements to drive the data interface between applications• Develop and configure various parts of the application like creating static & dynamic lookups, configuring views, audit attributes, access rights & groups etc.• Unit test the modules and prepare test plans to test the business functionalities of the modules