Data Etl

Sajeesh Sukumaran Email: ***********@*****.***

QA Lead Salesforce Testing/AWS(Amazon Web Service Testing) Phone: 469-***-****

Sajeesh has a total of 13.5 years work experience with 8.5 years with Infosys Limited (for Bank of America /Sun Trust client) and 5 years with S2 IT Group LLC (for COX Automotive –Manheim Client)

Sajeesh holds a B.E (Bachelors of Engineering) Degree in Electronics and Communication Engineering from Anna University – India with an aggregate of 91%

IBM Certified Specialist – Netezza Platform Software v6

Business Analyst and Data warehouse ETL test lead.

AWS Development and testing of various services like Lambda, Glue Job, SNS, S3, Kinesis (creating data streams), Athena, Step functions, Firehose etc and serverless deployment (CI/CD) using yaml file.

Salesforce Application Testing

KEY STRENGTHS:

Selenium Cucumber Automation framework

Salesforce Testing of various components

AWS testing using python, Creating Lamda scripts etc.

SOAP UI Testing for API ( Application Program Interface)

9+ years of experience in Data ware House Testing (good knowledge in both ETL and ELT Testing) and Data Migration Testing and Cross Platform Testing involving complex SQL queries for various database and Strong RDMS knowledge.

Strong experience in Project Management activities involving Project Scheduling, Invoicing via Field Glass and Task allocation via Clarity.

Strong experience on Fact and Dimensional Data modeling and testing of various SCD tables.

Rich experience in Banking and Financial domain (Basel II Compliance) and Credit Risk Management and Mortgage Technology.

Experience in MSTR Report Testing and Informatica /Datastage ETL testing (3 Years) and basic knowledge on QTP and Load Runner.

Hands on experience in UNIX server for checking logs, running jobs in command line, transferring files, checking the logs and reporting the errors if any.

Good experience in Job scheduling tools like Autosys and IBM Tech Director for job execution and monitoring.

Good experience in HP QC for Test management and Agile Testing tools such as JIRA.

Strong experience in Onsite-offshore team model for 8 years and has handled team of 20 members who are geographically distributed.

Have created 20+ test plans for the various database related testing projects detailing the testing approach and strategy.

Have worked in Onsite-Offshore model with team members of size 20 who are geographically distributed.

Have been involved in Micro strategy Report testing and tested around 200+ reports.

Have worked with several databases such as Netezza, Teradata, IBM Info sphere, SQL server and involved in testing complex test scenarios for data migration and data validation.

Worked with various Agile tools such as Rally, Mingle and Version One.

SKILLS SUMMARY:

Domain

Banking and Credit Risk Management, Basel Compliance,

Mortgage, Automobile

Database

SQL Server (2 years)

Teradata (5 Years)

Netezza(3 Years)

Oracle (2 Years)

IBM Info sphere(1 Years)

OS

Windows, Unix

Technologies

Cross Platform Testing, Data Migration Testing involving SQL Queries (ELT and ETL Testing), MSTR Report Testing, End to End Testing

Database Querying Tools

Agility Netezza work bench, Teradata SQL Assistant, Toad for SQL server, System I Navigator (IBM), Squirrel

Unix/Linux Accessing Tools

Putty/SSH Technicia

Performance Testing tool

Load Runner (6 months)

Automation Tool

QTP(6 months), HP- Unified Functional Tester (UFT) (6 months)

Test Management Tool

HP-Quality Center (8 years)

Agile Tool

JIRA ( 1 year),Rally, Version One, Mingle

ETL Testing tools

Informatica (2 year) and Datastage (1 year)

Job Scheduling Tools

Autosys (3 years), IBM data stage Tech Director (1 year)

Project Management Tools

Visio, Clarity, Fieldglass, Microsoft Project Manager

Other tools

FTP, ERWIN data model tool

API Testing

SOAP UI

ETL Tools

Informatica, IDQ (Informatica Data Quality )

AWS services

Glue, s3, Athena, Quicksight, Kinesis, Datapipeline, SNS, SES, Step functions, Lambda,CI/CD

Salesforce

Cases, Opportunities, Contacts, Roles, Profiles, Apex jobs, Integration Testing, Reports

Java

Eclipse Maven for Selenium Automation

VALID VISA:

H1B (April 2021)- i140 Approved.

EDUCATION:

Bachelors of Engineering- Anna University- 2006 pass out

CURRENT LOCATION:

Atlanta- Sandy Springs, Georgia .

EMPLOYER:

S2IT Group LLC limited (5 yrs -Current Employer)- Client- Cox Automotives

Infosys Limited (8.5 Year Experience with Infosys Limited)- Client- Bank of America

REFERENCES:

Vanda Pandey (Sr Scrum Master)- Cox Automotive mobile-404-***-**** (*******.******@**********.***)

Uma Palled ( Sr Manager)- Cox Automotive

(***.******@**********.***)

David Wrobel (Sr Mgr Software Engineering)- Cox Automotive-Manheim

*****.******@**********.*** – mobile – 754-***-****

CERTIFICATIONS:

IBM Certified Specialist - Netezza Platform Software v6

EXPERIENCE

Employer : S2 IT Group LLC

Title : Salesforce Senior Quality Tester

Client : Cox Automotive.

Location : Atlanta, Georgia.

Duration : May2019- April2020.

Project Name & Description:

Inventory Service:

This project involves case creation for various sections of Car inventory such as Client care, Deal Shield, Arbitration, Issue Management, Man-Ex. It also involves salesforce Integration with other systems like OVC, Service now, etc.

Key Responsibilities include:

Creating ‘Cases’ and checking the functionality

Creating new users and assigning them permission sets

Monitoring Apex jobs and checking for the failure

Creating various Salesforce reports

Creating Master and various type of contacts

Creating client accounts

Changing the case layout for various profiles

Validating various Objects, Fields and relationships.

Selenium Automation framework for Testing (identifying Page class, Selector class, runner file, step definition, Pom file)

Worked on Lightening components of salesforce.

Employer : S2 IT Group LLC

Title : AWS developer and tester

Client : Manhiem- Cox Automotive.

Location : Atlanta, Georgia.

Duration : Sep2018- April 2019.

Project Name & Description:

Guaranteed First Bid (GFB) data pulling from source(dynamo db) to S3 and then to redshift.

OVT (Oracle) and OVW (SQL server) tables into S3 and then to redshift.

Start/END api implementation for CADS bucket.

Crawler development for identifying any source column change and report the same via email.

Developing Validation scripts and integrating with the step functions for various ETL load process.

Athena Usage Monitoring using Quicksight Dashboard.

Key Responsibilities include:

Developing python scripts using lambda for various functions (ex: to validate the count between source and target, to get details from API response and store it in table, to connect to dynamo db and get the count etc)

Developing data pipelines using serverless yaml and pipeline groovy script.

Developing step functions to establish a process flow of data via different lambda function.

Designing the basic function model (using lucid chart)

Creating glue jobs for performing pulling of data from source to S3.

Creating tables schema in Athena.

Creating alerts and monitoring logs in cloud watch.

Creating scheduling process in cloud watch to schedule the lambda or step functions.

Creating local environment in cloud9 and deploy the lambda with extra packages from cloud9.

Dashboard creating using Quicksight(using both query and spice database).

Working with Kinesis (for real time data)- to build data streams, data firehose and data analytics for real time projects.

Creating CI/CD (continuous Integration / continuous Deployment) model for various projects using serverless yaml file and pipeline groovy file.

Employer : S2 IT Group LLC

Title : QA Lead

Client : Manhiem- Cox Automotive.

Location : Atlanta, Georgia.

Duration : May2015- Sep2018.

Project Name & Description:

ODS (Operation Data Store) Management:

This project is about the migration of various automotive information from DB2 platform (MSC)to Oracle platform (ODS) and also reporting to customer via API interface on ODS.

Key Responsibilities include:

Requirements Analysis, Test Strategy and Test Plan Preparation for Cross Platform testing.

SQL preparation for Cross Platform ETL Testing (preparing the queries based on the ETL logic given in the mapping document)

Preparation and Testing of various Clean up scripts for removing Bad data in the existing ODS system.

Testing of various new logics for data flow from MSC to ODS.

Testing of various API (Java logic) using SOAP UI testing.

Managing a testing team of 5 members and leading them for successful completion of testing.

Working on Sprint basis and to ensure product deliverables to be completed before each sprint and ready for deployment.

Co-ordination with various teams and helping in testing during production deployment.

Scheduling the task for various stories going for a Sprint.

Testing the front end application developed via IDQ (Informatica Data Quality) by Creating rules and mapping in IDQ tool.

Employer : Infosys Technologies Ltd

Title : ETL Test Lead

Client : SunTrust Bank, Bank of America

Location : Atlanta, Georgia.

Duration : Jan2011-April2015

Project Name & Description:

Infrastructure Testing- This project is about the migration of loan data from various sources such as SQL server, Teradata etc into Oracle environment.

Mortgage Testing- This project is about the Mortgage data processing from various sources (SQL server) and loading into Oracle environment. From Oracle the data is processed to IBM Info sphere and supplied for the down- stream users.

Fit for Purpose Testing- This project is about the data flow in the system is validated for various transformation logics and also the reconciled data in the Teradata and Netezza environment is performed. The migrated and transformed data flows into Micro Strategy reports which are validated for data consistency between the DW and reports.

Key Responsibilities include:

Requirements Analysis, Test Strategy and Test Plan Preparation for Cross Platform testing.

SQL preparation for Cross Platform ETL Testing (preparing the queries based on the ETL logic given in the mapping document)

Working with the various Fact and Dimension tables in the star/snowflake schema and testing the various Surrogate Keys generated as a part of Oracle migration.

Understanding the various relationships between the tables and the business need and framing SQL queries accordingly.

Using Informatica as ETL tool to understand the workflow and test the logic as necessary.

As a Test lead, involved in Test Plan preparation of the various DB testing initiatives.

As a Test lead, involved in effective participation on BRD,HLD and LLD discussion meetings, Test status reporting weekly along with the open defects, involved in defect triage call and following up on the defect resolution.

As a Test lead, involved in Estimation of testing time period for the various sub modules involved in the project.

better understanding of requirements.

Running jobs via IBM Tech Direct for loading IBM info sphere Tables.

Test Data Analysis for covering all scenarios to be tested.

Unix environment preparation for Netezza data load which includes Parameters file setting up etc.

Loading Netezza tables via Autosys jobs and analyze the logs for successful loading.

Fixing the issues if any load failure happens.

Validating the data load from Teradata to Netezza using SQL queries for the ETL logic involved.

Performing ETL testing using Informatica tool for verifying the mapping logic

Performance testing on the reports generated on the Netezza database.

Moving the source files in to the UNIX server and verifying the header and footer of the files for the data validation.

Active participation in Stakeholder Meetings to analyze the needs.

Tested 300+ Microstrategy reports and verified end to end data.

Testing various SCD tables (Slowing Changing Dimension) in Netezza using Lag/lead logic in SQL queries.

Working with the various Dimensional and Fact tables in Teradata and Netezza

Understanding the concept of day0 and day1 loads and framing the ETL queries accordingly to test the same.

Validating the Surrogate Keys and Surrogate IDs generated based on the conditions given.

As a Test lead, involved in Test Plan preparation of the various DB testing initiatives.

As a Test lead, managed a team of 20 Team in Offshore and 2 in Onsite.

As a Test lead, involved in identifying and assigning the tasks to the team members, mentoring the team members regarding the project and managing effective co-ordination between various modules such as Backend Testing and Micro strategy testing.

Employer : Infosys Technologies Ltd

Title : Test Analyst

Project Name : Countrywide, US Trust and LaSalle Migration

Client : Bank of America

Location : Chennai, India.

Duration : Mar2007-Dec2010

Project Description:

This project is about testing data migration of various bank data such as Countrywide, US Trust and LaSalle into Bank of America database. The project involves testing the BASEL II compliance of the data and also other complex requirements testing involving various mapping scenarios.

Key Responsibilities include:

Worked with many merger and acquisition data migration testing projects like Country Wide, LaSalle, US Trust etc.

Preparing Test cases (SQL queries) for complex mapping requirements to test the data flow logic.

Responsible for Estimation, Test Plan Preparation, Test Requirements Analysis, Preparation of Test scripts, Execution of Test cases, Reporting of Test Defects (Track open defects to closure), Onsite co-ordination and Participating in reviews.

Involved in Micro Strategy Report testing and Informatica ETL testing. Loading the database using workflow and checking the issue log.

Co ordination with the Dev team to resolve load issues and active participation in the defect Triage call.

Understanding and working with the Dimensional and fact tables in Teradata.

Verifying the referential integrity for the various tables depending on the mapping logic.

Creating test cases as per the ETL logic in the mapping doc and executing the same.

TRAINING EXPERIENCE

Employer : Infosys Technologies

Duration : Oct2006-Mar2007

Location : Mysore, Karnataka

Extensive training in Mainframe, COBOL, CICS, JCL and DB2.

Extensive training in Agile Methodology, Waterfall Model.

Contact this candidate