Having 14+ years of Experience as a Technocrat, in Testing Bigdata & Analytics and ETL / BI / MDM/TDM/TCOE with having expertise in Planning, strategist and delivering S/W test activities for Big Data Analytics, DWH, BI applications. Worked as part of Data TCOE from past 5 years.
Extensively more than 8 Years in Core Big Data Analytics and Data Science with Analytical Models Platforms. MDM applications, Test Data Management.
Currently Part of Data Testing Center Of Excellence [TCOE] involved in various activities like RFP's, RFI's with solution preparation, efforts estimation. Lead the Automation Accelerators building and design team and involved many successful automation implementation across complex data platforms like AWS, Azure, Hadoop data platform.
Experience on working on Test Discovery phase, Transitions for medium to large programs
Handled escalations to address and resolve various technical challenges.
Actively supported on Hiring process technically and managerial discussions in bringing the required skilled resources
Helped in data testers in up skilling
Worked as Strategic leadership role in test design, execution and providing key project deliverable. Mentored and trained the team on methodologies, tools, and techniques.
Extensive experience in coordinating the overall test activities with onshore-offshore model along with Agile/hybrid scrum models Expertise in proving the end to end testing solution with automation approaches for entire testing journey with ETL/DWH and bigdata platforms.
Title : Customer Relationship Management 360
Client : Can’t be disclosed due to NDA signed.
Role : Bigdata /Analytics test lead
Duration : Dec 2016 Till date
Project Environment : Clouderas open-source Hadoop framework.
Description :
Current scope of the project is to help in designing and developing the
Customer relationship with 360 degree model for the existing entire enterprise business spread across world and to bring
the entire vendors data into virtual single customer hub with MDM process to maintain the each customer’ s unique golden single
source of truth making this 360 model as near real time to get the campaign sources with SFMC real time integration. Also Analytics
being built on top this model will be used by business analytics team to evolve analytical strategies helping to take business decisions
with more appropriately from the management.
Roles & Responsibilities:
Analyzed the business requirements and design specification along with the Hadoop framework design.
Actively involved in the sprint planning, discussion and scrum meetings along with team being led by scrum master.
Understanding the requirements from the business owners who are responsible for prioritizing the backlog’s in the scrum
meetings for each sprint.
Carried out discussion with individual developer on the work items assigned respectively.
Upon having sufficient details, Use to start convert them into scenarios and their by authoring the test cases and executing the
same in the stage box.
Involved in the testing of the individual Hadoop jobs and captured the statistics to the team for further tune to reduce the
turnaround time to load the data.
Make sure testing of the individual script/jobs are executed successfully and then verifying the data.
Led the reporting team to ensure the validations are accurately tested as per the business req’s.
Supported the test managers to provide inputs as an when required about the test execution status.
Title : Adobe Audience Manager and MDP (Massive Data Processing)
Client : Adobe Internal team.
Role : Bigdata/Hadoop test engineer
Duration : Dec 2014 till date
Project Environment : Cloudera's open-source Apache Hadoop distribution, CDH.HUE GUI
Description: AAM and MDP projects have both Hadoop tracks where the massive data will be extracted from various Adobe source
systems and loaded into the warehouse using Hadoop jobs. This data sets loaded will be used for analytics purpose.
Roles & Responsibilities:
Analyzed the business requirements and design specification along with the Hadoop framework design.
Successfully completed training on the Cloudera’s Hadoop 1 developer track to get into the big data world.
Understood the Hadoop ecossytem like MapReducing programming model, HDFS, HBASE and hive, sqoop and pig.
Actively involved in the sprint planning, discussion and scrum meetings along with team being led by scrum master.
Understanding the requirements from the business owners who are responsible for prioritizing the backlog’s in the scrum
meetings for each sprint.
Carried out discussion with individual developer on the work items assigned respectively.
Upon having sufficient details, Use to start convert them into scenarios and their by authoring the test cases and executing the
same in the stage box.
Involved in the performance testing of the individual Hadoop jobs and captured the statistics to the team for further tune to
reduce the turnaround time to and the data.
Make sure testing of the individual script/jobs are executed successfully and then verifying the data.
Perform end to end testing between source stage and target DWH.
Tested the Predictive modeling and churn model.
Verify the MR is not consuming the system memory by keep monitoring the Job tracker as well as task tracker.
After the test cases execution completes then upload the proofs to JIRA.
Title : Customer service solution Xbox
Client : Microsoft Corporation Redmond, USA.
Role : Sr.BI test engineer
Duration : Oct 2011- Nov2012.
Project Environment : MSBI BI suite, SQL server 2008 R2.
Description: The Xbox is the video game console produced by Microsoft. It is integrated Xbox Live service that allows players to
compete online, download arcade games, game demos, trailers, TV shows, music and movies and its Windows Media Center
multimedia capabilities.
Roles & Responsibilities:
Involved in the discussion of the requirements and the functional requirements with business owners.
Involved in the discussion of preparing the test plan and strategy to be carried out for this test cycle.
Prepared the common verification check list for the QA team.
Participated in the day to day scrum calls to update the status of the test activities along with the test team.
After the assigning the work items to individual QA to test in the sprint cycle, Involved in the technical discussion with associated
developer to understand low level design of the code.
Authored the test case based scenarios found out of the tech discussion and get it reviewed by team members with each other.
Performed the unit testing, and integration testing along with end to end testing the ETL flow.
Prepared the temp test tables and the data wherever necessary to achieve test results wherever challenges in bringing the real
data quickly.
Copied the required proofs and documents in the common version control location in the remote system.
-
Title : Master Data Management Center(MDM)
Client : Blue Stem Brands USA.
Role : BI test engineer
Duration : Dec 2012- May 2013.
Project Environment : MDM Center, SQL server 2008 R2.
Worked at client location Riversand Global Technologies Ltd, Bangalore.
Description: MDM center is the Master data and product information suite, which Provides data management diversified services
for Retail, manufacturing, healthcare and Energy sectors. The main goal of this MDM product is “Right content, Right place, Right
time.Precisely single Version of the Truth' using an Enterprise Product Information (PIM) Solution.
Roles & Responsibilities:
Studied the business requirements and design specifications along the training in MDM domain.
Prepared the test plan and test strategy specifically for the migration process apart from the Functional plan as common to MDM
application.
Prepared the migration plan checklists and prepared the verification test cases to make sure migration is successful as per the
design specification.
Carried out performance testing with appropriate bench marks recorded at each level of the migration process and shared the
statistics captured to the management.
Tested the data is correctly landed to the new target system and also verified the new changes are also incorporated as per the
requirements.
Title : Stream Datawarehouse management
Client : Stream Global Services USA
Role : Software Associate
Duration : Apr2011 to Aug 2011.
Project Environment : Pentaho BI suite 4.1.2, SQL server 2008, SQL
Description: The main requirement is to build a standard for Stream call center database so as to perform the
efficient decision making which will be helpful to predict future business decisions.
Roles & Responsibilities:
Analyzed the requirements and the functional requirements of the DWH.
Involved in the discussion of preparing the test plan and strategy to be carried out for this test cycle.
Attended the training on the Pentaho tool to start working on this new project.
Involved in the preparation of the test matrix and necessary project testing check list documents.
Handled the deploying the test builds for individual sprints along with the team members.
Performed the test activities starting from the execution of the test cases, capturing the test results for proofs of testing and filling
the details in the JIRA.
Performed the Unit, System and integration testing to make sure End to end test scenarios are covered till the data loaded from
source to target warehouse.
Tested the ETL/DHW functionalities like SCD, transformation rules applied as per the requirements and also tested the data
quality and accuracy.
Provided the necessary documents to prod team and support team.
Title : QBE Insurance Migration.
Client : QBE Leadenhall, London
Role : Test Associate. Consultant
Duration : Aug2010 to Dec 2010.
Project Environment : Ascential Datastage 7.5, Oracle 9i, UNIX.
Description: This project mainly carried out to migrating the data from various legacy systems located in more than 20 countries
worldwide from various heterogeneous database’s to move into target system and there by maintaining a common data warehouse
with a flexible architecture so as to have the reliable decision making strategies with analysis of the data in future.
Roles & Responsibilities:
Understand the requirements and old and new functional data models to be migrated.
Participated in the technical discussion along with the development team to materialize the activities of this project with Low level
design perspective.
Based on the requirements and scenarios covered in the test plan, prepared test cases along with the team members.
Executed the test cases to cover complete test cases of the module assigned.
Prepared the test results and stored in the repository and provided the necessary documentation and details in the JIRA.
Monitored the job execution to make sure job is running and data loading is happening accurately in the test suite until roll out to
prod environment.
Project #8
Title : Flexcube core banking migration (3rd Phase)
Client : Canara Bank Bangalore
Duration : Apr 2009 to June 2010
Role : Associate consultant
Project Environment : Ascential Datastage 7.5, Oracle 10g, Windows.
Description: This project mainly carried out to migrating the existing (remaining non-core) bank branches which are not in the
network of flexcube’s core banking service and maintaining data warehouse of bank’s transactions, customers records for future
analysis.
Roles & Responsibilities:
Analyzed the requirements and understood the functional flow of the migration process.
Involved in the discussion of preparing the test plan and strategy to be carried out for this assignment.
After the requirement finalized, stated planning the test activities based on the scenarios.
Followed the test matrix to make sure all the scenarios are covered as planned previously.
Understood the ETL process and its flow to test the each phase while migrating to the warehouse.
After the test cases are review then started the execution of the test cases and recorded the
results from test suite.
Unit test done to make sure cross check the smoke test is done to make sure initial content is enough to continue our testing.
Followed with the developers whenever defects and bugs are raised.
Retested after bugs/defects are fixed with complete steps.
Title : FCC 5 (CITI_FX_MM_WORKFLOW5.2_LOT1—LOT3)
Client : CITI GROUP, London
Project Environment : SQL & PL/SQL, Oracle Developer Suit 2000, Oracle 9i.
Duration : Nov 2007 to Mar 2009
Role : Associate consultant
Description: This project mainly carried out to enhance the existing FLEXCUBE core banking system in CITI GROUP LONDON and
also to upgrading the database from 9i to 10G application server. The main enhances are made in FX (Foreign Exchange) And MM
(Money Market) modules to meet the present world banking standards.
Roles & Responsibilities:
Understand the requirements and old and new functional data models to be migrated.
Participated in the technical discussion along with the development team to materialize the activities of this project with Low level
design perspective.
Based on the requirements and scenarios covered in the test plan, prepared test cases along with the team members.
Reviewed by the team peers the test cases which I prepared.
Executed the test steps and queries as part of our unit /integration test activities in the test environment and captured the proofs
for the same as appropriate.
Whenever bugs are found, same is mentioned with steps to reproduce in the QC and informed through the test tool to the dev
team.
Test execution report use to send to the team as on daily bases.
Documented necessary activities and content for future reference for the team.
Technical Skills Summary
undefined