Pravas Ranjan Mohanty

• Analyzed data for planning and designing Power BI reports in Power BI Desktop.
• Wrote SQL queries to extract large volumes of records from databases.
• Developed PL/SQL queries for various database operations.
• Utilized Power BI Desktop to create calculated columns and measures using DAX.
• Demonstrated expertise in dimensional star and snowflake schemas.
• Created data analysis prototypes using Power BI, Power Pivot, Power View, and Power Map.
• Formulated advanced DAX functions, including Logic, Time Intelligence, and filter/table functions.
• Published interactive reports and dashboards while managing user roles and refresh schedules.
• Achieved significant improvements in migration processes within Media Domain through optimized quality checks.
  Facilitated training sessions for junior team, reinforcing foundational knowledge of critical concepts.
  Elevated standards of quality assurance, leading to enhanced project performance.
  Implemented efficient methodologies to bolster migration workflows effectively.

Project Undertaken:

Project 1 :-

Domain: Media.

Duration: July 2022 - September 2023.

Client: U.S.

Responsibilities:

Data Collection - Designing surveys and questionnaires, and collecting data from various sources such as online surveys, OneDrive, SQL Server, etc. To reach a wide audience.

Data Analysis - Utilizing statistical tools to analyze and interpret data, identifying trends, patterns, and actionable insights.

Market Evaluation - Evaluating market conditions, and identifying potential opportunities for products or services.

Analyzing competitors to understand their strengths and weaknesses.

Report Preparation: Developing detailed reports and presentations to effectively communicate findings. Presenting insights and recommendations to stakeholders and clients.

Strategy Development - Offering practical recommendations grounded in experiential insights. Collaborating with marketing, product development, and strategy teams to guide business decisions.

Monitoring and Tracking - Monitoring competitors' brand activities, product launches, and marketing strategies to spot trends and opportunities. Tracking the performance of marketing campaigns and other business initiatives.

Client Interaction - Delivering regular updates and discussing improvements based on experience with clients. Engaging with clients to understand their research needs and objectives.

Time Management - Overseeing research projects from start to finish, ensuring timely and precise delivery of results. Collaborating with team members and external vendors, as required.

Project 2 :-

Project: Capital One Monthly Tracking.

Client: Capital One.

Description:

• Capital One Financial Corporation is an American bank holding company specializing in credit cards. We deal with the data of credit card types from Capital One. We conduct a survey with some open-ended and closed-ended questions, and then generate the data based on the responses. We, as Power BI developers, develop interactive reports on a monthly basis, tracking feedback data.

Roles and Responsibilities:

• Analyzing business user requirements, analyzing data, and generating reports in Power BI Desktop based on the requirements.
• Imported data from the SQL Server database to Power BI to generate reports.
• Built highly interactive reports and dashboards using Power BI Desktop.
• Created a workspace and content packs for business users to view the developed reports.
• Developed parameter and dimension n-based reports, drill-down reports, charts, and reports using Power BI Desktop.
• Data Analysis Expressions (DAX) are used to solve a number of basic calculations and data analysis problems.
• Scheduling the reports to auto-update visual data with scheduled refresh.
• Good experience with Power Query, Power Pivot, and DAX functions.
• Creating drill-down and drill-through reports.
• Importing custom visuals from the Microsoft Power BI gallery, as per the client's request.
• Experience in creating YTD, QTD, MTD, and LYTD using calculated fields and measures with DAX.
• Used Power BI gateways to keep the dashboards and reports up to date.
• Deploying and scheduling reports using Power BI to generate daily, weekly, monthly, and quarterly reports, including the current status.
• Published reports and dashboards using Power BI.
• Providing security by using Row Level Security (RLS) implementation.