"Life is all about connecting dots backwards, have the courage to follow your heart and intuition. They somehow already know what you truly want to become " - Jobs,Steve
Summary :
* Hadoop ecosystem expertise ( MapReduce/HBase/HDFS/). Data Analysis using Pig.
* 1 year of experience in solving Big data problems using Hadoop, MR , Pig, Java
* Strong framework development experience using Java/J2EE Stack
* 3 years of experience in Web application design, development, Application Maintenance and testing.
* Sound knowledge in Object oriented design and Java programming, Web application development using Java, J2ee, Responsive web design ( Html 5, css )
* 2 years of work experience in data modeling, ETL script development using Teradata ,Reporting using Tableau.
* Diverse experience in working with variety of Database like Teradata, Oracle, Mysql, IBM Db2, Microsoft sql server
* Hands on experience in working with Amazon web services ( AWS) - Amazon EC2 Linux server instance, Amazon RDS MySql Cloud instance
Specialties:
• NoSql : Hadoop, Pig , Hive
* Languages : Java, J2ee, Shell Scripting, Python, Unix
* Frameworks: Spring
• Web Technologies : HTML5, Ajax JavaScript, CSS, XML, JSP, Jquery,
Responsive web design
• Databases : Teradata, Microsoft SQL Server 2008 R2/2012, MySQL, Oracle 10g, IBM DB2
• Cloud Platform : Amazon RDS MYSQL
• Operating Systems : Linux, Unix, Windows, Sun Solaris OS
• Tools : Eclipse, Teradata Sql assistant, GIT, Maven
* Testing : Junit testing, Power Mock
Software Engineer - Data Platform Tools & Services @ As part of Data Technology team at PayPal; Building out a , Real time analytics platform, using Hadoop to ingest and process massive amounts of customer interaction data, match business-defined behavioral patterns, and generate entities and interactions matching those patterns. The pipeline is an ecosystem of components built using HDFS, HBase, a data catalog, and seamless connectivity to enterprise data stores.
Specialities: Hadoop, MR, Java, Pig, Spring, Web Services From January 2014 to Present (1 year 10 months) San Francisco Bay AreaSoftware Developer Intern @ • Revamped the existing web application that manages Incident response management system( data issue Tickets) for CRM team. Technology Used: Spring MVC, J2ee, Maven, Html, Css, java script, oracle, Glassfish, Ldap, Kerberos.
• Built BI reports for Data analysis of PayPal’s Market performance in European continent using tableau.
• Worked on integrating new marketing channels for PayPal ( SMS, Direct Mail ) and developed a script that automates Data QA before file delivery.
• Worked on gathering business data requirements to design a large scale Business Intelligence dashboard for monitoring the health of CRM operations using MicroStrategy.
• Extensively performed performance testing, conducted quality audits and eliminated the various bottlenecks which reduced the performance of PayPal's new email contact management system. From June 2013 to August 2013 (3 months) California,SanjoseDatabase Marketing Analyst and Application Developer @ * Developed java based application to enforce governance model for campaign names used by PayPal’s Global enterprise marketing team and wrote test cases for testing the application using Junit test suite.
* Worked on developing a ETL script to load Unica contact history data (80 million) of PayPal’s Global marketing campaigns daily directly into Teradata data ware house tables by passing custom oracle contact history to reduce data migration overload. – Unix Shell scripting, Bulk data loading, Teradata Bteq, Fast Load, Fast Export
* Automated batch jobs using Unix Shell scripting and implemented quality audit checks and reports on every step of execution allowing 5 analysts to manage 250+ campaigns every day efficiently.
* Handled 1800 user tickets (Change management request, Incident response) and resolved user queries, data integrity issues by adhering to the SLAs and extensive experience in manipulating and analyzing large datasets.
* Developed and Installed QA reports as a unix cron job in the server for periodically performing consistency check on customer contact history between oracle data mart and Teradata data warehouse tables using Unix shell scripting, Teradata BTEQ and Oracle Sql loader. From July 2010 to July 2012 (2 years 1 month) Programmer Analyst Trainee( Vendor) @ Underwent professional Training on Programming languages like J2ee, Java. From July 2010 to December 2010 (6 months) Bachelor of Engineering, Computer Science (Anna University) @ ACADEMIC PROJECTS
Rapid Fuzzy clustering of Banking customers:-
Worked on optimizing fuzzy clustering of banking customers based on transactional data by combining Fuzzy-c-means algorithm (FCM) and Evolving clustering method (ECM). - Java, IBM DB2
Ecops – Web Application:- Great Mind challenge - Contest Conducted by IBM, India
Designed web application named E-cops, automated governance model for police department. Features include Criminal face detection (Bio metric authentication), Traffic update using Mobile based application. – J2ee ( Servlets, Jsp , Struts, Ajax), Jquery, Html , Css, Dojo, Java script, IBM DB2.
Container shipment and security using Radio Frequency Identification:-
Presented a research paper on “Container shipment and security using Radio Frequency Identification” at a national level technical symposium conducted at SRM university, chennai and won second prize. The paper illustrates how containers are secured using a passive RFID tag and also briefs about anti collision algorithms developed to prevent collision among tags during signal transmission. From August 2006 to May 2010 (3 years 10 months)
Master of Science (M.S.), Management Information Systems @ Texas A&M University From 2012 to 2013 Bachelor of Engineering (B.E.), Computer Science @ Anna University From 2006 to 2010 Shunmugavel Chandran is skilled in: Unica, Campaign Management, ETL, Unix, Unix Shell Scripting, Teradata, J2EE, Java, PL/SQL, Problem Solving, Web Design, Cognos, Unica Affinium Campaign, Java Enterprise Edition, Microsoft SQL Server, Data Warehousing, MySQL, Shell Scripting