Analyst

Abraham Murguia

**** ******** ******** **

Missouri City, TX 77459

Cell: 832-***-****

advch9@r.postjobfree.com

Experience:

North Texas Investors December 2018 – Current Houston, Texas

Real Estate Investor

Currently I’m a part owner in this company where we focus on Real Estate wholesaling deals and fix/flips. We focus in all Houston counties and its surrounding areas.

My day to day duties are managing 3 employees that perform outbound calls and administrative duties such as pulling excel reports, performing vlookup functions for various purposes. We have trained our employees to search for people who are interested in selling their properties that may be in distress. Once we obtain leads in our pipeline, appointments are set to speak to the seller/s in person or phone.

Conduct cold calls on a daily basis searching for motivated sellers who may be interested in selling a property. I also go door knocking a few days out the week when not making outbound calls to speak with property owners who are in the process of a foreclosure. I speak to them to offer our services where we could purchase their property prior to the foreclosure in an attempt to save their credit and in the process, them making money if they decide to sell the property with us or a real estate agent.

As I arrive to a property, I conduct an inspection indoors and outdoors looking for mayor issues with the foundation, walls, ceiling, electrical, etc. Once we assess damages. we then enter what repairs are needed on an excel spreadsheet with formulas that calculates the repair estimate.

Before giving a seller an offer, I run comparable sales (similar houses sold) to come up with our ARV (after repair value) by using Propelio, Prop stream systems and the MLS (multiple listing service). We also collaborate with Real Estate agents to obtain accurate information on comparable sales within a certain specific radius.

When we have a property under contract, we send the property details to cash buyer investors who are looking for houses at a discounted price for fix and flip opportunities. We set a viewing/inspection for the property so that investors can come in and view the property and conduct their inspections. We are there to help with any questions or concerns they may have.

Once an offer is accepted, we write a purchase and sale agreement, email it to an investor friendly title company to start the title search to look for liens, judgments or any reason why we would not be able to close on a property.

I stay in contact with the seller & title company throughout this process in case they have questions or concerns about the closing process.

Constellation Energy January 2013 – October 2018 Houston, Texas

Mass Market Operations Analyst

Monitor and execute day-to-day workflow activities and control reports, managing medium to complex exception handling activities. This includes system exception queues, activities, service requests or emails from utility supplier support contacts and coordination with other internal functional teams.

Participated in testing projects for at least 5-6 markets in the transformation phase in the transition of systems from Siebel to Genesis. Currently, I participated in regression testing for COH (Columbia of Ohio) market.

Responsible for monitoring and analyzing Electronic Data Interchange (EDI) transactions related to the on boarding of Commercial, Business and Residential retail Customers between sign up/contract execution.

Provide key performance indicator (KPI) metrics to the team for reporting analysis, documentation and presentations for management and team meetings.

Responsible for redefining business processes to align with changing business needs through tasks such as application work requests (AWR & Heat tickets) for system changes, bug fixes, enhancements and business maintenance.

Provide Customer level support by researching and responding to Customer inquiries, account issues, including Customer specific management, reporting and account reconciliations for rate corrections and account status.

Participate in projects to provide system enhancements and bug fixes as subject matter expert including tasks such as writing business requirements for system changes, creating user acceptance test cases and regression test cases. Work with Business Execution and Information Technology teams to implement projects on schedule

.

Provide communication and training to the team (including new employees) on systems and process changes and enhancements. Evaluate alternative courses of action and direct team members on appropriate resolution paths.

Coordinating information requests from multiple internal departments, and working with external parties such as utilities and third party vendors to ensure enrollments, drop & price plan change requests are processed and accepted with utilities.

Work closely with IT, Customer Care, Collections, Sales and Marketing to identify issues and assisting with root cause analysis of errors by working with upstream groups to prevent them from recurring.

Ensure that all Sarbanes-Oxley (SOX) key controls and other company policies are followed. Review and comprehend UDC/ISO market rule changes and ensure system processes are following current market requirements.

Gexa Energy - August 2005 - December 2012 Houston, Texas

Associate Business Account Specialist Team Lead

Researched and resolved enrollment and drop transactions of commercial & residential accounts to identify customers eligibility for disconnection of non-payment and move out transactions.

Prepared spread sheets, graphics, and word documents as required for tracking, reporting, analysis, documentation and presentations.

Analyzed closed accounts 60+ days in aging for possible bad debt/write off, bankruptcy, balance transfers and deposit waivers.

Assisted in creating process & procedures documentation for current or new work flows for Commercial & Residential reports across markets.

Responsible for running weekly and daily declined payment reports to assist with collecting Customer funds to prevent additional bad debt.

Collaborated closely with marketing group, Customer Service and Contract Administration Departments to accurately proofread service agreements, marketing letters, and IVR scripts in Spanish and English.

Speaker for new hires of residential customer service representatives regarding the daily job duties which impact and support departments within the accounting group and company.

Obtained customer credit information from customers to support credit reviews (using Experian and metro-net systems) for Commercial, multifamily accounts verifying payment history, deposits, disputes & ownership changes.

Analyzed financial data to assist with reporting for dollars collected for accounts dealing with PUC & BBB complaints.

Calculated and prepared entries expenses revenue related to retail power on final KWH usage to refund deposits for Commercial and Residential accounts and ensuring a timely turn around in mailing refund checks out to customers.

Education: Graduated from Parkview Baptist High School in 2004

Skills:

Solid computer background/experience, including Microsoft Office applications Excel, SQL, Word, Access and PowerPoint.

Strong organizational and time management skills.

Ability to provide quality work, meet tight deadlines and manage multiple tasks in a dynamic, fast-paced environment.

Ability to manage relationships by being a team player and resolving conflict within the team and other functional groups.

Excellent Customer service orientation, serving internal and external clients.

Ability to adapt to changing markets, systems, projects and processes.

Ability to communicate issues and process improvements to both team members and management.

I read books constantly about real estate investing, negotiation and personal development skills.

Contact this candidate