SUMMARY

• 11+ years of experience working in various domains and serving UK, Europe, and US customers by delivering IT services and meeting their business related expectations.
• Experience creating and revieweing the Business Requirement documents (BRD’s), Functional Requirement documets (FRD’s), System Requirements Specification (SRF’s), and ETL Mapping documents.
• Rich experience in doing Data analysis, profiling, Pruning, and finding the data insights and ability to present this in understandable format to the business customers and Data Scientists.
• Experience working in Agile Methodologies (Sprint planning, review, retrospective meeting, User Story creation, Story point estimation, Backlog planning, Daily Scrum standup meeting, Creating Backlog,Velocity, Burndown chart reporting).
• Experience working in Bigdata Hadoop technologies (Hadoop Cloud Architecture - HDFS, MapReduce, HiveQL, Pig, Sqoop, Spark, and Hbase eco system tools) including ETL Dataware house concepts.
• Hands on experience using complex SQL queries(DDL, DML, All type of table joins, All analytical functions, All aggregate functions, etc), PLSQL programming languages (Procedures, Functions, Triggers, Cursors, Exception handeling).
• Experience working on Unix commands including shell scripting for creating and executing the shell jobs.
• Experience working on backend tools such as Oracle, SQL server, Teradata, Cassandra, and Hive databases.
• Experience in Database server (SQL server 2000 and 2014) configuration assessment and Memory storage requirements for DataMigration projects.
• Experience in estimating the project efforts in PD’s for complex and large projects in all the project stages (SG0, SG1, SG2).
• Experience working in Insurance, Healthcare, BFS - core banking,Retail, and Life Sciences domain.
• Having rich experience working on JIRA / Github/ Jenkins/ HPALM/ SQUIDS tools.
• Experience managing all the project Test phases (Requirement gathering, project estimation, Test Plan and Test Stretagy creation, Test Design, Test Environment Setup,Test Data Management, Test Execution, Deriving Defect Triage call on daily basis with other stakeholders, Test Reporting, UAT, and Pre-production and Post production support and Testinng).
• Experience working with iBrowse automation tool for verifying the applications (Web and Desktop) compatibility on multiple browsers.
• Aclaimed recognitions for developing ETL automation tool using PL/SQL and Project Estimation template using Visual Basic for Applications (VBA).
• Experience managing the project team and work together with the team to achieve cohesive project goal.
• Highly dedicated, self motivated, hardworking, and a believer in a cohesive team effort for achieving the overall project objective.
• Having excellent communication and presentation skills with ability of strong problem solving.

TECHNICAL SKILLS

Programming Languages: Core Java (1.8),Spring Boot 2.0, C, Python, and VBA for excel.

Life Sciences Applications: eTrack and eLNB

Database: Oracle, SQL Server 2000,2008, and 2014, TERADATA, Cassandra,MongoDB, Microsoft CosmosDB.

Operating System: Windows 7/2000/XP and UNIX (HP-UX)

Reporting Tool: IBM Cognos Framework, Tableau

Data Integration Tools: Informatica 9.1.0, Talend 6.4.1, and Datastage IBM Infosphere 8.5

Testing tools: OneLeo Automation framework(Cucumber API), HPALM, JIRA, SQUIDS.

Webservices: Microsoft Azure (Logic Apps), - services, SAG Technolgy (File management and MFTP transfer events)

Office Automation Tools: Outlook, Word, Excel, PowerPoint

Modeling and Data Integration Tools: MongoDB, Derby Database, NoSQL DB, BigData Hadoop framework (HDFS), MapReduce, HiveQL, Pig, Spark, Sqoop, Hbase), AnyLogic 8 University 8.1.0

PROFESSIONAL EXPERIENCE

Senior Test Architect

Confidential

Responsibilities:

• Actively involved in understanding the critical business requirements for insurance domain and providing valuable input and suggestions to the business after consulting with other stakeholders.
• Analyse the requirements (FRD, BRD, NFR, etc) and provide ball park and final project test estimations for project manager review.
• Experience creating and reviewing requirements documents - Business, Functional, System and ETL mapping documents along with developing the business rules.
• Having rich experience working and designing the dataware house using DW concepts (Fact and Dimension tables, multi-dimensional schema’s such as Star, Snowflakes, and Fact constellation, SCD types 1,2, and 3) and extensive experience on BI reporting tools such as IBM cognos framework.
• Prepare Master Test Plan (MTP) and Detail test plan and share with project manager for review.
• Creating Test Stretagy to test e2e data flow and data accuracy.
• Supporting test manager for his stretagic goal for the team to enable test processes,tool, and technology.
• Arrange cross functional training sessions within the team to bring the team member upto the pace for their maximum utilization and productivity.
• Enabling tools and technology for their maximum usage in test automation.
• Proficient in designing efficient and ETL workflows to capture and process the ETL business functionality.
• Experience in gathering and processing raw data at large scale by writing scripts, SQL queries, and webscapping techniques.
• Experience in reviewing the test cases,Tracebility matrix created by the team to ensure that all requirements are covered under the test cases.
• Involved in the discussions with the BA’s, business users to clarify the gaps in requirements, ambiguities, scope change if any.
• Reviewed test execution results done by the team before giving signoff for UAT testing to business users.
• Derive defect triage call everyday (During test execution) with other stakeholders (Testing, Development,DBA, other corresponding teams).
• Creating Test Outcome Report (TOR) for e2e ETL dataware house testing performed.
• Having expertise in using Unix (HP-UX) commands and shell scripting techniques data processing.
• Actively involved in data cleansing and pruning the data inorder to remove redundancy and duplicacy of the data.
• Actively involved in data profiling and data analysis using SQL and also involved in data scrapping and maintaining the data quality.
• Worked and Managed in highly stressful situations and delivered the things within the defined timelines.
• Prudently lead and manage the things with less supervision and accomplish the tasks with my own with the support of the wonderful team.
• Good at preparing the presentations and presenting the meaningful insights of the data.

Tools: & Technology: IBM Infoshere Datastage 11.5, DB2 database, Unix, IBM Tivoli workload scheduler (TWS), BigData Hadoop HDFS, Hive,Sqoop, and Spark 2.4.4 framework

Confidential

Senior Test Architect - Automation

Responsibilities:

• Actively involved in understanding the critical business requirements for insurance domain and providing valuable input and suggestions to the business after consulting with other stakeholders.
• Analyse the requirements (FRD, BRD, NFR, etc) and provide ball park and final project test estimations for project manager review.
• Experience creating and reviewing requirements documents - Business, Functional, System and ETL mapping documents along with developing the business rules.
• Having rich experience working and designing the dataware house using DW concepts (Fact and Dimension tables, multi-dimensional schema’s such as Star, Snowflakes, and Fact constellation, SCD types 1,2, and 3) and extensive experience on BI reporting tools such as IBM cognos framework.
• Prepare Master Test Plan (MTP) and Detail test plan and share with project manager for review.
• Creating Test Stretagy to test e2e data flow and data accuracy.
• Supporting test manager for his stretagic goal for the team to enable test processes,tool, and technology.
• Arrange cross functional training sessions within the team to bring the team member upto the pace for their maximum utilization and productivity.
• Enabling tools and technology for their maximum usage in test automation.
• Proficient in designing efficient and ETL workflows to capture and process the ETL business functionality.
• Experience in gathering and processing raw data at large scale by writing scripts, SQL queries, and webscapping techniques.
• Experience in reviewing the test cases,Tracebility matrix created by the team to ensure that all requirements are covered under the test cases.
• Involved in the discussions with the BA’s, business users to clarify the gaps in requirements, ambiguities, scope change if any.
• Used kafka environment as a source for ETL jobs to consume data (Kafka events, Topics) and publish into EDW after necessary business tansfromations in staging layer ( services - Minions, Talend jobs, etc).
• Used OneLeo automation framework (Cucumber API) to automate the ETL flow and validate the data flow.
• Used HiveQL to process the data on Hive server using Hive Thrift client UI.
• Worked on MongoDB to store and manage the metadata information for business objects.
• Reviewed test execution results done by the team before giving signoff for UAT testing to business users.
• Derive defect triage call everyday (During test execution) with other stakeholders (Testing, Development,DBA, other corresponding teams).
• Creating Test Outcome Report (TOR) for e2e ETL dataware house testing performed.
• Having expertise in using Unix (HP-UX) commands and shell scripting techniques data processing.
• Actively involved in data cleansing and pruning the data inorder to remove redundancy and duplicacy of the data.
• Actively involved in data profiling and data analysis using SQL, Pythan, and Bigdata hadoop technologies and also involved in data scrapping and maintaining the data quality.
• Worked and Managed in highly stressful situations and delivered the things within the defined timelines.
• Prudently lead and manage the things with less supervision and accomplish the tasks with my own with the support of the wonderful team.
• Good at preparing the presentations and presenting the meaningful insights of the data.
• Supported business and management with clear and insightful analysis of data including mining activities (Including data auditing, aggregation, validation, and reconciliation), advance modeling techniques (Agent Based Modeling using Anylogic modeling and simulation tool), testing and creating and explaining results in clear and concise reports.

Tools: & Technology: MongoDB,Derby database, NoSQL DB,Dot Net (.Netframework),C#,Oracle, TERADATA, Cassandra,Microsoft Cosmos DB, Bigdata Hadoop Framework (HDFS, MapReduce), HiveQL, Spark 2.4.4, Pig, Sqoop, HDFS, MapReduce, Kafka environment, ETL informatica, Talend 6.4.1, and BI (IBM Cognos framework) tool, OneLeo cucumber/Selenium automation framework, Talend ETL automation tool.

Confidential

Senior Test Architect-BigData Hadoop Systems

Responsibilities:

• Actively involved in understanding the critical business requirements for retail banking domain and providing valuable input and suggestions to the business after consulting with other stakeholders.
• Involved from acquiring massive amount of data, analyze, and summarise the necessary findings and translated those into a understandable document.
• Supporting Test Manager for the test processes enablement and improvement. Also worked closely with TM in order to achieve testing milestones and deliveries.
• Help team members to address any issue/doubts and maintain proper communication with no conflicts.
• Actively involved in data profiling and data analysis using SQL, Pythan, and Bigdata hadoop technologies and also involved in data scrapping and maintaining the data quality.
• Involved in creating and reviewing functional ETL mapping documents for source and target and also responsible for developing the transformation logic between source and target as per the business requirements.
• Worked and managed in highly stressful situations and achieved the milestones within the defined timelines.
• Actively involved in data cleansing and pruning the data inorder to remove redundancy and duplicacy of the data.
• Prudently lead and manage the things with less supervision of my supervisors and accomplish the tasks with my own.
• Performed ETL automation using Cucumber/Selenium OneLeo framework to validate source and target systems data.
• Good at preparing the presentations and presenting the meaningful insights of the data.
• Supported business and management with clear and insightful analysis of data including mining activities (Including data auditing, aggregation, validation, and reconciliation), advance modeling techniques (Agent Based Modeling using Anylogic modeling and simulation tool), testing and creating and explaining results in clear and concise reports.
• Having rich experience working and designing the dataware house using DW concepts (Fact and Dimension tables, multi-dimensional schema’s such as Star, Snowflakes, and Fact constellation, SCD types 1,2, and 3) and extensive experience on BI reporting tools such as IBM cognos framework.
• Proficient in designing efficient and ETL workflows to capture and execute the ETL business functionality.
• Experience in gathering and processing raw data at large scale by writing scripts, SQL queries, and webscapping techniques.
• Used Bigdata cloud as a deployement and SaaS as a service model for analyzing, faster processing of data, and easy to maintain the integrated environment.
• Having sound practical experience working on real time projects using Unix (HP-UX) shell scripting to analyse, process, and finding the insight of the data.

Environment: Dot Net (.Netframework),C#,Cucumber/Selenium OneLeo Automation framework,SQL server 2000, 2008, and 2014, Cassandra, Teradata, Bigdata Hadoop Framework (HDFS, MapReduce), HiveQL, Pig, Sqoop, MongoDB,Hbase, Kafka environment, ETL Datastage Data Integration and BI (IBM Cognos framework), Talend 6.4.1 Data integration tool.