Joman Manuel Email & Phone Number

• Design, code, and maintain new complex SQL stored procedures andfunctions.
• Review SQL code written by other developers to ensure complianceto coding standards and best practices as well as maximumperformance.
• Work with other engineers to troubleshoot, repair, and performancetune databases.
• Perform data analysis and data profiling tasks to provide support andrecommendations for development and design decisions.
• Create SSIS packages for data transformation, cleansing, caching,aggregation, staging, and transfer.
• Define, prepare, execute, and implement data validation and unittesting methods to ensure data quality

- Creation of Stored Procedures for Import and Export Processes. - Creation of Invoicing feeds based on client's technical specification documents using SQL and.net code. - Production support if there are any bugs related to financial invoicing. - ETL using SSIS and Azure Data Factory when necessary. - Providing data dictionary and requirement documentation.

Pasig, National Capital Region, Philippines

(Bank Client)- Extract, Transform, Load of data from different sources andtargets- Creation of optimized and advanced SQL queries - Automation of ETL processes using Informatica Big Data Management- Providing end-to-end service to business - Creation of dashboard using PowerBI and Tableau- Providing data and requirement/project documentation

Pasig, National Capital Region, Philippines

(Telecom Client)- Data Migration- Stored Procedures and other SQL Scripts Optimizations- Data Analysis- Data Reconciliation- Data Cleansing- Product Translation and Validation- Optimized migration Scripts with around 60% or 12 hours timesavings- The 99 Perspiration Award 2020: For the optimization of migrationscripts for faster and efficient utilization of.

Makati, National Capital Region, Philippines

- Designing and developing database architechtures- Creating stored procedures, triggers, functions and other database objects when needed - Database Administration/Maintenance- Providing database/SQL assistance to other software developers- Coordinate with project management staff on database development timelines and project scope- Created scripts and.

Muntinlupa City, National Capital Region, Philippines

- Create or alter queries based on report requirements- Manipulate and analyze data from varying function sources using avariety of tools and data analysis techniques - Creating or enhancing of reports or templates based on businessrequirements