Ebin Jose

Project: Operational Metrics
Client: Wells Fargo, U.S

• Created different Data Pipeline based on client requirement to support analytics and reporting requirements.
• Worked in Agile model.
• Solving report variance issues, and addressing them with right priority.
• Working with DMI teams and clarifying the mapping documents.
• Designed and developed analytical data structures.
• Developed, implemented and maintained data analytics protocols, standards, and documentation.
• Monitoring and Maintenance the data pipelines, systems, and infrastructure to identify and resolve issues, ensuring data availability and reliability.

Project: Accounting Events Database (AED)

Client: AXA XL Insurance

• Created different ETL data flows based on client requirement used for reporting.
• Solving report variance issues, and addressing them with right priority.
• Effective debugging of mapping.
• Interacting with clients and business analysts to get clarity on the requirements and to provide value adds wherever necessary.
• Development, unit testing and integration testing.
• Involved in bug fixing during SIT and QA and also supported Functional testing, Performance testing and User acceptance testing.
• Discussing with business analysts and creation of the documents like High Level Design, Detailed Design Document, Unit Test Plan, Unit Test Result.

Project: PCA

Client: Anthem

• Implementation of logic in SQL (Teradata – BTEQ) and Informatica.
• Monitoring the loads using control – m tool.
• Figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.

Project: XC3

Client: Wellmark, US

• Analyze the business requirements and functional specifications
• Understanding thoroughly the Low Level Design and High Level Designs.
• Prepare Project Plan, Identify Source, Targets
• Identifying the data that is coming from heterogeneous sources like Oracle, Teradata, SQL server, Sybase and flat files.
• Idealize the most optimum Transformation Strategy
• Develop Mappings, Workflows and ksh script Suitable for the requirements
• Extract data from source database, Flat files and stage them into a single place and apply business logic to load them into a central Database system.
• Transform the mapping logic into Sql for Unit Testing
• Performed Pushdown Optimization to increase the read and write throughput.
• Migrated mappings and workflows from Development to Pre- Production.
• Worked on mapping re-usability using Mapping Parameters and Mapping Variables.
• Followed Informatica recommendations, methodologies and best practices.

Project: Sales Reporting System (SRS)

Client: Americo, US

• Monitoring jobs every day using Workflow monitor.
• Finding the errors when session fails and rectifying the same ASAP.
• Perform analysis and resolution of Help Desk Tickets (SCSM) and maintenance for assigned applications.
• Working on the daily tickets and issues.
• Worked on Dimension developed mappings and loaded data on to the relational database.