Ashitha Annu Andrews

Summary

Experienced data professional with a comprehensive skill set in Business Intelligence and Business Analytics and tools like Microsoft Excel, PowerBI, Tableau and Tibco Spotfire. Specializing in optimizing data structures and ensuring seamless operations within database management systems such as Microsoft SQL Server and MySQL. Leveraging Microsoft Team Foundation Server (TFS) for version control, contributions are made to collaborative development environments. Excel, Word, PowerPoint, Microsoft Visio, and Microsoft SharePoint are seamlessly utilized for facilitating robust data analysis and reporting. Proficient in SQL, HTML, CSS, React, Javascript, Python, and IronPython, bringing versatility to coding tasks. Accomplished in ETL processes, utilizing Microsoft SQL Server Integration Services (SSIS) for efficient data integration.

Experience

Senior Data Engineer, LTIMindtree
April 2024 – Present (1 year 4 months), Calgary, Alberta, Canada
Client: Microsoft

Guidehouse (3 years 1 month)
Spotfire Support Specialist
August 2020 – August 2022 (2 years 1 month), Trivandrum, Kerala, India

• Monitoring and maintaining production/non-production environments, resolving potential issues, and ensuring smooth business operations, I dedicated a remarkable amount of time to serving as Spotfire Support/Spotfire Admin alongside dashboard development.
• Provided technical support to Spotfire users, addressing inquiries related to software functionality, troubleshooting data visualization issues, and resolving software bugs or errors.
• Diagnosed and resolved Spotfire platform-related issues by conducting thorough analysis and collaborating with development teams to implement effective solutions, resulting in a significant reduction in downtime.
• Assisted users in customizing and configuring Spotfire dashboards, reports, and data visualizations according to specific business requirements, ensuring optimal performance and usability.
• Conducted training sessions for Spotfire users to enhance their proficiency in utilizing the platform's features and functionalities effectively. Developed comprehensive documentation, including user guides and troubleshooting manuals, to facilitate self-service support and knowledge sharing.

Business Intelligence Developer
August 2019 – August 2022 (3 years 1 month), Trivandrum, Kerala, India

• Utilizing BI tools like Spotfire, Tableau, and Power BI, I devised innovative designs and performed application development and implementation.
• Leveraged advanced skills in Power BI, Power Query, DAX coding, and Power Automate, optimizing data workflows and contributing to a 25% improvement in reporting efficiency and data-driven decision-making within the organization.
• In Tableau worked on projects that involve advanced functionalities such as connecting to stored procedure, creation of non default charts and embedding of dashboard.
• In Spotfire worked on multiple projects that involved advanced functionalities like coding in IronPython, R Data Function, JavaScript and Mods.
• Utilized advanced MS Office 365 proficiency in Excel, Macros, PowerPoint, Visio, and SharePoint to optimize data processes, resulting in a 20% increase in accuracy and a 30% improvement in efficiency.
• Utilized advanced SQL queries across Oracle, Microsoft SQL Server, and SQLite to extract, transform, and analyze data for BI solutions.
• Improved data retrieval and analysis efficiency by 20% by applying strong SQL skills in constructing efficient queries, views, and stored procedures.
• Executed development, testing, and deployment of SQL Server Integration packages quarterly, meeting project timelines with 95% accuracy.
• Maintained 100% data load integrity by creating and managing SQL execution packages.
• Proactively communicated to stakeholders, resulting in a quantifiable 20% improvement in collaboration effectiveness and stakeholder satisfaction.

Intern, Singularis Software Technologies
July 2016 – July 2016 (1 month), Kottayam, Kerala, India

• Learned HTML, CSS, and JavaScript, with expertise in building responsive and user-friendly web interfaces.
• Developed backend systems, integrated databases, and crafted interactive web applications, applying PHP skills in practical scenarios.
• Troubleshooted bugs, optimized code for performance, and implemented new features.

Intern, ipsr solutions ltd
June 2016 – June 2016 (1 month), Kottayam, Kerala, India

• Gained hands-on experience with PHP frameworks, libraries, and best practices.
• Received mentorship from experienced professionals, accelerating learning and gaining industry insights.
• Participated in training sessions and online resources to stay updated on PHP and industry trends.

Education

• Conestoga College — Postgraduate Degree in Information Technology Business Analytics (Sep 2022 – Dec 2023)
• St. Joseph's College of Engineering and Technology, Palai — BTech in Computer Science Engineering (2015 – 2019)