Analyst Data
Resume:
Richard C. Cynowa
** ****** ****, ********, ** 60559
**********@*******.***
Business Analyst with SharePoint experience versed in usability design of
web sites, reporting, and documentation. Over 10 years of IT experience as
an application designer/developer. Detail oriented team player with good
project management skills. Possess client focused analytical ability,
which facilitates implementation and timely resolution of process issues.
EDUCATION
M.S. Information Architecture, Illinois Institute of Technology, Chicago,
IL
B.S. Computer Information Systems, DeVry Institute of Technology, Lombard,
IL
TRAINING
Languages: ASP, Java, Perl/CGI, PHP and MySQL, Visual Basic
Software: Dreamweaver, FrontPage, Photoshop, Joomla! (Content Management
System)
Classes: Web Usability Design, Knowledge Management, Research & Usability
Testing, Instructional Design
TECHNICAL SKILLS
Languages: SQL, VBA, HTML, CSS, JavaScript, FOCUS, RPG/400
Software: SharePoint, MS Access/Excel/Project/Word, Visio, Stylus Studio
(XML), Cognos
PROFESSIONAL EXPERIENCE
Consultant 1/2009 - Present
. Redesigned a SharePoint site (and added a workflow process) for a
Sales/Education group at Allstate. Created a number of job aids to
assist the users of the site in the different processes.
. Creating small business web sites using templates and custom HTML/CSS
(e.g. www.jstanulis.com and www.smbwebsites.com). SharePoint site:
http://sp.smbwebsites.com
. Created a SharePoint site for a non-profit development project using
SharePoint Designer.
ALLSTATE (Computer Resource Solutions), Northbrook, IL 1/2008 -
12/2008
Report Analyst/SharePoint Site Administrator (Consultant)
. Created ad hoc and monthly (i.e. dashboard, expense, status, and
compliance) reports using MS Excel and Access.
. Created process/business flow diagrams using Visio.
. Created report requirements based on user and business needs.
. Managed SharePoint intranet sites (e.g. adding users, troubleshooting,
answering questions, and training) and version 2 to version 3 upgrade
(i.e. communication to users, training, documentation, setup of
libraries/groups/users, etc.).
UNIVERSITY OF CHICAGO, Chicago, IL 7/2007 - 10/2007
Business Analyst/Developer (Consultant)
. Created MS Access application and MS Excel reports using VBA to generate
a Bed Geography Census reporting system for the University of Chicago
Hospital.
UNIVERSITY OF CHICAGO (Physicians Group), Burr Ridge, IL 3/2006 - 4/2007
Business Intelligence Analyst
. Created ad hoc reports (i.e. mostly accounts receivable) based on user
requests in a fast paced environment using a combination of SQL, MS
Access, MS Excel (incorporating pivot tables/charts as needed).
Richard Cynowa Page 2
. Designed online form that assisted users in submitting report requests
and helped expedite the report creation process.
. Created process using Stylus Studio to generate XML files from multiple
data feeds.
. Created Bed Geography Census report requirements document for University
of Chicago Hospital.
ILLINOIS INSTITUTE OF TECHNOLOGY, Chicago, IL 8/2001 - 2/2006
Programmer/Analyst/Information Specialist
. Designed and developed official university admission and enrollment
reports (40 - 50 pages each) using MS Access, Excel, and VBA, including
user documentation.
. Implemented a government mandated, university wide international
tracking/reporting requirement, which included:
. Programming, testing, training, troubleshooting, and coordination of
all events
. Created both user and administrator support documentation
. Developed programs using FOCUS for ad hoc reports and data updates.
. Responsible for official admission and enrollment reporting within the
university, various external surveys, reporting requirements, and
information requests.
. Integrated a new admission system with a legacy system.
. Created data requirements, data flow diagrams, and support
documentation of field mapping between both systems.
. Developed programs using FOCUS and TCL, which generates over 40,000
batch transactions handling over 7,000 applications nightly.
. Responsible for Q/A, which involved creating and executing various
test plans.
COMDISCO, INC., Rosemont, IL 10/2000 - 5/2001
Business Systems Analyst
Developed design requirements for enhancements to a Web based application.
. Created more detailed and structured designs resulting in an accelerated
development time of application enhancements.
. Coordinated meetings between cross-functional teams to determine customer
requirements.
NEW RESOURCES CORPORATION, Rolling Meadows, IL 1/1997 - 8/2000
Staff Consultant - Provided IT consulting to diverse clients
U.S. Cellular, Chicago, IL (1998 - 2000)
. Ensured that codes/bill items which were part of the client's new billing
system conversion process were entered correctly, by using MS Access, SQL
and the documented conversion rules.
. Achieved an on-time data delivery schedule for cycle testing and
conversions by effectively training 3 - 4 data entry people and
coordinating their efforts.
Fujisawa USA, Inc., Deerfield, IL (1998)
. Accurately populated a new set of files over several libraries by writing
RPG and CL programs, which resulted in successful transfer of
information.
Viskase Corporation, Chicago, IL (1997 - 1998)
. Created online screens and printed reports to support new business
applications by writing RPG and CL programs.
. Developed RPG and CL programs to be used in the process of loading data
into 'Red Brick' data warehouse.
. Succeeded in effectively transferring data from legacy system into ACT!
by creating RPG and CL programs to export data, further manipulating the
data using MS Access.
Contact this candidate