Michael J. Litwin
**** **** **** abnjig@r.postjobfree.com
Madison, WI 53719 303-***-****
To obtain a position in a company that will provide an opportunity to use my
Objective:
statistical math and computer abilities for both contribution and advancement.
MS Excel(1), MS Access(1), SAS(2), SQL(2), SPSS(2), VBA(2), Cognos(3),
Computer:
Oracle – Siebel Analytics(2), Windows Vista(1), Windows XP(1), 2000(1), MS
Word(1), MS Powerpoint(2), People Soft V 6.0, 7.0(3), WorldMerge(1), 7.5 /
People Soft Query(3), DOS 5.0-6.0(2), Turbo C++(3), Basic and Pic Compiler(3)
Level of Skill: 1 – Expert, 2-Moderate, 3-Beginner
August 2008 to September 2009
Professional
DirecTV Englewood, CO, 80112
History:
Senior Business Analyst (Business Analytics)
Service Call Reduction analysis.
o Weekly reports measuring service calls metrics received from
customers within 7 or 30 days of technician performing customer
work orders.
o Coded SAS to collect and assemble data. SAS then generated
report exported into a clear, concise Excel format.
o Identified markets where metrics where not met by DirecTV.
Saved DirecTV $100,000 to $150,000 in quarterly
payouts to markets not meeting metric requirements.
Time in Motion study
o Analyzed timeframes for DirecTV installation.
o Identified deficiencies of scheduling times.
o Recommended increasing time frames to optimize scheduling
technician work.
Resulted in more efficient scheduling of technicians
daily work and reduced schedules.
Recommended increasing piece rate pay to technicians
to offset scheduling optimization and reduction of
technician work schedules.
o Improved expectations of technicians to perform work in timely
manner.
General duties
o Powerpoint / SAS/ Excel / Word to present analysis results to
Executive Team.
October 2007 to August 2008
Foothills Behavioral Health Westminster, CO, 80012
Data Analyst (Utilization Management)
Quarterly Reports automated in MS Access and MS Excel:
o Reports reflecting Medicaid and Medicare client’s days in care,
costs associated, usage of state facilities.
o Created automated database to produce reports.
o Improved time frame to complete reports.
Manual process converted to automated process.
Reduced time frame to assemble reports by 90%.
Created Provider directory using MS Access platform.
o Reduced time to identify therapists offering services for
Medicaid and Medicare clients.
o Aided in identifying best match for clients therapeutic needs
Analysis Projects
Michael J. Litwin
6929 East Pass abnjig@r.postjobfree.com
Madison, WI 53719 303-***-****
Identified costs and percent of clients associated with inpatient
o
care with specific diagnosis.
Set reasonable expectations of costs associated with inpatient
o
care.
Aided RFP for state contract providing optimal expected average
o
costs of Medicaid and Medicare clients.
November 2002 to October 2007
Human Synergistics/Center for Applied Research
Arlington Heights, IL 60004
Data Analyst
Organizational Culture, Effectiveness, Leadership Impact/Strategy
survey project coordination.
o Identified subgroups to report survey results.
o Managed 5 to 1000+ users.
o Maintained schedule of survey completion.
o Sent initial invitations, reminders to survey participants.
o Reported survey completion rates to clients.
Survey results reporting.
o Survey collection, assembly using SPSS, Excel and Word.
o Reported means, significant differences, comparative profiles.
Tracking Databases
o Created tracking databases in Excel moving away from manual
tracking procedures.
o Improved ability of project coordinators to quickly identify
completion rates.
o Aided identification of users required to complete surveys.
o Streamlined setup process of survey collection websites.
Identify survey participants.
Identify survey requirements of demographics.
Aided in setting customer time frame expectations.
April 1997 to September 2002
Alternative Resources Corporation (ARC) Barrington IL, 60010
Financial Analyst 9/97 – 9/02
Weekly and Monthly Financial Database.
o Created, developed, and maintained financial reporting using
Excel and Access.
o Compared current project revenue to forecasted revenue to
ensure compliance with executed contracts.
Quality assurance expense audits.
o Identified sales personnel expenses.
o Identified unacceptable expense practices.
Bank Reconciliations of Account receivable.
Maintained Fixed Assets.
Database that linked Revenue, Payroll, and Expenses of IT Staffing
projects.
o Created and maintained database.
o Aided in reconciling expenses and payroll compared to Revenue.
Project Coordinator 4/97 – 9/97
Managed Technology Deployment projects
o Nationwide basis
o Consisting of 30-50 regions across local U.S.
Michael J. Litwin
6929 East Pass abnjig@r.postjobfree.com
Madison, WI 53719 303-***-****
Coordination of regions and client schedule to maintain project schedule.
Compiled Invoicing details for Project billing in Excel.
June 1996 to March 1997
Ingram Systems and Research Inc Franklin Park, IL, 60131
Systems Analyst
Developed and analyzed sets of test data for on site projects
Designed robotic tester for phone keyboard
Researched information for Analog to Digital Converters
Participated in team project for the design of amplifiers
Bachelor of Arts, December 1995
Education:
Southern Illinois University, Carbondale, IL
Major in Mathematics, Minor in Physics
Related courses: Statistics, SAS Programming, Fourier Analysis
Provided Upon Request
References: