Vikram Hegde

Client: Bank of America

Project: Client Relationship Hub(CRH) SDP Migration

• Leading team of 10+ Engineers and Devops team to migrate complex value added processes running on Vertica Data warehouse to Hadoop Platform.
• Converted existing Vertica code to spark sqls and pyspark scripts.
• Migrated Terabyte/petabytes of data from Vertica to Hadoop ecosystem using ETLs running on scheduled basis in Autosys.
• Generated required end-to-end validation reports post ETL executions on production parallel environments.
• Successfully migrating it to production post getting it business signed off from client.
• Provided guidance and mentored less-experienced staff members.

Client: Bank of America

Project: IBM Sailfish DB2 Warehousing queries to Apache Impala-Kudu Migration

• Lead a team of 5+ Engineers and successfully delivered a POC on Migrating IBM DB2 Sailfish Warehouse Reporting Queries to Apache Impala Queries running on Hadoop Platform Kudu Columnar Storage.
• Created Reconciliation reports to provide E2E comparisons of Migration
• Optimised queries to beat current SLAs and provide satisfactory evidence to migrate to Apache Kudu on Hadoop platform.
• Customized frameworks using Pyspark to get best data migration results.

Projects: Client Facing Documents Manager, Legal@JPMC, Library, Office of the Legal Secretariat, Legal Financial Portal

• Led design and development of application database using Oracle 11g, 12c and MariaDB.
• Planned, Implemented Data modelling, Data analysis and Database development Process.
• Migrated Oracle Database 12c to 19c from Standalone to Private Oracle Cloud Infrastructure.
• Administered database with Backups, Restore points, Tablespace & Disk Management processes.
• Configured Microservices architecture based Cloud applications in JPMC Private Cloud.
• Developed RESTFUL APIs with ADFS authentication for App2App Integrations.
• Integrated with Jules for Continuous Integration and Continuous Deployments (CI/CD) using Jenkins and Liquibase for application and database deployments.
• Carried out Test Driven Development using JUnit and used SONAR for code coverage.
• Collaborated with Reporting and Analytics team for building SAP Business Objects Reports using Informatica for ETL.
• Performed Code Refactoring, Code Optimizations and Code Reuse at regular Intervals.
• Adopted Peer Programming and Peer code review processes as part of code promotions.
• Followed Agile development methodology for development processes.

Project: Cisco Network Audits

• Developed Database Objects, Stored Procedures for IC Audit & Optical Audit Rules in rbml
• Optimized SQL queries for better performance.
• Created Business Intelligence (BI) Reports development of Audit Metrics using Jaspersoft
• Followed Agile Development methodology.

Project: Data Warehousing and Data Mining, Philippines Postal Bank

• As a Research & Design Analyst for Building a new Data Warehouse, for Reporting & Analytics.
• Researched on building Data Models for Customer Profile Analysis and Credit Scoring using Weka Data Modelling Algorithms (Associative and classification).
• Created Universes, Business Intelligence reports & Dashboards for web and mobile in SAP Business Objects & Crystal Reports for Philippines Postal Bank.
• Documented High Level Design Documents (HLD) and Software Requirement Specification documents (SPS) for Business Requirements.
• Administered report generation using Scheduling, Report Bursting, Users and User Group Maintenance, Backups.
• Built reporting portfolio with tools like Universe Design Tool/Information Design Tool, Web Intelligence Client, Crystal Reports for Enterprise, Business Explorer, Dashboards, Query as Web Service tool, Central Management Console.

• Performed Data Migration of core banking module of Customers, Current and Savings accounts (CASA), Term Deposits (TD), Consumer Loans (CL), Payments(Standing Instructions and Payment Queues), Overdrafts and Limit Lines, Delinquency queues (DQ), Pension funds, Cards, Utility Payments & Agreements from Forpost to Flexcube.
• Developed Static and Financial Reconciliation Reports for Migration correctness checks.
• Designed and Developed Tables, Types, Indexes, Views, Triggers, stored procedures, packages and Functions.
• Optimized the code using Performance tuning concepts for generating table statistics, Explain Plan analysis, Optimizer Hints, Partitioning & indexing.
• Performed Database Administration (DBA) activities such as Database Backup & Restore.
• Documented using Technical Design Documents (TDDs) for Data Migration process.

Projects: ConnectCore

• Worked on developing Tables, Types, Indexes, Views, Triggers, stored procedures, packages and user defined Functions for business functionalities of banking application.
• Documented database development process with High level Design (HLD) and Low Level design (LLD) documents.