Saravanan Sankar

Saravanan Sankar Email and Phone Number

Cloud Data Architect @ Aetna, a CVS Health Company
Saravanan Sankar's Location
Fort Mill, South Carolina, United States, United States
Saravanan Sankar's Contact Details

Saravanan Sankar personal email

About Saravanan Sankar

Saravanan has Over 13 years of professional experience architecting and supporting the development and deployment of an Enterprise Data Lake and Datawarehouse Systems (Both Reengineering & Replatforming).- Extensive experience in Data Modeling, Information Architecture, Data Engineering, Analysis, Data Discovery, Data Profiling, Enterprise Architecture and Solution designs of OLTP and OLAP systems.- Extensive Domain knowledge on Banking, Finance & Insurance sectors.- Translate business and data requirements into data models in support of Enterprise Industry Standard Data Models (IBM Unified Data Model for HealthCare, IBM BDW).- Demonstrable experience in developing, validating, publishing, maintaining conceptual/ logical/physical data models for traditional RDBMS as well as Hadoop/Hive/BigQuery/Snowflake based implementation.- Demonstrable experience using data modeling tools - e.g., IBM InfoSphere Data Architect, ERwin.- Proficient in data mart design and creation of cubes, identifying Facts and Dimensions, concepts and methodologies like Kimball/Inmon, Star/Snowflake Schema, DataVault, SCD types, Normalization/De-Normalization and Surrogate keys.- Experience with managing meta data E.g., IBM Asset Manager/Information Governance Catalog.- Expert in metadata modeling for Data lineage & Traceability, Control/Balances and Data Quality.- Hands on Experience building data pipelines using Cloud Computing & Big Data Technologies like Databricks/Spark & Hadoop Ecosystems.- Extensive Database skills using SQL to create/maintain database objects (Tables/Views), writing/tuning complex SQL queries used in ETL process, subscription reports and support Ad-hoc business requests.- Depth experience in development methodologies such as SDLC, AGILE, SCRUM and Waterfall.- Hands on experience on Unified Data Analytics with Databricks, Databricks Workspace User Interface, Managing Databricks Notebooks, Delta Lake with Python, Delta Lake with Spark SQL.

Saravanan Sankar's Current Company Details
Aetna, a CVS Health Company

Aetna, A Cvs Health Company

View
Cloud Data Architect
Saravanan Sankar Work Experience Details
  • Aetna, A Cvs Health Company
    Senior Data Architect
    Aetna, A Cvs Health Company Aug 2022 - Present
    Hartford, Connecticut, Us
    Working on providing data solutions for Enterprise Health Insights Platform, digital architecture space, migrating on-prem systems using traditional databases (Posgres/Oracle) to GCP (Google Cloud) technologies such as Cloud SQL/AlloyDB, Data flow & BigQuery.
    View
  • Aetna, A Cvs Health Company
    Senior Data Engineer
    Aetna, A Cvs Health Company Sep 2017 - Aug 2022
    Hartford, Connecticut, Us
    • Worked on one of the world’s largest health care enterprise-wide data warehouse which is subject oriented that integrates data from almost every Aetna transactional system, such as: enrollment, medical and pharmacy claim, encounter, provider, product and utilization management. This allows for consistent reporting and analysis.• Developed strategic oversight and planning of logical and physical data models with traceability and databases design within the Hadoop platform using IDA for Re-platforming and Re-engineering existing EDW and various source systems into Data Lake with Multi-layer Architecture.• Lead Consumer Consumption Team, designed and developed a generic framework that produces 30+ published extracts to support downstream application needs.• Worked with key stakeholders to understand the data requirements and translates strategic requirements into usable enterprise information architecture.• Created flattened data models leveraging Big Data Horizontal storage in Hive for high ETL performance including complex data structures (ARRAY, STRUCT), ORC file format for storage layer. Provided ETL solution designs for Data Ingestion, Lookups, Data mapping by working closely with Business Analysts, Developers, Enterprise Architects and Solution Architects.• Conducted complex ETL data migrations to include assessing, planning, implementation, software development and data validation by closely working with ETL developers and providing support for BigIntegrate ETL issues and guiding in performance tuning.• Developing data and metadata policies and procedures to build maintain and leverage data models, ensuring compliance with corporate data standards using IBM InfoSphere Information Tools - IMAM/IGC/IA/FastTrack and Analyze change requests for mapping of multiple source systems for understanding of Enterprise wide information architecture to devise Technical Solutions.
    View
  • Infosys
    Technology Lead
    Infosys Oct 2014 - Sep 2017
    Bangalore, Karnataka, In
    Around 4 Years of professional experience in Data Modeling, Data Analysis, Data Architect and design of OLTP and OLAP systems.Worked on an enterprise-wide data warehouse in for Fortune 500 Bank which host Contracts, Positions and Balances and associated reference data for use across Finance, Risk and Compliance and act as a single source of truth for various reporting needs like Basel, Liquidity management, regulatory disclosures etc• Map and Gap analysis with multiple client teams and create Data Model (Logical & Physical)• Attend the data mapping sessions and drive the issues to resolution• Validate the data mappings and the data model changes.• Investigating data reconciliation and data processing issues• Data Management of the metadata
    View
  • Infosys
    Technology Analyst
    Infosys Oct 2013 - Oct 2014
    Bangalore, Karnataka, In
    Around 4 Years of professional experience in Data Modeling, Data Analysis, Data Architect and design of OLTP and OLAP systems.Worked on an enterprise-wide data warehouse in for Fortune 500 Bank which host Contracts, Positions and Balances and associated reference data for use across Finance, Risk and Compliance and act as a single source of truth for various reporting needs like Basel, Liquidity management, regulatory disclosures etc• Map and Gap analysis with multiple client teams and create Data Model (Logical & Physical)• Attend the data mapping sessions and drive the issues to resolution• Validate the data mappings and the data model changes.• Investigating data reconciliation and data processing issues• Data Management of the metadata
    View
  • Mastek Ltd
    Senior Software Engineer
    Mastek Ltd Apr 2011 - Oct 2013
    Reading, Gb
    • Worked on an enterprise-wide transaction system for Insurance companies which host personal automobile and homeowners' insurance solutions for UK & USA clients. The products sell through brokers accessing POS, underwriting policy, billing, post claims and used for generating various State regulatory reports.• Developed normalized Logical and Physical database models to design OLTP system for insurance applications. Created dimensional model for reporting system by identifying required dimensions and facts using Erwin (forward engineering & reverse engineering).• Conducted team meetings and Joint Application Design (JAD) sessions. Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems and developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects.• Performed Data validation, Data cleansing, Data integrity, Data Quality checking before delivering data to operations, Business, Financial analyst by using Oracle, Teradata.• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT) and applied data naming standards, created the data dictionary and documented data model translation decisions and maintained DW metadata and naming standards.• Intensive data mining practice for data manipulation/extraction in Teradata environment for data integration and created data rules to handle SCD Type II data using PLSQL.
    View
  • Mastek Ltd
    Software Engineer
    Mastek Ltd Apr 2010 - Apr 2011
    Reading, Gb
    Worked on an enterprise-wide transaction system for Insurance companies which host personal automobile and homeowners' insurance solutions for UK & USA clients. The products sell through brokers accessing POS, underwriting policy, billing, post claims and used for generating various State regulatory reports.• Developed normalized Logical and Physical database models to design OLTP system for insurance applications. Created dimensional model for reporting system by identifying required dimensions and facts using Erwin (forward engineering & reverse engineering).• Conducted team meetings and Joint Application Design (JAD) sessions. Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems and developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects.• Performed Data validation, Data cleansing, Data integrity, Data Quality checking before delivering data to operations, Business, Financial analyst by using Oracle, Teradata.• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT) and applied data naming standards, created the data dictionary and documented data model translation decisions and maintained DW metadata and naming standards.• Intensive data mining practice for data manipulation/extraction in Teradata environment for data integration and created data rules to handle SCD Type II data using PLSQL.
    View

Saravanan Sankar Skills

Thailand Audio Conferencing Insurance Oracle Database Mentoring Convert Merchant Banking Utilities United Kingdom Production Environment Toad For Oracle Self Driven Singapore Batch Processing Database Triggers Databases Florida Requirements Gathering Design Ocean Line Of Business Casualty Insurance Auditing Sap Ps Teradata Source Requirements Analysis Factoring Linux Execution Qualification Oracle Reports Low Level Design Datastage High Level Design Load Bangalore Team Management Layout Validation Asia Uml Reports Red Hat Linux Life Insurance Visual Basic Snapshot User Acceptance Testing Data Modeling Enterprise Architecture Property Testing Asset Management Pl/sql Vss Unix Shell Scripting Policy Sla Code Review Extract Mumbai Solution Scripting Oracle Report Builder Documentation Product Development Quality Control Reporting Venture Capital Loans Analysis Oracle Pl/sql Development Written London Document Review Auto Etl Sql Loader Yahoo C Production Support Tamil Applications Data Analysis Configuration Management Communication Quality Assurance Html Putty Oracle Sql Developer Queries Bangkok Business Intelligence Project Sql Automobile House Ssrs Information Architecture Unix Brokers Passport Change Requests Pdf Responsibility Leasing Banking Data Warehousing Subversion Code Renaissance Root Cause Analysis Unit Testing Trust New York Business Rules Defects Plot Data Analytics Elixir Software Oracle Chennai Filezilla Java Stocks Discount Trustee Rational Xde Quick Turnaround Software Development Health Insurance Superiors Transform Deliveries Technical Aspects

Saravanan Sankar Education Details

  • Southern New Hampshire University
    Southern New Hampshire University
    Data Analytics
  • Georgia Institute Of Technology
    Georgia Institute Of Technology
    Analytics
  • Ifet College Of Engineering, Anna University
    Ifet College Of Engineering, Anna University
    Information Technology
  • Thiru Kamaraj Mun. Hr Sec School
    Thiru Kamaraj Mun. Hr Sec School
    General

Frequently Asked Questions about Saravanan Sankar

What company does Saravanan Sankar work for?

Saravanan Sankar works for Aetna, A Cvs Health Company

What is Saravanan Sankar's role at the current company?

Saravanan Sankar's current role is Cloud Data Architect.

What is Saravanan Sankar's email address?

Saravanan Sankar's email address is sa****@****hoo.com

What schools did Saravanan Sankar attend?

Saravanan Sankar attended Southern New Hampshire University, Georgia Institute Of Technology, Ifet College Of Engineering, Anna University, Thiru Kamaraj Mun. Hr Sec School.

What skills is Saravanan Sankar known for?

Saravanan Sankar has skills like Thailand, Audio Conferencing, Insurance, Oracle Database, Mentoring, Convert, Merchant Banking, Utilities, United Kingdom, Production Environment, Toad For Oracle, Self Driven.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.