Developer Data

Summary

Vipin Hasija is a Senior Associate Technology in Sapient’s Gurgaon office.

He has five plus years’ experience in client management, requirements gathering, analysis, project planning, ETL design and development.

He possesses functional domain knowledge in Automobile, Insurance and IT Firm Domain.

Work Experience

Sapient Corporation, (Feb 2015 to present)

/ Magna InfoTech Pvt Ltd @ Sapient Corporation, (Sep 2013 to Feb 2015)

Talend Developer – Automobile

Project is based on gathering and migrating data via Implementation, Development and Maintaining Data ware house with the help of ETL Jobs on TALEND.

Responsibilities:

Look towards ETL Jobs for optimization.

Creation of new ETL jobs for Data Migration Purpose.

Client delivery documents

Qualtech Consultants PVT Ltd, (Nov 2011 to July 2013)

Sr. Software Engineer – Insurance Domain

It is the process to develop Queries, Procedures on Oracle on the basis of user’s requirement & generate reports and implementing in Talend jobs if required.

Responsibilities:

Normalized the database and recreated tables to improve the query performance.

Used explain plan utility to optimize the process.

Tested newly created jobs against existing jobs and supported users during User Acceptance Testing.

Helped team in recreated all the jobs on Talend DI environment installed on different server.

Responsible for maintaining the data cleansing and data quality jobs

Tested all the jobs and supported end user during user acceptance testing.

Debugging, Optimization of existing procedures & queries, creation of ETL migration scripts and also involved in writing test cases for the unit testing of the procedures, functions, packages.

DB Commit Technologies, Sep 2009 to Nov 2011

Talend Developer – IT Firm

This project is involved in the development of Data Warehouse based on three kinds of data marts such as Accounts, Loans and Insurance. Each data mart represents a collection of data pertaining to a single business process. In loan data mart, involved in disbursal of loan amount for various purposes like: personal loan, educational loan etc. The company requires different levels of analysis regarding loan amount, type of loans, type of customers, type of payment schedules, interest (variable or fixed), defaulters list and the penal interest calculations, etc. The data Warehouse (basically it is a data mart as it covers only one domain of the business) captures data from transactional database.

Responsibilities:

Development, payroll, Attendance, Time-sheets, Company profitability analysis etc.

Developed Procedures and Functions for ETL process & manual report generation.

Preparation of project Implementation Documentation.

End-user Training

Fine tuning the queries running on the back end of DBCMIS system Automation of monthly and weekly reports to be submitted to senior management.

Worked with multiple sources such as Tables, Flat files, Excel Sources for Extraction

Education

Jodhpur National University, Jodhpur, India

MBA-IT (Master of Business Administration), 2014

Punjab technical University, Jalandhar, India

MSC-IT (Master of Science), 2012

Skills

Tools

Talend, BODI

TOAD, PLSQL Developer. SQL Loader

Tortoise SVN, JIRA

Database

Oracle, MSSQL

Operating Systems

Windows

Programming Languages and Scripting

SQL, Unix

Other

Certifications/Training

Oracle Certified Associate

Oracle Certified Expert

DB2 Certified

Contact this candidate