Eshwar Janapareddy Email & Phone Number

Coventry, England, Gb

Rugby, Gb

London Area, United Kingdom

• Experienced in designing and development of data migration pipelines for multiple entities (Source Systems output files --> SSIS Packages, SQL Stored Procedures --> Kingswaysoft --> D365 F&O) from legacy ERP system - Oracle • Designed data pipelines to cleanse, transform the data, and backfill/enrich the data wherever required during the data migration• Implemented Obfuscation logic for PI data in the Data migration pipelines as per mapping templates by using Kingswaysoft… Show more • Experienced in designing and development of data migration pipelines for multiple entities (Source Systems output files --> SSIS Packages, SQL Stored Procedures --> Kingswaysoft --> D365 F&O) from legacy ERP system - Oracle • Designed data pipelines to cleanse, transform the data, and backfill/enrich the data wherever required during the data migration• Implemented Obfuscation logic for PI data in the Data migration pipelines as per mapping templates by using Kingswaysoft Data Anonymizer and SQL server Store procs • Designed SSIS packages to handle the loading of both obfuscated and unobfuscated data into multiple env – DM, Validation, UAT, Trial Cut-over env • Connecting with business, Implementation partner and UAT team to resolve issues/defects/configuration during data loads• Running Cut-Over Data Migration packages, debugging and analysing failures, providing post-production support to business Show less

Bournemouth, England, United Kingdom

• Experienced in designing and development of complete data migration pipeline (Source Systems --> SQL Server (Views, Stored Procedures, T-SQL) --> Azure Data Factory --> D365 CE, D365 F&O, D365 Field Service from legacy systems such as SAGE, OpenCRM, SimPro• Designed data pipelines to cleanse the data to close any gaps in the missing data and transform data wherever required namely, deduplication, generating new keys for Vendors, Customers and enriching information• Configured… Show more • Experienced in designing and development of complete data migration pipeline (Source Systems --> SQL Server (Views, Stored Procedures, T-SQL) --> Azure Data Factory --> D365 CE, D365 F&O, D365 Field Service from legacy systems such as SAGE, OpenCRM, SimPro• Designed data pipelines to cleanse the data to close any gaps in the missing data and transform data wherever required namely, deduplication, generating new keys for Vendors, Customers and enriching information• Configured and managed Azure resources setup to cater the Migration solution – ADF, Blob Storage, Azure SQL DB, Self-hosted Integration Runtime, had setup BYOD and linked the same with D365 to publish and transfer data into Azure SQL DB• Configured all the entities in scope in Azure SQL DB with required Primary/Foreign keys to ensure referential integrity is in place before the data load into D365• Advanced working SQL knowledge and proficient with data architecture and query authoring (SQL) with familiarity across variety of databases –DB2, SQL server, Oracle• Loading transformed Data into Dynamics F&O and CE through Data Management Framework, debugging and resolving various data load issues in Dynamics 365 F&O and CE• Performed source system data analysis in order to manage source to target data mapping and connecting with business leads wherever required for clarification• Maintained the run book required for data migration with all the detailed steps of the complete data pipeline• Created and maintained Power Automate flows to refresh data from sharepoint into SQL server• Created Power BI reports on top of legacy systems data to report Data quality issues• Performing weekly refresh of data load from legacy systems (SAGE & OpenCRM) and generate/load the data files for Dynamics 365 CE and F&O• Created BYOD to publish all reference data entities and designed a data pipeline to identify additions/deletions related to reference data to ensure easy debugging of any related data loading failures Show less

London

• Reporting to and working closely with the M&S Integration Lead for implementing M&S Bespoke School wear website (SaaS solution - Dynamics 365) • Understanding the current system landscape and identification of data objects within legacy systems to derive the scope of data migration• Engaged with the UK business regarding data cleansing, collection and enrichment activities• Evaluated the existing infrastructure and proposed the optimized data flow to achieve data migration… Show more • Reporting to and working closely with the M&S Integration Lead for implementing M&S Bespoke School wear website (SaaS solution - Dynamics 365) • Understanding the current system landscape and identification of data objects within legacy systems to derive the scope of data migration• Engaged with the UK business regarding data cleansing, collection and enrichment activities• Evaluated the existing infrastructure and proposed the optimized data flow to achieve data migration scope• Driving mapping workshops with the business to complete the conversion design documents and mapping/transformation requirements and approach• Managed the cleansing, collection, mapping and build activities for all the ETL flows using Azure Data Factory required for data migration• Heavily involved with Data Migration, Data Analysis, and Data Validation/Reconciliation• Defining approach for the identification, definition, build and reporting of data quality rules and resulting data cleansing requirements• Responsible for loading data pipeline output files into D365 F&O to ensure required data is available for business to progress with UAT• Worked with the Integration Lead on the Cut-over activities and the run book for Data Migration Show less

London, England, United Kingdom

• Developed ETL SQL scripts to extract GL balances and transactions, Vendors, Customers, Bank Balances from legacy systems. Running numerous test iterations in order to confirm accuracy of extracts and correct updates to D365.• Contributing to weekly progress meetings with senior stakeholders and supporting DL Data lead in progress updates and status reporting• Loading data into Dynamics 365 with the output files of the data pipeline in subsequent iterations and resolving any load… Show more • Developed ETL SQL scripts to extract GL balances and transactions, Vendors, Customers, Bank Balances from legacy systems. Running numerous test iterations in order to confirm accuracy of extracts and correct updates to D365.• Contributing to weekly progress meetings with senior stakeholders and supporting DL Data lead in progress updates and status reporting• Loading data into Dynamics 365 with the output files of the data pipeline in subsequent iterations and resolving any load issues• Defining and tracking data migration test plan (to support test iterations)• Completion of end-to-end testing of data migrations in dedicated DM environments as well as supporting test iterations for E2E and UAT test cycles, providing transformed data for each test cycle.• Supporting business teams in identifying and implementing data cleansing activities.• Performing data cleansing, quality checks, de-duplication• Planning of all mock loads and cutover including sequencing and dependencies for each data objects, business and technical owners, tracking and remediation processes• Supporting business in reconciling migrated data Show less

London, England, United Kingdom

• Creating data pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources (DB2, SQL) into Azure datalake storage Gen 2 & Azure Synapse • Proficient in developing PySpark scripts to handle complex data transformation within Azure databricks • Implementing Databricks pipelines to load data incrementally into the Delta lake using Azure Databricks (using the Merge functionality)• Creating deployment pipelines in Azure Devops to… Show more • Creating data pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources (DB2, SQL) into Azure datalake storage Gen 2 & Azure Synapse • Proficient in developing PySpark scripts to handle complex data transformation within Azure databricks • Implementing Databricks pipelines to load data incrementally into the Delta lake using Azure Databricks (using the Merge functionality)• Creating deployment pipelines in Azure Devops to implement CI/CD for the DataLake components • Developing config tables and orchestration tables logic within Azure Data Factory to implement reconciliation of data between sourcestagingtarget layers and implemented the same across multiple pipelines• Analyzed and Identified large ADF pipelines and decoupled them wherever possible to optimize data processing times and costs and thereby improved SLAs• Worked on migration of On-Prem Databases on to Azure Cloud with appropriate business transformations Show less

Chennai Area, India/London

• Extensive ETL experience using Informatica 6.1/8.1/9.5 (Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager), TeraData(15.10), DataStage (8.5), BRIO 6.6, BO(12.1.0)• Worked extensively on Data Integration, DataWarehousing and Business Intelligence & very strong in using Informatica Power Center, Informatica Data Quality (IDQ), Informatica Power Exchange, Business Objects, Qlik View, Oracle, SQL Server, UNIX Scripting and PowerShell Scripting • Develop… Show more • Extensive ETL experience using Informatica 6.1/8.1/9.5 (Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager), TeraData(15.10), DataStage (8.5), BRIO 6.6, BO(12.1.0)• Worked extensively on Data Integration, DataWarehousing and Business Intelligence & very strong in using Informatica Power Center, Informatica Data Quality (IDQ), Informatica Power Exchange, Business Objects, Qlik View, Oracle, SQL Server, UNIX Scripting and PowerShell Scripting • Develop, Test, Tune and Debug ETL Mappings, Sessions, workflows and schedules• Experience in Profile, Analysis, Standardize, Clean, Integrate Data. Build Scorecard, Merge & Match, Reference Data from various source systems using Informatica Data Quality (IDQ) and Informatica Analyst tools• Proficient in Administration of Informatica PowerCenter through Administration Console and Business Objects Server using Central Management Console (CMS) and Central Configuration Manager (CCM) with extensive experience in production releases• Experienced in building Staging, Operational DataSource (ODS) environments using Real Time Change Data Capture (CDC) tool Informatica PowerExchange• Source data analysis/profiling whenever necessary to support ETL design - Perform development activities to support cloud migration and development• Strong experience in working with and optimizing existing ETL processes and data integration and data preparation flows and helping to move them in production• Doing data analysis, design, modelling, and quality assurance techniques to maintain data structures and associated data transformation components• Performance tuning of Informatica Mappings/Workflows using Pipeline Partitioning technique, External Loader of Oracle, MLoad/TPump External for Teradata Show less