Arun Ramanathan Email & Phone Number

Chennai, TN, IN

Chennai, Tamil Nadu, India

Working in client location FORD Chennai as a Senior Business Analyst with Data Engineering Team. Proficiency Python, SQL and Google Cloud.

Chennai, Tamil Nadu, India

• Worked with the product team to understand the different types of sensitive elements, scope and collected relevant datasets which contained relational databases using SQL queries.
• Pre-processing the datasets with different NLP techniques like noise removal, stop words removal, Tokenization, Lemmatization and Stemming using NLTK and Spacy libraries.
• Calculated Bag of words, Term Frequency – Inverse Term Frequency (TF-IDF) and Word2vec to identify the quality of the training dataset.
• Enhanced the dataset creation with data augmentation and NLG techniques using packages like Markovify, nlpAug and scraped twitter and other social media platforms using python libraries.
• Created reports and dashboard using Tableau to cater to the business users on the feasibility and quality of the dataset used for training the classification models.

Chennai, Tamil Nadu, India

Data Analyst Team Lead

Chennai, Tamil Nadu, India

Worked on automating leave application and management process with Google sheets and Google App script.

Chennai, Tamil Nadu, India

• Worked as a product owner in gathering business requirements from the stakeholders for the creation of a new homogenized reporting layer which will house the transactions of PayPal and its subsidiaries.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis of large datasets for determining suitability for modeling and pattern identification for the ETL project.
• Performed data validation with SQL queries & Excel to identify the gaps between the source and target
• Created complex reports and dashboards with Tableau using data visualization best practices, parameters, filters, LOD expressions and calculated fields for sharing the insights with the stakeholders on data quality and.

Chennai Area, India

• Worked with large sets of data, updating and maintaining the master database with the latest set of information to ensure the information shared with client are the most accurate.
• Profiling/sourcing the right set of information/data through online research to ensure that the final data meetsthe client’s requirements.
• Worked with SQL queries in analyzing and cleansing the data for any inaccuracies and correcting them in the process.
• Created reports and dashboards with Tableau for ad-hoc andexplanatory analysis of data in helping stakeholders gaining valuable insights from the data.

Chennai Area, India

• Responsible for creating reports and dashboards using Tableau/Excel to evaluate the performance of our contact center agents on a daily, weekly, monthly and annual basis.
• Published scorecard for the agents for their periodical review and payroll process.
• Developed excel macros with VBA to automate repeated excel functions, thereby speeding the reporting process.
• Developed new reports to identify technical issues faced by the agents and reporting them to the stakeholders and the management.

Chennai Area, India

• Responsible for creating special pricing deals for HP Products using Eclipse, Watson, DART tools on the respective currencies for SEA (South East countries).
• Working with various Business units approvers to get the pricing for various products and releasing the approved quote to the sales for further negotiations with the customers.
• Created reports and dashboards for the sales team to help with compliance related issues and thereby helping in achieving increased revenue.
• Automation of process with the help of VBA Macros to avoid inaccuracies in the data and managing data to provide daily, weekly and monthly reports on sales performance with the business unit approvers and managers.

Chennai Area, India

• Handling E-mails from Telecom Operators like Airtel, Aircel, Reliance, BSNL etc. regarding our Value Added Services process.
• Preparing monthly reports for total complaints, activations and deactivations with MS-Excel and MS-Access.
• Preparing MIS reports on the types of complaints received and report the same to the Chief Executive Office of the company.
• Using data mining techniques to determine the best quality data to generate the reports.

Master Of Business Administration - Mba, Management Information Systems, General, B

Bachelor'S Degree, Computer Application, B

Higher Secondary School, Computer Science