Might be available
(Updated 2020-03-13)Data Architect Exp in TDM & ETL Dev/Test
Stockholm, Sweden
Native English, Beginner Svenska
- Test Data Management
- DWH-BI
- QA Testing
Skills (10)
IBM Tools
Selenium
ETL Testing
Automation Testing
Informatica
DWH-BI
ETL Developement
Test Data Management
Python
Jenkins
Summary
My name is Durga Vavileti, I’m writing this cover letter for applying job roles that suits my profile. I have a Bachelor of Technology graduation degree and 11+ years of experience in IT. My Expertise are in DWH-BI, Test Data Management, Manual and Automation Testing of cost-effective solutions.
I am a social and amicable person. I am confident, I will be able to live up to the expectations of the organisation and collaborate with stakeholders in a professional way. I inspire them to let me in, Gain trust and apply my experience and analytical abilities to bring out the visualisation that management is exactly looking for, to build cost effective solutions, improve the ways that we could monetise without compromising any existing systems and already successful methodologies.
Short Summary about my Achievements:
Supervise end to end implementation of DWH-BI and Test solutions for business.
Facilitate ROI on implemented solutions in estimated timelines.
Mentor team on best practices, troubleshooting techniques, methodologies and tools.
Develop efficient ETL, Test Data and BI jobs of DWH-BI solutions.
Develop and test automation frameworks that reduce manual test processes.
Identify defects in testing phase and take ownership to direct the defects to closure.
Drive improvements in CI/CD of processes.
Optimize IT resources from 25% to 14% utilization by developing efficient solutions.
Streamline test processes to fix bottlenecks and deadlock situations.
Formulate masking solutions in compliance with regulations like GDPR, SOX.
I hope you found this interesting and that I can get an opportunity to present myself personally. Thank you!
Best Regards,
Durga Vavileti
Professional Experience
2017-12 - 2019-07
Lead team of developers and testers; prepare estimate efforts require, delegate tasks and guide team during various phases for timely completion of tasks.
Conduct daily scrum meetings and take necessary actions based on burn downs.
Develop ETL jobs using informatica and BI reports using power BI as per requirement.
Develop automation framework for business requirement using selenium, python, etc.
Add or modify the existing automation test cases based on business requirement.
Prepare test data and load data into development and test environments.
Perform functional testing, performance testing and UI testing for web applications.
Perform regression testing to ensure the stability of application before release of enhancement or changes using selenium test automation.
Perform user acceptance testing; executing selenium test cases.
Capture defects in Jira and work with developer to close the open defects.
2015-12 - 2017-11
Drive PoCs for use cases and evaluate best possible DWH/BI, TDM and Test solutions.
Evaluate various tools such as informatica, power BI, etc. from integrity, scalability, performance standpoint for proposed solutions.
Plan, design, estimate and develop technical solutions using DWH/BI & TDM tools.
Develop automation framework as per business requirement using selenium, python, etc.
Implement, test & monitor quality and usability of technical solutions.
Perform user acceptance testing, integration testing and regression testing for DWH/BI reporting jobs.
Prepare test data using informatica and load data into development and test environments.
2015-03 - 2015-09
Analyse the business requirement, prepare detail design and unit test plans.
Develop ETL and BI jobs and perform unit testing on developed jobs.
Develop reusable test data jobs that minimises manual efforts.
Perform performance testing using JMeter for web applications.
Perform peer reviews and assist team members in troubleshooting and fixing the issues.
Involve in technical review meeting with clients and various cross functional teams.
Automate manual ETL processes by developing reusable SQL scripts and ETL jobs.
2013-11 - 2015-04
Lead team; prioritizing tasks, delegate tasks and assist team till final delivery.
Organize team meeting, efficiently manage time & resources, document MoM, delegate and monitor action items till closure.
Document the technical challenges, troubleshooting approach, work arounds implemented and review with team after each release.
Prepare project status report and participate in weekly and monthly status report meeting with stakeholders and management.
2012-01 - 2013-11
Develop reusable ETL jobs using informatica that minimizes manual efforts and provide high quality data to end users.
Prepare test data strategy, data retention plan, test data implementation plan.
Develop reusable sub-setting jobs using informatica, IBM optim tools that minimizes manual efforts and provide mask test and master data to end users.
Prepare test case and execute test case in ALM
Automate manual test process by developing reusable SQL scripts.
Capture defects in ALM and work with stakeholders in closing the defect.
Perform unit testing to validate usability of ETL jobs.
Perform UAT testing to validate transformation logic in ETL and reporting jobs.
Perform back up of test data with DBAs.
2009-10 - 2011-12
Prepare test scenarios, test plan and test case as per testing requirement and execute test cases in Quality Center.
Perform system testing, system integration testing using ETL, SQL scripts.
Perform validations like source to DWH/MDM targets, ETL informatica transformation rules, constraints check of the applications.
Perform peer reviews and assist team members in troubleshooting and fixing the defects.
2007-10 - 2009-05
Prepare detail design document as per business requirement.
Develop ETL jobs using informatica to extract data from various sources, transform the data using various transformations and load to target.
Perform unit testing, identify, fix and revalidate the issues.
Prepare resource traceability matrix for ETL jobs to deploy in test environments.
Academic Background
2000-12 - 2005-12