PROFESSIONAL SUMMARY:

• An experienced Quality Assurance (QA) Analyst wif 9 years of comprehensive experienceinHadoop, Big data Technologies, ETL and BI Tools and expert in writing complex SQL Queries to check the integrity of data to perform database, DWH, Stored Procedures, Functions, and packages testing. Possessing a proven ability to lead project teams to successfully deliver agreed upon solutions of the highest quality, often in complex and challenging customer environments.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing wif excellent interpersonal, analytical and organizational skills.
• Proficient in ETL Tools like Informatica Power Center, Ab Initio, SSIS and Reporting tools like Micro strategy (MSTR Reports), Tableau, Spotfire and SSRS. Exposure to web automation testing using TOSCA Automation tool and experience in automating Regression scripts using BTeq utiltiy. As a DevOps Tester experience in testing the Continuous Integration/ Delivery pipelines.
• A keen analyst and team player wif thorough understanding of all aspects of STLC including Analysis (BRD/FRS), Design, Development, Execution, Reporting and Closure Documentation.
• Experience in popular development methodologies such as Agile and Waterfall.
• me have worked in varied domains such as Banking (Financial Crimes, Global Banking and Markets), General Insurance and Healthcare (Claims).
• Now looking for a new and challenging Big Data Tester or ETL Tester position, one which will make best use of my existing skills and experience and also further my personal and .

TECHNICAL SKILLS:

Big Data Technology: Hive, Impala, Sqoop, Pig, HDFS, MapReduce

Databases: Oracle 11g/10g/9i, Mongo DB, SQL Server, MS Access

Testing Methodologies: Agile, Waterfall, V - model

ETL Tools: Informatica Power Centre, Ab Initio, SSIS

Reporting Tools: Tableau, MicroStrategy, Spotfire, SSRS

DB Tools: Teradata, SQL Server, Oracle, PL/SQL Developer, Toad

Search Analytics: Attivio Enterprise Search

Agile Tools: JIRA, Rally

Alert Generation Tool: NICE Actimize Tool RCM v5.7

Data Source: Database, Flat file, XML, Excel, JSON File

Test Automation: TOSCA, BTeq

Test Management Tools: HP Quality center

Scheduling Tools: iXp Autosys, CA Workload Automation

Other Tools: Putty, WinSCP, Beyond Compare, SVN

Programming Languages: SQL, MySQL, PL/SQL, HTML

PROFESSIONAL EXPERIENCE:

Confidential

Analyst

Responsibilities:

• QA Analyst played the role of lead as well as tester and ensured successful project delivery
• Performed Data Analysis, Data Validation, Data Verification and identifying data mismatch.
• Demonstrated capabilities on importing and exporting data from relational database into Hadoop cluster using Sqoop.
• Involved in creating HIVE tables, loading and analysing data using HIVE queries.
• Developed queries for analysing data in MongoDB database, Impala, Hive using Hive Query Language (HQL).
• Performed report data validations which are developed in Micro Strategy, Tableau, Spotfire and SSRS.
• Validated the JSON File by verifying the JSON Object Structure and data against the HIVE Tables.
• Played the role as a DevOps Tester testing the Continuous Integration/ Delivery pipelines wif exposure to tools like Git, Bitbucket, Jenkins, JFrog Artifactory, Ansible Tower, etc.,
• Performed BI & web automation testing using TOSCA Automation tool. Good Knowledge of TOSCA Test Suite (Modules, Test Case, Test Case Design, Requirement and Execution), TOSCA Scanning methods (XScan and TOSCA Wizard,) TOSCA Engines which helps to steer control (TBOX and Classic engines).
• Preparation of Test Plan, Test Condition/Scripts. Execution of the Test Scripts
• Utilized Job Scheduling tools like iXp Autosys and CA Workload Automation to run jobs. Test Management tools like JIRA, Rally, HP Quality Center to manage scripts and defects.
• Preparation of Traceability Matrix, SIT Entry/Exit documents, Sign off/ Pre-Production/Post-Production Reports
• Implemented new QA process wifin the team like daily calls, status reporting and Test Artefacts maintenance.
• Trained Team members on how to do Unit Testing of CI/CD Pipeline, Basic Hadoop Testing using UNIX
• Good understanding of Import and Export using Sqoop, noledge in partition and bucketing concepts of Hive. Good Knowledge in Map Reduce and Pig. Hands on Experience in UNIX commands and Shell Scripting basics.
• Performing peer reviews. Communicate proficiently wif team members. Collaborated wif Manager on hiring interns and tan provided them wif basic and appropriate supervision.
• Exhibited ownership, testing and leadership skills.
• Worked in Financial Crimes Technology domain as part of Risk and Compliance team.
• Gold & High Five for Leading the BDS Project and successfully delivering ahead of schedule.

Confidential

Sr. Test Engineer

Responsibilities:

• Detailed Analysis of Business Requirements Document.
• Preparation of Test Plan, Test Condition/Scripts. Execution of the Test Scripts
• Preparation of necessary Test data by keying in the backend using Teradata. We used Abinitio ETL tool. For loading the data from Source to Data warehouse we run CA Autosys Job.
• Data Validation based on Business logic
• Framing SQL queries based on the Business logic to validate data in Source DB/Flat Files wif the backend Teradata results.
• Preparation of Traceability Matrix.
• Regular Calls wif the onshore functional team for understanding the FRD walkthrough.
• Defect Tracking in HP QC. Liaising wif developers and programmers to swiftly resolve faults.
• Performing peer reviews. Interviewing new candidates for my team and hire them.
• Gain experience in General insurance domain.

Associate Software Engineer

Confidential

Responsibilities:

• Detailed Analysis of Business Requirements Documents on the different Models/Reports
• Preparation of Test Plan, Test Condition/Scripts. Execution of the Test Scripts
• Preparation of necessary Test data by keying in the backend using Oracle PL/SQL Developer/TOAD. Running the Autosys (CA Workload Automation iXp) Job to load data from Data warehouse to MSTR/ Actimize Risk Case Manager.
• Generated Alerts in the NICE Actimize Tool and validated the same against the business logic.
• Framing SQL queries based on the Business logic to validate data in Front End Actimize Model/Reports (generated using MSTR) wif the backend Oracle PL/SQL Developer/TOAD results.
• Utilized Job Scheduling tools like iXp Autosys and CA Workload Automation to run jobs. Test Management tools like HP Quality Center to manage scripts and defects.
• Preparation of Traceability Matrix, SIT Entry/Exit documents, Sign off/ Pre-Production/Post-Production Reports
• Implemented new QA process wifin the team like daily calls, status reporting and Test Artefacts maintenance.
• Preparation of necessary Test data by keying in the front end Plexis Quantum Choice Application. Running the ETL to load data from source to target Data warehouse.
• Framing SQL queries based on the Business logic to validate data in Front End Reports (generated using MS SSRS) wif the backend MS SSIS results.
• Regular Calls wif the onshore functional team for understanding the report handoff.
• Defect Tracking & Involved in Triage calls which happen between Testing/Functional & Technical team to discuss defects.
• Raising lots of questions on the BRD and asked the BA’s to update the documents and bring CR (after baseline).
• Drafting Minutes-of-meeting (MOM), Status mails and Weekly Metrics (WSR) about the project progress for the business leads.
• Performed Regression Testing & peer reviews. Supported the functional team during UAT for each release.
• Worked in GBAM (Global Banking and Markets) Domain as part of Risk and Compliance team, and Healthcare (Claims) domain.