PARAG DIGHE
Master of Business Administration (MBA)
Bachelor of Engineering (BE)
Oracle 9i Certified Associate (OCA)
Microsoft Certified Solution Developer (MCSD)
Status: Permenant Resident (Green Card)
[Send email using form at bottom]
About 13 years of experience in Software Design & Development, Database
Administration, Coordination with Onsite / Offshore team, as Software Architect.
Primary skills include Visual Studio.Net. C#, VB.Net (1.0, 1.1, 2.0), ASP.Net,
VB 6.0, ASP 3.0, COM, COM+, Java and Oracle 9i, PL / SQL, SQL, SQL Server 2000 /
2005, BizTalk, Crystal Reports 9, 11, UML, Work Flow management, FIX Protocol,
QuickFIX, Investment Banking.
Technical Skills
Operating Systems: Unix, Windows 2000, Windows NT 4.0
Web and Application Servers: IIS, Citrix, BizTalk Server
RDBMS: SQL Server 2000 / 2005 (T SQL, Stored Procedures, Tuning, Maintenance),
Oracle 9i, 8i, SQL & PL / SQL, Working with Data Dictionaries, Managing
Instances, Tablespaces and Data Files, OEM, Backup & Recovery, Security, Data
Modeling and Design, MS Access,
Languages / Technologies: Visual Basic.Net / 6.0, ASP 3.0 / ASP.Net, ADO.Net,
C#, C, UML, Java 2.0, Java Scripts, XML (XSLT, SAX, XPATH), VB Scripts, HTML,
Cold Fusion, Developer 2000 (Forms and Reports), Crystal Reports 9 / 11.
Others: UML, SOAP, COM, COM+, Oracle Applications (Sales / Purchase), Trilogy
SC Backbone, SC Pricer, SC Promotions, SC Reports, CML and SC Configuration
Model, Tivoli Problem Management Solution, Clarify, Visual Source Safe, Visual
Interdev, Visio 2000, Double-Take (Failover control), FIX Protocol, QuickFIX.
Packages & IDEs: Visio, Visual Studio.Net, Visual Interdev, FoxPro 2.6, Front
Page, MS Project 2000 etc.
Experience in working in remote PC environment and tools (Tivoli Remote,
PCAnywhere, Citrix Servers)
Patterns Have worked on systems based on ESB (Enterprise Service Bus), SOA
(Service Orientation Architecture) and patterns such as Factory and Singleton.
Major Assignments
Since December 2007
Credit Suisse First Boston
Role: Lead Developer
Worked on trading terminal (Premiar) for Sydney Futures Exchange (SFE), which
will be replacing SYCOM, a terminal supported by SFE. The new application will
support Portfolio, Messaging, Custom Market, Request for Quote, Traders Book and
Book Transfers, Administration and Personalization.
Roles & Responsibilities:
Desgin and Development of Premiar using C#, FIX, QuickFix, Sybase
Creation of Class Diagrams using Visio
Design and development of GUI components
August 2003 November 2007
Software Architect with Alliance One International (Farmville, NC)
Role: Architect (Managing complete Project life cycle)
Alliance One International is worlds 2nd largest tobacco merchant having
Operations and Procesing Plants all over the world. It has been rated amongst top
500 IT driven corporations. Highlights include use of cutting edge technologies
such as .Net, Colaboration, CMS, and ERPs etc.
Roles & Responsibilities:
Create and maintain Project Plans in MS Projects 2000
Analyze, design, develop, test, train and deploy new web applications and
Manufacturing systems around the world using .Net technologies
Create Functional Sepcs, High Level and System Design
Design of data models, Class Diagrams, Use Cases etc using Enterprise Visio
2000
Creation of Prototypes (VB.Net, C#, Visio, SQL Server 2000)
Design / Create Enterprise Development Templates (for data layer, business
latyer, UI etc) using Visual Studio .Net
Design and Develop applications with Work Flow which includes interfaces with
MS Exchange Server (ALERT, Worldwide Resource Availability)
Design and Develop interfaces with RF Scanners, Scales, Testing Equipments and
Image sensors, Process controls etc.
Develop and design the Disconnected architecture for the Manufacturing
system based on SOA.
Create and execute Test Scripts
Create User Training Manuals, Roll Out Plans
Coordinate development efforts amongst a team of about 15 developers onsite
and offshore etc.
Managing releases, deploy applications, User Training & Support
Designing the Migration plan for SQL Server 2005 upgrade
Develop specification and scope document to migrate applications to .Net 2.0
Tobacco Processing System (ToPS) - From April 2004
Analyze and Design all the systems within the ToPS which include modules for
Administration, Planning, Inventory, Processing, Costing, Shipment and Reporting.
Carrying the responsibilities of Design and coordinate the development, help
developers with enterprise templates and development standards, develop various
modules (including Inventory and Costing Modules) of the application in VB.Net,
C#, C++ / SQL Server 2000. Tech Lead in the .Net 2.0 and SQL Server 2005 Upgrade
initiative.
This system was recently reengineered to implement Service Oriented Architecture
for supporting the Disconnected remote locations using the system. This was a
step towards implementing ESB in the company IS. This was designed considering
deployment issues, latency, availability and integration with Central database.
A part of the Implementation & Training team for Tanzania, Argentina, Bulgaria,
India and other places worldwide.
ALERT (Agronomy Leaf Expert Reporting Tool) From June 2007
To assist with the management and administration of the CPA (Crop Protection
Agents) process, the Agronomy team has requested an electronic means of providing
global visibility of samples, test results, analysis of results, customer
reporting (CRM), actions plans, shipment coordination and trending in regards to
CPAs. Responsibilities include creation of design specifications, enterprise
templates, class diagrams, database design, Work Flow pipeline using Visual
Studio 2005 - .Net 2.0 (C#, ASP.Net, SQL Server 2005) and Visio.
This project included design and development of worksflow engine with the
following features:
1. Creation of a pipeline object using Messege Queuing
2. Creation of a component which would listen to the pipeline and route the
messages to their respective services (Customer Sample Results, Agronomy Sample
Results, QC etc)
3. Populate the Response queue from the Test Results service which includes
routing information such as Manufacturing, QC, Sale etc.
4. Generation of email notifications based on the response queue recipient,
sending the feedback back to the response queue and to the originating service
when the email is read by the reciepient by using Managed Event Syncs / hooks for
Exchange server.
CAB (Common Across the Board) - From March 2006
Alliance one maintains centralized data for controls which are common across the
board. This data is made available to locations around the world using SQL Server
Replication, BizTalk server, COM+ components etc. Design and Developed the
migration plan for this ASP application to migrate to ASP.Net 2.0 / C# / SQL
Server 2005.
Role involves development, testing, deployment and support of the support
systems involved.
Insite From March 2006
A localized reporting portal for Alliance One, a web application developed in
.Net 1.1, Crystal 9, with features such as load balancing, failover control
(implemented using server farms and redundant environemts) scheduling, managing
history and user profiles. Role involves troubleshooting, training and support of
the portal.
Management Dashboard Aug 2006 Oct 2006
A web application developed to provide summary of proceedings (Buying,
Receiving, Processing, Shipments etc) at a location to the Management with
features such as localization and personalization. Role involved analyze, design
and development of the application in VB.Net, ASP.Net, SQL Server 2000.
PAWS (PILAR Administration Web Site) Feb 2007 April 2007
A web application used to gather inventory data from Alliance One locations
across the world. This application then helps in generating reports required by
the financial institutions. Role involved design and development in VB.Net,
ASP.Net, and SQL Server 2000.
Q-TRACS Since May 2005
The quality control system for Alliance One, designed to be used either in stand
alone mode or integrate with a manufacturing system. The system designed to
record the customer quality requirements and test the samples and compare the
results with the given standards. Role involved analyze, design, develop, train
and support the system. This system is developed using C# and SQL Server 2000.
Weekly Processing Reports Aug 2003 Dec 2004
Design and Develop a Web App for Reporting System to track the Productivity
indicators for various Alliance One entities across various locations throughout
the world. Responsibilities included develop ASP.Net web application; create
Business & Data Services in VB.Net, creating Stored Procedures using T-SQL for
SQL Server 2000. Design and develop reports with Crystal Reports 9.0, for
Business Analysis Services.
Flash Comments Jan 2004 Feb 2004
Design and Develop an ASP.Net web application enabling the business to capture
financial information for a period spanning across a financial year. Major
building blocls were ASP.Net pages, C# for code behind and various modules and
services, SQL Server and stored Procedures for data services.
Worldwide Resource Availability March 2004 April 2004
This lets the users across various Dimon facilities to create and manage the
resource requisition and the resource allocation units manage the availabilities
and allocation of resources. The process flows per the predetermined workflow
implemented using VB.Net code modules. The responsibilities included creation of
High Level, System and Database design, develop the web application using
ASP.Net, VB.Net, XML, SQL Server Stored Procedures.
Design and develop interface with MS Exchange Calendar using Outlook Object
Model to get the resource availability information for the given periods and
update the allocation details, creation and execution of Test Scripts, Training
Manual and roll out plans.
May 2002 July 2003
Sr. Consultant/Architect/Developer with Keane, Inc-
Client: Whirlpool, Inc. (Benton Harbor, MI)
Role: Tech Lead / Developer (Team of 4)
Served as an Architect and Developer for the Migration Project: Client Server to
.Net and supported the team for the Merchandising Integrated Tools System (MITS
Pricing, Promotions, Quotes) of Whirlpool Inc, North America Region.
Requirement analysisis & estimations
Database Design, Class Diagrams, Design of Data Layer
Development and testing of New Business Development Opportunities in the MITS
Applications Maintenance / Support of MITA
Technical Documentation (Tech Specs, Use Cases, Test Cases)
Design and Development for the conversion of Windows based application to the
.Net Web based application
MITS Migration
This involved the design and maintenance of Database for the application,
developing Windows / Web Forms, using VB.Net and ASP.Net, XML Services and
ADO.Net integration. Modifying the Forms (Windows and Web) written in VB 6.0 and
ASP 3.0 for the upgrade to .Net based web enabled application. Reusing existing
business rules embedded in COM layer by making them .Net fit. Other
responsibilities included upgrading database from Oracle 8.05 to Oracle 9i.
Environment: Windows 2000, VB 6.0, ASP 3.0, .Net Framework (C#, ASP.Net,
ADO.Net, XML, SOAP), COM / COM+, Oracle 9i / Oracle 8.05
MITS (Pricing, Promotions, Quotes and Meet Comp)
This involved providing 24 X 7 support for the MITS application (Legacy and Web
Enabled), maintaining COM objects for Business rules for Pricing and Promotions,
user support involving cleaning and synchronizing of Database, developing the
database extracts for the data warehouse. Wrote and monitored Unix Shell Scripts
for automating various jobs such as Compilers, Extracts etc. complying with the
CMM Level 3 Processes.
Environment: Oracle 8.05, Visual Basic 6.0, COM, Trilogy, Citrix, Windows NT,
UNIX
May 2000 May 2002
Software Specialist - Patni Computers Ltd. (Mumbai, India)
CMM Level 5, Six Sigma and ISO 9002 Company. Deputed to the Client Site, which
include Pitney Bowes, Centegy and PurchasePro.
Requirement gathering
Creation Functional & Technical Design
Design & development of Modules
Creation & executed Test Plans
Extensive comunication with Clients
Resource Management
Clients:
Aug 2001 to May 2002
Pitney Bowes Inc. (Stamford-CT, US)
Role: Project Lead, Team of 4
Pathfinder Migration
The Project scope is to Design and Execute the Migration of Point of Sales Tool
(Pathfinder) a Client Server Application to Multi-Tiered Web Enabled
Application using .Net Framework. Reengineer the VB 6.0 and ASP 3.0 code, upgrad
it to .Net which involved converting ASP pages to ASPX pages, encapsulating data
in XML, changing the data layer from ADO to ADO.net and creating wrappers for the
existing COM components etc., Shell Scripts for automations. It also involved
Managing the Change Requests and Maintenance of the Tool till the Launch of the
web version.
Was the project lead, performed the role of Associate DBA and Architect of the
Migration Plan. Involved in designing the Pricing and Configuration Architecture,
which included Trilogy Pricer Model, Pricing Database & SC COM objects,
configuring the Parameter File for Databases, Backup and other performance
related issues, designing of Middle Tier Business Objects using VB.Net and C#.
Develop Web Forms using ASP.Net and VB.Net. For the existing Client-Server
Version, Maintaining VB 6 code for COM objects for Pricing & Business Rules,
using Trilogy Backbone and Trilogy APIs, writing stored procedures and queries.
It also involved interacting with UNIX and Mainframes for Price Downloads, Order
/ Quotes Uploads etc.
Environment: VB 6.0 / VB.Net, ASP 3.0 / ASP.Net, C#, XML, SOAP, Visual Studio
.Net, Oracle 8i, COM, Trilogy, Unix, Windows 2000, MS Project |