Ankit Khandelwal

Experience

• 

  Infosys

  Aug 2010 - May 2013

  Senior system engg.

  • Creation of SSIS Packages to extract modify and load data for Quantitative risk management tool• Created Data-driven Packages in SSIS as part of the automating the process for generating the Recon Reports.• The packages created included a variety of transformations, for example Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.• Extracted data from various sources like SQL Server 2005/2008, .CSV, Excel and Text file from Client servers and through FTP.• Creation and modification of database objects such as tables, stored procedures, triggers, functions, and views.• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.• Creation of batch jobs and running with Jp1 Scheduler• Troubleshoot in SQL Server jobs and JP1 batch job• Generation of Customized SSRS reports.• Running the Quantitave risk management tool to generate various reports like Valuation report, Daily Gap report, Pre Analysis report.• Analyzing the discrepancies in Reconciliation reports. Show less

• 

  Amdocs

  Jun 2013 - Jul 2015

  Senior Subject Matter Expert

  Role and Responsibilities:- Creation and maintenance of Master table.- Development of web services using Informatica Real time system to exchange data with Amdocs internal systems.- Scheduling and support of all ETL jobs and monitoring of continuous running web services.- Implemented Router, Filter, Join, Lookup, Update Strategy, Sequence generator, Xml Generator Transformations etc.- Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.- Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.- Deployment till UAT repository is part of my responsibilities. Show less

• 

  Wipro

  Jul 2015 - Aug 2018

  Team Lead
• 

  Capgemini

  Aug 2018 - Dec 2021

  Senior Consultant
• 

  Datametica

  Dec 2021 - Oct 2023

  • Senior Technical Project Manager

    Apr 2023 - Oct 2023

  • Technical Project Manager

    Dec 2021 - Apr 2023
• 

  Onix

  Oct 2023 - now

  Senior Technical Project Manager