Data Analyst Quality

Janhavi Chalapathy

*************@*****.*** +1-321-***-**** Florida, USA

PROFESSIONAL SUMMARY

Data Analyst with 3 years of experience specializing in database management, data pipeline development, and data quality automation. Skilled in PL/SQL, Oracle Exadata, and PostgreSQL, with a strong background in designing and optimizing complex SQL queries and stored procedures. Proficient in Python for ETL processes and data validation, utilizing tools such as Jupyter Notebooks and Microsoft Excel to support detailed analysis and reporting. Experienced in migrating on-premise databases to AWS and supporting Agile teams through effective test scenario design and project estimation.

TECHNICAL SKILLS

Databases: Oracle Exadata, Oracle 10g, PostgreSQL

Cloud & Migration: AWS, On-premise to Cloud Migration (Oracle Exadata to AWS)

ETL & Data Pipelines: ETL Pipelines (Python-based), Stored Procedures (Oracle), Data Quality Automation (Python)

Agile & Testing Tools: Agile Scrum Tools, Test Scenario Design, Validation Routines (Oracle)

Programming & Scripting: PL/SQL, Python, Python (Pandas)

Data Analysis & Query Tools: Complex SQL Queries, Jupyter Notebooks, Microsoft Excel, Microsoft PowerPoint

WORK EXPERIENCE

Citian, Data Analyst Mar 2024 - Present

●Developed and optimized complex PL/SQL queries within Oracle Exadata databases to support real-time transportation data analysis and reporting for public sector clients.

●Built and maintained ETL pipelines using Python, ensuring accurate and timely delivery of data to analytics and GIS teams for transportation planning projects.

●Created interactive data visualizations in Jupyter notebooks, translating technical findings into clear insights for both technical and non-technical stakeholders within city transportation departments.

●Improved data model structures and warehouse designs to support growing volumes of transportation data while maintaining reliable query performance in Oracle environments.

●Implemented automated data quality checks throughout ETL processes, helping ensure the integrity and accuracy of transportation datasets used for policy and operational decisions.

●Developed reusable Python scripts to transform and aggregate data from multiple sources, supporting agile responses to new analytics requests from urban planning teams.

●Configured and tuned Oracle and PostgreSQL databases to handle high-frequency transaction data generated by transportation IoT devices and management systems.

●Documented analytical workflows, data definitions, and process diagrams using Microsoft Office suite, making it easier for cross-functional teams to understand and use data assets.

●Participated in Agile sprints, estimating effort for new analytics features and helping prioritize tasks based on input from transportation leaders and technical stakeholders.

●Supported the migration of on-premise database systems to Oracle Exadata and AWS, improving system scalability and enabling advanced analytics on large-scale transportation data.

CaterTrax, Data Engineer Jun 2022 - Oct 2023

●Developed and maintained PL/SQL scripts and stored procedures on Oracle 10g to analyze wholesale credit transaction data and support regulatory reporting for foodservice management clients.

●Designed robust test scenarios and validation routines to ensure the integrity of client onboarding and KYC data within Oracle Exadata environments, improving compliance workflows for catering operations.

●Created detailed business requirements and user stories by collaborating with catering business teams, supporting Agile sprint planning and prioritization of analytics projects.

●Built interactive Excel dashboards and PowerPoint presentations using Microsoft Office suite to present operational insights to both kitchen managers and executive leadership.

●Analyzed end-to-end data flows across foodservice ordering, billing, and inventory applications, identifying key integration points and recommending improvements to streamline order lifecycle processes.

●Reviewed complex SQL queries and optimization strategies to improve performance for reporting tools used by client onboarding and customer service teams.

●Facilitated technical discussions and translated analytics findings for both technical IT staff and non-technical business stakeholders, adapting communication style as needed for various audiences.

●Estimated level of effort and resource requirements for analytics projects, supporting project managers with scoping and financial planning for new initiatives.

●Contributed to Agile team meetings by clarifying acceptance criteria, raising technical questions, and helping guide the team toward delivering business value.

●Supported multiple concurrent projects by identifying task priorities, tracking deadlines, and proactively reaching out to subject matter experts when additional information was needed.

EDUCATION

Master of Science in Computer Information Systems,

Florida Institute of Technology Florida, USA 3.8

Computer Science

K.S. School of Engineering and Management (KSSEM) Bangalore, India 3.6

Contact this candidate