Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Elavarasu Ramasamy

Mira Loma

Summary

Director of Data Analytics at Alignment Healthcare with expertise in cloud solution architecture and data transformation. Demonstrated success in ETL processes and data strategy, enhancing clinical quality and compliance through cross-functional collaboration. Proficient in Power BI and team leadership, delivering insights that improve operational efficiency and support value-based care initiatives.

Overview

20
20
years of professional experience

Work History

Director of Data Engineering

Alignment Healthcare
Orange
07.2018 - Current
  • Forged engagement partnerships with business leaders and CXOs to drive data transformation initiatives.
  • Developed and executed enterprise-wide data strategy, cloud migration roadmap, and data architecture.
  • Architected and redesigned analytics platforms across AWS and Azure, utilizing Snowflake and APIs.
  • Created conceptual, logical, and physical data models ensuring scalability and compliance with business objectives.
  • Led IaaS/PaaS solution architecture in AWS and Azure, integrating modern systems with legacy infrastructure.
  • Implemented ADF pipelines and ETL/ELT solutions for efficient data ingestion processes.
  • Integrated diverse structured and unstructured data sources, enhancing analytics capabilities.
  • Delivered insights through Power BI reports, enabling self-service analytics and standardized KPIs.

Solutions Architect

The MasterLock Company
Milwaukee
11.2017 - 06.2018
  • Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time
  • Architect and adapts ETL processes to accommodate changes in source systems and new business user requirements.
  • Involved in estimation, requirement discussions and requirement base lining.
  • Involved Code review & Unit Test Plan.
  • Design and develop the technical/functional specification for ETL development and implement using ODI.
  • Responsible for managing the Development, maintenance and support to achieved the highest level of customer (end user) acceptance and satisfaction within Service Level Agreements (SLA).
  • Manage a team that provides system support to business partners, the customer service group and the data warehouse group.
  • Managing different versions of releases made, controlling the changes imposed, and auditing and reporting on the changes made.
  • Coordinate and guide the offshore team

Solutions Architect

BMO Harris Bank
Chicago
09.2016 - 10.2017
  • Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Develop solution in highly demanding environment and provide hands on guidance to other team members.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat Files, Excel, XML files into Data warehouse database
  • Developed, deployed, and monitored SSIS Packages.
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008/2012.
  • Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
  • Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Conduct impact assessment and determine size of effort based on requirements.
  • Assist and verify design of solution and production of all design phase deliverables.
  • Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.
  • Resolve difficult design and develop issues.
  • Identify bugs when developers are not able to do so.
  • Lead in designing, specifying and selecting information system solutions, considering functionality, data, security, integration, infrastructure and performance
  • Estimate cost, and prepare business cases for IT solutions, considering infrastructure, licenses, development and support
  • Work with the Project Managers and Business Analysts to develop high level project schedule resource plans for implementation projects.

Sr. Developer

Northwestern Mutual
Milwaukee
01.2016 - 09.2016
  • Gathered user requirements. Responsible for Analysis and implementation for DB changes requested by users. Developing reports using efficient data retrieval techniques
  • Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
  • Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
  • Created SSIS package for File Transfer from the client location to the server using FTP task.
  • Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. .
  • Wrote queries for drill down reports to get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports using Global variables and expressions. Deployed generated reports onto the Report Server to access it through browser.
  • Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
  • Involved to convert existing BO reports into tableau dashboards using tableau 8.2
  • Support Activities to document, evolve, and communicate artifacts developed using Tableau
  • Involved in performance tuning of TSQL queries and Stored Procedures.
  • Optimized query performance by creating indexes.
  • Provided the knowledge transfer to the MSBI supporting team
  • This Project has developed using agile methodology and involved in various phase of agile such as daily scrum, Sprint goal, sprint review etc.

Sr. Developer

Anthem
Virginia Beach
10.2014 - 01.2016
  • Develop the stored Procedures and SSIS Packages as per the requirement
  • Test the procedures and packages in the local environments.
  • Involved Code review & Unit Test Plan
  • Involved the performance tuning for the developed Stored Procedures
  • This Project has developed using agile methodology and involved in various phase of agile such as daily scrum, Sprint goal, sprint review etc.

Sr. Developer

MedData
Seattle
10.2013 - 09.2014
  • Develop the report based on the specifications given by the business customers
  • Create the stored procedures which will be used to develop the SSRS reports
  • Analysis of Report requirements
  • Test the reports in the local environments.
  • Involved the performance for the developed Stored Procedures

Sr. Informatica Developer

McKesson Specialty Health
Scottsdale
01.2013 - 10.2013
  • Responsible for managing the Development, maintenance and support to achieved the highest level of customer (end user) acceptance and satisfaction within Service Level Agreements (SLA).
  • Managed stakeholders through effectively communicating project plans, progress, expectations, assumptions and dependencies in a timely and clear fashion throughout the project.
  • Involved in UAT and helped business users to test the solution before implementation.
  • Pear review of the reports and mappings developed and tested by the team to confirm with standards

SSIS/SSRS Developer

Aetna
Hartford
01.2011 - 12.2012
  • Develop the SSIS packages for extracting the data from Data warehouse to Provider portal database.
  • Create stored procedures and functions which will be used to load the data into Provider portal for delta load
  • Create stored procedures and functions which will be used to load the data into Online Enrollment for delta load
  • Analysis of Report requirements
  • Involved in Report Development.
  • Test the reports in the local and infoview environments.
  • Involved the performance tuning of the ETL packages and Stored

Education

Master of Computer Applications -

SRM University
India

Bachelor in Computer Technology -

Periyar University
India

Skills

  • Change management
  • Technology strategy
  • Budget management
  • Agile methodologies
  • Cybersecurity expertise
  • Risk management
  • Vendor management
  • Microservices architecture
  • and analytics
  • CI/CD practices
  • HEDIS and CMS metrics mastery
  • Risk adjustment analytics
  • Value-based care insights
  • Claims data expertise
  • Regulatory compliance reporting
  • Interdisciplinary collaboration
  • Advanced analytics tools proficiency
  • HIPAA compliance and governance
  • ETL development
  • Database administration
  • Business intelligence
  • Data warehousing
  • Data migration
  • API Development and intergration

Timeline

Director of Data Engineering

Alignment Healthcare
07.2018 - Current

Solutions Architect

The MasterLock Company
11.2017 - 06.2018

Solutions Architect

BMO Harris Bank
09.2016 - 10.2017

Sr. Developer

Northwestern Mutual
01.2016 - 09.2016

Sr. Developer

Anthem
10.2014 - 01.2016

Sr. Developer

MedData
10.2013 - 09.2014

Sr. Informatica Developer

McKesson Specialty Health
01.2013 - 10.2013

SSIS/SSRS Developer

Aetna
01.2011 - 12.2012

Master of Computer Applications -

SRM University

Bachelor in Computer Technology -

Periyar University
Elavarasu Ramasamy