Jaganpreet Singh Kohli

Experience

• 

  Birlasoft

  Aug 2010 - Sept 2012

  Oracle PL/SQL, Unix Developer
• 

  American Express

  Oct 2012 - Nov 2016

  BI Analyst (ETL Designer)

   Delivering the projects end to end including planning, design, development, test and deployment. Responsible for the design & implementation of various cost saving initiatives. Working with teams (e.g. Business Team, Database Team, Release Team, etc) across geographies to ensure the timely delivery of the projects. Actively working with business partners and source team to gather and analyze the requirements, reporting metrics and convert them into ETL User stories. Working closely with data architects to design the data model and fitment of the database tables into Dataware house – Star schema and reviewing the Logical and Physical data models. Developing the ETL code using Informatica Power Center, Netezza, DB2, Oracle to load the data into warehouse tables ensuring proper quality and audit logging standards.  Extensively worked on transformations like Expression, Lookup, Joiner, Aggregator, Source Qualifier, Update Strategy, Router and Mappings using Informatica Designer and processing tasks using Workflow Manager. Development of Unix shell (Korn) scripts for file download, file validation and sending reject notifications.  Worked on Hive to extract the data from SQL server and ingest the same into big data and build reports on top of it using tableau. Applying performance improvement measures in the existing code to increase the throughput Managing and executing the webfocus change migrations. Show less

• 

  Accenture

  Nov 2016 - Feb 2017

  Application Development - Specialist
• 

  Macquarie Group

  Feb 2017 - now

  • Assistant Vice President

    Apr 2024 - now

  • Manager

    Apr 2022 - Mar 2024

  • Assistant Manager - Axiom

    Jul 2019 - Mar 2022

  • Technology Executive - Axiom

    Feb 2017 - Jun 2019