SUMMARY

• He has been working in the Information Technology Industry for 15 years, primarily involved in analytical and technical capacities in the Estimation, Data Analysis
• Test Strategy, Test Planning, Data Validation, Test Solution for Azure Data Lake Web HDFS Big Data on cloud, ETL Test Design
• Execution and Support phases of Big Data and Data Warehousing Implementation Projects for Insurance, Travel & Hospitality, Investment Banking - Basel II, Retail and Sales domain. He has good knowledge on data validation in Cassandra, Hive, Spark, Oracle SQL
• Teradata QL, Data Stage, Snowflake Analytical data warehouse, Spotfire, tableau and UNIX.
• He has extensive experience in leading & managing the team, analyzing the requirements of project and understanding the efforts needed, defining the Strategy and develop the test plan for the tasks and well in DB script development. He has good knowledge of Big Data concepts, Hive and Hadoop Architecture understanding.
• He has managed and accomplished various projects performing End to End ETL testing, Hadoop / Hive and Cassandra No SQL DB testing and Azure Big Data Web HDFS test solutions on Azure Cloud for major leading clients.
• He has identified test automation quality across all disciplines, providing guidance, feedback, and suggestions to improve test automation practices.
• He has experience in QA Waterfall, Agile testing with good knowledge of agile life cycle(Scrum and Kanban)
• He has also experience in creating ETL test plan, preparing ETL test scenarios, execution of test cases, defect tracking and reporting.
• Experience in onshore co-ordination for multiple projects with offshore team.
• Strong in DWBI, SQL fundamentals.
• Certification- Orchestrating Big Data with Azure Data Factory.
• Trained and exposure to Core Java programming basics.
• Involved in large-scale business critical DW/BI Testing projects with the strong exposure to process and Methodology.
• Involved in preparing and review of test case documents and its executions.
• Good Understanding of OLTP (ER Modeling), Dimensional Modeling.
• Learnt project management skills coupled with a supportive technical background and have extensive experience in onsite/offshore co-ordination.
• Strong Analysis skills, excellent verbal and written communication skills.
• He has played multiple roles as software engineer, ETL test lead, ETL/BI project lead, Manager projects - ETL/Big Data testing and served in multiple organizations including product and consulting companies.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Databases/NoSQL DB: Oracle 8i, 9i, 10g, 11g, Teradata14.x, Cassandra

ETL/Orchestration tools: Azure Data Engineering - ADF, Azure SQL (DB+DW), Data Stage

Analytics: Azure data & analytics basics - Azure Cloud Platform, Azure Storage, Azure Data Lake + Analytics

Programming Languages: SQL, Core Java, Hive Query language, Spark SQL basics

Development/Reporting Tools: Tableau, Microstrategy’s Web cloud 10.4,Cognos 10.2.2, Spotfire

Automation: Self developed SQL for C++ transformation files, reconciliation logic implementation for full data validation, suggested inputs to team to develop Scala Spark SQL automation for data validation

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Long turnaround time for report generation and availability
• More user steps in creating and receiving reports
• Minimal flexibility in data selection
• Less user friendly report formats
• In the current system, the reports are not real time .Report request is placed through the application by selecting the parameters and report is generated with a scheduler and made available.
• The current reporting systems have been built with around report specific Oracle stored procedures for each report. All the data processing logic is present in the stored procs which are executed on run time when the report is being generated. The report generation therefore is slow as the Oracle stored procs take long time to generate.

Confidential

Responsibilities:

• The Confidential Group is a leading wholesale provider of reinsurance, insurance and other insurance-based forms of risk transfer. Dealing directly and working through brokers, its global client base consists of insurance companies, mid-to-large-sized corporations and public sector clients.
• Key Objective: Build a modular platform to enable rapid speed to market and self-service capability. Existing -Interfaces are distributor specific and have multiple versions for each distributor. Every customization has vendor dependencies, with impacts to timeline and cost. Data transfers among various systems are not fully automated. The majority of interfaces are not optimized for consistency.Too much vendor-owned intellectual property.
• Future: Provide a gateway for interfacing with external and internal applications Minimize dependency on vendors to do customizations, including quicker business transformations enable microservices, Rest API, real time and near real time calls with data governance capabilities. Increase speed and agility in being able to adapt to changes in the market and future technology standards.

Confidential

ETL Project test Lead

Responsibilities:

• Lead and mentored the team and made sure we are on track with any tasks assigned.
• Reviewed test plan for the overall testing strategy for Phase1 reporting-Reports/Dashboards.
• Monitored progress of the project in line with the business vision.
• Ensured adequate testing is planned and coordinate/help the execution of test cycles are per plan.
• Prepared common template to validate the grid reports against the benchmark data provided by business.
• Analyzed various reports/Dashboards generated in Microstrategy.
• Also have involved/helped in test cases and captured the logs for the test cases with suitable data.
• Providing status/ Technical discussion on daily onsite/offshore calls.
• Mentoring the team on technical hurdles/identifying scenarios whenever required.
• Defects tracking in HPLAM.

Confidential

Project Lead

Responsibilities:

• Prepared test plan for the overall testing strategy for various Line of Business (Phase1 and phase 2), discussed the same with stakeholders offshore and onsite.
• Monitored progress of the project in line with the business vision.
• Ensured adequate testing is planned and coordinate/help the execution of test cycles are per plan.
• Identified test automation quality across all disciplines, providing guidance, feedback, and suggestions to improve test automation practices
• Analyzed various reports generated by Spotfire.
• Also have involved/helped in test cases and captured the logs for the test cases with suitable data.
• Reviewed SQL queries /test scenarios/test data and involved in writing complex SQL queries for Data validations.
• Providing status/ Technical discussion on daily onsite/offshore calls.
• Mentoring the team on technical hurdles/identifying scenarios whenever required.
• Review Validation of data s in target tables and single point of contact between Dev - having 25 members and QA size of 6 members.
• Worked with Datastage Director for trouble shooting the Datastage jobs by understanding the events in job log views.
• Running, monitoring of the jobs using Data Stage Director and checking logs.

Confidential

ETL Test lead

Responsibilities:

• Prepared test plan for the overall testing strategy for Avis and Budget Loyalty program.
• Monitored progress of the project in line with the business vision.
• Ensured adequate testing is planned and coordinate/help the execution of test cycles are per plan.
• Prepared complex SQL queries for testing the business transformation rules. Automated some of the process in Excel.
• Automated most of the process for the complex source files C++ transformed, which drastically reduced the testing effort in completing the recurring, SIT iterations.
• Identified the gaps in requirement and provided feedback on the mappings documents, improved the project control process and made the system more process oriented rather than manual oriented.
• Defect management till closure