Data Analyst

Qualifications for Information Systems Management

Systems analysis professional with proven expertise providing applications support, facilitating client training, and troubleshooting in windows environments. Solid experience in PC/LAN administration and analysis.

Technical Expertise

Hardware Compaq and HP Servers, IBM PS/2, Unix and HP Laser Jet Printers, PCMICA, DHCP Server, Ethernet (3COM PRO 10/100), Cable Modem 10BASE/T, RJ45 C5, RG6 Coax

Mainframe IBM AS400, 3090/3084, RAMIS, CITYCIPA, ADVANTIS, MVS, TSO/ISPF, IMS, RUMBA, GUTS (EXTRA), TELNET, COBOL

Software LiDAR, ADAS/SQT, , GIS Arcmap, ArcGis9, NTRP, TMC Forum, MapPoint, Oracle HRMS, Business Objects XIR2, BusinessObjects Enterprise Developer (Designer & Administrator), Central Management Console, BusinessObjects 5.1 (Superviser & Designer), SnagIt, FileNet/Web Site Manager, COPANET, SharePoint, MS Access, DreamWeaver8, VISIO, PhotShop6, NetMeeting, GroupWise, Office(2000/2003/2007),CSG Telecom, PCI/ISA, CompuServe/LAN/WAN, Netview, Admin4x, Advantis Password, DREMS, Advantive, Voice Mail (FOCUS), ProComm Plus 3x Internet/Intranet Netscape, PC Console

Operating Systems Windows: 3.11, 95, NT 3.51&4.0, 98, 2000, XP; DOS 6.22

Miscellaneous COBOL, SQL, HTML, XML, Novell NetWare 3.x/4.x, TCP/IP

Data Analyst NAVTEQ 10/2009-Present

Provide statistical advice and guidance to clients interested in making decisions through the analysis or collection of data

 Run ADAS analytical tool to produce statistical results using SQT tool

 Craft manual documentation for department standards per projects

 Created documentation for training

 Produce charts from workshop surveys from customers regarding satisfaction of product quality

 Validate error value accuracy between 2 regional databases using ATLAS tool

 Interface with business clients to update them on progress of gap analysis in data provided

 Use ArcGIS for spatial data editing and drawing graphs

 Use other in-house tools to view/edit/analyze spatial data, and draw charts

 Assist with sample selections for Ground Truth testing

 Assist with any other help needed by the Program Manager and the Statistician

Data Analyst

Position purpose was to conduct research and analysis on spatial datasets with goal of supporting and developing derivative datasets for use in with conjunction with existing NAVTEQ products

 Generated and test value statement hypotheses for new datasets using the NTRP tool

 Developed prototype data products and provided performance analysis products by creating PIVOT tables

 Executed processes to create prototype products

 Developed and maintained production grade products by work with internal/external groups

 Created, maintained and expanded as necessary, geo-spatial referencing database components

 Demonstrated knowledge of data manipulation and visualization skills

 Implemented geospatial technology into existing processes in order to utilize and recommend the most effective tools for task completion

 Created documentation for all aspects of ongoing processes in preparation for ISO certification and review

Page 1 of 3

Senior Programmer/Analyst City of Chicago 09/2000-12/2008

Department of Innovation and Technology (DoIT)

The focus of this position was Oracle reporting, data base administration and web development

 System Administration for the Central Management Console

 Business Objects Designer and Supervisor modules

 Business Objects version 5x/XI Client/Server reporting

 Worked with SQL queries for data manipulate with the tables in the Universe

 Web-based application design and development

 System Design, Analysis and System Implementation

 Developed and executed training/communication

 Converted 70 Universes City wide at the row/object level using the WHERE clause (Designer tool)

 Migrated all 5x corporate reports and personal documents to XIR2 reports/documents

 Sent out instructions on how to prepare reports for migration to 5000 end-users (Supervisor and Designer tools – 5x/XIR2)

 Used Central Management Console (CMC) to set up and administer all end users individual and group accounts

 Expert with loading Oracle 6 and Deski Business Objects for certain individuals City wide

Department of Children & Youth Services (CYS)

Used GIS Arcmap software and other databases to analyze and assess various data sets for accuracy & completeness utilizing the city Web Interpreter; Analyzed current business operations/problems; Coded, tested, debugged & installed difficult programs for centralized usage; Developed programs to conform to system changes; Translated the requirements of end-users request into web pages with the ability to see what was wanted & generated a conceptual solution without seeing the actual product

 Used MS Visio to standardizing Web applications by preparing departmental web pages standards

 Wrote SQL queries in MS Access for data manipulations

 Strategized deployment of hardware and software to clients in educational systems

 Designed an Inventory database using MS Access and created a GUI interface screen

 Geocoded data files and manipulated data laysers

 Accessed the City’s GIS data repository to obtain base map data and data layers

 Build maps from GIS software then created objects, added graphs and other graphic materials to the map

 Utilized the Address Locator to obtain accurate addresses

 Manipulated GIS and departmental databases to generate tabular and cartographic output

 Converted, build and maintained graphic and non-graphic databases for departmental applications

 Complied with technical direction of the IT Director and identified issues that affected the work, analyzed problems in a systematic but timely manner, acted quickly and decisively to implement solutions

 Created, designed, and coded for other developers work effort in MS Access

 Communicated complex process and data flow situations with the use of process flow diagrams (VISIO)

 Uploaded files, created hyperlinks, added or removed pages from Web site and navigation in COPANET

 Posted, Published & maintained the functionality of the Web site of COPA

 Created simple pages/template (portals, portlets, text, images) layouts in web design

Department of Police

Provided substantial technical and program support for department and 25 districts which used extensive data bases or data systems for crime control or administrative purposes.

 Programmed and manipulated databases (CHRIS,IMEDGE,MUGSHOT) to meet the data processing and analytical needs of the department/unit

Page 2 of 3

Work History, Continued

 Provided substantial program expertise in support of department program objectives most technical as well as subject area/program problems

 Installed, upgraded, and troubleshot operating systems Windows 95/98/2000/XP and Mugshot cameras

Department of Fire

Assisted in development and modification of automated systems to replace manual process. Interviewed systems users’ that identified information process needs. Analyzed work flow and data requirements of converting process.

 Worked with Oracle Corporation team to design, implement and maintain an Oracle information system and analytical tools converting from a mainframe system.

 Gathered requirements during inception phase, documented and delivered functional specification documents, and assisted architecture analysis and design using Oracle forms and MS application

 Took part in the preparation of Project plan, user acceptance testing. Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.

 Took part in the meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail. This helped me to prepare Integration Test Plan which was used for doing a detailed testing on the business application.

 Created BO 5x reports from scratch and adhoc reports for management

 Managed multiple software development & maintenance projects

 Designed & developed production quality information systems in an Object Oriented Design Environment

 Performed analysis of system & business requirements as it related to system design

 Assigned tasks and managed technical details of programming staff during software development and support of business operations

 Managed budgets and staff to effectively meet business goals

 Demonstrated ability to manage the technical details and staff assignments during software development and web based application development

Cable/Modem Repair Technician RCN 02/2000 - 08/2000

Troubleshot external modems via NT network environments and PC/Macintosh TCP/IP for DHCP servers using automatic and manual processes in Windows 95/98/NT/2000. Set up e-mail accounts using an NT network for ISP customers on Netscape, Outlook Express, and Outlook.

 Solved problems related to outages on bridger addresses/hub sites and nodes. Monitored the Ping IP addresses of desktop/laptop NICs and MAC modem addresses on 3 COM and Nortel modems.

Database Administrator-Y2K Project Teksystems (Michael Reese Hospital) 01/1999 -12/ 2000

Assisted with conversion/improvement plans and providing documentation recommendations.

 Updated a MS Access inventory database using Y2K compliance software.

 Made research data available online to facilitate manufacturers’ access to Y2K compliance guidelines.

Consultant Teksystems (Northwestern Memorial Hospital)

Supported mainframe operations and over 1,000 users.

 Provided second-level support for MS Office 97 and Exchange/Outlook software.

 Performed Novell LAN administration, which included creating and expunging LAN user accounts.

Education

B.B.A., Management Information Systems, Illinois Institute of Technology

A.A., Electronic Technician Science, DeVry Institute of Technology

Graduate Studies

Geographic Information Systems, Chicago State University

Interest

Research and write RFP’s : Awarded Digital Divide/DCEO Grant (2006)

Page 3 of 3

Contact this candidate