Data Analyst Business Intelligence

SUSHMA VADALI NAGA

******.**********@*****.***

https://www.linkedin.com/in/sushma-vadali-naga-7b42938a/

Morris Plains, NJ

Professional Summary

• Perceptive and logical Data Analyst communicates well with both technical professionals and end-users to identify and translate business requirements.

• 6+ Years experience in providing Business Intelligence and Data Warehousing solutions in developing large scale Data Warehouse and Reporting Solutions.

• Explore and identify the business opportunities through quantitative/qualitative assessment and KPIs not limited to vertical/horizontal integrations. Upon alignment/approval, mobilize the project team with multi-functions/regions stakeholders.

• Drives business success with recommendations based on data findings by generating Dashboards in Tableau, PowerBI, SAS and other data visualization tools. High degree of fluency in Microsoft Suite applications like Excel – Lookups, Macros, Pivots, Formulas, Charts and Dashboards, including system reporting tools and experience with Power Automate or SharePoint.

• Developed and maintained SQL queries, DAXs to support business intelligence reporting, leading to a 25% improvement in data processing efficiency. Developed automated reporting solutions using Python and SQL, streamlining report generation processes, and reducing the time required for monthly and quarterly reports.

• Proactively communicate with project leaders to clearly define project background, objective, and expected deliverables to understand a project launch and to debrief project members. Actively participated in Agile ceremonies including daily stand-ups, sprint planning, and retrospectives.

• Guide, execute, and deliver fact-based market analysis – by applying market analysis frameworks and methodologies to determine ‘Where to Play’, in terms of product, price, distribution/channel opportunities, geographic markets, competitive position, product segments, technologies, etc.

• Looking forward to seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Skills

• Databases Technologies: MySQL, SAS, Excel, CSV, SPSS, Dimensions, Python (Basics Knowledge)

• BI Tools: Microsoft Power BI, Tableau and Google Analytics (Basic Knowledge)

• Development Techniques: ETL Process, Dashboard Development, Data Processing, Survey Programming

• Domain knowledge: Pharmacy Insurance, Market research, Agile, GIT, Kanban, SDLC

Work History

Data and Reporting Analyst 11/2022 to present

Prime Therapeutics – Remote, New Jersey

• Analyzed, interpreted, and transformed claims, member and pharmacy data into information and insight to empower internal and external stakeholders to make informed business decisions and process improvements.

• Developed analytic methodologies, models, and reports for existing and new pharma products through subject matter expert knowledge and utilization of analysis tools such as SASEG, SQL and Excel.

• Responsible for analytic and consultative which involves client pharmacy data, trends, and reports to deliver recommendations to stakeholders.

• Worked on Ad hoc tickets, User Stories from Kanban board daily in each sprint. Successfully delivered 250+ tickets to the respective pharmacy benefit managers team in Project Scope.

• Designed weekly, monthly, and periodic reports and other analysis for other departments in Excel, SQL.

• Documentation of project constraints business impacts and risks, noting potential impact to organization. Strong acumen for Business Systems Analysis, Acceptance criteria and Project Management.

• Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.

• Participated in requirements meetings to understand business needs and perform Risk Management and System Enhancements.

• Utilized Git for version control, including managing branches, handling merge conflicts, and maintaining project history, ensuring smooth collaboration with development teams.

Data Analyst 06/2016 to 06/2021

Kantar – Hyderabad, India

• Identified and documented detailed business rules and use cases based on requirements analysis. Led initiatives to integrate Power BI with existing data systems, employing APIs and data connectors to streamline data flow, improving real-time data access and automated reporting capabilities across the organization.

• Analyzed transactions using DAXs to build logical business intelligence model for real-time reporting needs. Utilized DAX to create complex measures and calculated columns, enhancing data analysis capabilities and providing deeper insights into market trends.

• Tested data prediction algorithms based on historical data.

• Developed dashboards using Power BI with required policies and procedures that reflected actual goals, tasks, and workflows, while meeting all regulatory compliance requirements.

• Extracted and interpreted data patterns to translate findings into actionable outcomes.

• Utilized data visualization tools to effectively communicate business insights. Worked with business intelligence software and various reports to glean insights into trends and prospects.

• Used statistical methods to analyze data and generate useful business reports.

• Identified, analyzed, and interpreted trends or patterns in complex data sets.

• Collaborated with business-unit leaders to conduct market research, identifying trends and consumer insights that informed strategic initiatives.

Education

Bachelor of Science: Computer Science

Malla Reddy Institute of Technology and Science - Hyderabad, India

Accomplishments

· Google Data Analytics Professional Certificate – Coursera (In Progress) Focus Areas: Data cleaning, data analysis, SQL, Python and data visualization techniques. Current Status: Completing modules on data interpretation and real-world application projects.

· Peer to Peer Awards - 2023

In recognition for achieving work on complex requests, received appreciation from a peer, as part of cross functional team.

· 2019 KORE (Kantar Operation Recognition) AWARDS

In recognition for achieving the target of executing the tasks individually and working with Global team to acquire the required results.

· 2020 Quarter I High Performance Rating

In recognition for consistently exceeding the whole quarter, the rating for Q1 quarter 2020 was Far exceed.

Contact this candidate