Feb '15-Feb'17 Tableau BI Developer Inventurus Knowledge Solutions, Inc. provides an integrated solution that enables enterprise healthcare organizations to achieve ?nancial and clinical outcomes. It offers IKS MARGIN that increases revenue and collections, as well as decreases costs and expands margins. The company also provides IKS PRACTICE, a suite of services to optimize the technology for clinicians and staff to run the practice and provide care. In addition, it offers IKS CARE that allows ambulatory organizations to deploy additional resources to enhance clinical care. Inventurus Knowledge Solutions, Inc. was founded in 2006 and is based in New York, New York. Responsibilities:
- Involved in all aspects of the software development life cycle, including requirements gathering and analysis, design, development and production support.
- Interacted with business users and performed Gap Analysis of Client requirements.
- Analyzed data from multiple departments like Health care, Patient Information, Cost management and Plan Management to assist in decision making.
- Involved in converting, cleaned, analyzed, organized, and documented large data?les prior to importing into Tableau desktop.
- Created Bullet graphs to determine pro?t generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
- Created designs and process ?ow on to how standardize Power BI Dashboards to meet the Requirements of the business
- Worked with team to extract data from external sources and modify data to a certain format to build Power BI reports.
- Loaded data from different sources (text-based ?les, Excel spreadsheets, transaction records) in legacy system to SQL Server databases using SQL Server Integration Services (SSIS)
- Developed Tableau data visualization using Cross tabs, Heat maps, Waterfall charts, Geographic Map, Bar charts.
- Created different KPI using calculated key ?gures and parameters
- Created multiple tableau dashboards to enhance the processing of complex visualization.
- Created solution driven dashboards by developing different chart types including Heat Maps, Geo Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms using Tableau and Power BI
- Reviewed Business requirements and prepared the dashboards as per therequirements and created various types of charts to provide better visualization.
- Blended data from multiple databases, source ?les and created differenttype of dashboards and reports by selecting linked ?eld.
- Worked with SCRUM Project Management and Agile Methodologies for Software development Life Cycle.
- Involved in reviewing business requirements and analyzing data sources form Excel/MS SQL Server for design, development, testing of reporting and analysis projects within Tableau Desktop
- Created dashboards to monitor an adequate doctor staff to patient work load.
- Developed executive dashboards for management and stakeholders to evaluation of initiatives.
- Provided analytic support to patient quality improvement teams working in different clinical departments.
- Created Dashboards with different style using components like List Box, Slider,
- Buttons, charts and Bookmarks and addedTooltips to provide additional information for different marks on views.
- Developed, maintained and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business speci?c challenges.
- Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data updated the worksheets. Published worksheets and related data sources to server.
- Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
- Created groups and users in Tableau server for user authentication.
- Published Tableau dashboards in Tableau server and Power BI dashboards in Power BI service.
- Worked with business users and provided appropriate training and scheduling as systems were deployed. Environment: Tableau Desktop7.x/8.x, Tableau Server, MS Office Suite (Word, Excel, PowerPoint), Oracle 11g, MS SQL Server.