Data-Driven BI Analyst with SQL & Power BI

Gayathri Ramachandran - Business Intelligence Developer

Rancho Cucamonga, CA ************@*****.*** +1-201-***-****

Work Authorization: H4 EAD (No sponsorship required) Availability: Immediate

LinkedIn: https://www.linkedin.com/in/gayathri-ramachandran-5265501b/

PROFESSIONAL SUMMARY

Data-driven Business Intelligence & Data Analyst with 5+ years of experience transforming raw data into meaningful insights, developing analytical dashboards, and supporting cross-functional decision-making. Strong hands-on expertise in SQL, Python, Power BI, Excel, ETL, and automated reporting. Experienced in healthcare and enterprise environments with strengths in requirements gathering, data validation, KPI reporting, visualization, and process optimization. Adept at independently handling analytical requests, performing trend analysis, ensuring data integrity, and presenting actionable insights. Fast learner with a continuous improvement mindset and a strong ability to collaborate across technical and business teams.

CORE COMPETANCY

SQL Querying, Data Extraction & Data Validation

Python for Data Analysis (Pandas, NumPy, Visualization)

Business Intelligence Tools: Power BI, Tableau, Hex (familiarity)

Snowflake (familiarity), SQL Server, MS Access

ETL, Data Cleansing & Transformation (Power Query, SSIS)

Dashboard Development & KPI Reporting

Data Modeling, Trend Analysis & Insight Generation

Requirements Gathering & Stakeholder Communication

UAT, Quality Assurance & Risk Assessment

Documentation, Process Mapping & Continuous Improvement

Agile / Scrum & Cross-Functional Collaboration

Continuous Process Improvement

PROFESSIONAL EXPERIENCE

Independent BI Project (Restaurant Chain Data Reporting) Jan 2024 – Present

Monitor operational KPIs including sales, performance trends, and process accuracy.

Perform end-to-end data analysis including extraction, cleaning, wrangling, and validation using SQL, Python, and Excel.

Build automated dashboards in Power BI to track operational KPIs, customer trends, and sales performance.

Translate business questions into analytical requirements and deliver actionable insights for decision-making.

Develop ETL workflows to improve reporting timeliness by 30% and reduce manual effort.

Prepare analytical reports, presentations, and training documentation for stakeholders.

Tata Consultancy Services (TCS) BI Developer Florida - Remote Jan 2023 – Dec 2023

Worked within the healthcare domain supporting medical operations reporting, patient data analysis, performance dashboards, and quality metrics.

Queried, extracted, and validated healthcare datasets using SQL & Python, ensuring data accuracy and completeness.

Created automated Power BI dashboards to track patient flow, provider performance, appointment trends, and operational KPIs.

Supported ad-hoc analytical requests by independently analyzing business questions and building data-driven solutions.

Improved data workflows using Power Query and Excel macros, reducing reporting cycle time by 40%.

Created documentation, data dictionaries, report specifications, and QA logs for technical and business stakeholders.

Collaborated with cross-functional teams to support data-driven decision-making aligned with business needs.

Ensured compliance with healthcare reporting standards, data governance rules, and validation procedures.

Developing Power BI dashboards and automated refresh pipelines for operational teams.

Denken Solutions Inc Reporting Analyst Irvine – Remote Oct 2021 – Dec 2022

Managed daily reporting cycles including KPI tracking, volume analysis, and operational insights.

Provided customer service support by addressing routine and non-routine data inquiries.

Supported tool enhancements, testing, and user documentation for analytics workflows.

Helped improve reporting turnaround time through automation and streamlined templates.

Designed and enhanced Power BI dashboards to track operational metrics for enterprise clients.

Conducted UAT, validated data integrity, and collaborated with product owners to align deliverables with business expectations.

Automated reporting workflows using Power Query and Excel macros, reducing manual effort by 40%.

Coordinated with project managers and SMEs to analyze requirements and define reporting logic.

Maintained documentation, change logs, and version control for audit readiness.

HCL Technologies Ltd ETL Developer Chennai - India Jul 2012 – Nov 2013

Gathered and consolidated operational data into SQL Server for recurring reports.

Designed end-to-end ETL workflows using SQL Server and SSIS to support financial and operational reporting.

Developed data models, templates, and validated datasets for dashboards used by leadership teams.

Troubleshot system issues, optimized query performance, and supported data migration and system upgrades.

Worked with cross-functional teams to gather requirements and deliver timely analytical solutions.

Partnered with technical teams to test and implement system upgrades

Ivesia Solutions Inc Jr. Data Analyst Chennai - India Jul 2010 – Aug 2012

Cleaned and transformed multi-source datasets (Excel, SQL Server, CSV).

Created visual reports and dashboards for internal teams.

Assisted in identifying process inefficiencies and proposed automation solutions.

Documented workflows, data dictionaries, and business processes.

EDUCATION

Bachelor of Technology – Information Technology Vel Tech – Anna University 2004 – 2008 India

CERTIFICATION

Microsoft Certified: Data Analyst Associate

Familiarity with PMP concepts & Agile/Scrum methodologies

TOOLS & TECHNOLOGIES

SQL, Python, Power BI, Hex (familiarity), Tableau, Snowflake (familiarity), MS Access, Excel (Advanced: Lookups, Pivot Tables, Formulas), SSIS, Power Query, Power Pivot, Jira, Confluence, Microsoft Project, Visio, Agile Tools

Contact this candidate