Home

Ram. k - Integration Architect

[email protected]

Location: Arnold, Nebraska, USA

Relocation: Yes

Visa: H1B

EMAIL:[email protected] PHN:469 598 1989 objective: Dedicated consultant experienced in building large bespoke systems and EAI applications for major blue-chip companies, seeking a position with a fast-paced company that allows for the application of various technologies as an Integrations solution consultant. Key Skills Integration Architect/ Senior Developer Middleware technologies: Microsoft Azure, BizTalk, TIBCO Scribe, REST API Integration of enterprise systems: Microsoft Dynamics 365 modules, SharePoint, Oracle eBusiness Suite, Unit 4(Agresso) Microsoft Dynamics CRM development - Plugins, Workflows & Power Automate flows and Dataverse. Enterprise integration of onpremise, Hybrid and fully cloud systems Strong knowledge of design and developing database objects using SQL Server, and NoSQL databases. DevOps CI/CD, Azure CLI, ARM Templates, PowerShell Scripting IBM s Maximo Asset management & Integration Framework (MIF) Exposure to full project life cycle with various UI, middleware and database technologies Agile Implementation Methodology; DevOps, JIRA Professional Qualifications Microsoft Certified Azure Developer (AZ-204) Microsoft Certified Professional (MCP) in web and windows application development using C# .Net Blue Prism Certified Developer for RPA Master s in science, Hyderabad India Key Experience Integration Architect/ Senior Developer with 18+ years of experience in the development, design, and implementation of various Enterprise Integration solutions for Transport, Health, Education, Retail, Public Service and Finance sectors. Integration of various enterprise applications like Dynamics 365 (Finance, Operations, CRM/CE), Products (Akeneo PIM, IBM s Maximo) & Price (Flintfox) management etc using Azure PaaS components Service Bus, Blob Containers, Azure Functions, Logic Apps, APIMs and Event Grid. Successfully migrated revenue service data from ITax (mainframes) into Microsoft Dynamics CRM using RPA, SQL Server and Tibco Scribe Light services Transformed & implemented fully on-premise BizTalk integration solution to Hybrid model with Azure PaaS service components. Achieved customised Integration of Maximo and Microsoft Finance system along with Installation and configuration of Greenfield Finance system, Microsoft Dynamics GP for one of the London s transport services unit, DLR. Having worked on many Enterprise systems, fairly understands the Procurement, Asset Management and standard Dynamics Finance & CE processes. With strong knowledge on Microsoft s SQL Server SSIS and SSRS, implemented data migration of bespoke system s finance data into Agresso (Unit 4) finance system for a London based prominent public sector organisation. Skills Microsoft Azure Cloud PaaS services, BizTalk, Tibco Scribe Light, Clear Span, MSMQ, Hands-on Dell Bhoomi and MuleSoft cloud services. Azure DevOps planning, security configuration, setup CI/CD build and release pipelines, Azure CLI, PowerShell Scripting and ARM templates for deployment. Proficient in design and development of Microsoft Azure PaaS components like Web API, APIM, Function & Logic Apps, Service Bus, and Storage etc., Microsoft Azure AD, Ping Directory, Federate & Identity services. Fair experience with Azure Graph API to read and post data into AAD and Dynamics 365. Microsoft Dynamics CRM development, Power Flow, Dataverse, Dynamics GP (Finance) 2015 configuration (Organisation, COA), GP eConnect, SharePoint; IBM s Maximo Integration Framework (MIF). Microsoft's SSRS, SSIS, Tibco Scribe Light Data Migration, Hands-on experience ETL Talend, Informatica Proficient in MS SQL Server and NoSQL (Cosmos, MongoDB) C#, MVC 5.0, ASP.Net Core, Entity Framework. Extensive experience in SOA using WCF, WebApi SOAP and REST API design and build using .Net / C#, XML, XSLT and JSON. Hands-on with SPA using Angular, Typescript, HTML5 and Bootstrap. Experienced with full project SDLC. Experience using project collaboration tools like Azure DevOps, Atlassian, Confluence, JIRA; Client facing capabilities. Experience working within a tight deadline and pressured environment. Experience of mentor and leading the team size of 5-8 members 2 | Page Professional Experience: Midwich Group, London UK (Oct 2022 July 2023) As part of Fusion-II programme, Midwich a trade only supplier for AV, IT and Document Solutions implements Microsoft s cloud service moving legacy solutions. This programme implements Microsoft Dynamics CRM, D365 Finance Operations for inventory management, and Akeneo PIM & Flintfox as product and price management systems. Working as senior Dynamics Integrations consultant, below are the deliverables and responsibilities: Customer Product Data Feeds As part of Digital transformation, Midwich Fusion-II programme moving legacy semi-automated customer data feed to complete cloud PaaS based automated solution. As senior integration developer, responsible for design and implementing the solution, below are the responsibilities and deliverables: Responsible for understanding the legacy processes and data structure, design & implement modularised decoupled solution with minimum code approach and automation. Extraction of MongoDB data as flat-file data and importing into SQL. Design and implement SQL database schema. Validate and import extracted staged data into normalised schema using standard SQL Scripts. Implemented Azure Function schedules to check data feed hours and inventory movements, integrating Akeneo, FlintFox and Dynamics CRM and decoupling by using service bus queue and Azure Blob Container. Implemented Scheduled Azure Logic App integrating with D365 Finance Operations Inventory-Visibility API and Akeneo PIM API for hourly updates to sync with staging SQL database. As part of data feed notification process, implementing Blob Container bounded Azure function to transfer customer data feed files by FTP/SFTP and Mimecast SMTP email service. Configured ARM templates and implemented Build and staged released pipeline (CI/CD) for various environments. Carrier Price Service As part of Fusion-II Programme, carrier delivery and its pricing process automation feature is implemented. As part of the integration solution, following are design and implementation responsibilities delivered as Integration Architect/ Senior Developer. Extracted data and vendor agreement details, transformed, and imported into database as structured data. Implemented Azure Function over HTTP trigger which return carrier price service for given data conditions like shipment address zone, weight, and package dimensions. Exposed secured APIM API for end system consumption to automate over-all service process. Exposed SQL data tables as Virtual Entities in Dynamics CE for data maintenance. Implemented power automate flows to de-normalise child table attribute data selections. Setup and configure CI/CD pipelines using ARM templates and binding key-vault secrets as pipeline variables Agilisys, London UK (Feb 2018 - Oct 2022) Worked on below assignments in various capacities and roles (Integrations Architect, Team Lead and Senior Developer): Dynamics CE Implementation, BCP (Bournemouth, Christchurch & Poole) Council BCP Digital transformation programme implements Dynamics CRM as the core platform for Citizen services. As part of customer service implementation team, following are responsibilities delivered as Integration Architect/ Senior Developer Designed and implemented Gazetteer APIM API, integrating with NLPG and LLPG address search services. Implemented Customer/Citizen, case details data integration with finance and other systems using Logic Apps subscribed over Service Bus messages which in turn are published through Dynamics CRM Service Endpoint. Designed and implemented File Handler service for customer upload documents using portal service. Blob container triggered event initiates virus scan, move file to secure location (Blob Container or SharePoint) and update Dynamics with file upload status. Azure PaaS component Blob Container, Event Grid, Service Bus and Functions are used. Implemented integration of third-party virus scan API for uploaded file s virus check. Involved in setting CI/CD for Document-Handler solution. Designed and implemented APIM API to retrieve resource availability (schedule) slots for customer case management booking. 3 | Page Revenue Services, States of Guernsey UK (https://www.gov.gg/revenue-service) As part of Digital transformation, SoG implemented Dynamics CRM as a core platform for data and customer services. It is required to extract customer and associated revenue data (both corporate and individual) from mainframe based ITax and SIR systems and implement the same with flexibility for future enhancements. Phase-I Responsibilities Corporate Revenue: Designing corporate service schema entities for Dynamics CRM. Involved in defining security roles and teams in accessing the data. Client discussion on data extraction from ITax and SIR systems. Coordinating with RPA team in extracting data into Staging Responsible for staged data migration corporate users, companies and revenue data into Dynamics including data validation, reconciliation reports and Scribe workflow design. Design bespoke API for existing UI service for register and manage corporate tax management. Design and implementation of bespoke API interfacing with Ping Directory for use search, register and verify operations. Prepared business case with data demography and benefits of Integration platform; recommending BizTalk as platform to implement an integration platform. Phase-II Responsibilities Individual Revenue: Implementation of BizTalk 2020 as integration platform. Installation and configuration of the BizTalk 2020 platform including BAM and ESB toolkit. Setup and configuration DevOps release pipelines to build release onto on-premises servers. Responsible for migrating customer, address, and revenue data into Dynamics - data validation, reconciliation reports (using SQL Server objects) and Tibco Scribe workflow design. Design generic framework service endpoint to read data from Dynamics using either OData or Fetch-Xml. Developed custom C# components to manage business specific SharePoint operations for BizTalk process. Design and implementation of data service pattern to extract data from Dynamics CRM and sync with subscribed endpoint systems. University of Glasgow, Glasgow UK An IT service to one of the prominent UK University (with 50K national and international students) to provision IT management consultancy to provide a business case for student and course enrolment data within university administration and various departments. It is to work with the client team on project initiatives in understanding the current data domain and its demography. As integration specialist, involved in establishing and preparing the business case study for Enterprise Integration Platform (EIP) with. Reviewed university data demography and its numerous point-to-point or disconnected integrations. Evaluated various cloud, on-premises and hybrid capable integration tools/products including Dell Boomi, MuleSoft and Microsoft cloud & on-premises solutions. Engage suppliers and research technical options, features, approaches, and cost-benefit profile of each option. High level data domain & entity mapping among software systems and manual practices. Develop a full business case and prepare proof of concept for proposed software and tools involving Boomi (atoms), MuleSoft (mule processes), and Microsoft s Azure PaaS artefacts (functions, logic apps and service bus). Based on recommendations, developed a test case interface integration using BizTalk-Azure as Hybrid Integration Platform for demo to management and technical team seniors. Considering client s data existence & practices, evaluating latest Gartner s Magic quadrant requisites, recommended the choice of tool/service for Integration platform with 15 years expenses projections and appropriate demos. 4 | Page Associate (April 2013 Dec 2017) May 2017 December 2017: CACHE, St. Albans UK CACHE (Council for Awards in Care, Health, and Education - setup by Ministry of Health, now part of NCFE) develops syllabus (and conducts exams) for NVQ levels in childcare. The assigned engagement is to enhance existing Integration solution with cloud service. System involves integration of SharePoint & Microsoft s CRM, Great Plains (finance system) with cloud based Digital Certificates and Qualify (a thirdparty teaching assistant product). As Integration Consultant, Responsibilities include: Certificates and qualifications associated in-house integrations into azure cloud services using Service Bus queues and Azure Functions. Implementing PR and PO associated eConnect event data integration with Azure queue topic, consumed by azure functions to post data into target system. Sync CRM Centre delivery address with Digital Certificates service system using Azure Function implementation. Read various SB queue messages for Centre and employee s registrations etc, process and post to subscribed systems GP eConnect, Dynamics CRM or SharePoint Implemented a .Net C# custom library to Create OU in activity Directory, SharePoint site. October 2015 March 2017: DLR (Docklands Light Railway), London, UK Assets & Finance Management: Implementation of new Financial, asset management systems and its integration with custom C# library using MSMQ and eConnect adapter. Installation of Microsoft s finance system, Dynamics GP 2015 both thick client & web client deployed into AWS. Managed AWS server configuration, storage and monitoring traffic & memory usage. Configuration and setup company, chart-of-accounts (COA) and its allocation, PR & PO processes etc., Loading basic data like COA, Inventory and Vendor data. Exposing GP client as Web Client for client s access over the internet. Customise built-in reports. Responsible for data migration of client s legacy procurement data (Purchase Order, Invoice, GLs etc) into GP using Integration Manager, using SQL Server SSIS and procedures Integrate Finance system with Maximo (Asset Management System) Setup and configuration of Maximo Integration Framework (MIF) for the integration using custom middleware stub developed in C#. Developed web interface to track and manage message flow using Angular 2.0. This includes features like display latest data with search options, resubmit failed messages, update message status etc., April 2013 September 2015: TFL (Transport for London), London, UK Asset Management Improvement Programmes (AMIP) Integration Architect: An Asset Management/ Performance processes and functionality into the core EAM system enabling a holistic view of material, labour and performance costs to be created which drives real-time decision making for fault management. Leading finance data (PR, PO etc.,) will be posted into Oracle R12, finance system. Reviewing existing Integration solution in TIBCO and delivering case study with BizTalk 2010 as Integration Platform. Responsible to replace TIBCO interfaces with BizTalk 2010 integration service without disrupting live processes. Installation and configuration of BizTalk Integration Server. Design and implementation Integration Framework which includes abstracted pipelines, adapters, archive, BAM tracking APIs and Generic error handler and email notification for the escalation. Responsible for design and implementation of Integration solution for Employees, COA, Vendors, Procurement process (PR, PO, Receipts, Invoice etc.,) and GL Transactions between Oracle R12 eBusiness suite and IBM s Maximo, an Asset Management System Setup and configuration of Maximo Integration Framework (MIF), publish channels (outbound) and enterprise services (Inbound) with Oracle R12. Designed and developed Microsoft ASP.Net MVC based web interface to track and trace (read-only) real time message processes Keywords: csharp continuous integration continuous deployment user interface active directory information technology container edition purchase order microsoft Arizona Delaware