Mohd Raffi A Email and Phone Number

Alveo is the leader in cloud-based market data integration, analytics and Data-as-a-Service solutions for financial services.We solve data management challenges for banks, asset managers, insurers, central banks, clearinghouses, and other market infrastructure firms. Our cloud-based data management solutions provide users with self-service capabilities to quickly get the quality data they need.RDBMS : Oracle 19c,12C, PostgresqlLanguages : PL/SQL, SQL, Core JavaGUI/Tools : Putty, SQL Developer, Python,Unix, Shell scripting. Control-M, and Bitbucket,Operating System : Windows, Unix.

Coordinated with Business analysts to understand the requirements.Created the High-level, Low-level design documents for ETL logic.Created the PL/SQL packages, procedures, functions applying the business logicDesigned and developed the functionality of loading data from flat files into oracle tables using SQL Loader.Designed and developed the Transformation logic in ETL using complex join queries in PL/SQL.Designed and developed the functionality of Extracting files from oracle tables.Defect fixing.Involved in Data Modeling.Designed and developed the FATCA Reporting Solutions for IRS using PL/SQL and Unix Shell Scripting.Code review. Adhering to coding standards.Optimized the queries which involve large volumes of data.

Working as Team lead, responsibilities of which include providing estimations, Assigning Tasks to team members, delivering the code to different test environments and managing Production releases.Coordinated with Business analysts to understand the requirements.Created the High-level, Low-level design documents for ETL logic.Design and developed the functionality of loading data of ETL from flat files into oracle tables using SQL Loader.Design and developed the Transformation logic in ETL using complex join queries in PL/SQL.Design and developed the functionality of Extracting files from oracle tables.Defect fixing.Code review. Adhering to coding standards.Migration between different environments like SIT, DAT, UAT, PROD.Estimation of tasks.Optimized the queries which involve large volumes of data.

Working as Team lead, responsibilities of which include providing estimations, Assigning Tasks to team members, delivering the code to different test environments and managing Production releases.Coordinated with Business analysts to understand the requirements.Created the High-level, Low-level design documents for ETL logic.Design and developed the functionality of loading data of ETL from flat files into oracle tables using SQL Loader.Design and developed the Transformation logic in ETL using complex join queries in PL/SQL.Design and developed the functionality of Extracting files from oracle tables.Defect fixing.Code review. Adhering to coding standards.Migration between different environments like SIT, DAT, UAT, PROD.Estimation of tasks.Optimized the queries which involve large volumes of data.