Pattu Arounassalam

• Responsible for the end-to-end development and management of the TAM (Television Audience Measurement) web application, delivering 22 comprehensive reports for Etisalat IPTV and OTT users.
• Designed and implemented an ETL process using PySpark, Python, and Hive to transform raw source data into actionable insights.
• Automated repetitive tasks using Python scripts, increasing efficiency within the team''s workflow processes.
• Implemented API integration for seamless communication between different software components within the organization''s ecosystem.
• Collaborated closely with team to create story points and sprint planning.
• Supported business objectives by developing custom reporting tools using Python libraries like Pandas and Matplotlib.
• Diagnosed and resolved numerous production issues within the TAM portal to ensure smooth operations.
• Developed and implemented user role management within the TAM portal to enhance user access and security.
• Collaborated with cross-functional teams to design, develop, and implement robust Python applications.
• Investigated new technologies like Docker or Kubernetes to streamline deployment processes while maintaining a consistent dev/prod environment.
• Improved application performance by optimizing Python code and implementing best practices.

Tools Used: Python 3.7, Apache Web Server, Flask, MongoDB, Compass, and PySpark

• Created workflows in the Huawei insights bigdata environment
• Developed query using hive and tested in staging server
• Developed and integrated more than 30 APIs for Bigdata as per client request
• Developed and Implemented User authentication and authorization for Bigdata APIs
• Written and executed hundreds of stored procedures, triggers, tables, views etc
• Maintained production database and test database for multiple usecases
• Tested and deployed the webAPI into testing and production server
• Tools Used: ASP.Net, C#, jQuery, SQL Server2018,JAVA servlet, JSP, Hadoop,hive

• Project#1: Atoll HRMS - It is a complete HRMS which includes employee attendance, Leave modules, User management, Payment modules, Payroll processes, End Of service etc
• Written and executed hundreds of stored procedures, triggers, tables, views etc
• Maintained production database and test database for multiple clients
• Developed major modules like manual attendance, Payroll process, Payment modules
• Implemented and tested multiple branches for all modules
• Developed several customized dashboards as per client request using Power BI
• Tested and deployed the application into testing server using Azure Virtual Machines
• Tools Used: ASP.Net, C#, jQuery, SQL Server2018, Azure VM, Crystal Report, Power BI

• Project#1: Alertfor - It’s a web application which will send notification to the users when any changes happened in particular part of a DOM element of a webpage
• Developed selection module which will automatically highlight the selected part on mouse move and it is saved in PostgreSQL DB
• Developed search alerts, browse alerts, add alerts module
• Developed login modules using OAuth API
• Tested and deployed the application into testing server using Azure Virtual Machines
• Tools Used: ASP.Net, C#, jQuery, PostgreSQL, Azure VM

• Project#1: Nano IMS Client Portal - This is a web application for our client AXA Gulf
• AXA Gulf have multiple web application for their internal and external management
• Provided full life cycle supports through design, coding, testing, debugging, implementation and integration
• Developed Addition request, Deletion request, Amend member request and card request modules
• Worked as a production support for the whole web application
• Monitored and updated back-end data by inter-communicating between API and Web application
• Tested and deployed the application into testing and production servers using Azure Virtual Machines
• Responsible for support, maintain and software functionality
• Tools Used: Azure VM, ASP.Net 4.5 MVC, C#, Sql Server 2012, jQuery, Entity Framework

• Project#1: Resivalue - It is an Appraisal generating tool for residential property in USA
• Its core feature is to compare, analyse and generate appropriate forms as required by the client
• Developed Value analysis module which compare subject property with other properties selected by the user
• Developed many more enhancements of overall product as per client request
• Developed custom reports based on standard forms(1004 UD,Property Appraisal) using crystal report
• Integrated with google map API for viewing nearby properties of the subject property
• Worked as a production support for the whole web application
• Tested and deployed the tool into testing and production servers using Azure Virtual Machines
• Tools Used: ASP.Net 4.5 MVC, Sql Server 2008,Knockout js, Dapper,Crystal Report

• Project#2: Alerto - It’s a tool which generates various customized reports based on output from a embedded instrument of a threading mill
• Developed Custom report, production report, Power Analysis report, Trend Analysis Report etc
• Developed few more enhancements of overall product as per client request
• Database design and implementation including tables, stored procedures and views
• Tested with use case and implemented as per client needs
• Responsible for support, maintain and software functionality
• Tools Used: ASP.Net 4.5 MVC, C#, Sql Server 2012, Knockout, jQuery, Dapper

Project#1: Large scale Gov search engine - The MyGovin is a vertical search engine for searching Indian government websites

• Scraped all URLs of Indian government web sites from central portal
• Developed search user interface which includes faceted search using solr
• Integrated Solr at the backend for indexing
• Developed Search history module to store the query log
• Converted web pages into xml and indexed in Solr
• Run Object ranking using Hadoop
• Tools Used: Java, Solr4.3, mySQL, Javascript, Hadoop

Project#2: Gas Agency Management - It’s a web app for managing internal data of a Gas Agency

• Developed 6 modules of the application
• Provided full lifecycle supports and requirements analysis through design, coding, testing, debugging, implementation and integration
• Developed Customer management, User management, raw materials management, login modules, Admin modules, Daily Entry module, Purchase Entry Module etc
• Developed database design and implementation including hundreds of tables, stored procedures and views
• Developed more than 20 Customized reports using RDLC report
• Responsible for support, maintain and software functionality
• Deployed in Azure VM using automated scripts
• Tools Used: ASP.Net 4.5 MVC, LINQ, C#, Sql Server 2012, jQuery, Entity framework, RDLC Report

Project#3: Twitter sentiment analysis - The project aims at finding sentimental analysis of the given tweets about a product using Twitter API

• We have found a complete analysis whether the tweet is positive or negative or neutral using machine learning algorithm
• Installed and Implemented Tweepy in the project
• Used TextBlob for processing and cleaning textual data
• Analysed the result set to meet the highest accuracy
• Responsible for Bug fixing and support, maintain
• Tools Used: Django, Python, twitter API

Project#4: ERP - It’s an Enterprise resource planning software for one of our client named Santhi Textiles, Erode

• I have developed 8 modules of the software
• Provided full lifecycle supports and requirements analysis through design, coding, testing, debugging, implementation and integration
• Developed Customer management, Order management, Process management, Raw materials management, Login modules, Admin modules etc
• Database design and implementation including tables, stored procedures and views
• Developed more than 20 Customized reports using RDLC report
• Responsible for support, maintain and document software functionality
• Deployed in Azure VM using automated scripts
• Tools Used: Azure VM, ASP.Net 4.5 MVC C#, Sql Server 2010, Kendo, RDLC report, Jquery, Entity framework