Data Analyst
Resume:
JOHNNIE G. HUNTER
*** ************ **. ******, **. 30607
*******.*.******@**.****.***
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