John Paul Asiño Mamaril

Enhanced and developed features for Backend and Frontend of EBX (MDM Platform) Data model written in Java. Maintained MDM Data model repositories through Gitlab. Provided technical documentation through Atlassian Confluence. Participated in Daily Scrum Meeting and provided Daily status Report from Atlassian Jira Story Board. Mentored colleagues for Process flow and Development tasks. Designed architecture and Technical Documentation for current MDM platform.

Developed DataStage ETL Jobs and scripts for data migration to Salesforce. Provided Technical Documentation, Data Flow and Data Mapping for DataStage ETL jobs. Developed Control M Schedule for Automation DataStage ETL Jobs and Scripts Execution. Performed Unit Testing and System Testing, and Created Test Cases for DataStage ETL process through Qtest Test Automation tool. Developed Interfaces in DataStage ETL and ETL UNIX Framework for DataStage. Provided Technical Documentation and Analysis of ETL migration process. Demonstrated and Mentored Snowflake Database. Developed and Analyzed ETL Migration process for current DataStage version to latest Version. Provided Technical Documentation and Analysis of Snowflake Databases. Developed and Technical Documentation of SAP Business Object Report into Control M Scheduling job. Provided Brownbag Training for ETL migration process and ETL UNIX framework for DataStage. Created new Design Process and provided Technical Documentation for Optimize DataStage ETL Process.

Designed and developed automation tool for testing, analysis, estimation, and documentation, successfully decreasing the need for human control and providing accurate performance results. Improved workflow efficiency through designing and developing automation tools. Conducted trainings regarding the use of technologies developed by the IT team. Responded efficiently to project demands by managing multiple technologies. Provided technical solution and designs, improving productivity and minimizing timeline delays. Designed and developed mainframe interfaces and job automation tool for other ETL migrations projects.