Chinmay

Contact : 512-***-****

sguruprasad@shaktisolutio

ns.com

EXPERIENCE SUMMARY

Over 15 years of experience in core development, team leadership, engineer & architect technical solutions, team

management, project leadership/management, IT Operations and Infrastructure support.

Core strengths: Logical Problem Solver, Adaptability, Excellent Communication, Quick Learner

A keen and fast learner with proven ability to implement gained knowledge accurately in a short turnaround time.

Enthusiastic about project domain with the ability to gain project specific domain knowledge to provide business

centric/oriented solutions. Worked with clients from diverse industries with effective results in each field.

Demonstrated capabilities in architecture, design and implementation of application performance monitoring and

enterprise monitoring tools and associated procedural guidelines. Involvement in security monitoring implementations for

PCI-DSS compliance.

Core expertise in Microsoft technologies covering development of multi-tier applications, web applications, portals,

middleware, windows based solutions and SOA with effective use of various Microsoft tools.

Practical focused knowledge of design patterns, development methodologies, and processes with a practical experience in

implementing them on projects. Proven record of process adherence.

Designed a framework that reduced web based development time by 60% and improved quality, stability, and scalability

of designed application.

Participated in ISO certification process and gained appreciation by demonstrating process compliance. Was chosen to

lead process audits performed by my employers client for assessing collaboration.

CORE TECHNICAL SKILLS

C# .NET, VB.NET, VB,

MS Office Add-Ins,

ASP.NET, MVC, Web XML, XSLT, XSD

C++, C

Forms, Web Services Templates and

extensions using VSTO

and VBA

Win Forms, Class

Reports,

HTML, JavaScript, Crystal T-SQL, MS SQL

Libraries

ExtJS, jQuery, Business Objects 2008/2012, Access,

Page 1 18

AngularJS, Bootstrap MySQL

Windows Services,

Workflow

RESTful Services, .NET OOPS, OOAD, SOA

WCF Services, User and

AJAX Server Controls, Foundation, WCF

Custom Controls

ASP .NET Server Workflow Services

Controls, Web API,

OWIN, OAuth

InstallShield, Pipeline

2.0/3.0

Incident Management, PowerShell PERL, Python, PHP

Pilot, Visual Studio

Enterprise Monitoring, Modules, Scripts,

2010/2012/2013, MS

Infrastructure Packages

Project

Architecture

INDUSTRIES

Manufacturing (Apparels, Jewelry)

E-Commerce (B2C Portals, B2B Portals)

Research (Automotive, Life Sciences, Healthcare)

Insurance (Claims processing)

Consumer/Business Services (Consumer Goods, Event

Pension/Retirement (Employer Reporting)

Management)

PROJECTS

Project: RCAR

Role: Sr. Software Developer

Client: HCSC, Naperville IL USA Jan 2016 Present

Project Brief:

Retail Core Admin Replacement (RCAR) project deals with migrating HCSCs core retail administration from in-

house software to SaaS based platform. The project consists of data conversion/migration activities followed by

building custom integration services to transfer data between systems.

Responsibilities:

- Responsible for design and development of SQL queries to aid in analysis of billing data and identification of

anamolies.

- Responsible for design and development of data extraction process for data conversion of billing financial

data.

- Responsible for development of SQL queries, procedures and functions to transform extracted billing

financial data to the required summaries and aggregations.

- Responsible for design and development of tools using .NET 4.5 to aid in optimal parameterized and

controlled execution of data conversion processes.

- Participate in design and architecture decision making and contribute to infrastructure requirement

specification.

- Assist in setting up SQL & .NET level performance monitoring using FogLight and dynaTrace.

Page 2 18

- Design and developed web based tool to assist business teams in researching data used in conversion.

Technologies:

.NET 4.5, MS SQL Server 2008, ASP.NET, MVC4,

Project: Updates to in-house applications

Role: Consultant Tech Lead

Client: CDW, Chicago IL USA Sep 2015 Jan 2016

Project Brief:

As part of revenue consolidation, the client needs its in-house applications to be modified and aligned to new

requirements. These softwares are used for cost tracking and billing for customer engagements.

Responsibilities:

- Responsible for overall technical design of changes required to realign software with new requirements.

- Providing design & development guidelines to team.

- Assist team in resolving development issues.

- Communicate technical progress with project management and business stake holders.

- Used ASP.NET web forms and DevExpress web controls in developing custom UI pages.

- Used C#, WCF, AutoMapper to design & develop custom application code to interface billing data with

PeopleSoft.

- Developed SQL stored procedures & functions for performing CRUD & handling complex business

operations used in processing.

Technologies:

.NET 4.5, ASP.NET 4.5, MS SQL Server 2012, Visual Studio 2013, TSQL, AutoMapper, Changepoint

Project: DPAS ER 2.0

Role: Sr. Software Developer

Client: Deloitte, Chicago IL USA Apr 2015 Sep 2015

Project Brief:

DPAS is Deloittes Pension Accounting System used by retirement systems in states of Massachusetts, Illinois,

Kentucky, Tennessee, and West Virginia. ER 2.0 was aimed at enhancing the Employer Reporting components

of DPAS to address latest requirements, provide flexibility, streamline technical & business needs and provide for

optimized operations. Enhancements involved factoring data structures associated with employer reporting,

designing staging storage tables for addressing contentions, redesign and development of reporting wizard in the

employer portal, and redesign of the batch processing modules.

Responsibilities:

- Responsible for design and development of the reporting wizard.

- Used ASP.NET web forms and web controls in developing base for the reporting wizard.

- Used Bootstrap library to provide enhanced look & feel for the wizard UI.

- Used a combination of jQuery, web methods and native ASP.NET AJAX combined with CSS & JavaScript

components from Bootstrap to achieve rich user experience.

- Designed the core platform for interactions, flow management, state management and data management for

the wizard.

- Seamlessly integrated new requirements into existing application architecture making it consistent for

Page 3 18

maintenance, support, and possible enhancement at individual implementation by existing developers.

- Developed SQL stored procedures & functions for performing CRUD & handling complex business

operations used in the reporting wizard.

Technologies:

.NET 4.5, ASP.NET 4.5, MS SQL Server 2012, Visual Studio 2013, TSQL, Bootstrap, jQuery

Project: Invoice Code Refactoring

Role: Sr. Software Developer

Client: HCSC, Naperville IL USA Aug 2014 Mar 2015

Project Brief:

Invoice code refactoring project focuses on analysis of the existing individual subscriber invoicing system to

improve performance. The work involved linearly executing SQL code, optimizing SQL statements, refactoring

them into logical business executions. The solution involved a batch/job processing framework implemented

using .NET framework 4.5 & Entity Framework. The batch processing framework processes business code units

implemented as SQL stored procedures in a multi-threaded multi-server architecture. The work also involved

integrating the new refactored system with existing web applications written in classic ASP.

Responsibilities:

- Responsible for refactoring / recoding the subsidy calculation business module.

- Involved in SQL code optimizations and code review.

- Responsible for .NET code reviews.

- Responsible for implementing logging and progress tracking modules without affecting performance.

- Responsible for analysis of existing classic ASP web application, understanding its complex architecture and

integrating new refactored solution into the web application.

- Participated in design and architecture decision making and contributed in infrastructure requirement

specification.

- Assisted in setting up SQL & .NET level performance monitoring using FogLight and dynaTrace.

Technologies:

.NET 4.5, MS SQL Server 2008, TSQL, ASP, dynaTrace, FogLight/Spotlight

Project/Team: IT-Monitoring (Application and Infrastructure Monitoring)

Role: Software Architect

Client: Asurion Inc., Nashville TN USA Dec 2012 Jul 2014

Project/Team Brief:

IT-Monitoring team is part of the operations arm of the IT organization at Asurion. The team is responsible for

providing technical tools and support to the operational groups that maintain the global applications and

infrastructure critical to Asurion business. The team maintains and administers various application performance

and infrastructure monitoring software and acts as a liaison between development teams and IT operations. These

monitoring software enable performance & health monitoring for complex hybrid applications composed of Web

applications (using ASP.NET, HTML, CSS, JavaScript, PHP, Joomla), middle ware, business processing layer

(.NET Services, BPM, Microsoft CRM, Microsoft Dynamics AX), and back end databases based on Microsoft

SQL Server & MySQL. The monitoring software also provide performance & health monitoring for IT

Infrastructure covering networks, servers, CITRIX, telephony, storage, etc.

Responsibilities:

- Act as a technical liaison between development and IT operations teams in providing operational insight

Page 4 18

into production infrastructure, assisting them in identifying key aspects of their applications that would need

monitoring.

- Responsible for design and implementation of operational monitoring structure.

- Define, document and implement performance monitoring standards for ASP.NET applications that utilize

MVC 2.0, AJAX, .NET Services (Web Services, WCF services), IIS, and SQL Server Databases.

- Provide technical contributions to business deliverable sprints and continuous-improvement sprints for class 1

business applications. Responsible for implementing changes to monitoring based on changes to the

applications and reviewing operational readiness.

- Responsible for providing design and architecture inputs for new business applications & projects being

executed. Work closely with Infrastructure & Application Solutions Engineers, Design Engineers, and

Infrastructure & Software Architects.

- Design and implementation of inter-tool integration using PowerShell 3.0, PERL, and PYTHON scripts to

provide correlated consolidated view of application & infrastructure health.

- Developed automated interactions using T-SQL, WMI, VB Script and PowerShell 3.0 to assist in gathering

application and business health statistics from application & infrastructure logs. Worked with development

teams to integrate such toolkits within their applications.

- Designed and developed Splunk applications using PERL, PYTHON, HTML 4.0, CSS 3, and JavaScript.

- Designed monitoring integrations using SNMP and SNMP MIB tools for CA Spectrum.

- Responsible to provide technical support to the team from a perspective of technical architect.

- Assist in implementation of Microsoft System Center Operations Manager and relevant automations and

integrations using PowerShell 3.0.

- Developed RESTful API as a service offering gateway using C# WCF Workflow Services to enable

automation tools to interact and perform various tasks with multiple monitoring products in an orchestrated

manner.

- Responsible for process definition and documentation.

Technologies:

C#, ASP.NET, WCF, Workflow Services, REST, MVC, middle ware, SQL Server, Infrastructure Monitoring

software (CA Spectrum, Tripwire File Integrity Monitoring, FogLight database monitoring), Application

Performance Monitoring software (OPNET Riverbed suite, Paessler PRTG) and data aggregation & indexing

software (Splunk)

Project: iWeb Responsive

Role: Design / Architecture Contributor

Client: Asurion Inc., Nashville TN USA Sep 2013 Nov 2013

Project Brief:

iWeb is a web based end-user facing application that enables customers to file insurance claims, track claims

status, and provide claims related documentation. iWeb (Responsive) is a newer version designed to fulfill the

needs for an application with richer UI, reusability, modularity, independent test & development that keeps up

with fast agile delivery model. The application has a step by step wizard like interface with validations and

backend processing between the steps.

* Note: This work was done in parallel with working on IT-Monitoring Team

Responsibilities:

- Participated in MS-COE efforts in evaluating possible use of using Angular JS.

- Identify and train programmers on Angular JS framework.

Page 5 18

- Participated in developing prototypes and mock applications to demonstrate capabilities.

Technologies:

Angular JS

Project/Team: Incident Management Team

Client: Asurion Inc., Nashville TN USA Jan 2011 Dec 2012

Project/Team Brief:

Incident Management team is part of the operations arm of the IT organization in Asurion. The team is tasked

with resolution of incidents and failures of business critical applications to restore service and minimize downtime

of applications.

Responsibilities:

- Responsible to lead an incident bridge and drive the incident to resolution.

- Responsible for coordinating triage activities, collating and analyzing information gathered on each support

member and decide further course of action.

- Provide technical direction to support teams for identifying issues across multi-technology applications

encompassing .NET Web Applications, .NET Web Services, TIBCO Enterprise Message system (EMS),

TIBCO Business Works (BW) Services, BLAZE rules engine, SQL databases, Microsoft Dynamics AX

and other supporting applications.

- Provide technical guidance on Windows and LINUX server platforms, VMWare, Network Load Balancers,

Firewalls, Routers & Switches and telephony infrastructure.

- Co-ordinate with business in gathering data pertinent to the incident, assessing impact to business, and

providing executive updates during and after the course of incident.

- Ensuring that service is restored to business as quickly as possible, with minimal impact and with a solution

acceptable to business keeping MTTI & MTTR within defined limits.

- Responsible for documenting the incident, identifying root cause, feeding action items to problem

management, program management and support groups as per ITIL v3 guidelines.

Key Achievements:

- Achieved MTTR targets for sev-1 incidents and consistently maintained overall average below yearly goal.

- Demonstrated excellence in handling incidents.

- Demonstrated excellent technical abilities that reflected in effective technical handling during incidents.

- Received appreciations from Sr. Management in handling business critical incidents.

- Key contributions in assisting and mentoring new incident controllers in handling incidents.

- Key contributions to setting up baseline for service mapping for application components in CA Service Desk

CMDB.

Methodologies:

ITIL v3 processes.

Project: Incident Control GUI

Role: Concept Designer, Developer

Client: Asurion Inc., Nashville TN USA Nov 2012 Dec 2012

Project Brief:

Incident Control GUI is a web application designed to provide user friendly interface to view, edit, log notes and

update incident tickets. The application provided rich desktop like user interface with intuitive shortcuts to

Page 6 18

allowing users to log different types of notes, highlight actions, embed links & references, and speed up the

process of capturing notes during troubleshooting on a production incident.

* Note: This work was done in parallel with working on Incident Management Team

Responsibilities:

- Responsible for vision & scope, requirement definition, planning development execution and deployment of

this application.

- Used ExtJS JavaScript framework to design rich UI.

- Used ASP.NET MVC4 and C# to develop RESTful API that would provide data to ExtJS UI.

- Developed backend C# WCF deployed as a Self-Hosted Windows Service and Object Adapter Pattern to

interact with CA Service Desk Web API.

- Used Entity Framework and POCO classes to design direct database interaction from the WCF service.

Technologies:

C#, ASP.NET MVC, ExtJS, RESTful API, WCF, Entity Framework, Design Patterns.

Project: Enterprise Service Library

Role: Architect / Contributor

Client: Synechron MS-COE Nov 2010 Dec 2010

Project Brief:

This project was an attempt to prototype a concept developed by Synechron Microsoft Center of Excellence. The

objective was to build a prototypical encapsulating library that would enable quick development, deployment and

administration of WCF services.

Responsibilities:

Worked as an architect on the concept development and design.

Developed code libraries using C#, .NET 4.5, WCF to allow

Used TDD based approach to test libraries.

Designed prototypical applications using C# Win Forms, WPF, ASP.NET, Web Services, Windows Services and other

technologies/methods to demonstrate capabilities and usage of the libraries.

Technologies:

C#, ASP.NET, MVC, RestAPI, Web Services, Win Forms, WPF, MVVM, MEF

Project: Data Extraction and Longitudinal Trend Analysis

Role: Solution Designer / Developer

Client: Coping Systems, Andover MA USA Sep 2010 Nov 2010

Project Brief:

Coping Systems is a leader in the field of medical informatics - dedicated to helping health care providers reduce

cost while continuously improving quality of care, patient safety and treatment outcomes.

The project involved re-designing and revamping the user interface for their product called DELTA. The project

involved designing dynamic UI elements on web pages based on user selections and present charts and graphs in

windows-like interface on the web. The UI requirements were very challenging in terms of implementing

functionality.

Responsibilities:

Design and delivery of complex rich graphical UI requirements using ExtJS JavaScript AJAX framework.

Page 7 18

Designed custom components in ExtJS to meet needs for dynamic UI. Integrated web charting library.

Used ASP.NET MVC 2 controllers for providing data to the UI.

Used web services as communication layer between distributed UI and business/data extraction layer.

Responsible for requirement understanding, web design, development of the UI components, unit testing and client

coordination for functional testing.

Technologies:

ExtJS (JavaScript Framework), ASP.NET.

Project: Excel Add-In for Annotations

Role: Solution Designer / Developer

Client: Coping Systems, Andover MA USA Sep 2010 Nov 2010

Project Brief:

Coping Systems is a leader in the field of medical informatics - dedicated to helping health care providers reduce

cost while continuously improving quality of care, patient safety and treatment outcomes.

The project involved designing Microsoft Excel 2007 based add ins to communicate with existing annotation web

services and provide query & result capabilities. In addition, there were other add ins designed to facilitate

functionalities similar to their existing web based tools.

Responsibilities:

Designed Excel 2007 Add-In using C# 3.5 and VSTO objects.

Used .NET Framework 3.5 features and libraries to invoke web service calls.

Used WSDL and web method invocation to retrieve data from remote web services. Used XML libraries to interact with

retrieved data.

Designed IntelliSense type auto-completion features using custom controls and hooks into Excel.

Provided custom actions and tools using toolbars, menus, forms, document templates, task panes, and the Ribbon.

Designed custom setup and deployment package for installation.

Responsible for documentation of requirement understanding, designing, task assignment & tracking, unit testing and

reviews, client communication and technical support to the team.

Technologies:

C#.NET 3.5, VSTO 2.0, Microsoft Excel 2007.

Project: HCS Informatics Tool for Pathway

Role: Project Manager / Application Architect

Client: Becton Dickinson and Company, San Jose CA USA Mar 2009 Nov 2010

Project Brief:

BD is a medical technology company that serves healthcare institutions, life science researchers, clinical

laboratories, industry and the general public. BD manufactures and sells a broad range of medical supplies,

devices, laboratory equipment and diagnostic products. The informatics tool being developed was part of a suite

of software that works with the Pathway devices. The tool was intended to provide informatics and analysis

capabilities on high-content-screening images and data gathered from Pathway instruments.

The initial assignments on the project focused on software verification. The later assignments were aimed at

developing enhanced data analysis features, which expand upon their current software capabilities. A challenge on

this project is the use of a specialized workflow development tool called Pipeline Pilot and ExtJS JavaScript

based framework for developing the modules. The project life cycle is governed by the clients quality processes

Page 8 18

and requires strict adherence in documentation and reporting.

Responsibilities:

As a project manager, responsible for review and verification of QA & QC requirement documents, test plans, test

cases, test execution documents and test result summaries.

Responsible for coordinating test cycles with clients development & delivery cycles.

Responsible for maintaining documentation for business requirements, product requirements, functional

requirements, FMEA, requirements matrix, QA/QC documents and assisting client to update them in Clear Case and

Clear Quest.

Responsible for requirement analysis, definition and design for installation package.

Responsible for technical research for using Install Shield 2010, technical guidance to team for developing the

installation package, unit testing, peer reviews, and managing deliveries.

Coordinating application knowledge transfer from customer to team, understanding and setting up delivery processes for

the project.

Responsible for overall scheduling, task management, status reporting, and delivery management.

Liaison between the customers development team and our testing team.

Responsible for research and development of rich UI using ExtJS in Pipeline Pilot 7.

Responsible for designing UI components, translating business and functional requirements to technical design and

workflow documents, defining module requirements, peer reviews, code reviews, and coordinating between development

and QA teams.

Key Achievements:

Phase I of the project was worked on by the vendor of Pipeline Pilot but was a near failure. I was able to learn Pipeline

Pilot and turn over the work from vendor to our team in a short span of three weeks thus saving time and efforts on

clients end.

Lack of rich UI design was the biggest downfall during phase 1. I was able to integrate ExtJS a rich JavaScript Based UI

framework within the Pipeline Pilot product using its extensibility features. This was highly appreciated by the client.

The vendor also reviewed the implementation and adopted it as a base for future enhancements to their product.

This project was chosen for the first ISO 9001:2008 audit to be conducted in our organization. Our team was the only

team to achieve 100% compliance. As a result, the client included our team in documentation and process compliance for

their audits.

Technologies:

Pipeline Pilot 7.5, ExtJS, InstallShield 2010, ClearCase, ClearQuest.

Project: Lab Management System (LMS)

Role: Project Manager / Application Architect

Client: Vitro Molecular Laboratories, Miami FL USA Jun 2008 Feb 2009

Project Brief:

The project involved designing lab management software to cater to specific needs of the pathology lab. It had a

browserbased digital pathology module that allowed users to manage digitally scanned pathological images,

provided indexing of images, categorizing by cases, providing basic patient information and facilitated image

editing, annotation, and analysis via a desktop tool. A challenging feature of this application was to implement the

digital conferencing tool that allows pathologists at different geographic locations to view and edit images on a

central server and conference to discuss results.

Responsibilities:

Used ASP.NET 2.0, HTML 4 and ExtJS JavaScript AJAX framework to deliver rich and complex user interface.

Page 9 18

Designed custom web controls to facilitate consistency of most common UI elements.

Provided database design in form of data dictionaries and ER diagrams.

Implemented complex data extraction and manipulation logic in database using T-SQL and stored procedures, user

defined functions and views. Expertise in developing complex data objects.

Designed ETL packages in SQL Server 2005 to convert data from legacy application.

Designed and implemented complex desktop app for viewing pathological images.

Designed desktop app delivery using ClickOnce deployment package.

As a Technical Manager, responsible for business understanding, gathering requirements, system design and

application architecture, task scheduling & management, client communications and deliveries.

Key Achievements:

Achieved 100% process compliance for the project for ISO 9001:2008 process compliance.

Quickly aligned myself to understand pathological terms, business rules and industry norms.

On time deliveries and project execution.

Technologies:

ASP.NET 2.0, C#.NET 2.0, ExtJS AJAX, SQL Server 2005, Web Services.

Project: Image Convertor

Role: Project Manager / Technical Manager

Client: Carl Zeiss, Germany Apr 2008 Jun 2008

Project Brief:

The project involved creating middleware tools to communicate between the clients existing software and a third

party software for converting high-content images. A key challenge was to design a customizable output format

that can be manipulated by endusers with ease and providing images from the third party software at acceptable

speed. Another technical challenge involved integration of unmanaged C++ code with managed C# wrappers

around the third party SDK.

Responsibilities:

Designed image convertors implemented using C++ using image conversion SDK.

Designed and implemented generic plug-and-play wrappers using C#.NET 3.5.

Responsible for requirement gathering, technical design, task assignment & tracking, unit testing and reviews, client

communication and technical support to the team.

Responsible for ISO 9001:2008 documentation which involved creating project plan, technical & functional design

document, review and approval of test plan and test cases, FMEA and product help documentation.

Key Achievements:

Achieved 100% process compliance for the project.

Received appreciation from client for documentation.

On time and below budget execution of project.

Technologies:

C#.NET 3.5, C++, third party SDK, Image conversion tools.

Project: SparksOnline (Web portal)

Role: Application Architect / Solution Designer / Lead Developer

Page 10 18

Client: Sparks Event Marketing, Philadelphia PA USA Aug 2005 Mar 2008

Project Brief:

Sparks provides event marketing services to big brands like Adidas, Nike, Verizon Wireless, and the likes. The

project was a complete overhaul of the online portal and back office applications porting it to new .NET based

architecture.

Responsibilities:

Contributed to design & implementation of the application architecture and handled further improvements.

Used Microsoft Office 2003 and Visual Studio Class Diagrams for documentation.

Designed UI using HTML 4, ASP.NET 2.0 and ASP.NET MVC 2.

Used ASP.NET AJAX Toolkit & AJAX.NET toolkit to design AJAX enabled custom web controls and ExtJS

JavaScript UI framework to deliver rich user experience.

Designed ASP.NET Web Services to provide communications between sub-portals, UI and business layer.

Responsible for client interaction and coordination for all web components of the application.

Responsible for gathering requirements, documentation and passing it to the module owners, demonstration of

completed modules, deployment of code, validation and getting client signoff.

Unit testing code, integration, validation with client and fixes as required.

Key Achievements:

Designed a framework that reduced web based development time and improved quality, stability, and scalability of

designed application.

Designed AJAX based Web UI toolset that provided significant improvements in loading large amounts of data from

remote databases within seconds.

Achieved client recognition for porting two complex modules one that involved an explorer like interface and the other

involved a calendar interface from existing back end desktop application to new web portal.

Worked on improvements to existing complex reports and automations on database backups, exports, and ETL jobs.

Technologies:

ASP.NET 2.0, C#.NET 2.0, JavaScript, AJAX, ExtJS, SQL Server 2005, Crystal Reports, SOA, XML / XSL /

XSD.

Project: SPIMS (Sales Portal)

Role: Technical Architect / Team Lead

Client: Shrenuj, Mumbai MH India Oct 2006 Apr 2007

Project Brief:

The software was designed to automate the sales process for the client. Designed using multi tier architecture, the

software was a webbased solution supported by various desktop based tools running off a server. The design was

scalable and provided data that could be imported into the clients existing production management software. The

site communicated with various public web services for gathering updates and presenting it. A dashboard and

wizard based UI approach using AJAX greatly enhanced user experience.

Responsibilities:

Reduced application development time by 60% for common CRUD operations by implementing development

framework.

Improved quality of user experience for high data volume pages by designing custom AJAX controls.

Used Microsoft VISIO 2003 for design and architecture documentation.

Page 11 18

Responsible for design and architecture for sales portal developed using ASP.NET 2.0, HTML 4.0 and ExtJS JavaScript

based UI framework.

Designed web services implemented using ASP.NET 2.0 Web Services that interacted with public internet services to

gather data and use business and data abstraction layers.

Developed module for communicating with remote SQL Server 2000 database.

Overall responsibility for application design and architecture, task allocation and tracking, unit testing, code &

functional reviews, database design, client interactions and deployment.

Key Achievements:

Significantly changed application development paradigm by implementing development framework, reducing

development time by 60% and improving quality, consistency and repeatability.

Technologies:

ASP.NET 2.0, C#.NET 2.0, SQL Server 2005, Crystal Reports, Adobe Photoshop 7.

Project: Test Lab Automation systems

Role: Project Lead / Lead Developer

Client: Automotive Research Association of India (ARAI), Pune MH India Apr 2004 Aug 2005

Project Brief:

ARAI is a government owned organization and Indias premier automotive research & certification agency based

out of Pune and Delhi. The project was aimed at automation of test laboratories in the automobile sector. The

system comprised of a number of cooperating multi-tier components. The solution involved designing a

customized solution on top of existing dynamometer & emission equipment controller software to suite specific

engine and vehicle testing needs. It also involved understanding & learning the government norms & regulations

and designing business intelligence into the software.

Responsibilities:

Designed and implemented complex reporting in Microsoft Excel 2003 using VBA and MACROS.

Designed and implemented calibration management application using C# Win Forms over .NET 2.0 framework;

designed Generic Class Libraries and adaptive UI using interfaces, abstract classes, custom controls, and 3rd party

controls. Used process threading & pooling to perform multiple calibrations at a time. Used VC.NET managed code to

communicate with proprietary embedded applications.

Designed flexible C# Windows Service to pull data from ORACLE 8.0 (via T-SQL stored procedures) using

distributed OLEDB sources and export it using custom schema to different proprietary formats. The schemas and data

fields to be exported were XML and were linked to Excel 2003 Add-In for ease of customizations.

Responsible for overall project coordination, client interactions, requirement gathering, specifications &

documentations, demos and module approvals, task assignment & tracking, and management reporting.

Key Achievements:

Successfully negotiated logical and practical requirements for the project based off dialogues with high ranking

researchers and directors in ARAI.

Was responsible for demonstration of completed application to high ranking government officials in live vehicle testing

scenarios.

Successfully and quickly learnt the global emission laws pertinent to engine and vehicle testing and certification. Was

accredited with successfully implementing complex business intelligence into the software to accommodate various norms

like EPA, EPA-2, EURO-I/II/III, BS-I/II etc.

Setup successful integration with a particular emission device by learning and configuring the libraries on the device to

enable communications. This helped secure the project for us.

Designed complex reporting logic using Excel VBA.

Page 12 18

Technologies:

VB 6.0, SQL Server 2000, ORACLE 8.0, C#.NET 2.0, Microsoft Excel 2003, VBA.

Project: eLearning Modules

Role: Team Lead

Client: Pearsons Learning, UK Jan 2004 Apr 2004

Project Brief:

The project covered four modules with each module containing 3 4 chapters. The chapter contained data in text,

graphic and animated form. My team did the textual representation and lay outing and a sub contractor did

animation & graphic content.

Responsibilities:

Responsible for leading a team of three analysts, requirement documentation, and task assignment & tracking.

Coordinated with sub-vendor in providing concise requirements, assigning tasks, and reviewing completed work.

Responsible for converting raw course material to story board and getting it proof read.

Provided technical support to the team for digital content conversion, XML, XSD, XSL-FO, PDF Conversion and

image editing.

Designed interactions using ActionScript for animated Macromedia Flash content provided by sub-contractor.

Tracked project status and cost reporting to management using Microsoft Excel 97 and Microsoft Project 97.

Technologies:

Adobe Professional, XML, Flash, ActionScript

Project: Website Builder (Product)

Role: Sr. Developer

Client: Synergy Solutions Pvt. Ltd. Aug 2003 Dec 2003

Project Brief:

The project was focused on developing a website that would allow users to build websites by selecting from a set

of predefined templates with some customization.

Responsibilities:

Responsible for design and development of the template selection module.

Responsible for design and development of site templates.

Used HTML, XML, XSLT, CSS, and JavaScript to develop website templates.

Used ASP and ADO.NET to design website front end.

Used MS Access and MS SQL 2000 to store website and configuration data.

Developed Tables, Views, Stored Procedures and User Defined Functions using T-SQL for master website database.

Developed T-SQL scripts ETL packages to export site configurations data to MS Access database.

Developed COM libraries in Visual Basic to interact with database and provide business functions.

Developed scripts using VBScript to interact with IIS 6.0 to dynamically create, remove and administer websites.

Technologies:

ASP, ADO.NET, XML, XSLT, CSS, JavaScript, VBScript, MS Access, MS SQL 2000, Visual Basic

Project: Sparks Back-Office-Operations (SparksBOO)

Page 13 18

Role: Developer

Client: Sparks Event Marketing, Philadelphia PA USA Apr 2002 Jul 2003

Project Brief:

Sparks provides event marketing services to big brands like Adidas, Nike, Verizon Wireless, and the likes. The

application provides online services to end customers and back office services to internal departments. Based on

3tier architecture, the solution is a composite of web based portal designed with ASP XML communicating with

VB6.0 based COM services and a back office desktop application developed with VB6.0. The application uses

multiple SQL 2000 databases for data storage.

Responsibilities:

Developed ActiveX DLL for business layer and data layer libraries using VB 6.

Used DCOM for inter-layer communications.

Implemented database tables, views, cross-database stored procedures and user-defined functions using T-SQL

statements for multiple Microsoft SQL Server 2000 databases as per provided requirements.

Participated in implementing application architecture utilizing distributed 3-tier architecture, object oriented

principles, technologies like ActiveX DLL/EXE as COM/DCOM components, linked databases, and modularization

as per design provided.

Designed reports in Crystal Reports 8.0 and integrated them into windows desktop and web UI using Crystal Reports

Viewer Controls.

Designed application web pages using HTML 4.0, JavaScript and ASP 2.0 to communicate with UI interaction layers.

Used XML object library in ASP 2.0 to transform XML using XSLT and generate content HTML.

Key Achievements:

Contributions to web UI design and implementation were recognized by the client. Involved in providing innovative user-

friendly designing for some key pages. Given the responsibility to overhaul the UI of one of the desktop modules.

Assigned to interact and coordinate with the client for a major portion of the desktop application and was responsible for

gathering requirements and passing it to my manager, demonstration of completed modules, deployment of code,

validation and getting client signoff.

Worked on complex reports that collated data from multiple databases, performed computations based on linked values

and presented it in drill-down fashion.

Technologies:

VB 6.0, SQL Server 2000, XML, XSL, XSDDTD, COM/DCOM, ASP 2.0, Crystal Reports 8.0.

Project: Garment-Accessories-Shipping-Production (GASP)

Role: Developer

Client: Cebon Apparels & Tropical Clothing, Navsari & Biollimora GJ India Jul 2001 Apr 2002

Project Brief:

The project was an endtoend production line solution for a Cebon Apparels Pvt. Ltd. & Tropical Clothing Co. in

Gujarat, India. Based on clientserver 2tier architecture using VB 6.0, SQL Server 7 and Seagate Crystal Reports

6.0 the solution covered modules for departments like accessioning, stock & provisioning, production, packaging,

and delivery. It had wide range of reports to provide real time and statistical information to all departments and

management.

Responsibilities:

Designed and implemented various windows forms using VB 6.

Page 14 18

Used ADODC Controls to manage connections with Microsoft SQL Server 7 database and display data in grid and

individual record view.

Improved performance of custom designed intellisence control and centralized all custom controls under ActiveX DLL.

Used Crystal Reports 7.0 with complex sub-reports and report links to pull data from Microsoft SQL Server 7

databases.

Improved report performance by consolidating and centralizing T-SQL queries in parameterized stored procedures.

Expertise in designing modular stored procedures using T-SQL.

Designed ActiveX EXE for with task bar integration, custom menus, and scheduled tasks.

Responsible for requirement gathering, on-going support, implementing change & enhancement requests, onsite

deployments, end-user training and maintenance of the environment.

Key Achievements:

Worked on reports critical to financial audits and completed in time with accuracy. This helped the client clear their audits

with less manual efforts in preparing reports and increased their confidence in the applications reliability.

Provided key support on-site greatly involving in the day to day business of each department and solving issues in

modules relevant to them.

Improved database performance and designed automated backup-restore jobs that would sync data between the two

production sites using FTP over dial-up connections. This proved very useful to the client and resulted into monetary

savings.

Technologies:

VB 6.0, SQL Server 7, Seagate Crystal Reports 6, FTP

Project: Garment-Accessories-Shipping-Production (GASP)

Role: Developer

Client: Cebon Apparels & Tropical Clothing, Navsari & Biollimora GJ India Jul 2001 Apr 2002

Project Brief:

The project was an endtoend production line solution for a Cebon Apparels Pvt. Ltd. & Tropical Clothing Co. in

Gujarat, India. Based on clientserver 2tier architecture using VB 6.0, SQL Server 7 and Seagate Crystal Reports

6.0 the solution covered modules for departments like accessioning, stock & provisioning, production, packaging,

and delivery. It had wide range of reports to provide real time and statistical information to all departments and

management.

Responsibilities:

Designed and implemented various windows forms using VB 6.

Used ADODC Controls to manage connections with Microsoft SQL Server 7 database and display data in grid and

individual record view.

Improved performance of custom designed intellisence control and centralized all custom controls under ActiveX DLL.

Used Crystal Reports 7.0 with complex sub-reports and report links to pull data from Microsoft SQL Server 7

databases.

Improved report performance by consolidating and centralizing T-SQL queries in parameterized stored procedures.

Expertise in designing modular stored procedures using T-SQL.

Designed ActiveX EXE for with task bar integration, custom menus, and scheduled tasks.

Responsible for requirement gathering, on-going support, implementing change & enhancement requests, onsite

deployments, end-user training and maintenance of the environment.

Key Achievements:

Worked on reports critical to financial audits and completed in time with accuracy. This helped the client clear their audits

Page 15 18

with less manual efforts in preparing reports and increased their confidence in the applications reliability.

Provided key support on-site greatly involving in the day to day business of each department and solving issues in

modules relevant to them.

Improved database performance and designed automated backup-restore jobs that would sync data between the two

production sites using FTP over dial-up connections. This proved very useful to the client and resulted into monetary

savings.

Technologies:

VB 6.0, SQL Server 7, Seagate Crystal Reports 6, FTP

Project: CyberJammies Quick-Response-System (QRS)

Role: Developer

Client: CyberJammies, UK Jul 2001 Dec 2001

Project Brief:

http://www.cyberjammies.co.uk/ is an online garment portal in UK with its production base in India. The

highlight of their sales was the '3day' shipping time. The online site sent order emails with XML content to the

production base in India. The QRS software was designed to fetch emails, parse them, generate orders, provide

production/packaging/delivery MIS reports, and generate airway bills and invoices.

Responsibilities:

Designed Windows Forms using VB 6 for all modules.

Designed data connectivity modules to interact with Microsoft SQL Server 2000 database using OLEDB.

Used Crystal Reports 8 to design various reports

Used Crystal Reports Viewer control in for reporting.

Implemented integration with label printers and bar-code scanners using their drivers & libraries.

Implemented VB 6.0 module to fetch emails from a mailbox using MAPI control, parse the body content using XML

library, validate content using XML Schema (DTD), and generate orders from the XML.

Used T-SQL statements and database normalization techniques to design the QRS database.

Used standard T-SQL statements to write Stored Procedures and Views in the database.

Key Achievements:

Received appreciation for reports to accurately print FedEx airway bills, multi-type shipping labels and self-initiated MIS

reports.

Independently worked on and successfully implemented the critical invoice report in a very short span with 100%

accuracy. The report was complex, had multiple calculations and sub-reports and was critical for business.

Technologies:

VB 6.0, SQL Server 2000, Microsoft Outlook, XML, XML DTD, MAPI & SMTP services, Label Printer

integration, barcode scanners, Crystal Reports 8

PROFESSIONAL EXPERIENCE

Shakti Solutions Aug 2014 Present

3160 Bee Caves Road, 300B, Austin, TX 78746, USA

Synechron Inc., USA Nov 2010 Aug

Page 16 18

1 Corporate Place South, Suite 200, Piscataway, NJ 08854 USA 2014

Synechron Technologies Pvt. Ltd., India

A Wing, Block 1.2, Embassy Tech-zone, Plot No. PL-3,

Rajiv Gandhi InfoTech Park, Hinjewadi Phase II

Pune 411057 INDIA

Optra Systems Pvt. Ltd., India Apr 2008 Nov

2010

503, B Wing, Manikchand IKON, Dhole Patil Road

Pune 411001 INDIA

Sang InfoTech Pvt. Ltd., India Aug 2005 Feb 2008

B-1, Flr. 3, Prabhat House, 164 S. Bapat Rd., Lower Parel,

Mumbai 400013 INDIA

Modi Measurement Systems Pvt. Ltd., India Jan 2004 Aug 2005

219, Hill View Ind. Est., Amrut Nagar Rd., Ghatkopar (W),

Mumbai 400086 INDIA

Synergy Solutions, India Jul 2003 Dec 2003

C-304, Ambika Tower, Pump House, Andheri (E)

Mumbai 400093 INDIA

Sang Information Systems Pvt. Ltd., India Jul 2001 Jul 2003

Software Developer

TECHNICAL SKILLS

Languages: C, C++, VB 6.0, VBA, VB.NET, C#.NET, ASP, Databases:

Microsoft SQL Server

ASP.NET, XML/XSL/XSD, HTML, JavaScript, PHP, JAVA (6.5/7.0/2000/2005/2008), Microsoft Access, MySQL

Frameworks / Technologies: .NET 2.0/3.0/3.5/4.0, VSTO, Application/Enterprise Monitoring: CA Spectrum, CA

WPF, WCF, WF, Microsoft Extensibility Framework, eHealth, OPNET tools (ARX, AIX, Dashboards, TTW),

ExtJS, Microsoft Enterprise Library, Microsoft Solutions Tripwire File Integrity Management, Splunk

Framework, AngularJS, Bootstrap

Tools/Software: Microsoft Visual Studio, Microsoft Office,

Concepts: OOP, OOAD, Design Patterns (MVC, MVVM, Microsoft VISIO, Microsoft Project, IIS, SQL Server,

Factory, Abstract, etc.), Development Methodologies Adobe Photoshop, XMLSpy, Acrobat Professional,

(Prototyping, Waterfall, Incremental, Spiral, RAD, Agile,

etc.)

EDUCATION

Post Graduate Diploma in IT 2010

Symbiosis Center for Distance Learning

Bachelor of Science (Physics) 2005

University of Mumbai

Page 17 18

CERTIFICATIONS

Honors Diploma in Software Engineering 2000

APTECH Education Ltd.

SOA Certified Professional 2014

Arcitura Education (on behalf of SOA School)

Page 18 18

Contact this candidate