Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 
avatar of hardik rawal

hardik rawal

hardik rawal has asked 0 questions and find answers to 1 problems.

Stats

13
EtPoint
2
Vote count
0
questions
1
answers

About

Developing and maintain Report Writing for EHR, Maintain all Report Server on remote location. Work among data analysts, SSIS and SSRS lead developers, plan, and production, Create Crystal Report., SQL Reports SSIS packages for Data Inter-migration, test, alter, and document SQL SERVER 2008 R2, packages, tables, store procedures, jobs

Dealing with various ETL process, Analysis of various Healthcare data, L1/L2 supports, developing Reports using BI tools • Working on Debugging of ETL packages, testing the Packages, scheduling Jobs to execute. Packages in SQL Server Integration Services. • Having proficiency at Data Transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup and Union all to load data into the target database. • Expertise in creating the new data Marts and its daily/monthly ETL process and its scheduling. • Expertise in developing various reports in Cognos Report studio, Analysis studio, Scheduling of Reports. • Expertise in development of Transformer cubes and Access Manager Administration. • Expertise in GE IDX Extractor (ETL), Optum autoloader(ETL) tool in day to day operations. • Expertise in developing the reports in Precision BI tool • Dealing with Healthcare plans in requirement gathering, analysis, extraction and compilation of data submissions in healthcare • Expertise in extraction/analysis of clinical data from Allscripts EEHR(electronics health records) application and PM(Practice Management), • Worked with DBA in various automated Database Administration processes (Backups,Recovery,Partitioning,Deadlocks,blocking etc )

Tables Store procedure, Jobs, Performance tuning work, Auto Data Migration packages tables on Sql Server 2008 R2