Data Information Technology

Thamizharasan Babu

https://www.linkedin.com/in/thamizharasanbabu/ Mobile: +1-312-***-**** ******@****.***.*** EDUCATION

Master’s in Information Technology and Management GPA: 3.9/4 Illinois Institute of Technology, Chicago, IL Jan ’16 – Dec ’17 Bachelors in Mechatronics Engineering GPA: 3.7/4

Anna University, Chennai, INDIA Aug ’04 – May ‘08

TECHNICAL SKILLS:

Programming Languages & Scripting: SQL, Unix Shell Scripting, JIL (Job Information Language), Python Database: MySQL Workbench, MS SQL Server, MS Access, HDFS. Methodologies: Agile (Scrum and Kanban)

BigData EcoSystem: Hadoop, MapReduce, Yarn, Hive

ETL Tools: SSIS, Data Integration & Pipelining

Tools: Autosys, MS Project, MS Visio, ServiceNow, Power BI, SSRS, Power BI, BMC Remedy, JIRA, MS Office Suite, MS Excel - Pivot Tables & VLOOKUP, Tableau, HP Site Scope, HP Alarm Point. Certification: ITIL V3 Foundation Certified

ACADEMIC PROJECT

Built an e-ticketing system using Java FX and MySQL database Jan ’16 – May ‘16

• Developed desktop application for admin and customer role to perform ticket sales and designed dimensional modeling, source to mapping documents for the OLTP employee dataset.

• Designed a database and implemented CRUD functionalities to all entities. Processed Illinois Crime Data (from 2001 to June,2016) using Hadoop MapReduce Aug ‘16 – Dec ‘16

• Installed and configured Hadoop in Linux CentOS and formed Hadoop cluster in pseudo distributed mode.

• Processed 4 million crime records to find the maximum count of crimes for each year and calculated number of reported crimes based on types.

PROFESSIONAL EXPERIENCE

Slater Technologies Inc. – Chicago (Intern) April’18 – Present

• Built a working model of private blockchain network using Ethereum on multiple Raspberry Pi3 kits.

• Setting up the R-Pi kits and installing Go client of Ethereum (Geth) according to the requirements.

• Created accounts with private keys on the R-Pi kits with one genesis block and multiple nodes using json files.

• Established peer-to-peer network creating a private blockchain for cryptocurrency transactions and mining. Cognizant Technology Solutions – India (Associate) Jan ‘10 – Dec ‘15 Health Care & Insurance Domain

• SME of the Batch Architect team for Onsite in Autosys and shell scripting in QA & Production environment.

• Design databases & build SQL scripts, PL/SQL stored procedures, functions, and triggers.

• Design and develop data marts and associated ETL processes.

• Executed SQL queries to test back end data validation of DB2 database tables based on business requirement.

• Developed variety of reports using SSRS & Power BI.

• Gathering required data from different data sources using SSIS to transform the data according to business requirement and load them in target database.

• Implemented business intelligence analysis & reporting by developing custom reports, dashboards that leverage a wide variety of data source and BI tools (Excel, Tableau & Power BI).

• Analyzed and created SQL, SSRS reports dashboards, tracking parameters to significantly increasing productivity and accuracy across the project.

• Delivered CRM strategies and roadmap for the client management to assist team in transforming the company’s deliverables and service operations.

• Identified process inefficiencies in the team through gap analysis & established quality control processes for clients, resulting in substantial defect margins reduction.

• Applied technical skills using SQL, Excel, JIRA and Visio in data collection, data mining, data analysis on operational metrics, in customer retention and increasing productivity.

• Achieved 100% accuracy in importing data from various file systems to Database using SQL queries & SSIS.

• Used Microsoft Excel for advanced analysis and modelling.

• Expert in creating Root Cause Analysis (RCA) for production failures in troubleshooting.

• Led BI product training for new interns.

Contact this candidate