Haresh Patel

Summary

Over **+ years of experience in Information Technology developing various business applications and implementation and maintenance support of complex systems

IT experience include analysis, design, development, implementation and testing of various client server applications using PowerBuilder, PFC, PL/SQL, core Java based technologies.

Application and Functional experience includes Credit Card Dispute, Credit Card Fraud, Retail Sales, Telecom Network Configuration, logistics and freight forwarding services, Commission system, Asset management And Order Processing.

Extensive experience and knowledge of working with multi-tier enterprise applications using various versions of Powerbuilder 5.0, 6.5, 8.0, 10.5, 11.0, 12.5

Extensive experience working with multi-tier environment where PowerBuilder Front End consumed SOAP/WSDL/XML based Webservices and Tuxedo services.

Good experience in Object Oriented Analysis and Design (OOAD).

Extensively used Object Oriented Techniques of PowerBuilder like Inheritance, Polymorphism and Encapsulation.

Designing standard Framework as per PowerBuilder Foundation class (PFC).

Strong working knowledge in configuration management and version control.

Worked on various version control systems like Start Team, Rational Team Concert (RTC), CM Synergy, Visual Source Safe, PB Native Version Control, Rational Clear Case

Strong exposure to SQL, PL/SQL programming and relational databases such as Oracle, Sybase ASE 12.5, MS SQL server 2008.

Bug fixing and debugging level experience in Core Java and C# .Net

Conversant with all phases of Software Development Life Cycle (SDLC), including requirement gathering, analysis, design, development, implementation, integration and testing

Good knowledge of SDLC Methodologies like Waterfall and Agile

Technical Depth - Resolving complex technical issues. Involved in coding of Powerbuilder, JAVA, components. Mentoring on best practices and processes. Ensuring quality, based on experience

Strong working knowledge in build process and release co-ordination

Have excellent customer communication and interpersonal skills with high level of adaptability.

Academic Qualifications

Master Of Computer Application (MCA) from Saurashtra University, India

Bachelor of Science (B.Sc) from Saurashtra university, India

Technical Summary

Business Domain

Credit Card Dispute, Credit Card Fraud, Retail Sales, Telecom Network Configuration, logistics and freight forwarding services, Commission system, Asset management And Order Processing,

Application

GUI Development, Maintenance and Production Support.

GUI Tools ( IDE)

Power Builder 5.0/6.5/7.0/8.0/10.5/11.5/12.5, (PFC), Eclipse, Toad, SSH Tectia.

Middle Tier

Tuxedo 8.0, Forte (iPlanet UDS 5.0 )

Internet Technologies

XML, Java Script, HTML

Database

Oracle 9i, MS SQL Server 2008, Sybase ASE 12.5, SQL Anywhere 6.0/8.0/11.0

Version Control Tools

Star Team, Rational Team Concert, CM Synergy, Visual Source Safe, PB Native Version Control

Operating System

Windows 7, Windows 2000, Windows XP, Unix

Professional Experience:

1.

Project Name

MSS (MACS Super Station), OMNI (Online Multi-Network Interface)

Client

Bank of America, Newark, Delaware, USA

Duration/Size

Apr 2007 – Till Date.

Description

MACS Super Station is the central GUI Case workflow system handling dispute cases originating through Mail, Telephone (TSS) and Internet (OLB). MSS is an Imaging system used to process customer correspondence. Mail Access Customer Satisfaction Super Station (MSS) employs a Comprehensive GUI that provides new functionality and seamless access to multiple systems and databases utilized by MACS representatives. This environment not only allows Bank of America to gain a competitive advantage, but also provides a marketing tool to gain new Affinity Groups. The systems and databases utilized by the MSS include Chargeback, Online Cardholder, Direct Send, Miscellaneous Fees, LVIS, and Disputes.

Online Multi-system Network Interface (OMNI) is a scalable, distributed application used to support various business functions such as account maintenance, fraud management, risk management, credit line management, authorizations and imaging. Its objective is to minimize the risk of loss to the bank by providing analysts with the tools for credit line management and for preventing and identifying fraud.

Environment

PowerBuilder 10.5/11.5/12.5, PFC, Oracle, Sybase ASE 12.5, MS SQL Server 2008 Tuxedo 8.0, C# .Net, IBM Websphere 7.5, Rational Team Concert ( RTC), Star Team Version Control, Windows 7.

Responsibility

Working as Subject Matter Expert for Bank of America Super Station Applications.

Discuss project requirements with Line of Business partners

Analysis of requirements for new development and enhancements projects.

Write technical design specifications both high level and low level design.

Develop complex aspects of code using Powerbuilder 12.5 modify OMNI and MSS credit card Superstation applications used to detect fraud, manage credit risk and process credit card claims.

Application development was done using Object Oriented techniques like inheritance, polymorphism and encapsulation

Writing database stored procedures, functions and triggers to implement business logic.

Provide guidance and technical assistance to Production support team to promptly address issues related to OMNI and MSS application production environment.

Respond to questions from internal security, compliance and audit groups on application behavior or technology usage

Write implementation plans for code deployment as part of a project release.

Developed and distributed Powerbuilder interface to consume Java webservices using SOAP/WSDL/XML.

2.

Project Name

RMS+ (Retail Management System)

Client

Sprint Nextel, Overland Park, Kansas, USA

Duration

Apr 2005 – Mar 2007

Description

RMS is a comprehensive software system developed for the Sprint PCS retail stores and affiliates to facilitate sale and activation of Sprint phones and services and accessories to the customers. Capabilities include Sales, activation, cancellation, return and exchanges of the Phones and accessories. Capabilities also include printing receipt, signature capture and allowing various Tender transactions including credit card processing, and gift card processing by interacting with third party vendor handling all the processing. The application includes two parts: Front Office and Back Office. Front office handles all the sales and interacts with a Java thin client interface to complete the activation of Services. Back office mainly includes all the administration tasks including setting up of data and security privileges

Environment

PowerBuilder 8.0/10.0, Oracle 8x/9x, SQL Server 2000, XML,Core JAVA, Rational Clear case, CM Synergy, Windows 2000, Windows XP

Role

Analysis of requirements for new development and enhancements.

Application development using PowerBuilder 8.0 with Object Oriented techniques using inheritance, polymorphism and encapsulation. Development also includes parsing XML file sent by the Java client and accessing the data from the file.

Creation of tables, views, indexes, sequences Writing Oracle stored Procedures, functions and triggers to implement business logic.

Unit testing and integration testing of the application.

Application support during business hours and on call off hours.

Documenting help for the modules developed.

Interacting with Business and System Analysts regarding various specifications of the modules including requirements, design of the module and any changes.

3.

Project Name

Poolaris

Client

Ericsson, Sweden.

Duration/Size

Dec 2003 – March 2005

Description

The POOLARIS system suite was developed following 2-tier client/server principles, with some functionality now migrated to intranet/web-based architecture.

VRIS(Value Resource Information System), ORIS, TRIS and FRIS run on a central Unix/Sybase SQL Anywhere database server, while BRIS runs on three Windows 2000/MS SQL Server 2000 servers on location in China. The clients have been developed with the Power Builder, Centura, Delphi and Omnis Studio tools.

All systems in the POOLARIS suite are connected via system interfaces, which are a key part in the POOLARIS concept. There are also a number of interfaces to external systems such as CBS and GOT.

Environment

Windows NT, Power Builder 6.5, Sybase SQL Anywhere 8.0, Omnis Studio, UNIX Sun Solaris

Role

Analysis of requirements for new development and enhancements projects.

Write technical design specifications both high level and low level design.

Application development using PowerBuilder 6.5 with Object Oriented techniques using inheritance, polymorphism and encapsulation. Development also includes parsing XML file sent by the Java client and accessing the data from the file.

Unit testing and integration testing of the application.

Application support during business hours and on call off hours.

Write implementation plans for code deployment as part of a project release.

4.

Project Name

Unified Freight System

Client

Kintetsu World Express, Japan.

Duration/Size

May 2003 – Dec 2003

Description

KWE is a world leader in providing complete logistics and freight forwarding services to its current and future customers. KWE, forwards its customers freight through various transport modes such as, Air, Ocean, Truck, Rail and Multimodal. KWE, has developed its Unified Systems such as Unified Freight System (UFS), Unified Warehouse system (UWS), Unified Accounting system (UAS) and Customer Service System (CSS) to provide up to date information about shipments to its internal users and customers. By gathering requirements from across the world KGIT has developed the core systems to meet KWE’s business needs. To meet the country specific needs such as local language, legal and business needs UFS has to modified/enhanced. These needs are identified by comparing UFS core application with those business operation needs specific to a country.

Environment

Windows NT, Oracle 8i (PL/SQL), PFC (Power builder 8.0), Forte (iPlanet UDS 5.0)

Role

Requirements gathering for new modules, requirement analysis and estimation.

Analysis of requirements for new development and enhancements.

Creating Functional/Technical Specification and Test case documents.

Version control of code and retrofitting code.

Quality assurance of code, creation of executables and deployment.

Documentation of new modules and enhancements.

Creation of user Manual, user training and support.

Task delegation to team members and tracking the task.

Technical and functional training of team members.

Resolution review before and after delivery provided by team.

Teleconference /meetings with client contact personnel.

Reporting to client on task progress and issue resolution.

5.

Project Name

SCA (Sales Credit Assignment), WWCS (World Wide Commission System)

Client

Cisco Systems (I) Pvt. Ltd. Bangalore

Duration/Size

April 2002 – April 2003.

Description

The SCA application/engine is a linking tool used to provide Cisco Sales with an engine to process both ERP and Point of Sales (POS) information received from Cisco distributors. Information contained in ERP and in the Worldwide Inventory Point of Sales System is automatically processed by the SCA engine

WWCS is the World Wide Commissions System. This system is used for entry of data, accepting the transfer of data files, transfer data from other application systems and produce payroll commission data. The main focus of this system is, to gather the data from other commission system and report out to payroll the employee/agent commissionable data.

Environment

Power Builder 6.0 With PFC, Oracle 8i, Adaptive Server Anywhere 6.0, Windows 7

Role

Requirements gathering for new modules, requirement analysis and estimation.

Analysis of requirements for new development and enhancements.

Creating Functional/Technical Specification and Test case documents.

Version control of code and retrofitting code.

Task delegation to team members and tracking the task

6.

Project Name

The Enterprise MPAC (Maintenance Planning And Control) system.

Client

Indus International, Inc.

Duration/Size

Dec 2001 – Apr 2002

Description

This project is a reengineering project, which covers the reusability of TSW functionality vis-à-vis extension of PFC framework. It includes architecture design of business layer comprising of services and templates for the development of EMPAC9.0 phase I.

This project captures the reusability of TSW class libraries at object level by

Mapping of TSW ‘classlib’ functionality to PFC classes

PFC Platform functionality required to support the new EMPAC application layout.

Environment

Windows NT, Power Builder 8.0 With PFC, Oracle 8.0

Role

Requirements gathering for new modules, requirement analysis and estimation.

Analysis of requirements for new development and enhancements.

Creating Functional/Technical Specification and Test case documents.

Version control of code and retrofitting code.

Unit testing and integration testing of the application.

Task delegation to team members and tracking the task

7.

Project Name

Order Processing and Export Documentation System

Client

Southern Sales And Services.

Description

‘Southern Sales And Services’ is one of the leading silk exporting companies catering to various clients in Europe and other Western countries.

The order-processing module performs operation such as performa invoice entry, maintenance of client, agent, designs of silk material, currency, bank, preparation of documents such as performa invoice, work order and generation of related MIS report.

The Shipment module performs operation such as receiving silk materials from the suppliers, maintenance of supplier details, preparing packing lists, allotment of boxes and generation of related MIS reports.

The Export & Documentation module prepares documents, which are required for exporting silk materials as for instance invoice, packing slip, cutting sheet, insurance certificate, bill of exchange etc.

The Report module generates management information system reports, which includes performa order details (Date Wise/ Client wise), Pending Order (Design wise /Date wise), Sales Details (Date wise/ Client wise/ Design wise), Outstanding Shipment (Client wise /Shipment wise) etc.

The Utility Module includes user management, which facilitates change of user, changing user ID, changing Password & changing rights, it also has facility for database backup, restoration and copying.

Duration/Size

Sep 2000 to Dec 2001.

Environment

Windows NT, Power Builder 7.0 With PFC, Oracle 8.0

Role

Requirements gathering for new modules, requirement analysis and estimation.

Analysis of requirements for new development and enhancements.

Creating Functional/Technical Specification and Test case documents.

Contact this candidate