Swapna Mangalvedhekar
Data Engineer
Mumbai
Summary
A highly skilled and results-driven IT professional with over 14 years of extensive experience, including 3 years as a Data Engineer and 3 years in ETL Testing. Proven expertise in designing, implementing, and optimizing robust data pipelines, data integration solutions, and ETL processes. Possesses a strong background in manual testing of web applications, mainframes, and telecom sales, along with endpoint management. Adept at leveraging analytical skills and technical knowledge to deliver high-quality, scalable, and efficient data solutions that support business objectives.
Overview
14
14
years of professional experience
4
4
years of post-secondary education
1
1
Certificate
1
1
Language
Work History
Data Engineer
Persistent Systems
Mumbai
07.2015 - Current
- Developed centralized data solution to consolidate endpoint inventory data from multiple sources using Azure Data Factory
- Designed and implemented data ingestion workflows to extract data from various endpoint management systems and load it into Azure Data Lake Storage
- Utilized Azure Databricks and PySpark to perform data cleansing, deduplication, and normalization
- Created unified endpoint inventory schema and transformed data to conform to standard format
- Enabled accurate and up-to-date visibility into organization's endpoint landscape, facilitating better asset management and security practices.
- Established robust monitoring processes to proactively detect system anomalies or performance bottlenecks before they impact users or critical operations
- Provided technical guidance and mentorship to junior team members, fostering a collaborative learning environment within the organization
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design
- Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in a timely manner
- Managed cloud-based infrastructure to ensure optimal performance, security, and cost-efficiency of the company''s data platform
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks
- Implemented real-time data processing solutions for timely decision-making and improved customer experience
- .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability
- Collaborated with system architects, design analysts and others to understand business and industry requirements
- Developed and delivered business information solutions
ETL Tester
Persistent Systems
11.2020 - 05.2021
- Performed comprehensive testing of ETL processes to ensure data accuracy and completeness
- Developed and executed test cases and test scripts for data validation
- Collaborated with development teams to identify and resolve data discrepancies
- Conducted data migration testing to validate successful transfer of data between systems
- Documented test results and reported issues to stakeholders.
- Supported business intelligence efforts through careful analysis of ETL-related metrics and trends
- Maintained high-quality documentation of test plans, scripts, and defects to facilitate knowledge sharing among team members
- Elevated team performance by providing mentorship and guidance on best practices in ETL testing methodologies
- Maximized system reliability through diligent verification of error handling capabilities within various modules
- Streamlined testing process by developing reusable SQL queries for various ETL components
- Validated data accuracy through comprehensive testing of source-to-target mappings and transformations
- Collaborated closely with development teams to ensure seamless integration of ETL components, resulting in accurate and efficient data processing
- Enhanced data quality by identifying and resolving ETL-related issues in a timely manner
- Authored and maintained well-organized, efficient and successful manual test cases for entire team
- Kept scripts and test cases updated with current requirements
- Safeguarded against incorrect calculations or aggregations in reports through meticulous validation of cube processing functions
- Performed thorough testing on data integration projects to ensure accurate results
- Contributed to successful project outcomes by effectively communicating test results and recommendations to stakeholders
- Boosted project efficiency by collaborating with cross-functional teams to define test cases and test plans
Manual Tester
Persistent Systems
- 01.2018
- Handled team of three members
- Responsible for assigning task and monitoring work progress on project
- Collaborated with business analyst to clarify application requirements
- Participated in test scenario, test case, traceability matrix preparation, test cycle execution, and defect tracking activity
- Involved in test case review activity
- Test status report creation, defect metrics collection, test estimation preparation for owned modules
- Handled release delivery
- Involved in knowledge transfer process for new members
- Conducted trainings for new joiners and groomed fresher resources on process and technical aspects
- Involved in interviewing recruit for project.
- Maintained accurate documentation of all discovered bugs, ensuring efficient tracking and resolution throughout the development lifecycle
- Improved software quality by meticulously executing manual test cases and identifying defects
- Optimized test coverage through continuous collaboration with stakeholders, refining requirements and addressing any gaps in specifications
- Facilitated smooth releases by coordinating closely with cross-functional teams for end-to-end integration testing
- Reduced defect leakage by rigorously analyzing requirements and creating comprehensive test plans
- Increased overall reliability of the product through diligent smoke testing during every build cycle
- Contributed to higher customer satisfaction rates by consistently meeting project deadlines and adhering to quality standards
- Promoted knowledge sharing among team members, conducting training sessions on new tools and techniques for manual testing
- Ensured seamless user experience by validating application functionality across multiple platforms and devices
- Boosted efficiency of the testing process by organizing test cases in a prioritized, easy-to-follow manner
- Proactively identified opportunities for test automation, working with the development team to implement scripts that accelerated testing efforts
- Streamlined communication between QA and development teams, implementing a standardized bug reporting process that expedited issue resolution
- Supported developers in debugging efforts, providing clear reproduction steps and logs for identified defects
- Collaborated with development team to diagnose and resolve software issues in a timely manner
- Executed test scripts, logged defects and worked to resolve issues noted in testing process
- Worked extended hours when necessary to meet deadlines
Manual and Data Migration Tester
Tata Consultancy Services
08.2010 - 11.2013
- Handled team of five members
- Responsible for assigning task and monitoring work progress on project
- Collaborated with business analyst to clarify application requirements
- Participated in test scenario, test case, traceability matrix preparation, test cycle execution, and defect tracking activity
- Involved in test case review activity
- Involved in data migration testing
- Creating test cases by studying mapping document
- Understanding data models
- Involved in writing and execution of SQL queries to validate source and target tables
- Validating table structure in source and target
- Validating constraints, null values, data duplication
- Involved in regression testing
- Validated reports generated using Spotfire tool
- Executing and debugging SQL queries to validate data in generated report
- Test status report creation, defect metrics collection, test estimation preparation for owned modules
- Handled release delivery
- Involved in knowledge transfer process for new members
- Conducted trainings for new joiners and groomed fresher resources on process and technical aspects
- Involved in interviewing recruit for project.
- Facilitated knowledge sharing within the team through regular presentations on new tools, techniques, and best practices in software testing
- Managed defect tracking systems effectively, ensuring timely resolution of reported issues while maintaining accurate documentation records
- Wrote and executed effective functional tests and carried out exploratory testing to assess product performance
- Mentored junior team members efficiently to generate best output
Software Test Engineer
CGI
11.2007 - 12.2009
- Project mainly based on General Insurance such as Home and Car insurance
- Involved in modules such as Underwriting, Accounts, Management, and Claims
- Role: Manual Tester
- Responsibilities: Understanding software requirement specifications
- Understanding General Insurance terminologies
- Preparing test cases
- Execution of test cases (manual)
- Defect logging and tracking with Test Director Tool
- Regression testing, retesting, system and system integration testing.
- Improved software quality by designing and executing comprehensive test plans and cases
- Identified critical bugs and worked closely with developers to ensure timely resolution, resulting in a more stable product
- Participated in post-release reviews to analyze lessons learned from completed projects, driving process improvements for future endeavors
- Managed defect tracking systems, ensuring accurate documentation of issues for efficient resolution
- Conducted regression testing, analyzed results, and submitted observations to development team
- Authored and maintained well-organized, efficient and successful manual test cases for entire team
- Monitored resolution of bugs, tested fixes, and helped developers tackle ongoing problems by providing QA perspective
- Tested functional and compatibility of new programs or updates in comparison to existing applications
Education
Bachelor of Engineering - Computer Engineering
A.C.Patil College Of Engineering
Kharghar 01.2002 - 04.2006
12th - Science Education
S.H. Jondhale
Dombivli 06.2002 - 06.2002
10th -
Swami Vivekanand Ranapratap Bhuvan
Dombivli 06.1999 - 06.2000
Skills
Basic Python
SQL(Simple to Medium)
Top Team
Azure Data Factory
Azure Databricks
PySpark
Performance Tuning
Data Warehousing
Data Migration
Big Data Processing
Data Quality Assurance
Spark Framework
SQL Expertise
Data Pipeline Design
RDBMS
Problem-Solving
Data Mining
Firmware Testing
Software Development Tools: JIRA, Confluence
Test Plans and Test Methodologies
Scenarios and Use Cases
Team Mentoring
Manual test case preparation
Software Documentation Reviews
Bug Tracking and Resolution
Certification
Aws Cloud Practitioner and Azure Fundamental(AZ-900)
Timeline
ETL Tester
Persistent Systems
11.2020 - 05.2021
Data Engineer
Persistent Systems
07.2015 - Current
Manual and Data Migration Tester
Tata Consultancy Services
08.2010 - 11.2013
Software Test Engineer
CGI
11.2007 - 12.2009
12th - Science Education
S.H. Jondhale
06.2002 - 06.2002
Bachelor of Engineering - Computer Engineering
A.C.Patil College Of Engineering
01.2002 - 04.2006
10th -
Swami Vivekanand Ranapratap Bhuvan
06.1999 - 06.2000
Manual Tester
Persistent Systems
- 01.2018
Accomplishments
- Bravo Award for showcasing excellent technical and business skills
- Awarded “Star Team” for on-time deliverables with zero-escalation
- Kudos Award for excellent Team Player
AWS Cloud Certifications, ISTQB Foundation level certified
I have completed AWS cloud practitioner certifications to demonstrate practitioner level knowledge.
ISTQB Foundation certification have done to demonstrate testing knowledge.