●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
Ab initio GDE (126.96.36.199,3.3.5), Co>Op (188.8.131.52,184.108.40.206)
Teradata, Oracle 10g/11g, MySQL, SQL Server 2008, DB2, Snowflake
QTP 9.0/9.5/10.0/11.0, Quality Center 8.2/9.0/9.5/10.0, SOAP, SOASTA, Schimitar
Windows XP/2000/NT, Linux, Mac OS
VB Scripts, Shell scripting, Python (Basic)
TortoiseSVN, CVS, Basecamp, GitHub, EME (Enterprise Metadata Environment)
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
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
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
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