Gokul Rajaraman

About Gokul Rajaraman

TECHNOLOGIES: ORACLE DB, PERL, AWS Redshift, UNIX, DELL BOOMI, HTML, XML, JSON, JQUERY, Python.• Over 10+ years of experience in Data Modeling, Oracle PL/SQL, ETL at Enterprise Data Warehouses, Data Marts, ODS and Data integration system.• Experience in data mining structured and unstructured data in a business environment with large-scale, complex data sets.• Over 2 years of experience in building ETL, Data Integration, Implementation Web Services from using Dell Boomi.• Over 3 years of experience in building applications using PL/SQL Web Tool kit, JavaScript, JQuery, AJAX.• Over 3 years of experience working on Perl scripting, Python and UNIX scripting.• Experience in building ELT process using AWS Redshift.• Created and used XML, JSON for data management and transmission.• In-depth knowledge on Software Development Lifecycle (SDLC) within Waterfall and AGILE software development methodologies adhering to best practices and industry standards and CICD. • Experience with Data flow diagrams, Data dictionary, Database normalization techniques, Entity relation modeling and design techniques.• Created Tables, Partition, Indexes, Sequence, Views, Triggers, Procedures, Function, Packages, Materialized View logs, Materialized Views, Types, Database Links, XMLDB, Oracle Scheduler to execute procedures, Shell Script and Framework for batch jobs.• Extensively tuned SQL queries written in procedures/functions at the back end which are called from the front end reports using Explain Plan, and DBMS_PROFILER.• Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.• Ability to use Jira, Jenkins, Bitbucket, Git. • Ability to look at solutions in unconventional ways. Sees opportunities to innovate and can lead the way.• Ability to produce clear documented and commented code.• Family with Big Data concepts, Hadoop, Hive.• Worked at onshore offshore model, leading team of 5 members.

Experience

1. Senior Developer

   ICE

   Jan 2021 — Present · Los Angeles, CA, US

   Application development focused on backend.Primary technologies: Oracle 19c, Shell, Perl, Python and Tidal scheduler.Domain: Fixed IncomeRole: Individual contributor role.

Education

• Alpha Matriculation

  Computer Science

  1991 — 2006

• St. Joseph's College of Engineering, Chennai, India

  Bachelor of Engineering, Computer Science

  2006 — 2010

Skills

• Html
• Unix
• Shell Scripting
• Jsp
• Sql
• Xml
• Database Design
• Oracle Sql
• Unix Shell Scripting
• Pl/Sql
• Javascript