Siddharth Pathak Email & Phone Number

Arlington, Virginia, United States

Mclean, VA, US

• Team: Platform Operations Horizontal Controls | Vendor: Iconma
• Primary responsibility to work on Proof-of-Concept viability for executing Control & Compliance reports on an internal CICD platform – Enterprise Model Platform (EMP).
• Leveraged Snowflake and AWS to test feasibility and functional viability for moving scripts from Databricks to Jupyter notebooks-like EMP environment.
• Set up the standards and process to build, test, deploy and productionize Horizontal Controls processes on EMP. Also set up process documentation for the same.
• Responsible for migration support when migrating processes and reports from Databricks to EMP. Successfully migrated 18 scripts in 2024, projected to migrate 62 in coming year, with projected savings of ~$125K in.

San Jose, CA, US

• Team: Credit Risk FLOD Testing & Monitoring
• As a Tester with Credit Risk First Line of Defense, key responsibility is to ensure adherence and adequacy to Policy, Procedures & Regulations pertaining to the Credit Risk space. Working as a Data Analyst with the.
• Test Lead for Adverse Action, Customer Identification Program & Ability to Pay tests. Key responsibilities include writing SQL or SAS scripts to identify population for a certain scope period and validate policy.

Mclean, VA, US

Client: Capital One | Vendor: Hanusoft Inc. Team: Card.AI (Card Analytics & Infrastructure)Card.AI’s Campaign’s execution involves identification and data analysis on targeted population (mostly US Card) for any kind of Marketing or Transactional fulfillments. - Associated with Campaigns right from the Intent discussion stage to analyze various business.

• Acted as a Data Science liaison in coding for algorithm maturity in AI/ML platforms. Implemented using R, Python & RapidMiner.
• Designed robust ensemble algorithms to fine-tune the Text Processing Module. Also created a Data Pipeline and implemented effectiveData Collection & Storage strategies in AWS.

New York, New York, US

• Design Data Architecture for an in-house SaaS & PaaS projects including ingestion, ETL, storing & modelling of data.
• Design and implement Data Models for various AaaS projects based on the requirements of the Data Science algorithm(s).
• Use quantitative methods & techniques to gain actionable insights from data. Predominantly in R and Python (using NumPy, pandas etc.).
• Create visualizations using Tableau, D3.js, plotly.js, and matplotlib in IPython
• Single-handedly develop Data Ingestion module using Node.js, Express.js & Shell Scripts. Deployed on AWS EC2. Storage in AWS RDS & S3
• Design security architecture for File Transfer & File Upload modules.

• Parsing and Cleaning data obtained from various sources, and creating interactive visualizations from this data.
• Using AWS to implement ETL and backend storage & Implementing Security measures on top of the full stack website development.
• Implemented above functionality wherein the process from after uploading a dataset to the creation of visualizations is fully automated.

• Project – Native American SC Archive
• Created a Project Plan with complete delivery timeline.
• Design database schema for variety of audio/video & textual data. Implement on AWS EC2 and RDS for staging purposes.
• Create an interactive meticulous Timeline using Timeline.js. Create additional visualizations using D3.js & Tableau.
• Design a website template for displaying of all the data.

• Project – MetaNumber Network & Cluster Analysis
• Implement the table-network-cluster algorithm in Python (NumPy, SciPy etc.) and obtain tightly-knit clusters. Backup storage on AWS S3.
• Recognize the best clusters and how they connect to each other in a network using force-directed graphs.
• Implement a visualization of the aforementioned network of clusters. Predominantly using Tableau & D3.js. Code backup on AWS EC2.

Columbia, SC, US

• The initiative Black Soldiers Mattered is a vision by Dr. Hudson to illuminate the service of BlackNorth Carolinians during World War I. The data that we had access to was about 21,000 recordsof significant information.
• Create a Leaflet-based map with time-slider controls to replay GPS tracks- implemented usingCSS, JavaScript, D3.js, and Leaflet APIs.
• Create another Leaflet-based map with a more meticulous time slider with Playback options,using the LeafletPlayback API.
• Plot Camp sites on US map, illustrated using Hexbins- implemented using D3.js Hexbin plugin,JavaScript, JSON objects, and CSS.
• Design an animation to illustrate a soldier's journey from being born to getting enlisted andfurther roles in the army- implemented using HTML, CSS, and Canvas Maps.
• Create additional visualizations in Tableau.

CSCE 101: Introduction to Computer Concepts: Majorly includes covering all aspects of websitedesign using HTML for design, and CSS and JavaScript for styling and additional effects.CSCE 102: General Applications Programming: Included interactive Android application designusing the tool MIT App Inventor 2.Responsibilities:Working as GTA for the Computer.

Indore, MP, IN

• As part of this internship I was part of a team which was responsible for designing a BusinessIntelligence solution for an electronics conglomerate. The aim was to extract information fromthe data given by client and.
• Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.Worked in an agile environment.
• Created and Monitored Informatica sessions.
• Extracted data from multiple sources, transformed the data according to business logic, andload the transformed data to targets.
• Developed BTEQ scripts for Data Extraction and processing.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer,

• The training encompassed designing the back-end of an Attendance and Salary Managementdatabase module for a corporation.Attendance and Salary Management
• This project was done as a part of university-mandated Industry Training credit. It involveddesigning an attendance and subsequent salary management database for the employees ofany arbitrary organization.
• For this purpose, a walk-through of the whole SDLC was done and I was assigned to thedatabase design team of the project.
• The backend was implemented using MySQL with ODBC connectivity via Java. The front endteam used HTML and CSS towards their purpose.

As part of this internship, initially I worked on several android application projects. Later, I was also part of database design team which was responsible for designing the ER diagrams and back-end of applications and software. Primarily used tools were Eclipse IDE (with Java and XML), andMySQL.

Master’S Degree, Computer Science

Graduate Certificate, Cyber Security Studies

Bachelor’S Degree, Computer Science And Engineering