Sign in

Data Engineer

Milpitas, CA
February 18, 2020

Contact this candidate


Shivani Bhat

**** *. **** ******, ********

California - 95035


Mob: 408-***-****

Experience Summary

Technically proficient, Confident and Experienced Data Warehousing professional with 10 years working experience in large complex BFSI customer projects.

Team Lead - Managed requirement gathering, Development, Testing and Delivery. Managed ETL Team, groomed new joiners and mentored team members.

Technical Project Manager – Managed 10+ person team for Development lifecycle. Experienced in Data Warehousing, Data Modeling, Data analytics and Data Architecture

Communication and leadership experience – Managed cross functional teams from multiple geographical locations

Passionate about learning new Technologies and implementing them.

Post-Graduation Project: Using OpenCV & Dlib (27 Layered version of a ResNet-35 Model) to detect and recognize Employees using live feed and account for their payroll and attendance through Facial Recognition. Primarily targeted towards SMEs Educational Qualification

Graduation B.E in IT from Thadomal Shahani Engineering College, Mumbai Post-Graduation PGP in Data Science from Aegis School of Business and Data Science Skills Summary

Domain Finance- Equities, Insurance, Banking



SQL, Shell Script, R Analytics, Hive, Sqoop, Python, Spark-scala Operating System /

ERP Version

Unix, Windows

Data Integration

Tools / DB

Oracle 9i/10g, Teradata 12/13, Netezza, Ab Initio CO>OP 3.0, 2.14/.15., Talend Data Integration


Machine Learning, Natural Language Processing, HDFS – Hadoop, MapReduce, Spark

Project 1

Project Name Data Quality Platform (DQP) Team Size 23 Start Date Jun 2016 End Date Till Date

Company Name L&T Infotech

Project Description

Data Quality Platform (DQP) is a Web-based ETL tool that enables data quality analysts and development teams across all Citi lines of business to define, manage and report on all levels of Assessment Project activity. It provides a platform through which authorized users can:

Configure the DQP platform itself

Perform discovery and analysis with data profiling

Define assessment projects

Execute checkpoint validation, scheduling, and monitoring

View data quality reports and Dashboards.

Role & Contribution

Coordination with Client and onsite team to analyze requirements, develop user stories, design solutions and provide estimates

Developed Abinitio Graphs for data quality checks, which included validation and transformations

Documented and executed all the test cases and processes for each release

Worked on server migration and testing on the migrated serves.

Technology & Tools Abinitio, SQL, Unix (Tectia), OPS Console Scheduling., ACE/BRE, HDFS, Hive, Python

Other Experience

Start Date Oct 2014 End Date June 2016

Company Name Oracle Financial Services Software Limited – Senior Consultant Role & Contribution

Gathered requirements from Wrapper team, and accordingly created Functional and Technical Requirement documents.

Developed Abinitio Graphs and Talend jobs

Documented and executed all the test cases and processes for each release.

Led ETL COE and Clearing Switch Team from OFSS.

Collaborated with multiple partner systems to share requirements. Co-ordinated between the Client and Partner system.

Provided requirements to the SIT/QA team for the testing. And coordinated with the teams to ensure timely completion. Technology & Tools Abinitio, SQL, Unix (Tectia), Autosys Scheduling, Talend, PLSQL, Other Experience

Title Accenture Pvt. Ltd. – Software Engineer

Start Date Aug 2013 End Date Sep 2014

Role & Contribution

Developed Ab initio Plan and Graphs, also created Unix Shell scripts and Sqls to extract the data from Database.

Worked independently on this project and was the Single Point of Contact for the client.

Created Auotsys Jobs for Scheduling purposes.

Performed System testing to ensure no defects are raised. Other Experience

Title Wipro Technologies Services Pvt. Ltd. – Project Engineer Start Date Oct 2009 End Date Jul 2013

Role &


Developed UNIX shell scripts and Ab Initio graphs to completely automate the process.

Created Ab Initio graphs out of business rule.

Ensured smooth business cycle by taking care of the operations.

Rule building basics in SmartStream TLM Reconciliation. Trainings/Courses

Professional Ab Initio training from the Ab Initio Corporation

Advanced Ab Initio training which included Plans, Vectors and Reusable graphs

Insurance Foundation Training

BigData, Hadoop/HDFS training, Hive, Spark – Scala, Python, R Achievements and Awards

Winner of Hackathon at L&T Infotech – Coding project for ‘HNI Customer Profiling’ using Machine Learning

Received Project Awards –

Client Centricity for significant team performance

‘We Applaud Award’ for exemplary performance in Clearing Switch project

‘We Applaud Award’ for exemplary performance in ETL CoE project

Received Client and supervisor Appreciation mails for delivering zero defect projects.

Received Appreciations from Supervisor’s for setting up issue free Abinitio environment on

Contact this candidate