Jyoti

Jyoti

Senior Software Engineer with Proven Experience in Data Engineering, SQL, and ETL Tools
United Arab Emirates
English

About Me

I value continuous learning and often find myself diving into new topics or hobbies—whether it's reading books, learning new software tools, or experimenting with different types of creative projects. I also believe in m…

Experience

Senior Software Engineer

Clover Infotech Pvt. Ltd.
Nov 2023 - May 2024 · 6 months

Led the design, development, and maintenance of data warehouse and ETL processes.
Collaborated with the business intelligence team to understand data requirements and implemented SSIS packages to meet organizational needs.
Demonstrated strong work ethic by consistently meeting deadlines and surpassing performance expectations.
Conducted database and query optimization to enhance system performance.
Developed a solution to notify clients in case of API failure, ensuring timely communication and prompt issue resolution.
Created comprehensive documentation outlining ETL processes.
Developed and deployed Microsoft SSRS reports for business insights.

Senior Software Engineer Remote

Clover Infotech
Aug 2023 - May 2024 · 9 months

Senior Software Engineer
Client - Star Union Dai-ichi (SUD) Life Insurance Company Limited 20th November 2023 to 31st May 2024
• Led the design, development, and maintenance of data warehouse and ETL processes.
• Collaborated with the business intelligence team to understand data requirements and implemented SSIS packages to meet organizational needs.
• Demonstrated strong work ethic by consistently meeting deadlines and surpassing performance expectations.
• Conducted database and query optimization to enhance system performance.
• Developed a solution to notify clients in case of API failure, ensuring timely communication and prompt issue resolution.
• Created comprehensive documentation outlining ETL processes.
• Developed and deployed Microsoft SSRS reports for business insights.

Client – ICICI Bank 1st June 2023 to 15th November 2023
Oracle Financial Services Analytical Applications OFSAA DOM (Domestic)
• Utilized ODI (Oracle Data Integrator) to optimize data validation and transformation processes based on ELT architecture, delivering high performance and cost-effective solutions to the business.
• Designed and developed interfaces, packages, and load plans to ensure seamless data integration and efficient processing
• Ensured correctness and completeness of Data loading (Incremental load and Dump Load).
• Ensured timely completion of tasks and conducted post-deployment analysis at the production level, following the project plan.
• Resolved complex, long-standing PCFC (Pre-shipment Credit in Foreign Currency) issues ensuring timely progress and improved efficiency.
• Created detailed ETL specification documents and optimized ETL execution time by implementing best practices for interface performance.
• Coordinated with ODI Lead and Business Analyst to ensure implementation aligned with requirements, and collaborated with Data Modeler and team members to clarify mappings

Oracle Financial Services Analytical Applications OFSAA DOM (Domestic)

ICICI Bank
Jun 2023 - Nov 2023 · 5 months

Utilized ODI (Oracle Data Integrator) to optimize data validation and transformation processes based on ELT architecture, delivering high performance and cost-effective solutions to the business.
Designed and developed interfaces, packages, and load plans to ensure seamless data integration and efficient processing.
Ensured correctness and completeness of data loading (Incremental load and Dump Load).
Ensured timely completion of tasks and conducted post-deployment analysis at the production level, following the project plan.
Resolved complex, long-standing PCFC (Pre-shipment Credit in Foreign Currency) issues ensuring timely progress and improved efficiency.
Created detailed ETL specification documents and optimized ETL execution time by implementing best practices for interface performance.
Coordinated with ODI Lead and Business Analyst to ensure implementation aligned with requirements, and collaborated with Data Modeler and team members to clarify mappings and other details.

OAC Analyst Cloud Developer

HDFC Bank
Sep 2022 - May 2023 · 8 months

Designed and architected OAC projects, including upgrades and migrations to the cloud.
Developed, tested, and implemented various reporting solutions.
Designed and built Oracle Analytics Server (OAS) repositories - RPD data models.
Addressed and resolved reporting issues resulting from cloud migrations.
Collaborated with cross-functional teams to develop robust reporting solutions.
Documented processes and procedures for assigned areas of responsibility.

Assistant Professor

K J Somaiya College of Engineering, Vidyavihar, Mumbai
Sep 2021 - Aug 2022 · 11 months

Assistant Professor

SIES Graduate School of Technology, Navi Mumbai
Mar 2021 - Aug 2021 · 5 months

Assistant Professor

K J Somaiya College of Engineering, Vidyavihar, Mumbai
Jul 2016 - May 2019 · 2 years 10 months

Teaching Assistantship

Sinhgad College of Engineering, Pune
Aug 2012 - Jun 2014 · 1 year 10 months

Skills

Program Development Database Packages: SQL Server Management Studio (SSMS) Postgres MySQL Oracle 12c Oracle 11g Google Firebase SQLite MongoDB MS Access Microsoft Database Server ETL Tools: SQL Server Integration Services (SSIS) Oracle Data Integrator (ODI) 12c Report-making Tools: Oracle Analytics Cloud (OAC) SQL Server Reporting Services (SSRS) Web Technology: PHP HTML5 CSS3 Bootstrap JavaScript jQuery AJAX XML Basics of Node JS VBScript SQL T-SQL PL/SQL ETL SQL Server Integration Services (SSIS) Oracle Data Integrator (ODI) Database design Database optimization Database analysis SQL Server Management Studio (SSMS) Postgres MySQL Oracle 12c Oracle 11g Google Firebase SQLite MongoDB MS Access Microsoft Database Server Oracle Analytics Cloud (OAC) SQL Server Reporting Services (SSRS) PHP HTML5 CSS3 Bootstrap JavaScript jQuery AJAX XML Node.js VBScript XAMPP Microsoft Excel
Report this Profile?