Apala Kachhwaha
Westmead,Australia
Summary
Experienced Data Analyst with over 12 years of extensive experience adept in utilizing a varied suite of data analysis and visualization tools, including Tableau, Power BI, and Toad for Oracle 16.3. Proficient in SQL (Structured Query Language), encompassing expertise in MySQL, PostgreSQL, Oracle Database, and Sybase, facilitating seamless data extraction, transformation, and management.
Well-versed in AWS Redshift and skilled in managing data warehousing solutions, ensuring optimal data performance and integrity. Equipped with a strong command of Linux and Windows/Unix machines, ensuring operational efficacy across diverse environments. Proficient in Rational Application Developer, contributing to the development of robust applications focusing on functionality and user-centric design.
Known for translating intricate business requirements into actionable insights, delivering solutions that enhance operational efficiency and drive informed strategic decision-making. Adaptable to evolving technologies and industry trends, fostering a data-driven culture for efficient decision-making
Overview
13
13
years of professional experience
1
1
Certification
Work History
Data Analyst at Westpac
Tata Consultancy Services
01.2022 - Current
- Gathering data from various sources (databases, APIs, spreadsheets, etc.).
- Cleaning and transforming raw data into a usable format.
- Ensuring data accuracy, consistency, and integrity.
- Performing exploratory data analysis (EDA) to identify patterns, trends, and correlations within the data.
- Employing statistical methods, predictive analysis, and data modelling to derive actionable insights.
- Generating reports, dashboards, and visualizations to communicate findings effectively.
- Assessing data quality and recommending improvements.
- Implementing and maintaining data quality standards and processes.
- Collaborating with stakeholders to understand business needs and objectives.
- Providing data-driven recommendations to support decision-making processes.
- Identifying opportunities for process improvement and optimization based on data insights.
- Utilizing analytical tools (such as SQL, Python, R, Excel, Tableau, Power BI, etc.) to perform analyses efficiently.
- Staying updated with the latest tools and technologies in the data analytics field.
- Ensuring adherence to data privacy regulations and organizational policies.
- Implementing and maintaining data governance frameworks.
- Effectively communicating complex technical findings to non-technical stakeholders.
- Presenting insights and reports in a clear and understandable manner.
- Keeping up-to-date with industry trends, best practices, and emerging technologies in data analysis.
Senior support executive
Tata Consultancy Services Ltd.
01.2017 - 12.2022
- Engaged in the analysis of banking software applications, offering support in error resolution reported by clients for improved software functionality.
- Experience with AWS Redshift for data analysis and extraction, leveraging its functionalities to derive meaningful insights.
- Contributed as a key team member in project enhancements by actively participating in requirement gathering sessions, ensuring alignment with project objectives.
- Provided second and third-level support (L2/L3) for issues arising during batch executions, ensuring smooth and error-free operations.
- Conducted comprehensive IT support duties, addressing daily production issues, and validating ledger and statement accounts for accuracy.
- Ensured seamless processing by monitoring scheduled operations and promptly addressing any system errors encountered during application executions.
- Responsibly handled reported errors from partners, ensuring swift resolution and minimal disruption to operations.
- Proficiently utilized scheduling tools such as Autosys and PMF for executing jobs and maintaining operational efficiency.
- Conducted regular status calls with clients, addressing day-to-day production issues to maintain a streamlined workflow.
- Executed Unix scripts for process automation, contributing to enhanced productivity and efficiency.
- Played an active role during system outages and production failures, swiftly identifying issues and contributing to their resolution.
- Compiled documentation for recurrent issues, initiated automation strategies, and conducted review sessions with the build team for project stability.
- Proficiently managed requests and incidents independently using Service Now and other relevant tools.
- Demonstrated expertise in crafting and executing PL/SQL queries and Unix commands and scripts for effective data analysis.
- Possessing a working knowledge of Python to support analytical functions and automation processes.
- Utilized TLM Smart Stream and ITRS for daily monitoring and maintenance of the production environment, ensuring system stability and performance.
Application developer and IT Analyst
Tata Consultancy Services Ltd.
08.2015 - 12.2016
- Offering comprehensive application support for banking software, addressing and resolving reported client errors to ensure smooth operations.
- Providing proficient L2/L3 support for issues encountered during batch execution, ensuring the accuracy and integrity of data processes.
- Collaborating as an integral part of the project, actively involved in enhancing functionalities and understanding project requirements through effective participation in requirement discussions.
- Responsible for compiling System Requirements Documents (SRD) and organizing team reviews to ensure alignment and clarity.
- Independently driving assigned projects, starting from requirement analysis to deployment in production, ensuring end-to-end project management.
- Preparing and reviewing Design Documents to outline system architectures and proposed solutions for enhanced project understanding.
- Engaged in coding, conducting unit tests, and integration tests to validate data processes and ensure seamless system functionality.
- Providing valuable support to the User Acceptance Testing (UAT) team by addressing and resolving defects efficiently.
- Proficiently utilizing PL/SQL programming and leveraging basic UNIX commands for data analysis and manipulation purposes.
System Engineer in Application Support/Maintenance
Accenture Services Private Ltd.
03.2011 - 08.2015
- Offered extensive application support and development for AT&T client operations nationwide in the USA, ensuring smooth functionality and efficient data analysis.
- Provided in-depth second and third-level (L2/L3) support for any issues arising during batch execution, focusing on resolving them promptly for uninterrupted operations.
- Efficiently prepared and configured User Acceptance Testing (UAT) environments as per specific user requests, ensuring accurate testing of software functionalities.
- Collaborated closely with clients and support teams to ensure the timely resolution of incidents and tickets, fostering efficient problem-solving and client satisfaction.
- Created, updated, and maintained comprehensive process documents, ensuring accuracy and alignment with operational requirements.
- Developed detailed Production Implementation plans for tested components, ensuring successful and seamless implementations.
- Monitored system processes to verify smooth and scheduled operations, addressing any deviations or issues promptly.
- Responsibly handled system errors generated by applications, providing timely solutions for continuous operational efficiency.
- Managed reported errors by partners, addressing concerns promptly and ensuring minimal impact on operations.
- Actively involved in application validation during deployment, confirming adherence to set test cases and ensuring the documentation is up-to-date for operational changes.
- Prepared and reviewed comprehensive Design Documents, ensuring accuracy and alignment with project requirements.
- Engaged in coding, conducting Unit Testing, and Integration Testing, ensuring the reliability and functionality of developed applications.
- Methodically documented results, maintained defect sheets, and reviewed checklists, ensuring quality standards and process adherence.
- Utilized expertise in PL/SQL development, working on assigned defects and enhancing functionalities in PL/SQL and Core Java.
Education
B-Tech -
01.2010
10+2 -
01.2005
10th -
01.2003
Skills
- Tableau
- Power BI
- Toad for Oracle 163
- SQL (Structured Query Language)
- MySQL, PostgreSQL
- Oracle Database
- AWS Redshift
- Sybase
- Python
- LINUX
- Windows Machine/Unix Machine
- Rational Application Developer
Certification
OCA - Oracle PL/SQL 11g developer certified Associate
Accomplishments
- Recognized with three Spot Awards, acknowledged as the Rising Star of the Quarter, and received two Stellar Awards at Accenture for consistently achieving on-time delivery. Acknowledged by clients with 3 to 4 appreciations for delivering high-quality work and maintaining a system free from critical bugs.
- Received a Stellar Award at AT&T for pivotal contributions resulting in a critical recovery of approximately 1.5 million dollars.
- Acknowledged as part of the Best Team at TCS, earning 350 gems for exceptional collaborative efforts.
- Earned an "On-the-Spot" Award at a swift pace for taking ownership of and successfully handling a complex project module, acquiring 300 gems in recognition.
- Recognized for outstanding teamwork at Citi, earning appreciation in the form of gems.
- Acknowledged by Westpac for exceptional performance and consistently helpful behavior, contributing positively to the organization.
apala.kachhwaha@tcs.com, apala.it02@gmail.com
Contact
0497501871
Present Address
Unit 2, 11-13 Jessie Street, Westmead, New South Wales, 2145, Australia
Personal Information
- Gender: Female
- Nationality: Indian
Timeline
Data Analyst at Westpac
Tata Consultancy Services
01.2022 - Current
Senior support executive
Tata Consultancy Services Ltd.
01.2017 - 12.2022
Application developer and IT Analyst
Tata Consultancy Services Ltd.
08.2015 - 12.2016
System Engineer in Application Support/Maintenance
Accenture Services Private Ltd.
03.2011 - 08.2015
B-Tech -
10+2 -
10th -
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Jasmine KaurJasmine Kaur
Customer Service Officer (Insurance Claims) at MUFGCustomer Service Officer (Insurance Claims) at MUFG