Testing Developer

PRAVEENKUMAR DR

EMAIL – *******.****@*****.*** PHONE – 614-***-****

EXECUTIVE SUMMARY

EXPERIENCED TLM DEVELOPER/ ETL TESTER WITH 4+ YEARS OF EXPERIENCE IN IT INDUSTRY

PERTAINING TO INVESTMENT BANKING, BANKING AND FINANCE DOMAINS COUPLED WITH AN EXTENSIVE

UNDERSTANDING OF TESTING METHODOLOGIES

3+ YEARS OF EXPERIENCE IN TLM RECON WHICH INCLUDES REQUIREMENT ANALYSIS, CONFIGURATION,

TESTING AND SUPPORT THE PRODUCTION ENVIRONMENT

EXPERIENCE WORKING IN TLM CLIENTS SUCH AS RECON ADMIN, DESIGN STUDIO, SMART SCHEMA,

SMART STUDIO, WEB CONNECT, CONFIGURATION IMPORT/EXPORT.

1+ YEARS OF EXPERIENCE IN ETL MANUAL TESTING, BUSINESS OBJECTS REPORT TESTING, AXIOM

REGULATORY REPORT TESTING

EXPERIENCE IN DATABASE TESTING, WEB BASED TESTING, UNIX BASED TESTING, BO/BI REPORTS

TESTING, AXIOM TOOL TESTING

EFFICIENT IN BUILDING SHELL SCRIPTS, BUILDING COMPLEX SQL QUERIES

WORKED ON EXECUTION ON AUTOMATED REGRESSION SCRIPTS USING HP QTP

WORKED ON DIFFERENT TESTING PHASES LIKE SYSTEM, INTEGRATION, REGRESSION WHICH INCLUDES

PREPARING TEST SCENARIOS, EXECUTING THEM AND TRACKING DEFECTS TO CLOSURE

CORE COMPETENCIES

ETL TESTING TLM(TRANSACTION LIFECYCLE MANAGEMENT) DATABASE

TESTING

UNIX AXIOM REGULATORY REPORTING HP ALM

SQL/PLSQL WEB BASED TESTING TEST LEAD

PROFESSIONAL EXPERIENCE

ETL TEST LEAD SINCE JANUARY 2014

TATA CONSULTANCY SERVICES (CLIENT: JP MORGAN CHASE) COLUMBUS, OH

PROJECT HANDLED: LIQUIDITY PREMIUM, MIS, LRI TO IRR DEPOSIT EXTRACTS, OFSA RE-PLATFORM,

USRRE AXIOM

RESPONSIBILITIES:

ETL TESTING

PREPARATION OF TEST SCENARIOS AND TEST CASES BASED ON THE FUNCTIONAL REQUIREMENTS.

●

PREPARATION OF SQL QUERIES TO BE USED IN TESTING.

●

PREPARATION OF TEST DATA FOR VARIOUS TESTING SCENARIOS

●

EXECUTION OF ETL JOBS IN UNIX TO LOAD THE INBOUND FILES INTO DATA WAREHOUSE DATABASE.

●

MONITORING AND DEBUGGING THE ISSUES IN THE ETL JOBS THROUGH LOGS.

●

ATTENDANCE TRACKING AND AUDIT CHECK VALIDATIONS

●

VALIDATING THE MAPPINGS AND BUSINESS TRANSFORMATIONS AS PER FUNCTIONAL REQUIREMENTS USING

●

THE SQL QUERIES

GENERATION OF OUTBOUND EXTRACTS USING THE ETL JOBS AND TRANSMITTING THE EXTRACTS TO

●

DOWNSTREAM SYSTEMS USING SFTP.

GENERATION OF REPORTS USING VALID PARAMETERS IN BUSINESS OBJECTS.

●

VALIDATION OF THE REPORT FORMAT AND DATA DISPLAYED.

●

EXECUTION OF TEST CASES, LOGGING DEFECTS IN HP ALM 11 AND PERFORMING DEFECT TRIAGE.

●

AXIOM REGULATORY REPORTING ENGINE CONFIGURATION/TESTING

PREPARATION OF TEST SCENARIOS AND TEST CASES BASED ON THE FUNCTIONAL REQUIREMENTS.

●

EXECUTION OF ETL JOBS TO PERFORM SANITY CHECKS AND TRANSFER THE FILE TO AXIOM SERVER.

●

EXECUTING WORKFLOWS WITH VALID PARAMETERS TO LOAD THE INBOUND FILES INTO AXIOM SYSTEM

●

EXECUTING REPORT WORKFLOW TO GENERATE THE REGULATORY REPORTS AFTER PERFORMING BUSINESS

●

TRANSFORMATION

VALIDATION OF THE REPORTS AND OTHER REPORT FUNCTIONALITIES LIKE ADJUSTMENTS, COMMENTS, SIGN

●

OFFS, EDIT CHECKS.

VALIDATION OF OP MODEL AND SECURITY FOR USER AND USER GROUPS

●

TLM RECON DEVELOPER FROM NOV 2010 TO DEC 2013

TATA CONSULTANCY SERVICES (CLIENT: JP MORGAN CHASE) CHENNAI, INDIA

PROJECT HANDLED: IMPLEMENTATION OF CASH TRANSACTION AND POSITION RECONCILIATIONS TO TLM 2.7

RESPONSIBILITIES

PRE & POST PRODUCTION SUPPORT (CASH AND POSITION RECS)

RESOLVING PRODUCTION QUERIES- FILE LOADING, OI ISSUES. DASHBOARD QUERIES.

●

RESOLVING SIT AND UAT DEFECTS AND PREPARATION OF ROOT CAUSE ANALYSIS DOCUMENT.

●

DISCUSSION WITH BUSINESS USER ON REQUIREMENT AND DESIGNING THE TECHNICAL FLOW/DESIGN

●

DOCUMENT

FUTURE PROJECT, TESTING,

● RECONCILIATIONS DISCUSSION WITH THE BUSINESS ON DEVELOPMENT

UAT

DEPLOYMENT AND

CONFIGURING TLM SMART SCHEMA, KB, RECON ADMIN, DESIGN STUDIO, SMART STUDIO, CT

CREATING RULES, CONFIGURING RULES, EVENTS SUCH AS (EDIT, POPULATION, CREATE DATA,

●

INITIATION ETC) WORKFLOW, PASS QUALITY, SCOPE, POPULATION, DATA ENRICHMENT (REFERENCE

MASKING), GROUPING.

CONFIGURING SMART SCHEMA (CREATING CUSTOMIZED UNIVERSE, CREATING OBJECTS, ATTRIBUTE

●

CREATION, PROPERTIES CHECK, GROUPING OBJECTS) AND KB FILE PREPARATION.

CREATING CUSTOMIZED BLTS AND DASHBOARDS (INCLUDING CUSTOM CONTROL).

●

PREPARATION OF STATIC DATA TEMPLATE AND CONFIGURATION FILES (SYST SETTING) FOR CATEGORIES, SET

●

ID, MESSAGE FEEDS, CURRENCY AND STOCKS.

CONFIGURATION RELATED TO DATA LOADING: LOAD TRIG TABLE, STL FETCH AND SYST PARAMETERS

●

SETTING.

CONFIGURING AND MAINTAINING USERS AND ROLES IN DESIGN STUDIO, MODIFYING MESSAGE

●

MAINTENANCE AND ACCESS AND LIMITS.

BACKEND TASKS SYBASE AND UNIX

LOADING BUSINESS FILES (FEED FILE DATA, CURRENCY AND ASSET FILES) AND CHECKING APPROPRIATE

●

TABLES THROUGH BACK END. USING QUERIES AND APPENDING THE TABLES FROM BACK END.

AUTOMATING INITIATION USING PROCESS CONCEPTS AT THE BACKEND.

●

CREATING VIEWS (JOINING DIFFERENT TABLE IN THE BACKEND) AND CUSTOMIZED UNIVERSE IN SCHEMA TO

●

DESIGN ANY DASHBOARD AS PER BUSINESS REQUIREMENT.

SKILL SET

LANGUAGES: C++, UNIX SHELL SCRIPTING, PERL (FUNDAMENTALS), PLSQL

DATABASES: ORACLE, SYBASE

TOOLS: TLM (TRANSACTION LIFECYCLE MANAGEMENT), AXIOM REG REPORTING, TOAD,

SQL DEVELOPER, WINSCP, TORTOISE SVN, SHAREPOINT, MS VISIO

TESTING TOOLS: HP ALM 11, QTP 9.2

EDUCATION & TRAINING

BACHELOR OF ENGINEERING (B.E.) IN ELECTRICALS AND ELECTRONICS FROM VISHVESHWARAYA

●

TECHNOLOGICAL UNIVERSITY, KARNATAKA WITH 70% IN JUNE 2010.

TRAINED IN TLM RECONCILIATION 2.7 SUITE.

●

TRAINED IN AXIOM REGULATORY REPORTING TOOL (LEVEL 1).

●

DOMAIN TRAINING ON CAPITAL MARKETS, INVESTMENT BANKING, RECONCILIATION AND ELECTRONIC

●

TRADING.

Contact this candidate