Page * of *

Ajay Jeyendran Ravichandran H*B cap exempt Email : adkji5@r.postjobfree.com

India Mobile :+91-807*******/948-***-****

Current Company: Absolutdata Research & Analytics solution (12-08-2022) Past :

EY (09-05-2022 to 10-08-2022)

JLL (01-06-2021 to 03-05-2022)

CTS (01-07-2011 to 31-05-2021)

Professional Summary:

• Overall 12 years of experience in data centric implementations for the domains - Healthcare, Telecom, Insurance, Asset and wealth management, Pharmacy & life science, Media & and entertainment,Retail,Finance.

• Follows best practices implementations.Worked for Fortune 500 clients such as Walt Disney, Disney theme parks and resorts, Everything Everywhere,Healthcare -Walgreens, BCBSMN

,Cigna,BSCA, Life science & pharmaceutical – Astellas : IQVIA,IPSOS,RP data and other vendors & JLL(Wealth & Investment),EY Audit partners.

• Worked in various implementation methodologies:

o Agile methodologies., Devops CI CD.Having good knowledge of SDLC,STLC

,Defect life cycle.Have worked with jira, Azure devops, Rally. o Having experiences in devops CI CD – Jenkins, bitbucket and familiar of docker

, ansible, kubernetes and production monitoring.

• Experiance in various testing methodologies & QA o Have involved in Functional testing, System integration testing, User acceptance testing

,Regression testing & Automations

o Involved in Automation of testing using unix, datagaps, Informatica DVO.Involved in customizing through pyspark,python.

o Involved in UAT for migration from microstrategy to Power bi for EY audit partner to ensure the migration is success and sign off.

o Identified and resolved issues related to Data quality, ETL/BI/Dashboard’s code implementation issues,business requirement gaps, functional issues, long running jobs, performance issues.

• Handled multiple data migrations projects

o Involved in On-premise to cloud.Validated structured and unstructured data, APIs, Streaming kafka data.

o Involved in migrating qlikview dashboards to GCP looker. Validated front end layout,dashboards and database

o Worked in migration from Netezza to Azure replatforming. o Well versed with writing SQL or stored procedure or implementing it in pipelines for automation frameworks.

Page 2 of 4

• Have worked on GCP

o Data engineering and looker LookML models, explore, looks, and dashboards. Implement persistent derived tables,multiple filters ( drop down filter, hierarcy, radio button,multi selection), Performance optimizations, caching policies, version control, and assess code quality.

o Have converted excel dashboard to looker dashboard.Worked with etl team for some of the use case to store and aggregate at snowflake level with most of the calculations at database side.

o Having good knowledge of GCP services – storage, bigquery,airflow

,dataflow,dataproc,datalab,dataprep,pub/sub,cloud sql.

• Having experience in Cloud services

o Azure services - Azure data lake, Azure data factory, databricks, Sparksql, Python, SQL

o Having experiences in AWS services – S3, redshift with hands on knowledge of glue jobs, Athena for data analysis,knowledge of lambda (event driven

).Exposure to Airflow and python.

o Having experiences in Snowflake – snowpipe,stored procedures,task, streams,snowsql,warehouse sizing.

• Experience in solutioning and documentation:

o Involved in the RFPs, Solutions, design document preparations, Source target mapping document, Visio models, RTM, test plan, test strategy, test scenarios, test cases, test executions, sending daily, weekly and monthly reports, Managing the clarification, defect tracker and testing and UAT sign off. Certifications Achievements

• Certified in ETL and BI

• Certified in ETL Informatica power

center

• Certified in IBM Cognos 10 BI

dashboard Author

• Certified in AWS Cloud Foundations

• Snowflake’s partner - SnowPro

Training certificate

• Certified in Building reports in

Google Looker

• Databricks’s partner – Data

engineering with databricks

• JLL Super Star Award 2021

• Lasalle’s Shinning Star Award 2021

• Cognizant Coral Award 2021: Doing the right thing, the right way

• Tibco Spotfire,Microstrategy,Business Objects,Reltio Master Data Management(MDM) Course completion

certification from Cognizant Academy

• Certified in Product manager,Agile Scrum,Life sciences Regulations & Standards, Healthcare AHM 250 from

Cognizant Academy. Independence policy from EY.

TECHNICAL SKILLS

Database : Oracle 9i,10g, Teradata 13.0, Netezza 6.0, MySQL, DB2

ETL : Informatica 9.5, Abinitio, Talend 7 Bigdata, PLSQL, SSIS(training)

ELT : Wherescape Red 6.7.5.0, Matillion

Cloud : AWS,Snowflake,GCP,Azure

Page 3 of 4

MDM : IBM Infosphere

BI : IBM Cognos 10,SSRS,Google’s Looker,Tibco Spotfire, Power BI

Streaming data : Kafka

Data Virtualization : Tibco Composite 6.2, Denodo 8

Analytical tools : SAS, Python, R, Pyspark

API Testing : Soap UI,Postman

Web Automation Testing : Selenimum with Python, Robot framework (Self study Exposure)

ETL Automation Testing tool : Informatica DVO, Queryserge,Presto, Datagaps

Agile : Confluence, Rally, Azure Devops, Jira, HP ALM REPRESENTATIVE PROJECT EXPERIENCE SUMMARY

Client

Domain

Technology

Roles and Responsibilities

Duration(in

Months)

NCR Insurance Azure data

factory,Azure

synapse,Teradata

Involved in Teradata to azure migration

history loads.

Have worked with adf,Teradata,stored

procedures.

Involved in data quality checks, ETL

validations.

4

Prudential

Singapore

Insurance Azure synapse,

databricks,

ADF,stored

procedures

Involved in netezza to azure migrations.

Have worked on data bricks, python,

pyspark,stored procedures.

Have worked on etl validations.

8

Friesland

Campina

Netherland –

EY Partner

Insurance Azure,ADF,Datab

ricks,Azuresql,Az

ure SQL,Power

BI,Azure devops

-Implemented UAT strategy from scratch

and completed the given module

successfully on time.

–Involved in manual testing,database and

dashboards,Integration testing.

3.5

Lasalle Wealth &

Finance

Talend,GCP,Sno

wflake,Liferay,Re

alpage,Yardi,Look

er,Automation tool

–

Datagaps,(Python

,Pyspark for

customizations)

- End to end snowflake logic implmentations

–Involved in manual testing,database and

dashboards,Integration testing.

-Validation of both etl and dashboard and

front end application integrations, API

integrations.

- Take part in UAT with BA.

11

Page 4 of 4

Client

Domain

Technology

Roles and Responsibilities

Duration(in

Months)

Astellas Life

Science

and

Pharmacy,

Clinical

trials

AWS,Talend,

Glue, Athena,

redshift, lambda

-Involved in AWS implementations.

-Worked with talend tool

-Involved in unit testing and writing SQL

statement.

-Have worked in product support mode.

12

Blue Shield

of California

Healthcare Informatica,

Netezza, Oracle,

Winscp,Putty,Coll

ab,ALM,AWS

Redshift

Worked on understanding the data model

and verifies data is as per the requirement

given by the business analyst. 8

Cigna Healthcare Soal UI, Rally,

HP ALM, Oracle,

Teradata,

Obiee,IBM MDM,

datastage,Seleniu

m,Confluence,

Kafka,Test

Automation

Master data Management to get golden copy

trusted data and 360 view of the members.

Involved in data quality.

29

Blue Cross

Blue Shied of

Minnesota

Healthcare SAS, Teradata

V14,Wherescape

Red

Business Analyst & SAS statistical model

development 16

Walgreens

Healthcare

Cognos,Tibco

Composite(Data

Virtualization),Spo

tfire,denodo

Business Analyst &

BI Development and Enhancement

24

EE

(Everything

Everywhere)

Telecommu

nication UK

Unix, Netezza,

Abinitio

ETL Technical production Support Analyst

12

The Walt

Disney

(Theme

Parks and

Resorts)

Media and

Enterainme

nt

Informatica

Powercenter,

Informatica

Powerexchange,I

nformatica DVO,

MS Visio, Oracle

10g,Teradata

13.0, Shell

scripting

Business Analyst & ETL Development and

support

7

The Walt

Disney

Media and

Enterainme

nt

Cognos, Oracle

9i

Admin and BI Support

5

Contact this candidate