Data Analytics Resume
Plano, TX
SUMMARY
- Self - Motivated, confident professional with 15 years of experience in real estate, mortgage, finance, and insurance industries with analytical and problem solving skills with the ability to handle multiple tasks with initiative and adaptability and capable of handling responsibilities independently as well as being a team member.
- A well-organized, goal-oriented, highly motivated effective team member with strong analytical, troubleshooting, and problem solving skills.
- Self-driven and self-directed learner who is always looking to increase my knowledge and expand my skillset.
- Regularly work with sensitive and confidential information with tact and discretion.
- Comfortable working with all influencers and continuous contact with all parties involved of the completion of projects, approvals and closings with understanding of the business processes and project requirements, white setting expectations upfront and keeping clients motivated through the process with a strong sense of urgency.
TECHNICAL SKILLS
MS Office: Windows 98,2000,XP,NT, 7, Vista, 10, 2010 MS Office Excel, Word, Outlook, PowerPoint, Snag It
Database/BI Tools/Languages: SQL Server Management Studio(SSMS)2008 - 2017, SQL Server Business Intelligence Development Studio (BIDS), SQL Profiler, Visual Studio 2012, 2017 SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), T-SQL
Mortgage/Claims Servicing Tools: NTREIS, Real Servicing, Calyx MSP, PACER, View2, LIV, Equator, AS400, Sales Force, Citrix, FiServ, LPS, PIVOT, FHA Neighborhood Watch, Velocify, Encompass, ISO Search, LexisNexis, COA, Compass Virtual Office (CVO), CoPart, Google Maps, Cypher, ARMS, PACE, Arbitration Forum(e-Hub), Claims Outcome Advisor(COA), Admin. Claims Servicer (ACS)
PROFESSIONAL EXPERIENCE
Confidential, Plano, TX
Data Analytics
Responsibilities:
- 3 projects of experience in role of a Microsoft Business Intelligence Developer
- SSMS: Establishing referential integrity, data consistency, and indexing and data cleanup procedures to maintain high quality data that can be used for reporting.
- SSRS: Defined the report layout and identified datasets for the report generation in BI Visual Studio. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
- Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements and notification techniques to maintain integrity and notify responsible parties in the event of an error.
- Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
- Experience in developing Drill-Through and Drill-Down Reports, Parameterized Reports, Sub Reports, Matrix Reports, and Chart/Graph Reports using MS SQL Server Reporting Services (SSRS)
- Proficiency in the use of T-SQL for developing Tables, Stored Procedures, Triggers, Views, User-Defined Functions, Indexes, SQL Performance Tuning to facilitate efficient data manipulation and consistency.
- Optimize and maintain the existing Databases; monitor database performance and growth, performance tuning, generate reports according to the business requirements using SQL Server Reporting Service (SSRS) and populating the data warehouse using SQL Server Integration Service (SSIS).
Confidential, Irving, TX
Sr. Loan Originator
Responsibilities:
- Worked Internet Aggregate and inbound sales lead calls from potential customers looking to obtain a home mortgage and build rapport and determine what the customers’ true needs are and structure the loans in achieving those goals from purchase or refinance.
- Discuss with the clients through the loan application process from start to finish, the processing stages to reach final loan approval for closing, document requirements needed, and different loans available and explain thoroughly the differences from Conventional Fixed, Jumbo, ARMS, FHA, VA, etc.
- Provide profession advice to the clients regarding their current mortgage status, the benefits of refinancing, or going with one loan program vs another always assuring the client the decision is theirs. Obtain payment for the appraisal and lock in the loan rate and program once the client is ready to move forward with the loan application
Confidential, Allen, TX
Realtor®
Responsibilities:
- Consult buyers and sellers though out the process of the buying and selling of the home. Provide comprehensive packages to respective parties to assist with determining the best strategy. Ensure the relations between my clients and I is a win-win relationship.
- Develop and implement negotiation strategy for buyers and sellers. Represent clients best interests, ensuring clients are getting the best deal possible and help simplify and put ease of mind to those represented through the process of buying and selling a home.
- Walk buyers and sellers throughout the offer, negotiations, and acceptance of an offer process. Along with staying in touch with title to make sure the process is moving forward toward closing for all parties.
- Frequent communication with all parties involved in the buying and selling process.
- Continual networking and prospecting to grow my business for new buyers and listings, cold calling, door - knocking/calling expired listings to assist homeowners achieve their goal of selling their current home to purchase their next home. Hold open houses’, talk with prospective buyers to assist with questions or concerns regarding the purchase process of a new home. CE courses and seminars to gain insight in the market and become a more expertise real estate consultant.
Confidential, Richardson, TX
Sr. Inside Auto Claims Rep
Responsibilities:
- Manage a portfolio of new and pending claims to completion, reviewing policy coverages, traffic laws for each state incidents occurred, take part statements and work diligently and fairly to recreate incident to determine fault for all respective parties.
- Providing invaluable customer service while communicating and negotiating with policyholders, agents, claimants, witnesses, and 3rd party insurance carriers. Continuously keeping stakeholders involved of the status of claims to completion and closing file reports.
- Discussion of policy terms and deductibles with policyholders. Policyholder, claimant, witness outreach conducting thorough investigations and analyzing detailed facts and statements of loss.
- Set up payment arrangements to the body shop, policyholders, and claimants, set up body shop inspections and rental vehicles, submit claims for subrogation review with a Payment Authority $2,500.00 before needing management approval.
- Mentoring of new hires, Extra: Catastrophe Team, Auto Restore Pilot, and Inside/Field Adjuster Monthly Conference Calls
Confidential, Richardson, TX
Independent Benefits Consultant
Responsibilities:
- Self-Marketing introductions to build business from cold calling and door knocking small to mid-size business in the DFW area, schedule meetings with the decision makers on the benefits of offering Confidential through their company for their employees.
- Conduct Employee Presentations, with information about the company and benefits of having adding supplemental insurance policy(s) to their current benefits and answer any questions or concerns
- Conduct one on one enrollment with interested parties. Monthly follow ups the stakeholders, assist on initial invoice and payment process with periodic follow up calls to address any questions/concerns or filing of claims.
Confidential, Frisco, TX
FHA Short Sale Asset Manager
Responsibilities:
- Customer Outreach to discuss and educate the possible FHA Short Sale opportunity and benefits over having the property going to foreclosure sale.
- Continuous communication with all stakeholders keeping everyone informed throughout the short sale approval/denial process in an inbound out bound call center environment.
- Review, analyze, and verify for accuracy FHA portfolio loans in default and determine the best form of action: short sale or foreclosure; and discuss with all stakeholders involved in the property
- Review and submit short sale packages for FHA approval as well as review for possible fraudulent information /documentation.
- Review/Underwrite: Customers last payment received, hardships and revenue loss severity, credit reports, income, tax returns, debt-to-income, and title reports, subordinate loan balances, current market values, net to values, net to current unpaid balances, purchase contracts and HUD’s to approve or deny for a short sale.
- Communicate with foreclosure attorneys to verify the foreclosure process is in accordance with regulations and fees are within guidelines prior to foreclosure sales