Hari Chinnan
*** ************ ***, #*** *******, NJ -07002 C 713-***-**** ****.*******@*****.***
Expert Talend developer with 10 years of experience in software development.
SUMMARY OF QUALIFICATIONS
• B.E in Electronics and Communication Engineering from a reputed university in India.
• Expert in developing ETL and Integration modules in Talend and Java.
• Expert in Java, Spring, SQL Server, Oracle, MySQL, Netezza.
• Excellent communication skills. Expert in technical documentation.
• Experience in requirements gathering, product development through agile
methodologies, client project implementations, technical support, production support and
debugging.
TECHNICAL EXPERTISE
• Languages: Java, C#, JavaScript, SQL, C++, Python
• ETL Tools: Talend, Talend Server, Ab initio
• Scripting: Bash, Python, Powershell
• Frameworks: Spring, Hibernate, JBOSS Drools, ASP .NET
• Databases: Oracle, SQL Server, MYSQL
• Servers: Red Hat Linux EE, Windows Servers 2k-2008.
• Misc software: Eclipse, Maven, Visual Studio, Websphere, Tomcat, Hadoop, Pig
PROFESSIONAL EXPERIENCE
Client: Citigroup. New York, NY
05/2014 – Present
Integration Developer
Working on Citi AML end to end reconciliation project. Citi has a mandate to reconcile data flow to
Mantas AML and input data. Project uses Talend and Java to reconcile data feeds from product
processors across all Citi Businesses and Input feeds to Mantas AML software.
Technologies used: Talend Integration Studio, Talend Server, Java, Linux, Shell scripts, Oracle.
• Working on changes to recon framework based on PFG recommendations.
• Developed new business rules in Java to accommodate changes.
• Communicated solutions to source/ Functional teams.
• Coordinated defect fix releases.
• Improved memory utilization of Framework by incorporating memory efficient data
structures provided by third party library MapDB.
• Enhanced Parser Framework by using jregex to provide conditional regex support.
• Offered consultation on standardizing development process around using Talend
Administration Center and Source Control best practices.
Client: Fordham. Bronx, NY
01/2014 – 05/2014
Integration Developer
Worked with Fordham IT dept for creating an integration solution for integrating Banner ERP and
SugarCRM implementations. Designed and developed an integration solution using RabbitMQ
and Talend and Java.
Technologies used: Talend Integration Studio, Talend Server, Java, Linux, Shell scripts,
RabbitMQ, Oracle.
• Created deployment instructions for deploying Open Source RabbitMQ solution to local
servers with SSH setup.
• Developed SQL Stored procedures to retrieve data from Oracle.
• Developed Talend jobs to retrieve data using sprocs, convert to JSON and post to
RabbitMQ message queues.
• Worked with SugarCRM team to create consumers for RabbitMQ queues.
• Trained team on supporting RabbitMQ servers and Talend solution.
Client: Citigroup. New York, NY
02 /2013 – 01/2014
Integration Developer
Work with Citigroup’s Risk Management division on eRecon, a proofing system used in Risk
management. eRecon software is used by Proof Analysts in Citi to reconcile accounts with
outstanding balances in Netezza Data Warehouse.
Technologies used: Talend Integration Studio, Talend Server, Java, Linux, Shell scripts,
Websphere, Spring, Hibernate, Autosys, Oracle.
• Developed SQL queries for retrieving GL feed from Netezza. Used Talend to retrieve data
from Netezza to eRecon system.
• Setup Talend team development environment using Talend server, Talend integration
studio, Linux and SVN.
• Trained team on Talend, Architected, designed and developed Talend based ETL modules.
• Developed jobs to handle loading GL data from Data Warehouse to eRecon system,
Provide custom rules based roll up of data, Email Notifications using sendmail,
Freemarker templates etc.
• Talend was also used to develop realtime backend services for providing custom UI
features like download of filtered GL, Sub Ledger and other data, upload of reconciled
data in Excel etc via integrating with Front end through TIBCO.
• Coordinated with infrastructure team on provisioning hardware needed for the eRecon.
• Developed deployment architecture for Talend in a clustered environment based on
Autosys scheduler and Storage Area Network, TIBCO and websphere.
• Worked on a Proof of Concept project using Hadoop. Setup Hadoop Cluster. Used Talend
and Pig to perform rules based aggregation of GL Feed data that’s currently being done in
Oracle in PL/SQL.
Client: Infogroup. Burlington, MA
06 /2012 – 02/2013
Integration Developer
Infogroup is a data and marketing services company that provides products and services to
generate sales leads, find new customers, and develop direct mail, email and telemarketing
campaigns. Worked on technology upgradation project for Infogroup Marketzone Plus(MZP)
productline, a CASS certified platform that provides Address Cleansing using USPS Change of
Address feed.
Technologies used: Talend Integration Studio, Talend Server, Java, Linux, Shell scripts, MySQL,
Toad.
• Migrated ETL layer from Ab Initio to Java and Talend based solution.
• Developed new Talend jobs for client projects.
• Migrated middleware from using BSD sockets to ZeroMQ base sockets with a Java native client
for interconnecting with legacy C++ services.
• Build unit tests in Java, Talend Integration Studio and MySQL. Created MySQL scripts for data
comparison tests.
• Mentored fellow teammates on Talend.
• Presented project proposals to manager on Talend development.
• Worked on Proof of Concept project using Hadoop, HDFS, Pig and Hive for Market Zone Plus.
DATACERT, Houston, TX
12/2008 – 06/2012
Integration Developer
Datacert has two products Aims is an invoice management and e-billing system and is in .NET
and Passport, Case and Spend management system is in Java. Both products cater to legal
industry. My role involved working in both products and technologies.
Developed REST based XML webservice integration module using Java, Spring MVC, JAX-RS,
●
Talend ETL components that consume REST webservice in Java-JET.
Developed Integration modules in Talend
●
Developed UI customizations in HTML, JavaScript and Groovy and Grails
●
Developed Go-Live Data Loads in Talend
●
Developed SQL tables, Scripts, Stored procedures and Triggers for customizations in
●
Passport.
Primary Technical Consultant for Integration projects for Spectra Energy, Johnson Controls
●
and Illinois Tool Works Matter and Spend Management implementation.
Developed Aims application using Visual Studio, C#, ASP .NET, Microsoft SQL Server
●
Client: Microsolve, Portland, OR
07/2008 – 12/2008
Senior Software Engineer
Worked on Microsolve client project in Portland, OR. Developed Microsoft .NET based web
application for PacifiCorp a utility company in Oregon. Web application provides a portal for
PacifiCorp’s pole inspection vendors to submit pictures of electric poles for quality assessment.
Used Visual Studio, Microsoft .NET and SQL Server to design a web application hosted on IIS.
●
Datacert India, Chennai, India
08/2007 – 07/2008
Senior Software Developer
Worked on product development for Datacert.
Developed Enhancements to Integration Framework in C# between Aims and third party software
●
Migrated production environments to Windows Server 2008.
●
Mentored both offshore and onshore resources through code reviews, quality control checks.
●
Worked with marketing and clients on product management road map and other requirements
●
gathering activities.
Worked with Customer support to resolve product issues.
●
PHOTON INFOTECH, Chennai, India
02 / 2007 - 08 / 2007
Senior Software Engineer
Software Consultant for developing CRM solution for a large Swedish Language Education
Company. Developed public facing CRM website using ASP .NET, C#, NHibernate, Visual Studio,
and Microsoft Enterprise Library.
BROOKS SOFTWARE (NOW PART OF APPLIED MATERIALS), Chennai, India
08 /2004-02 /2007
Senior Software Engineer
Worked on multiple Brooks’ software products. Developed for FactoryWorks Semiconductor
Manufacturing Execution System, AutoMod Factory Floor Simulation Software, Cornerstone and
RS1 Statistical Analysis Software, iReticles, reticles (Semi-con factory hardware) management
system.
Designed custom Statistical Analysis Suite for Infineon in Cornerstone. Developed Windows UI
●
in VC++ and custom DSL.
Design and Develop iReticles, reticles management system in Java, Oracle. Developed UI
●
pages in HTML, CSS and JavaScript. ORM in Hibernate and Database scripts in Oracle.
Worked on Intel’s FactoryWorks custom solution. Developed distributed computing modules
●
working over UNIX pipes in C++ for FactoryWorks. Assisted QA in testing FactoryWorks on
Solaris/Linux platforms
EDUCATION
UNIVERSITY OF CALICUT
1998 - 2002
Bachelor of Technology (B.Tech.), Electronics and Communication Engineering