Data Analyst Supply Chain
Resume:
Soniya Nelapati
Data Analyst
Location: New Jersey, USA Ph: 929-***-**** Mail: **********@*****.*** LinkedIn PROFESSIONAL SUMMARY:
4+ years of experience as a Data Analyst proficient in analyzing transactional and customer data using Excel, SQL, Python and R to drive data-driven marketing strategies.
Experienced in managing and optimizing SAP ERP transactions, conducting supply chain and inventory analysis and generating SAP BI reports.
Skilled in designing and implementing data models, developing and automating ETL workflows with Azure Data Factory and executing A/B testing.
Adept at financial forecasting, risk assessment and creating interactive Tableau dashboards for data visualization.
Proven ability to analyze SQL-based data for fraud detection and implement Alteryx workflows for reporting automation. Experienced in agile methodologies including scrum meetings, user story definition and backlog management.
Proficient in requirements gathering, creating business and system use cases with UML diagrams in MS Visio, financial data analysis and risk assessment. Skilled in developing dashboards in Excel and Tableau, utilizing Jira for project task management.
TECHNICAL SKILLS:
Data Analysis: Python, R, SQL, Excel
Data Visualization: Tableau, Power BI, Excel (Pivot Tables, LOOKUP Functions) Data Management: SAP ERP, SAP BI, Azure Data Factory, Alteryx Statistical Analysis: A/B Testing, Financial Modeling, Budget Forecasting ETL & Data Modeling: Azure Data Factory, ETL Workflows, Metadata Management, Data Lineage, Lifecycle Management, ER Diagrams, Dimensional Models
Reporting Tools: Tableau Dashboards, PowerPoint, Excel Reports Collaboration Tools: Jira, Agile Methodologies, Scrum Meetings Database Management: SQL, SAP BI Tools
Prototyping & Diagrams: MS Visio, UML Diagrams
Automation: Alteryx Workflows, Automated Reporting Processes Business Analysis: Business Use Cases, System Use Cases, Gap Analysis EDUCATION:
Master of Computer Science - New York Institute of Technology, New York, USA. Bachelor of Computer Science - Siddharth Institute of Engineering and Technology andhra Pradesh, India PROFESSIONAL EXPERIENCE:
MetLife – NY Sep 2023 – Present
Data Analyst
Utilized Excel, SQL, Python and R to analyze large transactional and customer data sets, identifying key trends that led to a 20% improvement in customer acquisition rates through data-driven marketing strategies.
Managed and optimized SAP ERP transactions, conducted in-depth supply chain and inventory analysis and generated SAP BI reports to enhance operational compliance and strategic decision-making.
Designed and implemented data models (ER diagrams, dimensional models) to support insurance claims analytics, fraud detection and customer segmentation, ensuring efficient data structuring for advanced analysis.
Developed and automated ETL workflows using Azure Data Factory, optimizing data integration across insurance systems, reducing processing time by 50% and improving data governance, metadata tracking and lineage management.
Executed A/B testing on policy pricing, claims processing and customer engagement strategies, deriving insights that optimized premium structures and improved customer retention rates.
Conducted financial forecasting and risk assessment using Excel and statistical modeling, providing predictive insights on profit margins, claims reserve and underwriting decisions to senior management.
Designed and developed interactive Tableau dashboards to visualize insurance claims trends, policyholder behavior and underwriting performance, enabling real-time decision-making for business leaders.
Analyzed SQL-based insurance claims data to detect fraudulent activities, claim anomalies and inefficiencies, leading to an 18% reduction in processing costs and improved fraud detection accuracy.
Implemented Alteryx workflows to automate insurance reporting processes, reducing manual data handling time by 25% and enhancing efficiency in regulatory compliance reporting. Smart AI – India Jul 2019 – Jul 2022
Data Analyst
Actively participated in daily scrum meetings to enhance team collaboration, effectively defined user stories and meticulously managed the product backlog, ensuring adherence to agile methodologies that drive project efficiency in banking initiatives.
Conducted in-depth surveys and prototyping sessions with key stakeholders, clients and subject matter experts to extract and document precise user and business requirements, thereby clearly defining the scope of the online banking system.
Expertly created detailed Business and System Use Cases, supported by comprehensive UML diagrams using MS Visio, to facilitate clear communication of system functionalities and user interactions within the banking framework.
Collaborated with senior analysts to execute thorough financial data analysis and reporting, contributing to budgeting, forecasting and financial modeling efforts while researching industry trends to deliver actionable insights for investment strategies.
Developed dynamic and interactive dashboards in Tableau to visualize essential financial metrics such as loan performance, deposit trends and customer segmentation, empowering stakeholders to make data-driven decisions.
Managed time-sensitive project deliverables, ensuring all tasks were completed on schedule and met stakeholder expectations through effective communication and diligent project tracking.
Conducted comprehensive risk assessments on loan portfolios and investment products, identifying potential risks and formulating mitigation strategies to protect the bank's assets and enhance overall financial stability.
Designed visually impactful dashboards in Excel and Tableau for data reporting, employing advanced techniques such as pivot tables and LOOKUP functions to extract, interpret and analyze data, transforming raw data into actionable insights.
Utilized Jira for the creation and management of project tasks, user stories and sprints, fostering collaboration and transparency among team members to streamline project workflows in the banking sector.
Contact this candidate