About Me
18+ years of experience as Microsoft Business Intelligence DTSSSISSSSRSSSAS T-SQL Stored Procedures Triggers SQLServer20+ years of Software Development experience in MS technologies like ASP.Net 1.1/2.0/3.5/4.0/Core 2.0 C# VB.Net SQLServer 2000/2005...
Show MoreSkills
Portfolio Projects
Description
Mahindra Finance is one of the leading NBFCs in India. A customer portal is designed to facilitate the customer tocomplete the investment journey with all required compliances in online mode with multiple payment options.Integration APIs were designed to facilitate the Channel partners to book the investment journey of customer in theirown portals and integration the same with MMFSL.Channel partner portal to facilitate the channel partners to book the deposit on behalf of their customers using thispublic applicationMMFSL branches & MMFSL Investment advisors can also book the investments on behalf of customers using differentpayment methods as Cheque and online payments as well.Internal applications to support the Fixed deposit operation right from KYC verification to Deposit profile changes hasbeen digitized.Data and payment reconciliation systems to reconcile the payments which has been made by customers using differentpayment modes.FD Repayment and interest payment reconciliation systems to reconcile the repayments of investments online.Online Submission of different compliance forms download of TDS certificates and other documents like FD Receiptsand interest certificatesSubmission of required compliance data to governing authorities using APIs and Jobs & RPA ImplementationOnline Checking and Verifying Compliances like PAN Validation and Retrieving data form CERSAI to digitize and fastenthe investment journey
Show More Show LessDescription
Mahindra Finance is one of the leading NBFCs in India. There are different litigation matter in court of law which incursexpenses and need to comply the processes as suggested by court of law.Digitization of Major Litigation processes such as case tracking and Legal NoticesCase Recordings hearing updates case stage movements and Final or Interim order updates are getting captured inportals digitally.Access to litigation document across pan India for all the field executives and other stakeholdersLitigation Expense Management for all types of litigation expenses tracked digitallyDifferent litigation processes automation such as notice generation and other letter generations from the system.Reminder Email and Messages sent to customers.The process of issuing different documents which will help them to appear in court of law or sign certain documents.Digitization of all these processes of Issuing Printing and complying these legal documents.Automation of litigation document Processing on azure Blob with Robotic Automation.Automation of Document Generation process using BOTs & RPA Implementation
Show More Show LessDescription
Development and implementation of overall data processing to align with different business processes. This includes datamodel design Database development standards and Implementation.Identification of Internal and external data sources and Documenting the Each every ETL Unit.Monitoring and Development of Different ETL packages.Fix incidents related to data using data scrubs after thorough investigation tracing back to the root cause Re-run ETL asneeded within SLA and report to user on incident resolution.Development of new ETL packages Reports - Document the design Unit testing results and QA results. Support user onUAT will ETL runs and data update as needed.Managing the ETLs and its development effort estimations incident reporting for failures RCA and meeting Resolutionand response TATs
Show More Show Less