Customer MDM, This project focused on conducting an in-depth analysis of Java-based applications, particularly related to Request for Enhancement (RFE) functionalities and batch job processing. The primary goal was to review existing codebases to identify system functionalities, detect gaps, and recommend performance improvements to enhance efficiency and align with business requirements. This initiative was part of a strategic effort to win the project from a bidding perspective., Conducted a thorough analysis of 5 projects to identify functionalities and performance gaps., Created comprehensive technical documentation and UML diagrams to support project proposals., Collaborated with cross-functional teams to align technical solutions with client requirements., Successfully secured project win through strategic analysis and proposal., Java, Oracle, Informatica IDCM, Restful APIs, MS Visio, Plant UML, JIRA, Confluence, JD-GUI, IntelliJ De-compiler, Batch Files, 5 Jencap Insurance, The project involved designing a comprehensive quick utility for insurance agents to manage insurance policies, risk assessments, and EIFS Contractors Program Quote Generators. The tool aimed to streamline the process of turning a prospect into a client efficiently., Led project execution and collaborated with stakeholders for requirement gathering., Designed and implemented workflow automation for insurance processes., Developed custom dashboards and reports to enhance data-driven decision-making., Improved operational efficiency and reduced manual efforts., Delivered an intuitive and scalable solution for insurance management., Enhanced data accuracy and reporting capabilities., MS Access, SQL Server, .NET, MS Excel, Visio, Power BI, Query, 6 Client Onboarding Experience, A SaaS solution leveraging Microsoft technologies, designed to streamline client onboarding and renewal processes through low-code/no-code capabilities. This platform integrates marketing, sales, and operations workflows, facilitating a seamless transition from prospect to client. Key functionalities include application development, workflow automation, and data integration using Azure Functions with JSON formats., Designed and optimized Power Automate workflows for REST API integrations., Configured Azure DevOps pipelines for automated deployment., Standardized client onboarding process across geographies., Reduced workflow actions by 30% through optimization., C#, Power Apps, Power Automate, Azure Functions, DevOps, Post Man, XRM Tool Box, GitHub, Dataverse, Figma, PlantUML, 15 Invoice Request and Intake, A centralized application designed to streamline and standardize invoice request submissions for client support services teams. The tool aimed to eliminate manual touchpoints, improve accuracy, and enhance efficiency in invoice generation and approval processes. The application served approximately 950 users, providing built-in validations, auto calculate the Exposure percentages, Premiums, Coverages and create reports., Automated invoice workflows with Power Automate, reducing manual touchpoints., Integrated Power Automate with OneDrive for document management., Reduced bottlenecks and enhanced timeliness of invoice processing., Designed solutions for improved operational efficiency., VBA, SQL Server, Power Automate, RPA Blue Prism, 5 Clearing House, A workflow management tool used by the Surplus Lines department to assign licensed brokers to states requiring surplus line placements. The application, initially built in MS Access, was modernized and migrated to SQL Server to improve scalability, maintainability, and security. It streamlined processes for 50 users, automating data imports and licensing assignments while ensuring compliance with regulatory requirements. Pre and Post binding Notices required for Surplus Lines Insurance Compliance USA at runtime., Modernization /Upgradation, Migrated application from MS Access to SQL Server for scalability., Automated data imports, saving ~300 manual business hours annually., Enhanced security with modern authentication methods., MS Access, SQL Server, VBA, REST APIs, C# DLL creation, LDAP, Workday, PeopleSoft, 9 Online Tools Suite, Web-based portal with 750 sites for managing business transactions and services., Rebranded portals and ensured compliance with data privacy standards., Integrated RPA bots to reduce manual tasks., Improved user experience with drag-and-drop features and server migration., Achieved seamless functionality across all sites., HTML, PHP, SQL Server, RPA Bots, 9 WinCert, Certificate generation and renewal tool with automated reporting processes., Automated reporting workflows, reducing processing time from 40 to 5 minutes., Integrated API services for seamless data exchange., Minimized manual errors through automation., Enhanced processing speed and accuracy., VB.NET, Oracle, API Services, VBA, 9 Sales Compensation Program, Application to calculate and administer sales commissions and incentives., Automated SCIP attribution processes for accurate reporting., Addressed key issues in revenue and compensation calculations., Transitioned manual processes to Anaplan, enhancing reporting accuracy., Improved accuracy and efficiency of compensation management., MS Access, Oracle Hyperion, VBA, 3 Open Tax Payables, Tax workflow management tool for surplus line operations., Automated ETL processes for improved data accuracy., Delivered zero UAT defect deployments., Streamlined tax workflows with enhanced reliability., MS Access, SQL Server, IBM iSeries, Informatica ETL, 6 Metastorm BPM, BPM module for workflow automation and audit trails., Performed SQL migrations and ensured high availability., Reduced manual errors in workflows, improving approval times., SQL Server, JavaScript, Windows Server, OpenText, 5 CAR - Wholesaler Enhancement, Tool for generating and managing client agreements., Developed macros for automated reporting processes., Enhanced document generation for agreements., MS Word VBA, MS Access, 6