SUMMARY

• Accomplished SAS Programmer / Marketing Database Analyst with expertise working on multi - platform environments, having worked in Financial Services, Telecom, and Insurance Industries, developing business processes to provide pertinent and accurate data to the Business Customer. Excellent communication and diagnostic skills, individual contributor and team player.

TECHNICAL SKILLS

Software: MS Office (Word, Excel, Access, PowerPoint), Oracle, DB2, Teradata, Sybase, Business ObjectsQueryMan, TOAD, PL/SQL

OS/Environments: Windows 3.1/95/98/NT/XP, PC-DOS, UNIX, LINUX, Sun Solaris, IBM/3090, MVS/TSO, HP3000

Development Applications: SAS/PC (v9), SAS/Base (v9), SAS/Proc, SAS/Reports, SAS/SQL, SAS/DataFlux, SQL

PROFESSIONAL EXPERIENCE

Confidential - Lewisville, TX

Business Analyst II

Responsibilities:

• Worked with Internal and External Customers to Identify and Remediate System Coding and Reporting Logic Issues.
• Evaluated, Analyzed, and Mapped Business Processes while working with the Business Units to determine possible Solutions to Increase Efficiencies and Productivity.
• Followed All Quality Assurance Processes, including Periodic Reviews and Transitions and Ensures the End Product Fulfils the Project Objectives.
• Collaborated with Management and Staff in the Development and Implementation of All Projects and /or Initiatives related to Operational Goals and/or Process Improvement Directives.
• Assisted on other Projects as needed, Preformed other related duties and Special Projects as required.
• Demonstrated the ability to work with all levels of management on projects.
• Demonstrated professional behavior and teamwork, punctual, dependable, and adheres to company policies and procedures
• Assisted with Training of Junior Staff Members with Projects and Technical Skills.
• Evidence the ability to work with all Levels of Management.
• Automate SAS Production Jobs to run on UNIX platform using CRON Scheduler and maintain SAS Code.
• Updated CRON Shell Scripts to schedule SAS Production Jobs to run at varies time on UNIX platform.

Confidential

Senior SAS Data Analyst

Responsibilities:

• Perform Analysis of Clients Current Direct Marketing Initiatives to Identify Key Insights and Opportunities.
• Presentation of Analytic findings, including recommendations to Agency and Client organizations.
• Assist in ongoing development of Customer Segmentation and Statistical Models.
• Create Client E-mail Campaigns for Marketing Initiatives using Loyalty Ware Application.

Confidential, Richardson, TX

Senior SAS Programmer / Analyst

Responsibilities:

• Maintain Dun & Bradstreet Data to be used in monthly update process of Financial Tables.
• Update SAP Data Files in Monthly Financial Process.
• Developed Matching Process using SAS/DataFlux Application to match New Business Customers to Dun & Bradstreet data.
• Developed QA Reports to verify accuracy of updates to data.

Confidential, Irving, TX

SAS Programmer/Mkting Database Analyst II

Responsibilities:

• Maintained a Business Customer Database with over 1M records that housed the Firma-graphic Data, Sales Organization, and Customer Segmentation to support Marketing Programs, Sales Compensation, and Revenue Recognition.
• Developed, Designed, and Implemented recurring Monthly Reports and Ad-hoc Studies to support Marketing Strategy and Analysis.
• Identified opportunities to automated and enhance existing recurring reports so they were produced on time.
• Documented production steps and quality control procedures to refine and improve audits to enhance quality of data systems and on deliverables.
• Maintained accuracy of Business Customer Database with the ability to tie back to Sales Force Data (SFDC), SMRS (Sales & Marketing Reporting System) and Finance Systems for business reporting needs.
• Contributed to development and quality control of the programming deliverables, utilizing tools and methodologies to meet team requirements.
• Created, managed, and maintained the programming specifications for the analysis datasets utilizing tools and methodologies to comply with business rules.
• Ensured programming code meets regulatory and company standards for efficient programming and reporting.
• Performed quality assurance procedures on work performed by other team members to improve accuracy.
• Pulled data from various sources (Oracle, Teradata, Access and Excel) to be used in the production of the Named List Process.
• Used SQL to create Production Tables to be pushed to Oracle, and Teradata.

Confidential, Irving, TX

SAS Programmer/Mkting Database Analyst I

Responsibilities:

• Managed Public Sector of Confidential / Nextel customer named list with over 60K records.
• Developed firmagraphics data using SSA for Sales Prospects to enhance Sales success.
• Interfaced and supported Sales, Marketing & Finance by researching and recommending resolutions for business decisions.
• Updated Customer Named List with Monthly Changes from customer list management application and quarterly changes from Duns & Bradstreet Database of over 26M records.
• Participated in the planning for enhancements to the customer list application.
• Created tables and update process for the Parent and Subsidiary Companies using SAS to maintain accurate data.
• Coordinated meetings to resolve issues associated with the Named List process.