Rini Jacob

Consultant

Deloitte Consulting India Pvt Ltd

Mumbai, MH

Email: adcg1o@r.postjobfree.com

Mobile: +91-974*******

Summary of Experience and Qualifications

* ***** ** ************ *******nce in IT services primarily in the field of Data warehousing and Business Intelligence.

Worked in Healthcare, Public Sector and TMT domains with Good Knowledge of SDLC and Agile methodology

Experience of implementing ETL solutions and DW modeling using Informatica PowerCenter, IBM DataStage, Oracle PL SQL

Knowledge of data visualization/reporting tools like Tableau, Cognos, QlikView.

Worked on Data Migration and Automated ingestion of data using Google Cloud Platform services – BigQuery, DataStudio, GCS and Python framework

Good analytical, presentation, communication and interpersonal skills

Deloitte Experience

Industry: TMT

Competency Area: Technology

Offering: Analytics and Cognitive

Role: GCP Developer (July 2019 till date)

Project Description: Large scale migration of data on Salesforce platform for a leading Technology giant. The scope of work included implementing a framework for migrating data from legacy Salesforce org and achieve better data quality through master data management implementation, add a new data governance function to rationalize a fragmented application architecture

Key Responsibilities:

Develop a framework to migrate data from legacy Salesforce system to new Salesforce org with improved architecture

Perform extensive analysis of the extracted data using Google Cloud Platform services like BigQuery, DataStudio and efficient storage of large volumes of data using Google cloud storage

Implemented an automation tool for end -to -end Salesforce data migration using Python framework, GCP and HTML

Thorough understanding of the Salesforce org and custom built Salesforce objects and their dependencies to generate validation scripts

Technical Environment: Google Cloud Platform - BigQuery, DataStudio, GCS, Python, HTML, Salesforce

Industry: Public Sector

Competency Area: Technology

Offering: Analytics and Cognitive

Role: ETL Developer (April 2016 till June 2019)

Project Description: Allegheny County Department of Human Services (ACDHS) is responsible for publicly-funded human services in Allegheny County, including services for older adults; mental health, child protection and services for individuals with intellectual and/or developmental disabilities. Create Data Layers for dashboard reporting on the ACDHS applications and maintaining Data Warehouse of all the Source Systems (Internal and External) using ETL migration, which contains detailed information about the clients and set of services being utilized by them.

Key Responsibilities:

Estimate, Design, Develop and Test the ETL solutions for the Datawarehouse.

Create Oracle PL SQL scripts to extract and transform the data that involved highly complex logic.

Analyze data and perform Data modeling to develop data layers for Tableau dashboards

Conduct thorough impact analysis and identify the impacts of existing modules

Performance tuning of SQL, DataStage jobs

Technical Environment: Oracle PL SQL, IBM DataStage, Tableau

Previous Experience

Industry: Healthcare

Role: BI Developer (Oct 2013 till March 2016)

Igate Global Solutions Pvt Ltd., Bangalore

Project Description: Leading US Healthcare company serving number of customers around the globe. The Purpose of this project is to extract transaction data (Orders, Sales & Backlog) of Client Healthcare system from multiple sources, map key measures and dimensions in a consistent fashion and present to leaders in a flexible, simple front-end reporting. This involves complex calculations of amounts, quantities and revenue recognition during the lifecycle of a transaction

Key Responsibilities:

Involved in the design and development of the data models, business rules and data mapping for the Enterprise Data Warehouse system.

Worked on enhancing the existing module based on additional user requirements after thorough impact analysis.

Generate Informatica mappings, Teradata bteq scripts to implement the ETL solutions

Implemented CDC (change data capture) for maintaining the history data.

Generated test cases and test plans for ensuring high quality of data

Technical Environment: Teradata, Informatica Powercentre, Cognos

System Experience

Software / Products:

Informatica PowerCenter; Proficiency: Advanced

IBM DataStage; Proficiency: Advanced

Google Cloud Platform; Proficiency: Intermediate

Tableau; Proficiency: Intermediate

Development Tools / Languages:

Oracle PL SQL; Proficiency: Advanced

Unix Scripting; Proficieny: Intermediate

Python; Proficiency: Intermediate

Middleware / Databases:

Oracle; Proficiency: Advanced

Teradata; Proficiency: Intermediate

General Tools:

Microsoft Excel, Microsoft Word, Microsoft Power Point, Notepad++, Visio, Google Suite

Education

Bachelor of Engineering (Computer Science)

Mumbai University, India, 2009-2013

Contact this candidate