Janardhan Daram

Company Overview: Novartis Pharma, a global healthcare leader, is committed to discovering innovative medicines to improve and extend people's lives.
Renowned for its dedication to research and development, it combines cutting-edge science with a focus on transforming patient care.
Headquartered in Switzerland.

• Generated Dashboards for Novartis Pharma Project
• Spearheading the entire gamut of functions for this project, including planning, requirement gathering, design, development, testing, and implementation.
• Leading a key role in generating complex formulas for business measure calculations based on various end-user requirements.
• Acting as a key member in creating and modifying Interactive Dashboards and guided navigation links within Power BI dashboards.
• Recognizing factors affecting the performance of reports and optimizing them using various features in Power BI.
• Performing unit testing on various reports and dashboards and managing performance issues effectively in Power BI.
• Meeting the needs of complex business logic by creating advanced formulas and calculations within Power BI.
• Engaged in conducting BI testing by validating the reports.
• Playing a vital role in dashboard development, such as creating Power BI extracts, refreshing data, connecting data sources like SQL and SharePoint, and performing formatting and report operations (sorting, filtering, ranking, Top-N Analysis).
• Created start-to-end reports in Power BI for the Novartis Parma project.
• The project involved analyzing data from Germany, using SQL and SharePoint as data sources.
• Delivered four different reports addressing various business needs and ensuring they adhered to project requirements.

Company Overview and Responsibilities: Tesco Project
Tesco provides information on stores located in Thailand and the UK, which serves as the foundation for developing Power BI reports on various stores' performance on a weekly, monthly, and yearly basis across different malls.

• Prepared use cases and designed documents by analyzing report specifications.
• Developed Power BI reports tailored to business requirements using filters, groups, sets, and parameters.
• Conducted Year-To-Date (YTD), Quarter-To-Date (QTD), and Month-To-Date (MTD) analyses in Power BI.
• Created multiple visualization charts, including heat maps, tree maps, stacked bar charts, waterfall charts, and custom charts.
• Deployed dashboards and reports on the Power BI Server, granting access to end-users for data analysis.
• Integrated data from diverse sources like SQL, flat files, and XML files for comprehensive reporting.
• Managed reports and dashboards, including scheduling reports on the Power BI Server, creating new schedules, and monitoring tasks daily.

Oracle Migration Project
In addition to Power BI work, I have worked on an Oracle database migration project, transitioning reports from Oracle 10g to Oracle 12c. This project utilized Oracle BI traditional tools and was unrelated to Power BI.

Key Contributions:

• Migrated legacy reports to the upgraded Oracle 12c environment, ensuring data accuracy and consistency.
• Collaborated with the team to streamline workflows and improve the performance of migrated reports.

Company Overview:Regency for Expats is a fully regulated insurance provider specializing in offering comprehensive international health insurance plans to globally mobile individuals across more than 120 countries.

Project Contributions:

• Requirement Analysis & Documentation:Prepared use cases and designed technical documents by analyzing report specifications to meet business requirements effectively.
  
• Power BI Report Development:Designed and developed Power BI reports utilizing advanced features such as filters, groups, sets, and parameters to fulfill business requirements.
  Conducted year-to-date (YTD), quarter-to-date (QTD), and month-to-date (MTD) analyses using Power BI workbooks.
  
• Data Visualization:Created multiple Power BI visualization charts, including Heat Maps, Tree Maps, Stacked Bar Charts, Waterfall Charts, and custom charts, to present insights effectively.
  
• Dashboard Deployment:Published developed dashboards and reports on the Power BI Server, enabling end-users with server access to view and interact with the data.
  
• Data Integration:Integrated various data feeds from diverse sources, including SQL databases, flat files, and XML files.
  
• Server Administration:Administered reports and dashboards on the Power BI Server, including report scheduling, creating new schedules, and evaluating daily tasks on the server.