Sanjay Sahu

Experience

• 

  Ami industries

  Oct 2002 - Jan 2005

  Technical Consultant

  User Requirement collection, Development and Testing in using Visual Basic and crystal reports for Payroll Accounting and System Administration Implementation with Oracle Apps 11i (HR and GL module)

• 

  DataVision Software Solutions Pvt. Ltd

  Jan 2005 - Aug 2005

  VB Programmer

  Senior Programmer in Development.Developed and tested new component using Visual Basic and crystal reports

• 

  BMC Software

  Sept 2005 - Mar 2011

  Develop new features and enhancements, find and fix the bugs reported by customers and QA and perform tests for the product Develop new features and enhancements, find and fix the bugs reported by customers and QA and perform tests for the product

  • Staff Product Developer

    Jul 2008 - Mar 2011

  • Product Developer

    Sept 2005 - Jun 2008
• 

  IBM Global Business Services

  Mar 2011 - Mar 2022

  Advisory System Analyst

  • Currently working as Test Lead in ETL /Corporate Analytical Warehouse/ HDS/ Data Mart Testing for Nationwide Building Society.• Exposure to Banking and Financial Domain and Data Warehousing- ETL Testing concepts• Good knowledge in testing Facts and Dimensions Based on mapping logic• Involved in requirements gathering, documentation, review, analysis, test plan creation, preparation, execution and reporting.Responsibilities:•Leading test team.•Involved in functional study of the application•Running the Jobs/Workflow for ETL process•Prepared and executing sql queries to verify Dimensional and Fact tables.•Verifying the data in target database after ETL process.•Performed column data mapping between source & target database.•Verifying the data which is loaded into target database•Interactions with BA & Dev teams to resolve the issues.•Reporting daily testing status report•Developed, Reviewed & Executed Test Scripts and Designed test data•Identified Test Scripts for Regression testing•Defect Analyzing and Reporting in ALM. Show less

• 

  IBM UK

  Feb 2017 - Mar 2018

  Advisory System Analyst

  Currently working for the IMAS CIS Data Provisioning Project for Nationwide, Swindon.Roles & Responsibilities includes:- Performing requirement analysis and identifying the gaps between functional mapping and detailed business requirements- Preparing the Master Test Plan, Test Briefing Pack, Test Commitment Document- Preparing stage 0, stage 1, stage 2 and stage 3 test estimates using GTEF and taking to TERB approval - Cordinating with Functional and Non-Functional Test Teams, Test Assurance SME's- Reporting weekly status reports to the PM and stakeholders- Engagement of Automation, Data Provisioning Team and Transformation Levers- Preparing Live Data Exception pack and approval from G-Sec Team- Leading System Integration Team- Performing Defect Management- Leading test team at Offshore Show less

• 

  Nationwide Building Society

  Mar 2022 - now

  Data Engineer