Hema Lakhani
Business Analyst
Pune
Summary
Dynamic IT professional with over 11.6 years of total experience with 5 years as a Business Analyst, specializing in leading digital initiatives within the banking and retail sectors. Expertise includes translating complex business objectives into structured solutions, ensuring strong stakeholder alignment and comprehensive documentation. Proven track record of driving process improvements and managing project scope in Agile environments demonstrates a commitment to delivering impactful results. Recognized for clarity, ownership, and a customer-centric approach, consistently enabling business value while collaborating with top-tier BFSI clients.
Overview
12
12
years of professional experience
8
8
Certifications
Work History
Business Analyst
E&Y Global (Big4)
06.2021 - 09.2023
- Leading on-boarding of applications and integrations in UAT & Production
- Conducted stakeholder interviews and workshops to gather, document, and validate end-to-end business requirements for data integration and Tableau reporting.
- Created detailed BRDs and user stories; mapped data flows between Nike systems and analytics platforms.
- Performed process mapping, identified inefficiencies, and recommended improvements for optimized decision-making and workflow execution.
- Acted as the primary communication bridge between US-based stakeholders and offshore tech teams to ensure clarity and scope alignment.
- Supported UAT by writing test cases and validating reports based on defined KPIs and business logic.
- Delivered actionable data-driven insights by analyzing business metrics, improving reporting effectiveness and transparency.
- Conducted Knowledge Transfer/training sessions for new onboarded Associates
- Implemented business solutions by building relationships with key business stakeholders & clients (banks), analyzing & validating business requirements.
- Escalated issues, if required to Product Engineering/Systems Engineering in accordance with business escalation procedures
- Project: Nike (US)
- Analyzed complex business requirements, translating them into actionable insights that enhanced operational efficiency across departments.
- Collaborated with cross-functional teams to develop strategic solutions, improving project delivery timelines and stakeholder satisfaction.
- Led comprehensive data analysis initiatives, identifying trends that informed executive decision-making and drove organizational growth.
- Developed and implemented process improvement strategies, resulting in streamlined workflows and reduced operational bottlenecks.
Senior Applications Developer
Bank of New York Technologies
05.2019 - 06.2021
- Led technical analysis and solutioning for financial reporting modules, guiding junior developers and collaborating with business teams for requirement clarification.
- Designed and maintained data marts and implemented dimensional modelling for investment-related data.
- Built Change Data Capture (CDC) workflows to track application value calculations and debt movement, reducing manual errors by 50%.
- Automated email alerts for various financial scenarios, significantly reducing support workload and manual intervention
- Project: Prudential Group of Investment Management (U.S.)
Senior Analyst
State Street
04.2015 - 06.2019
- Managed requirement gathering and documentation for building a large-scale data warehouse.
- Designed and implemented Informatica mappings, transformations, mapplets, workflows, and job schedules in an Agile setup.
- Performed analytical calculations on securities, trades, and fund movements to deliver enhanced reports.
- Scheduled ETL jobs with dependency management and ownership, ensuring smooth batch executions and timely data availability.
- Improved user base by 32% through accurate fund-based reporting and dashboard enhancements.
- Project: State Street (Germany)
Senior Applications Developer
Tata Consultancy Services
03.2012 - 05.2015
- Developed Informatica mappings, workflows, and complex ETL logic to support banking data operations.
- Implemented error-handling frameworks to improve ETL pipeline robustness.
- Led code release processes across environments (DEV, TEST, UAT, PROD), identifying and escalating risks and deployment issues to stakeholders.
- Delivered outbound reporting files and managed indirect data loads for regulatory submissions.
- Project: General Electrics Capital Bank
Education
Bachelor Tech (BE) - Electrical, Electronics And Communications Engineering
Sri Vaishnav Institute of Technology
08.2011
Skills
Business requirements analysis
Certification
Business Analysis Foundations
Interests
Conducted Offline and Online (Covid) workshops for Corporates- Appdirect, Pune, corporate professionals across Globe for Emotional Intelligence, Traveling, Watching Standup comedy
AWARDS / RECOGNITIONS
WOW Award – BNY Mellon: “Drive & Excellence”, WOW Award – BNY Mellon: “Connect the Dots”, SPOT Award – EY: Digital Transformation
Timeline
Business Analyst
E&Y Global (Big4)
06.2021 - 09.2023
Senior Applications Developer
Bank of New York Technologies
05.2019 - 06.2021
Senior Analyst
State Street
04.2015 - 06.2019
Senior Applications Developer
Tata Consultancy Services
03.2012 - 05.2015
Bachelor Tech (BE) - Electrical, Electronics And Communications Engineering
Sri Vaishnav Institute of Technology