profile-pic

Harish Rao

Seeking a position to utilize my skills and abilities in the Information Technology Industry that offers professional growth while being resourceful, innovative, and flexible.
  • Role

    Technical Lead

  • Years of Experience

    12 years

Skillsets

  • Data Analysis
  • SQL
  • Shell Scripting - 6 Years
  • ETL
  • Data Migration
  • Postgre SQL - 2 Years
  • design document
  • Oracle
  • Self-motivated
  • Team Player

Professional Summary

12Years
  • Sep, 2020 - Present6 yr

    Technical Lead / Integration Consultant

    Fidelity Management & Research
  • Apr, 2017 - Apr, 20203 yr

    Principal Software Engineer

    Dell International
  • Apr, 2015 - Jan, 20171 yr 9 months

    Senior Oracle Developer

    Capital One Bank
  • May, 2011 - Feb, 2012 9 months

    Senior Oracle Developer

    PMAM IT Services
  • Jun, 2012 - Jul, 20142 yr 1 month

    Senior Software Engineer

    CGI Information Systems & Management Consultants
  • Aug, 2014 - Apr, 2015 8 months

    Senior Oracle Developer

    Union Bank
  • Jan, 2009 - May, 20112 yr 4 months

    Oracle PL/SQL Developer

    AREVA Transport & Distribution
  • Jan, 2007 - Dec, 20081 yr 11 months

    Oracle Forms & Reports Developer

    InterDigital Inc

Applications & Tools Known

  • icon-tool

    TOAD

  • icon-tool

    SQL Developer

  • icon-tool

    Control-M

  • icon-tool

    Informatica

  • icon-tool

    AWS

  • icon-tool

    Jenkins

  • icon-tool

    Jira

  • icon-tool

    Snowflake

  • icon-tool

    Anypoint Studio

  • icon-tool

    Python

  • icon-tool

    Athena

  • icon-tool

    Bitbucket

  • icon-tool

    AWS Cloud

  • icon-tool

    Anypoint Studio

Work History

12Years

Technical Lead / Integration Consultant

Fidelity Management & Research
Sep, 2020 - Present6 yr
    Interacted with the PO & End Users to understand the requirements, enhancement of new features to Treasury Workspace Application, practiced Agile, involved in Scrum Meetings, Backlogs Grooming and Planning, validation, configuring AWS EC2, S3, Glue, SQS Queues, development & enhancement of PL/SQL Objects, enhancements to queries in Athena, Spark and PostgreSQL, enhancement to Snowflake SQL queries, Snowpipe, Time Travel setup, monitored Autosys jobs, Schedules in Anypoint Studio, PROD install setup, CM Tickets, involved in Spark migration, integration and deployment, addressing vulnerabilities.

Principal Software Engineer

Dell International
Apr, 2017 - Apr, 20203 yr
    Interacted with the PO and Business group to understand the requirements, implement and support SCDH & RCM Applications, practiced Agile, involved in Scrum Meetings, Backlogs Grooming and Planning, enhancement and development of PL/SQL Objects and Snowflake SQL queries, worked on Oracle ERP Concurrent Programs, Conversions, Request Sets, Interfaces, created and modified jobs/batch scheduling using Control-M, involved in Cloud Migration of database objects using GoldenGate & AWS, regression testing, unit testing & performance tuning of code, worked on Oracle 12c hardware upgrade and performed end-to-end testing of application, involved in Informatica upgrade to 10.2, developed & enhancement of workflows, enhancement of batch scripts & UNIX Shell Scripts

Senior Oracle Developer

Capital One Bank
Apr, 2015 - Jan, 20171 yr 9 months
    Enhancement & support to Risk Weighted Asset (RWA) Application/BASEL-II framework, practiced Agile, involved in Scrum Meetings, Backlogs Grooming and Planning, enhancement and development of PL/SQL Objects & Performance Tuning of Code, involved in Migration & Monthly Releases to QA/UAT/PROD, involved in Strategic Planning, leading the Agile POD, Off-Balance Sheet exposure, resolved PROD Incidents, data analysis/correction, research & investigation

Senior Oracle Developer

Union Bank
Aug, 2014 - Apr, 2015 8 months
    Developed and customized PL/SQL objects as per the mapping rules, asset management & support to Loan Returns Manager Application, involved in data error correction, data analysis & monitoring, involved in migration of code to UAT/PROD, developed new/existing data feeds for internal/external upstream source systems, customized scripts, negotiate backlogs and Performance Tuning of Code

Senior Software Engineer

CGI Information Systems & Management Consultants
Jun, 2012 - Jul, 20142 yr 1 month
    Interaction with the client to understand the business requirement, involved in Migration from Sybase to Oracle database, performed Bug-Isolation and Data-Conditioning for all cycles of the application, involved in Extraction Transformation and Loading into Oracle Tables, developed and customized PL/SQL Functions, Procedures and Packages, performed System Integrated Testing and Managed the defects by Triage Calls

Senior Oracle Developer

PMAM IT Services
May, 2011 - Feb, 2012 9 months
    Understanding Argo Group US Insurance property-casualty market, coverage, claims, customized conversions for Account Payables, ERP P2P cycle, customized and deployed PL/SQL Procedures and Packages, customization of Oracle Reports for Risk products, developed and customized Oracle Forms from scratch

Oracle PL/SQL Developer

AREVA Transport & Distribution
Jan, 2009 - May, 20112 yr 4 months
    Implemented eTerraSettlements application, coordinated with the Product Owner & Users, customized PL/SQL Packages, Procedures and Functions, constant monitoring of Data and performance tuning of the code

Oracle Forms & Reports Developer

InterDigital Inc
Jan, 2007 - Dec, 20081 yr 11 months
    Implementation of ebilling Application, developed and customized Oracle Forms & Reports, involved in conversions to seed data into account payables tables, prepared technical design document for the application.

Major Projects

6Projects

Product Costing (EPC)

Compensation Incentives (Coin$)

Planning Supply Chain Data Hub (SCDH)

Retail Channel Management (RCM)

Treasury Workspace Application

Sep, 2020 - Present6 yr
    Enhancement of existing system and adding new features.

Planning Supply Chain Data Hub (SCDH) & Retail Channel Management (RCM)

Apr, 2017 - Apr, 20203 yr
    Responsibilities: Interacted with the PO and Business group to understand the requirements Implement and Support SCDH & RCM Applications Practiced Agile, involved in Scrum Meetings, Backlogs Grooming and Planning. Enhancement and development of PL/SQL Objects and Snowflake SQL queries. Worked on Oracle ERP Concurrent Programs, Conversions, Request Sets, Interfaces. Created and modified jobs/batch scheduling using Control-M. Involved in Cloud Migration of database objects using GoldenGate & AWS. Regression Testing, Unit Testing & Performance Tuning of code. Worked on Oracle 12c hardware upgrade and performed End-to-End testing of application. Involved in Informatica upgrade to 10.2, Developed & Enhancement of Workflows. Enhancement of Batch Scripts & UNIX Shell Scripts. Managed Project documentation and version control using MS Visual Studio.

Education

  • Master of Science in Computer Science

    Long Island University

  • Bachelor of Engineering in Information Science & Engineering

    NIE

Certifications

  • Foreign corrupt practices acts

  • Capital one bank anti-money laundering (aml)

  • Anti-bribery & anti-corruption td bank data protection

  • Anti-money laundering (aml), anti-bribery & anti-corruption td bank

  • 2015 foreign corrupt practices acts capital one bank

  • Deutsche bank training in facilitative leadership

  • Data protection deutsche bank

  • Training in facilitative leadership