Project Manager
Resume:
*********@*****.*** Senthil P Jayaraman 508-***-****
*********@*****.*** Senthil P Jayaraman 508-***-****
Page 1
Summary
Diligent IT professional with 17 years of experience, working as project lead, project
manager and senior business analyst for the last 7 years. Proficient with Oracle
Applications Financial modules OM, AR, PA, GL and CRM modules OIC, Resource Manager,
HRMS. Techno-Functional expert in Oracle Applications Incentive Compensation (OIC).
Expert in ad-hoc reporting for strategic analysis by management and business teams.
Proficient in project planning using MS Projects and presentation skills using MS
PowerPoint. Technical Architect proficient with PL/SQL, SQL, SQL*Plus, TOAD, data
modeling, performance tuning and UNIX shell scripting. Experience includes working on
Oracle Applications data conversion / data migration, 11.5.10 / 11i implementations and
R12 upgrade projects. Worked as production support personnel / lead for more than 5
years with an India offshore team model environment. Good listener and problem solver.
Experience
Staples, Inc., Framingham, MA, USA Principal Software Engineer Mar 2012 – Aug
2013
Worked as senior business analyst and project lead for R12 Oracle Applications Incentive
Compensation module implementation projects for commissions business. Conducted
requirements gathering sessions with business users, documented the business
requirements and created functional design documents. Resourced, planned and
maintained all project tasks, tracked and reported weekly on key project metrics to project
team and stakeholders. Documented the complete process for OIC Plan migration between
Oracle Application instances. Prototyped, created project charter, developed project plan
and served as a liaison between vendors, business and internal IT team for Fiserv Accurate
to Frontier migration project. Ensured risk mitigation plans and contingency/cut over plans
are proactively communicated to the project team and management for this cash
reconciliation application consolidation project. Unit/Integration testing team member for
Oracle Applications Release 12 upgrade project. Developed comprehensive test plans with
IT team and business users, coordinated test activities and helped execute test
components. Developed Visio diagrams with high level process flows for the projects and
presented it to executive team using Microsoft Power Point.
Parametric Tech Corp., Needham, Senior Programmer Analyst Feb 2001 – Feb 2012
MA, USA
Worked as project manager for of Diners Club project team that interfaced corporate credit
card expenses to Oracle Applications 11i iExpense module, successfully eliminating
hundreds of man hours of manual expense entries. Responsible for coordination,
implementation and administration of full life cycle of this project. Worked as project lead
to IC Verify project team that installed credit card validation software in a master server
station communicating with merchant bank and 4 substation clients enabling business to
handle customer invoice payments through credit cards faster and more efficiently.
Conducted project meetings and collaborated with team members to build consensus on
project issues.
Worked as senior business analyst for PTC’s capital/value adding projects. PTC’s OIC expert
who advised sales operations and commissions business every fiscal year. Senior BSA and
technical lead for Double Compensation Prevention project team that saved roughly
$60,000/year in duplicate commissions. Designed the custom double compensation
determination logic and aided the development of Oracle packages, procedures, functions
and triggers using PL/SQL. Key IT member in solution options analysis, prototyping, best
practices documentation, SOX / MA security compliance, business process improvements,
financial modeling, financial forecasting and reporting. Proficient in MS Excel skills
including macros and pivot tables. Business analyst for Data Quality Clean Up-
Deduplication project that cleaned up customer accounts and contacts using IBM Quality
Stage. Worked extensively on the Data Stage ETL tool extraction column mappings.
Page 2
*********@*****.*** Senthil P Jayaraman 508-***-****
Worked as technical lead to Credit Check project team, designed and developed program
and workflow changes that applied custom holds on low balance customer’s new orders
leading to large amounts of customer balance collections. Received PTC excellence award
for this project work in 2005. BSA and technical lead for OIC Automated Sales Credits
Assignments project team that integrated Oracle Territory Manager (OTM) with Incentive
Compensation (OIC). Received PTC excellence award for this work in 2007. Architect and
developer for Salesperson data migration logic from legacy 11 (OSC 3i) to 11i Apps tables.
Designed and developed AR Auto Invoice customizations with PL/SQL, UNIX Scripts and
Oracle APIs.
Worked as production support lead for Oracle Applications OM, AR, OIC, GL, AP and PA
modules. Proficient in root cause analysis of production issues and development of highly
scalable fixes. Worked closely with Oracle support on various TAR/SR creation and
resolutions. Handled JAVA, JSP code changes for PTC’s commissions web tool (OCWT).
Generated cost savings to business with automated OIC setups using Mercury QTP loader.
Designed and developed Oracle Applications AOL setups loader using UNIX shell scripts
and Oracle fnd_load API.
Texas Instruments, Attleboro, MA, Oracle Applications Consultant Feb 2000 – Feb 2001
USA
Worked as Oracle Applications 11 implementation consultant who developed data
migration programs using Oracle SQL* Loader, control files and UNIX shell scripts to load
data from legacy mainframe to Oracle. Coded database packages using PL/SQL, standard
Oracle APIs and Unix shell scripts to massage, validate and load the data into staging
tables for Inventory (INV), Customers (AR), Bill of Materials (BOM) and BOM attachments.
Enhanced standard Auto Lockbox program to recognize customer debit memos as credit
memos and close out partially paid invoices. Developed macros using data loader tool to
load data from excel sheets to Oracle Applications. Created ad-hoc reports using Oracle
Discoverer 2000.
Butcher Company, Marlborough, Oracle Consultant Oct 1999 – Nov 1999
MA, USA
Tuned low performance queries and stock inventory report with Oracle session level trace files, tkprof
and explain plan. Created index, temporary staging tables and data population scripts with Oracle
PL/SQL procedures and functions. Developed dynamic table analyze scripts for high volume stock
inventory tables.
Tata Consultancy Services, Mumbai, Systems Engineer and Oracle May 1997 – Aug
India DBA 1999
Worked as technical architect and Oracle developer for India’s market regulator SEBI’s
Investigation Enforcement & Market Surveillance office automation (IES) project in Oracle
Client/Server architecture. Data modelled the IES application using Oracle Designer 2000
tool. Developed global Oracle libraries with PL/SQL, SQL* Plus and UNIX and created Forms
templates to provide a standard tool bar, functionality and security features for all the
application screens using Developer 2000 and Forms 4.5. Designed and developed matrix
and drill down reports for surveillance of irregular share price variations in Indian stock
market using Reports 2.5. As DBA, installed Designer 2000 repository, created databases,
users, database objects like tables, views, indexes, roles, handled session locks, increased
table space, altered rollback segments and added data files. Designed and developed
security audit data model for SEBI Automation Project. Created the password encoding and
decoding logic for the SEBI Automation project. Oracle Reports 2.5 expert, conducted
reporting training sessions for SEBI IT group.
A.C.E. Info Systems, Bangalore, Software Programmer Jun 1996 – Apr 1997
Page 3
*********@*****.*** Senthil P Jayaraman 508-***-****
India
Worked as developer creating employee details data entry screens and payment reports
using Forms 4.5and Reports 2.5 on Personal Oracle 7 database. Created MS-DOS batch
programs to install payroll application creating tables, database objects and icons. Created
reports using Reports 2.5 to print attendance ledgers and employee monthly payroll on
preprinted stationary.
Skills
Oracle Applications: Oracle Apps 12/11i/11.5.10, Oracle Applications 11i, Oracle
Applications 11.5.6, Incentive Compensation (OIC), Sales Compensation (OSC), Resource
Manager, Receivables (AR), Order Management (OE, OM), Project Accounting (PA), Human
Resources (HRMS), General Ledger (GL), Inventory (INV), Bill of Materials (BOM), Apps
Object Library (AOL), Territory Manager (OTM), iExpense, IBM Quality Stage 8.0.1, Data
Stage
Tools: MS Project 2003, MS Visio 2003, MS Power Point, MS Office 2000, SQL*Plus, TOAD,
Explain Plan, tkprof, Workflow builder 2.6, JDeveloper, Designer 2000, Discoverer 2000,
Developer 2000, Forms 4.5/6i, Reports 2.5/6i, SQL*Loader, Export/Import
Applications: Brio, Scopus, Visual Source Safe, Data Loader, OrgPlus, Homesite, Fiserv,
Frontier, Accurate, Applix, IC Verify, ServiceNow
Languages: PL/SQL, SQL, Pro*C, UNIX Shell Script (ksh), Java, JSP XML, JavaScript, HTML, C,,
C++
Databases: Oracle 10g, Oracle 9i, Oracle 8.1.6, Oracle 7.3.4/7.3.2, Personal Oracle 7, MS
Access
OS: Windows 7/XP/NT, Windows 2000, Sun Solaris 2.6, Sun Solaris 5.8, MS-DOS
Education
Quality for Project Managers The George Washington University Feb 2006 – Feb 2006
BS in Electronics Engineering Bharathiar University, India Jun 1992 – Apr 1996
Green Card Holder
Page 4
Contact this candidate