With BP as client, works as part of Rapid Application Development (RAD) team to support/develop LNG decision support systems. Including design, implements, and maintains of reliable and scalable software supporting our key user groups.Responsible for building dashboards (in plotly) , automating data fetch/ transformations and report generation from various databases using services and apis for Trading Analytics teams.

Building T24 R18 architecture compliant Data Warehouse and Reporting for Wealth Management products as a Data Engineer/Business Analyst.

Develop Applications using MS office products like MS Excel, MS Access with VBA/macro programming as backend language in insurance domain. I have created around 7 applications from scratch and supported around 15 existing applications. Keeping a check on the status of applications, its maintenance and planning notifications for the same.Performing daily checks to ensure all automation are in place and generating correct files.Manage Change Requirements/ Trouble shooting and conduct data analysis for insurance premiums paid• Using Tableau desktop toa. Create metrics, attributes, filters, reports and dashboardsb. Create advanced chart types, visualizations and complex calculations to manipulate the datac. Design, develop and support BI solutions, involved in debugging and monitoring and troubleshooting issues.Perform data analysis and trouble shooting for CMS database using SQL/T-SQL under SQL Server.Built SSIS package for automation of few reports.

• Providing support to various analytical Proprietary knowledge applications leveraged by McKinsey customers.• UI/ Smoke testing for various applications• UAT testing for the pricing tool.• Keep a check on the status of applications and planning Outages/Notifications for the same.• Assisting the team in setting up the process - protocols for the optimum Resource utilization and maintaining SLA of requests• Involved in all kind of Automation in the team and work with PKO (Proprietary Knowledge Organization) for adhoc automations/macros. • Assisting other teams to eliminate complex and manual work by suggesting complex excel functions or VBA automations.

Key responsibilities:- Bridging the knowledge gap between clients and development team. Understanding and documenting customer requirements. - Analyzing ad-hoc change requests and bug handling. Includes analysis, development and documenting the same. - Creating use cases for any new /existing change to be made in the module. - Developing the software module as per the desired, and documented, customer requirements. Making appropriate modifications/rectifications as per the change-requests/bug-reports. - Manual testing of various software modules and facilitating User Acceptance Tests - Training client team on various aspects of the product from user as well as development perspective. Coaching and mentoring junior.