Archisman Sahoo

Defined and implemented the analytics roadmap, aligning with business goals, and built an analytics team from scratch. Mentored and recruited a team of two analysts, completing multiple projects using SQL, Python, AI, ML, Excel, and Power BI to reduce vet cancellations and understand customer clusters. Communicated and collaborated with stakeholders to report data analysis findings and recommendat

Worked as a consultant on a customized risk assessment business solution for a top 25 US innovator pharmaceutical company, optimizing investment at each phase of product development. Performed revenue projection and accounted for macro and micro events to plot uptake and decline curves. Simulated financial data using Monte Carlo simulation for calculating EPV, NPV, IRR, and VAR.

Led project management for a team of three analysts in mobile app marketing, driving customer engagement using JIRA and Confluence. Led the creation of campaign metrics dashboards and analyzed over 10 campaign-level deep dives to measure engagement performance. Conducted lookalike modeling, tagging audits, and deep-dive funnel analysis for new features across strategic international markets.

Led multiple 5-step projects on debit card segmentation based on industry transactions, implementing K-means clustering in Python for dividing segments. Managed end-to-end timely quality delivery for over 200 clients in 50+ industries, leading a team of 12+ analysts for optimizer reports. Automated issuer report generation using Impala and SQL, and designed various metrics to help clients understa

Developed two acquisition and solicitation databases using SQL and Hive for improving the efficacy of high-profile marketing campaigns. Automated daily and monthly product-level summary reports in Python and Tableau. Stress-tested on baseline and stressed scenarios to verify capital strength for a top 5 US bank, reducing the probability of default by 2%.

Designed 15 attribute-based rules for potential abuse detection based on observed patterns in data. Conceptualized a simpler rule-based model in SQL and Excel based on the 80-20 rule for all abuse attributes. Analyzed several abuse cases occurring for inbound and outbound shipments in the India region and conducted model validation via positive and negative testing.

Analyzed and quantified 32 risk scenarios where operational risk losses could occur, collaborating with the Australian business team to build a capital model as per Basel II guidelines. Simulated the design of an operational risk model using Monte Carlo Simulation in R and developed a framework in SAS and SQL for Op risk capital. Allocated capital to 10 business divisions and helped reduce risk ca

Reduced reservation time by centralizing the server reservation system from 45 minutes to a single click. Increased capacity utilization of servers for trade simulations by 100% by developing a tool. Utilized HTML and SQL in the development of the tool.

Analyzed the impossibility of instantiating various signature schemes for higher security features and efficiency. Focused on tools used across the world in cryptology. Conducted research to understand and improve cryptographic methods.

Grade: 7.51/10

Activities and societies: Awarded INSPIRE merit scholarship from Dept. of Science & Tech, Govt. of India. Ranked in top 0.2% in India for IIT JEE, AIEEE & BITSAT exams.

Pursued an integrated 5-year Master of Science degree in Mathematics and Computing. Achieved a CGPA of 7.51 out of 10.

Grade: 88.67%

Completed Class XII under the CHSE, Odisha Board. Achieved a percentage of 88.67%.

Grade: 91.33%

Activities and societies: Only person to get merit certificate for 100/100 in Mathematics from School in ICSE 10 Board exam.

Completed Class X under the ICSE Board. Achieved a percentage of 91.33%.

Grade: 6.7/10

Activities and societies: Campus winner in Godrej Loud, Campus finalist in Mahindra War Room.

Completed a Post Graduate Diploma in Management with a specialization in Finance and Operations. Achieved a CGPA of 6.7 out of 10.