Shweta A.

Shweta A.

Proficient Business Intelligence Data Warehousing Resource in Cognos, Tableau, and Power BI

Shivpuri , India

Experience: 7 Years

Shweta

Shivpuri , India

Proficient Business Intelligence Data Warehousing Resource in Cognos, Tableau, and Power BI

20018.4 USD / Year

  • Immediate: Available

7 Years

Now you can Instantly Chat with Shweta!

About Me

B.Tech. professional with an experience of nearly 9 years in Consulting and Banking Sector

Excellence in the mapping of business requirements and translating them into functional specifications, use cases, services, implementations & custo...

Knowledge in administering activities, deliverables & jeopardies for various Agile projects

An effective leader with proven capabilities in leading teams during transformation project phase & programs; managed projects both from onshore and offshore locations

Getting trained in tools like Tableau/Power BI/Advanced Excel, etc. using Udemy/Coursera online platform

Show More

Portfolio Projects

S&N

Company

S&N

Contribute

 Analyze the BI reporting requirements and prepare functional and technical specification documents.  Designing the strategies for performing key application-related tests i.e.UAT, etc.

Description

Client:
Working with a client which takes a  pioneering approach  to the design of our  advanced medical products and
services , by securing wider access to our diverse technologies for more customers globally, and by enabling better
outcomes for patients and healthcare systems.
Project Profile:
The embedded reporting can no longer support the required increasingly large data sets nor the frequency at which
reporting is required without impacting the transactional complaint handling. This introduces delays to the
transactional complaint handling lowering the efficiency and endangers compliance with global requirements for
complaint management and 60 day target for complaint closure. At the same time, it negatively impacts stakeholders
relying on complaint data as access to the embedded reporting had to be disabled to ensure a stable system for
transactional complaint handling.

Page 3 of 7

The embedded reporting tool cannot deliver all reports that are required. This has led to issues in FDA audits where
the client was unable to deliver the required data within the expected time-frame to the investigator, and particular
required fields could not be delivered as requested.
The complaint analytics solution shall resolve the issues coming from large data sets, and de-coupling of the
analytics from the transactional database shall eliminate the impact of reporting on transactional complaint handling.
Furthermore, as a result, it will be possible to re-enable stakeholder’s access to complaint analytics reporting. The
solution shall have the option of drag and drop to create ad hoc reports, e.g. needed at an FDA audit to deliver
exactly what is requested by the inspector and within the required time-frame.

Key Responsibilities:
 Developing the sample reports as the requirements given.
 Developing the Reports/Dashboards in the Cognos Environment, and testing the reports against the
database.
 Effectively coordinating with the onsite team to migrate or implement the project from the Dev
environment to the Stage.
 Communicating effectively with the team.
Technical Environment: Cognos 10.2.2, Oracle SQL Server

Show More Show Less

Tools

Excel sheets

BCI

Company

BCI

Description

Client:
Working with a leading Health Care company, which develops, manufactures & markets the medical products and
healthcare services that focuses on critical therapies for life threatening and acute medical conditions.
Project Profile:
This Project is about client consolidating its ERPs down to 4 regional and 1 Bioscience manufacturing JD Edwards’s
instances. An effective Business Intelligence (BI) environment is needed to help realize the benefits from the ERP
consolidation effort. Therefore, the BI Strategy Project is an integrated component of the ERP Consolidation
Project.
Even though the BI Strategy is focused on the requirements of ERP (Finance and Supply Chain), we have taken a
broader, more holistic approach to the scope of the project.
The purpose of this project is to communicate high-level guiding principles that will steer future developmental
phases to the desired end-state
Key Responsibilities:
 Developing the test cases and testing the reports against the database.
 Effectively coordinating with the onsite and client team to migrate or implement the project from the Dev
environment to the Stage and finally to the Production and supporting the system.
 Communicating effectively with the team.
Technical Environment: Cognos 10.2.1, SQL Server

Show More Show Less

Tools

Excel sheets

SAINT

Company

SAINT

Description

Client Description: Client was in the Health Care Sector
Project Description: The project’s aim is to implement BI solution and create set of reports that helps in gathering
data for Life sciences. Commonly known as SAINT project, is a set of reports that will help users to retrieve the data
based on the technical spec documents provided. SIANT creates report as per the design document and implements
the same set of reports in the Dashboard form using the Data Visualization tool Spotfire.
Key Responsibilities:
 Creating a systemic document for upcoming project to analyze columns in each report, their description,
their availability in the current data warehouse and their association with respective dimension and fact
tables.
 Creating/Developing Cognos reports through the use of both Relational and Dimensional designed
packages.
 Analyze the reports, test them and see the areas where time to execute the reports can be improved i.e.
finding the gaps to improve report performance.
 Learn new technologies like Business objects.
 Development of Dashboards in Spotfire
Technical Environment: Cognos 10.2 BI Report Studio, Framework Manager and Oracle, Spotfire

Show More Show Less
Share:

Verifications

  • Profile Verified

  • Phone Verified

Preferred Language

  • English - Fluent

  • Hindi - Native/Bilingual

Available Timezones

  • Eastern Daylight [UTC -4]

  • Central Daylight [UTC -5]

  • Mountain Daylight [UTC -6]

  • Pacific Daylight [UTC -7]

  • Eastern European [UTC +2]

  • Eastern EST [UTC +3]

  • Greenwich Mean [UTC ±0]

  • Further EET [UTC +3]

  • Australian EDT [UTC +11]

  • Australian CDT [UTC +10:30]

  • Dubai [UTC +4]

  • New Delhi [UTC +5]

  • China (West) [UTC +6]

  • Singapore [UTC +7]

  • Hong Kong (East China) [UTC +8]