Anuj Gupta

About Anuj Gupta

Total of 15 Years of experience in field of Data warehousing, and Software/Product Development and implementation. Data Enthusiast working in financial sector using multiple products and technologies. Designing and Implementing End to End Product Implementation. Data mapping from SOR to Staging Layer, Processing layer calculations using business logic and financial modelling techniques, Moving data to result layer(fact) for adhoc analysis. Transform and aggregate the data to support the Reporting layer granularities of multiple dashboards. Data Modelling for all the necessary data elements which are not available in the system, so that all the reporting requirements can be met. Fact dimension modeling. Keeping this in mind we design the Data Model.Designing Data Quality checks which should be performed to check the Sanity, Validity and Conformance with Dimension data. Dimension data loading via SCDs which supports all historical changes to be maintained as-is. Designed and Lead the the fully automated deployment framework using Gitlab and Python. All code deployments happen via CI/CD pipelines. This improved the efficiency and decreased the deployment time by 80 pct.Created fully automated echo system using AWS(EC2, Elastic Beanstalk, S3 storage, Tomcat). Multiple processes will work as scheduled jobs. Feeds will be downloaded, cleansed, processed, uploaded. This process will refresh the website multiple times in a day. All feed backups will be taken, all logging will happen with timestamps for any issues seen at the end of day. Almost no human dependency. Currently building search functionality using DynamoDB as back end. This will help in evaluating the Dynamo db.Built fully functional marketing engine using rest APIs like Youtube, Twitter, Facebook, Gmail. User do not have to go to individual site for sharing the content, but can share from single place to all the different places. This had 2 modes of sharing:1. Automatic : This will share the articles in timely manner.2. Manual : This helps user in providing the insights. Engine suggests the popular tags using algorithms running at backend. User can search the keyword and find the popular tags rated to it. ERM/EPM Banking Financial Modules Expertise: End to End OFSAA Implementations.Liquidity Risk Management(LRM), Basel, GL Recon, Profitability (PFT)Regulatory Reporting.Delivered OFSAA Projects by implementing ERM and EPM solutions with all customer specific customizations.

Experience

1. Vice President

   M&T Bank

   Nov 2019 — Present · Buffalo/Niagara, NY, US

   Lead and managed the new implementation of FSDF, DIH and OCI PBSMCS modules of Cashflow and FTP. This was a complex and high-profile initiative that required effective coordination among multiple teams, including Oracle, M&T, and other technical groups, to ensure a seamless transition to production.Designing and Implementing the profitability and reconciliation requirements. Lead the Onboarding all the SORs of the bank on single FSDF platform which will be used across teams for example FDIC and Reg reporting. Defining the DQ checks on onboarded data. Execute the reconciliation to make sure we have golden source of Data. Feed the data to profitability for running cost/non cost allocations using different methodologies. Finally allocatimg cost to account level. Move data to fct/result layer. Transform the fct layer to supports the reporting granularities and business view to analyze the reports across multiple granularities example Line of Business, Product, Service, Customer, Region, Sales Manager Etc.Designing the Profitability Allocation Rules to assign the cost at account level so that it can be aggregated at any level using OFSAA. Business can make next year data driven budgeting decisions by viewing holistic view of current year profitability across LOBs.Designed and Lead the the fully automated deployment framework using Gitlab and Python. All code deployments happen via CI/CD pipelines. Improved the deployment efficiency time by 80 pct.Optimized the reconciliation framework from 7-8 hours to 15-30 minutes. This improved the batch times and gave room for business to analyze the reports.Lead the onboarding of reg reporting changes and mapped the SOR fields with FSDF Data Model.Customized the DQ reports and framework, make business understandable and performance efficient by 90 pct.Designed and automated the user Audit reports via Python, these helps analyze user has access and ensure all security checks are reviewed and approved by App owners.

Education

• Punjabi University

  Btech, Computer Engineering

  2005 — 2009

• H.M.D.A.V Public School

  10th

  1991 — 2002

• R.S.D College

  High School, Physics, Chemistry, Mathematics

  2002 — 2004

Skills

• Consulting
• Requirements Gathering
• Toad
• Sql
• Databases
• Core Java
• Team Management
• Software Development Life Cycle (Sdlc)
• Extract, Transform, Load (Etl)
• Sdlc
• Oracle
• Requirements Analysis
• Unix Shell Scripting
• Java
• Shell Scripting
• Obiee Basics
• Performance Tuning
• Unix
• Business Analysis
• Erwin
• Data Warehousing
• Jsp
• Xml
• Database Design
• Pl/Sql
• Ofsaa
• Eclipse
• Software Development
• Etl