Professional Summary A competent professional with 3.6 years of IT experience with Analyzing, Business Intelligence and Reporting. Involved in analyze of Finance Analytics Reports and Dashboards, and Custom Reporting Applications. Proficient in generating requirements for OBIEE reports using Oracle BI Analytics and Dashboards. Experience in development of Reports and Dashboard in PowerBI and OBIEE. Experienced in developing Power BI reports and dashboards from various Data Sources like Cube, Databases, Excel files. Good Experience in database design, data modelling, development, implementation, ETL and reporting in Power BI Having Good experience on DAX and Creating Tabular Model with DAX Having experience in creating Data level security which is Role based security. Created Dynamic security in Tabular Model for two types of users based on requirement. Created Custom columns and Conditional Columns in the Power BI using Power Query Used various transformation activities in Power Query to transform the data Practical understanding of data modelling (dimensional and relational) concepts like star-schema modelling, snowflake schema modelling, and fact and dimension tables. Created Answers in different views like Table, Pivot, Chart, Charts, Gauge, Narrative, Ticker etc. Created DDR (Direct Database Request) reports using SQL queries as per the requirements. Created business reports using BI Answers as per requirements. Generated various ad-hoc Reports and working with OBIEE 11g dashboard developer. Strong experience in Microsoft Excel with Data Analysis using analytical, Pivot, Functions. Strong experience in interacting effectively with business stakeholders and technical teams. Knowledge on OBIEE RPD (Physical, BMM, and Presentation Layer) for verifying the columns. Excellent Team Player, Analytical problem solver and critical thinker, innovative and creative, co-operative, results oriented, on-going learner, self-motivated, multi-task oriented. Excel at mentoring and coaching junior development and database professionals.
-
Information Technology Business System AnalystCommscope Jun 2022 - Jul 2024Bengaluru, Karnataka, IndiaPower-BI: Designed and developed interactive dashboards and reports using Power BI to provide insights and support business decision-making. Created custom visualizations and calculated fields to provide actionable insights. Developed complex DAX queries to meet reporting requirements. Built and maintained data models and integrated them with Power BI for effective data analysis. Utilized Power Query for data extraction, transformation, and loading (ETL) from multiple sources such as SQL Server, Excel, SharePoint, and others. Connected and integrated data from various sources, ensuring data consistency and accuracy in reports. Implemented data refresh schedules and automation for reports using Power BI Service. Collaborated with business stakeholders to gather and analyze business requirements for developing BI solutions. Worked closely with other teams such as IT and business analysts to understand data requirements and ensure data accuracy. Provided user training and support for Power BI tools and dashboards, enhancing data literacy across the organization. Optimized report performance by implementing best practices for data model design and query execution. Managed data security using row-level security (RLS) and user-based permissions in Power BI reports. Conducted performance tuning for reports to ensure fast load times and responsiveness. Deployed Power BI reports to Power BI Service and managed updates, versions, and sharing options. Utilized Power BI gateways for secure data refresh from on-premises and cloud data sources. Continuously improved existing reports and dashboards by incorporating feedback and ensuring they meet evolving business needs.OBIEE, ETL (Informatica), DAC: Designed and developed interactive reports and dashboards using Oracle BI Answers and Oracle BI Dashboards to provide insightful and actionable data. -
It Business AnalystCommscope Jun 2022 - Jul 2024Designed and developed interactive dashboards and reports using Power BI to provide insights and support business decision-making.
-
Application EngineerEteams (Client: Commscope) Apr 2022 - May 2022Developed Power BI reports to Power BI Service and managed updates, versions, and sharing options.Utilized Power BI gateways for secure data refresh from on-premises and cloud data sources.Ensured adherence to data governance policies, maintaining high standards for data quality and accuracy.Followed industry best practices in data visualization to ensure clarity, usability, and effectiveness of the reports.Translated complex data sets into meaningful visual insights for diverse stakeholders, including executives and department heads.Diagnosed and resolved issues in dashboards and reports, including data discrepancies, performance bottlenecks, and security concerns.Continually improved existing reports and dashboards by incorporating feedback and ensuring they meet evolving business needs.
-
Report ConsultantObiee, Etl (Informatica), Dac Jul 2019 - Mar 2021Designed and developed interactive reports and dashboards using Oracle BI Answers and Oracle BI Dashboards to provide insightful and actionable data.Created custom reports and dashboards based on user requirements and business needs, ensuring alignment with organizational goals.Created multiple DDR and BI Publisher reports using SQL and RTF Templates.Reports and Dashboards migrated from Development to UAT Instance using Catalog Manager.Developed and maintained the OBIEE RPD (Repository) at three layers (Physical, Business Model, and Presentation) to ensure accurate and efficient reporting.Modeled star schemas and snowflake schemas in the OBIEE repository for effective reporting.Created logical and physical joins, hierarchies, and measures in the repository to enable complex analytics and drill-down reports.Worked closely with the ETL team to understand and ensure data availability in the OBIEE repository.Monitored and optimized data load processes and ensured data accuracy and consistency across reports.Worked on repository migration and version control to ensure smooth transitions between development, test, and production environments.Worked for enhancing Dashboards & pages and development of ad-hoc and regular reports.Processed on Month-end reports and consolidations.Taken care of OBIEE Services and ETL Services ( Informatica, DAC) to bounce whenever required.
Sravani R Education Details
-
S.V UniversityComputers -
Oracle Cloud Fusion Analytics WarehouseCertified Implementation Professional
-
Oracle Cloud InfrastructureCertified Enterprise Analytics Professional
Frequently Asked Questions about Sravani R
What is Sravani R's role at the current company?
Sravani R's current role is Certified Microsoft Power BI, MS Power BI, Power BI Desktop, OAC, OBIEE, Informatica.
What schools did Sravani R attend?
Sravani R attended S.v University, Oracle Cloud Fusion Analytics Warehouse, Oracle Cloud Infrastructure.
Not the Sravani R you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial