Faruq Vadgama

*** ****** **

North Brunswick, NJ 08902

732-***-**** [Home]

201-***-**** [Cell]

acox89@r.postjobfree.com

Accomplished Senior-Level Executive with 18 years of experience in IT implementations,

Project Management, Operational Management, Strategic and Tactical Planning, and

Professional Services for Fortune 500 and Startup firms in manufacturing, financial services,

retail and technology.

Professional Experience

SumTotal Systems., Parsippany, NJ USA Oct 2012 – Till Date

SumTotal Systems, LLC, a Skillsoft Company, is the only HR software provider to deliver Talent

Expansion™ solutions that help organizations discover, develop and unleash the hidden potential

within their workforce and entire business ecosystem. Through the SumTotal elixHR® platform, we

offer our customers a virtual system of record for all talent applications, providing a unique ability

to link performance management, compensation and succession planning processes to learning

management systems (LMS) and workforce management data to provide the HR metrics and

workforce analytics they need.

IT Applications Manager

Responsible for providing program/project management services and act as a liaison with all

company Business Departments/Teams. Provided information technologies solutions to

complex business problems based on a comprehensive knowledge of organizational objectives.

Key Projects & Achievements

• Implemented a Change Management Process across the IT department

• Implemented Salesforce Chatter across the organization

• Implemented Salesforce Knowledge Base

• Upgraded Intranet environment from SharePoint 2007 to SharePoint 2013

• Implemented Extranet and Social Media Platform for outside customers

• Upgraded Softrax Financial system from 8.5 to 11.0

• Designed and developed Customer Communication application in sync with Salesforce

• Improved processes and data integrations between various systems

• Formalized Project management across departments

• Chaired the Change Committee to review/approve and prioritize projects

• Involved in budget and planning

• Managed SalesForce.com projects for both Sales & Service Cloud

• SalesForce CRM Integration with Financials, HR, TM, Customer Community and

Data warehouse platforms.

• Project Management using Agile methodologies

Environment: Salesforce.com, Softrax 11.x, Microsoft Great Plains, BigMachines, Microsoft SharePoint 2013,

Microsoft SQL Server 2012, .NET, C#, Java, Ruby, Informatica Cloud, Microsoft Project, Visio.

1

Dow Jones & Co., Princeton, NJ USA Jan 2005 – Oct 2012

Dow Jones & Company is a subsidiary of News Corporation (NYSE: NWS, NWS.A; ASX:

NWS, NWSLV; www.newscorp.com). Dow Jones is a leading provider of global business news

and information services.

Application Architect

Responsible for business application implementation, project management (small & large

projects), project planning, development & construction of business solutions, third party

consultant management (offshore, near shore & onsite). Creating project scopes and budgets

and do resource management and allocations. Define project priorities and business objectives

and establish relationship with the business partners.

Project: FxCRM – Fox News Digital Billing System

Role: Technical Lead/Architect, Project Manager

The FxCRM Project involves implementation of the Digital Billing System for Fox News which is a sister company

of Dow Jones. The Fox News Digital Billing was being handled manually which was an Audit and SOX

Compliance issue. FxCRM Project is supposed to automate the digital billing process and also put in controls in

place for audit and compliance purposes.

The Campaign/Orders are entered into the DoubleClick DFP system from where we receive a daily feed which gets

processed into the FxCRM system. Threshold rules are defined to manage change control which goes through the

approval process before it gets billed. The Billing template file is generated for the Broadway Financial system.

Responsibilities:

• Project scoping and requirements gathering

• Project planning and tracking

• Project resource allocations and management

• Gather requirements from business partners and user community

• Preparing functional and technical specifications

• Design of all the modules involved in the project

• Designing ETL Processes for the DFP/DSM data

• Designing Billing Extract for the Broadway Financial System

• Designing Transactional and Analytical reports

• Designing and Implementing data mappings and data warehousing

• Designing policies and procedures for change control and access levels

• Managing the onsite team in US

• Developing Forms and Reports

• Coordinating Stage moves for Integration and UAT testing

Environment: Oracle Middleware 11g,Oracle Forms 11g, Oracle Reports 11g, Oracle Discoverer 11g, Oracle Database

10g, PL/SQL, Java, SQL Navigator, Unix Shell scripts.

Project: Order-to-Cash (OTC) to xCRM Interface

Role: Technical Lead/Architect, Project Manager

The Dow Jones Financial System is being upgraded to PeopleSoft Financials 9.2. The interface between the xCRM

and PeopleSoft Financial system was be remapped and configured to support new features. It also involved

developing web services to get Customer and contacts data from SalesForce

Responsibilities:

• Gather requirements from the Billing/Finance users

• Project planning and tracking

• Preparing functional and technical specifications

• Managing the onsite team

• Data mapping with the PeopleSoft team

2

• Coordinating the development and testing cycles

• Designing and Developing Web Services interface to SalesForce

Environment: Oracle Middleware 11g,Oracle Forms 11g, Oracle Reports 11g, Oracle Discoverer 11g, Oracle Database

10g, PL/SQL, SQL Navigator, JDeveloper 11g, Web Services, Unix Shell scripts.

Project: xCRM Upgrade to Oracle Middleware 11g Platform

Role: Technical Lead/Architect, Project Manager

The objective was to upgrade the xCRM Billing System to Oracle Middleware 11g and also make into a web based

application. All the application objects including Forms, Reports and Discoverer reports were upgraded to 11g and

migrated to the Oracle Middleware 11g platform.

Responsibilities:

• Install and configure the Oracle Middleware 11g environment

• Components included Forms 11g, Reports 11g, Discoverer 11g, Oracle Weblogic server, Oracle

Enterprise manager, etc.

• Migrate all the Oracle 6i objects to 11g version

• Design and Develop new Forms for Dashboard, etc.

• Setup the Development, Stage and Production environment

• Designing ETL processes to integrate with the Advertising datawarehouse

• Analyzing and Implementing XML data transfers to the PS Billing System

• Designing the interfaces to/from Salesforce, PeopleSoft, E2 Billing system and Advertising datawarehouse

• Migrate the Database to Oracle RAC 10g

Environment: Oracle Middleware 11g,Oracle Forms 11g, Oracle Reports 11g, Oracle Discoverer 11g, Oracle Database

10g, PL/SQL, SQL Navigator, Unix Shell scripts.

Project: HP PPM Mercury Application Cluster Upgrade

Role: Technical Lead/ Project Manager

Dow Jones Information Technology Group established a Project Management Office (PMO) to support and

enhance Project Management at Dow Jones. HP Mercury’s product includes the following packages: IT

Governance Foundation, IT Governance Administrator, Portfolio Management, Program Management, Project

Management, Time Management, Resource Management and Demand Management.

The Mercury IT Governance (ITG) tool implementation provides Dow Jones with a comprehensive Demand and

Project Management tool. Mercury ITG is a unified, web-based workflow and project management system. It

provides a single project management process, input mechanism, and information repository as well as

management portfolio views supporting key performance measures and decision making strategies. Dow Jones will

leverage the functionality available to facilitate our system development life cycle (SDLC) process and Sarbanes-

Oxley required internal controls.

Responsibilities:

• Design Application Cluster environment for Development, QA and Production

• Implement the PPM Mercury Application across multiple clustered application servers

• Integration with the database server(s) and the Documentum application server(s)

• Planning seamless implementation

• Coordination and management of different teams involved

• Integration with Remedy

Environment: HP Mercury PPM, Oracle Database 10g, Cygwin, IIS Server, Java, Web Services, Unix Shell scripts.

•

Project: CourAccess – Systems Management and Access Control

Role: Project Manager/Technical Lead

Dow Jones implemented CourAccess to automate and control access to all the different applications/systems

throughout the company. CourAccess integrates with Courion to automate interface to Active Directory and

Microsoft Exchange. It also integrates with PeopleSoft HR to handle New Hires, Terminations and Employee

hierarchy. CourAccess provides individual system level approvals, audits and implementations.

3

•

Responsibilities:

• Project scoping and requirements gathering

• Project planning and tracking

• Project resource allocations and management

• Gather requirements from business partners and user community

• Preparing functional and technical specifications

• Design of all the modules involved in the project

• Managing the onsite team in US

• Coordinating Stage moves for Integration and UAT testing

• Successful migration to Production

Environment: Microsoft SQL Server 2005, Oracle Database 10g, Microsoft .NET 3.5, Microsoft IIS Server, SQL

Server Integration Services, Microsoft Visual Studio 2008

•

Project: CAU – Credit Card Account Update

Role: Project Manager

CAU implemented a web service based credit card information update/expiry system for all the Business Units in

Dow Jones using the DJCCCP (DJ Corporate Credit Card Processing). CAU was implemented as a web service

module in the corporate application repository. The interface to the bank to get the updates to the cards was

implemented using an XML file interface as defined by the FDMS (First Data Merchant Service).

Responsibilities:

• Post development review and implementation

• Inherited the project at the end of development stage when the project manager/SME left the company

• Identifying remaining work, coordinating with offshore and onshore development teams

• Building relationship with business partners

• Defining timelines and synchronizing with other projects and meeting the delivery dates

• Planning the integration and UAT testing schedules and Go live timeframe with Business Units and the Bank

Environment: Oracle Database 10g, IBM WebSphere 4.0, IBM Application Developer Studio 5.2, Java, Web Services,

Unix Shell scripts.

Project: xCRM – Billing Consolidation

Role: Project Manager/Technical Lead

The Billing Consolidation project’s objective is to integrate xCRM, Exact, COMS, Opera, APAC, and CIBS into one

consolidated Billing System. CIBS will be the base system for consolidation and all systems will conform to the

Factiva model for billing. The project involves a onetime conversion feed from xCRM to CIBS and a daily/monthly

feed automation from CIBS to xCRM to maintain the permissioning and royalty modules in xCRM.

Responsibilities:

• Project scoping and requirements gathering

• Project planning and tracking

• Preparing functional and technical specifications

• Managing the near shore team in Canada

• Coordinating Stage moves for Integration and UAT testing

Environment: Oracle Database 10g, SQL, PL/SQL, Forms 6i, Reports 6i, Oracle Discoverer, Unix Shell scripts.

Project: xCRM - Online Advertising

Role: Project Manager/Technical Lead & Architect

The Online Billing Automation Project initiative is to automate the online advertising order management- to-billing

process. Dow Jones has determined that there are a number of significant gaps that exist with the current manual

processes currently in place that will require the introduction of both technology and process automation and

enhancements to correct. The project consisted of the following modules:

4

• Operative Dashboard to xCRM interface for customer, campaigns and other related feed information

• Atex E2 Billing system to xCRM interface for Customer and sourcing information

• xCRM to PeopleSoft Billing interface for Invoices and adjustments

• xCRM to Advertising warehouse interface

• xCRM to Reps Commission interface to report on salesreps commissions

• xCRM Customizations to store and report on online advertising related information

Responsibilities:

• Project scoping and requirements gathering

• Project planning and tracking including scope changes

• Preparing functional and technical specifications

• Design of all the modules involved in the project

• Managing the off shore team in India and the onsite team in US

• Coordinating Stage moves for Integration and UAT testing

• Successful migration to Production

Environment: Oracle Database 10g, SQL, PL/SQL, Forms 6i, Reports 6i, Oracle Discoverer, Unix Shell scripts.

Project: xCRM – PeopleSoft Integration

Role: Technical Lead

Weekly and monthly files are created in xCRM for customers and billing transactions which are fed to PeopleSoft

billing to create customer invoices and adjustment documents. xCRM assigns the target invoice and adjustment

numbers as well as a batch name and number for each batch. The customer detail file must be sent first then each

billing and adjustment batch is sent to PeopleSoft Billing. The customer file represents any new customers or changes

to existing customers. The customer file is passed from PeopleSoft Billing to CARMS AR prior to invoice/adjustment

update.

Responsibilities:

• Designing the interface document and technical specifications

• Mapping of data elements between the two systems

• Development and implementation of the interface

• Coordinating Stage moves for Integration and UAT testing

• Successful migration to Production

Environment: Oracle Database 8/8i, SQL, PL/SQL, Forms 6i, Reports 6i, Oracle Discoverer, Unix Shell scripts.

CBS MarketWatch Inc., New York USA Jan 2004 - Jan 2005

Application Architect

MarketWatch, Inc., a wholly-owned subsidiary of Dow Jones & Company, is a leading innovator in business news,

personal finance information, real-time commentary and investment tools and data. The Company's MarketWatch

Licensing Services group is a leading licensor of market news, data, investment analysis tools and other online

applications to financial services firms, media companies, wireless carriers and Internet service providers.

Project: xCRM – eXtended Licensing Billing and Contract/Revenue Management System

Role: Project Manager/Business Systems Analyst/Technical Lead

The xCRM System is an internally developed MarketWatch application that supports a number of functions and

activities that are performed by various departments and divisions, including MarketWatch Licensing, IT, Finance,

Accounting and Billing. The application was designed and developed specifically to support the MarketWatch License

Sales process from booking to billing.

xCRM provides four types of functions as follows:

1. Customer Management (Contract & Billing, Inventory, Commissioning, Revenue)

2. Service Management (Sessions, Filters, Exclusions, Products),

5

3. Vendor Management via xPRM (Vendor management, permissioning and entitlement)

4. Royalty Management via SCBPM (Royalties/Usage)

5. Revenue Reporting

xCRM also interfaced with Oracle Financials and the Epicor Financial systems and the SCBPM Royalty

Management system.

Responsibilities:

• Requirements gathering and user inputs

• Design and development of the backend processes and front end screens

• Implementing user security and access groups

• Developing reports using Oracle Discoverer and Oracle Reports

• Defining product roadmap

Environment: Oracle Database 8/8i/9i, SQL, PL/SQL, Forms 6i, Reports 6i, Oracle Discoverer, Unix Shell scripts.

6

Pinnacor Inc., New York USA May 2000 – Jan 2004

Sr. Application Developer

Pinnacor Inc (formerly ScreamingMedia, Inc.) is a leading provider of business, financial and consumer

information and applications. The company offers fully hosted information solutions in Financial Services,

Corporate Information and Wireless markets, and excels in the customization and integration of data and

applications. Pinnacor delivers investment information and analytical tools to financial institutions; business

information and applications to corporate portals; and consumer and financial information to wireless devices,

ISPs, ITV devices, in-flight portals and kiosk.

Project: SCBPM – Client Over limit Billing and Provider Royalty Management

Role: Technical Lead

Pinnacor’s clients can receive, select, and use content from Pinnacor’s proprietary system, which aggregates,

normalizes and filters tens of thousands of pieces of content per day. Selected articles are then either hosted on

Pinnacor’s pages or delivered to clients via Pinnacor’s technology. Clients may use our application to populate

their site with content they choose or clients may let content populate automatically without editorial control.

Responsibilities:

• Requirements gathering and user inputs

• Design and development of the backend processes and front end screens

• Implementing user security and access groups

• Developing reports using Oracle Discoverer and Oracle Reports

• Implementing interface between front end SQL Server databases and SCBPM for Usage logs

Environment: Oracle Database 9i, SQL, PL/SQL, Forms 9i, Reports 9i, Oracle Discoverer, Unix Shell scripts.

Project: CCP – Customer Care Portal

Role: Technical Lead

Customer Care Portal (CCP) was a CRM application exclusively designed for Customer Service Implementation

and Trouble ticketing. The system was used by the sales and customer service staff to access the customer related

information including contacts, contracts, products, etc. The implementation group used it to track the customer

implementation and renewal of the contracts and services. CCP was a web based application designed in .NET and

C# with a SQL Server backend. It had a direct interface with the billing financial system for customers and related

information.

Environment: Windows 2000, SQL Server, Visual Studio .NET, C#, ASP.NET.

Project: Oracle Applications Implementation and Customizations

Role: Sr. Software Developer

The project involved Oracle APPS Financials Implementation for Sales Management, Order Entry, Accounts

Receivable, Accounts Payable, Purchase Order, Asset Management, General Ledger, etc. The system was customized

to handle the licensing billing and custom workflow defined by the business. Existing screens were customized for

specific needs and new screens and reports were created as plugins to accommodate extended modules for contract

management and permissioning, etc.

Environment: Oracle APPS 11.0.28, Sun OS, Windows NT/2000, Oracle 8/8i, Forms 4.5/6i/9i, Reports 2.5/6i/9i,

Oracle Discoverer.

Tata Infotech Ltd., Mumbai, India Nov 1996 – May 2000

Sr. Application Developer

Project: Enhancement And GST Conversion For BIGW, SYDNEY (AUSTRALIA) Nov‘99-Apr’00

BigW, Sydney, Australia is a company having a chain of stores distributes throughout Australia. It has all its operations

and processes computerized. Each of the stores has a separate database on Informix and controlled by the central

system, which is in Informix as well as in Cobol.

Australia is going to implement a new Tax system called GST (Goods and Services Tax) starting 01st July 2000.

According to GST some of the goods and services would be taxed 10% of their selling prices and some of them would

be exempted. Australia currently has a tax system called WST (Wholesale Sales Tax), which would be removed once

GST is implemented.

7

The project involves making changes to the existing systems to reflect the new tax system and isolating the old tax

rules.

Environment: HP-UX, Informix, Forms Painter, C, and Unix Shell Scripts.

Project: User Documentation for Tata Special Steels Ltd., Bombay (INDIA) Jul’99-Nov‘99

Tata Special Steels Ltd. (Tata SSL), Borivali, Mumbai, is a company dealing with steel products. It has all its processes

computerized and distributed into different modules like Accounts, Marketing, Production, etc. The project involved

documenting all of its modules, which required through understanding of the processes and also of the operations of

different modules.

Environment: Sun OS, Oracle 7.3, Developer 2000, Forms 3.0/Report Writer 1.1, C, Unix Shell Scripts, and MS

Office.

Project: Y2K Renovation And Testing For TATA SSL, MUMBAI (INDIA) Jun’99

The programs are developed in client/server environment with ORACLE Ver 7.3 RDBMS as backend under Sun

Solaris and Forms 3.0/Report Writer 1.1 as front-end tool under Unix environment. The project involved Y2K

renovation of the different systems.

Environment: Sun OS, Oracle 7.3, Forms 3.0/Report Writer 1.1, C, Perl, and Unix Shell Scripts.

Project: Development Of Graphical User Interface For The Trims Application

For NCDC, North Dakota (USA) Dec’ 98–May’99

TRIMS (Trouble Report Information Management System) are a fault tracking system catering to the needs of

development sites. It aids in project monitoring and quality assurance. It had been initially developed in PROGRESS

4GL available on UNIX based machines. TRIMS are targeted at Programmers, Test Co-coordinators and Project

Managers.

Environment: SCO Unix, Windows’95, Progress 8.1, Progress 4GL, User Interface Builder.

Project: Enhancement and Y2K for Trims Application

For NCDC, North Dakota (USA) Oct’ 98–Nov’98

The programs were developed in client/server environment with PROGRESS V8.1A RDBMS as backend under SCO

UNIX environment. The project involved modification to existing code to improve the efficiency of queries and also to

make the Reports Y2K compatible.

Environment: SCO Unix, Progress 8.1, Progress 4GL.

Project: HORIZONPLUS - General ledger

For North Central Data – Cooperative (NCDC), NORTH DAKOTA (USA) May’98–Sep’98

North Central Data Co-operative (NCDC), Mandan, North Dakota, develops software and provides data processing

services for Rural Electric and Telephone Co-operatives.

In the General Ledger module there are various tasks such as setting up accounts, entering adjustments (transaction

entry), setting up budgets, period-end processing (includes distributing account balances and printing financial

statements), and year-end processing (includes distributing profit and printing financial statements).

Environment: SCO Unix, Windows’95, Progress 8.1, Progress 4GL, User Interface Builder.

Project: DATA WAREHOUSE for General Electric Information Services (GEIS),

Rockville, Maryland (USA) Dec’96–Apr’98

GE Information Services, headquartered at Louisville is one of the major businesses of the General Electric Company.

General Electric Information Services has all the EDI services. Data Warehouse is built by collecting data from various

on-line databases viz. Client*Talk Express, ECLIPS, REVENUE, Change Management System, Global Revenue of

GEIS. The off - line warehouse will sit between a front-end and many on-line databases of GEIS.

The targeted users for this project were managers and analysts. The information in data warehouse will be used for

analysis and reporting.

Environment: HP-UX, Oracle 7.3, Informix 4.1, Sybase 10.0, SQL, PL/SQL, C, Perl, Pro*C, Informix 4GL, Sybase

SQR, Unix Shell Scripts.

8

CAPABILITIES

• •

Engagement Project Management Business &

Expertise • Technical Process Re-

Applications Evaluation &

design

Selection

•

• Team Building

Data Conversion, Interfaces

•

(ETLs) & Customizations IT Planning &

• Execution

Applications Implementation

• Quality Control/

Assurance

Technologies Software, Tools & Languages Databases

SalesForce.com, Force.com, Oracle 7.x, 8i, 9i, 10g, 11g

VisualForce, Oracle Applications SQL Server 2005/2008

version 11.0.28, Oracle Forms Informix 4.1

6i/9i/11g, Oracle Reports Sybase

6i/9i/11g, Oracle Discoverer Progress

3.1/11g, Visual Studio .NET, IBM MySQL

Websphere Studio Developer 5.2,

PeopleSoft Billing, C#, ASP.NET,

Java, Ruby, Rails Framework,

Microsoft Office 2003, Perfect

Office

Hardware & Operating Systems

Linux (RedHat, Mandriva,

Ubuntu), Unix (HP-UX, Sun OS),

MS-Windows (2000, NT, XP,

2008, 2012)

EDUCATION

SalesForce Developer (DEV401)

Building Applications with Force.com

Armiger International

Fundamentals of Project Management, 2007

Project Management: Intermediate, 2007

Project Management: Advanced, 2007

Oracle Corporation

Oracle Application Server 10g R2: Administration 1, 2006

Oracle Application Server 10g R2: Administration 2, 2006

Dow Jones Training Services

Red Hat Linux Enterprise Server Management, 2005

Oracle Corporation

Oracle 9i DBA Admin & Architecture, 2005

9

Thinkpath Training Center

2349 Programming the MS.NET Framework with C#, 2002

University of Mumbai

B. E., Electronics, 1992 – 1996

10

Contact this candidate