Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Ranjani

Charlotte,USA

Summary

Adept at leveraging advanced data analytics and visualization skills, including Python and Tableau, I significantly enhanced reporting processes and predictive modeling at Ernst and Young, driving actionable insights for global tax compliance. My collaborative approach and problem-solving abilities have streamlined workflows, ensuring data integrity and supporting strategic decision-making across multinational teams.

Overview

7
7
years of professional experience

Work History

Software Engineer/ Lead

Ernst and Young
Chennai, India
01.2020 - 07.2023
  • Company Overview: CMT or Commercial Management Tool is a CT Tax managed global EY product to manage “scope of work” and associated fees charged, along with workflow management and billing
  • CMT is a web application that will be used across EY areas (Americas, EMEIA & APAC) hosted on EY cloud and uses SQL server
  • Data Extraction & Analysis: Utilized SQL and Python to extract and analyze tax-related data from the Commercial Management Tool (CMT), focusing on scope of work, associated fees, workflow management, and billing data across EY's global regions (Americas, EMEIA, APAC)
  • Reporting & Dashboarding: Created and maintained real-time, interactive dashboards using Tableau to track project billing, scope, and fee status, enabling stakeholders to visualize data across regions and timeframes
  • Data Validation & Integrity: Performed thorough data validation and integrity checks on the data within SQL Server, ensuring accurate, reliable data for reporting and decision-making within the CMT web application
  • Process Optimization: Collaborated with cross-functional teams to optimize the data flow and enhance the reporting process, focusing on the seamless integration of tax data between the CMT application and other internal systems
  • Workflow Automation: Designed and implemented automated data workflows in collaboration with the development team to enhance the efficiency of billing and fee management processes within the CMT application
  • Tax Compliance & Insights: By using advanced Excel, Google Sheets, and Matplotlib tools to perform in-depth analysis on scope of work, tax compliance, and financial data, delivering actionable insights to the tax management team
  • Predictive Modeling: Utilized statistical methods such as logistic regression, linear regression, and decision trees to develop predictive models that forecast future tax liabilities and potential fee discrepancies, improving billing accuracy
  • Collaboration & Stakeholder Support: Acted as a liaison between tax, finance, and technology teams to define requirements, ensure proper data usage, and resolve any issues related to data discrepancies or reporting challenges in the CMT system
  • A/B Testing & Experimentation: Conduct A/B testing on reporting tools and dashboard features to determine the most effective configurations for tax and billing data presentation across different regions
  • Global Tax Reporting: Assisted in the generation of global tax reports and data visualizations for senior management, ensuring that the insights meet the business and compliance needs of EY's global operations
  • CMT or Commercial Management Tool is a CT Tax managed global EY product to manage “scope of work” and associated fees charged, along with workflow management and billing
  • CMT is a web application that will be used across EY areas (Americas, EMEIA & APAC) hosted on EY cloud and uses SQL server

Associate

Cognizant Technology Solutions
Chennai, India
04.2016 - 01.2020
  • Company Overview: E
  • TRADE Financial Corporation is a financial services company, an online discount stock brokerage firm for self-directed investors
  • Investors can buy and sell such securities as stocks, options, mutual funds and exchange-traded funds via electronic trading platforms or by phone
  • Data Analysis & Reporting: Analyzed large datasets from E
  • TRADE’s trading platform to identify trends, patterns, and market behavior, supporting decision-making for securities like stocks, options, and ETFs
  • SQL & Python for Data Manipulation: Utilized SQL for querying and Python (scikit-learn) for data processing, feature engineering, and predictive modeling to uncover valuable insights related to trading performance, risk management, and customer behavior
  • Data Visualization: Developed interactive dashboards and reports in Tableau and Excel to provide real-time visual insights on trading activity, market performance, and investment trends for stakeholders
  • Predictive Modeling & Statistical Analysis: Implemented logistic regression, linear regression, and decision trees to build models that forecast market movements, analyze investment strategies, and evaluate the risk-return profile of different securities
  • Product Analytics: Conducted A/B testing and experimentation to assess the impact of new trading features, user interface changes, and platform enhancements on investor behavior and engagement
  • Market Performance Tracking: Regularly tracked and reported on trading performance, portfolio risk, and investor behavior using tools like Google Analytics and Matplotlib, providing actionable insights for business teams
  • Cross-Functional Collaboration: Worked closely with product managers, trading analysts, and IT teams to ensure data is integrated seamlessly from various sources (trading systems, customer interactions, etc.), ensuring accuracy and consistency in reports and insights
  • Compliance & Risk Management: Performed data audits and ensure adherence to regulatory requirements by analyzing transaction data for compliance, security, and tax implications, working closely with the compliance team
  • Customer Insights & Behavior Analysis: Analyzed customer behavior data to identify patterns in trading habits, helping to optimize E
  • TRADE’s offerings and improve user experience across digital platforms
  • Data Quality Assurance: Conducted regular data validation and quality checks to ensure that data used for analysis and reporting is accurate, timely, and reliable
  • E
  • TRADE Financial Corporation is a financial services company, an online discount stock brokerage firm for self-directed investors
  • Investors can buy and sell such securities as stocks, options, mutual funds and exchange-traded funds via electronic trading platforms or by phone

Education

MS - Big Data Analytics & Information Technology

University of Central Missouri
Lee’s Summit, MO, USA
12.2024

MBA - International Business

Pondicherry University (Loyola College)
Chennai, India
06.2019

Bachelor of Technology - Computer Science & Engineering

SKR Engineering College
Chennai, India
05.2015

Skills

  • Python
  • R
  • MS SQL SERVER
  • MySQL
  • PostgreSQL
  • DynamoDB
  • Tableau
  • Power BI
  • Matplotlib
  • Seaborn
  • IAM
  • EC2
  • S3
  • Redshift
  • JIRA
  • Azure DevOps

Projects

Boston Crime Data Analysis and Visualization Project, Tableau, Excel, Python, MO, USA, Using sample dataset from Kaggle on Boston crime data to perform various analyses, including removing duplicates and applying joins. Based on the crime rate data, I created visualizations to analyse different scenarios. B2B Sales and Customer Insight Analysis (E-commerce Website), Python, logistic regression model, MO, USA, Using a sample Amazon dataset, we predicted performance reports by applying a deep learning logistic regression model to the Courier Status field, achieving an overall accuracy of 92%.

Timeline

Software Engineer/ Lead

Ernst and Young
01.2020 - 07.2023

Associate

Cognizant Technology Solutions
04.2016 - 01.2020

MS - Big Data Analytics & Information Technology

University of Central Missouri

MBA - International Business

Pondicherry University (Loyola College)

Bachelor of Technology - Computer Science & Engineering

SKR Engineering College

Similar Profiles

CREATE PROFILE
Ranjani