ANUSHA VEMURI

• Supported new project initiatives by analyzing preliminary business needs and defining factors such as budget constraints, time management and resource planning.
• Collected, defined and analyzed business requirements.
• Assisted development staff with drafting project plans, advising personnel on milestone planning.
• Coordinated data migration and consolidation efforts.
• Improved dashboard usability by implementing interactive visualizations
  resulting in a 20% increase in user engagement.

• Defined product road map and prioritized backlog of work to meet end user demands.
• Led workshops to analyze and solve business challenges with both stakeholders and cross functional team members through various techniques such as customer journey mapping.
• Supported and Agile Software Development process working in conjunction with end users, stakeholders and technical delivery teams (both offshore and onshore).
• Applied regulatory standards and policies in procedural data analysis.
• Developed 85% custom Microsoft Power BI dashboards, visualizations, and interfaces with Microsoft SSRS to deliver meaningful and actionable insights.
• Perform DAX queries using Power BI tools.
• Delivered 100% assigned tasks within the agreed budget.
• Experienced in solving data issues and performance issues effectively.
• Participated in all levels of discussions to understand requirement and priority and helped to achieve targets.
• Analyzed data to identify root causes of problems and recommend corrective actions.

• Create insightful BI based reports to monitor and highlight contributing factors to financial and operational variances and anomalies helping executives in key decision making.
• Generated daily, monthly and annual reports to address short- or long-term business intelligence questions.
• Worked in data extraction, preparation, and transformation using Microsoft Azure and Azure Data Factory (ADF).
• Developed intelligence-sharing dashboards, providing company-wide access to collected data.
• Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
• Created dashboards to monitor and track key performance indicators.

• Gathered and documented Business Intelligence requirements from users including business rules and measures.
• Migrated all Crystal reports and SSRS reports to SAP Business Objects.
• Provided solutions for optimizing report performances and dashboards using SAP Business Objects.
• Created views and tables for reports using MS SQL.
• Created universe designer using Business Objects IDT tool to support reports across multiple agencies.
• Developed financial reports for users as per requirements and helped users to understand functioning of reports.
• Participated in Unit and SIT level of testing reports by writing test cases to test universe and reports accordingly.
• Documented user manual and guidelines of reports and universe for future purposes.
• Used Jira and confluence tools to track progress of project and maintenance of projects.

• Supported business users & Customers in gathering requirements, business rules and developed reports accordingly.
• Developed SQL queries using stored procedures, common table expressions, temporary table to support Power BI and SSRS reports.
• Developed Power BI model used for financial reporting of P & L and Headcount.
• Experience in writing DAX functions in Power BI and Power Pivot.
• Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques.
• Generated various reports with drill downs, drill through, calculated members and drop downs.
• Created data sources, connection strings and defined datasets for generating report using various report items like tables, sub report and charts to develop reports using Power BI.
• Worked with team of 15 members and was successful in meeting project's tight deadlines.
• Utilized data visualization techniques to present and explain complex data sets.

• Worked with user to understand Requirements and prepared Technical Specification documents for all reports.
• Worked with Multiple data providers including Personal Data files and Free hand SQL to create reports.
• Worked on standard reports as per requirements and suggested few modifications as per changing requirements.
• Troubleshooted & analyzed reports using Drill Through and Slice & Dice.
• Interacted with users for analyzing diverse reports and scheduling them.
• Created Users, User groups and maintained user access rights by using CMC.
• Supported Crystal Report, WEBI reports, Universe and Stored Procedures issues.
• Worked on ETL activities by taking training on Service now for inserting updating and publishing operations.

• Conducted detailed analysis and reporting functions to ensure complete accuracy.
• Analyzed underlying database structure and business report requirements and designed universe as per requirement.
• Prepared Functional Specification and other related documents.
• Developed Web Intelligence reports according to requirements.
• Worked on Control-M jobs for BO reports.
• Tested reports, universe and prepared test case documents.
• Involved in maintenance of reports.
• Also involved in training users on Business Objects for ad hoc reporting.

• Worked well in a team setting, providing support and guidance.
• Analyzed underlying database structure and business report requirements and modification of Universe, Crystal Reports and Webi reports as per same.
• Provided estimates on Change requests and converting same into business solutions by modifying Universe and reports accordingly.
• Created Universe and developing reports for same.
• Created reports using variety of reporting functionalities available in Webi.
• Involved in production support.
• Involved in maintaining and administrating BO Server like maintaining users and groups of different regions.

• Analyzed underlying database structure and business report requirements and modification of Universe and Webi reports as per same.
• Provided estimates on Change requests and converting same into business solutions by modifying Universe and reports accordingly.
• Created complex objects in Universe according to report requirements.
• Created Webi reports using multiple data providers using Universe as data source.
• Created reports using variety of reporting functionalities available in Webi.

• Participated in requirements gathering sessions and discussed feasibility of reports with Business users.
• Prepared design technical specifications of Universe and Reports as per project requirements.
• Developed both Desk and WebI reports using Cross Tabs, Drill hierarchies, Filters and Complex calculations.
• Created complex reports using multiple data providers and synchronized data providers by linking common objects to provide required data in same report from different applications.
• Created different reports containing different layouts in reports that change based on user prompt selection.
• Performed unit testing and user acceptances test (UAT) for universe, reports, and security management to validate against application data.