Ranjith R. Email & Phone Number

Sterling, Va, Us

Austin, Texas, Us

Real-World Data (RWD) Extraction and Processing: A Comprehensive Engineering ApproachIn my recent project at Oracle, I had the opportunity to play a pivotal role as a Data Engineer in the development and management of a sophisticated Real-World Data (RWD) extraction and processing pipeline. This project aimed to harness Electronic Health Records (EHR) data from various tenants such as 'browncountyhospital', 'iuhealth', 'eamc', and more, translating this data into valuable insights for healthcare analytics.Key Responsibilities and Technologies:Data Extraction: Developed an efficient data extraction process using Java. This involved pulling vast amounts of data from multiple healthcare tenants, each with its unique data structure and content.Data Processing and Implementation: Implemented core processing components in Go. This step was crucial in streamlining the data pipeline, enhancing both the performance and scalability of the data processing tasks.Data Structuring and De-Identification: Utilized PySpark to structure and de-identify the datasets, a critical step in ensuring privacy compliance and data security. This process involved handling complex data entities such as ALLERGY, CONDITION, PROCEDURE, and more, totaling 13 distinct types.Cloud-Based Management and Storage: Leveraged AWS services including EMR for Spark environment execution, Lambda for various data formatting steps, S3 for general-purpose storage, and DynamoDB for logging and metrics. These tools were instrumental in managing the high-volume, high-variety, and high-velocity nature of healthcare data.This project was not just about managing large datasets; it was about ensuring that the data extracted and processed could be translated into meaningful insights that drive better healthcare decisions and outcomes. It was a challenging yet rewarding experience that underscored the importance of precision, privacy, and efficiency in healthcare data engineering.

Mclean, Va, Us

As a seasoned Data Engineer at CapitalOne, my tenure encompassed the management of extensive end-to-end data engineering processes, including data ingestion, data cleansing, data transformations, data auditing, and feature engineering. My expertise was central to developing and maintaining complex ETL pipelines, adeptly utilizing tools such as Apache NiFi and Kafka for real-time data streaming and processing. In the realm of big data, I demonstrated an in-depth understanding of Hadoop's architecture and its integral components like HDFS, MapReduce, Spark, Hive, and Sqoop. I was a key player in the development of production-ready Spark applications leveraging Spark-Core, DataFrames, Spark-SQL, Spark-ML, and Spark-Streaming API's. I implemented scalable solutions in Databricks, capitalizing on its Unified Analytics Platform for big data processing and machine learning applications.In managing data storage, I utilized the Snowflake data warehousing platform for efficient data management and quick data querying. Additionally, I played a significant role in the optimization of ETL workflows and the design of data ingestion pipeline. I have successfully implemented and consumed REST APIs, ensuring seamless data exchange and smooth communication between different software components.My knowledge extended to AWS Cloud services like S3, EMR, Lambda functions, Redshift, Athena, and Glue. I efficiently used AWS utilities such as EMR, S3, and CloudWatch to run and monitor Hadoop and Spark jobs on Amazon Web Services (AWS), enhancing the computation, query processing, and storage solutions.With my grasp of the latest data technologies and big data tools, I was successful in driving impactful data-driven decision-making processes at CapitalOne. My strong technical skills, coupled with my passion for solving complex data problems, helped me significantly contribute to the company's data strategies.

Warrensburg, Mo, Us

In my role, I demonstrated a deep proficiency in SQL and PySpark, adeptly creating complex queries for efficient data manipulation, extraction, and reporting. This skillset was crucial to guiding strategic decision-making processes within the organization. Using SQL in conjunction with Tableau, I designed and maintained database tables, views, and user-defined functions, streamlining data operations while simultaneously enabling interactive data visualizations.I exhibited proficiency in both SQL performance tuning and Tableau performance optimization, enhancing database and visualization efficiency and responsiveness. This ensured the organization was able to quickly access and interpret crucial data when needed, supporting faster, more informed decision-making.Further, I took a key role in managing the creation and maintenance of database objects and conducting thorough database analysis. This ensured data consistency and integrity, underpinning the accuracy of the data visualizations our teams produced. My collaboration with data science teams was also instrumental. I aided in data modeling tasks using SQL, PySpark, and Power BI, delivering clean, ready-to-use data that was then used to apply machine learning models and create interactive data visualizations. This, in turn, drove our data-driven decision-making processes and helped the organization leverage its data to the fullest. In summary, my skillset in SQL, PySpark, and data visualization tools like Tableau and Power BI, along with my collaborative approach, has enabled me to significantly contribute to the data engineering projects within the organization.

Mumbai, In

As a Data Engineer at HDFC AMC, I played a key role in upgrading their data management infrastructure. My work focused on transitioning from traditional on-premise Hadoop systems to a more robust Cloudera platform. I developed, tested, and launched ETL pipelines, while ensuring data integrity and security. To handle real-time data, I implemented Spark Streaming and Kafka, boosting operational efficiency. Additionally, I used my expertise in Python, SQL, and NoSQL to optimize data extraction, transformation, and loading processes. This project significantly improved data accessibility, speed, and reliability, fueling the company's data-driven decision-making processes.

Hyderabad, Telangana, In

• Assisted in the analysis of financial data, including market trends and company performance metrics,contributing to the development of investment strategies and portfolio management.• Conducted research on emerging trends, technologies, and regulatory changes in the finance industry, providing valuable insights to help inform the company’s financial decision-making process.• Collaborated with cross-functional teams to develop financial models and forecasts and participated in the preparation and presentation of reports and analyses to support management decisions and strategic initiatives.

Master'S Degree, Computer Science

Master'S Degree, Finance, General

Bachelor Of Technology - Btech, Mechanical Engineering

Secondary Education, Mathematics, Physics, Chemistry

Primary Education

Master'S Degree, Computer Science