Sandesh Lohar

Career Objective: Looking forward to work in an organization, which offers challenging opportunities and scope to utilize my skills towards providing optimal services. Career Highlights: Solution Architect with an overall 18 yrs of experience and TOGAF 9.0 Certification. Around 12 yrs experience as an Architect spanning different domains. Worked in Cognizant’s Microsoft Centre of Excellence (MSCoE ) and Banking & Financial Services’ Technology Consulting Group (TCG) as Architect. Worked as Technology Partner on an Account with 5 projects with team size of 80 members. Worked on PreSales supporting RFPs. Few of the major modules, utilities and features developed include : Proprietary Rules Engine using .Net Parallel Processing features. Zero Downtime Deployment strategy for a Multi-tier System - involving multiple tiers like - Web Farms, BizTalk Farm, Citrix Farm, SQL Server Cluster – based on f5 Networks Hardware Load Balancer. Metadata based Dynamic User Interface applications for Desktop and Web apps . Architected HealthCare Product as a Hybrid-Web Multi-Tenant Application (On Cloud+OnPremise Components) leveraging SaaS model for delivery, using RESTful Web API with MVC and JQuery on Microsoft Azure. Onsite Experience: 2 weeks[Dallas, TX, US] : Architecture & Code Assessment Nov – Dec 2009 3 Weeks[Appleton, WI, US] : Architecture Assessment Aug – Sep 2008 2 Months[Manchester, UK]: Application Migration Oct – Dec 2000. Core Technologies: ASP.Net WebForms ASP.Net MVC ASP.Net Web API WPF,Silverlight, WWF WCF, XML, Web Services C#, VB.Net, VB, VC++ COM/DCOM/Remoting .Net Framework 4.5 .Net Core Entity Framework JQuery, AngularJS LINQ, AJAX Microsoft Azure MS SQL Server 2014/Sync Framework/ Compact 3.5 UML Core Skills: SOA, XML & RESTful Web Services, WCF, WWF, MicroServices, Single Page Applications, Multi-Layered, Hybrid Cloud Applications, SaaS, ASP.Net Web Forms, MVC, Web API, Smart Clients, Client–Server, OBA, etc. Architecture, Design, Development, Deployment and Reviews. Performance Tuning, Optimization and Testing. Incorporating Security & Threat Modelling, Load Balancing, HA and DR in addition to other NFRs in Architecture. Creation of Modular & Re-Usable Application Infrastructural Components. Lastly, awareness of upcoming technologies like BigData, IoT, Machine Learning, HD Insights, Analytics, etc Tools Usage: Jmeter, Nouvola, New Relic, Fiddler, RedGate ANTS Profiler, Dot Trace, WCF Service Trace Viewer, SQL Server Query Profiler, FxCop, VS Code Analysis, VSS, TFS, Deep Zoom Composer, MS Visio, Enterprise Architect, VSTS, NUnit, ReSharper, etc Industry Experience: HealthCare BFS IME Hotel Industry Airlines Mortgage Energy & Utilities Responsibilities Handled: Act as a single point of contact for all technical and technological needs of the team. Create high level PoCs (Proof of Concept) to demonstrate/validate the proposed technologies Evaluate current and emerging technologies based on factors like relevance, cost, portability and time and proposing appropriate solutions. Provide technical guidance towards identifying and fixing glitches and performance bottlenecks. Conduct specific technical sessions to communicate the architecture, design decisions, upcoming technology features and the value-adds to the development team and other stake holders including clients. Coordinate with IT team to setup the local Development, Build, Testing (Functional as well as Load Testing) and Staging Environments. Ensure that build process itself handles the NFR related to the system passing a minimum specified % of unit test cases before getting deployed to Testing and Staging environments. Reviews of architecture, design and source code for potential bottlenecks, security flaws and other issues. Organizations Worked: Company Designation From To Changing Reason First Insight Software Solutions Solution Architect 21-May-2012 30-Jun-2016 Personal Reasons KPIT Cummins Solution Architect 9-May-2011 30-Mar-2012 Stagnation Cognizant Technology Solutions Architect 16-Apr-2007 2-Apr-2011 Travelling Needs Satyam Computer Services Ltd Sr. Systems Analyst. 2-Jan-2006 13-Apr-2007 Better prospects CapGemini Consulting Pvt Ltd Sr. Consultant. 29-Dec-2004 23-Dec-2005 Moving to Pune Accenture Pvt Ltd Sr. Software Engr. 1-Oct-2003 23-Dec-2004 Better prospects Syntel India Ltd Sr. Analyst. 22-Aug-2000 15-Sep-2003 Better prospects Rave Technologies Software Engr 5-Jun-2000 14-Aug-2000 Commutation Sang Softworks Programmer 24-Aug-1999 27-Nov-1999 Commutation DNC Data Systems Programmer 15-Jun-1998 13-Aug-1999 Stagnation. ProDesign Information Systems Programmer 5-Jun-1997 31-Jan-1998 Company Closure Net Exp Excluding Gaps: = (Net Working Days /365 ) = (6506 /365 ) = ~ 18 Yrs Certifications & Trainings TOGAF 9 [Enterprise Architect] Certified (Mar 2012). MCP Certification in ASP.NET & VB.NET Web Applications : 70-305 (2004) Corporate Training on Windows Azure Development. (ASAP) Aspiring Software Architect Professional Training from Microsoft. Education Qualification Year College/School University Bachelor Of Engineering (Electronics) 1997 DMCoE, Airoli Mumbai Personal Details Name Date Of Birth Gender Languages Spoken Marital Status Sandesh.Krishnappa.Lohar- Male English, Hindi, Marathi, Kannada Married Project Details Organization: First-Insight Software Solutions Ltd Duration: May 2012 – June 2016 Worked as Solution Architect in this Product Company. Architecting, designing and developing a large Web Based Multi-Tenant SaaS Hybrid Cloud System with peculiar NFRS, as a set of Cloud Based Web applications & services was really challenging as the older product was based on Windows Platform. and had to be re-written from sratch. Also ~1000 existing clients - with varying needs, sizes(databases), with other integrations and expectations were also required to be migrated to the new product in a phased manner all the while ensuring that performance , scalability and security were not comprised – were the most challenging aspect to be considered while architecting the solution. I was accountable for all the aspects of Product’s Technical Architecture, Design, Development, Perfomance Optimizations, Testing (Performance), Reviews, Deployment, Security, Database Re-Designing ,Performance Tuning of the Queries, Deployment Architecture including leveraging Features like AlwaysOn Availability, WSFC (Windows Server Failover Clustering),etc. The architecture specifically catered to providing inbuilt AutoSave and MetaData based Tables’ features in addition to other innovative features. More details may be shared on demand as product development is still in progress. Organization: KPIT Cummins InfoSystems Ltd Duration: May 2011 – Mar 2012 Worked as Solution Architect, in the MSCoE (Microsoft Centre of Excellence) As a part of my role, I typically worked on various proposals, providing innovative technology solutions for the cients. Solutions offered, relate to latest technologies like Microsoft Surface, DeepZoom, Windows Azure, Silverlight showcasing features and value-adds presented by upcoming technologies like Kinect (for windows),etc. Identification of potential Service Offerings from the Organization perspective, review and creation of assets and utilities to improve the developer productivity. Created a Excel based Project Dashboard, which provided the statistical information about the status of project, defects, categorizationbased on automated testing and reviews,etc. Also other tasks included initiation of Developer Community events by conducting brown bag sessions on technology,best practices, updates and other trainings. Organization: Cognizant Technology Solutions Ltd Duration: April 2007 – April 2011 For major part, worked in the role of Senior Architect as part of (MSCoE) Microsoft Solutions Centre of Excellence team for around 3 yrs. Later shifted to BFS TCG (Technology Consulting Group) for remaining period of 1 year. As part of BFS TCG ,worked as Technology Partner (single Point of Contact from BFS TCG group) for a large client First American (with team of 80 people) in BFS domain. Was involved with all (5) projects in the same account during the Architecture & Design phases for more than a year. Worked on many RFPs,Projects and MSCoE Activities during 4 yrs stay, like creation of assets, assessments and performance reviews, technical training sessions for dev teams and many of the activities as mentioned above in experience summary. Organization: Satyam Computer Services Ltd. Duration: Jan 2006 – April 2007 Worked as Sr System Analyst mainly as a member of Technical Review Panel. Project Title: Checkfree EPL- (Enhanced PortFolio) Client and Duration: Checkfree Investment Services,-. Details: Worked in the capacity of Review Panel Member, overseeing compliance to Architecture & also Low Level Design by the team and reviewing the design and code for performance issues. Technologies:ASP.Net, C#, .Net,Web Services,SQL Server,etc. Team Size: 50 Role:Technical Review Panelist Organization: Cap Gemini Duration: Dec 2004 – Dec 2005 Worked as a Senior Consultant in the Role of Offshore Technical Architect. Project Title :Nielsen Client and Duration: Neilsen,- To- Details: Worked as Offshore Technical Architect and Project Lead for this project. Responsibilities also included Use Case Analysis, Design, Code Reviews,Coding, Integration, Building, Testing, Documentation (using NDoc), Delivery, Deployment, Preparation of Build Plan, Release Notes, Client Meetings, preparation of Weekly Summary Reports, maintaining Issue Log for issue tracking & resolution, Configuration Management, Staffing ,etc. Technologies:BizTalk, ASP.Net, C#, .Web Services,SQL Server,Web Methods,etc Team Size: 12 Role:Tech Lead Project Title : HomeBanc Client and Duration: Homebanc Mortgage,- - Details: Role involved responsibilities of High Level Designing, Code Reviews, LLD Reviews, assistance in resolution of technical problems, Performance Tuning of Backend & Web applications. Technologies:ASP.Net,VB.Net,Web Services,SQL Server,etc Team Size: 10 Role:Tech Lead Organization: Accenture Duration: Oct 2003 – Dec 2004 Worked as a Senior Software Engineer in the Microsoft Avanade BU in the role of Technical Lead. Project Title : Northern Natural Gas (SQL Server) Module Lead. Client and Duration: NNG,- To- Details: Worked as SME (Subject Matter Expert) for SQL Server . Work involved total ownership of Database,its Schema & developing Stored Procedures for implementing business functionality. Technologies:SQL server 2000. Team Size: 5 Role:Tech Lead Project Title : RAP!D 4.0 (Remote Automated Processing of Input Data) Client and Duration: Hilton Hotels, (US), 16-Jan-2004 – 30-July -2004 Details: RAP!D enabled Hotel Staff users to very efficiently and effectively manage Importing Hotel Reservations Data into a local Database wherefrom it is uploaded into a CRS (Centralised Reservation System) via TIP Server using XML to format data in a proprietary format called STIF format,after various kinds of processing. Technologies: ASP.Net, VB.NET, C#.NET, SQL Server 2000, Visio 20 Team Size: 7 Role: Tech Lead Project Title : PMS (Property Management System) Client and Duration: Hilton Hotels (US), 1-Oct-2003 To 15-Jan-2004 Details: PMS System is a Desktop application that is used by Hotel to handle its daily affairs like House Keeping,Generate Reports like Night Audit,etc, Allot Rooms, Compute Room Rates depending on Customer Profile,Mode of Payment,etc. Some of the technical challenges faced during the Maintenance of the project: 1. Interpreting the Extremely Componentized Code implemented over 6 years by various coders,that too without any Documentation. 2. Doing Regression testing after enhancements,since a large number of Components were held in MTS (with no source code) ,proved very tedious. Technologies: VB 6.0 Visual Studio 6.0 SQL Server 2000 , Visual Source Safe. 6.0 Team Size: 5 Role: Tech Lead Organization: Syntel India Ltd. Duration: Aug 2000 – Sep 2003 Worked as a Senior Analyst in the role of Project Lead. Project Title :EQuIP (Enterprise Quality Information Processing) Client and Duration: Internal Application, 03-Feb-2003 To 15-Sep-2003 Details: The Web-Equip is a Web-Enabled version of an earlier windows based application called EQuIP, developed using ASP.Net & C# with SQL Server 2000 as the backend. This system allows online tracking of Quality Information related to syntel. It provides various reports in addition to mandatory Time-Activity Tracking of employees. Imlpemented in phases, was to be a flagship product for the company.It is designed to interface with other existing applications for it functioning. Technologies : ASP.Net, C#.Net, SQL Server 2000,Visio 2000 ,Visual Source Safe 6.0 Team Size: 8 (Peak Size 10) Role: Project Lead Project Title :Pegasus (Passenger Management System) Client and Duration: Airtours International Holidays (MyTravels Airlines UK.) 5-Dec-2000 To 31- 01 – 2003 Details: The Passenger Management system is basically a application that provides complete functionality to AirTours Aviation Division (which includes many Airlines in Europe & Canada which receive Passenger Manifests from their own Reservation systems in addition to various Tour Operators) like Pre-Order Sales,Automatic Passenger Seating Arrangements/Layouts generated on the fly,etc. eventually generating myriad of Reports like those sent to Caterers, Bonds, Departure Control Systems,etc. Technologies: VB 6.0, SQL Server 2000 ,HTML, Visual Source Safe. 6.0 Team Size: 6 Role: Module Leader Project Title : Pegasus Data Migration Client and Duration: Airtours International Holidays (MyTravels Airlines UK.),01-Oct-2000 To 30-Nov-2000 Details: Executed On-Site. Basically it implements customized migration of MS Access based data to the proposed SQL Schema. Technologiess: VB 6.0, Ms Access 97, SQL Server 7.0 Team Size: 1 Role: Developer. Organization: Rave Technologies India Pvt Ltd Duration: Jun 2000 – Aug 2000 Worked as a Software Engineer. Project Title : Policy Master Client and Duration:Sirius solutions, UK ,June-2000 To Aug-2000 Details: The system is responsible for tracking activities related to Insurance such as Claims, Claim Types,etc Technologies: VB 6.0, SQL Server 7.0,Rational Rose Team Size: 6 Role: Developer Organization: Sang Information Systems Duration: Aug 1999 – Nov 1999 Worked as a Programmer Client and Duration: JSA Group, UK ,Aug-1999 To Nov-1999 Details: This was typically a Client-Server application which provides a generic but comprehensive Financial Solution to virtually any kind of Contracter. Technologies: VB 5.0/6.0, SQL Server 7.0,Rational Rose,Visual Source Safe. Team Size:7 Role:Developer. Organization: DNC Data Systems Duration: Jun 1998 – Aug 1999 Worked as a Programmer Project Title : DNC ERP Client and Duration: (In-House Project),01-Nov-1998 To 13-Aug-1999 Details: A comprehensive automation solution to address the Organization's day to day activities aand workflows. Technologiess: VB 5.0,VC++ 5.0,MSSQL 7.0,Visual Source Safe. Team Size: 5 Role: Developer. Project Title : Task Scheduler Client and Duration: (In-House Project),15-Sep-1998 To 30-Oct-1998 Details: Developed as a component of the bigger workflow Automation project to enable scheduling and automatic execution of batch jobs and activities. Technologiess: VB 5.0,Visual Source Safe. Team Size: 1 Role:Developer Project Title : Proprietary Calendar Control Client and Duration: (In-House Project),01-Sep-1998 To 15-Sep-1998 Details:Details can be shared on demand. Technologies: VB 5.0,Visual Source Safe. Team Size: 1 Role: Developer Project Title : Proprietary Table Control Client and Duration: (In-House Project),01-Jul-1998 To 30-Aug-1998 Details: Details can be shared on demand. Technologiess: VC++ 5.0,Visual Source Safe. Team Size: 3 Role: Developer Project Title : SGML Tagging Editor Client and Duration: (In-House Project),15-Jun-1998 To 30-Jun-1998 Details: Details can be shared on demand. Technologiess: VB 5.0,Visual Source Safe. Team Size: 1 Role: Developer. Organization: ProDesign Information Systems Worked as a Programmer Duration: Jun 1997– Jan 1998 Project Title : Centre Management System Client and Duration: In-House Project, : 05-June-1997 To 31-Jan-1998 Details:This system was responsible for tracking day-to-day activities of a Training Centre like Student admissions, Training Progress,,Pending dues,Library activity tracking,etc, including generation of many Text Reports. Technologiess: VB 4.0/5.0, Ms Access 97 Team Size: 8 Role: Developer Project Details : B.E (Final Year) Academic Project Project Title : Image Compression & Decompression (Implemented JPEG, RLE formats) Details:A DOS-based application that extensively used C++ to Implement Image Processing algorithms from Digital Signal Processing domain. These algorithms were based on Fourier Transform Integrals, which was pretty challenging to be implemented in pure C++. Additionally the system was capable of capturing any screenshot & Compressing / Decompressing the Image according to the Compression Factor selected by the user. The Compression Factor determined the Image Quality and thereby the size of the Compressed Image file. The system, actually demonstrates the working of Digital Signal Processing, where higher frequencies' representation is removed from the Image, still retaining the spatial Information of the Image which is not recognised by the eye. Technologies: :Turbo C++ on MS DOS platform Duration : 7 Months Role : Development.