Inderjit Rana Email & Phone Number

Minneapolis, Mn, Us

Redmond, Washington, Us

Redmond, Washington, Us

- Work with the field sales team to help Health Care customers architect Azure Cloud Solutions with focus area of Data and AI which includes Databases, Big Data Analytics, Machine Learning and pre-built AI using Cognitive Services.- Work with customers to develop architectures leveraging Azure Cloud Platform meeting their business and IT requirements.- Serve as a key technical resource to the customer throughout the implementation lifecycle guiding them with best practices and eliminating technical blockers.- Advance technical skills continually, share the learnings with the technical community as well as feedback loop for the engineering teams building the Azure Platform.- Strong presentation skills to demonstrate bigger picture to leadership as well as dig deep into details for implementation efforts.- Hands-on architect with the ability to peform Proof of Concepts and lead development efforts.

Redmond, Washington, Us

Us

- Working on migrating a set of websites implemented in Java with Oracle database backend from on premise datacenter to AWS. - Responsible for implementing infrastructure provisioning code using Terraform, the environment consists of IaaS VMs for Apache Web Server, Tomcat Application Server, Oracle database and Wordpress blog. - AWS services utilized consist of VPC, VPC Security Groups, Internet Gateway, NAT Gateway, EC2, S3, Load Balancer, AMI, IAM and Code Commit.

• Worked in a DevOps role for the implementation of Big Data Analytics Platform on Microsoft Azure Cloud for the data received from Internet of Things devices, the platform consists of combination of PaaS and IaaS services and utilizes various Open Source tools and technologies including Apache Spark on Hadoop, HBase, OpenTsdb, KairosDb, Docker, Docker Swarm, Java Spring Boot, MongoDb, Cassandra, Ubuntu Linux, CentOS Linux, Python and R.• Responsible for implementing the CI/CD Pipeline for infrastructure provisioning, micro-service and spark jobs. Infrastructure provisioning code consists of Azure ARM Templates, Powershell and bash scripts. A variety of Micro-Services and Spark Jobs jobs written using Java Sprint Boot, Machine Learning Models in Python and R.• Used best practices for the CI/CD pipeline, GitHub Flow workflow followed for feature branches of the code, Bamboo Branch Builds and Octopus Channels used to validate feature branches before merge to master so that the Release Pipeline is always in good state.• Implemented Docker Image scanning for identifying security vulnerabilities using Twistlock as part of the CI/CD pipeline• Implemented monthly patching process for IaaS VMs where Packer was used for building new images and Blue Green Deployments for replacing old VMs with new VMs created using patched images.• Azure Services utilized in the infrastructure stack include VNET, Azure Storage, Load Balancer, Application Gateway, VM Scale Sets, Log Analytics, HDInsight, KeyVault, Azure Virtual Machines, CosmosDb, Log Analytics, Azure Resource Manager, Azure DNS Zone and Azure AD.

Minneapolis, Mn, Us

• Served as an architect for the Behavior Modelling application used to model the withdrawal pattern for investments.• Worked on design and implementation of load process responsible for loading the daily financial derivative trades (Options, Futures, Swaps, etc.) into database. • The application were implemented using good design principles where loosely coupled components where glued together using a IOC Container, business logic tested using Mock Framework without any dependency on the database. • Technologies used are Microsoft .NET Framework C#, SQL Server, Moq, Castle Windsor, NLog, etc.

St. Louis Park, Mn, Us

• Worked on building a generic Software-as-Service web-based platform to manage health care questionnaires (like health assessments, advanced care planning, etc.) and incorporating the information into Electronic Medical Records. • The system consisted of a set of single-page web applications hosted on Microsoft Azure, AngularJS front-end and ASP.NET MVC Web Api back-end over SQL Database using Entity Framework.• The applications follow good architectural principles of loosely coupled components tied together using Unity Dependency Injection container• Unit Testing for both server-side as well as client-side code with very high code coverage enforced by the build process.• Technologies Used: AngularJS, Mocha, Karma, ASP.NET Web API, Azure App Services, Azure Storage, SQL Database, Entity Framework, NLog, Unity, Bitbucket, Git, JIRA.

Toronto, On, Ca

• Worked on Project X team for a web-based product to be used by Legal Firms to manage lifecyle of cases. The software product was hosted on AWS Cloud Environment and implemented using Microservices Architecture.• Responsible for evaluation of various AWS services (S3, RDS, Lambda, IAM, VPC, etc.) to recommend cloud-centric solutions.• Worked on deployment strategy for AWS Lambda and RDS, performed proof of concept to provision MySQL and Aurora RDS instances using Terraform Templates.• Worked on implementation of web front-end using AngularJS• Technologies Used – AWS, Terraform, Powershell, ASP.NET 5 Core, ASP.NET Web API, ASP.NET MVC, AngularJS

Minneapolis, Mn, Us

• Worked on Capital Market Solution group responsible for Hedging the portfolio risk using financial derivatives like Futures, Options, Interest Rate Swaps, etc. The requirement of the system was to run computation intensive financial models which follow the embarrassingly parallel paradigm on a High Performance Computer Grid. Microsoft HPC Grid was implemented on IBM SoftLayer cloud to make use of classic cloud model where resources are fluid and can be increased or decreased based on computation need. • Responsible for design and implementation of the Grid Submission module which exposed a very flexible interface to allow financial engineers to send any program binaries along with input data to the Microsoft HPC Grid for processing without requiring knowledge of the Computer Grid or the underlying infrastructure. • Worked on design and implementation of load process responsible for loading the daily derivative trades into database. The design of database structures required gaining understanding of the derivatives. The application was implemented using good design principles where loosely coupled components where glued together using a IOC Container, business logic tested using Mock Framework without any dependency on the database. • Implemented the Change Management using SharePoint Workflow to stream line the approval process with all the information recorded on SharePoint lists and easily accessible for audit purpose, the user base consisted of Corporate Actuary, IT Operations and the management team.• Technologies Used - C#, .NET Framework, Entity Framework, Task Parallel Library, WCF, Powershell, SQL Server, Microsoft HPC, IBM SoftLayer Cloud, Castle Windsor, Moq, Nlog, SharePoint 2013, SharePoint Workflow

St Louis Park, Minnesota, Us

• Responsible for leading the design and development effort for the application used to manage the purchasing of Mortgage Servicing Rights for loans. The whole business process was automated using Windows Workflow which included exchange of loan transactions files with business partner, execution of pricing engine, approval process for making the final result files available to counter parties and upload of the transaction files to Amazon S3 Storage for data warehouse needs.• The application was implemented using Windows Workflow hosted in Windows Server AppFabric and exposed as a WCF Web Service, a set of services were also exposed for the front-end application to display workflow state data.• Involved in the design of the front-end ASP.NET MVC application used by the counter parties for exchange of loan transaction files and the internal users to communicate with the workflow application.• Responsible for researching and recommending the strategy for Amazon Cloud Services, specifically setup Simple Storage Service (S3) and the security using Identity and Access Management (IAM).• Responsible for setting up the Team Sites on SharePoint Online (part of Office 365) for issue tracking, task management, documentation and workflows for change management approval process. • Technologies Used - .NET Framework 4.5, C#, Windows Workflow, Windows Server AppFabric, Microsoft Business Rules Engine, WCF Services, ASP.NET MVC, ASP.NET Web API, Entity Framework, Knockout, Jquery, Amazon Web Services (S3 and IAM), Git, SharePoint Online, SharePoint 2013 Workflow, Log4net

Minneapolis, Minnesota, Us

• Served as an architect for the service layer around Box Tops for Education Program data which has over 100,000 participating schools and millions in yearly payout (2012 payout was over $74 million). The marketing program allows schools to earn cash by clipping physical BoxTops coupons on hundreds of products as well as eBoxtops which are earned by shopping online from business affiliate websites. The program also requires a complex fulfillment process which includes verification and enrollment of schools, box tops submission processing and school payout, an external business affiliate engaged as a fulfillment partner.• The WCF service web application exposed services consume by a variety of clients - public website BoxTops4Education.com which is the interface for school users, Java Web application to manage fulfillment process implemented by a business affiliate and Internal web application for administrative tasks.• Scheduled jobs for various miscellaneous needs like sending email notifications, processing of bonus eBoxTops earnings information received from online retailers.• WCF service web application followed layered architecture with persistence ignorant business entities, data access layer implemented using NHibernate and data transfer objects used to insulate service interface data from the underlying business entities. Loosely coupled system built with Castle Windsor Dependency Injection container for dependency injection.• Implemented an extensive suite of unit and integration tests for automated testing of the application components with Moq Mock Framework for mock implementation of dependencies.• Implemented the jobs responsible for communication with bank for payout process which included generation and secure transmission of files (SFTP) to bank for issue and void checks, processing of Issue Confirmation, Void Confirmation, Paid Confirmation and Outstanding Balance files received from bank to reconcile data in the system with bank records.

Minneapolis, Mn, Us

Consulting Client through Tech-Pro- Worked for the Capital Market Solutions team responsible for running complex financial simulations that crunches billions of operations on millions of records daily to forecast financial impacts on the company. The computation intensive nature of the application required running the application on high-performance computer grids. Platform Symphony and Milliman C2 were the middle-ware used for distribution of tasks to the grid nodes. - Implemented WCF Services which provided a simple interface for Grid Job Submission and retrieval of results to the consumer Hedging applications. The service layer hid all the complexity related to communicating with computation grids, packaging of the financial model binaries and inputs like policy data.- Services were implemented using a highly extensible and configurable architecture to allow easy addition of new simulation models or even new grid middle-ware. All the process steps to be executed on the web server and the grid nodes defined in XML Configuration, the steps relevant to particular simulation model and grid were selected based on the parameters in the service method calls by the consumer applications.- Responsible for architecting the next generation of the Hedging Application where the entire business process of running the simulation model as well as generating the inputs required by model implemented using Windows Workflow exposed as WCF Service. - Windows Workflow used the Tracking and Persistence features to record workflow execution state to SQL Server database provided by Windows Server AppFabric. The workflow state data allowed error recovery and also served as the store for reporting/administration user interface (ASP.NET Web App)- Technologies Used: Microsoft Visual Studio 2010, .NET Framework 3.5/4.0, C#, WCF, Windows Workflow, Windows Server AppFabric, ASP.NET, Entity Framework , Windows Services, SQL Server, NLog, MSBuild, Platform Symphony, Unity Application Block

Roseville, Mn, Us

Minneapolis, Minnesota, Us

Consulting Client through Tech-Pro• Working on the Manufacturig Quality Information System (MQIS) Team responsible for applications used on the plant floor intended for improving the product quality and traceability of ingredients going into various products.• Responsible for architecting the server-side solution exposing a set of WCF Services to be consumed by various clients including Smart Client applications and AS1 Workflow Tool (third-party Workflow Tool specialized for Manufacturing Operations) through a wapper API. The service solution was implemented using a layered architecture with WCF services at the top, persistence ignorant domain objects accessed by the services using repositories, persistence to Oracle database implemented using NHibernate with Fluent NHibernate Mappings. • Implemented a suite of .NET Compact Framework 3.5 applications for mobile devices (Windows CE) with scanning capabililties to be used on the plant floor, application forms used Mobile MVC Framework for separation of concerns and all server communication implemented using WCF Services with Basic Authentication over SSL.• Technologies Used: .NET Framework 4.0, Visual Studio 2010, .NET Framework 3.5, Compact .NET Framework 3.5, VB.NET, WCF, Web Services, LINQ, Oracle, NHibernate, Log4Net, Mobile MVC, AS1 Workflow, SQL Server 2008, Team Foundation Server, Infragistics Control Suite

Evansville, In, Us

Consulting Client through Tech-Pro• Worked on the implementation of Bid Quote System used by the Pricing Department to manage special pricing and rebates for large volume bids. Application managed the complete process of creating special price quotes for distributors selling products to end clients (hospitals, schools, etc.), converting quotes to formal contracts referred to as bids and the rebate process after the sale.• The application was a rewrite of an older system which over time grew into a multitude of VB 6.0 applications, an ASP.NET web application and numerous Access applications. The new system developed was an N-Tier ASP.NET 3.5 application with SQL Server 2005 database and SQL Reporting Services for the reporting needs, it provided integrated system eliminating the need of several little application add-ons.• The application implemented role-based security and was accessible to internal office users as well as external sales users on internet.• Led the development effort for the project, responsibilies include co-ordinating tasks among developers, mentoring less experienced developers, provide help for any technical questions, work with business to define the requirements, understand the problem domain, devise solutions, establish time estimates, design and implement the application as per the requirements with continuous feedback from business users.• Technologies Used: Visual Studio 2008, ASP.NET 3.5, C#, SQL Server 2005, SQL Reporting Services, AJAX, AJAX Control Toolkit, Javascript, Iron Speed, Log4Net, SVN, Tortoise SVN

Consulting client through Tech-Pro• Worked on ASP.NET internet applications used by customers to search and select carriers with best rates for their transportation needs, carriers to bid on the shipment rates and also used by internal staff to perform some of the administrative work. • Responsible for implementing and configuring WCF services for exchange of information between business partners (including communication between disparate technologies). In one specific scenario, enabled a business partner to incorporate carrier rate information from LPS WCF service in their PHP web application.• Implemented SSIS packages for Freight Payment system to integrate invoice information received electronically from business partner. Developed another set of SSIS packages which used audited invoices to create and transfer payment files in XML format to Wells Fargo Payment Manager service for disbursement of funds to carriers using ACH and International Wire Transfers. • Implemented presentation layer of Keyship Express set of applications, the business and data access layers were auto-generated using CodeSmith, data access layer used ADO.NET Entity Framework for database interaction. The architecture used loosely coupled layers, the presentation layer referred to all business entities by interfaces retreived using Dependency Injection without any reference to concrete implementations. • Responsible for enhancements to KeyShip KeyFreight, reviewed the implementations provided by the off-shore team and worked on upgrades for the application to use new framework. • The build process enforced best practices and coding standards using FxCop and StyleCop, all custom code in the business and data access layer was required to be accompanied by NUnit Tests.• Technologies Used: C#, ASP.NET 3.5, Forms Authentication, Membership API, .NET Framework 3.5, Visual Studio 2008, XML, XSD, AJAX, AJAX Control ToolKit, JQuery, WCF, ADO.NET

Minneapolis, Minnesota, Us

Consulting Client through Tech-Pro.Worked on Distribution List System (DLS) phase of the application which was implemented as an addition to the much bigger web-based Customer Relationship Management System developed internally. DLS collects and maintains product distribution information for the General Mills products distributed to secondary buyers through different channels. • Worked with Team Lead to define scope of the sub-system, document requirements using use cases and prototypes.• Development followed Scrum Software Development process with three-week iterations and daily stand-up scrum meetings, all the requirements were tracked using TFS Work Items to generate accurate burn down charts for each sprint and automated tests were implemented using NUnit. • Technologies used: VB.NET, ASP.NET 3.5, LINQ, AJAX, AJAX Control Toolkit, Visual Studio 2008, Team Foundation Server, Oracle, NHibernate, NUnit, Watin and Excel Package.

Billerica, Ma, Us

Consulting Client through Tech-Pro.

Minneapolis, Minnesota, Us

Consulting Client through Tech-Pro.

Us

Consulting Client through Tech-Pro.

Us

St. Paul, Minnesota, Us

Master Of Science, Computer Science

Education record