SUMMARY:

• Over 12+ Years of experience as Test Architect /QA Analyst/Big data on Quality Assurance, Manual Testing, Automation Testing, System Testing with on Client/Server Application.
• Well experienced on Confidential Telecomm with Amdocs Billing and Telegence CSM
• Well Experience in Jenkins, Test NG, Junit with many projects and also build automation tools.
• Well working knowledge in portal testing, UAT and GUI Testing in many projects
• Experience in Portal testing with many Myatt front end projects
• Experience in Electromagnetic devices in my earlier projects.
• Working with AGILE Methodology API Validation successfully done in many projects.
• Well knowledge in SOA testing,QTP during prod validation for Automation projects.
• Well knowledge in WebSphere worked with many Projects
• Well experienced on Cassandra GUI GRID Testing (Telegence CSM) as Front end and Backend CCR - R DTI Validation
• Working knowledge of selenium web driver using object oriented API for web-app testing.
• Well experienced in Selenium testing using web driver and Salesforce
• Well experienced on Jmeter and load runner in various projects
• Well experienced on Angular JS as front end and worked with Oracle as backend.
• Well knowledge of ETL Bugs and ETL Mapping sheets
• Using dimensions capture the summarized data of ETL Testing
• Well working knowledge Cloud based technologies
• Well experience on People soft application and tested in many projects.
• Well experience in Device testing in various projects
• Experience in working Test driven Development and Acceptance Test Driven Development
• Well knowledge of VB Script, java and j2ee and API validate on java application
• Knowledge of python functions and script mode programming for software testing.
• Worked on python modules, dictionary, tuples and exceptions
• Experience and working knowledge on Oracle/web logic
• Well experience on Back end (big data) validation using Hadoop with hive queries and use HUE front end tool and validate mismatch records between UI application and Hadoop data
• Well working knowledge of Customer care and billing in many projects.
• Involved in Data staging validation, Map reduce validation and output validation phase.
• Well working knowledge for Tools JIRA, TFS, Rally, Testing methodology with Manual and functional testing and defect management and tracking and submit daily report weekly reports.
• Well experience on Test data management during functional and performance testing
• Discover and understand the test data, refresh data, extract production data helpful for test data management to resolve Issues.
• Develop and execute software test plans/test cases on Telegence CSM in order to identify software billing problems and their causes.
• Working experience on Test Data Management tools HP Quality Center, HPALM, Load Runner, Jmeter,QTP-UFT, Selenium, Selenium web driver
• Experience on review documentation of software defects and assign software developers to investigate and resolve the issue
• Experience on review and approve test schedules or strategies in accordance with project scope or delivery dates
• Experience on review software documentation to ensure technical accuracy, compliance or completeness or to mitigate risks
• Monitoring the daily production Decision Stream loads.
• Well Experience in Unica Campaign Experience in Confidential Projects

TECHNICAL SKILLS:

Database: UNIX, Oracle 7i/8i/9i/10g, Microsoft Access

Programming Languages: Teradata SQL Assistance, Visual Basic, Visual Basic .NET, MS SQL Server, Oracle SQL, PL/SQL Working Knowledge in Java, C, C++, FoxPro 2.0, COBOL 3.0 ASP.NET, VB.NET

Operating Systems: Windows 2000/2003/XP, Window 2003 Server, Unix, korn shell programming, Powershell, Bash

Tools: WebSphere, Oracle Enterprise Manager (OEM), Documentum, Import, Angular JS Export, Control-M, Clear Case, Share point, Knowledge link, Oracle Reports 4.5/5.0/6.0,Oracle Forms 6.0, SQL*Plus, SQL*Loader, Cognos7.3, Cognos BI8, Toad v8.6.1, MS Office 2007, QTP, Unica, soapUI PRO Campaigns, E-Commerce, HP ALM, Eclipse, CQLSH, SQL, Load runner, QC-ALM,salesforce

PROFESSIONAL EXPERIENCE:

Confidential, Dallas

QA Analyst/ test Architect

Responsibilities:

• Experience in Functional Testing, Regression Testing using QTP, Selenium web driver, ALM-QC, Eclipse, SVN and worked with AGILE Methodology in various projects.
• Well Experience in Jenkins, Test NG, Junit with many projects and also build automation tools with many frameworks
• Well working knowledge in portal testing, GUI Testing,salesforce in many projects
• Working with Agile methodology for API Validation successfully done in various projects
• Working experience in Dynamic Object Oriented Requirements System (DOORS)and QC ALM with good knowledge in QA/DHF documentation and maintenance of DHF
• Worked with Angular JS to validate from front end and run Angular scripts also compare the data with backend
• Experience on ETL testing and validation with many projects and working with Salesforce reports
• Well experience in CST testing using GRID environment for Myatt,EBM,HALO projects.
• Well Experience on Jmeter and load runner
• Well knowledge in SOA testing during prod validation for Automation projects.
• GRID Test experience on eclipse with java coding and validate TELEGENCE, ROME, UDAS, ECDW DATA, ENABLER HDS-IMEI, DTI, CCR-R, CCR-L with end to end validation and experience on Cassandra backend
• Experience with HP Quality Center/Application Lifecycle Management for Test Case Creation, Test Case Execution and Defect Tracking, Test case Traceability, Requirement Traceability
• Working experience on power shell and Bash in many projects
• Well experience on mobile testing using see test, eggplant, appium tools
• See test fully integrated with HP Quality center and JIRA
• Experience with SOA Test and Soap UI pro Test in many projects
• Finding defects and bugs during implementation of projects
• Experience in Functional testing, regression testing using Soap UI PRO
• Generate daily reports weekly reports and tracking report
• Worked with data testing team(TDSS) and generate reports using pivot tables

Confidential, ARKANSAS

QA analyst/ big data testing / Test Architect

Responsibilities:

• Working experience in QTP, ALMQC,SELENIUM WEBRDRIVE, ITE,SVN,WSDL and Agile environment in various projects.
• Involved in Data staging validation, Map reduce validation and output validation phase.
• Involved in many projects using SoapUI PRO for regression and functional testing
• Working knowledge of selenium web driver, python using object oriented API for web-app testing.
• Working with Angular JS with Assortment Management Project and also worked with back end using Oracle and hadoop
• Well worked on ELT Tools also using salesforce,Cognos and microstrategy tools for reports.
• Knowledge of python functions and script mode programming
• Worked on python modules, dictionary, tuples and exceptions
• Well experience in Selenium testing using web driver
• Well experience in Device testing in various projects
• Experience in working Test driven Development and Acceptance Test Driven Development
• Well experience and involve many projects with Power shell and BASH
• Well knowledge of VB Script, java and j2ee and API validate on java application
• Experience and working knowledge on Oracle/web logic
• Validate proper data from source system landed in Hadoop and check data is extracted in Hadoop location, map reduce process works correctly
• Validate the data after post map reduce process
• Validate the transformation rules, check data integrity and no data corruption while comparing target data with HDFS
• Perform test execution, regression testing, functional system testing on assortment Discipline application.
• Well Experience in projects using JIRA, Testing, Maven, MS Build and Jenkins build tools
• Well Experience with several selenium projects using java code development
• Well experience on back end validation using Hadoop with hive queries and use HUE front end tool and validate mismatch records between UI application and Hadoop data
• Working experience on Test Data Management tools HP Quality Center, HPALM, Load Runner, QTP and Selenium.
• Experience with HP Quality Center/Application Lifecycle Management for Test Case Creation, Test Case Execution and Defect Tracking, Test case Traceability, Requirement Traceability
• Experience on review documentation of software defects and assign software developers to investigate and resolve the issue
• Create test cases and doing validation in Hadoop hive using inner joins and outer joins (all backend validation)
• Validate and create new projects in UI Application and run application
• Generate daily reports weekly reports and tracking report

Confidential, Texas

QA Analyst

Responsibilities:

• Perform mobile test execution, regression testing, functional system testing on Android application.
• GRID Test experience on eclipse with java coding and validate TELEGENCE, ROME, UDAS, ECDW DATA, ENABLER HDS-IMEI, DTI, CCR-R, CCR-L with end to end validation
• Working experience on power shell and Bash in many projects
• Well experience on mobile testing using seetest, eggplant, appium tools
• Seetest fully integrated with HP Quality center and JIRA
• Experience with SOA Test and Soap UI pro Test in many projects
• Experience in Functional testing, regression testing using Soap UI PRO
• Experience in working Test driven Development and Acceptance Test Driven Development.
• Working experience on java, servlets,javascript,XML,AJAX,J2EE in various projects and validate in end to end projects
• Experience with Appium we can get full access to backend API's and DB's from test code.
• Validate proper data from source system landed in Hadoop and check data is extracted in Hadoop location, map reduce process works correctly
• Validate the data after post map reduce process
• Validate the transformation rules, check data integrity and no data corruption while comparing target data with HDFS
• Well Experience with several selenium projects using java code development
• Working experience on Test Data Management tools HP Quality Center, HPALM, Load Runner, QTP, Selenium.
• Develop and execute software test plans/test cases on Telegence CSM in order to identify software billing problems and their causes.
• Experience with HP Quality Center/Application Lifecycle Management for Test Case Creation, Test Case Execution and Defect Tracking, Test case Traceability, Requirement Traceability
• Experience on review documentation of software defects and assign software developers to investigate and resolve the issue
• Experience on review and approve test schedules or strategies in accordance with project scope or delivery dates
• Experience of design and develop framework to automate web service XML formats using QTP
• Well knowledge of Agile Methodology working with Scrum master, product owners and vision meeting
• Working knowledge of entire lifecycle of ordering, provisioning and Billing for telecom services.
• Experience with testing techniques, phases and tools such as HP ALM
• Experience with PL/SQL,CQLSH, SQL testing and well knowledge of AS400
• Experience with testing techniques, phases and tools with HP ALM.
• Experienced with test reporting metrics and giving status
• Track & analyze test results and work closely with the developers to isolate and reproduce defects.
• Create & track bug reports. tools including hardware and software.
• Develop automated tests to meet story acceptance criteria
• Define product test plans based on eliciting criteria for acceptance.
• Develop, update, and maintain testing standards and procedures
• Working experience with testing on ETL Oracle PLSQL

Confidential, VA

QA ANALYST

Responsibilities:

• Well experience in CRM (customer Relationship Management) for Customer order
• Involved many projects using SoapUI Pro for functional and regression testing
• Well experience in Mortgage banking with Confidential bank.
• Well knowledge about banking loans with the customer credit line.
• Working with mortgage loans projects and client requirements
• Working with Canada Secured Card systems with various projects using Unix/Control-M/Oracle/Teradata environment. Support L3 Level requirements and analyze alert messages with quickly solve the errors and failure of daily/weekly/monthly jobs.
• Perform mobile test execution, regression testing, functional system testing sanitary testing smoke testing
• Experience with testing tech niques, phases and tools such as HP ALM
• Experience with PL/SQL,CQLSH, SQL testing
• Worked with UNICA Campaign management team (CMIT) and involved various projects using more than 100 Jobs in campaign schedule management.
• Restore client data from various external sources (FTP) to our file system
• Large volume data conversion, data cleansing, production report generation, and upholding scheduled data delivery standards
• Perform Data validation and massaging to ensure accuracy and quality of dataExperience in Dashboard production and Responsible for design, development of a diversity Dashboard Responsible for data access and delivery technologies linking data to the Dashboard output and create management level output and views
• Working experience in API, Data Migration, Metadata with SQL Developing.
• Working experience in CTRL-M Schedule Changes with different jobs.
• Working with Unix environment and writing queries in Oracle/Teradata for business requirement to satisfy Data ware house concepts.
• Knowledge of Power Builder and identify the transactions using PB connecting various testing/Developing & Production servers.
• Requirement gathering, design, development of coding, testing and involved in Roll out and Post Production for each project.
• Analysis of the specifications provided by the clients.
• Involved in world permission scan Unix coding and complete development and roll out / post production.
• Implemented Multiple signal file fix project in Unix environment to run oldest file first and other files waiting for rerun the jobs
• Worked with various system interfaces to gather requirements for migration and implementation.
• Extensively involved in creating audit reports by extracting from the data warehouse.
• Well knowledge of ftp in Unix environment using put/get of export import data from various Unix servers.
• Loaded and extracted data into Teradata using Fast Load, BTEQ, Fast Export, Multi Load, and Korn shell scripts.
• Coding Unix BTEQ Wrappers for loading and extracting data using BTEQ SQL of TERADATA
• Write Unix shell scripts to validate, format and execute the SQL’s on UNIX environment
• Experience in Control-M Jobs with knowledge of late alerts and identify the failure of jobs using Unix scripts/ SQL Queries

Confidential Plano, TEXAS

QA Tester

Responsibilities:

• Well knowledge of Meta data, Teradata also having Knowledge of Production data, Data Quality Management, Process knowledge management and EDW Quality Data Management
• Working with Korn shell using commands in Unix environment and programming for various projects in Confidential &T
• Working with Tivoli, Foglight / Asemon and Introscope in various projects
• Restore client data from various external sources ( FTP) to our file system
• Large volume data conversion, data cleansing, production report generation, and upholding scheduled data delivery standards
• Perform Data validation and massaging to ensure accuracy and quality of data
• Well experience in Oracle R12 and AME (Oracle approval management).
• Expert Level usage of Documentum in data quality and upload all types of documents in documented.
• Knowledge of Mercury Table Level Specification, Extract data base, scoring role, Audit Changes, Audit gap, Metrics etc.,
• Well Knowledge in Data Ware Housing and Business Intelligence Reporting
• Well knowledge in ERWIN Data Modeling and agile Software development
• Well Knowledge of Teradata with SQL Query Scripts verification
• Identify Mercury Table Level Specification with Script Knowledge, Database names, Tables Names with Target and Source details
• Well Knowledge of Documentum and Exporting and importing of table level specification documents. Knowledge about process Lineage documents with Visio Diagram.
• Working with different servers in Unix environment and written and locate table name and database names from various script
• Different varieties of query written in Teradata data sql assistance and also update various columns in tables
• Strong experience in Analysis, Design and Development using forms and reports. Extensively worked in SQL, PL/SQL, Forms and Reports.

Confidential, FL

QA Tester

Responsibilities:

• Strong experience in Analysis, Design and Development using forms and reports. Extensively worked in SQL, PL/SQL, Forms and Reports.
• Perform mobile test execution, regression testing, functional system testing on many applications.
• Working knowledge of entire lifecycle of ordering, provisioning and Billing.
• Experience with testing techniques, phases and tools such as HP ALM
• Experience with PL/SQL,CQLSH, SQL testing and well knowledge of AS400
• Experience with testing techniques, phases and tools with HP ALM.
• Experienced with test reporting metrics and giving status
• Track & analyze test results and work closely with the developers to isolate and reproduce defects.
• Create & track bug reports.
• Develop and maintain automation tests.
• Participate in Agile Scrum activities every day and every sprint calls
• Built models containing query subjects, query items and namespaces from imported metadata.
• Developed front-end screens using Forms 6i and generated custom reports using Reports 6i
• Well Knowledge in Cognos Client Tools Impromptu, Powerplay and Transformer.
• Well Working Experience in Cognos8 with Report Studio, Query Studio, Frame work manager & Transformer.
• Developed back end interfaces using PL/SQL packages, stored procedures, functions, Collections.
• Worked on tuning the SQL Queries for better performance and troubleshooting development problems.
• Responsible for SQL tuning and optimization using Analyze, Explain Plan, TKPROF utility and optimizer hints
• Receiving (Extracting) data from the mainframe systems and other external system which included flat files and processed it for the new application
• Created tables, materialized views, constraints, managing triggers, stored procedures, indexes, cursors.
• Created test plans and test scenarios for functionality and performance testing.
• Changed already existing Procedures, Functions, Views, and Packages to improve Performance, using PL/SQL

Confidential, Deerfield, CHICAGO

Oracle DATA ANALYST

Responsibilities:

• Creating Users and Responsibilities and customizing the navigation menu
• Creating new Forms and attaching to the menu
• Developed front-end screens using Forms 6i and generated custom reports using Reports 6i
• Extensively used of PL/SQL, Procedures, Functions, Form Triggers and Packages
• Developed system and operation documentation
• Monitored objects and events throughout the database using Oracle tools and TOAD to maintain peak performance
• Migrated the Data from FoxPro System to Oracle system through SQL *Loader from Flat File

Confidential,

Oracle Developer/ Support DBA

Environment: Oracle 8i/9i Windows 2003 Server, MS Access, Excel, SQL, PLSQL, Oracle Reports

Responsibilities:

• Porting of Data from FoxPro to Oracle through MS-Access & ODBC for Inventory Systems, Finance Accounting Systems & Payroll Systems
• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Responsibilities included collecting user requirements, performing feasibility analysis, proposing functional and technical specifications, developing code per the specifications, distributing tasks among team members, doing code reviews, facilitate source code control.
• Documented Tech Specs for the proposed data base design.
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
• Conducted SQL, PL/SQL training session for co-workers to educate about the latest Forms, Reports, SQL, PL/SQL features, PL/SQL performance tuning .