Mar 2022 – Nov 2022 · 8 mos · Gurugram, Haryana, India · Remote

• Senior Data Engineer

Sep 2020 – Mar 2022 · 1 yr 6 mos · Noida, Uttar Pradesh, India · Remote

• Project: Analytics
• Client: Leading streaming service platform.
• Role: Data Engineer
• Size: 15
• Tenure: September 2020 to Feb 2022.
• Description: An American subscription video-on-demand over-the-top streaming service.
• The team handles the data coming from various sources in the system and do necessary
• things on data that is required according to business needs.
• Roles and Responsibilities:
• Writing snowflake queries for the ETL and the analysis part.
• Creating data pipeline using Airflow i.e. creating dags to pick data from source and attach
• snowflake queries which at last inserts the data in respective tables.
• Using git for code versioning.
• Provide on-call support in case of any failure
• Data analysis in case of data duplication, nulls and other possible causes.
• Co-ordinate with the analytics team for their requirement.
• Data modelling according to the business needs.

Jul 2018 – May 2020 · 1 yr 10 mos · Gurgaon, India · On-site

• Project : TCTP (Tooling Control and Tracking Platform)
• Client : Siemens Energy
• Role : Lead
• Size : 12
• Tenure : October 2018 to Februray 2020.
• Description : The TCTP application supports the ordering and shipment of tools between depots and power stations world-wide. Tools and Kits are contained in a common Tool Catalog database.
• Other functions support inventory management and tracking, purchasing, billing and administration of data used by all modules.
• Roles and Responsibilities:
• Interfaced with stake holders and facilitated communication between client and the development
• team.
• Involved in Feasibility and Risk Analysis to identify the business critical and high-risk areas of the
• application.
• Involved in Design, Development and Testing Phase.
• Involved in code review and end to end implementation as well.
• Monitoring jobs and health of Application as per the client requirement.
• Automate existing processes thereby eliminating manual intervention and provide the data to
• business user.
• Developed Back end objects like stored package, function, procedure, trigger etc. for the client’s
• application.
• Worked on query optimization and performance tuning of existing code.

Mar 2018 – Jul 2018 · 4 mos · Gurgaon, India · On-site

• Project : DB-FSE (Financial Sector Entity)
• Client : Deutsche Bank
• Role : Module Lead
• Size : 10
• Tenure : March 2018 to July 2018
• Roles and Responsibilities
• ● Requirement gathering and Coordination with different teams which includes business as well as TCS Offshore team for on time delivery.
• ● Status reporting to the Business on daily and weekly basis and driving the status calls to discuss show Stoppers, issues and providing resolutions for them across the applications.
• ● Developed Backend procedures for the staging data load and SCD1 and SCD2 mappings for the dimension table.
• ● Perform unit testing and defect closure in given timeline during batch runs to avoid delays in batch.
• ● Provide technical and functional support to the application.
• ● Co-ordinate with business users for application maintenance and application tuning.
• ● Monitoring jobs and health of Application as per the client requirement through BMC Control-M utility. Automate existing processes thereby eliminating manual intervention and provide the data to business user with all the checks and to keep pace with upstream.
• ● Extending high-end technical support and ensuring high customer satisfaction levels through prompt redress of the problems and documentation and to meet SLA within time.

Oct 2017 – Jul 2018 · 9 mos · Gurgaon, India · On-site

• Project : Reference Data Services
• Client : Deutsche Bank Team
• Role : Module Lead
• Size : 18 members
• Tenure : Dec 2016 - Mar 2018
• Roles and Responsibilities:
• Involved in Documentation (BRD and FRD: business requirement documentation and functional
• requirement documentation) Phase.
• Interfaced with stake holders and facilitated communication between client and the IT department.
• Gathered all requirement like list of artifact, changes going for the release and make plan according
• to them.
• Raised GCM on Service-Now, made handover document for L2/L3 Team for Project Release.
• Made Deployment plan, Arranged hand over call, collect UAT sign-off documents,
• Generate Source Code Change Report for Project Release.
• Involved in Feasibility and Risk Analysis to identify the business critical and high-risk areas of the
• application.
• Successfully Delivered many live project release.
• Worked as a liaison between business users and developers to submit requirements and changes,
• clarify questions and issues.
• Experienced for organizing and documenting requirements, preparing use cases, writing business
• documents and reports in Pre- Testing phase.
• Worked on a team environment to finalize use cases to develop functional and detail design
• specifications of the application.
• Involved in Design, Development Phase and Testing Phase.
• Involved in code review and end to end implementation as well.

Dec 2015 – Sep 2017 · 1 yr 9 mos · Gurgaon, India · On-site

• Project : Reference Data Services
• Client : Deutsche Bank Team
• Role : Team Member(Developer)
• Size : 15 members
• Tenure : March 2016 - Sept 2017
• Roles and Responsibilities:
• Developed many Oracle objects like Procedure, Function, Package, Trigger, Materialized view, Index.
• Created many shell script in UNIX to handle the entire file handling related tasks.
• Involved in Feasibility and Risk Analysis to identify the business critical and high-risk areas of the application.
• Worked as a liaison between business users and developers to submit requirements and
• Changes, clarify questions and issues.
• Experienced in query optimization and performance tuning.
• Provided Extensive support on UAT Environment to client and consumers.
• Experienced for organizing and documenting requirements, preparing use cases, writing business
• documents and reports in Pre- Testing phase.
• Worked on a team environment to finalize use cases to develop functional and detail design
• specifications of the application.
• Developed a user acceptance test plan and test case scenarios to guide a select group of key end-
• users in testing the user interface and functionality of the application.
• Performed requirement walk through with the Dev. and QA teams with the aim to develop testing
• strategies and test plans such that test cases reflect user needs.
• Involved in code review and end to end implementation as well.

Jul 2013 – Nov 2015 · 2 yrs 4 mos · Mumbai Area, India · On-site

• Projects: Debit Card Reconciliation System (DCRS) / Cash in ATM (CIA) / Prepaid(Loyalty) Card
• Management System.
• Client: Punjab National Bank, Bank of India, IDBI, United Bank of India, Oriental Bank of India,
• Dena Bank, Federal Bank
• Role: Team Member (Developer, Client Support)
• Size: 20 members
• Tenure: July 2013 – November 2015
• Roles and Responsibilities:
• Gathering and analyzing the requirements of different banks to make the system as generalized system so that it can work for any Bank.
• Worked with client and functional team to finalize their requirement for develop and change in application.
• Development of File Processing module, GL Recon Report Generation module, TTUM Generating Module using PL/SQL Stored procedures.
• Worked as a liaison between operation team and Project manager to submit requirements and changes, clarify questions and issues.
• Deployed the application at client side.
• After deployment analyzing the performance issues and made necessary changes to improve the performance.
• Performed requirement walk through with the Development and QA teams with the aim to develop testing strategies and test plans such that test cases reflect user needs.
• Involved in code review and end to end implementation as well.
• Creation of Tables, Views, Constraints, Indexes and Packages.
• Developed Complex database objects like Stored Procedures, Functions, and Triggers using SQL and PL/SQL.
• Developed a user acceptance test plan and test case scenarios to guide a select group of key end- users in testing the user interface and functionality of the application.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Involved in the meeting with Client to understand their future requirement and scope.
• Migration of old interfaces from Java to Oracle.
• Involved in Analysis, Design, Development Phase and Testing Phase.

Dec 2011 – Aug 2012 · 8 mos · Noida Area, India

• Project: Learn@Will
• Client: Nucleus Software
• Role: Team Member
• Size: 06 members
• Tenure: Feb 2012 – June 2012
• Roles and Responsibilities:
• Written the backend JavaScript code for tooltip.
• Generated the xml in backend for required data.
• Developed a user acceptance test plan and test case scenarios to guide a select group of key end-users in testing the user interface and functionality of the application.
• Involved in code review and end to end implementation as well