Pankati Patel

Data focused Computer Scientist and Data Analyst with experience in data analysis, database design, data preprocessing, data utilization, storage, conditioning, retrieval systems, and full stack application development across cloud and on-premise environments. Skilled in SQL, Python, and JavaScript, with experience writing and modifying scripts to automate data processing workflows, normalize datasets, and support systems. Experienced in applying quantitative and qualitative analytical methods to evaluate datasets and communicate findings, including preparing and delivering briefings to stakeholders and technical audiences.

Experienced in Agile Software Development Life Cycle (SDLC) environments, API driven development and secure software engineering practices supporting scalable data systems.

Freelance Backend Developer – Real Estate Data Systems at Self – Employed (2025-01 – Present)

Designed and implemented secure relational database system for data storage, retrieval, and conditioning using MySQL and SQL based architecture. Developed and optimized SQL queries and scripts to automate data retrieval, normalization, and reporting workflows.

• Designed and implemented secure relational database system for data storage, retrieval, and conditioning using MySQL and SQL based architecture
• Developed and optimized SQL queries and scripts to automate data retrieval, normalization, and reporting workflows
• Created ER diagrams and relational data models to ensure data integrity, consistency, and reduced redundancy
• Developed PHP based CRUD applications to support structured data input, processing and secure backend operations
• Applied data validation and quality checks to ensure accuracy and reliability of stored datasets

Software Engineer/Project Manager – Data Tracking System at Kean University (2023-01 – 2023-05)

Led development of a data driven tracking system collecting, processing, and analyzing 800+ user interaction datasets. Designed relational database architecture to support data storage, retrieval, conditioning, and analytical processing of clickstream data.

• Led development of a data driven tracking system collecting, processing, and analyzing 800+ user interaction datasets
• Designed relational database architecture to support data storage, retrieval, conditioning, and analytical processing of clickstream data
• Independently developed Python and SQL scripts to automate data preprocessing, and transformation
• Applied quantitative methods to evaluate datasets and identify patterns, trends, anomalies, and data gaps
• Implemented authentication and validation protocols to ensure secure data handling and system integrity
• Created data visualizations & analytical reports to support data driven decision-making
• Assisted in determining stakeholder requirements for data reporting and automation solutions
• Translated customer requirements into technical specifications, data models, and system architecture designs
• Identified data gaps and inconsistencies and recommended and implemented improvements to data structure and collection methods
• Managed Agile team of 5 developers and coordinated delivery, analytics features, and documentation

Graduate Research Assistant – Data Analytics & Usability Research at Kean University (2022-01 – 2023-06)

Collected, processed, and analyzed large scale datasets (1,000+) to support usability research and behavioral pattern analysis. Performed data cleaning, conditioning, validation, and preprocessing to ensure dataset integrity.

• Collected, processed, and analyzed large scale datasets (1,000+) to support usability research and behavioral pattern analysis
• Performed data cleaning, conditioning, validation, and preprocessing to ensure dataset integrity
• Applied qualitative and quantitative methods to evaluate user interaction patterns and usability metrics
• Developed charts, graphs, and dashboards to communicate analytical findings
• Prepared and delivered data analysis briefings to faculty and research stakeholders

Web Developer – COVID Data Analytics Dashboard at Kean University (2021-05 – 2021-07)

Developed interactive data visualization dashboards using JavaScript and ArcGIS. Built AWS EC2 based pipelines to support automated data retrieval and near real time updates.

• Developed interactive data visualization dashboards using JavaScript and ArcGIS
• Built AWS EC2 based pipelines to support automated data retrieval and near real time updates
• Created scripts to support data processing, transformation, and visualization workflows
• Improved accessibility of complex datasets through interactive visual reporting tools supporting data driven insights

Code Samurai – SQL & Systems Mentor at Kean University (2021-01 – 2023-05)

Provided instructions in SQL programming, data querying, debugging, and relational database concepts. Guided students in data analysis, logic development, and scripts for database systems.

• Provided instructions in SQL programming, data querying, debugging, and relational database concepts
• Guided students in data analysis, logic development, and scripts for database systems
• Assisted students in understanding data retrieval, query optimization, and analytical reasoning

Master's of Science in Computer Information Systems – Kean University

Bachelor of Science in Computer Science – Kean University