Summary
Overview
Work History
Education
Skills
Timeline
Generic

Rajeev Krishnan

Summary

A versatile IT professional with over 20 years of experience in data analysis and software development within the Software Development Life Cycle (SDLC). Expert in designing and developing interactive dashboards and visual reports using tools such as Power BI, Tableau, and Excel, tailored to meet the needs of diverse stakeholders. Skilled at transforming complex datasets into clear, actionable insights, with a proven ability to communicate effectively with both technical and non-technical audiences. Extensive experience working with student data (Campus Solutions) and financial/procurement systems (KFS in MSUEDW). Strong background in data validation, cleansing, and quality assurance. Proficient in SQL, report automation, and backend optimization to support efficient, real-time analytics.

Overview

27
27
years of professional experience

Work History

Data Analyst

MSU, College of Education (CED)
10.2022 - Current
  • Company Overview: The College of Education (CED) at Michigan State University has been dedicated to preparing educators. The CED remains committed to enhancing education in our society.
  • Collaborating closely with departments and stakeholders to design and develop reports, and interactive dashboards present to diverse audiences, such as leadership teams, and other stakeholders.
  • Generating regular cadence reports and dashboards, including Enrollment, Graduation, Demographics, and other relevant data, each semester for the Leadership teams.
  • Generating ad-hoc reports in response to stakeholder requests.
  • Generating annual external reports for 'Title II (Teacher Preparation Programs) Fall' and 'Title II Spring' submissions to the National Teacher Preparation Data.
  • Generating data for the yearly external reports for the submission of the US News 'Best Online Education Master’s Program' and 'Best Graduate Program' rankings.
  • Generating data for the yearly external reports for the submission of the US News 'Best Graduate Program' rankings.
  • Querying and generating reports from multiple databases that encompass a diverse range of student data.
  • The College of Education (CED) at Michigan State University has been dedicated to preparing educators. The CED remains committed to enhancing education in our society.
  • Environment: Oracle SQL Developer, DBeaver, SQL Server, Power BI, Tableau, Excel Pivot.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Created dashboards to monitor and track key performance indicators.
  • Updated and developed scripts and queries to extract and analyze data from multiple sources.
  • Developed customized reports, summarizing and presenting data in visually appealing format.

Data Analyst / Information Technologist 1

MSU, University Procurement and Logistics (UPL)
02.2012 - 09.2022
  • Company Overview: University Procurement and Logistics (UPL) manages the Michigan State University supply chain, providing expertise in acquiring and distributing goods and services.
  • Collaborating closely with stakeholders to design, compose reports, and create presentations for diverse audiences, including the Department Director, Procurement team, and other stakeholders.
  • Extracted data from internal data warehouse system to SSRS.
  • Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization.
  • Collaborating closely with the Diversity team to create and analyze various reports.
  • Generating ad-hoc reports for Directors and Managers.
  • Engaged in UI design and database table creation for the Shipping application.
  • Managing and supporting a third-party application for Logistics, CAMS (SC Logic system).
  • Contributing to the Sustainability team, leading UPL’s sustainability initiatives by offering lasting supply chain solutions.
  • University Procurement and Logistics (UPL) manages the Michigan State University supply chain, providing expertise in acquiring and distributing goods and services.
  • Environment: Oracle SQL Developer, SQL Server, SSRS, Power BI, Tableau, ASP.net, Excel, Visual Studio.

Team Lead / Sr. Programmer Analyst

State of Missouri, Department of Social Services (DSS)
06.2011 - 02.2012
  • Company Overview: The Food Stamp and Disaster food stamp web application will provide a new intake interface application to deliver the DSS modernization effort of application components.
  • Designed and developed the GUI for Disaster Food Stamp applications.
  • Create and update new and existing stored procedures.
  • Participated in system UI design and the creation of database tables.
  • Developed mockup screens for Disaster Food Stamp applications.
  • Addressed bug fixes as identified by the testing team and clients.
  • Created Multilanguage, English and Spanish in Food stamp and Disaster applications.
  • The Food Stamp and Disaster food stamp web application will provide a new intake interface application to deliver the DSS modernization effort of application components.
  • Environment: ASP.net, Classic ASP, DB2, XML, XSLT, Visual Studio 2008, JavaScript, HTML/XHTML, CSS.

Sr. Programmer Analyst

MSU, Administrative Information Services (AIS)
08.2009 - 05.2011
  • Company Overview: OISS info is a web-based application used to maintain MSU’s international students and exchange visitors’ data.
  • Leading the team and serving as the primary resource for SEVIS (Student and Exchange Visitor Information System), OISS Info System applications, System Enhancement, and SEVIS II.
  • Interfaced with business users (Clients) to prepare and update Business Process Requirements and Software System Requirements.
  • Designed and Developed GUI for J-1 Department, OISS INFO using in ASP, XML and HTML.
  • Support and assist with the user acceptance testing (UAT) process to assure the successful delivery of all modules to the client.
  • Designed the Database and tables for J-1 Department. Create new tables, updated current tables, Views, Stored procedures and triggers for OISS INFO in SQL Server 2005.
  • Involved and maintained SEVIS application, for tracking and reporting foreign students and exchange visitors, in XML and VB 6.
  • Project tracking, Team coordination, Status reports to the Project Lead and project manager.
  • Managed work orders and provided customer supports.
  • OISS info is a web-based application used to maintain MSU’s international students and exchange visitors’ data.

Programmer Analyst/Web Developer

State of Georgia, Department of Juvenile Justice (DJJ)
04.2004 - 05.2009
  • Company Overview: Georgia DJJ provides supervision, detention and a wide range of treatment and an educational service for youths referred by the Juvenile Courts and provides assistance or delinquency prevention.
  • Team lead for Higher Sight Project.
  • Interfaced with business users (Clients) to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR).
  • Prepare design documentation: Work Flow, Data Flow, Process Flow diagrams.
  • Designed and Developed GUI using Web forms in ASP and HTML.
  • Designed the Database and tables for HS Application. Created tables, Views, Wrote complex stored procedures, queries, triggers for HS in SQL Server 2005.
  • Support and assist with the user acceptance testing (UAT) process to assure the successful delivery of all modules to the client.
  • Project tracking, Team coordination, Status reports to IT Director.
  • Managed DJJ work orders on various JTS modules and provided customer supports.
  • Georgia DJJ provides supervision, detention and a wide range of treatment and an educational service for youths referred by the Juvenile Courts and provides assistance or delinquency prevention.
  • Environment: ASP, ASP.net, SQL 2005/2000, XML, Visual Studio Interdev, VBScript, JavaScript, XML, HTML, IIS 6.0.

Sr. Programmer/ Business Analyst

Atreya Health Technology
07.2001 - 03.2004
  • Company Overview: Involved in development and testing of the EMR system, developed for AHT Technology, Dayton OH. This system is designed for physicians; to store their patient’s medical and personal details in a CD or smart card in the encrypted format.
  • Working with the client and coming up with clear requirements.
  • Design and Develop front end GUI using Web forms in ASP and HTML.
  • Designing the Database, Stored procedures and triggers in SQL Server 2005, SQL Server performance optimization.
  • JavaScript and VBScript are used extensively for client side validations.
  • Involved in complete Lifecycle Development using ASP, VB Script, Visual Studio Interdev and Java Script.
  • Conduct and participate in software design reviews to assure that the best technical approach and solutions are identified before starting the coding phase.
  • Solving the technical issues within the project.
  • Ensuring quality control in the deliverables.
  • Perform bug fixes as problems are discovered by the testing team or customers.
  • Involved in development and testing of the EMR system, developed for AHT Technology, Dayton OH. This system is designed for physicians; to store their patient’s medical and personal details in a CD or smart card in the encrypted format.
  • Environment: ASP, SQL 2005, Visual Studio Interdev, XML, XSLT, Visual Basic 6.0, VBScript, JavaScript, HTML, IIS 6.0.

Programmer

Dubai Marine
02.1998 - 04.2000
  • Company Overview: Financial Accounting system Involved in design, development, implementation & fine tuning of an on-line Financial Accounting system for maintaining information on banking activities, monthly cash ledgers, bill register payment registers, receipt register, general ledger, trial balance and balance sheet.
  • Design the screens and the tables to accommodate the new changes.
  • Designed and developed tables, constraints indexes and other database objects.
  • Designed and developed various screens for the application.
  • Design and Developed GUI.
  • Financial Accounting system Involved in design, development, implementation & fine tuning of an on-line Financial Accounting system for maintaining information on banking activities, monthly cash ledgers, bill register payment registers, receipt register, general ledger, trial balance and balance sheet.
  • Environment: ASP, VB, SQL server 2000.

Education

Bachelor of Science - Mathematics

Kerala University
India
05.1994

Post Graduate Diploma - Computer Application

NIIT
India
05.1996

Skills

  • Oracle SQL Developer
  • MS SQL
  • SSRS
  • Excel
  • Tableau
  • Power BI
  • ASPnet
  • HTML
  • DHTML
  • XML
  • Visual Studio

Timeline

Data Analyst

MSU, College of Education (CED)
10.2022 - Current

Data Analyst / Information Technologist 1

MSU, University Procurement and Logistics (UPL)
02.2012 - 09.2022

Team Lead / Sr. Programmer Analyst

State of Missouri, Department of Social Services (DSS)
06.2011 - 02.2012

Sr. Programmer Analyst

MSU, Administrative Information Services (AIS)
08.2009 - 05.2011

Programmer Analyst/Web Developer

State of Georgia, Department of Juvenile Justice (DJJ)
04.2004 - 05.2009

Sr. Programmer/ Business Analyst

Atreya Health Technology
07.2001 - 03.2004

Programmer

Dubai Marine
02.1998 - 04.2000

Bachelor of Science - Mathematics

Kerala University

Post Graduate Diploma - Computer Application

NIIT

Similar Profiles

CREATE PROFILE