Summary
Overview
Work History
Education
Skills
Certification
AI/ML Projects
Timeline
Generic

RAKSHIT ASHOK RATHI

Herndon,VA

Summary

Senior Solution Architect and Software Developer with over 9 years of experience in designing and implementing enterprise-grade systems. Proven expertise in full-stack development, cloud architecture, and system integration, achieving performance optimization of 99%. Demonstrated success in leading cross-functional teams and driving technical initiatives across finance, healthcare, and e-commerce sectors. Strong skills in AI integration, microservices architecture, and strategic technology planning.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Solution Architect

Amazon.com LLC
03.2022 - Current
  • Led development of Tax Adjustment Manager (TAM) platform, reducing processing time by 99% (3 hours → 2 minutes) through optimized Python and SQL transformations
  • Consolidated multiple fragmented data sources into centralized tax master dataset, delivering 40% performance uplift in tax rule processing
  • Redesigned Stat to Tax dashboard using AWS QuickSight and Athena, optimizing SPICE datasets to reduce load time from 90 minutes to <10 seconds
  • Automated International Tax Reporting workflows using Lambda and S3, achieving 500+ hours in annual efficiency gains

Python/ETL Developer

Comcast
09.2019 - 02.2022
  • Company Overview: DVG Tech Solutions LLC
  • Designed comprehensive ETL processes using Pentaho and Python to integrate billing feeds, JSON APIs, and third-party datasets for accurate customer invoicing
  • Leveraged HDFS and Hive to ingest, transform, and analyze structured/semi-structured data across millions of records
  • Automated departmental expense forecasting using reusable Python frameworks (Pandas, NumPy, openpyxl), reducing manual processing by 48 hours per month
  • Partnered with enterprise architects to map upstream financial data flows into Informatica workflows

ETL Developer

SC Johnson
05.2019 - 08.2019
  • Company Overview: DVG Tech Solutions LLC
  • Designed and optimized ETL pipelines in Informatica and Teradata supporting hourly analytics refreshes for near-real-time insights
  • Engineered business-centric data models for high-volume product datasets (~1M+ rows/hour) enabling demand forecasting and inventory optimization
  • Collaborated with product managers to translate cross-border sales requirements into structured data pipelines

ETL Developer

Anthem Inc.
02.2019 - 05.2019
  • Company Overview: DVG Tech Solutions LLC
  • Converted legacy SSIS logic to Informatica mappings, ensuring accurate claims data transformation and regulatory compliance
  • Integrated healthcare domain-specific logic (ICD codes, benefit rules) into ETL pipelines for high-quality claims reporting

Assistant Vice President, Software Developer

Bank of America Corp
02.2016 - 02.2019
  • Enhanced data quality by embedding rule-based validation checks into ETL pipelines using Informatica and Oracle PL/SQL
  • Designed Autosys job chains for end-to-end orchestration of reconciliation pipelines, ensuring data freshness for daily compliance reporting
  • Developed data anomaly detection systems supporting SOX and Basel II compliance requirements

Summer Intern, Software Developer

Bank of America Corp
06.2015 - 08.2015
  • Built data ingestion logic using Python to merge Oracle and MySQL datasets with delta comparison capabilities
  • Designed SLA breach tracking dashboard providing visibility into data pipeline health and job statuses

Education

Master of Science - Computer Science

University of North Carolina At Charlotte
Charlotte, NC
12.2015

Executive MBA - Information Technology

University of Ottawa
Kansas City
03.2021

Skills

  • Programming & Scripting: Python (Scikit-learn, NumPy, Pandas, Matplotlib, MLlib, Spark ML_), SQL, Shell (Bash), PL/SQL, JavaScript (AngularJS), Bootstrap
  • Data Engineering: ETL (Informatica, Pentaho), AWS Glue, Airflow, Data Lakes, Data Warehousing, Batch & Streaming Pipelines
  • Big Data Technologies: Hadoop, Hive, Spark (PySpark, MLlib), HDFS
  • AI/ML Technologies: OpenAI API, LangChain, Streamlit, ReAct Agents, Tool Calling, Prompt Chaining, Multi-Agent Architectures, Memory Management, Model Context Protocol (MCP)
  • Computer Vision & NLP: RealESRGAN, SentenceTransformer, FastAPI, Image Processing, Text Analytics, Embeddings
  • Cloud Platforms: AWS (S3, Glue, Lambda, Athena, QuickSight, Redshift, Bedrock), Azure
  • Databases: Oracle, MySQL, SQL Server, Teradata, PostgreSQL, NoSQL (MongoDB, DynamoDB)
  • Visualization & BI: Tableau, QuickSight, OBIEE, Excel VBA, Interactive Dashboards
  • Tools & Orchestration: Git, Control-M, Replit, CI/CD, Agile Development
  • Core Competencies: Data Modeling, Pipeline Architecture, Performance Optimization, Data Governance, Solution Architecture, SOX Compliance

Certification

  • Data Engineering on AWS - Amazon (2025-02)
  • Machine Learning with Apache Spark - IBM (2025-06)
  • Generative AI Database Design & Management with ChatGPT - Vanderbilt University (2025-06)
  • Prompt Engineering for AI Models using AWS Bedrock - AWS Bedrock (2025-03)

AI/ML Projects

  • AI Chatbot with OpenAI + LangChain - Built conversational AI assistant for finance queries using GPT API and deployed with Streamlit frontend
  • Resume Intelligence Matcher - Developed AI-powered resume analyzer using SentenceTransformer embeddings, cosine similarity, and GPT API for smart suggestions
  • Stock Market Analytics Agent - Created intelligent trading assistant using LLM agents, time series analysis, and multi-agent architecture for market forecasting
  • Image Enhancer AI with Real-ESRGAN - Built ML pipeline for image super-resolution using PyTorch and deployed as FastAPI microservice

Timeline

Solution Architect

Amazon.com LLC
03.2022 - Current

Python/ETL Developer

Comcast
09.2019 - 02.2022

ETL Developer

SC Johnson
05.2019 - 08.2019

ETL Developer

Anthem Inc.
02.2019 - 05.2019

Assistant Vice President, Software Developer

Bank of America Corp
02.2016 - 02.2019

Summer Intern, Software Developer

Bank of America Corp
06.2015 - 08.2015

Master of Science - Computer Science

University of North Carolina At Charlotte

Executive MBA - Information Technology

University of Ottawa

Similar Profiles

CREATE PROFILE
RAKSHIT ASHOK RATHI