Riyaz Sadikot

A Technical person with 8+ years of experience in the Information Technology Industry. Able to prioritize work effectively and achieve objectives within established timing, communicates effectively with all levels in the organization and able to execute upon objectives, Sound in analytical and problem-solving skills, Quick adaptability to new environment, Willingness to take up new challenges and a Team Player. Technical expertise in creating complex SQL queries, PLSQL, Performance Tuning, ETL architecture, Business Intelligence (BI) concepts, Data Analytics, Postgresql.

• Johnson & Johnson - Global Pricing Data Lake, Extracting and Ingesting data from different sources like Postgres, Oracle, Redshift DB’s using Python Framework. Implementing transformation logic while ingesting the data as per the requirements. Direct interaction with our client for requirement gathering, regular progress updates, providing the outcome as per the requirement and providing support on the deliverables. Code review for other team members. Worked as a backup Manager in absence of my Project Manager. Technologies Used - Amazon Redshift, AWS S3, DBeaver, Shell Scripting, Python.
• Banner Health - ESI, Extraction and loading data files from AWS S3 to postgres using DAP ETL tool. Implementation of transformation logics from L0 to L1 to L2 using postgresql queries. Code review. Data analysis to provide data insights to business for further refining of the requirements. Deploying the code into Production and providing KT to the support team. Technologies Used - DAP, Postgresql, DBeaver, AWS S3.
• Department of Commercial Taxes for the Government of Tamil Nadu State Authority (TCS - Gandhinagar), Understanding business requirements and design from onsite team\Business. Performance tuning of the report queries. Data Analytics. Creating new Data Marts out of the DWH tables as and when required. Created tracking mechanism to track the automated execution of each Data Marts. Creating, sending, and keeping a record of BI related patches sent to onsite for Production Deployment. On-boarding and mentoring of new team members. Technologies Used - Postgresql, Pgadmin, Eclipse.
• Customs Information System (TCS - Gandhinagar), Understanding the business requirements and design from onsite team\Business. Performance tuning of the report queries. Data Analytics. Creating, sending and keeping a record of BI related patches sent to onsite for Production Deployment. Technologies Used - Postgresql, Pgadmin, Eclipse.
• SMG3 application Support (TCS - Kolkata), Tracking and monitoring of daily Informatica jobs. Creating a ticket and redirecting it to the respective teams using Service Now tool if any daily job fails. Monitoring, analysis and resolution of the ticket raised. Validating the data once all Informatica job gets completed by executing SQL queries in Toad. Technologies Used - Toad, SNOW, Informatica.
• Training – Initial Learning Program (TCS – Trivandrum), Training in BI concepts, Data warehousing, ETL and Reporting. SQL/PLSQL., Informatica and Business Objects.

Date of Birth: 12/13/91.

Hobbies: Video Games, EDM, Foodie.

Strengths:

• Strong analytical ability and problem-solving skill, Quick learner.
• Supportive team player with willingness to take up new challenges.
• Flexible – Adaptability to dynamic environment.
• Positive attitude, Honest, Confident.