SARANYA RAVICHANDRAN
**** ********* ****, *** ****, CA-95129 *******.************@****.***.***
Ph: 408-***-**** www.linkedin.com/in/saranya23
SUMMARY OF QUALIFICATIONS
A dedicated and hardworking professional with 2 years of work experience in development and testing.
Possess excellent analytical and problem solving skills.
TECHNICAL SKILLS
Programming Languages : Python, Java, Android development, C, C++
Databases : MySQL, Teradata, PostgreSQL,Oracle
NoSQL database : Redis, MongoDB
Data Analytics : MapReduce, Hadoop, Big Data
ETL Tools : Datastage, Informatica
Cloud Platforms : Amazon Web services, Google App engine, Microsoft Azure,
IBM Bluemix
Web Development : HTML, CSS, JavaScript, JQuery, JSON, XML, Ruby on Rails
Testing : JMeter, Junit, IBM Tivoli
Reporting Tools : Microstrategy
Operating Systems : UNIX, Windows
Networking : OSI model, Internet protocols, Switching, Wireless LAN,
Cellular networks, TCP/UDP, Bluetooth, Socket programming
IDE’S/Tools : Eclipse, Wireshark, Weka, Visual studio, MS Office, Git
EDUCATION
Master of Science, Computer Science Dec 2016
University of Texas at Arlington GPA: 3.75/4.0
Courses: Design and analysis of algorithms, Cloud Computing, Data Mining, Data Science, Web data Management, Distributed Systems, Computer Networks, Software Engineering, Database Systems, Wireless Networks, Software Testing.
Bachelor of Engineering, Computer Science May 2012
Panimalar Institute of Technology Chennai, India GPA: 8.3/10
PROFESSIONAL EXPERIENCE
Project Engineer at Wipro Technologies, Chennai Dec 2012 – Jan 2015
Developer in Citi Bank project-NextGen EDW:
Performed extraction, transformation and loading of data from different sources like flat files to databases using IBM Infosphere Datastage and Teradata SQL.
Analyzed the Business and Functional Requirement Documents and laid out the steps for the data extraction, business logic implementation and loading into targets.
Deployed and executed parallel jobs and sequence jobs through IBM Tiwoli Scheduler.
Have developed BTEQ scripts and used Fastload, Multiload in TERADATA to load data from landing table to target table.
Extensively worked in Datastage Designer and Director to develop the mappings and monitor the job sequence. Modified existing mappings based on the user requirements for production batch support. Also performed Datastage migration successfully for various releases.
Tester in Bestbuy -CAM project:
Performed various testing and evaluation activities for the data been loaded from source PDW to target Netezza using tools like Tivoli MAESTRO.
Written test cases for unit testing and tested all possible scenarios for error free components.
Executed and scheduled runs for batch jobs and debugged the errors.
Worked in QA migration, support and created corresponding workflow with session tasks.
PROJECTS
Map-Reduce: Python, Amazon S2, Hadoop
Implemented a Map-Reduce program using python to calculate the number of triangles in a undirected graph and to count the number of times a word occurs in a debate. Used VMware and Hadoop for this project.
Used Amazon EC2 instances to implement another Hadoop- MapReduce to analyze Earthquake dataset to see if there is any relationship between depth and magnitude. Experimented with different number of mappers and reducers. Clustered the map-reduce output using Scipy library and performed visualization using Pygal charts..
Forest Cover Type Prediction – Kaggle Contest: Python
Implemented a Decision Tree classifier for an online contest conducted by Kaggle. The forest type has to be predicted by using a classification algorithm based on training and test sets and I used Python to implement it.
Amazon Web service: Python,S3,RDS,Elasticache
Created a Web interface to store a large dataset in the cloud storage, S3 and also used RDS to store the data as tables in a relational database. Calculated the time taken to fetch 1000,5000 and 20,000 random queries from the RDS and compared it with the time taken to fetch the data using Amazon ElastiCache.
Web Development: JQuery, JavaScript, HTML, Ruby-on-Rails
Developed a Server side web application framework using Ruby-on-Rails to host a webpage and used JQuery as a client side JavaScript framework to manipulate the DOM and perform AJAX calls. Later used Databases like MongoDB, Redis and PostgreSQL from which data was fetched and displayed on the webpage.
Photo-sharing site using Google App Engine: Python, Jmeter, MongoDB
Created a web service to upload pictures, comment and view other user’s pictures using Google app engine. Also scaled the application to be used by multiple users and used JMeter to stress test and validate the analysis.
Yelp Data Visualization: Python
Performed data mining/data analytics tasks like K-means Clustering on the yelp dataset and give visualized information using D3 bubble chart and Google API’s. Weka tool was used for clustering.
IBM Bluemix application: Python, Mysql
Created an application to store large datasets in Bluemix Containers and performed encryption and decryption on the content. User will be able to upload, view, delete and download the files based on his selection. Also used ClearDB MySQL database to store the data in tables and to perform insert, delete operations and to set user-quota and file size permitted.
Security Database System: MySQL, Java
Implemented a database system that shows the relationship between roles and account privileges. Used Java JDBC to establish a connection with MySQL database and executed the SQL queries.
Distributed Monitoring Tool: Java, C
Developed Distributed monitoring tool to monitor resource utilization like process count, CPU load, memory usage in a distributed environment. Server side Interface and communication module was done using Java Swing in Eclipse and monitoring program was written in C using Visual studio.