SALES SYSTEMS ANALYST Resume DALLAS, TX - Hire IT People

SUMMARY

4 years of IT experience in System Analysis, Development and Support of MS SQL Server with specialization in MS SQL Server 2008/2012.
Applying Agile Methodology such as Scrum to develop applications; Collecting and analyzing business requirements, and breaking them down into functional requirements for development.
Creating Stored Procedures and User Defined Functions to streamline the workflow; SQL Queries using Complex Select Statements, SQL Joins, Sub Queries and CTE's.
Creating meaningful SSRS reports using Drillthroughs, Subreports, and Cascading Parameters.
3 years of experience in Excel. Heavy emphasis on Vlookups, concatenation, pivot tables, and IF statements. Working with large data sets, auditing, data validation, cleansing. Also analyzing for trends and patterns.
Writing complex SQL queries using aggregate functions: Sum, Min, Count; and also string functions such as: Substring, CharIndex, Len, Left, etc.
4 years of mortgage experience working with purchases, modifications, and refinances. Experience with different loan types; FHA, FNMA,

TECHNICAL SKILLS

Databases: MS SQL SERVER 2008/2012

Languages': SQL, T - SQL

Operating Systems: Windows 2000/2003/ NT/ XP/ vista/7/8

Professional Software/ERP: Confidential

Software: Microsoft Office Word, Excel, Access, Power Point, Outlook, SharePoint

PROFESSIONAL EXPERIENCE

SALES SYSTEMS ANALYST

Confidential, DALLAS, TX

Responsibilities:

Instrumental in the successful platform migration, from Delphi operating system to Confidential .
Writing stored procedures to maximize query readiness and reduce network traffic.
Creating and scheduling SQL jobs in order to automate queries needed to back up tables and replicate databases. Monitoring jobs and ensuring appropriate updates have been executed.
Tuning legacy queries for better performance and optimization.
Creating new SSRS reports as assigned; Creating adhoc reports for the executive team as needed.
SSRS report troubleshooting, determining and curing errors on the web report server.
Updating existing queries through DBAmp to utilize Confidential language.

BUSINESS INTELLIGENCE ANALYST

Confidential, PLANO, TX

Responsibilities:

Interacting with business units to elicit requirements and translating them into functional reporting requirements.
Writing T-SQL queries to retrieve and analyze data from multiple tables in the database.
Creating and modifying SSRS reports showing loan turnover, highlighting which processors are taking loans from origination to funding, and tracking overall performance of each department.
Developing SSRS reports for attendance at our TX site, utilizing parameters and cascading parameters.
Locating tables using Database diagrams in SQL Server Management Studio, establishing relationships between multiple tables using Primary and Foreign keys.
Creating Weekly, Monthly and quarterly parameterized SSRS reports to analyze performance by Department, Team Lead, Associate, etc.
Extensive use of T-SQL in writing Stored Procedures, Triggers, Tables, Views and familiarity with Indexing.
Tune existing code to reduce locking and performance issues.

LOAN MODIFICATION PROCESSOR

Confidential, DALLAS, TX

Responsibilities:

Research and analyze mortgage files and determine their eligibility for modification.
Create checklist according to FHA, FNMA, FHLMC, SFO, and HFI guidelines.
Review borrower documents for accuracy and submit files for underwriting.
Knowledge of Investor Asset Management and the process of Reporting, Remittance, and Reconciliation.