Ram

Project:1

Project Name : DCE-WORKFLOW Client : HEWLETT PACKARD ENTERPRISE(HPE) Role : Software Developer Environment : Snowflake, Python, Jira, SQL.

Team Size :5

Duration : FEB 2022 to till date Description: DCE portal will provide the ability to upload AHS files via the web portal or through Chabot experience. InsightIQ reads the kafka topic and read the meta data file from s3 and the status of different fields are updated in S3. Loading the data from s3 files and load them into snowflake using AWS integration and process the data for the Infosight. 2 CONTRIBUTION:

 Bulk loading from the external stage (AWS, S3), internal stage to snowflake cloud using the COPY command.

 Loading data into snowflake tables from the internal stage using snowsql.

 Used SNOW PIPE for continuous data ingestion from the S3 bucket.

 Performed data quality issue analysis using snowsql by building analytical warehouse on snowflake.

 Perform troubleshooting analysis and resolution of critical issues.

 Developed snowflake procedures for executing branching and looping.

Project:2 Project Name : ILO Amplifier Pack Client : HEWLETT PACKARD ENTERPRISE(HPE) Role : Software Developer Environment : Robot Framework, Python, Jira, REST APIs

Team Size : 5

Duration : APR 2021 to JAN 2022 Description: The iLO Amplifier pack is designed for large enterprises and service provider environments, it gives you the power to discover, inventory, and update GEN8/9/10/11 at rapid speed and scale. Vcentre can also managed by connecting to the ILO Amplifier and update on servers performed.

CONTRIBUTION:

⮚ Automation testing using RESTAPIs methods.

⮚ Backend, functional, scale and GUI testing using REST APIs for the tool iLO Amplifier pack

⮚ Setup project lab infrastructure for automation testing.

⮚ Prepare test plan, Test cases and execution according to the feature.

⮚ Discover bugs within the software, identify, isolate and track bugs throughout the testing.

⮚ Worked on various hardware platform like Rack, Tower, Blade, Apollo and synergy servers.

⮚ Involved in data profiling and data wrangling with python.