Experience

• 

  Capgemini

  Aug 2016 - Jul 2019

  Performed role of an ETL Developer for an supply-chain management clientWork Description -• Creating ETL / SSIS packages to extract data from different sources - Excel, Flat files, SQL Server to files Using different SSIS components.• File Validation by checking file types, names and file handling techniques Using SSIS Packages.• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc. • Script Task- using script code to perform tasks which are not achievable using Built in tasks and Transformations.• Manipulating Data, Applying Business logic, converting Unstructured Data into Structured Data using SSIS packages.• PL/SQL blocks to accomplish multiple DDL, DQL, DML statements.• Advanced SQL Queries, Joins, Stored procedures.• Monitoring jobs in SQL agent Jobs.• Performed Unit Testing and Prepared Unit Testing Documents.• Creating SSRS parameterized reports & error reports. Show less Software Engineer worked on MSBI for an Fleet management clientProject Description - Creation and implementation of central repository for Custom Fleet in SQL Server 2016 (History enabled – SCD Type 2) for BI solution and data science use cases.Data Flow – Replicate data using Attunity from OLTP to staging layer (Oracle) and load data in central repository (SQL Server) using SSIS.Business solution – Creating and load data in report layer for BI analytics using SSIS. BI analytical reports using SSRS. Show less

  • Associate Consultant

    Aug 2018 - Jul 2019

  • Senior Software Engineer

    Aug 2017 - Jul 2018

  • Software Engineer

    Aug 2016 - Jul 2017
• 

  Deloitte

  Jul 2019 - now

  Working on FCPA engagements using Sql, Tableau & Power BI

  • Lead Solution Advisor

    May 2022 - now

  • Solution Advisor

    May 2021 - May 2022

  • Associate Solution Advisor - Forensic Analytics

    Jul 2019 - May 2021