Data Analytics, Business Intelligence

Abhijeet J Patil

Jersey City, NJ 551-***-**** **************@*****.*** LinkedIn Portfolio

EDUCATION

Master of Science in Information Systems Stevens Institute of Technology GPA: 4 Hoboken, NJ May 2023 Bachelor of Engineering K.J Somaiya Institute of Engineering & I.T. GPA:3.6 Mumbai, India June 2017 TECHNICAL SKILLS & CERTIFICATIONS

● Programming Languages: Python (Pandas, NumPy, TensorFlow, Matplotlib), HTML, R (dplyr, tidyr, ggplot2)

● Platforms & Tools: Salesforce, Alteryx, SQL, Tableau, Jira, Apache Airflow, Snowflake, ServiceNow, Bloomberg, SAP BODS, SAP Concur, Coupa, Google Analytics, Adobe Analytics, VBA, Pivot Table, Power query, Databricks, Power BI

● Database & Cloud Services: AWS, S3, SQL (Oracle 12c, SQL Server, MySQL, PostgreSQL, Teradata)

● Certification: Agile-Scrum Master, Google Data Analytics and Business Intelligence Analytics, Tableau Desktop Specialist PROFESSIONAL EXPERIENCE PROGRAM MANAGEMENT, BUSINESS ANALYSIS, FINANCIAL METRIC Associate, Data Analytics & Reporting Sumitomo Mitsui Banking Corporation Newport, NJ April 2024 – November 2024

● Created and delivered an executive-level dashboards addressing ad-hoc requests, summarizing key findings, compliance gaps, and strategic recommendations, resulting in a 70% increase in compliance rate and a 30% reduction in manual efforts

● Led a 12-month end-to-end project plan to improve compliance rate and drive policy improvements across the organization, leveraging data insights to enhance adherence to policies

● Developed executive-level presentation with a dashboard and reports using Tableau and Excel to track contract lifecycle stages, analyze forecast vs. actual performance, identify variance drivers, and provide real-time vendor performance insights, leading to a 25% improvement in onboarding efficiency

● Collaborated with the Third-Party Risk Management team to define vendor onboarding requirements and develop performance metrics, financial metrics for risk, improving data interpretation and accuracy, which enhanced compliance by 20%

● Redesigned a financial report to analyze profit and loss for expiring vendor contracts, identifying cost differences and renewal impacts, improving decision-making and increased profitability by 15% through collaboration with finance, and accounting team

● Partnered with traders to design custom data visualization reports, enhancing data interpretation and decision-making, which reduced trade execution time by 30% and increased profitability by 15% Senior Data Analyst CloudData Technology LLC Wilmington, DE July 2023 – April 2024

● Developed structured datasets and built ETL pipelines in Azure Data Factory and Snowflake, reducing data processing time by 35% and improving data accessibility for marketing and sales teams

● Conducted advanced customer profiling and segmentation analysis, leveraging unsupervised ML models (K-Means clustering, DBSCAN), leading to a 15% increase in personalized marketing effectiveness

● Implemented real-time financial performance dashboards in Tableau, integrating data from Snowflake, Azure Data Lake, and Salesforce, providing actionable insights that enhanced sales forecasting accuracy by 25%

● Designed and executed an end-to-end migration strategy from on-premises SQL databases to Snowflake and Azure Data Lake, improving query performance by 50% and reducing operational costs Research Analyst – Data and Finance Stevens Institute of Technology Hoboken, NJ Jan 2022 – May 2023

● Analyzed over 500,000 swipe activity records using SQL and Excel to identify usage trends, enabling a 40% faster transition from physical to online ID cards, reducing student wait times by 30%

● Collaborated with 10+ university vendors, leveraging SQL and Excel to analyze 200,000+ student transactions, leading to a 15% increase in student discounts and cost-saving opportunities

● Automated data processing tasks using SQL and Excel macros, eliminating 80+ hours of manual work per month, allowing the administrative team to focus on strategic decision-making Business Management Analyst Yazaki India Private Limited Pune, India March 2019 - June 2021

● Analyzed supply chain and product performance data monthly, collaborated with teams, and created visualizations for Senior Management that improved decision-making and increased operational efficiency by 20%

● Identified and fixed discrepancies in the product data and sales analysis, enhancing data accuracy by 15% and facilitating better decision-making and efficient data utilization

● Managed and delivered multiple projects on time using project management techniques, resolving issues promptly, maintaining clear communication with stakeholders, and fostering trust, resulting in a 25% increase in efficiency and 15% business growth Business Intelligence Analyst Accenture Mumbai, India November 2017 - March 2019

● Developed a data monitoring and alerting system for ETL processes that identified and corrected production issues before they impacted business operations, that reduced repetitive error occurrence by 50% and increased operation efficiency

● Coached a team of 3 interns around understanding the business processes leading the team to generate a report to visualize and identify gaps in the data-loading process

● Streamlined data refining and extraction processes using SQL and Excel, identifying and resolving system blockages that contributed to a 30% improvement in overall system performance within 3 months

Contact this candidate