Experience
Worldwide Machinery Business Analyst Houston, TX September 2015- Current
1.Review and price quotes for pipeline, construction, mining, and other heavy equipment project
a.Review and consult current or future bids with internal sales team to understand client's long term and short-term goal regarding their projects.
b.Consult with upper management best approach to give best possible prices to clients offering several different financial options for customers including rental, sale, leasing, buy back, logistics, international costs (taxes, VAT), etc.…
c.Setup and update detailed spreadsheet highlighting machine's market value, netbook value, original costs, manufacturer's information, specification, and status to summarize project package worth for upper management.
d.Create several quote templates to make each quote look attractive and presentable.
e.Submit quote with a 24-48 hour turn around and follow up with client adjustments and suggestions.
2.Manage quote progress, status, and reports
a.Organize master spreadsheet to track each quote based on priority, ensuring high alert quotes are completed promptly.
b.Create bi-monthly report on quotes submission and resolution for upper management.
c.Assists internal operations team to make ad hoc reports including current and future machine income, duration on project site, quantity, etc.
3.Develop several tools and template to automate daily processes
a.Create and update table of machine's status and financial information in our fleet to have information organized and ready to quote.
b.Input and update table with completed quotes information to be used for future quotes regarding pricing, costs, and rates to accurately price machines based on the market (North America, South America, Europe, Middle East, etc
c.Develop SharePoint website to automate quote request for sales team to ease managing and tracking quotes.
d.Work with developers to update current database with new fields based on upper management requests.
Primary Services Load Analytics for ENGIE (Contractor) Houston, TX July 2014 - July 2015
1.Evaluated commercial and industrial power consumption profiles within NEPOOL and NYISO power markets
a.Experience handling and managing issues with large quantities of electric usage data.
b.Understanding of energy market fundamentals, including load properties (e.g., usage, demand, load factor, voltage, losses and read cycles) and deregulated market design.
2.Processed historical scalar and interval data from utility companies into ENGIE Oracle systems and SQL based data parsing system, as well as troubleshooting issues and working directly with IT to resolve issues.
a.Researched, maintained, and updated internal tables of key attributes across multiple systems and databases.
b.Exposed to SQL through our pricing system and our data loading functions through in-house SQL queries.
c.Accurately processed customer account and historical usage data to be used in forecasting, pricing, and contracting with LodeStar (Oracle Data Management and Forecasting Software).
d.Reported issues and tested bugs via SharePoint with Siebel (Oracle Customer Relationship Management Software).
3.Analyzed and reviewed variances between historical data and forecast data to determine whether each account can be priced properly and prevented ENGIE from over or under hedging when selling power to our clients
a.Analyzed hourly usage data to identify anomalies, potential metering issues or fundamental changes in usage patterns.
b.Performed data manipulation related to incomplete or flawed load data or related to load adjustments.
4.Communicated with utility companies and internal groups (e.g., sales, pricing, and IT) to meet deadlines and to comply with Operations quality standards.
Burnett Staffing Systems Analyst for Stewart Lender Services (Contractor) Houston, TX September 2013 – June 2014
1.Processed numerous client’s loan request to meet business deadlines.
a.Reviewed excel data file type based on specific types of loans.
b.Scrub data files to make them database ready.
c.Provided direct reports to clients with status updates and completed work via e-mail and shared folder system.
2.Imported client’s data file bulk into database to be modified accordingly.
a.Ensured loan import is successful utilizing SQL to identify any extraneous loans.
b.Revised and implemented corrections that is not passed by quality control to resolve loan data issues.
c.Generated PDF sample loans from the clients excel data to be reviewed and set to printing department.
3.Resolve day to day technical issues within the Stewart Lender Services division’s applications and processes.
a.Identify recurring technical issues that need new ways to automate and ease monitoring of applications.
b.Work closely with Software Developers and Project Managers, ensuring Stewart Lender Services Division’s technical needs are met.
c.Deploy Document Templates prepared by the Business Analysts.
Certification
IBM Watson Analytics – Level 1
Education
University of Houston May 2012
Bachelor of Science in Mathematics with Option in Mathematical Finance
Minor in Economics
Skills _
Excel, Word, Outlook, SharePoint 2013, SQL, Oracle Data Manager Tool, Windows OS, Financial Analysis