Consulting for DTE EnergyDepartment: Plant & FieldProject Description: Complex Event processingClient was looking to capture and record real time electrical meter's outage data; verify the outage and forward necessary information to downstream systems. Implemented Azure EventHub with Azure Databricks for complex event processing utilizing Scala code and azure storage for checkpoint.Currently, on-boarding more sensor events to this platoform.

Consulting for CIBC FirstCaribbean International BankDepartment: Data WarehouseProject Description: Modernize on-premises Data Warehouse The scope of the project: approx. 300+ databases on 15 SQL servers:• Conducted inventory of databases, their versions, and related SQL servers & OS servers• Assessed the readiness for migration of each database• Quantified the compatibility for migration to Azure • Identified breaking changes & unsupported features• Reviewed related DTS and SSIS packages• Reviewed SQL Server Reporting Services• Recommended roadmap and migration/modernization path• Conducted POC per roadmap and documented findingCurrently, working with client on architecting Lakehouse, which includes Data lake & Azure Synapse Analytics

Consulting for Humana IncDepartment: Data Strategy & GovernanceProject Description: Data Certification AccelerationTechnologies1. Azure SQL, Blob Storage2. Azure Data Factory3. Logic Apps 4. Power Apps, Power Automate Flows, Power BI5. Power Automate with Azure Data Gateway7. SSIS packages (ETL operations on Excel, Oracle, Db2, Azure SQL)8. Client to Rest API, C#, Postman, Flow9. Azure Purview (Data Cataloging, Classification, sensitivity labeling...)10. Integration with IBM InfoSphere Information Governance Catalog - IGC (API & directly to Xmeta tables/views)11. Extracted data from IBM Information Analyzer (IA) for Power BI Data Quality Dashboard, grouped by Completeness, Validity, Accuracy, Consistency...)12. Integration with Salesforce Rest API13. Microsoft Purview implantation14. Built bridge to subscribe to Purview's EventHub, then pull add'l entity data from Purview and populate Company's Enterprise Data Catalog15. Containerized above python app and deployed to Azure Kubernetes utilizing GitHub actions and ArgoCD (+dockerfile, helms, igress, istio, cailico, jfrog artifactory, hs vault, terraform, ARM...)

Consulting for Fedway /Inter-Metro FrieghtProject Desction: MS SQL server migration from 6 office locations to Azure Azure Resources utilized1. SQL Managed Instance2. Blob Storage 3. File Storage4. Service private end point5. Vents, Peering, VPN Gateway, LNG, NSG... for Site-to-Site connectivity as well as Point-to-Site with certificate6. Azure Site recovery for file backup7. SQL database replication from Azure to on-premise8. Private DNS

Consulting for Stearns Lending Nov.2014 to Sept.2017 – Enterprise Post FundingSoftware descriptiona. Line of business user groups: Warehouse funding, Capital Markets, Servicing, Post Closing, Auditb. Post Funding functionality, such as, request to fund a loan/fund the loan, Board loan to Servicing (Data/Documents), Reports for Capital/Secondary Markets, Post funding audit Modules, Data boarding to Custodian, balancing Funding figures, etc.Automation for steps done manually in the past1. Created Investor specific Document packages based on configuration ( C# window Services, MS SQL and WCF)2. Background job to validate data against FNMA-EC and FRE-LQA (C# windows services, MS SQL and WCF)3. MERS Registration (C# windows services, MS SQL and WCF)4. ETL to QRM and Cycling QRM daily thru scripts (vbscript, power shell, command line)5. Loan boarding to Loancare (Create XML and secure FTP to servicer drop location via c# window service).

Consulting for Stearns Lending since Nov.2014 to presentSince Sept.2017 on Digital MortgageSoftware descriptiona. Line of Business user groups: MLO, Consumer, Partners such as realtors, builders, etcb. Point of sale functionality, create scenarios, create loans... Automation: 1. Pull income and Assets (VOI, VOA) into the system via http post API and embedded 3rd party widgets into the system (UI angular, middle tier C# Web API, hosted internally as well as Azure, db MS SQL)2. Obtain underwriting decision from FNMA via http WCF Services (UI angular, middle tier C# and db MS SQL).Other1. Mobile iOS and Android support, embedded angular components via web-view into mobile app ( Xamarin.Forms native PRISM) 2. Auth method - oAuth JWT3. Use git and TFS (visualstudio.com) for code repository.4. Use of TestFlight prior prod deployment5. Use Hockey and app center to monitor crashes and some level of automation testing.

Software - Home loan fulfillment software’s (iFulfill) AKA IBM's "impact"Core services include - Pricing, underwriting, frauditor, loan assignment, role based security, compliance, batch processes, etc.Tech specifics - Linyx, websphere, iLog/ODM, oracle, IBM MQ, IIS, ASP.Net C#, MVC etcIntegration to 3rd party - Landsafe Credit, CoreLogic Flood, Title, Imaging, Credit Card processing/PCI compliant, wire, servicing, DocuTech, etcSupport tools - Margin management, Admin and monitoring tools

Software - iOriginate, which supports Loan origination for Retail & Centralized SalesCore services include -Lead management, scenario management, Loan creation, Pricing, underwriting, loan assignment, role based security, compliance, etc.Technology - Windows server, IIS, ASP.NET, MVC, WebServices (asmx)On Perm install of Team Foundation Server - with continuous integration and continuous deployment to dev environment.

Part of Transition team for M&A of Countrywide by B of AResponsibilities include integration of iOriginate (POS) with B of A's HELOC/HELOAN platform, which included UDE (Pricing & Decision Engine) & ACAPS ( Fulfillment platform for HELOC/HELOANs).Immediate development team size 50 (27 on shore and 23 offshore), my immediate direct report 10 (2 on-shore and 8 off-shore)Technologies - IIS, C# ASP.NET, MVC, WebServices Addition Team’s responsibilities include integration with customer relationship, 1st mortgage underwriting as well as pricing platforms, document and package generation, management and printing

Application and Role Specific Responsibilities• Loan Origination for Wholesale lending division software (CWBC) core includes data collection, integration with customer relationship management system, marketing, pricing, underwriting, document services/eClosing, and 1st mortgage fulfillment platforms.• Technologies used for main application are include IIS, classic ASP, C++, VB6, ASP.NET, WebServices, windows services, MSMQ etc.• My role: Team manager of development team for Underwriting Module as well as production 24/7 support for the entire application.• Immediate development team size 25 (15 on shore and 10 offshore), my immediate direct report 7.• Responsibilities includes, design, architecture, coding, unit testing of CWBC underwriting module. As well as integrating with bank CLOUT platform.• Addition Team’s responsibilities include integration with FNMA to import loan files to CWBC, integration with eClosing, and integration to Fulfillment platform.

Application and Role Specific Responsibilities• Credit Merge Engine software (CME) core includes integration to credit bureaus to merge 3 files into one tri-merge credit report. Application support external customer integration as well as internal and it has on-line presnece.• Technologies used for main application are include WAS on JVM/iSeries (AS400), DB2, JAVA/J2EE, JSP, C++, VB6, ASP.NET, WebServices, windows services, MSMQ etc.• My role: Team Lead for development team for Credit moduel as well as production 24/7 support for the entire application.• Immediate development team size 10, my immediate direct report 3.• Responsibilities includes, design & architecture CME. • Addition Team’s responsibilities include integration with Fannie & Freddie as well as credit research for disputed items.

Supported Application and Role Specific Responsibilities• Loan Origination for Corresponding lending division software (CLD – GEMS & Platinum) core includes data collection, integration with credit report, pricing, underwriting,.• Technologies used for main application are include IIS, classic ASP, VC++, VB6, http post, windows services.• My role: Team manager of development team for Underwriting Module as well as production 24/7 support for the entire application.• Immediate development team size 25 (15 on shore and 10 offshore), my immediate direct report 1.• Responsibilities includes, design, architecture, coding, unit testing of Platinum & CLOUT underwriting module.