Experienced Business Analyst

**** ***** ***** • MCKINNEY, TX *****

PHONE 469-***-**** • E-MAIL *****.*******@*****.***

BRIAN GREEN

PROFESSIONAL EXPERIENCE

**** – 2008 Data Paradigm, Inc. Dallas, Texas

Business Commissions Analyst

 Created complex SQL queries and streamlined reporting processes that made the flow of business more efficient and effective.

 Developed flow charts for management that clearly demonstrated how commissions were calculated and distributed.

 Created definitions, processes and procedures that clarified and defined the structure of multi-level marketing companies.

 Provided quality assurance for external clients to ensure commission checks have been processed accurately.

2005 – 2008 Countrywide Home Loans Richardson, Texas

Business Analyst

 Utilized Microsoft Excel to retrieve data from SQL and Access tables and create reports using formulas, pivots and macros for easy navigation, creation and maintenance.

 Analyzed business data and developed reports that helped call center management monitor trends and optimize operations.

 Gained thorough knowledge of the mortgage industry and practices.

 Created monthly presentations for executive management that demonstrated productivity changes.

 Validated and analyzed executive reports for managing directors and the CEO.

 Created SQL code and data transformation service packages to further automate reports.

 Established process and procedure documentation that helped employees and management run reports easily and accurately.

 Created flow charts that helped management understand efficient methods for developing reports and processes.

 Worked with inter-department clients to ensure accuracy and timeliness of reports and documentation so the client could easily run their business.

2001 - 2004 Prestige Ford Garland, Texas

Service Dispatcher

 Supervised work distribution for vehicle technicians, and ensured customers’ vehicles were repaired in a timely manner.

 Mastered Reynolds and Reynolds Software to document and complete repair orders on customers’ vehicles to ensure correct billing.

 Managed accounts receivables for the service department’s commercial customers. Used Reynolds and Reynolds to document all correspondence from customers’ accounts payable departments.

SKILLS & ACCOMPLISHMENTS

 Proficient in Microsoft Excel (formulas, pivots, macros), Word, PowerPoint, Visio, Lotus Notes, Outlook, AS 400, Access and SQL. Have working knowledge and experience with Microsoft Visual Basics.

 Implemented a company-wide analysis program from the ground up that allowed individual Countrywide call centers to easily view call-taking statistics and to ensure all representative errors and trouble areas were identified and solved.

 Began implementing an automated system of SQL queries and Microsoft Excel Pivots to easily allow Data Paradigm to review commission checks within minutes instead of hours. The ultimate goal was to use pivots, macros and conditional formatting to resolve any possible check errors.

EDUCATION

2003 - 2008 University of Phoenix Phoenix, AZ

Bachelor of Science Program in Business Management

1996 - 1999 Stephen F. Austin State University Nacogdoches, TX

Concentration in Business Marketing

Contact this candidate