Data Analyst Analytics

MOHAN KALYAN CHINTALA

+1-561-***-**** *******************@*****.*** www.linkedin.com/in/chintala-mohan-kalyan SUMMARY

Data Analyst with 3+ years of experience in healthcare and finance, bringing a robust understanding of data analytics, business intelligence, and full-stack development. Proficient in SQL (MySQL, Oracle, SQL Server), Python, and ETL processes (Informatica, Control-M), along with cloud data platforms such as AWS Redshift and Snowflake. Adept at creating interactive dashboards using Tableau and Power BI, optimizing data pipelines, and providing data-driven insights to stakeholders. Holds Google Data Analytics and Snowflake certifications. Graduated in M.S. in Computer and Information Sciences at Florida Atlantic University.

TECHNICAL SKILLS

Programming & Query Languages: SQL (MySQL, Oracle, SQL Server), Python (Pandas, NLTK, NumPy), R (tidyverse, ggplot2), JavaScript (ES6+, Node.js, React.js, Vue.js), Bash / PowerShell Data Tools & Platforms: AWS (S3, Redshift), Snowflake, Oracle SQL Developer, Informatica, Google BigQuery(Overview familiarity), IcedQ (data quality validation). ETL & Workflow Orchestration: Informatica PowerCenter, Control-M, Apache Airflow (basic experience), Talend (exposure), Data Cleaning & Transformation (ETL/ELT pipelines, data validation) BI & Visualization: Tableau, Power BI, Excel (PivotTables, VLOOKUP, Charts), Data Modeling, Data Architecture, Data Visualization, Reporting.

Data Warehousing & Database Management: Data Warehousing Concepts (star/snowflake schemas, normalization), Snowflake Data Platform (warehousing, warehousing best practices), AWS Redshift

(cluster setup, query optimization), Oracle & SQL Server DB maintenance, indexing, performance tuning

Web Development & APIs: Front-end: HTML5, CSS3, Bootstrap, Vue.js, React.js, Back-end: Node.js

(Express), PHP (REST APIs), Databases: MySQL, PostgreSQL, Full-stack Integration (client-server communication, RESTful services)

Methodologies: Agile/Scrum, CI/CD, Git/Bitbucket, JIRA Data Science & Machine Learning: Statistical Analysis (hypothesis testing, regression, A/B testing), Predictive Modeling (scikit-learn, Keras/TensorFlow), Data Mining & Feature Engineering, Time Series Analysis (forecasting), Social Network Analysis (NetworkX), NLP (text processing with NLTK, spaCy), Anomaly Detection (intrusion detection, cybersecurity models) Domains: Healthcare Analytics (EHR, HIPAA, Claims), Financial Analytics (Forecasting, Budgeting, KPI Reporting)

EXPERIENCE

Data Analyst Morgon Stanley, Alpharetta, GA, USA Jan 2025 - Current Extracted, transformed, and analysed large-scale financial datasets using Oracle SQL Developer and Python for budget forecasting and executive reporting. Developed and maintained rolling financial forecasting models, increasing revenue prediction accuracy by 15%.

Built and deployed Tableau dashboards to visualize key financial KPIs, enabling leadership to identify trends and budget variances more efficiently.

Automated ETL workflows using Control-M to ensure timely and consistent updates to the enterprise financial data warehouse.

Conducted comprehensive data validation using IcedQ, identifying data discrepancies and improving report accuracy for compliance reporting.

Associate Software Engineer CVS Health, Tallahassee, FL, USA May 2024 – Dec 2024 Designed and built ETL pipelines using Informatica to consolidate electronic health records (EHR) and claims data into a centralized data mart.

Developed and published interactive dashboards using Tableau and Power BI to support clinical performance tracking and operational decision-making. Implemented IcedQ data quality frameworks to monitor and validate large-scale healthcare datasets, resulting in a 10% reduction in reporting errors.

Collaborated with clinicians, healthcare administrators, and cross-functional stakeholders to gather requirements and deliver actionable data insights. Ensured HIPAA-compliant handling of patient-level data while optimizing data accuracy, integrity, and usability for downstream analytics teams.

BI Analyst Carelon Global Solutions, Bengaluru, India Aug 2022 – Dec 2023 Developed ETL pipelines utilizing Informatica to consolidate patient and claims data from clinical and billing systems into a central analytics database. Created and published Tableau dashboards for hospital metrics and claims analysis, empowering management to identify high-cost claim categories and potential cost reduction opportunities. Implemented data quality frameworks with IcedQ to monitor and ensure healthcare data accuracy, resulting in a 10% reduction in data errors.

Collaborated with healthcare stakeholders to gather requirements and transform them into actionable analytics solutions, enhancing decision support for patient care management. Front-End Web Development Intern TCR Innovation Jan 2022 - June 2022 Completed a hands-on internship at Technical Coding Research Innovation (TCR Innovation), Navi Mumbai, where I gained practical experience in building modern, responsive web applications. Over the course of the internship, I received training and worked on a real-time project using HTML, CSS, JavaScript, VueJS, PHP, and MySQL, enabling me to understand both front-end and basic back-end integration.

Built a full-featured website “CAFESSA” with interactive components using Vue.js, styled with CSS & Bootstrap, and connected to a MySQL backend via PHP REST APIs. Understood how to structure and deploy a front-end application, perform database operations, and manage client-server communication.

Gained exposure to XAMPP, Visual Studio Code, and version control for full-stack development workflows.

PROJECTS

Social Network Analysis for Community Detection: Developed a tool using Networkx and Python to identify key influencers and community structures by applying graph algorithms (PageRank, centrality measures).

AI-Based Resume Screening System: Designed an NLP-driven tool using Python, NLTK, and spaCy for text processing, keyword extraction, and candidate ranking based on job descriptions. AI-Powered Personalized Learning Platform: Created a full-stack e-learning platform with adaptive quizzes and course recommendations using React.js, Node.js, PostgreSQL, and NLP models for personalized learning and progress tracking.

Carbon credit tracking: Developed a mobile-based Carbon Credit Tracking System that empowers individuals and businesses to monitor emissions, trade credits, and promote eco-conscious behaviour through real-time travel and sustainability insights. CERTIFICATIONS

Snowflake certification

Google data analytics

python in excel getting started with data analysis. nexcel with copilot with AI driven data analysis.

EDUCATION

Florida Atlantic University, Boca Raton, FL - Master of Science in Computer Science New Horizon College of engineering, Bangalore, India - Bachelor of Technology in Computer Science and Engineering

Contact this candidate