Power Bi Fp A

Tejaswini Kshirsagar

New York, US *********.**********@**********.*** 520-***-**** LinkedIn GitHub Portfolio SUMMARY

Analytics Professional with 5+ years of experience building reporting systems, modeling financial metrics, and deploying automated pipelines across large-scale enterprise environments. Specialist in data warehousing, extraction, cleaning, mining, transformation, and modeling, using tools like SQL, Snowflake, PL/SQL, SSIS, MS Excel, Power BI, and Python. Has engineered multi-source pipelines, reconciled GL- linked P&Ls, and created audit-ready dashboards to support FP&A, controllers, and product teams. Skilled in structuring raw, inconsistent datasets into validated reporting layers, enabling accurate margin analysis, forecast comparisons, and operational insights across trading, credit, and cost center domains. Owns end-to-end development from ingestion and schema design to stakeholder UAT and delivery. SKILLS

• Programming & Scripting: Python, Pandas, NumPy, Matplotlib, Seaborn, SciPy, Scikit-Learn, Spark, R, SAS, SPSS, Scala

• Data Analysis & Statistics: Statistical Modeling, Predictive Modeling, Hypothesis Testing, A/B Testing, Time Series Analysis, Regression Analysis, Clustering, Anomaly Detection, Root Cause Analysis, Data Mining, Data Cleansing, Statistical Analysis

• Cloud Computing & Architecture: AWS, Azure, Cloud Data Warehousing, Azure Blob Storage, Serverless Architecture, Data Lake

• Financial & Business Analysis: P&L Analysis, Margin Analysis, Revenue Attribution, Forecasting, Budgeting, Variance Analysis, Financial Reporting, Cost Analysis, Gap Analysis

• Data Governance & Compliance: Data Catalog, Data Lineage, Metadata Management, Data Security, Compliance, Data Auditing

• Data Visualization & Reporting: Power BI, Tableau, Microsoft Excel, Power Query, Design, Interactive Reporting, D3.js, ggplot2

• Data Engineering & Integration: ETL, Data Pipelines, Data Modeling, Data Warehousing, Apache Airflow, Informatica, Databricks,

• Database Technologies: Snowflake, Google BigQuery, Amazon Redshift, PostgreSQL, MySQL, SQL, PL/SQL, Data Integrity, Data Security, Metadata Management, Data Quality Management EXPERIENCE

Goldman Sachs Data Analyst Aug 2024 - Present

Project: Revenue Attribution & Profitability Analytics

• Built a revenue attribution model in SQL and Snowflake to break down $140M annual revenue across 8 trading desks by product, geography, and client tier; uncovered a $12M misclassification that was impacting margin reporting.

• Designed Power BI dashboards with dynamic filters and waterfall visuals to help finance leads compare quarter-over-quarter profitability across fixed-income and derivatives products; enabled faster reforecasting cycles during earnings prep.

• Partnered with Controllers and FP&A teams to align revenue allocation logic across GL entries, internal P&L, and trade-level data; reduced reconciliation errors by 68% and audit back-and-forth by 4 days per month.

• Wrote Python scripts to ingest and validate trade data files from 3 upstream systems, flagging anomalies using business rules and variance thresholds; helped identify stale pricing on structured notes that triggered a correction in desk-level margins.

• Automated weekly profitability snapshots using Airflow and Power Automate, syncing live data into team SharePoint decks; saved 6 hours/week in manual effort and ensured data consistency across reporting. LTIMindtree Jul 2021 - Mar 2023

Senior Data Analyst

• Developed PL/SQL procedures to automate ETL steps from staging to reporting layers, handling conditional joins and sequence logic; reduced daily processing time by 20% and removed dependency on manual triggers.

• Created 50+ SSIS workflows to consolidate data from 5+ sources into a unified warehouse; enabled timely access to clean, structured data for business teams to track KPIs and compliance metrics.

• Led SQL-based root cause analysis to investigate inconsistent reporting outputs across multiple layers; identified data truncation in source loads and implemented validation rules to prevent future issues.

• Integrated and synchronized high-volume RDBMS systems (50TB) by coordinating ETL batch schedules and adjusting indexing strategy; improved data sync accuracy and reduced load failures across prod and QA.

• Designed and maintained Power BI dashboards for credit risk and statement monitoring teams, including DAX measures and filter logic; helped analysts drill down by region and product in real time.

• Conducted requirement gathering sessions with end users and project leads, documenting business logic, data flow, and report expectations; improved clarity and minimized back-and-forth during dev sprints.

• Performed structured functionality validation during release cycles by comparing output metrics with expected thresholds; ensured accuracy and prevented rework during production deployment.

• Automated deployment pipelines in Jenkins using Shell scripting, introducing parameterization and rollback scripts; reduced deployment errors by 30% and saved 10+ hours/week in manual coordination.

• Supervised and mentored 4 trainees on SQL, Power BI, Python, and JIRA, guiding them through project tasks and reviewing queries for efficiency and readability.

7FinCorp Group Feb 2019 - Jun 2021

Business Intelligence Analyst

• Built Excel-based P&L and headcount models using dynamic named ranges, XLOOKUP, and conditional logic, enabling budget owners to compare forecast vs. actuals across 50+ cost centers without analyst support.

• Created back-end SQL procedures to pull revenue, GL, and contract data into structured Excel templates; automated version control and file drops using Power Automate to streamline month-end reporting cycles.

• Engineered metric alignment workshops with FP&A and business leads to finalize KPI definitions, then translated those into logic blocks for both Power BI dashboards and Excel review decks.

• Led stakeholder walkthroughs and UAT for 6 critical dashboards, captured enhancement requests, and reprioritized sprint tasks in Jira; reduced back-and-forth by establishing clear documentation and validation criteria. EDUCATION

University of Arizona Tucson, AZ

Master’s in Management Information Systems Aug 2023 – Dec 2024 University of Mumbai India

Bachelor’s in Computer Engineering Aug 2017 – Jun 2021 CERTIFICATIONS & ACHIVEMENTS

Microsoft Excel Collegiate Challenge Fall 2024 Certificate of Completion - Machine Learning A – Z – Hands on in Python & R for Data Science Scrum Fundamentals Certified (SFC)

Promoted to Senior Data Analyst within 8 months of joining LTIMindtree for outstanding performance

Contact this candidate