Data Analyst

TONI R. PEARSON

**** *. ******* ****** ~ Chicago, IL 60619 ~ 312-***-**** ~ *******@***.***

TECHN ICAL SUPPORT / I N FOR MAT ION SYSTEMS MANAGEMENT / BUSINESS SYSTEMS

A NALYST

People ~ Processes ~ Systems

Detailed-oriented professional with progressive experience across diverse industries. Excel in strategic

p lanning and process improvement with proven ability to identify opportunities to streamline

operations. Skilled communicator and leader with effective interpersonal relationship-building skills

to create and maintain professional rapport with clients.

A REAS OF EXPERT ISE

• •

Technical Support Deployment Analytical & Conceptual Problem

• Post Deployment Solving

• •

Application Support Deliverables Researched /Resolved

• Facilitate Client T raining T imely Manner

• •

Routine Client I nterface Ensure Advocate Client Issues when

Solutions Meet Requirements Communicate with Peers

TECHN ICAL COMPETENC IES

• •

Business Objects Reporting and Relational Database Theory

•

A nalysis MS Visio

• •

Cognos Access

• •

Oracle Forms (ERP) Excel

• •

SQL Developer Word

• Mgmt Studio

• Implementation Testing

S tatistical Tools: LiDAR ~ ADAS/SQT ~ NTRP ~ T MC Forum ~ MapPoint ~ ArcInfo ~ Arcmap

Network Concepts: TCP/IP, Routers, Fi rewall, Wireless, VPN, Remote Desktop ~

H a rdware/Software I nstalls

PROFESSIONAL EXPER IENCE

Caterpillar, Peoria, I L I T Analyst I I I 08/2012 to

P resent

Responsibili ties:

Obj100

TONI R. PEARSON

8733 S. Calumet Avenue ~ Chicago, IL 60619 ~ 312-***-**** ~ *******@***.***

• Development & Scope Of Services (Business Analysis )

• Implement & Sustain Services

• Direct 3 Or More Teams Responsible For Building, Enhancing, Or Maintaining These Services

( Identify Resource Requirements & Assign Individual Responsibili ties)

• Track Projects To Plan

• Supervise Between Vendor, Contractors, Consultant & Employees Regarding Time Management

Spent On Projects

• Onboard New Employees By Setting Up Their Dev, Qa, Pre-Prod, And Prod Environments'

I nfrastructure For Folders And Security Access For Bi Tools In Bobj Vs. 3.1, 4.0, And Cognos 10

• In teract With Business Partners To Capture Required Folder Structure And Access Level

Desired For Cws Groups

• Use Cmc To Set Up Authentications, Users And Groups, Folders, Universes And Connections

• Test Infoview Using 'No Sso' Links To Ensure User's See Folders They're Requesting

• Run Load Test / Scripts To Measure Balance Of Environment

• Manage Trainers Ids And Test Idt Vm Setup For New Students Taking Upcoming Bobj Classes

ATEDY (Awareness of Technology for Elderly, Disabled, Youth), Chicago, I L 10/2011 to Present

Grant Writer / Volunteer

Government Grants: Provide expertise to find government research funding or project grant funding,

determine and supervise what skills the [volunteer] principal investigator needs to have, and draft the

scope of work describing the research project and the deliverables. Work with the Executive Director

(ED) to find the volunteer leader with the r ight skills, and then allow the ED to explore opportunities

w ith government agencies once located.

Abbott, Abbott Park, I L Systems Analyst 08/2011 to 09/2011

Responsiblit ies:

• Translating The Business Process And I ts Requirements (Design, Testing, Implementation

Deliverables)

• Models The Business (Data, Process And Reconciling)

• Provides Business Leadership To The Developers On The Project Teams

• Prepare Strategic Business Requirements

• Uses Accepted Concepts, Standards And Toolsets

• Fully Utilize Data And Process Modeling Techniques Along With Workflow Analysis Techniques

• Consult With Customer And Systems Personnel To Determine Type Of Information To Be

P rocessed

• Devise Data Verification Methods And Standard Systems Procedures

• Define And Analyze Needs And Information Requirements

• Communicate With Non Technical Customers For Knowledge Transfer

• Develop In-Depth Understanding Of Business Areas Where Existing Or Modernized Programs

Could Provide Solutions

Obj100

TONI R. PEARSON

8733 S. Calumet Avenue ~ Chicago, IL 60619 ~ 312-***-**** ~ *******@***.***

Nufarm Americas, I nc., Bur r Ridge, I L B I Analyst/Developer 02/2011 to 07/2011

Client had a process f low that had to be followed and maintained in order to obtain the level of output

report volume expected. There were 7 development status’ (Queue, WIP Assigned, Definition

Pending, User Test, Rework/Debug, Ready to Promote, Alive-Prod) before reports went Live to

p roduction.

• Team Lead, Business Requirements were gathered From End-Users For B usiness Objects

X ir2 Reports

• Current Universe Was Reviewed Or Reused

• Requirements Were Supervised & Delegated To Oracle Developers

• Used Oracle Data Base SQL Scripts To Run The Data To Make Sure Requirement Logic Was

Correct

• Gave File Dump Of Data To End-User For Approval

• File Was Imported To Business Objects Designer Tool

• Test Envi ronment Was Created On The Universe

• File Exported To CMS Server To Create Infoview Reports

• Created The Report Display And Tested The Outcome Via Excel Export File

• Data Correct, Imported The File To Business Objects Designer Tool To Create The Universe In

T he P roduction Environment

• Created The Report Display And Tested The Outcome Via Excel Exported File

• Contacted End-User To Advise They Can View The Report Per Their Request In Infoview

• Provided F i rst Level Report Support

• Enabled The Universe, Managed Security, And Managed The Development P rocess

• T rack-I t Tickets Were Created For Issues With Existing Reports Or New Requests Of Reports

• There Were Weekly Status Reports For User Community And Weekly Meetings With

Development Team

• Trained End-Users In Infoview On How To Navigate And Create Their Own Reports From

Scratch

• Repeated The Above Concept For D ata Warehouse ETL Reporting Using M YSQL Scripts To

Run The Data To Make Sure Requirement Logic Was Correct

NAVTEQ, Data Analyst Chicago, I L (Consulting) 10/2009 to 12/2010

• Conduct Research And Analysis On Spatial Datasets With Goal Of Supporting And Developing

Derivative Datasets For Use In With Conjunction With Existing NAVTEQ Products.

• Use MS Excel To Create P ivot Tables To Do Chart Analysis.

• Implement Geospatial Technology In to Existing Processes In Order To Utilize And

Recommend The Most Effective Tools For Task Completions.

Obj100

TONI R. PEARSON

8733 S. Calumet Avenue ~ Chicago, IL 60619 ~ 312-***-**** ~ *******@***.***

• Provide Statistical Advice A nd G uidance To Clients I n terested In Making Decisions Through

T he Analysis Or Collection Of Data.

• Used M appoint To Create Test Route Files By Plotting NA And EU Region T mcs (Points) On

M ap.

• Used M apinfo For Potential Clients In The NA And EU Region.

• Generate And Test Value Statement Hypotheses For New Datasets.

• Used A rcview/Arcgis To Create Height And Slope Chart To Visualize And Analysis Data.

• Ut ilized Arcview M ap Templates To Create Consistent Styles In The Charts.

• Use L idar System To Test 4 Set Of Tolerances On Land : G round T ruth, D istance, Z Level,

A nd Bearing .

• Run ADAS Analytical Tool To Produce Statistical Results So Management Can Determine Best

P ractices.

• I nterface W ith Business Clients To Update Them On Progress Of Gap Analysis In Data They

P rovided.

• Verify Er ror Value Accuracy Between 2 R elational D atabases (ATLAS And ADAS) For North

A merica And Europe Data.

• Develop A nd Maintain Production Grade Products By Working With In ternal/External Groups.

• Produce Charts From Workshop Surveys From Customers Regarding Satisfaction Of Product

Quality.

• Assist With Sample Selections For Ground Truth Testing Using Arcgis For Spatial Data Editing

A nd Drawing Of Charts.

• Demonstrate Knowledge Of D ata M anipulation A nd Visualization Skills.

• Craft Manual Documentations For All Aspects Of Ongoing Processes In Preparation For ISO

Review And Create Training Manuals For New Employee.

City of Chicago, Chicago, I L Senior Reporting Analyst

09/2000 to 12/2008

Business Objects m igration p hases from version 5x to XIr2. There were 6 p hases of this project:

M igration Assessment Study, Planning, and Migration to Test Environment, Customer Testing, User

Testing, and Production Implementation.

• Defined And Documented Prerequisites For Customer Acceptance And Sign-Off (1 Week To

Review And Sign Off On Plan).

• Defined And Documented The Technical Steps For The Migration.

• Migration Of The Existing Business Objects 5x Content To Xir2 Test Environment.

• Security Configuration Was Implemented.

• Reports And Universes Testing Were Done In The New Xir2 Environment By Key Users.

• Formal Business Objects Classes.

• Differences Demonstrated For Existing Users (Implementation And Rollouts, Web In telligence).

• Provided Customer Assistance With Production Implementation And Cutover.

Obj100

TONI R. PEARSON

8733 S. Calumet Avenue ~ Chicago, IL 60619 ~ 312-***-**** ~ *******@***.***

Programmer Analyst - Department of Children & Youth Services (CYS)

• Complied With T echnical D irection From The IT Director And I dentified I ssues T hat

A ffected The Work F low A nd Analyzed Problems In A Systematic But Timely Manner.

• Acted Quickly And Decisively To I mplement Solutions To Problems.

• Analyzed Current B usiness Operations A nd Access Potential Problems For New Projects As

T hey Came In to The Department.

• Used A rcview/Arcgis To Visualize, Create, Manage, And Analyze Geographical Data As

C artographer .

• Used M S Visio To Standardize Web Applications By Preparing Departmental Web Pages.

• Communicated Complex Processes And D ata F low Situations With The Use Of V IS IO For

M anagement Analysis Of Utilizing Storage Space And Computer Labs.

• Wrote SQL Queries To I mplement A n Inventory Tracking System Using A G U I I nterface To

A n Access Database.

• Strategized Post-Deployment And Deployment Of Hardware And Software To Clients Awarded

S tate Grants.

• Coded, Tested, Debugged & I nstalled D ifficult Programs For Centralized Usage For Other

Developers Work In MS Access.

• Converted, Build And Maintained Graphic And Non-Graphic Databases For Departmental

A pplications.

• Gathered A nd Translated The R equirements Of End-Users Request Into Web Pages With The

A bility To See What Was Wanted & Generated A Conceptual Solution Without Seeing The

Actual Product.

• Created Simple Pages/Template (Portals, Portlets, Text, Images) Layouts In Web D esign U sing

D reamweaver8 .

D esktop Technician - Department of Police

• Provided Substantial T echnical A nd Program Support For Department And 25 Districts

W hich Used Extensive Data Bases Or Data Systems For Crime Control Or Administrative

Purposes.

• I nstalled Databases (CHRIS, I MEDGE, MUGSHOT) To Meet The Data Processing And

A nalytical Needs Of The Department.

• I nstalled, U pgraded A nd T roubleshot Operating Systems: Windows 95/98/2000/XP And

M ugshot Cameras.

Computer Applications Analyst I - Department of Fi re

• Assisted In D evelopment A nd Modification Of A utomated Systems To Replace Manual

P rocess.

• I nterviewed Systems Users’ That Identified Information Process Needs.

Obj100

TONI R. PEARSON

8733 S. Calumet Avenue ~ Chicago, IL 60619 ~ 312-***-**** ~ *******@***.***

• Analyzed Work Flow And D ata Requirements Of Converting Process.

• Worked With O racle Corporation Team To D esign, I mplement A nd Maintain An O racle

I nformation Systems A nd Analytical Tools Converting F rom A Mainframe System.

• Gathered R equirements D uring I nception Phase, D ocumented A nd D elivered F unctional

Specification Documents, And Assisted A rchitecture A nalysis And D esign Using O racle

Forms And MS Applications.

• Took Part In The Preparation Of P roject P lan, User Acceptance Testing .

• Acheived Detailed Understanding Of Business Functionality And Took The Responsibility Of

P reparing The F unctionality T est P lan W hich Was Used By Testing Team While Doing Their

Testing Process.

• Took Part In The Meetings With Sr. Business Analyst And Managers And Understood Various

P rocess Plans, Business Process And Functionality In Detail. This Helped Me To Prepare

I ntegration T est P lan W hich Was Used For Doing A Detailed Testing On The Business

A pplications.

• Created B O 5x R eports (300) From Scratch And Adhoc Reports For Management.

• Managed Mul tiple Software D evelopment A nd Maintenance Projects.

• Designed A nd D eveloped P roduction Quality Information Systems In An Object O riented

D esign E nvironment.

E DUCAT ION

B.B.A, I l linois Institute of Technology, Chicago, I L

A.A., DeVry Institute of Technology, Chicago, I L

Obj100

Contact this candidate