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 reports, manipulated data and prepare databases and records for analyses. And used quantitative and analytic skills along with analysis tools to develop ad hoc analyses.Key Roles, Achievements, and Responsibilities• 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• Define business requirements via standard analysis techniques such as process mapping, data collection, facilitation and workflow analysis• Identify potential risks, opportunities and issues of importance; communicate to project leadership as appropriate• Document business and functional requirements; ensure linkage to test cases• Review data and provide immediate feedback in order to increase productivity, profitability, and customer satisfaction• Developed reporting dashboards that provide customers with a performance snapshot• Served as a project lead on designated projects• Understood project plans and is able to clearly articulate roles, project goals, and timelines• Excellent oral and written communication skills to effectively conduct project management and presentation duties.• Ability to process time sensitive data and information from multiple sources, make decisions and communicate actions.• Ability to observe, interpret and document workflow processes.• Ability to prioritize, organize, and work independently or as part of a project team to complete multiple tasks.

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 team members who was with the department since its inception. Assisted in migrating data from Relational Databases to Data Warehousing. Also led in projects/applications with various departments and internally in creating business tools/systems.Key Roles, Achievements, and Responsibilities• 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• Participated in QA and testing activities according to planned schedules• Performed root cause analysis and defect correction as indicated by test results• Evaluated outcomes, report results and document findings according to current standards• Ensured work product aligns with customer requirements• One of original developers for Client Monthly Reports• Previously worked as an Interim Report Development Manager• Excellent verbal/written communication skills and strong analytic abilities, & can perform well both independently & as a team player Technical SkillsMS SQL Server 2008/2005, MS Access, SQL, Transact-SQL(T-SQL), MS SQL Server Integration Services(SSIS), MS SQL Server Analysis Services(SSAS), MS SQL Server Reporting Services(SSRS), SQL Query Analyzer, Visual Studio 2008/2005, MS Project, Crystal Reports 9, MS VISIO 2003/2007.

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 foreseeable workload. Key Roles, Achievements, and Responsibilities include:• 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.• Create, write, and maintain various VB scripts to hand off information from one system to another.• Managed any and all escalated calls that were brought to the department. • Reviewed all reports pertaining to the operations side of claims such as calls and data entries. Ensuring that they were handled in a timely manner.• Work with outside agencies in providing key information regarding national catastrophes• Work with vendors responsible for claims adjusting ensuring claims were handled in a timely manner.• Worked with clients and customers in resolving policy discrepancies while handling the claims on properties.

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 maintain client’s accounts and handle customer inquiries.Key Roles, Achievements, and Responsibilities• 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.• Coached and mentored colleagues in daily tasks and efficiency.• Originated and tracked customer claims.• Distributed daily workload among the team.• Handled escalated customer calls.

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 available, as it is now.I was in charge of managing Title Officers and Real Estate Attorneys in all 50 states, Puerto Rico, & Guam. I handled real estate transactions (Commercial and Residential). Worked in resolving liens, judgments, subordinated mortgages, worked with Tribal Counsels on non-US territories, and advocated with attorneys for the borrower/lender.My department handled high volumes of real estate transactions. Anywhere from 500-1,500 transactions a month. I was intricate in turning the department from a staff of 5 to a staff of 75 in just two years.Key Roles, Achievements, and Responsibilities:• 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.• Work with IT in creating an application that can manage workflow, reports, and manage relationships.• Coordinate with Sales Representatives in locating potential clients throughout the nation.• Create billing reports and distribute funds for services within our vendor network.• Assisted company in additional business ventures which would provide the company not only additional revenue, but would also assist in serving our clients more in house.

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 the handling of residential loans from start to finish. This includes originating, processing, to light underwriting of the loan.Also worked with our IT department in creating an artificial intelligence system that will allow us to create rates based on how an applicant filled out the information during off hours of businessKey Roles, Achievements, and Responsibilities:• 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).• Provide case statements, and clauses to the IT department that would assist in the programming of an online loan application.

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 uncovering their financial needs. As an Assistant Customer Service Manager, not only did I hold the roles of a Personal Banker, but I was also in charge of training the Customer Service Representatives in methods of looking for clients’ needs, the scheduling of the Customer Service staff, managing workflow, handling conflicts with clients or staff, and authorizing banking transactions. During my time in Fullerton Main, we were identified as a flagship branch and was utilized for testing new products/service items.Key Roles, Achievements, and Responsibilities:• 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• Excellent oral and written communication skills with strong influencing skills• Demonstrated leadership and assertiveness

Computer Information Technologies, Business Management

Engineering, Computer Information Technologies

Activities and Societies: Filipino Club (SCPASA)