Shivam Vazare
Nashik
Summary
Versatile and results-driven professional with a robust background in ETL testing and data analysis at INCIF Technologies Pvt Ltd. Excelled in leveraging AWS services and SQL querying to enhance data integrity and operational efficiency. Demonstrated leadership in guiding teams towards achieving project milestones while fostering an environment of quality assurance and innovative problem-solving.
Overview
4
4
years of professional experience
1
1
Certification
Work History
ETL TESTER
INCIF TECHNOLOGIES PVT LTD
06.2023 - Current
- Generated inventory reports to monitor stock levels and operations
- Verified data accuracy concerning specific date ranges
- Made data modifications based on provided information
- Conducted data comparisons to ensure consistency and accuracy
- Detected and resolved data leakage using SQL queries
- Ensured the maintenance and integrity of inventory data
- Studied requirement specifications and designed modules for testing
- Designed and executed test cases, registered defects in Zephyr, and validated project functionality
- Extensively performed system testing and regression testing
- Prepared defect status reports, bug summary reports, and release notes
- Analyzed functional specifications (FSD), created test cases, and executed them
- Performed incremental testing, GUI testing, functional testing, and regression testing for defects
- Conducted record count checks from intermediate tables to target systems
- Validated key field data for missing or null values and ensured accurate aggregate values in fact tables
- Verified modeling views and checked BI reports against loaded fact and dimension tables
- Reported defects and tracked resolutions using Zephyr
Associate Consultant (DS)
Capgemini Technology Services India limited
07.2021 - 05.2023
- The project focused on enhancing customer insights for automotive brands such as Mokka, Citroën, Opel, Peugeot, and DS Automobiles
- Utilizing AWS Cloud Computing services, we developed a scalable pipeline to handle millions of customer data points
- This included leveraging AWS RDS DB, SQL Server, S3 Buckets, SageMaker for model building, and EC2 for scalable computation
- The pipeline processed large volumes of data to predict customer trends, offering actionable insights into purchasing behavior and preferences
- Led a team of two junior members, ensuring task distribution and timely delivery of project milestones
- Built and optimized an end-to-end data pipeline for ingesting, cleaning, and processing millions of customer records
- Employed AWS SageMaker to develop machine learning models for trend predictions and actionable insights
- Utilized SQL Server and RDS for managing and querying structured data efficiently
- Performed data validation and transformations to ensure consistency and integrity in large datasets
- Ensured seamless integration of data through S3 Buckets and optimized computational performance with EC2 instances
- Designed dashboards and reports for stakeholders to visualize customer trends and insights
- Collaborated with cross-functional teams to understand business requirements and align data models with organizational goals
Education
Post Graduation - Artificial Intelligence And Machine Learning
University Of Texas At Austin
Mccomb Business School12-2023
B.E. -
PREC, Loni
Pune University07-2019
Diploma -
Sandip Polytechnic
Nashik07-2016
Skills
- Data validation
- SQL querying
- Test case design
- Regression testing
- Data integrity
- Report generation
- AWS services
- Quality assurance
- Problem solving
- Team leadership
- Defect tracking
- Software functionality feedback
- ETL modeling
- QA reporting
- Software compatibility testing
- Software development life cycle
- Bug reporting
- Test strategy
- Project management
- Usability testing
- 3D modeling
- CAD design
Professional Work Experience
Overall 3+ years of experience in software testing, manual testing on web-based, Client/Server including database testing, web service testing, data warehousing-DWH/ETL.
Windows 95/98/2000/NT/XP
UNIX, HPALM, JIRA, Zephyr
Oracle 9i/10g/11g, SQL Server 2005/2008,
Tableau, SSIS Package, SQL Developer
Hadoop
Certification
- Python Programming By Great Learning 2023
- Google Cloud Data And Machine Learning Fundamentals Domain Foundation By Automation Academy
- Power BI By Automation Academy Foundation Level Certification
- AWS Cloud Practitioner Essentials
- ISTQB Foundation Level 1 Certificated
- Introduction To Cyber-Security
Accomplishments
- Rewarded with Best Performer from Capgemini Technologies ,Pune
Disclaimer
I hereby declare that the above-mentioned information is correct to the best of my knowledge., 02/26/25, Nashik
Timeline
ETL TESTER
INCIF TECHNOLOGIES PVT LTD
06.2023 - Current
Associate Consultant (DS)
Capgemini Technology Services India limited
07.2021 - 05.2023
Post Graduation - Artificial Intelligence And Machine Learning
University Of Texas At Austin
B.E. -
PREC, Loni
Diploma -
Sandip Polytechnic
Similar Profiles
Venkata Nagaraju InakolluVenkata Nagaraju Inakollu
Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)
S ChetanS Chetan
Assistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt LtdAssistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt Ltd
Shweta SinghShweta Singh
Support Engineer-IT at I-Telemetry Technologies Pvt. Ltd. (Subsidiary of Aaxis Nano Technologies Pvt. Ltd.)Support Engineer-IT at I-Telemetry Technologies Pvt. Ltd. (Subsidiary of Aaxis Nano Technologies Pvt. Ltd.)
RAJU VISHWAKARMARAJU VISHWAKARMA
Lead Proposal Engineer at EMERSON EXPORT ENGG CENTRELead Proposal Engineer at EMERSON EXPORT ENGG CENTRE
Mansi BurhadeMansi Burhade
Educator at Gurukul FoundationEducator at Gurukul Foundation