Project Management Manager

JEAN T. PIEKARA, MBA

Chicago, IL ***** Cell 312-***-**** ********@*****.*** http://www.linkedin.com/pub/jean-piekara/b/1bb/a88

PROFILE

I desire a functional position, to apply my proven financial IT experience, within my established career in custom and commercial software implementations, in a mid to large company within the greater Chicagoland area, where I can grow, continue to learn, take on increasing challenges and be a positive contributor.

CORE KNOWLEDGE AND STRENGTHS

• Software/System Implementations

• Project Management

• Relationship Management

• Workflow Automation

• Testing/Scripting/Documentation

• Data/Business/System Analysis

• Change Management

• System Security

• SQL Queries/Ad Hoc Reports

• Data Flow/Process Mapping

• Critical Technical Support

• Issue Resolution

EDUCATION

Master of Business Administration in MIS/Finance Dominican University

Bachelor of Science in Marketing University of Illinois at Chicago

Project Management Certificate Program 2013 DePaul University

Client Server Certificate Program Illinois Institute of Technology

TECHNICAL SKILLS

Business Objects, CCI AdDesk Sales, ADMARC, DISCUS v.4.0, SQL Reporting, (Oracle), TOAD, FOCUS, UAT Test Plan, MVS/TSO/JCL/VSAM, FTP, Microsoft Office (Word,Access Excel (macros, formulas, pivot tables, v-lookup functionality), Crystal Reports, PowerPoint, Outlook, Visio), Microsoft Dynamic AX/ADIT Engines, TCP/IP, ITSM, SharePoint, Agile Development Methodology, User Experience & Tableau (Online Classes), Cognos

PROFESSIONAL EXPERIENCE

Wolters Kluwer, Riverwoods, Illinois 03/2017 to Present

Project Manager – Agile Solutions, Inc. Contractor

Consulting engagement providing project management for new initiatives including resource management, asset warranty replacement, office moves and quality assurance testing on check printer upgrades. Plan, execute and finalize capital budget projects of medium to high complexity. Manage technical resources and coordinate efforts of team members and third party contractors to deliver projects according to plan..

Work with stakeholders to define project scope, business case, and requirements.

Project effort, cost estimates, scheduling, communication, plan, execution, assumptions, risks, quality control and monitor financial management throughout the project’s life cycle

Manage issues, risks, action items and provide dashboard analytics, metrics and reporting on each project’s progress

Work with a diverse group of technical / non-technical personnel on infrastructure / software implementation projects

Northwestern Memorial Hospital, Chicago, Illinois 11/15 – 09/16

IT Visio Senior Business Process Analyst - Healthcare – The CSI Companies Contractor Utilized Visio to perform current state analysis with department stakeholders to document 70 plus cross-functional EPIC applications revenue cycle billing workflows. Performed enterprise analysis to create business case for new product development and system enhancements within EPIC system for physician / nurses / care managers / patient / hospital billing

Provided detailed EPIC workflow analysis and process redesign for hospital’s revenue cycle operations relating to registration, medical coding, provider credentialing and new enrollment for government (Medicare and Medicaid) and commercial payer claims found in EPIC’s EMR / EHR systems

Conducted review sessions with SME’s to identify and eliminate manual processes

Facilitated Lean interviews with stakeholders (e.g. Executive Sponsors, Directors, Business End-user and SME’s) to re-engineer workflows for process improvements

Identified preventative and corrective actions to improve health outcomes in patient population related to value-based care

Conducted business process analysis to understand existing workflows and systems, document current processes and systems, create requirements for new processes, develop use cases, and manage requirement changes

University of Chicago, Chicago, Illinois 11/14 – 09/15

Senior Business Systems Analyst / Project Manager – Identity and Access Management

Lead liaison between IAM development group and core business units to design, develop, configure and implement new systems and enhancements of existing systems for Identity and Access Management implementation team.

Defines systems scope and objectives based on stakeholder needs and an understanding of business systems and industry requirements

Documents functional / technical requirements, use cases, current / future Visio process flows and specifications related to IAM efforts including integration projects, defects, bugs and general IAM service delivery

Jean Piekara, MBA, (Continued) Page 2

Collaborate with IAM Architects in application development process to ensure functional requirements become incorporated into technical solutions

Ensures coding, testing, and debugging processes are complete before implementing software solutions

Familiar with Provisioning, Data Governance Policies, and Identity and Access Governance Administration concepts

Demonstrates expertise in project management principles for projects of a short to intermediate duration

Created end user guides and training documents to upload and publish to University’s content management system

CNO Financial Group – Bankers Life & Casualty, Chicago, Illinois 04/13 – 10/14

Configuration Analyst – Agency Compensation

Work with implementation team to design and configure new IBM Agency compensation system (Varicent / Cognos) to meet business and technical needs. Create calculations and payments of agent and manager commissions and incentives, modeling, dashboarding, sales analytics, producer onboarding and field hierarchy management reporting.

Configure application functionality consistent with business requirements

Build relational databases and create detailed mapping documentation including transformation rules

Interface IBM compensation system with systems integrator resources throughout implementation life cycle

Extract, transform, and load data utilizing various file types (CSV, XLS, XML, etc.) into relational databases at the table and attribute level

Support compilation of business requirements, Visio workflow diagrams, UX / UI designs, screen mockups, design documents, field data mapping, process reengineering, use cases, test scripts, test cases, testing plan, integration testing, gap analysis, solution design

Coordinate and communicate with internal / external (IBM) project managers, SME’s, developers, programmers, resources and international implementation project team

Create and maintain naming standards for objects, screens and formulas and defined business rules for agent compensation reporting extracted from data warehouse and data marts

Hallmark Services Corporation, Naperville, Illinois 06/12 – 12/12

Business Analyst – Healthcare Insurance - Interactive Business Systems Contractor

Partnered with business / user group representatives to understand the underlying informational and/or process automation needs demanded for the Affordable Care Act and the Exchange. Acted as a bridge from business vision into technical realization of a solution. Assisted Project Management with coordination of development efforts. Business focus was claims processing for Blue Cross & Blue Shield.

Evaluated information gathered from multiple sources to decompose the high-level information into details, to abstract up from low-level information to a general understanding

Utilized an Agile-Iterative methodology to identify the underlying needs/requirements that drove user requests.

Reviewed project deliverables, including technical specs, business process models, test plans and scripts

Learned new technologies, beyond the scope of current assignments

Conducted gap analysis among business, functional and technical requirements

Tribune Company, Chicago, Illinois 05/1995 – 09/2011

Business Systems Analyst to Applications Support Analyst – Circulation/Advertising Group

Responsible for application support of front-end receivables systems. Responded to system issues including analysis, diagnosis and resolution. Assured accurate and timely billing of 900,000 active subscribers and 2500 vendors, including commissioned sales force.

Finance Team Lead and Team member on multiple software implementation projects both domestic and international for classified / display advertising and circulation billing (Accounts Receivables / Payables, Credit & Collections, & Billing)

Collaborated with cross-functional teams, business units, offshore vendors, onshore clients, IS partners, users, and stakeholders to support, implement and execute projects deliverables

Performed regression / integration testing and quality assurance assessments to evaluate system functionality integrity

Documented risks, requirements, processes and UAT test plans in support of business operations

Initiated, executed, managed production issues, system enhancements and upgrades using ITIL Incident, Problem and Change management process and tools

Led projects from research, approvals, installations, assigned responsibilities and monitored progress to communicate status to stakeholders using Agile Methodology and SharePoint 2010 Enterprise tools

Designed and created SQL query ad hoc reports utilizing Toad and Business Objects

Participated in JAD sessions to influence business units to standardize processes and procedures

Defined security role policy and procedures for system user access

Maintained and updated HTML internal intranet website; uploaded weekly and monthly reports to website

Troubleshot critical production problems impacting billing system reporting, payroll and 1099 processing

Reconciled Accounts Receivable accounts were properly debited for invoices and credited for payment balances in the Accounts Receivable module with the AR accounts in the general ledger and supported accounting teams thru month-end, quarterly and annual financial close process

Configured, updated and implemented security tables, ID’s and roles for system user access

Integrated user enhancements / upgrades to production systems that interfaced to Oracle databases and ERP systems for financial, receivables / payables and lockbox customer transmissions and reporting

Analyzed data mapping issues from complex relational databases to interfaces with Oracle databases, ERP systems (PeopleSoft), business intelligence systems (Business Objects), data marts and data warehouses

Wrote business requirement documents of modifications and procedures for Sarbanes-Oxley compliance

Jean Piekara, MBA, (Continued) Page 3

AWARDS

Chicago Tribune Team Excellence Award-ChicagoTribune’sTeam-Implementation of a Client-Server Circulation system

Newsy Quarterly Award–Chicago Tribune’s Individual Billing and 1099 Processing Award

Chicago Tribune Y2k Team Award – Chicago Tribune

Corporate Tribune Publishing Team Excellence Award–Chicago Tribune’s Departmental Intranet Web Development Team

Team Excellence Award – Multiple Products Team–Chicago Tribune

Silver Team Recognition Award for Automation–W.W. Grainger

PROFESSIONAL ASSOCIATIONS & ACTIVITIES

Univ. of Illinois – Alumni Dominican University– Alumni Chicagoland Digital Photography Meetup Group Project Management Institute PMI Chicagoland Toastmasters

Contact this candidate