Oracle Retail - Pl/SQL, FORMS, REPORTS
Resume:
Karthikeyan Varadharajan Appleton, Wisconsin 54913.
Oracle Retail - RMS Mobile: +1-614-***-****
Techno-Functional Consultant E-mail:
acb10x@r.postjobfree.com
Professional Summary
. Around 13 years of IT experience and Over 5+ years experience in Oracle
Merchandise Operation Management (MOM) modules . Retail Merchandising
System (RMS/Retek), Retail Sales Audit (ReSA), Retail Price Management
(RPM), Store Inventory Management (SIM), Retail Invoice Matching (ReIM),
Allocation and Retail Integration Bus (RIB).
. Domain experience includes RETAIL, LOGISTICS and INSURANCE.
. Hands-on experience in Oracle SQL, PL/SQL, UNIX Shell scripting, Oracle
Forms 10g/Reports 10g, Open Interfaces and APIs Oracle RDBMS using Oracle
8i/9i, Oracle Forms 6/6i, Oracle Reports 6/6i, PL/SQL, Triggers,
Procedures, Functions, Packages.
. 5+ years of client facing experience in various countries USA, MEXICO,
UK, and MALAYSIA.
. 5+ yrs of experience in production support projects.
. Have experience in successfully working closely with the customers and
leading development and supporting applications in Onsite - Offshore
Model.
. Keen focus on Application DBA activity, performance tuning, testing, and
quality assurance.
. Wrote high performance queries/programs using Collections, Bulk Binds,
Objects, Nested tables, REF Cursors
. Developed Batch jobs using Pro*c and UNIX shell scripting.
. Performing SQL performance tuning using Explain plan, Trace files,
TKProf.
. Basic knowledge in HTML, JAVA, JSP and Servlet.
. Strong approach to maintain and tune Applications.
. Expert in data Migration, Export - Import, SQL *Loader,
. Expert using FTP, TOAD, SQL Navigator, SQL Developer tools.
. Adept at all stages of project lifecycle, from business requirements and
technical definitions to development, testing, user acceptance testing
(UAT), production support, and completion.
. Self-motivated, action oriented, result focused, articulate, decisive
individual, blends developed operational understanding with technical
expertise to lead a team in, direst circumstances, to success.
Education
. Bachelor of Engineering, Electronics and Communication, Madras University
(1995 - 1999).
Experience
. Mastech Inc, USA Senior Software Engineer
Dec, 2012 - Current
. Satyam Computer Services Ltd. Project Lead
May, 2003 - Nov, 2012
. Pentasoft Malaysia Sdn Bhd. Analyst Programmer
May, 2002 - May, 2003
. Kumaran System Pvt. Ltd. Programmer
July, 2000 - May, 2002
Achievements:
. Accredited with 'Pat on the back' award from Satyam for three times as
recognition for my consistent and meritorious performance across multiple
project.
. Won multiple customer accolades in Production Support role with GM, and
was recognized specifically for my successful efforts in managing highly
critical production issues. This includes special recognition for my role
in swiftly resolving a particular production break down issue with
potential to stop GM - Dealer interaction, by quickly coordinating with
all concerned external parties (AT&T and UPS) and fixing the technical
issue to put the application back on track in a short time.
Technical Skills
Operating Systems : MS-DOS, Windows NT/2000/XP, UNIX, Sun Solaris
8/10.
Languages : UNIX shell Scripts, Oracle SQL, PL/SQL, Pro*C,
Java,
Java Script, PSP (PL/SQL Server
Pages).
Databases : ORACLE 9i/10g, LDAP - Sun Java System Directory
Server.
GUI : FORMS 6i/9i/10g, REPORTS 6i/9i/10g, Visual
Basic 5.0.
Version Control : Tortoise SVN, Visual Source Safe & PVCS.
Web Related : HTML, DHTML, CSS, XML, SOAP and RMI.
Tools & Utilities : TOAD, SQL Developer, HP Quality Center,
COGNOS Server Side Administration,
Knowledge in INFORMATICA & LOAD RUNNER.
Application Server : Web logic 8.1.
Web Server : Knowledge on Iplanet.
Product/ Packages: Retek RMS 13, RPM 13, RIB, MS Office Products.
Clients
Client Role
Duration
. Mills Fleet Farm Production Support 12
Months
Appleton, Wisconsin
. Abercrombie & Fitch, Application Development & 51
Months
New Albany, Ohio. Production Support.
. General Motors, Production Support 17
Months
Warren, Michigan.
. Ford Motor Company, Production Support & 44 Months
Offshore and Application Development
Basildon, UK.
. Hong Leong Assurance, Application Development 12
Months
Petaling Jaya, Malaysia.
. Paquete Express, Application Development 22 Months
Offshore and
Los Mochis, Mexico.
Projects Profile
Retail MOM - Merchandise Operations Management - 13.0.7
Client : Mills Fleet Farm
Role : Oracle Retail Consultant
Organization : Mastech Inc / IBM USA
Duration : Dec 2012 - Till Date
Team Size : 10
Environment : RMS 13.0.7, RIB, RPM, Allocation, ReSA, ReIM, SIM, RPM &
RDW, Forms 10g, Reports 10g, PL/SQL, Pro*C, Oracle Exadata, & UNIX Shell
Scripts, ESB.
Project Description
Mills Fleet Farm is a privately held family business, founded in 1955 to
sell merchandise wholesale to farmers. They operate 34 stores, some as
large as 250,000 sq. ft. and 16 Convenience Stores in four upper Midwestern
states.
They have two offices; their Finance organization is located in
Brainerd, Minnesota, while Merchandising and Operations functions are
headquartered in Appleton, Wisconsin in conjunction with their only
warehouse
Project involved Application Maintenance and support of the Oracle retail
Merchandise Operations Management (MOM) applications 13.0.7 - RMS, RIB,
RPM, ReSA, ReIM, SIM & RDW.
Contribution
. Involved in working on AMS tickets. Retail Outstanding tickets reduced
from 57 in 2012 to only 4 in 2013, which is an improvement of 93%.
. Seamless resolution of batch failures by excellent coordination by
Philippines and India team
. Proactive Batch Monitoring, Batch Failure issue resolution and point
upgrade resulted in reduction of batch issues from 75 in 2012 to only 25
by end 2013, which is an improvement of 81%.
. Involved in the RMS, RPM & RIB upgrade impact analysis.
. Providing support for RIB using tools RDMT & RIHA.
. Created custom interface in RIB by modifying the XSD file and required
property files.
. Upgraded RMS & RPM 13.0.5 to 13.0.6, 13.0.7.
. Currently working on ORPOS 13.4 and ReSA 13.0.6 integration.
. System, Integration and UAT testing.
. Coordinate with the offshore team and get the development done.
RMS (Retail Merchandising System) - Cost Method Of Accounting
Client : Abercrombie and Fitch, USA
Role : Project Lead
Organization : Satyam Computer Services Limited, India
Duration : January 2012 - Till Date
Team Size : 10
Environment : RMS 13, Forms 10g, Reports 10g, PL/SQL, Pro*C, Oracle 10g,
Oracle 10g AS & UNIX Shell Scripts, ESB,
SOA.
Project Description
The project is for leading fashion retailer Abercrombie & Fitch
Co (ANF).
Abercrombie's request for the Cost Method of Accounting was driven in order
to better manage the business processes. The change to cost accounting will
improve Abercrombie's ability to gain visibility to financial margins;
track visibility of correlation between promotion and sales; and reduce
efforts currently in process related to the markdown of merchandise. Other
drivers of the business change include: IFRS potential replacement/merge
with US GAAP, statutory reporting requirements and timing of the
implementation of Just Enough (JE) planning system.
Currently under the retail method, Abercrombie recognizes a charge to
cost of goods sold based upon actual and estimated markdowns in the retail
selling prices for the season. With the cost accounting method there will
not be any reductions in retail selling price until merchandise is sold or
if Abercrombie expects to sell the merchandise below the original cost.
Contribution
As a Project lead, responsible for the
. Interacting with business user, to understand the Business requirement
and prepare the technical design document.
. Prepared an effort estimation chart for each higher-level requirement.
Calculated the effort in terms of PHs (Person Hours) required completing
each individual task.
. Managed resource planning of onsite and offshore teams.
. Design the conversion script for the cost method of accounting change.
. Performance improvement of the conversion process by multi threading to
complete the same in given window.
. Create one time Journal entry to people soft for the Cost adjustment in
RMS.
. Create functional test scripts.
. System, Integration and UAT testing.
. Coordinate with the offshore team and get the development done.
RMS (Retail Merchandising System)
Client : Abercrombie and Fitch, USA
Role : Technical Lead/ Onsite Co-ordinator
Organization : Satyam Computer Services Limited, India
Duration : May 2008 - December 2011
Team Size : 30
Environment : RMS 13, RIB, Forms 10g, Reports 10g, PL/SQL, Pro*C, Oracle
10g,
Oracle 10g AS & UNIX Shell Scripts, ESB,
SOA.
Project Description
The project is for leading fashion retailer Abercrombie & Fitch
Co(AnF) ., Project is to replace the company's aging COBOL applications
running on a mainframe with a modern Oracle platform for retail
merchandising systems (RMS 13 with AnF specific customization), store
systems and more. RMS project enables them to go into multiple countries.
Oracle Retail Merchandising System is a flexible, proven, and scalable
foundation from which to profitably and efficiently execute their core
merchandising activities, including inventory replenishment, purchasing,
and vendor management, in a global environment, across multiple retail
channels. The solution incorporates three functional areas: business
foundation management, merchandise management, and merchandise financial
tracking, allowing them to streamline their business systems and unify
business practices across their organization.
Contribution
As a Technical/Onsite Coordinate, responsible for
. The RMS modules - Purchase Order, PO Workroom, Inventory Management,
Stock Ledger, and Item reclassification.
. Interacting with business user, to understand the Business requirement
and prepare the technical design document.
. Involved in Initial Data Load (IDL) from Mainframe to RMS Application and
created numerous data validation scripts to validate after the IDL load
to make sure to check the data quality.
. Database design for ANF specific requirements.
. Modifying RIB packages for the interface changes with WMS, ESB.
. Develop and modify Pro*C and UNIX shell scripts for RMS daily/ weekly
stock ledger batch programs.
. Implement and Integrate of Oracle Webutil Functionality for uploading
excel data to RMS for bulk data processing.
. Develop custom Screens in Oracle Forms & Reports.
. Extensively used Oracle Stored Procedures, Functions, Packages and
Triggers, Views.
. Extensively Used Analytical Functions for the various complicated
business logics.
. Created hash partition for the custom RPM tables to improve the
performance
. Create functional test scripts.
. Maintained different versions of the source code through SVN
. Coordinate with the offshore team and get the development done.
. Involved in identifying and fixing the data integration issues between
the RMS modules.
GM- GSC09 Applications
Client : General Motors, USA
Role : Onsite Coordinator
Organization : Satyam Computer Services Limited, India
Duration : January 2007 - May 2008
Team Size : 8
Environment : UNIX, Solaris 8, Oracle9i/ 10g, Web logic 8.1, Shell
scripts,
C++, Java, Java script, HTML & DHTML
Project Description
The GM GSC09 is multi application support contract. In that I
was supporting 3 critical applications.
Part Rate Generator:
PRG computes Lean Capacity Rates (LCRs) for parts across programs,
based on Product Portfolio Content (PPC) penetration forecasts. The
application offers the flexibility to run various forecasts and calculate
LCRs to optimize purchasing decisions and cost savings. PRG is also used to
identify program content errors, including Vehicle Description Summary
(VDS) conflicts and range errors in penetration forecasts
Global Tire warranty Claims:
Global Tire Warranty & Claims is a system to collect and measure data on
why tires
are adjusted on all GM vehicles around the world. This system is common in
approach and global in scope and will provide an early warning for any
changes in performance related to tire adjustments. Additionally, by
design, this system facilitates an effort to improve the number of tires
being returned, under warranty, by GM Dealers to the tire manufacturers.
This improvement will result in additional credits (revenues) to GM for
replacement tires.
Global Part Description System Clone. :
GPDS clone is a database application running on Oracle database
server. It serves as a data hub for GPDS and E-Squared data and provides
the ability for applications to select GPDS and/or E-Squared data without
impacting the Production system. The GPDS Clone also serves as a staging
area for changed data from iMAN to GPDS and also has FAST and VPPS data for
adhoc reporting purposes. GPDS clone serves as a database server for the
COGNOS reports.
Contribution
As an Onsite Coordinator, responsible for
. Supporting Batch jobs running in UNIX.
. Modifying the UNIX Shell scripts and Oracle PL/SQL packages based the new
change requests.
. Identify methods to improve sustainability of the application.
. Identify methods to improve business process.
. Interacting with business user.
. Testing the application after server migration, patches.
. Fixing the production defects.
. Manage the Offshore team.
FDSE (Ford Direct Stock Exchange)
Client : Ford Motor Company, UK.
Role : Offshore Lead
Organization : Satyam Computer Services Limited, India
Duration : June 2004 - December 2006
Team Size : 5
Environment : UNIX, Oracle8i, PL/SQL server pages (PSP), Java script,
HTML,
DHTML & Shell scripts.
Project Description
This application, Ford direct stock Exchange (FDSE), Web Selling
is enabling Dealers to purchase premium used vehicles direct from Ford.
Provide dealers with the ability to purchase re-marketed vehicles through
various buying mechanisms and to provide Ford Motor Company with a method
of selling vehicles through various channels such as wholesale, bidding and
electronic auction. The application has interface with various systems
running in different platform. Application get data feed through batch
process from different application and similarly at the end of each day
data feed will be sent back to the respective system via batch process.
Contribution
As a Offshore leader, is responsible for
. Application DBA.
. Development of user interface for the application through, the back end
procedure & functions.
. Used SQL* loader to load data.
. Performed DBA activities like creating users, roles and granting and
revoking privileges.
. Fixed the production defects.
. Understanding and preparing Requirement specifications for the
enhancements.
. Code Review.
. Preparing quality documents.
PandA (Parts and Accessories)
Client : Ford Motor Company, Australia.
Role : Team Lead
Organization : Satyam Computer Services Limited, India
Duration : June 2003 - May 2004
Team Size : 6
Environment : Windows NT, Oracle8i, Developer 2000 (Forms 9i & Reports
9i) &
PL/SQL, VB Script & Iplanet.
Project Description
PANDA is the migration of existing PANDA application in Unisys
COBOL to forms 9i and Oracle 9i and also development of new programs PANDA
(Parts and Accessories), supports four major customer groups: Warehouse:
manages all aspects of material control - receiving, storage, order
processing, claims, intra-company shipments, packaging, junking, and cyclic
inventory. Supply: performs forecasting, procurement, and expediting.
Marketing and Sales: measures dealer performance against targets. Finance:
performs costing, accounting and pricing functions, billing through to
statements and receivables.
Contribution
As a team leader, was responsible for
. Accounting, Miscellaneous, Mazda Interface modules.
. Preparing Requirement specifications for the programs
. Testing - unit testing & integration testing
. Functional Testing
. Code Review
PENTAISF
Client : Hong leong Assurance, Malaysia.
WanaArtha Life, Indonesia.
Takaful Nasional, Malaysia.
Role : Module Lead
Organization : Pentasoft Malaysia Sdn. Bhd., Malaysia.
Duration : June 2002 - May 2003
Team Size : 6
Environment : Windows NT, Oracle8i, Developer 2000 (Forms 6i & Reports
6i) &
PL/SQL
Project Description
This system is developed to automate the Life Insurance operations.
This system contains the modules for registration and underwriting of the
policy holder as new business, the policy holders, plan, etc. information
capturing as masters, agency management, policy servicing, Reinsurance and
also claims, receipts, payments and general enquiry about the policy.
Contribution
As Insurance New Business & Claims module lead, was responsible for
. Analysis of the requirements provided by the clients.
. Identify the GAPS.
. Re design the database based on the GAPS identified.
. Prepare Program specification.
. Designed and developed Oracle Forms, Reports, stored procedures and
function.
. Created database triggers to implement business rules.
. Created required views and indexes and clusters to improve database
performance.
. Testing - unit testing & integration testing
. Played an active role in tuning the performance of both the application
and Database.
. Maintained different versions of the source code through PVCS.
SIPWEB
Client : Paquete Express, Mexico
Role : Team Member
Organization : Kumaran Systems Pvt. Ltd.
Duration : July 2000 - May 2002
Team Size : 18
Environment : UNIX, Oracle8i, Developer 2000 (Forms 6i & Reports 6i) &
PL/SQL.
Project Description
Paquete Express is a major logistics company in Mexico with a market
share of more than 60%. The project was partial re-development and partial
re-engineering whereby, Kumaran with its expertise in the Oracle platform
was asked by the clients for redesigning their existing system to be more
suited to current standards and technology.
In the process, one of the major refinement that was made was the database
set up was changed from a distributed to a centralized system. This is only
the second of its kind as far as redevelopment is concerned and the first
as far as redevelopment from Clipper to Oracle for Kumaran. The team
followed the whole SDLC process towards its approach to the project.
Contribution
As a team member, was responsible for
. Booking, Delivery & Admin modules development.
. Created the technical specification documents and developed the programs.
. Designed and developed complex Oracle Forms and Reports.
. Wrote Dynamic SQL, PL/SQL Procedures, Functions, Packages, and Triggers.
. Created Object Library and Property Classes.
. Prepared unit test cases, did unit testing, System testing, Integration
testing, and UAT with client.
. Implementation of the project at the Client site MEXICO.[pic]
Contact this candidate