Data Analyst Power Bi

Annapurni Subramaniam, Data Analyst

W. Lafayette, US, 765-***-****, *****@*****.***, https://www.linkedin.com/in/asubr/ SUMMARY Dynamic Power BI – Dashboard Data Analyst with over 14 years of experience in data analysis and visualization. Proficient in using Power BI, Microsoft Fabric, and APIs, with a recognized certification in DAX. At Purdue University, led data-driven projects that streamlined operations, driving meaningful insights through innovative visualizations. Proven ability to enhance user experience and support data storage processes. Eager to leverage analytical skills to deliver impactful solutions that meet organizational needs. WORK EXPERIENCE

10/2021 – Present Research Data Analyst and Visualization Specialist, Purdue University

W. Lafayette, IN

Conducting in-depth data analysis and crafting visualizations utilizing APIs, 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'.

07/2008 – 09/2021 Administrator of Library Enterprise Applications, Purdue University

W. Lafayette, IN

Orchestrated Tableau visualizations, OBI dashboards, and data analysis, including annual reporting and statistical digest for various departments and accreditation.

Customized, maintained, and troubleshot Library Cloud Applications across West Lafayette's eight libraries and PNW 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, while serving on various committees at Purdue Libraries and volunteering with PULSE and the Code4Lib Sponsorship committee.

Provided exceptional customer support and training for all staff, faculty, and students across Purdue Libraries, including implementing cloud software solutions for Purdue Fort Wayne.

Executed Tableau API integration and Oracle BI reporting, creating comprehensive dashboards and generating reports through Cognos and Brio.

Designed workflows and trained staff on library application software, demonstrating expertise with SharePoint and web APIs to enhance access to cloud data.

Collaborated on the textbook project with ITAP (campus project). Managed acquisitions, cataloging, and circulation functions across all libraries, ensuring smooth operations.

Certified in cloud software, demonstrating leadership, training, and mentoring capabilities.

Delivered ongoing customer service and training to library staff. Utilized Python, PL/SQL, and Perl scripting to streamline data conversion processes for accessibility.

Developed APIs and facilitated integrations, enhancing system interoperability.

Leveraged ArcGIS and story maps for impactful visualizations. Chaired the Task Force for WALC visualizations and the hiring committee for IT positions in Purdue Libraries, while contributing to the Pulse awards committee and Libraries APSAC.

01/2008 – 06/2008 Programmer, Enurga 47906

Customized software solutions employing Visual C++ programming on MS SQL Server.

08/2006 – 03/2008 Volunteering, Cumberland Elementary School West Lafayette, United States 09/2003 – 05/2007 Volunteered, Montessori School of Greater Lafayette

West Lafayette, United States

10/1997 – 04/2001 Programmer, Purdue University W. Lafayette, IN Engineered and debugged event management and space scheduling systems using object-oriented programming in Smalltalk on Oracle databases, optimizing scheduling processes for professors and students. Developed web pages in Perl to enhance student systems (SSINFO), initiating a digital transformation for student services. Conceived the TRAX system as part of a collaborative team to centralize databases across Purdue's departments, improving efficiency. Generated comprehensive reports using Brio and Crystal Works for staff stakeholders.

Mentored departmental staff on existing systems, fostering knowledge transfer and skill development.

07/1993 – 07/1995 Programmer Analyst – EDP Department, May Merchandising Company

St. Louis, MO

Analyzed, designed, and programmed multi-user meeting support systems utilizing Clipper and PowerBuilder, revolutionizing the conferencing capabilities for department store buyers nationwide. Provided technical support and software training during buyer meetings, enhancing user proficiency.

Diagnosed and resolved issues on other in-house systems while mentoring staff in best practices.

08/1992 – 05/1993 Lab Consultant, University of Missouri- St. Louis St. Louis, MO Assisted students with various software and systems across the campus, ensuring a productive learning environment.

07/1992 – 08/1992 Programmer, Department of Natural Resources Rolla, MO Debugged the Well Management system within a LAN environment, improving operational reliability.

Programmed enhancements in Dbase III Plus to upgrade the system. Resolved LAN issues to maintain seamless network connectivity. 12/1991 – 05/1992 Help Desk Assistant, University of Missouri-Rolla Rolla, MO Conducted short courses and assisted users, providing support to students, staff, and faculty on software and systems. 06/1991 – 08/1991 Graduate Assistant, University of Missouri-Rolla Rolla, MO Developed the CITE marketing driver using Pascal, showcasing technical proficiency.

Analyzed the 'FOURTH SHIFT' package to simulate a marketing environment, contributing to project insights.

05/1988 – 03/1990 System Analyst, Artson Engineering Limited Bombay, India Analyzed and designed Payroll, Tendering, and Share accounting systems, enhancing operational accuracy.

Upgraded financial accounting systems to improve processing efficiency. Facilitated employee training on all in-house systems, fostering user competency.

03/1987 – 04/1988 Computer Programmer, Choudhary International Bombay, India Developed the Payroll system, streamlining payroll processing. Maintained the financial accounting system, ensuring data integrity and accuracy.

06/1986 – 09/1986 Computer Operator, Weizmann Financial Resources (I) Ltd Bombay, India Maintained the financial accounting system to ensure continuous functionality.

Managed mailing lists, databank, and financial reports for all customers, providing critical support.

EDUCATION

1992 – 1995 Missouri S&T

M.S., Computer Science

Rolla, MO

1989 – 1990 Univ. of Bombay

M.Com

Bombay, India

1988 – 1989 Agrawal classes

Diploma, Computer Programming and applications

development

Bombay, India

1983 – 1986 Univ. of Bombay

B.Com

Bombay, India

SKILLS Microsoft Fabric Power BI

Tableau Tableau Prep

Data Science R

Angular JS Java

PL/SQL Perl

Python API programming

SQL XML

CSS Smalltalk

C++ C

IBM Cognos Oracle BI Enterprise

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 leadership

training communication skills

team player customer oriented

project management time management skills

mentoring Data Analysis

Data Visualization Reporting

Data Collection Data Management

Analytical Skills Attention to Detail

Dealing with Ambiguity Problem Solving

Graphic Design

Contact this candidate