Dharani Golla

• Actively conducting Agile and Scrum meetings with the team members and discussing the business requirements.
• Understanding the legacy applications, talking to Business Users, documenting the 'As is' process, creating Business Architecture Diagrams, and Process Design Documents.
• Analyzing requirements for process workflow changes, changes to the data model, data transformations required, Business Rules needs, new Ul requirements, and determining modifications required to the existing Ul screens.
• Conducting sessions on elaboration items to ensure all risks are identified, prioritized, discussed, mitigated or workaround solutions decided.
• Analyzing Reporting requirements, and creating Report specifications for developers.
• Conducting user story discussion sessions with business users and developers to elicit requirements, create sub-user stories, and decide on the acceptance criteria.
• Showcase newly developed functionality to Business users, get feedback and signoff.
• Ensure newly developed functionality is as per the requirements.

Environment: MicroStrategy Cloud, Oracle SQL Server and Qlik Sense, MS excel, MS Word, MS Power Point

• Worked with Business users and was involved in requirements gathering, design /development life cycle, user interaction, and report design and development
• Managed BI architecture for the SIERA portal, providing a single point of access for key business metrics and results, leading a team of five in an offshore-onshore model, and completing projects with zero escalations.
• Prepared comprehensive Business Requirement Documents (BRDs), Use Cases, User Stories, and other relevant documentation.
• Collaborated with ETL, data, architect teams to develop a schematic layer in MicroStrategy and created logical data models for new enhancements.,
• Automated 10+ complex dossiers, reducing 30 hours of manual effort to a single click.
• Played a critical role in developing and deploying key dashboards, enhancing business insights and decision-making.
• Document best practices for optimizing the performance of MicroStrategy reports and dashboards, including tips on efficient data modeling, report design, and system configuration in JIRA Confluence.
• Expertise in creating automation scripts leveraging various Python libraries to perform accuracy checks from various sources.

Environment: MicroStrategy 10.2,11 Vertica, Agile, MS Office

• Collaborated with cross-functional teams to gather and document requirements, integrated data from various sources, and designed interactive visualizations to aid in decision-making.
• Identified process improvements, managed project documentation, and ensured timely completion of tasks.
• Identified process gaps and recommended improvements to enhance operational efficiency.
• Designed interactive visualizations with drill-down capabilities for enhanced analysis by claims managers and executives.
• Architected and developed MicroStrategy reports and dashboard for MFS Investment.
• Supported developers by troubleshooting MicroStrategy-related issues and ensuring smooth operational continuity.
• · Expertise in designing Office Plugin, Dossiers, Hyper, URL API, and Workstation in Microstrategy.
• Monitor ongoing development efforts and provide regular progress updates to IT and business teams.
• Stay current with new product features and performance-tuning techniques

Environment: MicroStrategy 9.4.1/10.1, Oracle 11g, Informatica, VMware, MS Office, Agile, Scrum

• Produced monthly reports using advanced Excel spreadsheet functions.
• Utilized data visualization tools to effectively communicate business insights.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of the best placement for needed resources.
• Improved decision-making processes with accurate data analysis and visualization techniques.
• Created worksheets using Tableau with primary and secondary data sources using data blending linked by specified relationships.
• Created Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created various views in Tableau - like Tree-maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts etc.,
• Used parameters and input controls to give users control over certain values.
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc.

• Ensured timely delivery of accurate reports by monitoring data processing workflows and resolving any issues quickly.
• Integrated multiple data sources into a centralized repository for more efficient analysis and reporting.
• Streamlined data collection processes for improved accuracy and efficiency in reporting.
• Increased user satisfaction with BI systems by providing comprehensive training and support.
• Assisted clients in defining KPIs and performance metrics, enabling accurate tracking of progress toward strategic goals.
• Developed test plans, performed GUI testing, and utilized MS Project for task and resource management.
• Created over 50 visualizations and dashboards in Power BI, conducted data analysis, and managed project timelines and estimations.
• Provided direct consulting to customers, analyzed data patterns, and worked on end-to-end project
  management and product support.
• Managed project estimations and timelines, providing solutions within stipulated SLAs.
• Utilized advanced DAX queries and Power Query techniques for data transformation and visualization.
• Worked on Connecting to a Snowflake database from Power Query Online.

Environment: Microsoft Power BI 2.40, Azure Data factory

• Designed and developed a merchandising analytics dashboard for GAP Client, integrating data from various sources to provide comprehensive retail insights.
• Developed dynamic visualizations and KPIs, implemented drill-down capabilities, and participated in requirement-gathering meetings.
• Created mapping documents and prompted ad hoc reports, optimizing SQL for performance.
• Collaborated with the ETL team for data validation, utilizing OLAP services to enhance query performance.
• Created complex reports using Freeform SQL and implemented advanced filters with Apply Simple and Apply Comparison functions. ·
• Used analytical and governing settings in VLDB properties to tune the SQL and calculate the metrics in dealing with nulls and zeroes.
• Created complex reports using Freeform SQL.

• Collaborated with cross-functional teams to ensure seamless integration of new features.
• Continuously updated skills through training courses, workshops, and self-study—staying current on industry trends and emerging technologies.
• Collaborated with stakeholders to design and implement BI solutions for clients Rummy Circle and Lottoland.
• Managed operational activities such as cache refreshes and contributed to MicroStrategy Mobile and Web for dashboard creation and updates.
• Performed user testing for reports and documents before migration to production.
• Designed and updated dashboards for MicroStrategy Mobile (iPad) and Web to assess company performance and
  monitor business goals.
• Created intelligent cubes based on freeform SQL to serve multiple reports and developed complex grid reports with OLAP and drill capabilities.
• Created reports with various object prompts to generate various Ad hoc reports.