Highlights:

Skills:ETL QA Lead, BSA, ETL QA

Data Analyst, ETL QA Lead, BSA 04/2018 - current
Tata Consultancy Services, , United States
IFRS9, USGAAP and FAS91 Implementation for Toyota Financial Services
Data Analyst responsibilities: • Gathered, cleaned, and preprocessed data from various sources, ensuring accuracy and consistency for analysis. • Conducted in-depth analysis to identify trends, correlations, and actionable insights to support business strategies. • Created detailed reports using SAP BO and Excel to present findings to stakeholders. • Designed and optimized complex SQL queries to extract, manipulate, and validate data from relational databases. • Partnered with cross-functional teams to define data requirements and align analytical outputs with business objectives. • Identify inefficiencies, workflows, proposed solutions, and implemented process improvements to enhance data accuracy and timeliness. ETL QA Lead Responsibilities: • Designed and executed QA strategies for ETL processes, ensuring seamless data flow across multiple systems. • Conducted data quality checks and performance tuning of ETL workflows which improved efficiency significantly. • Used Excel VBA and formulae to replicate IFRS9, USGAAP, and FAS91 instrument-level calculations to validate application results. • Automated regression testing for ETL pipelines using SQL scripts. • Collaborated with development teams to identify and resolve data discrepancies during migration projects. BSA Responsibilities: • Gathered and analyzed business requirements, translating them into technical documentation and functional specifications. • Conducted feasibility studies and gap analysis for system enhancements and upgrades. • Liaised between stakeholders and IT teams to ensure project deliverables met business objectives. • Designed and delivered customized reports and dashboards using SAP BusinessObjects to support decision-making. Key Achievements_____________________________________________________________ • Spearheaded the successful delivery of IFRS9 and FAS91 projects across multiple business lines, ensuring 100% compliance with regulatory deadlines. • Automated QA processes for large-scale ETL pipelines, reducing testing time by 30% and enhancing system reliability. • Streamlined data validation workflows, improving the accuracy of financial data by eliminating recurring discrepancies. • Designed dashboards that reduced reporting time for stakeholders by 25%, enabling faster decision-making--
QA Lead 02/2016 - 04/2018
Tata Consultancy Services, , India
Website and mobile app developments for Toyota Financial Services
Key Responsibilities_____________________________________________________________ • Estimating budget for testing and preparing milestones. • Attend daily standups and other scrum ceremonies, attend meetings with different stakeholders to identify challenges, risks, and requirement gaps, and come up with mitigation plans. • Identify testing scope and accordingly select necessary resources. • Devise test plan, prepare test strategy, test coverage matrix, schedule, and document testing artifacts. • Create test cases and perform smoke testing, SIT, UAT, End-to-end, and regression testing. • Tracking bugs and attending defect triage calls. • Highlight potential risks and come up with mitigation plans. • Guide and lead the QA team and act as an onsite coordinator. • Facilitate UAT and prepare acceptance report. • Obtain signoffs from business. Skills_________________________________________________________________________ QA Tools: HPQC, Jira, Selenium Programming: Java--
QA Tester 03/2013 - 02/2016
Tata Consultancy Services, , India
Project: Credit Card CRM application – Citigroup Inc.
Responsibilities: • Devise test plan, prepare test strategy, test coverage matrix, schedule, and document testing artifacts. • Create test cases and perform smoke testing, SIT, UAT, End-to-end, and regression testing. • Tracking bugs using HPQC. • Provide UAT support Skills_________________________________________________________________________ QA Tools: HPQC, Jira--

West Bengal University Of Technology 08/2008 - 07/2012
, , India
Degree: Bachelor's Degree
Major:Electronics & Instrumentation Engineering
I have obtained B.Tech degree with GPA of 6.97

Login to view resume: Resume_Keshab Majumder - ETL QA