Arun Mathew Chandy

ad1y18@r.postjobfree.com 240-***-****) Bethesda, MD

Senior Business Intelligence Systems Consultant / Power BI Architect (Azure Data Developer)

Data Analysis, Reporting, Visualization and Data Science with more than two decades of experience working with world renowned corporations and business leaders developing reporting and data analysis /dashboard visualizations for Local County Government, Healthcare Sector, Software marketing/sales, Human Resources /Payroll and Manufacturing Industry.

Expertise in BI systems and Applications specialized in MSBI Stack (SQL Server/SSIS and SSAS & SSRS) and Microsoft power platform.

Industry Verticals:

Government (Local) – Baltimore County Government, MD

Manufacturing & Supply Chain Industry – AMCOR / Bemis & MRF

HealthCare Payer – Carefirst BCBS

Sales & Marketing - IBM Software

HR and Payroll Data -Accenture PLC

TECHNICAL SKILLS

Business Intelligence Systems & Coding Skills:

oAzure Data Developer / Microsoft Power Platform Power BI (with DAX) Desktop / App server

oMS SQL Server Analytical Services (Tabular and exposure to Multi-Dimensional Models) (7+ years).

oPower Apps

oFME (2023 Flow & Workbench)

oAzure Data Factory

oMSBI Stack (SSIS, SSAS, SSRS) 2008-16

oMicrosoft Excel (with Power Pivot), MS Access (Forms, VBA)

oTableau 10 Desktop & Server (2 years).

oMicroStrategy

oSAP Crystal Reports 7 to 2016, SAP Business Objects, SAP R/3

oOracle Hyperion (Essbase and BQY designing), Oracle BIEE

oIBM Cognos Reporting Studio, IBM SPSS

oExposure to ArcGIS dashboards and power BI integration

oExposure to Python and R programing for data sciences.

oExposure to AWS, Snowflake and SAP HANA

oExposure to Intelligence Builder & QlikView.

oExposure to using SAP data via Simplement to create dashboards

Programming/Query Languages: DAX, MDX, SQL, Python, R programming & VB for Microsoft applications

RDBMS: MS SQL 2016, Oracle, Teradata, MS SQL server, IBM DB2, MySQL, Postgre SQL & MS Access

Data Tools: Visual Studio Data Tools 2017/2019, FME -Flow (workbench)

ETL: SSIS & Exposure to Informatica, FME

Project Management:

oSAFe® 4 Agilist (Certification in progress)

oMicrosoft Team foundation Service (TFS)

oAzure DevOps

Skilled in data analysis of EMS (National Highway Traffic Safety Administration (NHTSA) Office of Emergency Medical Services) for state of MD.

HealthCare EDI Insurance industry - Enrolment / Group & Billing – HIPPA EDI: 834/820 /837 and Group installation XML & TriZetto Facets 5.40 with Medical Customer service Workflow process expertise.

EDUCATION, CERTIFICATIONS AND PROFESSIONAL TRAINING

Education:

Bachelor of Engineering - Electrical and Electronics Engineering with a focus on Information Technology (2000 – 2004)

Technical Certifications:

Tableau Certified Associate (Desktop / Server) - In training.

Cognos Report studio & Analysis studio training by IBM

Presentation skills for a global audience, corporate training by IBM

Pipeline metrics analysis and financial forecasting training by IBM

Microsoft SSRS, Hyperion report development and Essbase connections training from Accenture PLC.

ANIIT Certification – NIIT Academy: Technical Diploma – VBA programming, Java J2EE and .NET and MS – SQL DB

Distributed Control Systems – Training by HONEYWELL (PLC, SCADA & ladder logic programming for Controller systems)

Professional Experience Summary

AGASTI, Baltimore, MD Aug ’15– Till date

Agasti is an IT solutions partner specializing in the business intelligence solutions to federal/state governments and commercial clients in manufacturing, public health services, telecom, retail, media, and financial services industry.

Business Intelligence Consultant: BI Reporting & Analytics and ETL development projects for different clients

Client: Baltimore County Government Feb’20– Till date

Senior BI (PowerBI) Consultant

Azure Data Developer (with focus on Azure data factory & Power BI Service )

Played the role of BI Consultant & database architect supporting developing dashboards and metrics for 25 local government departments and offices.

Developed data flows and BI products from various data sets and sources.

Consulted in creating requirements document and helping procurement of vendor case management applications for County Health Departments.

Develop/assist in design Geocoding process flows EMS incidents.

Enterprise data mapping and data architecture using Sparx (Enterprise Architect).

Exposure to implementing Dataverse tables, building and managing dataflow and workspaces.

Work with ETL teams to design the data flow and cube designing.

Create documents and training documents for using the tools and reports created using power BI app

Create power apps and deploy for use by power BI report consumers.

Currently Working in an Agile environment ADO.

Built SSAS Tabular models for power BI Reporting and POC projects.

Expert knowledge on Power BI Desktop (up till oct 2023 PB Desktop release).

Applications Utilized: MS SQL Server (Database, Analytical Engines & Reporting Services), MS BI (SSIS/SSAS/SSRS)2016-17 & visual studio 2017), SQL Server Management Studio (SSMS), FME (Flow and Workbench, moderate exposure to FME app server). Microsoft office suite (Excel, Access, Visio and PPT), Power BI Desktop to develop dashboards and reports and Power BI App to publish for pro users.

Client: AMCOR Oshkosh, WI Aug ’19– Dec’19

Senior Power BI Consultant & Manufacturing SAP Data Analyst

Working with manufacturing business Analyst and subject matter experts to create highly utilized power BI reports and dashboards.

Work with ETL teams to design the data flow and cube designing.

Create documents and SOP for using the tools and reports created using power BI app

Create power apps and deploy for use by power BI report consumers.

Build Visio diagrams to create data flows and work on predictive analysis process and reports.

Currently Working in an Agile environment using TFS.

Built SSAS Tabular models and published in SAL Azure for power BI Reporting and POC projects.

Expert knowledge on Power BI Desktop updates (Nov 2019 PB Desktop release).

Applications Utilized: MS SQL Server (Database, Analytical Engines & Reporting Services), MS BI (SSIS/SSAS/SSRS)2016 & visual studio 2017), SQL Server Management Studio (SSMS), Simplement Microsoft office suite (Excel, Access, Visio and PPT), Power BI Desktop to develop dashboards and reports and Power BI App to publish for pro users.

Client: CareFirst BlueCross BlueShield Owings mills, MD Aug ’15– July ’19

Senior HealthCare Consultant & Data Analyst

HIPPA X12 EDI Transactional (834/820/Group XML)/Automated Enrolment processing root cause analysis on identified defects and implementing process and systems change ; Responsible for oversight defect logging and review of SERD (Small Enhancements Requirements Document) ; Assign tasks & guide Senior Business Analyst in development of Use cases, detailed business requirements and building test case scenarios .

Expert level understanding of TriZetto Facets 5.50 in functional areas Member/subscriber, Customer Service, Workflow, Claims & Billing.

TriZetto Facets Reporting (RUBI) working with business users building daily status reports for C suite executives. Depending on usage/value, collaborated with ETL, BI and DBA to transform these status reports as standard dashboards for enterprise level implementation.

Work as a liaison between public exchanges/CMS & Carefirst business teams to understand changes in EDI processing (ex. Switch files for VA-FFM) and working with mandates, legal and policy leadership implement these changes to EAB (Enrolment and Billing) day to day business process and rules.

Working in close partnership with District of Columbia Health Benefit Exchange Authority implemented a customized Group installation XML EDI Process (Event Driven XML EDI process). Provided guidance and data mapping details requirements to be implemented in this custom EDI so that group installation / maintenance and termination process could be automated in Carefirst System (Facets: group/subgroup), did UAT on Facets SIT A /B and provided timely and accurate and accountable feedback to DCHBX.

Support all internal projects in Carefirst EAB vertical and provided guidance for technical and business process review meetings with other business areas like individual markets and Claims vertical projects as a subject matter expert on Exchanges, EDI and Facets business systems.

Maintain and report KPIs and workforce time and productivity metrics for senior leadership.

Accountable for providing business system requirements & user requirements in JAD sessions working with Senior BAs, Data Modelers /Architects & Pega developers other software developers working with our (On/Offshore) implementation partners (cognizant and Infosys); worked as a liaison between all these teams and Carefirst business.

Responsible for the Small Business Health Options Program (SHOP) Data migration (ETL process) for small groups (2-50 employer size groups), between CareFirst BlueCross BlueShield and Public Exchanges, was accountable for this member and group data transfer between CF and DCHBX.

Accountable Business stakeholder with oversight over all EAB Projects providing User requirement, testing scenarios & UAT Approvals for (Automated Enrolment Command Centre, Payment Management System Command Centre, Escalation Management Command Centre & Enrolment Reconciliation Command Centre) and Group XML ver.2 injection from DCHL and processing the same to Facets.

Collaborate Public Exchange EDI teams, Internal CF Project Delivery managers, QA and Offshore teams to plan / prioritize system enhancements and project releases.

Data Analytics Projects / process:

1.Developed Power BI Reports; migrated the existing standard scheduled reports created in Facets Rubi to Power BI Desktop. Initial phase of this project Data was accessed from Facets Reports DW using the on premises import mode; build the models within Power BI developed enhanced existing reports.

2.Data cleaning and integration with other data sources within Power BI and developed Dashboard, Utilized DAX (Data Analysis Expressions) to recreate the access / Excel VBA logics and formulas. Developed Calculated Columns, Tables measures rewriting mostly from Excel reports & Developed KPIs. Also, worked on and created time calculations.

3.Worked on sensitive data and had PHI/PII information, implemented row level security & also had to work with Power BI server administrator and configuring the Power BI gateway for on premise data refresh and schedule data refresh in Power BI.

4.Utilized existing SSAS cubes and created live connections and deployed the Dashboards to Power BI app server.

5.Implemented SSIS Projects to consume flat files from different external health care exchanges (MD Exchange/ VA Federally facilitated marketplace & DC HBX)

6.Build and scheduled SSRS reports and pinned these reports to Power BI Dashboards.

7.Created security group by using the Admin Portal; configure access to dashboards and app workspaces; configure the export and sharing setting of the tenant; for apps that I created. Engaged with Power BI Admins to create reports on Usage, control gateway permissions, Tennant Settings & Capacity settings.

8.Deployed BI Desktop reports to Power BI Service and deployed dash boards for specific user groups working with Power BI Server administrators in the organization.

Projects Enrollment and billing HIPPA EDI (843/820 & XML) Projects implemented that I was accountable:

1.Group & Membership Data migration to DCHBX, review make edits the use cases for the ETL process; ensure data quality and timely ftp process. Engage with exchange to troubleshoot issues, do root cause analysis and fix the issue before the next schedule data transfer by collaborating and engaging with technical teams and business users.

2. 820-member level Payment processing & Reconciliation project:

(a)Accountable to building process and systems for applying payment and retractions to Facets; creating test scenarios and validation rules for applying payments and retraction to right group.

(b) Oversight of building a reconciliation process based on 820 EDI transactions, subscriber eligibility and identify overpayment, underpayment and orphan members for a given coverage month. Supervised building the logical data models and reviewed and approved the final physical models and implements the entire process end to end.

3. 834 Enrollment Reconciliation project & Pega Command Centers:

(a) Collaborated with public exchanges and FSP (Full-Service Producers) to create business rules for building a monthly enrolment member level reconciliation system. Working with technical partners-built business systems and process to identify create discrepancies report it back to exchanges and create internal Pega work objects for EAB technicians.

(b) process improvement to auto resolve identified discrepancies which was implemented as a later project helped save time and effort that also improved customer service.

4. Accountable success full execution Federal Employees Group (large group with 60k members) class migration project, where more than 30k members were notified via notification letters and defaulted a different Class.

5. EAB & Credit Collections Facets Workflow project: Created business process diagrams using Visio, working with business user’s custom built an end workflow process using Facets Customer service application. This process helps Carefirst track Paper transactions, Manual Claims processing issues and Automated Enrollment Errors. Dashboards are also designed to keep track of productivity and daily open inventory for different functional Areas.

Applications Utilized: IBM DB2, Oracle 12c, MS SQL Server, MS BI (SSIS/SSAS/SSRS)2012/2017,), Microsoft office suite (Excel, Access, Visio and PPT), Power BI, MicroStrategy & Tableau for Data Visualizations. Erwin for Data modelling.

IBM – Software Group (SWG) Aug ’09 – Sept ‘14

Business Intelligence Data Analyst - Software Marketing Systems

IBM SWG is a major vertical of IBM. Since 2010, it was sub-divided into two groups: Middleware and Solutions, lead a team of 15 analysts to support middleware marketing data analytics.

Engage with the software leadership as subject matter expert on IBM marketing data addressing business owner’s questions and producing efficient and reliable reports and dashboards to help decision making

Generate tactical and strategic analytical insights to inform, support and execute marketing programs across IBM software middle ware group

Conduct regular and ad-hoc analysis and data mining on customer & Transactional data to provide business insights for tactical and strategic requirements

Analysing existing transactional database schemas and designing start schema models to build sophisticated reports using Cognos report studio, Hyperion and Excel

Data modelling using IBM SPSS working with business and technology teams

Prepare executive presentations for internal, customer and analyst facing events, including template design and key messaging to clearly communicate IBM’s position as an industry leader

Make design changes in the BI reports built and customized to take in to account organizational changes and accusations

BI Report development projects for SWG marketing: Project ‘Sunrise’ migration of Oracle Hyperion BI reports to an IBM Cognos environment

IBM CO-Marketing budgeting data analysis for Business partners, funds allocations for marketing events around the world an analysis of its usage and impact on overall business pipeline in terms of leads created

IBM Software sales and GAP analysis on the CQ-NQ (current/next quarter), this is a weekly update reports that’s published through Hyperion Essbase. This report was automated to pull data a collection of Sales lead generation CRM data marts

IBM software marketing Digital data lead generation, web response & events data queried through IBM DB2 Client and IBM Cognos report builder to create reports from the data. QlikView Reporting tool also use for building custom reports and IBM Mid-Market Program framework data analysis

Identify, Analyse, formulate, document and communicate business data requirement for technical data specifications and deep dives into the data content (data profiles) to understand interdependencies, quality rules, potential enrichments, etc. from both data sourcing and data utilization perspective

Data Analysis and modelling that includes data, process and calculations required for statistical and/or mathematical studies

Verify the delivered system against functional and non-functional requirements and specifications. Author a test plan and test cases, define the test data, execute tests, communicate test progress and results, and maintain a requirements traceability matrix (RTM)

Adequately address and balance long-term needs with near-term project iteration requirements and timing. Effectively collaborates with subject matter experts, project leads, analysts and developers to understand needs and communicate a detailed requirements and specifications

Proactively and effectively convey business requirement and data & reporting specifications to ETL and BI engineers and provided clarification and guidance when needed

Applications Utilized: IBM DB2, IBM Cognos Report studio, Query studio and Analysis studio, MS SQL 2008/12, IBM SPSS, IBM Enterprise Marketing Management tool (UNICA), Microsoft office suite (Excel, Access, Visio and PPT with VBA programming), Oracle Hyperion 9.3 with Essbase, QlikView, MicroStrategy and Tableau.

Accenture PLC – Accenture HR Services Dec ’06 - Aug ’09

Management Information Systems – Team Lead / Process Analyst / Subject Matter Expert

AHRS – Is an integral part of Accenture PLC responsible for internal Human resources data management as well as a service provider for external customers. I was part of the MIS (management information systems group) where I had been working as a BI Developer and Reporting specialist. My responsibilities included writing SQL queries and stored procedures for the BI Report development through MS-SQL, Cognos Impromptu, Ceridian payroll processing systems, SAP r/3, PeopleSoft HRMS and MSBI (SSIS/SSAS and SSRS).

Project: Accenture North America May 08-Aug ‘09

Role: MIS HR Data Analyst & SSRS Developer

The Project involved creating and maintaining new databases for AHRS Operational floor, where we had to be responsible for the data systems that included Performance tuning, creating, deploying, and scheduling reports. One major task was to ETL of data from flat file, excel sources and Access DB etc.., migration of data, writing T-SQL code, make backups and create various operational, drill-through and dynamic reports through SSRS & SSAS.

Business Process case studies to analyze data models and organizational structures of Accenture (North America) NA to better understand the human resource data for NA employees and the employees who work in the NA as part of Accenture’s global workforce development programs

Design logical & physical data models and created DDL scripts to create db schema and db objects

Design various HR services, drill through and drill down reports through SSRS 2005

Developed MDX queries against SSAS cubes to generate reports for analysis

Involved in general db administration, query performance tuning and validating the existing schema

SAP R/3 HR report building for all geo regions of Accenture NA and scheduling of these reports.

Applications Utilized:MS SQL Server 2008, MS Access (Forms and Macros), MSBI (SSIS, SSRS, SSAS) VB Script, C#, ERWIN Data Modelling, BIDS 2005 and SAP R/3, VBA Programming, Oracle Toad.

Project: Wyeth Pharmaceuticals, USA Jan ‘08-April ‘08

Business Requirement Analysis from users and administrators for designing data models for Benefit programs, plan types and other HR functionality

Customize the Brio* tool to work with the legacy systems and data sets that were used for the HR Systems, do a data migration to oracle db. And do a run time analysis on the HR data before loading to the systems before using this data for publishing the reports.

Manual testing on the quality of data migrated from one system to another, maintaining adequate process documentation

Work with HR teams at Wyeth to get transitioned on the design concepts that the use for their standard reports and suggest improvements and provide better options on the same

Applications Utilized: SAP R/3, PeopleSoft HRMS, Ceridian Payroll, Microsoft office suite (Excel, Access, Visio and PPT with VBA programming), *Oracle Hyperion (Brio 6.x)

Project: Levi Strauss & Co, USA Aug ‘07-Dec ‘07

Business Analysis on HR data systems and assist in application development, debugging, configuration and optimization from a Database and BI systems perspective

Responsible for performance tuning and optimization of SQL queries and Indexes

Conducting BI applications and Database system study & coordinating with team members for system design, integration & application maintenance. Keep system down time to within the SLA and updating the business users these issues

Customize and develop reports that are of standard or work with the business users and HR leadership to build custom reports

Applications Utilized: SAP R/3, PeopleSoft HRMS, Ceridian Payroll, Microsoft office suite (Excel, Access, Visio and PPT with VBA programming), Oracle Hyperion (Brio 6.x)

Project: GMAC, USA May’07-Aug ‘07

(The General Motors acceptance Corporation, now Ally financial)

Build PeopleSoft HRMS query g for building and scheduling custom and standard reports. Use the data directory and analyse the tables and HR managers handbook to build reports that can be used for everyday HR functions

Worked on existing report performance improvements projects, found issues, and fixed them.

PeopleSoft ERP system worked on mapping employee IDs to Dept. IDs and other HR functionality implemented into the existing system

Worked to build equal employment opportunity commission reports through PeopleSoft query designing

Applications Utilized: SAP R/3, PeopleSoft HRMS, Ceridian Payroll, Microsoft office suite (Excel, Access, Visio and PPT with VBA programming), Oracle Hyperion (Brio 6.x)

Other HR Reporting Projects: Dec ’06-May’07

Client: Sandvik North America

(Engineering group that builds tools, materials technology, mining, and construction)

Role: SAP & PeopleSoft HRMS – Technical trainee & MIS Reporting

Client: Best Buy

(Electronics retail outlets across NA)

Role: Associate Technical trainee – MIS Reporting systems

MRF India Pvt. Ltd, Kottayam / Chennai, India April’04 – Dec ‘06

SQL Data Analyst – Management Systems Engineer

Madras Rubber Factory (MRF) is one of the leading manufacturers of radial tyre in India; Data management project that involved material management and production floor supply chain management. SQL Server along with VB and Crystal reporting were technologies used by the IT technical team and IT were also involved with project management tools implementation and its support.)

Creation and maintenance of SQL server data base and application development through VB and Crystal Reports publishing

SQL and T-SQL used extensively to create the data management systems and build reports and retrieve data information through the custom-built applications

Transferred data from flat files, Excel spreadsheets and heterogeneous data to SQL server using DTS and used BCP & Bulk insert

Technical documentation and document control process implemented, version controls and periodical checks planned and executed. Lead a team of engineering interns on the document management project

Performed complete back-up and restoration, database maintenance, service pack updates on server and client, conduct performance tuning and build ActiveX DLL COM Components using VB 6.0

Install and train manufacturing floor production engineers on Primavera project planning tools, teak formal and informal training sessions for medium to large groups of engineers

Data and statistical research sales pipeline data and build desktop analytical and automation projects using Microsoft Access and Excel through VBA programming

Interfacing with automation engineers on the manufacturing floor for business requirement analysis and coordinate with sub-contractors to implement these functional requirements into the production line

Maintain and track updates to the process documentation of DCS, PLC and SCADA systems

Applications Utilized: MS SQL Server 2000, T-SQL, DTS, Microsoft office suite (Excel, Access, Visio and PPT with VBA programming), VB 6.0, Crystal Report 8.0, Windows NT & Primavera Project Planning Tool v.3, BRIO

Contact this candidate