Summary
Overview
Work History
Education
Skills
Certification
Work Availability
Interests
Quote
Timeline
SoftwareEngineer
Vipul Jain

Vipul Jain

BI Senior ETL Developer
Bengaluru,Karnataka

Summary

Experienced BI Developer with over 13 years of experience adept in bringing forth expertise in System Analysis, Design and Development of Data Warehousing Applications. Demonstrated versatility and adaptability in working on different technologies. Able to effectively self-manage during independent projects, as well as collaborate as part of a productive team.

Overview

4
4
Certifications
4
4
years of post-secondary education
13
13
years of professional experience

Work History

Senior Manager Data Management and Delivery

JLL
Bengaluru, Karnataka
05.2019 - Current
  • Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.
  • Developed ingestion pipelines and data analysis systems
  • Utilized Azure Data lake, Azure Data factory, Azure Databricks and MS SQL Server studio
  • Developed PySpark scripts to automate manual load performed during failures.
  • Troubleshoot ETL failures and performed manual loads
  • Assisted a dynamic team of engineers in the UK and India to implement global infrastructure changes that enhanced network performance and customer provision services in a timely manner
  • Implement enhancements to existing applications in addition to onboarding Property data from new countries using IICS.
  • Rich experience to extract data from REST API's using IICS.

System Analyst

Australia and New Zealand Bank(ANZ)
Bengaluru, Karnataka
01.2016 - 04.2019
  • Delivered in-depth informatic ETL training, imparting knowledge of best practices for protecting data and minimizing errors.
  • Gathered requirements and performed gap analysis through design workshops with users.
  • Developed Database & Unix scripts for a major investment Banking and Insurance/Finance Client.
  • Good experience on autosys and control-M scheduling tools
  • Coordinate build and deploy, release acceptance, release communications, preparations and training activities, distribution and installation of releases
  • Worked as a Technical Designer for Smart Choice Super plus product and APRA 2016
  • Developed flowcharts and diagrams to describe and lay out logical operational steps.

Principal Consultant - BI

NTT DATA
Bengaluru, Karnataka
12.2011 - 12.2015
  • Liaise and support Business Analyst team in requirements feasibility studies and discussions
  • Created Informatica Mappings with Source qualifier, Aggregator, Connected & unconnected lookups, Filter, Update Strategy, Rank, Stored Procedure, XML, Expression and Sequence Generator transformations.
  • Improving the Performance issue in overall ETL batch load and created a Unix shell script for post-production validation.
  • Performed Upgrades for Informatica Power centre Version 8.6.0 to Informatica Power center 9.1.0
  • Close collaboration with QA, Enterprise Reporting and System Integration teams in driving the enterprise projects
  • Directed onsite training for business users to maximize productivity.
  • Developed comprehensive business cases to analyze costs, benefits, ROI and TCO of proposed solutions.

Programmer Analyst

Cognizant
Bengaluru, Karnataka
10.2007 - 12.2011
  • Evaluated and adopted new technologies to address changing industry needs.
  • Design and implement feature enhancements supporting the business processes for the core enterprise systems: AIX, COBOL, JCL Informatica, DWH and Oracle.
  • Coordinate, build and deploy, release acceptance, release communications, preparations and training activities, distribution and installation of releases.
  • Develop or improve the engineering system to enable higher-quality tools and products to be developed and delivered; identifies risks, costs, and opportunities for improvement
  • Successfully build, tested and integrated features/functions through system life cycle (e.g. integration, customer feedback, release, and engineering phases)

Education

Bachelor of Engineering - Electronics And Communications Engineering

University Of Rajasthan
Kota, Rajasthan
07.2003 - 05.2007

Skills

Informatica and IICS

undefined

Certification

Certified PowerCenter Data Integration 9.x:Developer Specialist, Informatica

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Interests

Gadgets

Technology

Quote

Everything we see hides another thing; we always want to see what is hidden by what we see.
René Magritte

Timeline

Senior Manager Data Management and Delivery

JLL
05.2019 - Current

System Analyst

Australia and New Zealand Bank(ANZ)
01.2016 - 04.2019

Principal Consultant - BI

NTT DATA
12.2011 - 12.2015

Programmer Analyst

Cognizant
10.2007 - 12.2011

Bachelor of Engineering - Electronics And Communications Engineering

University Of Rajasthan
07.2003 - 05.2007

Similar Profiles

CREATE PROFILE
Vipul JainBI Senior ETL Developer