JAMES C. MOHAN

732-***-**** •ad41wp@r.postjobfree.com

Woodbridge, NJ • linkedin.com/in/james-mohan/

Business Intelligence Reporting and Analysis

Accomplished NYU MBA with strong finance and computer science background with functional and technical experience in Looker, Snowflake, Kettle, Denodo and Oracle Receivables. Fluent in Spanish.

RESULTS

Produced over 4,000 scheduled or ad hoc reports for IDT’s business units using many different

platforms using Looker, Snowflake, Denodo, Pentaho Data Integration (Kettle) and SQL

Quickly became adept in cutting edge technologies including Looker, Denodo and Snowflake

Successfully managed over $100MM worth of credit portfolios

TECHNICAL TOOLKIT

Client-Server Programming: SQL • PL/SQL • Looker • LookML • Tableau • Birst • Brio • Hyperion Designer • Python • Pentaho • Kettle • PowerBuilder • Snowflake • Denodo • C/C++ • UNIX • VBA • JIRA • Oracle SQL Developer • SourceTree • GitHub • SCRUM • AppWorx • Braze/Appboy

Oracle Financials: Receivables Module / System Administration / Certified Oracle Forms 6i Developer

CAREER SYNOPSIS

PROFESSIONAL SERVICES GROUP OF CENTRAL NEW JERSEY, Somerville, New Jersey 2023 to Present

Technology Analyst (consulting pro bono 501 (c) (3) organization)

Employing Google Workspace, WordPress, SQL, Python, HTML and CSS to enhance and automate production of organization’s data and upgrade it’s website.

Member of Technology Committee focusing on providing membership and presenter data for scheduled and ad hoc reporting.

Compile Monday morning meeting attendance data for use by Marketing Committee

IDT CORPORATION/NET2PHONE, Newark and West Long Branch, New Jersey 2005 to 2023

Business Intelligence Engineer/Reporting Analyst

Generated over 4,000 scheduled reports or ad hoc data requests for IDT’s business units which met client volume and quality requirements and allowed them to make better informed business decisions.

Wrote complex SQL and PL/SQL code which provided business units with decision making capabilities.

Created robust reports with Brio to enhance business intelligence for business units.

Migration of Oracle data to Snowflake/Exposure to Denodo/Creation of LookML and Looker Explores:

Became proficient with Snowflake, Denodo and Looker central to new Business Intelligence mandate.

As part of the Business Intelligence department’s transition from being a reporting group to being a data procurement group, participated in the migration of numerous Oracle tables to Snowflake.

Migration entailed the use of Pentaho Data Integration (Kettle) and AWS.

Once the data was in Snowflake, it was exposed to Denodo (a data virtualization platform).

Created Denodo base views and business views which were exposed to Looker.

Wrote LookML code in Looker after exposing Denodo views.

Created Explores in Looker which enabled end users to create their own reports.

Converted dozens of reports from legacy reporting system to Looker Explores and Looks

Goal of self-service reporting for IDT’s business units achieved by the Business Intelligence department.

JAMES C. MOHAN • 732-***-**** • ad41wp@r.postjobfree.com

Woodbridge, NJ • linkedin.com/in/james-mohan

Page Two

ESTATE OF ARTHUR J. MOHAN, Glen Rock, New Jersey 2003 to 2005

Executor

Managed hospital/nursing home care for terminally ill parents.

Executed numerous responsibilities related to the settling of a substantial estate including the sale of the family home and the efficient distribution of all assets.

RUTGERS UNIVERSITY FOUNDATION, New Brunswick, New Jersey 2001 to 2003

Application Developer

Programmed in PowerBuilder and produced a series of efficient and effective DataWindows using SQL. The results of all programming assignments were employed by fundraisers to pinpoint potential donors.

Created vital reports for fundraisers which were used to produce mailings to potential donors.

Converted reports to PowerBuilder from legacy system to provide fundraisers with data continuity.

Produced ad hoc reports using SQL; reduced future programming time via versatility and reusability.

ENGELHARD CORPORATION, Iselin, New Jersey 1996 to 2000

Systems Analyst (1999 to 2000)

Quickly became proficient in supporting the credit department’s Oracle 7.3 Receivables module.

Successfully transitioned career toward IT by initiating a series of special projects which included:

* Managing the credit department’s intranet web page.

* Setting up Oracle-based system to produce collections letters and monthly customer statements

Credit & Collections Specialist (1996-1999)

Managed multi-million-dollar domestic and international account credit portfolio, exercising credit-granting authority of up to $200,000.

AMERADA HESS CORPORATION, Woodbridge, New Jersey 1990 to 1996

Credit Analyst

Managed $100MM credit portfolio of major accounts (government agencies, oil companies, airlines, utilities). Analyzed customer financial statements and evaluated credit standing to recommend lines of credit and terms of sale.

EDUCATION

MBA in Finance / International Business

NEW YORK UNIVERSITY, New York, New York

BA (cum Laude) in Economics / Spanish

BUCKNELL UNIVERSITY, Lewisburg, Pennsylvania

Advanced Technology Education:

AAS in Computer Science

MIDDLESEX COUNTY COLLEGE, Edison, New Jersey

Diploma in Client-Server Programming

CHUBB COMPUTER SERVICES / Top Gun School

Contact this candidate