Poojitha Manne

* Collaborated with senior management, subject matter experts, and IT teams to define and refine business requirements
* Converted business needs into detailed functional and non-functional requirements.
* Developed complex stored procedures for various tasks, including index maintenance, data profiling, metadata searches, and populating the data mart.
* Designed, developed, and tested ETL strategies to integrate data from multiple source systems.
* Implemented SSIS packages for ETL processes, including data profiling, cleansing, and validation.
* Designed incremental data loads for the data mart using checksum and timestamp techniques.
* Created master-child packages in SSIS to consolidate data from multiple sources into SQL Server, leveraging execute package tasks for modular programming.
* Configured SSIS package parameters for deployment across development, testing, and production environments.
* Experienced in data mapping, performance tuning, and identifying bottlenecks in sources, mappings, targets, and sessions.
* Strong expertise in data modeling within data warehouse environments, including star schema and snowflake schema.
* Developed SSAS cubes with key performance indicators (KPIs) and aggregations for front-end analysis teams.
* Utilized multidimensional and tabular models in Analysis Services to enable real-time reporting from back-end relational data sources.
* Designed SSRS reports to support in-depth business analysis.
* Created expressions to calculate, group, filter, parameterize, and format report content.
* Developed executive summary dashboards and scorecards in Tableau for performance monitoring.
* Delivered on-demand reports in multiple formats with standard and data-driven subscriptions.
* Designed and built Power BI visualizations and dashboards based on business requirements.
* Used Power BI (Power View) to create interactive analytical dashboards displaying key metrics, such as legal case matters, billing hours, and case proceedings, with slicers and filters for user interactivity.
* Created ad-hoc reports in Excel Power Pivot and shared them via Power BI to aid decision-making and strategic planning.
* Used Power Query in Power BI for data transformation, including pivoting and unpivoting datasets for data cleansing and preparation.
* Implemented various DAX functions for fact calculations to enhance data visualization efficiency in Power BI.
* Configured Power BI Gateway to keep dashboards and reports updated with on-premise data sources.
* Managed code versioning and check-in/check-out processes using TFS for efficient collaboration.

* Provisioned virtual machines (VMs) on Microsoft Azure with SQLServer and established communication through endpoints.
* Migrated enterprise databases to Microsoft Azure Data Factory.
* Assisted in developing a backup and recovery strategy for databases on a virtualized platform using Microsoft Azure.

* Analyzed business requirements and facilitated the planning and implementation phases of the OLAP model during JRD meetings.
* Participated in JAD meetings to align business, development, and testing teams with a shared understanding of project objectives.
* Optimized query execution times by encapsulating frequently executed SQL statements into stored procedures.
* Performed data cleansing and scrubbing within the staging database to ensure data accuracy.
* Developed SSIS packages with robust error and failure handling mechanisms, including event handlers, row redirects, and logging.
* Implemented a master-child package framework to enhance maintainability and performance.
* Configured SSIS packages using parameters to dynamically acquire values at runtime.
* Optimized SSIS package performance through parallelism, fast load options, buffer size adjustments, and checkpoints.
* Managed SSIS packages within the SSISDB catalog using environment configurations and automated execution via SQL Agent jobs.
* Contributed to the design of data warehouses using the Star-Schema methodology and migrated data from multiple sources into Oracle tables.
* Created data models and data flow diagrams to visualize the future-state process.
* Developed complex calculated members in SSAS cubes to improve report performance.
* Designed SSAS cube objects, including KPIs, aggregations, perspectives, and translations.
* Formatted dashboards with multiple chart types, trends, and KPIs using Power View for analytical insights.
* Translated business requirements into detailed functional and non-functional specifications using workflow diagrams, sequence diagrams, activity diagrams, and use case modeling.
* Designed interactive scorecards and dashboards in Power BI (Power Pivot/View) to present key metrics for various departments and executive leadership.
* Created reports using SSRS, Excel Services, and Power BI, deploying them on SharePoint Server based on business needs.
* Designed and developed complex, data-intensive reports in Power BI, incorporating visualization elements like gauges, funnels, and line charts for comprehensive business analysis.
* Improved report performance through caching and snapshot optimization techniques.
* Proactively identified and resolved issues to enhance system quality and performance.
* Engaged in cross-team collaboration to share knowledge and mitigate risks early in the development lifecycle.
* Implemented TFS for version control, change management, and bug tracking to streamline project development.

* Engaged with business users to gather requirements and define the desired look and feel of applications.
* Developed interactive dashboards, leveraging context filters and sets to handle large volumes of data efficiently.
* Utilized Excel sheets, flat files, and CSV files to generate ad-hoc reports in Tableau.
* Designed dashboards to track actionable and non-actionable complaints using data from multidimensional databases.
* Created dashboards to compare expected weekly registrations with physician-specific registrations, incorporating dual-axis charts for better visualization.
* Developed various views for patient registrations, doctor scheduling, and lab tracking.
* Designed dashboards for monitoring billing and deposit systems.
* Implemented security measures and managed user roles across different modules.
* Applied filters, quick filters, sets, parameters, and calculated fields to enhance Tableau reports.