Amar Janardhanan
*********@*****.*** +91-776*******
C-223, SMR Galaxy Apt. AECS Layout, Block-A, Chinnapnahalli, Bangalore-560037 PROFESSIONAL EXPERIENCE
Dec’16 to Present Tata Consultancy Services System Engineer PROFILE SUMMARY
• An organized and goal-driven IT professional with experience of development in Business Intelligence, Data Analytics and Web Development.
• As a member of Analysis team, designed and developed many modules mostly from scratch with good quality while adhering to time lines. Took part in peer code and design reviews.
• As a member of Automation Team, designed and developed many automation scripts for automating the manual workflows and created many UI dashboards to show meaningful reports and process flow. Mentored and provided training to junior members in the team
• Strong Python, SQL, JavaScript skills. Good Understanding of SAP HANA database.
• Individual with strong communication, interpersonal skills, self-motivated, quick learner and team player.
• Proven ability to work individually by single handedly delivering many development scripts. TECHNICAL SKILLS
Programming Languages
Database
UI Technologies
Development Tools
Other Skills
: Python, JavaScript
: SAP HANA, MySQL
: SAP UI5
: Anaconda, Sublime Text, SAP HANA Studio
: Flask Framework, Pandas, Selenium, Web Scraping, UI Automation PROFESSIONAL EXPERIENCE
Quality Assurance Tool
• Collaborated in the design and development of a quality assurance tool for SAP systems which identifies and classifies error at each phase of development till the deployment of the system.
• Developed and tested Python OS scripts to ensure the quality of the systems and logs were generated with the desired error/success message.
• Involved in coordinating with other teams to understand the manual process and conceptualize the Python scripts to automate the process.
• Identified errors were reported back to concerned people via automated mails during each phase of the system build.
• Designed and developed visually impactful dashboards for managers to assist them in root cause analysis of the error.
• Enhanced the quality of system build by 40% and reduced time taken by manual procedure by 60%.
• Tool Box: Python, SAP UI5, SAP HANA
Data Extraction Tool/Web Automation Tool
• Designed and Implemented a framework responsible for the extraction and validation of data from various web-based tools.
• Written many Python scripts for extraction of raw data from web.
• Worked on Data Cleansing and manipulation to convert the data into desired format as per the requirement. The extracted data can be saved in multiple formats and even loaded into database for further and easy reference.
• Worked on flask framework to deploy the python scripts in windows server.
• Worked on Pandas Library, good knowledge on data frames to handle complex data and modify raw data to required form as per the requirement.
• Worked on Selenium library to extract data from Web pages and to automate manual UI Tasks thereby reducing manual efforts.
• Tool Box: Python, Pandas, Flask, Selenium, Excel library(xlrd,xlwt), HANA Database. UI Dashboards and Tools
• Designed and Developed many UI Dashboards to show the process flow of different teams in project and developed reports for quick analysis of the data.
• Good understanding of MVC architecture.
• Worked on SAP HANA database created many calculation views to gather the data from multiple tables.
• Worked on complex SQL queries to fetch data and model the raw data into required format.
• Good understanding of JSON format, worked on complex data to model the data to desired format for pictorial representation as well as in UI tables.
• Worked in core architecture team for designing and development of database tables and UI design for various tools used with in the project.
• Worked as owner of few of the UI dashboards to gather the requirement from stakeholders and came up with optimum solutions to map the process flow and developing reports.
• Tool Box: SAP UI5, SAP HANA, JavaScript, Ajax
ACADEMIC CREDENTIALS
• B.E. Electrical and Electronics Engineering, CMRIT, Bangalore, 2012-2016 with an aggregate of 71.5%.
• CBSE Class 12, Greenway Modern Sr. Sec. School, Delhi, 2012, Secured 70%.
• CBSE Class 10, Greenway Modern Sr. Sec. School, Delhi, 2010, Secured 88%. ACHIEVEMENTS
• Zonal winner of ROBOTICS WORKSHOP of National Robotics Championship-2013 organized by ARK Techno – Solutions conducted at IIT-Bombay
DECLARATION
I solemnly declare that the above furnished details are true to best of my knowledge and belief. Place: Bangalore
Amar Janardhanan