Power Bi Sql Developer

SRI MEHER TAMMINA

VA +1-937-***-**** ***************@*****.*** LinkedIn

SUMMARY

Detail-oriented Data Analyst with over 4 years of experience transforming complex data into actionable insights. Proficient in Power BI, SQL, and advanced DAX queries while enhancing query performance, data modeling, and schema design. Experienced in delivering end-user training and support, streamlining dashboards and ETL processes. Recognized for precise data storytelling, cross-functional collaboration, and meeting tight deadlines.

TECHNICAL SKILLS

• Programming & Scripting: Python, Pandas, NumPy, Matplotlib, Seaborn, OpenPyXL, SciPy, VBA, Shell Scripting, Jupyter Notebook

• Database Management & Querying: SQL, Oracle, PostgreSQL, SQL Server, MySQL, MongoDB, Data Warehousing, Normaliza- tion/Denormalization, Relational and Non-Relational Databases

• Data Visualization & BI Tools: Tableau, Calculated Fields, LOD, Parameters, Dashboard Actions, Power BI, DAX, Measures, Bookmarks, Drillthrough, Excel, Power Query, PivotTables, INDEX-MATCH, Data Models, Dashboards, Macros, SSRS, Google Data Studio

• Reporting & Data Analytics: Ad-hoc Analysis, Exploratory Data Analysis, EDA, Forecasting Models, Time-Series Analysis, Trend & Variance Analysis, Data Cleansing, Data Wrangling, Statistical Analysis, Root Cause Analysis, Performance Dashboards, Descriptive

& Diagnostic Analytics

• Financial & Regulatory Analytics: SOX Compliance, CCAR Reporting, Dodd-Frank, Basel Frameworks, Internal Audit Support, Risk Scoring Models, Expense Reconciliation, P&L Reporting, Budgeting, KPI Alignment

• Data Quality, Governance & Documentation: Data Lineage, Metadata Management, Data Dictionaries, Source-to-Target Mapping, QA Testing, Data Profiling, Validation Rules, Audit Trail Creation, Data Governance Standards

• Cloud Platforms & Services: AWS, S3, Glue, RDS, Redshift, Azure SQL Database, Google Cloud Platform, BigQuery, Snowflake

• Agile Tools & Collaboration: JIRA, Confluence, Agile/Scrum, Stand-Ups, User Stories, Sprint Planning, Version Control, Git, Cross-Functional Collaboration

• Data Formats & APIs: CSV, Excel, JSON, XML, Web APIs, REST API Integration

• Soft Skills: Analytical Thinking, Attention to Detail, Problem-Solving, Critical Thinking, Communication Skills, Collaboration

& Teamwork, Time Management, Stakeholder Management, Adaptability, Business Acumen, Presentation Skills, Ownership & Accountability, Continuous Learning

WORK EXPERIENCE

Morgan Stanley Jan 2024 - Present

Data Analyst USA

• Designed and deployed enterprise-grade Tableau dashboards with complex calculated fields, LOD expressions, filters, and drill-down functionality to support investment and asset management functions, fraud analytics, and operational KPIs.

• Built and maintained data pipelines pulling from SQL Server, Snowflake, and internal financial systems using optimized SQL (CTEs, window functions) to prepare datasets for regulatory and business reporting.

• Led end-to-end data integration projects using SSIS, custom APIs and other financial systems to streamline data flow across various business systems, ensuring real-time data access for decision-makers.

• Automated SOX-compliant reporting processes using Python (Pandas, NumPy, OpenPyXL) integrated with scheduling tools (Airflow, CRON), reducing manual efforts by over 70% while improving data auditability.

• Developed Excel-based reconciliation tools with Power Query, VBA macros, and lookup chains to streamline month-end close, variance analysis, and general ledger reviews across accounting and operations.

• Partnered with compliance and internal audit teams to deliver data required for CCAR stress testing, internal model governance, and Dodd-Frank regulatory assessments.

• Created data models for reporting based on business requirements and configured data mappings between SQL Server and Snowflake, ensuring smooth data flow and consistency across systems.

• Translated high-level stakeholder requests into technical specifications and implemented business logic in dashboards and analytics models that influenced decisions on asset management, expense controls, and workforce optimization.

• Supported data ingestion and transformation efforts from Snowflake into Tableau dashboards, maintaining proper data lineage, security filters, and change management logs across versions.

• Participated in global Agile teams with cross-functional squads, tracked backlog using JIRA, and maintained all technical documen- tation and process standards via Confluence.

• Conducted root cause analysis on data discrepancies flagged during model reviews and created validation scripts to reconcile results across systems and environments.

Hexaware Technologies Jan 2020 - Jul 2022

Data Analyst India

• Designed interactive Power BI dashboards using custom DAX measures, slicers, bookmarks, and row-level security to track customer retention, SLA compliance, and contact center resolution metrics while providing training and support to end-users on BI tools.

• Created scalable ETL pipelines in AWS and PostgreSQL by reviewing SQL queries and execution plans, integrating and transforming customer behavior data from CRM systems, third-party APIs, Excel files, and operational databases.

• Developed PySpark applications on Databricks for data transformation, storing processed data in Redshift for analysis.

• Conducted in-depth exploratory data analysis (EDA) using Python (Matplotlib, Seaborn, StatsModels) to detect churn patterns, behavior clusters, and service anomalies, resulting in a 12% reduction in customer attrition.

• Created advanced Excel reports with scenario modeling, nested formulas, what-if analysis, and dynamic tables to support business case evaluations and executive decision-making.

• Defined and implemented KPI frameworks, aligning metrics across delivery, product, and customer teams while enforcing consistent definitions through data governance practices.

• Led the validation of data migration efforts from legacy systems, built source-to-target mapping logic, and developed automated SQL scripts to reconcile transactional data.

• Delivered business insights to internal and external stakeholders via storytelling dashboards and data narratives, increasing stakeholder engagement and report usability.

• Trained non-technical users to access and interpret self-service BI solutions, promoting analytics adoption and improving report turnaround times.

Intex Technologies Jun 2019 - Dec 2019

Data Analyst India

• Supported senior analysts in preparing daily, weekly, and monthly sales and inventory reports using Excel (PivotTables, VLOOKUP, INDEX-MATCH) and charts, improving visibility of SKU-level performance across regions.

• Queried internal SQL databases to retrieve historical and real-time product movement data; cleaned and pre-processed datasets to support dashboards and reporting workflows.

• Analyzed seasonal pricing trends, discount campaigns, and product margins, contributing directly to the pricing team's promotional strategy during high-volume sales periods.

• Developed basic sales forecasting models using historical data trends, average lead times, and distribution channel performance, enhancing demand planning accuracy.

• Created standardized Excel reporting templates with automated inputs and dynamic charts, reducing reporting time by 50% and minimizing manual errors.

• Supported logistics and distribution analysis by mapping inventory flow, identifying bottlenecks, and suggesting route optimization opportunities based on regional delivery data.

• Participated in cross-functional team meetings and delivered ad-hoc data summaries for use in executive dashboards and performance review presentations.

EDUCATION

University of Dayton, Ohio Jun 2024

Master of Science, Business Analytics

JNTU, Kakinada, India May 2019

Bachelor of Technology, Mechanical Engineering

PROJECTS

Distribution Network Optimization Model for Copeland Copeland

• Developed a cost-efficient model for Copeland using Python, Excel, MySQL, and What'sBest tool to determine new distribution center locations and optimize customer-product routing, reducing transportation and inventory costs by 20%.

• Created Tableau dashboards to visualize model outcomes and designed it as a flexible framework for addressing future supply chain challenges.

Provided Insights for Finance Retail, E-commerce & Supply Chain Industries

• Designed and developed interactive Tableau and Power BI dashboards and reports to provide actionable insights into financial operations, strategies and supply chain performance.

• Automated updates to end users, enabling real-time tracking, promotions and comparisons across different timeframes.

• Empowered management with data driven decision-making capabilities, improving operational efficiency.

• Developed a centralized data warehouse and data marts integrating multiple disparate data sources into a single source of truth, enabling enterprise-wide reporting, advanced analytics, predictive modeling, and informed decision-making for investment, asset management, and expense optimization.

• Implemented advanced data governance protocols, including robust data quality frameworks and strict access controls, ensuring data integrity, regulatory compliance, and secure handling of sensitive financial information across global locations.

Contact this candidate