Project Manager Oracle

Professional Profile

A seasoned IT professional offering over twelve years of experience in

Information Systems management, Technology implementation, support,

validation and administration. Professional experiences include

consulting, application development, Business Intelligence (BI) reporting

and analytics, ERP implementation, SDLC software development, programming

and management in industry, government, education, financial sector,

manufacturing, healthcare, pharmaceutical and telecommunication sector.

Professional Employment History

November 2009 - Present, Consultant MK2 Technology, Cleveland, Ohio

. Consulted on Banner HR/Payroll implementation and go-live for

Otterbein University. Converted

legacy data from (SCT) Plus to Banner 7.x. Reported to CIO as team lead

with data conversion and population to banner tables maintaining data

integrity. Troubleshot payroll disposition errors, HR deduction and

benefit administration issues and performed data integrity testing.

Consulted clients on how Banner interprets data to accommodate client

business processes and nuances. Helped clients go from Banner 7.x to 8.x

upgrade. Prepared clients for ODS and EDW go-live. Developed and deployed

Argos reports to be compliant with Federal and State reporting

requirements.

April 2009 - November 2009, Freelance IT Consultant, Project Manager and

Application Developer

. Consulted on Banner Student, Finance, HR, Financial Aid, Alumni,

Banner ODS/EDW implementation projects as technical and

functional consultant and project Manager. Performed legacy data

conversion and population to Banner tables. Troubleshot as first

level support consultant in Banner issues resolution, Banner

payroll disposition error correction and data integrity testing.

Advised clients as a Project Manager and IT consultant on Banner

7.x to 8.x upgrade and Oracle Database migration. Prepared

clients for ODS and EDW go-live. Clients include Lehigh

University, Dennison University, Wilberforce University, Stark

State, Thompson Rivers University, Alabama A&M.

. Trained functional and technical staff on Banner HR, Payroll,

Position Control, Self Service, Web Time Entry, EPAF, Finance and

Financial Aid crossover, forms navigation and best practices.

Teamed with local IT resources assisting in legacy data

conversion through Converter tool and technical problem

resolution. Clients include Dennison University, Wright State,

University of Dayton, Seton Hall University and Qatar University.

. Developed analytical and metric reports using Argos 3.x, Cognos

8.x, Crystal Reports 11, Oracle Discoverer, Micro Strategy,

Oracle APEX, MS- Access and Hyperion.

. Steered projects with SciQuest e-procurement implementation and

interfacing product with Banner

Finance, Commercial Off The Shelf (COTS) applications and turnkey

solutions for Ohio University.

. Served as lead ERP strategist, Banner consultant, programmer,

Data Warehouse analyst and Argos BI reports Developer for

Advancement & Alumni office, Lehigh University, Bethlehem,

Pennsylvania. Consulted on strengthening the financial position

of University endowment and ongoing campaign.

March 2007 - March 2009 Principal Consultant, SunGard HE, Malvern,

Pennsylvania

. Principal consultant for Sungard Higher Education, a fortune 500

company with 6 Billion Dollars (US) in revenues and has a global

presence in over forty countries.

. Consulted Sungard Banner ERP and Data Warehouse implementations,

programming and development, preparing and training clients for go-

live. Led and steered Banner projects that are complex

implementations that deviate from vanilla implementation requiring

client modifications and retrofitting Banner to large institutions

or Board of Regents. Assisted local Project Management teams with

challenging implementation issues. Consulted on implementing Banner

(7.x/8.x) General, SIS, Financial Aid, Finance (AP and AR), and HR

(and Position Control) modules, reporting tools, DW components and

ancillary applications with Banner.

. Conducted onsite training on various Banner modules, Oracle FGAC

security and Data Warehouse components. Developed and deployed BI

reporting portals, e-commerce sites driven by metrics for strategic

decision making using Cognos BI suite, Oracle Discoverer, Argos,

Hyperion and Crystal Reports. Assisted implementing and scheduling

jobs in Oracle Scheduler and AppWorx. Developed analytical and

metric reports for Institutional Research (IR). Helped client IT

departments with go-live initiatives and integrated products under

Banner SOA architecture and Banner customizations.

. Authored, evaluated, developed and deployed a validation and change

control, work order systems

and documented protocols, user guides and training material.

. Sungard clients include Colorado Community College System and Board

of Regents, Tennessee

Board of Regents, University of North Florida, Western University of

Health Sciences, Nassau Community College and institutions of SUNY

system, Alabama A&M, Foothill deAnza Community College, Alabama A&M

University, Salt Lake City Community College, Lamar University and Lamar

State College, Thompson Rivers University (Canada), Hamilton College,

Wright State University, University of Dayton, Kent State, Missouri

State University, Devry University, Cuyahoga Community College, Oklahoma

University, Sierra College, Texas A&M, Yavapai College, California State

University System

March 2006 - March 2007 IT Consultant/Project Manager, Robert Half

(RHMR), Nashville, Tennessee

. Consultant, Senior Programmer/Analyst and Project Lead for

Alkermes, a Bio- Pharmaceutical CGMP manufacturer and healthcare

distributor. Helped take Alkermes' IS and IT implementation to the

next level. Consulted on Trackwise on Oracle 9i, BI report

development, Noetix, Sharepoint, Crystal Reports, Business Objects,

MS-SQL Server and Oracle RDBMS. Gathered user requirements for

analysis and designed applications, information content, databases

and reporting portals over the Web with an in-built system's rules

engine adaptable customizable to mimic business operations using

.NET, ASP, ActiveX, XML, SQL Stored Procedures, VB and Java script

and LDAP. Led a RFID Clear Label Manager barcode project for

inventory and logistics in supply chains. Designed, developed,

budgeted, presented projects to stakeholders on new project

implementations and trained functional and technical users. Managed

projects initiation to close with minimizing risks, managing

change, consulting on change controls, documenting and validating

projects for FDA compliance and regulations.

. Project manager on implementing and integrating SciQuest Higher

Markets e-Procurement solution integrated with Banner Finance

module at Middle Tennessee State University (MTSU). Integrated e-

procurement vendor portal to link with Banner FOAPAL elements.

Executed project from start to close in accordance with the project

charter within budget, timeframe and available resources for

deploying solution enterprise wide for Purchasing and Auxiliary

Services. Authored user guides and introduced a training

curriculum. Trained, managed and launched a campus wide marketing

blitz, project launch and gala for a successful systems

implementation and minimize systemic risks.

. Developed, marketed and trained internal resources on the products

and consulted on building institutional workflows, modification of

business processes, practices and operations by optimizing on

required customization and integrations with vendor sites, LDAP

and web services.

June 2005 -March 2006 Banner Consultant, Robert Half (RHMR), Nashville,

Tennessee

. Consulted on Banner Student Information System (SIS), Finance, HR

functional and technical implementation. Assisted IT departments

as a local resource for a successful implementation. Migrated data

from SCT Plus to new Banner environment. Programmed and developed

scripts, reports and assisted with Banner implementation project

with Tennessee Board of Regents (TBR) and other affiliated

institutions. Served as on-site Banner Consultant in HR, Payroll

and Finance go-live. Developed reports and deployed on the web

using Self service Reporting and document management and content

portal. Consulted on Banner functional and technical areas for

Human Resource, Position Control, Payroll, Finance crossover.

Resolved day-to-day Banner administrative issues. Authored training

materials and conducted functional and technical training. Helped

IT departments with go live initiatives by assisting data migration

and conversion issues with Banner Converter tool, data mapping and

technical trouble shooting.

January 2000 - April 2005 IT Department, Wilberforce University,

Wilberforce, Ohio

Programmer, Project and Enterprise Manager- Administrative Systems

. Led a four person team implementing SCT Banner with General, Student,

Finance, AR, Financial-Aid, Security, Workflow, Campus Pipeline,

Evisions and Self Service reporting modules run on Oracle 8IAS

Database, Oracle Forms and Reports Server powered by IBM P650 and IBM

RS/6000 servers. Served as a Systems Administrator on Red Hat Linux 7,

Solaris 8, and IBM AIX 4/5. Tasks included troubleshooting shell

scripts, data migration and resolving performance issues.

. Developed reports, fine tuned Banner Object Access Views, developed

user interfaces, EDI and data loads, and business reports in SQL,

PL/SQL, Oracle Forms and Reports 6i, Proc*C, PERL, Visual Basic and

JavaScript using object-oriented programming concepts. Used Rational

Rose and Visual Architect to draw case diagrams for database

architecture. Reviewed and approved code testing by development teams

before final deployment.

. Performed junior DBA duties such as performance tuning,

troubleshooting, integrating auxiliary applications, applying patch

updates across database instances. Implemented procedures for data

loading operations, and enforced integrity standards across Oracle and

SQL Server databases.

. Used SQL*Loader ETL tools for uploading data into multiple database

instances, and executed scripts and stored procedures to eliminate

duplicate records of data that violated integrity standards.

. Designed and implemented MS-Access databases to monitor and better

manage Banner Security classes to streamline Finance, Student and

Financial Aid modules.

. Resolved database performance issues and limitations in ERP solutions

by tuning and applying software patches. Liaised between SCT and

Metalink for technical support.

. Assisted DBAs, developers, and system analysts with business

intelligence tools, data mining, and data warehousing strategies to

develop reports using Oracle Developer, Discoverer and Application

Express.

. Consulted on IT solutions and strategies to increase revenue and

optimize performance in Finance, Accounts Payable, Accounts

Receivable, Procurement, Financial Aid, e-payment and supply chain

logistics. Managed staff, vendor licenses, leases, negotiated

contracts and maintaining customer relations. Filled in for the CIO on

IT and Banner steering committees, IT oversight committees as

consultant and spokesperson.

May 2000 - April 2005 Adjunct Faculty/IT Consultant (Part Time) - CLIMB,

Wilberforce University, Ohio

. Served as adjunct faculty for Adult and Continuing Education

instructing following courses: Visual C++ programming, Visual Basic

.NET programming, Operating Systems, Systems Analysis and Design,

Oracle Academic Initiative (Database Management, Developer Forms and

Reports), Telecommunications, Networking, Data Communication, seminar

and independent thesis project.

. IT consultant to Continuing Education in curriculum development,

distance learning strategies, operations management, authored and

evaluated grants and fund raising strategies from federal, state,

corporate, health care, non-profits, foundations and sponsored

research.

. Advisor to Vice President of Academic Affairs on curriculum

development and strategic IT trends in the corporate sector to

streamline distance and e-learning trends, and consulted on

strategic intellectual property investments and streamlining course

content with other Climb satellite offices.

. Implemented Oracle OLTP solutions, Blackboard, SSL security,

Skillsoft and WebCT online course content, and BI analytical tools

and E-commerce strategies that helped increase revenues and

enrollment.

September 1998 - December 1999 Finance Department, Wright State

University, Dayton, Ohio

Graduate Research Assistant/Adjunct Lecturer

. Developed Visual Basic applications using ADO's and ActiveX components

with MS-Access to create financial simulations that interacted with

stock market simulation software and extracted financial data from

Stock-Track and the Edgar Online Database.

. Designed and implemented a database to track student payrolls and work-

study programs using MS-Access. Excel macros were written for matrix

reporting using VBA for front end users.

. Teamed with faculty on research projects specializing in corporate

finance, investment and portfolio management, acquisitions and

mergers, capital budgeting, financial accounting, and commercial

banking.

. Served as an adjunct lecturer in researching and interpreting

Corporate Financial statements and Investment Strategies in stocks,

bonds, derivatives, futures, mutual funds, hedging, securities, IPO

pricing and evaluating risks in portfolio management.

Education and Background

Masters - Management Information Systems and Business Administration,

Wright State University, Dayton, Ohio

M.B.A concentration in Finance, Wright State University, Dayton, Ohio

B.S., Engineering Physics, Slippery Rock University of Pennsylvania,

Slippery Rock, Pennsylvania

Training and Certification

Cognos BI 8 Report Authoring and Administration - IBM Cognos,

Philadelphia, PA

ClearOrbit Label Manager Barcode/RFID Technology - ClearOrbit, Austin,

Texas

SunGard/SCT Banner training: Student, Finance, Financial Aid, HR, Luminis

and Alumni - Malvern PA,

Sungard HE ODS/EDW and Enrollment Management with Cognos cubes,

Rochester, NY

Sungard HE Degreeworks Training

Oracle 8i Database Administration and Oracle Developer 2000, Oracle

Corp., San Francisco

Oracle SQL, PL/SQL blocks, Forms and Reports, Oracle Corporation, Troy,

Michigan

Ohio Super Computing, OARNET and Third Frontier Networks (2005) - Ohio

State University, Ohio

Summary

Operating Systems: Windows XP/Vista, AIX, UNIX, Linux (Red Hat), Solaris,

MS-DOS, Novell

Hardware: IBM RS/6000, IBM P650, IBM Netfinity 5000, IBM AS/400, Sun

Microsystems, IBM PCs, Dell and IBM Blade servers, SAND, RAS servers,

SPARC processor based machines, Cray cluster - Ohio.

Computer Languages: SQL, TSQL, SQL*plus, PL/SQL, Pro*C, Visual Basic,

.NET, ASP.NET, C, C++, PERL, JavaScript, HTML, XML, Essbase, ABAP

RDBMS: Oracle 7.x/8i/9i/10g, MS-SQL Server 2000,'03,'05, DB2, MYSQL, IBM

UniVerse

ERP Systems/solutions: SunGard/SCT Banner, Banner Self Service and

Luminis, Oracle Process Manufacturing, SciQuest Higher Markets, SAP BW,

Seibel CRM, Degreeworks, Resource 25, TrackWise 5/6/7.0, Oracle e-

Business Suite, CBORD

Reporting Tools: Cognos 8 BI (Query, Report, Analysis, Metric Studio),

Cognos - Connection, PowerPlay, Framework Manager and Transformer, Oracle

Forms and Reports, Oracle Discoverer, Argos and MAPS server, Crystal

Reports XI, Business Objects, Micro Strategy, Noetix, Hyperion (and Brio)

Tools/Applications: Cognos 7.x - Impromptu and Powerplay, Oracle

Application Express (APEX), Microsoft Exchange Server, MS-Office tools,

MS-Outlook, MS Access, IIS, Lotus Notes, SharePoint, AppWorx, TrackIt,

SAS, SPSS, Mathematica, Matlab, Rational Rose, Visual architect, AutoCAD,

Origin, SQC Pack, Six Sigma

Development Tools: PL/SQL editor, SQL Developer, Oracle Forms and

Reports, Oracle Warehouse Builder (OWB), Oracle ETL tools, Banner Web

Tailor, AppWorx, APAC, Apex SQL, TOAD, Visual Studio .NET, Visio, Visual

Architect, Oracle Developer and JDeveloper, Dreamweaver, Adobe

Authorware, CSS

Other: Unix, Linux, Apache JServer, RAID, LDAP, DegreeWorks, Schedule 25,

Add-Astra, LAN/WAN networks, SSL, Kerberos, Symantec-Ghost, Blackboard,

DARS, WebCT, Document Management System, Evisions-TouchNet and

Intelicheck, E~print, Pocket Recruiter, VeriSign, Clean-Address (Runner),

Utimaco Encryption, EDI, E-commerce, Quality Control and Quality

Assurance, ISO 9000/9001, WebEx, GoTo Meeting

Network/Telecom: Novell, MS-Active Directory, TCP/IP, VOIP, WIFI, PBX,

MTSO services, Packet Switching, Token Ring, Parallel and Serial

Communication, BlackBerry Enterprise Server

References

Jon P. McClintock (614)- 823-1464 Email: ***********@*********.***

Director, Administrative Computing, Otterbein University, OH

Michael Boehm 614-***-**** Email: *****@*****.***

Former CIO, Otterbein University, OH and Kent State OH, Lakeland

Community College, OH

Warren Lord 703-***-****

Director Enrollment Services - Seton Hall University, NJ, USA

Former CIO of Central State University, Wilberforce University and

Hampton University

Dr. Kamal Fernando - 937-***-****

Application Development and Project Lead: Online Learning Web Systems -

AC Neilson

Wright Patterson Air Force Base (WPAFB) and Fellow of the Mechanical

Engineering Consortium ABET.

Greg Lurie, CPA - 615-***-****

Senior Principal Consultant and Practice Manager, Managed Solutions,

SunGard Higher Education, Florida, USA

Former CFO, Belmonte University TN, Limpscomb University TN, Fisk

University, TN.

Contact this candidate