Sashidharan Ravichandran

http://linkedin.com/in/sashidharan-ravichandran-8883a0218

Email: ad3u45@r.postjobfree.com

Phone:201-***-****

Certification ID: H865-4560

OBJECTIVE

A highly skilled Data Engineer with 9+ years of expertise, seeking a challenging position to leverage my skills in database design, optimization, and management to contribute to the success of a dynamic organization.

EDUCATION

Fairleigh Dickinson University, New Jersey Dec 2014

Master of Science in Electrical Engineering GPA (3.6/4.0)

Anna University, India April 2012

Bachelor of Electrical Engineering GPA (3.7/4.0)

TECHNICAL DETAILS

Skilled IT professional in data design and development on Azure, Microsoft SQL Server.

Experience in designing Azure Data Factory pipelines to integrate data from various sources.

Designed, developed, and implemented ETL design for incremental analytical data loads for the Enterprise data warehouse solution.

Expertise in handling and interpreting healthcare data such as Member Eligibility, Claims, CCDs, HRAs and ADT, ensuring data accuracy and integrity.

Proficient in orchestrating outbound extracts processes for eligibility, claims, clinical, and prior authorization data.

Applied advanced SQL queries and Python scripts within Azure Databricks to efficiently clean, filter, and manipulate raw data, ensuring it meets quality and format standards.

Expertise in creating several reports such as drill down reports, parameterized reports, linked reports, Charts, sub reports using SSRS and PowerBI.

Designed and developed complex Spark applications, leveraging DataFrames, and Spark SQL for efficient data manipulation and analysis.

Experience in migrating Snaplogic pipelines to cost effective solutions using SSIS and Azure Services.

Experience in Continuous Integration and Continuous deployment (CI/CD) process using Github, Git.

TECHNICAL SKILLS

SQL Server Tools

Azure Data Studio, SSMS, SSIS, SSRS

Database

Azure SQL Database, MS SQL Server.

ETL Tools

Azure Data Factory, Azure Databricks, SSIS

Analysis Engine

Apache Spark

Reporting Tools

PowerBI, SSRS

Language

T-SQL, Basic Python and VB .NET

Tools

Orion Rhapsody, Microsoft Visual Studio, Snaplogic, QTP, HP ALM

WORK EXPERIENCE

EMPLOYER: EVOLENT HEALTH

Arlington, VA

ROLE: Senior Database/Business Intelligence Engineer Jan 2018 – till date

Description:

Evolent is focused on the prevention of future illness and how to improve the efficiency of health systems. Through their technology platform, Identifi, data analytics enable physicians to identify high risk individuals and create targeted interventions personalized to that individual.

Skills and Responsibilities:

Developed metadata configuration driven Azure Data Factory pipelines to handle multiple data sources.

Implemented stored procedures to efficiently transform raw data into a standardized format, enhancing data quality and consistency across the organization.

Implemented a process to orchestrate outbound extracts processes for eligibility, claims, clinical, and prior authorization data.

Developed and executed scheduled jobs in Azure Databricks for automated data transformation, reducing manual intervention and improving overall efficiency.

Innovatively implemented a delta sensing process to optimize data processing efficiency for clients sending full files, reducing both processing time and database storage space.

Built PowerBI reports to unit test with a large volume of clinical and admin data.

Proactively developed use cases for stakeholders and built dashboards in PowerBI to provide them with insights about various kinds of valuable business data.

Worked extensively in handling Health Risk Assessments (HRAs) and CCDs to gather crucial patient health information.

Built processes to handle Admission, Discharge, and Transfer (ADT) data for maintaining comprehensive and up-to-date patient records.

Maintained reference data for pharmacy claims operations by integrating and updating information from Optum, MediSpan, and RxNorm sources, ensuring accuracy and relevance.

Successful migration of legacy SSIS packages to configuration-driven models for enhanced performance and scalability.

Designed ORION to orchestrate flow by designing a framework calling SSIS packages and Stored Procedures.

Tools and Environment: Azure Data Factory, Azure SQL Data Studio, Azure Databricks, PowerBI, Orion Rhapsody 5/6, MS SQL Server 2016/2022, SQL Server Data Tools 2012, TFS 2013.

CLIENT: Evolent Health

Arlington, VA

ROLE: SQL Server Developer Jan 2016 – Jan 2018

Skills and Responsibilities:

Developed and designed ETL processes to onboard various input data sources coming from different vendors.

Extensively worked on creating and optimizing stored procedures for transforming data into standardized company formats.

Experienced in performance tuning and troubleshooting of ETL processes for efficient and reliable data flow.

Extensively worked on onboarding Admin and Clinical Data that includes Eligibility, Medical/RX, ADT data.

Designed and implemented logging systems for tracking data loads from multiple clients.

Successfully orchestrated the outbound extracts process, extracting critical data elements such as eligibility information, claims, and lab data.

Proactively identified and implemented process improvements, resulting in increased efficiency and reduced turnaround times for outbound extracts.

Developed and implemented a process for the efficient onboarding of ICD-10 codes and CPT/HCPCS codes, ensuring compliance with industry standards and organizational requirements.

Implemented data validation checks before data is loaded into fact tables, ensuring the integrity and accuracy of critical business information.

Created complex SSIS packages using Script task that reads the file and performs data validation before loading.

Proactively improved problem-solving and continuous improvement mindset in addressing and rectifying data quality issues.

Collaborated with cross-functional teams to understand and meet data processing requirements.

Tools and Environment: Rhapsody 5/6, MS SQL Server 2012/2014, SQL Server Data Tools 2012, TFS 2013.

CLIENT: FEPOC

Washington, DC

ROLE: SQL Server Developer Mar 2015 – Dec 2015

Description:

FEPOC manages the national claims processing system for the Blue Cross Blue Shield (BCBS) Federal employee program. The environment requires BIA update annually. The scope of the project was to optimize performance measurement to stay on track using SSRS and to validate benefit information responses received from clients.

Skills and Responsibilities:

Involved in benefit configuration projects like 270/271 to provide enrollment information to the clients.

Created stored procedures to validate X12 Transactions using SQL Server 2014.

Created data driven HTML report using SQL Server Agent Job and scheduled to deliver via email.

Involved in Agile projects to provide daily user stories and blocked reasons for all sprints in the release.

Created a data driven report which provides defects raised by testers for the release using stored procedures and scheduled it daily.

Created SQL Server Reports using SSRS 2014 for the team to track every project in the release in real time and deployed into Microsoft SharePoint 2013.

Created parameterized reports for the users and clients based on their requirements.

Deployed the developed reports with sub-reports and drill through reports that gives real time project status for the release.

Generated tester workload reports which calculate tester’s performance and provides required days to complete the project on time.

Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.

Created reports in SSRS with different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.

Created complex Stored Procedures, Functions, Triggers, Tables, Indexes, Views, SQL joins and T-SQL Queries to test and implement business rules.

Designed and created views for security purposes, implemented rules, defaults, and user defined data types.

Designed and implemented data access stored procedures and triggers for automating tasks.

Designed index, statistics, and optimized queries by using execution plan for performance tuning of the database.

Tools and Environment: MS SQL Server 2012/2008, SQL Server Business Intelligence studio 2012/2008 (SSRS/SSIS)

Contact this candidate