Ms. Millie Mendoza

acappe@r.postjobfree.com

Mobile

801-***-****

[pic]

Position of Interest: Business Analyst/ERP Mapping/Data Analyst

[pic]

Summary

Ms. Millie Mendoza has a B.S. Electronics Engineering and education in

Finance. Her professional experience totals 20 years with 10 years in

Technology and 10 years in Finance. Holding certificates in financial

analysis, underwriting and quality for process improvement. SDLC experience

encompassing systems analysis, cost feasibility, design specifications,

business requirements for processes, programming, implementation, testing

and deployment. Implementer of BI solutions across multiple technologies,

collaborating in the development for OLAP Cubes and Service Oriented

frameworks to consolidate gaps between user requirements and

implementation. Result driven lead, writer and verbal interpersonal

communicator to execute integration of enterprise processes. Effective

communicator providing dashboards, Visio and Power Point presentations with

department report to COO, CEO and Board of Directors. Resourceful in

developing projects and defining portfolios. Creative SQL and procedure

language implementer with 3 years experience.

Education

B.S. Electronic Engineering

Brigham Young University, Provo, UT

Course Work: Statistics

Princeton University, Princeton, NJ

Career History

Marion County Hospice, Ocala FL- Business Analyst/Report Writer

2/2013 -11/2013

. Business process and intelligence implementer using SQLSEVER

2008/2012 SSIS,

SSAS, SSRS, SSMS, Adhoc and AllScripts management..

. Assessor for business process application requirements.

. Defining datasets, data frames, tables, views, procedures, data

sources, dimensions and report developer.

. Statistical programming in SAS and R.

. Implementer to fulfill Office of Inspector General Requirements.

. Provider for on call support 24/7 for users, systems and

applications.

. Manager and organizer for projects developing task, deadlines, status

and resources.

. Provider for IT Support framework and Windows Server 2008 networks.

. Implementer for IT help desk queries, asset types, views, forms and

processes in KACE.

Facilities Management Project University of Utah - Business-Data Analyst

Contractor 7/2012-1/2013

. Gathered requirements from department stakeholders and SME for the

implementation of a Facilities Management Database with MS SQL SERVER.

. Developed reports and cubes using SSRS and SSAS.

. Implemented reports and rendered data analysis for efficient resource

usage.

Aquent - DVC, Business Analyst Contractor

4/2012-7/2012

. Gathered report requirements from marketing and consulted with SME on

data sources.

. Data querying to identify customer trends through statistical analysis

to forecast, sample and define metrics. Tools used: MS SQL, SSRS,

Visio and Excel Data Analysis/dashboards.

. Implemented reports and rendered data analysis to facilitate apprised

marketing strategies.

. Analysis results presented to Marketing Manager using Power Point.

CR England Global Transport, SOA Business Analyst (Contractor)

6/2011- 8/2011

. SCRUM Software Development Methodology & Agile iterative

implementation of Business Process Management.

. Project scheduling and assignment of resources.

. Gathered requirements for business process implementation & flow

charts, defined use cases and acceptance testing criteria.

. Liaison between management and technical development.

. AS400 to MS SQL Server using TMW Enterprise Resource Planning

Management System.

. Designer and implementer of EDI systems and robust interfaces

utilizing associated models (schedulers, cost optimization agents,

systems engineering models, process models, financial models etc) to

evaluate multiple strategies and inform decisions at a detailed level.

. Defining test criteria, white box testing and processes.

. SQL/SSRS to research data & programming with VBA.

. Conductor of research for benchmarking the tactical strategies driving

the value assessments and project design

. Analyst to support Executives, Management with Business Process

Design/Data Mapping efforts.

. Mastered global transport principles to implement valid modeling,

workflows, business system solutions and apprised decisions.

. Used MS SSRS, SSAS, Visio, Word, TMW ERP, Power Point and JIRA for

project management.

Utah Transit Authority, EFC Business-Data Analyst & Systems Evaluation

2/10 - 04/11

. Defined traffic data metrics.

. Reviewed, researched, and supported urban mobility plans developed by

local governments for areas inside and outside transportation

concurrency management areas. Maintained current knowledge in

multimodal transportation planning and congestion management

alternatives.

. Scheduling for over 35 testers.

. Delivered traffic analysis, reports and reviews to COO and Board of

Directors of Utah Transit Authority.

. Liaison between Business Operations Management and Engineering.

. DMAIC project methodology and use of six sigma quality management

tools including: Data distribution-kurtosis & skewness, variable

dependencies-covariance & correlation and analysis of variance-ANOVA,

FTEST & TTEST.

. Gathered requirements for business process implementation & flow

charts, defined test scenario and acceptance criteria.

. Developed Multidimensional Analysis and dashboards using SAP Crystal

Reports, SAP SDK, Xcelsius & Power Pivot using Excel Data Analysis.

. Assessed Electronic Smart Card system functionality.

. Project lead conducting and defining test models, feasibility, user

documentation and follow-up evaluation.

. Quantified user acceptance testing for the Electronic Fare Charge

system: metrics, system model and evaluation.

. Developed user and system requirements using a requirement

traceability matrix. EFC metrics included: trip-construction,

location, terminal accuracy, account hot-listing, reconciliation,

usage and throughput.

. Queried from Middleware to determine real-time data accuracy and

efficiency.

. Implemented reports and dashboards to be published in SharePoint.

. Scope: Reviewed, analyzed and evaluated system performance through

Usability and Black Box testing.

. Developed risk mitigation plans to reduce system/process setbacks

including: time for analysis process, account credits and payments.

. Identified and tracked processes, operator/customer issues and

resolution.

. The EFC Analyzer reduced analysis time by 55% and improved issue

detection by 125%. Performed analysis to forecast revenue,

performance, usage and ROC. Application logic documented with Visio

and PowerPoint. The Analyzer was implemented using: SAS, PL, MS Sql,

SSRS, SSAS, VBA, Excel & BI Objects to extract from the data store and

card data from MetraNet.

Sykes & Associates, Analyst

8/09- 02/10

Case Analyst, Jury Shadow, Application Developer, Legal compliance and

Contract Manager, Legal Researcher and Class Action Manager. Developed

and integrated business processes for the implementation of a database

application. Developed database with MS Access and used PL/SQL for

queries. Used Visio to chart workflow.

University of Utah, Administration/Database Developer

4/09 - 12/09

Identified, improved and developed business processes such as: data

integration and database-FMAX/PeopleSoft import-export. Gathered

technical requirements and specifications for processes and system.

Interfaced with IT/developers for issue resolution. Implemented

database with Access, reports for cost/ employee performance analysis,

designed workflow charts with Visio. Automated PeopleSoft payroll

export to Excel VBA application. This increased the department's

operational process efficiency by 43%, improved tracking of each

building's operating cost and materials. Reduced expenditure by 30%.

Managed departmental operations such as: work schedules, payroll

reporting, prepared check rosters and budgets (GAAP), assigned service

request, organized records and prepared monthly reports. Revised and

added policies, procedures and plans for department goals. Performed

continuous business improvement projects for operations and

maintenance efficiencies and cost. Performed duties using Kronos [WM]

and prepared EPAFs for hire and termination. Trained employees to use

Campus Information System.

Millie Mendoza Commercial Lending, Owner/Manager

8/05 - 2/07

Commercial loan evaluation and placement. Managed contracts from

inception to closing. Oversaw Federal and State regulatory compliance.

Evaluator of asset performance, equities, market, volatility and

income forecast. Financial Analyst and presenter to funding committee

assessing credit risk, asset values, borrower's/business stability and

capacity to pay. Contract executor, negotiator & closer. Analyzed GAAP

standard documents: cost breakdown for development and construction,

county permits, budgets, business plans, operating statements, taxes,

P/L, cash flow, income analysis, statements of earnings, cap rate,

income projections, NOI, reserves & balance sheets. Project funding

capped at 30 million. Ex. Independence Square Office Park, Hotel Park

City, Highland Market Place and Canyon View Condos.

City 1st Mortgage, Loan Officer/Financial Analyst

8/05 - 11/08

Business development, loan origination, loan processing, ordered

reports/insurance and reviewed close documents. Managed contracts from

inception to closing. Oversaw federal and state regulatory compliance.

Analyzed, interpreted and assessed financial information GAAP

standard. Gathered financial data, tax information and credit

documentation for qualification. Reviewed and initiated the creation

of loan documents for legal, structural considerations assessing their

compliance with policies and regulations. Product experience includes:

residential land development, construction and commercial loans. Used

automated valuation systems to determine and forecast property values.

Processed loan files with Loan Soft and CredCo. Used Goldmine for

account development.

GMAC Mortgage, Loan Officer/Financial Analyst

8/04 - 7/05

Identified markets and demographics for business development. Managed

contracts from inception to closing. Oversaw federal and state

regulatory compliance. Account Manager for a portfolio of 78

commercial accounts including: Developers, representing agents,

investors, construction companies and businesses. Underwrote and

analyzed data to determine risk and loan placement. Submitted

documentation for condition approval and funding. Reviewed, analyzed

and edited closing documents. Used Loan Pro, CLOUT, AssetWise/DU/LP

for loan processing and underwriting.

Mortgage Financial Group, Loan Officer/Financial Analyst

9/98 - 7/04

Originated loans with FHA, VA, Utah Housing, HUD Grants, Redevelopment

Agency Grants, taught First Time Home Buyer and Rural Housing Programs

with Salt Lake County Housing. Managed contracts from inception to

closing. Oversaw federal and state regulatory compliance. Used Calyx-

Point for loan underwriting, processing and tracking. Used ACT for

business development.

Critique Medical Case Management, Data Analyst/Database Developer

3/00 - 9/01

Executor of continuous business process improvement that rendered

increased throughput in operation, reduced maintenance and cost.

Liaison between case managers and IT. Gathered requirements for

business process implementation, streamlined critical patient case

procedures, record tracking and worked with case managers to develop

Clinical Data Management application. It included Insurance letters,

case budgets, Clinical Report Forms, database/dataset and queries.

Improved intake time by 30% and tracking time by 150%. Used ICD-9,

CPT codes, MS Access, SQL, ad-hoc & Excel.

Atkinson Electronics, Siemens/STAEFA Controls Engineer/Process Analyst

12/98 - 3/00

Implementer of control systems with continuous process improvement

that rendered precise throughput in operation, reduced maintenance and

cost. Implemented energy efficient building automation for

temperature, security, pressure and lighting. Integrated functionality

with SCADA system and Ladder Logic abiding ISO 9000. Ex. Prowswood

Building 6440 Wasatch Blvd & Granger Medical Clinic 3725 W 4100 S,

West Valley, UT. Used: Apogee Native BACNet, Staefa MS-1800

Combination, NCRE system controllers, DDC, VAV, MUX, fan coil

controllers, HVAC control valves, zone actuators, valves, duct and

outside air sensors.

Primavera SureTrak Project Management, Software Engineer

11/97 - 11/98

Facilitated JAD sessions. Implemented OLE Pivot module and Objects for

PMS. Used C++ & VB.

Tenet Medical Information Systems, Software Engineer

11/95 - 11/97

Facilitated JAD sessions for development. ERP data integration to

streamline patient's admission, billing, Labs, procedures,

prescriptions, diagnosis and release. ETL SQL to Oracle. Used data

sets, C++, PowerBuilder, SQL, assembly and VB.

Hill Air Force Base 84th RADES Radar Evaluation Squadron, Software /Radar

Engineer 8/93 - 11/95

Facilitated JAD sessions for development. Designer-Implementer of

Radar Evaluation/Test & Remote Control to improve radar sensitivity,

azimuth, resolution, range and speed. Used ARCGIS and real time data

to evaluate performance. Developed testing procedures according to

metrics and code using C ++, VB, assembly language, Symantec & Borland

compilers on Windows NT. Used Smith Charts and LaPlace transform for

radar parameters. Microwave & Fiber optic transmitter-receiver

communication system.

Rockwell International Allen Bradley, Inside Sales Engineer/Process Analyst

10/92 -10/93

Created quotes and bids according to system specification. Responsible

for account management: over 80 distributors, 150 Clients and bids

under 20 million. Presented bids and designed systems for clients such

as Kennecott Mining. Used: SCADA Systems - Ladder Logic Programming,

Smart micro controllers, Centerline, Industrial Controls, AC/DC Drives

soft stop/start, sensors, photonic sensors to implement manufacturing

and mining solutions.

Military Duty

US NAVY

Awards

Hoffman La Roche Scholarship & True North Academy Sales Award

Certificates:

Financial Analysis, 2002, 2005, 2007

Real Estate/Leases/Contracts & Utah Law, 2008

Allen Bradley MCC, Advanced Product and Industrial Controls

Microsoft Office Professional: Outlook, Excel, Word, Access, Microsoft

Money, Power Point, Windows CE

Siemens Building Technology

Associations:

Women in business, Salt Lake Chamber of Commerce

Women Building Communities

Institute of Electrical & Electronic Engineers, IEEE

Brigham Young University Management Society

University of Utah SWE Women in Engineering

Community Volunteer

Freedoms Foundation at Valley Forge . KRCL Community Radio . Board of

Realtors Government Affairs Committee .Christmas in July& Shrimp-Fest

for the Road Home . Latin Alliance . East Indian Association-U of U .

BYU Alumni Association

Contact this candidate