Post Job Free
Sign in

Exstream Dialogue consultant/developer-->Looking for abroad jobs

Location:
Trivandrum, KL, 695581, India
Posted:
April 27, 2011

Contact this candidate

Resume:

SUMESH J CHACKALACKAL

• BE in Electronics & Communication

• Received "Macrosoft India Champion Award (Best employee)" award.

• Undergone training in Exstream Dialogue Chackalackal house,

Athirampuzha P.O,

Kottayam,

Kerala – 686562, India.

E-mail: **********@*****.***

Phone: +919**-*******

+914**-*******

Objective:

To work with a progressive organization to utilize my innovative knowledge and technical skills that enhances my professional growth.

Professional Experience: (5 Years 3 months)

UST Global (May 2010 -Till Date)

Technopark, Trivandrum, India.

http://www.ustri.com

Designation: Sr Software Engineer

UST Global headquartered in Aliso Viejo, California is a provider of IT services. UST Global® is a leading provider of end-to-end IT services and solutions for Global 1000 companies.

HSBC Software Development India (Nov 2009 –May 2010)

Pune, India.

http://www.hsbcglt.com/

Designation: Sr Software Engineer

HSBC Global Technology (GLT) is part of the HSBC Group - one of the world's largest financial service organizations. Headquartered in London, the HSBC group network is spread across 9,500 offices in 76 countries with a customer base of 125 million.

Macrosoft IT Solutions India Pvt. Ltd (Aug 2006 –Oct 2009)

Technopark, Trivandrum, India.

www.macrosoftindia.com

Designation: Software Engineer

Macrosoft IT Solutions India Pvt. Ltd, which provides technology and development support for Macrosoft Inc, USA (www.macrosoftinc.com) is a state-of-the-art information technology company based at Technopark, Trivandrum. Macrosoft Inc has been a true business partner for over a decade to many Fortune 500 companies as a leading provider of consulting services in software development and system integration.

Aryans Infoway (Jan 2006 –July 2006)

Technopark, Trivandrum, India.

Designation: Software Developer

Software Exposure:

Primary Skills : HP/Exstream Dialogue version 5.0/6.0

Operating system : Win 98, Win XP, Win 2000, Win 2003

Languages/Technologies : C, C#, Vb.net, Crystal Reports, Crystal Enterprise, Websphere MQ, XML, Endevor, JCL

Database : SQL Server 2000, Oracle 9i, Oracle 10g

Achievements and Certification:

Received "Macrosoft India Champion Award (Best employee)" award.

Microsoft Certified Professional in Developing and Implementing Windows based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET

Undergone training in Exstream Dialogue

Education:

B.E in Electronics & Communication Engineering from Madurai Kamaraj University, TamilNadu with an aggregate of 70%.

Diploma in Software Engineering with specialization in .Net (A TATA Enterprise)

Pre Degree Passed in first class with 69.4% from Mahatma Gandhi University in March 2000.

SSLC Passed in first class with 65.16% from Kerala State Education Board in March 1998.

Project Details:

“Letters/Statements in Healthcare Industry”

Client : WellPoint

Team Size : 10

Software Used : HP/Exstream Dialogue v 5.0/6.0,

Environment : Windows XP, Citrix

Description : WellPoint, Inc. which is the largest health benefits company in terms of commercial membership in the United States has its major part of customer correspondence via Letters/Statements generated via HP/Exstream Dialogue. The documents that spread over different categories such as Small/Large Group, Medicare, Member/Provider/Agency communications etc. are structured into a single Database scheme in Dialogue. Approximately 122 applications for 1300 Letters/Statements are in production. The Dialogue Engine runs in Mainframe system which provides the input data and takes out the AFP output generated which are delivered to Print Center via SteamWeaver for address cleansing. The documents are archived too via OnDemand for later use. Dialogue features such as templates, sections, messages, search keys, library components, functions/formulas, frames, automated tables, design layers, AFP/PDF queues etc are used for development.

“Bank Statements”

Client : HSBC

Team Size : 2

Software Used : Exstream Dialogue, Endevor, JCL

Environment : Windows 2000, Citrix

Description : This objective of this project is to compose the debit card statements for the HSBC Colombia. The three types of statements are cloned from the core product and implemented along with the local amendments. The Dialogue parent-child architecture is implemented in this project. The statements include Account, Composite and Loan statement. Marketing messages are also implemented as per the requirement. The Engine runs on mainframe and the data comes from AS 400 system. The outputs of AFP statements are delivered to print centre as well as the print reports.

“Document Automation”

Client : Comgraphics Inc., US

Team Size : Five

Software Used : Exstream Dialogue, vb.net

Database : Access

Environment : Windows XP

Description : This objective of this project is the rebuild of an existing dialogue application for the production of financial statements which would go for printing as postscript files and to web as pdf files. The legacy application had six application (in dialogue), which in turn reduced to single application. The input is a 2gb flat file, which holds account information of over one lakh customers. It is a two-pass process in dialogue. Several processing is done in vb.net in between the two-pass process. The very advantage of the application is that the end user sees only a vb.net exe, which eventually kicks off all the dialogue process, and the application ends up with several postscript and pdf files in specified folders and the whole process ends in almost 4 hours which was taking 12-14 hours previously. The output files are named(based on number of sheets) and splited dynamically using breakup tables in “Control” folder. Three sortindex files are used for the second pass, which in creates copies of account statements mailed to different addressees.

“Darstran Oracle Logminer”

Client : International Software Products, US

Team Size : Two

Software Used : C, vb.net, Websphere MQ, mono

Database : Oracle 9i, Oracle 10g, Oracle 11g RAC

Environment : Windows 2000, Linux, IBM AIX

Supported platforms : IBM Mainframes, AS 400, Unix, IBM AIX, LINUX, HP-UX versions 10 and 11 PA-RISC & Itanium, Sun Solaris Sparc, S-390 & Z-Series Mainframe (MVS), Windows 95 upwards

Description : This objective of Logminer is to capture Oracle transaction logs as sqls and replicate it to any RDBMS. This mining is automated by a C application, which triggers a procedure in oracle in a timely manner. The committed sql statements undergo transformation rules and send via Websphere MQ application to the client’s server. The SQLs are blocked as unit of work with an added header and the application transmits it to multiple target servers. Transformation to multiple database servers, like IDMS SQL, DB2 Mainframe, DB2 Non Mainframe, SQLSERVER, SYBASE, MYSQL and ORACLE can be done at the same time targeted to different remote servers via MQ. The application automatically resends from the last check point on a system restart or system/network failure. A local database replica is maintained to resend any missing blocks. The application code is standardized to compile and run any platform. A .net version was also developed which has minimum functionalities.

“BPrint”

Client : Bowne, US

Team Size : Two

Software Used : c#

Database : XML

Environment : Windows 2000

Description : This purpose of BPrint is to automate the process of mainframe applications. The BPrint runs as a windows service and watches for a trigger file on input directories of different clients. Once the input file is placed on to the input directory, the BPrint Service gets triggered by the trigger file. The BPrint service takes the input file and passes it through receive adapters and copies it into the input directory of shell script and invokes the shell. The shell generates output and reports, which in turn is again passed through send adapter of BPrint for final placement of output files and reports on to required servers. The whole process is done in a separate thread, so that multiple input files can be processed at same time. After the completion of input file, the environment files are compressed and stored for future references. All the mainframe and BPrint related settings are stored as xml files.

“Crystal Reports Automation”

Client : APS Healthcare, US

Team Size : Four

Software Used : Crystal Reports, Crystal Enterprise

Database : MS SQL 2000

Environment : Windows XP

Description : This objective of Crystal Reports Automation is to create PDF, excel or text reports in Crystal Reports and send these reports to specified clients in a Daily, Weekly, Monthly, Quarterly or Yearly basis. Since there are lots of Reports to be sent to clients, these Reports are set in Crystal Enterprise to be sending in Specified time. Our work includes making required changes in Stored Procedure while automating and finally automating. We work on live database in remote machines at client’s side.

Personal Profile:

Name : Sumesh J Chackalackal

Date of birth : 07-10-1981

Father’s name : Jose C Chackalackal

Sex : Male

Nationality : Indian

Passport No : G1249299

Languages Known : English, Malayalam, Tamil and Hindi.



Contact this candidate