Quality Analyst, Ecommerce, Wcs, Cms, Wmb, Soap Ui, SQL, Sdlc, Agile

Arpitha Chandregowda

Cell: 804-***-****

*******.**@*****.***

Summary:

●8+ years of Professional IT experience in Design, Development & Testing of client/server, web based, ETL applications

●Hands on experience in Data Warehousing ETL routines including developing and migrating Ab initio graphs

●Used various Ab initio components such as Join, Rollup, Scan, Reformat, Merge, Dedup, Sorted etc,.

●Experience using AIR commands to run graphs and data validation on both legacy on-Prem and Cloud environments

●Experience in working on Enrichment Cloud Environment (ECE) AWS S3, EC2

●Knowledge in job work-flow scheduling and monitoring tools like Automic (Arow)

●Experience with various scripting languages like Linux/Unix shell scripts, Python (Basic)

●Experience in prod parallel testing of ab initio code on both legacy and cloud environments to aid the cutover process

●Worked on analysis of Ab initio graphs to provide input for modernization intent as part of poc

●Experience developing and testing python custom framework components library as part of poc to modernize ab initio graphs

●Extensive experience in both manual and automation testing techniques using tools like QTP, SOAP, SOASTA, Scimitar

●Good knowledge working on end to end Data Warehousing and E Commerce applications

●Used ticketing systems like Quality Centre, Mantis, Bugzilla and Jira

●Experience with Unit testing/ Test driven Development (TDD), Load Testing, Continuous Integration testing and UAT

●Experience in all Phases of Software Development Life Cycle (Analysis, Design, Development, Testing and Maintenance) using Waterfall and Agile methodologies.

●Experience in using various version control systems like CVS, Git, GitHub and svn

●Facilitated sprint planning, daily scrums, retrospectives, stakeholder meetings, and software demonstrations.

●Good experience working in deadline driven environment with superior interpersonal communication and technical documentation skills

EDUCATION: The Oxford College of Engineering, Bangalore, India

Bachelor of Engineering, Information Science & Engineering Jun 2007

Skill Set:

ETL

Ab initio GDE (3.2.6.1,3.3.5), Co>Op (3.2.5.1,3.3.5.9)

Databases

Teradata, Oracle 10g/11g, MySQL, SQL Server 2008, DB2, Snowflake

Testing Tools

QTP 9.0/9.5/10.0/11.0, Quality Center 8.2/9.0/9.5/10.0, SOAP, SOASTA, Schimitar

Operating Systems

Windows XP/2000/NT, Linux, Mac OS

Programming Languages

VB Scripts, Shell scripting, Python (Basic)

Version Controls

TortoiseSVN, CVS, Basecamp, GitHub, EME (Enterprise Metadata Environment)

Other tools

AWS (Basic), Automic (arow), Control-M, WebSphere Commerce Server, Websphere Message Broker, IBM Websphere MQ, dotCMS, Monexa, Qpasa, IBM Accelerator & Admin Console, Interwoven teamsite, Omniture, Mantis, JIRA, ResultSpace, Salesforce,), Service now

Certifications: Scrum Master Certification from Scrum Alliance

Work Experience:

Capital One, Richmond, VA Feb2019-Present

ECE Pipeline Migration- Retail

Job Role: ETL Developer

Analyzed Retail projects and prioritized them for migration to AWS environment based on extensive interactions with business users

Developed and deployed Arow jobs and workflows with reference to the existing Control M architecture

Modified and migrated Ab initio graphs for Staging, Distribution and Loading projects from legacy On Prem (DDE) platform to AWS Cloud (ECE) environment by replacing Teradata with Snowflake loads

Performed data validations of input and output files between DDE (legacy) and ECE (AWS cloud) by using Data Comparison Tool for record count, mismatches and data discrepancies

Promoted code fixed and code migrations through Change orders on Service now platform complying with Change Management Process

Involved in lift and shift of jobs and data from legacy systems to cloud using Ab Initio and Arow scheduling tool

Monitored jobs through warranty support period and fixed job dependency related issues

Extensively worked in offshore & onshore model to coordinate and take the stories to completion by leading the team through every sprint.

Tracked and updated artifacts on Jira board set up for the scrum team

Handled incidents and alerts through pager duty platform

Performed stability check of the EMEs for cutover and involved in creating cutover documentation like constellation diagram, MBM plan, Analysis document.

Worked on Snowflake and Tera data for data extraction and data validation

Performed prod parallel testing on legacy and cloud environments to aide cutover of projects on AWS cloud environment

Decommissioned jobs/workflows on legacy servers once the jobs on AWS Cloud (ECE) environment and workflows were BAU.

Provided detailed analysis report of ab initio graphs/plans/psets on cloud as part of poc to modernize ab initio Graphs to Pyspark

Analyzed input and output file sizes to determine the usage of Quantum/ Quantum lite as part of modernization poc

Developed and tested Python custom framework components (File Reader, File Writer, Filter, Join, Aggregator)

John Wiley & Sons, Hoboken, NJ Oct2012-Feb2014

IFRS Application, Client: John Wiley & Sons Inc.,

Job Role: Senior QA Consultant

Analyzed Project plan, Requirements documents, and Design documents to create Test plan, Test Strategy, detailed test cases for IFRS application, Monexa billing platform and dotCMS.

Facilitated sprint planning, daily scrums, retrospectives, stakeholder meetings, and software demonstrations.

Involved in testing and creating page templates using dotCMS as Content Management system

Involved in testing order capture and processing on Monexa billing services Portal with JIRA being the bug tracking tool

Worked on testing the integration of various third-party tools like payment gateways, Disqus (feature-rich comment system with social network integration) along with checkout flows on AS400 mainframe.

Worked extensively on extracting EDI files and validating them.

Worked on all stages of Software Test Life Cycle adhering to Agile SDLC methodology

Digital Classroom, Client: John Wiley & Sons Inc,. Location: Hoboken, NJ

Job Role: Senior QA Consultant

Created, reviewed and executed test cases for online subscription site (digitalclassroom.com) with publisher subscriber model, customer service interface and Monexa platform and logged defects on Mantis bug tracking tool

Involved in testing rich media user Interface comprising text, videos, downloadable e-book library, interaction with social media for single and bulk subscriptions on multiple browsers

Involved in Functional testing, Content testing, cookies testing, Integration testing, Regression testing and end to end testing of the application

Sapient Corporation, Bangalore, India Apr 2010 – Apr 2012

Target.com

Client: Target Corporation, Location: Bangalore, India

Job Role: Associate QA L2

Involved in the functional, User Interface, regression and integration testing of Search, Shop, Browse, Registries, Lists, Guest Account Management and Checkout functionalities of the Target.com application

Worked on WebSphere Commerce Server as CMS to test the user data, promo codes and content of website on

WebSphere Message Broker v7.0, service platform to validate transformation of messages

Involved in validating and transforming the formats of user data and shipment notification service codes to MB formats from OMS DB

Involved in testing the fulfillment services using OMS Sterling interface to test the complete order life cycle

Involved in testing the Integration layer involving WebsphereMQ Message Broker using Qpasa and RFHUtil.

Worked on validating EDI files

Created, reviewed and executed manual and automation test scripts of various IL and UI interfaces on HP Quality Center, QTP and Scimitar

Worked on SOAP UI for web service calls to and from Accertify(Fraud management service provider)

Involved in creating Traceability matrix, Test plans, Test reports, Status reports, Root cause analysis reports and Defect reports in the iterative process

Involved in performance testing by preparing Run comparison reports and analyzing various Performance runs on SOASTA Cloud Test

Involved in Continuous Integration testing of the Integration Layer of the application

Sapient Corporation, Bangalore, India Feb 2009 – Mar 2010

.

SonyStyle.com

Client: Sony Electronics

Job Role: Associate Technology L1

Involved in testing the critical modules such as Pricing feed, Inventory feed and configuration testing of CTOs

Performed Database Integrity testing using SQL queries to ensure the data has been populated as intended and all database events occurred properly.

Involved in testing migration of data from WCS6.0 platform to Oracle

Used Omniture site catalyst as web analytics tool to extract, measure, analyze, and optimize integrated data

Worked on WCS and Interwoven Teamsite for web Content Management aiding in creating and publishing content through QA, Staging and Live environments

Created and tested SKUs in QA environment and propagated them to higher environments using UNIX commands

Involved in extensive regression testing and integration testing

Used HP QC as defect and requirement tracking tool and TortiseSVN as version control.

Sapient Corporation, Bangalore, India Jan 2008 – Feb 2009

Walt Disney Parking and Resort Online

Client: Walt Disney

Location: Bangalore, India

Job Role: Associate Technology L1

Created and executed test scripts and logged defects on Quality Centre ensuring quality of the web application in agile environment based on Wireframes, Visual Designs and Functional Specification documents.

Actively learned new process and developed templates for documenting the process, metrics etc.

Involved in pixel testing using Caliper tool and testing media rich UI content of the application that used cascaded style sheets for layout, visual effects and background color on cross browsers and cross platforms

Used SQL aggregate functions to test the data through queries

Participated in creating test plan and traceability matrix

Sapient Corporation, Bangalore, India Jun 2007 – Dec 2007

Trading & Risk management Pilot Project, Client: Sapient

Location: Bangalore, India

Job Role: Trainee Technology

Worked on .Net Smart Client Software Factory as the platform to develop Front office to Back office operations of Stock market system which helps a trader to buy or sell the equities

Participated in gathering requirements and creating Requirement documents

Participated in daily stand up meetings, defect triage meetings and Project management meetings

Reviewed artifacts and CRs and got approvals from clients/SMEs for the estimates

Worked extensively on SQL validation scripts

Also involved in performing unit, functional, regression and user acceptance testing the end to end application

Contact this candidate