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**-*******
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.