Meghana Sruthi Pydipati
Gurgaon
Summary
Experienced Data Analyst adept at leveraging analytical skills to drive actionable insights for companies. Proactive leader with expertise in optimizing data processes, task prioritization, and problem-solving. Demonstrated strong work ethic, adaptability, and exceptional interpersonal skills, coupled with a desire for continuous learning and taking on new challenges.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Targray India Pvt. Ltd.
Gurgaon
03.2023 - Current
- Implemented Risk Reporting measures such as Positions, VaR and Mark to Market, by sourcing data into a normalized database, calculating measures using Python-based models and reporting the results through user-friendly dashboards
- Devised a statistical solution for deriving the Price Trend using Scikit, Pandas & Numpy
- Built a quantitative model to derive UT Bot Alert Indicators to identify profitable trade opportunities with high risk reward ratios
- Coordinated with Team to gather and prepare data for creating Power BI dashboards for Risk Management
- Worked on Intelligent Document Processing of WorkFusion - an end-to-end automated solution to extract data from documents using OCR & ML Models
- Led work on Automation Scripts for Data Gathering.
- Supervised existing programming processes from concept through production, optimizing source code for responsible data management and analysis.
Data Analyst
Targray India Pvt. Ltd.
Gurgaon
10.2021 - 03.2023
- Gathered requirements from stakeholders to design data-based automation pipelines and reports.
- Developed Automation Scripts for Data Gathering using Selenium, Beautiful Soup, from varied sources - Websites (subscribed & non-subscribed), SFTP, APIs, Excel Files, PDF Files, and other process automations
- Automated manual reporting processes by developing scripts in Python.
- Designed an automated process to generate kml to display geographic data.
- Conducted exploratory data analysis of complex datasets for Risk Management using Python libraries such as NumPy and Pandas.
- Prepared a reporting tool on Power BI for Price Trend Analysis on processing data using SQL.
- Trained junior analysts on best practices in data mining and visualization tools.
Business Analyst
Dhatri Mines & Minerals Pvt. Ltd.
Hyderabad
11.2017 - 09.2021
- Maintained Operational and Financial data to monitor transactions and daily dispatches
- Analyzed operational data, surfacing insights and findings to support business and technical decisions.
- Developed financial models and forecasts to support business decisions.
- Created dashboards for buyer statistics and performed age-wise analysis of receivables
- Managed projects and served as liaison between client and internal groups to clarify terms and meet deadlines.
Consultant
Deloitte US India
Hyderabad
06.2015 - 07.2017
- Worked on developing data-handling applications that simplified reading of US Tax Forms through automation, thereby reducing the time taken by nearly 75%
- Improved end-to-end Processing Time of applications by optimizing ASP.NET code and SQL Stored procedures
- Assisted in the development of complex SQL queries to support project objectives
- Hands-on experience in Macros & VBA scripts and Spreadsheet Analysis for Financial forms in MS Excel
Education
MBA - Finance & Marketing
Amity Business School, Amity University
05.2015
B.Tech - Electronics & Communication Engineering
SASTRA University
05.2013
Skills
- Python Programming
- Statistical & Quantitative Analysis
- Machine Learning - Correlation, Regression, Classification
- Price Trend Data Analysis
- Risk Analysis & Reporting - Value-at-Risk, Positions & Exposure, Mark-to-Market, P&L
- MS SQL
- MS Excel - VBA, Macros, Power Query
- RPA - Automation Anywhere, WorkFusion
- ETL Tools - MS Power BI, Qlikview
- SQL Server Integration Services (SSIS)
- ASP NET Development
- MVC Framework
- C#, C
Certification
- Jun 2022: IBM Certified Course on: Exploratory Data Analysis for Machine Learning Supervised Machine Learning: Classification Supervised Machine Learning: Regression Unsupervised Machine Learning Coursera
- Jun 2021: Automation Anywhere Certified Advanced RPA Professional V11.0 Automation Anywhere
- Jan 2021: Data Analyst with Python Track DataCamp
- Dec 2013: Six Sigma Green Belt (CSSGB) BSI
Accomplishments
DhatriTargrayTargray
- Spot Awards by Deloitte USI for outstanding value to clients.
- QAI Emerging Leader Award by QAI Global Services at Amity University for demonstrating managerial abilities and team building skills.
- Award for 'Best in Leadership Qualities' by Amity University Uttar Pradesh for demonstrating consistency, confidence, and competence through creative and quality-driven approach.
Languages
Telugu
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Tamil
Beginner (A1)
A1
Spanish
Beginner
A1
Timeline
Senior Data Analyst
Targray India Pvt. Ltd.
03.2023 - Current
Data Analyst
Targray India Pvt. Ltd.
10.2021 - 03.2023
Business Analyst
Dhatri Mines & Minerals Pvt. Ltd.
11.2017 - 09.2021
Consultant
Deloitte US India
06.2015 - 07.2017
MBA - Finance & Marketing
Amity Business School, Amity University
B.Tech - Electronics & Communication Engineering
SASTRA University
Similar Profiles
Sneha MuthineniSneha Muthineni
Software QA Engineer at Targray India Pvt LtdSoftware QA Engineer at Targray India Pvt Ltd
Randhir Kumar PrasadRandhir Kumar Prasad
Stacker at Engineering and Allied Services Pvt. Ltd, Lift & Shift India Pvt. Ltd, Roadwings International Pvt. Ltd, Western Carriers India Pvt. Ltd, Tractor India Pvt. Ltd, Transworld Terminal Pvt. LtdStacker at Engineering and Allied Services Pvt. Ltd, Lift & Shift India Pvt. Ltd, Roadwings International Pvt. Ltd, Western Carriers India Pvt. Ltd, Tractor India Pvt. Ltd, Transworld Terminal Pvt. Ltd
Viraja ParanjapeViraja Paranjape
Associate Director, Financial Risk Remediation at UBS Business Solutions (India) Pvt. Ltd. (Erstwhile Credit Suisse Services (India) Pvt. Ltd.)Associate Director, Financial Risk Remediation at UBS Business Solutions (India) Pvt. Ltd. (Erstwhile Credit Suisse Services (India) Pvt. Ltd.)
Smriti RanaSmriti Rana
Technical Architect & Lead at Builder.aiTechnical Architect & Lead at Builder.ai
Sakshi ShuklaSakshi Shukla
Supervisor (C9) at Citi Corp ServicesSupervisor (C9) at Citi Corp Services