Summary
Overview
Work History
Education
Skills
Certification
Languages
Disclaimer
Timeline
Generic
Punkaj Kumar Aggarwal

Punkaj Kumar Aggarwal

Delhi

Summary

Result-driven Lead Software Designer with 15 years of experience in delivering quality results across demanding projects. Reporting Using Cognos Analytics; Data modelling using framework manager, databases DB2, oracle, teradata; Visualization using QlikView, Tableau, OBIEE in banking, Income TAX, Risk and Energy domain.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Lead - Operational Risk & NFR Report

NatWest Group
03.2024 - Current
  • Led technical delivery to ensure project alignment and successful execution.
  • AWS Athena, S3, and EMR Executed comprehensive requirement collection and analysis with both business and technical stakeholders.
  • Oracle PL/SQL
  • SQL
  • Data Interpretation
  • Mitigated technology risks and coordinated inter-team dependencies.
  • Data Visualization
  • GIT, Bitbucket, Created reports, dashboards and visualizations to distill large datasets into clear, concise and meaningful information for stakeholders.
  • Agile Scrum practices
  • Airflow, Autosys
  • Adaptable and proficient in learning new concepts quickly and efficiently.
  • Proved successful working within tight deadlines and a fast-paced environment.
  • Resolved problems, improved operations and provided exceptional service.


Senior Software Designer – Op Risk & NFR Reporting

NatWest Group
09.2022 - 03.2024
  • Spearheaded the migration of QlikView to Tableau for enhanced reporting solutions.
  • Created dashboard and Reports using Cognos Analytics; Data model using Framework manager
  • Created feeds for downstream system like OpRisk and SLX based on Vantage data
  • Designed data models in Tableau from AWS Athena using PySpark
  • Site Admin Activities: Managing users, permissions, and scheduling.
  • Managed the Eichel data lake programme for sourcing and centralising data across systems.
  • Created Tableau dashboards for multiple applications such as operational risk, Model Risk Management and ProAct.
  • Worked on the xDP (eXpress Data Pipeline) framework, which is an in-house tool for file ingestion, ETL, and backfeed extracts generation.
  • Developed ETL pipeline to optimize data for analytical purposes using PySpark SQL.
  • Developed Airflow DAGs in Python to simplify daily file ingestion.

Sr. Lead Analyst – ORION Reporting

Virtusa Consulting Services
08.2018 - 09.2022
  • Migration of Reports to QlikView which was based on data from Open Pages GRC tool from IBM
  • Created technical and functional documents to facilitate smooth migration of reporting
  • Collaborated with IBM GRC team and build multiple reports and data extracts which supports the Vantage System implementation and data reconciliation
  • Helped testing team to write SQL queries to perform end to end data testing.
  • Collected, analyzed, and interpreted complex data from system to provide actionable insights.

Lead Engineer – Insight DW

HCL Technologies
08.2016 - 08.2018
  • This project is to migrate Cognos reports to Oracle-OBIEE
  • Performing reverse engineering in order to create requirement document from report.
  • Mapping of report column with oracle database in which OBIEE report needs to build.
  • Creation/Tuning of query.
  • Continuous interaction with Onsite client/User for data and design analysis.
  • Using agile methodologies.
  • Mapping of warehouse columns with the transaction source system.
  • Provide training on SQL, COGNOS, and PL/SQL to new joiners.
  • Microsoft ETL tool – SSIS production support.
  • Worked on OBIEE.

Technology Analyst

Infosys Technologies
11.2013 - 08.2016
  • Worked on projects for Indian Income Tax and KOC (Kuwait Oil Company)
  • This project is to develop, customize, data analysis, ITR filing, tax
    collection and deduction and to provide solution to client in the form of
    Cognos reports.
  • Created the reports using report studio using functionalities like lists, cross-tab,master detail, etc. Responsible for technical design related decisions.
  • Implementation of data security at FM Level as well as report level
  • Creating and publishing of Packages in Framework Manager
  • Writing dynamic procedures in order to develop real time report.

Education

Master of Computer Applications - Computer Science

UPTU, Jaipuria Institute of Management
Vasundhara, U.P.
07-2010

Skills

  • Cognos Analytics proficiency
  • Tableau proficiency
  • SQL/(PL/SQL)
  • Framework manager
  • Data Modelling
  • QlikView

Certification

Certified Scrum Master

Languages

English: C2 Proficient
Hindi: C2 Proficient

Disclaimer

I hereby declare that the information furnished above is true to the best of my knowledge.

Timeline

Lead - Operational Risk & NFR Report

NatWest Group
03.2024 - Current

Senior Software Designer – Op Risk & NFR Reporting

NatWest Group
09.2022 - 03.2024

Sr. Lead Analyst – ORION Reporting

Virtusa Consulting Services
08.2018 - 09.2022

Lead Engineer – Insight DW

HCL Technologies
08.2016 - 08.2018

Technology Analyst

Infosys Technologies
11.2013 - 08.2016

Master of Computer Applications - Computer Science

UPTU, Jaipuria Institute of Management

Similar Profiles

CREATE PROFILE
Punkaj Kumar Aggarwal