Yaswanth Kumar CH
Data Engineer
Bengaluru,Karnataka
Summary
An IT experience in Big Data Hadoop and Business analysis who has experience around 13+ year's professional experience, out of which 9+ years in Hadoop with expertise in Hadoop and its components like HDFS, MapReduce, Hive, Impala, Pig, Sqoop, Oozie, Python, Spark. Demonstrates strong analytical, communication, and teamwork skills, with proven ability to quickly adapt to new environments. Eager to contribute to team success and further develop professional skills. Brings positive attitude and commitment to continuous learning and growth.
Overview
1
1
Language
14
14
years of professional experience
Work History
Tech Lead
Relevance Lab
Bangalore
01.2014 - Current
- Currently working as a Lead Developer in RELEVANCE LAB Pvt. Ltd
- Project Name: First Citizen Bank – Unified Release Management – Build & Deployments
- Technologies Used: Azdo - repository, DB visualizer, Mobaxterm & IBM DataStage client
- Description: This DevOps platform delivers end-to-end backend enablement for banking systems, supporting the design, development, and deployment of new features across newly established PODs. It also oversees defect management, production support, and scheduled IBM DataStage ETL refresh cycles on a monthly and quarterly basis to ensure data integrity and system stability.
- Responsibility: Managed creation and configuration of IBM DataStage projects using the Admin Client in Development environments.
- Performed end-to-end deployment of IBM DataStage jobs, Control-M parameter files, and Unix scripts across QA, UAT, and Production environments.
- Utilized Azure DevOps for pull request validation, CI/CD artifact generation, and manual deployments to DataStage environments.
- Executed Netezza database refresh activities, maintaining environment consistency and enabling effective QA/UAT testing.
- Created and managed request items for database refreshes and environment support activities.
- Raised and maintained Change Requests (CRs) for Production deployments in compliance with organizational release management processes.
- Coordinated with Development, QA, Infrastructure, and Release Management teams, facilitating smooth deployment cycles and minimizing downtime.
- Monitored release schedules, proactively resolved deployment issues, and ensured adherence to implementation timelines.
- Worked extensively across SDLC phases including development support, deployment, environment management, and production support.
- Project Name: Scholastic EDL - Oracle Financial & Procurement Enhancements
- Technologies Used: Hadoop Components, Rest API's, Apache Tomcat Server, Hive, MySQL, Oozie, Impala, Python, Linux, S3 Storage, SSO
- Description: This is a book manufacturing company want to analyze the month end report for no of titles sold & free coupons provided, revenue analysis across multiple regions. There are many reports created to reconcile the transactions from Hadoop and Oracle fusion.
- Responsibility: Involved in extracting data from oracle containers to Hadoop HDFS by using REST API's.
- Worked on creating Hive & Impala external tables based on the requirement.
- Implemented Partitioning and Bucketing on Hive & Impala tables for better performance.
- Worked on various file formats like Parquet, XML and txt files.
- Used Spark to process the XML data and to run on Spark engine.
- Experienced in handling large datasets using Partitions, buckets in-memory capabilities, Effective efficient joins, Transformations and other during ingestion process itself.
- Worked on Oozie to develop workflows to automate ETL data pipeline.
- Configured Oozie workflow to run multiple jobs which run independently with time and data availability.
- Managed data in HDFS and processed incoming data from Oracle containers.
- Create and manage the reports in visualization tool.
- Facilitated user access by assigning specific roles and permissions for individual reports.
- Tracked and analyzed requests on Tomcat Server to maintain application efficiency.
- Test and promote the newly developed features to application server.
- Project Name: CASSA
- Technologies Used: Sqoop, Hive, PySpark, Impala, Python, JAVA, Apache Tomcat server, MySQL, O-Auth
- Description: CASSA is abbreviated as Compound And Supply Study Analysis, As business looking the clinical trials of drugs on various studies across the globe. Based on clinical trials trying to plan the inventory on multiple compounds. The reports business track through the Compound related Studies, inventory, Supply & demand of orders, tracking the medical kits on sites, Patients enrollment and phase details, Wastage of drugs that are expired at sites. Business use this analysis to plan the future inventory & based on orders. Extraction of data consumed at 4 different locations and stored in HADOOP EDL. Performed various queries in hive/Impala to get the desired information and later used visualization tool for displaying Graphs and Reports.
- Responsibility: Written SQOOP/Python script to import the required table data to HDFS for further processing
- Load Data to External/Managed tables by using Hive/Impala/Java programing
- Analyzing data using Hive/Impala queries
- Created final tables which stored processed data which was further used by BI Tools to create dashboards
- Project Name: Forecast Accuracy
- Technologies Used: Sqoop, Impala, Oozie, Tableau
- Description: The objective of the project is validate the actual vs expected forecast quantity in legs, each leg calculate as quarter. Business users use the data in Tableau to view the calculated formulas.
- Responsibility: Written SQOOP to import the required table data to HDFS for further processing
- Configure the tableau data source and updated the existing calculated formulas.
- Project Name: Evidence Search
- Technologies Used: JAVA, AD Group, Apache Solr, OCR
- Database Used: PostgreSQL
- Description: Search engine is configured using Apache solr, all the Docx, ppts, pdf files to able to search in application. User can be able to filter the documents based on keyword mentioned in metadata. Document data extracted through XML metadata from Veeva Vault.
- Key Responsibilities: Validate the document meta data in search engine using search & Advanced search options.
- Validate the search results metadata information against Veeva Vault source.
- To create functional and performance documents.
- Responsible for documenting Test Strategy and Test Plan Documents based on functional understanding of the product, Functional Specifications and Change Order documents
- Manage the reports and provide access at admin module.
- Project Name: OR Insight App
- Clients: Johnson & Johnson
- Technologies Used: iOS, JAVA, HP ALM Tool
- Database Used: PostgreSQL
- Description: OR APP is a iOS based application, user can download the application either in mobile/iPad to access the patient details. Doctors can add the operation details and select the Operation Room surgery cases. Users can be able to select the individual case instrument add to a list. Business users can be able to record the operation time to start/Stop the timer to submit the case. Saved cases are stored in DB and view the updated notifications in device.
- Key Responsibilities: Record the requirements and Test cases in HP ALM
- Perform the iPhone/iPad device test
- Interaction with clients in meetings to understand their requirements and issues
- To create functional and performance documents.
- Responsible for documenting Test Strategy and Test Plan Documents based on functional understanding of the product, Functional Specifications and Change Order documents
Associate Software Engineer
Store Simple Pvt Ltd
Bangalore
11.2012 - 12.2013
- Associate Software Engineer with experience in designing, developing, and maintaining software applications. Skilled in programming, debugging, testing, and collaborating with cross-functional teams to deliver reliable solutions.
Education
Bachelor of Technology -
JNTU Kakinada University
Andhra Pradesh01-2012
Skills
Operating systems
Python programming
Hadoop ecosystem
IBM DataStage
Azure DevOps
ETL processes
Data modeling
SQL
Project management
Technical documentation
Team leadership
Data analysis
Timeline
Tech Lead
Relevance Lab
01.2014 - Current
Associate Software Engineer
Store Simple Pvt Ltd
11.2012 - 12.2013
Bachelor of Technology -
JNTU Kakinada University
Languages Known
English, Telugu and Hindi.
PERSONAL DOSSIER
- Date of Birth: 13th Jun'1991
- Address: Yaswanth Kumar C H, S/o C H Samba Siva Rao, 1, 13a sri sai vasantha Nilayam, Akshya Nagar, Ramurty Nagar, Bangalore – 560016.
- Marital Status: Married