Lakshmi R
Data Engineer
About
My professional journey started as a data engineer in the year 2012 with most advanced and innovative technologies where I enjoy and immerse myself in a diverse range of technologies, including AWS Lambda, Python, S3, SNS, CloudWatch, DynamoDB, VPC, NumPy, CNN, Kafka, TOAD, Eclipse, Apache Tomcat. I found myself working on various projects in domains like manufacturing, financial, healthcare, and e-commerce.
As the years progressed, from 2015 to 2017, my skills expanded to encompass new technologies and platforms. I delved into AWS Lambda, Kinesis, EMR, API Gateway, HDFS, Oozie, Hive, Sqoop, Snowflake, Spark, Zookeeper, Apache NiFi, Pyspark, Terraform, few AWS services(Redshift, SNS, SQS, S3, IAM,) Jenkins, Netezza, Git. During this period, my projects continued to span different domains, gaining valuable experience and expertise.
Experience
Senior Technical Business Analyst - TRAVELERS INSURANCE - Hartford, CT
(2023-11 - 2025-03)
- Conducted discovery workshops, stakeholder interviews, and requirement-gathering sessions to identify business needs and translate them into detailed functional and technical specifications.
- Analyzed existing policy administration, billing, claims, and underwriting workflows to identify process improvement opportunities and automation initiatives.
- Created and maintain Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), process flows, use cases, wireframes, user stories, and acceptance criteria.
- Collaborated with Solution Architects to define system integrations involving policy administration systems, payment gateways, reporting platforms, and third-party vendor applications.
- Worked extensively with SQL to validate business data, reconcile policy transactions, investigate production issues, and verify system enhancements.
- Utilized Python scripts for data validation, reconciliation reporting, and automation of manual business processes.
- Performed API analysis and integration validation using REST services, JSON payloads, and API documentation to ensure seamless communication between applications.
- Facilitated Agile ceremonies including Sprint Planning, Backlog Grooming, Daily Standups, Sprint Reviews, and Retrospectives.
- Lead User Acceptance Testing (UAT) by creating test scenarios, test cases, executing tests, coordinating business users, and obtaining production sign-offs.
- Partnered with QA teams to review test coverage, validate defects, and ensure successful resolution prior to deployment.
- Supported production releases by conducting impact assessments, release validation, and post-implementation verification.
- Collaborated with compliance, finance, underwriting, and operations teams to ensure solutions meet regulatory and audit requirements.
- Developed Power BI dashboards and operational reports that provide visibility into claims processing, billing exceptions, and policy servicing metrics.
- Performed root cause analysis for production incidents and recommend long-term corrective actions.
- Reduced manual reconciliation efforts by 30% through automation of validation processes using SQL and Python.
- Improved requirements quality and reduced UAT defects by 25% through enhanced stakeholder engagement and requirement traceability practices.
Technical Business Analyst - INKIT SOLUTIONS - Hyderabad, India
(2016-05 - 2021-06)
- Gathered business requirements from stakeholders and translated them into detailed functional and technical specifications for enterprise applications.
- Worked closely with business users, project managers, developers, and QA teams throughout the Software Development Life Cycle (SDLC).
- Conducted Gap Analysis and As-Is/To-Be process assessments to identify operational inefficiencies and recommend system improvements.
- Created workflow diagrams, business process models, data flow diagrams, and use case documentation using Visio and Lucid chart.
- Supported implementation of ERP, CRM, and reporting solutions involving Salesforce, SAP, Oracle, and custom-built applications.
- Participated in data migration initiatives by performing data mapping, transformation analysis, validation, and reconciliation activities.
- Developed SQL queries to analyze customer, transaction, and operational datasets for reporting and business intelligence purposes.
- Collaborated with technical teams to define API integration requirements between internal and external systems.
- Assisted in designing reporting dashboards and KPI scorecards using Power BI and Tableau.
- Conducted requirement walkthroughs, solution reviews, and user training sessions for business users.
- Managed requirement traceability matrices (RTM) to ensure complete coverage from requirements through testing and deployment.
- Led User Acceptance Testing activities including test planning, defect tracking, business validation, and release readiness reviews.
- Coordinated production deployments and post-production support activities.
- Worked on multiple Agile projects utilizing Scrum methodologies and JIRA for backlog management and sprint tracking.
- Improved operational efficiency by identifying automation opportunities that reduced manual processing time by approximately 35%.
- Increased data accuracy and reporting consistency through implementation of standardized validation and reconciliation procedures.
Python Trainer - Python Trainer & Technical Consultant
(2012-06 - 2016-04)
- Delivered classroom and online training programs covering Python Programming, SQL, Data Structures, Object-Oriented Programming, and Software Development fundamentals.
- Designed comprehensive training materials, assignments, coding exercises, and capstone projects.
- Conducted hands-on workshops covering Python automation, file processing, database connectivity, APIs, and data analytics.
- Trained students and working professionals on Python libraries including Pandas, NumPy, Matplotlib.
- Developed real-world business use cases involving data analysis, reporting automation, and ETL concepts.
- Mentored over 250 students and professionals, achieving consistently high placement and certification success rates.
- Provided technical consulting for small automation projects and reporting solutions utilizing Python and SQL.
- Assisted learners in developing industry-ready projects focused on analytics, automation, and business reporting.
Education
Master of Science - Engineering Management - Gannon University, PA, USA (2023-05)
Bachelor of Technology - Mechanical Engineering - Jawaharlal Nehru Technological University, Hyderabad, India (2008-05)

