Narasimha Rao Kakarla

Organization Name: HCL Tech

Project Name: PC7 (eBay) and Acxiom Impact

Client: Zeta Global

Sub Client: Consumer Reports, Sallie Mae, Nextel and General Motors. Role: Software Engineer

Duration: March 2021 to till Date

About Client:

• Zeta Global acquired PC7 (eBay) and Acxiom Impact which are also Email service providers.
• All these tools are data-driven marketing technology company that helps brands acquire more customers, retain them for longer and grow their value by supporting customers with ESP tools to grow their business.

Responsibilities:

• Worked on External Tables to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL Stored procedures, Functions and Packages for Imports and Exports.
• Created Indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and External Tables.
• Used Bulk Collections for better performance and easy retrieval of data by reducing context switching between SQL and PL/SQL engines.
• Creation of database objects like Tables, Views, Materialized views, Procedures and Packages using ORACLE tools like Toad, PL/SQL Developer and SQL*Plus.
• Partitioned the fact tables and Materialized views to enhance the performance.
• Extensively used Bulk Collections in PL/SQL objects for improving the performance.
• Created Records, Tables, Collections (Nested tables and Arrays) for improving Query performance by reducing context switching.
• Handled errors using Exceptional Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created Views and generated export files using Views.
• Knowledge on UNIX Commands.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints for rule based optimization.
• Wrote SQL, PL/SQL programs required to retrieve data using Cursors and Exception handling.
• Involved in all phases of SDLC (Software development lifecycle) from analysis, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.
• Effective made use of Aggregate functions, Indexes, Analytical functions, Views.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function based).
• Developed complex database objects like Stored Procedures, Functions and Packages using SQL and PL/SQL
• Modeling for OLTP and dimensional modeling for OLAP.
• Loaded data into Oracle tables using external tables.
• Experience with Oracle supplied packages such as DBMS_OUTPUT and UTL_FILE.
• Worked extensively on Ref cursor, external tables and collections.
• Expertise in Dynamic SQL, Collections, Exceptional handling