Annapurni Subramaniam
*****@*****.*** 765-***-****
https://www.linkedin.com/in/asubr/
SUMMARY
Dynamic Data Engineer with over 30 years of experience in data analysis, visualization, and engineering. Proficient in Tableau, Tableau Prep, Microsoft Fabric, Power BI, and APIs, with certifications in DAX enhancing quantitative expertise. Achieved significant improvements in data storage and ETL processes at Purdue University. Proven ability to design impactful analytics solutions, contributing significantly to organizational efficiency. Committed to leveraging unique skills to drive data-driven decision-making for innovative companies, enhancing operational effectiveness and achieving strategic goals.
WORK EXPERIENCE
Purdue University – West Lafayette, IN
Research Data Analyst and Visualization Specialist Oct 2021 – Present
• Conducting in-depth data analysis and crafting visualizations utilizing APIs, Tableau, Tableau Prep, Microsoft Fabric, and Power BI for the
'Center of Food Demand Analysis and Sustainability'. https://ag.purdue.edu/cfdas/data-resources/dashboards
• Facilitating data storage, executing ETL processes, and analyzing data to support individual projects.
• Achieved certification from SQLBI in 'Introduction to DAX' and 'Mastering in DAX Workshop. Administrator of Library Enterprise Applications July 2008 – Oct 2021
• Orchestrated Tableau visualizations, OBI dashboards, and data analysis, including annual reporting and statistical digest.
• Customized, maintained, and troubleshot Library Cloud Applications across eight libraries and campuses.
• Pioneered innovative applications for patrons, staff, and faculty to enhance user experience.
• Configured third-party integrations for Bursar, SAP, Blackboard, and other campus applications.
• Actively participated as a core member of the development group for cloud software, guiding projects from design to implementation.
• Provided customer support and training for staff, faculty, and students.
• Executed Tableau API integration and Oracle BI reporting, generating dashboards and reports.
• Designed workflows and trained staff on library application software.
• Collaborated on the textbook project with ITAP.
• Managed acquisitions, cataloging, and circulation functions across all libraries.
• Certified in cloud software, demonstrating leadership, training, and mentoring capabilities.
• Utilized Python, PL/SQL, and Perl scripting to streamline data conversion processes.
• Developed APIs and facilitated integrations, enhancing interoperability.
• Leveraged ArcGIS and story maps for impactful visualizations.
• Chaired the Task Force for WALC visualizations and IT hiring committee, Dean’s award and Team’s award of $1000. Enurga – West Lafayette, IN Jan 2008 - July 2008
Programmer
• Customized software solutions employing Visual C++ programming on MS SQL Server. Purdue University – West Lafayette, IN Oct 1997 - April 2001 Programmer
• Engineered and debugged event management and space scheduling systems using Smalltalk on Oracle databases.
• Developed web pages in Perl to enhance student systems (SSINFO).
• Conceived the TRAX system to centralize databases across Purdue's departments.
• Generated comprehensive reports using Brio and Crystal Works.
• Mentored departmental staff on existing systems, fostering knowledge transfer and skill development EDUCATION
Missouri S&T, Rolla, MO – M.S.,Computer Science. 1992-1995 University of Bombay, Bombay, India – M.Com 1989-1990 VOLUNTEERING
Cumberland Elementary School
• Volunteered in Library, Copy Room, Computer labs and Classrooms. Montessori School of Greater Lafayette
• Volunteered to read, teach phonics and classroom help.
• Provided reading lessons to pre-school kids.
Indian Women’s Association
• Volunteered in Event’s Committee for 20 years
• Co-President of IWA for 2 years
Bharatiya Temple and Cultural Center of Greater Lafayette
• Volunteering in several roles for last 12 years as Trustee, Treasurer, Weekly Lunch Coordinator, Communications Team, Temple Events Team, Outreach with Purdue organizations and Students, Private Puja Services. SKILLS
• Tableau, Tableau Prep, Power BI, Python, Microsoft Fabric, Data Science, R, Java, Angular JS, PL/SQL, Perl, API Programming, XML, CSS, C++, C, IBM Cognos, Oracle BI Enterprise, Smalltalk, Brio, Crystal reports, Clipper, PowerBuilder, Dbase, COBOL, Basic, Pascal, PL/I, GDDM, ADA, MySQL, Oracle, Microsoft SQL server, Github, Gitlab, MARC, Dublin core, BIBFRAME, Drools, ArcGIS
• Project Management, Data Warehousing, Data Modeling, Collaboration, Big Data, Data Analytics, Information Systems, ETL Design, Schema Design, Object-Oriented Programming (OOP), Data Warehouse