Recruitment

USA MAP and Abbreviations

U.S.A
Time Zone
 State/Possession Abbreviation
ALABAMA AL
ALASKA AK
AMERICAN SAMOA AS
ARIZONA AZ
ARKANSAS AR
CALIFORNIA CA
COLORADO CO
CONNECTICUT CT
DELAWARE DE
DISTRICT OF COLUMBIA DC
FLORIDA FL
GEORGIA GA
HAWAII HI
IDAHO ID
ILLINOIS IL
INDIANA IN
IOWA IA
KANSAS KS
KENTUCKY KY
LOUISIANA LA
MAINE ME
MARSHALL ISLANDS MH
MARYLAND MD
MASSACHUSETTS MA
MICHIGAN MI
MINNESOTA MN
MISSISSIPPI MS
MISSOURI MO
MONTANA MT
NEBRASKA NE
NEVADA NV
NEW HAMPSHIRE NH
NEW JERSEY NJ
NEW MEXICO NM
NEW YORK NY
NORTH CAROLINA NC
NORTH DAKOTA ND
OHIO OH
OKLAHOMA OK
OREGON OR
PENNSYLVANIA PA
RHODE ISLAND RI
SOUTH CAROLINA SC
SOUTH DAKOTA SD
TENNESSEE TN
TEXAS TX
UTAH UT
WEST VIRGINIA WV
WISCONSIN WI
WYOMING WY
VERMONT VT
VIRGINIA VA
WASHINGTON WA
IMMIGRATION RULES AND VISA
 INS—IMMIGRATION AND NATURALIZATION SERVICE
The immigration and Naturalization Service (INS) was a part of the United States Department of Justice, which used to handle legal and illegal immigration and naturalization.

Most of its functions have now been divided into two Bureaus:-

U.S. Citizenship and Immigration Services (USCIS) - handling immigration processing and citizenship services. USCIS is responsible for processing different kind of Visas (H1B, L1, H4, F1, F2, B1, B2 with extension etc.) They are responsible for issuing Employment Authorization
Documents, granting Lawful Permanent Resident Status (getting your “Green Card”), and granting Citizenship.

Department of Homeland Security (DHS) – Assists USCIS in processing different Visas. Check the person’s authenticity with own database. Without Approval from DHS, USCIS is not able to issue any kind of visas. Handling border and enforcement activities of the INS.

To Enter in US three things required. (For H1b)


Passport with Visa

H1B Approval

I-94 Form

After arrival, Social Security No. Should be obtained from Social Security Department.
H1B- Work Visa (Work Authorization). Valid for 3 years extendable to another 3 yrs, total 6 yrs.
H4- DEPENDENT VISA (No work Authorization). For H1B Dependent. Valid for 3 yrs extendable to
another 3 yrs.
B1- Business Visa (No work Authorization). Valid for 6 months extendable to another six months,
total 1 yr.
B2- Visitors Visa (No work Authorization). Valid for 6 months and extendable to another 6 months.
L1- Intra-company transferee Managerial Visa. (Work Authorization). Valid for 5 yrs. L1 visa allows
companies operating both in the US and abroad to transfer certain classes of classes of employee
from its foreign operations to the USA operations for up to 7 years. The employee must have
worked for a subsidiary, parent, affiliate or branch offices of your US Company outside of the US
for at least one year out of the last three years.
L2- L1 dependent visa. Valid for 5 yrs. After 3 months they can apply for Employment
Authorization Document (EAD).
F1- Study Visa/Student Visa. Valid for 2 yrs. can be extended yearly till the completion of studies.
Work Authorization (EAD/OPT- Optional Permit KIND
DIFFERENT to Work).
OF VISAS
J1- Student Visa. Depend on level of study. Valid for 2 yrs can be extended yearly till the
completion of studies. Work Authorization
TN Visa- For CANADIAN Citizens. Depend on work time. Max 5 yrs.
Green Cards: Valid for 10 yrs. Work authorization. Employment based GC.
 Processes to get Employment based GC

Through RIR- Reduction in Recruitment

PERM: PERM is the new labor certification system that will allow
employers to file labor certifications (the pre-requite for most
employment based Green Cards) online. The employers will not
need to submit supporting documentation with the cases and
will instead retain the documents for inspection in case of an
audit.
 IRS- INTERNAL REVENUE
SERVICES
(Income tax department of
US)

If a person has annual salary - $90,000, following taxes he has to pay to government

Federal Tax - – 12-22%

State tax – 8%

Social Security – 10-15%

Medicine Tax – 5%

CA- SDI/SUI- 0.05% (only in California)

PS: If salaries of two persons are same and if one person has more no. of dependents as compare to second than first will pay less tax than second one.

# Social Security Tax- Paid by all including H1B but H1b can only avail the benefits after becoming a Green Card Holder. GC Holder can ask for remuneration from Social Security Department in case of being temporarily handicapped or permanent
handicapped, in case of pregnancy or in case of jobless.
Recruitment Process
 RECRUITING PROCESS FLOW

CLIENT

Finalized Resumes and Account/ Sales Manager

then submitted to Client (AM/SM/BDM)
with a brief summary of
Experience/ skills with
expected hourly rate or
annual salary

A.M Screens the

requirement and sends to
respective recruiters with a
A.M. then call up C.C. to Recruiting Head
consultants & screen
them on their
parameters and finalize
resume Resume Search
•DICE/Monster
•Sub Vendors
Finalized Resumes then (Broadcasting)
forwarded to Account •Own Database
Manager CC to •Hot List
Reporting Manager

Screening Based on
•Resume
•Telephone Interview (1)
(1). Technical Skills,
•Availability
Communications
•Rate Caps (2)
skills, experience
(2). Rate confirmation
from the Employer in
case of H1B from
consultant in case of
GC/citizen
 US TAX TERMS
1099
 End
Client

CAP/HCL/Wipro/TC Implementer

ACCOUNT MANAGER/RECRUITER Our Company

Employees 1099 Contractors Corp. To Corp. W-2 Contractors

H1B/ GC/ Citizen/ EAD/ GC/ Citizen/ EAD/ OPT/ Own H1B/ GC/ EAD/ GC/ Citizen/ EAD/ OPT/
TN TN OPT/ TN of another TN
Corp.

Offer Letter Contract b/w & Contract between Offer letter with W-2
Independent Contractor Corporation & other Hourly rate mentioned
(1099 Contract) Corp. (Corp. to Corp.
contract)

Salary Twice a month Invoicing Monthly Invoicing Monthly Twice a month Hourly
Payment terms- Net 30 Payment Net 30 days basis
days (30 net 30)

1-15th-22nd of month 1-30th-30th of next month 1-30th-30th of next month 1-15th-22nd of month
15-31st-7th of next month 15-31st-7th of next month

We deduct the taxes No Tax deduction. No Tax Deduction We deduct the taxes
Consultant himself pays
the taxes
TECHNICAL SKILLS
 Standard Hierarchy and Responsibilities in any organization

Delivery Manager

Client Management ,Budgets study, ensure the deadline ,communicating with

the clients

Practice Head

Managing the technology , to do the resource management , to track the

resource pool, resource plan.

Program Manager/Project manager

Managing multiple projects & team managers

Project Manager (PM)

More of management role and designing the projects(Architect is also in the

same level)
Team Lead (TL)

Team Management, Assessing the responsibilities, Distribution of work.

Senior Software Engineer (SSE)

Development and Critical work in the projects

Software Engineer(SE) (or) Jr. Developer

Completely in coding/programming and development

 Skill Set

JAVA FRONT END DEVELOPER: java Web Development with

AJAX, JSP and JSF / Struts
Devsphere develops robust and secure Java Web Applications,
using AJAX, XHTML, XML, DOM, CSS, JavaScript, JSP, JSF, JSTL,
Struts, Spring, Hibernate and EJB3.

1. VB Developer:
 Skill Set ….

4. VC++ Developer
Skill Set: VC++6.0, MFC, ATL, ODBC< Active-X
Development, DLL Development, Rational Rose, UML or
Booch Or Rambaugh object oriented methodology,
COM/DCOm or Corba (Visibroker/ Orbix), HTML/DHTML,
Javascript, Windows NT/95.
7. Oracle Back End Developer:
Skill Set: Oracle 8.0, Stored Procedures, Database Triggers,
Pro*C, PL/SQL, C/C++, Unix or NT (for consultsnts stronger in
back end development)

8. Progress Developer
Skill Set: Progress 8, MFG-PRO, Customization experience
required.
Skill Set….
9. VAX/VMS Developer:
Skill Set: VAX/VMS, DCL, FORTRAN or C, Lexical functions,
FDL, RMS, RDB or Oracle, DECFORMS, FMS, Indexed files.
 Skill Set…
10. MANMAN Developer
Skill Set: HP 3000, MPE/XL, Fortran or
COBOL, IMAGE, MANMAN or
12. QA TESTER:
Skill Set: Test Scripts, Test Plans, Test Cases, (Winrunner, Stress test using Loadrunner, Test Director, TSL) or SQA Suite (SQA Manager, SQA Robot, SQA Basic) or QA Partner and Silk, Black
box testing (where only functionality is tested), white box testing (where coding is also tested and the tester must know the development environment like language/operating system/database in
which application is developed), ISO 9001

13. ASIC Designer or ASIC Verification Engineer

Skill Set: ASICs Verilog XL for behavior modeling, synopsys tools for synthesis, cadence and Verilog tools for layout tools for layout designs, SPICE.(we are not looking for CAD/CAM designers)
14. Embedded Consultant:
Skill Set: RTOS (pSOS or VxWorks), C,
Assembly, Embedded systems
17. Oracle DBA-
Skill Set: Oracle DBA, SQL*DBA, SQL Loader, Export/Import, Backup and recovery, performance tuning, database sizing,database scripts, Application Tuning, SQL, SQL*Plus,
DetectI/O Problems, I/O tuning, UNIX resource consumption detecting and tuning, using SGA buffers to run SQL faster, Oracle 8 partitioning, Avoiding excessive rollback generation.
18. HP-UX Admin-
Skill Set: HP-UX Admin., Shell Scripts, HP overview, SAM, Awk, Grep, Cron, Any otherUnix utilities, web/e-mail servers.

19. SUN Solaris Admin:

Skill Set: Solaris Admin, Shell Scripts, Sun Net managaer tools, Awk, Grep, Cron, Any other Unix utilities, web/e-mail servers.
20. Windows NT Admin
Skill Set: Windows NT Admin, NT 4.0 server, DNS, TCP/IP,
PDC/BDC, Trusted domains, Proxy domains, Proxy Server,
Exchange Server, Exchange server, IIS web server, E-mail
server, RAS, DHCP,VPN, Routers
23.Lotus Notes Programmer
Skill Set: Lotus Notes R5, Domino, Lotus
Notes Script, Web application, Workflow,
E-mail server, Admin (Must be certified)
26. AS/400 Programmer
Skill Set: AS/400, ILE RPG/400, ILE COBOL/400, RPG/400, COBOL/400, DB2/400, OS/400, CL/400 (this is for a basic programmer either in RPG or COBOL)
OR
AS/400, ILE RPG/400, Cool 2/E (earlier called Synon 2/E), CL/400, O/400 (cool 2/E is a CASE tool to generate cade for either RPG or COBOL)
OR
AS/400, CL/400, RPG/400, COBOL/400, DB2/400, JD Edwards.

27. Mainframe Programmer/ Legacy System

Skill Set: IBM Mainframe VS COBOL II, MVS, XPor, DB2, and CICS
OR
IMS DB/Dc, COBOL< VS COBOL II
28. BAAN Consultant
Skill Set: BAAN (any module), Advanced BAAN tools,
Triton 4GL, Customization experience
Application Servers (J2EE)

BEA Web Logic

Cold Fusion
IBM Web sphere
Oracle Application server
IPlanet enterprise Server

Database Applications Development/ Administration

Oracle
DB2
SQL Server
Sybase

Development/ Analysis Tools

Visual Age
Visual Studio.Net
Jbuilder
OO Modeling Development
C/C++
Rational UML, Earwig
Commerce Server
ATG Dynamo
Broad Vision
IBM Commerce server
Blue Martini

CRM
Siebel
Salesforce
SAP
Oracle
Blue Martini
SalesLogix
Onyx
Pivotal
Clarify
Vantive/ PeopleSoft
CAI Platforms / CMS Servers
Webmethods
Tibco
Vitria
BEA Tuxedo

Embedded Systems

VxWorks
PSOS
J2ME

ERP
SAP; my SAP, SAP, BC, JCO, MiniApps, ITS
Peoplesoft
Baan
Oracle
JD Edwards

Java2
JSP, EJB,Servelts
CMS, JDBC, RMI, JFC, JNI
Java, JDK, Symantech Café
CLIENT SERVER
 CLIENT SERVER
Front End/Client Connection DataBase / Back end

VB
VC ++ ODBC Oracle
PB Sybase
D2k Sql Server
JDBC/ODBC
Java Informix

Boston – Marketing Training Material

 CLIENT SERVER CHART
Client Server Front End Special Tools Back End (DB resides on) Language Operating
Application (Client side – GUI) Developer (SP, db triggers) System/Platfor
DBA (Prod., Devel.) m

Oracle Developer 9i/ 6i SQL Loader, Designer Oracle 11g,10g,9i,8i,8.x,7.x PL/SQL UNIX or NT
(Forms 9i/6i Report 9i/6i) 2000, Oracle Application (Only Oracle)
Developer 6 Server(OAS)
(Forms 6 Report 6)
Developer 2000
Forms 5.0,4.5 Reports 3.0,2.5)
Visual Basic Visual Basic 6.0,5.0,4.0 ADO,RDO,OLE, SQL Server Transact -SQL NT
(Microsoft) ACTIVEX,COM, 2012,2008,2005,2000,7.0,6.x PL/SQL UNIX or NT
DCOM, Crystal Reports Oracle 11g,10g,9i,8i,8.x,7.x Transact –SQL UNIX or NT
Sybase 11.x,10.x,9.x UNIX or NT
Informix 11.x,10.x,9.x
PowerBuilder PowerBuilder 7.x,6.x,5.x,4.x PFC Sybase 11.x,10.x,9.x Transact -SQL UNIX or NT
(Sybase) SQL Server Transact –SQL NT
2012,2008,2005,2000,7.0,6.x PL/SQL UNIX or NT
Oracle 8i,8.x,7.x UNIX or NT
Informix 11.x,10.x,9.x
VC++ Visual C++ 6.0,5.0,4.0 MFC SQL Server 2000,7.0,6.x Transact -SQL NT
Oracle 11g,10g,9i,8i,8.x,7.x PL/SQL UNIX or NT
Sybase 11.x,10.x,9.x Transact –SQL UNIX or NT
Informix 11.x,10.x,9.x UNIX or NT
C++ C++ ATL,STL SQL Server Transact -SQL NT
2012,2008,2005,2000,7.0,6.x PL/SQL UNIX or NT
Oracle 11g,10g,9i,8i,8.x,7.x Transact –SQL UNIX or NT
Sybase 11.x,10.x,9.x UNIX or NT
Informix 11.x,10.x,9.x
Operating Systems Windows NT 4.0 / 2000, SCO Unix, Solaris 8 & 9, Windows 95/98, MS-DOS, Apple
Macintosh, Redhat Linux, SuSe Linux,HP-UX,AIX

Sun Java Technologies J2EE, JSP, Servlets, Java JDK 1.4, java-script 1.2, XML, Struts, WSAD, Tile, Hibernate,
Quartz,

Microsoft Technologies Visual Studio 6 & Visual Studio .NET, IIS 5.0, & 9,ASP

Oracle 11g,10g,9i,8i,8.x,7.x
Databases /SQL Server 2012,2008,2005,2000,7.0,6.x / MySQL, PostgreSQL
7.x,DB2,Ingres,Informix,MS Access, Sybase/IBM-DB2-UDB

Design Patterns ProtoType Pattern, Command Pattern, Factory Pattern, Builder Pattern, Immutable
Pattern and Singleton Patterns

EJB Design Patterns Session Façade, Domain Data Transfer Pattern, Custom Data Transfer Pattern, JDBC for
Reading, Business, Delegate Pattern and Service Locator Pattern

Development Tools IBM Visual Age for Java 3.02, Forte 4.0, Builder 8, and Together 6

Open Source Technology Red Hat Linux 7 & 8, Jakarta Tomcat 4, Apache web server, UNIX

Application Servers Jrun 3.1 Application Server, Jrun Cluster Server, Weblogic 8 Application Server, Oracle 9i
Application Server,websphere,weblogic,Sun One,

Security Systems Site Minder Policy Server 4.51, Site Minder Web Agent 4.51
 IIS Mail Server, Mail Enable Mail Server, Qmail & SendMail, TCP/IP networks
E-mail / Networking setup and
troubleshooting.

Firewall Check Point NG, Symantec,Mcafee

SCC( Supply Chain Collabration) i2 Commerce Suite( Negotiate, Projects,

SCM / ERP Catalog) ,i2
Trade Matrix 5.1.1, i2 Site Management, Oracle Application 10.7 /11i/R12 / Radical
2.0,BAAN,SAP,Peoplesoft,JD Edwards,Navision,Axapta,Great planes,Ramco
Marshal
Project Management Microsoft Project 2000, Rational Rose, Kintana(Mercury company)

Other Erwin 3.5.2, TOAD 7.3, IBM Distributed Debugger 3.02, JProbe, and JThreadLyser, and
tools CAML,Crystal Reports(Seagate)

EAI / Middleware Tibco,seebeyond,Vitria,Webmethods,Mercator,SAP XI,Tuxedo,

CRM Siebel,Clarify,SAP CRM,Oracle CRM,Peoplesoft CRM,Vantiv,

Data warehousing Informatica,Cognos,Business Objects,Hyperion,Datastage,Oracle DW,Abnitio,Erwin

Client Server Developer 2000 Forms 6i/4.5/5.0 & Reports 2.5 / 3.0 /PLSQL/Sql Loader/ Oracle WebDB
/ Jdeveloper/ Oracle Replication Server/Oracle Portal / Pro*C,

Storage Tool Veritas Volume Manager,EMC Storage, IBM Tivoli,SAN,NAS,Hitachi

Documentum,Interwoven Teamsite,IBM,sharepoint MOSS,OPENTEXT,SITECORE,ORACLE

Content Management Tool ECM

Mail Management Software IBM Lotus notes, Microsoft Outlook, MS Exchange server, Eudura,

Testing Tools Winrunner,Loadrunner,Test Director ,QTP, IBM Rational robot, Test Manager,Silk Test, Silk
Performer,

Markup Language HTML, DHTML, XML

DATABASE
 DATABASES INTRODUCTION

DATABASES VERSIONS OS
Oracle 11G,10G 9i,8i,8.x,7.x Unix or NT
Sybase 11.x,10.x,9.x Unix or NT
SQL Server 2012,2008,2005,2000 NT
,7.x,6.x
 Different types of Database
Administrator
DEVELOPMENT-DBA
PRODUCTION-DBA
Install Database
Performance Tuning
(Setup,Config)
Backup & Recovery
Design Database
Unix Admin/Scripting
Logical Design
On Call 24 X 7
(Erwin,Designer 2K)
Configuration
Physical Design
(Table,File structure)
Unix Admin/Scripting
Writing Stored Procedure
& Triggers

ERP - DBA
PeopleSoft DBA – Oracle/SQL Server/Informix
Oracle Apps DBA - Oracle
SAP Basis – Oracle/SQL Server/Informix
BUSINESS INTELLIGENCE
DATAWAREHOUSING
 BI

SAP – Business Intelligence Data Warehousing

SAP Business Warehouse(BW) Informatica - ETL
Basis Oracle Data Warehouse OWB - ETL,
Teradata, Brio,Abintio,IBM BDW,Datastage
SEM – SAP Strategic Enterprise Management
BPS – Business Planning
BCS – Business Consolidation REPORTING
CPM – Corporate Performance Monitor Cognos – ETL/Reports
BSC – Balanced Scorecard Microstrategies – ETL/Reports
BIC – Business Information Collection Business Objects – Reports
SRM – Stakeholder Relationship Discoverer – Reports)

Peoplesoft - EPM
 Business Intelligence : Oracle Data Warehousing

• Oracle Embedded Data Warehouse (EDW) – 4.1

 Purchasing Intelligence
 Financial Intelligence

Oracle Warehouse Builder (OWB) – 9.X, 10g,11g

 EDW Standard Repository
 Custom Repository

Oracle Discoverer – 3.x, 4.x, 9iDS

 Admin Edition
 Desktop Edition
 Plus Edition
 Viewer Edition
 BI - Contd

Commonly used Terminology in DW

Datamart
ETL (Extract Transform Loading)
OLAP (Online Application Programming)
Data Mining
Cube
Dimension
Powerplay
Reportnet
Impromptu
Fact table
Decision Support System (DSS)
 ERP
 ERP stands for Enterprise Resource Planning and it is a concept which has been around for more than two decades.

But what exactly is ERP? As Manufacturing Industries boomed around the world, one major challenge was how to organize and streamline the rapidly mounting
volumes of data. Manufacturing companies had various operations performed at various department levels, with data at each process critical to the other. There
needed to be a seamless integration in the flow of data across organization. This need was fulfilled by software applications that came to be known as ERP. Thus ERP is
an application which facilitates the capture, control and flow of information at each process level across the entire organization. The data is actually stored in an
underlying database controlled by the application.
 Enterprise Resource Planning(ERP)

MUST KNOW: SAP, Oracle Applications and Peoplesoft

VERSIONS
Modules names available in each

Distinguish between Functional and Technical consultants

Functional Terms – e.g.: Gap analysis, Blueprint, Setups, Configuration, Requirement gathering etc

Technical terms RICE (Reports, Interfaces, Conversions, Extensions) – Different in each ERP

SAP – ABAP, Sap scripts,BDC, Smart forms, EDI/IDOC, ALE, Dialog Programming etc
Oracle – PL/SQL, Forms Reports etc
Peoplesoft – Peoplecode, Peopletools, Panels, Pages, SQR, App Engine etc
ERP TECHNICAL CHART
PeopleSoft Oracle SAP

Language People Code PL/SQL ABAP/4

Report SQR/Crystal/nVision Reports / ABAP/4

Discoverer

Screens Panel Designer/Pages Forms Screen

Painter
ABAP/4
Interfaces SQR/App Engine PL/SQL BDC’s
 PeopleSoft
Financials, HRMS, Distribution, Manufacturing/Student
Version: 9.0,8.9, 8.8,8.5,8.4,8.0, 7.5,
7.0, 6.0, 5.0
HRMS Public or Financials Collaborative or Eapps Student Admin.(SA)
eBenefits *Student Admin
commercial *General Ledger
eCompensation
*Accounts Payable Academic Advisement
*Human Resources(HR) eCompensation Manager Desktop
*Accounts Receivable Advancement
*Base Benefits(BENEFITS) eDevelopment
Asset Management Campus Community
*Payroll eEquity
Billing Financial Aid
*Benefits Administration ePay
Project Costing Grants
Time and Labor eProfile
Budgets *Student Admissions
Pension Administration eProfile Manager Desktop
Expenses *Student Financials
Stock Administration eRecruit
Treasury *Student Records
Insurance eRecruit Manager Desktop
Recruit Workforce Treasury Management Employee Self-Service
FSA (Flex Spend Admin.) Risk Management Manager Self-Service

Distribution CRM Manufacturing

Purchasing Collaborative Selling Bills and Routings
Inventory Configuration Cost Management
Order Management Field Service DataBridge
Order Planning Help Desk Demand Planning
Product Config Marketing/Telemarketing Engineering
Remote Order Entry Order Capture Enterprise Planning
Billing Quality Production
Sales Management
Demand Planning
Support Production Planning
Enterprise Planning
Quality
 PeopleSoft Tools
Interfaces & Conversion
Tool: SQR’s 1) Reporting
2) Conversion
3) Interface Tool

People Code: The proprietary scripting language used in the development of PeopleSoft applications.

Development
People Tools: Administration
Reporting and Analysis

Panel Designer: Used for creating panels (screens) for user input

Tree Manager: Used for security and reporting.

Process Scheduler provides PeopleSoft applications with a user-configurable tool that

Process Scheduler: integrates with PeopleSoft panels, PeopleSoft security, and PeopleCode functions.
Through this integration, Process Scheduler enables users to request and monitor batch
processes related to their PeopleSoft application.
 PeopleSoft Tools

Application Designer: Using Application Designer to build, maintain, customize, and upgrade
PeopleSoft applications. We can use Panel, panel group and menu to
create application.

Data Mover: It allows you to import and export data across multiple
database platforms.
Data Management:
Import Manager: to import data into your PeopleSoft tables.

Mass Change: It use to create SQL processes which supplement your

application functionality.
 PeopleSoft Tools
Reports:
Used for complex reporting
SQR’s:

Crystal: Crystal Reports from Seagate software is a report formatter that helps you generate clear and easy-
to-read printed reports containing data from your PeopleSoft applications.

N vision PS/nVision enables you to retrieve information from your PeopleSoft database into a Microsoft Excel
(mainly spreadsheet—not merely as "raw" data, but as information in a form that helps you see the big picture,
financials): explore the details, and make decisions.

For defining database queries in an easy-to-use graphical environment. You create queries to extract the
Query: data you need from your PeopleSoft database.

Tree Manager to create and maintain trees. A tree is a PeopleSoft object that defines the
Tree Manager: groupings and hierarchical relationships between the values of a database field.

Cube Manager allows you to define and save templates for building and updating OLAP cubes. The
Cube Manager: Cube Manager provides all these benefits while achieving a nearly platform-independent solution -
the great majority of a cube's design attributes can be applied to either Arbor Essbase or Cognos
PowerPlay.
 Business Process:

Workflow: To automate the Business process without any human intervention.

Example Purchase Req, Purchase Order etc.,

Message To automate the process with 3rd party applications.

Agent:
SAP Business Objects Suite (BOBJ)
SAP Advanced Planner and Optimizer (APO)
SAP Analytics
SAP Apparel and Footwear Solution (AFS)
SAP Business Information Warehouse (BW)
SAP Business Intelligence (BI)
SAP Catalog Content Management (CCM)
SAP Enterprise Buyer Professional (EBP)
SAP Enterprise Learning
SAP Portal (EP)
SAP Exchange Infrastructure (XI) (From release 7.0 onwards, SAP XI has
been renamed as SAP Process Integration (SAP PI))
Governance, Risk and Compliance (GRC)
Enterprise central Component (ECC)
SAP Human Resource Management Systems (HRMS)
SAP InternetSAP Modules Server (ITS)
Transaction
SAP Incentive and Commission Management (ICM)
SAP Knowledge Warehouse (KW)
SAP Manufacturing
SAP Master Data Management (MDM)
SAP Service and Asset Management
SAP Solutions for mobile business
SAP Solution Composer
 SAP Practice

Strategic Alliances with SAP

q MYSAP.COM Partner

q SAP National Implementation Partner

q ASAP Partner

q Provide consulting expertise and resources to SAP on several

projects

q Currently involved in joint project bids with SAP

q We have SAP in-house

 Methodology
Step by Step approach
PHASE MAJOR DELIVERABLES PHASE AVG

Project Project Planning, Procedures, 1 Month Avg

Prep Technical Requirements, Kickoff

Business Team Training, Develop System 1–3 Month Avg

Blueprint Environment, Business Process Design

Realization Configuration, Develop System 2-6 Month Avg

Management, Technical Builds,
Reports, Authorizations,
Documentation, Testing

Final Prep End-user training, System 1-2 Month Avg

management, cutover
planning/implementation

Go-Live Go-live, Productive system support 1 Month Avg

SAP TECHNOLOGY PRACTICE

SAP TECHNOLOGY
PRACTICE

ABAP/ 4 BASIS BW ALE/ EDI W ORKFLOW R/ 3 VERSION SOLUTION

eCOM M ERCE UPGRADES CENTER
 SAP TECHNOLOGY BASIS PRACTICE
Version: 4.7, 4.6C,4.6,4.5,4.0,3.1H

S AP TECHNOLOGY
B AS IS P RACTICE

S AP RDB M S OP ERATING HARDW ARE

ADM INIS TRATION S YS TEM AP P LICATION

C AP AC ITY P LANING ORACLE NT IB M

P ERF. TUNING INFORM IX AIX UNIX HP

S AP S EC URITY S QLS ERVER HP UX C OM P AQ

TM S DB 2 DEC UNIX DIGITAL

TECH. ARCH. S OLARIS S UN

INS T./ UP GRADES OS / 3 9 0 DELL

 SAP Application modules
Sales and Distribution Financial Accounting
Materials Management Controlling
Production Planning Asset Management
SD FI
MM R/3 CO
PP AM
Client Server
ABAP/4
QM PS
PM WF
HR IS
Quality Management Project System
Plant Maintenance Work Flow
Human Resources Industry Solutions

: 3
 SAP MODULES
Financial Accounting(FI) Controlling(CO) Asset Management(AM)
General Ledger Cost center accounting Depreciation
Accounts Receivable Project Accounting Sales of assets
Special Purpose Ledger Profitability analysis Maintenance value
Accounting Information System Activity based accounting Inventory
Accounts Payable Job order accounting Replacements
Treasury Product costing accounting Investment Management
Legal Consolidation Profit center accounting Repair value
Enterprise controlling Ownership

Project Systems (PS)

Funds and resource management
Time Management
Quality control
Project Management
Information System
 SAP MODULES

Plant Maintenance (PM) Quality Management(QM)

Processing of unplanned tasks Quality inspection
Maintenance planning Quality management information system
Maintenance bills of materials Quality planning
Service management
Maintenance notification
By date or counters Production Planning(PP)
Sales and operations planning (SOP)
Master production scheduling (MPS)
Product costing
Kanban
Routings
Production orders
Repetitive manufacturing
Make to order
Shop floor control (SFC)
Activity based costing
Process manufacturing
 SAP MODULES
Materials Management (MM) Sales and Distribution (SD)
Material procurement Pre-sales support
Reorder point processing Quotation processing
Material valuation Sales order processing
External service management Delivery processing
Inventory management Inquiry processing
Invoice verification Contract management
Vendor valuation Pricing conditions
Billing
 SAP HCM –
Human Capital Management

Human Resources (HR)

Payroll (US and International)
Travel expense accounting
Recruitment
Workforce planning
Organization management
Time Management
Benefits Management
Personal Administration
Training Administration
Personnel Planning
Oracle Apps
Oracle E-Business Suite
Oracle Corporation markets its home-grown
software applications, including Oracle Financials,
Oracle HRMS, Oracle CRM etc. as parts of the
"Oracle E-Business Suite". The following enterprise
Supply Chain Management
Supply Chain Planning
Logistics & Transportation Management
Order Management
Price Management
Manufacturing
Oracle Financial Applications
The Oracle E-Business Suite provides an extensive set of financial
applications used extensively in businesses around the world. Oracle
Corporation groups these applications into "suites", which it defines as
sets of common, integrated applications designed to execute specific
business processes.
The Oracle Financials application-set relies on the Oracle RDBMS
infrastructure and includes applications such as:
Oracle Assets
Oracle General Ledger
Oracle Payables
Oracle Receivables
Oracle Cash Management
Oracle Projects Applications
The Oracle E-Business Suite family of
Oracle Projects applications supports the
full lifecycle of project and portfolio
management with a single, accurate view
of all project-related activities. Industry
Oracle Inventory
Oracle Integrated Receiving (Brazil localization)
Oracle MRP
Oracle Order Entry
Oracle Order Fulfillment (order to cash process)
Oracle Payroll
Oracle Purchasing
Oracle Receivables
Oracle TMS (Transportation/G-Log)
Oracle Work in Process.
Oracle Process manufacturing.
Oracle Federal Administration
Commercial, non-profit and public sector entities use these
applications to run many of the world’s mission-critical
processes. Oracle Corporation makes the software available on
various hardware platforms.
 Oracle E- Business (Advanced)
Versions: 11i (11.5.10), 11.03, 11.0NCA, 10.7 Character, SC (smart client),NCA
GUI: Developer 2000, Forms 4.5, Repots 2.5 (Version: 11.0.3,11.0,NCA,SC)
Developer 6i, Forms 6i, Reports 6i (Version: 11i)
Database – Oracle 8i, Oracle 9i,10G,11G
E- Business
CRM Manufacturing Distribution Financials Procurement HR I- Store Self Service BIS (Business
Intelligent Systems)

Discrete Process (GEMMS)

Flow OE/OM Purchasing/
(Advance Iprocurement(SSP) Financials
Pricing/Shi Self Service Purchasing Sales
MRP (material resource Planning) Customer
pping)
MPS Procurement
Inventory
WIP (work in progress) HRMS
PO
BOM (bill of materials) Payroll
INV (Inventory) Benefits i store
ENG (engineering) Oracle Advance i payment
QM (quality management) Benefits(OAB) i marketing
Cost Mgt. Training Administration i support
OE (order entry) GL (general ledger) Self Service Employee
PUR (purchasing) AP (accounts payable SS Time
AR (accounts receivable) SS Expenses
FA fixed assets) SS Purchasing
CM (cash management) SS HRMS
Treasury
ORACLE PLANNING
Property
Oracle APS – ASCP, ODP, GATP
Oracle Projects/Project
APS – Advance Planning&Scheduling
Accounting
ASCP – Advance Supply Chain planning
Project Costing
ODP – Oracle Demand Planning
Project Billing
GATP – Global Available to Promise
 Oracle CRM E-Business Suite
Analytical Customer Intelligence
Applications
Marketing Intelligence Sales Intelligence Call center Intelligence

Business Sales Field Depot

Marketing iStore Online TeleSales iSupport Contracts Scheduler
Applications Service Repair
Partner
(PRM)
Mobile
iPay Field Sales Customer Spares Service
iMarketing MES Sales Comp Support
Field
Mgt Contracts
Collections
Service
CRM
Foundation Universal Work Queue Resources Territories Assignment Engine

Interaction Tasks Notes Calendar 1-on-1 Fulfillment

Channels
MES Interaction History Interaction Blending Order Capture

E-Business Call Center

Foundation Telephony Manager
Email Center Web Mobile
Scripting
Predictive Dialer

Common Application Architecture & Schema

E-Business
Platform eBusiness Platform

08/26/2025 74
Microsoft

Microsoft Dynamics ERP is an enterprise

resource planning application primarily
geared toward midsize organizations as well
as subsidiaries and divisions of larger
organizations. Microsoft Dynamics ERP
includes four primary products:
Software Testing

Software testing is an investigation

conducted to provide stakeholders with
information about the quality of the product
or service under test.Software Testing also
provides an objective, independent view of
the software to allow the business to
Testing methods

The box approach

Software testing methods are traditionally divided into black box testing and white box
testing. These two approaches are used to describe the point of view that a test
engineer takes when designing test cases.
Black box testing
Black box testing treats the software as a "black box"—without any knowledge of
internal implementation. Black box testing methods include: equivalence partitioning,
boundary value analysis, all-pairs testing, fuzz testing, model-based testing,
traceability matrix, exploratory testing and specification-based testing.

Advantages and disadvantages: The black box tester has no "bonds" with the
code, and a tester's perception is very simple: a code must have bugs. Using the
principle, "Ask and you shall receive," black box testers find bugs where
programmers do not. But, on the other hand, black box testing has been said to
be "like a walk in a dark labyrinth without a flashlight," because the tester doesn't
know how the software being tested was actually constructed. As a result, there
are situations when (1) a tester writes many test cases to check something that
could have been tested by only one test case, and/or (2) some parts of the back-
end are not tested at all.
White box testing
White box testing is when the tester has access to the internal data structures
and algorithms including the code that implement these.
Types of white box testing
The following types of white box testing exist:
API testing (application programming interface) - Testing of the application using
Public and Private APIs
Code coverage - creating tests to satisfy some criteria of code coverage (e.g., the
test designer can create tests to cause all statements in the program to be
executed at least once)
Fault injection methods - improving the coverage of a test by introducing faults
to test code paths
Mutation testing methods
Static testing - White box testing includes all static testing
Grey box testing (American spelling: Gray
box testing) involves having access to internal
data structures and algorithms for purposes of
designing the test cases, but testing at the user,
or black-box level. Manipulating input data and
formatting output do not qualify as grey box,
because the input and output are clearly
Automated testing
Many programming groups are relying more and more on automated
testing, especially groups that use Test-driven development. There are
many frameworks to write tests in, and Continuous Integration software
will run tests automatically every time code is checked into a version
control system.
While automation cannot reproduce everything that a human can do
(and all the strange ways they think of doing it), it can be very useful for
regression testing. However, it does require a well-developed test suite
of testing scripts in order to be truly useful.
Testing Tools
Program testing and fault detection can be aided significantly by testing
tools and debuggers. Testing/debug tools include features such as:
Program monitors, permitting full or partial monitoring of program code
including:
Formatted dump or Symbolic debugging, tools allowing inspection of
program variables on error or at chosen points
Automated functional GUI testing tools are used to repeat system-level
tests through the GUI
Tool Name Company Name Latest Version
HP QuickTest Professional HP 10.5
IBM Rational Functional Tester IBM 8.1
Rational robot IBM 2001
Selenium OpenSource Tool 1.0.1
SilkTest Microfocus 2009
TestComplete Automated QA 7.52
TestPartner Micro Focus 6.3
WATIR Open Source Tool 1.6.5
Testing Levels

Unit Testing
Integration Testing
System Testing
ETL TOOLS

Embarcadero
DT/Studio Technologies
DataStage IBM

Ab Initio Software
Ab Initio Corporation
Data Junction Pervasive Software
Oracle Warehouse Builder Oracle Corporation
Microsoft SQL Server Integration Microsoft
SAP BW SAP
Transformation Manager ETL Solutions
 EAI Platform
SIF (Schools Interoperability Framework)
Data Integration
Enterprise Integration Patterns
Enterprise Service Bus
OSS through Java Initiative
Open Knowledge Initiative (using SOA for application integration)
SAP Exchange Infrastructure
Health Level 7
Comparison of business integration software
TIBCO
Microsoft BizTalk Server
IBM WebSphere Message Broker
WebMethods
Oracle BPEL Process Manager
E BUSINESS
 E-Business

Microsoft Sun Others

Web Application/Web Services: JAVA Java Script
NET Framework Servlet HTML
C# (C Sharp) JSP DHTML
ASP/ASP.NE J2EE CGI Perl
Visual Basic (VB/VB.NET) Java Beans Cold Fusion
Visual C++ (VC/VC.NET) EJB XML
J# (J Sharp) Swing WML
.Net Compact Framework RMI
ADO/ADO.NET JMS
Internet Information Server (IIS) Swing Web Server
Struts/Struts CX Internet Information Server (IIS)
Java Web Server
Apache Web Server
iPlanet
Application Server IIS
Silver Stream SunOne
Weblogic Tomcat
Netscape Application Server Pramati
IBM – Websphere - Visual Age for Java JBoss
WebSphere Application Server Oracle AS/ OC4J
WSAD Interstage Application Server (Fujitsu)
Websphere Business Integrator JRun
Oracle Application Server
 Internet / Intranet APP

DATABASE WEB SERVER

APPLICATION SERVER
IIS (ASP)
Oracle J O HTML
Silverstream Java Web
Sybase Server JAVA SRIPTS
D D Weblogic and/or
Sql Server Apache Web VB SCRIPTS
B B NAS
Informix Server APPLETS
Websphere “IBM”
C C iPlanet ACTIVE X
XML
Site Server CE IIS

JAVA /JAVA SCRIPTS/ JSP/ JAVA- SERVLETS/ ASP/ EJB/

COM-DCOM / COBRA,RMI
CLIENT/BROWSER
LEGACY MANAGEMENT PRACTICE
 Introduction of Legacy Practice

What are legacy systems?

 IBM Mainframes in the high-range and AS/400, Unix in the mid-range systems
 Developed 2-3 decades ago
 Poorly documented, expensive to maintain and yet extremely fast and robust!
 Used by most banks, insurance companies, manufacturing, automotive, power/ utilities and
retail clients
 What are Legacy Systems?

Mainframes
Relatively large computers built to handle very large databases, thousands of user terminals with fast
response times, and millions of transactions
Used mainly by
Large companies for mission critical applications and bulk data processing
e.g. Banking and Insurance (Mellon Bank, Allstate), Retail (Wesco, Les Schwab, Lowe’s), Healthcare (Kaiser
Permanente, Harrington Benefit Services), Automotive (Blue Bird, Goodyear), Telecommunications (Alltel)
Government organizations (e.g. Ohio Dept. of Taxation)
Mid Range Systems
Application System 400 (AS/400)
Middleware
Technologies used to connect Legacy to Open Systems (Microsoft/ Sun technologies)
 IBM MQ Series
 TIBCO
 Skills – Mainframe
Combinations :
– COBOL, CICS, VSAM, JCL
– COBOL, CICS, DB2, JCL
– COBOL, IMS DB/DC, JCL
COBOL – VS COBOL II, MF COBOL, AcuCOBOL
Database Management Systems (DBMS)
 IMS DB/DC – an older hierarchical DBMS (Info Mgmt System – DB is the database component and DC is online
screens) – very complex logic, used from within COBOL programs
 IDMS – an older network DBMS – also very complex
 DB2 – a Relational DBMS like Oracle
VSAM (Virtual Storage access method) is a file based system – used for data storage and access…which is now done
by a DBMS
JCL (Job Control Language)
Tools
 Version Control: Changeman, Endevor, CA-Panvalet
 Debugging: Xpeditor
 Tool-writing: Rexx, CLIST
Environment
 MVS or Z/OS – OS; TSO (Time Sharing Option), ISPF (Interactive System Productivity Facility) – Development
Environments
 Skills – AS/400

Languages:
 RPG, RPGLE – different versions (COBOL programmers can usually learn this very fast)
 COBOL, C, C++, Java etc. also work on AS/400

Operating System:
 OS/400

Control Language:
 CL/400 – similar to batch programming on DOS and JCL on mainframe

Development Tools:
 PDM (Programming Development Manager), SEU (Source Entry Utility – the editor for PDM), DFU (Database
File Utility – similar to SPUFI for DB2), SDA (Screen Design Aid), RLU (Report Layout Utility), QUERY/400
 Signon / Synon / 2E- An integrated development environment to develop COBOL and RPG code for AS/400s
Database:
 DB2/400 – IBM DB2, but operates on OS/400 – Knowledge of SQL