Roles and Responsibilities : Managing complete File Exchange activities. Worked on Claims and Clinical Healthcare data . Loading data from Text (Master Data) Files to Database through automatic scheduling of SSIS packages Loading data from Stage DB to Tran DB using SSIS package. Auto Notification to Client for missing files  Fetching Data and load to SQL server DB for Power BI reports and Dashboards. Ensure that all jobs are running correctly and all HL7 Connection are up and reading and writing data without delay. Ensure that Feeds which is receiving through Core Point Integration Engine is loading correctly and timely. Ensure that all files which are receiving from client are uploading correctly & no files are undelivered, in case files are missing report to Clients through auto/Manual notification.  Monitoring SQL jobs with error handling.  Preparing and reviewing the functional & technical specifications like HLD, LLD (Low Level Documents). Hands on experience in building and deploying the Reports/Dashboards by Power BI. Worked on data manipulation using DAX and used DAX functions like table function, aggregation function and iteration functions. Created Healthcare patients information related Dashboards using visualizations like Pie, Bar Chart, KPIs,Tree maps etc. Understanding of the Change management process and supporting the customer’s request on time using Service Now tool.

 Extraction of data from the data warehouse to multidimensional cubes (Hyperion Essbase Cubes) through analytic integration services. Maintenance, enhancement and support of these multidimensional cubes and also ensuring data quality of these cubes. Building complex dashboards using Hyperion Financial reporting which pulls data from these cubes. Understanding requirement on Change Requests raised from the client/users end and analyze on the code change/development required. Tracking on the incidents raised and resolving of issues opened on the HP Quality Center tool and to keep the incidents logged to be within the SLA. Performing unit tests and Data level testing with proper documentation of the test cases and to get them signed off from the QA team before migrating to Production. To constantly stay in touch with the Onsite coordinator in collecting requirements/information on the latest updates and for handover of tasks.  To schedule and conduct Timeline calls with the client to analyze and understand the root cause on Critical issues rose in Production and to conclude on Action items.

Loading data into the Cube - Getting data from the ETL team and after formatting loading it into the cube with the help of Essbase Administration Services.Copying Cube data - Copying Cubes data from Production to UAT and Development Server for Financial Reporting. QC validation - Doing daily quality checks of cube data manually confirming prior and actual years data.Smoke Testing and Log analysis- To check whether all the applications are running after server down using Smartview Add in and Web analysis.Report Generation - Generation of weekly excel reports by loading SFDC and Cube source data to MS access DB.