User

ETL Developer

BMT Score
86
86%
  • Remote

Available for

About Chanchal C

A performance driven ambitious software developer with an extraordinary blend of and technical knowledge. Ability to communicate and motivate team members to enhance strategic goals and bottom line objectives. Creative problem solving and troubleshooting skills complemented by meticulous attention to details that will result in the success of an organization by developing new applications or improving existing ones.

Work Experience

Images

ETL Developer

  • January 2018 - February 2023 - 5 Year
  • India

Projects

Images

BIAPPS Upgrade Project

  • November 2021 - December 2022 - 14 Months
Technologies
Role & Responsibility
    The project involves upgrading BIAPPS version from 11.1.1.10.2 in finance & HR to 11.1.1.10.3.
    RESPONSIBILITIES: 
    ODI 12c mapping development based upon ODI 11g interfaces
    Bug and issue fixes
    Participated in business requirement gathering through interactive sessions with Business Teams.
    Analysed the existing customer environment and provided guidance to the team to integrate the new ETL’s and to deliver the code on time.
    Having Onsite communications on daily basis.
    Created technical specification, unit testing documents.
    Responsible for Deliverables.
    Involved in unit testing and Integration testing.
    Having client interactions on new requirements gathering/Defect fixes.
...see less
Images

BI Development

  • May 2021 - October 2021 - 6 Months
Technologies
Role & Responsibility

    The project involves customization on top of existing BIAPPS project.

    RESPONSIBILITIES: 
    Prepared Technical Design Documents for the Finance Management module.
    Worked with Design and developed the Interfaces in ODI.
    Worked with Users regarding the design and new enhancements.
    Worked on the data validation between source and warehouse instances.
    Extended the warehouse tables and custom tables and created the Custom ODI Interfaces as per the BIAPPS standards.
    Performed Unit and Integration testing at various levels of the ELT (ODI).
    Worked on the customizations for OOTB mappings as per new requirements.
    Worked on Migration the ODI Components from one environment to another environment. 
    Mapped the custom Scenarios in ODI Load Plans.
    Debugged the ODI sessions by using the logs of the sessions.
    Created Custom Load Plan’s and monitored the load Plan’s.
    Developed multiple fact and dimension’s tables as per the design and new requirements.
...see less
Images

BIAPPS Informatica To ODI Migration

  • November 2018 - March 2021 - 29 Months
Technologies
Role & Responsibility
    The project is mainly focused on migrating existing Oracle BIAPPS & Custom implementation on informatica to ODI 11g along with upgrading BIAPPS version.

    RESPONSIBILITIES: 
    ODI ETL development based upon the informatica implementation.
    OBIEE Report testing and data validation.
    Performed troubleshooting and providing resolutions to OBIEE issues. 
    Fixing the bugs / applying enhancement to the existing code through production support. 
...see less
Images

ODI Development

  • March 2017 - September 2018 - 19 Months
Role & Responsibility
    ct Description:FreightCar America's purpose-built railcar facility features the latest equipment and a dedicated workforce with extensive railcar experience. The project involved reporting on their existing inventory and BOM (bill of material). It was the custom BI project with ODI 12c
    RESPONSIBILITIES: 
    Mappings are developed.
    Procedure and packages are developed
    Developed Load Plan and Scenarios
    Worked on Other ODI Objects
    Documentation
...see less
Images

TechCare Incident Analysis

  • May 2015 - March 2017 - 23 Months
Role & Responsibility
    This project is in python & flask to showcase pending and active tech incidents and its analysis. 
    The objective is to create a website which can be used across Incubic to identify focus areas immediately.

    RESPONSIBILITIES: 
    Code development using industry best practices.
    Unit testing and debugging for any issues
    Enhancements & bug fixes 
...see less
Images

TechCare Incident Analysis

  • June 2013 - April 2015 - 23 Months
Technologies
Role & Responsibility
    Installation & Configuration of Operating systems and applications 
    Experience of handling priority/exigency issues under stressful environment 
    Administration of windows platform with policy configurations 
    Advance configurations and debugging of MS Office such as MS Outlook, Lync/Skype for Business, Acrobat, MS Visio 
    Network installation and configuration esp. Wi-Fi 
    Share and document ideas, solutions, improvements and process efficiencies with team 
    Global Support for Remote Desktop technology platforms 
    Video conferencing support (WebEx and Bomgar) 
    Experience with Service Now preferred but not mandatory 
    Exposure on designing, development & testing of applications. 
    Database design using PL/SQL 
    Development of responsive web pages for pc and mobile devices. 
...see less

Industry Expertise

Education

Education

in M. Tech

Maharshi Dayanand University
  • June 2014 - June 2018

Our Suggestions