Data Engineer

*

Summary

* ***** ** ******** *********** experience across various domains.

3+ years of lead experience at both offshore and onsite.

7+ years of Insurance domain experience including Risk Management.

7+ years of experience in PL/SQL and MSBI Suite.

5+ years of experience with both Agile and SDLC development process.

5+ years of experience in Data Modeling using SSAS.

5+ years of experience in Salesforce Cloud Model.

Thorough knowledge in the ETL, Reporting, Data Analysis,QA, Business Process, Implementation Methodologies, Project Life Cycle Management and Documentation Standards.

Experience in building high-volume Data Warehouse and Data Marts.

Experience in both Development and Support of processes.

Experience in developing products from scratch and working on the entire lifecycle. Skills

PL/SQL Salesforce Methodologies:

SSMS – 2005,2008,2012 Visual Cron Waterfall

SSRS – 2005,2008 R2 & 2012

C# .NET

Cognos – Query Studio

SSAS – 2005 & 2008

SSIS – 2005,2008, 2012

Cognos - Report Studio

Agile

Accolades

Technical Appreciation

Award (Riskonnect Inc.)

Outstanding Team

Contributor Award

(Riskonnect Inc.)

Pat on the Back Award.

(Cognizant Technology

Solutions)

Outstanding Performer for the

Year 2015-2016.

(Riskonnect Inc.)

Shining Star Award.

(Riskonnect Inc.)

Certifications:

External Certification on Oracle

Database SQL

Expert (IZ0-047) provided by NIIT India

Salesforce Certification By Riskonnect

Data Warehousing CCP provided by Cognizant General Insurance CCP provided by Cognizant Education

Bachelor of Technology (Electronics & Communication Engineering), Anna University, India

2004 – 2008.

CGPA: 7.9

2

Work Experience

Senior Data Engineer/Team Lead - Riskonnect Inc. Atlanta, GA July 2012 – Feb 2018

Extract from the ftp, transform as per the requirement and Load huge volumes of Insurance Data into the Salesforce Cloud Model.

Designed and built cloud infrastructure for the project

Write SQL queries, cursors and stored procedures to Extract, Transform and Load data.

Perform Data Analysis and Data Modeling for the Insurance Data to be loaded.

Identify inefficiencies in the process & build automated Out Of the Box Solutions to gain efficiency.

Provide training to the onsite and off shore teams, & create training documentations

Automate processes using Visual cron tool and create best practices documents.

Anchored various critical projects to successful completion on time. Data Analyst & Programmer - Cognizant Technology Solutions Chennai, India Mar 2009 – Mar 2012

Get on calls with the client to understand the data model and requirement.

Analyze the data and perform data modeling using SSAS.

Design Data in both star schema and snow flake schema.

Designed and developed SSIS packages to perform ETL of data.

Designed and developed SSRS reports to present the data.

Create SharePoint sites and integrate the reports into it.

Work on Data Mining Analysis as per the requirement. Cognos Report Developer – Changepond Technologies Chennai, India July 2008 – Feb 2009

Understand the Banking data model.

Create Cognos Reports of the same using Cognos – Query Studio & Report Studio.

Code reviews on defect fixes.

Contact this candidate