About

S. Amalan is a highly skilled data engineer with over 7 years of experience working with data in OLAP systems, including 5 years in healthcare and 2 years in fintech. He has a strong background in data engineering, including shell scripting, shell/SQL based ETL, Twitter analysis using ETL, automation of data analysis using SQL, analysis of reviews for mobile applications hosted on Apple iTunes and Google Playstore using XML-SQL, and segmentation of high value makers (high transaction volume) for financial institutions. He is extremely detail-oriented and accurate in all forms of communication, having developed end-user documents, release notes, installation notes, and helped the documentation team with official core product material. Amalan is experienced in analyzing, troubleshooting, testing, delivering, and supporting enterprise software that dealt with multiple flavors of Unix and SQL in terabyte databases. His technical skills include proficiency in Linux, SunOS/Solaris, HP-UX, AIX, Windows XP/7, macOS, Postgres, Netezza, Oracle, DB2, Sybase – SQL, object management, query performance, shells: csh, bash, tcsh, ksh; utilities: awk, sed, ssh, SFTP, cron, Airflow, Splunk, Git, CA Autosys, Sterling File Gateway, Rational ClearCase, Apache, WebLogic, Jboss, Tuxedo, WorkPoint, Rational ClearQuest (IBM), MS Dynamics, JIRA, Quality Center (HP), Application Lifecycle Management (ALM-HP), Java clients, Web-based clients, X GUIs, Cloudera Essentials for Apache Hadoop, Introduction to Apache Hive, HUE (Hadoop User Interface) demo, and Tableau. Currently working as a Data Engineer - Analytics at Virgin Pulse, Amalan has developed a bash/python program that checked 30 separate items from a pre-boarding QA perspective in the incoming encounter and medical code files (ICD9/10 DX/PX, CPT) to satisfy the requirements of the software that ingested data. He has also performed QA with the help of the program mentioned above, finding problems and generating reports for the Implementation Team which interfaced with the new clients to get the issues resolved. Amalan has run monthly ingest and build programs for incoming patient encounter and medical code files that get merged with 3rd party demographic data. He has also worked on migrating legacy data from a file-based system on Linux to a RDBMS