Pranshu A

AI Automation & SaaS Developer

Upwork • Freelance

Dec 2023 - Present • 2 yrs 7 mos

• Build end-to-end AI automation systems, document-intelligence workflows, RAG and knowledge applications, API-driven SaaS products and business automation tools. • Recent development work includes AI document processing, structured extraction, research workflows, model integrations using GPT, Claude and Gemini, FastAPI backend services, PostgreSQL databases, authentication, payment integrations and production deployment. • Technical work spans Python, FastAPI, Next.js, TypeScript, PostgreSQL, APIs, webhooks, Docker, Nginx and Linux VPS infrastructure.

AI, Automation & Trading Systems Consultant

Freelancer.com • Freelance

Oct 2015 - Present • 10 yrs 9 mos

• Independent consultant building automation, analytics, AI and trading technology solutions for global clients and custom business requirements. • Delivered 50+ analytics and automation solutions across Excel, VBA, SQL and Python for trading, logistics, operations and reporting workflows. • My work includes AI document analysis, RAG and knowledge systems, GPT/Claude/Gemini integrations, structured data extraction, FastAPI backends, PostgreSQL databases, API and webhook integrations, Excel and Python reporting automation, dashboards, reconciliation workflows and production deployments. • I have also built TradingView and Pine Script workflows, broker and exchange API integrations, trading bots, market-data pipelines, TP/SL automation, position tracking, PnL reconciliation, logging, monitoring and risk-control systems. • Technical stack includes Python, Excel/VBA, SQL, Power BI, FastAPI, PostgreSQL, Redis, Node.js, APIs, Docker, Linux, Ubuntu, Nginx and VPS deployment.

Data Analyst

McKinsey & Company • Full-time

Feb 2015 - Nov 2015 • 9 mos

• Supported consulting and decision-support engagements through large-scale data cleaning, analytical modeling and automated reporting. • Built Excel-based simulation tools for strategic decision-making and developed scenario-testing frameworks using Alteryx and SQL for complex business modeling. - Also created standardized Excel templates and process documentation to improve repeatability and efficiency across analytical workflows.