Andy Rivera Email & Phone Number

Phoenix, Arizona, United States

Santa Ana, CA

• As a BI Database Analyst II, I was responsible for conducting and leading projects that provide marketing, research, product, and distribution development support to our clients. I analyzed marketing and retention.
• Developed a dynamic SharePoint Wiki Library integrating BI tools and reports for Business End Users and SMEs.
• Utilized analytical tools such as SAS, SQL and Excel, load, process and develop results from data files.
• Collect and analyze data to generate process metrics (i.e. cycle time of existing process).
• Documents client organization's direction, structure, business processes
• Analyze business and IT processes to understand customer needs

Santa Ana, CA

• As a Business Intelligence Developer, my major roles entailed developing of codes, tests and solutions based on pre-defined requirements utilizing various tools mainly from Microsoft’s BIDS. I was one of the original.
• Designed and developed end-to-end solution in MS Business Intelligence Development Studio (BIDS) that support projects and enterprise level strategies
• Conducted research, provided facts, and made recommendations on Business Intelligence products, services, protocols, and standards
• Worked within established development guidelines, standards, methodologies, and naming conventions
• Gained a thorough understanding of the requirements and ensure the project plan includes tasks that address each of them
• Collaborated with team members to identify project risks, design mitigation plans, and development estimates

• Contributed to the origination of the Claims Department for Safeco FIS. Overseeing the operations side of the department ensuring efficiency within the daily workflow, escalated issues, and adjusting resources based on.
• Handled expansion of staff especially during catastrophes
• Coached and mentored employees on certain skillsets and moved resources based on their strengths.
• Provide outside departments with consults of increasing efficiencies and managing current resources.
• Worked closely with upper management (Directors and VP’s) in reviewing adjacent departments in efficiency and hand offs of work items.
• Created applications and reports for my department as well as other departments.

Irvine, CA

• Started in Safeco FIS initially as a temp with the position of a Customer Service Representative within the Lender Placed Insurance Department. When hired, I entered in with the Team Lead position. Primary role was to.
• Download client’s weekly portfolio into our systems and resolve any discrepancies found on file.
• Ensure that we process each loan within the client’s portfolio.
• I was the key person handling special accounts or new accounts.
• Created an automated application for balancing accounts.
• Worked with IT in creating productivity and efficient reports.

Orange, CA

• Assisted in creating and provided a "One-Stop-Shop" Title and Escrow service for national lending firms. With title companies being regional, the concept of creating a national title & escrow service network was not as.
• Assisted in creating and expanded a national title desk.
• Establish a national title network and coordinate relationships with vendors.
• Managed crisis and discrepancies brought up by vendors and clients.
• Interview, hire and manage staff.
• Established workflow and efficiencies within the office.

Kirkland, WA

• Loanworks, Inc. (A subsidiary of IndyMac Bank) was one of the first eCommerce lending companies at the time. Our leads were generated mostly from banner links on various search engines.My job main responsibility was.
• Pioneered the eCommerce lending division.
• Worked in a high volume environment of over 20-30 loans in the pipeline every month.
• Originated loans through warm leads (Contact clients from information provided from online ads).
• Processed all loan documents (Obtain title, bank statements, verifications, and order appraisals)
• Light underwriting of loans (Completion of the 1008 and compose information of compensating factors that will assist in the closing of the loan).

Yorba Linda, CA & Fullerton CA

• As a Personal Banker IV, I was responsible for offering and selling financial products and services to both consumers and small business customers. Routinely work with customers to build and deepen the relationships by.
• Continuously exceeded defined goals and accountability, personally and for the branch
• Skilled in assessing customer/client needs, providing solid advice/recommendations, and building customer relationships based on mutual trust in order to optimize sales opportunities to new and existing customers/clients
• Built solid relationships with teammates, business partners and specialists by fostering teamwork, partnership and collaboration
• Applied strong critical thinking and problem solving skills to meet customer’s needs.
• Demonstrated initiative, a commitment to continuous learning, and the ability to adapt to changing demands and requirements

Computer Information Technologies, Business Management

Engineering, Computer Information Technologies

Activities and Societies: Filipino Club (SCPASA)