SUMMARY:

• Over 12+ years of Software Quality Assurance (QA) and System Analysis experience testing AWS, Data Warehouse, Hadoop, Mainframes Client - Server Systems and Applications for Banking/Finance, Insurance/Healthcare, and Retail/Manufacturing Industries.
• Experience working with CDC Golden Gate/AWS environment, integration with real time Apache Kafka, Zookeeper, SQS, EC2, S3 Splunk, RDS, DMS.
• Strong working experience on DSS applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience on Hadoop Ecosystems like Hive, Pig, Sqoop, and Map Reduce.
• Hands on experience in using Map reduce programming model for Batch processing of data stored in HDFS.
• Automate & Develop the Testing for the validations and Entries of the System Test Flows using Pentaho scheduler.
• Data analysis using Python, PL/SQL and Apache Drill.
• Experience in developing Automated test scripts using Mercury Win Runner, selenium for functional testing of the application.
• Extensively worked on the Performance Testing using tools xymon, splunk, Jmeter.
• Good Knowledge and work experience in Agile and Waterfall methodologies.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Expertise in OLTP/OLAP System Study, Slowly Changing Dimensions types (SCD'S) Analysis and E-R modeling, developing Database Schemas like Star flake and Snowflake schema.
• Expertise in extended validation of report functionality developed, using BI, MSTR, Tableau by writing complex SQLs at the backend.
• Proficient working with the tools such as ALM Quality Centre (QC), confluence, JIRA and Confluence/ JIRA
• Expertise in Waterfall, Iterative and Agile (scrum) methodologies for the product development.
• Has expertise in Test Strategy, Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Involved in Design and Development of test plans based on high-level and detailed designs. Analyzed the user/business requirements and functional specs documents.
• Collaborate with Data Analysts, Business Partners and Developers on requirements and Design to process Big data in efficient manner.
• Strong interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills.
• Experience working as onsite coordinator to resolve the issues/risks with offshore team.

SUMMARY OF IT TOOLS USED:

ETL Tools:  Informatica Power center, Oracle Data Integrator, Data Stage

Reporting Tools:  Business Objects XI R2/6.1/ 5.1, Cognos 8, OBIEE

Testing Tools:  Tableau, Query surge, HP Quality Center/Test Director, Load Runner, QTP, Manual Testing, Bugzilla, Win Runner, HTTP Watch

Database Management:  Hbase, HDFS, HCatalog, Oracle 8i/9i/10g, Sybase, SQL Server 2000/2005, MySQL, ODBC, DB2, IMS TOAD 8.5, MS Access, Rapid SQL, PLSQL Developer, Dynamo

Operating Systems:  Window 2003 Server, Windows 2000 Advanced Server, Windows 98, Windows XP, Linux and UNIX(AIX).

Version control:  Visual Source safe, WINCVS, PVC, Source gear Vault, TFS, Confluence, GIT, Slack, Jira

Data Modeling Tools:  Sqoop, ERWIN, MS Visio, kubernetes, Distributed Tracing

Web Programming:  Map Reduce, HTML, XML, JSP, Java Script, Strom

Programming languages:  PIG, HIVE, Cobol, JCL, Pascal, C/C++, PL/SQL, VB 6.0

Scheduling tool:  Oozie, Pentaho, flink, Mainframes OPC Scheduler, Control M, Autosys, TIDAL, Pentaho

Others:  MS Office 2003, Adobe Acrobat Professional 6, MS office, JSON, Mainframes, Microsoft Outlook, Lotus Notes, Clarify, HP Service desk

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

DB Engineer

Responsibilities

• Tested application integrity after running data Extraction, Transformation and Loading programs with services GG, Strom, RDS.
• Validate AWS, SQS Queue, Kafka, Storm for the Data Transformation.
• Analyzed and interpreted test data, verifying critical software requirements to support development of requirements for system modification, development of test measures and criteria, test planning, execution and reporting activities.
• Responsible for writing the scripting in PIG for Analysis purpose
• Automate the Testing for the complete Auto System Test Flow for each integration points.
• Work on Esmart Incidents and ager duty Assigned to the Esmart group Data & Services BIA MDP.
• Generate Avro/Json schemas for the Performance evaluation.
• Execute the Performance metrics to identify gaps between the data ingestion layers and fine tune wherever required.
• Responsible for Partitioning the Kafka clusters after evaluation of performance.
• Executed test scripts and verified the results. Reported Bugs to developers through the JIRA/Confluence.
• Document and track defects identified during testing. Report accurate testing status and recommend release to the next environment
• Supports data management activities associated with testing and analysis of test data to determine satisfaction of test objectives.
• Wrote Complex SQL queries to validate the standard reports.
• Involved in the triage meetings with business and development team.
• Developed reusable components to reduce the time.
• Used Confluence to Write Test case and attached test scripts to test cases.
• Monitored the workflows from the Workflow Monitor.
• Regression testing is done as per the new releases and versions.

Environment: AWS/S3, Aurora, Maria DB, MYSQL,golden gate, oracle, RMS, Strom, Splunk, Pentaho, RDS, Power Center 8.1, workflow manager, workflow monitor, Oracle UNIX, Toad, Micro Strategy, SQS Queue

Confidential, Beaverton, OR

Senior Big Data Tester

Responsibilities:

• Analyzed the Business requirements, User Interface specifications, Use Case documents and Test Procedures. Creation of Test Plans, Test Procedures and Test Cases.
• Participate in Scrum planning, user story creation, retrospective meetings.
• Perform Map Reduce operations involve in processing the input files and applying map and reduce operations to get desired output.
• Integrated Hadoop into traditional ETL, accelerating the extraction, transformation, and loading of massive structured and unstructured data
• Load data into Hive tables using HQL scripts.
• Run Oozie workflow to perform pig action, hive actions and loading data into tables.
• Performed Integration, aggregation and End to End testing using Automated Hive scripts.
• Validated Business Intelligence Tableau reports for Data Analytics.
• Validation of Pre-Hadoop processing to ensure that that data is getting processed without any errors.
• Validation of non-functional testing like performance and failover testing plays a key role to ensure the whole process is scalable and is happening within specified SLA.
• Involved in Report Validation, Cube Testing, Dash Board Testing in the Hadoop Framework
• Performed Integration, aggregation and End to End testing using Automated Hive scripts
• Validated cubes and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio
• Involved in the triage meetings with business and development team.
• Developed reusable components to reduce the time.
• Designed Standards, Policies, Procedures and best practices of using Informatica
• Tested maps using Mapping Designer in Informatica according to the business specifications.
• Used Quality center to Write Test case and attached test scripts to test cases.
• Monitored the workflows from the Workflow Monitor.
• Regression testing is done as per the new releases and versions.

Environment: Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), Oracle Data integrator, Selenium, Cognos 8, SQL *Loader, Quality Center, Oracle9i/10g, Sybase, Windows XP, TOAD, UNIX.

Confidential, Bloomington,IL

Senior QA Analyst

• Analyzing the requirements and understood the business critical functionalities for restructuring of the Application.
• Assist & coordinate in gathering the functional requirements and documenting them.
• Automate the Big data regression suite to validate after each release
• Execute the ingestion methods to load data into HDFS cluster using Sqoop & API methodology.
• Perform Analytics on Hadoop file system.
• Developed the Test case, Test Scenarios, Test Plans and Reporting Documents.
• Participated in the User Acceptance Testing with the Stake holders
• Responsible for gathering Test data from the legacy systems
• Executed test scripts and verified the results. Document and track defects identified during testing. Report accurate testing status and recommend release to the next environment.
• Extensively used SQL scripts and procedures & joins to confirm the data transfer from source to target as per the business rules.
• Tested Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done correctly.
• Data Analysis using Python scripting.
• Perform data quality analysis, standardization and validation.
• Execute and validate the AQP work flow.
• Automate the Necho system validation & Verification process

Environment: Informatica Power center 7.1(ETL), Microsoft SQL SERVER 2005 (SSIS), Business Objects XIR2, Toad for Oracle, MTM, ORACLE 9i, Unix, Bugzilla, Control M, Source Gear Vault, Windows XP.

Confidential, Jacksonville, FL

ETL Automation Test Lead/Data Analyst

Responsibilities:

• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Develop and Automate the XAD flow using web interfaces
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing, Sanity, Regression and end-end testing
• Implemented SDLC, QA methodologies and concepts in the Project
• Automate the Scheduling and automating jobs to be run in a batch process
• Worked on profiling the data for understanding the data and mapping document.
• Reported bugs and tracked defects using Bugzilla.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used TOAD Software for Querying ORACLE.
• Validated Standard Business objects reports against business requirements
• Involved in working with Source Gear Vault for Version Management
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases

Environment: Informatica Power center 7.1(ETL), Microsoft SQL SERVER 2005 (SSIS),Business Objects XIR2, Toad for Oracle, ORACLE 9i, Unix, Bugzilla, Control M, Source Gear Vault, Windows XP.

Confidential, Chattanooga,TN

Data warehouse QA

Responsibilities

• Provided inputs for creating detailed Test Plan. Created and executed test cases for User Interface functionality, Data Warehouse data (Fact tables, Dimensions, References and Lookups) and Reports.
• Test cases were designed to cover System testing and Integration testing scenarios.
• Performed System testing, regression testing and user Acceptance testing (UAT).
• Created Automation test scripts and performed Regression testing. Created User Defined Functions to enhance the maintainability of regression scripts.
• Executing manual test cases/scripts and documented test results. Reported Bugs through Test director bug-tracking tool.
• Submitted Status and Test Evaluation Reports to Test Lead. Constantly updated test deliverables.
• Responsible for preparing User Manuals.
• Used Test director to Write Test case and attached test scripts to test cases.
• Designed ETL template using Metadata Reporter for easy walk through with customers.
• Studied documentation on Business Requirements, System requirements and application.
• Maintained Test Matrix for latest test results information.
• Interacted with business analysts in resolving the problems in different environments (Unix, NT)

Environment: Data stage 7.5, Cobol, JCL, DB2, VSAM, Business Object Reports, Windows 2000/XP Professional, LINUX, SQL, PL/SQL, ASP.NET, VB.NET Oracle 9i, DB2, Test Director 8.0

Confidential, Hartford, CN

Business System Analyst

• Analyzed the Business requirements, User Interface specifications, Use Case documents and Test Procedures. Creation of Test Plans, Test Procedures and Test Cases. Was part of Test Planning, Test Design, Test Execution and Test Evaluation Involved in Functional, Integration, System and Regression Testing of the application
• Creating Test plans, Test cases based on requirements of application.
• Participated in various project meetings. Tested the application manually using Internet Explorer and Netscape Navigator.
• Tested application integrity after running data Extraction, Transformation and Loading programs.
• Executed test scripts and verified the results. Reported Bugs to developers through the Test director.
• Involved in gathering, analyzing, distilling and clearly conveying complex information to business and project team members through JAD sessions
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements using RUP methodology.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process.
• Conducted interviews and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions
• Produced documents for business requirements (requirements matrix), design requirements, gap analysis, solution recommendations, test cases, test plans and reference guides
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Developed detailed System test plan including test procedures and test cases
• Conducted Integration testing, Performance testing, Functional testing and Load testing to ensure that the application meets the requirements and to ensure usability readiness
• Developed test automation scripts for Regression and Performance testing
• Identified and resolved many application bugs and bottlenecks
• Verified all the functional and load requirements are met

Environment: Informatica 7.1, Windows 2000, Win runner, Test Director, HTML, Autosys, JavaScript, Servlets, JDBC, JSP, Web methods, Toad for Oracle, Oracle 8i.