Data Analyst Business Intelligence

Sushant S Belapurkar

Business Intelligence and Data Analyst

Irvine, California, USA

Phone: 469-***-****

*******.***********@*****.***

LinkedIn:sushant-s-belapurkar

github:sushantsbelapurkar

Profile summary

Results-driven Business Intelligence and Data Analyst with 11+ years in FinTech, 7+ years in Data Analytics including 4 years in the USA. Expert in translating complex datasets and business information into actionable insights using advanced data analytics, data modeling, and data visualization tools and techniques. Skilled at presenting and storytelling technical details to non-technical audiences, I have led global teams and startups on strategic projects. Passionate about continuous learning, I am open to relocating within the USA.

Key Skills

Advanced SQL: DDL, DML, CTE, window functions, complex queries, subqueries, advanced joins, stored procedures, normalization-denormalization, views, performance tuning etc.

Data Modeling & ETL: Proficient in data modeling, ETL, and data warehousing for relational databases.

Data Analytics: Skilled in collecting, extracting, integrating, statistical analysis & modeling, generating insights from large datasets using Redshift, MS-SQL, MySQL, AWS.

Data Visualization: Proficient in Looker and Tableau for creating data models, data visualizations, and informative reports.

Python: Experienced in data manipulation, data wrangling, automation, and analysis using Python, with proficiency in NumPy and Pandas libraries.

Automation & Workflow Orchestration: Skilled in developing efficient data processing pipelines, automating data processing tasks, and orchestrating workflows with Apache Airflow.

Financial Analytics: Strong domain expertise in investment banking, finance & accounting, and e-commerce. Proficient in translating business requirements into effective database structures.

Communication & Presentation: Excellent communication and presentation skills with strong problem-solving and critical thinking abilities.

Professional experience

Business Intelligence & Data Analyst

ThredUp Inc, CA, USA

May 2020 - Present

Technologies: Redshift, AWS, MySQL, Looker, Python, Snowflake, Airflow, Databricks, Advanced Excel

Led the development of data analytics, data model design, and implementation, as well as OLAP reporting for revenue recognition and audit operations in accounting and finance, contributing to a successful IPO listing of the company.

Spearheaded payment validation and reconciliation automation project, reducing error rates from 5-6% to 0.8-1% and accelerating month-end close by two days. Implemented ETL/ELT processes, developed data models and pipelines, extracted and integrated data via API and third-party data mart, cleansed and analyzed data, and streamlined processes through automation.

Directed cross-departmental collaboration to develop and deploy reports, visualizations, and dashboards, enhancing data-driven decision-making. Projects included customer response analysis, pattern identification, fraud detection, and trend analysis with delivering critical insights and presentations to both data science and non-technical teams.

Analyzed and revamped the company's loyalty program, conducting data analysis, generating insights, and developing monitoring dashboards, leading to a 20% increase in loyalty redemptions.

Senior Engineering Analyst

Accenture Pvt Ltd, India

April 2014 - Jul 2018

Technologies: MS-SQL Server, Python, JupyterLab, .NET framework, Fidessa, APTP (investment banking tools)

Led a team in transforming large client datasets to APTP format, focusing on data profiling, Source-to-Target Data Mapping, metrics analysis, complex data analytics, Technical Specs documentation, and ETL processes.

Managed cross-border projects for international investment banks, achieving significant middle and back-office cost and time reductions. Developed, modified, and optimized database objects and complex queries using Advanced SQL for trade matching, reporting, and trade settlement operations.

Professional Project

GitHub: Advance portfolio Analytics

April 2019 - Present

Technologies: MySQL, Python, JupyterLab, Tableau, Airflow, pandas, matplotlib, Advanced Excel

Developed an advanced stock market analysis and portfolio rebalancing system, utilizing data warehousing, schema design, data modeling concepts, and data pipeline development to extract and analyze 10 years of financial results from large datasets and API integrations.

Integrated investment principles from Graham and Lynch into a finance management tool, analyzing data with advanced SQL and Python to select and manage a diversified stock portfolio, and automated processes using Airflow.

Delivered annual returns consistently surpassing the S&P 500 index over the last 5 years by driving data-driven decision-making and enhancing stock selection accuracy.

Associate Test Analyst

NSE.IT Ltd, India

Nov 2010 - Mar 2014

Technologies: Oracle DB, HP-ALM, Ensettle (investment banking tool), Advanced Excel

Analyzed complex datasets for diverse clients, specializing in matching processes, applying complex SQL queries for data handling and interpreted management reports effectively.

Developed comprehensive test plans, scripts, and execution strategies for development, User Acceptance Testing (UAT), and product environment

Education & Certification

Master of Science in Business Analytics - Dec 2019

Saint Mary’s College of California, USA

GPA:3.9 with Honors

Bachelor of Engineering in Computers - May 2008, Mumbai University (62.98%)

Certification: NSE Academy Certification in Financial Markets (NCFM)

Contact this candidate