SQL
Jennifer Pruyn
Huntley
Summary
Goal-oriented professional with expertise in enhancing operational standards and team organization. Proven ability to implement effective employee engagement strategies that drive productivity. Strong analytical skills utilized to streamline processes and prioritize tasks efficiently. Extensive experience with a demonstrated track record of achieving measurable results.
Overview
25
25
years of professional experience
Work History
Business Systems Analyst Senior
Advocate Health
Oak Brook
03.2018 - Current
- Safeguarded the security of the Health Information Technology system(s) through identity, process, and documentation management.
- Ensured the priority of patient care was maintained through customer service, respect and teamwork.
- Responsible for report and dashboard development across several teams monitoring operational and executive objectives.
- Identified and mediated resolutions and improvements to existing system processes.
- Documented and communicated changes to team for implementation.
- During a significant transition of staffing, ensured that systems, processes and work flows continued to operate as needed, and identifying escalation points as needed.
- Responsible for Physician Orientation and onboarding to access to organizational systems.
- Part of an on-call rotation for the security and access management to electronic medical record and additional systems.
IT Manager
MEADOWS CREDIT UNION
Palatine
03.2012 - 02.2018
- Directed the strategic technological planning and support of the Credit Union as part of the leadership team, through infrastructure and systems growth and adapting to the changing IT landscape and security threats.
- Planned, communicated and implemented Credit Union corporate projects including the migration of the Core Financial System, upgrades of ancillary financial systems, and the improvements of hardware in the Credit Union’s virtual network and data center.
- Lead the new location build out and migration of network infrastructure and data center for the facility office move, ensuring minimal downtime for staff and members and ready for business Monday morning.
- Created and maintained all IT related policies, procedures, and documentation to align with both state and federal guidelines and requirements inclusive of the master IT Policies and Procedures, and risk assessments for critical systems and applications.
- Facilitated, lead and documented the Disaster Recovery and Business Continuity planning of the Credit Union with the collaboration of each department.
- Generated reports, data extracts and critical analysis utilizing the back end environment of the Credit Union which included use of SQL on an Oracle database, batch scripts and JasperSoft Reports.
- Managed and negotiated vendor contracts and relationships.
- As lead of the IT team, ensured all applications, systems and websites were available 24/7 outside of planned maintenance windows inclusive of responding to critical pages, addressing vendor notifications, and unplanned incidents.
- Supervised and mentored a staff of two; a developer and network administrator.
Senior Business Systems Analyst
EPSILON
Schaumburg
11.2007 - 02.2012
- Work closely with internal and external clients to gather key business and technical requirements for Data Warehouse and Data Mart modifications.
- Strategically analyzed data and processes to outline areas of improvement and increase client value.
- Prepared test cases and performed quality assurance testing on newly implemented code and processes throughout all aspects of implementation.
- Trained and mentored colleagues on the business nuances of our client account along with existing technical steps.
- Work in team environment to ensure that requests and deadlines were met in a timely manner, as well as ensuring upmost client satisfaction.
- Function as a liaison between the technical development team and the business to communicate needs and recommend technical approaches to solutions.
- Assisted in the daily operations support process, addressing failures and delays within the job control system (JCS) in order to ensure an up to date database environment.
- Documented processes and procedures of key role activities performed.
Contractor - Ab Initio Developer/Business Analyst
WALGREENS
Deerfield
09.2007 - 10.2007
- Created and documented business requirements, detail design documents and unit test plans for modifications to the Pharmacy Accounts Receivable System.
- Documented code and data flow utilizing MS Visio.
- Worked with business users to clarify requested system changes and document business requirements.
- Developed and unit tested code, utilizing Ab Initio, Korn Shell scripting and SQL.
- Utilized RCS for software version control, and MS Visual SourceSafe for documentation version control.
Ab Initio Developer/Business Analyst
ACXIOM CORP.
Downers Grove
11.2006 - 08.2007
- Worked with customer to document business requirements and impact analysis for a critical infrastructure upgrade for a Fortune 500 client.
- Created and documented detail code designs, business process flow for miscellaneous projects, code migrations and plan reviews in a team environment.
- Developed and unit tested projects utilizing several applications, primarily, Ab Initio, Datastage, Korn Shell and Orbiter.
- As part of a team and rotation schedule, responsible for on-call production support to address system process failures, errors and user submitted tickets, as well as production set up for specialized weekly migrations.
Education
Master of Science - Business Analytics, Healthcare Concentration
LEWIS UNIVERSITY
Romeoville, Illinois05.2021
Master of Business Administration - Management
ROBERT MORRIS UNIVERSITY
Chicago, Illinois09.2012
Bachelor of Science Degree - Mathematics, with Lower Division Honors
NORTHERN ILLINOIS UNIVERSITY
De Kalb, Illinois05.1994
Skills
- Database management systems
- Spreadsheet applications
- Data visualization techniques
- Project coordination
- ServiceNow expertise
- Business intelligence tools & analytical skills
- Process mapping techniques & use case design
- Collaboration platforms
- Continuous improvement strategies
- Requirements analysis & data integration methods
- SQL development & scripting languages
- Data mapping and transfer strategies
- Training and development programs
- Root-cause identification
References
Available Upon Request
Software
Microsoft Access
Microsoft Excel
Ab Initio
Microsoft Visio
Korn Shell Scripting
Tableau
ServiceNow
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Business Systems Analyst Senior
Advocate Health
03.2018 - Current
IT Manager
MEADOWS CREDIT UNION
03.2012 - 02.2018
Senior Business Systems Analyst
EPSILON
11.2007 - 02.2012
Contractor - Ab Initio Developer/Business Analyst
WALGREENS
09.2007 - 10.2007
Ab Initio Developer/Business Analyst
ACXIOM CORP.
11.2006 - 08.2007
Master of Science - Business Analytics, Healthcare Concentration
LEWIS UNIVERSITY
Master of Business Administration - Management
ROBERT MORRIS UNIVERSITY
Bachelor of Science Degree - Mathematics, with Lower Division Honors
NORTHERN ILLINOIS UNIVERSITY
Similar Profiles
Debra DownhamDebra Downham
Medical Coder II at Advocate HealthMedical Coder II at Advocate Health
Daniel LinebergerDaniel Lineberger
Clinical Nurse II Resource Team Med/Surgical Nurse at Advocate HealthClinical Nurse II Resource Team Med/Surgical Nurse at Advocate Health
Amanda ClearyAmanda Cleary
Registered Nurse, Medical-Surgical Unit at Advocate HealthRegistered Nurse, Medical-Surgical Unit at Advocate Health
Annika JacksonAnnika Jackson
Registered Nurse, Emergency Department at Advocate HealthRegistered Nurse, Emergency Department at Advocate Health
William OliverWilliam Oliver
Frozen Dairy Team Lead at WalmartFrozen Dairy Team Lead at Walmart