Aug 2017 – Feb 2018 · 6 mos · Greater New York City Area

• BI-Connector: Team is responsible for development of BI Connector. The BI-C lets you use MongoDB as a data source for your SQL-based BI and analytics platforms. It receives SQL queries from various BI platforms and translates them into appropriate MongoDB queries, which are sent to MongoDB. If it is not able to send the queries to MongoDB then it does in-memory operations to perform those queries E.g. (Join, Union etc.). It supports MySQL wire protocol to accept queries and results are sent back using MySQL wire protocol.
• Implemented push down functions to MongoDB.
• Optimized queries with no column reference to database in field list.
• Fixed parser issue related to parenthesis.
• Memory Manager for BIC to handle unpredictable growth of in-memory operations.

Oct 2016 – Aug 2017 · 10 mos · San Francisco Bay Area

• Analytics Team: Analytics team in ColorTokens responsible for storing all logs. These logs are used for further analysis
• and reporting. Design and implemented analytics framework core components.
• Project:
• Design and implementation of schema of logs in Cassandra and Elastic search.
• Implementation of Kafka consumer and processing of logs in Apache Flink.
• Developed REST services in NodeJS for data access for the underlying Elassandra based data store.
• Design and Implemented analytics framework deployment script.
• Technology Worked on: Kafka, Apache Flink, Elassandra, NodeJS, shell script.

Feb 2015 – Oct 2016 · 1 yr 8 mos · San Jose

• Software Engineer, Backend Analytics Nanolog Development Team: Storage team in Zscaler responsible for storing transactions logs. These logs are used for further analysis and reporting.
• Project:
• 1. Zscaler Query Language: a generic query framework implemented in C that supports custom SQL like language on storage servers or any kind of storage logs.
• Implement a mechanism to generate metadata of logs to feed to query framework to query on it.
• Implementation of various mathematical functions (max, min, day boundary, month boundary, md5, histogram). - Bug Fixes and enhancement on Query Engine and Query Planner. - Disk based sorting (External Sorting).
• 2. A Query Scheduler/Executor for distributed data: Based on map reduced framework this Framework is responsible for performing parallel task on distributed servers.
• A distributed framework to run queries on multiple remote nodes and collect resultant data. - Runs any kind of command supported by the remote nodes.
• For SQL based queries ZQL and key-store framework is used to run map-reduce jobs. - Support wide variety of options for merging resultant data.
• Plugin framework to support export of resultant data framework various 3rd party tools.
• Data queuing framework to support reliable transport of resultant data to external destination.
• Implemented feature of splitting of queries among various redundant server for fast processing of data.
• Implemented feature to keep track of failed queries and re run them in daemon mode.
• Implemented packaging of this framework to install on any UNIX system (shell scripting). 3. Zkeystore Framework: A generic is a framework to store Key value pairs with a support for composite/hierarchical key values.
• Technology worked on: C, Perl, GIT, SVN , FreeBSD (UNIX), SQL, Shell Script
• Cerner

Oct 2012 – Jan 2015 · 2 yrs 3 mos · Kansas City, Missouri Area

• Cerner Corp, Kansas City, MO Oct 2012 – Present
• Software Engineer, PowerOrders Dev
• OrderWin32 Dev: Worked on design and development of various new features for Cerner’s Industry leading Millennium software suite using C++ and Java. Worked with PowerOrders team of Millennium software product. PowerOrders is the backbone of the Millenium system providing end to end services to manage patient care. It is the widely used HealthCare product by Physicians and Nurses.
• Projects:
• 1. Designed and developed a new UI page that helps external clients in billing processes.
• a. Solved complex physician workflow problems using various design pattern including Factory and delegation design pattern.
• b. Implemented the dynamic controls in Front end UI using VC++ with MFC libraries and STL libraries.
• c. Unit testing was done using Google Test APIs.
• d. Responsible for unscripted testing and black box testing for end to end solution.
• 2. Solved complex medication drug-drug interaction problem by enhancing existing feature and improved the performance of millennium product.
• a. The Project was implemented on frontend as well as backend side.
• b. Front-end changes were storing the override reason whenever interaction occurs and store them in STL collection and send the request to CCL (Cerner Custom SQL) scripts.
• c. Improved the performance of the query by breaking down the query into four different parts and reducing the join queries and at same point the increase the query performance by merging four same type of query into one query.
• d. Improved the performance of the query by reducing the database calls.
• e. Responsible for unscripted testing and black box testing for end to end solution.
• f. Created testing plan for database testing and implemented it.
• Technology worked on: Visual Studio 2010, VC++/C++, Tortoise-SVN, Google Mock Testing framework C++, PL SQL (CCL Script)

May 2012 – Sep 2012 · 4 mos · Alachua, FL

• Vitera Healthcare Solution, Alachua, FL May 2012 – Sep 2012
• Application Programmer I, RMS (Remote Monitoring System) Team
• Vitera Remote Monitoring System: Distributed application used to log information about Vitera products installed at customer site. It is also used to distribute software updates automatically.
• Improved the performance of query by reducing the processing speed from 1 minute to 22.
• Worked as developer for maintaining the sites that remotely monitor client systems that was used by internal developers for development of other products.
• Automate the process of active directory domain controller whenever new server is installed at the client site by creating various domain groups and assigning them privileges using PowerShell scripts.
• Technology worked on: Visual studio 2008, C#, ASP.NET, WPF C# in MVVM Pattern , C++, PostgresSQL and ClearCase

Oct 2011 – Dec 2011 · 2 mos · Herndon, VA

• Project: The Federal National Mortgage Association (FNMA) known as Fannie Mae was established to provide local banks with federal money to finance home mortgages in an attempt to raise levels of home ownership and the availability of affordable housing. Fannie Mae created a liquid secondary mortage market and thereby made it possible for banks and other loan originators to issue more housing loans. Mulitfamily department issues loan more than 4 units. The position was Production Support for Multifamily department. The project was to develop documentation of all application under multifamily as knowldge trasition and was part of Production support team to support application.
• Responsibilities:
• o Familiar with secondary mortgage market, and worked on aquisition and servicing phase of loan.
• o Shadowing the SMEs to solve issues specific to application.
• o Performed Root cause analysis to resolve business application issues.
• o Performed User Acceptance Testing (UAT) and shakeout testing during the release of application.
• Technology Worked On: Autosys, Toad, DbVisualizer , UNIX

Jan 2011 – Jan 2011 · 0 mo

• Software Engineer

Mar 2009 – Apr 2009 · 1 mo · New Delhi, India

• Project: The Defence Research and Development Organisation (DRDO) is an agency of the Republic of India, responsible for the development of technology for use by the military. The project was to migrate the Defense Library Management System (DeLAS) from Visual basic to Java and MS Access to Oracle.
• Responsiblities:
• Upgraded the Defense Library Management System (DeLAS) in Visual Basic with the help of Microsoft Access
• Debugging of Software and fixing issues and documentation of errors.
• feature enhancement of HRIMS software that contained the information of all the employees working in DESI DOC division of DRDO.
• Technlogy Worked on : Visual Basic 6.0 , MS Access

Jul 2007 – Jul 2007 · 0 mo · Gurgaon, India

• Project: Reliance Infocomm Limited provides telecom services in India. The company offers mobile and fixed line telephony services, including broadband, national and international long distance services, data services, Internet services, and a range of value added services and applications. The Project was design GUI of Softphone. A softphone is a software program for making telephone calls over the Internet using a general purpose computer, rather than using dedicated hardware.
• Responsiblities:
• Designed the prototype of GUI of Softphone in Visual Basic with the help of Oracle
• Generated the idea of how to advertise on the Softphone proficiently.
• Technology Worked On: Visual basic 6.0 , Oracle 9i