Rishad Arakkal Pulikkathazhath
50 Elyse Rd, Mansfield,United States
Summary
Personal info Key Technical Skills: 4+ years of experience in leading cross-functional teams for data science and data analytics projects with an overall experience of 18+ Years. 10+ years of experience in developing and leading the team to build data driven applications using Oracle PL/SQL, Forms/Reports 6i, ETL, Unix technologies. Delivered a python program for running analytics queries across different relational database (Oracle, SQL Server, Mysql). Setup the infrastructure for Bigdata Environment in statestreet and created the pipeline to ingest the data from relational database to HDFS system for analytics and Visualization. Experience in MapReduce, Spark, Tez execution engines used in bigdata. Experience in Snowflake ingestion and transformation process.
Overview
18
18
years of professional experience
Work History
Principal Engineer
Fidelity Investments
01.2021 - Current
- Fidelity investment
- Playing a lead role in shared data SAI team In data driven project which is using technologies like Python, Oracle PL/SQL, Snowflake, informatica, Tableau, Data service API.
- Design and development of Data Engineering Frameworks - Data ingestion, Data quality
- Python process to clean the bloomberg characteristic data using Pandas and NumPy libraries.
- Experience in snowflake ingestion process
Principal Consultant
10.2008 - 01.2021
- Oracle Financial Services
- Playing a lead role in on-site Big Data consulting project which is using technologies like Hadoop,hive,Impala, Sqoop,Oozie, Pyspark, Streamsets,Unix, SQL, Oracle, XML
- JSON, Airflow, Autosys
- Experience in mapreduce, Spark and Tez execution engine
- Developed big data application
- Work experience using all the above mentioned execution engines
- Setup the infrastructure for multiple Bigdata Environment and ingested the data from relational database to HDFS system for analytics and Visualization
- Strong technical background covering Oracle PL/SQL programing and Abinitio ETL and
- Unix Technology
- Proven track record in data modelling, delivering Oracle based solutions - SQL queries
- PL/SQL code
- Identify tuning opportunities; implement improvements and advice developers on SQL tuning options
- Documenting database design using visualization tools
- Practice good analysis, design and development standards through reviews and workshops in collaboration with offshore development team members.
Software Engineer
HCL Technologies
01.2007 - 09.2008
- In depth knowledge of Oracle Architecture , Design principles, Performance tuning, normalization concepts with Database administrative experience
- Created PL/SQL Stored Procedures, Functions, Packages, and Triggers extensively used Cursors, REF cursors, User-defined object types, Records, forms and reports in
- PL/SQL programming
- Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance
- Extensively used Materialized views and DB links for remote instances to retrieve data from other databases Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, DB links and privileges
- Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers
- Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance
- Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
- Designed and developed Oracle Forms Reports using Forms and Reports 6i for client specific requirements
- Analyzed and fixed the data discrepancies between various systems and identified bad data caused due to the data migration from various legacy systems
- Involved in design and development phases of Software Development Life Cycle SDLC
- Used performance-tuning methods to increase the performance of the oracle database
- Created and modified several UNIX Shell Scripts according to the changing needs of the project requirements
- Extensively used Autosys and cron to schedule the batch process
Junior Software Engineer
Edkal Business Solutions
05.2005 - 01.2007
- Designed and implemented client-server application using Oracle Forms and Reports 6i
- Builder
- Involved in the complete development, design and Implementation of module
- Administration package for ERP (Enterprise resource Plan)
- Involved in the generation of User Interface using oracle forms by extensively creating forms and reports as per the client requirements
- Strong knowledge in performance tuning and helped team to resolve these performance issue
- Possesses experience in explain plan TKPROF, Hints,Partitioning and Indexing for performance tuning
- Developed PLSQL Procedures,Functions,Packages,Triggers and involved in SQL, PL/Sql
- Tuning
- Performed Database Administrator role for a short period in this company
- Involved in
- Total database Administration including Backup monitoring, scheduling of job (Oracle)
- Extensively utilized TOAD and SQL developer for building data driven applications.
Education
Msc -
Bioinformatics
Muthayammal College
Timeline
Principal Engineer
Fidelity Investments
01.2021 - Current
Principal Consultant
10.2008 - 01.2021
Software Engineer
HCL Technologies
01.2007 - 09.2008
Junior Software Engineer
Edkal Business Solutions
05.2005 - 01.2007
Msc -
Bioinformatics
Muthayammal College
Similar Profiles
MICHAEL O'BRIENMICHAEL O'BRIEN
FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)
Randolph Roark IIRandolph Roark II
Workplace Planning Consultant at Fidelity InvestmentsWorkplace Planning Consultant at Fidelity Investments
Richard De HoyosRichard De Hoyos
Financial 401k Representative at Fidelity InvestmentsFinancial 401k Representative at Fidelity Investments
Arturo CastilloArturo Castillo
Workplace Planning Associate at Fidelity InvestmentsWorkplace Planning Associate at Fidelity Investments
Vanessa OmaeVanessa Omae
Patient Care Technician at Methodist Midlothian HospitalPatient Care Technician at Methodist Midlothian Hospital