尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
Lawrence Nowicki
PROFESSIONAL SUMMARY:
IT professional with over 20 years of technical IT experience and over 10 years of MS
Access development experience. Solid understanding of application design,
development, testing, and implementation of medium to large database projects utilizing
MS Access. Expertise in data and analytics with a demonstrated ability in data
manipulation and analysis of statistical data from large databases. Mr. Nowicki possesses
experience with designing tables, all query types, drop-downs, error messages, nested
formulas, conditional formatting, report creation, and automated distribution, use of MS
Excel Macros and VBA.
CORE COMPETENCIES:
 Proficient using MS Suite: MS Access, MS Excel, MS PowerPoint, MS
SharePoint, MS Word, MS Project.
 Advanced MS Access application design experience.
 Experienced with Excel functionalities, such as sliding, PowerPivot, PivotTables,
etc.
 Familiar with Excel functions and nesting formulas.
 Modifying and reading existing SQL statements; linking, importing, cleaning, and
spec creation of various data types.
 Experience designing tables, all query types, drop-downs, error messages, nested
formulas, conditional formatting, report creation, and automated distribution, use
of MS Excel Macros.
PROFESSIONAL EXPERIENCE:
Seeking employment – 07/2015-Present
Dell, Dearborn, MI – 04/2015-07/2015
Asset Management Analyst
 Prepare and reconcile reports for out-of-warranty hospital based computers.
Lifecycle of these assets are tracked and confirmed ready for disposal using a
proprietary application.
Delphi, Troy, MI – 05/2014-10/2014
MS Access Application Developer
 Designed and developed Supplier Contract database.
 Push-button database automatically imported multiple text files, created editable
views, then created and sent personalized small to medium sized mass mailings,
each with updated Excel attachments. Each button is customized for a specific
simplified user function.
 Use of looped SQL statements, interactive dialog boxes to add some decision
capabilities, error messaging to provide feedback.
 All mailings and attachments are also time-stamped and tracked – this new
procedure greatly improved time spent and simplified end-user input compared to
previous processes.
 Used VBA to execute different functions, i.e., import functions, mailing
functions.
Ford Motor Company, Dearborn, MI – 09/2013-05/2014
MS Access Application Developer (contract)
 Designed and developed Cost and Planning database.
 This menu driven “checkbook” database was used by multiple engineers, cost
analysts, and Paint, Body, and Final Assembly division management to monitor
spend rates, timelines, and milestones.
 Required extensive specifications and requirements gathering from three primary
reporting areas; Responsible for providing and presenting solutions for many
database requirements.
 Created highly customized database to meet the exact needs of the customer. Use
of multiple linked and auto-imported lookup reference tables, interactive queries,
conditional formatted forms, import & export of data tables, excel files,
automated charts with instant updates.
 Assisted in creating VBA functions.
Blue Cross and Blue Shield of Michigan, Detroit, MI – 03/1990-04/2013
Management Information Analyst Advanced
 Developed and maintained MS Access database applications.
 Designed and developed Precert/Appeals Turnaround database – this menu driven
database was used by up to 20 analysts daily and housed 40,000 records used for
various metrics reports and tracking status of Precertification cases.
 Performed Project Management Lead Analyst responsibilities, including
estimating and monitoring on-time delivery of Ad Hoc and recurring data requests
(BIRTS) using MS Access and Excel.
 Modified existing databases using VBA.
Project Data Analyst Advanced
 Developed and maintained MS Access database applications, including RMS time
tracking and project management tool, departmental employee profiles and report
descriptions, and departmental asset tracking .
 Provided quarterly, routine and ad hoc reports using MS Access and Excel for
BCBS projects and senior management.
 Reports provided trend information for claims and inquiry adjustment and
rejection activity.
 Created database applications, including departmental employee profiles and
report descriptions.
 Provided intranet file maintenance using SharePoint.
Project Management Analyst
 Provided project management support for planning and implementation of Care
Management and Standard of Acceptable Care project work-plans for the
Integrated Health Management department using Project Workbench software.
 Utilized the project master work-plan to identify opportunities for enhanced
resource, time and cost management.
 Designed and developed Issue Tracking System which utilized a networked
spreadsheet and Access97 reporting application, which allowed for immediate
updates on management level reports.
 Compiled and reported Care Management usage data for trend analysis.
EDUCATION SUMMARY:
Walsh College – Troy, MI
Master of Science in Financial Economics
Central Michigan University – Mt. Pleasant, MI
Bachelor of Science in Business Administration
Macomb Community College – Warren, MI
Associate’s Degree in Robotics and Flexible Automation

More Related Content

What's hot

Arvind _MSBI_3YearsExp
Arvind _MSBI_3YearsExpArvind _MSBI_3YearsExp
Arvind _MSBI_3YearsExp
Arvind Kumar Varma
 
Michael Liang Resume_Irvine_CA_ShortVersion
Michael Liang Resume_Irvine_CA_ShortVersionMichael Liang Resume_Irvine_CA_ShortVersion
Michael Liang Resume_Irvine_CA_ShortVersion
MICHAEL LIANG
 
aparna_sas
aparna_sasaparna_sas
aparna_sas
Aparna Mishra
 
Rajesh resume
Rajesh resumeRajesh resume
Rajesh resume
rajesh rajesh
 
profResume
profResumeprofResume
profResume
paul Lelekumo
 
GCharles_Resume_Summer_2016_SS_Short
GCharles_Resume_Summer_2016_SS_ShortGCharles_Resume_Summer_2016_SS_Short
GCharles_Resume_Summer_2016_SS_Short
sshgc
 
Yang Kong's Resume for QA
Yang Kong's Resume for QAYang Kong's Resume for QA
Yang Kong's Resume for QA
Yang Kong
 
Theodore Baar - Business Intelligence
Theodore Baar - Business IntelligenceTheodore Baar - Business Intelligence
Theodore Baar - Business Intelligence
Ted Baar
 
MISResume
MISResumeMISResume
Beyond InfoPath
Beyond InfoPathBeyond InfoPath
Beyond InfoPath
Shailen Sukul
 
Scott_Laurel_Resume
Scott_Laurel_ResumeScott_Laurel_Resume
Scott_Laurel_Resume
Scott Laurel
 
SSAS - Other Cube Browsers
SSAS - Other Cube BrowsersSSAS - Other Cube Browsers
SSAS - Other Cube Browsers
Peter Gfader
 
Analyst Resume
Analyst ResumeAnalyst Resume
Analyst Resume
Melissa Byrd
 
Reports with SQL Server Reporting Services
Reports with SQL Server Reporting ServicesReports with SQL Server Reporting Services
Reports with SQL Server Reporting Services
Peter Gfader
 
Resume (sas)
Resume (sas)Resume (sas)
Resume (sas)
Ekansh Aggarwal
 
Frederic Ellise 04-06-2016
Frederic Ellise 04-06-2016Frederic Ellise 04-06-2016
Frederic Ellise 04-06-2016
Frederic Ellise
 
SQL Server Reporting Services
SQL Server Reporting ServicesSQL Server Reporting Services
SQL Server Reporting Services
Ahmed Elbaz
 
Fast Focus: SQL Server Graph Database & Processing
Fast Focus: SQL Server Graph Database & ProcessingFast Focus: SQL Server Graph Database & Processing
Fast Focus: SQL Server Graph Database & Processing
Karen Lopez
 
HsiehJungchanMCITP2014Q4hitFBI
HsiehJungchanMCITP2014Q4hitFBIHsiehJungchanMCITP2014Q4hitFBI
HsiehJungchanMCITP2014Q4hitFBI
Jungchan Hsieh
 
Qidb resume
Qidb resumeQidb resume
Qidb resume
Bin Qi
 

What's hot (20)

Arvind _MSBI_3YearsExp
Arvind _MSBI_3YearsExpArvind _MSBI_3YearsExp
Arvind _MSBI_3YearsExp
 
Michael Liang Resume_Irvine_CA_ShortVersion
Michael Liang Resume_Irvine_CA_ShortVersionMichael Liang Resume_Irvine_CA_ShortVersion
Michael Liang Resume_Irvine_CA_ShortVersion
 
aparna_sas
aparna_sasaparna_sas
aparna_sas
 
Rajesh resume
Rajesh resumeRajesh resume
Rajesh resume
 
profResume
profResumeprofResume
profResume
 
GCharles_Resume_Summer_2016_SS_Short
GCharles_Resume_Summer_2016_SS_ShortGCharles_Resume_Summer_2016_SS_Short
GCharles_Resume_Summer_2016_SS_Short
 
Yang Kong's Resume for QA
Yang Kong's Resume for QAYang Kong's Resume for QA
Yang Kong's Resume for QA
 
Theodore Baar - Business Intelligence
Theodore Baar - Business IntelligenceTheodore Baar - Business Intelligence
Theodore Baar - Business Intelligence
 
MISResume
MISResumeMISResume
MISResume
 
Beyond InfoPath
Beyond InfoPathBeyond InfoPath
Beyond InfoPath
 
Scott_Laurel_Resume
Scott_Laurel_ResumeScott_Laurel_Resume
Scott_Laurel_Resume
 
SSAS - Other Cube Browsers
SSAS - Other Cube BrowsersSSAS - Other Cube Browsers
SSAS - Other Cube Browsers
 
Analyst Resume
Analyst ResumeAnalyst Resume
Analyst Resume
 
Reports with SQL Server Reporting Services
Reports with SQL Server Reporting ServicesReports with SQL Server Reporting Services
Reports with SQL Server Reporting Services
 
Resume (sas)
Resume (sas)Resume (sas)
Resume (sas)
 
Frederic Ellise 04-06-2016
Frederic Ellise 04-06-2016Frederic Ellise 04-06-2016
Frederic Ellise 04-06-2016
 
SQL Server Reporting Services
SQL Server Reporting ServicesSQL Server Reporting Services
SQL Server Reporting Services
 
Fast Focus: SQL Server Graph Database & Processing
Fast Focus: SQL Server Graph Database & ProcessingFast Focus: SQL Server Graph Database & Processing
Fast Focus: SQL Server Graph Database & Processing
 
HsiehJungchanMCITP2014Q4hitFBI
HsiehJungchanMCITP2014Q4hitFBIHsiehJungchanMCITP2014Q4hitFBI
HsiehJungchanMCITP2014Q4hitFBI
 
Qidb resume
Qidb resumeQidb resume
Qidb resume
 

Viewers also liked

Strategies2015
Strategies2015Strategies2015
Strategies2015
Klara Onallah
 
Business Strategy
Business StrategyBusiness Strategy
Business Strategy
Florida Attorney Search
 
Decentralization of education service ogawa
Decentralization of education service ogawaDecentralization of education service ogawa
Decentralization of education service ogawa
Munkh Orgil
 
Venture planning in nursing
Venture planning in nursingVenture planning in nursing
Venture planning in nursing
Eko Priyanto
 
Curriculum process
Curriculum process Curriculum process
Curriculum process
Eko Priyanto
 
Unit 4 methods of data collection
Unit 4 methods of data collectionUnit 4 methods of data collection
Unit 4 methods of data collection
Eko Priyanto
 
Unit plan
Unit planUnit plan
Unit plan
Eko Priyanto
 
1 sistemas de numeración
1 sistemas de numeración1 sistemas de numeración
1 sistemas de numeración
conrado perea
 
32 windows xp
32 windows xp32 windows xp
32 windows xp
conrado perea
 
30 sistema de archivos
30 sistema de archivos30 sistema de archivos
30 sistema de archivos
conrado perea
 

Viewers also liked (10)

Strategies2015
Strategies2015Strategies2015
Strategies2015
 
Business Strategy
Business StrategyBusiness Strategy
Business Strategy
 
Decentralization of education service ogawa
Decentralization of education service ogawaDecentralization of education service ogawa
Decentralization of education service ogawa
 
Venture planning in nursing
Venture planning in nursingVenture planning in nursing
Venture planning in nursing
 
Curriculum process
Curriculum process Curriculum process
Curriculum process
 
Unit 4 methods of data collection
Unit 4 methods of data collectionUnit 4 methods of data collection
Unit 4 methods of data collection
 
Unit plan
Unit planUnit plan
Unit plan
 
1 sistemas de numeración
1 sistemas de numeración1 sistemas de numeración
1 sistemas de numeración
 
32 windows xp
32 windows xp32 windows xp
32 windows xp
 
30 sistema de archivos
30 sistema de archivos30 sistema de archivos
30 sistema de archivos
 

Similar to Lawrence Nowicki Resume July2015

Chris_Eriksen_Resume
Chris_Eriksen_ResumeChris_Eriksen_Resume
Chris_Eriksen_Resume
Chris Eriksen
 
Resume
ResumeResume
Resume
Ravi Mehra
 
Linda Ege Resume
Linda Ege ResumeLinda Ege Resume
Linda Ege Resume
Linda Ege
 
shun(Michael)_Liang_Resume_2-1-2017
shun(Michael)_Liang_Resume_2-1-2017shun(Michael)_Liang_Resume_2-1-2017
shun(Michael)_Liang_Resume_2-1-2017
MICHAEL LIANG
 
Ankit Patel - Tableau Developer
Ankit Patel - Tableau DeveloperAnkit Patel - Tableau Developer
Ankit Patel - Tableau Developer
Ankit Patel
 
Resume - Stuart Arnold
Resume - Stuart ArnoldResume - Stuart Arnold
Resume - Stuart Arnold
Stuart Arnold
 
Richard cooper no phone- 8-2015
Richard cooper  no phone- 8-2015Richard cooper  no phone- 8-2015
Richard cooper no phone- 8-2015
Richard Cooper
 
ResumeB
ResumeBResumeB
ResumeB
Scott Bennett
 
Resume_YueWang
Resume_YueWangResume_YueWang
Resume_YueWang
Yue Wang
 
CV
CVCV
Brooks Powell Resume 2010-09-10
Brooks Powell Resume 2010-09-10Brooks Powell Resume 2010-09-10
Brooks Powell Resume 2010-09-10
Brooks Powell, ITIL v3F, MCP, Lean6σ YellowBelt
 
OMAR_SANTIAGO_resume_2015
OMAR_SANTIAGO_resume_2015OMAR_SANTIAGO_resume_2015
OMAR_SANTIAGO_resume_2015
Omar Santiago
 
Sophia wang (2)
Sophia wang (2)Sophia wang (2)
Sophia wang (2)
Dibakar27
 
Resume: Joseph S. Valencia
Resume: Joseph S. ValenciaResume: Joseph S. Valencia
Resume: Joseph S. Valencia
JoeValencia32
 
Resume_Sanket_S_Manjrekar - Software Developer
Resume_Sanket_S_Manjrekar - Software DeveloperResume_Sanket_S_Manjrekar - Software Developer
Resume_Sanket_S_Manjrekar - Software Developer
Sanket S. Manjrekar
 
Sql Resume Jl Herndon
Sql Resume Jl HerndonSql Resume Jl Herndon
Sql Resume Jl Herndon
JessicaLHerndon
 
GSLResume_May2015
GSLResume_May2015GSLResume_May2015
GSLResume_May2015
Gary Love
 
Colinsobersbiresume 20120723doc
Colinsobersbiresume 20120723docColinsobersbiresume 20120723doc
Colinsobersbiresume 20120723doc
colinsobers
 
Nikhil_MSBI_updated
Nikhil_MSBI_updatedNikhil_MSBI_updated
Nikhil_MSBI_updated
Nikhil Korripati
 
Gregory.Harvey.2015
Gregory.Harvey.2015Gregory.Harvey.2015
Gregory.Harvey.2015
Greg Harvey
 

Similar to Lawrence Nowicki Resume July2015 (20)

Chris_Eriksen_Resume
Chris_Eriksen_ResumeChris_Eriksen_Resume
Chris_Eriksen_Resume
 
Resume
ResumeResume
Resume
 
Linda Ege Resume
Linda Ege ResumeLinda Ege Resume
Linda Ege Resume
 
shun(Michael)_Liang_Resume_2-1-2017
shun(Michael)_Liang_Resume_2-1-2017shun(Michael)_Liang_Resume_2-1-2017
shun(Michael)_Liang_Resume_2-1-2017
 
Ankit Patel - Tableau Developer
Ankit Patel - Tableau DeveloperAnkit Patel - Tableau Developer
Ankit Patel - Tableau Developer
 
Resume - Stuart Arnold
Resume - Stuart ArnoldResume - Stuart Arnold
Resume - Stuart Arnold
 
Richard cooper no phone- 8-2015
Richard cooper  no phone- 8-2015Richard cooper  no phone- 8-2015
Richard cooper no phone- 8-2015
 
ResumeB
ResumeBResumeB
ResumeB
 
Resume_YueWang
Resume_YueWangResume_YueWang
Resume_YueWang
 
CV
CVCV
CV
 
Brooks Powell Resume 2010-09-10
Brooks Powell Resume 2010-09-10Brooks Powell Resume 2010-09-10
Brooks Powell Resume 2010-09-10
 
OMAR_SANTIAGO_resume_2015
OMAR_SANTIAGO_resume_2015OMAR_SANTIAGO_resume_2015
OMAR_SANTIAGO_resume_2015
 
Sophia wang (2)
Sophia wang (2)Sophia wang (2)
Sophia wang (2)
 
Resume: Joseph S. Valencia
Resume: Joseph S. ValenciaResume: Joseph S. Valencia
Resume: Joseph S. Valencia
 
Resume_Sanket_S_Manjrekar - Software Developer
Resume_Sanket_S_Manjrekar - Software DeveloperResume_Sanket_S_Manjrekar - Software Developer
Resume_Sanket_S_Manjrekar - Software Developer
 
Sql Resume Jl Herndon
Sql Resume Jl HerndonSql Resume Jl Herndon
Sql Resume Jl Herndon
 
GSLResume_May2015
GSLResume_May2015GSLResume_May2015
GSLResume_May2015
 
Colinsobersbiresume 20120723doc
Colinsobersbiresume 20120723docColinsobersbiresume 20120723doc
Colinsobersbiresume 20120723doc
 
Nikhil_MSBI_updated
Nikhil_MSBI_updatedNikhil_MSBI_updated
Nikhil_MSBI_updated
 
Gregory.Harvey.2015
Gregory.Harvey.2015Gregory.Harvey.2015
Gregory.Harvey.2015
 

Lawrence Nowicki Resume July2015

  • 1. Lawrence Nowicki PROFESSIONAL SUMMARY: IT professional with over 20 years of technical IT experience and over 10 years of MS Access development experience. Solid understanding of application design, development, testing, and implementation of medium to large database projects utilizing MS Access. Expertise in data and analytics with a demonstrated ability in data manipulation and analysis of statistical data from large databases. Mr. Nowicki possesses experience with designing tables, all query types, drop-downs, error messages, nested formulas, conditional formatting, report creation, and automated distribution, use of MS Excel Macros and VBA. CORE COMPETENCIES:  Proficient using MS Suite: MS Access, MS Excel, MS PowerPoint, MS SharePoint, MS Word, MS Project.  Advanced MS Access application design experience.  Experienced with Excel functionalities, such as sliding, PowerPivot, PivotTables, etc.  Familiar with Excel functions and nesting formulas.  Modifying and reading existing SQL statements; linking, importing, cleaning, and spec creation of various data types.  Experience designing tables, all query types, drop-downs, error messages, nested formulas, conditional formatting, report creation, and automated distribution, use of MS Excel Macros. PROFESSIONAL EXPERIENCE: Seeking employment – 07/2015-Present Dell, Dearborn, MI – 04/2015-07/2015 Asset Management Analyst  Prepare and reconcile reports for out-of-warranty hospital based computers. Lifecycle of these assets are tracked and confirmed ready for disposal using a proprietary application. Delphi, Troy, MI – 05/2014-10/2014 MS Access Application Developer  Designed and developed Supplier Contract database.  Push-button database automatically imported multiple text files, created editable views, then created and sent personalized small to medium sized mass mailings, each with updated Excel attachments. Each button is customized for a specific simplified user function.  Use of looped SQL statements, interactive dialog boxes to add some decision capabilities, error messaging to provide feedback.
  • 2.  All mailings and attachments are also time-stamped and tracked – this new procedure greatly improved time spent and simplified end-user input compared to previous processes.  Used VBA to execute different functions, i.e., import functions, mailing functions. Ford Motor Company, Dearborn, MI – 09/2013-05/2014 MS Access Application Developer (contract)  Designed and developed Cost and Planning database.  This menu driven “checkbook” database was used by multiple engineers, cost analysts, and Paint, Body, and Final Assembly division management to monitor spend rates, timelines, and milestones.  Required extensive specifications and requirements gathering from three primary reporting areas; Responsible for providing and presenting solutions for many database requirements.  Created highly customized database to meet the exact needs of the customer. Use of multiple linked and auto-imported lookup reference tables, interactive queries, conditional formatted forms, import & export of data tables, excel files, automated charts with instant updates.  Assisted in creating VBA functions. Blue Cross and Blue Shield of Michigan, Detroit, MI – 03/1990-04/2013 Management Information Analyst Advanced  Developed and maintained MS Access database applications.  Designed and developed Precert/Appeals Turnaround database – this menu driven database was used by up to 20 analysts daily and housed 40,000 records used for various metrics reports and tracking status of Precertification cases.  Performed Project Management Lead Analyst responsibilities, including estimating and monitoring on-time delivery of Ad Hoc and recurring data requests (BIRTS) using MS Access and Excel.  Modified existing databases using VBA. Project Data Analyst Advanced  Developed and maintained MS Access database applications, including RMS time tracking and project management tool, departmental employee profiles and report descriptions, and departmental asset tracking .  Provided quarterly, routine and ad hoc reports using MS Access and Excel for BCBS projects and senior management.  Reports provided trend information for claims and inquiry adjustment and rejection activity.  Created database applications, including departmental employee profiles and report descriptions.  Provided intranet file maintenance using SharePoint. Project Management Analyst
  • 3.  Provided project management support for planning and implementation of Care Management and Standard of Acceptable Care project work-plans for the Integrated Health Management department using Project Workbench software.  Utilized the project master work-plan to identify opportunities for enhanced resource, time and cost management.  Designed and developed Issue Tracking System which utilized a networked spreadsheet and Access97 reporting application, which allowed for immediate updates on management level reports.  Compiled and reported Care Management usage data for trend analysis. EDUCATION SUMMARY: Walsh College – Troy, MI Master of Science in Financial Economics Central Michigan University – Mt. Pleasant, MI Bachelor of Science in Business Administration Macomb Community College – Warren, MI Associate’s Degree in Robotics and Flexible Automation
  翻译: