Oracle Application’s Techno Functional/ITIL (US Citizen ) abul0r@r.postjobfree.com 703-***-****
Published White Papers & Articles
XML services for service oriented projects Publish on 2009
A Patching Mechanism I Use for Oracle Code Migration Published on Aug-06
Using 'Windowing' to Calculate UNDO Segment Size Considering Peak and Off-Peak Database Time Published on Sep-06
At National level awarded silver medal for Post Graduation work for 98.5% amazing accuracy in
‘low pressure dia casting simulation work ’ Paper presented on Jan, 1999
Architectural & Design work
Generic framework was design and developed for loading Inventory items, dynamic BOM creation into e-business suite.
Design system to collect sales orders from custom application into e-business suite and develop workflow,
Procurement flow, invoicing, EDI interface, service contract, field service and closing orders.
Architect on developing generic mechanism for handling various xml messages like RosetaNet 3A4, 3A6, 3B2, 3C3,
2A1,EDI850, EDI855, EDI856, EDI810, EDI832
SOX complaint design OID - e-biz connectivity & LDAP authentication for oracle e-business suite.
Put forth XML Architecture to consume and publish xml records over TIBCO bus or web service (WSDL).
Sales reps quota calculation generic rule based engine is developed and receive Hugh compliments from business.
E-biz upgrade from 11.5.4 to 11.5.10.2 – Under this project, developed various designs
• Redesign processing logic & bring down performance of “worksheet” creation from 16 to 2 hrs.
• Use stored outlines to avoid core oracle product code changes to address performance.
• Work with oracle product development team to address various data conversion, data corruption & performance
doing upgrade process.
• Developed algorithm/query to correctly calculate UNDO size for particular database.
Pre-processor module of single & multi threaded program developed by understanding hardware & software capacity.
even though it’s not AI (Artificial Intelligent) project, enhanced retro transactions processing methodology amaze business
and stake holders.
Responsible for developing eBusiness suite concurrent manager capabilities under hood of simple PERL module.
Design generic program to load various type revenue records.
Core Technical Competencies
• On 15+ year software working experience, hands on Oracle Applications 11i, R12 in INV, CST, BOM, WIP, PO,
OM, HZ, Install Base, Service Contracts, AP, AR, GL ( Oracle Financials ) EDI, Tibco XML Services, Web
services,SOA, wsdl, CN, WMS, Workflow design & Customization, APEX, BI Publisher
• Expert in Development/ Customizations/ Conversions/ Up-gradation/ Debugging/Integration of Oracle
Applications.
• Data Administration, Database design, Sql Loader, External Table.
• Performance Tuning using techniques like AWR and PERFSTAT and I3 from Symantec and SQL optimizer to Fine
Tune SQL and Taking Advantage of the New Optimizer Techniques and Database Parameters, Tracing
Techniques, TKprof, Execution Paths & Oracle wait event analysis.
• Strong application development skills using C++, C, Pro*C, PL/SQL, Sybase, Oracle.
• Use of various design patterns in JAVA, C++ & PL/SQL languages.
• Real Time, Multithreaded, Communication (Socket Programming) applications development.
• Single Sign-on, Oracle Internet Directory, BC4J, iAS10g, Apache.
• UNIX shell programming. Ksh, Csh, Sed, Awk, PERL. Oracle Metalink, OEM, ERwin, TAR management.
• Extensive experience in Application Object Library (AOL), develop Functional Document(MD50), Technical
Design Documentation (MD70) and Installation Documents (MD120)
• Worked on Oracle database hosting web-service, database consumes web-service.
Core Management Competencies
• Developed and executed technical project plans for multiple projects.
• Ability to prioritize effectively, multi-task and achieve objectives within time and budget constraints.
• Effective management of on-shore, off-shore IT model.
• Develop/Embrace team culture in development team.
• While building strong business relationship perform business process modeling. This leads to improve process
cycle time and productivity improvement
Career History
Centurylink International, Arlington VA 2000 to present
A Unique hybrid local and Global voice, data, Internet and wireless Telecom Company
Title – Staff Engineer
Advanced through a series of IT promotions based on consistent strong performance, applying technology to business
problems, improving productivity and developing various architectures to streamline IT systems and by managing
development resources. Recipient of Qwest Spirit of Service award and multiple Spirit LinQ awards for outstanding
customer service. Worked on various of projects as follows
R12 Upgrade – Lead two R12 (12.1.3 & 11g database) upgrade implementations from 11.5.10.2 to 12.1.3. First upgrade
was in government area, with two operating units, and second one was commercial business.
• Functional – Foremost important is to make sure business understand new e-Biz interface compare to old form
based interface. Working closely with business analyst write down requirement gathering, customizations,
configuration setups for oracle application, MOAC setup, writing training material, provide analytical/knowledge
extraction from data for business, Demo changed functionality to end users, support system testing and play IT
point of contact for business.
• Technical – Estimating work efforts, architecting system interfaces, designing custom solutions, conversion
scripts, leading developers, scheduling, and providing production support and most important handling post
production performance issues. Using OAF extend EO, VO to support business requirements. After R12 upgrade
converting form based reports to BI publisher, Using ebiz iRepository to interface with mainframe system using
SOA web service. Publishing pl/sql functions as webservice using Native Oracle XML DB Web Services
• Management – Upgrades are real challenging projects and this time 8 smart minds from offshore & 4 from
onshore along with few TCS team members, we(as a team) able successfully deliver this project. My ITIL
certification, technical skill sets and knowledge of Agile / Scrum methodologies help me to lead this small team.
Consolidation Project: On this 11i implementation project, It’s an oracle e-business suite system uses various oracle
modules like Order Management(ONT), Purchasing(PO), Receivables(AR), Bill of Material(BOM), Field Service(CSF),
Projects(PA), General ledger(GL), warehouse management(WMS), Service Contract(OKS), Install Base(CSI)
While working on this $21 Million project, I successfully completed following tasks.
• Functional Work closely with business, key stakeholders in requirements gathering, GAP analysis, Configuration,
discuss Data Migration strategies, and back out plans.
• Flex Use, Setups, DFF, FND Load, Concurrent Manager setups.
• Creation of MD050, MD070 as well as MD120
• Created training material and also conducted training sessions with end Users.
• Analyze various business issues like - Cost of Goods Sold, Sales order profitability, internal labor etc
• Technical Move of old legacy system(11.5.3) to new 11.5.10, migrate 64,000 parties, their customer accounts,
customer sites, locations into new system using TCA module public API. Develop various data massaging
techniques ( eg, address cleanup using wsdl, name and site cleanups, develop reports to get business input).
Then converted ITEMs, Install Base, Service contracts, in-flight orders, Purchase Orders, project and project
tasks. To track overall process, developed error tracking mechanism to improve conversion effectiveness.
• Develop TIBCO XML services to transfer data from B2B communication. Use of data compression mechanism
reduce XML payload by 98.5%.
• Load various Sales order (new, change, disconnect, move) through external systems using XML interface into e-
biz. Use of automation in customer, BOM, Item creation helps business to avoid order fallouts and success rate
around 95%. Afterwards work with business to achieve 98.7% accuracy. To achieve 100% accuracy, ROI was not
impressive.
• For all converted sales order types (install, install-PB, Maintenance Only, Labor only, and Return) design of workflow
processes, associate business flow with various workflow processes for automation.
• Use of B2B communication using EDI technology send and receive EDI850, 855, 856, 810 messages and
RosetaNet xml(3A4, 3A6, 3B2, 3C3) to various suppliers.
• Using EDI832 & Cisco RosetaNet xml 2A1 collect item, quote information, and load into oracle application.
• Along with providing technical guidance to all team members, handling management conflicts and keep project
on budget & on time.
• Address various UNIX and database performance issues.
• Lead coordinator to manage workload across onshore and offshore team members and defect resolutions.
• Handle FORM Personalization, Custom.pll for adding various validations and oracle API calls.
• Use APEX language for quickly displaying business reports.
• Management On this project, I was responsible for 12 development team members work. My daily agile/scrum
meeting help me to navigate this project successfully. Constant touch and code reviews, design discussions,
brainstorm sessions help me to build good team culture. This really help during user acceptance test and post
production support.
Networx Project: It’s an order management system to place orders as per Networx contract with USA government.
Technologically it uses various oracle modules to place sales orders, setup service/equipments at customer site, provide
customer service and billing.While working multi-phase project of each phase around $600K to $1.3 Million.
My contribution to this project as follows
• I reduce defect frequency by through code review and making sure code is performance tuned.
• Redesign EDI ( electronic data interchange ) interface into XML interface
o New XML interface framework design
o Responsible for framework development.
o Design XML schema’s for EDI850, EDI855, EDI856 & EDI810
o Overall responsible for individual developers work on this area.
• Responsible for developing complex report like order profitability report, procurement reports.
LDAP authentication for SOX project: For E-business suite and custom application, users required to be authenticated
using central corporate LDAP directory.
• Overall accounted for leading development team, architect the process to address SOX requirements. Design
also well conversant business requirements.
• Implemented new features to synch-up LDAP with OID and e-biz users & their responsibilities.
• Work on SSO, OID, OCA, OCJ4 securities, iAS10g
• Use oracle DAD (Database Access Descriptor) technology to cater unique business requirement.
Oracle Upgrade: Upgrade e-business suite from 11.5.4 to 11.5.10.2 for Sales Compensation module (CN).
• Technical lead for development and DBA team.
• Responsible for enhancing various performances during and after upgrade. Using ‘Stored Outlines’ address
performance issues which leads to avoid change in core oracle product to suit client environment.
• Redesign number of processes to fit business requirements.
• Publish two articles/papers on metalink on “Patching mechanism” & “undo table space size”
Qwest Sales Compensation: On this 11i implementation project, Qwest has start using CRM product ( CN ) for their
sales compensation . Initial project phase I was responsible for Qwest custom development for this project. Development
involve writing multiple interfaces
• Interface between company’s hierarchy manager to Oracle CRM product(JTF, HR)
• Collecting customer’s transaction from 17 billing systems. These collections include database to database load,
flat file of delimiter or fixed width file to database load. I was a designer for this C++ generic loader framework.
With a help of 2 team members this product was deliver with testing in 2 months from scratch.
• Responsible for writing complex Pre-processor, assigns transaction from customer to sales reps and handle all
RETRO’s . Module has concurrent processing mechanism which process nearly 20 million transactions in
recoded 2.35 hrs, by using 10 processor S class HP UNIX server.
• Responsible for process performance tuning include
SQL tuning
Job Forking
Developing a generic concurrent batch processing mechanism
• Architecture of Quota Engine design, which predicts sales reps quota -- Quota Engine has a capability of dynamic
formula configuration.
• Working with Core CRM product Oracle development team on various TAR’s
• FIN project – Design project interface which is Sorbonne Auxiliary compliance. Project loads more than
$520,000,000 dollar revenue collection for BMG sales compensation system.
Commission Calculation: This is a batch engine of commission calculation, written in C++, which calculates the
65,000 agent’s commission depending upon their sales plans.
Responsibilities
• I worked on the batch process of loading data from various database, flat files to our project database and then
commission calculation process.
• Apart from ongoing maintenance responsibility, I implemented the 2001 sales plan in this system. By using a
design patterns code become more generic and standard. Use of Rational Rose to create new project classes,
interaction diagrams, helps me too in documentation.
• I improved the performance of the batch engine nearly 35 % by avoiding the parsing & reparsing of the same
query. This is achieved by converting normal queries into bind one. ( previously engine is taking 13-14 hrs, now it
takes 7:30 – 8:00 hrs )
• To resolve the production problems, correction of production database, I had written number of cursors,
procedures, triggers.
• To accommodate the new 2001 sales plan design, I suggested & design the new database tables. As SQL’s are
the hearts of the project. I improve the performance of the database by avoiding a table latching.
Covasoft Inc . Austin, Texas May 2000 to July 2000
Title – Consultant
Covasoft Product- This is a real time business Management system.
• I was responsible for the writing a module (as a statically link library) for the smoothening the communication
between client & server in TCP/IP socket communication. I started this work from scratch & written nearly 15
classes in C++ to achieve this aim. By creating abstract classes it become true modular. Advantage of this
modular design is, it gives good traits to write client modules. By using abstract classes, virtual functions achieve
advantage of run time polymorphism.
Leading Edge Systems Limited, Bombay Aug 1999 to Apr 2000
Title – Engineer I
Leading IT company providing a software service / products for the financial applications like Index computation, Share
trading software, Stock Pro (settling, slips etc), Money Manager (Dept market).
Computer to Computer Link
Computer to computer link is a real time system for trading shares on the National stock exchange India . System is
divided into two parts Trading Server Software (TSS – server ) and Trading Workstation ( TWS – client ). System works
on the specifications that provided by NSE to trade on NSE & also simultaneously save the data in the local database that
would be available to all the users. This speed up the operation in the back office without putting any extra load on the
Front office.
Index Computation System
This is a real time system that calculate indices defined on the group of stock exchanges and then disseminates values to
multiple index monitors to display
• Price capture module: This module is responsible for getting the trade and currency values from NSE and Knight
Rider . This module is developed in VC++, socket
• Price Receive module : This module is responsible for getting trade and currency from PCM and calculate the
Index – Real time, online, Offline, currency Index . Then send Message to one more. This module is developed
in Pro*C, socket
Credit Rating Information Services of India Ltd . For S&P USA
Index Computation System This is real time systems that calculate the indices defined on a particular stock exchange and
then disseminates values to multiple index monitors to display.
• Responsible for the developing the Multiplex Module, which has a socket communication with the Aplha server
and multiple client application.
• I have used the windows socket functions extensively to transfer data from the server to the clients on real time
basis. I also used MFC collection classes for queuing the packets
M/s Bajaj Auto Ltd June 95 – June 96
Title - Section Manager
Its automobile company, I was serving as Section Manager in Production field. Responsible for 92 works production
and tool cost.
Education & Certification
• MS in Mechanical Engineering from Indian Institute of Science, Bangalore.
• BS in Mechanical Engineering from Walchand college of Engineering, Sangli.
• Unix Korn Shell Scripting by Brain Bench. Fundamentals of web services development by BEA.
• Oracle PL/SQL by Brain Bench. Oracle Certified Associate (OCA) & Oracle Certified Professional (OCP).
• Oracle University courses: Work Flow, Field Service, Oracle10g database, Warehouse Management (WMS).
• Completed training – OA framework, iProcurement, APEX, Apps DBA, SOA, AP,AR,GL
• ITIL Foundation (v3) certified.
Awards Received: Qwest Spirit of Service award and multiple Spirit LinQ awards & now highest ICE (Innovation Collaboration Excellence) award.