Sql Server Sales

C URRICULUM V ITAE

LAURA LEE TURPIN

**** **** ******* *** *******, AZ 85008

HOME: 602-***-**** CELL: 602-***-**** EMAIL ********@***.***

CAREER OBJECTIVE

SSRS REPORTING SPECIALIST DATA RETRIEVAL AND ANALYST WEB DESIGN CHARTS & GRAPHIC ARTS

Provide expertise in determining quality reporting solutions for complex business problems within scope, budget and under tight

schedules. Design, develop and create websites, Social media sites, videos and quality presentations. I am flexible in moving from

project to project with the ability to adapt to current applications or current technologies being utilized. I am looking to continue to make

a significant contribution to reporting objectives, web design and development or IT related functions.

WORK EXPERIENCE

Lexicon Building Systems 1736 S Nevada Way Phoenix, AZ 85204

Dates: January 2011 – Current

Title: Web Developer and Author of Website www.lexiconbuildingsystems.com

Description: Develop and designing of the company’s website. Update DNS, MX records and website optimization. Format photos and

convert documents to secure .pdf for downloading purposes. Develop Facebook page and other media for marketing initiatives. Design

corporate presentations. Produced video for an introduction to Social Media: http://www.youtube.com/watch?v=EXc8deXbHmM

ADDITIONAL WORK EXPERIENCE

Televerde 4636 E University Dr. Ste #150 Phoenix, AZ 85034

Dates: November 2000 – October 2010

Title: SQL Report Writer

Description: SQL Report writing with 7+ years’ experience, delivering business intelligence through the creation and design of reports.

Responsible for developing reporting solutions to meet the reporting and information needs of each differing business unit and customer

facing reporting. Solutions vary in type and scope from quick-hit ad-hoc reports to new, custom and standardized reports that work across

any campaign type.

Daily activities could include any/all of the following:

• SQL Server Reporting Services (SSRS), Xcelsius, SAP • Use VB, IIF statements, SQL expressions, XML, HTML

Business Objects, and Excel reporting and CSS

• Develop stored procedures, views and ETL processes and • Web design and development for internal activities and

jobs using SQL Server 2005 and 2008 fund raisers

• Create complex SQL queries to pull data • Create graphic design, PowerPoint, flash and media

presentations

• Consult with peers and executives to define business needs

• Develop web landing pages Secure Extranet set up for

• Perform analysis and data mining to determining trends www.intelegility.com

and campaign results

ADDITIONAL WORK EXPERIENCE

Subia Corporation 2434 S 24th St Phoenix, AZ 85034

Dates: June 1985 through August 1996

Title: Presentation Graphics Supervisor

Daily activities could include any/all of the following:

•

• Meet and consult with client for majority of all projects • Setup files on disc for electronic imaging, prepress and

color output for print media and presentation graphics

• Storyboarding and formatting client requirements and

• Setup job tracking systems and quality control

implement for production

1 P a g e

C URRICULUM V ITAE

• Monitor entire life cycle of projects and see through to • Cross platform capabilities: Macintosh, IBM, and all

completion and satisfaction of the client Dicomed systems

• Demo and facilitate new software • Supervise all project elements and deadlines

PROFESSIONAL SKILLS INCLUDE BUT NOT LIMITED TO:

• Broad knowledge of SQL Server back-end database • Comprehensive knowledge of Xcelsius and SAP Business

schemes Objects

• Excellent verbal and written communication skills • Comprehensive knowledge Crystal reporting

• Ability to interact directly with clients, non-technical • Strong knowledge in SQL Server Reporting Services

resources of varying disciplines (SSRS)

• Translation of business requirements into technical • Use of VB, IIF statements and SQL expressions

solutions and options; conceptualization of design for

• Strong knowledge of Microsoft Office applications

reporting or presentation requirements

o Excellent experience at Excel formulas - pivot tables

• Experienced in production scheduling and project lifecycle

o Excellent experience PPT presentations

management

• Ability to logically troubleshoot technical issues • Broad knowledge of Camtasia Studio

• Methodical approach to testing and analysis • Ability to work independently and as a team member

• Ability to generate detailed documentation of internal and • Excellent at implementation, execution, organizing and

external resources managing multiple priorities and/or projects

• Create graphic design of dashboards, graphs and charts • Problem solver with the ability to encourage others in

collaborative resolutions for any issues

• Manage and maintain Intranets and Extranets and Website

• Excellent at decision making and critical thinking

design/development and support

• Developed 100+ reports for production, finance, • Marketing video for SwapSmart Consignment Store:

accounting, sales and marketing http://www.youtube.com/watch?v=xCAxzcaMSLQ

• Familiar with various ERPs and CRMs

EDUCATION AND TRAINING

Formal Education:

• University Of Phoenix, Phoenix, AZ.

o Bachelor of Science - Major in Information Technology – Graduated Class of 2009

• Scottsdale Community College, Scottsdale, AZ.

o Associate of Applied Science - Major in Motion Picture & TV Production. Emphasis on Graphic Arts

Certifications:

• ITIL Certification - Foundation Certificate - IT-Service Management.

o ID number N8DDTT5464. Issued by Examination institute for Information Services. Issue Date 07/2006

• Rio Salado - Computer Technology

Workshops:

• UniversalClass.com MySQL Programming

• Learn It First - SQL Server 2008 Database Administration

2 P a g e

C URRICULUM V ITAE

ACCOMPLISHMENTS:

• Created the first automated report in Televerde history reducing administration time by 30%.

• Mentored other report writers and graduated them from Excel pivot tables to SQL reporting services.

• Developed the first Xcelsius interactive dashboard for clients, which I then automated to perform across any campaign or client

base.

• Developed an automated scorecard report for Logicalis. The report is a pipeline scorecard submitted to HP monthly to determine

partner funding. This report required data collection from 25 sales reps. Previously this was manually coordinated and merged into

multiple Excel spread sheets. This process required 7 to 10 days from the executive management to complete and deliver to HP. I

designed a web form on Televerde's secure portal for Logicalis’ sales reps to log on and input into a Televerde database of individual

sales pipeline information. I then extracted and exacted the data to automatically generate a scorecard report. All formulas were

applied in SQL Reporting Services. All management now has to do is log into the site and download the scorecard into Excel,

reducing executive time from days to minutes.

• Created a flash presentation of this new scorecard report and demonstrated the flexibility of this new process at the HP Solution Elite

Partner Summit in 2008 held in Texas.

• In 2008 I was awarded Televerde’s MVP trophy.

REFERENCES:

• Laura Poulson - Incentive Logic. 480-***-****. Business email: ********@**************.***. Former Director of IT for

Televerde. My Director Supervisor from 2000 to 2006.

• Allison Kleeschulte, Director of Campaign Services for Televerde. Contact phone: 602-***-****. Business email:

*******.***********@*********.***. My Director Supervisor from 2008 to 2010.

• Juma – Lead .NET developer for Televerde. 480-***-****.

• Marlo Fletcher - Business Builders Marketing. Business Owner. Work associate and friend. 602-***-****. Email:

*****.********@*************************-**.***.

• Tom Engelthaler – Desert Schools Federal Credit Union as the Senior DBA. Business phone: 602-***-****. Business email:

******.***********@*************.***. Former DBA for Televerde.

3 P a g e

Microsoft Approved Courses:

• 2071: Querying Microsoft SQL Server 2000 with Transact

• 2072: SQL Server 2000 Database

• 2073: Programming MS SQL Server 2000 Database

• 2792A: Implementing & Maintaining MS SQL Server 2005 Database

4 Page

Contact this candidate