Sandhya Patro
Data Analyst
Bengaluru,KA
Summary
Results-oriented Data Analyst specializing in ETL pipeline design and database management, refined at Examroom.ai. Demonstrated expertise in automating workflows and improving data integrity, while fostering collaboration with cross-functional teams. Proficient in SQL and data visualization, providing actionable insights that support business objectives.
Overview
10
10
years of professional experience
Work History
Data Analyst
Examroom.ai
Banglore
07.2023 - Current
- Feedback Survey ETL : Designed and implemented an ETL pipeline to extract user inputs from IVR calls via Amazon Connect CloudWatch logs, integrating the data into Amazon Redshift for downstream analytics.
- Ensured accurate capture of user-state mapping based on IVR inputs, to support regional analysis.
- Automated ETL workflows using Apache Airflow improve reliability and reduce manual intervention.
- Finance Console – Data Modeling: Led the data modeling efforts for the Finance Console platform, translating business logic and Figma designs into an efficient, normalized schema.
- Built and deployed the database on PostgreSQL, creating optimized tables and relationships to support key finance workflows.
- Leveraged DBdocs for schema design and documentation, improving cross-team understanding and maintainability.
- Amazon RDS – Database Administration & Optimization : Administered Amazon RDS databases, managing access control, backups, and restorations to ensure data integrity and security.
- Developed and optimized several stored procedures to improve data processing performance for varied business scenarios.
- Authored detailed DB docs to document database design, schemas, and best practices, facilitating team onboarding and knowledge sharing.
IT Data Analyst
Dell Technologies
Banglore
07.2021 - 07.2023
- Maintained records on incident reduction and performance metrics monthly and quarterly.
- Analyzed trends and identified areas for improvement through data assessment.
- Utilized SQL for data extraction, creating stored procedures, and managing triggers.
- Implemented window functions and views to enhance database analysis.
- Conducted exploratory data analysis using Pandas for deeper insights.
Sr. Compliance Analyst
Amazon Development Centre
Pune
11.2017 - 07.2021
- Analyze the daily inflow of products and generate reports by categorizing them into groups of Dangerous Goods regulations. Analyze daily utilization data to find unproductive time spent on the floor, and publish daily reports for the same.
- Analyze daily defects in quality to identify their trend, and formulate strategies to resolve them.
- Create an interactive report in Power BI for all the daily analyses. Report violations of rules, regulations, policies, and procedures by evaluating or investigating errors.
Quality Analyst
Firstcry.com
Pune
06.2015 - 10.2017
- Analyzing & tracking the team's performance as per the SOP. Helping the team to perform with 100% quality.
- Discussing the error points with the team.
- Training the new joiners and mentoring them whenever required. Working with any kind of testing on new projects.
- Collaborated with cross-functional teams to identify quality issues.
Education
BSc - Biotechnology
P. E. Institute of Modern College
Pune01.2015
Bachelor of Science - Science
Kisan Veer Mahavidyalaya
Satara01.2012
10th -
Sanjeevan Vidyalaya
Panchgani01.2010
Skills
- Data analysis and insights
- ETL workflow automation
- Database management
- Data modeling and documentation
- Exploratory data analysis
- Data visualization with Power BI
- Cloud services expertise
- ETL pipeline design
- SQL querying
- Data warehouse knowledge
Languages
Languages Known: English, Hindi, Marathi, Odia
Languages
Hindi
First Language
English
Upper Intermediate (B2)
B2
Work Preference
Work Type
Full TimeWork Location
RemoteHybridImportant To Me
Work-life balanceCareer advancementFlexible work hoursTimeline
Data Analyst
Examroom.ai
07.2023 - Current
IT Data Analyst
Dell Technologies
07.2021 - 07.2023
Sr. Compliance Analyst
Amazon Development Centre
11.2017 - 07.2021
Quality Analyst
Firstcry.com
06.2015 - 10.2017
BSc - Biotechnology
P. E. Institute of Modern College
Bachelor of Science - Science
Kisan Veer Mahavidyalaya
10th -
Sanjeevan Vidyalaya
Similar Profiles
Naveen Arockiasamy KNaveen Arockiasamy K
Proctor / Onboarding Agent at Examroom.aiProctor / Onboarding Agent at Examroom.ai
Vivek NeekhraVivek Neekhra
Data Scientist at Examroom.AIData Scientist at Examroom.AI
Nevint N. VNevint N. V
Software Engineer - Dot Net Developer at Examroom.AISoftware Engineer - Dot Net Developer at Examroom.AI
Neha DasguptaNeha Dasgupta
Team Lead – Inside Sales & Growth Strategy at LivspaceTeam Lead – Inside Sales & Growth Strategy at Livspace
ANUSHA VIJAY SHETANUSHA VIJAY SHET
Financial Treasury Analyst at Goldman SachsFinancial Treasury Analyst at Goldman Sachs