Jim Pelichowski

Delivered turn-key "self-service" payroll metrics application for Cast and Crew. System includes automated back-end management of source data that is easily consumed by Tableau. Client can control all aspects of the automated process with very little support required from IT. This is significant since many organization purchase Tableau without understanding the need for data preparation on the back-end. Since Tableau is marketed and used as a "self-service" data analytics tool -- there is… Show more

Delivered turn-key "self-service" payroll metrics application for Cast and Crew. System includes automated back-end management of source data that is easily consumed by Tableau. Client can control all aspects of the automated process with very little support required from IT. This is significant since many organization purchase Tableau without understanding the need for data preparation on the back-end. Since Tableau is marketed and used as a "self-service" data analytics tool -- there is a great need to have the back-end/data sourcing to be as agile. Show less

Stop Meeting Like This (SMLT) is a trailblazing company helping other organizations manage their internal meetings more effectively.

Ongoing as subcontractor for Senturus:
Developed Tableau visualizations to support SMLT survey reporting for clients. Developed data preparation for complex survey output from survey tools such as Survey Monkey -- so that Tableau is highly effective with visualization.

As subcontractor for Senturus:
Providing ongoing mentoring and report development for company financial reporting

As subcontractor for Senturus:
Providing ongoing mentoring for reporting and data architecture

As subcontractor for Senturus:
Providing ongoing support for new Tableau dashboard application. Areas responsible for include ETL, Tableau Server administration, and worksheet/dashboard maintenance.

As subcontractor for Senturus:
Integrated Canadian payroll operations into U.S. operations achieving a single reporting source (single source of the truth)

As subcontractor for Senturus:
Prototype and develop dashboard application that provides a visual risk profile for Wells Fargo company-wide information assets. Application allows key stakeholders to quickly identify and drill into key information assets in focus - reducing the complexity and cycle time utilized with past technical approaches.

As subcontractor for Senturus:

Created reporting application for workman’s compensation payroll analysis for U.S. operations.

Role: BI Architect, Report Developer, Project Manager

Technology platform:
• Reporting Layer: IBM Cognos 10.2.1
• Data Warehouse/ODS Layer: SQL Server/SSIS
• Application Layer: In-house workman’s compensation data
Tools Utilized: Cognos Framework Manager, Cognos Transformer, Report Studio; MS SQL Server, MS SSIS
Key… Show more

As subcontractor for Senturus:

Created reporting application for workman’s compensation payroll analysis for U.S. operations.

Role: BI Architect, Report Developer, Project Manager

Technology platform:
• Reporting Layer: IBM Cognos 10.2.1
• Data Warehouse/ODS Layer: SQL Server/SSIS
• Application Layer: In-house workman’s compensation data
Tools Utilized: Cognos Framework Manager, Cognos Transformer, Report Studio; MS SQL Server, MS SSIS
Key Deliverables
• OLAP cube
• Data Mart and ETL
• Cognos Framework Manager Model
• Cognos Transformer Model
• Custom Reports
• Multi-server Cognos installation


Show less

Capitalize/Waterfield (Tulsa, OK) – Oil and Gas Industry August 2013 – July 2014
Projects
• Cognos Mobile reporting for SCADA (gas meter volumes)
• Accounting Dashboard Application and Management Dashboard
• Cognos software installation and migration from older software versions
• Various oil and gas financial and operational reports
Role: BI Architect, DB Architect, Report Developer, Cognos Sys Admin
Technology platform:
• Reporting Layer: IBM Cognos… Show more

Capitalize/Waterfield (Tulsa, OK) – Oil and Gas Industry August 2013 – July 2014
Projects
• Cognos Mobile reporting for SCADA (gas meter volumes)
• Accounting Dashboard Application and Management Dashboard
• Cognos software installation and migration from older software versions
• Various oil and gas financial and operational reports
Role: BI Architect, DB Architect, Report Developer, Cognos Sys Admin
Technology platform:
• Reporting Layer: IBM Cognos 10.2.1
• Data Warehouse/ODS Layer: SQL Server/SSIS
• Application Layer: Waterfield midstream processing
Tools Utilized: Cognos Framework Manager, Report Studio; Workspace Advanced, MS Office
Key Deliverables
• Mobile reporting (including Cognos Active Reports) for executive management (used to present to investment bankers for growth funding – plant capacity).
• Accounting Dashboard that assists accounting personnel with the monthly accounting close process. Dashboard displays process setup issues/reconciliation errors (red, yellow, green) with drill-through to detail items (i.e. journal entries, allocation detail, contract revenue tie-out)
• Management Dashboard displaying key charts and metrics (using Cognos Workspace Advance)
• Installation of Cognos 10.2.1 on multiple servers (single server and multi-server)
o Secure (https) Cognos Mobile installation within multiple firewalls (outside to DMZ to internal)
Show less

Projects
• Facility Management Dashboard
• Moxie Report conversion project
Role: Report Developer
Technology platform:
• Reporting Layer: IBM Cognos 10.2.1
• Cognos Transformer cube
• Netezza Twin Fin data warehouse appliance
• Oracle 11g
Tools Utilized: Report Studio, MS Office
Key Deliverables
• Facility Management Dashboard currently being used by over 2000 facility managers across the United States.
o Dashboard created in Report Studio using… Show more

Projects
• Facility Management Dashboard
• Moxie Report conversion project
Role: Report Developer
Technology platform:
• Reporting Layer: IBM Cognos 10.2.1
• Cognos Transformer cube
• Netezza Twin Fin data warehouse appliance
• Oracle 11g
Tools Utilized: Report Studio, MS Office
Key Deliverables
• Facility Management Dashboard currently being used by over 2000 facility managers across the United States.
o Dashboard created in Report Studio using multi-dimensional (cube) data
• Solid team effort to create one of the best performing BI report applications at DaVita (per DaVita)
• Responsible for the Cognos report conversion of 50 reports that resided in MS Access/Excel files.
Show less

As Sr. Consultant for Infolink:

Developed dashboards and reports for Purdue business management against their new data warehouse. Areas of focus include human resources and financial management.

As consultant for Infolink:

Project: Teacher Assignment Validation Reporting

Role: BI Architect, Report Developer

Technology platform:
• Reporting Layer: IBM Cognos 10.1.1
• Data Warehouse/ODS Layer: SQL Server/SSIS
• ERP Layer: Peoplesoft HR, Campus

Tools Utilized: Cognos Framework Manager, Report Studio; MS Office; Google Docs

Key Deliverables:
• Custom Teacher Application “Dashboard” with supporting drill-through detail. Used by… Show more

As consultant for Infolink:

Project: Teacher Assignment Validation Reporting

Role: BI Architect, Report Developer

Technology platform:
• Reporting Layer: IBM Cognos 10.1.1
• Data Warehouse/ODS Layer: SQL Server/SSIS
• ERP Layer: Peoplesoft HR, Campus

Tools Utilized: Cognos Framework Manager, Report Studio; MS Office; Google Docs

Key Deliverables:
• Custom Teacher Application “Dashboard” with supporting drill-through detail. Used by principals (150) for staffing efficiency and data accuracy between Peoplesoft HR and Campus scheduling.
• Campus School Course Master data validation and individual school course validation reporting:
--Validates course entries in the Campus Course Master for accuracy (approx. 30 unique error checks). This master is used for individual schools (150 or so) to set course schedules.
--Report takes about one minute to run. Old report (legacy) was taking about 4 hours to run.
--Improves data submissions to the Colorado Dept. of Education (by reducing the number of submissions due to inaccuracies).
Show less

Project: CPS Back Office:

Role: Project Manager, BI Architect, Report Developer

Technology platform:
• Reporting Layer: IBM Cognos 10.1
• Data Warehouse/ODS Layer: Netezza TwinFin
• ERP Layer: Peoplesoft

Tools Utilized: Cognos Framework Manager, Report Studio; Aginity Workbench for Netezza; MS Office

Key Deliverables:
• Developed a set of new inventory management reports used in core operations by over 1200 branch locations and lead cost… Show more

Project: CPS Back Office:

Role: Project Manager, BI Architect, Report Developer

Technology platform:
• Reporting Layer: IBM Cognos 10.1
• Data Warehouse/ODS Layer: Netezza TwinFin
• ERP Layer: Peoplesoft

Tools Utilized: Cognos Framework Manager, Report Studio; Aginity Workbench for Netezza; MS Office

Key Deliverables:
• Developed a set of new inventory management reports used in core operations by over 1200 branch locations and lead cost accountants.
• Developed Netezza views (complex SQL) to support new reports.
• Conversion of 140 legacy Cognos reports to the new Netezza data warehouse and ODS layer.
• Managed 2 additional (remote) Infolink resources to complete this task.
• Report conversion involved meta-data conversion and complex custom java-script prompt pages.
• Developed Cognos Framework architecture for Enterprise Data Warehouse and Operational Data Store to support new reports and conversion reports.
Show less

As subcontractor for Infolink:

Roles: BI Architect, Report Developer

Technology: IBM Cognos 10.1: Report Studio, Framework
Manager, SQL Server 2008

Deliverables:

• Board of Trustees Reports

Highly sensitive reports used by the Chief Risk Officer to present to the Janus Board of Directors on the status of key risk factors and metrics associated with the company’s portfolio offerings. (Janus Capital Group, Inc. is a publicly owned asset management holding… Show more

As subcontractor for Infolink:

Roles: BI Architect, Report Developer

Technology: IBM Cognos 10.1: Report Studio, Framework
Manager, SQL Server 2008

Deliverables:

• Board of Trustees Reports

Highly sensitive reports used by the Chief Risk Officer to present to the Janus Board of Directors on the status of key risk factors and metrics associated with the company’s portfolio offerings. (Janus Capital Group, Inc. is a publicly owned asset management holding company with approximately $167.7 billion in assets under management).

Utilized advanced Cognos reporting techniques to deliver dynamic data and charts that are specific to the investment community and Janus’ core investment model approach. Effectively replaced a highly manual (daunting) spreadsheet process invoking very positive feedback from the Chief Risk Officer (with a significant time savings for him personally).

• Risk Attribution Reports

Used by portfolio managers, product managers and marketing and sales personnel to assess/present portfolio performance by key investment components (against standard equity indexes). Replaced legacy reporting with new charting capabilities and new dimensional slices of information to assist with information competitive advantage. (Janus’ core competency is based on focused research and being ahead of the competition with respect to market knowledge).
Show less

Part time freelance:

Project: New ERP and Reporting System
Role: BI Architect, Report Developer
Technology platform:
• Reporting Layer: IBM Cognos 8.4.1
• Data Warehouse/ODS Layer: Oracle 11g
• ERP Layer: StoneRiver Powersuite (Ver. 7.1)
Tools Utilized: Cognos Framework Manager, Report Studio; MS Office
Key Deliverables
• Cognos Framework model for insurance risk reporting (to support approximately 50 reports for Workman’s Comp claims)
• Developed 20 … Show more

Part time freelance:

Project: New ERP and Reporting System
Role: BI Architect, Report Developer
Technology platform:
• Reporting Layer: IBM Cognos 8.4.1
• Data Warehouse/ODS Layer: Oracle 11g
• ERP Layer: StoneRiver Powersuite (Ver. 7.1)
Tools Utilized: Cognos Framework Manager, Report Studio; MS Office
Key Deliverables
• Cognos Framework model for insurance risk reporting (to support approximately 50 reports for Workman’s Comp claims)
• Developed 20 reports from legacy system
• Created high level management dashboard
Show less

As Sr. Consultant at Infolink:

Roles: Project Manager, Business Analyst, BI Architect, Trainer, Software Installer, Developer

Technology: IBM Cognos 8.4.1: Analysis Studio, Report Studio, Query Studio, Framework Manager, Transformer, Data Manager, SQL Server 2008

Deliverables:

• Review and assess project scope by conducting business and technical interviews.
• Develop detail project schedule for implementation phases.
• Conduct business analysis and consult… Show more

As Sr. Consultant at Infolink:

Roles: Project Manager, Business Analyst, BI Architect, Trainer, Software Installer, Developer

Technology: IBM Cognos 8.4.1: Analysis Studio, Report Studio, Query Studio, Framework Manager, Transformer, Data Manager, SQL Server 2008

Deliverables:

• Review and assess project scope by conducting business and technical interviews.
• Develop detail project schedule for implementation phases.
• Conduct business analysis and consult with subject matter experts.
• Analyze data sources and map to business requirements.
• Create dimensional models and physical models (data mart design).
• Consult and implement data warehouse architecture.
• Build Cognos Framework Manager and Transformer Model(s)
• Create Cognos Analysis Studio reports.
• Create Cognos Report Studio reports.
• Perform Report Studio, Analysis Studio and Query Studio training.
• Perform specialized training as needed (e.g. Drill-through reporting)
Show less

As consultant for Infolink:

Roles: Project Manager, Business Analyst, BI Architect, Trainer

Technology: IBM Cognos 8.4: Analysis Studio, Report Studio, Framework Manager, Transformer, SQL Server 2005

Deliverables:

• Review and assess project scope by conducting business and technical interviews.
• Develop detail project schedule for implementation phases.
• Conduct business analysis and consult with subject matter experts.
• Analyze data sources and map to… Show more

As consultant for Infolink:

Roles: Project Manager, Business Analyst, BI Architect, Trainer

Technology: IBM Cognos 8.4: Analysis Studio, Report Studio, Framework Manager, Transformer, SQL Server 2005

Deliverables:

• Review and assess project scope by conducting business and technical interviews.
• Develop detail project schedule for implementation phases.
• Conduct business analysis and consult with subject matter experts.
• Analyze data sources and map to business requirements.
• Create dimensional models and physical models (data mart design).
• Build Cognos Framework Manager and Transformer Model(s)
• Create Cognos Analysis Studio reports.
• Create Cognos Report Studio reports.
• Perform Analysis Studio training.
Show less

As consultant for Infolink:

Roles: Cognos Developer, Software Mentor/Trainer

Deliverables:

• Create framework model for timeliness reporting of dependent and neglected children (how children are managed through the court system).
• Create complex timeliness reports measuring judicial performance in handling neglected and dependent children.
• Provide IBM Cognos Transformer mentoring.

As consultant for Infolink:

Roles: Software Installer, Data Architect (Framework Manager), Cube Developer (Transformer), Software Mentor

Deliverables:

• Install and configure IBM Cognos 8.4.1 in 3-tier architecture
• Provide post-install mentoring on IBM Cognos security
• Configure data sources for both Oracle and SQL Server
• Create Framework Manager model for relational reporting
• Create Transformer (Cube) model for analytics reporting
• Create Report… Show more

As consultant for Infolink:

Roles: Software Installer, Data Architect (Framework Manager), Cube Developer (Transformer), Software Mentor

Deliverables:

• Install and configure IBM Cognos 8.4.1 in 3-tier architecture
• Provide post-install mentoring on IBM Cognos security
• Configure data sources for both Oracle and SQL Server
• Create Framework Manager model for relational reporting
• Create Transformer (Cube) model for analytics reporting
• Create Report Studio and Analysis Studio reports
• Demonstrate Cognos capabilities
Show less

As consultant for Infolink:

Role: Report Developer (Report Studio)

Deliverables:

• Human Capital Management (HR) Reports

Various HR benefits report feeds from source HR system (Ultipro) into health care provider systems (Cigna, Aetna) for the purpose of notifying employees of benefit options after they have terminated employement.

Employee HR record updates for integration with general ledger accounting system.

As consultant for Infolink:

Roles: Software Mentor/Trainer

Deliverables:

• IBM Cognos security mentoring
• IBM Cognos backup and restore training/documentation
• IBM Cognos portlet management training
• IBM Cognos Transformer mentoring

This is now a lifelong project for me that I am tracking on www.swimmingamericandream.com. I started swimming 2 years ago and I am going to do my first 10K swim at Horsetooth Reservoir which people come to do from all over the world. I will be trailing most of them :-)

http://www.horsetoothswim.com/

My goal after this is to swim 15 miles. Being in the business intelligence industry offers quite a bit sitting and so I am doing something about it :-)