Test Cases Data
Resume:
Flat: **, Yashraj Appt,
Kadam Plaza, Katraj, Pune-411046
Email id: acr7an@r.postjobfree.com
Cell: 917*********
Salil K.Agarwal
Profile
Extensive Knowledge in the Architectural Design and Software Development Life Cycle (SDLC) and Software Testing Life Cycle applications.
Extensive Knowledge in Data Warehousing Concepts
Having good experience in Star Schema and Snowflake Schema
Having experience in Preparing Test Plan, Test Scenarios, Test cases, Test Execution and documenting the Test results.
Hands on experience Regression Testing, Re-Testing, Smoke Testing and Sanity Testing
Worked with multiple databases like Oracle, Teradata, Netezza
Skill Set
ETL Tools: Datastage 8.7, Cognos 10.2
RDBMS: Oracle 11g, Teradata 14.0
Languages: Oracle SQL, PL/SQL, Visual Basic
O/S: Windows XP/2007, UNIX AIX
Defect Management: Clear Quest,
Test Management: RQM
Education:
Master’s in Computer Applications -2008, Allahabad Agriculture University, India,
Master in Business Administration – 2014, Maharashtra Institute of Technology
Diploma in Advance Computing (DAC) 2002, CDAC ACTS, Hyderabad
Bachelors in Commerce –1998, Allahabad University
Professional Experience
May 2011 – Till date, Test Specialist-Data IBM India Pvt. Ltd. India
Sound Knowledge on various ETL tools viz. (Datastage & Oracle Warehouse Builder[OWB]).
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad).
• Strong hands on experience in Oracle SQL & PL/SQL.
• Well versed in writing UNIX shell scripts.
Conducted and actively participated in reviews, walkthroughs of test cases.
Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Datastage.
• Experience in using Oracle Databases, Teradata.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Expertise in extended validation of report functionality developed, using Cognos, Business Objects, by writing complex SQLs at the backend.
• Good concept of ETL, Warehouse and BI applications integration.
• Good experience in working with onsite-offshore team model projects.
• 5+ years with SQL/PL-SQL and expertise in writing complex SQL Queries.
• Work extensively with slowly changing Dimensions & Audit Tables
• Experienced SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle
Environment: Datastage 8.7, Teradata 15.0, Cognos 10.2
Team Size : 7 to 8
March 2010 – May 2011, Technical Associates Tech Mahindra,Mumbai,India
Tech Mahindra Ltd is a CMM 5 Level Telecom Service Provider. My role is as follows:
Worked on Etisalat Project as BI Team Member on Telecom Domain
Extensively used Datastage to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata
• Executing and monitoring jobs through Control-M.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Preventing occurrences of multiple runs by flagging processed dates
• Reviewed Datastage mappings and test cases before delivering to Client
• Written Test Cases for ETL to compare Source and Target database systems.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Datastage and provide technical support and hands-on mentoring in the use of Datastage for testing.
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Ensured that the mappings are correct and conducted data validation testing
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance .
• Extraction of test data from tables and loading of data into SQL tables.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system
• Executed the Test cases for BO and Cognos.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Prepared the test cases after thorough analysis of each requirement.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Conducted and actively participated in reviews, walkthroughs of test cases.
• Reviewed the ETL mappings (Datastage) to ensure the transformation rules are applied correctly.
• Executed the workflows in the workflow manager, to start the ETL process.
• Created and executed SQL queries to perform source to target testing on DB2 database. Performed the following tests:
o DATA COMPLETENESS
o VALIDITY
o UNIQUENESS
o DATA INTEGRITY
o DATA TRANSFORMATION
o DATA QUALITY
o INITIAL AND INCREMENTAL LOAD TESTS
Environment: Datastage 8.7, Oracle 11g, Cognos 10.2
Team size: 8 to 10 member
Feb 2006 – Mar 2010, Technical Associates Reliance Infostreams Pvt Ltd
Responsibility: My responsibilities are performing User Acceptance Testing (UAT) of the clarify tools, Write Functional Test case, Review Functional Test cases prepared by Other Team Members, Execute Test Cases.
Amdocs Clarify 13.1, Clarify Thin Client, BMC Remedy AR System 7.0., Defect Management tools Rational Clear Quest and Rational Clear Case and Single-eView,iCare, UCS, Verify, (Reliance Domestic product)
Good knowledge on Reliance CDMA and GSM product, Tariff Plan, Erecharge and billing system.
Good knowledge about CAFs (postpaid and Prepaid both), Service Tariff Plan, R-Connect plans, R-World plans, Roaming plans, Promotions, Handset Schemes, Handsets, Channel Partners, Activation Process of CDMA and GSM both, All View or Service MACD from Service Creation to Termination.
Have developed an expertise in the " Telecom Customer Life Cycle Management" other related Service Delivery aspects, Order management, Project of Wireless CDMA, GSM, 3G, VAS & Data.
Having good knowledge of end-2-end testing in OSS / BSS, expertise in manual testing, test plan preparation, test data preparation, test case creation, review of test result, sanity, system testing, system integration testing, UAT support, good analysis of BRS, SRS, TDS documents and well versed on defect management, traceability matrix and test execution report etc.
Ensuring accurate and timely loading and inserting CDRs in the database for the complete prepaid
customer base (including mobile services, fixed line services, PCO etc) of the company for CDMA services
Environment: Clarify 13.1, Oracle 10g
References: Available upon request
Contact this candidate