Dipu Kumar

• Developed API Gateway for Markit Wire and TradeServ, triggering Lambda functions to push data to Kinesis Stream.
• Utilized Glue ETL jobs to store and analyze data in a data lake, leveraging Athena and QuickSight.
• Wrote PySpark code for Glue jobs, configured CloudWatch event triggers for failure notifications, and integrated data feeds into Snowflake.
• Worked with Oracle databases to integrate and optimize data flow into the data pipeline.
• Created Lambda functions to send CSV files to clients via email

Role in Project: OutSystems Developer.

• Involved in creating user interfaces for all activities, and enhancing/bug-fixing existing code based on requirements.
• Responsible for sending mail to bidders, as well as working on push notifications and webhooks.

Role in project: Oracle APEX and PL/SQL Developer.

• Designed user interfaces for various activities, such as creating products and using Oracle Apex.
• Utilized the Apex Mail package to send emails.
• Developed procedures, functions, views, table functions, and other PL/SQL components to enhance existing packages.

• Developed Oracle PL/SQL packages to call Microsoft web services for retrieving calendar availability and scheduling meetings.
• I created a user interface using Oracle APEX.
• Wrote advanced SQL queries, utilizing Oracle analytic functions for complex data transformations.

• Developed and modified database objects (e.g., synonyms, indexes, triggers), and created a UI using Oracle Forms.
• Integrated Pentaho ETL to automate data extraction, transformation, and loading, ensuring seamless data synchronization across systems.
• Collaborated with the business team to gather requirements, and prepared SRS and SDD documents detailing functional flows and design.