Engineer Data

Vivek Vishwanathan

Certified Cloud Specialist/Data Engineer

Email: ******.****@*****.***

Ph: 405-***-****

SUMMARY:

Multifaceted Solutions Architect with 15+ years of professional experience in highly challenging environment developing strategies and road-maps for data warehouse business solutions on cross technology platforms including SAP ERP, Salesforce and Cloud computing.

Exceled building Cloud Business Solutions with a demonstrated history of working in the hospital & health care (EPIC & Cerner EMR system), pharma, finance and retail industry.

Technology leader with cloud computing and data engineering experience in architecting enterprise-wide datawarehouse, business intelligence implementation, dimensional data modeling, Dashboard data security and Master Data Management

Architected solution to deploy on-premise database to Oracle Cloud Infrastructure (ADWC) and synchronized data using FastConnect for healthcare revenue and clinical data.

Techno-functional expert in Data & Analytics, business analysis for customer facing applications.

Collaboration and influence skills that bridged gap and established effective business user and end customer relationships.

Partnered with data scientist & analytics team and other IT stakeholders in strategic planning, project deliverables and proactively drive vision for future state of organization.

Implemented infrastructure to ingest, process, and store huge volume of data. Denormalized data for real time ingestion and created jobs to aggregate and summarize data for analytical queries.

Ability to ramp up quickly and manage multiple projects simultaneously through complexity and ambiguity. Ability to work under time constraints with strong problem-solving skills.

CERTIFICATION:

Oracle Cloud Certified Autonomous DB specialist

Oracle Cloud Certified Solutions Architect

Oracle Cloud Certified Operation Associate

Project Management Certified Professional

TECHNOLOGY EXPERTISE:

Data & Cloud Platforms

Oracle Cloud Infrastructure, Amazon Web Services (AWS), Google Cloud Platform

ETL/ BI/OLAP Cloud Application:

Tableau, OBIEE, MicroStrategy, SAP BO, Microsoft SSRS, SSIS, IBM DataStage, Informatica 10.x PowerCenter/PowerMart/Informatica Data Explorer (IDE), Pentaho, Python, Oracle APEX, JSON

SQL & NoSQL Databases

Oracle 19c, Oracle Autonomous Database, Cassandra

Functional Skills

HealthCare Revenue Cycle (Cerner & EPIC), Clinical Data Management, Finance Data Store

EXPERIENCE:

Sr. Oracle Cloud Architect, Adventist Health, Sacramento CA (Feb 2017 – Present)

Responsibilities:

Responsible for cloud migration of Oracle 11g on-premise database with over 1200 objects and storage of 22TB to Oracle Autonomous Database on Cloud

Provided autonomous cloud DB design oversight based on AWR reports, SQL monitor HTML report executed on premise database objects for cloud migration

Developed implementation strategies for on-premise data lift and shift from Pluggable database using ENCRYPTION_ALGORITHM to Oracle Cloud Infrastructure

Design a highly scalable and redundant Cloud virtual infrastructure to support the company’s future growth

Built a highly available database on cloud environment with sufficient resources to handle the workload variation

Set budget on cost tracking tags with soft limits on spending credits on Oracle Cloud Infrastructure

Designed IAM policy for accounts team to read usage budgets. Set alert rules to monitor budget.

Built a pilot dashboard analytics with database availability, SQL execution, number of users on OCI suite

Validated performance by setting up performance baseline (STS), throughput, SQL profiles and removing unnecessary parameters

Designed BI solutions (ETL & reporting) related to Work Force Management, Cost Analytics, supply chain areas such as Surgical Services, Clinical & Non-Clinical, Labs, Hospital services.

Built data governance for Cerner & EPIC source system data, ensured high system availability, usability, integrity and data security for sensitive information (PII & PHI).

Duties included data model design, development, support of enterprise database initiatives, development of front-end dashboards.

Provided solutions for c-executives drive savings, business efficiency, innovation & improvements.

Implemented end to end solution for Workforce Management that benefited executives to monitor operational agility, productivity during high volume, Bi-Weekly productivity for Nursing Units and Auxiliary departments, productivity analysis, Bi Weekly Payroll data.

WFM dashboard has 85K views with over 3000 users. Organization reduced financial and non-compliance risk, reduced workforce expenses and increased access to monitor productive and premium hours & dollars

Data Engineer Solution Consultant Client: HP INC. /UNISYS (April 2016 – December 2016)

Description: Responsible for applications development, network and server management services for the consortium’s integrated on-line, real time system-CalWIN (California Work Opportunity and Responsibility to Kids Information Network) which is an automated healthcare and welfare eligibility determination system developed and managed by Hewlett Packard Enterprise that serves 18 California counties with over 2.5 million families.

Data Engineer Consultant Health Net, Sacramento CA (August 2015 – February 2016)

Risk Adjustment project involved submission of claims and enrollee data to Department of Health and Human Services. Built application for payments transfer from issuers with relatively lower-risk populations to issuers with relatively higher-risk populations.

Lead Data Engineer NetApp, Sunnyvale CA (July 2010 – August 2015)

Lead enterprise business intelligence project build that involved data load from different source system into data warehouse and build reports for headcount pacing, termination trend, manager SPOC, NetApp financial review reports. Responsible for functional requirements for HR, Finance, Procure to Pay, Receivables, Sales Booking Commission Reconciliation subject areas. Built review report to compare actuals (Bookings, Billings, Backlog, Revenue and Shipments) with target numbers provided by the forecast team on a Quarterly Basis and project actuals and reconcile against project cost tracker.

Sr. Solutions Architect Elavon/US Bank, Atlanta GA (June 2009 – July 2010)

The goal was to design, develop and integrate data from multiple financial source system using ETL tool, IBM Datastage, to build GLOBAL MERCHANT SYSTEM BILLING, GLOBAL MERCHANT ADJUSTMENTS.

Solutions Engineer McKesson HEALTHCARE, San Francisco, CA (Mar 2008 – June 2009)

Responsible for delivery of multiple BI projects (EPIC Data) under Pharma BusinessTechnology Solutions (BTS). Responsible for business analyst activities, preparation of high-level design/low level design specification, data validation of GL upload and payroll procedures.

ETL Analyst CARS.COM, Chicago IL (Nov 2006 – Dec 2007)

Built future state of CAM (Cars.com Architecture Makeover) Release 1. Developed Service Oriented Architecture to inter-link CARS.COM database. Project goal was to create a master database to support listings and develop the CAM ETL infrastructure to efficiently process new listing feeds.

ETL Developer ACXIOM / WOLTERS KLUWER HEALTH, Phoenix, AZ (Mar 2006 – Oct 2006)

Responsible for legacy mainframe data conversion to OLAP system. Built Datawarehouse design for HealthCare Analytics marts such as (1) Retail Rx Mart (2) Invoice Mart (3) Claims Mart (4) Invoice & Retail Mart for delivering configurable dynamic client product deliverables

ETL Developer PACIFICARE INSURANCE, Orange County, CA (Aug 2005 – March 2006)

Responsible for analyzing, designing and developing ETL processes in PacifiCare Insurance using IBM Datastage. Analyze processes and define business requirement specifics. Developed a technical design (Rx Claims Solutions) for processing FQA (Fully Qualified Account) tagged segments.

SQL Developer Oklahoma State University, Oklahoma (Aug 2003 – Jul 2005)

Graduate assistant responsibility included database architecture; physical and logical design, creation, optimization, deriving conversion and migration methods for existing data, and developing automated conversion and migration methods.

EDUCATION:

Master of Science in Electrical & Computer Engineering (Oklahoma State University)

Bachelor of Science in Engineering (University of Madras)

Contact this candidate