Utkarsh Puranik

HELLO, THERE I’m Utkarsh Puranik
SOFTWARE ENGINEER based in Indore, India.

  • 14+ Experience
  • 20+ Applications

About Me

I am a seasoned technology and project management professional with over a decade of experience in delivering quality software in diverse environments. I strive to stay updated on technological front and learn new things. Apart from work, I am a history buff, I enjoy listening/reading to history podcasts, audiobooks, books.

Technical Skills

  • C#
  • SQL
  • JavaScript
  • .NET Core
  • AWS
  • Serverless
  • Containers
  • Kubernetes
  • .NET Core MVC
  • GitHub
  • HTML
  • Microsoft Azure
  • Team City
  • Octopus Deploy
  • ASP.NET
  • Python
  • Snowflake
  • React
  • REST
  • PowerShell

Other Skills

  • Software Architecture
  • System Design
  • Project Management
  • Cross functional team leadership
  • Agile Methodologies
  • Cloud Development
  • Technical Architecture

Work Experience

2022 - Present

Sage

Principal Software Engineer

Working in Platform Engineering team.

2015 - 2022

WM Universal Solutions

Digital Deputy Manager

I was challenged by the Digital Group Director to take a technical management position in the Elements project which is Self Service Business Intelligence application as the team would benefit from my overall domain and business unit process understanding and I would get management exposure.

  • I realigned the team towards domain and data understanding as the function of the team was to understand the business requirements, correlate them with the data and identify technical changes to resolve the issue. Earlier, the team was only focused on the technical side which made the correlation part difficult and a lot of time wasted in the analysis.
  • Led the modernization of the existing On-prem SSIS/SQL Server data warehouse platform to Cloud (Snowflake/Matillion). Redesigned multiple subject areas to foundational issues and improve data quality.
  • Designed and led the development of Natural language Narratives for business data to be sent as a Summary of key data points available on the BI platform. Identified a generic design that allows for minimal to no efforts for new data point addition. The solution contained many moving parts like Frontend, Backend, API layer, ETL components and third party API.
  • Wrote an application to provide waste data to US Environment Protection Agency (EPA) system, Energy Star for Customers who were tracking this information for their Sustainability goals.
  • Wrote a solution using AWS components (Lambda, API Gateway, CloudFront, CloudFormation, S3) to generate thumbnails for images received in Data acquisition to allow reports to render faster.
Principal Software Engineer

As a Principal Engineer, I was responsible for the design, development, unit/integration testing and deployment of Projects and continuous improvement items.

  • Designed and implemented end-to-end integration of WM National accounts with servicechannel.com to provide a seamless service experience to customers. Customer location managers can request and track service status in near real-time.
  • Designed and developed a mobile web application for repair technicians going in the field to repair compactors to check in, check out and log summary back to Microsoft Dynamics Nav. The web app can function offline and syncs back on internet availability.
  • Designed and wrote application interfaces for software vendors of Trash hauling companies. Integrated these interfaces to WM National Account applications to provide work order, service and tonnage updates to Customers.
  • Managed, improved and automated archaic process of code generation through an ORM tool on the legacy application.
  • Led the design and development of Configure Price Quote (CPQ) project which automated the pricing process which was a 1200 column excel file being shared with multiple people for different column data. The process was broken up and flow was managed through this application.
  • Travelled to an onsite business location (Windsor, CT, USA) for knowledge transition on a workflow project and to revive development/improvement efforts that were stalled out due to people leaving the organization. It used a specialized workflow tool Sequence (by PNMSoft). Revived the process and had all the high & medium priority efforts completed within 6 months.
  • Established Continuous Integration (CI) process for Build and Deployment using Team City and environment-based deployment workflow using Octopus Deploy.
  • Generated more than 50 SQL Reports within 2 months to provide business team insights into the parameters of key processes. These reports in turn help them identify new applications to improve the business process and drive efficiency in existing ones.
2011 - 2014

Tata Consultancy Services (TCS)

IT Analyst

Worked as Consultant for two clients over a 4 years time-span

National Commodities and Derivatives Exchange (NCDEX)
  • Designed and implemented integration of NCFE (NCDEX Clearing Front End) system with COMTRACK (Commodity Depository System) for physical settlement of commodities. Used files-based instructions for various steps of the process like blocking and release of commodity lots based on reconciliation.
  • Integrated with organizational CRM to align with Company Master data
  • Led a team of developers to design and develop a web application to manage Collateral margins for exchange member broking companies.
  • Created and maintained a build deployment process
Westpac Corporation
  • Designed and wrote a system to implement RSA SecurId for management of accounts and during transfers to secure transactions on Business banking tools for Westpac's St George Bank, Bank of Melbourne and BankSA.
2008 - 2011

Diaspark Infotech(Earlier SUVI Information Systems)

Software Engineer L2

Started my career at this company as a Junior Software engineer and got promoted to Software Engineer L1 within a year and to L2 a year after that.

  • Worked on a windows to web migration of agency management product for Sandata Inc. Worked against very tight deadlines and developed high-quality product.
  • Designed and implemented a Data import process for Sandata Inc to receive agency/patient data from Medicare and Medicaid. Received Crown of the fortnight award for it.
  • Started as a junior engineer in a New York Times project. Being first on the project, created several prototypes to achieve requirements. Developed the system from scratch and integrated it with Epsilen learning management platform.
  • Experimented with Silverlight as it was first released and wrote a music player which could play local songs or stream online music while maintaining a library.

Education

2004 - 2008

Mahakal Institute of Technology, Ujjain

Bachelor of Engineering (Information Technology)
  • Designed and implemented a system for managing point of sale (POS) at a store, managing inventory and transactions as a major project for the final semester.
  • Attended training at Training Centre, IIT Roorkee for .NET and created a shopping cart software like Amazon, being the only team (2 developers) out of 80 students from all over India.
  • Wrote a system to manage a music shop, managing inventory of albums as a minor project.