Lipsa Bihari

2+ Years Analytical & Technical Experience Detail-oriented and results-driven Data Analyst with 2+ years of hands-on technical experience in relational database querying (SQL), automated data pipelines (Python), and analytical data modeling (Advanced Excel, Power BI). Proven expertise in cross-referencing complex relational databases, extracting high-volume datasets using multi-table joins, subqueries, and aggregations, and executing comprehensive data cleaning and discrepancy audits. Demonstrated ability to translate intricate business requirement specifications into quantitative insights, interactive dashboards, and executive reporting summaries.

Adept at cross-functional stakeholder presentation, critical root-cause diagnosis, and managing concurrent analytics deliverables under strict release cycles in fast-paced Agile environments.

Data Analyst - eTeam InfoServices Pvt. Ltd. - Bangalore, India

(2024-04)

• Data Extraction & Query Optimization: Author and optimize complex SQL queries across PostgreSQL and Microsoft SQL Server schemas using multi-table joins, CTEs, and window functions to extract, reconcile, and validate transaction datasets.
• Data Cleaning & Discrepancy Audits: Perform structured data hygiene and cleansing protocols on raw application records; identified and resolved over 150+ data discrepancies and schema mismatches prior to production deployments.
• Python Analytics & Automation: Developed custom Python scripts (utilizing Pandas and NumPy) to automate recurring data validation checks, synthetic test dataset generation, and tabular reconciliations, reducing manual auditing time by 40%.
• Business Requirements Translation: Intersected with Business Requirement Documents (BRD) and functional specs to formulate 400+ validated test data conditions, verifying calculations, pricing structures, and reporting accuracy.
• Cross-Functional Stakeholder Presentations: Partner with Product Managers, Data Engineers, and Developers in daily Agile Scrum ceremonies, delivering data anomaly briefings and executive root-cause analysis decks.

Data Analyst Intern - Servii Automotives Solutions Pvt. Ltd. - Bangalore, India

(2023-02 - 2023-12)

• Database Integrity Validation: Executed MySQL queries to audit backend transactional logs, user registration pipelines, and order histories, ensuring 100% compliance with defined business rules.
• Excel Reporting & Reconciliation: Built structured Microsoft Excel workbooks incorporating Power Query, XLOOKUP, and dynamic Pivot Tables to audit monthly reports across Orders, Inventory, and Returns modules.
• Issue Documentation & Tracking: Logged, analyzed, and prioritized system data anomalies in Jira with step-by-step reproduction scenarios and SQL query proofs, accelerating bug turnaround by development teams.

Master of Computer Applications (MCA) - CMR Institute of Technology, Bangalore (2023)

B.Sc - Jagat janani +3 Science College, Jeypore (2020)