Geethanjali Chillale
Bangalore
Summary
A Data Analyst and Automation Specialist with proficiency in Power BI, ServiceNow automation, and statistical analysis, who uses data visualisation to enhance decision-making by 45%. 80% more efficient workflows because to expertise in PostgreSQL, Active Directory, and PowerShell scripting. capable of managing servers, patching Linux, and providing 99.9% system uptime through experience in real-time monitoring. devoted to using automation and data to propel company expansion.
Overview
2
2
years of professional experience
3
3
Certification
Work History
DATA ANALYST - INTERN
Twilearn
Bangalore
01.2025 - Current
- To find patterns and insights in datasets, exploratory data analysis (EDA) was carried out.
- SQL was used to effectively manage and query relational databases.
- Python was used to automate analytical operations, visualise data, and preprocess it.
- Data-driven dashboards and reports were created to aid in business decision-making.
DATA ANALYST - SYSTEM ENGINEER
Tata Consultancy Services
Bangalore
11.2021 - 09.2023
- Designed and implemented user-friendly Power BI dashboards to monitor automated ticket statuses, enhancing data accessibility and reducing live reporting time by 35%.
- Developed a comprehensive dashboard displaying succeeded, failed, and manually queued tickets, incorporating interactive visualizations such as graphs and bar charts.
- Integrated dynamic filters for ServiceNow request types and time periods (daily, weekly, monthly, quarterly, yearly) to enhance data analysis and usability.
- Enabled monitoring of tickets in various stages, including in-progress, queued for automation, successful, failed, and manually processed, ensuring comprehensive tracking.
- Deployed a real-time Power BI dashboard to track ticket automation progress, providing stakeholders with enhanced visibility and increasing reporting efficiency by 40%.
- Collected daily data from the dashboards to monitor ticket trends and identify potential issues, ensuring accurate and timely decision-making.
- Isolated and analyzed failed ticket data, categorizing failures and identifying root causes. This analysis led to a 20% improvement in code efficiency, reducing failure rates and optimizing ticket processing.
- Cleaned, analyzed, and visualized data in pie charts, funnel charts, and Excel reports, improving data accessibility and decision-making speed by 35%.
- Generated customized reports based on client requirements using real-time data from dashboards, ensuring a 50% improvement in report delivery time and providing clients with accurate, on-demand insights.
- Collaborated with the Greenfield ServiceNow team to understand their processes and interfaces, facilitating the integration of Ignio automation UI with ARS (Active Directory) and the database through Postgres SQL.
- Deployed automation code for ServiceNow request forms and worked closely with cross-functional teams to ensure smooth integration and functionality.
- Tested and validated the integrated automation processes, ensuring seamless operations and enhanced ticket management across systems.
ASSOCIATE SYSTEM ENGINEER
Tata Consultancy Services
Bangalore
11.2020 - 10.2021
- To improve automation capabilities and streamline data flow, Postgres SQL was used to integrate Ignio UI with ARS and Refinitiv ServiceNow databases.
- In order to streamline workflows to deploy the Ignio Studio bundle in Ignio UI, PowerShell scripts were developed to automate the Snow request operations in Ignio Studio.
- Before being deployed to production, ServiceNow request forms were tested in UAT to ensure correct functioning and effective execution.
- After extensive testing in UAT, the automation code was successfully deployed to the production environment, guaranteeing smooth integration and operational effectiveness.
- Real-time server monitoring ensured uninterrupted uptime and timely resolution of any alarms by proactively identifying and resolving problems.
- To guarantee server security, stability, and health, monthly patching tasks were carried out on PROD and UAT servers.
- Upgraded annual certificates before licence expiry to maintain uninterrupted service and compliance.
- Utilised Postgres SQL for SQL query optimisation to analyse and track ticket processing, including success and failure rates, to make reports of ticket status, by improving efficiency by 40% and for better operational insights.
Education
INTERMEDIATE - undefined
Sri Chaitanya College
01.2016
BACHELOR OF TECHNOLOGY - undefined
JNTU University
01.2020
Skills
- Power BI
- SQL
- Python
- MS Excel
- Matplotlib
- NumPy
- Powershell Scripting
- Ignio Studio Integration
- Postgres SQL
- JSON
Certification
- Data Analytics Course, Trainity
- SQL & PostgreSQL for Beginners, Udemy
- Linux Mastery: Master the Linux Command Line, Udemy
Timeline
DATA ANALYST - INTERN
Twilearn
01.2025 - Current
DATA ANALYST - SYSTEM ENGINEER
Tata Consultancy Services
11.2021 - 09.2023
ASSOCIATE SYSTEM ENGINEER
Tata Consultancy Services
11.2020 - 10.2021
INTERMEDIATE - undefined
Sri Chaitanya College
BACHELOR OF TECHNOLOGY - undefined
JNTU University
Similar Profiles
Shaik AaminShaik Aamin
Web Development Internship at TwiLearn Edutech Pvt. Ltd.Web Development Internship at TwiLearn Edutech Pvt. Ltd.
Sijith VJSijith VJ
Principal Software Engineer at OraclePrincipal Software Engineer at Oracle
Sreeram TRSreeram TR
Catalog Manager at AmazonCatalog Manager at Amazon
Partha Protim BoraPartha Protim Bora
Senior Project Management Specialist - SCM at Honeywell Technology Solutions (Aerospace Division)Senior Project Management Specialist - SCM at Honeywell Technology Solutions (Aerospace Division)
Anil Kumar SawAnil Kumar Saw
Staff Engineer at Altimetrik India Pvt. LtdStaff Engineer at Altimetrik India Pvt. Ltd