Akansha Rana Profile

Summary

Results-driven Data & Software Engineer with 6+ years of experience delivering enterprise-scale data engineering, analytics, cloud, and backend solutions. Proven expertise in Data Migration, ETL Pipelines, Data Modeling, Supply Chain Analytics, Cloud Platforms, Machine Learning, and API Development. Experienced in Azure, AWS, GCP, Databricks, Snowflake, Python, SQL, and modern data architectures. 

Education

M.S | Vellore Institute Of Technologies | Data Science
B.Tech | J.B Institute of Technology | Computer Science
12th | Pinewood School | PCM
10th | Pinewood School | Science

Internship

IOT & Robotics Internship | Inspireleap Private Limited, Online
WordPress Trainee | Itenic Solution, Noida

Technical Skills

Programming:Python, SQL, R, PHP, JavaScript, HTML5, CSS3
Frameworks:Django, Flask, FastAPI, Streamline, React
Data Engineering:Data bricks, Snowflake, ETL Pipelines, Data Modeling, Data Architecture
Cloud:Azure, AWS, GCP, EC2, Lambda, S3, Azure Blob Storage
Databases:PostgreSQL, MySQL, SQLite, MongoDB, Redis, DynamoDB
DevOps:Git, Azure DevOps, Docker, Kubernetes
Analytics:Tableau, Data Visualisation, Machine Learning, Predictive Analytics

Tools & Technologies

Databricks
Snowflake
Power BI
Tableau
Docker
Kubernetes
Synapse
Delta Lake

Languages

English(Professional)
Hindi(Native)
Spanich(Beginer)
French(Beginer)

Work Profile Focus

Delivery Strength: End-to-end ownership from requirement analysis to deployment support.
Data Focus: ETL pipelines, migration validation, analytics dashboards, and decision-support reporting.
Engineering Style: Clean backend APIs, scalable data models, code review, and documentation-first delivery.
Leadership: Mentoring junior developers, sprint coordination, stakeholder communication, and cross-team collaboration.
Business Impact: Workforce planning, resource optimisation, process automation, and performance monitoring.

Experience

Senior Software Engineer, Data Consultant – Tredence Analytics (Jul 2023–Nov 2025)
Project: Data Migration, Data Validation, Data Modelling, Supply Chain and Capacity Planning, Integrated Data Analytics & Performance Monitoring Platform
Skills Used: Python, FastAPI, PySpark, Streamlit, Databricks, Snowflake, Azure, GCP, Git, Azure DevOps, Synapse, SQL, MySQL, PostgreSQL, Linux Shell Scripting, Windows
Live Project: https://notebooklm.google.com/
Roles & Responsibilities:
- Designed and implemented a data migration and validation framework to transition enterprise HealthCare data assets from Teradata to modern cloud-based data platforms (Snowflake/Databricks) while ensuring accuracy, consistency, and performance optimization.
- Migrated analytical and reporting data from Snowflake to Databricks, implemented data lineage tracking, and automated Tableau metadata extraction for improved data governance and visibility.
- Designed and implemented an automated data processing and knowledge assistance pipeline integrating API data ingestion, Azure-based storage, and LLM prompt engineering for intelligent response generation.
- Designed and optimized data-driven solutions for Nestlé’s Global Command Center and Capacity Planning initiatives to enhance operational efficiency, demand forecasting, and resource management within the CPG and Supply Chain domain.
- Led the design, development, and delivery of data-driven solutions under the IRIS program, focusing on improving data accuracy, analytical capabilities, and cross-functional insights for the CPG and Supply Chain vertical.
Software Engineer – GroupM Media (Jun 2021–Jun 2023)
Project: Synapse
Skills Used: Python, Django, Azure, SQL, SQLite, API Development, RestAPI, Git, Windows, Linux
Roles & Responsibilities:
- Gathered and collected data from various sources, including databases, APIs, and external sources.
- Applied statistical methods and techniques to analyze and interpret data.
- Used data visualization tools and techniques to present findings in a clear and meaningful way.
- Developed and programmed software solutions using Python, Django, and SQL Server.
- Designed and architected new features from scratch, ensuring scalability and performance.
- Created reports, dashboards, and visualizations to communicate analytical findings and recommendations.
- Refactored and documented code to meet coding standards and maintainability.
- Identified opportunities for application enhancement, made recommendations, and implemented systems accordingly.
- Led and managed a team of junior developers, providing guidance and support.
- Managed projects using Scrum methodology, including code review, testing, and deployment.
- Conducted testing and debugging of code, including the creation of automated unit tests when necessary.
Contract Software Developer – Full Time/Contract/Trainee (Sep 2019–May 2021)
Projects: Chat Bot Backend Design, Rest API Design, SEO Addition, Bill Payment Microservice, WordPress Website Design
Skills Used: Python, Django, FastAPI, WordPress, Flask, AWS, Azure, SQL, MySQL, DynamoDB, AWS Lambda, EC2, Lex Bot, Windows, Linux
Project Link: https://www.kramate.com/
Employment History: Square Yards Pvt Ltd (Feb 2021-May 2021), D2C Consultancy (Sep 2020-Dec 2020), Kramate Pvt Ltd (Feb 2020-Apr 2020), Shine Group Pvt Ltd (Apr 2019-Jan 2020), BI Infotech Pvt Ltd (Apr 2018-Jun 2019)
Roles & Responsibilities:
- Designed and implemented robust, scalable REST APIs using Python, Django, Flask, and FastAPI to support various frontend clients and external integrations.
- Architected and deployed a high-availability Bill Payment Microservice, ensuring transactional integrity and seamless payment processing.
- Leveraged AWS services including Lambda for serverless workflows and computing, and EC2 for hosting scalable application instances.
- Managed cross-cloud environments utilizing Azure infrastructure and deployed services across both Linux and Windows operating systems.
- Designed, optimized, and managed relational and NoSQL database schemas using SQL, MySQL, and DynamoDB to support high-throughput application needs.
- Designed and integrated an intelligent Chat Bot Backend utilizing AWS Lex Bot, improving automated user interaction and engagement workflows.
- Developed and customized responsive enterprise websites using WordPress.
- Implemented SEO additions and optimizations to boost organic search rankings, improve site performance, and enhance web traffic metrics.

Projects

RPPS (Resource Project Planning Software)

Utilisation and project efficiency through intelligent planning. This MS project at Vellore Institute Of Technology uses business analytics and machine learning to analyse employee skill datasets, project requirements, and historical utilisation trends.

Skills Used	Team Size	Year	Keywords	Key Functionalities
Data Science, Predictive Modelling, Machine Learning in HR, Data Visualisation (Dashboards), Talent Optimisation	Individual	2026	Workforce Analytics, Resource Allocation, Bench Management, Skill Gap Analysis, Project Recommendation Systems	Employee-project recommendation engine, skill-gap analysis, workforce analytics dashboard, bench-duration monitoring, utilisation rate tracking, predictive and prescriptive resource planning.

Finance Calculator

A lightweight Python library for essential finance analytics, ranging from basic profitability metrics to advanced risk simulations and time-value-of-money calculations.

Skills Used	Team Size	Project Link	Features
Python, Finance	Individual Contributor	View Package	NPS, profitability margins, EBITDA/EBITA, current ratio, debt-to-equity, ROE, FCF, CFO, cash-flow margin, NPV, FV, Sharpe Ratio, Monte Carlo price simulations, and audit logging.

Flask-URL-Shortner-App

A simple domain-independent URL shortener built using Flask. It accepts valid URLs across domains such as .com, .org, .in, and .ly, then redirects users through generated short links.

Skills Used	Team Size	Project Link	Key Functionalities
Python 3, Flask, urllib.parse	Individual Contributor	View Repo	Domain-independent URL handling, random 5-character short-code generation, original URL redirection, and validation for all valid URLs.

Rozerpay Payment Integration

A payment integration project that creates a seamless checkout experience using Razorpay's standard checkout workflow and secure backend order creation.

Skills Used	Team Size	Key Functionalities
Python, HTML, CSS	Individual Contributor	Credit/debit card, UPI, net banking, and wallet payments; secure Python backend communication with Razorpay APIs; test-mode setup for debugging; and automatic success-page redirection.

pdf_text_extractor

A lightweight and efficient Python utility designed to parse, extract, and clean textual data from PDF files for reuse in text, JSON, NLP, analytics, and archiving workflows.

Skills Used	Team Size	Key Functionalities
Python, HTML, CSS, PyPDF2, pdfplumber, pypdf	Individual Contributor	Single-page and multi-page PDF parsing, text extraction, content cleanup, structured export support, NLP preprocessing, data analysis, and document archiving support.

Online Voting Application

An online voting system designed to reduce fraud in manual voting and earlier online voting systems by combining face recognition, OTP validation, and database-backed voter verification.

Skills Used	Team Size	Key Functionalities
Python, Django, OpenCV, MySQL, SSL/TLS	4	Location-free voting, face recognition, OTP verification, voter database validation, secure access control, and candidate selection after successful identity matching.