Data analyst

Kiran Chalamala

Miami, FL +1-513-***-**** *****.**********@*****.*** linkedin.com/in/chalamkn

Education:

Master of Information Technology, University of Cincinnati 01/2023 – 04/2024

Academic Projects:

Project 1: Data Analysis and Visualization with Python and SQL for Business Insights 04/2023-07/2023

Key Point: Analyzed large datasets using Python and SQL, creating interactive visualizations in Power BI to deliver actionable insights that improved decision-making by 25%.

Project 2: Automated Reporting with SQL and Excel 01/2024-04/2024

Key Point: Developed an automated reporting system with SQL and Excel, reducing manual reporting efforts by 40% and improving the accuracy of key business metrics.

Professional Experience

Sr. Data Analyst Health Care Services Corporation-Miami, FL 01/2024 – Present

Boosted reporting efficiency by 20% by optimizing query performance using T-SQL stored procedures and indexing strategies. Leveraged my agility to quickly adapt to the data model requirements and applied SQL expertise to streamline report generation and reduce processing time.

Increased operational efficiency by 25% by automating ETL workflows with Azure Data Factory and Python. Collaborated with cross-functional teams to translate business needs into scalable solutions, using my problem-solving skills to address challenges in data processing.

Improved data consistency and reporting accuracy by designing effective data models with SQL Server. Partnered with business analysts to ensure accurate reporting, utilizing my communication and collaboration skills to align technical solutions with business objectives.

Reduced processing time by 50% by designing and implementing efficient ETL processes with SQL Server and Azure technologies, enabling faster data access for academic departments. My fast learning and adaptability allowed me to quickly implement new data integration techniques, improving real-time data availability.

Enhanced decision-making for academic departments by creating and deploying interactive Tableau dashboards, improving procurement insights by 35%. Leveraged my analytical and communication skills to ensure dashboards met user needs and delivered clear, actionable insights.

Improved reporting accuracy by 30% through thorough data analysis and data transformation using SQL. Partnered with faculty and researchers to ensure data integrity and alignment with academic goals, demonstrating my attention to detail and collaborative approach.

Junior Data Analyst Tata Consultancy Services-Hyderabad, India 07/2021 – 12/2022

Reduced report generation time by 30% by optimizing ETL pipelines using Informatica and SQL Server, improving data quality and consistency. Applied critical thinking and problem-solving to identify bottlenecks and streamline data workflows.

Improved procurement reporting accuracy by designing data models to integrate new data sources, resulting in better decision-making for retail clients. My fast learning and adaptability were key in rapidly integrating external data sources and improving system scalability.

Automated manual processes, reducing reporting time by 40% and freeing up resources for strategic projects. I applied my Python skills to automate routine tasks, and communicated these changes clearly to stakeholders, ensuring quick adoption and maximizing operational efficiency.

Junior Data Analyst Infinity Data Technologies-Bengaluru, India 01/2020 – 06/2021

Improved data accuracy and performance by 25% by developing SQL-based data pipelines for automating data ingestion and reporting. My agile approach and attention to detail allowed me to quickly identify and address inefficiencies, optimizing the data pipeline for faster results.

Enhanced decision-making speed by creating and optimizing Power BI dashboards, enabling real-time access to procurement metrics. My communication skills ensured that the dashboards were tailored to meet user needs, resulting in 20% faster decision-making.

Ensured smooth data integration, maintaining high data quality across systems. My ability to collaborate effectively with business teams and my adaptability to new technologies ensured data flows remained compliant and efficient.

Certifications: Microsoft Power BI, Advanced SQL, Python from Coursera

Core Competencies & Technical Skills

Programming Languages: SQL, Python, R, HTML

ETL Development: Azure Data Factory, Informatica, Apache Kafka, Python (Pandas, NumPy)

Data Storage & Management: SQL Server, Azure Data Lake, Azure Blob Storage, Azure SQL Database, AWS Redshift, Google BigQuery

Data Modeling & Analysis: Data Mapping, Normalization, Data Transformation, Regression Analysis, A/B Testing, Hypothesis Testing, Predictive Analytics, Entity-Relationship Diagrams (ERD)

Big Data & Cloud Technologies: Azure Databricks, Apache Spark, AWS (S3, EMR), Google Cloud, Apache Hadoop

Business Intelligence Tools: Power BI, Tableau, Qlik, Excel (Advanced Functions, Pivot Tables, VLOOKUP, Macros)

Data Integration & APIs: REST APIs, Data Ingestion, Data Integration from CRM/ERP systems

Machine Learning: scikit-learn (for basic regression and clustering)

Soft Skills: Adaptability, Agility, Problem-solving, Strong Communication, Collaboration, Attention to Detail, Critical Thinking, Business Acumen, Time Management, Stakeholder Engagement, Data Quality Management.

Contact this candidate