Rab Nawaz Email & Phone Number

Los Angeles, California, United States

Extracted data using SQL scripts from Legacy system Oracle 12c and placed at HDFS in Flat File format. Transferred data from Flat files to PostgreSQL by performing ETL process using Snaplogic Tool.Developed Snaplogic pipelines to crosswalk the data between different modulesDeveloped notebooks to validate the data in PostgreSQLDeveloped pipelines to log data into PostgreSQLDesigned and Built Data Marts for different Modules (FIN,SCM,HCM) for data Staging in PostgreSQL.Designed and Built Database for Employee Bank information and validated Bank information using RestAPI snaplogic snaps.Wrote complex SQL scripts using Joins, User Defined function, Procedure and triggers to data look up the data between different entities.Did the troubleshooting for Snaplogic pipelines and notebooks.Performed pushdown optimization and parallel processing for large data files.Performed query tuning and optimizationWorked on Enterprise Data Warehouse application, to process data from Source systems i.e. Flat, PostgreSQL and Oracle files and processes to the Oracle Fusion Cloud Test and Production database.Worked on Oracle Fusion Cloud application.Designed and implemented end-to-end data integration workflows using Snaplogic pipelines to ensure seamless data flow across disparate sources.Conducted troubleshooting and debugging of Snaplogic pipelines, utilizing Dashboard logs and monitoring to identify and resolve issues.Utilized Snaplogic IPaaS to design and develop Extract, Transform, Load (ETL) processes for OLAP data integration, ensuring seamless flow of data from diverse sources to Target Database.Implemented indexing and other database optimizations to enhance the efficiency of PL/SQL queries.Developed and implemented Online Analytical Processing (OLAP) solutions using Snaplogic, ensuring efficient data analysis and reporting capabilities.

Los Angeles Metropolitan Area

Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughsImplemented caching mechanisms and parallel processing techniques to enhance the overall efficiency of OLTP data transactions.Created and managed source to target mapping document for all facts and dimension tablesUsed ETL methodologies and practices to create Snaplogic Pipelines. Followed and enhanced programming and naming standards.Collaborated with business analysts and stakeholders to understand data requirements and translated them into snaplogic pipelines, ensuring accurate data mapping and transformation.Tuned and optimized existing PL/SQL code for enhanced performance, ensuring smooth and efficient data processing.Scheduled and orchestrated Talend jobs using Manager optimizing job execution to meet business requirements.Implemented metadata management practices within Snaplogic Manager, documenting data sources, transformations, and job dependencies.Designed, developed, and implemented end-to-end data integration solutions using Snaplogic IPaaS. Created and optimized PL/SQL scripts and stored procedures for data manipulation, extraction, and transformation.Created and deployed physical objects including custom tables, custom views, stored procedures and indexes to PostgreSQL for Staging and Data-Mart environmentDesigned and Implemented ETL for data load from heterogeneous sources to Salesforce, PostgreSQL , SQL Server and Oracle Target databases and for Fact and slowly Changing Dimensions SCD-Type1 and SCD-Type2

Phoenix, Arizona, United States

Gathering information, design HLD and LLD for MRP/MRV Program.Create ETL process, design ETL Load daily 25 files from 8 different source system i.e. SQL Server 2008, Flat Files, Oracle 10g and XML Files.Understanding Waterfalls methodology, design waterfall techniques in our Data model for MRP/MRV application.Develop new Informatica mappings, workflows, sessions and mapplets for data control.Responsible for code review for Developers Coordination between development, QA and Business team.Worked on Informatica 9.6.1. Create folders, export metadata for various objects in XML files and import them in the different Repository.Load data from Flat File , clean files by using normalizer and perform various tasks, move data to oracle database.Writing Shell script for file validation i.e. file layout, number of columns check, rows, empty file check etc.Creating expression, router and filter transformation.Creating parameters, timer and workflows.Create jobs in Autosys, monitor and check the logs for any failure.Creating stored procedures. Function in oracle database.Create Metadata tables in the database for various files i.e. file name, workflow running, session information number of rows inserted in the database table

Bachelor In Science, Computer Science

Master Of Science - Ms, Computer Scie