Mohammed Faiyaz

Technical Lead and Functional analysts to understand the functional requirements and from there designed the Technical specifications.
Worked with complex flat files and snowflake in the process of extraction of data.
Worked in an environment which involved of different source/target systems like AWS and Flat files.
Developed the jobs and documented by following the ETL standards.
Involved in creation of development Code review check list and Process flow documents. Designed and developed the QA test case.
Implemented complex SQL to transform staging and validate the data.
Unit testing and Integration testing the individual and extract-transform-load jobs in sequence respectively at TMC.
Extensively used TMC to be schedulingthe job to run.
Used Job Sequencers to run the jobs sequentially and reporting.
Exported and imported the jobs between the development, QAand Prod servers
Involved in S.I.T (System Integration and Testing) and U.A.T (User Acceptance Testing). Supported Data Reconciliation team during the data recon process
Extensively used SQL coding for overriding the generated SQL in Snowflake.
Needs to write the SQL query to run the jobs at TMC as per the client requriment
Developed jobs using the stages like Sequential file, Dataset, staging table to View table.
Needs to identify history data is available or not at View table / main table.
Follow up Scrum, Scrum call, Scrum Master.

Technical Lead and Functional analysts to understand the functional requirements and from the redesigned the Technical specifications.
Worked with complex flat files and snowflake in the process of extraction of data.
Worked in an environment which involved of different source/target systems like AWS and Flat files.
Developed the jobs and documented by following the ETL standards.
Involved in creation of development Code review checklist and Process flow documents.
Designed and developed the QA test case.
Implemented complex SQL to transform staging and validate the data.
Unit testing and Integration testing the individual and extract-transform-load jobs in sequence respectively at TMC.
Extensively used TMC to be scheduling the job to run.
Used Job Sequencers to run the jobs sequentially and reporting.
Exported and imported the jobs between the development, QA and Prod servers.
Involved in S.I.T (System Integration and Testing) and U.A.T (User Acceptance Testing).
Supported Data Reconciliation team during the data recon process.
Extensively used SQL coding for overriding the generated SQL in Snowflake.
Need to write the SQL query to run the jobs at TMC as per the client requirement.
Developed jobs using the stages like Sequential file, Dataset, staging table to View table.
Need to identify history data is available or not at View table/maintable.
Followup Scrum, Scrum call, Scrum Master.

Designed the technical design documents from Functional specifications.
Worked with Project Lead, Technical Lead and Functional analyst to understand the functional requirements and from the redesigned the Technical specifications.
Worked with complex flat files and Database in the process of extraction of data.
Worked in an environment which involved of different source/target systems like Oracle and Flat files.
Developed the jobs and documented by following the ETL standards.
Involved in creation of UTPs, Code review checklist and Process flow documents.
Designed and developed the QA test case.
Implemented complex logics in Transformer stage like date validation, use of stage variables.
Unit testing and Integration testing the individual and extract-transform-load jobs in sequence respectively.
Extensively used Autosys for scheduling the cron job to run.
Used Job Sequencers to run the jobs sequentially and reporting by using Log Catcher.
Exported and imported the jobs between the development, QA, Pre-prod and Prod servers.
Involved in S.I.T (System Integration and Testing) and U.A.T (User Acceptance Testing).
Supported Data Reconciliation team during the data recon process.
Extensively used SQL coding for overriding the generated SQL in Oracle and also tested the data loaded into the database.
Developed jobs using the stages like Sequential file, Dataset, ODBC stage, Lookup, Join, Match grouping, Suspect Records, Tokenization and Dekenization, MD5 etc.
Followup Scrum, Scrum call, Scrum Master.

Designed the technical design documents from Functional specifications.
Worked with Project Lead, Technical Lead and Functional analyst to understand the functional requirements and from the redesigned the Technical specifications.
Worked with complex flat files in the process of extraction of data.
Worked in an environment which involved of different source/target systems like Oracle and Flat files.
Developed the jobs and documented by following the ETL standards.
Involved in creation of UTPs, Code review checklist and Process flow documents.
Designed and developed the Internal Auditing jobs.
Implemented complex logics in Transformer stage like date validation, use of stage variables.
Unit testing and Integration testing the individual and extract-transform-load jobs in sequence respectively.
Used Job Sequencers to run the jobs sequentially and reporting the Status of the Job through Email.
Involved in S.I.T (System Integration and Testing) and U.A.T (User Acceptance Testing).
Supported Data Reconciliation team during the data recon process.
Used the Client components Designer, Director and Administrator.
Developed jobs using the stages like Sequential file, Dataset, ODBC stage, Lookup, Join, Aggregator, thash, tbuffer, RemoveDuplicates, FTP.

Project deployment, operations handover, Training, and Exposure to the full cycle of Maintenance.
Infrastructure and documentation with direct client communication on root cause analysis.
Maintaining multiple applications, keen understanding of SQL Server 2012 and Windows server production environments.
Solving Technical and Product related issues.
Analyzing the performance of our Application concerning Database.
Testing the Modules of Application before releasing to the client.
Maintaining the Admin site and Self-care.
Handling the user escalations directly and resolving issues.
Creating the Schemas and users in Database.
Customer Administration tool used to create new groups, roles for clients and authorizethem to view reports.

Technical Lead and Functional analyst to understand the functional requirements and from there redesigned the Technical specifications.
Worked with complex flat files and Snowflake in the process of extraction of data.
Worked in an environment which involved different source/target systems like AWS and Flat files.
Developed the jobs and documented by following the ETL standards.
Involved in creation of development Code review checklist and Process flow documents. Designed and developed the QA test case.
Implemented complex SQL to transform staging and validate the data.
Unit testing and Integration testing the individual and extract-transform-load jobs in sequence respectively at TMC.
Extensively used TMC to be scheduling the job to run.
Used Job Sequencers to run the jobs sequentially and reporting.
Exported and imported the jobs between the development, QA, and Prod servers.
Involved in S.I.T (System Integration and Testing) and U.A.T (User Acceptance Testing). Supported Data Reconciliation team during the data recon process.
Extensively used SQL coding for overriding the generated SQL in Snowflake.
Needs to write the SQL query to run the jobs at TMC as per the client requirement.
Developed jobs using the stages like Sequential file, Dataset, staging table to View table.
Needs to identify history data is available or not at View table/maintable.
Follow-up Scrum, Scrum call, Scrum Master.