SUMMARY

• High performing and qualified IT professional with 12 years of experience and the ability to lead direct and indirect employees within cross - functional teams as well as advise on key management areas such as project management, business operations, process improvement/reengineering, data analysis, change management, technology & system integration, strategy, performance planning and execution. Strong experience working in various industries including Telecommunications, Healthcare, Insurance and Electrical Equipment’s. Solid understanding of Business Requirement gathering, Business Process Flow, Business Process Modeling, Business Analysis and Data Mapping in Agile/Waterfall/DevOps environments.
• Hands-on Experience in Requirements Analysis, Test Design, Test Development in Manual and Automated Testing for Client/Server and Web applications.
• Strong understanding of Software Test Life Cycle, Test Methodologies and Test Plans.
• Expertise in testing tools like Win Runner, Test Director, Load Runner, Quick Test Pro and Quality Center.
• Performed end-to-end software testing Confidential various stages of application development by applying Business/Use Cases for Ad-Hoc, Black Box, White Box, Security, Smoke, Volume, Configuration, Data-Driven, Positive/Negative and UAT.
• Have good knowledge of Business Acceptance Testing (BAT) testing.
• Proficient in GUI Testing, Functional Testing, Regression Testing, Integration Testing, Database testing, System testing, Security testing, Smoke testing, Build Verification Testing, User Acceptance Testing and Cross browser Testing.
• Hands on Experience in working in multi environment includes on site/off shore model.
• Actively involved in User Acceptance Testing (UAT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes.
• Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Experience data driven testing using Jenkins.
• Experience in automating web applicable testing using selenium web driver with TestNG framework.
• Expertise in creating BDD driven test frame work
• Good Knowledge of Healthcare System with prime focus on Claims, Provider, Eligibility and Prior Authorization
• Expertise in Claims Processing, HIPAA Regulations and 834, 837 278, 276, 277 Transactions for health care industries
• Well versed in Hadoop ecosystem - Map Reduce, Pig, Hive, HBase, Oozie and Sqoop
• Experience in loading multiple larger datasets into HDFS and processing the datasets by using the Hive and Pig.
• Experience in validating tables with Partitions, bucketing and Loading data into HIVE tables.
• Articulate with interpersonal, intuitive, technical, analytical and problem solving skills.
• Excellent skills in analyzing user’s requirements, modeling the system and ensuring the functionality, with client satisfaction as the primary focus.
• Self-motivated, energetic and highly ethical in all work related assignments thus able to immediately contribute to corporate goals and objects
• Good written, communication, interpersonal skills, proven team player with an analytical mind bent to problem solving and delivering solutions

TECHNICAL SKILLS

Testing Tools: Jira,QC, Selenium, Quick test Professional, BPT, Load Runner, Win Runner

Defect Tracking Tools: Jira, Quality Center, Test Director, Silk

ETL Tools: Informatica 9.5.1,Hadoop

Reporting: Power BI, Business Objects

Database: Oracle, MS - SQL Server, Teradata, DB2,MS Access

Operating system: Unix, Linux, Windows

Languages: C, C++, Java, J2EE, SQL, VB, ASP, JavaScript

Scripts: HTML, XML, Java script, VB Scrip tApplications: SOA, Mainframes, AWS, Azure

OTHERS: MS Project, Visio

Environment: Jira, HP Quality Center,REST, HIVE, HADOOP,Azure, Toad, Teradata, INFORMATICA 9.5, CSS, JavaScript, PL/SQL, Oracle 10g, TOAD, UNIX, ERICSSON BILLING SYSTEM, SAMSON BILLING SYSTEM, Shell Script and Windows XP.

Environment: HP Quality Center 12.1, Java 1.5, J2EE, HTML, Java Servlets, Jakarta Struts1.1, Swing, Tiles, Log4J, Eclipse3.1, Harvest, XML, AS/400, Web services, Web logic 9.2,Selenium,Cucumber, BDD,REST, HIVE, HADOOP, Teradata, Power BI, Toad, SQL, INFORMATICA, CSS, JavaScript, PL/SQL, Oracle 10g, TOAD, UNIX, ERICSSON BILLING SYSTEM, SAMSON BILLING SYSTEM, Shell Script and Windows XP.

Environment: HP Quality Center 10, Java 1.5, J2EE, HTML, Java Servlets, Jakarta Struts1.1, Swing, Tiles, Log4J, Eclipse3.1, Harvest, XML, AS/400, Web services, Web logic 9.2, SQL Server, Oracle, Hadoop, DB2, Python,REST, HIVE, CSS, JavaScript, PL/SQL, Oracle 10g, TOAD, UNIX, ERICSSON BILLING SYSTEM, SAMSON BILLING SYSTEM, Shell Script and Windows XP.

Environment: Mercury Quality Center, MS Office, Oracle, SQL, Windows NT/2000 (Word, Excel, Power Point) MS Project, SOAP UI.

Environment: Windows XP, UNIX, Quality Center, Putty, Oracle, Toad, Enabler, ICORE, TLG.

Environment: Windows NT/7 servers, Silk Center, Java, PEGA, DB2, Lotus Notes, Snagit 9, IBM Mainframes (COBOL, DB2, JCL, TSO, TIBCO), SAS, SOAPUI.

Environment: Windows XP, Quality Center, QTP, XML, IBM mainframes, SQL Server 2000, VB scripts, ESB (Enterprise service Bus), VB Script, SOAP UI, Mainframe

Environment: C, VB, Micro Processors, MS-Word, MS-Excel.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. ETL/Data Warehouse/Reports QA Tester

Responsibilities:

• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Providing details analysis & resolution on complex Teradata BTEQ scripts used for data loads into IDW system and any defects raised by business users in Production.
• Working with Hadoop team on HDFS file issues and querying Hive views using Ambari to find any data issues / Anomalies.
• Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Defects identified in testing environment are communicated to the developers using Quality Center/Jira - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases,
• Scheduling and automating jobs to be run in a batch process using Control-M
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Responsible for providing guidance to offshore team on all daily activities for all ongoing projects.
• Created ABC script which inserts data into audit master and audit ref tables.
• Executed QA services for enhancing efficiency of technologies and related updates for Azure Cloud Storage applications.

Confidential, Atlanta, GA

Sr QA Analyst/ETL/SQL Tester

Responsibilities:

• Experience in developing business architecture using requirements such as scope, processes, alternatives, and risks.
• Experience in analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Communicate client’s business requirements by constructing easy-to-understand data and process models.
• Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
• Used HP ALM for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
• Created ABC script which inserts data into audit master and audit ref tables.
• Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications.
• Used TOAD Software for Querying ORACLE and Teradata SQL Assistant for Querying Teradata
• Tested Data mapping activities from Source systems to Teradata
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
• Coordinated with development team in system integration test and services level unit testing.
• After Daily loads are completed, all the critical field values should be matched between Source-SPS or SPS - core Confidential row level.
• Extracted Power BI reports and validated them against business requirements and data loaded from source. Performed reviewed with business on the same for sign off .
• Performed Regression testing on various existing flows using Selenium & TestNG, selenium & Junit.
• Created Test Automation Framework with Cucumber and Selenium WebDriver
• Validated the Map reduce, Pig, Hive Scripts (Python) by pulling the data from the Hadoop and validating it with the data in the files and reports.
• Involved in all over the quality controls (Hadoop & Teradata), data validations, Key business checks, RTAS implementation of Hadoop ETL flow and Teradata landing zone/target tables.
• Coordinated various project specific access requests related to Hadoop components like Edge node and HDFS directories, Hive tables, Autosys instances, Mainframe LPARs.
• Coordinating various database requests like Access category, DB questionnaire, Initial Environment Setup, DDL notepad through nexus and other ticketing portals.
• Performed various Hadoop controls like date checks, record checks, balance checks, threshold limits for records and balances etc. for various SORs (system of records) like Data and stat files on checkpoint basis.
• Worked on payment reconciliation production issues on Ericsson billing system
• Identified and pointed out design gaps during testing of major CRs. Communicated effectively with developers and became a 'go-to-tester' for challenging test cases.
• Helped Business in reproducing production issues in QAT and driving them with SA’s and developers for resolution.
• Conduct formal high level calendar design reviews with Customer IT operations and business groups

Confidential, Atlanta, GA

Sr Test Analyst

Responsibilities:

• Analyzed Business Requirements, Functional Requirement & High level Design documents and user stories of Rebellion and uprising projects of Confidential
• Designing Test plan based on process flow, HLD and use cases.
• Designed & developed the test cases and Participated in Project Document walkthrough and Review Test Cases in PM meetings.
• Performed Integration, System testing, sanity/Smoke testing and End-to-End testing, Regression test to ensure the application is working as expected.
• As part of the integration/E2E testing we would test all the Provisioning and Engineering systems using various tools like (EMA, EDAT etc.)
• Perform testing on the devices as well, which would require extensive updating of various Engineering systems in the Environment.
• Used Postman & SOAPUI for rest service testing.
• Involved in preparation of data request based on the project requirements (Business Requirements, Functional Requirements, Application Design Document) for various applications like Wireless Analysis, Extensively worked on different wireless technologies like GSM, UMTS.
• Involved in back office testing (RSL, Minotaur, Moneta, Hawkeye) - database, file and file transfer using FEMM and connect enterprise validations.
• Created test data using Vision billing systems based on the project requirements.
• Performed regression testing of application for each release and CR Testing.
• Extensively involved in both Positive and Negative Testing and written Test Cases.
• Performed billing creation - database, BCH, DB Extraction, MRC BATCH file, Charging system validation (SDP), PAM job validation
• Reported the defects to the development team by using defect-Management tools like Quality Center & Web Track.
• Retested the Reported defects once the Developer resolves the issue in application for every release and once it is passed will close the defect in QC.
• Performed extensive SQL queries for validating data against Source and Target systems
• Experience in testing of Data Warehouse/ETL Applications developed in Informatica using SQL Server, Oracle, Hadoop, DB2, and UNIX and also have ability to evaluate ETL/BI specifications and processes.
• Experience in UNIX, RDBMS, Hadoop, HIVE (HQL), Oracle (PL/SQL), MS Access.
• Testing and bug fixing of an embedded logging application written in Python.
• Extensively used SQL for data validation during back-end testing.
• Performed validation on payment gateway daily extension and chargeback file
• Extensively used TOAD and SQL developer to execute SQL Queries as well as to access database objects.
• Involved in executing different Shell Scripts to validate the batch job’s and also involved in validating the audit logs and Error logs on UNIX servers.
• Involved in using various UNIX commands for file validations.

Confidential, Atlanta, GA

Sr Test Analyst/Lead

Responsibilities:

• Manages the execution and tracking of the test plan and to ensure the timely delivery of high quality software product standards for Client /Server, desktop, web based n-tier applications, products, and/or enhancements to existing applications
• Interface with Business Analysis, Engineering, and Management teams to clarify requirements, set testing priorities and escalate issues. Evaluate and prioritize reported bugs
• Acted as interface between Technical Team and the Business.
• Generate Management reports and report weekly status
• Worked on different types of Assertions like XML for better Performance and Stress testing.
• Involved in mapping and translation using SOAP testing for REST API.
• Analyzed business requirements and authored test cases for test execution in both manual and automated modes for online banking and loan application modules.
• Developed simple automation test scripts using QTP based on the test cases identified from functional requirements.
• Successfully designed the change management procedure for the project after identifying the criteria for change / feature request qualification, bug reporting, roles and responsibilities and issue escalation processes.
• Conducted multiple sessions of user acceptance testing (UAT) for the financial services and online trading modules, recorded user feedback and logged it in the form of bugs.
• Verified defect fixes in both manual and automated modes using QTP scripts along with SQL queries for data validation.
• Used Quality Center for defect tracking and reporting bugs. Recorded defect details, assigned severity and reported defect status to the Quality Manager.
• Performed Backend testing to validate the data using SQL queries to the required Test cases.
• Developed recommendations and designing solutions for process improvements.
• Worked effectively and collaboratively with the QA team, development teams, PM’s, and business users.

Confidential, Atlanta, GA

Test Analyst

Responsibilities:

• Involved in developing and executing test plan, test cases and test scripts for interfaces.
• Update and provide executive status of issues and defects via Quality Center.
• Analyze business and system requirements, mange development of specifications to create and execute detailed test plans, and verify bug fixes.
• Involved in internal and external test package review with stakeholders/PM/TM/Mediation Architects /development team.
• Configure test environment and create strategy for product development and certification. Assure test data, schedule automated/manual tests. Approve results documentation and tracking systems updates.
• Maintain and utilize technical knowledge to interface with Mediation (GFW Data/VOICE and WLINE).
• Was responsible for getting files from Confidential &T labs and decoding them to ensure they meet the business requirements.
• Expertise in tracking system flow (file process, parsing, archiving and output generation).
• Responsible for Downstream billing systems validation (TLG/Enabler/EOD/PMOSS/ICORE/Content manager).
• Supervise development of SQL-queries/procedures for database and backend testing.
• Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports.
• Expertise in tracking system flow (file process, parsing, archiving and output generation).
• Involved in sanity testing on UNIX box (CTE/Components), GUI - Gold Fusion Works and Oracle DB.
• Co-ordinate with offshore on daily basis and getting updates on ongoing projects.
• Worked on testing production work requests and sustainment tickets per release.
• Responsible for creating test summary package Confidential the end of release.
• Worked on Defect RCA for cancelled/closed defects.
• Perform dual roles on multiple concurrent projects utilizing both strong written and communication skills.
• Interacted with developers to resolving conflicting issues

Confidential, Raleigh, NC

Test Analyst

Responsibilities:

• Identifying the project objectives and requirements to create a Business Scenario Test Metrics and E2E/IST High Level Test Requirements
• Used BMC Remedy to create Remedy tickets and verify entered information in Pega front end
• Establishing the Primary Contact List to support Test Case steps related to requirements and setting up the expectations to the End Users.
• Involved in planning and execution of E2E, IST and Regression Test Cases and responsible for mapped the High Level Test requirements to the Test Cases in Silk Center
• Participated in test planning, writing test cases/scripts within PEGA PRPC and correct the according
• Tracked software issues and report statuses on the daily Executive check point calls.
• Responsible for understanding and creating the System and Data flow diagram(s)
• Provided a written/verbal escalation of project status, resources and schedule issue as required to Executive Level Management.
• Work extensively on various EDI transactions with the reimbursement background using Facets claim procedure.
• Tested the EDI 837 interfaces, Developed test cases and test scripts for all 835, 837 278, 276, 277, Institutional and Professional HIPAA Transactions.
• Involving in Analysis and design walkthroughs to better understand the Requirement Documents (TDD)
• Involved in writing PEGA Use cases and also writing test case documentation.
• Involved in Business Rules Engine BRE document for the implementation of Workflows in Pega PRPC.
• Based on requirement documentation, translated the information to business scenarios and high level Test cases.
• Worked on test plan to create manual/automated test scripts for the test cases including test details for the functionality test using Silk Center
• Involved in breaking down QA tasks and project planning.
• Checked the data flow through the front and backend and extensively used SQL queries to extract the data from the database.
• Participated in the User Acceptance Warranty Testing
• Involved in debugging/logging application using Pega Tracer tool and PAL
• Tracked bugs & defects by prioritizing bugs, assigning bugs, verifying and troubleshooting in Silk center.
• Review weekly migration activities and documentation of migration activities after defect fixing and coordinating efficient testing practices for effective iterative testing.
• Working closely with the development team to ensure that the testing issues are resolved and also report problems and provide risk assessments
• Participated in walk through meetings with the client, business analyst and the development team.

Confidential, Colorado Springs, CO

Quality Assurance Project Manager/Lead

Responsibilities:

• Involved in Test Planning and execution of E2E/IST, Regression testing from the scope closure to completion of the project.
• Scheduled Project kick-Off meeting and Weekly Test Team Meeting, Established Primary Contact List to support Test Case steps related to requirements
• Identified project objectives and requirements to create a Business Scenario Test Metrics and E2E/IST High Level Test Requirements
• Created System Data flow diagram(s) and Tracked Project for the Major Milestones
• Mapped High Level Test requirements to the Test Cases in Quality Center
• Tracked software issues and report statuses on the daily Executive check point calls.
• Provided a written/verbal escalation of project status, resources and schedule issue as required to Executive Level Management.
• Attended reviews and walkthroughs to better understand the Requirement documents(SOBR)
• Prepared Test scripts and Test Plans for E2E, IST and Regression testing.
• Create manual/automated test scripts for the test cases including test details for the functionality test in Test Plan using Quality Center.
• Involved in different interfaces: in different test phases: System, integration, back out, Shakeout, and GUI testing.
• Lead Regression testing process and involved in training off shore and on shore regression testers. Back up Test Manager and lead a team of 10 resources.
• Worked extensively with Investment Professionals, Financial Analysts, Operations as well as Business Architect and Development leads on requirement gathering and process evaluation
• Performed system analysis on the architecture of source as well as target application Custodian Download Process.
• Involved in testing APIs by calling various services using SOAP UI.
• Worked with SOAP UI, LOAD UI, Selenium, QC, Oracle, Teradata, Web Services, Agile Methodology.
• Defects are logged using Mercury Quality Center
• Participated in the User Acceptance Warranty Testing
• Automated regression scripts using QTP
• Tracked bugs & defects by prioritizing bugs, assigning bugs, verifying and troubleshooting in Mercury Quality center

Confidential

Programmer/Tester

Responsibilities:

• Understanding and Analysis of the Functional & Design requirements.
• Design and execution of manual test cases for Functional, Regression, Integration, System Testing and UAT.
• Development and execution of Test Scenarios, Test cases.
• Mapping of test cases to requirements and its traceability.
• Preparation of Test & Defect reports manually using excel sheets.
• Preparation of test setup and data.
• Preparation of Test, Defect logs and documentation.
• Perform Walkthroughs with development team to solicit them.
• Defect tracking and closure.