Data Analyst

JOHNNIE G. HUNTER

*** ************ **. ******, **. 30607

706-***-****

ablkp0@r.postjobfree.com

EXPERIENCE SUMMARY

. Data Analyst, Business Analyst, System Analyst, Software Developer,

Application Design, Software Instructor, User Support

. T-SQL, SQL, ETL, SSIS, SSRS, Crystal Reports, MS Access, MS SQL Server

2000 - 2005

. Oracle, Sybase and SQL-Server.

. Database Design, Data Mapping, Stored Procedures, Data Conversion,

Requirement Document, Data Flow Diagrams

. System Development Life Cycle (SDLC), Joint Application Design (JAD)

PROFESSIONAL EXPERIENCE

11/2009 - 05/2010 Office Manager (Volunteer)

Economic Justice Coalition

504 Oconee St. Athens, GA 30605

. Designed and implemented office policies

. Established standards and procedures

. Organized office operations and procedures

. Monitored and record phone calls

. Prepared time sheets

. Controlled correspondences

. Reviewed and approved supply requisitions

. Liaise with other agencies, organizations and groups

. Updated organizational memberships

. Maintained office equipment

. Organized orientation and training of new staff members

. Provided on the job and other training opportunities

. Planned and implemented office systems, layout and equipment

procurement

. Implemented procedural and policy changes to improve operational

efficiency

. Ensured security and confidentiality of data

. Designed and implemented office policies and procedures

. Analyzed and monitored internal processes

. Handled customer inquiries and complaints

04/2009 - 06/2009 - Data Analyst

Aztec Energy Partners

1951 Honey Creek Commons, Conyers, GA 30013

. Developed/maintained/monitored various system applications to ensure

capability, functionality and accuracy of information reported through

interpretation and analysis

. Statistical profiling of the customer data, creating and maintaining

data baselines

. Developed SQL queries, stored procedures and triggers

. Improved the business process model for improved automation and

efficiency

. Developed Reports using SSRS and Crystal

. Conducted Data Analysis, Data Modeling, Data Mapping, Data Validation

and Verification, Data Consolidation and Data

Cleansing

. Performed database maintenance and data extraction using T-SQL.

. Imported and transformed data into SQL Database from different data

sources using MS SQL Server DTS

11/2007 - 04/2009 - Database Analyst

GoodCents

400 Perimeter Center Terrace NE Suite 245, Atlanta, GA. 30346

. Performed database maintenance and data extraction using T- SQL,

stored procedures

. Imported and transformed data into SQL Database from different data

sources using MS SQL Server DTS

. Communicated with clients to correct any data anomalies

. Developed SQL queries to extract, manipulate, and calculate

information used to provide decision support and analytical

reporting to clients

. Analyzed and produced reports needed by clients utilizing Crystal

Report X

. Mentored and assisted other members of IT team

04/2007 - 11/2007- Data Analyst

Client Profiles

1215 Hightower Trail, Atlanta, GA.

. Extracted and converted legacy data formats into SQL 2000/2005

databases

. Manage design, implement, and verify data conversion modules

. Import and transform data into SQL Database from different data

sources using MS SQL Server DTS

. Use SQL 2005 Integration Services or Transact SQL to extract data

. Data Analysis, Data Modeling, Data Mapping, Data Validation and

Verification, Data Consolidation and Data Cleansing

. Developed reports using SSRS and Crystal

. Gathered requirements and identifying needs for data presentation

02/2005 -02/2006 - PC Support Vocational Instructor

Corrections Corporation of America, Gadsden Correctional Institution

6044 Greensboro Hwy Quincy, FL 32351

. Instructed adult on the utilization in Microsoft Office Suite ( MS

Word, Access, Excel, Publisher, PowerPoint, Outlook, and

Explorer), typing, general office procedures, and business math

. Conferred with management, supervisor and staff to determine training

objectives

. Prepared course objectives and outline for course of study following

Florida Department of Education curriculum guidelines or

requirements

. Planned and documented a program of study that meets the individual

needs, interest and abilities of students, to include outline,

text, handouts, PowerPoint presentations, and test; design laboratory

exercises

. Administered written and practical exams to evaluate student's

performance and progress; record results; write and issue

performance and/or progress reports as necessary or required

. Maintained accurate, complete and appropriate records as required by

policies, regulations, and procedures and rules of behavior

for the classroom

. Provided software and hardware support to educational staff

04/2004 - 09/2004 - Programmer Analyst

Fringe Benefit Management Corp.

3101 Sessions Road Tallahassee, FL 32303

. Worked in a team environment to develop system flow diagrams, system

specifications, and oral and written directions to produce advanced

working accurate computer programs or to update or modify existing

programs

. Designed report and screen layouts for supervisor approval

. Implemented the specifications required for testing environment,

debugged, tested programs and evaluated test results to prepare

programs for installation

. Installed programs, files, indexes and utilities

. Provided software support to users

09/1998 - 01/2003 - Sr. System Analyst/Developer

Digicon Corp.

1401 Deshler St SW Fort McPherson, GA 30330

. Served as senior developer analyst, for design, development and

deployment of system application

. Worked with users and/or their IT staff to determine the source and

resolution of technical problems

. Developed applications in accordance with DOD and U.S. Army security

policies

. Assisted with the development, analyst and conversion from a client

server application to a web-based application

. Analyzed and designed data requirements and data structure

. Performed code refactoring

. Prepared proposals to re-engineer business process and implementation

. Guided developers in project development

. Identified data requirements

. Conducted training sessions, technical meetings relating to design,

development, implementation and system utilization

05/1990 - 12/1999 25B Information Systems Operator Analyst U.S.

Army Reserve

01/1980 - 08/1987 74F Computer Programmer U.S. Army

[pic][pic][pic][pic][pic][pic]

Contact this candidate