| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Contact : PHONE NUMBER AVAILABLE
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
|
