Informatica Developer
Resume:
Mark Anthony H. Nasuli
Block * Lot ** Jade Street Hilltown Residences
Fortune, Marikina City
Mobile: +639*********
Email: *****************@*****.***
AREAS OF INTEREST
• ETL Development
EDUCATION
Tertiary: Bachelor of Science in Mathematics
University of the Philippines, Diliman
2006 – 2010
Graduated April of 2010
Secondary: Our Lady of Perpetual Succor College.
Concepcion Dos, Marikina City.
2002-2006
Graduated March of 2006
PROFESSIONAL EXPERIENCE /PROJECTS HANDLED
• Accenture (January 2019 – Present)
Associate Manager (January 2019 – Present)
PROJECT: Data Warehouse
DURATION: January 2020 – Present
CLIENT INDUSTRY: Products
DESCRIPTION: Team Lead
TECHNOLOGY: Informatica Powercenter 10, Oracle
ROLE/S: Team Lead (January 2020 – Present)
• Assign tasks to team members
• Technical lead of the team
• Review specifications and code done by the team members
• Align with onshore team for the tasks to be assigned to the team
• Perform development and testing
• Quality Assurance lead of the project
PROJECT: Data Warehouse
DURATION: June 2019 – December 2019
CLIENT INDUSTRY: Products
DESCRIPTION: Team Lead
TECHNOLOGY: Informatica Powercenter 10, Oracle
ROLE/S: Team Lead (June 2019 – December 2019)
• Assign tasks to team members
• Technical lead of the team
• Review specifications and code done by the team members
• Align with onshore team for the tasks to be assigned to the team
• Perform development and testing
PROJECT: Data Migration for a Health Company
DURATION: January 2019 – May 2019
CLIENT INDUSTRY: Healthcare
DESCRIPTION: Solutions Designer
TECHNOLOGY: Microsoft SQL Services
ROLE/S: Solutions Designer (January 2019 – May 2019)
• Created the technical and functional solution for a data migration project
• Arch Global Services Incorporated (May 2017 – December 2018) Data Integrator III (May 2017 – December 2018)
PROJECT: Data Warehouse
DURATION: May 2017 to December 2018
CLIENT INDUSTRY: Banking
DESCRIPTION: ELT Developer
TECHNOLOGY: Informatica 10, Microsoft SQL Services, Batch Scripting ROLE/S: Informatica Developer (May 2017 – December 2018)
•Creates the necessary documents for the whole development process which includes technical design document, unit test scripts and migration documents
•Define sources/targets (Database and flat files) connections.
•Designs and develops Informatica Powercenter mappings, seesions and workflows.
•Analyze and troubleshoot invalid mappings, sessions, and workflows.
•Utilize log files and debugging to fix mapping errors.
•Validate mappings results using complex SQL queries.
•Modify mappings, sessions and workflows for enhancement purposes.
•File all necessary requests for code migration and implementation
•Recommendation of efficient procedures or strategies to enhance data processing.
•Creation of data quality process if required in the project.
•Creation of data error handling process if required in the project.
• MPP Data Integration/Infosemantics Asia (July 2015 – April 2017) ELT Developer (July 2015 – April 2017)
PROJECT: Financial Analytics
DURATION: July 2015 to April 2017
CLIENT INDUSTRY: Banking
DESCRIPTION: ELT Developer
TECHNOLOGY: Teradata 13, Teradata Decision Expert, Teradata GCFR Process ROLE/S: ELT Developer (July 2015 – April 2017)
•Creates the necessary views/tables for the ELT process
•Creates the necessary Teradata BTEQ scripts for the ELT process
•Develop TDE code for ELT
•Perform Unit Testing
•Prepare documents for migration
• IBM (July 2013 – July 2015)
ETL (Informatica) Consultant (July 2013 – July 2015) PROJECT: Client's IM
DURATION: July 2013 to July 2015
CLIENT INDUSTRY: Healthcare
DESCRIPTION: ETL Informatica Developer
TECHNOLOGY: Informatica Powercenter 9, UNIX, Teradata 13 ROLE/S: ETL Developer / Analyst (July 2013 – July 2015)
•Creates the necessary documents for the whole development process which includes technical design document, unit test scripts and migration documents
•Define sources/targets (Database and flat files) connections.
•Designs and develops Informatica Powercenter mappings, seesions and workflows.
•Analyze and troubleshoot invalid mappings, sessions, and workflows.
•Utilize log files and debugging to fix mapping errors.
•Validate mappings results using complex SQL queries.
•Modify mappings, sessions and workflows for enhancement purposes.
•File all necessary requests for code migration and implementation
•Recommendation of efficient procedures or strategies to enhance data processing.
•Creation of data quality process if required in the project.
•Creation of data error handling process if required in the project.
•Creation of UNIX shell scripts for pre or post processing of source/target (database and flat files).
•Creation of UNIX shell scripts for mailing of the log files of the result of the integration
• Accenture (June 2010 – July 2013)
Level 2 Support Analyst (July 2010 – September 2011) ETL (Informatica) Consultant (September 2011 – July 2013) PROJECT: Vale Legacy
DURATION: July 2010 to July 2013
CLIENT INDUSTRY: Mining, Steel, Energy and Logistics DESCRIPTION: Vale Legacy Service Support Level 2 team (July 2010 – September 2011)/Vale Legacy Data Integration team (September 2011 - Present)
TECHNOLOGY: Lotus Notes 6.5, Informatica Powercenter 8.6.1, Oracle 10g, Toad for Oracle version 9, HP-UNIX platform
ROLE/S: ETL Developer / Analyst / Technical Lead (September 2011 – July 2013)
•Coordinate business processing specifications and enhancements to functional team.
•Define sources/targets (Database and flat files) connections.
•Designs and develops Informatica Powercenter mappings, seesions and workflows.
•Analyze and troubleshoot invalid mappings, sessions, and workflows.
•Utilize log files and debugging to fix mapping errors.
•Validate mappings results using complex SQL queries.
•Modify mappings, sessions and workflows for enhancement purposes.
•File all necessary service requests to help desk.
•Recommendation of efficient procedures or strategies to enhance data processing.
•Creation of data quality process if required in the project.
•Creation of data error handling process if required in the project.
•Creation of UNIX shell scripts for pre or post processing of source/target (database and flat files).
•Creation of UNIX shell scripts for mailing of the log files of the result of the integration
•Performs migration to Q.A environment from development environment.
•Performs extensive testing in Q.A environment.
•Provides analysis for problems occurring in the production environment
•Documents necessary updates and test results for a project.
•Conducted Informatica Powercenter trainings.
•Conducted basic ETL concepts trainings
•Makes sure that all integration built by the team followed the agreed process and with the best quality
•Creates the necessary documents for the whole development process Level 2 Support (Lotus Notes based Applications) / Subject Matter Expert
•Identifies and solves critical issues in the production environment within a limited amount of time and meeting agreed SLA’s
•Fix existing problems in the production environment and providing enhancements for the application
•Subject Matter Expert for almost all of the Lotus Notes applications used by the client
•Create knowledge bases for all the issues encountered in the production environment TECHNICAL SKILLS
Programming: Basic knowledge in Microsoft Visual C++ Basic Knowledge in Visual Basic 2005
Skilled in Microsoft Excel Macros
Basic knowledge in Java
Skilled in UNIX Scripting
Database Management: Skilled in Data Integration
Knowledgeable in Business Intelligence
Skilled in Oracle
Basic knowledge in Teradata
ETL tools: Skilled in Informatica Powercenter 8.6.1 Skilled in Informatica Powercenter 9.1.2
Basic knowledge in Informatica Developer
Basic Knowledge in Terada Decision Expert
Operating Systems: Microsoft Windows 98/XP/Vista/Windows 7 UNIX
Scripting: Skilled in Unix Scripting
Skilled in Lotus Notes Scripting
Basic knowledge in Teradata BTEQ scripting
Applications: Microsoft Word, PowerPoint and Excel Other Skills: Fluent in English and Filipino, both oral and written has good communication skills
Intermediate level in Brazilian Portuguese language TRAININGS AND SEMINARS ATTENDED
UNIX Basic UNIX Commands and Shell Scripting
SQL Basic SQL Command
INFORMATICA Basic Informatica 8.6.1 Administration and Development Business Basic Knowledge about Business Intelligence Intelligence
Teradata Basic Teradata concepts
Testing Application Testing Concepts
HONORS AND AWARDS:
Kalinga - People Developer (Company Level - Nominee) September 2011
Accenture - Vale Legacy Project
This reward and recognition is awarded to those people who becomes an instrument in the achievement of team goals within the project
Agila – Business Operator (Company Level - Nominee) September 2012
Accenture - Vale Legacy Project
This reward and recognition is awarded to those people who encourage team buildups and ensuring that delivery center’s goal are everyone’s goal People Developer (Project Level)
Accenture - Vale Legacy Project
This reward and recognition is awarded to those people who becomes an instrument in the achievement of team goals within the project
Business Operator (Project Level)
Accenture - Vale Legacy Project
This reward and recognition is awarded to those people who becomes an instrument in the achievement of team goals within the project
Value Creator (Project Level)
Accenture - Vale Legacy Project
This reward and recognition is awarded to those people who becomes an instrument in the achievement of team goals within the project
CHARACTER REFERENCE:
Gian Paolo B. Velasquez
Consulant
Teradata Philippines
*********.*********@********.***
Sharon C. Chan
Associate Manager
ACCENTURE PHILIPPINES
******.*.****@*********.***
Hencelita Sotelo.
Team Lead
IBM PHILIPPINES
*******@**.***.***
Contact this candidate