Database architecture & tuning
Schema design for transactional systems, index and query optimisation, stored-procedure refactoring, recovery planning, encryption and access control.
Available for consulting assignments
Uttam Rawat
Software Consultant · Technical & Delivery Lead
Nineteen years of building enterprise systems that hold up in production — ASP.NET and C# on the front, deeply tuned SQL Server and Oracle underneath. I design the database, architect the system, lead the team, and stay accountable for the delivery date.
UR
19+
years in the field
- 0Years of experience
- 0Years hands-on RDBMS
- 0Enterprise deliveries
- 0Years with Microware
Solutions delivered for
UNICEF◆Michelin◆Maruti Suzuki◆Hamdard◆FICCI◆Reliance Foundation◆JSLPS◆Oxfam◆Diamond SIS · USA◆
◆◆◆◆◆◆◆◆◆
01 — Profile
Engineering leadership, from the schema upward
I am a software consultant and team leader who has spent the better part of two decades turning business requirements into systems that thousands of people use every day — donor CRMs, dealer portals, distribution and inventory platforms, and monitoring dashboards for development programmes.
My strongest ground is the database. I have designed and optimised schemas that carry heavy transactional load, rebuilt query paths that were quietly costing hours, handled recovery situations, and put process, security and encryption controls around data that has to stay confidential. Above that layer I take on system study and SRS, technical architecture, implementation, and the client conversation that keeps all of it aligned.
At present I lead the delivery team on the JSLPS engagement, helping hold the whole system together while continuing to innovate on techniques and features. I have been with Microware Computing & Consulting since 2013.
02 — Expertise
What I am brought in to do
Four capability areas that recur across every assignment I have delivered.
Application engineering
Enterprise web portals and Windows applications on the Microsoft stack, from front-end screens to Windows services and third-party system integration.
MIS & reporting
Management dashboards, physical and financial progress tracking, flexible ad-hoc report builders and charting for programme monitoring and evaluation.
Team & delivery leadership
System study and SRS, technical architecture, planning, progress reporting to senior management, direct client liaison and on-time delivery ownership.
SQL Server & database design
ASP.NET / C#
System & solution architecture
Reporting & BI tooling
Team leadership & delivery
03 — Career
Employment record
Five organisations, one consistent thread: build it well, ship it on time, keep it running.
-
Dec 2013 — Present
Microware Computing & Consulting Pvt. Ltd. India
Software Consultant & Team Lead
Software development, performance tuning, optimisation of programs and databases, team management, delivery ownership and troubleshooting. Currently leading the team on the JSLPS engagement.
-
Jan 2013 — Dec 2013
Crocus Infotech Pvt. Ltd. India
Software Engineer
Application development and optimisation across client engagements.
-
Nov 2009 — Dec 2012
Magnon International Pvt. Ltd. India
Software Engineer — Development & DB Design
Software development and database design for marketing and dealer-facing platforms.
-
Sep 2007 — Sep 2008
Visesh Infotecnics Ltd. India
Software Engineer
Software development and database design.
-
Jan 2006 — Jul 2007
Source IT India Ltd. India
Software Developer
Application development — where the career began.
04 — Selected work
Projects that shaped the practice
Enterprise portals, kiosk and desktop applications, and monitoring systems for global brands and development organisations.
UNICEF CRM Portal
A CRM automating the online donation programme of the country's largest UN organisation — used by marketing, accounts and CRM teams alongside telemarketing vendors. Covers user and agency management, donor management, the retention process, corporate fund raising, MIS reporting and a CMS, integrated with UNICEF's Donor Perfect system. The dialer binds to the CRM on a unique lead ID so agents log appointments, outcomes and new detail live during the call.
- Database design, system design and live testing
- Technical architecture
- Direct requirement gathering with the client
- Progress reporting to senior management
Michelin Dealer Portal
A national platform for Michelin tyre dealers across India: order placement, schemes applicable to each dealer's territory, target-versus-achievement tracking and account statements. Dealers create end users to grow their own sales, and both dealers and end users file warranties online to earn bonus points.
- Coding, design and client-end implementation
- Database and system design, live testing
- Technical architecture and client interaction
Hamdard Sales Portal
An inventory and distribution portal for mid-size and corporate enterprises — goods receipt, sale and purchase, disposition, transfers and live stock status at any point in time. Includes Single Sign-On, so one authentication carries the user across every application they hold rights to with no repeated prompts inside a session.
- Database design, system design and live testing
- Technical architecture, SSO implementation
- Client-end implementation and rollout
Maruti Marketing Portal — CARS
Comparison Analysis and Reporting System: an intranet application letting Maruti's marketing team view, compare and analyse car data across manufacturers. Category reports for sales, fuel capacity and more, flexible day-to-day report generation with charting, and an administrator module managing manufacturer, segment, model-variant, specification, fuel price and price / sale / production uploads.
- Coding, design and client-end implementation
- Technical architecture
Contact Organizer
FICCI's central databank of industry, government and diplomatic contacts, accessible and updatable by every department and office. Users filter people by their own criteria, build private contact groups, export to labels, lists and tables, search the membership database for member organisations, and manage event participants.
- Front-end programming and screen design
- Coding, design and client-end implementation
- Module testing
Michelin Kiosk Application
A kiosk installed at dealer locations, letting the dealer register a customer's warranty on the spot. Successful registration enters both dealer and end customer into daily, monthly and yearly prize draws.
- Coding, design and client-end implementation
- Database design, system design and live testing
Monitoring & Evaluation MIS
Plantation monitoring and a full M&E system with a dashboard for project information — physical and financial progress, M&E indicators selectable graphically and spatially, status monitoring, capacity-building and village-meeting records, a ready reference for contact points and project structure, and village-level intervention MIS.
- Coding, testing and implementation
Diamond Student Information System
Work with a US channel partner on a school management platform trusted at more than 270 campuses — student management, financial and operational efficiency, and reporting tools that satisfy accreditation and government requirements.
- Front-end programming and screen design
- Built the full graphing and charting capability
05 — Education
Qualifications
2011
Master of Computer Applications
Sikkim Manipal University
2008
Bachelor of Computer Applications
Sikkim Manipal University
2003
GNIIT
NIIT
2003
Bachelor of Arts
HNB Garhwal University
Languages
EnglishExcellent — read, write, speak
Hindi (native)Excellent — read, write, speak
06 — Contact
Let's talk about your system
Consulting assignments, architecture reviews, database rescue work or delivery leadership — write to me and I will respond personally.