Pratap Singh Email & Phone Number

India

Pune, Maharashtra, India

QA Manager - Data Sourcing Hub - Chief Data Office. Responsible for QA delivery of quarterly data sourcing releases. Application platform (ETL) is based on Hadoop Ecosystem including Oozie, Swoop, Flume, Hive and Hue.

Pune Area, India

Working as an Analyst for RefData testing. Involved in testing of Asset Control - An internal system that acts as a strategic repository within Barclays Capital for static and time series data. Data is available on the full range of asset classes - that is fixed income, rates, equities, commodities, and FX.

Gurgaon, India

Worked on a key strategic initiative targeted at providing an integrated SOA based all-in-one platform (Galaxy) to the Portfolio (Fund) managers and their support group to manage and monitor Mutual fund investments and take intelligent investments decisions based on the integrated research data and other embedded features.Also worked on FODE (Front Office Data Environment), another key initiative to provide a centralized data repository containing data for all asset classes along with RefData which can be used by a host of applications by just hooking to the FODE Data Access Layer.Handled responsibility of building a forum to establish the strong foundation for data testing principles and bring awareness about this dimension of testing across organization. As a lead of Data Forum Committee in Fidelity, the objective was to set up a platform to discover issues and complexities involved in Data testing and discuss about the resolutions for the same. Additionally discuss and draw an approach to the solutions that are robust, automated and generic enough to implement them across projects with minimal modifications required.As a regular project member lead data testing related activities including Test Strategy, Test Plan, Execution and other critical aspects of Data Testing.Developed automated solutions to automate various manual and error prone tasks like True Copy data validation, data transformation testing, re-conciliation.

Gurgaon, India

Worked as a Senior Test Analyst on complex DWH project with RBS. It involved testing the end to end flow of data from versatile sources of data to Analytical layer based on Star Schema DWH modelling. The DWH was build on Oracle Server and other techologies involved were Information Power Center, Oracle DWH, UNIX, OFSA, OBIEE and BOXI.Performed Equivalence Testing for a Data Migration projcet involving migration of huge amount of Bank data on Credit Risk and RWA to a new techology stack. Automated the testing process to reduce time and effort.Developed Test Plan, Strategy and Estimation matrices for the project and lead these activities till delivery.Performed as a Subject Matter Expert on Credit Risk Measures, RWA calculations, Functional aspects of IRB approach under BASEL 2 and their implementation in Risk Engine developed by client.Created Automation Tools like DB Comparison Utility, ETL SQL Execution Automation, SQL Scripts and Test cases generation tool and other utilities using Perl and Shell Scripting.Provided Support to BAs in chalking out the Use Cases and UAT scenarios for business stake holders across various divisions of RBS.

Be (Ece), Electronics And Telecommunication

Education record