Reports Developer

Cee Everett

**** **** ***** ***** ******, Georgia 30288

acepd4@r.postjobfree.com 404-***-****

Software developer with a successful track record in

reporting,

application design, problem solving, requirement gathering and

analysis.

Technical Crystal Reports 2011, Tableau 8.0, MS SQL 2008, SQL, Windows

Summary: 7, UNIX, stored procedures, PL/SQL, SQL Plus, VB, MS Excel.

Oracle 11g, MS SQL Server, Microsoft Access Toad, SQL

Developer, Tableau data sources and data marts.

PHP ( see website) developed www.cedargroveumc.org

Education: University of N.C. at Chapel Hill

B.S. Business Administration and Accounting

US Army - Computer Programmer / Systems Analyst

Military: Honorable Discharge

Experience: Reporting Analyst

March 3, 2014 to Present

Georgia Student Finance commission

2082 East Exchange Place Tucker, GA 30084

Contracted thru Delta Information Systems

(funding for contract expires on June 30 2014)

Technical environment: SAP Crystal Reports 2011, OBIEE BI

Publisher, Oracle 11g database, Tableau 8, SQL Developer and

SQL Plus.

Developed SQL code to create data sources and pivot tables (MS

Excel).

Created Tableau visualizations displaying enrollment data from

the University System of Georgia, SAT and ACT/AP test results

from Georgia public and private graduates from 2007-13;

Developed parameter driven Crystal Reports to display

course-taking patterns; grading patterns; post-secondary

attendance of Hope eligible gradates; trends in standardized

test scores, including AP, ACT and SAT data.

Documented matching processes used to link normalized GPA

datasets to internal and external data sets.

Exposure to OBIEE BI Publisher for producing reports and

dashboards.

Created document for GAAWARDS data - What is available and how

it can be accessed using Crystal Reports, SQL, and Oracle data

tools. (GAAWARDS is a data repository that contains Georgia

student information used by researchers for analysis of

educational and workforce data for the State of Georgia.)

BI Application Support Developer

May 2013 - Nov 2013

McKenney's Inc.

1056 Moreland Industrial Blvd SE Atlanta, GA

Created Tableau 8 BI visualizations and Data. Worked to

Created Data Marts and Data Sources on Tableau Server.

Supported ERP accounting applications (Microsoft Dynamics SL)

developing advanced database queries for extraction and

analysis of information using MS SQL Server 2008, MS

Transact-SQL and stored procedures.

Developed stored procedures generating HTML email alerts for

thresholds reports for financial and human resources.

Exposure to Microsoft SQL Server Integrated Services

Maintained, updated and developed enterprise reports using

Crystal Reports 2011.

Mckenneys Projects:

Created visualization for Applied vs Unapplied Labor Hours for

Field and Office workers to include Company, Division,

Department and Employee Details.

Created data stores for details of assigned techs with last

date of service call, techs with open service calls and

assigned service calls with service dates greater than 7 days

for the Service Dept.

Worked with the Accounting Vice President to create

visualization for Budget vs Actual revenue.

Created visualization report to show certification expirations

for field employees.

Completed Tableau advanced training including Guided Analytics

and Data Blending

Developed Tableau Visualizations for

Weekly Hours Total for top n Projects by Department.

Weekly Department Labor Hours Trend

Weekly Payroll $ by Department

Average Labor Rate Trend (Budget vs Actual)

Percentage of Labor Budget Spent

Ratio of Field to Office employees by Company, Division,

Department with employee details

Developed Crystal Report for customer data reported any new

billing for the month as well as any billing for the month

over $30,000.

I am familiar with Tableau 8 data marts, filters and data

sources, creating Groups, creating drill down reports and

Tableau best practices for design. I worked with combined

axis charts and combo charts using banding and reference

lines, discrete and continuous date parts.

I had to demonstrate commitment to accuracy and quality while

meeting deadlines.

Sr. Systems Support Specialist

April 2009 - Nov 2012

Georgia Perimeter College

1975 Lakeside Parkway Tucker, GA

Oracle Developer using SQL, PL/SQL, UNIX, TOAD, HTML, Crystal

Reports, Shell scripts, stored procedures, functions and

packages.

Responsible or analysis, design, development, testing,

implementation and maintenance of Banner Student Information

System and other third party vendor applications.

Demonstrated coding skills in Agile development environment

process data from a variety of sources.

Served as Team Lead for problem resolution and SQL development

for Student Financial Aid and Student Information systems and

Student Accounts.

Advanced PL/SQL Training - 2012

Java Programming (Comprehensive Hands on Introduction)

Learning Tree 2011

Shell Programming Class - Learning Tree 2011

Attended COGNOS Data Warehouse training - 2011.

Sr. Software Developer / Project Leader

March 1998 - July 2007

Georgia Lottery Corp. Inc.

250 Williams Street Atlanta

Developed full life cycle software technical design

specifications for data warehouse environment using Oracle

10g, UNIX, PL/SQL, SQL, Visual Basic 6, VB.Net, ODBC,

Microsoft Excel, Informatica Dashboard and Crystal Reports.

Developed reports for the Sales Reporting integrating data for

sales reports from several sources including Oracle, Excel

spreadsheets, and flat files that were used for Crystal

Report ad hoc reports, Informatica dashboards and internal

business systems.

I reported on over 3.5 billion dollars in annual sales data

from 8000 point of sales terminals. Many reports required

extreme accuracy as they were used as public press release

information.

Promoted from Developer to Sr. Developer to Project Leader.

9 years designing database tables using advanced SQL queries,

joins and unions.

Experienced with user interface design

Created algorithm for password encryption of in-house

applications.

Supervised day to day software project related tasks of the

software development staff. Included gathering requirements,

and performing analysis and design. I used Microsoft Project,

Microsoft Visio. COBOL, XML data analysis using XML Spy.

Led Software Development team of 5 programmers to install

newest version of Informatica Power Center 6.2, Power Analyzer

including dashboard reporting and process flow documentation.

Converted over 50 SAS programs to Visual Basic 6 and Oracle

10g.

Explored emerging technologies to determine applicability to

business needs.

Sr. Software Developer

Federated Systems Group - (Riches, Macy's) - Atlanta GA

6108 Governor's Lake Parkway Norcross, Georgia

Sept 1996 - Mar 1998

Software Developer using IBM DB2, Microsoft SQL Server,

Microsoft Access.

Led team effort to code a system to replace a legacy system of

batch processes,

Combined eleven different databases into one for

centralization of warehouse operations for retail stock

fulfillment system for Macy's, Burdines, Bloomingdales and the

Bon Marche stores. This saved the company several million

dollars per year.

Contact this candidate