Sandipan Basu Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

• Spearheaded the Payments Fraud project across the UK, USA, and ASP regions, overseeing the capture of attempted fraud instances, system performance evaluation, and incurred losses analysis.• Conducting data extraction and engineering for the Payment KPI Dashboard tailored for the Asia Pacific region, illuminating instances of Payments Fraud within real-time banking transactions.• Collaborating with stakeholders, including IT and data architecture teams, to refine fraud tagging, alert systems, and detection indicators, ensuring the finalization of key performance indicators (KPIs).• Orchestrating the preparation and dissemination of dashboards to the Leadership team for monthly Global Business Review papers.• Conducting comprehensive analysis of payment transactions to detect and prevent fraud, employing advanced techniques such as Mule Analysis.• Documenting project proceedings to uphold key definitions and logic for future reference.• Directing the Payment Fraud project migration for UK and ASP regions from the SAS platform to Feedzai utilizing Google Cloud and DSW.• Leading ad-hoc projects spanning various regions, delivering insightful recommendations to the leadership team.• Managing and mentoring a team of 5 members, overseeing their contributions to and coordination across multiple projects.

India

• Managed end-to-end marketing campaigns targeting After Sales business for leading automotive clients in the US, involving pre/post-campaign analysis, execution, and generation of insights to inform performance decisions.• Collaborated with Accounts to assess data requirements and devise data architecture solutions enabling easy access and retrieval of data from Oracle or SQL server databases via SAS server.• Optimized existing ETL processes and developed standardized, automated database solutions tailored to individual OEMs.• Coordinated with analysts and data scientists to establish data marts and additional layers for expedited reporting and exploratory data analysis.• Automated SAS and Python programs to streamline processes and eliminate manual intervention.• Produced comprehensive technical documentation for various contributed programs.• Created visualization reports utilizing Excel, PowerPoint, and Tableau to evaluate Sales and After-sales performance for OEMs and measure campaign effectiveness.• Conducted routine Data Cleansing, Data Wrangling, and Data Scaling to identify and address data quality issues, providing insights for managerial decision-making and strategic planning. Mentored new team members, offering guidance on technical and functional aspects as needed.• Led and supervised a team of three individuals, providing day-to-day project support and fostering professional growth.• Demonstrated complete ownership of multiple portfolios, effectively managing client expectations through proactive communication.

Bengaluru Area, India

Bengaluru Area, India

• Collaborated with the Marketing Automation team to grasp operational requirements.• Developed and maintained SAS Programs within SAS Data Integration Studio and crafted Campaign flow diagrams using SAS Customer Intelligence.• Supported the Operations Team in monitoring batch execution and conducted defect analysis for deployed campaigns and Jobs.• Evaluated automation feasibility for intricate projects and administered standard tools.• Implemented changes in SAS DI Jobs and managed job deployment using SAS DI and SAS Management Console.• Rolled out new outbound campaigns and executed modifications to existing ones utilizing SAS CI, SAS Management Console, and SAS Information Map.• Implemented changes to inbound campaigns through real-time decision-making applications in SAS CI.• Fine-tuned batch performance by adjusting SAS CI tool settings and optimizing flows in Scheduled Manager.• Developed test plans and strategies for automated testing of campaigns and codes before launch.• Visualized response for requests routed via JAVA services to the database using SOAP Test.• Maintained and managed codes across SAS Platforms and monitored server and service health using AP Dynamics, proactively addressing load issues and generating live dashboards for team awareness.• Ensured high-quality service delivery to enhance satisfaction, loyalty, and customer partner experience while maintaining production support documentation using Confluence.• Conducted Weekly Connects with clients to facilitate communication and disseminate updates across the marketing automation team.• Provided training and mentorship to new joiners and stakeholders on technical aspects. Additionally, contributed to ITIL service improvement initiatives for overall project efficiency.

Bangalore Urban, Karnataka, India

Bangalore

• Managed end-to-end recurring and ad hoc requests for multiple portfolios, overseeing direct mail, email, and telemarketing campaigns for leading US retail stores.• Programmed SAS codes and generated files on the UNIX server for campaigns, auditing SAS codes and campaigns executed by team members.• Facilitated direct interaction with client teams through weekly calls, gathering campaign information, flagging issues, and resolving challenges.• Analyzed campaign requirements and critical criteria to filter potential customers for various promotions across multiple industries.• Extracted data from CRMS or PDR, scrubbed records for risks and opt-outs, segmented populations based on marketing channels and promotional offers, and created test and control groups.• Developed workbooks based on population segmentation and generated audit reports, uploading them to the MRM for client approval.• Conducted primary audits (Self Audit) to ensure 100% quality on campaign files in UNIX before shipping to respective mail houses.• Ensured timely and 100% quality delivery within SLA parameters.• Optimized process flow by eliminating redundant steps and non-value-adding items, leveraging effective SAS codes, and exploring automation and integration opportunities for multiple campaigns.• Conducted process training for the team and provided mentorship on technical and functional aspects.

Bengaluru Area, India

Market research and lead generation.

Bengaluru Area, India

Relationship Manager and Investment Adviser for Privilege Customers. Cross selling and upselling products, retaining privilege customers by providing best possible service.

Kolkata Area, India

Conversion of registered users to paid users, increasing both customer and consumer base.

Postgraduate Degree, Applied Statistics, A

Passionate in understanding key concepts in Statistics to upgrade my knowledge and keen to upskill my work experience using Statistics.

P.G.D.M, Marketing

Bachelor Of Technology (B.Tech.), Computer Science & Engineering