Excellent consultant available immediately for your client.

Hi! Partners,

Good Morning. We have an excellent H1 consultant who is available
immediately for a project and open for relocation. He is comforatble
with the following positions e.g. Vignette Architect, System Analyst,
Business Analyst, Solution Designer, Solution Architect. please find
attached the resume of Mandar Redij for your consideration. Please go
through the resume and let me know if you have any position for the
consultant.

Availability: Immediate

Current Location: Newark, DE

Rate: $65-70/hr C2C


Here is the profile of the consultant

Mandar Redij

SUMMARY OF EXPERIENCE

· Over 13 years of professional IT experience in Software Development
Life Cycle. During this period performed various roles such as System
Analyst, Business Analyst, Technical lead / Architect and Solution
Designer and Project leader, Analyst programmer.
· Specialized in requirement analysis and web application design using
various technologies like Oracle, SQL Server, Vignette V7, Vignette V5,
V6, TCL, JAVA, XML, XSLT, Web Services etc. This includes design of
Database, Application and User interface layer. Also involved in
interface design for application integration using APIs, Web Services
and MQ Series.
· Domain experience includes Telecom, Retail, Hospitability,
Manufacturing, Finance, Banking and Insurance.
· Designed and implemented complex Application Integration Interface
for Telecom Billing at BT, UK.
· Functional experience Telecom Billing, Material Management, HR,
Finance, Engineering services and e-commerce applications including
Content Management, B2B and B2C applications.
· Over a year experience managing software pre-sales, proposals,
project scope, efforts and cost estimates, providing technical
solutions and initiating the project.
· Worked on internet, client/server and mainframe technologies.
· Sound knowledge of SOA, MVC and struts.
· Strong Analytical and Design, Problem solving skills.
· Excellent communications and inter-personal skills.


TECHNICAL SKILLS

O S : Windows 95/2003/XP/NT, DOS, MVS, LINUX,
UNIX, AIX.
Database : Oracle (7, 8i, 9i, 10g), SQL server 2003, IDMS,
DB2 and Access.
Programming Languages : PL/SQL, TCL, JAVA, XSLT, COBOL, JCL,
Easytrieve+, HTML, JavaScript and ABAP/4
Tools : Vignette Content Suite 7.3 (VCM, Dynamic Site,
VAP), VBIS, ER Win, VISIO, MS-Office, MS-
Project,
XMLSpy, TOAD, Pl/SQL Developer,
PowerBuilder and FoxPro.
Protocols : TCP/IP, HTTP, LDAP, SOAP
Application Interface : MQ Series & Web service using SOAP, XML,
CSV,TLV and Flat files
Application / Application Servers : BEA WebLogic Server 8.1, Tomcat,
Jboss


EDUCATION

Master of Computer Management, Poona University, India, June 1992.
Bachelor of Science, Poona University, India, June 1990.

Certification
Oracle Certification in SQL, Feb 2000


PROFESSIONAL EXPERIENCE

TCS JAN 06 - APR 06
Worked as a team member of E-business Practice & CoE (Centre of
Excellence). Practice division performs the pre-sales activities such
as building proposals and offerings, while CoE provides technical
support to projects and builds competency in related technologies.
Title: Team Member.

Responsibilities
· Responding to client's RFP and RFQs. This includes preparing
questionnaire to understand high level requirements. Providing
technical solution, software configuration and product evaluation.
· Creating Vignette Content Management (VCM)/ Portal (VAP) or vignette
V6 V7 upgrade Proposals which includes high level effort and cost
estimations and tentative project plan
· Supporting various projects for product compatibility, migration
etc. e.g. Web logic platform up gradation and oracle 8i to 9i for one
of the project.
· Standardising project documents which facilitates smooth execution
of project and QA
· Arranging training and knowledge sharing sessions to build vignette
content management competency in project team.

TCS
Client: Southern Sun Hotels, Johannesburg (South Africa) Jul'05 -
Dec 05
Project: SoutherSun.com
The business objective of Southern Sun Hotels (SSH) is to increase
hotel reservation on the web and reduce load on call centre. SSH is
rewriting the web site for re-branding and optimising of the site
performance and usability. As a part of this his project SSH has
decided to upgrade from existing Vignette V6.0 Content management
system to the Vignette V 7.3 CMS built on J2EE platform.

Title: Solution Architect

Responsibilities
· Analysing the existing Vignette V6 site and defining the scope for
improvement with help of stakeholders.
· Functional Requirements capturing for the web application liaising
with SSH Management, Call Centre, IT team and other software vendors.
This includes
ü Content Management and publishing various type of content
ü Email and SMS Notifications to subscribed users.
ü Content syndication required for content items like Local
Attractions, Weather, Maps and Currency calculator.
ü Integration with other application such as Reservation Hub (using
Java API with OTA XML protocol), Frequent Guest System (using Web
Services) and partner sites (using I-frames).
ü Requirement for Web analysis reports (using WebTrends) and
functional reports.
· Creating and getting the sign off for the System Requirement
Specification document
· Proposing software architecture for the new system.
· Estimating cost and effort for the project for given scope
· Creating and Getting sign off for the Technical Design Document
· Design the VCM application which includes complex CTD (contain type
definition), workflow, CMA extension like validation and preview
· Vignette Content Management and Content Delivery design (Dynamic
Site) that includes content type definitions, workflow, user set up,
site structure, templates etc.
· Database modelling using Erwin and, Creation of Database in SQL
Server2003.

Environment: Vignette VCM V7 (v7.3.0.1), Dynamic site (v 2.0.3),
Vignette V6, XML, XSLT, Web services, Java, JSP, SQL Server 2003. Web
logic Application server 8.1.
Client: Chen & Co, Seattle WA Dec'04 - June 05
Project: Saver Program Application
This is a web based Loyalty program application based on J2EE and
Oracle database. The key assets of the system are client and consumer
registration, transaction processing for awarding and redeeming loyalty
points, managing the web content and workflow for the content items.
Title: Database Architect

Responsibilities
· Understanding the system requirements and defining over all
application design.
· Detail design of the database for the application which includes
ü Defining the database standards and conventions.
ü Installing the oracle and creating database, users and roles
ü Creating logical and physical database model using Erwin.
ü Generating DDL script and creating the database objects (Tables,
views, indexes, constraints and sequences.)
ü Created database instances for development and testing for various
phases of the system.
ü Defining backup strategy
· Quality Assurance of Database
· Designed batch jobs for bulk data processing and various store
procedures used in the application.
· Provided technical solution and processing logic for critical
business function like streaming advertisements, user requests queuing
and processing, internal messaging.
· Defined workflows for various content items like Client web pages,
Product data, promotions, service requests, Messages, Communities news
and advertisements.
· Guided the team for functional understanding and applying technical
solution.

Environment: Oracle 9i, PL/SQL, ERWin, Java, JSP, Jboss Application
server, Struts.


Client: British Telecom, London UK Aug 02 - Nov 04

Project: Order Provisioning Billing Interface (OPBI on SPG),
BT whole sale a strategic decision to migrate wholesale billing system
from mainframe based OneBill system to open GENEVA Billing System.
Technical solution was required to transfer order processing data from
mainframe to oracle based Geneva billing system instantly when the
order is closed and CDR (call data records). Data mapping was required
for data coming from mainframe to map data as per XML schema provided
by Geneva. Existing application CHESS (based on IBM MQ) is used
receive order events and subsequent Web Service call is used to get
order data.
Title: Solution Designer

Responsibilities
· Analysing high-level requirements and providing alternative
solutions for implementing billing interface. This is based on
technologies to be used and the workflow to be followed.
· Capturing functional requirements for billing system leasing with BT
Wholesale Billing development teams, Customer Management Centres,
Process Managers and Wholesale Product Manager.
· Captured Technical requirements and created interfaces
specifications for web service, CHESS (MQ Series implementation) and
Geneva (GBSF) billing systems.
· Impact analysis on various systems (order provisioning and
processing applications and manual processes and suggesting necessary
changes. This Includes analysing each order processing scenario for
each product type (PSTN, ISDN and Broadband) and order type.
· Creating high level and low-level design for OPBI that includes,
Batch jobs, Job control process, Data model, Data load requirement,
Migration and Error resolution.
· Reviewed test plans and test cases to ensure completeness in terms
of requirement.
· Help the Delivery and release management to plan and release the
OPBI enhancements and thereby working closely with SPG and TCS Delivery
teams.
· Responsible for identifying and providing inputs to improve OPBI
system performance.

Environment: Oracle 9i, PL/SQL, Oracle web application server,
MQ-Series, Web Services, XML, XSLT, XMLSpy, Visio, ERWin, TOAD,
Mainframe, IDMS, CICS,


Client: World Bank, Washington DC. Sept'00 - Jan 01
Project: Transaction Reconciliation & Investigation System

The project aims at automating Reconciliation, Investigation and its
reporting modules. Reconciliation process reconciles ledger and
statements using rule engine built for it.
Investigation is a tracking system for the transactions. It's
functionality is creating and maintaining investigation details and
provides various robust GUIs that streamline the entire information
entry process. Project is based on MVS architecture using web based
JAVA application on front-end and Oracle database on back-end.

Title: System / Data Analyst

Responsibilities
· Designing the database using ERWIN. Generating scripts for table
creation, adding constraints, sequences, indexes, views and
materialized views. Materialized ware created to access remote database
efficiently.
· Writing stored procedures and triggers.
· Optimizing DML and writing stored procedures to ensure immediate
response to the front end. This has special significance due to the
substantial data volume and distributed nature of database.
· Providing SQL support for Java developers for creating database
objects.
Environment: Solaris 2.6, Oracle 8I, PL/SQL, JAVA (JSP, EJB, Servlets),
Web Sphere 3.5, Visual Age


Client: Arrow Electronics, New York, NY. Jul'00 - Jul 01
Project: Arrow.com Website.

Web site redesigned for arrow with improved performance,
personalization and customisation options to make more users friendly.
Existing site developed in Oracle web application server is replaced
with Vignette V/5. The key assets of the system are User registration,
Part search, Line card, Shopping Cart, Order maintenance, Arrow news.
New web site provides personalization and customization options to make
more user friendly. XML is used extensively for interaction with
application layer and database.

Title: Tech Lead
Responsibilities
· Interacting with client for requirement and design specification.
· Worked with technical architect for identifying technological
solutions and proof of concept.
· Responsible for requirements capturing and detailed design. High
level and low level design of CMA(Content Management Application) and
CDA(Content Delivery Application).
· Development of CMA for content entry and workflow. CDA development
for the business areas like User registration, Office locator & Line
cards, Site search, Part search and shopping cart. Used vignette tools
like observation manager for personalization.
· Co-ordinated development of Java tier (An Application layer between
CDA and Database) His role was limited to define and test the XML
interface.
· Upgrading Vignette V5 to V6 using tcl.

Environment: Vignette Story Server 5.0, vignette V6, TCL 8.2, Java
Script, HTML, Oracle 8i, Apache Web server 1.3.12 , Solaris, Web logic
server, EJB, and XML.


Client: Business News Publication Apr'00 - Jun' 00
Project: bnp.com Website.
The Project caters the publishing requirements of a Publishing house.
The business requirements featured existence of multiple magazines
under a particular industry segment with each magazine having a
periodic issue. Articles are created and associated to a particular
issue. Technical features incorporated in this site separate content
database from vignette system database.
Title: Analyst Programmer

Responsibilities
· Responsible for low level design of CMA.
· Defining Content workflow for article, images and issues.
· Identifying web pages and components requirement for CMA Which
include Creation of an Magazine, Creation of an Issue, Entry and
Updating of Content and Workflow Management.
· Defining workflow tasks for launching of periodic issues and the
expiring content related to that particular issue.
· Coding templates for internal site. Which include internal site
navigation templates and submitting images, associating images to body
copies.

Environment: Vignette Story Server 5.0, TCL 8.2, Java Script, HTML, SQL
Server 7.0, IIS Web server Windows NT 4.0


Client: Humana Insurance Nov'99 - Jan' 00
Project: Claim Reporting system.
This was maintenance and enhancement of Maternity claim reporting
system. This involved modifications to existing reports and developing
additional reports.
Title: systems specialist

Responsibilities
Activities Performed by him as a systems specialist includes analysing
Change Requests, co-ordinated detailed Design, Development and Testing.
Environment: IDMS DB/DC, ADSO, COBOL and JCL.


Client: Prudential Insurance (Roseland, NJ) Aug'98 - May' 99
Project: Prudential General ledger System.
This project objective was making prudential general ledger system
Y2Kcompliant and enhancement maintenance as per client specifications.
Title: Analyst Programmer

Responsibilities
· Y2K impact analysis of exiting code.
· Analysis of existing code for required modification due to
functional requirement.
· Modifications involved coding of ADSO dialogues, MAPs, Edit tables,
logical records using tools IDD, OLM, DMLO and OLQ.
· Coding necessary changes in COBOL IDMS DB/DC programs and Job JCL.
· Testing of converted code: Baseline, unit testing and system
testing.

Environment: IBM ES9000, DB2, MVS JCL, COBOL II, IDMS and ADSO


Client: Prudential Insurance (Valhalla, NY) Apr'98 - Aug' 98
Project: Prudential Resource Management System
This project objective was making prudential resource management system
Y2K compliant. System encompassed of 28 applications over 1800 ADSO
dialog and 700 IDMS DC and batch programs.
Title: Analyst Programmer
Responsibilities
· Y2K Impact analysis performed using customised editor SPF PRO
· Coding necessary changes in COBOL programs, JOB JCL, ADSO dialogs.
· Testing of converted code Baseline, Regression and Y2K.
· System testing of all applications.

Environment: IMVS JCL, COBOL II, IDMS BATCH, DC, ADS/O, VSAM


Client: Metro Dade County (County Govt., Miami FL) Nov'97 - Mar'
98
Project: Elderly Service Division system
Project objective was Y2K compliance conversion of the Elderly Services
Division system. The system assists the Division in maintaining
information on senior citizens, benefits due to them and benefits
availed of and also to produce funding reports. Project outsourced to
Data Core System Philadelphia, for Y2K Remediation.
Role: Analyst Programmer
Responsibilities
· Impact analysis performed manually by code review
· Database and work records modification to increase size of date/year
fields.
· Coding in COBOL programs, JOB JCL, ADSO dialogs and Maps, Edit
tables.
· Testing of converted code Baseline, Regression and Y2K.

Environment: MVS JCL, COBOL II, IDMS BATCH, ADS/O


Client: Norfolk Southern Inc. -Ronake, VA Dec'96 - Nov' 97
Project: Expenditure Accounting System
This project involved production support and system enhancements. Main
functional components of the system were Interline settlement, Bill
passing and accounts payable
Role: Analyst Programmer.
Responsibilities
· Analysis & documentation of existing system. Determining required
modification and enhancement needed as a result of introduction of new
business requirement.
· Modifications of ADSO dialogue, IDMS and DB2 programs as per
specifications.
· Preparation of test plans to satisfy all possible test cases needed
to ensure reliability of modification or enhancements before going to
production system.
· Testing and documentation of modified and new programs.
· Production support.
Environment: MVS JCL, TSO/ISPF, COBOL II, IDMS, ADS/O, DB2, Easytrive+
and FoxPro


Client/Employer: Usha Ispat Ltd (India)
Project: Material Management System Apr 94 to Dec 96
Material Management system was an integrated part of custom-built ERP
package for the steel plant in Redi. This system is divided into
subsystems based on functions like material procurement, storage and
inventory, Material costing, laboratory analysis and quality and
material disposition

Title: Sr. Systems Analyst

Responsibilities
· Requirement capture and documenting functional specification
· Designing database and layouts of input screens and reports
· Creating Test plans as per business requirements
· Integration with Financial Accounting system
· Successfully carried out the implementation of the system.
· Training users and creating operation manuals
Worked on computerization of various procurement functions such as
Processing Purchase requisitions, Floating inquiries or tenders,
Quotations and comparison statement, Placing orders follow-ups, Invoice
verification & Bill passing, Vendor Master & Quality Analysis and
Material rejections.
Also analysed and designed inventory management functions such as
Material Issue, Good Receipts and inspection of incoming goods,
Material disposition, Maintaining stock levels and generating Automatic
purchase requisitions, Inventory control - VED & ABC analysis,
Inventory costing by FIFO & Weighted average method.

Environment: Oracle 7, Power Builder 4, AIX (Unix), and Windows 3.11


Project: Sales & Dispatch System Apr 94 to Dec 96
Functionalities analysed and designed in this system - Maintaining
sales budgets and targets, Sales Order processing of dealers and direct
customers, Finish good inventory and warehouse management, despatch
schedule, invoicing, taxes and duties, account receivable and
settlements.
Title: Sr. Systems Analyst

Responsibilities
· Requirement capture and documenting functional specification
· Designing database and layouts of input screens and reports
· Integration with Financial Accounting system
· Creating Test plans as per business requirements
· Successfully carried out the implementation of the system.
· Training users and creating operation manuals
· Documentation as per ISO 9001 specs.

Environment: Oracle 7, Power Builder 4, AIX (Unix), and Windows 3.11


Project: Production Planning and information system. Apr 94 to Dec 96
This system includes Production Budget, Manpower requirement, BOM and
Costing
Environment: ORACLE 7.1, POWER BUILDER 4, AIX, and WINDOWS 3.1.


As a programmer worked on following applications Jan 93 to Apr94
As Analyst Programmer involved in analysis, development, testing and
implementation of several stand alone applications within this steel
manufacturing plant.

· Personnel & Payroll
· Purchase Management, Stores & inventory management,
· Projects tracking system.
· Land acquisition and payment information system,
· Production analysis system.
· Laboratory analysis system
· Marketing management system.


Environment: FoxPro 2.x, FoxBASE, DOS 5,6 and Novell NetWare 3.12.

Look forward to hear from you.

Best Regards
Deepak

ACS International Resources Inc.
Delaware Technology Park, 5 Innovation Way,
Newark, DE 19711 U.S.A.
Phone:914-509-6159 / 302-355-0638
Fax :302 372 8087
deepakp.DeleteThis@acslimited.com
www.acs-intl.com