Post Job Free
Sign in

Data Engineer

Location:
San Jose, CA, 95139
Posted:
March 09, 2011

Contact this candidate

Resume:

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



Contact this candidate