Financial & Operations Database Systems Professional with experience in
fast-past time-sensitive environments. Highly developed analytical and
problem solving skills in Business Intelligence, data retrieval, data
analyses, report writing, report automation, with attention to details and
time management. Highly proficient oral and written communication skills,
and works well in cross-functional teams. Insight into the users' data
needs, goals, and desired results with a strong understanding and interest
in both technology and applying it to business practices. Experience
includes all the phases of Software Development Life Cycle, numerous
software applications, change management, and assessing end-user needs for
financial systems.
Key Strengths Include:
. SQL/TSQL, Ad-Hoc Queries, . MS Visual Basic, .Net 2003, . MS SQL Server 200X Database
Reporting ASP Administration
. ERP, MRP, Time & Expense . MS Access, MS Excel, MS . COGS, Revenue, Inventory,
Administration Word, MS Office AR, AP, MRP
. Data Integration, . Data Imports & Exports . System Implementations and
Interfaces, and Conversions Upgrades
Career Highlights:
Application & Database Administration
> Successfully upgraded Costpoint ERP Application and MS SQL Database
software and Server in first three months.
> Created and implemented automated help desk application for IT
Department track calls, computer inventory, and allow for IT staff to
reset database passwords through a web interface.
> Automated collection and storage of multiple database permissions
allowing for instant security audit reporting reducing IT's time from
several days of collecting, analyzing, and reporting to instantaneous
reporting for regular monthly, quarterly, and yearly intervals.
> 25%+ Improvement in the IT's departments customer satisfaction for
data related issues with end users by providing personal interaction
with end users, expediting request where appropriate, and providing
estimated time of completion while allowing for reduction of staff
with estimated annual savings of $275K.
Sr. Programmer Analyst
> Through database automation, allowed for cost reduction in staffing by
20% (minimum annual cost savings estimated at $300K) while improving
overall efficiency approximately 80% by creating and implementing data
marts of the key elements used by analyst and staff.
> Developed a data mart and reporting system to pull together financial,
purchasing, manufacturing, and personnel data from multiple sources
for: reporting, application data feeds, and data extracts for finance,
budget, accounting, program controls, and operations with estimated
user time savings of 65%.
> Successfully converted program structures and related financial data
from CINCOM to Costpoint (ERP systems). Identified issues with how
financial data would not interface correctly with MPM (Earned Value
system) along with the lack of historic details going forward in
departmental reporting.
> Recommended and implemented an automated means of bridging financial
data requirements for MPM and allowed for the continuation of detailed
reporting that would not have been available after the conversion.
Financial Cost Analyst
> Developed standardized and customized data extracts from multiple data
sources including centralized Oracle ERP database, MS Access
Databases, and various MS Excel Models and workbooks providing
analysts with up to 75% more time to be spent in the analysis of data
and not the collection of data.
> Designed and implemented MS Access Database to summarize and report on
demand specific costs, key indicators, and stop-light reports used by
analyst and managers.
Technical Consultant / Software Engineer
> Developed and coded MS SQL conversion database that included: data
extraction routines from legacy MANMAN systems; data import routines;
conversion rules and routines; and, export final load files used to
load new ERP systems including SAP, MK, BAAN, and ORACLE.
> Developed and implemented a MANMAN HP Classic ERP Data Mart that
provided customers with financial reporting for audit purposes and
reporting of serialized product shipments in event of recalls.
Work History:
MK Technical (ITT-RSS & EDO, Financial/Programmer Analyst / 2 years
Morgan Hill) Consultant
ITT - RSS, Morgan Hill, CA ERP Application & Database 2 years
Administrator
ITT - RSS (EDO), Morgan Hill, CA Sr. Programmer Analyst 4 years
ITT - RSS (Condor Systems),Morgan Financial Cost Analyst 2 years
Hill, CA
JAS Systems, San Jose, CA Technical Consultant / Software 5 years
Engineer
Sony Electronics, San Jose, CA Technical Consultant Internship 1 year
Education:
Bachelor of Science, Business Administration / MIS
San Jose State University, San Jose, CA, 1995
Additional Classes: SQL Server 2005 Administration, MS Analysis Server 2008
and BI Solutions, SharePoint 2007 for Developers, CMMI, MPM Earned Value