Sudheshna Nandimandalam
Columbia,MO
Summary
- Over 6 years of experience as a Business Intelligence Developer using Power BI visualization, COGNOS, in various business domains, including healthcare and information technology.
- Experienced in Data Visualization and modeling.
- Expertise in business intelligence application development, planning, debugging, testing, deployment, support, and maintenance.
- Strong experience in all phases of Software Development Life Cycle (SDLC) from requirements gathering to design and development.
- Create engaging and actionable dashboards and reports.
- Strong in Project Management, Test Management, Business Analysis, Testing, Technical Analysis, Problem-solving, and effective communication.
- Extensive experience in report creation using Power Query, Power Pivot, and Power View.
- Experience with Microsoft Power BI (Desktop, Service, and Mobile).
- Extracted data from On-Premises and SaaS (Software as a Service) into Power BI desktop.
- Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules.
- Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
- Created new measures and new calculated columns for reports and dashboard analysis.
- Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
- Published reports and dashboards to the Power BI service through the Office 365 integration.
- Shared the dashboards among multiple users in the group.
- Implemented row level security by restricting the users for the data access.
- Configuring the data sources to schedule the data refresh using Power BI gateways (Personal and Enterprise). And created Content packs.
- Created User Groups and shared the content packs among multiple users in the specified group.
- Strong analytical thinking and problem-solving ability
- Excellent communication and stakeholder management
- Agile/Scrum project environment experience
- Ability to translate business requirements into technical solutions
Overview
17
17
years of professional experience
Work History
Sr. Analyst
MBS Textbook Exchange
Columbia, MO
06.2020 - 11.2025
- · Involved in reviewing the Investments application and interacting with business users to understand the user requirements.
- Created new measures and new calculated columns for reports and dashboard analysis.
- Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
- Worked on Custom Visualizations like multi slicer and Hierarchy slicer.
- Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
- Develops ETL (Extraction, Transformation, and Loading) processes to acquire and load data from various sources.
- Published reports and dashboards to the Power BI service through the Office 365 integration.
- Shared the dashboards among multiple users in the group.
- Implemented row level security by restricting the users for the data access.
- Experience in working with COGNOS.
- Created weekly reports, Monthly reports and yearly reports and automated them using Power Bi.
- Created Content packs that package up a dashboard, report, and dataset to send to my colleagues.
- Good Knowledge and experience on Power Bi Gateways (Personal and Enterprise gateways).
- Used agile development Methodology.
- Maintain accurate reporting and ensure project success.
- Environment: MS Power BI Desktop, MS Power Bi report Builder, MS SQL Server 2008R2/2014, T-SQL, SQL Server Reporting services, SQL Integration Services, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Management Studio, SQL server Profiler, Python and R
Report Analyst
OBERD
Columbia, MO
01.2018 - 06.2018
- Worked on sending out subscription emails for SSRS reports.
- Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports.
- Created various visualizations such as stacked chart, pie charts, Donut charts, cards according to business requirements.
- Worked on RLS to constrain the user access to the row level data.
- Worked on both live and import data to Power BI for creating reports.
- Worked with Power BI gateway to schedule daily job to refresh data.
- Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server.
- Managed relationship between Power BI using star schema.
- Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions.
- Utilized power BI desktop to design real time dashboards and scorecards for analytical decision.
- Deployed reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
- Published reports and dashboards designed in Power BI utilizing Power BI services and shared it across through Microsoft Office 365.
- Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements.
- Environment: MS SQL Server 2014, SQL Server Integration Services 2014 (SSIS), SQL Server Analysis Services 2014 (SSAS), T-SQL, Microsoft Visual Studio 2014, JIRA, Import/ Export Tools, MDS, DQS, Power BI, Tableau, MS Access.
SQL Developer
Hewlett Packard, HP
Roseville, CA
06.2008 - 11.2011
- Created tables, indexes, stored procedures, and user-defined functions to enforce business rules.
- Executed performance tuning on SQL queries, triggers, and stored procedures.
- Generated efficient SQL queries using join conditions and optimized index utilization.
- Managed creation and manipulation of SQL Server databases to support operational needs.
- Integrated frontend applications with SQL Server backend for seamless data interaction.
- Developed complex T-SQL statements for data retrieval and performance optimization.
- Utilized SQL Profiler for troubleshooting and optimizing SQL Server and T-SQL code.
- Administered server security, including creating logins, managing roles, and scheduling backups.
Education
Bachelor’s - Electrical, Electronics And Communications Engineering
Madha Engineering College
Chennai11-2003
Skills
- SQL Server
- MS SQL Server
- SharePoint
- Power BI Report Builder
- Excel Reporting
- Power Query
- Power Pivot
- Power View
- Logical and Physical Database Design
- UML
- Database Design
- Data Modelling
- MS Word
- MS Excel
- MS PowerPoint
- MS Access
- MS Project
- Power BI
- Cognos
Personal Information
Visa Status: Green Card
Timeline
Sr. Analyst
MBS Textbook Exchange
06.2020 - 11.2025
Report Analyst
OBERD
01.2018 - 06.2018
SQL Developer
Hewlett Packard, HP
06.2008 - 11.2011
Bachelor’s - Electrical, Electronics And Communications Engineering
Madha Engineering College
Similar Profiles
Sabrina ElbertSabrina Elbert
Picker at MBS Textbook ExchangePicker at MBS Textbook Exchange
Chad HackmanChad Hackman
Inventory Specialist at MBS Textbook ExchangeInventory Specialist at MBS Textbook Exchange
Phillip MaisellsPhillip Maisells
Warehouse Worker at MBS Textbook ExchangeWarehouse Worker at MBS Textbook Exchange
Marissa ViscaynoMarissa Viscayno
Nurse II Cardiovascular Nurse at University of Missouri Health CareNurse II Cardiovascular Nurse at University of Missouri Health Care
Jake MazucJake Mazuc
Product Owner at Veterans United Home LoansProduct Owner at Veterans United Home Loans