Oracle Project
Resume:
Sanjeev Tripathi
* ******** ******** *. **********, MA 01863
H: 978-***-**** C: 781-***-****
*********@*******.***
Permanent U.S. Resident (Green Card Holder)
SUMMARY:
. Over 15 years of IT experience in analysis, design, development,
testing, implementation, customization and product development
using Oracle Applications (R12/11i/10.7/10.6), Oracle tool set and
other third party tools for Hi Tech, Finance, Pharmaceuticals,
Insurance, Manufacturing, and Electronics Industries in global team
environment.
. Experience as a Techno-Functional Analyst/Team Lead in
Implementation, Customization, Migration, upgrade and Production
Support of GL, AR, AP, FA, CE, FA, PO, INV, OM, HR Payroll, PA,
WIP, Quotes, Contracts, Service Requests, Cost modules of Oracle
Applications (R12/11i/10.x).
. Extensive experience in customization of Oracle EBS using OA
Framework, APEX and Oracle Forms 9i/Reports 9i to improve business
functionality and provide depth visibility to management.
. Strong project management, organizational, team building,
leadership and cross-functional skills. Successfully managed
outsource/offshore development and support teams.
TECHNICAL SKILLS:
. Oracle Applications: Oracle EBS R12 (12.0.4) RUP6, 11i(11.5.X)/10.7
SC/10.6 (GL,AR, AP,CM, FA, INV, OM, PO, PA, WIP, Costing, Work
Flow, HR, Payroll, Install Base, Contracts, Service Requests,
Quotes, Incentive Compensation, Global Accounting, iProcurement,
iTime, iExpenses, Application Object Library (AOL) and System Admin
modules), Oracle Alerts, XML Gateway/EDI.
. Database: Oracle 10G, 9i, 8i(8.1.7.4)/7.x
. Languages: SQL, PL/SQL, JAVA, C, COBOL, PASCAL, Pro*C and JSP
. Hardware: IBM PC and Compatible, HP Servers, Sun Solaris Servers,
DEC Alpha Servers
. OS: Windows NT/2000/98/95/3.1, UNIX, Linux
. Tools/Utilities: Developer 2000, Forms 9i/6i/4.5/4.0/3.0, Reports
9i/6i/2.5/2.0, Oracle Application Express (APEX) 3.2.1, Oracle
JDeveloper, SQL*Loader, Discoverer 10G, XML Gateway, BI Publisher,
Import/Export, TOAD, Oracle Discoverer, ADI, Reflection (FTP
Protocol), Power Builder (4.0), PVCS, Business Objects 5.i/5.0/4.0,
MKS, Crystal Reports, MS Projects, MS Office, PowerPoint.
. Web Servers : Tomcat 1.4, Apache, Weblogic
PROFESSIONAL EXPERIENCE
STR, Enfield CT
July 09 - Present
Role: Sr. Consultant/ Tech Lead
. Designed and developed interfaces to synchronize data in Oracle EBS
Trading Community Architecture (TCA) data model and other
applications.
. Developed strategy to implement procedures to improve quality of
data and have golden copy of customer data in Oracle TCA module
that being referred by multiple applications (Customer Hub).
. Used Data Quality Management feature of Customers Online to improve
data quality.
. Designed and developed Interface programs to load Install base,
service requests and service contracts data from legacy application
to oracle EBS.
. Created custom responsibilities and Implemented strategy to archive
aged data while maintain accessibility using same GUI to be
compliance with SOX and other regulatory authorities.
. Designed and developed custom reports for Oracle EBS using BI
Publisher and Oracle Discoverer for external audit and SOX
compliance purpose.
. Created functional design and technical design documents along with
other required documents to keep all the stake holders on the same
page and have low future maintenance overheads.
. Implemented change control process along with other process
improvements to understand business requirement more accurately and
convert in efficient technical solution.
. Established software coding standards to have uniformity of code
for better performance, smooth integration, easy maintenance and
improve quality of support.
. Mentoring junior team members to bring them up to the speed to
improve team performance.
Environment: Oracle Financials 11i (11.5.10), Sun Solaris, BI Publisher,
Discoverer 10G, OA Framework (OAF), PL/SQL, SQL*Loader, Toad, Oracle
database 10G, SVN
EMC Corporation, Hopkinton MA
July 04 - July 09
Role: Team Lead/ Principal Software Engineer
. Lead the team to do substantial customization in AR and AP/PO
modules to convert data from legacy application to Oracle 11i and
archive it to improve performance.
. Designed and developed Product lookup, Order Lookup and Customer
Lookup screens using APEX to have comprehensive information about
these entities at one place for use convenience.
. Customized workflow programs for PO and service Module using Oracle
Workflow and PL/SQL.
. Customization of the Order Management Workflow for the RMA
transactions.
. Designed and developed reports like Quantity in hand with serial
number and revisions, Shipping tracking report, shipping document
station, Shipping queue, Open order ageing report, booking on hold,
Revenue recognition reports, Budgeted Vs Actual report using Oracle
BI Publisher.
. Created encryption and decryption and data masking procedures to
copy HR, Payroll and other sensitive & confidential data from PROD
to cloned instances.
. Designed and developed reports like Customer invoice summary,
Revenue details report, AR remaining balance report, AR receipts
and AR ageing reports using BI Publisher.
. Created custom workflow program to improve functionality of
iExpense and AP.
. Customized and personalized forms for OM, AR, INV, AP, PO and
Project Accounting modules to meet the business requirement by
extending functionality and maintaining same look and feel.
. Designed and developed GL Reconciliation Process for Journal
Import. Developed the Reconciliation Instance report, which can be
used for various imports inbound / outbound. This process is a
daily process scheduled by daily scheduler.
. Created documentation including Business specifications, Technical
specifications and end user documentation as per Oracle's
Application Implementation Methodology (AIM).
. Good understanding of Service Oriented Architecture (SOA) and
experience with Oracle Applications (OA) Framework to customize
Oracle EBS.
. Designed and developed interface programs for finance modules
AR/AP/GL/CM and CRM modules (Service Contracts/Services Requests/
Install base) to load data from legacy system to Oracle EBS.
. Created concurrent programs to archive aged data for Contracts,
Quotes, Service Requests and Incentive Compensation modules to
improve performance of the system and reduce admin cost.
. Worked extensively to provide support to customers on PROD system
through Oracle on Demand (OOD) and Oracle online support process
(metalink) to narrow and resolve issues efficiently.
. Work in onsite/offshore/outsourcing models, and implemented
processes to improve communication process, efficient utilization
of resources to lower TCO of solution while maintaining quality.
. Traveled internationally for various Oracle EBS implementation
projects and worked closely with vendors, implementation partners
and outsourcing teams to come out with best possible solution.
. Created and time to time revised documents on development standards
to avoid duplicate efforts and improve maintenance and support
activities.
. Followed PMI guidelines and techniques to improve quality of
deliverables and complete task on time and with in budget, used
Waterfall, Oracle AIM and Agile SCRUM methodologies.
Environment: Oracle Applications R12, 11i(11.5.10, 11.5.9 ...10.7) GL, AR,
AP, PO, CE, FA, OM, INV, WIP, Workflow, PA, HR, Payroll, Contracts, Service
Request, Quotes, Incentive Compensation, Customer Online, MS Projects,
Toad, Oracle Forms 9i/6i. Oracle Reports 9i/6i, Discoverer 11G/10G, BI
Publisher 10.1.3.3.1, APEX 3.2.1, (PeopleSoft 8.x, 7.x, SAP R/3, SAP B/W
3.x Sun Solaris, HP UNIX, Linux, Windows, Oracle Database 11/10G, 9i, 8i
State Street Bank, Boston MA
Feb 04 - July 04
Role: Sr. Consultant/ Tech Lead
Migration of Ireland Companies from SAP R/3 to Oracle Apps 11.5.9
. As a Tech lead worked with business analysts and end users to
create GAP and MAP analysis report to migrate finance operations of
Ireland companies from SAP R/3 to Oracle Applications.
. Developed IMS OOPs Process, Bridge between AP to AR and AP to GL
and also AR to GL. The AP Invoices get transferred to AR as
transactions completed and invoices paid.
. Developed AR Customer Interface with all the customer info
including Banks and profile info. This Interface is developed
various customizations and validations to suit SSC business needs.
. Designed and developed GL Invoice Import for the Ireland rollout
project, serving their business needs. This Interface couples
various feeds coming into GL
. Designed and customized the AP OOPs custom Form (Out of Pockets),
to generate the OOPs invoices in AP. This form serves like the
Invoice gateway form, apart it generated the distributions lines
automatically from business policies.
. Designed/developed various DFF's, Flex fields and Value sets
necessary for all the above custom processes and Reports based on
the business requirements. Also involved in defining the AP/GL/ AR
Lookup Codes, Profile options etc to satisfy custom process.
. Designed and developed various Custom reports on AP Electronic
Payments and AR Auto receipts.
. Developed and Supported AP Open Interface, feeds from various
sources needs to validate and to generate invoices with the
transaction report / error report.
. Customized the AR Auto Invoice process for Ireland, thru user form
Interface, which the users can upload the source file in three
formats with several validations to load into AR Interface tables.
The user can view the transaction report / Error report log.
. Developed customized user friendly AR Interface Form, to generate
AR Transactions using Auto Invoice. This form was designed to
accept the input sources for different formats, which validates and
submits Auto Invoice with the log report.
Environment: Oracle Financials 11i (11.5.9), Sun Solaris, Oracle Reports
6i, Oracle Forms 6i, PL/SQL, SQL*Loader, Toad, SAP R/3, Oracle database 8i,
PVCS
Parexel International Corporation, MA
April 98 - Jan 04
Role: Senior Programmer/Analyst (Team Lead)
. At PAREXEL involved in implementing Billing and Costing
functionality of Oracle Projects. Converted all Open Contract
Projects, Agreements, Funding, Budgets (Original and Current
Budgets), Costs (Summarize by project/task/Expenditure category),
Pass Thru Revenues and Invoices.
. Created interface programs using SQL*Loader and Oracle PL/SQL to
connect Oracle applications and custom applications to automate
dataflow and avoid data related issues.
. Designed and developed data warehouse system using Business Objects
4.0, created universes on top of Oracle Applications and schema and
custom PAREXEL Project Accounting schema.
. Created functional and technical specifications for enhancements
and customizations in Oracle Applications to meet business needs.
. Designed schema for custom Parexel Project accounting system to
meet business needs.
. Designed and developed Reports Interface Customization and
Extensions (RICE) solutions for Oracle application modules namely
GL, AR, AP, CM, FA and Project Accounting (PA) using Oracle
toolset.
. Implemented Order to Cash process for one of acquired unit of
Parexel including data conversion from legacy to system to Oracle
Application using Oracle interface and API's.
. Developed procedures to post Inter company transactions in multi-
currency and multi-org.
. Contributed in upgrade of Oracle Applications 10.7 SC to 11i
including developing data conversion procedures and migration of
customized programs for specific business needs.
. Customized and implemented new workflow programs for Project
Accounting, Accounts Payables and Purchasing modules to streamline
business processes.
. Administered and configured reporting tools such as Business
Objects (BO) and Oracle Discoverer to run ad-hoc reports by end
users and created standard reports.
. Developed stored procedures to extract data from source
application, perform data cleansing to validate and load to staging
tables from where it can be picked by standard Oracle Application
processes.
. Created custom tables to store additional information in Oracle
applications.
. Created document for development standards to have uniformity in
the code and proper naming convention and other required details
which can be used to future changes.
. Configured, administered Oracle Discoverer and assist user to
create ad hoc reports.
Environment: Oracle Financials 11i (11.5.6), 10.7 SC, Sun Solaris, Oracle
Reports 6i/2.5, Oracle Forms 6i/4.5, PL/SQL, SQL*Loader, Toad, Business
Objects 4i, Oracle database 8i, MKS
ADDITIONAL PROFESSIONAL EXPERIENCE
Consultant at AETNA Life Insurance, Hartford CT; worked on design,
development, test and implementation of Fee for Service (Extension to
Oracle General Ledger). Followed Oracle coding standards and used Oracle
provided templates for developing forms and reports. Also worked on
Designing and coding of interface between Fee for Service and Oracle
General Ledger; registering forms, reports, menus, value sets, concurrent
programs using AOL functionality; integration of Fee for Service extension
to Oracle Application system admin module.
Consultant at OHM Corporation, OH; involved in the Implementation and
Customization of Project Accounting and Account Receivables modules. It was
migration of financial data from legacy system to new Oracle system using
Oracle Financial 10.6 and later on upgraded to 10.7. Also responsible for
customize standard and Develop new reports for AR and Project Accounting
modules using Oracle Reports (2.0/2.5), tuning reports using optimization
techniques; created Interfaces to integrate Oracle Financial system with
legacy system using interface tables, SQL*Loader, PL/SQL procedures, AOL
functionality and UNIX scripts.
DEVELOPER for DCM Data Systems, Delhi India; developed custom software
applications for finance, payroll and HR using Oracle Developer 2000
toolset (Oracle Forms 4.5, Oracle Reports 4.5) and oracle database 7.0
PROGRAMMER ANALYST for NetCom Software & Systems, Delhi India; analyzed
business operations and developed software application for Material
Requirement Planning (MRP) for an electronic goods manufacturer using Power
Builder 4.0 and Oracle 7.0.
EDUCATION and ASSOCIATIONS
MS Computer Applications, Barkatullah University, India
Completed 80% coursework towards MS IT Management, Brandeis University,
Waltham MA
BS Major in Mathematics, Jiwaji University, India
Member, Project Management Institute (PMI)
Contact this candidate