Jacob Paul

• Working with L1 and L2 Teams in resolving issues and troubleshooting

• Deploying Omnia and Abnitio Codes.
• Working with stakeholders to resolve P2 issues
• Tracking recurring issues and assigning Problem Records to Development Teams

• Co-ordinating with teams in releases and walk throughs

• Documenting issues and creating knowledge base to team

• Currently in Sydney but working with offshore associates in India

• Excellent knowledge of Big Data Landscape in CBA and also familiar with Abnitio codes.

• Monitoring and supporting critical production loads.

• Creating work arounds and solutions for team to deliver data loads within SLA.

• Training and building team to increase the knowledge base of the team.

• Created ETL mappings, sessions and workflows and set dependency.
• Analysis of source data and creating mapping documents.
• Creating stage, intermediate and core mappings and workflows.
• Work with the team to resolve all defects and issues raised during the development and testing stage.
• Performance tuning of ETL workflows
• SAP BODS Upgrade from 4.2.3 to version 4.2.9 in linux environment
• In this role I was able to learn about the Mobile Industry and the apply my technical knowledge in the improvements of the current ETL jobs The team was able to meet 100% SLA on ETL Loads Received Rising Star Award for ETL related improvements in 2001
• Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
• Managed team of employees, overseeing hiring, training and professional growth of employees.
• Resolved problems, improved operations and provided exceptional service.
• Used critical thinking to break down problems, evaluate solutions and make decisions.
• Learned new skills and applied to daily tasks to improve efficiency and productivity.
• Exceeded goals through effective task prioritization and great work ethic.

• Worked extensively in the role of developer on Informatica Power Center.
• Created ETL mappings, sessions and workflows and set dependency.
• Analysis of source data and creating mapping documents of the same.
• Creating staging, intermediate and core mappings and workflows.
• Work with the team to resolve all defects and issues raised during the development and testing stage.
• Closely worked with testing team to resolve defects and informatica admins for code deployment.

• • Development of ETL mapping in stage and core using Informatica.
  • Creating ETL sessions and workflows and dependency.
  • Co-ordinate all Europe operations and worked on the onsite offshore model.
  • Requirement gathering and analyzing and documenting the same.
  • Assisting the Data Modeler in creation of the Data model and perform analysis.
  • Documenting the analysis into Low and High Level Design documents.
  • Communicate issues and resolutions to customer and get the sign off on the issues.
  • Ensure timely completion of all the deliverables and raise up issues in case on no delivery.
  • Resolve all the incidents and tickets raised by the clients.
  • Provide quick and permanent fixes to all the new issues and monitor the same.
  • Testing in development, Integration testing and in UAT and using HP Quality center
  • Creating test cases for Unit Testing, User Acceptance testing and Integration testing.
  • Migrate the codes across using the change request to test and production.
  • Complete Change Request and Release management using the Service Now Tool
  • Data profiling the manual text file using the Data flux tool and verify the quality of data.
  • Monitor all the ETL runs perform restart and recovery in case of any failure.
  • Creating ADHOC reports using Business Objects to investigate issues raised by business
  • Creating basic UNIX scripts to move the files from the staging area to the landing area.
• Underwent training on big data concept and technologies likes Vertica and HadoopUnderwent training on big data concept and technologies likes Vertica and Hadoop Started in the project as ETL developer and support engineer and later promoted to the SME Europe role in the project.
• As Team Lead the team achieved 100% SLA for consecutively for 3 months and also received the best team award.
• Worked in client location for 3 months in Breda, NetherlandsWorked in client location for 3 months in Breda, Netherlands.
• Orchestrated efficient large-scale software deployments, including testing features and correcting code.

• Analyzing requirements and translating into design by focusing on Agile methodology.
• Designed and implemented ETL process to load, clean and transform data from different sources to a single data warehouse.
• Creation of Staging, Integration and Derived Layers and Mart layers in Data warehouse.
• Cleansed and aggregated the data and used different transformations to load data in to the data warehouse.
• Completion of detailed documentation for SIT and Test Results with detailed component description.
• Resolving the Jira defects raised by the business users and implementing the fixes.
• Completed the development and testing in the planned timelines and received appreciation for the same.
• Requirement gathering, analyzing and documenting the same.
• Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance.