Amarnadh Jagu

About Amarnadh Jagu

Senior ETL and Guidewire consultant with 16 years of experience as a Technical analyst,Developer and administrator having solid experience in Insurance, Banking, Finance, HealthCare and Manufacturing domains Experience with Guidewire insurance software implementing and extending DataHub & InfoCenter data warehouse using SAP BODS ETL Tools Experience with generating the premium BI reports using SAP Business Objects reportingtool Experience in writing in Teradata scripts and query optimization. Extensive experience in IBM Info sphere Data Stage - ETL integration with SAP bankanalyzer functional module performing data extract, loading and transformation process forfinancial general ledger accounts data. Experience in designing and implementing Data Warehouse applications mainly using ETL toolTalend Data Fabric 6.2 for Big data integration and data ingestion. Extensive Knowledge and exposure on IBM Info sphere MDM PME data model, IGC(Information Governance Catalog) data governance & Information Analyzer dataprofiling and quality. Experience in UNIX file/dataset management to keep the load ready data for all financialtransactional data. Experience on Water fall and Agile methodology project implementation. Experience in functional document & HLD preparation, business & data analysis on financialsystem road map for banking products. Process improvement by performing the Quality Champion role for quality code deployment inevery month production cycle. Data processing for emphasizing on analysis, development, design, testing andimplementation of various projects for Pharmaceutical, Material Management, Banking & financial industries. Involved in complete Software Delivery Life Cycle (SDLC) in large data warehouseenvironment for financial data system. Thorough knowledge in data warehousing, dimensional modeling, data integration, datavirtualization, data synchronization, star schema, snow flake schema, ETL development & performance tuning, BI data analysis, SAP integrating, DFS & HDFS cluster segregation. Thorough domain knowledge in Banking & financial system and involved in profitabilityfinancial structure for varies banking products like Loans, Cards, Investments & Depositsfor all instruments. Key role performance on Credit & small business cards to load thedefaulting accounts into the financial module. Thorough domain knowledge on GuideWire Insurance product dimensional modelling.

Experience

1. Sr Data Warehousing and Guide Wire Developer on Datahub Infocenter

   Texas Windstorm Insurance Association

   Jun 2018 — Present · Austin, TX, US

   Analyze the existing functionality of TWIA & TFPA Business model.• Understand the Business requirements and the GuideWire data base model.• Responsible to load the data into DATA HUB & INFO CENTER from Policy Center, Billing Center & Claim Center.• Working on requirements and create the user story’s in Rally.• Working with BA’s to understand the reporting requirements.• Connecting with GuideWire product team to understand the GW out of box model.• Attending the daily scrum stand-up calls and update the status in Rally on user story’s/tasks.• Attending the Sprint planning, retrofit meetings and corresponding demos.• Frequent touch base with Product owners to understand the functional requirements.• Working with Data analyst team during the preparation of BRD & Mapping specifications?• Develop the ETL jobs using the SAP BODS tool in GuideWire insurance product.• Responsible for code deployment from central repository to UAT & Prod• Created SSIS Packages for vendor reporting like TICO.• Created Datastage jobs for custom EDW loading.• Working on POC for IBM InfoSphere DataStage 11.7.1 Service Pack 1 (SP1) on a Red Hat OpenShift Container Platform 3.11 cluster on the AWS Cloud

Education

• Indira Gandhi National Open University

  Master of Computer Applications (MCA), Computer Software Engineering

  2000 — 2002

• Acharya Nagarjuna University

  Bachelor of Science (BSc), Computer Science

  1996 — 1999

Skills

• Talend
• Business Glossary
• Unix
• Ibm Information Governance Catalog
• Extract, Transform, Load (Etl)
• Xml
• Data Migration
• Metadata Workbench
• Datastage
• Hadoop
• Data Integration
• Software Development Life Cycle (Sdlc)
• Oracle
• Requirements Analysis
• Sql
• Integration
• Big Data
• Business Intelligence