BERNARD ALPHONSE

Project Description :

Nordea Bank : This is European financial services group and the largest financial group in the Nordic countries. Common data warehouse is to integrate Finance, Risk and Treasury data and reporting in order to respond to industry demand and deposit guarantee covers private individuals, companies and other legal entities

• Developed Store Procedures using javaScript API / SQL Scripting and creating the snowflake complex queries.
• Created Internal and External stages and transformed data during load.
• Experienced in handling of structured and semi structured data loads and unloads into snowflake DW
• Involved in zero copy cloning ( Cloning databases for dev and QA environments )
• writing complex snowflake scripts in snowflake cloud data warehouse to business analysis and reporting.
• Hands-on experience with Snowflake utilities , SnowSQL and SnowPipe
• Participates in the development improvement and maintenance of snowflake database application
• Used temporary and Transient tables for different databases ( Staging )
• Hands on experience on creating the snowflake regular views and materialized views

Project Description :

Hartford is a United States-based investment and insurance company and they sell products primarily through a network of agents and brokers.

• Developed PL/SQL packages, procedures, functions and collections to implement business logic.
• Worked in Production Support Environment as well as QA/TEST environments for maintenance requests, bug fixes, enhancements and data changes.
• Responsible for deploying the SSIS packages and scheduling package through jobs and Expert in writing Dax query and MDX QUERY
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services SSAS

Project Description : BIP application is to maintain the Budget management, Recording consumed elements, tracking the activity, Contractual management and Financial functions.

• Developed PL/SQL packages, procedures, functions and Collections to implement business logic.
• Performed modifications on existing reports as per change request.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes
• Extensively used bulk collection in PL/SQL objects for improving the performing and Improved the performance of the application by rewriting the SQL queries.

Project Description: This report is to maintain and support the travel and expense report for ford employee and system keeps track of day-to-day customers operations like deposits, withdrawals and payments for the customers as well as the employees.

• Improved the performance of the application by rewriting the SQL queries.
• Performed modifications on existing document as per change request and maintained it.
• Worked in Procedures, Functions, Packages and Unix shell scripts and cron job and involved in the continuous enhancements and fixing of production problems.

Project Description: Cisco wants to perform set of enhancements (Supervisor level filtering) to set of existing CUIC based UCCX Historical reports and to modify the existing report templates with supervisor level filtering

• Developed and modified triggers, packages, functions and stored procedures for data conversions.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links
• Involved in Unit testing and Functional Testing.

Project Description: Vietnam bank is a government bank which provides welfare measures for the people. We developed in lending application which helps to provide loan to different customers. It includes all the activities like Booking, Disbursal, Payment, Early Settlement, schedule, reschedule.

• Involved in maintenance support, monitoring and basic tuning.
• Performance tuning of Oracle Databases and User applications
• writing complex SQL queries using TOAD and SQL developer and involved in the continuous enhancements and fixing of production problems.
• Worked on in Sequences, Views, Procedures, Functions, Packages, PL/SQL Collections, Ref Cursor and Bulk collect