Jasdeep K. Email & Phone Number

United States

West Des Moines, Iowa, United States

Testing viability and feasibility of new technologies - like Confluent Connectors, Confluent Schema Registry, Confluent Topic creation process, Connector deployment using Terraform, Hackolade’s CI/CD capabilities to make data integration process easy and robust. Defined reference architecture, target state architecture, guiding principles and different design patterns for data integration and data warehousing.Designed and implemented Actuarial Data Mart to fulfill actuarial department needs; one of the largest projects in the company spanning over multiple years and phases which automated all data needs and saved almost 65% of their time. Created and implemented robust architectural Designs which helps send on-premises data to cloud snowflake database.

Des Moines, Iowa Area

Designed and implemented Enterprise Data warehouse to help fulfill reporting needs for data coming from different admin systems. Played all roles on this project starting from architect to developer.Designed and implemented operational data store on Microsoft SQL Server using Informatica Power Center for ETL to fulfill web application and other data needs. Played all roles starting from architect to developer on this project. In this project I consolidated data from five different source systems with totally different layout of data and values. All data was standardized before loading into data store.Created logical and physical data models using SAP Power Designer and worked with DBA to implement databases in Microsoft SQL server.Worked with Systems Analysts and Data modelers from source systems to perform data analysis activities to capture data requirements completely and correctly and represent them in a formal and visual way.o Created detailed technical documents for developers using Microsoft Visio and excel.o Worked with developers on daily bases to evaluate risks and impacts of the issues they are facing.o Took responsibility of complex ETL processes.

Des Moines, Iowa Area

Work with Systems Analysts and Data modelers to perform data analysis activities to capture data requirements completely and correctly and represent them in a formal and visual way.Document all data mapping rules and processes based on business requirements in data management repository.Work with lead developers on daily bases to evaluate down steam impact of current implementations.Work with users to do user acceptance testing.Act as intermediary between business and development teams when issues with downstream data arise. Recommend changes to existing code, Crystal Reports and Business Object Reports.Implemented data mart on Oracle 11g and designed and created reporting framework for CORE. Consolidated data from different sources and Created Data storage on oracle 11g using PL/SQL to Extract, transform and Load data. This project will make business reporting faster. With this implementation business don’t need to collect data from multiple sources to create and send reports to the users; 55+ reports are created and provided to end-users automatically. Created loan volume summary using Business object Webi that display performance monitoring measures for sales and sales trends.Designed and developed Auditing universe and reports to collect statics on report usage. These reports will help support team to know the usage of reports and help resolve performance issues with reports.Designed time tracking mart and reports to facilitate time management team. This process will help with better time management.

Des Moines, Iowa Area

Responsible for defining the complete data warehouse architecture. Define data and technical architectures and technical requirements for the data warehouse. Direct and design the ETL process involving data quality and testing. Write data transformation specification and ETL Design Specification.Designed and implemented Data mart on DB2 AIX and created reporting framework using Business Object WebI for the Retirement and Investment line of business with advisor centric data. Consolidated data from five different source systems using Informatica 9.1.3 to extract, transform and Load. This project made business reporting 50% faster. With this implementation business don’t need to take manual steps to collect data from multiple sources to create and send reports to end-users; reports are created and provided to end-user automatically. Created interactive scorecard with advisor summary using Business object Webi that display performance monitoring measures for sales, sales trends and retention of advisors for 150 users.Designed and implemented operational data store and campaign system on DB2 AIX using Informatica 9.1.3 for ETL for Retirement and Investment Customer relationship management. This process consolidated data from three different source systems to get customer information, their contract information and their investments to make decisions on different kind of campaigns. Based upon customer information automated campaign process was created which end up saving 20% of the costEnhanced existing Data storage architecture to utilize same data storage for multiple subject areas. Added actuarial allocated expenses and Federal income tax subject areas to existing data storage. Created conformed Dimensions so that different subject areas can use those dimensions. Designed and implemented Retirement and investment Finance pre tax operating earning centric Data Mart and reporting framework

Des Moines, Iowa Area

Designed and Implemented Enterprise Data warehouse and informational layer for Agribusiness Insurance line of business on Teradata using Informatica 7.1.3 and Bteqs for ETL. Responsible for all ETL operations including client feeds, warehouse loads, data extraction and data quality. Created multiple cubes for reporting purposes.

Menomonee Falls, Wi

Designed and implemented customer based Data Mart using DB2 and Informatica 6.1.2 ETL tool. Designed and developed Business object reporting framework. Was responsible for ETL Design specifications, transformation specification and resolving discrepancies and inconsistencies in data Mart. Responsible for performance, tuning and coordinating with data warehouse team for loading data to data mart.Designed and implemented Enterprise Data warehouse for customer information systems using DB2 database and Informatia 6.1.2 ETL tool. Analyze source data, assist data warehouse team with data cleaning and data validation. Created Systematic validation process and Test Plans for system testing. Created UNIX scripts to schedule different procedures and to generate validation reports automatically. Did Unit Testing, validation Testing and system testing of data published by ETL and created Informatica mappings, sessions and workflows in Power Center 6.2.1