Delivering continous data using cloud data lake platform. Data as a service profile created using snowflake & Oracle integration. Tasks created in snowflake to perform the data transformation (T in ELT).

New design and architecture created for Datawarehouse schema terminology (Snowflake schema) to get the maximum performance of datawarehouse platform. Integrating a application to access the always available data from snowflake.

Oraganization's matrix dashboard to analyse and understand the organization's performance on each key matrix. KPI we created was individual KPI for each dashboard including diversity, attrition, headcount etc.   

ETL created to take Payroll HR data from Microsoft Dynamics and push it to Salesforce. First i created Crystal Reports and then SSRS in Salesforce platform. Later we converted the reports to Salesforce views. Full lifecycle involvement to get the data, transform it to get business values and creating reports using crystal report/SSRS.

Health Care Data comes in different ways including HL7 feeds and XML transcript. We built the ETLs to handle live feeds, Row data and Transcript to transform in business value data. We written ETLs, SQL Procedures to handle the data issues, data cleansing.