Devendra Lakhotia

Group Treasury Transformation, Liquidity Technology

• Analyzed complex business requirements to develop effective high level technical solutions and drive project success.
• Worked in a cross-functional Agile train alongside stakeholders, solution designers, business analysts, architects, and data engineers
• Led stakeholder meetings to gather insights, ensuring alignment between business needs and technology capabilities.
• Identify issues, assess risks, and propose improvements to optimise system design.
• Ensure technical specifications meet high standards and align with delivery processes.
• Actively contribute to Agile practices, estimation, and delivery planning sessions.
• Mentored junior analysts in best practices for data analysis and requirement gathering, fostering professional growth within the team.

• Business Analysis using various analytics techniques to develop comprehensible analytical solution to solve different Ad-hoc request.
• Pre & post Analysis for different Campaign launching (NBC) and presented data by creating various Reports.
• Generating Insights & Trends for different financial products and related campaigns.
• Analysing the web traffic metrics generated by the Digital Campaigns running in BPB CBA.
• Responsible for interacting with business partners to identify needs and business requirements
• Analysed the Digital Campaigns data to identify campaign effectiveness across different Channels using Adobe Analytics and Tableau.
• Preparation of brief document for Implementation & build by defining the Next Best Conversations for customers.

• Reporting - Responsible for developing, publishing and maintaining Tableau dashboards and Data sources.
• Responsible for interacting with business partners to identify needs and business requirements for creating BI reports.
• Getting Insights into database and transform data according to the requirements.
• Creating checklist for performance and Dashboards developments.
• Testing the Reports(UAT).
• Publishing the reports to server, applying securities and giving custom permissions to access the reports.
• Responsible for creating/scheduling reports using BI Analytics to extract data from Remedy.

• Analysing the web traffic metrics generated by the Digital Campaigns running in CBA.
• Responsible for interacting with business partners to identify needs and business requirements for creating BI reports.
• Analysed the Digital Campaigns data to identify campaign effectiveness across different Channels using Adobe Analytics and Tableau.
• Preparation of brief document for Implementation & build by defining the Next Best Conversations for customers.
• Business Analysis using various analytics techniques to develop comprehensible analytical solution to solve different Ad-hoc request.
• Pre & post Analysis for different Campaign launching (Target Segment) and presented data by creating various Dashboards.
• Generating Insights & Trends for different financial products and related campaigns.

• Worked for a US based client (BFSI) in SAS automation and Reporting.
• Developed, tested and modified SAS stored MACROS that are used in SAS Programs that create Reports.
• Troubleshoot and improve performance of SAS programs that do not run properly and make sure it.
• Automated hard coded programs and Business reports for Performance monitoring and Documented SAS processes and trained new hires.

• Providing experience and behavioral analytics to better understand member experiences as well as facilitate insights for a US based client (Insurance).
• Deliver, Standardize and Centralize DXD reporting and analytics to drive operational and digital insights.
• Analysis & Insights on Web Page Optimisation and Reporting using Dashboards.
• Performed Cross channel analysis in Web Analytics to reduce MSR calls for servicing activities and to engage members through digital Channel.
• Performed regression analysis, segmentation analysis, and correlation analysis.
• Extracting data from existing data sources, Developing and executing Business reports for Performance Monitoring.
• Create Tables, listings and graphs using the SAS datasets with procedures such as DATA STEP, PROC.
• Developed, tested and modified SAS stored MACROS that are used in SAS Programs that create Reports.

• Responsibilities include Performance tuning, indexing, analysing database objects.
• Database object creation, disaster recovery and security.
• Database design and implementation for e-learning solution to a private banking organization.
• Part of the team that implemented Microsoft business intelligence tools for the first time in the organization.
• Developing comp stored procedures using SQL in SQL server 2008 for the back end design of the e-learning solution.