💼 ETL Tester | Business Analyst | Python & SQL Developer | Stock Market Enthusiast
I’m a data-driven professional with 4+ years of experience in ETL Testing and 3+ years as a Business Analyst, specializing in validating complex data pipelines, optimizing data accuracy, and translating business requirements into actionable insights.
I have designed and developed Python-based automation frameworks for File-to-Database and Database-to-Database validation, enabling seamless ETL verification through automated SQL query execution and result comparison. These frameworks generate detailed test reports, significantly reducing manual effort and improving efficiency.
With 8+ years of experience as a stock market trader and investor, I bring a strong analytical mindset, pattern recognition ability, and data interpretation skills that enhance my problem-solving and decision-making approach in every project.
| Category | Tools / Skills |
|---|---|
| Languages | Python, SQL, DAX |
| Databases | SQL Server (SSMS), MySQL |
| ETL Tools | Talend, SSIS |
| Testing Tools | TestRail, JIRA, Confluence |
| Data Visualization | Power BI, Excel |
| Libraries | Pandas, NumPy, OpenPyXL, Matplotlib, pyodbc |
| Other Skills | Data Validation, Data Comparison, Regression Testing, Business Analysis, Automation Frameworks |
| Project | Description | Tech Stack |
|---|---|---|
| 🔍 File-to-DB & DB-to-DB Validation Automation | Automated validation framework that compares data between files and SQL Server databases, generating detailed pass/fail reports. | Python, SQL, Pandas, pyodbc |
| ⚙️ Python Automation Scripts | Automated Excel and CSV validation tasks with report generation | Python, Pandas, OpenPyXL |
| 📊 Power BI Dashboard | Interactive Power BI dashboard providing sales and performance insights | Power BI, SQL |
| 🧪 ETL Testing Suite | End-to-end data validation, count checks, and transformation verifications | Python, SQL |
| 💹 Stock Market Analyzer | Analyzes stock data and estimates profit/loss using Vedic Math-based logic | Python, yfinance |
✅ 4+ years of ETL Testing experience across major clients — NYC Public Schools, Fifth Third Bank, Dominos, Thermo Fisher, Centene, USAA, Pluto TV, Credit Acceptance
✅ Designed Python automation frameworks for File-to-DB and DB-to-DB validation
✅ Strong SQL expertise in data validation, duplicate checks, and transformation rule testing
✅ 3+ years as a Business Analyst — experience in requirements gathering, stakeholder discussions, and report building
✅ 8+ years as a Stock Market Trader — strong data interpretation, pattern analysis, and decision-making skills
✅ Experienced in Power BI dashboards and Excel data automation
- Advanced Python for data validation and automation
- Power BI storytelling dashboards
- Machine Learning fundamentals for QA and analytics
📧 Email: pramodb630@gmail.com
🔗 LinkedIn: https://www.linkedin.com/feed/
💻 GitHub: https://github.com/Pramodb630
⭐ "Data is only as powerful as the insights you extract and the actions you take from it."