Biju Jos Cheruvathur
Senior Full Stack BI Developer
Summary
Senior Full Stack BI Developer (Data Architect, Data Engineer, and Data Analyst) with a demonstrated history of ETL, Data Warehouse, BI Semantic (Tabular Models), and Visualization work in the Engineering, Pharmaceutical and Hospital & Health Care industries. Skilled in Python, R, SQL, MDX/DAX, and VBA. Adept with Business Intelligence Solutions such as SSRS, SSIS, SSAS, Power Pivot, Power BI and Tableau. Experienced with SQL Server, Azure SQL Server, Azure Data Factory, Azure Synapse, Azure Databricks, Spark and Hadoop.
Overview
17
17
years of professional experience
Work History
Senior Full Stack BI Developer
Kaiser Permanente
, California
12.2019 - Current
- As a Full Stack BI Developer at Kaiser Permanente, I am primarily a data engineer on KP’s COVID-19 reporting team.
- Building business intelligence and data visualization dashboards using MS Power BI.
- Create and maintain visualizations for Kaiser Permanente’s President's dashboard. DAX formulas are used to incorporate complicated features and nonstandard functionality. Design is coordinated with tabular model development to maximize visualization loading speed (Power BI, DAX).
- Use MS Visual Studio and DAX studio to build and maintain SSAS tabular models for Kaiser Permanente’s Covid-19 Financial and Covid-19 Executive dashboards. Includes creation of Measures, Calculated Columns, Relationships, Hierarchies, Perspectives, and Derived Dimensions. (Visual Studio, SSDT, SSAS, DAX).
- Developer on Agile team participating in PI Planning, Stand ups, Backlog Refinement, Retrospectives, etc. (Agile).
Senior Reporting Analyst
Logix Communications
, Texas
06.2018 - 12.2019
- Building business intelligence and data visualization dashboards using MS Power BI, Tableau, SSRS and OBIEE.
- Data extracting and analyzing based on dynamics data entities .(Azure Cloud).
- Designing ad hoc reports and custom SQL using parameters, filters and prompts.
- Implementing changes to existing BI analytics.
- Building new data mart and maintaining existing database and BI systems.
- Executing migration and publishing reports and dashboard in various environment like Dev, Test, UAT and Prod.
- Administrating report servers and managing users access and security groups.
- Working closely with business units stakeholders including HR, Payroll, Finance, AR, AP, IT and Project Management teams.
- Troubleshooting data issues.
- Helping business unit for creating new change request requirement to interpret and understand data in reports.
- Implementing process improvement activities.
- Focusing on the detail and quality of data.
- Participating in team planning sessions Key Deliverables:.
- Developed Payroll Spending Dashboards and Payroll Allowances & Premiums Dashboard for Payroll Department.
- Developed Headcount Dashboard, Attrition Dashboard and New Hire Dashboard for HR Department.
- Developed Financial Dashboard to show KPI data for revenue, budget and forecast for Energy Services.
- Developed Expense Dashboard to show KPI data for employee expenses and project expenses.
- Converting reports between Tableau and Power BI.
- Support and maintain existing dashboards for AR, IT and Environmental Services Department.
- Support legacy reports from legacy systems.
ETL/BI System Analyst
TERVITA
Calgary, Alberta
11.2013 - 06.2018
- Responsible for Power BI and reporting architecture in Tervita.
- ETL/Business Intelligence Specialist with demonstrated ability implementing solutions to enhance business processes.
- Plan, implement and direct cost-effective solutions and strategies.
- Develop in-house ETL solutions as well as customize out-of-box ETL application solutions.
Informatica Integration Consultant
GROUNDSWELL GROUP INC
Calgary, Alberta
03.2011 - 11.2013
- Responsible for ETL analysis and design solutions.
- Involved with technologies such as Informatica, ORACLE golden gate, MDM architect, SFTP configuration, PL/SQL, UNIX shell scripts and encryption keys.
- Proposed optimal technical solutions coordinating between Business and Technology teams.
Informatica Analyst
Verisk Health
01.2005 - 01.2011
- Involved with project to load results from, Risk Smart software onto EDW through an automated monthly process.
- (The software generates a risk measure for an individual based on a combination of claim diagnosis and demographic information.).
- Responsible for requirements specification, design documents, ETL design, coding, testing and migration.
- Defined and managed ETL resource requirements and allocations, monitored and improved quality, and ensured best practice development techniques.
- Created and maintained external schedules for execution of production processes (ETL and Report publisher).
- Skills required included Informatica, Teradata, UNIX shell scripting, and PL/SQL 2.
Education
Bachelor Of Engineering - Information Technology
CUSAT
Skills
POWER BI , TABLEAU
undefinedTimeline
Senior Full Stack BI Developer
Kaiser Permanente
12.2019 - Current
Senior Reporting Analyst
Logix Communications
06.2018 - 12.2019
ETL/BI System Analyst
TERVITA
11.2013 - 06.2018
Informatica Integration Consultant
GROUNDSWELL GROUP INC
03.2011 - 11.2013
Informatica Analyst
Verisk Health
01.2005 - 01.2011
Bachelor Of Engineering - Information Technology
CUSAT
Similar Profiles
Marie A. StevensonMarie A. Stevenson
Patient at Patient FinancialAdvisor, Kaiser Permanente Eligibility and FinancialServices, FinancialAdvisor, Kaiser PermanentePatient at Patient FinancialAdvisor, Kaiser Permanente Eligibility and FinancialServices, FinancialAdvisor, Kaiser Permanente
Edith NagunaEdith Naguna
Special Needs Program Care Mgt RN Consultant at Kaiser Permanente - Southern California Permanente Medical GroupSpecial Needs Program Care Mgt RN Consultant at Kaiser Permanente - Southern California Permanente Medical Group
MICHAEL NAVAMICHAEL NAVA
Area Director at Kaiser Permanente – The Permanente Medical GroupArea Director at Kaiser Permanente – The Permanente Medical Group
Diana IovescuDiana Iovescu
Program Manager III- Centers for Reproductive Health/IVF at Kaiser Permanente- The Permanente Medical GroupProgram Manager III- Centers for Reproductive Health/IVF at Kaiser Permanente- The Permanente Medical Group
Manish PadalaManish Padala
Full Stack Java Developer (BI-Focused) at AccentureFull Stack Java Developer (BI-Focused) at Accenture