Project Manager
Resume:
Faruq Vadgama
North Brunswick, NJ 08902
732-***-**** [Home]
201-***-**** [Cell]
********@*****.***
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