Lakshmi Rishi Vardhan Tommandru
Atlanta,USA
Summary
Senior Business Systems Analyst with 8+ years of experience delivering enterprise solutions across banking, telecom, healthcare, retail, and insurance domains. Expertise in ERP implementation, ERP product support, Salesforce CRM (Sales & Service Cloud), and core banking integrations. Proficient in requirements gathering, AS-IS/TO-BE process modeling, GAP analysis, system design, and documentation (BRD, FRD, FSD, user stories, acceptance criteria). Experienced in ETL and data warehousing: Informatica, SSIS, ODI, IBM DataStage, AWS Redshift, SSAS. Strong data analytics and visualization skills: Power BI, OBIEE, Tableau, MicroStrategy, Cognos, Business Objects, TIBCO Spotfire. Skilled in cloud platforms: AWS, Microsoft Azure, Oracle IaaS/SaaS/PaaS. Knowledge of Identity and Access Management (IAM) and ITIL-based service management for ERP and enterprise applications. Hands-on in system integration testing (SIT), UAT, defect management, and post-production support. Experienced in service management tools: BMC Remedy, ServiceNow, CA Technologies. Adept at API integrations and middleware solutions for Salesforce, ERP, and financial systems. Strong understanding of banking compliance, data governance, audit standards, and HIPAA/PHI regulations. Experienced in Agile/Scrum methodologies: sprint planning, backlog grooming, sprint reviews, retrospectives, and release coordination. Capable of product ownership responsibilities, including roadmap planning, sprint backlog management, and stakeholder engagement. Proven ability to translate business requirements into scalable technical solutions. Expertise in core domains: Banking, Insurance, Healthcare, Telecom, Supply Chain, Retail e-commerce, HRMS, Automotive, Fleet, and Heavy Equipment. Skilled in incident resolution, problem management, and change management in enterprise IT settings. Hands-on experience with Salesforce workflows, validation rules, custom objects, dashboards, and reporting automation. Strong SQL skills for ETL validation, reconciliation, and financial reporting. Experienced in documenting end-to-end data flows, process diagrams, and system interactions.
Overview
10
10
years of professional experience
Work History
Senior Business Systems Analyst
T-Mobile
Atlanta, USA
02.2025 - Current
- Led ERP and telecom billing system integration with banking payment services, ensuring seamless data flows and compliance.
- Developed BRDs, FRDs, FSDs, and user stories aligned with banking regulations and ERP best practices.
- Modeled AS-IS/TO-BE business processes for financial transactions, telecom billing, and customer accounts.
- Designed source-to-target ETL mappings and workflows using Informatica, SSIS, and ODI.
- Validated ETL results using SQL scripts and reconciliation processes, ensuring 100% data accuracy.
- Supported Salesforce Sales & Service Cloud enhancements, including workflows, validation rules, dashboards, and approval processes.
- Coordinated API integrations between Salesforce, ERP, billing, and banking systems.
- Conducted system integration testing (SIT) and UAT, managing defects and ensuring timely resolution.
- Implemented IAM policies, role-based access controls, and audit trails for sensitive data.
- Managed post-production support, monitoring ERP and financial transaction workflows.
- Participated in Agile/Scrum ceremonies, backlog grooming, sprint planning, and release coordination.
- Utilized BMC Remedy and ServiceNow for incident and change management tracking.
- Trained business users on ERP and Salesforce dashboards for operational efficiency.
- Documented end-to-end process flows, data lineage, and integration diagrams for audit and compliance.
- Collaborated with cross-functional teams including development, QA, operations, and stakeholders.
- Ensured compliance with banking regulations, data governance, and audit controls.
- Implemented data quality checks, cleansing, and transformation procedures for ETL workflows.
- Optimized ETL pipelines for scalability, efficiency, and performance.
- Generated operational, financial, and compliance reports using Power BI and Tableau.
- Conducted stakeholder workshops for process improvement and requirement validation.
Senior Business Systems Analyst
Comerica Bank
Ann Arbor, USA
09.2021 - 01.2025
- Led ERP and core banking system implementations across loans, deposits, and payment systems.
- Gathered and documented functional and non-functional requirements, creating BRDs, FRDs, FSDs, and acceptance criteria.
- Modeled AS-IS and TO-BE processes and performed GAP analysis for banking workflows.
- Designed and validated ETL workflows integrating core banking data into warehouses.
- Supported Salesforce CRM enhancements, including workflows, reports, dashboards, and approval processes.
- Conducted API integrations between Salesforce and backend banking applications.
- Performed system integration testing and UAT, tracked defects, and ensured timely resolution.
- Ensured compliance with ITIL, banking regulations, and data governance.
- Utilized ServiceNow and BMC Remedy for incident, problem, and change management.
- Generated financial and operational reports for management and regulatory compliance.
- Participated in Agile/Scrum ceremonies and managed sprint deliverables.
- Conducted risk assessment and mitigation for financial and transactional processes.
- Trained business users on Salesforce, reporting tools, and ERP dashboards.
- Documented end-to-end system architecture, process flows, and data lineage.
- Collaborated with development, QA, and operations teams for seamless solution delivery.
Business Systems Analyst
Optum
Fort Worth, USA
08.2018 - 08.2021
- Gathered and analyzed requirements for claims, eligibility, and financial data systems.
- Authored BRDs, FRDs, FSDs, and user stories with detailed acceptance criteria.
- Modeled AS-IS and TO-BE processes for claims adjudication and payment workflows.
- Developed ETL pipelines using Informatica and AWS Redshift for healthcare data integration.
- Designed source-to-target mappings for claims and financial datasets.
- Validated ETL and reporting data using SQL scripts and reconciliation checks.
- Supported Salesforce Service Cloud for case management and member inquiries.
- Configured Salesforce workflows, dashboards, and reports.
- Coordinated API integrations between Salesforce, claims systems, and financial platforms.
- Conducted system integration testing and UAT for financial and claims modules.
- Tracked defects and collaborated with development teams for resolution.
- Ensured compliance with HIPAA, PHI, and healthcare data governance standards.
- Generated operational, financial, and compliance reports.
- Participated in Agile/Scrum ceremonies and sprint planning sessions.
- Provided post-production support for financial and claims workflows.
- Conducted stakeholder workshops for process validation and improvement.
- Documented end-to-end data flows, process diagrams, and system interactions.
- Performed data quality audits and cleansing for claims and financial data.
- Assisted in risk mitigation and compliance assessments.
- Trained business users on Salesforce, ETL dashboards, and reporting tools.
Associate Software Engineer
Aditi Technologies Pvt. Ltd.
Hyderabad, India
09.2015 - 12.2016
- Delivered end-to-end Salesforce solutions across Sales Cloud, Service Cloud, Experience Cloud, and Marketing Cloud.
- Integrated Salesforce with ERP systems (SAP, Oracle, NetSuite) using REST/SOAP and OData.
- Developed custom Apex REST APIs for subscription management and SaaS billing workflows.
- Created reusable Aura and LWC components to support multi-client UI requirements.
- Designed API-led MuleSoft architectures for clients across retail, SaaS, and manufacturing.
- Implemented Zapier workflows for lightweight CRM integrations for mid-sized clients.
- Built Flows, approval processes, and declarative automation for complex business processes.
- Designed scalable custom objects, field-level design, and ERDs for multi-cloud architectures.
- Integrated external data with Salesforce Connect and OData services.
- Built Apex batch jobs for ETL-like data processing for multiple enterprise clients.
- Developed Apex controllers for Visualforce pages used in legacy client applications.
- Configured Experience Cloud portals for partner and customer self-service.
- Implemented SFDX-based CI/CD using GitLab pipelines and automated deployments.
- Performed full SDLC documentation including data maps, sequence diagrams, and design specs.
- Executed complex data migrations using Data Loader, ETL scripts, and Apex ETL tools.
- Conducted stakeholder workshops to gather requirements and design technical solutions.
- Built cross-cloud reporting dashboards for sales, service, and partner performance.
- Optimized Apex code and SOQL queries for multi-org clients with high data volumes.
- Created unit tests delivering 90–95% coverage across multiple business modules.
- Mentored offshore and junior developers on Apex, LWC, and Salesforce best practices.
- Designed secure integration patterns with OAuth 2.0, API tokens, and Named Credentials.
- Developed third-party integrations with Marketo, HubSpot, Zendesk, and Jira.
- Implemented Salesforce Shield encryption for clients with regulatory requirements.
- Set up deployment pipelines using Copado for enterprise clients requiring audit trails.
- Built reusable metadata-driven frameworks for validation, logging, and exception handling.
- Supported multi-client managed services projects delivering enhancements across multiple orgs.
- Created plug-and-play LWC components for subscription renewals and license management.
- Established best practices for version control, branching strategies, and release management.
- Conducted performance audits and refactored legacy codebases for improved scalability.
- Successfully delivered 15+ multi-system integration projects across diverse industries.
Education
Master of Science - Information Systems
Central Michigan University
Mount Pleasant, MI05.2018
Bachelor of Science - Computer Science Engineering
Vignan University
Guntur, India06.2015
Skills
- Business Systems Analysis
- Requirements Gathering & Documentation
- BRD
- FRD
- FSD
- User Stories
- ETL & Data Warehousing
- Salesforce Sales Cloud & Service Cloud
- Data Mapping & STTM
- SQL & Data Reconciliation
- API & System Integrations
- UAT & Defect Management
- Agile / Scrum / SDLC
- Banking Compliance & Data Governance
- JavaScript (ES6)
- HTML
- CSS
- Bootstrap
- JSON
- XML
- AJAX
- AWS
- Azure Cloud
- Agile/Scrum
- JIRA
- Confluence
Projects
Rental Management System, Developed a full-stack Rental Management System as part of a Master's capstone project, enabling landlords and tenants to manage property listings, payments, and rental agreements efficiently., Python, Flask, Django, MySQL, PostgreSQL, HTML, CSS, JavaScript, Bootstrap, Designed and implemented Python-based backend services with Flask/Django to handle user authentication, property listings, lease tracking, and maintenance requests., Integrated a relational database (MySQL/PostgreSQL) to store and manage user data, property details, and rental transactions securely., Built dynamic, user-friendly interfaces using HTML, CSS, JavaScript, and Bootstrap, enhancing usability and responsiveness across devices., Implemented RESTful APIs for data interaction between frontend and backend, ensuring smooth and secure data communication., Used Git for version control and followed Agile development practices including weekly sprints and peer code reviews.
Methodologies
- Agile / Scrum
- Waterfall
- Hybrid SDLC
Timeline
Senior Business Systems Analyst
T-Mobile
02.2025 - Current
Senior Business Systems Analyst
Comerica Bank
09.2021 - 01.2025
Business Systems Analyst
Optum
08.2018 - 08.2021
Associate Software Engineer
Aditi Technologies Pvt. Ltd.
09.2015 - 12.2016
Master of Science - Information Systems
Central Michigan University
Bachelor of Science - Computer Science Engineering
Vignan University