SUMMARY:

Reporting and data analysis expert with eight years of Mortgage Servicing reporting experience and an eye for process improvement. Expertise includes SSRS, SQL, Excel, Access, VBA, SSIS, ETL, and Technical Writing. Detail attentive and manage changing priorities easily.

TECHNOLOGIES:

• SSRS
• SQL Server
• T - SQL
• Toad
• Oracle
• PL/SQL
• ETL
• OBIEE
• Excel
• VBA
• SSIS
• Visual Studio
• Access
• Word
• Visio
• ProClarity
• Hyperion
• Lawson
• Monarch
• AS400 DTFs
• JIRA
• SVN
• Data Analysis
• Data Automation
• DokTrak
• LPS
• LSAMS
• Rekon2000

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

BI Developer

Responsibilities:

• Created and maintained parameter driven SSRS reports with click through capability.
• Created and maintained stored procedures.
• Gathered and documented requirements (BRD creation) for new reports.
• Created the SSRS report templates now in use for Performing and Default Reporting.
• Created a UDF to help our report server determine which report groups to refresh each day.
• Gave a training on Excel best practices to members of my reporting team.
• Served as an Excel resource to teammates and business units I support.
• Reduced a coworker’s query run time from over five hours to 23 SECONDS. He was using CURSOR with tables of 90K, 2K, 210, and 26. I got rid of the cursor and used reduced temp tables.
• Created and maintained ETLs
• Created and maintained SSIS packages to load reporting tables using daily MSP and ALS extracts.

Confidential, Dallas, TX

Data Analyst

Responsibilities:

• Created an Access and Excel based ETL and reporting solution to automate the intake, cleanup, and transformation of sales files and to provide reporting on Sales Trending and KPIs. This project involved Excel macros, Access tables linked to Excel, linked staging tables, linked reference tables, reporting tables, and Access ETLs, and reporting queries.
• Developed Excel macros to clean up spreadsheets and move them to Excel upload files linked to Access staging tables.
• Developed Access ETLs to cleanse the staging data, add calculated columns and append the data to the reporting tables.
• Developed monthly Sales Revenue Trending and KPI reports.
• Performed data mining using OBIEE.
• Queried and updated IMS.

Confidential, Irving, TX

Business Operations Analyst

Responsibilities:

• Identified and implemented needed process improvements in data access and data integration
• Developed and maintained SSIS packages to automate the upload of Excel files into SQL Server.
• Developed and maintained SQL queries and Excel dashboard and ad hoc reports.
• Developed and maintained VBA based Excel query tools with parameters, allowing business users to query SQL Server databases with parameters.
• Gathered and documented requirements.
• Converted Access reports to T-SQL.
• Was a query performance SME for the department, reducing run time of one Access query from over two HOURS to 13 seconds. It used three Access tables which pulled in three SQL Server VIEWS before running the Access query. I got the definition of the views and wrote a Microsoft SQL (Access backend SQL) query which hit the tables directly.
• Led team-wide training for all developers on my team on Excel shortcuts, toolbar customization, and use of my Data Cleanup Macro Workbook.

Confidential, Denton, TX

Financial Analyst

Responsibilities:

• Produced and maintained 35 monthly executive and SEC reports.
• Mined data from AS400, Hyperion, Lawson, ProClarity, Access, and Excel.
• Gathered and documented requirements.

Confidential, Lewisville, TX

Information Analyst

Responsibilities:

• Developed and maintained PLSQL scripts and Excel dashboards and reports.
• Gathered and documented requirements.
• Participated in weekly SCRUM meetings.
• Led team-wide training on Excel shortcuts, toolbar customization, and use of Personal Macro Workbook functionality.
• Validated data using LPS-MSP, primarily SER1, LMT1, PL05, and MAS1/DFRM.
• Earned the Chase “On the Spot” award for Liquidations MIS for 2013 Q3.

Confidential, Coppell, TX

Information Analyst

Responsibilities:

• Developed and maintained parameter driven SSRS reports with drill-down and click-through capabilities.
• Served as a SQL and SSRS mentor to my teammates and as an Excel subject-matter expert for business units across the company.
• Developed T-SQL queries and stored procedures.
• Led department-wide Excel training for all onshore and offshore BI developers.
• Developed an Excel macro workbook for instant cleanup of raw data from SQL Server. This was distributed throughout the company and is still used widely at the company and elsewhere (see the reference for this on my LinkedIn profile).
• Gathered and documented requirements.
• Performed data mining using OBIEE and Monarch.
• Validated data using LPS-MSP, primarily SER1, LMT1, PL05, and MAS1/DFRM.
• Served as project manager for complete SDLC of the Contact Center’s Complaint Tracker add-on, overseeing development of prototype, application, testing, data capture and reporting.

Confidential, Richardson, TX

Reporting Business Analyst

Responsibilities:

• Developed T-SQL queries and monthly, weekly and ad hoc Excel reporting.
• Gathered and documented requirements.
• Developed PLSQL queries for ad hoc data mining.
• Supported implementation teams at client sites.
• Earned Spot Award for working several long weeks to help meet client delivery deadline.
• Gathered and documented requirements.
• Developed an Access database and forms to mimic a Siebel database to allow Dicker Staffing to train associates for a major client of theirs.
• Created an Access database to store physician, litigant and legal services data, as well as data entry forms.
• Generated Excel tools used to combine data from disparate data sources and refresh pivot tables for reporting.
• Saved a major B2B account for Cingular Wireless.
• Taught High School Math. Subjects included: Statistics, Trigonometry, Algebra II, Geometry, Algebra I, and Math Models.
• Wrote districtwide math curriculum for Dallas Confidential .
• Taught TAKS test study courses for Dallas Confidential .