OnBenchMark Logo

Raja Sekhar (RID : yb8plkm8fx9h)

designation   SASS Developer

location   Location : Hyderabad, India

experience   Experience : 6 Year

rate   Rate: $18 / Hourly

Availability   Availability : 2 Week

Work From   Work From : Any

designation   Category : Information Technology & Services

Shortlisted : 1
Total Views : 122
Key Skills
SASS MSSQL Services SSAS Tabular Microsoft Analysis Services Cubes
Discription

Project Details 

Environment  :           Snowflake, Server Reporting Services.

Description:

 

Urovant Sciences is a bio pharmaceutical company focused on developing and commercializing innovative therapies for urological conditions, the project was mainly into data warehouse,

Reporting tables are created in the Snowflake tool in L3 Schema. Initially raw data is loaded into Stage DB by ETL process, again by ETL data is loaded to L1 Schema, will be doing the Curation in L2 schema and finally reporting tables are created in L3 schema.

 

  • Created Tables & Views by using DDL & DML Operations initially.
  • Worked on Joins, Sub-Queries, Derived Tables, CTEs and Temp tables.
  • Written QCs for all the reporting tables what we have developed the code.
  • Involved in gathering the user requirements.
  • Created Cross-Tab, Drill-down, Drill-down and Sub-Report using and linked reports using SQL SERVER Reporting Services.
  • Identified the data source and defining them to build the data source views.
  • Debugging reports and deploying reports.
  • Involved in SSRS report deployment and report server configuration.
  • Involved in other Client projects to explain the development as they used the same kind of code in their science projects.
  • As per the Validation check rules well use of the SQL Scripts like Views, String functions.
  • Used various report items like tables, sub report and charts to develop the reports in SSRS.
  • Scheduled the reports to run automatically.
  • Created schedules and subscriptions.
  • Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet

 

Project Details 

Environment  :           SQL Server Integration Services, T-SQL

 

Description:

 

Waystar’s technology platform simplifies and unifies healthcare payments across the revenue cycle. Initially data is loaded in SQL Server, will be creating Stored Procedures for reporting.

It is a Migration project, will be creating procedures same as on old UI and providing the code to develop the reports in LookerBI.

 

  • Worked on Joins, Sub-Queries, Derived Tables, CTEs and Temp tables.
  • Written QCs for all the reporting tables what we have developed the code.
  • Involved in gathering the user requirements.
  • As per the Validation check rules well use of the SQL Scripts like Views, String functions.
  • Worked on Stored Procedures as per the requirement.
  • Good knowledge on Sub queries, Joins and stored procedures.

 

 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!