Available to hire
Hi, I’m Priyam Sheta, a finance-focused Business and Data Analyst with over 5 years of experience transforming complex data into strategic insights, primarily for the banking and financial services sectors. I specialize in using tools like SQL, Python, Power BI, and cloud analytics to help businesses make data-driven decisions. I truly enjoy collaborating with cross-functional teams to streamline workflows and deliver actionable insights.
Currently, I work as a Data Analyst at Mastercard in New York, where I manage large-scale data sets and develop interactive dashboards that support product, finance, and risk teams. I’m passionate about using data to tackle challenges like fraud detection and improving business performance through advanced analysis and machine learning techniques.
Language
English
Fluent
Work Experience
Data Analyst at Mastercard
January 1, 2024 - June 10, 2024Collected, cleaned, and transformed over 5 TB of structured and unstructured financial data from Amazon RDS, Redshift, S3, and DynamoDB to support reporting, dashboarding, and machine learning use cases. Developed interactive Power BI and Tableau dashboards with real-time data feeds and 30+ dynamic KPIs, supporting product, finance, and risk teams and reducing ad-hoc reporting requests by 40%. Conducted advanced exploratory data analysis (EDA) using Python to identify trends and outliers for fraud detection and business insights. Collaborated with data scientists to prepare ML-ready datasets and automated recurring reports, reducing manual effort by 30%. Maintained scheduled reports and data refresh jobs using Apache Airflow and AWS Lambda, built parameterized SQL queries and Python scripts for flexible data extraction, and partnered with DevOps to streamline analytics deployment with CI/CD pipelines. Supported data governance initiatives ensuring 100% compliance, assisted in evaluatin
Data Analyst at Mastercard
January 1, 2024 - June 1, 2024Collected, cleaned, and transformed over 5 TB of structured and unstructured financial data from Amazon RDS, Redshift, S3, and DynamoDB to support reporting, dashboarding, and machine learning use cases. Developed interactive Power BI and Tableau dashboards with real-time data feeds and 30+ dynamic KPIs, reducing ad-hoc reporting requests by 40%. Conducted advanced exploratory data analysis using Python to identify trends and support fraud detection. Collaborated with data scientists to prepare ML-ready datasets and resolved data quality issues. Automated recurring reports and visualizations using SQL and Python, increasing reporting accuracy across 6 business units. Created and maintained scheduled reports and data refresh jobs using Apache Airflow and AWS Lambda. Partnered with DevOps to deploy analytics workflows via CI/CD pipelines using AWS CodePipeline and Terraform. Supported data governance initiatives ensuring 100% compliance. Assisted in evaluating fraud scoring models using
Data Analyst at Mastercard
January 1, 2024 - June 13, 2024Collected, cleaned, and transformed over 5 TB of structured and unstructured financial data from Amazon RDS, Redshift, S3, and DynamoDB to support reporting, dashboarding, and machine learning use cases. Developed interactive Power BI and Tableau dashboards with real-time data feeds and 30+ dynamic KPIs, supporting product, finance, and risk teams and reducing ad-hoc reporting requests by 40%. Conducted advanced exploratory data analysis using Python to identify trends, correlations, and outliers for fraud detection and business performance insights. Collaborated with data scientists to prepare ML-ready datasets and automated recurring reports using SQL and Python, reducing manual effort by 30%. Created and maintained scheduled reports and data refresh jobs using Apache Airflow and AWS Lambda. Partnered with DevOps to streamline deployment of analytics workflows with CI/CD pipelines. Supported data governance initiatives with 40+ validation checks ensuring compliance. Assisted in evalu
Data Engineer at BMO Financial Group
June 1, 2023 - September 30, 2023Migrated complex SQL-based data extraction workflows from Dataiku to SAS, improving processing time by 15.5%. Designed and deployed automated ETL pipelines using Apache Airflow, streamlined data testing and deployment cycles. Leveraged GCP BigQuery for large-scale customer data analysis, identifying usage trends and forecasting behavioral anomalies to support marketing strategies. Conducted statistical hypothesis testing to evaluate customer behavior changes, leading to over 500 new user sign-ups through data-driven campaigns. Created optimized joins across multiple datasets, improved query performance and accuracy in customer analytics reports. Integrated and maintained CRM analytics using Salesforce to boost customer engagement. Collaborated cross-functionally with data science, marketing, and CRM teams to deliver actionable insights and measurable business impact.
Data Engineer at BMO Financial Group
June 1, 2023 - September 30, 2023Migrated complex SQL-based data extraction workflows from Dataiku to SAS, improving processing time by 15.5% and enhancing maintainability. Designed and deployed automated ETL pipelines using Apache Airflow, streamlining data testing and deployment cycles. Leveraged GCP BigQuery to analyze large-scale customer data and forecast behavioral anomalies for marketing. Conducted statistical hypothesis testing leading to 500+ new user sign-ups through data-driven campaigns. Created optimized joins across 7+ datasets improving query performance and accuracy in customer analytics reports. Integrated CRM analytics using Salesforce, enhancing customer engagement. Collaborated with cross-functional teams to deliver actionable insights and drive measurable business impact.
Data Engineer at BMO Financial Group
June 1, 2023 - September 30, 2023Migrated complex SQL-based data extraction workflows from Dataiku to SAS, improving processing time by 15.5% and enhancing maintainability. Designed and deployed automated ETL pipelines using Apache Airflow, streamlining data testing and deployment cycles. Leveraged GCP BigQuery to analyze large-scale customer data and forecast behavioral anomalies for marketing strategy. Conducted statistical hypothesis testing (t-tests) to evaluate customer behavior changes, leading to over 500 new user sign-ups through data-driven campaigns. Created optimized joins across multiple datasets improving query performance and accuracy in analytics reports. Maintained CRM analytics using Salesforce, contributing to higher customer engagement. Collaborated with cross-functional teams to deliver actionable insights and measurable business impact.
Business Data Analyst at Accenture
August 1, 2019 - July 31, 2022Automated operational workflows and monitoring processes using SQL and Shell scripting within Citi Private Banking systems, increasing reliability and reducing manual intervention by 80%. Developed and optimized complex SQL queries for data extraction, transformation, and validation, ensuring data accuracy across high-volume financial datasets. Improved ETL batch job efficiency and reduced processing time by 40% by refining scheduling logic. Led incident and job failure analysis through ServiceNow, implementing real-time alerting systems and escalation workflows that cut resolution time by 30%. Built and maintained real-time dashboards in Power BI and Excel, providing visibility into job statuses and key financial KPIs. Designed 50+ advanced DAX measures and calculated columns in Power BI to create dynamic reports, reducing reporting turnaround time by 60%. Partnered with various teams to oversee server log monitoring, SSL certificate renewals, and compliance verifications, maintaining
Business Data Analyst at Accenture
August 1, 2019 - July 31, 2022Automated operational workflows and monitoring processes using SQL and Shell scripting within Citi Private Banking systems, increasing reliability and reducing manual intervention by 80%. Developed and optimized complex SQL queries for data extraction, transformation, and validation ensuring data accuracy across high-volume financial datasets. Improved ETL batch job efficiency reducing processing time by 40%, boosting SLA adherence by 15%. Led incident and job failure analysis through ServiceNow, implementing real-time alerting systems that cut resolution time by 30%. Built and maintained real-time dashboards in Power BI and Excel displaying job status, system performance, and financial KPIs. Designed 50+ advanced DAX measures to create dynamic reports reducing reporting turnaround time by 60%. Partnered with infrastructure, business, and vendor teams to oversee server log monitoring, SSL certificate renewals, and compliance verifications.
Business Data Analyst at Accenture
August 1, 2019 - July 31, 2022Automated operational workflows and monitoring processes using SQL and Shell scripting within Citi Private Banking systems, increasing reliability and reducing manual intervention by 80%. Developed and optimized complex SQL queries for data extraction, transformation, and validation ensuring accuracy across high-volume financial datasets. Improved ETL batch job efficiency by 40%, boosting SLA adherence by 15%. Led incident and job failure analysis through ServiceNow, implementing real-time alerting systems that cut resolution time by 30%. Built and maintained real-time dashboards in Power BI and Excel for job and financial KPI visibility. Designed over 50 advanced DAX measures creating dynamic, drill-through reports and reducing reporting turnaround time by 60%. Partnered with infrastructure, business, and vendor teams to oversee server log monitoring, SSL certificate renewals, and compliance verifications ensuring audit-ready operations.
Education
Master of Science at Indiana University, Bloomington, IN
August 1, 2022 - May 31, 2024Master of Science at Indiana University, Bloomington, IN
January 1, 2022 - May 1, 2024Master of Science at Indiana University, Bloomington, IN
August 1, 2021 - May 31, 2024Qualifications
Industry Experience
Financial Services, Professional Services, Software & Internet
Hire a Data Scientist
We have the best data scientist experts on Twine. Hire a data scientist in McKinney today.