Poornachandra Kongara — Business Analyst

Data Analyst driving revenue growth and operational efficiency through predictive analytics, A/B testing, and scalable data solutions. I solve business problems by building end-to-end data infrastructure from ETL pipelines processing 8M+ records monthly to real-time dashboards tracking 15+ KPIs. My approach: identify the metric that matters, build the system to measure it, and optimize until it moves. 💡 Key Expertise: - Data Analysis & Visualization: Python, SQL, Power BI, Tableau, and R to uncover insights, forecast trends, and build compelling dashboards. - ETL & Data Warehousing: Scalable pipelines using AWS (Redshift, S3, Glue) and Databricks to handle large datasets efficiently. - A/B Testing & Statistical Modeling: Clustering, regression, and experimentation to drive decisions and optimize user engagement. - Big Data & Cloud Computing: Real-time analytics with PySpark, BigQuery, AWS Athena, and Redshift Spectrum. - Business Intelligence: Designing KPI dashboards, writing optimized SQL scripts, and tracking operational metrics that move the needle. 🚀 Notable Impact: → Automated ETL workflows saving 100+ manual hours/month (50% efficiency gain) → Led A/B testing strategies boosting engagement by 5% across 10+ metrics → Reduced cloud storage costs by $10K annually via SQL optimization → Built Covid-19 dashboards influencing public health strategy I'm driven by the challenge of making data useful, usable, and impactful. Whether it's building infrastructure, improving workflows, or crafting insights - I love turning complexity into clarity. Let's connect if you need someone who turns messy data into clear, actionable strategy.

Stackforce AI infers this person is a Data Analyst with expertise in ETL, A/B testing, and data visualization across Government and Pharmaceutical sectors.

Location: Houston, Texas, United States

Experience: 3 yrs 11 mos

Skills

Data Analysis
Financial Analysis
Data Visualization
Data Quality
Etl & Data Warehousing
A/b Testing
Teaching
Data Engineering
Operational Efficiency

Career Highlights

Automated ETL workflows saving 100+ hours monthly.
Led A/B testing strategies boosting engagement by 5%.
Built impactful Covid-19 dashboards influencing public health.

Work Experience

Consulate General of India, Houston

Data Analyst (1 yr 1 mo)

Vertex Pharmaceuticals

Data Analyst (5 mos)

Northeastern University

Graduate Teaching Assistant (3 mos)

Data Analyst (Finance & Operations) (11 mos)

Iksula

Data Analyst (1 yr 6 mos)

Data Analyst (5 mos)

Education

Master of Science - MS at Northeastern University

Bachelor of Engineering - BE at MCT's Rajiv Gandhi Institute Of Technology

Poornachandra Kongara

Business Analyst

Houston, Texas, United States3 yrs 11 mos experience

Most Likely To SwitchAI Enabled

Key Highlights

Automated ETL workflows saving 100+ hours monthly.
Led A/B testing strategies boosting engagement by 5%.
Built impactful Covid-19 dashboards influencing public health.

Stackforce AI infers this person is a Data Analyst with expertise in ETL, A/B testing, and data visualization across Government and Pharmaceutical sectors.

Contact

Skills

Core Skills

Data AnalysisFinancial AnalysisData VisualizationData QualityEtl & Data WarehousingA/b TestingTeachingData EngineeringOperational Efficiency

Other Skills

SQLMicrosoft ExcelPythonTableauExcelPySparkAWS GlueSnowflakePower BISQLAlchemyMachine LearningLooker StudioGoogle AnalyticsStreamlitPyPDF

About

Experience

3 yrs 11 mos

Total Experience

11 mos

Average Tenure

1 yr 1 mo

Current Experience

Consulate general of india, houston

Data Analyst

May 2025 – Present · 1 yr 1 mo

Engineered automated expense reporting and reconciliation pipelines using Python and SQL, streamlining financial workflows across 6+ consular departments and reducing manual data processing time by 40%.
Developed Tableau dashboards on $2.3M+ consular expenditures, integrating SQL and Excel data sources to accelerate leadership fiscal decisions by 3x.
Executed end-to-end data cleaning and preprocessing on 50,000+ financial records using Python (Pandas) and Excel, reducing data inconsistencies by 35% and improving overall dataset accuracy to 98%+ for downstream reporting and analysis.

SQLMicrosoft ExcelData AnalysisFinancial Analysis

Vertex pharmaceuticals

Data Analyst

Jan 2024 – Jun 2024 · 5 mos · Boston, Massachusetts, United States · On-site

🧪 Engineered scalable ETL pipelines using PySpark, AWS Glue, and Snowflake, reducing data processing time by 30% and enabling faster clinical insights.
📈 Led A/B testing initiatives to refine customer engagement strategies, boosting click-through, conversion, and user engagement metrics by 5%.
🔬 Conducted exploratory analysis of Flow, Nucleic Acid, and T1D assay data with Python & SQL, improving comprehension for scientists by 40%.
📊 Built dynamic Power BI dashboards integrated with 4+ data sources via SQLAlchemy, enabling real-time monitoring of 15+ KPIs for 10+ stakeholders.
⚙️ Designed and automated ETL pipelines (Python + AWS Redshift), processing 8M+ records monthly and saving 100+ manual hours, improving efficiency by 50%.
💾 Optimized SQL workflows, reducing cloud storage costs by $10K annually and enhancing dashboard reporting speed by 30%.

PySparkAWS GlueSnowflakePower BIETL & Data WarehousingA/B Testing

Northeastern university

2 roles

Graduate Teaching Assistant

Sep 2023 – Dec 2023 · 3 mos · On-site

🧑‍🏫 Delivered lectures for “INFO 7374 – Applied Machine Learning using Python in Finance,” simplifying complex ML and finance concepts for 50+ students, enhancing comprehension and engagement.
📊 Mentored hands-on projects covering predictive modeling, quantitative finance, and Python-based analytics, preparing students for real-world applications.
💬 Facilitated in-depth discussions on financial forecasting, data processing, and ML algorithms, encouraging critical thinking and problem-solving.
💡 Provided one-on-one mentorship to students applying machine learning to real-world finance scenarios, boosting technical proficiency and career readiness in data-driven roles.

PythonMachine LearningTeaching

Data Analyst (Finance & Operations)

Jan 2023 – Dec 2023 · 11 mos · On-site

🔍 Conducted exploratory data analysis (EDA) on search filter usage across two systems using SQL and Excel, optimizing functionality and reducing site latency by 10%, leading to better user experience.
🛠️ Enhanced performance of 25+ Looker Studio dashboards by optimizing SQL queries, reducing server resource usage and saving $10K annually in cloud storage costs.
⚙️ Automated dashboard workflows in Looker Studio, streamlining data retrieval and integration, which improved accessibility and cut manual effort by 30%.
📊 Leveraged Excel (Pivot Tables, VLOOKUP) to analyze large datasets, uncover insights, and improve reporting accuracy across key metrics.

SQLExcelLooker StudioData Analysis

Iksula

2 roles

Data Analyst

Promoted

Nov 2020 – May 2022 · 1 yr 6 mos

📦 Analyzed eBay Global Shipping data using Python and SQL driven ETL pipelines — improving operations and generating $100K+ in monthly revenue gains.
📈 Conducted A/B testing across 10+ KPIs (add-to-cart, conversion rate) using Google Analytics, leading to a 4% increase in sales conversions and stronger customer engagement.
🧠 Enhanced data processing using advanced SQL (joins, CTEs, window functions), streamlining prep for 50+ reports and saving 10+ hours/week.
📊 Built Tableau dashboards to communicate trends and KPIs to stakeholders, supporting data-driven operational decisions.
⚙️ Optimized workflows using Apache Airflow, automating reporting and cutting processing time by 30 minutes per report.
🔁 Developed scalable ETL pipelines with PySpark to process and cleanse global shipping datasets, ensuring high-quality, real-time analytics.
🤝 Partnered with cross-functional teams to build SQL views and reporting tools, providing actionable insights for performance optimization.

PythonSQLData Analysis

Data Analyst

May 2020 – Oct 2020 · 5 mos

Analyzed 10,000+ shipments using SQL, generating logistics and sales insights for major carriers (UPS, FedEx) that informed pricing strategy
Built Power BI and Tableau dashboards tracking user engagement and purchasing behavior, leading to a 5% improvement in recommendation models
Collaborated with 10 shipping experts to implement data-driven changes, reducing shipping costs by 20% and improving delivery efficiency

SQLPythonData Analysis